phpBB.nl

Code: Selecteer alles

<?php
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

$sql = "SELECT poster_id FROM " . POSTS_TABLE . " ORDER BY post_id ASC";
if( !$result = $db->sql_query($sql) )
{
	echo 'GENERAL_ERROR, "Error getting post_ids from phpbb_post_text';
}

while ( $row = $db->sql_fetchrow($result) )
{
	set_time_limit(60);
	$sql2 = "SELECT user_id FROM " . USERS_TABLE . " WHERE user_id = '".$row['poster_id']."'";
	if( !$result_user = mysql_unbuffered_query($sql2) )
	{
		echo 'GENERAL_ERROR, "Error getting user_ids from phpbb_users';
	}
	flush();
    ob_flush();
	$outcome = $db->sql_fetchrowset($result_user);
	if($outcome[0]['user_id'] != $row['poster_id'])
	{
		$update_sql = "UPDATE " . POSTS_TABLE . " SET poster_id = '-1',  post_username = 'Unknown User' WHERE poster_id = '".$row['poster_id']."'";
		if( !$result_update = mysql_unbuffered_query($update_sql) )
		{
			echo 'GENERAL_ERROR, "Error updating posts table';
		}		
		echo $update_sql."<br>";
		
		echo $row['poster_id']."\n";
	}
}
echo "done!!!";
?>