prepare('SELECT id_site, titre, date_ajout, date_upd, etat, url, url_pub, c1, c2, c3, description_en, banner, lg_en, lg_fr, lg_it, lg_sp, lg_jp,lg_no, lg_de, popularite, popularite_ip, metaDescription, metaKeywords, url_www FROM sites WHERE (etat = \'A\' or etat = \'F\' or etat = \'T\') AND id_site = :site'); $reponse->execute(array('site' => $site)); } catch (PDOException $e) { require($real.'/requires/php/PDOerror.php'); } while ($donnees = $reponse->fetch()) { $id_site = $donnees['id_site']; $sname = $donnees['titre']; $date_ajout = $donnees['date_ajout']; $date_upd = $donnees['date_upd']; $etat = $donnees['etat']; $url = $donnees['url']; $url_pub = $donnees['url_pub']; $c1 = $donnees['c1']; $c2 = $donnees['c2']; $c3 = $donnees['c3']; $des_en = $donnees['description_en']; $banner = $donnees['banner']; $lg_en = $donnees['lg_en']; $lg_fr = $donnees['lg_fr']; $lg_it = $donnees['lg_it']; $lg_sp = $donnees['lg_sp']; $lg_jp = $donnees['lg_jp']; $lg_no = $donnees['lg_no']; $lg_de = $donnees['lg_de']; $popu = $donnees['popularite']; $ip_last = $donnees['popularite_ip']; $metaDescription = $donnees['metaDescription']; $metaKeywords = $donnees['metaKeywords']; $url_www = $donnees['url_www']; if ($ip != $ip_last){ $popu++; try { $reponse2 = $bdd->prepare('UPDATE sites SET popularite = :popu, popularite_ip = :ip WHERE id_site = :id_site'); $reponse2->execute(array('popu' => $popu, 'ip' => $ip, 'id_site' => $id_site)); } catch (PDOException $e) { require($real.'/requires/php/PDOerror.php'); } } $jour = substr($date_ajout,6,2); $mois = substr($date_ajout,4,2); $annee = substr($date_ajout,0,4); /*if ($url_pub != '') { $iiiurl = $url_pub; }else{ $iiiurl = $url; }*/ $iiiurl = $descendre.'go/'.$url_www.'.'.$www_ext; $url_image = $url; //retirer le http:// $nbc = strlen($url_image); $url_image = substr($url_image,7,$nbc); $url_titre = $url_image; //retirer le www. $nbc = strlen($url_image); $www = substr($url_image,0,4); if ($www=='www.') { $url_image = substr($url_image,4,$nbc); $url_titre = $url_image; } $url_image = str_replace('.','-',"$url_image"); $url_image = str_replace('/','-',"$url_image"); $url_image = str_replace('~','-',"$url_image"); } //langues $lang_fr = ''; $vir = ', '; if ($lg_en == 'y') { $lang_fr .= $vir.'english'; } if ($lg_fr == 'y') { $lang_fr .= $vir.'french'; } if ($lg_sp == 'y') { $lang_fr .= $vir.'spanish/Portuguese'; } if ($lg_it == 'y') { $lang_fr .= $vir.'italian'; } if ($lg_de == 'y') { $lang_fr .= $vir.'german'; } if ($lg_jp == 'y') { $lang_fr .= $vir.'chinese/japanese'; } if ($lg_no == 'y') { $lang_fr .= $vir.'other'; } //retirer la , du debut $nbc = strlen($lang_fr); $lang_fr = substr($lang_fr,2,$nbc); //cat├ęgories $cat_fr = ''; $vir = ', '; switch($etat) { case "T": $req_sqlc = "SELECT id,en,en_abs FROM categories WHERE id = 48 LIMIT 0, 1"; break; case "F": $req_sqlc = "SELECT id,en,en_abs FROM categories WHERE id = 33 LIMIT 0, 1"; break; default: $req_sqlc = "SELECT id,en,en_abs FROM categories WHERE id = :c1 LIMIT 0, 1"; } $reponse = $bdd->prepare($req_sqlc); try { $reponse->execute(array('c1' => $c1)); } catch (PDOException $e) { require($real.'/requires/php/PDOerror.php'); } while ($donnees = $reponse->fetch()) { $idd = $donnees['id']; $fr = $donnees['en']; $n_abs = $donnees['en_abs']; $cat_fr .= ''."".$fr.''.''.$vir; } try { $reponse = $bdd->prepare('SELECT id,en,en_abs FROM categories WHERE id = :c2 LIMIT 0, 1'); $reponse->execute(array('c2' => $c2)); } catch (PDOException $e) { require($real.'/requires/php/PDOerror.php'); } while ($donnees = $reponse->fetch()) { $idd = $donnees['id']; $fr = $donnees['en']; $n_abs = $donnees['en_abs']; $cat_fr .= ''."".$fr.''.''.$vir; $rowc++; } try { $reponse = $bdd->prepare('SELECT id,en,en_abs FROM categories WHERE id = :c3 LIMIT 0, 1'); $reponse->execute(array('c3' => $c3)); } catch (PDOException $e) { require($real.'/requires/php/PDOerror.php'); } while ($donnees = $reponse->fetch()) { $idd = $donnees['id']; $fr = $donnees['en']; $n_abs = $donnees['en_abs']; $cat_fr .= ''."".$fr.''.''.$vir; $rowc++; } //retirer la , $nbc = strlen($cat_fr); $nbc--; $nbc--; $cat_fr = substr($cat_fr,0,$nbc); ?> <?php echo "$sname - $url" ?> - Duck's Feet Links

Languages:

Category:

.jpg" title="" alt="" class="bdr1" /> \n\"$sname"; }} ?>

Back