phpBB.nl

Code: Selecteer alles

<?     /*** phpBB3 - Last Active Topics System ***/

    // Gebaseerd op een script van Ioan Filipov
    // Auteur: Bart S.T. Carlier @ BODB InternetWorks
    // Email: info@bodb.nl
    // Datum: 24.12.2007
    //------------------------------

include ("forum/config.php");
   $mysql_connection = mysql_connect ($dbhost, $dbuser, $dbpasswd) or die ("Connection failed");
   mysql_select_db ($dbname) or die ("Selecting database failed");


//Edit these parameters:

//Table prefix
$table="phpbb3_";

//Show last x topics
    $laforums="15";


    $link=mysql_connect($dbhost, $dbuser, $dbpasswd);
    $db=mysql_select_db($db);

//De nummers achter NOT IN refereren aan de fora die niet meegenomen worden in de lijst, bv privefora

    $query="select * from $table".topics."  WHERE topic_approved = '1' AND forum_id NOT IN (45,48,52,53,54,59) order by topic_last_post_time desc limit 0,$laforums";
    $query2="select config_name,config_value from $table".config." where config_name = 'server_name' limit 0,1";
    $result2=mysql_query($query2);
    $row2 = mysql_fetch_array($result2);
    extract($row2);
    $result=mysql_query($query);


    echo "<table width=\"100%\">";

    while ($row=mysql_fetch_array($result)) {
    extract($row);
        echo "<tr><td valign=top><font color=\"#99cc00\">>&nbsp;</font></td><td valign=top><font color=\"#38312b\"><a href=\"http://".$config_value."/forum/viewtopic.php?f=".$forum_id."&t=".$topic_id."&p=".$topic_last_post_id."#p".$topic_last_post_id."\" target='_self'>".$topic_title."</a></td></tr>";
    }

// end of XML output loop

echo "</table>";

    //-------------------------- END
    ?>