Away message for users

Hi,

This is something that is common in IRC - /me is away

In BBs, a user is either online or offline (or invisible).

But, on my Bulletin Board, the folks created such a community that every time someone goes on a holiday or goes offline for a while, he/she posts a new thread to annouce they're 'away.

So, I wrote a hack allowing a user to change his/her status to "away", including a return date and an away reason which will show up in their profile.

Likewise, the online/offline icon in postbit and buddy list will change to an away icon (a very faded version of the 'offline' one).

Some demo captures:

The Edit Profile screen, when a user is NOT away:



The Edit Profile screen when a user IS away:



The Get Info (User Profile) screen when a user IS away:



The Get Info (User Profile) screen when a user is NOT away:



The postbit icon when a user is away:




How to install:

Download the attached zip file. Upload away.gif to your images dir (or create your own away.gif).

Upload install_awayuser.php to your admin dir and follow the instructions.

Cheers,

Bira

newest version by sho here:
https://vborg.vbsupport.ru/showthrea...606#post287606

[StarBuG]

I installed it and anything seems to work fine but now i recognised a problem!

After a users returndate he is still away!
No changes..

Hmm any suggestions would be nice

Greetings

StarBuG

[Russ]

But....

Admin CP editing a user gets this message

Database error in vBulletin Control Panel 2.2.1:

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: Tuesday 22nd of January 2002 06:43:14 PM
Script: http://buffy.phpwebhosting.com/forum...=edit&userid=1
Referer: http://buffy.phpwebhosting.com/forums/admin/?


Could you tell me what I need to edit.. i tried the suggest you have earlier on page 5 of this thread, but it didn't seem to make a difference.

Cheers.

[Wolf42]

[QUOTE]Originally posted by Russ
But....

Admin CP editing a user gets this message

Database error in vBulletin Control Panel 2.2.1:

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: Tuesday 22nd of January 2002 06:43:14 PM
Script: http://buffy.phpwebhosting.com/forum...=edit&userid=1
Referer: http://buffy.phpwebhosting.com/forums/admin/?


Could you tell me what I need to edit.. i tried the suggest you have earlier on page 5 of this thread, but it didn't seem to make a difference.

Cheers.

[Joshua Clinard]

I know this is a long thread, but can someone answer my question?

[PhotoGenie]

I am having the same problem as a few others with the away icon not showing in post. Online status is on and everything else seems to be ok.. Ijust dont see the icon.. Great hack though.

[PhotoGenie]

My mistake on the last error but now I'm getting this error when I go to user options at the bottom of members profile..

Database error in vBulletin Control Panel 2.2.1:

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=27
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: Tuesday 29th of January 2002 08:40:47 AM
Script: http://www.a2zautoforums.com/admin/u...edit&userid=27
Referer: http://www.a2zautoforums.com/admin/i...%26userid%3D27

I noticed a couple of other post with the same problem. Has anyone created a fix yet or figured out how to fix this?

Thanks

Please disregard this post the problem was the coma after:

FROM_UNIXTIME(awaydate) AS awaydate

was missing. Hasn't been updated in the install script.

[PhotoGenie]

I upgraded to 2.2.2 and tried twice install this hack twice. I backed up my php files before i started installing the hack so I had fresh files each time. I couldn't get anything to show at all anywhere. I know I'm seeing 2.2.2 at the beginning of this post, lol.. I managed to get it installed on 2.2.1 and it worked perfectly.. Its a real nice addition. Just not for me right now.

[Linus]

[QUOTE]Originally posted by PhotoGenie
My mistake on the last error but now I'm getting this error when I go to user options at the bottom of members profile..

Database error in vBulletin Control Panel 2.2.1:

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=27
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: Tuesday 29th of January 2002 08:40:47 AM
Script: http://www.a2zautoforums.com/admin/u...edit&userid=27
Referer: http://www.a2zautoforums.com/admin/i...%26userid%3D27

I noticed a couple of other post with the same problem. Has anyone created a fix yet or figured out how to fix this?

Thanks

Please disregard this post the problem was the coma after:

FROM_UNIXTIME(awaydate) AS awaydate

was missing. Hasn't been updated in the install script.

[Linus]

[QUOTE]Originally posted by bira
sorry, try adding a coma , after "FROM_UNIXTIME(awaydate) AS awaydate"

[PhotoGenie]

Yep Linus.. My problem too.. I corrected it the first time I installed it but the second time I had forgotten it... Seems thats really the only problem in the installer.. Mine is working now though .. I really like this hack.