SHOW:
|
|
- or go back to the newest paste.
| 1 | UPDATE `creature_template` SET `ScriptName` = 'npc_muradin_gunship' WHERE `entry` = 36948; | |
| 2 | UPDATE `creature_template` SET `ScriptName` = 'npc_saurfang_gunship' WHERE `entry` = 36939; | |
| 3 | UPDATE `creature_template` SET `ScriptName` = 'npc_zafod_boombox' WHERE `entry` = 37184; | |
| 4 | UPDATE `creature_template` SET `ScriptName` = 'npc_korkron_defender' WHERE `entry` = 37032; | |
| 5 | UPDATE `creature_template` SET `ScriptName` = 'npc_korkron_primalist' WHERE `entry` = 37030; | |
| 6 | UPDATE `creature_template` SET `ScriptName` = 'npc_skybreaker_vindicator' WHERE `entry` = 37003; | |
| 7 | UPDATE `creature_template` SET `ScriptName` = 'npc_skybreaker_protector' WHERE `entry` = 36998; | |
| 8 | UPDATE `creature_template` SET `ScriptName` = 'npc_icc_spire_frostwyrm' WHERE `entry` = 37230; | |
| 9 | UPDATE `creature_template` SET `ScriptName` = 'npc_korkron_axethrower_rifleman' WHERE `entry` = 36968; | |
| 10 | UPDATE `creature_template` SET `ScriptName` = 'npc_korkron_axethrower_rifleman' WHERE `entry` = 36969; | |
| 11 | UPDATE `creature_template` SET `ScriptName` = 'npc_mortar_soldier_or_rocketeer', AIName = '' WHERE `entry` = 36982; | |
| 12 | UPDATE `creature_template` SET `ScriptName` = 'npc_mortar_soldier_or_rocketeer', AIName = '' WHERE `entry` = 36978; | |
| 13 | UPDATE `creature_template` SET `ScriptName` = 'npc_gunship_mage' WHERE `entry` = 37117; | |
| 14 | UPDATE `creature_template` SET `ScriptName` = 'npc_gunship_mage' WHERE `entry` = 37116; | |
| 15 | UPDATE `creature_template` SET `ScriptName` = 'npc_gunship_trigger' WHERE `entry` = 37547; | |
| 16 | UPDATE `creature_template` SET `ScriptName` = 'npc_gunship_portal' WHERE `entry` = 37227; | |
| 17 | UPDATE `creature_template` SET `ScriptName` = 'npc_marine_or_reaver' WHERE `entry` = 36957; | |
| 18 | UPDATE `creature_template` SET `ScriptName` = 'npc_marine_or_reaver' WHERE `entry` = 36950; | |
| 19 | UPDATE `creature_template` SET `ScriptName` = 'npc_sergeant' WHERE `entry` = 36960; | |
| 20 | UPDATE `creature_template` SET `ScriptName` = 'npc_sergeant' WHERE `entry` = 36961; | |
| 21 | UPDATE `creature_template` SET `ScriptName` = 'npc_gunship_skybreaker' WHERE `entry` = 37540; | |
| 22 | UPDATE `creature_template` SET `ScriptName` = 'npc_gunship_orgrimmar' WHERE `entry` = 37215; | |
| 23 | UPDATE `creature_template` SET `ScriptName` = 'npc_gunship_cannon' WHERE `entry` = 36838; | |
| 24 | UPDATE `creature_template` SET `ScriptName` = 'npc_gunship_cannon' WHERE `entry` = 36839; | |
| 25 | ||
| 26 | UPDATE `gameobject_template` SET `ScriptName` = 'transport_gunship' WHERE `entry` IN (201580, 201812); | |
| 27 | ||
| 28 | ||
| 29 | DELETE FROM `areatrigger_scripts` WHERE `entry` IN (5630, 5628); | |
| 30 | INSERT INTO `areatrigger_scripts` (`entry`,`ScriptName`) VALUES | |
| 31 | (5628,'at_icc_land_frostwyrm'), | |
| 32 | (5630,'at_icc_land_frostwyrm'); | |
| 33 | ||
| 34 | -- SpellScripts | |
| 35 | DELETE FROM `spell_script_names` WHERE `spell_id` IN (70713, 68645, 69471, 69488, 69402, 70175, 71335, 71339); | |
| 36 | INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES | |
| 37 | ('70713', 'spell_icc_remove_rocket_pack'),
| |
| 38 | ('68645', 'spell_rocket_pack'),
| |
| 39 | ('69471', 'spell_gb_heat_drain'),
| |
| 40 | ('69488', 'spell_gb_overheat_drain'),
| |
| 41 | ('69402', 'spell_gb_incinerating_blast'),
| |
| 42 | ('70175', 'spell_gb_incinerating_blast'),
| |
| 43 | ('71335', 'spell_gb_burning_pitch'),
| |
| 44 | ('71339', 'spell_gb_burning_pitch'); |
