CRE Loaded 6.2 Pro: affiliate_banners

00001 <?php
00002 /*
00003   $Id: affiliate_banner_product.php,v 2.00 2003/10/12
00004 
00005   OSC-Affiliate
00006 
00007   Contribution based on:
00008 
00009   osCommerce, Open Source E-Commerce Solutions
00010   http://www.oscommerce.com
00011 
00012   Copyright (c) 2002 - 2003 osCommerce
00013 
00014   Released under the GNU General Public License
00015 */
00016 
00017   require('includes/application_top.php');
00018 
00019   if (!tep_session_is_registered('affiliate_id')) {
00020     $navigation->set_snapshot();
00021     tep_redirect(tep_href_link(FILENAME_AFFILIATE, '', 'SSL'));
00022   }
00023 
00024   require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_AFFILIATE_BANNERS_PRODUCT);
00025 
00026   $location = ' &raquo; <a href="' . tep_href_link(FILENAME_AFFILIATE_BANNERS_PRODUCT, '', 'NONSSL') . '" class="headerNavigation">' . NAVBAR_TITLE . '</a>';
00027 
00028 // $affiliate_values = tep_db_query("select * from " . TABLE_AFFILIATE . " where affiliate_id = '" . $affiliate_id . "'");
00029 
00030   $affiliate_banners_values = tep_db_query("select * from " . TABLE_AFFILIATE_BANNERS . " where affiliate_products_id >'0' order by affiliate_banners_title");
00031 ?>
00032 <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
00033 <html <?php echo HTML_PARAMS; ?>>
00034 <head>
00035 <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
00036 <title><?php echo TITLE; ?></title>
00037 <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
00038 <link rel="stylesheet" type="text/css" href="stylesheet.css">
00039 </head>
00040 <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
00041 <!-- header //-->
00042 <?php require(DIR_WS_INCLUDES . 'header.php'); ?>
00043 <!-- header_eof //-->
00044 
00045 <!-- body //-->
00046 <table border="0" width="100%" cellspacing="3" cellpadding="3">
00047   <tr>
00048     <td width="<?php echo BOX_WIDTH; ?>" height="28" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
00049 <!-- left_navigation //-->
00050 <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
00051 <!-- left_navigation_eof //-->
00052     </table></td>
00053 <!-- body_text //-->
00054     <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
00055       <tr>
00056         <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
00057           <tr>
00058             <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
00059             <td align="right"><?php echo tep_image(DIR_WS_IMAGES . 'affiliate_links.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
00060           </tr>
00061           <tr>
00062             <td colspan=2 class="main"><?php echo TEXT_INFORMATION; ?></td>
00063           </tr>
00064         </table>
00065         </td>
00066       </tr>
00067       <tr>
00068         <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
00069       </tr>
00070       <tr>
00071         <td><table width="100%" align="center" border="0" cellpadding="0" cellspacing="0"><td>
00072 <?php
00073   if (tep_db_num_rows($affiliate_banners_values)) {
00074 
00075     while ($affiliate_banners = tep_db_fetch_array($affiliate_banners_values)) {
00076       $affiliate_products_query = tep_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . $affiliate_banners['affiliate_products_id'] . "' and language_id = '" . $languages_id . "'");
00077       $affiliate_products = tep_db_fetch_array($affiliate_products_query);
00078       $prod_id = $affiliate_banners['affiliate_products_id'];
00079       $ban_id = $affiliate_banners['affiliate_banners_id'];
00080       switch (AFFILIATE_KIND_OF_BANNERS) {
00081         case 1: // Link to Products
00082           if ($prod_id > 0) {
00083             $link = '<a href="' . HTTPS_SERVER . DIR_WS_CATALOG . FILENAME_PRODUCT_INFO . '?ref=' . $affiliate_id . '&products_id=' . $prod_id . '&affiliate_banner_id=' . $ban_id . '" target="_blank"><img src="' . HTTPS_SERVER . DIR_WS_CATALOG . DIR_WS_IMAGES . $affiliate_banners['affiliate_banners_image'] . '" border="0" alt="' . $affiliate_products['products_name'] . '"></a>';
00084             $link1 = '<a href="' . HTTP_SERVER . DIR_WS_CATALOG . FILENAME_PRODUCT_INFO . '?ref=' . $affiliate_id . '&products_id=' . $prod_id . '&affiliate_banner_id=' . $ban_id . '" target="_blank"><img src="' . HTTP_SERVER . DIR_WS_CATALOG . DIR_WS_IMAGES . $affiliate_banners['affiliate_banners_image'] . '" border="0" alt="' . $affiliate_products['products_name'] . '"></a>';
00085             $link2 = '<a href="' . HTTP_SERVER . DIR_WS_CATALOG . FILENAME_PRODUCT_INFO . '?ref=' . $affiliate_id . '&products_id=' . $prod_id . '&affiliate_banner_id=' . $ban_id . '" target="_blank">' . $affiliate_products['products_name'] . '</a>';
00086                         }
00087           break;
00088         case 2: // Link to Products
00089           if ($prod_id > 0) {
00090             $link = '<a href="' . HTTPS_SERVER . DIR_WS_CATALOG . FILENAME_PRODUCT_INFO . '?ref=' . $affiliate_id . '&products_id=' . $prod_id . '&affiliate_banner_id=' . $ban_id . '" target="_blank"><img src="' . HTTPS_SERVER . DIR_WS_CATALOG . FILENAME_AFFILIATE_SHOW_BANNER . '?ref=' . $affiliate_id . '&affiliate_banner_id=' . $ban_id . '" border="0" alt="' . $affiliate_products['products_name'] . '"></a>';
00091             $link1 = '<a href="' . HTTP_SERVER . DIR_WS_CATALOG . FILENAME_PRODUCT_INFO . '?ref=' . $affiliate_id . '&products_id=' . $prod_id . '&affiliate_banner_id=' . $ban_id . '" target="_blank"><img src="' . HTTP_SERVER . DIR_WS_CATALOG . FILENAME_AFFILIATE_SHOW_BANNER . '?ref=' . $affiliate_id . '&affiliate_banner_id=' . $ban_id . '" border="0" alt="' . $affiliate_products['products_name'] . '"></a>';
00092             $link2 = '<a href="' . HTTP_SERVER . DIR_WS_CATALOG . FILENAME_PRODUCT_INFO . '?ref=' . $affiliate_id . '&products_id=' . $prod_id . '&affiliate_banner_id=' . $ban_id . '" target="_blank">' . $affiliate_products['products_name'] . '</a>';
00093                         }
00094           break;
00095       }
00096 
00097           if ($prod_id > 0) {
00098 ?>
00099         <table width="95%" align="center" border="0" cellpadding="4" cellspacing="0" class="infoBoxContents">
00100           <tr>
00101             <td class="infoBoxHeading" align="center"><?php echo TEXT_AFFILIATE_NAME; ?>&nbsp;<?php echo $affiliate_banners['affiliate_banners_title']; ?></td>
00102           </tr>
00103           <tr> 
00104             <td class="smallText" align="center"><?php echo $link; ?></td> 
00105           </tr> 
00106           <tr> 
00107             <td class="smallText" align="center"><?php echo TEXT_AFFILIATE_INFO; ?></td> 
00108           </tr> 
00109           <tr> 
00110             <td class="smallText" align="center"> 
00111              <textarea cols="60" rows="4" class="boxText"><?php echo $link1; ?></textarea> 
00112    </td> 
00113           </tr> 
00114           <tr> 
00115             <td>&nbsp;<td> 
00116           </tr> 
00117           <tr> 
00118             <td class="smallText" align="center"><b>Text Version:</b> <?php echo $link2; ?></td> 
00119           </tr> 
00120           <tr> 
00121             <td class="smallText" align="center"><?php echo TEXT_AFFILIATE_INFO; ?></td> 
00122           </tr> 
00123           <tr> 
00124             <td class="smallText" align="center"> 
00125              <textarea cols="60" rows="3" class="boxText"><?php echo $link2; ?></textarea> 
00126    </td> 
00127           </tr>
00128           </table>
00129 <?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?>
00130 
00131 <?php }
00132 }
00133 }
00134 ?>
00135           </table>
00136          </td>
00137       </tr>
00138      </table></td>
00139 <!-- body_text_eof //-->
00140     <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
00141 <!-- right_navigation //-->
00142 <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
00143 <!-- right_navigation_eof //-->
00144     </table></td>
00145   </tr>
00146 </table>
00147 <!-- body_eof //-->
00148 
00149 <!-- footer //-->
00150 <?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
00151 <!-- footer_eof //-->
00152 <br>
00153 </body>
00154 </html>
00155 <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
affiliate_banners_product.php
