Hey! I got a little problem! I have removed tokens on tier 5-6 so now is the question how do i fix price on it so tier 5-6 cost money?
Does anyone got a sql or something else?
Regard, dRACE
Printable View
Hey! I got a little problem! I have removed tokens on tier 5-6 so now is the question how do i fix price on it so tier 5-6 cost money?
Does anyone got a sql or something else?
Regard, dRACE
if you want to change the prices.. go to your navicat or SQLyog ore whatever you using and search for the ID of the item you want to modify the price.. and then modify the price..:P
in itemextendedcost put a 0 for it...
Hey! I dont know how and i have searched in items it cant find something with that id! I will make tier 5-6 cost money!
Regard, dRACE
Maybe search for the itemid of the tier 5-6....and then change the COLUMN "itemextendedcost" to 0
I'll get a query quick
This is the query
Quote:
UPDATE `items` SET ItemExtendedCost = 0 WHERE `entry` BETWEEN '1' and '40000';
Do you mean gold?
I just wanna make so the tier 5-6 cost money..
I done what you said! But i cant find the id. but is there not a easy.. way.. to "EDIT" it like with a query? OR SOMETHING?
omg there are more tables in your database..
if your are using navicat go to the right button and press next page
Thanks now i just found that out! But is that not a easy way like with a SQL file or something does anyone got one?
i have done it all to with my own hands
are you scared you must do to much
for your own server..?
Galex i know but it will take loong loong time its about hours! Because there are much tier 5 and 6 items.. have anyone got a sql?
it will take loong loong time its about hours! Because there are much tier 5 and 6 items.. have anyone got a sql?
Code:Don't use this.
Hello channel_49 that did not solve my problem season 1-2 needs too cost or honor points! But 5-6 money :)
Sorry wrong query...
Hey channel_49 nice query.. now the problem is you killed my "Tier 3 - 4" And tiere 5-6 not fixed yet.. have you a quete there can fix it back! Now the tier 3 vendor is dead! You have changed tier 3 all things cost 100g and 4 cost nothing .. o..m..g! :(
All raid tier now have same price only 4-6 Season not have a price omfg! :(((!!
Give me a query that fix the problem back and fix tier 5-6 with price!
Hello channel 49! Now you just "Killed all my raid tier vendor!" Now 1-4 have same price! And 5-6 No price!
Hello channel 49 now you have killed my raid tiers so raid tier vendor 1-4 have same price and 5-6 no price and season no price! Gimme me a quote there make so 1-4 is same price at last.. and 5-6 have price!
Tier 5 = 175 gold, Tier 6 = 200 gold.
channel_49 i just putted in my server and now tier 1 cost 50 g (every thing) and tier 2 75 gold and tier 3 100 and tier 4 - 5 - 6 nothing! - I have removed my cache folder!
Revert back to an older version of your items table before using this:
Change 1750000 (tier 5 price) and 2000000 (tier 6 price).
T5 = 175 gold, T6 = 200 gold.
Code:UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30152';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30154';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30150';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30151';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30153';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30161';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30163';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30159';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30160';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30162';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30190';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30194';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30185';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30189';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30192';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30166';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30168';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30164';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30165';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30167';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30171';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30173';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30169';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30170';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30172';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30212';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30215';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30214';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30211';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30213';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30125';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30127';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30123';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30124';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30126';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30131';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30133';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30129';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30130';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30132';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30136';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30138';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30134';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30135';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30137';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30146';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30149';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30144';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30145';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30148';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30115';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30117';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30113';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30114';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30116';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30120';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30122';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30118';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30119';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30121';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30228';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30230';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30222';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30223';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30229';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30219';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30221';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30216';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30217';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30220';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30233';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30235';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30231';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30232';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30234';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30141';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30143';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30139';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30140';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30142';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30206';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30210';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30196';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30205';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '30207';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31064';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31070';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31065';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31061';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31067';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31003';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31006';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31004';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31001';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31005';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30987';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30998';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30991';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30985';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30995';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30989';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30997';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30990';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30982';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30993';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30988';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30996';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30992';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30983';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30994';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31051';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31054';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31052';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31050';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31053';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30974';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30980';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30976';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30970';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30978';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30972';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30979';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30975';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30969';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '30977';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31015';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31024';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31018';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31011';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31021';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31012';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31022';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31016';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31007';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31019';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31014';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31023';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31017';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31008';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31020';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31027';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31030';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31028';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31026';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31029';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31056';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31059';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31057';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31055';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31058';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31039';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31048';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31042';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31034';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31044';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31037';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31047';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31041';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31032';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31045';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31040';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31049';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31043';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31035';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31046';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31063';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31069';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31066';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31060';
UPDATE items SET buyprice = '2000000', itemextendedcost = '0' WHERE entry = '31068';
channel_49 there is no price. on tier 5-6 but is a bit crappy you have made tier 1-2-3-4 same price..
Now it works! And the price on all tier is okay.. ;)
Thank for the best support by channel_49 i'll give you a +rep!
Can you give me a query that give price on tier 4
Code:UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29076';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29079';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29077';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29080';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29078';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29040';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29043';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29038';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29039';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29042';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29028';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29031';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29029';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29032';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29030';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29035';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29037';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29033';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29034';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29036';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29081';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29084';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29082';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29085';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29083';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29049';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29054';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29050';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29055';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29053';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29058';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29060';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29056';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29057';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29059';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29068';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29070';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29066';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29067';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29069';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29073';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29075';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29071';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29072';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29074';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29061';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29064';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29062';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29065';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29063';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29098';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29100';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29096';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29097';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29099';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29086';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29089';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29087';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29090';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29088';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29093';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29095';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29091';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29092';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29094';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29044';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29047';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29045';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29048';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29046';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '28963';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '28967';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '28964';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '28968';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '28966';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29011';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29016';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29012';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29017';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29015';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29021';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29023';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29019';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29020';
UPDATE items SET buyprice = '1750000', itemextendedcost = '0' WHERE entry = '29022';
Once a time you did it channel_49 ! ;) - Thank you so much! Do you have a query that fix season 1 (Armor and weapon) and season 2 (Armor and weapon) and season 3 (Armor and weapon) with price?