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)
{
$context['TPortal']['shoutbox'] = $txt['tp-last'].' '.$limit.' '.$txt['tp-shouts'].'
';
// Clean stuff
$shouts = array();
$i = 0;
// Loop it into an array to reverse
while($row = mysql_fetch_assoc($request))
$shouts[$i++] = '' . $row['value3'] . '
' . timeformat($row['value2']) . '
' . doUBBC($row['value1']) . '
';
// Freedom!!!
mysql_free_result($request);
// Now we reverse it!
$shouts = array_reverse($shouts);
// For each we divide and conquer.
foreach($shouts as $shout)
$context['TPortal']['shoutbox'] .= $shout;
}