/admin/user.php error please help as soon as you can....

I installed the away user hack that can be found here...

https://vborg.vbsupport.ru/showthrea...threadid=33099

well later on I found that there is an error, I can remove it fine if I want but I want it so thats not an option.. here's the error I'm getting....



Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: SELECT *,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,FROM_UNIXTIME(awaydate) AS awaydate
avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
FROM user
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
WHERE user.userid=1
mysql error: You have an error in your SQL syntax near 'avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
' at line 2

mysql error number: 1064

Date: Monday 21st of July 2003 01:19:40 AM
Script: http://www.fusionflux.com/forum/foru...=edit&userid=1
Referer: http://fusionflux.com/forum/admin/user.php?action=find


heres the php

PHP Code:

  $user=$DB_site->query_first("SELECT user.*,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,FROM_UNIXTIME(awaydate) AS awaydate
                               avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
                               FROM user
                               LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                               LEFT JOIN customavatar ON customavatar.userid=user.userid
                               WHERE user.userid=$userid"); 


anyone have an ideas?

[Oblivion Knight]

You forgot to add the comma after "awaydate"

[Xelation]

oops lol, I feel embaressed now