Un système de news sur son site lié au forum

Code :
<?php



$hotedb = "localhost"; // Host

$utilisateurdb = "forum"; // utilisateur mysql

$passdb = "s9rwt6AZdTEGWcAas9rwt6AZdTEGWcAa"; // pass de l'utilisateur

$db = "forum"; //nom de la db

$prefixe = "mybb_"; //Prefixe des tables dans mybb



mysql_connect($hotedb, $utilisateurdb, $passdb, $db);



$topics = "SELECT * FROM `".$db."`.`".$prefixe."threads` WHERE `fid` = '3' ORDER BY `dateline` DESC;";

$rtopics = mysql_query($topics) or die('Erreur: '.$topics.'<br />'.mysql_error());





    if (mysql_num_rows($rtopics) == 0) //Vérifie si des News existent. Si oui, on les affiche; sinon, on affiche un message

        {

        echo("Aucune News n'a été rédigée pour le moment.");

        mysql_free_result($rtopics);

        }

    else

        {

        while ($data = mysql_fetch_array($rtopics)) {

        

            $idtopic = $data['tid'];

            $posts = "SELECT * FROM `".$db."`.`".$prefixe."posts` WHERE `tid` = '".$idtopic."' ORDER BY `dateline` ASC LIMIT 1;";

            $rposts = mysql_query($posts) or die('Erreur: '.$posts.'<br />'.mysql_error());

            $affichernews = mysql_fetch_array($rposts);

            

            $titre = $data['subject'];

            $auteur = $affichernews['username'];

            $date = $affichernews['dateline'];

            $message = $affichernews['message'];

            $dateconvertie = date("r",$date);

            $datanglais = array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Dec", "Mon,", "Tue,", "Wed,", "Thu,", "Fri,", "Sat,", "Sun,");

            $datfrancais   = array("Janvier", "Février", "Mars", "Avril", "Mai", "Juin", "Juillet", "Août", "Septembre", "Octobre", "Novembre", "Décembre", "Lundi", "Mardi", "Mercredi", "Jeudi", "Vendredi", "Samedi", "Dimanche");

            $dateok = str_replace($datanglais, $datfrancais, $dateconvertie);

            echo("<table rules=\"rows\" frame=\"box\" width=\"500\"><tr><td>Sujet: <u>".$titre."</u></td></tr><tr><td width=\"200\" align=left>Rédigée par <font color=\"green\">".$auteur."</font></td><td width=\"300\" align=right>Le ".$dateok."GMT</td></tr></table><table rules=\"rows\" frame=\"box\" width=\"500\"><tr><td>");

            

            $bbcode = array("\n", "[color=", "]", "[/color", "[b", "[/b", "[u", "[/u");

            $codehtml   = array("<br>", "<font color=", ">", "</font", "<b", "</b", "<u", "</u");

            

            echo $newphrase = str_replace($bbcode, $codehtml, $message);

            echo("<br><a href=\"./forum/showthread.php?tid=".$idtopic."\">Voir les commentaires sur le forum.</a></td></tr></table><br>");

            mysql_free_result($rposts);

            mysql_feee_result($rtopics);

            }

        mysql_free_result($rtopics);

        }

    mysql_close();    

?>