[Fix] Sell 97+ items

[Koko]

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]

UPDATE t_item SET a_price = 200000, WHERE a_level = 96, a_flag = 62; it dont work for me why

[Koko]

Why dont u use the query I made, it works perfectly o.o

[SibaN]

UPDATE t_item SET a_price = a_price / 2 WHERE a_level > 96 AND a_flag = 62 dont work for me

[Koko]

Try to remove the AND a_flag = 62

[SibaN]

UPDATE t_item SET a_price = a_price / 2 WHERE a_level > 96 dont work

[ATTACH=CONFIG]1038[/ATTACH]

[someone]

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]

what i do now please

[SibaN]

UPDATE t_item SET a_price = a_price / 2 ;WHERE a_level > 96 AND a_flag = 62

[someone]

No more help for you learn SQL sintax before trying to receive help:

2