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

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?

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?

Does this work with version 3.0.7?

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!!??

Is it available for vb 3.5.0 ?

Was wondering the same thing BoYagoob

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

Any solution to this problem?

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
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]

Anyone know if it works with 3.5.0 GOLD???

Has this hack been updated for 3.5? :)

I could port this to 3.5.0 if I get the permission...
But judging by gamingforce's last activity, I doubt I ever will.

Well I hope you do! It would be a great hack to have! :)

pleaaassee get it to work for 3.5.4 someone!

Yes please can someone please help us out here, or point us in the direct of a similar mod.

Hey PV, have you asked Gamingforce about this as yet???

GAMINGFORCE can you please port this or at least give someone like PV permission to port it.

Please, pretty please. (now this is just sad) :bunny:

Comr On Somoene Posrt This To 3.6..:(

I'm really hoping it'll come out for 3.6.5 too :)

I've emailed Gamingforce for permission to port this to 3.6.x. If I get a response, I'll update this thread.

:)

Yay! Hope so!!