aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2015-02-20 18:23:19 +0100
committerAokromes <Aokromes@users.noreply.github.com>2015-02-20 18:23:19 +0100
commit6445761827518192d21e3e39521358df5754a617 (patch)
tree070cb5dbfd25d833d21ccf8001a1f62340e86ee3
parentc5a29004f3662e85157c8641cff663629d6d3d6c (diff)
DB/Creature: Hyldsmeet Warbear
By Killyana, closes #12043
-rw-r--r--sql/updates/world/2015_02_20_04_world.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/2015_02_20_04_world.sql b/sql/updates/world/2015_02_20_04_world.sql
new file mode 100644
index 00000000000..1560b983859
--- /dev/null
+++ b/sql/updates/world/2015_02_20_04_world.sql
@@ -0,0 +1,10 @@
+--
+DELETE FROM `creature` WHERE `id` = 29498;
+DELETE FROM `vehicle_template_accessory` WHERE `entry` IN (29500) AND `accessory_entry` IN (29498);
+INSERT INTO `vehicle_template_accessory` (`entry`,`accessory_entry`,`seat_id`,`minion`,`description`,`summontype`,`summontimer`)VALUES
+(29500,29498,0,1,'Brunnhildar Warbear',8,0);
+
+DELETE FROM `creature` WHERE `id` = 30175;
+DELETE FROM `vehicle_template_accessory` WHERE `entry` IN (30174) AND `accessory_entry` IN (30175);
+INSERT INTO `vehicle_template_accessory` (`entry`,`accessory_entry`,`seat_id`,`minion`,`description`,`summontype`,`summontimer`)VALUES
+(30174,30175,0,1,'Hyldsmeet Warbear',8,0);