"; include("config.php"); mysql_connect($dbhost, $dbuser, $dbpasswd); mysql_select_db($dbname); if(isset($_POST['submit'])) { $sql = mysql_query("SELECT * FROM phpbb_users WHERE user_id='".$_POST['naam']."'"); $aantal_users = mysql_num_rows($sql); if($aantal_users == 0) { die("Die user bestaat niet"); } $sql2 = mysql_query("SELECT forum_id FROM phpbb_forums ORDER BY forum_id DESC LIMIT 1"); $laatste_id = mysql_fetch_object($sql2); $user = mysql_fetch_object($sql); $forum_id = 1; ?>
Posts stats
Waar en hoeveel heb jij gepost?
Statistieken voor echo $user->username; ?>
Forum
Berichten
Percentage
if($user->user_posts == 0) { die("Geen berichten"); } while($forum_id <= $laatste_id->forum_id) { $sql3 = mysql_query("SELECT * FROM phpbb_posts WHERE poster_id='".$user->user_id."' AND forum_id='".$forum_id."'"); $aantal_berichten = mysql_num_rows($sql3); $sql4 = mysql_query("SELECT * FROM phpbb_forums WHERE forum_id='".$forum_id."'"); $forum = mysql_fetch_object($sql4); $percentage = round($aantal_berichten / $user->user_posts * 100, 2); if($aantal_berichten != 0) { ?>
echo $forum->forum_name; ?>
echo $aantal_berichten; ?>
echo $percentage; ?>%
} $forum_id++; } ?>
Totaal:
echo $user->user_posts; ?>
echo "100%"; ?>
© 2004 Lucas van Dijk
} else { $sql = mysql_query("SELECT * FROM phpbb_users ORDER BY user_id DESC LIMIT 1"); $laatste_id = mysql_fetch_assoc($sql); ?>
Selecteer user:
$sql = mysql_query("SELECT * FROM phpbb_users where user_id !=-1 ORDER BY username ASC"); $id = 0; while($id != $laatste_id[user_id]) { $user_id = mysql_result($sql, $id, "user_id"); $username = mysql_result($sql, $id, "username"); echo "
".$username."
"; $id++; } ?>
} echo ""; ?>