[Acedeal]

This one is not working as expected

Database error in vBulletin 3.0.7:

Invalid SQL: 
	SELECT user.username,user.userid,gllcts2_user.pl_nickname,gllcts2_user.pl_playerflags,gllcts2_user.server_timestamp 
	FROM gllcts2_user AS gllcts2_user
	LEFT JOIN user AS user ON(user.username=gllcts2_user.pl_nickname)
	WHERE gllcts2_user.server_timestamp>=1121691062
	ORDER BY gllcts2_user.pl_nickname

mysql error: Table 'dow-gamers_net-vb.user' doesn't exist

mysql error number: 1146

Date: Monday 18th of July 2005 07:57:02 AM
Script: http://www.dow-gamers.net/?
Referer: http://www.dow-gamers.net/vb/showthread.php?p=108192

UPDATE--
You forgot the
" . TABLE_PREFIX . "
on your
LEFT JOIN Statement
should read

LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.username=gllcts2_user.pl_nickname)