Unlimited Bank

[rorschach 0]

Hello I just have installed the offline shop system It works but when i withdraw some yangs in my bank the amount of yang does not decrease from the bank but I get them.

Here is the function that I think does the job :

DBManager::instance().DirectQuery("UPDATE player.player SET money = money - %u WHERE id = %u", dwRequiredMoney, ch->GetPlayerID());

I would be grateful if someone could help me.

Thank in advance.

[kodepiko 39]

On 12.07.2016 at 0:22 AM, rorschach said:

Hello I just have installed the offline shop system It works but when i withdraw some yangs in my bank the amount of yang does not decrease from the bank but I get them.

Here is the function that I think does the job :

DBManager::instance().DirectQuery("UPDATE player.player SET money = money - %u WHERE id = %u", dwRequiredMoney, ch->GetPlayerID());

I would be grateful if someone could help me.

Thank in advance.

try changing to

DBManager::instance().DirectQuery("UPDATE player.player SET gold = gold - %u WHERE id = %u", dwRequiredMoney, ch->GetPlayerID());

 

I think you need also check condition if price > money

just replace money to gold because in player.player there's gold field, not money

[rorschach 0]

Thanks for the answer, the system works with a new column(money) in player.player so I think you are wrong. I think I solved when I changed the coding of the money column. But I have two last problem, the first is that when I put a weapon with 1-5 bonus(maybe some bonus works I only check with average body/magic damage) and then I close the shop, the item lost it's bonus. The second is that I can't change the price of an item after having created the shop.