User Away Messages

[ Feature Description ]
This hack allows users to easily set themselves as away via the Edit Profile page. An optional away message can be added along with the away status. Away messages are viewable at the top of the user profile (by the avatar/user picture). If a post is made when a user is in away mode, the user is automatically set off away mode.

[ Hack Concept ]
Credits to bira for making the original away message hack for vBulletin 2. This is a complete remake however.

[ Future Plans ]

• Show away status in postbit. (If you want, you can add this right now by using an xhtml conditional ($bbuserinfo[awaystatus] == 1)).

[ Example ]
http://www.gamingforce.com/forums/member.php?u=852


Enjoy!

[henken]

Can this be used on vB 3.0.8 without any problems too?

[Yukino_AE]

If a post is made when a user is in away mode, the user is automatically set off away mode.

i installed this hack and it seems good except when i try to post something while being away. it just gives me a db error message.

Database error in vBulletin 3.0.7:

Invalid SQL: UPDATE user SET awaystatus = '0',awaymessage = '',awaysince = '0' WHERE userid = '1'
mysql error: Table 'aex4.user' doesn't exist

mysql error number: 1146

Date: Wednesday 17th of August 2005 09:13:52 PM
Script: http://anime-extreme.net/forum/newthread.php
Referer: http://anime-extreme.net/forum/newth...newthread&f=17
Username: Yukino


but when i got to the forum again it DOES post the thread but it doesn't show in thread count. or posts.

help?

[Yukino_AE]

i did do the original query with the intructions and added my prefix but is this another query that wasn't listed in teh instructions?

[ReZ]

Does this work with version 3.0.7?

[Mastar]

I've installed this on vb3.07?? and the only error i got so far is when I did the fuctions_newpost.php i got an error at line 703 when trying to edit or post a reply and new thread.

Also when I try saving my profile, I get this -->> Database error in vBulletin 3.0.7:

Invalid SQL: UPDATE user SET
birthday = '02-03-1975',
birthday_search = '1975-02-03',
usertitle = 'Visiting Mods/Admins',
customtitle = 2,
parentemail = '',
homepage = '',homepage = '',
awaystatus = ,
awaymessage = '',
awaysince = ,homepage = '',
awaystatus = ,
awaymessage = '',
awaysince = ,
icq = '',
aim = '',
yahoo = '',
msn = '',
usergroupid = 6
WHERE userid = 392

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '
awaymessage = '',
awaysince = ,homepage = '',
a

mysql error number: 1064

Date: Saturday 24th of September 2005 12:46:29 PM
Script: http://www.wanthelp.com/forums/profile.php
Referer: http://www.Wanthelp/forums/profile.php?do=editprofile
Username: Name
IP Address: 00.00.00.00

Any Help!!??

[BoYagoob]

Is it available for vb 3.5.0 ?

[Startinfresh]

Was wondering the same thing BoYagoob

[Scribbller]

Ok everything is fine but the hack doesnt work I set my self away go back to edit my profile and see that I am not set away thus nothing shows up when I view my own profile. Any ideas why?

PS. I am using 3.0.9

[Scribbller]

Originally Posted by Yukino_AE

i installed this hack and it seems good except when i try to post something while being away. it just gives me a db error message.

Database error in vBulletin 3.0.7:

Invalid SQL: UPDATE user SET awaystatus = '0',awaymessage = '',awaysince = '0' WHERE userid = '1'
mysql error: Table 'aex4.user' doesn't exist

mysql error number: 1146

Date: Wednesday 17th of August 2005 09:13:52 PM
Script: http://anime-extreme.net/forum/newthread.php
Referer: http://anime-extreme.net/forum/newth...newthread&f=17
Username: Yukino


but when i got to the forum again it DOES post the thread but it doesn't show in thread count. or posts.

help?

Any solution to this problem?

[Scribbller]

Ok I solved both the problems myself first one well I didnt edit the files completely left out an edit. Second one which Yukino_AE posted you need to change a bit of code in functions_newpost.php the edit tells you to do this

[FIND]-->
		// ### POST NEW POST ###

[REPLACE WITH]-->
		if ($bbuserinfo['awaystatus'] == '1') {
			$DB_site->query("UPDATE user SET awaystatus = '0',awaymessage = '',awaysince = '0' WHERE userid = '$bbuserinfo[userid]'");
		}

		// ### POST NEW POST ###

Problem is with the bit highlighted in red so what I did was repace the word user with the name of the table in database eg my user table is called vb_user so the code should now look like
[REPLACE WITH]-->
if ($bbuserinfo['awaystatus'] == '1') {
$DB_site->query("UPDATE vb_user SET awaystatus = '0',awaymessage = '',awaysince = '0' WHERE userid = '$bbuserinfo[userid]'");
}

// ### POST NEW POST ###[/CODE]