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;
}