Shop system Znote AAC

[dchampag]

Hey there otland,

I am using the latest Znote AAC, I added this function for the shop system so that I can add items to shop through database.

function get_shop_offers() {
    return mysql_select_multi("SELECT `type`, `itemid`, `count`, `description`, `points` FROM `znote_shop`;");
}

This is working for the tables and shop list, but I am unable to purchase the first item on the list, I cannot figure out why. I am not getting any errors in my log, every other item purchase works as it should. What would be the difference between adding items to the table category_items from this function versus config.php shop_offers? When the items are added to config['shop_offers'], there is no issues. Thank you!

Website link is as follows

Infernal OT

 

[dchampag]

Bump. Can anyone explain to me why the table generated from this MySQL script is causing issues for the first item, but not when using the manual table in config?

 

[dchampag]

UPDATE, I was able to dump the variables from the array and see that the array key was initiating with 0 instead of 1 and that was the only difference. the solution for this is as follows if anyone has this issue.

if ($shop['useDB'] === true) {
    $shop_list = get_shop_offers();
    array_unshift($shop_list, "phoney");
    unset($shop_list[0]);
} else {
    $shop_list = $config['shop_offers'];
}