No mobs on Demon Fall Ridge in Ashenvale #8614

Closed
baric opened this Issue Dec 9, 2012 · 14 comments

Comments

Projects
None yet
6 participants

baric commented Dec 9, 2012

I'm guessing that whomever did sniffs for Ashenvale missed this area. There are no mobs on it or in the adjacent barrows. This subzone may still be populated in retail wow.

From wowwiki: Demon Fall Ridge is located in Ashenvale, just west and above Demon Fall Canyon. It is home to several kinds of lesser demons, who inhabit both the exterior part of the ridge as well as the interior of an abandoned barrow den set into the side of the ridge. In the deepest parts of this den waits Diathorus the Seeker - a dreadlord and ruler of the demonic conclave in Ashenvale.

http://www.wowwiki.com/Demon_Fall_Ridge

@ghost ghost assigned Kinzcool Dec 9, 2012

baric commented Dec 9, 2012

This is a 3.3.5 problem

Owner

Aokromes commented Dec 9, 2012

For me it's populated on 3.3.5a....
.go c 20029

baric commented Dec 9, 2012

ok, I see what I did now. There are no creatures outside the barrow den (which is still an error, I think). I then ran down a bit into the barrow dens, saw nothing, then did a .lookup creature diathoras and got nothing back so I presumed the barrow den was empty as well. It is not, since diathorUs does exist (spelling error on my lookup)

However, shouldn't there be mobs outside the den as well? If no, then close it. But I could have sworn there were mobs outside of the barrow den as well

Owner

Aokromes commented Dec 9, 2012

Yeah, you are right, ouside part needs mobs.

baric commented Dec 9, 2012

I'll bet these can still be sniffed from the retail client since that area was not revamped in Cataclysm

Owner

Aokromes commented Dec 9, 2012

I sniffed it, but we can't parse it.

baric commented Dec 9, 2012

I don't know what that means, lol. Should I just go through with a F2P account and replicate the mobs manually?

baric commented Dec 10, 2012

---
from the 4.3.4 sniff..
Below is a grep for "Demon Fall Ridge". Should I write an sql for what's needed in 3.3.5 or is there some auto-generator for that?
==============
(@OGUID+0087, 1622  , 1, 1, 1, 1559.646 , -2812.193, 181.5358 , 0         , 0           , 0           , 0           , 1            , 120, 255, 1) , -- Bruiseweed (Area: Demon Fall Ridge)
(@OGUID+0110, 1623  , 1, 1, 1, 1599.648 , -3088.057, 89.47401 , 0         , 0           , 0           , 0           , 1            , 120, 255, 1) , -- Wild Steelbloom (Area: Demon Fall Ridge)
(@OGUID+0174, 1732  , 1, 1, 1, 1619.236 , -3106.807, 90.91071 , 0         , 0           , 0           , 0           , 1            , 120, 255, 1) , -- Tin Vein (Area: Demon Fall Ridge)
(@OGUID+0281, 176784, 1, 1, 1, 1550.686 , -2862.281, 181.7537 , 3.141593  , 0           , 0           , 0           , 1            , 120, 255, 1) , -- Bonfire (Area: Demon Fall Ridge)
(@OGUID+0817, 194493, 1, 1, 1, 1374.725 , -2831.769, 108.8041 , 0.5410506 , 0           , 0           , 0           , 1            , 120, 255, 1) , -- -Unknown- (Area: Demon Fall Ridge)
(@OGUID+0818, 194493, 1, 1, 1, 1404.046 , -2800.933, 123.3604 , 5.026549  , 0           , 0           , 0           , 1            , 120, 255, 1) , -- -Unknown- (Area: Demon Fall Ridge)
(@OGUID+0819, 194493, 1, 1, 1, 1417.007 , -2822.992, 118.1442 , 5.026549  , 0           , 0           , 0           , 1            , 120, 255, 1) , -- -Unknown- (Area: Demon Fall Ridge)
(@OGUID+0820, 194493, 1, 1, 1, 1421.219 , -2796.809, 153.7972 , 0.2094394 , 0           , 0           , 0           , 1            , 120, 255, 1) , -- -Unknown- (Area: Demon Fall Ridge)
(@OGUID+0821, 194493, 1, 1, 1, 1451.965 , -2794.421, 145.078  , 5.026549  , 0           , 0           , 0           , 1            , 120, 255, 1) , -- -Unknown- (Area: Demon Fall Ridge)
(@OGUID+0822, 194493, 1, 1, 1, 1499.291 , -2835.965, 111.9275 , 5.480334  , 0           , 0           , 0           , 1            , 120, 255, 1) , -- -Unknown- (Area: Demon Fall Ridge)
(@OGUID+0823, 194493, 1, 1, 1, 1527.103 , -2857.062, 182.6613 , 5.951575  , 0           , 0           , 0           , 1            , 120, 255, 1) , -- -Unknown- (Area: Demon Fall Ridge)
(@OGUID+0824, 194493, 1, 1, 1, 1528.889 , -2868.595, 124.904  , 0         , 0           , 0           , 0           , 1            , 120, 255, 1) , -- -Unknown- (Area: Demon Fall Ridge)
(@OGUID+0825, 194493, 1, 1, 1, 1551.413 , -2884.564, 133.2239 , 3.194002  , 0           , 0           , 0           , 1            , 120, 255, 1) , -- -Unknown- (Area: Demon Fall Ridge)
(@OGUID+0828, 194493, 1, 1, 1, 1603.379 , -2986.516, 182.1524 , 6.161013  , 0           , 0           , 0           , 1            , 120, 255, 1) , -- -Unknown- (Area: Demon Fall Ridge)
(@OGUID+0830, 194493, 1, 1, 1, 1611.031 , -3083.823, 89.96418 , 6.213374  , 0           , 0           , 0           , 1            , 120, 255, 1) , -- -Unknown- (Area: Demon Fall Ridge)
(@OGUID+0837, 194493, 1, 1, 1, 1658.446 , -3083.14 , 89.46181 , 5.567601  , 0           , 0           , 0           , 1            , 120, 255, 1) , -- -Unknown- (Area: Demon Fall Ridge)
(@OGUID+1275, 21004 , 1, 1, 1, 1632.571 , -3075.198, 85.95863 , 5.480336  , 0           , 0           , 0           , 1            , 120, 255, 1) , -- Monument to Grom Hellscream (Area: Demon Fall Ridge)
(@CGUID+0108, 11697, 1, 1, 1, 1377.036 , -2832.29    , 108.1152   , 5.778122   , 120, 0, 0), -- Mannoroc Lasher (Area: Demon Fall Ridge) (possible waypoints or random movement)
(@CGUID+0109, 11697, 1, 1, 1, 1416.111 , -2819.088   , 117.2318   , 0.7778586  , 120, 0, 0), -- Mannoroc Lasher (Area: Demon Fall Ridge) (possible waypoints or random movement)
(@CGUID+0110, 11697, 1, 1, 1, 1427.88  , -2804.32    , 121.8488   , 0.8998177  , 120, 0, 0), -- Mannoroc Lasher (Area: Demon Fall Ridge) (possible waypoints or random movement)
(@CGUID+0111, 11697, 1, 1, 1, 1442.541 , -2817.363   , 120.4686   , 1.898855   , 120, 0, 0), -- Mannoroc Lasher (Area: Demon Fall Ridge) (possible waypoints or random movement)
(@CGUID+0112, 11697, 1, 1, 1, 1442.845 , -2781.555   , 143.3298   , 3.407407   , 120, 0, 0), -- Mannoroc Lasher (Area: Demon Fall Ridge) (possible waypoints or random movement)
(@CGUID+0113, 11697, 1, 1, 1, 1520.548 , -2910.79    , 128.7899   , 0.3708913  , 120, 0, 0), -- Mannoroc Lasher (Area: Demon Fall Ridge) (possible waypoints or random movement)
(@CGUID+0114, 11697, 1, 1, 1, 1522.825 , -2851.57    , 182.1475   , 5.156503   , 120, 0, 0), -- Mannoroc Lasher (Area: Demon Fall Ridge) (possible waypoints or random movement)
(@CGUID+0115, 11697, 1, 1, 1, 1538.938 , -2878.932   , 183.4645   , 1.239184   , 120, 0, 0), -- Mannoroc Lasher (Area: Demon Fall Ridge)
(@CGUID+0116, 11697, 1, 1, 1, 1544.031 , -2848.745   , 182.5147   , 5.044002   , 120, 0, 0), -- Mannoroc Lasher (Area: Demon Fall Ridge)
(@CGUID+0117, 11697, 1, 1, 1, 1544.416 , -2863.002   , 112.0556   , 2.701836   , 120, 0, 0), -- Mannoroc Lasher (Area: Demon Fall Ridge) (possible waypoints or random movement)
(@CGUID+0118, 11697, 1, 1, 1, 1563.016 , -2859.155   , 182.2932   , 4.066617   , 120, 0, 0), -- Mannoroc Lasher (Area: Demon Fall Ridge)
(@CGUID+0119, 11697, 1, 1, 1, 1581.573 , -2897.424   , 182.3294   , 1.43117    , 120, 0, 0), -- Mannoroc Lasher (Area: Demon Fall Ridge)
(@CGUID+0521, 16030, 1, 1, 1, 1625.747 , -3095.011   , 89.12293   , 2.2015     , 120, 0, 0), -- Maggot (Area: Demon Fall Ridge)
(@CGUID+0523, 16030, 1, 1, 1, 1636.01  , -3052.925   , 90.07569   , 4.715363   , 120, 0, 0), -- Maggot (Area: Demon Fall Ridge)
(@CGUID+0525, 16030, 1, 1, 1, 1647.72  , -3076.708   , 88.33277   , 1.016972   , 120, 0, 0), -- Maggot (Area: Demon Fall Ridge)
(@CGUID+1200, 33767, 1, 1, 1, 1374.708 , -2831.778   , 108.8892   , 0.541052   , 120, 0, 0), -- Demon Gate Master Bunny (Area: Demon Fall Ridge)
(@CGUID+1201, 33767, 1, 1, 1, 1404.029 , -2800.942   , 123.4439   , 5.026548   , 120, 0, 0), -- Demon Gate Master Bunny (Area: Demon Fall Ridge)
(@CGUID+1202, 33767, 1, 1, 1, 1416.99  , -2823.001   , 118.2203   , 5.026548   , 120, 0, 0), -- Demon Gate Master Bunny (Area: Demon Fall Ridge)
(@CGUID+1203, 33767, 1, 1, 1, 1421.201 , -2796.817   , 153.8806   , 0.2094395  , 120, 0, 0), -- Demon Gate Master Bunny (Area: Demon Fall Ridge)
(@CGUID+1204, 33767, 1, 1, 1, 1451.948 , -2794.429   , 145.1598   , 5.026548   , 120, 0, 0), -- Demon Gate Master Bunny (Area: Demon Fall Ridge)
(@CGUID+1205, 33767, 1, 1, 1, 1499.274 , -2835.974   , 112.01     , 5.497787   , 120, 0, 0), -- Demon Gate Master Bunny (Area: Demon Fall Ridge)
(@CGUID+1206, 33767, 1, 1, 1, 1527.086 , -2857.071   , 182.7446   , 5.951573   , 120, 0, 0), -- Demon Gate Master Bunny (Area: Demon Fall Ridge)
(@CGUID+1207, 33767, 1, 1, 1, 1528.871 , -2868.603   , 124.9871   , 0          , 120, 0, 0), -- Demon Gate Master Bunny (Area: Demon Fall Ridge)
(@CGUID+1208, 33767, 1, 1, 1, 1551.396 , -2884.573   , 133.3072   , 3.193953   , 120, 0, 0), -- Demon Gate Master Bunny (Area: Demon Fall Ridge)
(@CGUID+1211, 33767, 1, 1, 1, 1603.361 , -2986.525   , 182.2357   , 6.161012   , 120, 0, 0), -- Demon Gate Master Bunny (Area: Demon Fall Ridge)
(@CGUID+1213, 33767, 1, 1, 1, 1611.014 , -3083.831   , 90.04794   , 6.213372   , 120, 0, 0), -- Demon Gate Master Bunny (Area: Demon Fall Ridge)
(@CGUID+1220, 33767, 1, 1, 1, 1658.428 , -3083.149   , 89.54523   , 5.5676     , 120, 0, 0), -- Demon Gate Master Bunny (Area: Demon Fall Ridge)
(@CGUID+1903, 40995, 1, 1, 1, 1000.899 , -419.2377   , 2.916759   , 5.702795   , 120, 0, 0), -- Azure Iron Ore (Area: Demon Fall Ridge)
(@CGUID+1929, 40995, 1, 1, 1, 1002.032 , -417.783    , 2.686168   , 5.72626    , 120, 0, 0), -- Azure Iron Ore (Area: Demon Fall Ridge)
(@CGUID+1957, 40995, 1, 1, 1, 1003.192 , -416.0978   , 2.4286     , 5.041037   , 120, 0, 0), -- Azure Iron Ore (Area: Demon Fall Ridge)
(@CGUID+2364, 6072 , 1, 1, 1, 1447.932 , -2824.844   , 153.4091   , 1.22173    , 120, 0, 0), -- Diathorus the Seeker (Area: Demon Fall Ridge)
(@CGUID+2365, 6073 , 1, 1, 1, 1401.077 , -2798.341   , 123.294    , 3.016682   , 120, 0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
(@CGUID+2366, 6073 , 1, 1, 1, 1420.36  , -2797       , 153.2968   , 4.158457   , 120, 0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
(@CGUID+2367, 6073 , 1, 1, 1, 1451.373 , -2815.769   , 154.2159   , 4.385233   , 120, 0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
(@CGUID+2368, 6073 , 1, 1, 1, 1500.756 , -2835.735   , 111.587    , 5.95405    , 120, 0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
(@CGUID+2369, 6073 , 1, 1, 1, 1512.831 , -2880.098   , 111.6148   , 5.640291   , 120, 0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
(@CGUID+2370, 6073 , 1, 1, 1, 1550.406 , -2885.673   , 132.9547   , 4.354227   , 120, 0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
(@CGUID+2371, 6073 , 1, 1, 1, 1555.71  , -2901.445   , 182.4397   , 3.857178   , 120, 0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
(@CGUID+2372, 6073 , 1, 1, 1, 1566.779 , -2894.126   , 132.5958   , 0.1956479  , 120, 0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
(@CGUID+2373, 6073 , 1, 1, 1, 1567.959 , -2827.635   , 181.6369   , 1.869659   , 120, 0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
(@CGUID+2376, 6073 , 1, 1, 1, 1588.703 , -2944.849   , 182.2199   , 0.340708   , 120, 0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
(@CGUID+2379, 6073 , 1, 1, 1, 1654.183 , -3087.397   , 88.7214    , 5.580345   , 120, 0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
(@CGUID+2403, 6115 , 1, 1, 1, 1420.313 , -2851.199   , 133.127    , 0.9438578  , 120, 0, 0), -- Roaming Felguard (Area: Demon Fall Ridge) (possible waypoints or random movement)
(@CGUID+2404, 6115 , 1, 1, 1, 1448.441 , -2799.244   , 144.3881   , 6.189845   , 120, 0, 0), -- Roaming Felguard (Area: Demon Fall Ridge) (possible waypoints or random movement)
(@CGUID+2405, 6115 , 1, 1, 1, 1461.483 , -2783.054   , 154.6106   , 4.637331   , 120, 0, 0), -- Roaming Felguard (Area: Demon Fall Ridge) (possible waypoints or random movement)
(@CGUID+2406, 6115 , 1, 1, 1, 1476.938 , -2805.129   , 149.5406   , 5.849179   , 120, 0, 0), -- Roaming Felguard (Area: Demon Fall Ridge) (possible waypoints or random movement)
(@CGUID+2407, 6115 , 1, 1, 1, 1521.961 , -2856.834   , 111.6264   , 4.90235    , 120, 0, 0), -- Roaming Felguard (Area: Demon Fall Ridge) (possible waypoints or random movement)
(@CGUID+2408, 6115 , 1, 1, 1, 1532.919 , -2870.632   , 124.7444   , 4.680573   , 120, 0, 0), -- Roaming Felguard (Area: Demon Fall Ridge) (possible waypoints or random movement)
(@CGUID+2409, 6115 , 1, 1, 1, 1536.901 , -2881.913   , 111.9105   , 0.7063568  , 120, 0, 0), -- Roaming Felguard (Area: Demon Fall Ridge) (possible waypoints or random movement)
(@CGUID+2410, 6115 , 1, 1, 1, 1610.802 , -3083.251   , 89.95774   , 1.347837   , 120, 0, 0), -- Roaming Felguard (Area: Demon Fall Ridge) (possible waypoints or random movement)
(@CGUID+2411, 6115 , 1, 1, 1, 1611.121 , -2985.179   , 182.0912   , 2.853907   , 120, 0, 0), -- Roaming Felguard (Area: Demon Fall Ridge) (possible waypoints or random movement)

@ghost ghost assigned malcrom Jan 12, 2013

Contributor

ZxBiohazardZx commented Jan 25, 2013

you should write it manually, no auto shit for it

baric commented Jan 29, 2013

Thanks, I'll get on it. I wasn't exactly sure how sniffs are converted to sql

baric commented Jan 29, 2013

Here's the sql. There was no pathing data so I had to recreate that as best as I could, including existing mobs that should have had pathing but didn't. The area is much more Blizz-like now than before.

Obviously set @ocuid and @cguid to TC appropriate values.

-- missing objects/mobs on Demon Fall Ridge
SET @OGUID := 200200;
DELETE FROM `gameobject` WHERE `guid` >= @OGUID+0 AND `guid` <= @OGUID+3;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
(@OGUID+0, 1622  , 1, 1, 1, 1559.646 , -2812.193, 181.5358 , 0         , 0           , 0           , 0           , 1            , 120, 255, 1) , -- Bruiseweed (Area: Demon Fall Ridge),
(@OGUID+1, 1623  , 1, 1, 1, 1599.648 , -3088.057, 89.47401 , 0         , 0           , 0           , 0           , 1            , 120, 255, 1) , -- Wild Steelbloom (Area: Demon Fall Ridge),
(@OGUID+2, 1732  , 1, 1, 1, 1619.236 , -3106.807, 90.91071 , 0         , 0           , 0           , 0           , 1            , 120, 255, 1) , -- Tin Vein (Area: Demon Fall Ridge),
(@OGUID+3, 176784, 1, 1, 1, 1550.686 , -2862.281, 181.7537 , 3.141593  , 0           , 0           , 0           , 1            , 120, 255, 1) ; -- Bonfire (Area: Demon Fall Ridge);

SET @CGUID := 523000;

DELETE FROM `creature` WHERE `guid` >= @CGUID+0 AND `guid` <= @CGUID+25;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
(@CGUID+00, 11697, 1, 1, 1, 1377.036 , -2832.29    , 108.1152   , 5.778122   , 120, 10, 1), -- Mannoroc Lasher (Area: Demon Fall Ridge) (waypoints or random movement)
(@CGUID+01, 11697, 1, 1, 1, 1442.845 , -2781.555   , 143.3298   , 3.407407   , 120, 10, 1), -- Mannoroc Lasher (Area: Demon Fall Ridge) (possible waypoints or random movement)
(@CGUID+02, 11697, 1, 1, 1, 1520.548 , -2910.79    , 128.7899   , 0.3708913  , 120, 10, 1), -- Mannoroc Lasher (Area: Demon Fall Ridge) (possible waypoints or random movement)
(@CGUID+03, 11697, 1, 1, 1, 1522.825 , -2851.57    , 182.1475   , 5.156503   , 120, 10, 1), -- Mannoroc Lasher (Area: Demon Fall Ridge) (waypoints or random movement)
(@CGUID+04, 11697, 1, 1, 1, 1538.938 , -2878.932   , 183.4645   , 1.239184   , 120,  0, 0), -- Mannoroc Lasher (Area: Demon Fall Ridge)
(@CGUID+05, 11697, 1, 1, 1, 1544.031 , -2848.745   , 182.5147   , 5.044002   , 120,  0, 0), -- Mannoroc Lasher (Area: Demon Fall Ridge)
(@CGUID+06, 11697, 1, 1, 1, 1544.416 , -2863.002   , 112.0556   , 2.701836   , 120, 10, 1), -- Mannoroc Lasher (Area: Demon Fall Ridge) (possible waypoints or random movement)
(@CGUID+07, 11697, 1, 1, 1, 1563.016 , -2859.155   , 182.2932   , 4.066617   , 120,  0, 0), -- Mannoroc Lasher (Area: Demon Fall Ridge)
(@CGUID+08, 11697, 1, 1, 1, 1581.573 , -2897.424   , 182.3294   , 1.43117    , 120,  0, 0), -- Mannoroc Lasher (Area: Demon Fall Ridge)
(@CGUID+09, 16030, 1, 1, 1, 1625.747 , -3095.011   , 89.12293   , 2.2015     , 120, 10, 1), -- Maggot (Area: Demon Fall Ridge)
(@CGUID+10, 16030, 1, 1, 1, 1636.01  , -3052.925   , 90.07569   , 4.715363   , 120, 10, 1), -- Maggot (Area: Demon Fall Ridge)
(@CGUID+11, 16030, 1, 1, 1, 1647.72  , -3076.708   , 88.33277   , 1.016972   , 120, 10, 1), -- Maggot (Area: Demon Fall Ridge)
(@CGUID+12, 6073 , 1, 1, 1, 1420.36  , -2797       , 153.2968   , 4.158457   , 120,  0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
(@CGUID+13, 6073 , 1, 1, 1, 1451.373 , -2815.769   , 154.2159   , 4.385233   , 120,  0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
(@CGUID+14, 6073 , 1, 1, 1, 1500.756 , -2835.735   , 111.587    , 5.95405    , 120,  0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
(@CGUID+15, 6073 , 1, 1, 1, 1512.830 , -2877.935   , 111.1157   , 2.860      , 120,  0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
(@CGUID+16, 6073 , 1, 1, 1, 1550.406 , -2885.673   , 132.9547   , 4.354227   , 120,  0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
(@CGUID+17, 6073 , 1, 1, 1, 1555.71  , -2901.445   , 182.4397   , 3.857178   , 120, 10, 1), -- Searing Infernal (Area: Demon Fall Ridge)
(@CGUID+18, 6073 , 1, 1, 1, 1566.779 , -2894.126   , 132.5958   , 0.1956479  , 120,  0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
(@CGUID+19, 6073 , 1, 1, 1, 1537.930 , -2823.109   , 181.6067   , 5.282221   , 120,  0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
(@CGUID+20, 6073 , 1, 1, 1, 1583.341 , -2959.558   , 182.2528   , 5.410459   , 120,  0, 0), -- Searing Infernal (Area: Demon Fall Ridge)
(@CGUID+21, 6115 , 1, 1, 1, 1420.313 , -2851.199   , 133.127    , 0.9438578  , 120, 10, 1), -- Roaming Felguard (Area: Demon Fall Ridge) (waypoints or random movement)
(@CGUID+22, 6115 , 1, 1, 1, 1461.483 , -2783.054   , 154.6106   , 4.637331   , 120, 10, 1), -- Roaming Felguard (Area: Demon Fall Ridge) (waypoints or random movement)
(@CGUID+23, 6115 , 1, 1, 1, 1521.961 , -2856.834   , 111.6264   , 4.90235    , 120, 10, 1), -- Roaming Felguard (Area: Demon Fall Ridge) (waypoints or random movement)
(@CGUID+24, 6115 , 1, 1, 1, 1610.802 , -3083.251   , 89.95774   , 1.347837   , 120, 10, 1), -- Roaming Felguard (Area: Demon Fall Ridge) waypoints or random movement)
(@CGUID+25, 6115 , 1, 1, 1, 1611.121 , -2985.179   , 182.0912   , 2.853907   , 120, 10, 1); -- Roaming Felguard (Area: Demon Fall Ridge) (waypoints or random movement)

-- reposition to avoid position clash with other mob
UPDATE `creature` SET `position_x` = 1553.05, `position_y` = -2844.765, `position_z` = 129.70, `orientation` = 0.6726, `MovementType` = 0, `spawndist` = 0 WHERE `guid` = 20082;

-- pathing for Felguard #20872 on 
SET @WPID := 208720;
UPDATE `creature` SET `MovementType`=2, `position_x`=1445.667358, `position_y`=-2785.956299, `position_z`=144.079132, `currentwaypoint`=0 WHERE `guid` = 20872;
DELETE FROM `creature_addon` WHERE `guid` = 20872;
INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES (20872, @WPID);
DELETE FROM `waypoint_data` WHERE `id`=@WPID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
(@WPID,  0, 1445.667358, -2785.956299, 144.079132, 0, 0, 0, 0, 100, 0),
(@WPID,  1, 1450.664429, -2799.601807, 144.581528, 0, 0, 0, 0, 100, 0),
(@WPID,  2, 1457.757935, -2801.675293, 145.510452, 0, 0, 0, 0, 100, 0),
(@WPID,  3, 1467.130493, -2804.867188, 147.879959, 0, 0, 0, 0, 100, 0),
(@WPID,  4, 1476.766113, -2806.016602, 149.540283, 0, 0, 0, 0, 100, 0),
(@WPID,  5, 1478.050537, -2798.385254, 149.963150, 0, 0, 0, 0, 100, 0),
(@WPID,  6, 1473.788696, -2787.377197, 152.504379, 0, 0, 0, 0, 100, 0),
(@WPID,  7, 1468.064453, -2783.520264, 154.801208, 0, 0, 0, 0, 100, 0),
(@WPID,  8, 1460.110718, -2782.338135, 154.570343, 0, 0, 0, 0, 100, 0),
(@WPID,  9, 1466.063477, -2783.569580, 155.144333, 0, 0, 0, 0, 100, 0),
(@WPID, 10, 1473.382202, -2788.681152, 152.407547, 0, 0, 0, 0, 100, 0),
(@WPID, 11, 1477.975464, -2797.371094, 150.017349, 0, 0, 0, 0, 100, 0),
(@WPID, 12, 1473.043457, -2804.988770, 149.482895, 0, 0, 0, 0, 100, 0),
(@WPID, 13, 1465.716309, -2806.197021, 147.414398, 0, 0, 0, 0, 100, 0),
(@WPID, 14, 1457.339355, -2802.397949, 145.514069, 0, 0, 0, 0, 100, 0),
(@WPID, 15, 1450.980835, -2794.119385, 144.331573, 0, 0, 0, 0, 100, 0);

 -- pathing for Felguard #20874 on 
SET @WPID := 208740;
UPDATE `creature` SET `MovementType`=2, `position_x`=1427.127686, `position_y`=-2794.929199, `position_z`=153.367630, `currentwaypoint`=0 WHERE `guid` = 20874;
DELETE FROM `creature_addon` WHERE `guid` = 20874;
INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES (20874, @WPID);
DELETE FROM `waypoint_data` WHERE `id`=@WPID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
(@WPID,  0, 1427.127686, -2794.929199, 153.367630, 0, 0, 0, 0, 100, 0),
(@WPID,  1, 1434.866943, -2792.607666, 153.983551, 0, 0, 0, 0, 100, 0),
(@WPID,  2, 1439.881104, -2789.645996, 156.961761, 0, 0, 0, 0, 100, 0),
(@WPID,  3, 1446.391846, -2787.082031, 158.247574, 0, 0, 0, 0, 100, 0),
(@WPID,  4, 1452.749390, -2784.158691, 156.516998, 0, 0, 0, 0, 100, 0),
(@WPID,  5, 1461.059204, -2782.987793, 154.608047, 0, 0, 0, 0, 100, 0),
(@WPID,  6, 1459.080078, -2790.694580, 157.111328, 0, 0, 0, 0, 100, 0),
(@WPID,  7, 1457.619629, -2795.229492, 158.473236, 0, 0, 0, 0, 100, 0),
(@WPID,  8, 1455.797607, -2801.988037, 158.055511, 0, 0, 0, 0, 100, 0),
(@WPID,  9, 1453.832642, -2808.706543, 155.066422, 0, 0, 0, 0, 100, 0),
(@WPID, 10, 1451.864258, -2814.851807, 153.940338, 0, 0, 0, 0, 100, 0),
(@WPID, 11, 1453.883789, -2807.040039, 155.886780, 0, 0, 0, 0, 100, 0),
(@WPID, 12, 1457.238525, -2798.087891, 158.691376, 0, 0, 0, 0, 100, 0),
(@WPID, 13, 1459.887451, -2791.610352, 157.409363, 0, 0, 0, 0, 100, 0),
(@WPID, 14, 1461.216431, -2782.308350, 154.564026, 0, 0, 0, 0, 100, 0),
(@WPID, 15, 1450.710571, -2784.914063, 157.356842, 0, 0, 0, 0, 100, 0),
(@WPID, 16, 1444.170044, -2787.408203, 158.144180, 0, 0, 0, 0, 100, 0),
(@WPID, 17, 1434.528687, -2791.566895, 154.061630, 0, 0, 0, 0, 100, 0);


-- pathing for Felguard #20876 on 
SET @WPID := 208760;
UPDATE `creature` SET `MovementType`=2, `position_x`=1519.061279, `position_y`=-2911.228271, `position_z`=128.724503, `currentwaypoint`=0 WHERE `guid` = 20876;
DELETE FROM `creature_addon` WHERE `guid` = 20876;
INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES (20876, @WPID);
DELETE FROM `waypoint_data` WHERE `id`=@WPID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
(@WPID,  0, 1519.061279, -2911.228271, 128.724503, 0, 0, 0, 0, 100, 0),
(@WPID,  1, 1520.779297, -2904.444336, 130.019699, 0, 0, 0, 0, 100, 0),
(@WPID,  2, 1523.576782, -2894.323975, 129.760376, 0, 0, 0, 0, 100, 0),
(@WPID,  3, 1525.399658, -2887.565674, 129.650497, 0, 0, 0, 0, 100, 0),
(@WPID,  4, 1527.510254, -2880.891602, 127.859444, 0, 0, 0, 0, 100, 0),
(@WPID,  5, 1530.465454, -2871.784424, 124.707077, 0, 0, 0, 0, 100, 0),
(@WPID,  6, 1534.396240, -2865.125244, 124.945396, 0, 0, 0, 0, 100, 0),
(@WPID,  7, 1541.486206, -2857.385254, 129.325195, 0, 0, 0, 0, 100, 0),
(@WPID,  8, 1546.340820, -2852.342285, 129.804764, 0, 0, 0, 0, 100, 0),
(@WPID,  9, 1551.960815, -2845.879395, 129.609558, 0, 0, 0, 0, 100, 0),
(@WPID, 10, 1547.109009, -2851.705322, 129.800903, 0, 0, 0, 0, 100, 0),
(@WPID, 11, 1542.209229, -2856.704590, 129.541779, 0, 0, 0, 0, 100, 0),
(@WPID, 12, 1534.886353, -2864.229248, 125.346100, 0, 0, 0, 0, 100, 0),
(@WPID, 13, 1530.252686, -2871.376953, 124.679268, 0, 0, 0, 0, 100, 0),
(@WPID, 14, 1528.427368, -2877.171631, 126.128044, 0, 0, 0, 0, 100, 0),
(@WPID, 15, 1525.856323, -2887.348633, 129.625702, 0, 0, 0, 0, 100, 0),
(@WPID, 16, 1523.781738, -2894.034180, 129.770584, 0, 0, 0, 0, 100, 0),
(@WPID, 17, 1521.690063, -2900.714355, 129.564087, 0, 0, 0, 0, 100, 0);

-- pathing for Lasher CGUID+0  
SET @WPID := (@CGUID+0)*10;
UPDATE `creature` SET `MovementType`=2, `position_x`=1377.440918, `position_y`=-2831.153320, `position_z`=108.026917, `currentwaypoint`=0 WHERE `guid` = @CGUID+0;
DELETE FROM `creature_addon` WHERE `guid` = @CGUID+0;
INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES (@CGUID+0, @WPID);
DELETE FROM `waypoint_data` WHERE `id`=@WPID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
(@WPID,  0, 1377.440918, -2831.153320, 108.026917, 0, 0, 0, 0, 100, 0),
(@WPID,  1, 1382.229004, -2827.563721, 108.826355, 0, 0, 0, 0, 100, 0),
(@WPID,  2, 1391.730957, -2823.097656, 109.964256, 0, 0, 0, 0, 100, 0),
(@WPID,  3, 1403.629517, -2820.422607, 113.992607, 0, 0, 0, 0, 100, 0),
(@WPID,  4, 1414.020630, -2821.883545, 116.552795, 0, 0, 0, 0, 100, 0),
(@WPID,  5, 1425.679565, -2823.227295, 118.282143, 0, 0, 0, 0, 100, 0),
(@WPID,  6, 1437.257935, -2822.140869, 120.388496, 0, 0, 0, 0, 100, 0),
(@WPID,  7, 1444.380127, -2817.184570, 120.541428, 0, 0, 0, 0, 100, 0),
(@WPID,  8, 1439.560669, -2812.109863, 120.442703, 0, 0, 0, 0, 100, 0),
(@WPID,  9, 1429.911133, -2806.321045, 121.627449, 0, 0, 0, 0, 100, 0),
(@WPID, 10, 1420.165527, -2802.415283, 122.528816, 0, 0, 0, 0, 100, 0),
(@WPID, 11, 1406.437866, -2799.521240, 123.336349, 0, 0, 0, 0, 100, 0),
(@WPID, 12, 1408.145020, -2806.980225, 124.640030, 0, 0, 0, 0, 100, 0),
(@WPID, 13, 1411.558472, -2817.519531, 130.557297, 0, 0, 0, 0, 100, 0),
(@WPID, 14, 1414.248291, -2826.448975, 134.029892, 0, 0, 0, 0, 100, 0),
(@WPID, 15, 1416.987061, -2833.898926, 134.158966, 0, 0, 0, 0, 100, 0),
(@WPID, 16, 1418.680298, -2841.623291, 134.089142, 0, 0, 0, 0, 100, 0),
(@WPID, 17, 1417.675415, -2851.522949, 133.205948, 0, 0, 0, 0, 100, 0),
(@WPID, 18, 1419.567261, -2843.880615, 134.064331, 0, 0, 0, 0, 100, 0),
(@WPID, 19, 1418.282349, -2835.081543, 133.903214, 0, 0, 0, 0, 100, 0),
(@WPID, 20, 1413.755615, -2826.055420, 133.871857, 0, 0, 0, 0, 100, 0),
(@WPID, 21, 1410.707886, -2816.007813, 129.677521, 0, 0, 0, 0, 100, 0),
(@WPID, 22, 1407.735840, -2804.345947, 123.423225, 0, 0, 0, 0, 100, 0),
(@WPID, 23, 1411.128418, -2800.364258, 123.362190, 0, 0, 0, 0, 100, 0),
(@WPID, 24, 1423.222046, -2802.809082, 122.215492, 0, 0, 0, 0, 100, 0),
(@WPID, 25, 1432.720093, -2807.233643, 121.249458, 0, 0, 0, 0, 100, 0),
(@WPID, 26, 1442.866333, -2811.426514, 120.474632, 0, 0, 0, 0, 100, 0),
(@WPID, 27, 1442.986938, -2817.752686, 120.496185, 0, 0, 0, 0, 100, 0),
(@WPID, 28, 1432.807739, -2820.319336, 120.214920, 0, 0, 0, 0, 100, 0),
(@WPID, 29, 1422.910767, -2822.051270, 118.090607, 0, 0, 0, 0, 100, 0),
(@WPID, 30, 1411.085083, -2819.568359, 115.681824, 0, 0, 0, 0, 100, 0),
(@WPID, 31, 1400.672852, -2819.333740, 113.069351, 0, 0, 0, 0, 100, 0),
(@WPID, 32, 1392.437012, -2822.626953, 110.105415, 0, 0, 0, 0, 100, 0),
(@WPID, 33, 1381.681763, -2827.953857, 108.544312, 0, 0, 0, 0, 100, 0);

-- pathing for Lasher CGUID+3  
SET @WPID := (@CGUID+3)*10;
UPDATE `creature` SET `MovementType`=2, `position_x`=1525.115723, `position_y`=-2850.323975, `position_z`=182.264648, `currentwaypoint`=0 WHERE `guid` = @CGUID+3;
DELETE FROM `creature_addon` WHERE `guid` = @CGUID+3;
INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES (@CGUID+3, @WPID);
DELETE FROM `waypoint_data` WHERE `id`=@WPID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
(@WPID,  0, 1525.115723, -2850.323975, 182.264648, 0, 0, 0, 0, 100, 0),
(@WPID,  1, 1531.196411, -2840.045166, 182.315933, 0, 0, 0, 0, 100, 0),
(@WPID,  2, 1540.609741, -2830.145752, 182.035614, 0, 0, 0, 0, 100, 0),
(@WPID,  3, 1550.371094, -2824.623535, 181.914169, 0, 0, 0, 0, 100, 0),
(@WPID,  4, 1560.609863, -2825.602783, 181.713562, 0, 0, 0, 0, 100, 0),
(@WPID,  5, 1573.442139, -2834.195557, 181.620041, 0, 0, 0, 0, 100, 0),
(@WPID,  6, 1573.676636, -2843.122803, 182.236511, 0, 0, 0, 0, 100, 0),
(@WPID,  7, 1575.495605, -2852.658936, 183.287399, 0, 0, 0, 0, 100, 0),
(@WPID,  8, 1573.915161, -2863.642578, 182.804459, 0, 0, 0, 0, 100, 0),
(@WPID,  9, 1568.231201, -2881.090820, 183.118271, 0, 0, 0, 0, 100, 0),
(@WPID, 10, 1558.646729, -2884.779541, 183.471115, 0, 0, 0, 0, 100, 0),
(@WPID, 11, 1549.383301, -2877.014160, 182.969772, 0, 0, 0, 0, 100, 0),
(@WPID, 12, 1541.126465, -2864.694092, 182.265366, 0, 0, 0, 0, 100, 0);

-- pathing for Felguard CGUID+21 on 
SET @WPID := (@CGUID+21)*10;
UPDATE `creature` SET `MovementType`=2, `position_x`=1418.673340, `position_y`=-2849.543701, `position_z`=133.128998, `currentwaypoint`=0 WHERE `guid` = @CGUID+21;
DELETE FROM `creature_addon` WHERE `guid` = @CGUID+21;
INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES (@CGUID+21, @WPID);
DELETE FROM `waypoint_data` WHERE `id`=@WPID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
(@WPID,  0, 1418.673340, -2849.543701, 133.128998, 0, 0, 0, 0, 100, 0),
(@WPID,  1, 1419.053223, -2840.867188, 133.872528, 0, 0, 0, 0, 100, 0),
(@WPID,  2, 1416.689941, -2834.154297, 134.137970, 0, 0, 0, 0, 100, 0),
(@WPID,  3, 1414.608398, -2827.471436, 134.225082, 0, 0, 0, 0, 100, 0),
(@WPID,  4, 1412.582764, -2820.770996, 132.077194, 0, 0, 0, 0, 100, 0),
(@WPID,  5, 1409.088867, -2810.655762, 126.843498, 0, 0, 0, 0, 100, 0),
(@WPID,  6, 1411.302002, -2817.291016, 130.399963, 0, 0, 0, 0, 100, 0),
(@WPID,  7, 1413.902222, -2826.605957, 134.035446, 0, 0, 0, 0, 100, 0),
(@WPID,  8, 1416.532471, -2833.090820, 134.308105, 0, 0, 0, 0, 100, 0),
(@WPID,  9, 1418.736084, -2841.765137, 134.127487, 0, 0, 0, 0, 100, 0);

-- pathing for Felguard CGUID+22 on 
SET @WPID := (@CGUID+22)*10;
UPDATE `creature` SET `MovementType`=2, `position_x`=1461.952393, `position_y`=-2777.578613, `position_z`=154.923584, `currentwaypoint`=0 WHERE `guid` = @CGUID+22;
DELETE FROM `creature_addon` WHERE `guid` = @CGUID+22;
INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES (@CGUID+22, @WPID);
DELETE FROM `waypoint_data` WHERE `id`=@WPID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
(@WPID,  0, 1461.952393, -2777.578613, 154.923584, 0, 0, 0, 0, 100, 0),
(@WPID,  1, 1465.133545, -2767.573975, 154.857132, 0, 0, 0, 0, 100, 0),
(@WPID,  2, 1472.367310, -2758.643555, 156.072708, 0, 0, 0, 0, 100, 0),
(@WPID,  3, 1482.150879, -2754.233887, 156.292877, 0, 0, 0, 0, 100, 0),
(@WPID,  4, 1493.999512, -2752.110352, 158.143372, 0, 0, 0, 0, 100, 0),
(@WPID,  5, 1497.644165, -2753.630127, 159.105545, 0, 0, 0, 0, 100, 0),
(@WPID,  6, 1500.601318, -2760.660889, 160.422638, 0, 0, 0, 0, 100, 0),
(@WPID,  7, 1501.830933, -2768.006348, 160.797318, 0, 0, 0, 0, 100, 0),
(@WPID,  8, 1503.898804, -2771.084473, 161.295364, 0, 0, 0, 0, 100, 0),
(@WPID,  9, 1509.369507, -2777.201904, 163.673080, 0, 0, 0, 0, 100, 0),
(@WPID, 10, 1512.175049, -2785.971191, 165.083893, 0, 0, 0, 0, 100, 0),
(@WPID, 11, 1513.801514, -2792.097412, 165.634216, 0, 0, 0, 0, 100, 0),
(@WPID, 12, 1518.169800, -2796.058838, 165.138840, 0, 0, 0, 0, 100, 0),
(@WPID, 13, 1524.349854, -2800.773926, 167.720108, 0, 0, 0, 0, 100, 0),
(@WPID, 14, 1525.073975, -2806.124023, 169.219666, 0, 0, 0, 0, 100, 0),
(@WPID, 15, 1522.830933, -2812.213623, 170.961700, 0, 0, 0, 0, 100, 0),
(@WPID, 16, 1511.613159, -2814.369385, 174.126556, 0, 0, 0, 0, 100, 0),
(@WPID, 17, 1510.135620, -2812.832031, 174.583145, 0, 0, 0, 0, 100, 0),
(@WPID, 18, 1507.537842, -2804.130127, 177.219849, 0, 0, 0, 0, 100, 0),
(@WPID, 19, 1510.847778, -2799.395020, 178.859070, 0, 0, 0, 0, 100, 0),
(@WPID, 20, 1516.893555, -2797.346436, 180.676239, 0, 0, 0, 0, 100, 0),
(@WPID, 21, 1522.649170, -2800.572021, 182.535858, 0, 0, 0, 0, 100, 0),
(@WPID, 22, 1524.135986, -2803.739746, 183.545761, 0, 0, 0, 0, 100, 0),
(@WPID, 23, 1525.988403, -2809.307129, 183.373550, 0, 0, 0, 0, 100, 0),
(@WPID, 24, 1531.261963, -2816.573486, 183.528900, 0, 0, 0, 0, 100, 0),
(@WPID, 25, 1525.760620, -2811.326904, 183.373657, 0, 0, 0, 0, 100, 0),
(@WPID, 26, 1524.779297, -2808.985840, 183.373657, 0, 0, 0, 0, 100, 0),
(@WPID, 27, 1523.441772, -2802.632324, 183.127411, 0, 0, 0, 0, 100, 0),
(@WPID, 28, 1517.132202, -2796.257080, 180.712280, 0, 0, 0, 0, 100, 0),
(@WPID, 29, 1513.053223, -2798.000732, 179.479279, 0, 0, 0, 0, 100, 0),
(@WPID, 30, 1507.427002, -2804.455811, 177.126724, 0, 0, 0, 0, 100, 0),
(@WPID, 31, 1508.335205, -2810.697266, 175.403000, 0, 0, 0, 0, 100, 0),
(@WPID, 32, 1511.198853, -2812.709717, 174.371857, 0, 0, 0, 0, 100, 0),
(@WPID, 33, 1517.645874, -2814.697510, 172.516037, 0, 0, 0, 0, 100, 0),
(@WPID, 34, 1522.476196, -2811.204834, 170.816132, 0, 0, 0, 0, 100, 0),
(@WPID, 35, 1524.924316, -2804.578857, 168.840012, 0, 0, 0, 0, 100, 0),
(@WPID, 36, 1522.207397, -2800.135010, 167.209824, 0, 0, 0, 0, 100, 0),
(@WPID, 37, 1515.743164, -2793.846436, 165.489563, 0, 0, 0, 0, 100, 0),
(@WPID, 38, 1513.621826, -2789.284180, 165.761047, 0, 0, 0, 0, 100, 0),
(@WPID, 39, 1511.703735, -2782.553467, 165.049728, 0, 0, 0, 0, 100, 0),
(@WPID, 40, 1509.514526, -2776.442139, 163.672668, 0, 0, 0, 0, 100, 0),
(@WPID, 41, 1504.341187, -2768.239258, 160.875214, 0, 0, 0, 0, 100, 0),
(@WPID, 42, 1499.623779, -2758.871826, 160.065994, 0, 0, 0, 0, 100, 0),
(@WPID, 43, 1492.976929, -2750.636963, 158.080460, 0, 0, 0, 0, 100, 0),
(@WPID, 44, 1487.860107, -2750.589600, 157.576538, 0, 0, 0, 0, 100, 0),
(@WPID, 45, 1478.629761, -2755.590332, 155.843948, 0, 0, 0, 0, 100, 0),
(@WPID, 46, 1469.609863, -2761.452148, 155.947708, 0, 0, 0, 0, 100, 0),
(@WPID, 47, 1465.007324, -2767.513184, 154.872833, 0, 0, 0, 0, 100, 0),
(@WPID, 48, 1462.420410, -2775.385254, 155.379456, 0, 0, 0, 0, 100, 0);

-- pathing for Felguard CGUID+23 on 
SET @WPID := (@CGUID+23)*10;
UPDATE `creature` SET `MovementType`=2, `position_x`=1529.591064, `position_y`=-2869.343506, `position_z`=124.593094, `currentwaypoint`=0 WHERE `guid` = @CGUID+23;
DELETE FROM `creature_addon` WHERE `guid` = @CGUID+23;
INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES (@CGUID+23, @WPID);
DELETE FROM `waypoint_data` WHERE `id`=@WPID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
(@WPID,  0, 1529.591064, -2869.343506, 124.593094, 0, 0, 0, 0, 100, 0),
(@WPID,  1, 1521.646606, -2867.309082, 125.010071, 0, 0, 0, 0, 100, 0),
(@WPID,  2, 1513.953125, -2865.164551, 121.647118, 0, 0, 0, 0, 100, 0),
(@WPID,  3, 1505.404785, -2862.673584, 118.801720, 0, 0, 0, 0, 100, 0),
(@WPID,  4, 1503.566650, -2868.243408, 116.714241, 0, 0, 0, 0, 100, 0),
(@WPID,  5, 1502.711060, -2874.966064, 113.316238, 0, 0, 0, 0, 100, 0),
(@WPID,  6, 1512.905396, -2877.691650, 111.030319, 0, 0, 0, 0, 100, 0),
(@WPID,  7, 1521.637085, -2882.186279, 111.867195, 0, 0, 0, 0, 100, 0),
(@WPID,  8, 1529.314087, -2885.161865, 111.463722, 0, 0, 0, 0, 100, 0),
(@WPID,  9, 1539.290527, -2881.081299, 112.201981, 0, 0, 0, 0, 100, 0),
(@WPID, 10, 1543.733276, -2870.510986, 112.591675, 0, 0, 0, 0, 100, 0),
(@WPID, 11, 1538.328125, -2855.836182, 111.515526, 0, 0, 0, 0, 100, 0),
(@WPID, 12, 1527.172241, -2852.837158, 111.962715, 0, 0, 0, 0, 100, 0),
(@WPID, 13, 1519.438599, -2860.600342, 111.478615, 0, 0, 0, 0, 100, 0),
(@WPID, 14, 1511.972412, -2870.450684, 111.600555, 0, 0, 0, 0, 100, 0),
(@WPID, 15, 1507.419556, -2876.432617, 112.032738, 0, 0, 0, 0, 100, 0),
(@WPID, 16, 1504.038330, -2877.903809, 112.833618, 0, 0, 0, 0, 100, 0),
(@WPID, 17, 1502.584595, -2873.350342, 113.795448, 0, 0, 0, 0, 100, 0),
(@WPID, 18, 1505.001221, -2866.783203, 117.746407, 0, 0, 0, 0, 100, 0),
(@WPID, 19, 1506.119873, -2863.151855, 118.807045, 0, 0, 0, 0, 100, 0),
(@WPID, 20, 1513.878296, -2865.620605, 121.673973, 0, 0, 0, 0, 100, 0),
(@WPID, 21, 1527.201050, -2868.420166, 124.730896, 0, 0, 0, 0, 100, 0);

-- pathing for Felguard CGUID+24 on 
SET @WPID := (@CGUID+24)*10;
UPDATE `creature` SET `MovementType`=2, `position_x`=1682.383301, `position_y`=-3116.470459, `position_z`=89.554993, `currentwaypoint`=0 WHERE `guid` = @CGUID+24;
DELETE FROM `creature_addon` WHERE `guid` = @CGUID+24;
INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES (@CGUID+24, @WPID);
DELETE FROM `waypoint_data` WHERE `id`=@WPID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
(@WPID,  0, 1682.383301, -3116.470459, 89.554993, 0, 0, 0, 0, 100, 0),
(@WPID,  0, 1674.620605, -3109.400146, 88.976250, 0, 0, 0, 0, 100, 0),
(@WPID,  0, 1658.956787, -3095.415039, 89.265846, 0, 0, 0, 0, 100, 0),
(@WPID,  0, 1653.566772, -3084.082275, 88.686615, 0, 0, 0, 0, 100, 0),
(@WPID,  0, 1646.295532, -3068.169434, 88.805115, 0, 0, 0, 0, 100, 0),
(@WPID,  0, 1636.780884, -3059.662109, 88.973808, 0, 0, 0, 0, 100, 0),
(@WPID,  0, 1624.316528, -3060.500488, 89.142319, 0, 0, 0, 0, 100, 0),
(@WPID,  0, 1617.466064, -3070.297119, 89.184601, 0, 0, 0, 0, 100, 0),
(@WPID,  0, 1617.102051, -3082.547607, 89.317902, 0, 0, 0, 0, 100, 0),
(@WPID,  0, 1627.488770, -3091.394531, 88.658096, 0, 0, 0, 0, 100, 0),
(@WPID,  0, 1637.340332, -3094.989258, 88.381920, 0, 0, 0, 0, 100, 0),
(@WPID,  0, 1650.978027, -3098.081299, 88.389397, 0, 0, 0, 0, 100, 0),
(@WPID,  0, 1665.720093, -3104.706787, 88.814766, 0, 0, 0, 0, 100, 0);

-- pathing for Felguard CGUID+25 on 
SET @WPID := (@CGUID+25)*10;
UPDATE `creature` SET `MovementType`=2, `position_x`=1606.020386, `position_y`=-2979.190918, `position_z`=182.066589, `currentwaypoint`=0 WHERE `guid` = @CGUID+25;
DELETE FROM `creature_addon` WHERE `guid` = @CGUID+25;
INSERT INTO `creature_addon` (`guid`, `path_id`) VALUES (@CGUID+25, @WPID);
DELETE FROM `waypoint_data` WHERE `id`=@WPID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
(@WPID,  0, 1606.020386, -2979.190918, 182.066589, 0, 0, 0, 0, 100, 0),
(@WPID,  1, 1592.612793, -2967.980469, 181.734604, 0, 0, 0, 0, 100, 0),
(@WPID,  2, 1584.635986, -2961.699951, 182.099609, 0, 0, 0, 0, 100, 0),
(@WPID,  3, 1576.772339, -2950.720215, 182.331390, 0, 0, 0, 0, 100, 0),
(@WPID,  4, 1570.186157, -2937.653564, 181.647690, 0, 0, 0, 0, 100, 0),
(@WPID,  5, 1569.346313, -2915.366455, 181.606720, 0, 0, 0, 0, 100, 0),
(@WPID,  6, 1567.291138, -2897.670410, 181.974411, 0, 0, 0, 0, 100, 0),
(@WPID,  7, 1561.564575, -2883.124512, 183.536499, 0, 0, 0, 0, 100, 0),
(@WPID,  8, 1554.509888, -2870.604492, 182.784332, 0, 0, 0, 0, 100, 0),
(@WPID,  9, 1559.559570, -2883.650391, 183.535065, 0, 0, 0, 0, 100, 0),
(@WPID, 10, 1565.662109, -2900.051514, 181.913925, 0, 0, 0, 0, 100, 0),
(@WPID, 11, 1570.201538, -2913.283936, 181.571747, 0, 0, 0, 0, 100, 0),
(@WPID, 12, 1573.806274, -2932.618896, 181.725723, 0, 0, 0, 0, 100, 0),
(@WPID, 13, 1579.702026, -2949.056885, 182.503983, 0, 0, 0, 0, 100, 0),
(@WPID, 14, 1586.535400, -2960.601807, 182.164642, 0, 0, 0, 0, 100, 0),
(@WPID, 15, 1595.999878, -2972.899414, 181.872986, 0, 0, 0, 0, 100, 0);

Oxtar commented Feb 2, 2013

Use a pastebin.

baric commented Feb 3, 2013

http://pastebin.com/kWXDb0JR

Doesn't anyone know how to say please around here.

@ghost ghost assigned ZxBiohazardZx Mar 4, 2013

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment