[docvader]

Uae, getting a mysql error when trying to access the Who's Online section of my site:

Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT user.username, session.useragent, session.sessionhash, session.location, session.lastactivity, user.userid, user.options, session.host, session.badlocation, session.incalendar, user.aim, user.icq, user.msn, user.yahoo,
// [END HACK='vB Pager' AUTHOR='WwW.UAEWEB.COM' VERSION='2.0.4' CHANGEID= 3 ]

IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM session AS session
LEFT JOIN user AS user USING (userid)
WHERE session.lastactivity > 1106699443

ORDER BY user.username asc

mysql error: You have an error in your SQL syntax near '// [END HACK='vB Pager' AUTHOR='WwW.UAEWEB.COM' VERSION='2.0.4' CHANGEID= 3 ]

' at line 3

mysql error number: 1064

Date: Tuesday 25th of January 2005 04:45:44 PM
Script: http://x.russbo.com/vb/online.php?
Referer:
Username: xxxxx
IP Address: xxxx

My online.php relevant section looks like this:

$sorturl = "online.php?$session[sessionurl]";

eval("\$sortarrow[$sortfield] = \"" . fetch_template('forumdisplay_sortarrow') . '";');


// [START HACK='vB Pager' AUTHOR='WwW.UAEWEB.COM' VERSION='2.0.4' CHANGEID= 3 ]
$allusers = $DB_site->query("

SELECT user.username, session.useragent, session.sessionhash, session.location, session.lastactivity, user.userid, user.options, session.host, session.badlocation, session.incalendar, user.aim, user.icq, user.msn, user.yahoo,
// [END HACK='vB Pager' AUTHOR='WwW.UAEWEB.COM' VERSION='2.0.4' CHANGEID= 3 ]


IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

Any ideas? It was working before the hack.

rich