Advertisement
Guest User

Untitled

a guest
Feb 26th, 2017
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.50 KB | None | 0 0
  1. REPLACE INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (13812, 'spell_hun_explosive_trap');
  2. REPLACE INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
  3. (78100, 'spell_sonic_breath_periodic'),
  4. (92407, 'spell_sonic_breath_periodic'),
  5. (92408, 'spell_sonic_breath_periodic'),
  6. (92409, 'spell_sonic_breath_periodic');
  7. UPDATE `creature_template` SET `ScriptName` = 'npc_food' WHERE `entry` IN (48276,48293,48295,48298,48299,48302);
  8. REPLACE INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
  9. (81198, 'spell_nefarian_electrocute_dummy'),
  10. (81272, 'spell_nefarian_electrocute_dummy');
  11. REPLACE INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
  12. (76200, 'spell_lord_obsidius_transform');
  13. REPLACE INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
  14. (44735, 'spell_electric_overload_primer');
  15. REPLACE INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES
  16. (5368,11,0,0,'achievement_prototype_prodigy ');
  17. REPLACE INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES
  18. (6937,16,341,0,''),
  19. (6937,11,0,0,'achievement_torch_juggler');
  20. UPDATE `creature_template` SET `ScriptName` = 'npc_lightning_orbs' WHERE `entry` = '49520';
  21. UPDATE `creature_template` SET `ScriptName` = 'npc_defias_envoker' WHERE `entry` = '48418';
  22. UPDATE `creature_template` SET `ScriptName`= "npc_maloriak_atramedes_event" WHERE `entry` =49938;
  23. UPDATE `creature_template` SET `ScriptName` = 'npc_ogre_henchman' WHERE `entry` = '48230';
  24. UPDATE `creature_template` SET `ScriptName`= "npc_dk_blood_parasite" WHERE `entry` =38231;
  25. UPDATE `creature_template` SET `ScriptName`= "npc_sha_searing_totem" WHERE `entry` =2523;
  26. UPDATE `creature_template` SET `ScriptName`= "npc_warl_infernal" WHERE `entry` =89;
  27. UPDATE `creature_template` SET `ScriptName`= "npc_crashin_trashin_robot" WHERE `entry` =17299;
  28. UPDATE `creature_template` SET `ScriptName`= "npc_sonnar_pulse_summon" WHERE `entry` =41546;
  29. UPDATE `creature_template` SET `ScriptName`='boss_halfus_wyrmbreaker' WHERE `entry`=44600;
  30. UPDATE `creature_template` SET `ScriptName`='npc_pulsing_pumpkin' WHERE `entry` = 23694;
  31. UPDATE `creature_template` SET `ScriptName`='npc_wisp_invis' WHERE `entry` IN (23686, 24034);
  32. UPDATE `gameobject_template` SET `ScriptName`='go_pumpkin_shrine' WHERE `entry`=186267;
  33. UPDATE `creature_template` SET `ScriptName`='npc_head' WHERE `entry`=23775;
  34. UPDATE `creature_template` SET `ScriptName`= "npc_scarlet_trainee" WHERE `entry` =6575;
  35. UPDATE creature_template SET ScriptName='npc_apothecary_hummel' WHERE entry=36296;
  36. UPDATE `creature_template` SET `faction_A` = 16, `faction_H` = 16, `Health_mod` = 86.189, `lootid` = 36296, `mechanic_immune_mask` = 650854235, `ScriptName` = 'npc_apothecary_baxter' WHERE `entry` = 36565;
  37. UPDATE `creature_template` SET `faction_A` = 16, `faction_H` = 16, `Health_mod` = 86.189, `lootid` = 36296, `equipment_id` = 128, `mechanic_immune_mask` = 536870917, `flags_extra` = 256, `ScriptName` = 'npc_apothecary_frye' WHERE `entry` = 36272;
  38. UPDATE `creature_template` SET `faction_A` = 16, `faction_H` = 16, `Health_mod` = 86.189, `mechanic_immune_mask` = 536870917,`ScriptName`='npc_crazed_apothecary' WHERE `entry`=36568;
  39. UPDATE `creature_template` SET `ScriptName`= "npc_ritual_tiki_mask" WHERE `entry` =52364;
  40. UPDATE `creature_template` SET `ScriptName`= "npc_ancient_artifact" WHERE `entry` =52446;
  41. UPDATE `creature_template` SET `ScriptName`= "npc_ancient_artifact" WHERE `entry` =52450;
  42. UPDATE `creature_template` SET `ScriptName`= "npc_haz_nightmare" WHERE `entry` =52271;
  43. UPDATE `creature_template` SET `ScriptName`= "npc_pride_of_bethekk" WHERE `entry` =52061;
  44. UPDATE `creature_template` SET `ScriptName`= "npc_devastating_slam" WHERE `entry` =52324;
  45. UPDATE `creature_template` SET `ScriptName`= "npc_venomous_effusion" WHERE `entry` =52288;
  46. UPDATE `creature_template` SET `ScriptName`= "npc_twilight_hatchling" WHERE `entry` =39388;
  47. UPDATE `creature_template` SET `ScriptName`= "npc_flamefly" WHERE `entry` =48671;
  48. UPDATE `creature_template` SET `ScriptName` = 'npc_chromie' WHERE `entry` = 26527;
  49. UPDATE `creature_template` SET `ScriptName`= "npc_sanotron_500" WHERE `entry` =46185;
  50. UPDATE `creature_template` SET `ScriptName`= "npc_seed_of_chaos" WHERE `entry` =41126;
  51. UPDATE `creature_template` SET `ScriptName`= "npc_reign_of_chaos" WHERE `entry` =41168;
  52. UPDATE `creature_template` SET `ScriptName`= "npc_homeless_citizen" WHERE `entry` =42386;
  53. UPDATE `creature_template` SET `ScriptName`= "npc_homeless_citizen" WHERE `entry` =42384;
  54. UPDATE `creature_template` SET `ScriptName`= "npc_defias_blackguard" WHERE `entry` =636;
  55. UPDATE `creature_template` SET `ScriptName`= "npc_forsaken_catapult" WHERE `entry` =36283;
  56. UPDATE `creature_template` SET `ScriptName`= "npc_molten_front_rayne" WHERE `entry` =52467;
  57. UPDATE `creature_template` SET `ScriptName`= "npc_spore" WHERE `entry` =40585;
  58. UPDATE `creature_template` SET `ScriptName`='boss_baleroc' WHERE `entry`=53494;
  59. UPDATE `creature_template` SET `ScriptName`= "npc_molten_captain_saynna" WHERE `entry` =52493;
  60. UPDATE `creature_template` SET `ScriptName`= "npc_molten_captain_saynna_event" WHERE `entry` =52854;
  61. UPDATE `creature_template` SET `ScriptName`= "npc_molten_front_marin_bladewing" WHERE `entry` =52494;
  62. UPDATE `creature_template` SET `ScriptName`= "npc_molten_front_marin_bladewing" WHERE `entry` =52935;
  63. UPDATE `creature_template` SET `ScriptName`= "npc_baine_totem" WHERE `entry` =54433;
  64. UPDATE `creature_template` SET `ScriptName`= "npc_baine_totem" WHERE `entry` =54434;
  65. UPDATE `creature_template` SET `ScriptName`= "npc_energy_flux" WHERE `entry` =44015;
  66. UPDATE `creature_template` SET `ScriptName`= "npc_fiery_vortex" WHERE `entry` =53693;
  67. UPDATE `creature_template` SET `ScriptName`= "npc_energy_flux" WHERE `entry` =39613;
  68. UPDATE `creature_template` SET `ScriptName`= "npc_stonebull_crayfish" WHERE `entry` =53561;
  69. UPDATE `creature_template` SET `ScriptName`= "npc_stonetalon_prisoner" WHERE `entry` =37167;
  70. UPDATE `creature_template` SET `ScriptName`= "npc_right_foot" WHERE `entry` =53087;
  71. UPDATE `creature_template` SET `ScriptName`= "npc_left_foot" WHERE `entry` =52577;
  72. UPDATE `creature_template` SET `ScriptName`= "npc_warden_sunwell" WHERE `entry` =37523;
  73. UPDATE `creature_template` SET `ScriptName` = 'mob_yenniku' WHERE `entry` = 2530;
  74. UPDATE `creature_template` SET `ScriptName` = 'mob_bwemba' WHERE `entry` = 52234;
  75. UPDATE `creature_template` SET `ScriptName`='npc_lady_sylvanas_windrunner' WHERE `entry`=10181;
  76. UPDATE creature_template SET ScriptName = 'npc_thug' where entry = 42562;
  77. UPDATE creature_template SET scriptname = 'npc_anachronos' WHERE entry = 15192;
  78. UPDATE creature_template SET ScriptName='npc_00x09hl' WHERE entry=7806;
  79. UPDATE `creature_template` SET `ScriptName`= "npc_spectral_ghostly_citizen" WHERE `entry` =10384;
  80. UPDATE `creature_template` SET `ScriptName`= "npc_spectral_ghostly_citizen" WHERE `entry` =10385;
  81. UPDATE `creature_template` SET `ScriptName`= "curse_of_boundless_agony" WHERE `entry` =45032;
  82. UPDATE `creature_template` SET `ScriptName`='boss_hex_lord_malacrass' WHERE `entry`=24239;
  83. UPDATE `creature_template` SET `ScriptName`='npc_gazakroth' WHERE `entry`=24244;
  84. UPDATE `creature_template` SET `ScriptName`='npc_queldelar_sp' WHERE `entry`=38056;
  85. UPDATE `item_template` SET `ScriptName` = 'item_tainted_queldelar' WHERE `entry` IN (49879,49889);
  86. UPDATE `creature_template` set `ScriptName` = 'mob_akilzon_eagle' where `entry`=24858;
  87. UPDATE `creature_template` SET `ScriptName`='npc_blood_worms', `faction_A`=1890, `faction_H`=1890, `speed_run`=0.5, `Health_mod`=3.78 WHERE (`entry`=52827);
  88. UPDATE `creature_template` SET `faction_A`=1890, `faction_H`=1890,`dmg_multiplier`=7.5, `Health_mod`=3.78, `ScriptName`='npc_amani_snake' WHERE (`entry`=24338);
  89. UPDATE `creature_template` SET `exp`=3, `faction_A`=1890, `faction_H`=1890,`Health_mod`=6, `ScriptName`='mob_amani_lynx' WHERE (`entry`=52839);
  90. SET @CREATURTEMPLATE_ENTRY = 96006;
  91. SET @CREATURTEMPLATE_NAME = "Summoner NPC";
  92. SET @CREATURTEMPLATE_SUBNAME = "Darkstanley Inc.";
  93. SET @CREATURTEMPLATE_MODELID = 24978;
  94. REPLACE INTO creature_template (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `dmgschool`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifier`, `DamageModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES
  95. (@CREATURTEMPLATE_ENTRY, 0, 0, 0, 0, 0, @CREATURTEMPLATE_MODELID, 0, 0, 0, @CREATURTEMPLATE_NAME, @CREATURTEMPLATE_SUBNAME, 'Directions', 0, 80, 80, 0, 35, 3, 1, 1.14286, 1, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, 'NPC_Summoner', 0);
  96. UPDATE `creature_template` SET `speed_run`=1.28571426868439, `VehicleId`=463, `minlevel`=4, `maxlevel`=4, `faction_h`=2203, `faction_a`=2203, `Unit_Flags`=8, `Modelid1`=238, `Resistance4`=1, `mechanic_immune_mask`=2147483647, `scriptname`='npc_crowley_horse' WHERE `entry`=35231;
  97. UPDATE `creature_template` SET `speed_run`=1.28571426868439, `npcflag`=0, `VehicleId`=494, `minlevel`=4, `maxlevel`=4, `Faction_A`=2203, `Faction_H`=2203,`Unit_Flags`=8, `Modelid1`=236, `Resistance2`=90, `Resistance4`=1, `unit_class`=2, `scriptname`='npc_greymane_horse', `mechanic_immune_mask`=2147483647 WHERE `entry`=35905;
  98. REPLACE INTO `creature_template` VALUES (35552, 0, 0, 0, 0, 0, 29694, 0, 0, 0, 'Lord Darius Crowley', '', '', 0, 10, 10, 0, 0, 2173, 2173, 3, 1, 1.14286, 1, 1.14286, 1, 1, 13, 17, 0, 42, 7.5, 1111, 2000, 1, 33024, 2048, 0, 0, 0, 0, 0, 0, 9, 13, 0, 7, 262148, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, '', 0, 1, 0, 11, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 613097436, 0, 'npc_lord_darius_crowley_c2', 13623);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement