View difference between Paste ID: uBFi3Zcf and 5f5Eskdb

-  	//PATH TO FORUM
+  	// Path to forum and necessary initial vars
 	define('IN_PHPBB', true);
 	define('NO_KILL_ON_DB_ERROR',true);
 	$phpEx = "php";
 	$starttime = 0;
 	$phpbb_root_path = "forum/";
-
+
-	// PHPBB vars
+	// Include common functions.
 	include_once($phpbb_root_path . 'common.' . $phpEx);
 	// Start session management.
 	$user->session_begin();
 	$user->setup('viewforum');
-	// Grab 10 latest posts
+
-	$db_selected = @mysql_select_db($dbname);
+	// Require config for DB credentials.
-	$sql = 'SELECT topic_id,topic_title,topic_time,topic_first_poster_name,topic_replies,topic_first_post_id FROM `' . $table_prefix . 'topics` where `forum_id` = 2 ORDER BY `topic_id` DESC LIMIT 10';
+
-	$result = @mysql_query("$sql");
+	// Connect to database.
 	$dbc = @mysql_connect($dbhost,$dbuser,$dbpasswd);
-	// Format post in $allnews
+
-
+	// Error if connection could not be made.
-	while ($row = @mysql_fetch_array($result)) {
+
 	else {
-		$time = date("M j/y",$row[2]);
+		// Grab 10 latest posts
-		$post_info = mysql_fetch_array(mysql_query("SELECT * FROM `{$table_prefix}posts` where `post_id` = {$row[5]}"));
+		$db_selected = @mysql_select_db($dbname);
-		if (! include_once($phpbb_root_path . 'common.php')) return;
+		$sql = 'SELECT topic_id,topic_title,topic_time,topic_first_poster_name,topic_replies,topic_first_post_id FROM `' . $table_prefix . 'topics` where `forum_id` = 2 ORDER BY `topic_id` DESC LIMIT 10';
 		$result = @mysql_query("$sql");
-		$user->optionset('viewsmilies', TRUE);
+
-		$user->optionset('bbcode', TRUE);
+		// Format posts in $allnews array
-		$user->theme['template_path'] = "prosilver";
+		while ($row = @mysql_fetch_array($result)) {
 			$time = date("M j/y",$row[2]);
-		$post = generate_text_for_display($post_info['post_text'], $post_info['bbcode_uid'], $post_info['bbcode_bitfield'], 7);
+			$post_info = mysql_fetch_array(mysql_query("SELECT * FROM `{$table_prefix}posts` where `post_id` = {$row[5]}"));
-		$comments = "<a href=\"http://rly.cc/forum/viewtopic.php?t={$row[0]}\">({$row[4]})</a> ";
+			// The "7" flags on emoticons, BBCode, and magicURLs
-		$allnews[$row[2]] = "
+			$post = generate_text_for_display($post_info['post_text'], $post_info['bbcode_uid'], $post_info['bbcode_bitfield'], 7);
 			$comments = "<a href=\"http://rly.cc/forum/viewtopic.php?t={$row[0]}\">({$row[4]})</a> ";
-
+			$allnews[$row[2]] = "
-	}
+
 		}
-	// Close that DB!
+
-	@mysql_close($dbc);
+		// Close that DB!
 		@mysql_close($dbc);
-	// Sort the array numerically.
+
-	krsort($allnews, SORT_NUMERIC);
+		// Output our news!
-	$sent = 0;
+		foreach ($allnews as $i => $data) echo $data;