[Summary view] [Print] [Text view]

   1  <?php
   2  /*

   3  $Id: affiliate_clicks.php 14 2006-07-28 17:42:07Z user $

   4  

   5    OSC-Affiliate

   6  

   7    Contribution based on:

   8  

   9    osCMax Power E-Commerce

  10    http://oscdox.com

  11  

  12    Copyright 2006 osCMax

  13  

  14    Released under the GNU General Public License

  15  */
  16  
  17  // Most of this file is changed or moved to BTS - Basic Template System - format.

  18  // For adding in contribution or modification - parts of this file has been moved to: catalog\templates\fallback\contents\<filename>.tpl.php as a default (sub 'fallback' with your current template to see if there is a template specife change).

  19  //       catalog\templates\fallback\contents\<filename>.tpl.php as a default (sub 'fallback' with your current template to see if there is a template specife change).

  20  // (Sub 'fallback' with your current template to see if there is a template specific file.)

  21  
  22    require ('includes/application_top.php');
  23  
  24    if (!tep_session_is_registered('affiliate_id')) {
  25      $navigation->set_snapshot();
  26      tep_redirect(tep_href_link(FILENAME_AFFILIATE, '', 'SSL'));
  27    }
  28  
  29    require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_AFFILIATE_CLICKS);
  30  
  31    $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_AFFILIATE_CLICKS, '', 'SSL'));
  32  
  33    $affiliate_clickthroughs_raw = "
  34      select a.*, pd.products_name from " . TABLE_AFFILIATE_CLICKTHROUGHS . " a 
  35      left join " . TABLE_PRODUCTS . " p on (p.products_id = a.affiliate_products_id) 
  36      left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on (pd.products_id = p.products_id and pd.language_id = '" . $languages_id . "') 
  37      where a.affiliate_id = '" . $affiliate_id . "'  ORDER BY a.affiliate_clientdate desc
  38      ";
  39    $affiliate_clickthroughs_split = new splitPageResults($affiliate_clickthroughs_raw, MAX_DISPLAY_SEARCH_RESULTS);
  40  
  41    $affiliate_clickthroughs_numrows_raw = "select count(*) as count from " . TABLE_AFFILIATE_CLICKTHROUGHS . " where affiliate_id = '" . $affiliate_id . "'";
  42    $affiliate_clickthroughs_query = tep_db_query($affiliate_clickthroughs_numrows_raw);
  43    $affiliate_clickthroughs_numrows = tep_db_fetch_array($affiliate_clickthroughs_query);
  44    $affiliate_clickthroughs_numrows =$affiliate_clickthroughs_numrows['count'];
  45  
  46    $content = affiliate_clicks;
  47     
  48    include (bts_select('main', $content_template)); // BTSv1.5

  49  
  50    require (DIR_WS_INCLUDES . 'application_bottom.php'); 
  51  ?>