Away message for users

[Crunch]

egh on 2.2.6 in the functions I can't find where to put the

// Leave Away Message in Profile (v1.2)
if ($post[away]=="1") {
eval("\$onlinestatus = \"".gettemplate("postbit_away")."\";");
} else {
if ($post['lastactivity'] > $datecut and !$post['invisible'] and $post['lastvisit'] != $post['lastactivity']) {
eval("\$onlinestatus = \"".gettemplate("postbit_online")."\";");
} else {
eval("\$onlinestatus = \"".gettemplate("postbit_offline")."\";");
}
}
// Leave Away Message in Profile (v1.2)



can someone who's recently installed it on that or 2.2.5 give me an idea of where it's around? (line wise)

[talon3dhq]

[QUOTE]Originally posted by Birdie501
Hi,

i found the error:

In the installation instructions you should change step 4 in member.php

You have to insert the code not after

eval("\$referrals = \"".gettemplate("getinfo_referrals")."\";");
}


but after:

eval("\$referrals = \"".gettemplate("getinfo_referrals")."\";");
}
else {
$referrals = '';
}


so that it looks like this


eval("\$referrals = \"".gettemplate("getinfo_referrals")."\";");
}
else {
$referrals = '';
}
// Leave Away Message in Profile (v1.2)
if ($userinfo[away]=="1") {
$sincedate = vbdate($dateformat, $userinfo[awaydate]);
if ($userinfo[returndate]=="0000-00-00") {
$returndate = "Unbekannt";
} else {
$returnaway = explode("-", $userinfo[returndate]);
$returndate = vbdate($dateformat, mktime(0,0,0,$returnaway[1],$returnaway[2],$returnaway[0]));
}
eval("\$away .= \"".gettemplate("getinfo_away")."\";");
} else {
$away = "";
}
// Leave Away Message in Profile (v1.2)


Regards
Birdie501 :)

[talon3dhq]

ok. I installed everything, and have no error messages, but also NOTHING shows up either! I can set the away status in the Admin control panel only, but as far as the main site is concerned, there is nothing showing in the usercp or the members profile..anyone?

[talon3dhq]

ok, quick update. The hack is technically working, but only from the admins control panel. If I set my status to away, it shows it correctly in my profile, and if PM'ed, the user will get the auto reply. However, I still can't get this to show up in the "edit profile" area. I have edited the template as directed, but still nothing!..ugh!

[talon3dhq]

Ok, fixed it myself, and It was a user mistake. thanks anyway guys, and yes, it is a great hack!

[Hellburn]

@talon3dhq i have the same prob. Can you tell me what you have fix?

[NeRilkA]

yes me too, i can't see in my user profil th away option

please tell us what did you do

[talon3dhq]

Sure..

The VERY first change that needs to be made to the "member.php" file says find eval("dooutput(\"".gettemplate("modifyprofile")."\");"); and place
// Leave Away Message in Profile (v1.2)
if ($bbuserinfo[away]=="1") {
$awaystatus = "<font color=\"{hovercolor}\"><b>You have been marked as 'away' since ".vbdate($calformat1, $bbuserinfo[awaydate])."</b></font>";
$away1checked = "checked";
$returndate = explode("-",$bbuserinfo[returndate]);
$dayname = "day".$returndate[2]."away";
$$dayname = "selected";
$monthname = "month".$returndate[1]."away";
$$monthname = "selected";
$yearname = "year".$returndate[0]."away";
$$yearname = "selected";
} else {
$awaystatus = "select whether you are away or not";
$away0checked = "checked";
}
eval("\$awaytext = \"".gettemplate("modifyprofile_away")."\";");
// Leave Away Message in Profile (v1.2)

ABOVE IT.... I was placing it AFTER it...that was why it wasn't working correctly.

Hope that helps.

[Hellburn]

Great hack but i wont a field for the "post subject" in the box. Can you make a code for this? Thank You.

[Bro_Joey_Gowdy]

Im useing vB2.2.6 and cannot find any of these :


root/usercp.php
Step 2 of 2 FIND:
if ((!$buddy or $bbuserinfo['usergroupid']==6) and $buddy[lastactivity]>$datecut) {
$onoff="on";
} else {
$onoff="off";
}


and :


admin/user.php
[i]Step 1 of 4 FIND:
$user=$DB_site->query_first("SELECT *,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost



Anyone have any thoughts ??

[talon3dhq]

In Root/UserCP.PHP- The Code should be:
if ($buddy['lastactivity'] > $datecut and (!$buddy['invisible'] or $bbuserinfo['usergroupid'] == 6) and $buddy['lastvisit'] != $buddy['lastactivity']) {
$onoff="on";
} else {
$onoff="off";
}


In Admin/User.PHP- The Code should be:
$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,

[talon3dhq]

In Root/UserCP.PHP- The Code should be:
if ($buddy['lastactivity'] > $datecut and (!$buddy['invisible'] or $bbuserinfo['usergroupid'] == 6) and $buddy['lastvisit'] != $buddy['lastactivity']) {
$onoff="on";
} else {
$onoff="off";
}


In Admin/User.PHP- The Code should be:
$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,

I think that is what you need.

[Boofo]

Can anyone please tell me how to fix the following? This is what an autoreply private message looks like.

Auto Reply: test
Hi Boofo,

I have been away since Today (Testing the size problem in private messaging...) and will read your message when I return on Jul 7, 2002.

This is an auto-reply generated by the bearfacts2.com Forum Messaging System.


The color and italics show up fine but the size always shows the tags.

[Boofo]

Please disregard my last message. It was user error on my part. I forgot to make a size vb code replacement variable. Duhhh!!!!

[The Ghost]

hi,

I want to use this Hack on my Version 2.2.6.

Knows somebody Problems with this Hack and Version 2.2.6?

Thanks!

[The Ghost]

Hello?

[Boofo]

From what I have heard and seen, it works fine on 2.2.6. They have it running here and they are running 2.2.6. :)

[The Ghost]

thx for your info -> I'll try it :cool:

[The Ghost]

Work's fine on 2.2.6 !! thx!

[Anitah]

I followed all the directions to the "t" but...

1. nothing whatsoever shows up

2. my buddy list icons are 'broken'

I did all the changes in a text editor and then uploaded the files, not realizing that the usercp.php would leave me with this:

<td><img src="images/.gif" border="0" alt="toko-g is -line"></td>

I've done a few hacks to my board, but I'm just not proficient enough to know how to fix this.

Needless to say, I can't begin to know why the 'away' hack doesn't appear at all.

Could I please get some help on this?

[Buu]

Question :

I installed the hack completely with all the right things no error what so ever but when i look @ a users profile who IS away i cannot see this :

https://vborg.vbsupport.ru/

did i over see anything i checked the files 3 times but couldn't see it . I'm running VBB 2.2.5

[Boofo]

Did you add the $away to your getinfo template? :)

[Buu]

yep that is the most strange thing about it :S

[Boofo]

I had that same problem when I first installed it. I uninstalled it and reinstalled it and then everything worked fine. You might want to give that a shot. :)

[Buu]

k will do that tomorrow then thx for the advise :D

[Troy J.]

hmm mine vanished i had it installed and working just fine then i come back today and its gone.......all the files are still the same and the templates still the same.....i can get into the admin cp and change there away status it just doesnt show up for them in there edit profile.....but ive checked and rechecked the code i have in there and its right

[Boofo]

Things usually don't just disappear on their own. :) Did you add any hacks or change any code or templates?

[Scrub]

Your best bet is to reupload the install file, click uninstall, then go back to the very beginning and click new install and keep clicking next until you reach the end of the file. Then tada. Its should work. Just did that and it worked for me. :)

[dprice]

Great hack! Thanks!

[WitchyT]

This is a great hack! :) But I'm getting the same problem over here, the away reason isn't being shown at the profile, and I've tried re-installing it several times.

Any idea? I followed all steps and everything's working except for that part. I'm currently using VB 2.2.6.

Edited to say: Nevermind this post ;), got it working! Thanks to talon3dhg for the fix posted before (post #252), that was the only problem.

[carpman]

Hello, need a lillte clarification on this hack.

I have $onlinestatus in postbit template which show

Online
or
Offline

If i install this hack can i get it to change 'offline' to 'away' if user sets themselves as being 'away'.

Would look silly having 'offline' and 'away' message.

cheers

[Boofo]

When you install the hack, it adds it to the functions.php so it will show the away message accordingly in the postbit. :)

[QUOTE]Originally posted by carpman
Hello, need a lillte clarification on this hack.

I have $onlinestatus in postbit template which show

Online
or
Offline

If i install this hack can i get it to change 'offline' to 'away' if user sets themselves as being 'away'.

Would look silly having 'offline' and 'away' message.


cheers

[PhoenixBB]

I'm using 2.2.6 and I can't get it working. I keep getting a parse error in Usercp.php line 382. Line 382 is just ?>

There is code differences to that in the installer script. Dunno if that is causing the problem. The code is actually

if ($buddy['lastactivity'] > $datecut and !$buddy['invisible'] and $buddy['lastvisit'] != $buddy['lastactivity']) {
$onoff="on";
} else {
$onoff="off";
}

As there was no mention of userid==6 stuff I left that out.

I've spent 2 days trying to suss it to no avail. I thought installing the weather hack and vbpad might have been more difficult but they went smoothly compared to this. :(

Anyone know why I'm getting that parse error?

[ZiRu$]

can i get a TEXT installation for version 1.2.........thx

[Boofo]

https://vborg.vbsupport.ru/showthread.php?postid=257017#post257017

[QUOTE]Originally posted by ZiRu$
can i get a TEXT installation for version 1.2.........thx

[ZiRu$]

thx man

[Boofo]

You're very welcome there, sir. ;)

[marc49]

ok, this thread is 20 pages long so maybe this has been answered already but I am getting this error

Database error in vBulletin Control Panel 2.2.5:

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=103
mysql error: You have an error in your SQL syntax near 'avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
' at line 4

mysql error number: 1064

Date: Wednesday 14th of August 2002 02:53:11 PM
Script: http://www.mysite.com/admin/user.php?action=edit&userid=103
Referer: mysite.com/admin/user.php


I am running 2.2.5


*EDIT*

Never mind, I started looking through the pages while I was waiting for a reply and I think I got it fixed.

[Boofo]

I think you need a comma after FROM_UNIXTIME(awaydate) AS awaydate like this:

FROM_UNIXTIME(awaydate) AS awaydate,

[|DarkManX|]

how can i put the away icon in the sig??

[JasonGreen]

It's a great idea, but it doesn't work.

[Sho]

Humm, I want a re-release for 2.2.6. I know talon3dhq told us what to replace instead of what the installer tells us, but, well, JelSoft certainly made those changes for a reason. :pirate:

[Schorsch]

question:

1) can I use this without any errors on vB 2.2.6 ?

Schorsch

[Sho]

I don't think so. At least I didn't get it to run on my test installation.

[Schorsch]

:surprised: :(

[ExAvIoUr]

everything i try to use the away feature i get this

Please make sure that you have completed all the required fields. These include username, password and email. Press the back button, correct the error and try again.

how cna i fix this.

[ZiRu$]

[QUOTE]Originally posted by Boofo
https://vborg.vbsupport.ru/showthread.php?postid=257017#post257017

[Sho]

:(

And that's the next problem, well ...

[Boofo]

I used the install_awayuser.php file, myself, when I installed it and it worked great for me. I just found that link in the thread. Sorry. :)

[QUOTE]Originally posted by ZiRu$


UM....that is INCOMPLETE

it dosent show up to put the info in the profile and in the instructions it says VIEW NEXT PAGE

[Sho]

Still can't get it to work on 2.2.6. Hmhm. Boofo, do you use 2.2.6?

[Boofo]

No. Im still using 2.2.5 (with the security updates), but I have seen many peopple say it works on 2.2.6 just fine. What is it doing or not doing? I'll see if I can help you figure it out. :)

[QUOTE]Originally posted by Sho
Still can't get it to work on 2.2.6. Hmhm. Boofo, do you use 2.2.6?

[Sho]

The installer orders you to replace code that is not there anymore: usercp.php step 2/2, user.php step 1/4. Now talon3dhq told us on page 18 (&perpage=15, post 262 (https://vborg.vbsupport.ru/showthread.php?postid=267009#post267009)) how the new 2.2.6 code snippets looks like. I found them and applied bira's changes - not by replacing, but by complementing as seemed logical to me. Result: parse errors. Unfortunately, my PHP knowledge is limited. I'm looking for someone who goes over it, maybe even re-releases this hack for 2.2.6 - bira didn't visit this board since the beginning of the year.

As always, sorry for my clumsy English. And thanks a lot for showing interest! :)

[Boofo]

Ok, pm me the code taht needs to be changed or added and the code BEFORE you changed it and I will have a look at it. I'm sure it can't be too hard to fix. :)

[QUOTE]Originally posted by Sho
The installer orders you to replace code that is not there anymore: usercp.php step 2/2, user.php step 1/4. Now talon3dhq told us on page 18 (&perpage=15, post 262 (https://vborg.vbsupport.ru/showthread.php?postid=267009#post267009)) how the new 2.2.6 code snippets looks like. I found them and applied bira's changes - not by replacing, but by complementing as seemed logical to me. Result: parse errors. Unfortunately, my PHP knowledge is limited. I'm looking for someone who goes over it, maybe even re-releases this hack for 2.2.6 - bira didn't visit this board since the beginning of the year.

As always, sorry for my clumsy English. And thanks a lot for showing interest! :)

[Sho]

PM is on its way. Thanks again! ;)

[Sho]

How to get this hack to work with 2.2.6 starting with the original installer:

Now here's how to get past the problems with usercp.php step 2/2 and user.php step 1/4 when installing for vB 2.2.6. All credit goes to Boofo (who provided the final replacements) and talon3dhq (who found the right code in 2.2.6's files)! Here we go:

a) usercp.php, step 2/2:

Bira wants us to find:

if ((!$buddy[invisible] or $bbuserinfo['usergroupid']==6) and $buddy[lastactivity]>$datecut) {
$onoff="on";
} else {
$onoff="off";
}

Instead, search for (thanks talon3dhq (https://vborg.vbsupport.ru/showthread.php?postid=267009#post267009)!):

if ($buddy['lastactivity'] > $datecut and (!$buddy['invisible'] or $bbuserinfo['usergroupid'] == 6) and $buddy['lastvisit'] != $buddy['lastactivity']) {
$onoff="on";
} else {
$onoff="off";
}

And replace it with (thanks Boofo!):

// Leave Away Message in Profile (v1.2)
if ($buddy[away]=="1") {
$onoff="away";
} else {
if ($buddy['lastactivity'] > $datecut and (!$buddy['invisible'] or $bbuserinfo['usergroupid'] == 6) and $buddy['lastvisit'] != $buddy['lastactivity']) {
$onoff="on";
} else {
$onoff="off";
}
}
// Leave Away Message in Profile (v1.2)

b) user.php, step 1/4:

Bira wants us to find:

user=$DB_site->query_first("SELECT *,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost

Instead, search for (thanks talon3dhq (https://vborg.vbsupport.ru/showthread.php?postid=267009#post267009)!):

$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,

And replace it with (thanks, Boofo!):

$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,

--- snip ---

Besides, I ran into some minor problems most of you won't have a problem with. Anyway, here we go again:

a) usercp.php, step 1/2:

Bira wants us to find:

$sql="SELECT userid,username,invisible,lastactivity

You will find:

$sql="SELECT userid,username,invisible,lastactivity,lastvisit

Replace it with:

$sql="SELECT userid,username,invisible,away,lastactivity,lastvi sit

b) user.php, step 4/4:

Bira wants us to find:

$DB_site->query("UPDATE user SET birthday='$birthday'

You will find:

$DB_site->query("UPDATE user SET birthday='$birthday',options='$options',usergroupi d='$usergroupid',username='".addslashes(htmlspecialchars($ausername))."'$pwdinclude,email='".addslashes(htmlspecialchars($email))."',styleid='$userstyleid',parentemail='".addslashes(htmlspecialchars($parentemail))."',coppauser=$coppauser,homepage='".addslashes(htmlspecialchars($homepage))."',icq='".addslashes(htmlspecialchars($icq))."',aim='".addslashes(htmlspecialchars($aim))."',yahoo='".addslashes(htmlspecialchars($yahoo))."',signature='".addslashes($signature)."',adminemail=$adminemail,showemail=$showemail,invi sible=$invisible,usertitle='".addslashes($usertitle)."',customtitle=$customtitle,joindate=$joindate,cook ieuser=$cookieuser,nosessionhash=$nosessionhash,da ysprune='$daysprune',lastvisit=$lastvisit,lastacti vity=$lastactivity,lastpost=$lastpost,posts='$post s',timezoneoffset='$timezoneoffset',emailnotificat ion=$emailnotification,receivepm='$receivepm',emai lonpm='$emailonpm',ipaddress='".addslashes($aipaddress)."',pmpopup=IF(pmpopup=2 AND $pmpopup=1,pmpopup,'$pmpopup') WHERE userid=$userid");

Change it to:

$DB_site->query("UPDATE user SET away='$away',awaydate=$awaydate,returndate='$retur ndate',awayreason='".addslashes(htmlspecialchars($awayreason))."',birthday='$birthday',options='$options',usergrou pid='$usergroupid',username='".addslashes(htmlspecialchars($ausername))."'$pwdinclude,email='".addslashes(htmlspecialchars($email))."',styleid='$userstyleid',parentemail='".addslashes(htmlspecialchars($parentemail))."',coppauser=$coppauser,homepage='".addslashes(htmlspecialchars($homepage))."',icq='".addslashes(htmlspecialchars($icq))."',aim='".addslashes(htmlspecialchars($aim))."',yahoo='".addslashes(htmlspecialchars($yahoo))."',signature='".addslashes($signature)."',adminemail=$adminemail,showemail=$showemail,invi sible=$invisible,usertitle='".addslashes($usertitle)."',customtitle=$customtitle,joindate=$joindate,cook ieuser=$cookieuser,nosessionhash=$nosessionhash,da ysprune='$daysprune',lastvisit=$lastvisit,lastacti vity=$lastactivity,lastpost=$lastpost,posts='$post s',timezoneoffset='$timezoneoffset',emailnotificat ion=$emailnotification,receivepm='$receivepm',emai lonpm='$emailonpm',ipaddress='".addslashes($aipaddress)."',pmpopup=IF(pmpopup=2 AND $pmpopup=1,pmpopup,'$pmpopup') WHERE userid=$userid");

--- snip ---

Don't forget, the installer has another error! Thanks to Birdie501 for pointing this out to us.

a) member.php, step 4/4:

Bira wants us to find:

eval("\$referrals = \"".gettemplate("getinfo_referrals")."\";");
}

And place this after it:

// Leave Away Message in Profile (v1.2)
if ($userinfo[away]=="1") {
$sincedate = vbdate($dateformat, $userinfo[awaydate]);
if ($userinfo[returndate]=="0000-00-00") {
$returndate = "Unknown";
} else {
$returnaway = explode("-", $userinfo[returndate]);
$returndate = vbdate($dateformat, mktime(0,0,0,$returnaway[1],$returnaway[2],$returnaway[0]));
}
eval("\$away .= \"".gettemplate("getinfo_away")."\";");
} else {
$away = "";
}
// Leave Away Message in Profile (v1.2)

Instead, place it after:

eval("\$referrals = \"".gettemplate("getinfo_referrals")."\";");
}
else {
$referrals = '';
}

[Boofo]

How about coming out with a text file for the full install now (for 2.2.5 AND 2.2.6)? :)

[Sho]

I am currently working to get my board open again, afterwards - an hour or so - I'm going to write a new text installer for vB 2.2.6 that includes the templates. I am considering to re-release it. Of course with full credit to bira and you guys!

[Sho]

Note: This hack works with 2.2.7 *and* 2.2.6!

This hack is a re-release of "Away" message for users (https://vborg.vbsupport.ru/showthread.php?s=&threadid=33099) by bira (https://vborg.vbsupport.ru/member.php?s=&action=getinfo&userid=2028) - now it works with vB 2.2.6/2.2.7. (He/She didn't visit this board since the beginning of 2001 and didn't react to PM and mail, too; I hope this re-release is fine with him/her.) In addition to changing the instructions to make them valid for 2.2.6/2.2.7, other errors in the original installer were fixed. All I did was compiling the new text-based installer; code was kindly provided by Boofo (https://vborg.vbsupport.ru/member.php?s=&action=getinfo&userid=9948), talon3dhq (https://vborg.vbsupport.ru/member.php?s=&action=getinfo&userid=242) and Birdie501 (https://vborg.vbsupport.ru/member.php?s=&action=getinfo&userid=2865).

Now I am going to quote what bira told us about her hack:

[QUOTE]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).

[Sho]

I re-released this hack for vBulletin 2.2.6.

Look here: https://vborg.vbsupport.ru/showthread.php?s=&threadid=42520

Thanks to all who contributed!

[joeboo]

...re-release? I installed the first release on my board (vB 2.2.6) and had no errors, or problems what so ever.

[Boofo]

How about releasing a version that has both parts (2.2.5 and 2.2.6) in it for those who want a text version for pre-2.2.6?

[Sho]

I would, but I don't have vB 2.2.5 here to validate what I'm writing. And I'm going to bed now - it's 6:30 AM over here and I am *still* awake. :).

How about you use my re-release as a template, create a file for 2.2.5, post it in the 2.2.6 thread and I link to the posting in my own first post? :)

G'night!

[JulianD]

I have the original version too, but i will try this new version.... The actual version seems a little buggy in my forums.

[JJR512]

That's odd...I had no problems getting it to work with 2.2.6. It's been a while since I installed it, though, and I don't recall what adjustments, if any, I had to make for any code differences, though.

[Sho]

[QUOTE]Originally posted by joeboo
...re-release? I installed the first release on my board (vB 2.2.6) and had no errors, or problems what so ever.

[Erwin]

I've been running this on 2.2.6 for many months now with no problems either. But that's just me. :)

[Sho]

There are several errors and unclear instructions in the original installer by bira (code to replace has changed in 2.2.6, a wrong find/add after, etc.). Look in one of my last posts here, I compiled a list of them. Some were pointed out by me and fixed by Boofo, others by Birdie501 and talon3dhq. You probably didn't have any problems getting around these errors, others might have. :)

Please note that I have fully credited bira and all who contributed to this re-release! And only after bira did not react to PM and mail - he/she didn't visit this board since the beginning of 2001.

I only compiled the new text-based installer, that's all.

[Boofo]

Yes, Erwin, but didn't you and JJR512 already have the hack installed when you upgraded to 2.2.6? That is a lot different than installing it on a fresh copy of 2.2.6 and being a newbie at it, too. We've all done enough of these hacks where we get to know how to work around these things. The people just starting out doing it haven't been doing it very long, and it gets confusing sometimes for them. Just like it did for us when we were new at it.

[Velocd]

Sounds good, I've noticed some minor errors in my version also, so I'll have to update when I get the chance ;)

[JJR512]

When I upgraded to 2.2.6, no, I didn't have it installed. I had it installed in an earlier version, but in an earlier upgrade I didn't reinstall it. Besides, having it already installed shouldn't matter. Having it already installed only saves you the trouble of doing any database changes and possibly adding templates; those are the easy parts. The hard parts are doing the file modifications, and upgrading completely destroys file modifications, because you're using new, clean files.

I understand what you're saying about being a newbie...but it's because I had to figure things out on my own that I'm not a newbie anymore. ;)

But I'm not saying there's anything wrong; I'm just saying that, in my experience, I don't have any problems.

[Sho]

Anyway, using fresh & clean 2.2.6 files there are at least two code snippets you can't find using the original installer, because JelSoft rewrote them. talon3dhq posted the new 2.2.6 snippets and Boofo applied bira's changes to them.

Also, there is a wrong find/add after in the original installer - it makes you add bira's code where it doesn't belong. Birdie501 pointed this one out.

Finally, there are some very unclear find/replace instructions. For example, you have to search for "...lastactivity" and change it to "...away,lastactivity". Now, in 2.2.6, the line is "...lastactivity,lastvisit". If you just replace the whole line, you loose the "lastvisit". I wrote down the complete new lines and their correct replacements in the new installer.

It's not like you should add errors to your hacks only to make "newbies" work harder, imo. ;)

[Sho]

Some more information about the changes:

Using fresh & clean 2.2.6 files there are at least two code snippets you can't find using the original installer, because JelSoft rewrote them. talon3dhq posted the new 2.2.6 snippets and Boofo applied bira's changes to them.

Also, there is a wrong find/add after in the original installer - it makes you add bira's code where it doesn't belong. Birdie501 pointed this one out.

Finally, there are some very unclear find/replace instructions. For example, you have to search for "...lastactivity" and change it to "...away,lastactivity". Now, in 2.2.6, the line is "...lastactivity,lastvisit". If you just replace the whole line, you loose the "lastvisit". I wrote down the complete new lines and their correct replacements in the new installer.

[Boofo]

That's the key word...experience. After we do enough hacks, we gain the experience to be able to modify sections of code to fit our needs. Apparently, you didn't do the file compare on the upgrade. That is the only way to go for the minor upgrades (i.e 2.2.5 to 2.2.6) as far as I am concerned. :)

All I was trying to point out that for us who have been around this a little longer, it is easier than it is for the new ones coming along. What is easy for us, can be a nightmare for them. We have all been through that part of it at one time or another and anyone who says he wasn't scared when installing their first few hacks is either a damned genius or a damned liar. :)

[QUOTE]Originally posted by JJR512
When I upgraded to 2.2.6, no, I didn't have it installed. I had it installed in an earlier version, but in an earlier upgrade I didn't reinstall it. Besides, having it already installed shouldn't matter. Having it already installed only saves you the trouble of doing any database changes and possibly adding templates; those are the easy parts. The hard parts are doing the file modifications, and upgrading completely destroys file modifications, because you're using new, clean files.

I understand what you're saying about being a newbie...but it's because I had to figure things out on my own that I'm not a newbie anymore. ;)

But I'm not saying there's anything wrong; I'm just saying that, in my experience, I don't have any problems.

[ULTIMATESSJ]

I also found a few problems when i installed the old one on my localhost, hopefully this one will work, good job

/me clicks install

[ZiRu$]

yes....this one is complete

/me installs it...hope it works good

[Attrox]

I like this one better, nice job! Now to install it...

[Schorsch]

in postbit I want to leave out the away image, instead I want just text ("Schorsch is away!"), located over "registered since", just like it's here in vbulletin.org forums.

how can I do this ?

thanks,
Schorsch

[Sho]

Schorsch:

First change your "postbit_away" template to something like this:

$post[username] is away.

Now, you have to understand that this hack changes how $onlinestatus behaves. When a user is away, the online/offline icons in his posts are replaced by the "postbit_away" template. That certainly makes sense, since the online/offline status doesn't really matter when a user is away. Now here's what you *can* do: modify "postbit_online" and "postbit_offline" as well: "$post[username] is online", "$post[username] is offline". Then, move $onlinestatus in your "postbit" template to whereever you want it - above "registered since", for example.

[Schorsch]

cool, thanks Sho, I'll try it this evening :)

[Sho]

Glad I could help. :)

[Dean C]

what's different from the previous version...

i.e. what has been fixed/modified :D?

- Mist

[Sho]

[QUOTE]Originally posted by Sho
Some more information about the changes:

Using fresh & clean 2.2.6 files there are at least two code snippets you can't find using the original installer, because JelSoft rewrote them. talon3dhq posted the new 2.2.6 snippets and Boofo applied bira's changes to them.

Also, there is a wrong find/add after in the original installer - it makes you add bira's code where it doesn't belong. Birdie501 pointed this one out.

Finally, there are some very unclear find/replace instructions. For example, you have to search for "...lastactivity" and change it to "...away,lastactivity". Now, in 2.2.6, the line is "...lastactivity,lastvisit". If you just replace the whole line, you loose the "lastvisit". I wrote down the complete new lines and their correct replacements in the new installer.

[Schorsch]

I installed this hack now, works like a charm :) :banana:

Thank you very much!!!!

regards,
Schorsch

[Sho]

:classic:

[DestyNova]

:thumbup: thanks Sho

curious I already install your hack at my local and it s perfect but not my server yet so I wonder if do I have to delete and install new one? Is there anything I can update without having to delete it? I already have old one at my server and I have some errors that members mentioned at Bira's thead.

thanks again

[Sho]

Since nothing has changed on the database side, download bira's original installer (there's a link to the thread in the first posting; around page 10 someone posted a text-based installer of the old version), find the code snippets you originally inserted into your files, delete them and install my re-release of the hack. Your user's away status won't be affected by it. :)

[DestyNova]

Great, thanks Sho :)

[Sho]

Just don't run the queries listed under "Database Changes", of course. The tables are already there.

[carpman]

hello i am getting an error when i try and edit user in admin cp, it is a mysql error that seems to be pointing this hack:


start error:


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=7
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: Saturday 24th of August 2002 01:49:57 PM
Script: http://www.domain.co.uk/forums/forums/admin/user.php?s=&action=edit&userid=7
Referer: http://www.domain.co.uk/forums/admin/index.php?s=&loc=user.php%3Fs%3D%26action%3Dedit%26userid%3D7

[Sho]

If you are trying to install this hack on 2.2.6, please try my re-release (https://vborg.vbsupport.ru/showthread.php?s=&postid=287606#post287606).

[carpman]

what if i have already installed previous hack?

do i have to unistall or can i just run sql statments and edit files with new code?

[Sho]

On the database side, nothing has changed. You don't have to delete the tables. Just revert the code changes. Find what you added and delete it, than find what you replaced and replace it again with what my installer tells you to find (!). When that is done, follow the instructions in my installer from the beginning. Just don't run the queries again. Templates are still the same, too.

[carpman]

[QUOTE]Originally posted by carpman
what if i have already installed previous hack?

do i have to unistall or can i just run sql statments and edit files with new code?

[Sho]

Good. I hope my re-release helps you. Good luck. :)

[PhoenixBB]

I don't have the this code in usercp:

if ($buddy['lastactivity'] > $datecut and (!$buddy['invisible'] or $bbuserinfo['usergroupid'] == 6) and $buddy['lastvisit'] != $buddy['lastactivity']) {
$onoff="on";
} else {
$onoff="off";
}

I have:

if ($buddy['lastactivity'] > $datecut and !$buddy['invisible'] and $buddy['lastvisit'] != $buddy['lastactivity']) {
$onoff="on";
} else {
$onoff="off";
}

There is no $bbuserinfo['usergroupid'] == 6)

I use 2.26

[Sho]

PhoenixBB, I just opened vbulletin226.zip and checked it again, and found the code. Line 38. On the other hand, I did not at all find the code you quoted.

Please note that the information given in the installer is based on original 2.2.6 files.

[PhoenixBB]

Hi, the above quote I quoted is what I have on line 38 of the usercp. I just checked the original file (VBulletin226 Release Candidate), and the original file I have, is the exact same. IE on line 38 there is not that 'usergroupid==6' bit.

Hmm, what does it mean? Did they change the files at some point??

[Sho]

Hm, there was some sort of "2.2.6 beta package" up for a day, yes. The zip I used to validate the installer was downloaded the same day I put the re-release up.

[Sho]

I quote John from this thread (http://www.vbulletin.com/forum/showthread.php?threadid=46938):

[QUOTE]Files changed between 2.2.6 RC and 2.2.6 final:

avatar.php, editpost.php, memberlist.php, newreply.php, private.php, usercp.php, admin/forum.php, admin/usergroup.php

John

[PhoenixBB]

Everything else has been working on the board thus far - including various hacks. Except for this, one it was always the usercp which gave me a parse error (the ?> ) on last line. As I don't have the usergroup thingy in my original, I'll try removing that bit from the replacement code. It can't be important for me if it wasn't there originally, so it might be better to leave out than in. I'll try both ways. The database changes made didn't refer to that bit did they? I mean it's not a necessary line is it?

Trust me to download on the day they have a beta up! Oy!

[Sho]

I think it should work, yes. The line you have is basically the one bira's original installer tells us to search for - one reason I re-released the hack is because you can't find this line in 2.2.6 final, among other errors. ;)

Good luck!

[carpman]

if upgrading from original hack can i leave templates as is?

[Sho]

Yep, the templates are unchanged. :)

[PhoenixBB]

It works, it works!! Woo and hoo!!

* PhoenixBB does a happy dance

Curiously when I removed the 'usergroupid==6' bit I got a parse error. So I put it back, and it worked fine. So even tho it wasn't there originally, it makes no difference having it there. Everything works a treat. :D

Thank you sooo much!

[Sho]

Good! :classic:

[Boofo]

All "or $bbuserinfo['usergroupid'] == 6)" means is "or Admins". :)

[QUOTE]Originally posted by PhoenixBB
It works, it works!! Woo and hoo!!

* PhoenixBB does a happy dance

Curiously when I removed the 'usergroupid==6' bit I got a parse error. So I put it back, and it worked fine. So even tho it wasn't there originally, it makes no difference having it there. Everything works a treat. :D

Thank you sooo much!

[Gohan]

Great hack, I've install it on my forum 2.2.7 and fine working.

[Sho]

Great! :)

[Joshua Clinard]

Thank you so much! I tried to install this hack since 2.2.4, and I never got it working, since some of the code changed. Now I have it on 2.2.7, and it works perfectly.

[Sho]

I am currently in the progress of updating my own forums to 2.2.7. If everything works as expected, I will edit my initial posting in this thread to reflect that his hack works with 2.2.6 as well as with 2.2.7. ;)

[Sho]

I am very happy to announce that this hack works perfectly well with 2.2.7. I modified my initial posting accordingly.

[Unknown553]

In the modifyprofile_away template, there really isn't a need for this piece of code:

<option value="01" $year2001away>2001</option>

As you will not be returning in the past ;)


In fact, if you could, it'd be a great feature if you disabled return dates in the past. If it's too hard I will totally understand, I'm just being picky. Great hack, I had a lot of problems with the original hack, this one works flawlessly though. Thanks for updating it!

[Sho]

Actually, I'm working on it. ;)

Will take some time, though. Busy updating my own forums to 2.2.7 right now. :)

[Unknown553]

I can understand that. Moving over 70 hacks is a pain. :( I've just applied the critical security patches so far, not sure if I will convert to 2.2.7 all the way yet, maybe just wait for v3 :)

[groovesalad]

Installed it, and the away system works, however, when I click on a username I get this:

Fatal error: Call to undefined function: dotimeonline() in /www/g/groove_salad/htdocs/forum/member.php on line 1412

how can I get this corrected?

[Unknown553]

When I PM an away user I get the auto reply, but there are no contents inside the PM, it's just blank. I do have the priv_autoreply template too, I double checked....Ideas?

[Dark Shogun]

Does anyone have the away.gif?

Dark Shogun

[sklwer]

Does this Hack work on Version 2.28"?????
Thanks

[Data]

I'm getting the following error within the member.php file:

Parse error: parse error in /home/gaming2/public_html/forums/member.php on line 1413

It's funny, because I tried to locate the line, but when opening the edit menu to search for this, the option was gray, meaning that I couldn't select it to see what was going on.

Um, let me see if this helps. Download the file from the server and when you open it in notepad it'll show all nicely organized. Does anybody know what the problem might be anyways?

[ddausch]

Thx for this hack ...öhm oder einfach Danke für diesen feinen Hack..

my english not to good?? ..naja wird sicher verstanden was ich meine ^^

[poolking]

I have got this hack working under 2.2.8

Now how do I get the away info from the user profile to also appear in the postbit template?

[Blago]

[QUOTE]Originally posted by poolking
I have got this hack working under 2.2.8

Now how do I get the away info from the user profile to also appear in the postbit template?

[poolking]

In the modifyprofile template find

$birthday
$customtext

and after them add

$awaytext

Then the away fields will appear in the edit profile, It had me scratching my head why it wouldn't appear in any of my other styles.

Still waiting for an answer to the postbit question.

[adriandaz]

thanks, installed successfully on 2.2.8 no problems :D

[Webster Media]

I keep getting a parse error on line 266 of admin/functions.php. I have read almost every thread in this post, and have not had any luck.

I am running vB version 2.2.8, and any help you guys could give me would be great.

Line 266 of functions.php is this:

} else {


Which shouldn't matter, but this is the part I am questioning:

if ($buddy['lastactivity'] > $datecut and (!$buddy['invisible'] or $bbuserinfo['usergroupid'] == 6) and $buddy['lastvisit'] != $buddy['lastactivity']) {
$onoff="on";
} else {
$onoff="off";
}


EDIT: Just installed the version made for 2.2.6, and this one did not work either. Got same error message.

Regards,
Nick B.

[Sho]

Try https://vborg.vbsupport.ru/showthread.php?s=&postid=287606#post287606

[NTLDR]

Follow the instructions carefully, this hack works fine on vB 2.2.8.

[Sho]

The original version certainly does not work on 2.2.6 and 2.2.7, which is why I re-released this hack with updated and corrected instructions. You can find a list of errors and their corrections both in this thread, as well as in the new. See link above.

(Edit: Whoa. Just noticed that both threads were merged.)

[SemperFidelis]

Ok
On vb 2.2.9 once applying Sho updated version of the hack, I am now getting a blank page returned when trying to access usercp.php

Here is a snippet of the code from there regarding the required changes:

Change #1

// Leave Away Message in Profile (v1.2a) (Start Code Replaced)
// Here is the original :
// $sql="SELECT userid,username,invisible,usertitle,lastactivity,l astvisit
// FROM user
// WHERE (user.userid='$buddyuserssql')
// ORDER BY username";
// Here is its replacement :
$sql="SELECT userid,username,invisible,usertitle,away,lastactiv ity,lastvisit
FROM user
WHERE (user.userid='$buddyuserssql')
ORDER BY username";
// Leave Away Message in Profile (v1.2a) (End Code Replaced)


Change #2

// Leave Away Message in Profile (v1.2a) (Start Code Replaced)
// Here is the original :
// if ($buddy['lastactivity'] > $datecut and (!$buddy['invisible'] or $bbuserinfo['usergroupid'] == 6) and $buddy['lastvisit'] != $buddy['lastactivity']) {
// {
// $onoff="on";
// } else {
// $onoff="off";
// Here is its replacement :
if ($buddy[away]=="1") {
$onoff="away";
} else {
if ($buddy['lastactivity'] > $datecut and (!$buddy['invisible'] or $bbuserinfo['usergroupid'] == 6) and $buddy['lastvisit'] != $buddy['lastactivity']) {
$onoff="on";
} else {
$onoff="off";
}
}
// Leave Away Message in Profile (v1.2a) (End Code Replaced)



Any help with getting this sorted would be greatly appreciated.

[vLIMIT Sandman]

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: SELECT userid
FROM user
WHERE username='Peter'
AND userid <>
mysql error: You have an error in your SQL syntax near '' at line 4

mysql error number: 1064

Date: Monday 13th of January 2003 05:13:39 AM
Script: http://www.inthebackground.com/forums/forums/admin/user.php
Referer: http://www.inthebackground.com/forums/admin/user.php?action=edit&userid=6

That was what i got when trying to update someone from the admin cp.

[LilTara]

I've got the same problem vLIMIT.... does anyone have a fix for this? *crosses fingers*

-----------------------------------------------------------------
*pops in a while later* I got a fresh copy of user.php and redid the changes on it. Works perfect.

I had very little problem and I'm running 2.2.9 :cool: Great hack!

[subu1]

hi, that was a great hack and it works on my 2.2.8. *Click install*

but i have a litle problem, in my Profil, ich have a double from this but it is only one in my member.php

auweia my englisch *g*

// Leave Away Message in Profile (v1.2a)
if ($userinfo[away]=="1") {
$sincedate = vbdate($dateformat, $userinfo[awaydate]);
if ($userinfo[returndate]=="0000-00-00") {
$returndate = "Unknown";
} else {
$returnaway = explode("-", $userinfo[returndate]);
$returndate = vbdate($dateformat, mktime(0,0,0,$returnaway[1],$returnaway[2],$returnaway[0]));
}
eval("\$away .= \"".gettemplate("getinfo_away")."\";");
} else {
$away = "";
}
// Leave Away Message in Profile (v1.2a)

==========================================
<tr>
<td bgcolor="#F1F1F1" colspan="2" align="center">
<normalfont><b>$userinfo[username] ist nicht verf?gbar</b><normalfont>
<br><smallfont><i>Grund: $userinfo[awayreason]</i></smallfont><br>
<normalfont>ab: $sincedate &nbsp;&nbsp;&nbsp; zur?ck am: $returndate</normalfont>
</td>
</tr>

can you help me? :)



greetz/gr??e subu1

[leitel]

Excuse me, but does this hack run on 2.3?

[iggy123]

I tried it on 2.3 and i get a SQL error from the user.php


Invalid SQL: SELECT userid
FROM user
WHERE username='Kois'
AND userid <>
mysql error: You have an error in your SQL syntax near '' at line 4

mysql error number: 1064

[Alien]

Can anyone confirm this working on a copy of 2.3.0? :)

[AlexanderT]

Installed it on a testboard running v2.3.0 final - no probs.

[AlexanderT]

... and *that* is why the very first post of this thread points to a new version (v1.2a) that takes all these changes you mentioned into account.

https://vborg.vbsupport.ru/showthread.php?postid=287606#post287606

[Alien]

Great, I'll give it a whirl.

Any idea how many queries this hack adds by chance? :D

[Frozen Dreams]

I installed version 1.2a on a 2.2.9 ... and it works like a charm
thanks a lot :)

[Boofo]

Has anyone figured out a way of having this hack automatically set the user as back when their return date comes due?

[DelFDgfd_gT]

Step 3/4.

========
||FIND||
========

if ($posts=="") {
$posts=0;
}

==================
||ABOVE that ADD||
==================

// Leave Away Message in Profile (v1.2a)
if ($awaydate!="") {
$awaydate="UNIX_TIMESTAMP('".addslashes($awaydate)."')";
} else {
$awaydate="''";
}
// Leave Away Message in Profile (v1.2a)

Ok, basically, I cant find

if ($posts=="") {
$posts=0;
}


any thoughts?

[Splitfyre]

Received errors when hacking the user.php file.

Does this hack work in 2.30? Will be going through an uninstall for now and then re-hack at a later date when this function becomes fully stable on 2.30 :bunny:

[cYbercOsmOnauT]

This is a cool hack! I will install it soon (first I need to translate the texts ;))

[Frozen Dreams]

[QUOTE]05-28-03 at 07:09 AM Ramsy de Vos said this in Post #391 (https://vborg.vbsupport.ru/showthread.php?postid=400956#post400956)
Step 3/4.

========
||FIND||
========

if ($posts=="") {
$posts=0;
}

==================
||ABOVE that ADD||
==================

// Leave Away Message in Profile (v1.2a)
if ($awaydate!="") {
$awaydate="UNIX_TIMESTAMP('".addslashes($awaydate)."')";
} else {
$awaydate="''";
}
// Leave Away Message in Profile (v1.2a)

Ok, basically, I cant find

if ($posts=="") {
$posts=0;
}


any thoughts?

[C.Assassin]

installed on 2.3.0 no probs

[Christoff]

Yup... on 2.3.0 no probs... i like it a lot.
So does m users.
Thread about being away was the biggest one.

[cYbercOsmOnauT]

Great hack!

/me clicks install.

[Holidazed]

This is awesome. Works wonderously.

Suggestions:
Filter the Away messages through the vBB filter system
Multiple away messages.
Admins can edit and/or lock an away message so it cannot be edited.
Add a "Start Date" option so people can set away status in advance. eg. I will be gone from xx-xx-xxx to xx-xx-xxxx.

[DarkDraco07]

i get this error

Database error in vBulletin 2.2.9:

Invalid SQL: UPDATE user SET element='2', birthday='1985-6-4',signature='',customtitle='1',usertitle='Admin / Web Master',email='darkdraco@darknemesis.com',parentem ail='',coppauser='0',homepage='http://www.darknemesis.com',icq='',aim='',yahoo='',usergr oupid='6', ,away='0',awaydate='',returndate='',awayreason='' WHERE userid='1', gender='2', rpgclass='11', rpgrace='13', alignment='3', rpgtype='2', rpggender='2' WHERE userid='1'
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 'away='0',awaydate='',returndate='',awayreason='' WHERE userid='

mysql error number: 1064

Date: Thursday 24th of July 2003 03:22:36 PM
Script: http://www.darknemesis.com/forums/forums/member.php
Referer: http://www.darknemesis.com/forums/member.php?s=&action=editprofile

[clamcrusher]

i get this error:

Parse error: parse error, unexpected T_ELSE in /usr/local/psa/home/vhosts/chemical-conversions.com/httpdocs/member.php on line 1387



heres my code:

btw-the last "else{" is line 1387


$refcount = $DB_site->query_first("SELECT count(*) AS count
FROM user
WHERE referrerid = '$userinfo[userid]'");
$referrals = $refcount[count];
eval("\$referrals = \"".gettemplate("getinfo_referrals")."\";");
}// Leave Away Message in Profile (v1.2)
if ($userinfo[away]=="1") {
$sincedate = vbdate($dateformat, $userinfo[awaydate]);
if ($userinfo[returndate]=="0000-00-00") {
$returndate = "Unknown";
} else {
$returnaway = explode("-", $userinfo[returndate]);
$returndate = vbdate($dateformat, mktime(0,0,0,$returnaway[1],$returnaway[2],$returnaway[0]));
}
eval("\$away .= \"".gettemplate("getinfo_away")."\";");
} else {
$away = "";
}
// Leave Away Message in Profile (v1.2)

else {
$referrals = '';
}

// get extra profile fields

[clamcrusher]

nevermind birdie501 already solved it on page 14

[clamcrusher]

ok new problem.

fixed the above and now when i try and use admin cp to view a user, or edit a user, or find away users etc....it gives the same error code.

Parse error: parse error, unexpected '{' in /usr/local/psa/home/vhosts/chemical-conversions.com/httpdocs/admin/user.php on line 1733

i tried uninstalling the hacks on user.php and nothing changed, just now the error is on line 1733 instead of line 1746(cause i removed lines from removing the hack code)

here is the code where it sais the error, line 1733 is the line that sais: if ($orderby=="") {


// ###################### Start findaway #######################
if ($action=="findaway") {
__if ($orderby=="") {
____$orderby="awaydate";
__}
__if ($limitstart=="") {
____$limitstart=0;
__} else {
____$limitstart--;
__}
__if ($limitnumber=="") {
____$limitnumber=99999999;
__}
__$users=$DB_site->query("SELECT user.userid,username,FROM_UNIXTIME(awaydate) AS awaydate,returndate,awayreason,away FROM user WHERE away = 1 ORDER BY $orderby $direction LIMIT $limitstart,$limitnumber");
__$countusers=$DB_site->query_first("SELECT COUNT(*) AS users FROM user WHERE away=1");
__$limitfinish=$limitstart+$limitnumber;

[Oblivion Knight]

To save yourself a couple of queries (currently for every instance that someone sets their status as away, a query is added), I'd advise doing the following:

Open: showthread.php

Find:
postbit_offline,postbit_onlineAdd BEFORE:
postbit_away,

Find (again):
postbit_offline,postbit_onlineAdd BEFORE:
postbit_away,

[Dan_UPC]

Thanks bira, this is a really nice hack.

[Crank]

i got user.php erorrs when i installed i would love to use this hack although i had to uninstall.
i couldnt even approve members to the site

Invalid SQL: SELECT userid
FROM user
WHERE username='wildflower'
AND userid <>
mysql error: You have an error in your SQL syntax near '' at line 4

mysql error number: 1064


i had used the 1.2a the latest version to install this hack and still got this erorr. any one know of a fix. i would love to use this hack.

[Pseudomizer]

Hello @LL,

does this hack work in VB3.0.x ?

Cheers,

[jamesk]

Anyone planning on doing this for vb3?

[Gamingforce]

I will.

[Pseudomizer]

[QUOTE=Gamingforce]I will.

[Edison Chen]

Okay, I have installed the Custom AWOL hack locatedhere (https://vborg.vbsupport.ru/showthread.php?t=42979&highlight=Custom+Who%27s+Online) as well and it won't allow me to incorporate the hacks together.

For this particular line in the member.php,

// +++++++ Custom Who's Online Locations Hack v1.0 [ g-force2k2 ] +++++++
$DB_site->query("UPDATE user SET birthday='".addslashes($birthday)."',signature='".addslashes($signature)."',customtitle='".intval($customtitle)."',usertitle='".addslashes($customtext)."',email='".addslashes(htmlspecialchars($email))."',parentemail='".addslashes(htmlspecialchars($parentemail))."',coppauser='$coppauser',homepage='".addslashes(htmlspecialchars($homepage))."',icq='".addslashes(htmlspecialchars($icq))."',aim='".addslashes(htmlspecialchars($aim))."',yahoo='".addslashes(htmlspecialchars($yahoo))."',usergroupid='$bbuserinfo[usergroupid]',userloc='".addslashes($userloc)."' WHERE userid='$bbuserinfo[userid]'");
// +++++++ Custom Who's Online Locations Hack v1.0 [ g-force2k2 ] +++++++

I can't seem to know where to add the $awaysql for this hack.

// Leave Away Message in Profile (v1.2a)
$DB_site->query("UPDATE user SET birthday='".addslashes($birthday)."',signature='".addslashes($signature)."',customtitle='".intval($customtitle)."',usertitle='".addslashes($customtext)."',email='".addslashes(htmlspecialchars($email))."',parentemail='".addslashes(htmlspecialchars($parentemail))."',coppauser='$coppauser',homepage='".addslashes(htmlspecialchars($homepage))."',icq='".addslashes(htmlspecialchars($icq))."',aim='".addslashes(htmlspecialchars($aim))."',yahoo='".addslashes(htmlspecialchars($yahoo))."',usergroupid='$bbuserinfo[usergroupid]' $awaysql WHERE userid='$bbuserinfo[userid]'");
// Leave Away Message in Profile (v1.2a)

I can't seem to incorporate them. Help?

[David Coutts]

I had the same problem with another hack. Just try chucking $awaysql at the end, just before "WHERE userid='$bbuserinfo[userid]", but don't forget to make a backup or whatever. Or you could just delete it. :p It worked for me.

[Edison Chen]

Thanks. It works now. ;)

[mholtum]

Is there away to make this work with 3.0.3?

[Alchemist]

Does anyone know how to fix $year. Because even when I edit the template to fix from 2001-2004 to 2005 - 2009, doesn't work.

[Dan_UPC]

[QUOTE=Alchemist]Does anyone know how to fix $year. Because even when I edit the template to fix from 2001-2004 to 2005 - 2009, doesn't work.

[abud999]

thankz Bira & thankz Lesane

bye

[abud999]

<font size="2">thankz Bira & thankz Lesane

bye</font>

[Cle]

I've installed this hack on 2.3.5 and it's working great :D Although I have the same problem as described above. I cannot change the Returndate Year. I already tried the tweak of Dan_UPC, but it's not working. Does anybody have an idea?

[okidoki73]

Hi

is it some news on getting this hack to work whit vb 3.0.x ?
i really want it on my forum but the old version will not work for me :(

[Sho]

I wrote a version of this hack for vB3 (all new code - includes away status in postbit & co, PM auto-reply, as well as some additions, like optionally deactivating away mode on the return date, etc.), let me see if I find the time to package it over the holidays.

[Boofo]

[QUOTE=Sho]I wrote a version of this hack for vB3 (all new code - includes away status in postbit & co, PM auto-reply, as well as some additions, like optionally deactivating away mode on the return date, etc.), let me see if I find the time to package it over the holidays.

[Sir_Yaro]

any chance for 3.0.x version ???

[Sir_Yaro]

I found it:
https://vborg.vbsupport.ru/showthread.php?s=&threadid=67250

[Mum]

I am trying to find something like this for 3.6.5, any ideas anyone? I've been searching for ages.