+- 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)
- Koko - 02-28-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.
- SibaN - 03-26-2012
UPDATE t_item SET a_price = 200000, WHERE a_level = 96, a_flag = 62; it dont work for me why
- Koko - 03-26-2012
Why dont u use the query I made, it works perfectly o.o
- SibaN - 03-26-2012
UPDATE t_item SET a_price = a_price / 2 WHERE a_level > 96 AND a_flag = 62 dont work for me
- Koko - 03-26-2012
Try to remove the AND a_flag = 62
- SibaN - 03-26-2012
UPDATE t_item SET a_price = a_price / 2 WHERE a_level > 96 dont work
[ATTACH=CONFIG]1038[/ATTACH]
- someone - 03-26-2012
Your error, why do you use commas in the SQL command?
and when you dont put semicolon it will take all the lines and save them as 1 single instruction, which your fist line shows an error (you have a comma before WHERE)
- SibaN - 03-26-2012
what i do now please
- SibaN - 03-26-2012
UPDATE t_item SET a_price = a_price / 2 ;WHERE a_level > 96 AND a_flag = 62
- someone - 03-26-2012
No more help for you learn SQL sintax before trying to receive help:
2