diff options
| -rw-r--r-- | sql/updates/world/2012_12_14_01_world_waypoint_data.sql | 1 | ||||
| -rw-r--r-- | sql/updates/world/2012_12_14_02_world_misc.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2012_12_14_04_world_misc.sql | 7 |
3 files changed, 9 insertions, 1 deletions
diff --git a/sql/updates/world/2012_12_14_01_world_waypoint_data.sql b/sql/updates/world/2012_12_14_01_world_waypoint_data.sql index 9e9e99500db..e3589c53340 100644 --- a/sql/updates/world/2012_12_14_01_world_waypoint_data.sql +++ b/sql/updates/world/2012_12_14_01_world_waypoint_data.sql @@ -175,6 +175,7 @@ DELETE FROM `waypoint_data` WHERE `id`=883750; INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_flag`, `action`, `action_chance`, `wpguid`) VALUES (883750, 1, -8541.23, 1144.3, 18.9831, 0, 3000, 0, 0, 100, 0), (883750, 2, -8538.3, 1149.52, 19.0522, 0, 2000, 0, 0, 100, 0), +(883750, 3, -8538.3, 1149.52, 19.0522, 0, 15000, 0, 1029, 100, 0), (883750, 4, -8538.3, 1149.52, 19.0522, 0, 2000, 0, 0, 100, 0), (883750, 5, -8544.61, 1133.18, 18.1536, 0, 0, 0, 0, 100, 0), (883750, 6, -8551.97, 1118.55, 19.0523, 0, 0, 0, 0, 100, 0), diff --git a/sql/updates/world/2012_12_14_02_world_misc.sql b/sql/updates/world/2012_12_14_02_world_misc.sql index 8e51865dad0..29aa47909e1 100644 --- a/sql/updates/world/2012_12_14_02_world_misc.sql +++ b/sql/updates/world/2012_12_14_02_world_misc.sql @@ -2,7 +2,7 @@ DELETE FROM `spell_script_names` WHERE `spell_id` IN (24750, 24751, 44436); INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (24750, 'spell_trick'), (24751, 'spell_trick_or_treat'), -(44436, 'spell_gen_tricky_treat'); +(44436, 'spell_tricky_treat'); DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (42965,42966); INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES diff --git a/sql/updates/world/2012_12_14_04_world_misc.sql b/sql/updates/world/2012_12_14_04_world_misc.sql new file mode 100644 index 00000000000..2cd99cfb12a --- /dev/null +++ b/sql/updates/world/2012_12_14_04_world_misc.sql @@ -0,0 +1,7 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=44436; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(44436, 'spell_tricky_treat'); + +DELETE FROM `waypoint_data` WHERE `id`=883750 AND `point`=3; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_flag`, `action`, `action_chance`, `wpguid`) VALUES +(883750, 3, -8538.3, 1149.52, 19.0522, 0, 15000, 0, 1029, 100, 0); |