ooopsss

<?php  

    $lan_file = e_PLUGIN."e107bb/languages/".e_LANGUAGE.".php";

    require_once(file_exists($lan_file) ? $lan_file :  e_PLUGIN."e107bb/languages/English.php");



    $gen = new convert;



    $text = "";



    if(defined("PHPBB_PREFIX")) {

    $text .="<div style=\"text-align: center;\">

    <table style=\"width: auto;\" class=\"fborder\">

    <tbody><tr>

    <td style=\"width: 5%;\" class=\"forumheader\">&nbsp;</td>

    <td style=\"width: 45%;\" class=\"forumheader\">Sujets</td>

    <td style=\"width: 15%; text-align: center;\" class=\"forumheader\">Auteur</td>

    <td style=\"width: 5%; text-align: center;\" class=\"forumheader\">Vues</td>

    <td style=\"width: 5%; text-align: center;\" class=\"forumheader\">Réponses</td>

    <td style=\"width: 25%; text-align: center;\" class=\"forumheader\">Date</td>

    </tr>";



       $lastsql="SELECT * FROM `".PHPBB_PREFIX."topics` ORDER BY `topic_last_post_time` DESC LIMIT 0, 5";

       $lastsql2=mysql_query($lastsql) or die("could not select posts".mysql_error());

       while($lastsql3=mysql_fetch_array($lastsql2)) {



       $usersql="SELECT username FROM `".PHPBB_PREFIX."users` WHERE user_id='".$lastsql3['topic_poster']."' LIMIT 0, 1";

       $usersql2=mysql_query($usersql) or die("could not select users");

       $usersql3=mysql_fetch_array($usersql2);



       $forumsql="SELECT forum_name FROM `".PHPBB_PREFIX."forums` WHERE forum_id='".$lastsql3['forum_id']."' LIMIT 0, 1";

       $forumsql2=mysql_query($forumsql) or die("could not select users");

       $forumsql3=mysql_fetch_array($forumsql2);



       //From newforumposts_menu.php

       $datestamp = $gen->convert_date($lastsql3['topic_last_post_time'], "forum");





    //   $text .= "<img src='".THEME."images/".(defined("BULLET") ? BULLET : "bullet2.gif")."' alt='' /> <a href='".PHPBB_PATH."viewtopic.php?p=".$lastsql3['post_id']."'>Post: ".$lastsql3['post_subject']."</a><

br /> Posted by ".$usersql3[ 'username']."<br />".$datestamp."<br />";



       $text .= '

          <tr>

          <td style="width: 5%; text-align: center;" class="forumheader3"><img src="e107_plugins/forum/images/lite/new_small.png" alt=""></td>

          <td style="width: 45%;" class="forumheader3"><b><a href="'.PHPBB_PATH.'viewtopic.php?f='.$lastsql3['forum_id'].'&t='.$lastsql3['topic_id'].'">'.$lastsql3[ 'topic_title'].'</a></b> <span class="smalltex

t">(<a href="'.PHPBB_PATH.'viewforum.php?f='.$lastsql3['forum_id'].'">'.$forumsql3[ 'forum_name'].'</a>)</span></td>

          <td style="width: 15%; text-align: center;" class="forumheader3"><a href="'.PHPBB_PATH.'memberlist.php?mode=viewprofile&u='.$lastsql3['topic_poster'].'">'.$usersql3[ 'username'].'</a></td>

          <td style="width: 5%; text-align: center;" class="forumheader3">'.$lastsql3[ 'topic_views'].'</td>

          <td style="width: 5%; text-align: center;" class="forumheader3">'.$lastsql3[ 'topic_replies'].'</td>

          <td style="width: 25%; text-align: center;" class="forumheader3"><a href="'.PHPBB_PATH.'memberlist.php?mode=viewprofile&u='.$lastsql3['topic_last_poster_id'].'">'.$lastsql3[ 'topic_last_poster_name'].'

</a><br/>'.$datestamp.'</td>

          </tr>

    ';



       }



    $text .="

    </tbody></table>

    </div>";

/* And the menu creation part */

       $caption = "Derniers Messages Du Forum";

       $ns -> tablerender($caption, $text);



    }

    ?>

<?php

// phpBB 3.0.x auto-generated configuration file

// Do not change anything in this file!

$dbms = 'mysql';

$dbhost = 'localhost';

$dbport = '';

$dbname = 'titi';

$dbuser = 'titi';

$dbpasswd = 'titi';

$table_prefix = 'phpbb_';

$acm_type = 'file';

$load_extensions = '';



@define('PHPBB_INSTALLED', true);

// @define('DEBUG', true);

// @define('DEBUG_EXTRA', true);

?>