[Fix] Sell 97+ items

[SibaN]

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]

Try to put the / at different places.

 

Ex: a_price/ 2

a_price/2

a_price /2

 

etc

[Bradox]

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]

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]

why i past thes in updat in navicat i restart server than i cannt buy itemes from cash shop

[slayer1]

OMG LMFAO you need to put a semicolon at the end of every line, add one of these ; to the end

[Creep]

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]

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]

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]

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.