[Ascent][Help]Tier 5-6 Price?

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..

Quote:

---

Originally Posted by dRACE

I just wanna make so the tier 5-6 cost money..

---

First, set the extended cost to 0 and then find buyprice adn set the buyprice to the price you wish(buyprice is in copper ex. set it to 1500 to make it cost 15s ect)

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?