require_once("./inc/dat/brandm.inc");
function sid_code($sid,$code) {
$zmiana1 = array('+','/','=');
$zmiana2 = array('-','_','.');
if ($code == 1) {
$sid = base64_encode($sid);
$sid = str_replace($zmiana1, $zmiana2, $sid);
$sid = substr($sid, 9, strlen($sid)).'kTi'.substr($sid, 0, 9);
} else {
$sid = substr($sid, -9).substr($sid, 0, strlen($sid)-9-3);
$sid = str_replace($zmiana2, $zmiana1, $sid);
$sid = base64_decode($sid);
}
return $sid;
}
$search=array("Ą","ą","Ć","ć","Ę","ę","Ł","ł","Ń","ń","Ś","ś","Ó","ó","Ż","ż","Ź","ź"," ","&","ü","Ü","ö","Ö","ä","Ä","ß","a","á","é","a","ő","č","A","ú","o","đ","í","e","ř","/",".","--");
$replace=array("a","a","c","c","e","e","l","l","n","n","s","s","o","o","z","z","z","z","-","-and-","ue","ue","oe","oe","ae","ae","ss","a","a","e","a","o","c","A","u","o","d","i","e","r","-","-","-");
function txtcut($title,$max) {
if (strlen($title)>$max) {
$title = substr($title, 0, $max-1);
$pos = strpos($title, ' ',$max-10);
if ($pos === false) {
$title .= '...';
} else {
$title = substr($title, 0, $pos).'...';
}
}
return $title;
}
function pages($url,$url2,$page,$pages) {
if ($pages>1) {
echo "
Page: ";
if ($page <> 1) {
$pagep = $page - 1;
if ($page == 2) {
echo "Précédente";
} else {
echo "Précédente";
}
}
$start = 1;
if ($page < $pages - 10) {
$pages = $page + 10;
if ($pages - 20 > 0) {
$start = $pages - 20;
}
}
for($i=$start;$i<=$pages;$i++){
if($i==$page){
print " $i ";
}else{
if ($i == 1) {
print " $i ";
} else {
print " $i ";
}
}
}
if ($page <> $pages) {
$page++;
echo "Suivante";
}
echo "
";
}
}
//$kat = array("All","Sandals","Slippers","Boots","Lace up Shoes","Slip on Shoes");
$kat = array("Toutes","Bottes","Bottines","Chaussons","Baskets basses","Baskets montantes","Tongs","Sandales","Espadrilles","Mocassins","Non spécifié","Derbies","Chaussures bateau", "Richelieus", "Baskets", "Chaussures de sport", "Chaussures à lacets");
$id_kat = array("0","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16");
$size = array("37","37.5","38","38.5","39","39.5","40","40.5","41","41.5","42","42.5","43","43.5","44","44.5","45","45.5","46","46.5","47","47.5","48","48.5","49");
if ($_GET['s']) {
$_GET['s'] = htmlspecialchars(stripslashes(trim($_GET['s'])), ENT_QUOTES);
for ($i=0;$i query($query0);
$r = $stmt -> fetch();
if ($r[0]) {
$s_brand = $r[0];
$title .= ' - '.$s_brand;
$link_m = '/marque-'.$_GET['m'];
}
$query3 = "(brand_link LIKE '".$_GET['m']."') and ";
}
$coltab = array("Toutes", "Blanc", "Gris", "Beige", "Marron", "Noir", "Bleu", "Turquoise", "Petrole", "Vert", "Kaki", "Jaune", "Orange", "Rouge", "Rose", "Lilas", "Or", "Argent", "Multicolore");
$coltab1 = array("Toutes", "blanc", "gris", "beige", "marron", "noir", "bleu", "turquoise", "petrole", "vert", "kaki", "jaune", "orange", "rouge", "rose", "lilas", "or", "argent", "multicolore");
$coltab2 = array("Toutes", "blanches", "grises", "beiges", "marron", "noires", "bleues", "turquoise", "petrole", "vertes", "kaki", "jaunes", "orange", "rouges", "roses", "lilas", "or", "argent", "multicolores");
if ($_GET['f']) {
$_GET['f'] = htmlspecialchars(stripslashes(trim($_GET['f'])), ENT_QUOTES);
$link_f = '/colour-'.$_GET['f'];
foreach ($coltab1 as $key => $val) {
if ($_GET['f'] == $val) {
//$s_farbe = $coltab[$key];
$idf = $key;
$title .= ' - '.$coltab[$idf];
$link_f = '/couleur-'.$coltab1[$idf];
$s_farbe = $coltab[$idf];
break;
}
}
if ($_GET['f'] =='non-specifie') {
$idf='0';
$link_f = '/couleur-non-specifie';
}
$query4 = "(col='$idf') and ";
}
if ($idk) {
$query1 = "((category='$idk') or (category2='$idk') or (category3='$idk')) and ";
}
if ($s_size) {
$tmp = str_replace('.','_',$s_size);
$query2 = "(s$tmp = '1') and ";
}
if ($_GET['promos']) {
$_GET['promos'] = htmlspecialchars(stripslashes(trim($_GET['promos'])), ENT_QUOTES);
if ($_GET['promos']=='promos') {
$query5 = "(priceold>price) and ";
$sale = ' checked="checked"';
$link_sale = '/promos';
$title .= ' - Promos %';
}
}
$query0 = "SELECT count(*) FROM fr_shoes_m WHERE ";
$query0 .= $query1;
$query0 .= $query2;
$query0 .= $query3;
$query0 .= $query4;
$query0 .= $query5;
$query0 .= " (ok=1)";
$stmt = $pdo -> query($query0);
$r = $stmt -> fetch();
if ($_GET['p'] == '') {
$page = 1;
} else {
$page = $_GET['p'];
}
$offset = ($page-1)*20;
$pages = ceil($r[0]/20);
$alle = $r[0];
if (!$alle) $_GET['d']='e';
if ($page>$pages) $_GET['d']='e';
?>
echo ' ';
echo ' ';
if ($alle) $site_index = ''; else $site_index = 'no';
if (($page>$pages) && ($alle)) {
$site_index = 'no';
@include('./inc/canonical.inc');
}
echo ' ';
echo ' Chaussures Hommes - '.$title.'';
?>
Catégorie
$tabc = array_fill(0, 20, 0);
$query0 = "SELECT category, count(*) FROM fr_shoes_m WHERE ";
$query0 .= $query2;
$query0 .= $query3;
$query0 .= $query4;
$query0 .= $query5;
$query0 .= " (ok=1) and (category<>0) GROUP BY category";
$stmt = $pdo -> query($query0);
while($r = $stmt -> fetch()) {
$tabc[$r[0]] += $r[1];
}
$query0 = "SELECT category2, count(*) FROM fr_shoes_m WHERE ";
$query0 .= $query2;
$query0 .= $query3;
$query0 .= $query4;
$query0 .= $query5;
$query0 .= " (ok=1) and (category2<>0) GROUP BY category2";
$stmt = $pdo -> query($query0);
while($r = $stmt -> fetch()) {
$tabc[$r[0]] += $r[1];
}
$tmp = [];
$all = 0;
for ($i=1;$i<20;$i++) {
if (array_key_exists($i, $tabc) && $tabc[$i] > 0) {
$link1=str_replace($search,$replace,$kat[$i]);
$link1 =strtolower(preg_replace("/[^a-z0-9-]/i", "", $link1));
if (($idk0) && ($idk0==$i)) {
$tmp["$kat[$i]"] = '- '.$kat[$i].' ('.$tabc[$i].')
';
$tmpsel1["$kat[$i]"] = '';
} else {
$tmp["$kat[$i]"] = '- '.$kat[$i].' ('.$tabc[$i].')
';
$tmpsel1["$kat[$i]"] = '';
}
$all += $tabc[$i];
}
}
if ($idk0==0) {
echo '- Toutes ('.$all.')
';
$sel1 = '';
} else {
echo '- Toutes ('.$all.')
';
$sel1 = '';
}
ksort($tmp);
foreach ($tmp as $key => $val) {
echo $val;
$sel1 .= $tmpsel1[$key];
}
?>
Taille
$query0 = "SELECT sum(`s37`), sum(`s37_5`), sum(`s38`), sum(`s38_5`), sum(`s39`), sum(`s39_5`), sum(`s40`), sum(`s40_5`), sum(`s41`), sum(`s41_5`), sum(`s42`), sum(`s42_5`), sum(`s43`), sum(`s43_5`), sum(`s44`), sum(`s44_5`), sum(`s45`), sum(`s45_5`), sum(`s46`), sum(`s46_5`), sum(`s47`), sum(`s47_5`), sum(`s48`), sum(`s48_5`), sum(`s49`) FROM fr_shoes_m WHERE ";
$query0 .= $query1;
$query0 .= $query3;
$query0 .= $query4;
$query0 .= $query5;
$query0 .= " (ok=1)";
if ($_GET['g']) {
echo '- Toutes
';
$sel2 = '';
} else {
echo '- Toutes
';
$sel2 = '';
}
$stmt = $pdo -> query($query0);
$r = $stmt -> fetch();
for ($i=0;$i0) {
$link1=str_replace('.','-',$size[$i]);
if (($idg==$i) && ($_GET['g'])) {
echo '- '.$size[$i].' ('.$r[$i].')
';
$sel2 .= '';
} else {
echo '- '.$size[$i].' ('.$r[$i].')
';
$sel2 .= '';
}
}
}
?>
Marque
$query0 = "SELECT count(*), count(DISTINCT brand) FROM fr_shoes_m WHERE ";
$query0 .= $query1;
$query0 .= $query2;
$query0 .= $query4;
$query0 .= $query5;
$query0 .= " (ok=1)";
$stmt = $pdo -> query($query0);
$r = $stmt -> fetch();
$all = $r[0];
$cbrands = $r[1];
$query0 = "SELECT brand, count(*) as rsum FROM fr_shoes_m WHERE ";
$query0 .= $query1;
$query0 .= $query2;
$query0 .= $query4;
$query0 .= $query5;
$query0 .= " (ok=1) GROUP BY brand ORDER BY rsum DESC LIMIT 200";
$stmt = $pdo -> query($query0);
$num_rows = $stmt->rowCount();
while ($r = $stmt->fetch()) {
$ibrands[$r['brand']] = $r['rsum'];
}
if ($ibrands) {
ksort($ibrands);
if ($s_brand) {
echo '- Toutes ('.$all.')
';
} else {
echo '- Toutes ('.$all.')
';
}
foreach ($ibrands as $key => $val) {
$link1=str_replace($search,$replace,$key);
$link1 =strtolower(preg_replace("/[^a-z0-9-]/i", "", $link1));
if (($_GET['m']) && ($_GET['m']==$link1)) {
echo '- '.$key.' ('.$val.')
';
} else {
echo '- '.$key.' ('.$val.')
';
}
}
}
?>
Couleur
$query0 = "SELECT col, count(*) FROM fr_shoes_m WHERE ";
$query0 .= $query1;
$query0 .= $query2;
$query0 .= $query3;
$query0 .= $query5;
if (($idf) || ($_GET['f'] =='non-specifie')) {
$query0 .= " (ok=1) and (col<>8) GROUP BY col";
$stmt = $pdo -> query($query0);
$sum = 0;
while($r = $stmt -> fetch()) {
$sum += $r[1];
$rcol[$r[0]] = $r[1];
}
echo '
';
$rest = $rcol[0];
unset($rcol[0]);
} else {
$query0 .= " (ok=1) and (col<>0) and (col<>8) GROUP BY col";
$stmt = $pdo -> query($query0);
$sum = 0;
while($r = $stmt -> fetch()) {
$sum += $r[1];
$rcol[$r[0]] = $r[1];
}
echo '
';
$rest = $alle-$sum;
}
if ($rcol) {
foreach ($rcol as $key1 => $val1) {
foreach ($coltab as $key => $val) {
if ($key1==$key) {
if ($key==$idf) {
echo '
';
} else {
echo '
';
}
}
}
}
}
if (($_GET['f'] =='non-specifie') && ($alle)) {
echo '
';
} else {
if ($rest>0) {
echo '
';
}
}
?>
Prix
$query0 = "SELECT count(*) FROM fr_shoes_m WHERE ";
$query0 .= $query1;
$query0 .= $query2;
$query0 .= $query3;
$query0 .= $query4;
if ($link_sale) {
$query0 .= " (ok=1)";
$stmt = $pdo -> query($query0);
$r = $stmt -> fetch();
echo '- Toutes ('.$r[0].')
';
echo '- Promos ('.$alle.')
';
$price_sale = $alle;
} else {
$query0 .= "(priceold>price) and ";
$query0 .= " (ok=1)";
$stmt = $pdo -> query($query0);
$r = $stmt -> fetch();
echo '- Toutes ('.$alle.')
';
if ($r[0]>0) echo '- Promos ('.$r[0].')
';
$price_sale = $r[0];
}
?>
if ($link_sale && ($page==1) && !$idg && !$idk & !$idm & !$idf) @include('./inc/sale.inc');
if ($_GET['d'] !== 'e') {
echo <<
echo '';
if ($s_kat) {
if ($s_kat=='Non spécifié') {
echo 'Chaussures ';
} else {
echo $s_kat.' ';
}
} else {
echo 'Chaussures Hommes ';
}
if ($s_brand) {
echo $s_brand.' ';
}
if ($idf) {
echo $coltab2[$idf].' ';
}
if ($s_size) {
echo ' taille '.$s_size.' ';
}
if ($link_sale) {
echo '- Promos %';
}
echo '
';
if ($s_kat=='Non spécifié') {
echo 'Non spécifié
';
}
echo ''.$alle.' articles trouvés. Page '.$page.' / '.$pages.'.
';
?>
if ($_GET['a']) {
$_GET['a'] = htmlspecialchars(stripslashes(trim($_GET['a'])), ENT_QUOTES);
if ($_GET['a']==2) {
$sort = 2;
echo 'Trier par: Les moins chers / Les plus chers / Marque A-Z / Marque Z-A';
$query_o = "ORDER BY price DESC";
} else if ($_GET['a']==3) {
$sort = 3;
echo 'Trier par: Les moins chers / Les plus chers / Marque A-Z / Marque Z-A';
$query_o = "ORDER BY brand ASC";
} else if ($_GET['a']==4) {
$sort = 4;
echo 'Trier par: Les moins chers / Les plus chers / Marque A-Z / Marque Z-A';
$query_o = "ORDER BY brand DESC";
}
} else {
echo 'Trier par: Les moins chers / Les plus chers / Marque A-Z / Marque Z-A';
$query_o = "ORDER BY price ASC";
}
?>
$query = "SELECT id, name, description, brand, size, price, priceold, availability, dir, thumb, product_url, shop_name, thumb1, shipping_cost FROM fr_shoes_m WHERE ";
$query .= $query1;
$query .= $query2;
$query .= $query3;
$query .= $query4;
$query .= $query5;
$query .= " (ok=1)";
$query .= $query_o;
$query .= " LIMIT $offset, 20";
$stmt = $pdo -> query($query);
while($row = $stmt -> fetch()) {
echo '';
echo '';
if ($row['dir']<>0) {
echo '';
}
$fullprice = $row[price]+$row[shipping_cost];
$sale='';
if (($row["priceold"]==0) || ($row["priceold"]<=$row["price"])) $row["priceold"]=''; else $sale = round(($row["priceold"]-$row["price"])*100/$row["priceold"]);
$row[price] = str_replace('.',',',$row[price]);
if (($page==1) && (!$price_from)) $price_from = $row[price];
$row[priceold] = str_replace('.',',',$row[priceold]);
$row[description] = txtcut($row[description],150);
$row[size] = rtrim($row[size],',');
echo ' | ';
echo ''.$row[name].' '.$row[description].' | ';
$link1=str_replace($search,$replace,$row[brand]);
$link1 =strtolower(preg_replace("/[^a-z0-9-]/i", "", $link1));
echo 'Marque: '.$row[brand].' ';
echo 'Taille: '.$row[size].' | ';
echo '€ '.$row[price];
if ($row["priceold"]) {
echo " € ".$row["priceold"]."";
}
echo '';
if ($sale) {
echo ' -'.$sale.'% ';
}
if ($row[shipping_cost]=='0') {
echo 'Livraison gratuite ';
} else {
$row[shipping_cost] = number_format($row[shipping_cost], 2, ',', '');
echo 'Livraison: €'.$row[shipping_cost].' ';
}
$fullprice = number_format($fullprice, 2, ',', '');
echo 'Prix global: €'.$fullprice.' ';
if ($row[availability]<>'') {
echo 'Availability: '.$row[availability].' ';
}
echo 'Boutique: '.$row[shop_name].' | ';
$par = sid_code($row[product_url],1);
echo ' | ';
echo '
';
}
echo '
';
if ($_GET['a']) {
pages("homme{$link_s}{$link_g}{$link_m}{$link_f}{$link_sale},a$sort",".html",$page,$pages);
} else {
pages("homme{$link_s}{$link_g}{$link_m}{$link_f}{$link_sale}","",$page,$pages);
}
if ($_GET['d'] !== 'e') {
echo <<