phpBB.nl

Code: Selecteer alles

<!-- INCLUDE overall_header.html -->
<!-- INCLUDE menu.html -->
<div style="-moz-border-radius: 10px; -webkit-border-radius: 10px; border: 1px solid #666; padding: 4px;" class="kop" >
<strong>
<center>Laatste mededelingen</center>
</strong>
</div>
<br>
<center> 
<?php
$number=2;
$template="Piplup";
include("/home/www/pokerestless.100webspace.net/cutenews/show_news.php");
?></center>
<br>
<div style=" background-color: #7eace4; -moz-border-radius: 10px; -webkit-border-radius: 10px; border: 1px solid #666; padding: 4px;" >
<strong>
<center>
Laatste 5 posts
</center>
</strong>
</div>
<br>
 <center>   
[b]DE LAATSTE 5 POSTS CODE STAAT HIERONDER IN HET ORIGINEEL[/b]
</center>
<!-- INCLUDE menuend.html -->
<!-- INCLUDE overall_footer.html -->

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

Code: Selecteer alles

define('IN_PHPBB', true);
$phpbb_root_path = './'; // Het pad naar je phpBB3 root.
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);