Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Already on GitHub? Sign in to your account

[CREATURE] Razormane Wolves - add and bind to Razormane Hunters #8514

Closed
baric opened this Issue Nov 30, 2012 · 5 comments

Comments

Projects
None yet
3 participants

baric commented Nov 30, 2012

-- Razormane Hunters in the Barrens (9 guids) are all missing the Wolves that path with them
-- create a Razormane Wolf pet (#3939) for each of the 9 Razormane Hunters (#3265)
SET @GUID := xxx; -- set by tdb team

--insert 9 razormane wolves into new guids (@GUID to @GUID+8) with invalid xyz coords (we don't know them yet)
DELETE FROM `creature` WHERE `guid` >= @GUID AND `guid` <= @GUID+8;
INSERT INTO `creature` (`guid`, `id`, `map`, `position_x`, `position_y`,  `position_z`, `spawntimesecs`, `curhealth`, `MovementType`) VALUES 
(@GUID , 3939, 1, 0.0, 0.0, 0.0, 90, 120, 1),
(@GUID+1, 3939, 1, 0.0, 0.0, 0.0, 90, 120, 1),
(@GUID+2, 3939, 1, 0.0, 0.0, 0.0, 90, 120, 1),
(@GUID+3, 3939, 1, 0.0, 0.0, 0.0, 90, 120, 1),
(@GUID+4, 3939, 1, 0.0, 0.0, 0.0, 90, 120, 1),
(@GUID+5, 3939, 1, 0.0, 0.0, 0.0, 90, 120, 1),
(@GUID+6, 3939, 1, 0.0, 0.0, 0.0, 90, 120, 1),
(@GUID+7, 3939, 1, 0.0, 0.0, 0.0, 90, 120, 1),
(@GUID+8, 3939, 1, 0.0, 0.0, 0.0, 90, 120, 1);
-- bind the wolves to the 9 razormane hunters (id 3265)
DELETE FROM `creature_formations` WHERE `leaderGUID` >= 20301 and `leaderGUID` <= 20309;
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES 
(20301, 20301, 0, 0, 2),
(20301, @GUID, 4, 60, 2),
(20302, 20302, 0, 0, 2),
(20302, @GUID+1, 4, 60, 2),
(20303, 20303, 0, 0, 2),
(20303, @GUID+2, 4, 60, 2),
(20304, 20304, 0, 0, 2),
(20304, @GUID+3, 4, 60, 2),
(20305, 20305, 0, 0, 2),
(20305, @GUID+4, 4, 60, 2),
(20306, 20306, 0, 0, 2),
(20306, @GUID+5, 4, 60, 2),
(20307, 20307, 0, 0, 2),
(20307, @GUID+6, 4, 60, 2),
(20308, 20308, 0, 0, 2),
(20308, @GUID+7, 4, 60, 2),
(20309, 20309, 0, 0, 2),
(20309, @GUID+8, 4, 60, 2);
-- now set the wolf pets to the same xyz as their leader
UPDATE `creature` c1, `creature` c2, `creature_formations` cf 
SET c1.`position_x` = c2.`position_x`, c1.`position_y` = c2.`position_y`, c1.`position_z` = c2.`position_z` 
WHERE c1.`guid` = cf.`memberGUID` AND c2.`guid` = cf.`leaderGUID` 
AND c1. `guid` >= @GUID AND c1.`guid` <= @GUID+8;

@ghost ghost assigned ZxBiohazardZx Nov 30, 2012

Owner

Aokromes commented Nov 30, 2012

Guids are assigned by tdb team.

baric commented Nov 30, 2012

ok, wasn't sure how that was done. You just need 9

Owner

Aokromes commented Dec 2, 2012

btw:

(43486, 3939, 1, 0.0, 0.0, 0.0, 90, 120, 1),
(43487, 3939, 1, 0.0, 0.0, 0.0, 90, 120, 1),

0 , 0 , 0?

baric commented Dec 2, 2012

I use decimal points out of programming habit for float fields. Integers will work fine. They're just going to get reset anyway in the final sql statement.

Contributor

ZxBiohazardZx commented Dec 3, 2012

redo them with @Guid pointers, so we can set the parameters and specify how many are required with a comment

SET @GUID := xxx; -- set by tdb team

INSERT INTO (blablabla) VALUES

(@GUID  ,0,0,0,0), -- Example 1
(@GUID+1,0,0,0,0), -- Example 2

krofna added a commit to krofna/TrinityCore that referenced this issue Dec 18, 2012

DB/Creature: Add pathings and formations for various creatures:
Add formation for Razormane Wolves and Hunters Closes #8514
Add missing Raptor Egg nests Closes #8594
Add pathing for Twilight Prophet Closes #8601
Add pathing for Setis Closes #8602
Add pathing for Lapress Closes #8604
Add pathing for Ghost Howl Closes #8605
Add formation and pathing for Magram Pack Runners & Bonepaws Closes #8606
Add formation for Caliph Scorpidsting Closes #8608

raczman pushed a commit to raczman/TrinityCore that referenced this issue Apr 20, 2014

DB/Creature: Add pathings and formations for various creatures:
Add formation for Razormane Wolves and Hunters Closes #8514
Add missing Raptor Egg nests Closes #8594
Add pathing for Twilight Prophet Closes #8601
Add pathing for Setis Closes #8602
Add pathing for Lapress Closes #8604
Add pathing for Ghost Howl Closes #8605
Add formation and pathing for Magram Pack Runners & Bonepaws Closes #8606
Add formation for Caliph Scorpidsting Closes #8608
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment