= NOW() AND s.specials_first_day <= NOW(), s.specials_new_price, p.products_price) as ord FROM products as p LEFT JOIN specials as s ON (p.products_id = s.products_id) LEFT JOIN fournisseurs as f ON (p.fournisseurs_id = f.fournisseurs_id) WHERE p.categories_id = '".$HTTP_GET_VARS['path']."' AND p.products_visible = 'yes' ".(($_SESSION[wholesaler])?("AND p.visible_wholesale='1'"):(""))." "; $result=mysql_query("$select") or die(mysql_error()); $tototal = mysql_num_rows($result); $select .= " ORDER BY ".$HTTP_GET_VARS['sort']." $asc LIMIT ".$HTTP_GET_VARS['page'].",$nbre_ligne"; $result=mysql_query("$select"); $NavNum = "= NOW() AND s.specials_first_day <= NOW(), s.specials_new_price, p.products_price) as ord FROM products as p LEFT JOIN specials as s ON (p.products_id = s.products_id) LEFT JOIN fournisseurs as f ON (p.fournisseurs_id = f.fournisseurs_id) LEFT JOIN categories as c ON (p.categories_id = c.categories_id) WHERE TO_DAYS(NOW()) - TO_DAYS(p.products_date_added) <= $nbre_jour_nouv AND p.products_visible=\"yes\" AND c.categories_visible=\"yes\" ".($_SESSION[wholesaler]?"AND c.categories_wholesale_visible = 'yes'":"")." ".(($_SESSION[wholesaler])?("AND p.visible_wholesale='1'"):(""))." AND p.products_qt > 0"; $select = $selectP." ".$AddQuery; $result=mysql_query("$select"); $resultP=mysql_query("$selectP"); $tototal = mysql_num_rows($result); $select .= " ORDER BY ".$HTTP_GET_VARS['sort']." $asc LIMIT ".$HTTP_GET_VARS['page'].",$nbre_ligne"; $result=mysql_query("$select"); } //-------------- // PROMO-------- //-------------- if(isset($HTTP_GET_VARS['target']) and $HTTP_GET_VARS['target'] == "promo") { if(isset($HTTP_GET_VARS['view'])) { $AddQuery = " AND p.categories_id = ".$HTTP_GET_VARS['view']." "; $NavNum = "= NOW() AND s.specials_first_day <= NOW(), s.specials_new_price, p.products_price) as ord FROM products as p INNER JOIN specials as s ON (p.products_id = s.products_id) LEFT JOIN categories as c ON (p.categories_id = c.categories_id) LEFT JOIN fournisseurs as f ON (p.fournisseurs_id = f.fournisseurs_id) WHERE s.specials_visible=\"yes\" AND p.products_visible=\"yes\" AND p.products_qt > 0 AND c.categories_visible=\"yes\" ".($_SESSION[wholesaler]?"AND c.categories_wholesale_visible = 'yes'":"")." AND TO_DAYS(s.specials_first_day) <= TO_DAYS(NOW()) AND TO_DAYS(NOW()) <= TO_DAYS(s.specials_last_day) ".(($_SESSION[wholesaler])?("AND p.visible_wholesale='1'"):(""))." "; $select = $selectP." ".$AddQuery; $result=mysql_query("$select"); $resultP=mysql_query("$selectP"); $tototal = mysql_num_rows($result); $select .= " ORDER BY ".$HTTP_GET_VARS['sort']." $asc LIMIT ".$HTTP_GET_VARS['page'].",$nbre_ligne"; $result=mysql_query("$select"); } ?>

0) { $rowp = mysql_fetch_array($result2); if ($_SERVER[HTTP_HOST]=="www.dreams4women.com") print "
".$rowp['text_list']."
"; else print "
Hoofdmenu erotiek shop
"; } print "
"; if($tototal > $nbre_ligne) // 1 { print ""; print ""; print ""; print ""; print ""; print ""; print "
"; // Classement par titre if($HTTP_GET_VARS['page'] == 0) { // Afficher boite de classement $titreOrderLang = explode("|",$titreOrder); $titreOrderLang1 = explode("|",$titre_order_1); $iMax = count($titreOrderLang)-1; print ""; // Afficher classement if(isset($order)){ print " ".$order."";} else { print " Id"; } } else { if(isset($order)){ print " ".CLASSER_PAR." ".$order."";} else { print " ".CLASSER_PAR." Id"; } } // End if page == 0 print ""; // Afficher navigation haut de page include('includes/listNav.php'); print "
"; } // fin 1 else { print "
"; } /////////////// // START TABLE/ /////////////// if($tototal == 0) print "
"; // Si champs vide if($tototal == 0) { print ""; print "
".strtoupper(PAS_DE_PRODUITS_DANS_CETTE_CATEGORIE)."
"; // 0 article dans le tableau print ""; print ""; print ""; print ""; print ""; print "
"; if($HTTP_GET_VARS['target'] == "new" OR $HTTP_GET_VARS['target'] == "promo") { print ""; print ""; print ""; print ""; print ""; print ""; print "
"; print ""; if(!isset($ti[$HTTP_GET_VARS['view']][0])) $ti[$HTTP_GET_VARS['view']][0]="".TOUTES.""; print " ".$ti[$HTTP_GET_VARS['view']][0].""; print "
"; } print "
"; print "
0 ".STRTOLOWER(ARTICLE)." - ".STRTOLOWER(PAGE)." 1 ".DE." 1
"; print "
"; print "
"; } else { print ""; while($a_row = mysql_fetch_array($re2)) { // Si champs pas vide // V?fier si l'article est en promotion $new_price = $a_row['specials_new_price'] ; $old_price = $a_row['products_price'] ; if(empty($new_price)) { $price = PRIX.": $old_price $symbolDevise"; } else { $today = mktime(0,0,0,date("m"),date("d"),date("Y")); $dateMaxCheck = explode("-",$a_row['specials_last_day']); $dateMax = mktime(0,0,0,$dateMaxCheck[1],$dateMaxCheck[2],$dateMaxCheck[0]); $dateDebutCheck = explode("-",$a_row['specials_first_day']); $dateDebut = mktime(0,0,0,$dateDebutCheck[1],$dateDebutCheck[2],$dateDebutCheck[0]); if($dateDebut <= $today and $dateMax >= $today) { $econPourcent = (1-($a_row['specials_new_price']/$a_row['products_price']))*100; $econPourcent = sprintf("%0.2f",$econPourcent)."%"; $price = PRIX.": $old_price $symbolDevise|$new_price $symbolDevise";// removed promo tag , ".ECONOMISEZ." $econPourcent } else { $price = PRIX.": $old_price $symbolDevise"; } } // VĂ©rifier si cet article est dans le caddie if(isset($HTTP_SESSION_VARS['list']) and strstr($HTTP_SESSION_VARS['list'], "+".$a_row['products_ref']."+")) { $caddie_yes = "\"".ARTICLE_PRESENT_DANS_LE_CADDIE."\""; $isThere = "yes"; } else { $caddie_yes = " "; $isThere = "no"; } // Couleurs ligne tableaux include('includes/color_lines_table.php'); print ""; // Bouton article dans le caddie print ""; // Image print ""; } else { print ""; } // titre print ""; // bouton // si l'article a des options if($isThere=="yes") { if($a_row['products_options'] == 'no') { print ""; } else { print ""; } } else { $qt=$a_row[products_qt]; if($a_row['products_options'] == 'no') { print ""; } else { print ""; } } print ""; // texte if ($_SESSION[wholesaler]) $price= PRIX.": ".getwholesaleprice($a_row[products_id])." $symbolDevise"; $ProdNameProdList = nl2br($a_row['products_desc_'.$HTTP_SESSION_VARS['lang']]); $ProdNameProdList = str_replace("", "", $ProdNameProdList); $ProdNameProdList = str_replace("", "", $ProdNameProdList); $ProdNameProdList = str_replace("
", "", $ProdNameProdList); $ProdNameProdList = str_replace("", "", $ProdNameProdList); $ProdNameProdList = str_replace("", "", $ProdNameProdList); print "
"; print ""; print ""; // Ref print ""; print ""; print ""; // Prix print ""; print ""; print ""; } print "
$caddie_yes
"; if($a_row['products_im']=="yes") { print "\"".$a_row['products_name_'.$HTTP_SESSION_VARS['lang']]."\"
".strtoupper($a_row['products_name_'.$HTTP_SESSION_VARS['lang']])."
\"".RETIRER_DU_CADDIE."\"
".(($qt>0)?("
"):(""))." ".ACHETER."
0)?("im/".$HTTP_SESSION_VARS['lang']."/add_caddie.gif"):("im/".$HTTP_SESSION_VARS['lang']."/knop-reseveren.gif"))."\" alt=\"".AJOUTER_AU_CADDIE."\" ".(($qt>0)?("onclick=\"alert('".$a_row['products_name_'.$HTTP_SESSION_VARS['lang']]." ".A_ETE_AJOUTE_DANS_VOTRE_CADDIE."')\">"):(""))."
0)?("im/".$HTTP_SESSION_VARS['lang']."/voir_desc.gif"):("im/".$HTTP_SESSION_VARS['lang']."/knop-reseveren.gif"))."\" border=\"0\">
".strtolower(adjust_text($ProdNameProdList,75,"...[...]"))."
$a_row[gender]
".NREF.": ".strtoupper($a_row['products_ref'])."
$price
"; // END TABLE //////////////////////// //Afficher navigation // //////////////////////// print ""; print ""; print ""; if($tototal > $nbre_ligne) { print ""; } print ""; print "
"; // Classement par categories if(isset($HTTP_GET_VARS['target']) and ($HTTP_GET_VARS['target'] == "new" OR $HTTP_GET_VARS['target'] == "promo")) { while($to = mysql_fetch_array($resultP)) { $categ[] = $to['categories_name_'.$HTTP_SESSION_VARS['lang']]."|".$to['categories_id']; } $categ = array_unique($categ); asort($categ); $categ = array_values($categ); print ""; print ""; print ""; print ""; print ""; print ""; print "
"; print ""; if(isset($HTTP_GET_VARS['view'])) $titleF = $ti[$HTTP_GET_VARS['view']][0]; else $titleF = TOUTES; print " ".$titleF.""; print "
"; } print "
"; // include navigation Bas de page include('includes/listNav.php'); print "
"; print ""; print ""; print ""; print ""; print ""; print "
"; // Article PR?ENT dans votre caddie : Article ABSENT dans votre caddie print "
".ARTICLE_PRESENT_DANS_LE_CADDIE."
"; print "
"; $PageNum = ceil($HTTP_GET_VARS['page']/$nbre_ligne)+1; ($tototal>1)? $article = STRTOLOWER(ARTICLES) : $article = STRTOUPPER(ARTICLE); if(empty($nbr)) $nbr = 1; print "
$tototal $article ".strtolower(EN_STOCK)." - ".PAGE." $PageNum ".DE." $nbr
"; print "
"; print ""; } ?>