phpBB.nl

Code: Selecteer alles

<?php     

             /*** 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 ("config.php");
           $mysql_connection = mysql_connect ($dbhost, $dbuser, $dbpasswd) or die ("Verbinden mislukt. Meld dit aan het Development Team AUB.");
           mysql_select_db ($dbname) or die ("Database selecteren mislukt. Meld dit aan het Development Team AUB.");


        //Verander deze instellingen naar uw eigen wil:

        //Tabelprefix, standaard is dit phpbb_ ( Let op! Vergeet niet de underscore (_) )
        $table="phpbb_";

        //Laat de laatste x topics zien, vul voor x uw eigen waarde in.
            $laforums="5";


            $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, teamfora e.d.

            $query="select * from $table".topics."  WHERE topic_approved = '1' AND forum_id NOT IN (26,27,28,29,30) 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=\"25%\">";

            while ($row=mysql_fetch_array($result)) {
            extract($row);
            $time = date('d-m-Y G:i ', $topic_time);
                echo "<tr><td valign=top><span style=\"font-size: 12px;\"><font color=\"#CCCCCC\">$time</font></span></td><td valign=top><span style=\"font-size: 12px;\"><font color=\"#FFFFFF\"><a href=\"http://".$config_value."/viewtopic.php?f=".$forum_id."&t=".$topic_id."&p=".$topic_last_post_id."\" target='_self'>".$topic_title."</a></font></span></td></tr>";
            }

        // end of XML output loop

        echo "</span></table>";

            //-------------------------- EN
?>