$sql = "SELECT phpbb_users.user_id FROM `phpbb_users`;";

if( !($members = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, 'Could not query information', '', __LINE__, __FILE__, $sql);
}

$current_member = 0;

while ($user = mysql_fetch_array($members, MYSQL_ASSOC))
{
	echo "working on member id ". $user['user_id']."...";

	$n = 1;

	//I must say this is purely genius
	//grabs the text of the (LIMIT n) posts by the user
	$sql = "SELECT phpbb_posts_text.post_text FROM `phpbb_posts`,`phpbb_posts_text`
		WHERE phpbb_posts.poster_id = " . $user['user_id'] . "
		AND phpbb_posts.post_id = phpbb_posts_text.post_id
		ORDER BY phpbb_posts.post_time DESC
		LIMIT ". $post_history." ;";

	if( !($result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, 'Could not query information', '', __LINE__, __FILE__, $sql);
	}

	$inc = "0";

	$flesch_total = "0";
	$flesch_total_grade = "0";

	while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
	{
			//replace all bbcode with _nothing_
			$text = preg_replace('/\[.*?\]/','',$row['post_text']);

			$flesch_total = $flesch_total + calculate_flesch($text);	
			$flesch_grade_total = $flesch_grade_total + calculate_flesch_grade($text);	

			$inc++;
			//var_dump($row);
	}

	$posts = mysql_num_rows($result);
	if ($posts == "0")
	{
		$posts = 1;
	}

	$flesch_average = round(($flesch_total / $posts),2);
	$flesch_grade_average = round(($flesch_grade_total / $posts),2);

	echo "average: ".$flesch_average." grade: ".$flesch_grade_average." |";

	$sql = "UPDATE `phpbb_users` SET `user_flesch_average` = '" . $flesch_average . "', `user_flesch_grade_average` = '". $flesch_grade_average ."' WHERE `user_id` =" . $user['user_id'] . " LIMIT 1 ;";

	if( !($result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, 'Could not query readability or grade', '', __LINE__, __FILE__, $sql);
	}

	$flesch_average = 0;
	$flesch_grade_average = 0;
	$current_member++;
	$inc = 0;
	echo "done\n";

}