Simple quick conversion for Nuke Treasury

wiz · Client Joined: Oct 09, 2006 Posts: 394 Location: UK

For all those that may not know....

In /admin/modules/treasury.php
Find:

Code:

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

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

Replace with:

Code:

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

list($radminsuper) = $db->sql_fetchrow($result);

It should be line 51.

montego · Posted: Mon Apr 27, 2009 10:02 pm

Thanks!

wiz · Client Joined: Oct 09, 2006 Posts: 394 Location: UK

No worries.. I sourced the info from this forum, but i thought that it is a module that many people actually use..so will cause problems for many too. Cheers

wiz · Client Joined: Oct 09, 2006 Posts: 394 Location: UK

May i add.......
If you do not do this, Treasury will still work, donations will stlll come in. However, Admins will not be able to view or reconcile donations.

Cheers
WIZ

wiz · Client Joined: Oct 09, 2006 Posts: 394 Location: UK

correction... it is not fixed. I am struggling with this error..

Fatal error: Call to undefined function sql_fetch_row()

Code:

// $result = sql_query("select radminsuper from ".$prefix."_authors where aid='$aid'", $dbi);
$sql="select radminsuper from ".$prefix."_authors where aid='$aid'"; // Fix for RN 2.3
$result =$db->sql_query($sql);

list($radminsuper) = sql_fetch_row($result, $dbi); //throwing error - WIZ

Cheers
WIZ

duck · Involved Joined: Jul 03, 2006 Posts: 267

change to $db->sql_fetchrow

wiz · Client Joined: Oct 09, 2006 Posts: 394 Location: UK

nope, that doesnt do it.

Fatal error: Call to a member function sql_fetch_row() on a non-object

Palbin · Posted: Tue Apr 28, 2009 12:46 pm

Code:

list($radminsuper) = $db->sql_fetchrow($result);

wiz · Client Joined: Oct 09, 2006 Posts: 394 Location: UK

FIXED
Thanks guys..i forgot that sql_fetch_row now becomes sql_fetchrow.

Original post modified to reflect the true solution.

Cheers
WIZ

sexycoder · Posted: Wed Jun 03, 2009 3:23 am

What about this after

Search for

Code:

function Treasury()
{
global $admin, $bgcolor2, $prefix, $dbi, $currentlang, $multilingual;

Replace with

Code:

function Treasury()
{
global $admin, $bgcolor2, $prefix, $db, $currentlang, $multilingual;

One question I can see more like this in modules/Donations/admin/index.php

Can anybody tell me if this module should be converted all. Let me know please because I still see dbi Shocked

Guardian2003 · Posted: Wed Jun 03, 2009 4:18 am

I have the module available on my site but it's $5
I have already done the $dbi conversion and also fixed a number of errors and made it XHTML 1.0 Transitional Compliant. I am in the middle of writing a new module to replace Treasury completely including multiple currency support, subscriptions and one-off payments but I have had to put it aside for now to finish some more urgent projects and client work.

sexycoder · Posted: Wed Jun 03, 2009 6:40 pm

Quote:

I have the module available on my site but it's $5

u dont accept free emails. I dont understand why not because I regret to use payment email account. What happens if I switch to another internet company then your email is gone. I dont understand what could be your limitations but I would like to have NT to see what u did with that old module.

luckson · Posted: Wed Jun 03, 2009 8:50 pm

Guardian2003, That sounds like a good fix with just $5 however I have been jailed in your Sentinel for trying to hack! ? while trying to check your stuff in the site:p> eh lol. anyway...i have sent a PM for you.

Thanks
Luckson

Guardian2003 · Posted: Wed Jun 03, 2009 9:24 pm

I replied to your PM. Just to clarify for other readers, I am occassionally having the same issue with the 406 error. It is not due to NukeSentinel (tm) but seems to be a server problem. I thought it was something unique to my ISP doing weird things with my NAT firewall or giving me a proxy IP as it resolves itself if I reboot my modem.
Now that you have made me aware you are having the same problem, I can take steps to resolve it.
Thank you for the PM and for letting me know.