squawell - what error do you get? Paste it here

Evil_Incarnate - you have a comma missing after FROM_UNIXTIME(awaydate) AS awaydate

It should be:

FROM_UNIXTIME(awaydate) AS awaydate[high],[/high]
avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar

thankya bira, and great hack btw
works a treat now...

Glad it works. Thanks :)

this is my error
=====================================
Database error in vBulletin Control Panel 2.2.1:

Invalid SQL: UPDATE user SET away=0,awaydate=,returndate='0000-00-00',awayreason='',birthday='0000-00-00',options='15',usergroupid='2',username='789',em ail='plumgreen75@hotmail.com',styleid='1',parentem ail='',coppauser=0,homepage='http://www.',icq='',aim='',yahoo='',signature='',adminema il=1,showemail=1,invisible=0,usertitle='<div style=\"width:100%; font-size:8pt; color:white; filter:Glow(color=purple, strength=2)\">???ŷ|??</div>',customtitle=0,joindate=UNIX_TIMESTAMP('2001-11-25 05:03:38'),cookieuser=1,nosessionhash=0,daysprune= '-1',lastvisit=UNIX_TIMESTAMP('2001-12-11 14:25:09'),lastactivity=UNIX_TIMESTAMP('2001-12-11 14:25:09'),lastpost=UNIX_TIMESTAMP('2001-12-11 09:51:15'),posts='2',timezoneoffset='0',emailnotif ication=1,receivepm='1',emailonpm='0',ipaddress='' ,pmpopup=IF(pmpopup=2 AND 0=1,pmpopup,'0') WHERE userid=85
mysql error: You have an error in your SQL syntax near 'returndate='0000-00-00',awayreason='',birthday='0000-00-00',options='15',usergro' at line 1

mysql error number: 1064

=====================================

any idea??and thankz ur help~~

squawell, scroll up and look at post #62 ( https://vborg.vbsupport.ru/showthrea...284#post206284 ) for the fix :)

bira~~~thankz!!

now it's work!!

I get this
Database error in vBulletin 2.2.0:

Invalid SQL: UPDATE user SET birthday='0',signature='',customtitle='0',usertitl e='Administrator',email='chrisdildy@hotmail.com',p arentemail='',coppauser='0',homepage='',icq='',aim ='',yahoo='',usergroupid='6' WHERE userid='1', ,away='1',awaydate='1008201008',returndate='01-12-13',awayreason='Testing this old thing out :)' WHERE userid='1'
mysql error: You have an error in your SQL syntax near ' ,away='1',awaydate='1008201008',returndate='01-12-13',awayreason='Testing this ' at line 1

mysql error number: 1064

Date: Wednesday 12th of December 2001 06:50:08 PM
Script: http://www.webmafiaforums.com/***/***/member.php
Referer: http://www.webmafiaforums.com/****/m...on=editprofile



when I mark myself away in the admin cp it works great..but the usercp.com or it is the memeber.php that I get this error when I hit submit...

I have installed this hack only to figure out that I am not getting the online and offline tags happening so it will not work under a post. I am running 2.20 and cannot upgrade right now because I will lose alot of work I have into it. Can someone tell me why it wont show online, offline, or away? I have $onlinestatus in the templete and I see ppl talking about turning that on in the vb options but its not there in 2.20 are at least not mine, so what do I do?

I'm having the same problem in 2.2.1 I have the online option turned on in the admin cp in the vbulletin options.

The ComputerGuy: you made a complete mess of the UPDATE user query. Check the instructions again and make sure you follow them accurately.

mADmAX & Nemesis77: Go to the Admin Control Panel -> Options -> Forum Home Page Options, and select 'yes' for 'Display logged in users on home page'