"; br(3); DebutTableau("#000000", "1", "0", "80%"); DebutTableau("#354785", "20", "0", "100%"); echo " Pas de liens référencés dans la base de données du site \"$site\" !!! "; FinTableau(); FinTableau(); br(4); echo ""; } else { // ------------------------------------------------------------------------- // // Création du menu de selection des rubrique existantes // // ------------------------------------------------------------------------- // $req2 = "SELECT name_rub FROM " . $tb_rub . " ORDER BY name_rub"; $req2 = mysql_db_query($cfgBase, $req2); echo ""; echo ""; echo ""; while ($rub_exist = mysql_fetch_array($req2)) { echo ""; } echo ""; echo "

"; echo "  $rub_exist[0] \n"; echo "

"; echo ""; br(2); echo "Actuellement " . $nbsites . " sites référencés"; br(2); // ------------------------------------------------------------------------- // // Création du formulaire TOP n (toutes catégories) + Nouveautés // // ------------------------------------------------------------------------- // $req3 = "SELECT * FROM " . $tb_liens . " WHERE valid=1 ORDER BY nb_click DESC LIMIT 0,$topsite"; $req3 = mysql_db_query($cfgBase, $req3); $req4 = "SELECT * FROM " . $tb_liens . " WHERE valid=1 ORDER BY id_lien DESC LIMIT 0,$nouv"; $req4 = mysql_db_query($cfgBase, $req4); $req5 = "SELECT * FROM " . $tb_liens . " WHERE valid=1 ORDER BY nb_click DESC LIMIT 0,$topcat"; $req5 = mysql_db_query($cfgBase, $req5); DebutTableau("#FFFFFF", "1", "0", "100%"); DebutTableau("#5A6BA5", "20", "0", "100%"); DebutTableau("#FFFFFF", "1", "0", "100%"); DebutTableau("#AFBDFF", "20", "0", "100%"); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

"; // Titre TOP n sites toutes catégories echo ""; DebutTableau("", "1", "0", "60%"); echo "TOP $topsite (Toutes catégories)"; FinTableau(); // Contenue TOP n sites toutes catégories DebutTableau("#000000", "1", "0", "60%"); DebutTableau("#354785", "1", "0", "100%"); while ($top_n = mysql_fetch_array($req3)) { echo " \n"; echo "$top_n[1]\n"; echo " ($top_n[7] hits)\n"; br(1); } FinTableau(); FinTableau(); echo ""; echo "

"; // Titre n nouveautés echo ""; DebutTableau("", "1", "0", "60%"); echo "$nouv dernières nouveautés"; FinTableau(); // Contenue n nouveautés DebutTableau("#000000", "1", "0", "60%"); DebutTableau("#354785", "1", "0", "100%"); while ($new = mysql_fetch_array($req4)) { echo " \n"; echo "$new[1]\n"; echo " ($new[7] hits)\n"; br(1); } FinTableau(); FinTableau(); echo ""; echo "

"; echo ""; br(1); // ------------------------------------------------------------------------- // // Création du formulaire qui affiche les n sites les plus visités par // // catégories // // ------------------------------------------------------------------------- // DebutTableau("", "1", "0", "100%"); echo "Les $topcat sites les plus visités par rubriques"; FinTableau(); $sql = "SELECT * FROM " . $tb_rub . " ORDER BY name_rub"; $sql = mysql_db_query($cfgBase,$sql); DebutTableau("#000000", "1", "0", "100%"); DebutTableau("#5A6BA5", "20", "0", "100%"); while ($rub = mysql_fetch_array($sql)) { $sql2 = "SELECT * FROM " . $tb_liens . " WHERE name_rub=\"$rub[1]\" AND valid=1 ORDER BY nb_click DESC LIMIT 0,$topcat"; $sql2 = mysql_db_query($cfgBase, $sql2); $test = mysql_num_rows($sql2); echo ""; echo ""; echo ""; echo ""; if ($test!=0) { while ($site = mysql_fetch_array($sql2)) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } else { echo ""; echo ""; echo ""; } echo "

"; echo " $rub[1] "; echo "

"; echo "  "; echo "$site[1] ($site[7] hits) enregistré le $site[5] à $site[6]"; echo "

"; echo "    $site[4]"; echo "

"; echo "    "; echo "Pas de site enregistrés dans cette rubrique !!!"; echo "

"; echo ""; echo ""; echo ""; echo "

"; echo "

"; } FinTableau(); FinTableau(); // ------------------------------------------------------------------------- // FinTableau(); FinTableau(); echo ""; echo ""; echo ""; echo ""; FinTableau(); FinTableau(); FinTableau(); FinTableau(); } } else { DebutTableau("#000000", "1", "0", "100%"); DebutTableau("#354785", "20", "0", "100%"); echo " Désolé, le serveur MySQL de mon hébergeur est down !!! "; FinTableau(); FinTableau(); } //Un peu de pub quand meme !!! br (2); Pub(); FinHTML(); // ------------------------------------------------------------------------- // // Module de click // // ------------------------------------------------------------------------- // // la fonction de redirection------------------ function redir($url) { echo ""; } if($module == 'click') { $maj = "UPDATE dyna_liens SET nb_click=nb_click+1 WHERE url_lien='$url'"; $maj = mysql_db_query($cfgBase, $maj); echo $maj; redir("$url"); } ?>