| Server IP : 109.234.164.53 / Your IP : 216.73.216.110 Web Server : Apache System : Linux cervelle.o2switch.net 4.18.0-553.32.1.lve.el8.x86_64 #1 SMP Thu Dec 19 13:14:03 UTC 2024 x86_64 User : computer3 ( 1098) PHP Version : 7.1.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/computer3/litsolide.com/ |
Upload File : |
<?php
if (($ses_marq > 0) AND ($ses_marq2 < 1)){
//////////////////////////////////////////////////////
if ($px_par_page =='1'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.avis, p.note, p.name, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
LEFT JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
LEFT JOIN marques m
ON m.id= pm.id_marque
INNER JOIN session_list ss
ON ss.cha_var1 = pm.id_marque
WHERE p.status = 1 AND p.status2 = 0 AND ss.session = :session AND pp.position = 1
GROUP BY p.id ORDER BY p.date_insere DESC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('session' => $session));
}
else if ($px_par_page =='2'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.avis, p.note, p.name, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
LEFT JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
LEFT JOIN marques m
ON m.id= pm.id_marque
INNER JOIN session_list ss
ON ss.cha_var1 = pm.id_marque
WHERE p.status = 1 AND p.status2 = 0 AND ss.session = :session AND pp.position = 1
GROUP BY p.id ORDER BY p.price ASC, p.date_insere DESC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('session' => $session));
}
else if ($px_par_page =='3'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.avis, p.note, p.name, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
LEFT JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
LEFT JOIN marques m
ON m.id= pm.id_marque
INNER JOIN session_list ss
ON ss.cha_var1 = pm.id_marque
WHERE p.status = 1 AND p.status2 = 0 AND ss.session = :session AND pp.position = 1
GROUP BY p.id ORDER BY p.price DESC, p.date_insere DESC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('session' => $session));
}
else {
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.avis, p.note, p.name, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
LEFT JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
LEFT JOIN marques m
ON m.id= pm.id_marque
INNER JOIN session_list ss
ON ss.cha_var1 = pm.id_marque
WHERE p.status = 1 AND p.status2 = 0 AND ss.session = :session AND pp.position = 1
GROUP BY p.id ORDER BY p.position ASC, p.date_insere DESC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('session' => $session));
}
} else if (($ses_marq > 0) AND ($ses_marq2 > 0)){
/////////////////////////////////////////////////
if ($px_par_page =='1'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.avis, p.note, p.name, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
LEFT JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
INNER JOIN session_list ss
ON ss.cha_var1 = pm.id_marque
LEFT JOIN marques m
ON m.id= pm.id_marque
INNER JOIN session_list2 sd
ON sd.cha_var1 = pc.id_category
WHERE p.status = 1 AND p.status2 = 0 AND ss.session = :session AND sd.session = :session AND pp.position = 1
GROUP BY p.id ORDER BY p.date_insere DESC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('session' => $session));
}
else if ($px_par_page =='2'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.avis, p.note, p.name, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
LEFT JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
INNER JOIN session_list ss
ON ss.cha_var1 = pm.id_marque
LEFT JOIN marques m
ON m.id= pm.id_marque
INNER JOIN session_list2 sd
ON sd.cha_var1 = pc.id_category
WHERE p.status = 1 AND p.status2 = 0 AND ss.session = :session AND sd.session = :session AND pp.position = 1
GROUP BY p.id ORDER BY p.price ASC, p.date_insere DESC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('session' => $session));
}
else if ($px_par_page =='3'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.avis, p.note, p.name, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
LEFT JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
INNER JOIN session_list ss
ON ss.cha_var1 = pm.id_marque
LEFT JOIN marques m
ON m.id= pm.id_marque
INNER JOIN session_list2 sd
ON sd.cha_var1 = pc.id_category
WHERE p.status = 1 AND p.status2 = 0 AND ss.session = :session AND sd.session = :session AND pp.position = 1
GROUP BY p.id ORDER BY p.price DESC, p.date_insere DESC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('session' => $session));
}
else {
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.avis, p.note, p.name, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
LEFT JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
INNER JOIN session_list ss
ON ss.cha_var1 = pm.id_marque
LEFT JOIN marques m
ON m.id= pm.id_marque
INNER JOIN session_list2 sd
ON sd.cha_var1 = pc.id_category
WHERE p.status = 1 AND p.status2 = 0 AND ss.session = :session AND sd.session = :session AND pp.position = 1
GROUP BY p.id ORDER BY p.date_insere DESC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('session' => $session));
}
} else if (($ses_marq < 1) AND ($ses_marq2 > 0)){
/////////////////////////////////////////////////
if ($px_par_page =='1'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.avis, p.note, p.name, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
LEFT JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
LEFT JOIN marques m
ON m.id= pm.id_marque
INNER JOIN session_list2 sd
ON sd.cha_var1 = pc.id_category
WHERE p.status = 1 AND p.status2 = 0 AND sd.session = :session AND pp.position = 1
GROUP BY p.id ORDER BY p.date_insere DESC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('session' => $session));
}
else if ($px_par_page =='2'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.avis, p.note, p.name, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
LEFT JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
LEFT JOIN marques m
ON m.id= pm.id_marque
INNER JOIN session_list2 sd
ON sd.cha_var1 = pc.id_category
WHERE p.status = 1 AND p.status2 = 0 AND sd.session = :session AND pp.position = 1
GROUP BY p.id ORDER BY p.price ASC, p.date_insere DESC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('session' => $session));
}
else if ($px_par_page =='3'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.avis, p.note, p.name, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
LEFT JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
LEFT JOIN marques m
ON m.id= pm.id_marque
INNER JOIN session_list2 sd
ON sd.cha_var1 = pc.id_category
WHERE p.status = 1 AND p.status2 = 0 AND sd.session = :session AND pp.position = 1
GROUP BY p.id ORDER BY p.price DESC, p.date_insere DESC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('session' => $session));
}
else {
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.avis, p.note, p.name, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
LEFT JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
LEFT JOIN marques m
ON m.id= pm.id_marque
INNER JOIN session_list2 sd
ON sd.cha_var1 = pc.id_category
WHERE p.status = 1 AND p.status2 = 0 AND sd.session = :session AND pp.position = 1
GROUP BY p.id ORDER BY p.date_insere DESC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('session' => $session));
}
} else {
/////////////////////////////////////////////////
if ($px_par_page =='1'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.avis, p.note,p.name, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
LEFT JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
LEFT JOIN marques m
ON m.id= pm.id_marque
WHERE p.status = 1 AND p.status2 = 0 AND pp.position = 1
GROUP BY p.id ORDER BY p.date_insere DESC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute();
}
else if ($px_par_page =='2'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.avis, p.note, p.name, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
LEFT JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN marques m
ON m.id= pm.id_marque
WHERE p.status = 1 AND p.status2 = 0 AND pp.position = 1
GROUP BY p.id ORDER BY p.price ASC, p.date_insere DESC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute();
}
else if ($px_par_page =='3'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.avis, p.note, p.name, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
LEFT JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
LEFT JOIN marques m
ON m.id= pm.id_marque
WHERE p.status = 1 AND p.status2 = 0 AND pp.position = 1
GROUP BY p.id ORDER BY p.price DESC, p.date_insere DESC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute();
}
else {
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.name, p.avis, p.note, p.cle_tva, p.vignette, p.meta_keywords, p.price, p.discount, pp.picture, p.hstock, p.stock, p.h_achat_direct, m.name AS lamarque FROM products p
INNER JOIN products_pictures pp
ON pp.id_product = p.id
INNER JOIN products_categories pc
ON pc.id_product = p.id
LEFT JOIN products_marques pm
ON pm.id_product = p.id
LEFT JOIN products_attributes pa
ON pa.id_product = p.id
LEFT JOIN marques m
ON m.id= pm.id_marque
WHERE p.status = 1 AND p.status2 = 0 AND pp.position = 1
GROUP BY p.id ORDER BY p.date_insere DESC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute();
}
}
$results = $test->fetchAll();
$smarty->assign("products", $results);
/*
// Si pas d'attributs........
foreach ($_SESSION['cart'] as $num => $prod) {
foreach ($prod[0] as $key => $value) {
if ($prod[0]['product'] == $p_id) {
$smarty->assign("vall", $value);
}
}
}
*/
?>