Error with Administration treasury icon

Involved Joined: Apr 05, 2006 Posts: 263

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

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.

Posted: Mon Jan 19, 2009 3:14 pm

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

Posted: Mon Jan 19, 2009 3:17 pm

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

Posted: Mon Jan 19, 2009 3:20 pm

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

Posted: Mon Jan 19, 2009 3:21 pm

I've done exactly the same thing. Laughing

Posted: Tue Jan 20, 2009 9:18 am

$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

Posted: Tue Jan 20, 2009 10:14 am

Refer to Only registered users can see links on this board! Get registered or login! and jakec reply.

Posted: Tue Jan 20, 2009 11:28 am

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

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

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);

Posted: Tue Jan 20, 2009 6:44 pm

TY all