The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
Details »» | |||||||||||||||||||||||||
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 Show Your Support
|
Comments |
#62
|
|||
|
|||
Hello.
Still doesn't work. Here is what I am getting now: There seems to have been a slight problem with the My Site database. Please try again by pressing the refresh button in your browser. An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists. We apologise for any inconvenience. Database error in vBulletin Control Panel 2.2.1: Invalid SQL: UPDATE user SET away=0,awaydate='UNIX_TIMESTAMP('1969-12-31 17:00:00')',returndate='0000-00-00',awayreason='',birthday='0000-11-26' ,options='15',usergroupid='2',username='gmull875', email='gmullins875@hotmail.com',styleid='1',parent email='gmullins875@hotmail.com',coppauser=1,homepa ge='http://',icq='',aim='',yahoo='',signature='',adminemail=1 ,showemail=1,invisible=0,usertitle='Junior Member',customtitle=0,joindate=UNIX_TIMESTAMP('200 1-12-09 21:21:43'),cookieuser=1,nosessionhash=1,daysprune= '-1',lastvisit=UNIX_TIMESTAMP('2001-12-10 17:58:47'),lastactivity=UNIX_TIMESTAMP('2001-12-10 17:58:47'),lastpost=UNIX_TIMESTAMP('1969-12-31 17:00:00'),posts='0',timezoneoffset='-3',emailnotification=1,receivepm='1',emailonpm='1' ,ipaddress='206.153.0.195',pmpopup=IF(pmpopup=2 AND 1=1,pmpopup,'1') WHERE userid=2164 mysql error: You have an error in your SQL syntax near '1969-12-31 17:00:00')',returndate='0000-00-00',awayreason='',birthday='0000-11-2' at line 1 mysql error number: 1064 Date: Tuesday 11th of December 2001 08:51:53 AM Script: http://www.mysite.com/forum Referer: http://www.mysite.com/forum/admin/us...it&userid=2164 |
#63
|
||||
|
||||
ok, try this:
change: Code:
if ($awaydate!="") { $awaydate="UNIX_TIMESTAMP('".addslashes($awaydate)."')"; } else { $awaydate=""; } Code:
if ($awaydate!="") { $awaydate="UNIX_TIMESTAMP('".addslashes($awaydate)."')"; } else { $awaydate="[high]''[/high]"; } awaydate='$awaydate' to awaydate=$awaydate |
#64
|
|||
|
|||
Right on Buddy.
She's A-OK. Thanks again. |
#65
|
|||
|
|||
[QUOTE]Originally posted by bira
ok, try this: change: Code:
if ($awaydate!="") { $awaydate="UNIX_TIMESTAMP('".addslashes($awaydate)."')"; } else { $awaydate=""; } Code:
if ($awaydate!="") { $awaydate="UNIX_TIMESTAMP('".addslashes($awaydate)."')"; } else { $awaydate="[high]''[/high]"; } awaydate='$awaydate' to awaydate=$awaydate |
#66
|
||||
|
||||
SirSteve,
It's in admin/user.php Don't know if you added the Admin CP add-on or not. If you did, just open it and make sure the code looks like that. if you didn't have any problems in the user Admin CP page nor any errors, then most likely you don't need to change anything. Cheers, Bira |
#67
|
||||
|
||||
I get this
Parse error: parse error in /home/web+++++/public_html/XXXX/admin/install_awayuser.php on line 488 |
#68
|
||||
|
||||
sorry, my bad. Download the zip file again (from the first post)
|
#69
|
|||
|
|||
[QUOTE]Do you have the normal Online/Offline status icons showing in your postbit template? Do you have the setting for those turned ON in your vBulletin Options??
|
#70
|
||||
|
||||
[QUOTE]Originally posted by bira
OK, I'm going to upload a new installer, which includes: 1) 'Away' auto-cancel when a user posts (optional) 2) Auto-reply to PMs while away (optional) 3) 'Away' details editable in the user's page in Admin CP If you haven't installed the hack yet, then ignore this post and simply download the zip from the first post If you already installed the hack, here's what you need to do to add the Admin CP bit: Open admin/user.php Find: Code:
$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, Code:
$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,[high]FROM_UNIXTIME(awaydate) AS awaydate,[/high] Code:
makeinputcode("IP Address","aipaddress",$user[ipaddress]); PHP Code:
Code:
if ($posts=="") { $posts=0; } PHP Code:
Code:
$DB_site->query("UPDATE user SET birthday='$birthday' Code:
$DB_site->query("UPDATE user SET [high]away=$away,awaydate=$awaydate,returndate='$returndate',awayreason='".addslashes(htmlspecialchars($awayreason))."',[/high]birthday='$birthday' |
#71
|
|||
|
|||
hey bira i get this error when trying to change user info from adminCP
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 3 mysql error number: 1064 Date: Wednesday 12th of December 2001 11:29:15 PM Script: http://www.fscknetworks.net/forums/f...=edit&userid=1 Referer: http://210.49.170.7:81/forums/admin/...s=&action=find got any ideas? |
Thread Tools | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|