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

[Xelation]

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

https://vborg.vbsupport.ru/showthread.php?s=&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/forum/admin/user.php?action=edit&userid=1
Referer: http://fusionflux.com/forum/admin/user.php?action=find


heres the php



$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