phpBB.de

Code: Alles auswählen

<?php

Instructions:
Edit the varibles below, upload this script, and run it.
*/

//Edit these varibles to your host
$host = "localhost";
$user = "USERNAME"; //the mySQL user
$password = "PASSWORT"; //the mySQL user's password
$dbname = "DATABASE"; //the name of your mySQL database
$posttable = "phpbb_posts"; //the table where your post info is stored...
$usertable = "phpbb_users"; //the table where all your users' info is stored...

//Do not edit anything below unless you know what you are doing...

$link = mysql_connect ($host, $user, $password); //Connect to the database...

$query = "SELECT DISTINCT poster_id, COUNT(poster_id) AS posts FROM " . $posttable .  " GROUP BY poster_id";//Find out how many posts each user has made...
$result = mysql_db_query($dbname,$query,$link);
while ( $row = mysql_fetch_array($result)) {
	$query2 = "UPDATE ".$usertable." SET user_posts = ".$row[posts]." where user_id =".$row[poster_id];//Update their profile
	if (mysql_db_query($dbname,$query2,$link)) {
		print("<font color='blue'>The user with the ID of ".$row[poster_id]." was updated.</font><br />\n");
	} else {
		print("<font color='red'>The user with the ID of ".$row[poster_id]." was not updated.</font><br />\n");
	}
}
mysql_close($link);//and we're done...
?>