search

MarcTowler / ItsLit-RPG-Tracker

Issue tracker for all parts of the ItsLit RPG
0 stars 0 forks source link

Sold items not affecting balance #56

Closed MarcTowler closed 4 years ago

MarcTowler commented 4 years ago

since bringing in multi-shops image

MarcTowler commented 4 years ago

issue seems to be localised to shop id 2

MarcTowler commented 4 years ago

Issue is due to the following:

shop does not range item (db entry for shop_item is non-existant)
item is sold to shop
the initial select query fails to pull price which causes the 2nd and 4th queries to fail, 3rd query is a success which means that the item is removed but nothing else happens...

To fix, every shop needs to have shop_item entry for every item.... But I don't want every shop to sell those items, I will need to add a field in the shop_items table called ranged as a boolean, if true, it appears in the shop, if false it does not appear

MarcTowler commented 4 years ago

cid/uid mis match on DB query again, really need to look at changing that long term to fix overall