aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorNay <dnpd.dd@gmail.com>2013-07-19 03:25:52 +0100
committerNay <dnpd.dd@gmail.com>2013-07-19 03:25:52 +0100
commitebd9090d80df3494fe2b023110d402c5bb7a1460 (patch)
tree124bfb93cb7e5b73546a633c5c781da8da96a800 /sql
parent0691a4310f865fe9fdd317f64b5e856a9b6f8ea9 (diff)
DB/NPCs: Fix Margrave Dhakar equipment
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2013_07_18_02_world_the_flesh_giant_slayer.sql2
-rw-r--r--sql/updates/world/2013_07_18_03_world_equipment.sql4
2 files changed, 5 insertions, 1 deletions
diff --git a/sql/updates/world/2013_07_18_02_world_the_flesh_giant_slayer.sql b/sql/updates/world/2013_07_18_02_world_the_flesh_giant_slayer.sql
index e79a54598e7..c8d7773c461 100644
--- a/sql/updates/world/2013_07_18_02_world_the_flesh_giant_slayer.sql
+++ b/sql/updates/world/2013_07_18_02_world_the_flesh_giant_slayer.sql
@@ -15,7 +15,7 @@ UPDATE `creature_template` SET `ScriptName`='npc_morbidus' WHERE `entry`=30698;
-- Template updates
UPDATE `creature_template` SET `faction_A`=2102, `faction_H`=2102, `exp`=2, `minlevel`=80, `maxlevel`=80, `unit_flags`=`unit_flags`|832, `speed_run`=0.99206, `VehicleId`=271 WHERE `entry`=30698; -- Morbidus
-UPDATE `creature_template` SET `faction_A`=1770, `faction_H`=1770, `npcflag`=`npcflag`|1, `equipment_id`=30954, `gossip_menu_id`=10060 WHERE `entry`=31306; -- Margrave Dhakar
+UPDATE `creature_template` SET `faction_A`=1770, `faction_H`=1770, `npcflag`=`npcflag`|1, `gossip_menu_id`=10060 WHERE `entry`=31306; -- Margrave Dhakar
UPDATE `creature_model_info` SET `bounding_radius`=0.465,`combat_reach`=7.5,`gender`=0 WHERE `modelid`=31176; -- Morbidus
UPDATE `creature_model_info` SET `bounding_radius`=0.3825,`combat_reach`=1.875,`gender`=0 WHERE `modelid`=27558; -- Margrave Dhakar
diff --git a/sql/updates/world/2013_07_18_03_world_equipment.sql b/sql/updates/world/2013_07_18_03_world_equipment.sql
new file mode 100644
index 00000000000..4097327637b
--- /dev/null
+++ b/sql/updates/world/2013_07_18_03_world_equipment.sql
@@ -0,0 +1,4 @@
+-- equipment for Margrave Dhakar
+DELETE FROM `creature_equip_template` WHERE `entry` = 31306;
+INSERT INTO `creature_equip_template` (`entry`, `id`, `itemEntry1`, `itemEntry2`, `itemEntry3`) VALUES
+(31306, 1, 41371, 0, 0);