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

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?