[CREATURE] Setis - correction and pathing #8602

Closed
baric opened this Issue Dec 8, 2012 · 0 comments

Comments

Projects
None yet
2 participants
@baric

baric commented Dec 8, 2012

--
-- Before Cataclysm, this rare elite was a Fel Reaver type mob in Silithus
-- but the 3.3.5 TDB has this mob inexplicably nerfed to his post-Cataclysm size and damage
--
-- This fixes his pre-Cat size, damage and restores his zone pathing

--====================================
-- Setis correction and path
--====================================
UPDATE `creature_template` SET `scale`=3, `mindmg`=700, `maxdmg`=900 WHERE `entry`=14471;
UPDATE `creature` SET `MovementType`=2, `position_x`=-7970.898438, `position_y`=1507.219971, `position_z`=-1.551867 WHERE `guid`=51838;
DELETE FROM `creature_addon` WHERE `guid`=51838;
INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES (51838, 518380);

DELETE FROM `waypoint_data` WHERE `id`=518380;
INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_flag`, `action`, `action_chance`, `wpguid`) VALUES 
(518380, 1, -7970.898438, 1507.219971, -1.551867, 0, 0, 0, 0, 100, 0),
(518380, 2, -7943.037598, 1493.791138, -6.626160, 0, 0, 0, 0, 100, 0),
(518380, 3, -7918.484375, 1468.855347, -5.768747, 0, 0, 0, 0, 100, 0),
(518380, 4, -7894.920898, 1446.878418, -9.586535, 0, 0, 0, 0, 100, 0),
(518380, 5, -7887.063965, 1414.645752, -4.758429, 0, 0, 0, 0, 100, 0),
(518380, 6, -7879.735840, 1375.461914, -8.273664, 0, 0, 0, 0, 100, 0),
(518380, 7, -7863.913574, 1348.840820, -6.652806, 0, 0, 0, 0, 100, 0),
(518380, 8, -7839.481934, 1331.171509, -9.644982, 0, 0, 0, 0, 100, 0),
(518380, 9, -7799.420410, 1305.002441, -5.837549, 0, 0, 0, 0, 100, 0),
(518380, 10, -7775.251953, 1267.372559, -4.494194, 0, 0, 0, 0, 100, 0),
(518380, 11, -7796.921387, 1231.137085, -4.357635, 0, 0, 0, 0, 100, 0),
(518380, 12, -7814.783203, 1204.887451, -0.534356, 0, 0, 0, 0, 100, 0),
(518380, 13, -7823.562500, 1158.288696, 1.645526, 0, 0, 0, 0, 100, 0),
(518380, 14, -7818.532227, 1123.668945, 0.376355, 0, 0, 0, 0, 100, 0),
(518380, 15, -7803.921387, 1086.932251, 4.711929, 0, 0, 0, 0, 100, 0),
(518380, 16, -7769.979980, 1061.283813, 1.140280, 0, 0, 0, 0, 100, 0),
(518380, 17, -7748.981934, 1029.688477, 2.546784, 0, 0, 0, 0, 100, 0),
(518380, 18, -7725.582031, 994.818115, 1.862588, 0, 0, 0, 0, 100, 0),
(518380, 19, -7700.375977, 961.477478, -1.844931, 0, 0, 0, 0, 100, 0),
(518380, 20, -7660.693848, 939.870605, 0.607142, 0, 0, 0, 0, 100, 0),
(518380, 21, -7628.968262, 925.089294, 0.414325, 0, 0, 0, 0, 100, 0),
(518380, 22, -7594.459473, 932.484253, 1.851091, 0, 0, 0, 0, 100, 0),
(518380, 23, -7550.452148, 954.033569, 0.911450, 0, 0, 0, 0, 100, 0),
(518380, 24, -7519.019531, 969.427917, 1.444063, 0, 0, 0, 0, 100, 0),
(518380, 25, -7476.106934, 979.391663, 2.042855, 0, 0, 0, 0, 100, 0),
(518380, 26, -7428.556641, 978.902710, 3.131437, 0, 0, 0, 0, 100, 0),
(518380, 27, -7390.671875, 1013.550964, 3.490367, 0, 0, 0, 0, 100, 0),
(518380, 28, -7373.875977, 1046.144897, 4.743690, 0, 0, 0, 0, 100, 0),
(518380, 29, -7364.927734, 1093.089844, 1.329022, 0, 0, 0, 0, 100, 0),
(518380, 30, -7347.156250, 1145.419922, 1.288395, 0, 0, 0, 0, 100, 0),
(518380, 31, -7364.325195, 1159.787231, 3.236028, 0, 0, 0, 0, 100, 0),
(518380, 32, -7399.254395, 1182.984497, 1.843866, 0, 0, 0, 0, 100, 0),
(518380, 33, -7429.508301, 1202.897827, 3.029610, 0, 0, 0, 0, 100, 0),
(518380, 34, -7468.980469, 1233.918945, 3.407038, 0, 0, 0, 0, 100, 0),
(518380, 35, -7511.831543, 1250.466309, 3.333737, 0, 0, 0, 0, 100, 0),
(518380, 36, -7540.864258, 1269.111328, 6.091939, 0, 0, 0, 0, 100, 0),
(518380, 37, -7555.662109, 1299.827026, 2.850513, 0, 0, 0, 0, 100, 0),
(518380, 38, -7569.881348, 1333.556763, 3.011905, 0, 0, 0, 0, 100, 0),
(518380, 39, -7598.235352, 1373.451294, 4.004597, 0, 0, 0, 0, 100, 0),
(518380, 40, -7626.755371, 1409.476685, 3.858852, 0, 0, 0, 0, 100, 0),
(518380, 41, -7655.338867, 1460.769531, 3.685694, 0, 0, 0, 0, 100, 0),
(518380, 42, -7697.577637, 1485.361694, 4.425735, 0, 0, 0, 0, 100, 0),
(518380, 43, -7728.651855, 1513.852295, -0.668692, 0, 0, 0, 0, 100, 0),
(518380, 44, -7740.848633, 1555.398560, 1.300065, 0, 0, 0, 0, 100, 0),
(518380, 45, -7763.296875, 1582.227173, -0.216693, 0, 0, 0, 0, 100, 0),
(518380, 46, -7787.744629, 1593.927979, 2.871248, 0, 0, 0, 0, 100, 0),
(518380, 47, -7832.063965, 1601.147339, 4.115499, 0, 0, 0, 0, 100, 0),
(518380, 48, -7870.669434, 1592.223389, 2.563943, 0, 0, 0, 0, 100, 0),
(518380, 49, -7908.875977, 1561.901733, -2.734423, 0, 0, 0, 0, 100, 0),
(518380, 50, -7932.152832, 1528.089844, -0.895027, 0, 0, 0, 0, 100, 0),
(518380, 51, -7946.883301, 1508.120239, -6.629673, 0, 0, 0, 0, 100, 0);

@ghost ghost assigned ZxBiohazardZx Dec 8, 2012

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