How can I verify the admin from a different database?

Nuke Cadet Joined: Feb 13, 2003 Posts: 7 Location: USA

I used to apply the following code and it worked very well. But since I upgraded to phpnuke 6.0 this is no longer possible, instead the script is searching for the admin data in a wrong database.

Any help?

--
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/username/public_html/com/includes/sql_layer.php on line 306
Table 'username_anotherdb.nuke_authors' doesn't existSelection from database failed!
--

The code I am using:

Quote:

$youareadmin = 0;
global $prefix, $dbi, $admin;
if (is_admin($admin)) {
$youareadmin = 1;
}

include("auth.php");
getusrinfo($user);
$uname = $cookie[1];

if ($registered)
{
$result=sql_query("select name, email from ".$user_prefix."_users where uname='$cookie[1]'", $dbi);
list($your_name, $your_email) = sql_fetch_row($result, $dbi);
}

Thanks

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Try changing "$user_prefix" to just "$prefix"

Nuke Cadet Joined: Feb 13, 2003 Posts: 7 Location: USA

Thanks, but I am sorry it did not help.

Richard

Nuke Cadet Joined: Feb 13, 2003 Posts: 7 Location: USA

I think the global definitions we are required.

It functions this way: Very Happy

Quote:

global $user, $userinfo, $cookie, $user_prefix, $prefix, $dbi, $admin;
include("auth.php");
if (is_user($user)){
getusrinfo($user);
$uname = $userinfo[uname];
$email = $userinfo[femail];
$url = $userinfo[url];
$score = 1;
$registered = 1;
$result=sql_query("select name, email from ".$user_prefix."_users where uname='$cookie[1]'", $dbi);
list($your_name, $your_email) = sql_fetch_row($result, $dbi);
} else {
$registered = 0;
$name = ""; $email = ""; $url = "";
$score = 0;
}

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

And that is exactly the code you have that doesn't work?