aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorteacher <none@none>2010-02-04 16:12:52 +0100
committerteacher <none@none>2010-02-04 16:12:52 +0100
commit61cc641384fc863b4b781866d8a687f0b4b7fcb1 (patch)
treeeaace6f02d78e0bfb1cb7cfb3254aa3b12359942 /sql/updates
parentad63efde8d35d0fd56ce84ca1decf154bd2787ce (diff)
Added Spell "Launch Spear" to creature "Ymirheim Spear Gun" (by Malcrom).
Added missing spell updates for Rev 7285 (by manuel). Renamed a wrongly named file. Added two recent scriptname updates to world_scripts_full.sql. --HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/7285_world_script_waypoint.sql1
-rw-r--r--sql/updates/7285_world_scriptname.sql1
-rw-r--r--sql/updates/7293_world_scriptname.sql (renamed from sql/updates/7293_world_creature_template.sql)0
-rw-r--r--sql/updates/7296_world_creature_template.sql4
4 files changed, 4 insertions, 2 deletions
diff --git a/sql/updates/7285_world_script_waypoint.sql b/sql/updates/7285_world_script_waypoint.sql
index fe11d7dbe49..ca4b4e35e3d 100644
--- a/sql/updates/7285_world_script_waypoint.sql
+++ b/sql/updates/7285_world_script_waypoint.sql
@@ -10,4 +10,3 @@ INSERT INTO `script_waypoint` VALUES
(35491,8,761.823,625.299,418.482,0,''),
(35491,9,755.923,631.506,413.966,0,''),
(35491,10,744.841,634.505,411.575,0,'');
-
diff --git a/sql/updates/7285_world_scriptname.sql b/sql/updates/7285_world_scriptname.sql
index 7265c6e0405..3f57f64afc8 100644
--- a/sql/updates/7285_world_scriptname.sql
+++ b/sql/updates/7285_world_scriptname.sql
@@ -9,4 +9,3 @@ UPDATE `instance_template` SET `script`='instance_trial_of_the_champion' WHERE `
UPDATE `creature_template` SET `ScriptName`='npc_argent_soldier' WHERE `entry` IN (35309,35305,35307);
UPDATE `creature_template` SET `ScriptName`='npc_black_knight_skeletal_gryphon' WHERE `entry`=35491;
UPDATE `creature_template` SET `AIName`='PassiveAI' WHERE `entry` IN (35332,35330,35328,35327,35331,35329,35325,35314,35326,35323);
-
diff --git a/sql/updates/7293_world_creature_template.sql b/sql/updates/7293_world_scriptname.sql
index b978069d230..b978069d230 100644
--- a/sql/updates/7293_world_creature_template.sql
+++ b/sql/updates/7293_world_scriptname.sql
diff --git a/sql/updates/7296_world_creature_template.sql b/sql/updates/7296_world_creature_template.sql
new file mode 100644
index 00000000000..82a9121e542
--- /dev/null
+++ b/sql/updates/7296_world_creature_template.sql
@@ -0,0 +1,4 @@
+-- Add Spell "Launch Spear" to creature "Ymirheim Spear Gun"
+UPDATE `creature_template` SET `spell1`=59894 WHERE `entry`=31280;
+-- Add necessary spells for vehicles (for rev 7285).
+UPDATE `creature_template` SET `spell1`=68505,`spell2`=62575,`spell3`=68282,`spell4`=66482 WHERE `entry` IN (36558,35644);