| 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/ODLDDD_2/ |
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.name, 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 pc.id_category = :cat AND ss.session = :session AND pp.position = 1
AND (SELECT COUNT(*) FROM products_categories WHERE id_product = p.id AND id_category = :cat) > 0
GROUP BY p.id ORDER BY p.position ASC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('cat' => $cat, 'session' => $session));
}
else if ($px_par_page =='2'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.name, 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 pc.id_category = :cat AND ss.session = :session AND pp.position = 1
AND (SELECT COUNT(*) FROM products_categories WHERE id_product = p.id AND id_category = :cat) > 0
GROUP BY p.id ORDER BY p.price ASC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('cat' => $cat, 'session' => $session));
}
else if ($px_par_page =='3'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.name, 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 pc.id_category = :cat AND ss.session = :session AND pp.position = 1
AND (SELECT COUNT(*) FROM products_categories WHERE id_product = p.id AND id_category = :cat) > 0
GROUP BY p.id ORDER BY p.price DESC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('cat' => $cat, 'session' => $session));
}
else {
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.name, 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 pc.id_category = :cat AND ss.session = :session AND pp.position = 1
AND (SELECT COUNT(*) FROM products_categories WHERE id_product = p.id AND id_category = :cat) > 0
GROUP BY p.id ORDER BY p.position ASC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('cat' => $cat, '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.name, 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
INNER JOIN session_list2 sd
ON sd.cha_var1 = pc.id_category
WHERE p.status = 1 AND ss.session = :session AND sd.session = :session AND pp.position = 1
AND (SELECT COUNT(*) FROM products_categories WHERE id_product = p.id AND id_category = :cat) > 0
GROUP BY p.id ORDER BY p.position ASC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('session' => $session, 'cat' => $cat));
}
else if ($px_par_page =='2'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.name, 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
INNER JOIN session_list2 sd
ON sd.cha_var1 = pc.id_category
WHERE p.status = 1 AND ss.session = :session AND sd.session = :session AND pp.position = 1
AND (SELECT COUNT(*) FROM products_categories WHERE id_product = p.id AND id_category = :cat) > 0
GROUP BY p.id ORDER BY p.price ASC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('session' => $session, 'cat' => $cat));
}
else if ($px_par_page =='3'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.name, 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
INNER JOIN session_list2 sd
ON sd.cha_var1 = pc.id_category
WHERE p.status = 1 AND ss.session = :session AND sd.session = :session AND pp.position = 1
AND (SELECT COUNT(*) FROM products_categories WHERE id_product = p.id AND id_category = :cat) > 0
GROUP BY p.id ORDER BY p.price DESC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('session' => $session, 'cat' => $cat));
}
else {
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.name, 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
INNER JOIN session_list ss
ON ss.cha_var1 = pm.id_marque
INNER JOIN session_list2 sd
ON sd.cha_var1 = pc.id_category
WHERE p.status = 1 AND ss.session = :session AND sd.session = :session AND pp.position = 1
AND (SELECT COUNT(*) FROM products_categories WHERE id_product = p.id AND id_category = :cat) > 0
GROUP BY p.id ORDER BY p.position ASC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('session' => $session, 'cat' => $cat));
}
} 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.name, 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 sd.session = :session AND pp.position = 1
AND (SELECT COUNT(*) FROM products_categories WHERE id_product = p.id AND id_category = :cat) > 0
GROUP BY p.id ORDER BY p.position ASC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('session' => $session, 'cat' => $cat));
}
else if ($px_par_page =='2'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.name, 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 sd.session = :session AND pp.position = 1
AND (SELECT COUNT(*) FROM products_categories WHERE id_product = p.id AND id_category = :cat) > 0
GROUP BY p.id ORDER BY p.price ASC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('session' => $session, 'cat' => $cat));
}
else if ($px_par_page =='3'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.name, 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 sd.session = :session AND pp.position = 1
AND (SELECT COUNT(*) FROM products_categories WHERE id_product = p.id AND id_category = :cat) > 0
GROUP BY p.id ORDER BY p.price DESC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('session' => $session, 'cat' => $cat));
}
else {
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.name, 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 sd.session = :session AND pp.position = 1
AND (SELECT COUNT(*) FROM products_categories WHERE id_product = p.id AND id_category = :cat) > 0
GROUP BY p.id ORDER BY p.position ASC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('session' => $session, 'cat' => $cat));
}
} else {
/////////////////////////////////////////////////
if ($px_par_page =='1'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.name, 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 pc.id_category = :cat AND pp.position = 1
GROUP BY p.id ORDER BY p.position ASC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('cat' => $cat));
}
else if ($px_par_page =='2'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.name, 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 pc.id_category = :cat AND pp.position = 1
GROUP BY p.id ORDER BY p.price ASC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('cat' => $cat));
}
else if ($px_par_page =='3'){
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.name, 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 pc.id_category = :cat AND pp.position = 1
GROUP BY p.id ORDER BY p.price DESC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('cat' => $cat));
}
else {
$test= $GLOBALS['bdd']->prepare('SELECT DISTINCT pa.id_attribute, p.seo, p.id, p.name, 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 pc.id_category = :cat AND pp.position = 1
GROUP BY p.id ORDER BY p.position ASC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
$test->execute(array('cat' => $cat));
}
}
$results = $test->fetchAll();
$smarty->assign("products", $results);
?>