phpBB.nl

<?php
// ########################################################
// ## Title: Recent Topics for v2.0.4
// ## Author: CFSILENT <cfsilent@yahoo.com> - http://www.seekideas.com/
// ## Description: Display Recent Topics on any page.
// ##
// ## Demo: http://www.seekideas.com/
// ## Installation Level: Easy
// ## Installation Time: 2 minutes
// ########################################################

/* Basic config */
$topicnumber = 10; /*+++ Number of topics you want to display +++*/
$scroll = "up"; /*+++ Scroll "down" or "up" */

/* Database config */
include 'config.php'; /*+++ Replace "XXX" with relative or URL path of your forum directory. +++*/
/*+++ Example (Relative Path): phpBB2, forum, board, etc. +++*/
$urlPath = "http://www.voetbalstats.nl/forum";
/*+++ Example (URL Path): http://www.phpbb.com/phpBB2 +++*/

// Connecting & Selecting Databases
$table_topics = $table_prefix. "topics";
$table_forums = $table_prefix. "forums";
$table_posts = $table_prefix. "posts";
$table_users = $table_prefix. "users";
$link = mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("Could not connect");
mysql_select_db("$dbname") or die("Could not select database");

// Perform Sql Query
$query = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username
FROM $table_topics t, $table_forums f, $table_posts p, $table_users u
WHERE t.topic_id = p.topic_id AND
f.forum_id = t.forum_id AND
t.topic_status <> 2 AND
p.post_id = t.topic_last_post_id AND
p.poster_id = u.user_id
ORDER BY p.post_id DESC LIMIT $topicnumber";
$result = mysql_query($query) or die("Query failed");

// Outcome of the HTML
// Be carefull when you edit these!
print "<marquee id=\"recent_topics\" behavior=\"scroll\" direction=\"$scroll\" height=\"100\" scrolldelay=\"75\" scrollamount=\"2\" onMouseOver=\"document.all.recent_topics.stop()\" onMouseOut=\"document.all.recent_topics.start()\">
<table cellpadding='3' cellSpacing='2' width='600'>";
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "<tr valign='top'><td><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><font color=\"#ffffff\"><b><a href=\"$urlPath/viewtopic.php?topic=$row[topic_id]&forum=$row[forum_id]\">" .
$row["topic_title"] .
"</a></td></font></b><td><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><font color=\"#000080\"> door: <a href=\"$urlPath/profile.php?mode=viewprofile&u=$row[user_id]\">" .
$row["username"] .
"</td><td><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><font color=\"#d9d9d9\">" .
date('F j, Y, g:i a', $row["post_time"]) .
"</td></tr></font>";
}
print "</table></marquee>";

// Free Result
mysql_free_result($result);

// Close the Connection
mysql_close($link);
?>

Witch hazel schreef:Volgens mij worden instellngen in een document overruled door de algemene board instellingen. Heb het dus over kleur en zo. Mischien moet je kijken of er ergens in je bestand niet verwijzingen staan naar css instellingen. Zoals een class of zo.