Helping for compatible a mod in vb4 to vb6

[zohall]

Hello
i have a mod in vb4 and it is a payment method for our country
it is important for us and no body want upgrade to vb6 without this.

can u help us?

we have error when uploading xml file

An unexpected error was returned: 'Call to a member function hide_errors() on null'

Exception trace:

## /forum/core/includes/adminfunctions_product.php(952) : eval()'d code(35) Exception Thrown
#0 /forum/core/includes/adminfunctions_product.php(952): eval()
#1 /forum/core/admincp/product.php(1213): install_product()
#2 /forum/includes/api/interface/collapsed.php(149): require_once('/home/bydgofzg/...')
#3 /forum/includes/vb5/frontend/controller/relay.php(33): Api_Interface_Collapsed->relay()
#4 /forum/index.php(65): vB5_Frontend_Controller_Relay->admincp()
#5 {main}​

it is here:

https://github.com/ZarinPal-Lab/vBulletinModule/

[glennrocksvb]

Try replacing all instances of $db with $vbulletin->db

Some are already using it but most are not.

I don't know how those worked correctly in vB4 because the $db variable is not defined and thus has a null value. Maybe there was $db = $vbulletin->db; declaration before but it was deleted?

[zohall]

i replaced all

but still error

An unexpected error was returned: 'Call to a member function hide_errors() on null'

Exception trace:

## /forum/core/includes/adminfunctions_product.php(952) : eval()'d code(35) Exception Thrown
#0 /forum/core/includes/adminfunctions_product.php(952): eval()
#1 /forum/core/admincp/product.php(1213): install_product()
#2 /forum/includes/api/interface/collapsed.php(149): require_once('/home/bydgofzg/...')
#3 /forum/includes/vb5/frontend/controller/relay.php(33): Api_Interface_Collapsed->relay()
#4 /forum/index.php(65): vB5_Frontend_Controller_Relay->admincp()
#5 {main}​​

[glennrocksvb]

I tried installing it on my local vB6 and doing the changes I suggested and it got past that error and got a new error.

An unexpected error was returned: 'Call to undefined function fetch_query_sql()'

Make sure you are correctly replacing $db with $vbulletin->db. Take note of where the $ sign is.

To fix the new error, replace fetch_query_sql with fetchQuerySql.

You may still get new errors after that.

Btw, since this mod was made for vB4, it may not completely work with vB6 without further tweaks.

[zohall]

yes new error is arrived

An unexpected error was returned: 'mysqli_query(): Argument #2 ($query) must be of type string, array given'

i think is is related to query of db

[zohall]

for example this code is right?

if ($check = $vbulletin->db->query_first("

[glennrocksvb]

Technically it's correct. It shouldn't cause any issue. Although storing the output in the $check variable is unnecessary as the variable is not used thereafter. The variable is supposed to contain an array of all the columns in the resulting query but no column is used. It's basically only concerned if the query returns any records or rows and doesn't care about the records itself.

[zohall]

there are not many codes, pls if u have time pls see this and find out what is the problem.

[zohall]

i fond what is the problem

$db->query_write(fetch_query_sql($api, 'paymentapi'));

change to

$db->query_write("INSERT INTO " . TABLE_PREFIX . "paymentapi (title, active, classname, currency, recurring, settings) values ('zarinpalwg', 1, 'zarinpalwg', 'usd', 0, '" . serialize($apisettings) . "')");

but "subsettings" field in phpmyadmin is empty

[zohall]

i fixed it.

[glennrocksvb]

Glad you figured it out.

If you're comfortable sharing the solution, it could be really helpful for others facing the same issue.

[zohall]

im using

global $vbulletin;
$db = $vbulletin->db;
$settings = array("gpid" => array("type" => "text", "value" => "", "validate" => "string"), "d2t" => array("type" => "text", "value" => "", "validate" => "string"));
$subsettings = array('show' => array('type' => 'yesno', 'type' => 'yesno', 'type' => 'yesno'));
$db->query_write("INSERT INTO " . TABLE_PREFIX . "paymentapi (title, active, classname, currency, recurring, settings, subsettings) values ('gooyapay', 1, 'gooyapay', 'usd', 0, '" . serialize($settings) . "', '" . serialize($subsettings) . "')");

in xml

my xml completely is: