관리-도구

편집 파일: banner.php

<?php
/**
 * banner functions
 *
 * @copyright Copyright 2003-2022 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: DrByte 2020 Dec 24 Modified in v1.5.8-alpha $
 */

/**
   * Set the status of a specified banner
   * @param int $banners_id
   * @param int $status
   * @return queryFactoryResult
   */
  function zen_set_banner_status($banners_id, $status) {
    if ($status != 0 && $status != 1) return -1;
    global $db;
    $sql = "UPDATE " . TABLE_BANNERS;
    $sql .= ($status == 1) ? " SET status = 1, date_scheduled = NULL" : " SET status = 0";
    $sql .= ", date_status_change = now() WHERE banners_id = '" . (int)$banners_id . "'";
    return $db->Execute($sql);
  }

/**
   * Activate any unactivated banners whose scheduled start date is set to a time before "now".
   */
  function zen_activate_banners() {
    global $db;
    $banners_query = "SELECT banners_id, date_scheduled
                      FROM " . TABLE_BANNERS . "
                      WHERE date_scheduled IS NOT NULL";
    $banners = $db->Execute($banners_query);

if ($banners->RecordCount() > 0) {
      while (!$banners->EOF) {
        if (date('Y-m-d H:i:s') >= $banners->fields['date_scheduled']) {
          zen_set_banner_status($banners->fields['banners_id'], 1);
        }
        $banners->MoveNext();
      }
    }
  }

/**
 * Expire any banners whose expiry date has recently passed
 */
  function zen_expire_banners() {
    global $db;
    $banners_query = "SELECT b.banners_id, b.expires_date, b.expires_impressions,
                             sum(bh.banners_shown) as banners_shown
                      FROM " . TABLE_BANNERS . " b, " . TABLE_BANNERS_HISTORY . " bh
                      WHERE b.status = 1
                      AND b.banners_id = bh.banners_id
                      GROUP BY b.banners_id, b.expires_date, b.expires_impressions";

$banners = $db->Execute($banners_query);

if ($banners->RecordCount() > 0) {
      while (!$banners->EOF) {
        if (zen_not_null($banners->fields['expires_date'])) {
          if (date('Y-m-d H:i:s') >= $banners->fields['expires_date']) {
            zen_set_banner_status($banners->fields['banners_id'], 0);
          }
        } elseif (!empty($banners->fields['expires_impressions']) && $banners->fields['banners_shown'] >= $banners->fields['expires_impressions']) {
            zen_set_banner_status($banners->fields['banners_id'], 0);
        }
        $banners->MoveNext();
      }
    }
  }

/**
   * Given a specific action and group or banner-id identifier, display a relevant banner.
   * @param string $action
   * @param string $identifier
   * @return string
   */
  function zen_display_banner($action = '', $identifier = '') {
    if ($identifier == '' || $action == '') return FALSE;
    global $db, $request_type;

switch ($request_type) {
      case ('SSL'):
        $my_banner_filter = " and banners_on_ssl = 1 ";
        break;
      case ('NONSSL'):
        $my_banner_filter = '';
        break;
    }

if ($action == 'dynamic') {
      $new_banner_search = zen_build_banners_group($identifier);

$banners_query = "SELECT count(*) as count
                        FROM " . TABLE_BANNERS . "
                           WHERE status = '1' " .
                           $new_banner_search . $my_banner_filter;

$banners = $db->Execute($banners_query);

if ($banners->fields['count'] > 0) {
        $banner = $db->Execute("SELECT banners_id, banners_title, banners_image, banners_html_text, banners_open_new_windows, banners_url
                               FROM " . TABLE_BANNERS . "
                               WHERE status = 1 " .
                               $new_banner_search . $my_banner_filter . " ORDER BY rand()");

} else {
 return 'ZEN ERROR! (zen_display_banner(' . $action . ', ' . $identifier . ') -> No banners with group \'' . $identifier . '\' found!';
 }
 } elseif ($action == 'static') {
 if (is_object($identifier)) {
 $banner = $identifier;
 } else {
 $banner_query = "SELECT banners_id, banners_title, banners_image, banners_html_text, banners_open_new_windows, banners_url
 FROM " . TABLE_BANNERS . "
 WHERE status = 1
 AND banners_id = '" . (int)$identifier . "'" . $my_banner_filter;

$banner = $db->Execute($banner_query);

if ($banner->RecordCount() < 1) {
 //return 'ZEN ERROR! (zen_display_banner(' . $action . ', ' . $identifier . ') -> Banner with ID \'' . $identifier . '\' not found, or status inactive';
 }
 }
 } else {
 return 'ZEN ERROR! (zen_display_banner(' . $action . ', ' . $identifier . ') -> Unknown $action parameter value - it must be either \'dynamic\' or \'static\'';
 }

if ($banner->RecordCount() < 1) {
 return 'ZEN ERROR! (zen_display_banner(' . $action . ') failed.)';
 }

if (!empty($banner->fields['banners_html_text'])) {
 $banner_string = $banner->fields['banners_html_text'];
 } else {
 if ($banner->fields['banners_url'] == '') {
 $banner_string = zen_image(DIR_WS_IMAGES . $banner->fields['banners_image'], $banner->fields['banners_title']);
 } else {
 $target = '';
 if ($banner->fields['banners_open_new_windows'] == '1') {
 $target = ' rel="noopener" target="_blank"';
 }
 $banner_string = '<a href="' . zen_href_link(FILENAME_REDIRECT, 'action=banner&goto=' . $banner->fields['banners_id']) . '"' . $target . '>' . zen_image(DIR_WS_IMAGES . $banner->fields['banners_image'], $banner->fields['banners_title']) . '</a>';
 }
 }

zen_update_banner_display_count($banner->fields['banners_id']);

return $banner_string;
  }

/**
 * Check to see whether a banner exists according to the criteria of action and banner-group-id identifier
 * @param string $action
 * @param string $identifier
 * @return queryFactoryResult
 */
  function zen_banner_exists($action = '', $identifier = '') {
    if ($identifier == '' || $action == '') return FALSE;
    global $db, $request_type;

switch ($request_type) {
      case ('SSL'):
        $my_banner_filter = " AND banners_on_ssl= 1 ";
        break;
      case ('NONSSL'):
        $my_banner_filter = '';
        break;
    }

if ($action == 'dynamic') {
      $new_banner_search = zen_build_banners_group($identifier);
      $sql = "SELECT banners_id, banners_title, banners_image, banners_html_text, banners_open_new_windows, banners_url
                           FROM " . TABLE_BANNERS . "
                               WHERE status = 1 " .
                               $new_banner_search . $my_banner_filter . " ORDER BY rand()";
      $result = $db->Execute($sql);
    } elseif ($action == 'static') {
      $sql = "SELECT banners_id, banners_title, banners_image, banners_html_text, banners_open_new_windows, banners_url
                       FROM " . TABLE_BANNERS . "
                       WHERE status = 1
                       AND banners_id = '" . (int)$identifier . "'" . $my_banner_filter;
      $result = $db->Execute($sql);
    } else {
      return false;
    }
    if ($result->RecordCount() > 0) {
      return $result;
    } else {
      return FALSE;
    }
  }

/**
   * Update statistics for a given banner
   * @param int banner id
   */
  function zen_update_banner_display_count($banner_id) {
    global $db;
    $banner_check = $db->Execute(sprintf(SQL_BANNER_CHECK_QUERY, (int)$banner_id));

if ($banner_check->fields['count'] > 0) {
      $db->Execute(sprintf(SQL_BANNER_CHECK_UPDATE, (int)$banner_id));

} else {
      $sql = "INSERT INTO " . TABLE_BANNERS_HISTORY . "
                     (banners_id, banners_shown, banners_history_date)
              VALUES (" . (int)$banner_id . ", 1, now())";
      $db->Execute($sql);
    }
  }

/**
 * Update banner click statistics
 * @param int $banner_id
 */
  function zen_update_banner_click_count($banner_id) {
    global $db;
    $db->Execute(sprintf(SQL_BANNER_UPDATE_CLICK_COUNT, (int)$banner_id));
  }

/**
 * Build banner group SQL queries
 * @param string $selected_banners (colon-separated list of banner groups)
 * @return string SQL where clause
 */
 function zen_build_banners_group($selected_banners) {
 global $db;
 $selected_banners = explode(':', $selected_banners);
 $size = sizeof($selected_banners);
 $new_banner_search = '';
 if ($size == 1) {
 $new_banner_search = " banners_group = '" . $db->prepare_input($selected_banners[0]) . "'";
 } else {
 for ($i=0, $n=$size; $i<$n; $i+=1) {
 $new_banner_search .= " banners_group = '" . $db->prepare_input($selected_banners[$i]) . "'";
 if ($i+1 < $n) {
 $new_banner_search .= ' or ';
 }
 }
 }
 if ($new_banner_search != '') {
 $new_banner_search = ' and (' . $new_banner_search . ')';
 }
 return $new_banner_search;
 }