All pastes #392794 Raw Edit

Someone

public text v1 · immutable
·published 2007-03-13 02:12 UTC
rendered paste body
		if($limit>100) $limit=100;
		$request = db_query("SELECT * FROM {$tp_prefix}shoutbox WHERE 1 ORDER BY value2 DESC LIMIT $limit", __FILE__, __LINE__);
		if (mysql_num_rows($request) > 0)
		{
			$shouts= $txt['tp-last'].' '.$limit.' '.$txt['tp-shouts'].'<hr />';


			$i = 0;
			while($row = mysql_fetch_assoc($request))
				$shouts[$i++] ='<div style="margin: 4px;"><div style="border: dotted 1px; padding: 2px 4px 2px 4px;" class="windowbg2"><b>'.$row['value3'].'</b></div><div style="padding: 2px;"> '.timeformat($row['value2']).'</div><div style="padding: 4px;">' . doUBBC($row['value1']) . '</div></div>';


			// Freedom!!!
			mysql_free_result($request);


			// Now we reverse it!
			$shouts = array_reverse($shouts);

			// Clean the string
			$context['TPortal']['shoutbox'] = '';

			// For each we divide and conquer.
			foreach($shouts as $shout)
				$context['TPortal']['shoutbox'] .= $shout;

		}