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:
PHP Code:
if ((!$buddy[invisible] or $bbuserinfo['usergroupid']==6) and $buddy[lastactivity]>$datecut) {
$onoff="on";
} else {
$onoff="off";
}
Instead, search for (thanks
talon3dhq!):
PHP Code:
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!):
PHP Code:
// 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:
PHP 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
Instead, search for (thanks
talon3dhq!):
PHP Code:
$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!):
PHP Code:
$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:
PHP Code:
$sql="SELECT userid,username,invisible,lastactivity
You will find:
PHP Code:
$sql="SELECT userid,username,invisible,lastactivity,lastvisit
Replace it with:
PHP Code:
$sql="SELECT userid,username,invisible,away,lastactivity,lastvisit
b) user.php, step 4/4:
Bira wants us to find:
PHP Code:
$DB_site->query("UPDATE user SET birthday='$birthday'
You will find:
PHP Code:
$DB_site->query("UPDATE user SET birthday='$birthday',options='$options',usergroupid='$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,invisible=$invisible,usertitle='".addslashes($usertitle)."',customtitle=$customtitle,joindate=$joindate,cookieuser=$cookieuser,nosessionhash=$nosessionhash,daysprune='$daysprune',lastvisit=$lastvisit,lastactivity=$lastactivity,lastpost=$lastpost,posts='$posts',timezoneoffset='$timezoneoffset',emailnotification=$emailnotification,receivepm='$receivepm',emailonpm='$emailonpm',ipaddress='".addslashes($aipaddress)."',pmpopup=IF(pmpopup=2 AND $pmpopup=1,pmpopup,'$pmpopup') WHERE userid=$userid");
Change it to:
PHP Code:
$DB_site->query("UPDATE user SET away='$away',awaydate=$awaydate,returndate='$returndate',awayreason='".addslashes(htmlspecialchars($awayreason))."',birthday='$birthday',options='$options',usergroupid='$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,invisible=$invisible,usertitle='".addslashes($usertitle)."',customtitle=$customtitle,joindate=$joindate,cookieuser=$cookieuser,nosessionhash=$nosessionhash,daysprune='$daysprune',lastvisit=$lastvisit,lastactivity=$lastactivity,lastpost=$lastpost,posts='$posts',timezoneoffset='$timezoneoffset',emailnotification=$emailnotification,receivepm='$receivepm',emailonpm='$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:
PHP Code:
eval("\$referrals = \"".gettemplate("getinfo_referrals")."\";");
}
And place this after it:
PHP Code:
// 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:
PHP Code:
eval("\$referrals = \"".gettemplate("getinfo_referrals")."\";");
}
else {
$referrals = '';
}
More Information