All pastes #974522 Raw Edit

Stuff

public text v1 · immutable
·published 2008-04-06 20:44 UTC
rendered paste body
UPDATE `creature_template` SET `modelid_A` = '14173', `modelid_H` = '0', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Cataclysm Hound Sunwell', `subname`='', `IconName` = '', `rank`='1', `family`='0', `type`='3', `flag1`='72', `RacialLeader`='0' WHERE `entry` = '25957';
UPDATE `creature_template` SET `modelid_A` = '169', `modelid_H` = '11686', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Nether Energy', `subname`='', `IconName` = '', `rank`='0', `family`='0', `type`='10', `flag1`='0', `RacialLeader`='0' WHERE `entry` = '24781';
UPDATE `creature_template` SET `modelid_A` = '22590', `modelid_H` = '0', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Coilskar Witch', `subname`='', `IconName` = '', `rank`='1', `family`='0', `type`='7', `flag1`='8', `RacialLeader`='0' WHERE `entry` = '24696';
UPDATE `creature_template` SET `modelid_A` = '10927', `modelid_H` = '0', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Sister of Torment', `subname`='', `IconName` = '', `rank`='1', `family`='0', `type`='3', `flag1`='8', `RacialLeader`='0' WHERE `entry` = '24697';
UPDATE `creature_template` SET `modelid_A` = '22596', `modelid_H` = '0', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Priestess Delrissa', `subname`='', `IconName` = '', `rank`='1', `family`='0', `type`='7', `flag1`='72', `RacialLeader`='0' WHERE `entry` = '24560';
UPDATE `creature_template` SET `modelid_A` = '18783', `modelid_H` = '16925', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'World Trigger', `subname`='', `IconName` = '', `rank`='0', `family`='0', `type`='10', `flag1`='0', `RacialLeader`='0' WHERE `entry` = '22515';
UPDATE `creature_template` SET `modelid_A` = '22733', `modelid_H` = '0', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Sunblade Sentinel', `subname`='', `IconName` = '', `rank`='1', `family`='0', `type`='9', `flag1`='8', `RacialLeader`='0' WHERE `entry` = '24777';
UPDATE `creature_template` SET `modelid_A` = '20419', `modelid_H` = '0', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Ethereum Smuggler', `subname`='', `IconName` = '', `rank`='1', `family`='0', `type`='7', `flag1`='8', `RacialLeader`='0' WHERE `entry` = '24698';
UPDATE `creature_template` SET `modelid_A` = '21900', `modelid_H` = '0', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Sinister Squashling', `subname`='', `IconName` = '', `rank`='0', `family`='0', `type`='12', `flag1`='0', `RacialLeader`='0' WHERE `entry` = '23909';
UPDATE `creature_template` SET `modelid_A` = '22843', `modelid_H` = '0', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Wretched Bruiser', `subname`='', `IconName` = '', `rank`='1', `family`='0', `type`='7', `flag1`='8', `RacialLeader`='0' WHERE `entry` = '24689';
UPDATE `creature_template` SET `modelid_A` = '22845', `modelid_H` = '0', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Wretched Skulker', `subname`='', `IconName` = '', `rank`='1', `family`='0', `type`='7', `flag1`='8', `RacialLeader`='0' WHERE `entry` = '24688';
UPDATE `creature_template` SET `modelid_A` = '22844', `modelid_H` = '0', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Wretched Husk', `subname`='', `IconName` = '', `rank`='1', `family`='0', `type`='7', `flag1`='8', `RacialLeader`='0' WHERE `entry` = '24690';
UPDATE `creature_template` SET `modelid_A` = '16217', `modelid_H` = '0', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Brightscale Wyrm', `subname`='', `IconName` = '', `rank`='0', `family`='0', `type`='1', `flag1`='0', `RacialLeader`='0' WHERE `entry` = '24761';
UPDATE `creature_template` SET `modelid_A` = '22586', `modelid_H` = '0', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Tyrith', `subname`='', `IconName` = '', `rank`='0', `family`='0', `type`='7', `flag1`='0', `RacialLeader`='0' WHERE `entry` = '24822';
UPDATE `creature_template` SET `modelid_A` = '4587', `modelid_H` = '0', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Mana Tide Totem', `subname`='', `IconName` = '', `rank`='0', `family`='0', `type`='11', `flag1`='0', `RacialLeader`='0' WHERE `entry` = '10467';
UPDATE `creature_template` SET `modelid_A` = '23404', `modelid_H` = '0', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'M\'uru Sunwell', `subname`='', `IconName` = '', `rank`='3', `family`='0', `type`='10', `flag1`='4', `RacialLeader`='0' WHERE `entry` = '25960';
UPDATE `creature_template` SET `modelid_A` = '1126', `modelid_H` = '17612', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Pure Energy', `subname`='', `IconName` = '', `rank`='0', `family`='0', `type`='10', `flag1`='0', `RacialLeader`='0' WHERE `entry` = '24745';
UPDATE `creature_template` SET `modelid_A` = '19294', `modelid_H` = '0', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Hand of the Deceiver Sunwell', `subname`='', `IconName` = '', `rank`='1', `family`='0', `type`='7', `flag1`='72', `RacialLeader`='0' WHERE `entry` = '25955';
UPDATE `creature_template` SET `modelid_A` = '23503', `modelid_H` = '0', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Anveena Replica', `subname`='', `IconName` = '', `rank`='3', `family`='0', `type`='7', `flag1`='104', `RacialLeader`='0' WHERE `entry` = '26579';
UPDATE `creature_template` SET `modelid_A` = '4590', `modelid_H` = '0', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Grounding Totem', `subname`='', `IconName` = '', `rank`='0', `family`='0', `type`='11', `flag1`='0', `RacialLeader`='0' WHERE `entry` = '5925';
UPDATE `creature_template` SET `modelid_A` = '3886', `modelid_H` = '0', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'High Explosive Sheep', `subname`='', `IconName` = '', `rank`='0', `family`='0', `type`='7', `flag1`='0', `RacialLeader`='0' WHERE `entry` = '24715';
UPDATE `creature_template` SET `modelid_A` = '4589', `modelid_H` = '0', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Magma Totem V', `subname`='', `IconName` = '', `rank`='0', `family`='0', `type`='11', `flag1`='0', `RacialLeader`='0' WHERE `entry` = '15484';
UPDATE `creature_template` SET `modelid_A` = '15294', `modelid_H` = '0', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Flame Strike Trigger (Kael - 5Man)', `subname`='', `IconName` = '', `rank`='0', `family`='0', `type`='10', `flag1`='0', `RacialLeader`='0' WHERE `entry` = '24666';
UPDATE `creature_template` SET `modelid_A` = '19682', `modelid_H` = '0', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Phoenix', `subname`='', `IconName` = '', `rank`='1', `family`='0', `type`='4', `flag1`='72', `RacialLeader`='0' WHERE `entry` = '24674';
UPDATE `creature_template` SET `modelid_A` = '11686', `modelid_H` = '0', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Arcane Sphere', `subname`='', `IconName` = '', `rank`='0', `family`='0', `type`='10', `flag1`='0', `RacialLeader`='0' WHERE `entry` = '24708';
UPDATE `creature_template` SET `modelid_A` = '20245', `modelid_H` = '0', `modelid_A2` = '0', `modelid_H2` = '0', `name` = 'Phoenix Egg', `subname`='', `IconName` = '', `rank`='0', `family`='0', `type`='10', `flag1`='64', `RacialLeader`='0' WHERE `entry` = '24675';

update creature_template set modelid_h=modelid_a where modelid_h=0;
update creature_template set modelid_a=modelid_h where modelid_a=0;