aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorMachiavelli <machiavelli.trinity@gmail.com>2011-03-04 21:16:27 +0100
committerMachiavelli <machiavelli.trinity@gmail.com>2011-03-04 21:17:06 +0100
commita9582964d3ca140a1ec1d5894b79e72ed15a65a6 (patch)
treeffcae65f1b7a7875a144bf7890979e50d9b4b1a6 /sql
parentc2a2d7201b42bf51ab6a8eea104435fc71a0b617 (diff)
Core/Vehicles: Make the vehicle system more aura driven. Get rid of redundant checks and update relevant data.
Closes #805
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2011_03_04_world_npc_spellclick_spells.sql3
-rw-r--r--sql/updates/world/2011_03_04_world_vehicle_accessory.sql1
2 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/2011_03_04_world_npc_spellclick_spells.sql b/sql/updates/world/2011_03_04_world_npc_spellclick_spells.sql
new file mode 100644
index 00000000000..f4a5825225c
--- /dev/null
+++ b/sql/updates/world/2011_03_04_world_npc_spellclick_spells.sql
@@ -0,0 +1,3 @@
+DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=32930;
+INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`quest_start`,`quest_start_active`,`quest_end`,`cast_flags`,`aura_required`,`aura_forbidden`,`user_type`) VALUES
+(32930,65343,0,0,0,0,0,0,0); -- Ride Vehicle Kologarn Arms
diff --git a/sql/updates/world/2011_03_04_world_vehicle_accessory.sql b/sql/updates/world/2011_03_04_world_vehicle_accessory.sql
new file mode 100644
index 00000000000..53cb37d43f1
--- /dev/null
+++ b/sql/updates/world/2011_03_04_world_vehicle_accessory.sql
@@ -0,0 +1 @@
+UPDATE `vehicle_accessory` SET `minion`=1 WHERE `entry` IN(32640,32633);