<?php
/*
  $Id: product_info.php,v 1.97 2003/07/01 14:34:54 hpdl Exp $

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2003 osCommerce

  Released under the GNU General Public License
*/

  require('includes/application_top.php');

	// IMPLEMENTATION BRUNO POUR TRACKING///////////////////////////////////////////////////
	// oliscr@gmail.com ////////////////////////////////////////////////////////////////////
  $liste_referers='SELECT referers_id as id, referers_url as url '
  				 .'FROM referers ';
  $r_referers=tep_db_query($liste_referers);
  
  while($a_referers=tep_db_fetch_array($r_referers))
    {
	  // si le referer est stocké dans la table des comparateurs
	  if(ereg($a_referers['url'],$_SERVER['HTTP_REFERER']))
	    {
		  //on recupere le dernier enregistrement 
		  $last='SELECT max(time) as dernier '
		  	   .'FROM referers_sessions '
			   .'WHERE customers_ip="'.$_SERVER['REMOTE_ADDR'].'" '
			   .'AND products_id="'.$_GET['products_id'].'" '
			   .'AND referers_id="'.$a_referers['id'].'" ';
		  $r_last=tep_db_query($last); $a_last=tep_db_fetch_array($r_last);
		
		  // on incremente de 1 le nombre de views du produit
		  $a='SELECT * '
		    .'FROM products_to_referers '
			.'WHERE products_id="'.$_GET['products_id'].'" '
			.'AND referers_id="'.$a_referers['id'].'" ';
		  $aa=tep_db_query($a);
		  
		  $f2=fopen('loggg.txt','a+');
		  fwrite($f2,$a_referers['url'].' '.$_SERVER['HTTP_REFERER'].' '.$a."\n");
		  fclose($f2);
		  if ( (mysql_num_rows($r_last)>0) && ((time()-$a_last['dernier']) < 3) )
		    { 				  
			      $f=fopen('last.txt','w');
				  fwrite($f,'OUI '.mysql_num_rows($r_last) .' '. time(). ' ' .$a_last['dernier'].' '.$last);
				  fclose($f);
 /*rien*/ }
		  else 
		    {
			
			  	  $f=fopen('last.txt','w');
				  fwrite($f,'NON '.mysql_num_rows($r_last) .' '. time(). ' ' .$a_last['dernier'].' '.$last);
				  fclose($f);

			  if((mysql_num_rows($aa)>0) && ($done==FALSE))
				  // mise a jour
				{ $requete='UPDATE products_to_referers SET views=views+1 '
						  .'WHERE referers_id="'.$a_referers['id'].'" '
						  .'AND products_id="'.$_GET['products_id'].'" ';
				  //echo $requete; 
				  tep_db_query($requete);
				  
				  $insertion_session='INSERT INTO referers_sessions (customers_ip,referers_id,products_id,time) '
									.'VALUES ("'.$_SERVER["REMOTE_ADDR"].'","'.$a_referers['id'].'","'.$_GET['products_id'].'","'.time().'");';
				  tep_db_query($insertion_session);	
				  
				  $f=fopen('logg.txt','a+');
				  fwrite($f,time().' mise a jour '.$_SERVER['HTTP_REFERER']."\n");
				  fclose($f);
				  $done=TRUE;
				}
			  else if($done==FALSE)
				  // ou nouvelle insertion
				{ $requete='INSERT INTO products_to_referers (products_id,referers_id,views,sells) '
						  .'VALUES ("'.$_GET['products_id'].'","'.$a_referers['id'].'","1","0");';
				  //echo $requete; 
				  tep_db_query($requete);
				  
				  $insertion_session='INSERT INTO referers_sessions (customers_ip,referers_id,products_id,time) '
									.'VALUES ("'.$_SERVER["REMOTE_ADDR"].'","'.$a_referers['id'].'","'.$_GET['products_id'].'","'.time().'");';
				  tep_db_query($insertion_session);	
				  
				  $f=fopen('logg.txt','a+');
				  fwrite($f,time().' nouvelle insertion '.$_SERVER['HTTP_REFERER']."\n");
				  fclose($f);
				  $done=TRUE;
				}
			}
		}
	}
	// fin IMPLEMENTATION BRUNO POUR TRACKING///////////////////////////////////////////////////
	// oliscr@gmail.com ////////////////////////////////////////////////////////////////////
	
// Tracking Newsletter - Baphira 	

	if(isset($HTTP_GET_VARS['tracking_newsletter']) && $HTTP_GET_VARS['tracking_newsletter'] != ""){
		$query_check_tracking = tep_db_query("SELECT * FROM tracking_newsletter WHERE customers_id = '".$HTTP_GET_VARS['tracking_newsletter']."'");
			$check_tracking = tep_db_fetch_array($query_check_tracking);
			 if($check_tracking['customers_id'] != ""){
				tep_db_query("UPDATE tracking_newsletter SET products_id = '".$HTTP_GET_VARS['products_id']."', index_ref = '0', annif_ref = '0', date = now(), order_id = '0', newsletter_id = '".$HTTP_GET_VARS['newsletter_id']."' WHERE customers_id = '".$HTTP_GET_VARS['tracking_newsletter']."'");
 			 }else{
				tep_db_query("INSERT INTO tracking_newsletter VALUES ('".$HTTP_GET_VARS['tracking_newsletter']."', '".$HTTP_GET_VARS['products_id']."', '0', '0', now(), '0', '".$HTTP_GET_VARS['newsletter_id']."')");
			 }	
	}
// eof Tracking Newsletter

  require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO);

  $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
  $product_check = tep_db_fetch_array($product_check_query);
  
  // Aller chercher la catégorie pour déterminer le stylesheet
  	  $categories_query = tep_db_query("select parent_id from categories INNER join products_to_categories ON products_to_categories.categories_id = categories.categories_id
											where products_to_categories.products_id='". (int)$HTTP_GET_VARS['products_id'] ."'");
  	  $categories = tep_db_fetch_array($categories_query);  	
  // EOF stylesheet query
  
    // SECTION REFERCEMENT TEST BETA VERSION
  $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, if(specials.status = 1, ifnull(specials_new_products_price, p.products_price), p.products_price) as new_price, specials_new_products_price, specials.status, p.products_status  from ". TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p " . "LEFT JOIN specials ON specials.products_id = p.products_id WHERE p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
    $product_info = tep_db_fetch_array($product_info_query);
    // ajout modèle si existe dans le titre
    if ($product_info['products_model'] != null){
     $modele = " [".$product_info['products_model']."]";
    }else{
     $modele = "";
    }
	// Enlève les accents et autres
		$strip_array = array("&eacute;", "&egrave;","&agrave;","&ugrave","&quot;");
		$strip_replace = array("e","e","a","u","'");
		$description = str_replace(array("&quot;"),array("'"),htmlspecialchars(preg_replace($search,$replace,str_replace($strip_array, $strip_replace,$product_info['products_description']))));

  // CHERCHER LA CATEGORIE
 // permet d'aller chercher le numéro de catégorie
$cat_id_ref_query = tep_db_query("SELECT categories_id FROM products_to_categories WHERE products_id='" . $product_info['products_id']."'");
$cat_id_ref = tep_db_fetch_array($cat_id_ref_query);
$cat_nom_ref_query = tep_db_query("SELECT categories_name FROM categories_description WHERE categories_id ='" . $cat_id_ref['categories_id']."'");
$cat_nom_ref = tep_db_fetch_array($cat_nom_ref_query);

$cat_parent_query = tep_db_query("SELECT parent_id FROM `categories` WHERE categories_id='" . $cat_id_ref['categories_id']."'");
$cat_parent = tep_db_fetch_array($cat_parent_query);
$cat_nom_parent_query = tep_db_query("SELECT categories_name FROM categories_description WHERE categories_id ='" . $cat_parent['parent_id']."'");
$cat_nom_parent = tep_db_fetch_array($cat_nom_parent_query);
// ainsi $cat_nom_ref['categories_name'] représente le nom de la catégorie du produit...

  // FIN DE SECTION PHP
  
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<?php
// BOF: Header Tag Controller v2.5.7
		if ( file_exists(DIR_WS_INCLUDES . 'meta_tags.php') ) {
		  require(DIR_WS_INCLUDES . 'meta_tags.php');
		} else {
		?>
  			<title><?php echo TITLE; ?></title>
		<?php
		}		
// EOF: Header Tag Controller v2.5.7
?>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
 <link rel="stylesheet" type="text/css" href="stylesheet.css">
 
<!--[if lte IE 6]>
        <link rel="stylesheet" type="text/css" href="stylesheet_ie6.css">
<![endif]-->
<?php 
// filtre IE 7 - uniquement pour la page produit
if (ereg("MSIE 7.", $_SERVER["HTTP_USER_AGENT"])) {
	echo '<link rel="stylesheet" type="text/css" href="stylesheet_ie7.css">';
}
	 // Update du stylesheet
	 	echo tep_list_category_stylesheet($current_category_id);
	 ?>	 
<?php require('includes/form_check.js2.php'); ?>	 
<script type="text/javascript" src="js/prototype.js"></script>
<script type="text/javascript" src="js/scriptaculous.js?load=effects"></script>
<script type="text/javascript" src="js/lightbox.js"></script>
	 <script language="javascript"><!--
function popupWindow(url) {
  window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,copyhistory=no,width=800,height=600,screenX=150,screenY=150,top=150,left=150')
}
//--></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="3" cellpadding="3" class="countour_site">
  <tr>
    <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
    </table></td>
<!-- body_text //-->
    <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<?php
  if ($product_check['total'] < 1) {
?>
      <tr>
        <td><?php new infoBox(array(array('text' => TEXT_PRODUCT_NOT_FOUND))); ?></td>
      </tr>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
      <tr>
        <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
          <tr class="infoBoxContents">
            <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
              <tr>
                <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
                <td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td>
                <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
              </tr>
            </table></td>
          </tr>
        </table></td>
      </tr>
<?php
  } else {
  /************ PARTIE FLASH ********************/
		include('includes/modules/add-on/flash.php');
?>
      <tr>
        <td>
		 <table border="0" width="100%" cellspacing="1" cellpadding="0">
           <tr>
            <td class="infoboxContents_product_title" align="left"><?php echo strtoupper(substr($products_name,0,1)).
			  								 substr($products_name,1,strlen($products_name)); ?><hr></td>
			<?php 
			/************ PARTIE FLASH  2********************/
				include('includes/modules/add-on/flash2.php');
			?>		   
		</td>
		</tr>
      <tr>	
		<td class="main">	  
			<div class="product_background">
				<div class="product_image"><?php include('includes/modules/add-on/morepics.php');?></div>
				<div class="product_description"><?php include('includes/modules/add-on/description.php');?></div>
			</div>
        </td>	
      </tr>

	  <tr>
		<td class="main">
		<?php echo "<b>".strtoupper(substr($products_name,0,1)).
			  								 substr($products_name,1,strlen($products_name))."</b><br>"; 
			  echo stripslashes($product_info['products_description']); ?></td>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
<?php
    $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'");
    $reviews = tep_db_fetch_array($reviews_query);
    if ($reviews['count'] > 0) {
?>
      <tr>
        <td class="main"><?php echo TEXT_CURRENT_REVIEWS . ' ' . $reviews['count']; ?></td>
      </tr>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
?>

    if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) {
?>
      <tr>
        <td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></td>
      </tr>
<?php
    }
?>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>


      <tr>
        <td><a href="http://www.shopaffairs.com/shipping.php"><b><font size="1" color="#FF0000">Toutes les commandes réglées (CB, Paypal) passées avant 17h sont expédiées le jour même (voir conditions)</font></b></a><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
      <tr>
      	<td class="main">
			<?php include(DIR_WS_MODULES. 'xselling_products.php');?>
		</td>
      </tr>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
      <tr>
        <td>
<?php
    if ((USE_CACHE == 'true') && empty($SID)) {
      echo tep_cache_also_purchased(3600);
    } else {
      include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);
    }
  }
?>
        </td>
      </tr>
    </table></td>
<!-- body_text_eof //-->
    <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- right_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- right_navigation_eof //-->
    </table></td>
  </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>