[matthewhotdude]

Ok got a SQL problem...Can be seen here http://www.chattaboxforums.com

Does this seem ok?


chdir('../');

require_once('global.php');
require_once('includes/class_bbcode.php');
require_once('includes/functions_newpost.php');

$parser =& new vB_BbCodeParser($vbulletin, fetch_tag_list());
$sql = $db->query("
select s.*, g.opentag, g.closetag
from " . TABLE_PREFIX . "shoutbox as s, " . TABLE_PREFIX . "user as u, " . TABLE_PREFIX . "usergroup as g
where u.userid = s.user_id and g.usergroupid = u.usergroupid
order by id desc
limit " . $vbulletin->options['ddsb_show'] . "
");
$alt_count = 1;

while ($row = mysql_fetch_assoc($sql))
{
$alt_class = ($alt_count % 2) ? 'alt1' : 'alt2';

$id = $row['id'];
$user_id = $row['user_id'];
$user_name = $row['user_name'];
$opentag = $row['opentag'];
$closetag = $row['closetag'];