[Sommaire] [Imprimer]

   1  <?php
   2  /**

   3   * redirect handler 

   4   *

   5   * @package page

   6   * @copyright Copyright 2003-2006 Zen Cart Development Team

   7   * @copyright Portions Copyright 2003 osCommerce

   8   * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0

   9   * @version $Id: header_php.php 3000 2006-02-09 21:11:37Z wilt $

  10   */
  11  if (!defined('IS_ADMIN_FLAG')) {
  12    die('Illegal Access');
  13  }
  14  switch ($_GET['action']) {
  15    case 'banner':
  16    $banner_query = "SELECT banners_url
  17                     FROM " . TABLE_BANNERS . " 
  18                     WHERE banners_id = :bannersID";
  19  
  20    $banner_query = $db->bindVars($banner_query, ':bannersID', $_GET['goto'], 'integer');
  21    $banner = $db->Execute($banner_query);
  22    if ($banner->RecordCount() > 0) {
  23      zen_update_banner_click_count($_GET['goto']);
  24      zen_redirect($banner->fields['banners_url']);
  25    }
  26    break;
  27    case 'url':
  28    if (isset($_GET['goto']) && zen_not_null($_GET['goto'])) {
  29      zen_redirect('http://' . $_GET['goto']);
  30    }
  31    break;
  32  
  33    case 'manufacturer':
  34    if (isset($_GET['manufacturers_id']) && zen_not_null($_GET['manufacturers_id'])) {
  35      $sql = "SELECT manufacturers_url
  36              FROM " . TABLE_MANUFACTURERS_INFO . " 
  37              WHERE manufacturers_id = :manufacturersID 
  38              AND languages_id = :languagesID";
  39  
  40      $sql = $db->bindVars($sql, ':manufacturersID', $_GET['manufacturers_id'], 'integer');
  41      $sql = $db->bindVars($sql, ':languagesID', $_SESSION['languages_id'], 'integer');
  42      $manufacturer = $db->Execute($sql);
  43  
  44      if ($manufacturer->RecordCount()) {
  45        // url exists in selected language

  46  
  47        if (zen_not_null($manufacturer->fields['manufacturers_url'])) {
  48          $sql = "UPDATE " . TABLE_MANUFACTURERS_INFO . "
  49                  SET url_clicked = url_clicked+1, date_last_click = now() 
  50                  WHERE manufacturers_id = :manufacturersID 
  51                  AND languages_id = :languagesID";
  52          
  53          $sql = $db->bindVars($sql, ':manufacturersID', $_GET['manufacturers_id'], 'integer');
  54          $sql = $db->bindVars($sql, ':languagesID', $_SESSION['languages_id'], 'integer');
  55          $db->Execute($sql);
  56          zen_redirect($manufacturer->fields['manufacturers_url']);
  57        }
  58      } else {
  59        // no url exists for the selected language, lets use the default language then

  60        $sql = "SELECT mi.languages_id, mi.manufacturers_url
  61                FROM " . TABLE_MANUFACTURERS_INFO . " mi, " . TABLE_LANGUAGES . " l 
  62                WHERE mi.manufacturers_id = :manufacturersID 
  63                AND mi.languages_id = l.languages_id 
  64                AND l.code = '" . DEFAULT_LANGUAGE . "'";
  65        
  66        $sql = $db->bindVars($sql, ':manufacturersID', $_GET['manufacturers_id'], 'integer');
  67        $manufacturer = $db->Execute(sql);
  68  
  69        if ($manufacturer->RecordCount > 0) {
  70  
  71          if (zen_not_null($manufacturer->fields['manufacturers_url'])) {
  72            $sql = "UPDATE " . TABLE_MANUFACTURERS_INFO . "
  73                    SET url_clicked = url_clicked+1, date_last_click = now() 
  74                    WHERE manufacturers_id = :manufacturersID 
  75                    AND languages_id = :languagesID";
  76            
  77            $sql = $db->bindVars($sql, ':manufacturersID', $_GET['manufacturers_id'], 'integer');
  78            $sql = $db->bindVars($sql, ':languagesID', $_SESSION['languages_id'], 'integer');
  79            $db->Execute($sql);
  80  
  81  
  82            zen_redirect($manufacturer->fields['manufacturers_url']);
  83          }
  84        }
  85      }
  86    }
  87    break;
  88  }
  89  
  90  zen_redirect(zen_href_link(FILENAME_DEFAULT));
  91  ?>