All pastes #358124 Raw Edit

Stuff

public php v1 · immutable
·published 2007-02-16 02:15 UTC
rendered paste body
$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);$sql = "SELECT 		phpbb_posts_text.post_text 	FROM 		`phpbb_posts`,`phpbb_posts_text`	WHERE 		phpbb_posts.poster_id = " . $userdata['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);$flesch_total = 0;$flesch_total_grade = 0;while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){	$text = preg_replace('/\[.*?\]/','',$row[post_text]);	$flesch_total = $flesch_total + calculate_flesch($text);		$flesch_grade_total = $flesch_grade_total + calculate_flesch_grade($text);	}$flesch_average = round($flesch_total / mysql_num_rows($result),2);$flesch_grade_average = round($flesch_grade_total / mysql_num_rows($result),2);//Silly, Sinful code.if ($userdata['user_id'] == "7") {	$flesch_average = '666';	$flesch_grade_average = '666';}$sql = "UPDATE 		`phpbb_users` 	SET 		`user_flesch_average` = '" . $flesch_average . "',		 `user_flesch_grade_average` = '". $flesch_grade_average ."'	 WHERE 		`user_id` =" . $userdata['user_id'] . ";";if( !($result = $db->sql_query($sql)) )	message_die(GENERAL_ERROR, 'Could not query readability or grade', '', __LINE__, __FILE__, $sql);