Introduction :

bonjour à tous,
Ce site est le votre : toutes les photos du rassemblement de Cunlhat que vous m'enverrez seront mises sur ce site afin que tous les internautes en profitent.
L'adresse à laquelle vous pouvez m'envoyer vos photos est xtrem.dj@wanadoo.fr

Le Forum

"; // ------------------------------------------------------------------------- // // Affiche les n dernières discussions de Phorum. // // ------------------------------------------------------------------------- // // Auteur: J-Pierre DEZELUS // // Email: jpdezelus@phpinfo.net // // Web: http://www.phpinfo.net/ // // ------------------------------------------------------------------------- // $cfgHote = "localhost"; $cfgUser = "freewheels"; $cfgPass = "19810902"; $cfgBase = "freewheels_db"; $cfgTable = "free_forum"; $cfgRep = "phorum/"; $cfgRead = "read.php3"; $nbMsgForum = 10; // Nbre de discussions à afficher // connexion à la base mysql_connect($cfgHote, $cfgUser, $cfgPass); echo "Les ".$nbMsgForum." dernières discussions du forum - "; // Nb msg aujourd'hui $sql = "SELECT COUNT(id) "; $sql .= "FROM ".$cfgTable." "; $sql .= "WHERE approved = 'Y' AND datestamp LIKE '".date("Y-m-d")."%'"; $resultat = mysql_db_query($cfgBase, $sql); $enr = mysql_fetch_array($resultat); echo "".($nb = $enr[0])." message".($nb > 1 ? "s" : ""); echo " posté".($nb > 1 ? "s" : "")." aujourd'hui"; // Nb msg hier $date = date("d/m/Y"); $elts = explode("/", $date); $hier = mktime(0, 0, 0, $elts[1], $elts[0]-1, $elts[2]); $sql = "SELECT COUNT(id) "; $sql .= "FROM ".$cfgTable." "; $sql .= "WHERE approved = 'Y' AND datestamp LIKE '".date("Y-m-d", $hier)."%'"; $resultat = mysql_db_query($cfgBase, $sql); $enr = mysql_fetch_array($resultat); echo " [".$enr[0]." hier]"; echo "

\n"; // Affichage des fils de discussion et du nombre de réponses $sql = "SELECT id,subject,datestamp "; $sql .= "FROM ".$cfgTable." "; $sql .= "WHERE approved = 'Y' AND parent = 0 "; $sql .= "ORDER BY id DESC LIMIT 0,".$nbMsgForum; $resultat = mysql_db_query($cfgBase, $sql); while ($message = mysql_fetch_array($resultat)) { $sql2 = "SELECT count(*) "; $sql2 .= "FROM ".$cfgTable." "; $sql2 .= "WHERE approved = 'Y' AND thread=".$message[0]." AND parent <> 0"; $resultat2 = mysql_db_query($cfgBase, $sql2); $nbRep = mysql_fetch_array($resultat2); echo " - "; $date = substr($message[2], 8, 2) . "/"; $date .= substr($message[2], 5, 2) . " "; $date .= substr($message[2], 11, 5); echo "[".$date."] "; if (strlen($message[1]) > 40) $msg = substr($message[1], 0, 40)." ..."; else $msg = $message[1]; $lien = $cfgRep.$cfgRead."?f=1&loc=0&i=".$message[0]."&t=".$message[0]; echo "".$msg.""; // nb de réponses if ($nbRep[0] > 0) echo " [".$nbRep[0]."]"; echo "
\n"; } ?>