[Viks]

problem appears to be the syntax...not the mod.
try this
in line -> SELECT DISTINCT user.username, session.useragent,user.userid

there sud be a space between "session.useragent," AND "user.userid"

like below:

SELECT DISTINCT user.username, session.useragent, user.userid

Originally Posted by shadiguy1

this is what i get when i install it.

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT DISTINCT user.username, session.useragent,user.userid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM session AS session
LEFT JOIN user AS user USING (userid)
WHERE session.lastactivity >

ORDER BY session.userid

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY session.userid' at line 7

mysql error number: 1064

Date: Thursday 10th of February 2005 08:46:21 AM
Script: http://nextelelite.com/forums/index.php?
Referer: http://nextelelite.com/
Username: Shadiguy1
IP Address: 205.188.116.7