[tamago]

You need to modify showteams.php.

Change:

PHP Code:

$useronoff=$DB_site->query_first("SELECT COUNT(*) AS count FROM session WHERE userid='$userid' AND lastactivity>$datecut"); 


to

PHP Code:

$useronoff=$DB_site->query_first("SELECT COUNT(*) AS count FROM ".TABLE_PREFIX."session WHERE userid='$userid' AND lastactivity>$datecut"); 


It was missing the TABLE_PREFIX.

Originally Posted by bishop93

Seems that everything works -- except when you click on the "No-Team" (which seems kinda out of place, when I would think that it would just show nothing there rather than "No Team") I get the following error. Otherwise, this works great.

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT COUNT(*) AS count FROM session WHERE userid='1' AND lastactivity>1102881603
mysql error: Table 'xxx_xxx.session' doesn't exist

mysql error number: 1146

Date: Sunday 12th of December 2004 03:15:03 PM
Script: http://URL/showteams.php?do=teamless
Referer: http://URL/showthread.php?p=11738
Username: xxx
IP Address: xxx