diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/8770_world_areatrigger_scripts.sql | 3 | ||||
| -rw-r--r-- | sql/updates/8770_world_script_waypoints.sql | 8 | ||||
| -rw-r--r-- | sql/updates/8770_world_scriptname.sql | 12 |
3 files changed, 23 insertions, 0 deletions
diff --git a/sql/updates/8770_world_areatrigger_scripts.sql b/sql/updates/8770_world_areatrigger_scripts.sql new file mode 100644 index 00000000000..158ad414759 --- /dev/null +++ b/sql/updates/8770_world_areatrigger_scripts.sql @@ -0,0 +1,3 @@ +INSERT INTO areatrigger_scripts VALUES +(5369,'at_RX_214_repair_o_matic_station'), +(5423,'at_RX_214_repair_o_matic_station');
\ No newline at end of file diff --git a/sql/updates/8770_world_script_waypoints.sql b/sql/updates/8770_world_script_waypoints.sql new file mode 100644 index 00000000000..a66c25db739 --- /dev/null +++ b/sql/updates/8770_world_script_waypoints.sql @@ -0,0 +1,8 @@ +-- waypoint for mimron inferno +INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES +(33370, 1, 331.674, -68.6878, 409.804, 0, '0'), +(33370, 2, 274.578, -92.1829, 409.804, 0, '0'), +(33370, 3, 226.433, -66.6652, 409.793, 0, '0'), +(33370, 4, 206.092, -34.7447, 409.801, 0, '0'), +(33370, 5, 240.208, 1.10346, 409.802, 0, '0'), +(33370, 6, 337.199, 11.7051, 409.802, 0, '0');
\ No newline at end of file diff --git a/sql/updates/8770_world_scriptname.sql b/sql/updates/8770_world_scriptname.sql new file mode 100644 index 00000000000..95277633d0e --- /dev/null +++ b/sql/updates/8770_world_scriptname.sql @@ -0,0 +1,12 @@ +UPDATE `creature_template` SET `ScriptName` = 'npc_thorims_hammer' WHERE `entry` =33365; +UPDATE `creature_template` SET `MovementType` =2, `ScriptName` = 'npc_mimirons_inferno' WHERE `entry` =33370; +UPDATE `creature_template` SET `ScriptName` = 'npc_hodirs_fury' WHERE `entry` =33312; +UPDATE `creature_template` SET `ScriptName` = 'npc_freyas_ward' WHERE `entry` =33367; +UPDATE `creature_template` SET `ScriptName` = 'npc_lorekeeper' WHERE `entry` =33686; +UPDATE `creature_template` SET `ScriptName` = 'npc_brann_bronzebeard' WHERE `entry` =33579; +UPDATE `creature_template` SET `ScriptName` = 'npc_freya_ward_summon' WHERE `entry` =34275; +UPDATE `creature_template` SET `ScriptName` = 'npc_mechanolift' WHERE `entry` =33214; +UPDATE `gameobject_template` SET `ScriptName` = 'go_ulduar_tower' WHERE `entry` =194375; +UPDATE `gameobject_template` SET `ScriptName` = 'go_ulduar_tower' WHERE `entry` =194371; +UPDATE `gameobject_template` SET `ScriptName` = 'go_ulduar_tower' WHERE `entry` =194370; +UPDATE `gameobject_template` SET `ScriptName` = 'go_ulduar_tower' WHERE `entry` =194377;
\ No newline at end of file |