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] Lapress - pathing #8604

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

Comments

Projects
None yet
2 participants

baric commented Dec 8, 2012

-- Lapress is a rare elite in Silithus that paths around Hive'Regal
-- TBD has two spawns for this type (error) and no path for either

--====================================
-- Path for Lapress (guid #43120)
--====================================
-- remove duplicate guid #51782
DELETE FROM `creature` WHERE `guid`=51782;
DELETE FROM `creature_addon` WHERE `guid`=51782;

-- set pathing for guid #43120
UPDATE `creature` SET `MovementType`=2, `position_x`=-7803.758789, `position_y`=515.706482, `position_z`=-38.351662 WHERE `guid`=43120;
UPDATE `creature_addon` SET `path_id` = 431200 WHERE `guid` = 43120;

DELETE FROM `waypoint_data` WHERE `id`=431200;
INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_flag`, `action`, `action_chance`, `wpguid`) VALUES 
(431200, 1, -7803.758789, 515.706482, -38.351662, 0, 0, 0, 0, 100, 0),
(431200, 2, -7836.155762, 493.625061, -35.266079, 0, 0, 0, 0, 100, 0),
(431200, 3, -7853.409180, 473.479858, -33.659664, 0, 0, 0, 0, 100, 0),
(431200, 4, -7883.189941, 436.889862, -32.837315, 0, 0, 0, 0, 100, 0),
(431200, 5, -7902.391113, 426.345123, -32.146542, 0, 0, 0, 0, 100, 0),
(431200, 6, -7935.672852, 417.698547, -30.542465, 0, 0, 0, 0, 100, 0),
(431200, 7, -7962.825684, 424.285736, -31.605789, 0, 0, 0, 0, 100, 0),
(431200, 8, -7985.026367, 438.749878, -30.173546, 0, 0, 0, 0, 100, 0),
(431200, 9, -7990.209961, 447.782166, -30.206039, 0, 0, 0, 0, 100, 0),
(431200, 10, -7990.671387, 458.651367, -30.272879, 0, 0, 0, 0, 100, 0),
(431200, 11, -7981.745117, 472.982819, -28.886236, 0, 0, 0, 0, 100, 0),
(431200, 12, -7978.358398, 486.361145, -27.435070, 0, 0, 0, 0, 100, 0),
(431200, 13, -7976.823730, 500.482758, -29.771008, 0, 0, 0, 0, 100, 0),
(431200, 14, -7969.692383, 514.711243, -29.564129, 0, 0, 0, 0, 100, 0),
(431200, 15, -7956.184570, 519.753662, -29.493561, 0, 0, 0, 0, 100, 0),
(431200, 16, -7947.121094, 518.579346, -28.268650, 0, 0, 0, 0, 100, 0),
(431200, 17, -7926.888184, 512.964294, -30.582899, 0, 0, 0, 0, 100, 0),
(431200, 18, -7906.528809, 511.238007, -31.442280, 0, 0, 0, 0, 100, 0),
(431200, 19, -7885.870117, 513.818298, -32.604053, 0, 0, 0, 0, 100, 0),
(431200, 20, -7865.162598, 522.834473, -35.134956, 0, 0, 0, 0, 100, 0),
(431200, 21, -7835.427246, 536.469238, -35.256481, 0, 0, 0, 0, 100, 0),
(431200, 22, -7811.894531, 531.935547, -37.693974, 0, 0, 0, 0, 100, 0),
(431200, 23, -7787.803223, 517.669800, -39.175011, 0, 0, 0, 0, 100, 0),
(431200, 24, -7758.233887, 498.946594, -43.895679, 0, 0, 0, 0, 100, 0),
(431200, 25, -7740.895020, 487.130463, -44.247120, 0, 0, 0, 0, 100, 0),
(431200, 26, -7724.676270, 473.797882, -43.348301, 0, 0, 0, 0, 100, 0),
(431200, 27, -7711.100098, 466.066101, -42.162849, 0, 0, 0, 0, 100, 0),
(431200, 28, -7693.685547, 462.775269, -41.935429, 0, 0, 0, 0, 100, 0),
(431200, 29, -7679.479980, 465.434692, -42.725754, 0, 0, 0, 0, 100, 0),
(431200, 30, -7671.343750, 477.136871, -43.937260, 0, 0, 0, 0, 100, 0),
(431200, 31, -7670.163086, 492.271149, -43.557579, 0, 0, 0, 0, 100, 0),
(431200, 32, -7676.005371, 503.306671, -42.504585, 0, 0, 0, 0, 100, 0),
(431200, 33, -7687.912598, 517.063599, -42.958843, 0, 0, 0, 0, 100, 0),
(431200, 34, -7706.184570, 525.815552, -43.932297, 0, 0, 0, 0, 100, 0),
(431200, 35, -7718.318848, 525.054443, -43.541885, 0, 0, 0, 0, 100, 0),
(431200, 36, -7751.656738, 514.520874, -43.412769, 0, 0, 0, 0, 100, 0),
(431200, 37, -7778.547363, 507.991516, -41.380962, 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