block-User_Info.php - $user_prefix Problem

Posted: Sun Nov 16, 2008 2:24 pm

In the user info block (block-User_Info.php) $prefix is used instead of $user_prefix.

Change line 250 of /blocks/block-User_Info.php:

Code:

$sql = 'SELECT username, user_regdate, user_email, user_website FROM '.$prefix.'_users where user_regdate IN (\''.date('M d, Y',time()).'\', \''.date('M d, Y',time()-86400).'\') order by user_regdate DESC, username';

To this:

Code:

$sql = 'SELECT username, user_regdate, user_email, user_website FROM '.$user_prefix.'_users where user_regdate IN (\''.date('M d, Y',time()).'\', \''.date('M d, Y',time()-86400).'\') order by user_regdate DESC, username';

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

This was changed a few month's ago but somehow got overwritten. Thanks for the catch!

Posted: Mon Nov 17, 2008 8:30 am

FYI There are some other ones. I just haven't had time to track them down yet. I think they might be in the shoutbox addon, but not sure.

Posted: Mon Nov 17, 2008 9:45 am

Did global search on a distribution.

It's in the upgrade script (oops) and also in

/includes/nukeSEO/content/Forums.php

Also as Palbin reported in that block. I am not seeing them in the addons. I am searching on $prefix.'_users.

Posted: Mon Nov 17, 2008 10:02 am

You will also need to search on $prefix."_users

Posted: Mon Nov 17, 2008 10:15 am

No hits on that. $prefix."_users I mean.

Posted: Mon Nov 17, 2008 10:54 am

The only others I found were 7 in the rndb_upgrade.php file. All have been corrected and SVN'd

Posted: Mon Nov 17, 2008 11:13 am

[\RavenNuke_v2.30.00\AddOnFiles\Shout_Box\public_html\blocks\block-Shout_Box.php]
Line 463 :

Code:

$sqlF = "SELECT user_timezone, user_dateformat from ".$prefix."_users WHERE username='$username'";

[\RavenNuke_v2.30.00\AddOnFiles\Shout_Box\public_html\modules\Shout_Box\admin\index.php]
Line 190 :

Code:

$sqlF = "SELECT user_timezone, user_dateformat from ".$prefix."_users WHERE username='$username'";

[\RavenNuke_v2.30.00\AddOnFiles\Shout_Box\public_html\modules\Shout_Box\index.php]
Line 88 :

Code:

$sqlF = "SELECT user_timezone, user_dateformat from ".$prefix."_users WHERE username='$username'";

Line 763 :

Code:

$sqlF = "SELECT user_timezone, user_dateformat from ".$prefix."_users WHERE username='$username'";

Posted: Mon Nov 17, 2008 11:19 am

Interesting. Then there may be more. My regular expression didn't catch that and it should have <grrr>. guess It needs a tune up ROTFL

. Thanks. I'll get that corrected ASAP.

Posted: Mon Nov 17, 2008 11:56 am

I think I just found 75 more. I'm verifying now.

Posted: Mon Nov 17, 2008 12:07 pm

Yep. I'm correcting them now.

Posted: Mon Nov 17, 2008 12:31 pm

I've committed all the ones I found. There are still a few in the RNYA folder but I accidentally closed them before I corrected them Laughing

. I will clean the rest up when I get back.