[GO/FIX] Razormaw Matriarch's Nest (202083) #7424

Closed
nelegalno opened this Issue Aug 17, 2012 · 9 comments

6 participants

@nelegalno
Contributor
-- Razormaw Matriarch's Nest (202083) GO spawn
-- The sources for the GO locations are the videos quoted below 

SET @GUID := xxxx; -- Set by TDB team (3)
SET @POOL := xxxx; -- Set by TDB team (1)

DELETE FROM `gameobject` WHERE `id`=202083;
INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES
-- https://github.com/TrinityCore/TrinityCore/commit/205cb06df9c3535e186b2e7fae10c72ab5de9e3c
(14999,202083,0,1,1,-2944.48,-3277.68,62.27,3.32798,0,0,0.995661,-0.093059,18000,100,1),
-- https://www.youtube.com/watch?v=c1Dz_-ycIuU#t=124s
(@GUID+0,202083,0,1,1,-3000.93,-3329.01,64.9771,4.10851,0,0,0.885393,-0.464843,18000,100,1),
-- https://www.youtube.com/watch?v=yWSvwdNHspY#t=30s , https://www.youtube.com/watch?v=c1Dz_-ycIuU#t=95s
(@GUID+1,202083,0,1,1,-3020.76,-3245.81,58.8009,5.38478,0,0,0.434249,-0.900793,18000,100,1),
-- https://www.youtube.com/watch?v=f0rCteF0Ras#t=200s , https://www.youtube.com/watch?v=yWSvwdNHspY#t=30s
(@GUID+2,202083,0,1,1,-2992.36,-3188.19,55.1982,3.01524,0,0,0.998005,0.0631367,18000,100,1);

DELETE FROM `pool_template` WHERE `entry`=@POOL;
INSERT INTO `pool_template` (`entry`,`max_limit`,`description`) VALUES
(@POOL,1,"Razormaw Matriarch's Nest (202083)");

DELETE FROM `pool_gameobject` WHERE `guid` IN (@GUID+0,@GUID+1,@GUID+2,@GUID+3);
INSERT INTO `pool_gameobject` (`guid`,`pool_entry`,`chance`,`description`) VALUES
(14999,@POOL,25,"Razormaw Matriarch's Nest (202083) P1"),
(@GUID+0,@POOL,25,"Razormaw Matriarch's Nest (202083) P2"),
(@GUID+1,@POOL,25,"Razormaw Matriarch's Nest (202083) P3"),
(@GUID+2,@POOL,25,"Razormaw Matriarch's Nest (202083) P4");

Tested on TDB49 up to 2dc72ec
Updated code to reflect data from 205cb06

@nelegalno
Contributor

Guesswork based on the videos, the links are in the fix.

@nelegalno
Contributor

Related to #8594 and 205cb06

@ZxBiohazardZx
Contributor

the commit you link to has 4 spawnlocations, a pool template and guids in that, whats the need of this fix after that?

@nelegalno
Contributor

The Razormaw Matriarch's Nest (202083) should have 4 spawn locations and a pool, in the linked commit only the first spawn point is added and no pool is associated with it. Since my fix was older I updated it based on the info from the commit.

@DDuarte DDuarte was assigned Aug 9, 2013
@Aokromes
Member

The only spawn i can found on sniffs.

(@OGUID+116, 202083, 0, 1, 1, '', -2951.57, -3285.63, 62.3761, 0, 0, 0, 0, 1, 120, 255, 1), -- 202083 (Area: 1017)

@nelegalno
Contributor

As you can see in http://www.wowhead.com/object=202083#comments:id=1205979 since patch 3.3 and before patch 4.0.3 there ware 4 spawn locations with five to eight hour spawn timer, as of patch 4.0.3 it was changed to a single location with about 1h timer.

@DDuarte DDuarte was unassigned by Aokromes Oct 22, 2014
@Rushor
Contributor
Rushor commented Feb 14, 2015

updated, but there must be separted pushes to 3.x and 4.x/6.x

-- ONLY UPDATE FOR WOTLK 3.X - no cherrypick to 4.x, 5.x, 6.x
SET @GUID := xxx; -- Set by TDB team (4)
SET @POOL := xxx; -- Set by TDB team (1)


DELETE FROM `gameobject` WHERE `id`=202083;
INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES
-- https://github.com/TrinityCore/TrinityCore/commit/205cb06df9c3535e186b2e7fae10c72ab5de9e3c
(@GUID+0,202083,0,1,1,-2944.48,-3277.68,62.27,3.32798,0,0,0.995661,-0.093059,18000,100,1),
-- https://www.youtube.com/watch?v=c1Dz_-ycIuU#t=124s
(@GUID+1,202083,0,1,1,-3000.93,-3329.01,64.9771,4.10851,0,0,0.885393,-0.464843,18000,100,1),
-- https://www.youtube.com/watch?v=yWSvwdNHspY#t=30s , https://www.youtube.com/watch?v=c1Dz_-ycIuU#t=95s
(@GUID+2,202083,0,1,1,-3020.76,-3245.81,58.8009,5.38478,0,0,0.434249,-0.900793,18000,100,1),
-- https://www.youtube.com/watch?v=f0rCteF0Ras#t=200s , https://www.youtube.com/watch?v=yWSvwdNHspY#t=30s
(@GUID+3,202083,0,1,1,-2992.36,-3188.19,55.1982,3.01524,0,0,0.998005,0.0631367,18000,100,1);

DELETE FROM `pool_template` WHERE `entry`=@POOL;
INSERT INTO `pool_template` (`entry`,`max_limit`,`description`) VALUES
(@POOL,1,"Razormaw Matriarch's Nest (202083)");

DELETE FROM `pool_gameobject` WHERE `guid` IN (14999, @GUID+0, @GUID+1, @GUID+2, @GUID+3);
INSERT INTO `pool_gameobject` (`guid`,`pool_entry`,`chance`,`description`) VALUES
(14999,@POOL,25,"Razormaw Matriarch's Nest (202083) P1"),
(@GUID+0,@POOL,25,"Razormaw Matriarch's Nest (202083) P2"),
(@GUID+1,@POOL,25,"Razormaw Matriarch's Nest (202083) P3"),
(@GUID+2,@POOL,25,"Razormaw Matriarch's Nest (202083) P4");
@Rushor
Contributor
Rushor commented Feb 14, 2015
-- ONLY UPDATE FOR CATA 4.x and further expansions like 5.x, 6.x

SET @GUID := xxxxxx; -- Set by TDB team (3)
DELETE FROM `gameobject` WHERE `id`=202083;
INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES
(@GUID, 202083, 0, 1, 1, -2951.57, -3285.63, 62.3761, 0, 0, 0, 0, 1, 3600, 255, 1);  -- 202083 (Area: 1017)
@Rushor Rushor was assigned by Killyana May 1, 2015
@Rushor Rushor added a commit that referenced this issue May 11, 2015
@Rushor Rushor DB/Gameobject: Razormaw Matriarch's Nest
* closes #7424
* thanks 2 @nelegalno 4 report + provided datas
715e834
@Rushor
Contributor
Rushor commented May 11, 2015
@Rushor Rushor closed this May 11, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment