phpBB.nl

Code: Selecteer alles

<? 
/**
* Mod Title:   Top 10 Posters
* Mod Version: phpBB 2.0.4
* Author:      Charlie Page
* Description: Shows the top 10 posters at your board
* Release:     v1.0, 05.31.2004
***
* Demo:                http://www.xboxassassin.com/e3/forums
* Installation Level:  Easy 
* Installation Time:   2 minutes
* Files To Edit:       This one 
* Included Files:      top10.php
***
* Installation Notes:
* Upload this file and set $ppath, change the prefix and $url, 
* Include this into a page and your done!
*/
$url = "http://www.xboxunderground.nl/forum"; // No trailing slash
$ppath = "/httpdocs/forum/config.php";    // Physical path to the config.php file
if(empty($count))

//-----------------[ DO NOT EDIT BELOW HERE ]------------------------- 
include_once("$ppath"); 
$db = @mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("here we die at connection"); 
@mysql_select_db("$dbname",$db) or die("here we die"); 

echo "<table cellspacing=\"3\" cellpadding=\"5\" border=\"0\" align=\"center\"><tr><td><b>Username</b></td><td><b>Posts</b></td><td><b>Topics</b></td></tr>";

$query="SELECT * FROM gocms2_users ORDER BY `user_posts` DESC LIMIT 0, 10";
		$result=mysql_query($query);
		while($row = mysql_fetch_array($result)) {
	    $username = "$row[username]";
		$id = "$row[user_id]";

if ($row[user_id] == "-1") {

} else {

	$query2 = mysql_query("SELECT * FROM gocms2_topics WHERE topic_poster='$id'") or die(mysql_error());
	$num = mysql_num_rows($query2);

echo "<tr><td><a href=\"$url/profile.php?mode=viewprofile&u=$row[user_id]\"><center>$row[username]</center></a></td><td><center>$row[user_posts]</center></td><td>$num</td></tr>";
}
}
?>