Mine

		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 />';

			while($row = mysql_fetch_assoc($request))
			{
				$shouts .='<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;">';
				$myshout='';
				$myshout=$row['value1'];
				$shouts .= doUBBC($myshout);
				$shouts .= '</div></div>';
			}
			$context['TPortal']['shoutbox']=$shouts;
			mysql_free_result($request);
		}