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'].'
'; $i = 0; 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); // Clean the string $context['TPortal']['shoutbox'] = ''; // For each we divide and conquer. foreach($shouts as $shout) $context['TPortal']['shoutbox'] .= $shout; }