Error with Administration treasury icon

bugsTHoR · Worker Joined: Apr 05, 2006 Posts: 211

when i click on the treasury Icon in the administration
i managed to fix my other problems with it thanks to help offerd before. but could not find an answer to this problem.

i get this error message

Code:

Fatal error: Call to undefined function sql_query() in /home/oqhxyrwk/public_html/gamersmad.com/admin/modules/treasury.php on line 25

and i look in the treasury.php on line 25 it says this

Code:

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

its a seperate DB like is sugested for easier backup , but how come its not finding my god authers account in the other DB
im using ravens current version just so you know 2.30

sorry if this has been answerd i could not find it

jakec · Posted: Sun Jan 18, 2009 1:52 pm

This is due to the $dbi issue that has been discussed in the forums. Please refer to the sticky which talks about how to convert to the new SQL layer.

Doulos · Involved Joined: Jun 06, 2005 Posts: 454

Code:

I have changed lines 25 and 26$result = sql_query("select radminsuper from ".$prefix."_authors where aid='$aid'", $dbi);
list($radminsuper) = sql_fetch_row($result, $dbi);:

To this:

Code:

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

I also changed all other instances of $dbi to $db and I still am getting this error:

Quote:

Fatal error: Call to undefined function sql_query() in /home/clanfga/public_html/admin/modules/treasury.php on line 25

The only way I am able to get this working is to comment out lines 25 and 26.

EDITED BY PALBIN - fixed code tag

jakec · Posted: Mon Jan 19, 2009 3:17 pm

You are missing the $db-> in the queries above.

Doulos · Involved Joined: Jun 06, 2005 Posts: 454

grr, I was looking at the examples and still missed it.

jakec · Posted: Mon Jan 19, 2009 3:21 pm

I've done exactly the same thing. Laughing

bugsTHoR · Worker Joined: Apr 05, 2006 Posts: 211

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

is this what im after as this does not do the trick either

Palbin · Posted: Tue Jan 20, 2009 10:14 am

Refer to

Only registered users can see links on this board!
Get registered or login to the forums!

and jakec reply.

bugsTHoR · Worker Joined: Apr 05, 2006 Posts: 211

sorry maybe im mising something but i followed it to the letter and changed all refrence to DB in the file from dbi , no worky worky
i blanked it out with // and it does work fine wether it still going to work ok i have no idea.

anyhoos ty

Raven · Posted: Tue Jan 20, 2009 12:33 pm

bugsTHoR wrote:

sorry maybe im mising something but i followed it to the letter and changed all refrence to DB in the file from dbi , no worky worky
i blanked it out with // and it does work fine wether it still going to work ok i have no idea.

anyhoos ty

It should read:

Code:

$result = $db->sql_query("select radminsuper from ".$prefix."_authors where aid='$aid'");
list($radminsuper) = $db->sql_fetchrow($result);

bugsTHoR · Worker Joined: Apr 05, 2006 Posts: 211

TY all