diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2017-03-27 04:44:49 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-03-27 04:44:49 +0200 |
| commit | af265280c4881b2bd67f2ede8e1189b10cf9dc45 (patch) | |
| tree | e49dbbcdca074c66ecb798b2dc8ef74f24eb96b2 /sql | |
| parent | da3c2e2b0bc7f4b1fede71f2c2ce1e82dad814e3 (diff) | |
DB/creature: Combatant Mount Quartermaster
Closes #19159 by ArcaneFox
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2017_03_27_01_world.sql | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_03_27_01_world.sql b/sql/updates/world/master/2017_03_27_01_world.sql new file mode 100644 index 00000000000..e1b658be657 --- /dev/null +++ b/sql/updates/world/master/2017_03_27_01_world.sql @@ -0,0 +1,19 @@ +-- Necrolord Sipe (Area: Old Town) +DELETE FROM `creature` WHERE `guid`= 452603 AND `id`= 73190; +INSERT INTO `creature` (`guid`,`id`,`map`,`zoneId`,`areaId`,`spawnMask`,`PhaseId`,`PhaseGroup`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`VerifiedBuild`) VALUES +(452399, 73190, 0, 0, 0, 1, '0', 0, 0, 0, -8758.906, 385.1371, 101.1392, 0.6503221, 120, 0, 0, 0, 0, 0, 0, 0, 0, 23420); + +DELETE FROM `creature_template_addon` WHERE `entry`= 73190; +INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`aiAnimKit`,`movementAnimKit`,`meleeAnimKit`,`auras`) VALUES +(73190, 0, 51037, 0, 0, 0, 0, 0, 0, ''); + +DELETE FROM `npc_vendor` WHERE `entry`=73190 AND `ExtendedCost`=5214 AND `type`=1 AND `item` IN (140353,140350,124089); +INSERT INTO `npc_vendor` (`entry`,`slot`,`item`,`maxcount`,`ExtendedCost`,`type`,`PlayerConditionID`,`IgnoreFiltering`,`VerifiedBuild`) VALUES +(73190, 6, 140353, 0, 5214, 1, 0, 0, 23420), -- Vicious Gilnean Warhorse +(73190, 5, 140350, 0, 5214, 1, 0, 0, 23420), -- Vicious War Elekk +(73190, 4, 124089, 0, 5214, 1, 0, 0, 23420); -- Vicious War Mechanostrider + +UPDATE `npc_vendor` SET `VerifiedBuild`=23420 WHERE `entry`=73190 AND `item` IN ( +116777, -- Vicious War Ram +102514, -- Reins of the Vicious Warsaber +70909); -- Reins of the Vicious War Steed |