Files
mod-azerothshard/modules/mod-as-common/data/sql/db-world-diff/item_template___update.sql
Yehonal 6fa0b0f315 Init
2021-06-09 01:15:26 +02:00

214 lines
16 KiB
SQL

UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '28234';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '28235';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '28236';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '28237';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '28238';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '28239';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '28240';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '28241';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '28242';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '28243';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '30343';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '30344';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '30345';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '30346';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '30348';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '30349';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '30350';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '30351';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '37864';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '37865';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '38589';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '42124';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '42126';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '51377';
UPDATE `item_template` SET `AllowableRace` = '-1' WHERE `entry` = '51378';
UPDATE `item_template` SET `BuyCount` = '20' WHERE `entry` = '19997';
UPDATE `item_template` SET `BuyCount` = '20' WHERE `entry` = '20390';
UPDATE `item_template` SET `BuyPrice` = '1000000', `AllowableRace` = '-1' WHERE `entry` = '42122';
UPDATE `item_template` SET `BuyPrice` = '1000000', `AllowableRace` = '-1' WHERE `entry` = '42123';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40784';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40785';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40786';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40804';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40805';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40806';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40823';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40824';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40825';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40844';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40845';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40846';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40862';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40863';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40864';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40879';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40880';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40888';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40905';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40926';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40932';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40938';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40962';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40974';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40975';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40982';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40990';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '40991';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41000';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41006';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41012';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41018';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41026';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41032';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41037';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41043';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41048';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41054';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41059';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41064';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41069';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41074';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41080';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41086';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41136';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41142';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41150';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41156';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41198';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41204';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41210';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41216';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41224';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41229';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41234';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41274';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41280';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41286';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41292';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41297';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41303';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41309';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41315';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41320';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41326';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41616';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41620';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41624';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41629';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41634';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41639';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41649';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41654';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41660';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41666';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41671';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41677';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41682';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41714';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41766';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41772';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41831';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41835';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41839';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41853';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41858';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41863';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41868';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41873';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41880';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41884';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41892';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41897';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41902';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41908';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41914';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41920';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41926';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41933';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41939';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41945';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41951';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41958';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41964';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41970';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41992';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '41997';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42004';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42010';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42016';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42027';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42028';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42029';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42030';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42031';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42032';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42033';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42062';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42063';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42064';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42065';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42066';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42067';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42068';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42114';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42115';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42128';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42129';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42130';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42131';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42132';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42208';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42227';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42232';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42237';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42242';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42248';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42255';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42260';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42265';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42270';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42275';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42280';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42285';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42290';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42317';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42322';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42327';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42332';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42346';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42352';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42362';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42384';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42390';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42450';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42485';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42490';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42495';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42502';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42513';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42519';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42525';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42531';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42537';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42559';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42564';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42570';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42578';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42583';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42588';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42597';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42602';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42607';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42614';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42620';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '42852';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '44419';
UPDATE `item_template` SET `BuyPrice` = '1000000' WHERE `entry` = '44420';
UPDATE `item_template` SET `Flags` = '64', `maxcount` = '5', `spellid_1` = '36177', `ScriptName` = 'azth_main_morph' WHERE `entry` = '32561';
UPDATE `item_template` SET `name` = 'Garga\'s Magic Box', `Flags` = '64', `maxcount` = '5', `spellid_1` = '36177', `description` = 'Non sono così egocentrico da chiamare un NPC come me.', `ScriptName` = 'item_azth_hearthstone_loot_sack' WHERE `entry` = '32558';
UPDATE `item_template` SET `name` = 'Mark of Azeroth', `Flags` = '0', `maxcount` = '0', `stackable` = '2147483647', `spellid_1` = '0', `spellcharges_1` = '0', `description` = 'Il bottino di ogni avventuriero!' WHERE `entry` = '37711';
UPDATE `item_template` SET `name` = 'Mucca', `Flags` = '64', `stackable` = '1060', `spellid_1` = '36177', `ScriptName` = 'azth_get_morph' WHERE `entry` = '32543';
UPDATE `item_template` SET `name` = 'Smartstone', `Flags` = '64', `spellid_1` = '36177', `ScriptName` = 'azth_smart_stone' WHERE `entry` = '32547';
UPDATE `item_template` SET `name` = 'The Lich King', `Flags` = '64', `stackable` = '30721', `spellid_1` = '36177', `ScriptName` = 'azth_get_morph' WHERE `entry` = '32544';