+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Tutorials & Guides (https://lckb.dev/forum/forumdisplay.php?fid=124)
+----- Forum: Ep1 Guides (https://lckb.dev/forum/forumdisplay.php?fid=178)
+----- Thread: [Fix] Sell 97+ items (/showthread.php?tid=698)
- SibaN - 03-26-2012
i learn that if you tell me how i do that i have good database only i have few problem with query but thx you for help
UPDATE t_item SET a_price = a_price / 2 WHERE a_level > 96 AND a_flag = 62 work for me but problem i cannt buy items in cash shop
but that work for me
UPDATE t_item SET a_price = a_price *1 WHERE a_level > 96 AND a_flag = 62 that work perfect i know what is problem
- Koko - 03-27-2012
Try to put the / at different places.
Ex: a_price/ 2
a_price/2
a_price /2
etc
- Bradox - 03-27-2012
Prices have to be as following: DB price = client price / 2.
Simple query (backup your table before, in case this query is wrong):
UPDATE t_item SET a_price = a_price / 2 WHERE a_level > 96 AND a_flag = 62
Hf
Edit: that will only work if the flag of those items is 62. If u use Falos item sql i think it is.
dont work
- UniX - 03-27-2012
Prices have to be as following: DB price = client price / 2.
Simple query (backup your table before, in case this query is wrong):
UPDATE t_item SET a_price = a_price / 2 WHERE a_level > 96 AND a_flag = 62
Hf
Edit: that will only work if the flag of those items is 62. If u use Falos item sql i think it is.
It works perfectly, but dont forget "; "
Use this:
UPDATE t_item SET a_price = a_price / 2 WHERE a_level > 96 AND a_flag = 62;
- SibaN - 03-28-2012
why i past thes in updat in navicat i restart server than i cannt buy itemes from cash shop
- slayer1 - 07-07-2012
OMG LMFAO you need to put a semicolon at the end of every line, add one of these ; to the end
- Creep - 07-17-2012
OMG LMFAO you need to put a semicolon at the end of every line, add one of these ; to the end
maybe not only in the end.. maybe alos between /2 and WHERE if it dont work
- Addicted - 08-16-2012
LOL what? So, you are sayig in the column a_price in t_item instead of the actual cost of the 97+ equippment say its 2000000 you put a_price/2 instead?
- dethunter12 - 08-16-2012
hmm i think this looks more how it should i learned sql a ltittle bit
UPDATE t_item SET a_price = a_price / 2 WHERE a_level >"96" AND a_flag = 62;
- Koko - 08-16-2012
To be honest I only tested the query on phpmyadmin and it worked like a charm.
And Addicted, what I say is that for 97+ items, u have to divide the price by 2 (only in the database). For example, if the current db price is 2,000,000 for an item, then u'll have to set it to 1,000,000. The query will do that for every 97+ items.