Nuke Treasury Help

New Member Joined: Apr 20, 2006 Posts: 8

Anyone want to rewrite this module for 7.9? I'm to lazy!

Posted: Mon Apr 24, 2006 9:34 am

What's this $dbi? Can you try the query without it and see what happens? Try leaving it out of the query and the result row.

Just have the query be:

$result = sql_query("select radminsuper from ".$prefix."_authors where aid='$aid'");
list($radminsuper) = sql_fetch_row($result);

No guarantee but that's what the code looks like in my admin.php.

Posted: Mon Apr 24, 2006 5:59 pm

Guess that wasn't it.....it added another error!!

Posted: Mon Apr 24, 2006 6:25 pm

Sorry. I guess I don't know what it is then. Oh, I just took a look at sql_layer.php and on line 85 the code is for mssql not mysql. I realize that your file may not line up exactly like mine does (mine is from Ravennuke) but it's worth checking. I'm wondering if possibly you could have the wrong database type in config.php? There's a $dbtype variable there. That's just a wild guess though.

Posted: Mon Apr 24, 2006 6:59 pm

Nope

Posted: Mon Apr 24, 2006 8:18 pm

Well I am sure not helping much. I'm looking at the SQL layer thing again and the definition for the fetch_row goes like this:

case "MySQL":
$row = mysql_fetch_row($res);

So, if you want to try just one more thing, just have the $result be the parameter passed to that, leaving out the $dbi for that one but leaving it in the query itself.

The definition for the query is:

case "MySQL":
$res=@mysql_query($query, $id);

So that's where the $dbi comes in to play.

In other words you statement would be:

list($radminsuper) = sql_fetch_row($result);

Like I say, I don't know but I sure don't see anything else that's obviously wrong.