aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/426_world_scripts.sql (renamed from sql/updates/425_world_scripts.sql)0
-rw-r--r--sql/updates/427_world_scripts.sql57
2 files changed, 57 insertions, 0 deletions
diff --git a/sql/updates/425_world_scripts.sql b/sql/updates/426_world_scripts.sql
index 1d653e57891..1d653e57891 100644
--- a/sql/updates/425_world_scripts.sql
+++ b/sql/updates/426_world_scripts.sql
diff --git a/sql/updates/427_world_scripts.sql b/sql/updates/427_world_scripts.sql
new file mode 100644
index 00000000000..dd5d8c7b597
--- /dev/null
+++ b/sql/updates/427_world_scripts.sql
@@ -0,0 +1,57 @@
+Update `instance_template` set `script`='instance_scarlet_monastery' where `map`='189';
+Update `gameobject_template` set `ScriptName`='go_loosely_turned_soil' where`entry`='186314';
+
+update `creature_template` set `scriptname`='boss_headless_horseman',
+`minlevel`=70, `maxlevel`=70, `minhealth`=67068, `maxhealth`=67068,
+`minmana`=3155, `maxmana`=3155, `type`=6
+ where `entry` = 23682;
+
+update `creature_template` set `scriptname`='mob_head',
+ `minlevel`=70, `maxlevel`=70, `type`=6, `modelid_h`=21908,
+`minhealth`=24300, `maxhealth`=24300,
+`faction_A`=14, `faction_H`=14
+where `entry` = 23775;
+
+update `creature_template` set `scriptname`='mob_pulsing_pumpkin',
+`faction_A`=14, `faction_H`=14, `type`=6,
+`minlevel`=70, `maxlevel`=70,
+`minhealth`=9781, `maxhealth`=9781,
+`minmana`=3155, `maxmana`=3155
+where `entry` = 23694;
+
+--helper
+Update `creature_template` set `scriptname`='mob_wisp_invis',
+`faction_A`=35, `faction_H`=35,
+`unit_flags`='33554434' where `entry`='23686';
+
+-- pumpkin fiend
+Update `creature_template` set
+ `minlevel`=70, `maxlevel`=70,
+`faction_A`=14, `faction_H`=14,
+`type`=6
+where `entry`='23545';
+
+-- wisp
+Update `creature_template` set `scriptname`='mob_wisp_invis',
+`modelid_a`=21342, `modelid_h`=21342,
+`faction_A`=35, `faction_H`=35, `unit_flags`='33554434'
+where `entry`='24034';
+
+update `creature_template` set `equipment_id`=23682 where `entry` = 23682;
+replace into`creature_equip_template` (`entry`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `equipinfo1`, `equipinfo2`, `equipinfo3`, `equipslot1`, `equipslot2`, `equipslot3`)
+VALUES (23682, 50495, 0, 0, 33490690, 0, 0, 781, 0, 0);
+
+Replace into `script_texts` values
+(-1189001, 'It is over, your search is done! Let fate choose now, the righteous one',0,0,0,0,0,0,0,0,11961,1,0,'Headless Horseman SAY_ENTRANCE'),
+
+(-1189002, 'Here\'s my body, fit and pure! Now, your blackened souls I\'ll cure!',0,0,0,0,0,0,0,0,12567,1,0,'Headless Horseman SAY_REJOINED'),
+
+(-1189003, 'Over here, you idiot!',0,0,0,0,0,0,0,0,12569,1,0,'Headless Horseman SAY_LOST_HEAD'),
+
+(-1189004, 'Harken, cur! Tis you I spurn! Now, $N, feel the burn!',0,0,0,0,0,0,0,0,12573,1,0,'Headless Horseman SAY_CONFLAGRATION'),
+
+(-1189005, 'Soldiers arise, stand and fight! Bring victory at last to this fallen knight!',0,0,0,0,0,0,0,0,11963,1,0,'Headless Horseman SAY_SPROUTING_PUMPKINS'),
+
+(-1189006, 'Your body lies beaten, battered and broken. Let my curse be your own, fate has spoken',0,0,0,0,0,0,0,0,11962,0,0,'Headless Horseman SAY_PLAYER_DEATH'),
+
+(-1189007, 'This end have I reached before. What new adventure lies in store?',0,0,0,0,0,0,0,0,11964,0,0,'Headless Horseman SAY_DEATH'); \ No newline at end of file