<?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);
?>