No More Gold bugs

[ucigashu]

deleted , DAMNNNN im just sharing what i found , WAAAAAAAA i hate you all



Deleted...

[~ViVo~]

Actually, When you put an item in a vendor, Simply put a 1 after it.
EG : .npc vendoradditem 1234 1

[latruwski]

i figured out how to exterminate all gold bugs
Example:
You buy a item free , and sell it for gold


I saw a buypricefix , to hard , to find all ID's
so i figured out how to repair all

UPDATE items SET itemextendedcost = '0' WHERE entry BETWEEN '1' AND '9999999999';

UPDATE items SET buyprice = (sellprice*5) WHERE entry BETWEEN '1' AND '9999999999';

If an item costs 0 gold
this sql makes
0 X 5 = 0 gold
A item costs 100 gold , you sell it for 20 gold

Have Fun !!!

i am sure i posted fixes in one of my query posts for this... your query totally sucks lol

 UPDATE items SET buyprice = (sellprice*5) WHERE buyprice <= sellprice

now you have less 99999 shit

anyhow i posted this already

[ucigashu]

i am sure i posted fixes in one of my query posts for this... your query totally sucks lol

 UPDATE items SET buyprice = (sellprice*5) WHERE buyprice <= sellprice

now you have less 99999 shit

anyhow i posted this already

it works in my database ) , thx anyway

[TheSpidey]

WHERE entry BETWEEN '1' AND '9999999999';
Can be omitted, since you want all items anyway. No need to check the entry.