kickass!
but I get this error
Code:
Invalid SQL:
SELECT user.username,userfield.field23,usergroup.orderid,user.userid,gllcts2_user.pl_nickname,gllcts2_user.pl_playerflags,gllcts2_user.server_timestamp
FROM gllcts2_user AS gllcts2_user
LEFT JOIN vb3_user AS user ON(user.username=gllcts2_user.pl_nickname)
LEFT JOIN vb3_usergroup AS usergroup ON(usergroup.usergroupid=user.usergroupid)
LEFT JOIN vb3_userfield AS userfield ON(userfield.userid=user.userid)
WHERE gllcts2_user.server_timestamp>=1129321357
ORDER BY usergroup.orderid DESC, gllcts2_user.pl_nickname;
MySQL Error : Unknown column 'userfield.field23' in 'field list'
Error Number : 1054
Date : Friday, October 14th 2005 @ 03:28:37 PM
Script : http://www.s2tg.com/forum/
Referrer : http://www.s2tg.com/
IP Address : XXXXXXXXXXXX
Username : |s2tg|twitch
Classname : vb_database