[Paul M]

Originally Posted by floris

Database error in vBulletin 3.0.3:
 
Invalid SQL: SELECT userid, lastactivity, options, username,opentag,closetag
FROM vb3_user
LEFT JOIN vb3_usergroup ON(user.usergroupid = usergroup.usergroupid)
WHERE lastactivity > 1100037600 
mysql error: Unknown table 'user' in on clause
 
mysql error number: 1109

Oopsy?

Floris,

I believe that replacing the four lines of the SQL query with this should work.

PHP Code:

$todaysusers = $DB_site->query("SELECT userid, lastactivity, options, username,opentag,closetag
FROM " . TABLE_PREFIX . "user as user
LEFT JOIN " . TABLE_PREFIX . "usergroup as usergroup ON(user.usergroupid = usergroup.usergroupid)
WHERE lastactivity > " .$cutoff. " "); 


Please let me know and I will update the instructions.