/ -> redirect.php (source)

[Summary view]

   1  <?php
   2  /*
   3    $Id: redirect.php,v 1.10 2003/06/05 23:31:31 hpdl Exp $
   4  
   5    osCommerce, Open Source E-Commerce Solutions
   6    http://www.oscommerce.com
   7  
   8    Copyright (c) 2003 osCommerce
   9  
  10    Released under the GNU General Public License
  11  */
  12  
  13    require ('includes/application_top.php');
  14  
  15    switch ($HTTP_GET_VARS['action']) {
  16      case 'banner':
  17        $banner_query = tep_db_query("select banners_url from " . TABLE_BANNERS . " where banners_id = '" . (int)$HTTP_GET_VARS['goto'] . "'");
  18        if (tep_db_num_rows($banner_query)) {
  19          $banner = tep_db_fetch_array($banner_query);
  20          tep_update_banner_click_count($HTTP_GET_VARS['goto']);
  21  
  22          tep_redirect($banner['banners_url']);
  23        }
  24        break;
  25  
  26      case 'url':
  27        if (isset($HTTP_GET_VARS['goto']) && tep_not_null($HTTP_GET_VARS['goto'])) {
  28          tep_redirect('http://' . $HTTP_GET_VARS['goto']);
  29        }
  30        break;
  31  
  32      case 'manufacturer':
  33        if (isset($HTTP_GET_VARS['manufacturers_id']) && tep_not_null($HTTP_GET_VARS['manufacturers_id'])) {
  34          $manufacturer_query = tep_db_query("select manufacturers_url from " . TABLE_MANUFACTURERS_INFO . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and languages_id = '" . (int)$languages_id . "'");
  35          if (tep_db_num_rows($manufacturer_query)) {
  36  // url exists in selected language
  37            $manufacturer = tep_db_fetch_array($manufacturer_query);
  38  
  39            if (tep_not_null($manufacturer['manufacturers_url'])) {
  40              tep_db_query("update " . TABLE_MANUFACTURERS_INFO . " set url_clicked = url_clicked+1, date_last_click = now() where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and languages_id = '" . (int)$languages_id . "'");
  41  
  42              tep_redirect($manufacturer['manufacturers_url']);
  43            }
  44          } else {
  45  // no url exists for the selected language, lets use the default language then
  46            $manufacturer_query = tep_db_query("select mi.languages_id, mi.manufacturers_url from " . TABLE_MANUFACTURERS_INFO . " mi, " . TABLE_LANGUAGES . " l where mi.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and mi.languages_id = l.languages_id and l.code = '" . DEFAULT_LANGUAGE . "'");
  47            if (tep_db_num_rows($manufacturer_query)) {
  48              $manufacturer = tep_db_fetch_array($manufacturer_query);
  49  
  50              if (tep_not_null($manufacturer['manufacturers_url'])) {
  51                tep_db_query("update " . TABLE_MANUFACTURERS_INFO . " set url_clicked = url_clicked+1, date_last_click = now() where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and languages_id = '" . (int)$manufacturer['languages_id'] . "'");
  52  
  53                tep_redirect($manufacturer['manufacturers_url']);
  54              }
  55            }
  56          }
  57        }
  58        break;
  59    }
  60  
  61    tep_redirect(tep_href_link(FILENAME_DEFAULT));
  62  ?>