diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2024_05_22_03_world.sql | 490 |
1 files changed, 490 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_05_22_03_world.sql b/sql/updates/world/master/2024_05_22_03_world.sql new file mode 100644 index 00000000000..5f1f33116a4 --- /dev/null +++ b/sql/updates/world/master/2024_05_22_03_world.sql @@ -0,0 +1,490 @@ +SET @CGUID := 7000412; +SET @OGUID := 7000194; +SET @UNPHASED_OGUID := 7000168; + +DELETE FROM `phase_name` WHERE `ID`=12607; +INSERT INTO `phase_name` (`ID`, `Name`) VALUES +(12607, 'Kul Tiran Unlock - Port Fogtide Part 1 K''thir'); + +DELETE FROM `phase_area` WHERE `PhaseId`=12607; +INSERT INTO `phase_area` (`AreaId`, `PhaseId`, `Comment`) VALUES +(9579, 12607, 'Kul Tiran Unlock - Port Fogtide Part 1 K''thir - Tidecross'), +(9578, 12607, 'Kul Tiran Unlock - Port Fogtide Part 1 K''thir - Port Fogtide'), +(9622, 12607, 'Kul Tiran Unlock - Port Fogtide Part 1 K''thir - Krakens Reach'); + +DELETE FROM `creature_equip_template` WHERE (`ID`=1 AND `CreatureID` IN (148911,148912)); +INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `AppearanceModID1`, `ItemVisual1`, `ItemID2`, `AppearanceModID2`, `ItemVisual2`, `ItemID3`, `AppearanceModID3`, `ItemVisual3`, `VerifiedBuild`) VALUES +(148911, 1, 152426, 0, 0, 0, 0, 0, 0, 0, 0, 54762), -- Drowned Convert +(148912, 1, 119396, 0, 0, 113879, 0, 0, 0, 0, 0, 54762); -- Drowned Harbinger + +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags`=0x40, `unit_flags2`=0x800 WHERE `entry`=148913; -- Umbral Hulk +UPDATE `creature_template` SET `unit_flags2`=0x800, `unit_flags3`=0x800000 WHERE `entry`=142609; -- Handyman Gareth +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=148912; -- Drowned Harbinger +UPDATE `creature_template` SET `unit_flags2`=0x0 WHERE `entry`=134747; -- Tidesage Defector +UPDATE `creature_template` SET `faction`=14, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=148916; -- Grasp of the Deep +UPDATE `creature_template` SET `faction`=14, `speed_run`=0.428571432828903198, `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=148915; -- Corrupted Waters +UPDATE `creature_template` SET `faction`=16, `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=148911; -- Drowned Convert +UPDATE `creature_template` SET `unit_flags3`=0x1000000 WHERE `entry`=149374; -- FX Stalker + +UPDATE `creature_template_difficulty` SET `ContentTuningID`=517, `StaticFlags1`=0x10000000, `VerifiedBuild`=54762 WHERE (`Entry`=148911 AND `DifficultyID`=0); -- 148911 (Drowned Convert) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=517, `StaticFlags1`=0x10000000, `VerifiedBuild`=54762 WHERE (`Entry`=148912 AND `DifficultyID`=0); -- 148912 (Drowned Harbinger) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=517, `StaticFlags1`=0x10000000, `VerifiedBuild`=54762 WHERE (`Entry`=148913 AND `DifficultyID`=0); -- 148913 (Umbral Hulk) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=517, `StaticFlags1`=0x10000000, `VerifiedBuild`=54762 WHERE (`Entry`=148915 AND `DifficultyID`=0); -- 148915 (Corrupted Waters) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=517, `StaticFlags1`=0x20000100, `VerifiedBuild`=54762 WHERE (`Entry`=148916 AND `DifficultyID`=0); -- 148916 (Grasp of the Deep) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x30000100, `VerifiedBuild`=54762 WHERE (`Entry`=149374 AND `DifficultyID`=0); -- 149374 (FX Stalker) - Sessile, CanSwim, Floating + +UPDATE `creature_equip_template` SET `VerifiedBuild`=54762 WHERE (`ID`=1 AND `CreatureID` IN (134696,134747)); +UPDATE `creature_model_info` SET `VerifiedBuild`=54762 WHERE `DisplayID` IN (88680, 90148, 8550, 11686); +UPDATE `creature_template` SET `VerifiedBuild`=54762 WHERE `entry` IN (218646, 218647, 72889, 93145, 28363, 97200, 105299, 105301, 121498, 56717, 153898, 52675, 60776, 4092, 48632, 56732, 56747, 153928, 44606, 68904, 68905, 24368, 77006, 141792, 153941, 198484, 141800, 141805, 40583, 36535, 4155, 4159, 64900, 4167, 198527, 109450, 158041, 145898, 40625, 145903, 162102, 40634, 73033, 56839, 129722, 56843, 73042, 170218, 4218, 28514, 202621, 28517, 4223, 60913, 149995, 202637, 206689, 64977, 150017, 60941, 64993, 56897, 150024, 154074, 77149, 4269, 77153, 65011, 69066, 56921, 129803, 40725, 166246, 32633, 56930, 77182, 146016, 69086, 166266, 150081, 129836, 158190, 162241, 162243, 162244, 162245, 154148, 162246, 162247, 162248, 162249, 162250, 162251, 154154, 162252, 162253, 162254, 52936, 304, 166313, 305, 73195, 125837, 81305, 162290, 218977, 146107, 150159, 69181, 202800, 109674, 162317, 142088, 97551, 150190, 69212, 73265, 36855, 158327, 81403, 142148, 105721, 134069, 32857, 105742, 105743, 105744, 57156, 57157, 32867, 61213, 150295, 61243, 130079, 28860, 45057, 174626, 32913, 32914, 32915, 32919, 178684, 32927, 32930, 154431, 69427, 101823, 113971, 178763, 158531, 53258, 65407, 81603, 174733, 178783, 53270, 166644, 33030, 138314, 4710, 122135, 29023, 61427, 61431, 61442, 211268, 33113, 158632, 211272, 211273, 33118, 4777, 45268, 33121, 4779, 146495, 33134, 33136, 101976, 73638, 162719, 126283, 150583, 25064, 101995, 154638, 170851, 126312, 33186, 158706, 49392, 33202, 134442, 65614, 61567, 183042, 122313, 122314, 122316, 33241, 122319, 33244, 81834, 53494, 102088, 53501, 118289, 130437, 154735, 154741, 77814, 77816, 150706, 142609, 122366, 49485, 73780, 142625, 142634, 69756, 90018, 102169, 41440, 33343, 154817, 29305, 61699, 90049, 61707, 162933, 61709, 146750, 69820, 77927, 33388, 122477, 171094, 171095, 138705, 1043, 195399, 138718, 138719, 53694, 53695, 53696, 9158, 122532, 65851, 98246, 138740, 130646, 134696, 171146, 114462, 82074, 21354, 98293, 90199, 134747, 33524, 61884, 33552, 167169, 102396, 159087, 33572, 150995, 78121, 86219, 70025, 126712, 155056, 70027, 102423, 183406, 155069, 90296, 86250, 86251, 142949, 179392, 29582, 155126, 134884, 138938, 49864, 134897, 155144, 33686, 183501, 138963, 138967, 207800, 175422, 130897, 143045, 114709, 94471, 151168, 98542, 45906, 175474, 66151, 33768, 155242, 155243, 155245, 155247, 171456, 110732, 155273, 175519, 155275, 155277, 171474, 70250, 70251, 70252, 62164, 191736, 110758, 131009, 82428, 37890, 45992, 45993, 54105, 82457, 122969, 78430, 118924, 37949, 175616, 135129, 98696, 114895, 70356, 54191, 38009, 38010, 131140, 110907, 98761, 29929, 29932, 74475, 33993, 159514, 175725, 139298, 139300, 70468, 58321, 139304, 187894, 34035, 139319, 139328, 34057, 147430, 94808, 155543, 111008, 74570, 74571, 38135, 179850, 50284, 70544, 139385, 183928, 102950, 62465, 183937, 155595, 131318, 115143, 98949, 155645, 155648, 54423, 50376, 94923, 147562, 192104, 78736, 184018, 99009, 94960, 131404, 151654, 99031, 94996, 86918, 135513, 155760, 86928, 74787, 151719, 58605, 107194, 135552, 42428, 111263, 208459, 50561, 208478, 127503, 58676, 188252, 78948, 99200, 131595, 123503, 172093, 172094, 83026, 131615, 131617, 131619, 58739, 155919, 151870, 123531, 139737, 58777, 135713, 131667, 58787, 54741, 135725, 164076, 212668, 30472, 147895, 147896, 75029, 147923, 18357, 18359, 91241, 18360, 18362, 34564, 156034, 147941, 18375, 18376, 147951, 18406, 34605, 46753, 91305, 147998, 54879, 62982, 62983, 172312, 164218, 42753, 111587, 91349, 111595, 148044, 131853, 135903, 42778, 127809, 164255, 139968, 91387, 148075, 139980, 139988, 135939, 172386, 148092, 135947, 54969, 26627, 26628, 196696, 26641, 208849, 63091, 14505, 160271, 14507, 160291, 59072, 59080, 164363, 14559, 59100, 14565, 87451, 115795, 107698, 107699, 34826, 148201, 132007, 152253, 67231, 55087, 115831, 59153, 99646, 115844, 176583, 152290, 152291, 67263, 67264, 67266, 99663, 99664, 164450, 164451, 196845, 140163, 103725, 164461, 180658, 51090, 164463, 152323, 200912, 200913, 164475, 119938, 200918, 115902, 144246, 103758, 180690, 111861, 111864, 164501, 136160, 152359, 152360, 71381, 152361, 184759, 164517, 111882, 136183, 75452, 136189, 164532, 63313, 152397, 144311, 164557, 14745, 152414, 152415, 152416, 71440, 63342, 144324, 59303, 111941, 184823, 164578, 35013, 71466, 152448, 196993, 140315, 152464, 152465, 67437, 71486, 156523, 55308, 55312, 59368, 99868, 124164, 71529, 124166, 55334, 152512, 180860, 95833, 184915, 156575, 99891, 95843, 152542, 152545, 140398, 152548, 152552, 152553, 152555, 152556, 152566, 152567, 152568, 47297, 95886, 95888, 63502, 39208, 39209, 71603, 59458, 55419, 31125, 67569, 67571, 156650, 59479, 83775, 185005, 140474, 51405, 55466, 209333, 156709, 63591, 181012, 91938, 201261, 152681, 185074, 152682, 144596, 2889, 205340, 152703, 205341, 205342, 205343, 31239, 152712, 205352, 43404, 201320, 144637, 185128, 185129, 185130, 185131, 205378, 144644, 172992, 172995, 201340, 152756, 197298, 75829, 160859, 168962, 116329, 144680, 124436, 144683, 35362, 71803, 164934, 43468, 156842, 152794, 152795, 205437, 209490, 104217, 67779, 164967, 156884, 104251, 63766, 193335, 104262, 132609, 197396, 67844, 136683, 181224, 189340, 144807, 59779, 67879, 96223, 152910, 67883, 59789, 165066, 148870, 47649, 165073, 148879, 104341, 156987, 92208, 128652, 59822, 59824, 112464, 120564, 71979, 148911, 148912, 148913, 71983, 71984, 148915, 148916, 43658, 84152, 205627, 205630, 67966, 27483, 67977, 47739, 144915, 76084, 185409, 205665, 15363, 205667, 185423, 124691, 185427, 39665, 205674, 185437, 185438, 185439, 59930, 185456, 140925, 100436, 140938, 144987, 68057, 185479, 185480, 149043, 68065, 64017, 144997, 157161, 47841, 104528, 88334, 145020, 116691, 108600, 64061, 76209, 23574, 140997, 141002, 193644, 193645, 193647, 76227, 193648, 193650, 193652, 193653, 193654, 193655, 60040, 31698, 124828, 153172, 27654, 27656, 27657, 141029, 27658, 27659, 189620, 157231, 193674, 201773, 173430, 193675, 141039, 193677, 193678, 193679, 193680, 141043, 193682, 141046, 193684, 193686, 153202, 181546, 141059, 76283, 108682, 137025, 27707, 137036, 197774, 141088, 181579, 116802, 153245, 157298, 165408, 169458, 27756, 161375, 189722, 145185, 214020, 149240, 177584, 141143, 149244, 96609, 157354, 161414, 68288, 31851, 141175, 15666, 149289, 56165, 201934, 214082, 205989, 84520, 15687, 137158, 39984, 169554, 39987, 165512, 68336, 141226, 52148, 145278, 15714, 141239, 169594, 60276, 68376, 165556, 153415, 72436, 169617, 149374, 64346, 157475, 137233, 173675, 72451, 80551, 141286, 72455, 80557, 173685, 96754, 96756, 189893, 7690, 121071, 72490, 161573, 72496, 214211, 198038, 214235, 27981, 214236, 129208, 214240, 214241, 214242, 117072, 145415, 76585, 181861, 173767, 173768, 173769, 173770, 72545, 76598, 108996, 206172, 40165, 60410, 189988, 64471, 157602, 64479, 165737, 64526, 80728, 52392, 68599, 32158, 52405, 64556, 52414, 52418, 52422, 165805, 153658, 52438, 52440, 52442, 32206, 68655, 28165, 105097, 113204, 173945, 173951, 60583, 60585, 60586, 88938, 186120, 76801, 149684, 129440, 32273, 36330, 186151, 97081, 97083, 97084, 174018, 137588, 52571, 178095, 161901, 32335, 56636, 56637, 28302, 174073, 198370, 80951, 60709, 20220, 60710, 68820, 44530); +UPDATE `creature_template_model` SET `VerifiedBuild`=54762 WHERE (`Idx`=0 AND `CreatureID` IN (127503,131853,107699,145903,108600,105742,171094,111864,61699,74570,161375,155144,32927,38010,78121,155056,155760,144246,127809,138740,65407,98696,45906,99868,162933,104217,156575,124164,137588,68905,151654,53258,96223,148201,178763,102169,59822,56897,33118,150081,56843,58605,99664,145898,61431,38009,160859,67231,62465,64479,105301,141805,61567,80557,101976,61213,154074,76209,61709,28514,29023,131318,202800,102423,56637,44530,61442,34035,59779,33768,49485,84520,33552,33202,52414,52422,52438,50284,52392,76585,68599,81834,105299,176583,158041,67779,154741,55308,55312,173769,150995,141800,69086,165073,201773,33136,122135,71603,33244,58787,129722,55419,164363,73265,170851,38135,142949,136683,63091,110732,59458,55334,32273,26628,29305,27654,99031,56165,86250,86918,115143,86928,146016,111882,72436,119938,64061,105744,164967,164557,171474,69427,172094,156884,95833,174018,165408,164450,162317,105743,129208,164218,104528,172995,165737,36855,171456,184759,153941,80551,172386,122366,117072,36535,175474,141792,165066,115844,173768,173770,67571,109450,153172,67966,175422,173767,94808,172992,166644,172093,147430,164501,162102,108682,116802,39987,23574,26627,205343,126712,74475,118924,164934,165512,120564,104341,103758,138719,77814,56930,77927,41440,67569,100436,33241,138718,68336,114462,33113,136160,73195,15687,50376,114895,169554,108996,32857,68655,91349,135903,94996,93145,152910,64346,83775,155595,166266,60709,49864,71979,15363,158190,78948,111941,72889,185005,61884,139737,4159,144596,70252,52675,53494,87451,99663,52571,52936,88938,53501,39665,185131,40634,72496,71466,72490,105097,70251,71984,185130,138967,71983,180690,115902,157475,90199,166246,185129,179850,71529,177584,135513,91938,70250,135129,153415,180860,113971,97551,32919,178095,180658,39984,175616,73638,181012,185423,33686,95888,61243,167169,185128,90049,51405,67883,178783,185427,185439,27659,64017,88334,43468,183501,43404,181546,102950,181579,59080,184915,77153,138705,53695,154817,56839,74787,26641,64471,104262,45993,102088,95886,179392,183937,184823,59100,157161,68904,143045,189893,198038,197298,154431,165556,197774,33343,196845,205340,78430,152512,197396,164532,52418,205341,156987,82074,205342,123531,60410,205989,131667,45992,189722,64556,201934,82457,98761,33524,90018,67879,43658,205352,200912,59930,137036,152253,53696,214020,214211,214235,138314,144324,214236,81305,77149,214240,214241,115831,214242,209333,206689,208478,72545,208459,94923,123503,84152,165805,142148,214082,110907,1043,185409,149995,146495,207800,4155,4218,80728,56732,146750,53694,56636,4167,4223,209490,174626,189620,32915,193335,202637,137158,98246,201320,205630,166313,205437,98949,205627,205665,192104,201340,201261,121071,73033,181861,189340,112464,186151,146107,29932,58777,50561,122477,2889,157231,147896,32914,147895,68065,126312,94471,149684,83026,164517,107194,113204,101823,149043,111861,32913,59479,131140,144311,157354,99009,156842,202621,161573,62164,27981,99200,104251,196993,28860,198527,150190,105721,172312,102396,160291,164255,69212,99646,86219,162719,186120,185480,129440,47297,75029,185479,157602,61427,60276,63313,34605,149289,54969,46753,78736,33134,27756,144683,134069,174733,122532,54105,68057,169617,107698,159514,36330,97084,68376,144680,116329,58676,183042,52442,144807,64526,45057,97083,191736,205674,153245,77006,33388,60913,135725,58739,171146,139304,111595,34826,97081,63342,155543,145185,27483,68820,30472,187894,134442,52440,142625,139300,205667,124828,183928,160271,71440,130646,59153,42753,178684,109674,98293,150295,70544,59824,99891,173951,34057,33993,91387,27658,58321,74571,155919,168962,185074,47739,44606,135713,206172,81603,185456,154638,96756,155277,103725,110758,198370,161414,131619,174073,173945,155275,122969,150159,131617,121498,183406,96754,155273,52405,90296,111587,27657,169594,131615,173430,173685,97200,59789,101995,208849,61707,35013,98542,65614,37890,164475,52148,72455,124436,31125,76227,150024,156034,200918,124691,94960,181224,82428,111008,175725,196696,155648,76801,27656,169458,211273,111263,137233,34564,67977,211272,198484,42428,200913,155645,81403,173675,60586,63591,152703,92208,188252,151168,150017,72451,128652,185438,55087,33572,77182,211268,14507,185437,62983,158327,70468,56717,60585,170218,125837,164463,54191,51090,42778,149244,164461,155126,64900,60776,122319,126283,67844,164076,32867,80951,212668,157298,131595,75452,161901,76283,205378,60040,144637,114709,116691,149240,56747,33186,118289,130437,60583,32930,115795,37949,77816,59368,153202,67266,122316,155247,28517,154735,195399,184018,33121,60710,155245,141046,141002,140315,135552,91305,91241,156523,28165,164451,59303,67264,156650,122314,164578,155243,132609,71803,131009,155242,76598,67263,95843,69181,122313,49392,45268,147998,141239,137025,141175,140474,131404,141088,142088,144915,140938,130079,154154,136189,155069,139980,132007,129803,140925,141059,141039,139968,141143,139385,138963,147923,139298,130897,148044,134897,138938,141029,145278,147941,140398,136183,140163,141226,139328,147951,145415,140997,148092,144997,139319,139988,145020,141043,148075,129836,134884,135947,135939,141286,144987,147562,151719,152568,152360,154148,153928,153898,152290,152359,153658,152552,152542,152545,152548,152795,151870,150583,152682,152681,152397,152465,144644,152323,152567,152448,152553,152555,152414,152291,152756,152556,152464,152712,152361,152566,152794,152416,152415,193655,193650,193654,193653,193679,193678,193677,193675,193674,193652,193684,193680,193682,193686,193647,193644,193645,193648,162248,162245,162241,162253,162251,158706,162254,158531,162243,162247,158632,162244,162246,156709,159087,162290,162252,162250,162249,55466,69820,69756,4092,96609,124166,86251,171095,40583,65851,63502,60941,66151,76084,64977,14745,69066,35362,31698,53270,7690,73042,64993,71486,33030,21354,73780,20220,65011,29929,71381,70356,70027,70025,68288,67437,63766,59072,57157,57156,56921,54879,54741,54423,48632,47841,40725,40625,40165,39209,39208,25064,31239,32633,32335,32206,32158,31851,29582,28363,27707,28302,24368,18362,18375,18376,18406,18359,18357,18360,15714,15666,14559,14565,14505,9158,4779,4777,4710,4269,305,304,148913,75829,218647,218646,218977,148911,142609,149374,148912,142634,150706,148916,134747,148870,134696,148879,148915,189988,62982,175519,47649)) OR (`Idx`=3 AND `CreatureID` IN (105742,111864,33768,49485,50284,165073,111882,105744,105743,175474,166266,71979,115902,197298,43658,207800,205627,113204,111861,202621,99646,144807,171146,44606,42428,72451,91241,164578,152795,134747)) OR (`Idx`=2 AND `CreatureID` IN (105742,111864,59779,33768,49485,50284,165073,111882,105744,105743,175474,166266,71979,70252,115902,70250,197298,33343,43658,77149,207800,205627,113204,111861,59479,202621,99646,144807,171146,44606,124436,42428,72451,91241,164578,152795,148916,134747,47649)) OR (`Idx`=1 AND `CreatureID` IN (105742,111864,65407,59779,33768,49485,33552,50284,173769,165073,110732,55334,99031,56165,115143,111882,105744,156884,105743,175474,173768,173770,173767,205343,118924,164934,120564,155595,166266,71979,70252,52936,71984,115902,70250,135129,184823,59100,157161,197298,33343,205340,205341,205342,205989,90018,43658,205352,137036,53696,77149,207800,146750,98246,205627,201340,73033,68065,113204,111861,59479,99009,202621,104251,198527,102396,99646,78736,68376,58676,144807,171146,71440,173951,44606,103725,122969,173685,124436,42428,72451,33572,77816,91305,91241,164578,152795,152794,162253,162251,162252,162250,162249,55466,69756,86251,40583,40725,40165,218646,149374,148916,134747,47649)) OR (`Idx`=5 AND `CreatureID`=207800) OR (`Idx`=4 AND `CreatureID` IN (207800,152795)); +UPDATE `creature_questitem` SET `VerifiedBuild`=54762 WHERE (`CreatureEntry`=127503 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=127503 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=127503 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=127503 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=131853 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=131853 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=98696 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=99868 AND `DifficultyID`=0 AND `Idx`=6) OR (`CreatureEntry`=99868 AND `DifficultyID`=0 AND `Idx`=5) OR (`CreatureEntry`=99868 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=99868 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=99868 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=99868 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=99868 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=104217 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=156575 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=131318 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=131318 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=131318 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=141800 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=141800 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=165073 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=165073 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=165073 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=164967 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=164967 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=164967 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=164967 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=95833 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=95833 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=95833 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=129208 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=129208 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=129208 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=164218 AND `DifficultyID`=0 AND `Idx`=5) OR (`CreatureEntry`=164218 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=164218 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=164218 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=164218 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=164218 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=141792 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=141792 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=165066 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=162102 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=162102 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=162102 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=116802 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=116802 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=114895 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=166266 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=166266 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=113971 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=95888 AND `DifficultyID`=0 AND `Idx`=7) OR (`CreatureEntry`=95888 AND `DifficultyID`=0 AND `Idx`=6) OR (`CreatureEntry`=95888 AND `DifficultyID`=0 AND `Idx`=5) OR (`CreatureEntry`=95888 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=95888 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=95888 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=95888 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=95888 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=95886 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=197298 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=197774 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=131667 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=131667 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=131667 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=189722 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=201934 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=201934 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=201934 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=115831 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=115831 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=209333 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=209333 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=209333 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=209333 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=209333 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=206689 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=206689 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=206689 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=208478 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=208478 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=208478 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=208478 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=208478 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=142148 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=142148 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=185409 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=185409 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=201320 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=201320 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=201320 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=98949 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=201261 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=201261 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=201261 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=181861 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=181861 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=189340 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=189340 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=189340 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=189340 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=189340 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=186151 AND `DifficultyID`=0 AND `Idx`=6) OR (`CreatureEntry`=186151 AND `DifficultyID`=0 AND `Idx`=5) OR (`CreatureEntry`=186151 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=186151 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=186151 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=186151 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=186151 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=2889 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=2889 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=2889 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=157231 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=164517 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=164517 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=59479 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=157354 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=157354 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=157354 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=157354 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=99200 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=99200 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=99200 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=99200 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=99200 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=28860 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=164255 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=186120 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=157602 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=97084 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=97083 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=97081 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=27483 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=142625 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=142625 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=99891 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=99891 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=99891 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=99891 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=206172 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=206172 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=206172 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=206172 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=206172 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=154638 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=96756 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=155277 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=155277 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=131619 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=131619 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=155275 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=155275 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=122969 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=122969 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=150159 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=150159 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=150159 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=131617 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=131617 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=183406 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=183406 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=183406 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=183406 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=183406 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=96754 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=155273 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=155273 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=131615 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=131615 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=101995 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=98542 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=98542 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=200918 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=200918 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=200918 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=94960 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=94960 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=94960 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=27656 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=188252 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=14507 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=14507 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=185437 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=131595 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=131595 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=130437 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=130437 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=122316 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=122316 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=156523 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=95843 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=122313 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=147998 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=147998 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=137025 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=140474 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=140474 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=131404 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=131404 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=144915 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=144915 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=130079 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=130079 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=154154 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=154154 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=136189 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=136189 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=140925 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=140925 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=141143 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=141143 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=147923 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=147923 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=130897 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=130897 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=130897 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=148044 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=148044 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=134897 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=134897 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=138938 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=138938 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=145278 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=145278 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=147941 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=147941 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=140398 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=140398 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=141226 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=141226 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=147951 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=147951 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=145415 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=145415 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=140997 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=140997 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=148092 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=148092 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=144997 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=144997 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=145020 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=145020 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=141043 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=141043 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=148075 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=148075 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=129836 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=129836 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=135939 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=135939 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=141286 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=141286 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=144987 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=144987 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=147562 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=147562 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=154148 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=154148 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=152359 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=152359 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=152548 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=152556 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=193655 AND `DifficultyID`=0 AND `Idx`=9) OR (`CreatureEntry`=193655 AND `DifficultyID`=0 AND `Idx`=8) OR (`CreatureEntry`=193655 AND `DifficultyID`=0 AND `Idx`=7) OR (`CreatureEntry`=193655 AND `DifficultyID`=0 AND `Idx`=6) OR (`CreatureEntry`=193655 AND `DifficultyID`=0 AND `Idx`=5) OR (`CreatureEntry`=193655 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=193655 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=193655 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=193655 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=193655 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=193650 AND `DifficultyID`=0 AND `Idx`=9) OR (`CreatureEntry`=193650 AND `DifficultyID`=0 AND `Idx`=8) OR (`CreatureEntry`=193650 AND `DifficultyID`=0 AND `Idx`=7) OR (`CreatureEntry`=193650 AND `DifficultyID`=0 AND `Idx`=6) OR (`CreatureEntry`=193650 AND `DifficultyID`=0 AND `Idx`=5) OR (`CreatureEntry`=193650 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=193650 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=193650 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=193650 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=193650 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=193654 AND `DifficultyID`=0 AND `Idx`=10) OR (`CreatureEntry`=193654 AND `DifficultyID`=0 AND `Idx`=9) OR (`CreatureEntry`=193654 AND `DifficultyID`=0 AND `Idx`=8) OR (`CreatureEntry`=193654 AND `DifficultyID`=0 AND `Idx`=7) OR (`CreatureEntry`=193654 AND `DifficultyID`=0 AND `Idx`=6) OR (`CreatureEntry`=193654 AND `DifficultyID`=0 AND `Idx`=5) OR (`CreatureEntry`=193654 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=193654 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=193654 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=193654 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=193654 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=193653 AND `DifficultyID`=0 AND `Idx`=9) OR (`CreatureEntry`=193653 AND `DifficultyID`=0 AND `Idx`=8) OR (`CreatureEntry`=193653 AND `DifficultyID`=0 AND `Idx`=7) OR (`CreatureEntry`=193653 AND `DifficultyID`=0 AND `Idx`=6) OR (`CreatureEntry`=193653 AND `DifficultyID`=0 AND `Idx`=5) OR (`CreatureEntry`=193653 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=193653 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=193653 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=193653 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=193653 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=193677 AND `DifficultyID`=0 AND `Idx`=10) OR (`CreatureEntry`=193677 AND `DifficultyID`=0 AND `Idx`=9) OR (`CreatureEntry`=193677 AND `DifficultyID`=0 AND `Idx`=8) OR (`CreatureEntry`=193677 AND `DifficultyID`=0 AND `Idx`=7) OR (`CreatureEntry`=193677 AND `DifficultyID`=0 AND `Idx`=6) OR (`CreatureEntry`=193677 AND `DifficultyID`=0 AND `Idx`=5) OR (`CreatureEntry`=193677 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=193677 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=193677 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=193677 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=193677 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=193675 AND `DifficultyID`=0 AND `Idx`=10) OR (`CreatureEntry`=193675 AND `DifficultyID`=0 AND `Idx`=9) OR (`CreatureEntry`=193675 AND `DifficultyID`=0 AND `Idx`=8) OR (`CreatureEntry`=193675 AND `DifficultyID`=0 AND `Idx`=7) OR (`CreatureEntry`=193675 AND `DifficultyID`=0 AND `Idx`=6) OR (`CreatureEntry`=193675 AND `DifficultyID`=0 AND `Idx`=5) OR (`CreatureEntry`=193675 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=193675 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=193675 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=193675 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=193675 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=193674 AND `DifficultyID`=0 AND `Idx`=9) OR (`CreatureEntry`=193674 AND `DifficultyID`=0 AND `Idx`=8) OR (`CreatureEntry`=193674 AND `DifficultyID`=0 AND `Idx`=7) OR (`CreatureEntry`=193674 AND `DifficultyID`=0 AND `Idx`=6) OR (`CreatureEntry`=193674 AND `DifficultyID`=0 AND `Idx`=5) OR (`CreatureEntry`=193674 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=193674 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=193674 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=193674 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=193674 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=193652 AND `DifficultyID`=0 AND `Idx`=9) OR (`CreatureEntry`=193652 AND `DifficultyID`=0 AND `Idx`=8) OR (`CreatureEntry`=193652 AND `DifficultyID`=0 AND `Idx`=7) OR (`CreatureEntry`=193652 AND `DifficultyID`=0 AND `Idx`=6) OR (`CreatureEntry`=193652 AND `DifficultyID`=0 AND `Idx`=5) OR (`CreatureEntry`=193652 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=193652 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=193652 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=193652 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=193652 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=193684 AND `DifficultyID`=0 AND `Idx`=10) OR (`CreatureEntry`=193684 AND `DifficultyID`=0 AND `Idx`=9) OR (`CreatureEntry`=193684 AND `DifficultyID`=0 AND `Idx`=8) OR (`CreatureEntry`=193684 AND `DifficultyID`=0 AND `Idx`=7) OR (`CreatureEntry`=193684 AND `DifficultyID`=0 AND `Idx`=6) OR (`CreatureEntry`=193684 AND `DifficultyID`=0 AND `Idx`=5) OR (`CreatureEntry`=193684 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=193684 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=193684 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=193684 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=193684 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=193680 AND `DifficultyID`=0 AND `Idx`=10) OR (`CreatureEntry`=193680 AND `DifficultyID`=0 AND `Idx`=9) OR (`CreatureEntry`=193680 AND `DifficultyID`=0 AND `Idx`=8) OR (`CreatureEntry`=193680 AND `DifficultyID`=0 AND `Idx`=7) OR (`CreatureEntry`=193680 AND `DifficultyID`=0 AND `Idx`=6) OR (`CreatureEntry`=193680 AND `DifficultyID`=0 AND `Idx`=5) OR (`CreatureEntry`=193680 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=193680 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=193680 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=193680 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=193680 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=193682 AND `DifficultyID`=0 AND `Idx`=10) OR (`CreatureEntry`=193682 AND `DifficultyID`=0 AND `Idx`=9) OR (`CreatureEntry`=193682 AND `DifficultyID`=0 AND `Idx`=8) OR (`CreatureEntry`=193682 AND `DifficultyID`=0 AND `Idx`=7) OR (`CreatureEntry`=193682 AND `DifficultyID`=0 AND `Idx`=6) OR (`CreatureEntry`=193682 AND `DifficultyID`=0 AND `Idx`=5) OR (`CreatureEntry`=193682 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=193682 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=193682 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=193682 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=193682 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=193686 AND `DifficultyID`=0 AND `Idx`=10) OR (`CreatureEntry`=193686 AND `DifficultyID`=0 AND `Idx`=9) OR (`CreatureEntry`=193686 AND `DifficultyID`=0 AND `Idx`=8) OR (`CreatureEntry`=193686 AND `DifficultyID`=0 AND `Idx`=7) OR (`CreatureEntry`=193686 AND `DifficultyID`=0 AND `Idx`=6) OR (`CreatureEntry`=193686 AND `DifficultyID`=0 AND `Idx`=5) OR (`CreatureEntry`=193686 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=193686 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=193686 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=193686 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=193686 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=193647 AND `DifficultyID`=0 AND `Idx`=10) OR (`CreatureEntry`=193647 AND `DifficultyID`=0 AND `Idx`=9) OR (`CreatureEntry`=193647 AND `DifficultyID`=0 AND `Idx`=8) OR (`CreatureEntry`=193647 AND `DifficultyID`=0 AND `Idx`=7) OR (`CreatureEntry`=193647 AND `DifficultyID`=0 AND `Idx`=6) OR (`CreatureEntry`=193647 AND `DifficultyID`=0 AND `Idx`=5) OR (`CreatureEntry`=193647 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=193647 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=193647 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=193647 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=193647 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=193644 AND `DifficultyID`=0 AND `Idx`=10) OR (`CreatureEntry`=193644 AND `DifficultyID`=0 AND `Idx`=9) OR (`CreatureEntry`=193644 AND `DifficultyID`=0 AND `Idx`=8) OR (`CreatureEntry`=193644 AND `DifficultyID`=0 AND `Idx`=7) OR (`CreatureEntry`=193644 AND `DifficultyID`=0 AND `Idx`=6) OR (`CreatureEntry`=193644 AND `DifficultyID`=0 AND `Idx`=5) OR (`CreatureEntry`=193644 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=193644 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=193644 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=193644 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=193644 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=193645 AND `DifficultyID`=0 AND `Idx`=10) OR (`CreatureEntry`=193645 AND `DifficultyID`=0 AND `Idx`=9) OR (`CreatureEntry`=193645 AND `DifficultyID`=0 AND `Idx`=8) OR (`CreatureEntry`=193645 AND `DifficultyID`=0 AND `Idx`=7) OR (`CreatureEntry`=193645 AND `DifficultyID`=0 AND `Idx`=6) OR (`CreatureEntry`=193645 AND `DifficultyID`=0 AND `Idx`=5) OR (`CreatureEntry`=193645 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=193645 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=193645 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=193645 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=193645 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=193648 AND `DifficultyID`=0 AND `Idx`=10) OR (`CreatureEntry`=193648 AND `DifficultyID`=0 AND `Idx`=9) OR (`CreatureEntry`=193648 AND `DifficultyID`=0 AND `Idx`=8) OR (`CreatureEntry`=193648 AND `DifficultyID`=0 AND `Idx`=7) OR (`CreatureEntry`=193648 AND `DifficultyID`=0 AND `Idx`=6) OR (`CreatureEntry`=193648 AND `DifficultyID`=0 AND `Idx`=5) OR (`CreatureEntry`=193648 AND `DifficultyID`=0 AND `Idx`=4) OR (`CreatureEntry`=193648 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=193648 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=193648 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=193648 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=162241 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=162241 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=162241 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=162253 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=162253 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=162253 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=162253 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=162251 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=162251 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=162251 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=162251 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=158706 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=162254 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=158531 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=158531 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=162243 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=162243 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=162243 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=162247 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=162247 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=162247 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=158632 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=162244 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=162244 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=162244 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=162246 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=162246 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=162246 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=156709 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=156709 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=156709 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=162252 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=162252 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=162252 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=162252 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=162250 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=162250 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=162250 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=162250 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=162249 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=162249 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=162249 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=162249 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=96609 AND `DifficultyID`=0 AND `Idx`=3) OR (`CreatureEntry`=96609 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=96609 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=96609 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=148913 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=148913 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=148911 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=148911 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=148912 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=148912 AND `DifficultyID`=0 AND `Idx`=0); +UPDATE `creature_quest_currency` SET `VerifiedBuild`=54762 WHERE (`CurrencyId`=1166 AND `CreatureId` IN (29932,39665,52571,53494,56747,59080,59153,74475,74787,75452,75829,76585,77816,81305,94960,95833,95886,95888,96754,96756,98542,98696,98949,99200,99868,101995,104217,113971,114895)) OR (`CurrencyId`=614 AND `CreatureId` IN (55308,55312)) OR (`CurrencyId`=2778 AND `CreatureId` IN (56636,56637,56717,56732,56747,58605,58676,58739,58777,58787,59080,59153,59303,59368,59479,59789,60040,60583,60585,60586,61707,61709,62465,64061,64479,64556,64900,65614,67263,67264,67266,67879,67977,68904,69427,70468,70544,72451,72455,72490,72496,73195)) OR (`CurrencyId`=738 AND `CreatureId` IN (58605,58676,58777,58787,59368,60040,61709,64061,64479,64556,64900,65614,67263,67264,70468,72451,72455,72490,72496,73195)) OR (`CurrencyId`=1275 AND `CreatureId` IN (94960,95833,95886,95888,96754,96756,98542,98696,98949,99200,99868,101995,104217,113971,114895,122313,122316)) OR (`CurrencyId`=1314 AND `CreatureId` IN (95888,114895)) OR (`CurrencyId`=1155 AND `CreatureId` IN (96609,99200,99868,99891,104217,115831,116802)) OR (`CurrencyId`=1553 AND `CreatureId` IN (127503,129803,130079,130897,131404,132007,134069,134884,134897,135939,136160,136183,136189,137025,138938,138963,139298,139319,139328,139385,139968,139980,139988,140398,140925,140938,140997,141029,141039,141043,141059,141088,141143,141175,141226,141239,141286,142088,144644,150583,151719,151870,152290,152291,152323,152359,152360,152361,152397,152414,152415,152416,152448,152464,152465,152542,152545,152548,152552,152553,152555,152556,152566,152567,152568,152681,152682,152712,152756,152794,152795,153658,153898,153928,154148)) OR (`CurrencyId`=1721 AND `CreatureId` IN (144644,150583,151719,151870,152290,152291,152323,152359,152360,152361,152397,152414,152415,152416,152448,152464,152465,152542,152545,152548,152552,152553,152555,152556,152566,152567,152568,152681,152682,152712,152756,152794,152795,153658,153898,153928,154148)) OR (`CurrencyId`=1719 AND `CreatureId` IN (156709,157298,158531,158632,158706,159087,162241,162243,162244,162245,162246,162247,162248,162249,162250,162251,162252,162253,162254,162290)) OR (`CurrencyId`=1816 AND `CreatureId` IN (164218,164557,165408)) OR (`CurrencyId`=1822 AND `CreatureId` IN (164218,164517,165066,175725,181224,183501)) OR (`CurrencyId`=1807 AND `CreatureId`=165066) OR (`CurrencyId`=2009 AND `CreatureId` IN (165066,175725,181224,183501)) OR (`CurrencyId`=1820 AND `CreatureId`=165073) OR (`CurrencyId`=1907 AND `CreatureId`=175725) OR (`CurrencyId`=1982 AND `CreatureId` IN (181224,183501)) OR (`CurrencyId`=2003 AND `CreatureId` IN (181861,185409,185437,186120,186151,188252,189340,189722,191736,193644,193645,193647,193648,193650,193652,193653,193654,193655,193674,193675,193677,193680,193682,193684,193686,197298,197774,202621,206689)) OR (`CurrencyId`=2118 AND `CreatureId` IN (181861,185409,185437,186120,186151,188252,189340,189722,191736,193644,193645,193647,193648,193650,193652,193653,193654,193655,193674,193675,193677,193680,193682,193684,193686,197298,197774)) OR (`CurrencyId`=2122 AND `CreatureId` IN (181861,185409,185437,186120,186151,188252,189340,189722,191736,193644,193645,193647,193648,193650,193652,193653,193654,193655,193674,193675,193677,193680,193682,193684,193686,197298,197774)) OR (`CurrencyId`=2245 AND `CreatureId` IN (186151,193644,193645,193647,193648,193650,193652,193653,193654,193655,193674,193675,193677,193680,193682,193684,193686,200918,201261,201320,201934,206172,208478,209333)) OR (`CurrencyId`=2413 AND `CreatureId` IN (186151,200918,201261,201320,201934)) OR (`CurrencyId`=2774 AND `CreatureId` IN (186151,206172,208478,209333)) OR (`CurrencyId`=2800 AND `CreatureId` IN (186151,200918,201261,201320,201934,206172,208478,209333)) OR (`CurrencyId`=2806 AND `CreatureId` IN (186151,200918,201261,201320,201934,206172,208478,209333)) OR (`CurrencyId`=2807 AND `CreatureId` IN (186151,200918,201261,201320,201934,206172,208478,209333)) OR (`CurrencyId`=2106 AND `CreatureId` IN (193644,193645,193647,193648,193650,193652,193653,193654,193655,193674,193675,193677,193680,193682,193684,193686)) OR (`CurrencyId`=2809 AND `CreatureId` IN (200918,201261,201320,201934,206172,208478,209333)) OR (`CurrencyId`=2812 AND `CreatureId` IN (200918,201261,201320,201934,206172,208478,209333)) OR (`CurrencyId`=3010 AND `CreatureId` IN (200918,201261,201320,201934,206172,208478,209333)) OR (`CurrencyId`=2706 AND `CreatureId` IN (206172,208478,209333)) OR (`CurrencyId`=2707 AND `CreatureId` IN (206172,208478,209333)) OR (`CurrencyId`=2708 AND `CreatureId` IN (206172,208478,209333)) OR (`CurrencyId`=2709 AND `CreatureId` IN (206172,208478,209333)) OR (`CurrencyId`=2780 AND `CreatureId` IN (206172,208478,209333)) OR (`CurrencyId`=2784 AND `CreatureId` IN (206172,208478,209333)) OR (`CurrencyId`=2649 AND `CreatureId`=206689) OR (`CurrencyId`=2650 AND `CreatureId`=206689); + +UPDATE `gameobject_template` SET `VerifiedBuild`=54762 WHERE `entry` IN (276617, 296619, 296059, 281079, 276239, 278406, 276240, 327231, 278405, 278402, 296877, 327230, 276234, 294713, 294712); + +-- cleanup previous sql +DELETE FROM `creature_addon` WHERE `guid` IN(7000374 /*Marla Featherfoot*/, 7000371 /*Handyman Gareth*/, 7000386 /*Sister Alison*/, 7000342 /*Slickbear Osprey*/, 7000363 /*Slickbear Osprey*/, 7000383 /*Slickbear Osprey*/, 7000396 /*Slickbear Osprey*/, 7000397 /*Slickbear Osprey*/); +DELETE FROM `creature_addon` WHERE `guid` IN(7000353 /*Awakened Tidesage*/, 7000359 /*Awakened Tidesage*/, 7000360 /*Awakened Tidesage*/, 7000361 /*Awakened Tidesage*/, 7000345 /*Awakened Tideguard*/, 7000344 /*Awakened Tideguard*/); + +UPDATE `gameobject` SET `phaseUseFlags`=`phaseUseFlags`|0x1 WHERE `guid` IN(@UNPHASED_OGUID+10, @UNPHASED_OGUID+13); -- Stove and Mailbox + +DELETE FROM `gameobject` WHERE `guid`=@OGUID+0; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 294713, 1643, 9042, 9579, '0', 12607, 0, 3342.913330078125, -338.9132080078125, 15.80521011352539062, 2.12057352066040039, 0, 0, 0.872495651245117187, 0.488621890544891357, 120, 255, 1, 54762); -- Chair (Area: Tidecross - Difficulty: 0) CreateObject1 + +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+111; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curHealthPct`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES +(@CGUID+0, 149374, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3365.564208984375, -419.96875, 12.36450576782226562, 0, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- FX Stalker (Area: Tidecross - Difficulty: 0) CreateObject1 +(@CGUID+1, 148911, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3448.19970703125, -415.802337646484375, 7.987992286682128906, 1.076999425888061523, 120, 10, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Tidecross - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+2, 148915, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3424.11376953125, -409.634674072265625, 7.743753433227539062, 5.791848659515380859, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Tidecross - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+5, 148915, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3430.8056640625, -413.7098388671875, 7.437210559844970703, 3.208292484283447265, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Tidecross - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+6, 148916, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3438.3681640625, -393.298614501953125, 6.024278163909912109, 0, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Grasp of the Deep (Area: Tidecross - Difficulty: 0) CreateObject1 +(@CGUID+8, 148915, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3437.263427734375, -407.008941650390625, 7.583593368530273437, 4.673287868499755859, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Tidecross - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+9, 134747, 1643, 9042, 9579, '0', 12607, 0, 0, 1, 3352.244873046875, -342.774322509765625, 16.65855789184570312, 5.851102352142333984, 120, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 54762), -- Tidesage Defector (Area: Tidecross - Difficulty: 0) CreateObject1 (Auras: 247866 - Set Health % (Uses Override Points) (No Health Regen)) +(@CGUID+10, 148911, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3453.452392578125, -425.2725830078125, 6.884391307830810546, 2.85922408103942871, 120, 10, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Tidecross - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+12, 134747, 1643, 9042, 9579, '0', 12607, 0, 0, 1, 3352.390625, -351.68402099609375, 15.71787548065185546, 4.428467273712158203, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Tidesage Defector (Area: Tidecross - Difficulty: 0) CreateObject1 +(@CGUID+14, 148915, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3433.3330078125, -408.333984375, 7.994829654693603515, 4.257474899291992187, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Tidecross - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+15, 148912, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3418.171875, -429.732635498046875, 11.74487781524658203, 5.663686275482177734, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Harbinger (Area: Tidecross - Difficulty: 0) CreateObject1 (Auras: 271028 - Call of the Deep) +(@CGUID+18, 148915, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3428.5751953125, -404.7890625, 7.228157520294189453, 1.4411851167678833, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Tidecross - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+19, 134747, 1643, 9042, 9579, '0', 12607, 0, 0, 1, 3347.98876953125, -343.15972900390625, 16.64837265014648437, 3.745503902435302734, 120, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 54762), -- Tidesage Defector (Area: Tidecross - Difficulty: 0) CreateObject1 (Auras: 247866 - Set Health % (Uses Override Points) (No Health Regen)) +(@CGUID+20, 148915, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3476.511474609375, -454.0804443359375, 6.636890888214111328, 1.032038211822509765, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Tidecross - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+21, 148916, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3501.92529296875, -423.607635498046875, 0.083333335816860198, 0, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Grasp of the Deep (Area: Tidecross - Difficulty: 0) CreateObject1 +(@CGUID+22, 148915, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3470.139892578125, -458.806182861328125, 6.346177577972412109, 4.163447380065917968, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Tidecross - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+23, 148916, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3414.817626953125, -474.27777099609375, 0.083333335816860198, 5.973855972290039062, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Grasp of the Deep (Area: Tidecross - Difficulty: 0) CreateObject1 +(@CGUID+24, 148915, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3475.14892578125, -460.59552001953125, 6.297577857971191406, 3.778400897979736328, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Tidecross - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+25, 148916, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3541.77685546875, -429.342010498046875, 0.083333335816860198, 2.620720386505126953, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Grasp of the Deep (Area: Tidecross - Difficulty: 0) CreateObject1 +(@CGUID+26, 148916, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3539.454833984375, -420.920135498046875, 0.083333335816860198, 4.469449043273925781, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Grasp of the Deep (Area: Tidecross - Difficulty: 0) CreateObject1 +(@CGUID+27, 148915, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3471.353515625, -451.041015625, 6.61063241958618164, 2.131592273712158203, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Tidecross - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+28, 148915, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3469.2197265625, -453.99639892578125, 6.908860206604003906, 1.071720361709594726, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Tidecross - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+29, 148916, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3519.056396484375, -457.8975830078125, 0.083333335816860198, 3.68891143798828125, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Grasp of the Deep (Area: Tidecross - Difficulty: 0) CreateObject1 +(@CGUID+30, 148916, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3504.145751953125, -415.5694580078125, 0.083333335816860198, 2.073617219924926757, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Grasp of the Deep (Area: Tidecross - Difficulty: 0) CreateObject1 +(@CGUID+31, 148913, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3483.6376953125, -419.05633544921875, 6.647120475769042968, 4.705828189849853515, 120, 10, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Umbral Hulk (Area: Tidecross - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+32, 148911, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3480.181396484375, -386.390625, 16.59953498840332031, 4.895256519317626953, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Tidecross - Difficulty: 0) CreateObject1 +(@CGUID+33, 148916, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3445.19091796875, -516.87677001953125, 0.083333335816860198, 4.392369270324707031, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Grasp of the Deep (Area: Tidecross - Difficulty: 0) CreateObject1 +(@CGUID+34, 148915, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3476.0419921875, -451.5625, 6.303946495056152343, 0.506454348564147949, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Tidecross - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+35, 148916, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3497.6171875, -509.180572509765625, 0.083333335816860198, 4.392369270324707031, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Grasp of the Deep (Area: Tidecross - Difficulty: 0) CreateObject1 +(@CGUID+36, 148915, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3468.58056640625, -454.362579345703125, 6.79957437515258789, 1.975586175918579101, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Tidecross - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+37, 148912, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3448.594970703125, -453.8358154296875, 8.082350730895996093, 3.012395143508911132, 120, 10, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Drowned Harbinger (Area: Tidecross - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+38, 148913, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3465.436767578125, -494.201385498046875, 6.572281837463378906, 4.801684856414794921, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Umbral Hulk (Area: Tidecross - Difficulty: 0) CreateObject1 (Auras: 274175 - Channel) +(@CGUID+39, 148916, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3546.921875, -485.78125, 0.083333335816860198, 4.469449043273925781, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Grasp of the Deep (Area: Tidecross - Difficulty: 0) CreateObject1 +(@CGUID+40, 148916, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3545.826416015625, -495.326385498046875, 0.083333335816860198, 0.755925476551055908, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Grasp of the Deep (Area: Tidecross - Difficulty: 0) CreateObject1 +(@CGUID+41, 148911, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3481.3515625, -480.692718505859375, 6.597652912139892578, 1.251629233360290527, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Tidecross - Difficulty: 0) CreateObject1 +(@CGUID+42, 148912, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3488.7587890625, -417.505218505859375, 6.510265350341796875, 6.153154850006103515, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Harbinger (Area: Tidecross - Difficulty: 0) CreateObject1 (Auras: 271028 - Call of the Deep) +(@CGUID+43, 148911, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3483.48876953125, -478.670135498046875, 6.581457138061523437, 3.516422510147094726, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Tidecross - Difficulty: 0) CreateObject1 +(@CGUID+44, 148916, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3586.58935546875, -440.692718505859375, 4.92404937744140625, 5.117872238159179687, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Grasp of the Deep (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+45, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3503.346435546875, -382.71527099609375, 6.314236164093017578, 2.076563596725463867, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+46, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3501.3212890625, -382.951385498046875, 6.314236164093017578, 1.522756099700927734, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+47, 148912, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3502.02001953125, -380.298614501953125, 6.353076934814453125, 4.913446903228759765, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Harbinger (Area: Port Fogtide - Difficulty: 0) CreateObject1 (Auras: 264940 - Call of the Abyss) +(@CGUID+48, 148912, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3518.057373046875, -382.145843505859375, 16.6903228759765625, 5.557717323303222656, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Harbinger (Area: Port Fogtide - Difficulty: 0) CreateObject1 (Auras: 271028 - Call of the Deep) +(@CGUID+49, 148912, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3511.760009765625, -393.205108642578125, 6.56809234619140625, 3.169427871704101562, 120, 10, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Drowned Harbinger (Area: Port Fogtide - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+50, 148916, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3643.287353515625, -444.302093505859375, 13.41114711761474609, 1.741947054862976074, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Grasp of the Deep (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+51, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3535.467041015625, -381.482635498046875, 6.5042572021484375, 3.38532423973083496, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+52, 148916, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3614.1328125, -446.239593505859375, 5.572735786437988281, 3.688911676406860351, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Grasp of the Deep (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+53, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3588.827392578125, -396.3104248046875, 16.89543533325195312, 2.452473163604736328, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+54, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3581.157958984375, -396.517364501953125, 16.60230827331542968, 1.272322416305541992, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+55, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3574.807861328125, -508.04095458984375, 0.140679240226745605, 2.688588857650756835, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+56, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3571.8662109375, -514.0341796875, 0.139411062002182006, 4.452610492706298828, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+57, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3584.389404296875, -401.960784912109375, 16.60230827331542968, 0.484660476446151733, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+58, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3550.857666015625, -450.588531494140625, 0.572025537490844726, 5.982308387756347656, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+59, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3552.41064453125, -451.859375, 0.572025537490844726, 1.842507481575012207, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+60, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3532.62158203125, -380.751739501953125, 6.504252433776855468, 5.650117874145507812, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+61, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3587.210205078125, -407.20233154296875, 16.60230827331542968, 0.62401658296585083, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+62, 148912, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3548.15966796875, -425.46875, 0.804541826248168945, 3.159037113189697265, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Harbinger (Area: Port Fogtide - Difficulty: 0) CreateObject1 (Auras: 271028 - Call of the Deep) +(@CGUID+63, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3585.149658203125, -397.08575439453125, 16.62926864624023437, 4.154784202575683593, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+64, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3581.771484375, -402.083984375, 16.60230827331542968, 2.413240671157836914, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+65, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3573.758056640625, -510.308380126953125, 0.139699935913085937, 3.615733861923217773, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+66, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3553.365478515625, -381.677093505859375, 16.15038490295410156, 5.29509592056274414, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+67, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3555.361083984375, -381.888885498046875, 16.15038490295410156, 4.303819656372070312, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+68, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3577.06201171875, -509.042449951171875, 0.139835238456726074, 1.526866436004638671, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+69, 148916, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3620.318603515625, -526.9930419921875, 6.323585987091064453, 0.668976485729217529, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Grasp of the Deep (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+70, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3572.785888671875, -519.0941162109375, 0.139620363712310791, 4.914678096771240234, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+71, 148912, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3556.494873046875, -490.89410400390625, 0.552253782749176025, 3.147835016250610351, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Harbinger (Area: Port Fogtide - Difficulty: 0) CreateObject1 (Auras: 271028 - Call of the Deep) +(@CGUID+72, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3600.320556640625, -428.0457763671875, 5.454006195068359375, 1.953807353973388671, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+73, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3576.97314453125, -520.248779296875, 0.140257239341735839, 4.400138378143310546, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+74, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3586.9697265625, -465.11285400390625, 6.74224853515625, 5.254476547241210937, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+75, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3589.315185546875, -466.880218505859375, 6.742248058319091796, 2.989683866500854492, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+76, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3604.2548828125, -426.458038330078125, 5.454006195068359375, 1.954077363014221191, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+77, 148912, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3601.493896484375, -425.28472900390625, 5.454006195068359375, 1.954361438751220703, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Harbinger (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+78, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3625.671142578125, -413.24652099609375, 15.79984664916992187, 2.259026288986206054, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+79, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3674.66943359375, -453.36328125, 21.65297508239746093, 0.31341138482093811, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+80, 148913, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3648.404541015625, -506.484375, 6.671468257904052734, 2.981900930404663085, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Umbral Hulk (Area: Port Fogtide - Difficulty: 0) CreateObject1 (Auras: 274175 - Channel) +(@CGUID+81, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3597.634521484375, -492.416656494140625, 0.381497621536254882, 6.235125541687011718, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+82, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3625.328125, -411.217010498046875, 15.79984664916992187, 2.430947303771972656, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+83, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3627.9296875, -413.51910400390625, 15.79984664916992187, 2.503057718276977539, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+84, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3666.30224609375, -453.252532958984375, 20.22124290466308593, 2.447956800460815429, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+85, 148912, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3620.88720703125, -407.236114501953125, 22.62500572204589843, 5.694407939910888671, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Harbinger (Area: Port Fogtide - Difficulty: 0) CreateObject1 (Auras: 264940 - Call of the Abyss) +(@CGUID+86, 148913, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3570.567626953125, -543.467041015625, 0.600516140460968017, 4.684421062469482421, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Umbral Hulk (Area: Port Fogtide - Difficulty: 0) CreateObject1 (Auras: 274175 - Channel) +(@CGUID+87, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3626.536376953125, -409.576385498046875, 15.79984664916992187, 2.766130685806274414, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+88, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3670.82373046875, -457.756683349609375, 20.83261680603027343, 0.843264758586883544, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+89, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3597.869873046875, -494.442718505859375, 0.381496667861938476, 0.505746543407440185, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+90, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3629.10498046875, -409.451385498046875, 15.79984664916992187, 2.889693737030029296, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+91, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3671.871826171875, -461.073486328125, 19.60461235046386718, 1.637911796569824218, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+92, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3627.60498046875, -411.548614501953125, 15.79984664916992187, 2.585329055786132812, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+93, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3670.387451171875, -455.313446044921875, 21.15402984619140625, 4.057841300964355468, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+94, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3620.320068359375, -420.285919189453125, 5.454006195068359375, 2.47154855728149414, 120, 10, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+95, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3665.569580078125, -456.939239501953125, 19.67727851867675781, 2.875813007354736328, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+96, 148912, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3600.287353515625, -493.1163330078125, 0.381493151187896728, 3.342629909515380859, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Harbinger (Area: Port Fogtide - Difficulty: 0) CreateObject1 (Auras: 264940 - Call of the Abyss) +(@CGUID+97, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3650.890625, -428.302093505859375, 16.17822074890136718, 3.904781579971313476, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+98, 148912, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3619.66064453125, -488.494781494140625, 6.664469718933105468, 3.339392423629760742, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Harbinger (Area: Port Fogtide - Difficulty: 0) CreateObject1 (Auras: 271028 - Call of the Deep) +(@CGUID+99, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3636.372314453125, -456.503204345703125, 9.682898521423339843, 4.262720584869384765, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+100, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3649.834228515625, -426.461822509765625, 16.17822074890136718, 4.025083065032958984, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+101, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3661.249267578125, -546.741455078125, 9.779524803161621093, 2.194059133529663085, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+102, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3664.1015625, -553.13580322265625, 8.903179168701171875, 3.132960796356201171, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+103, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3661.893310546875, -542.74884033203125, 9.757716178894042968, 1.375940680503845214, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+104, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3660.61962890625, -544.85357666015625, 9.842406272888183593, 6.201165676116943359, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+105, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3625.22998046875, -516.8038330078125, 6.42628335952758789, 0.669945478439331054, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+106, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3668.807373046875, -542.90435791015625, 9.435515403747558593, 5.357151031494140625, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+107, 148915, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3659.380126953125, -541.81048583984375, 9.630007743835449218, 0.846104085445404052, 120, 5, 0, 100, 1, NULL, NULL, NULL, NULL, 54762), -- Corrupted Waters (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+108, 148911, 1643, 9042, 9578, '0', 12607, 0, 0, 0, 3654.741455078125, -483.520843505859375, 7.53641510009765625, 5.825610160827636718, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Drowned Convert (Area: Port Fogtide - Difficulty: 0) CreateObject1 +(@CGUID+109, 142609, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3345.7041015625, -340.84027099609375, 15.88854312896728515, 0.272221922874450683, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Handyman Gareth (Area: Tidecross - Difficulty: 0) CreateObject1 +(@CGUID+110, 134696, 1643, 9042, 9579, '0', 12607, 0, 0, 1, 3346.368896484375, -378.435760498046875, 18.62731361389160156, 1.479342818260192871, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762), -- Marla Featherfoot (Area: Tidecross - Difficulty: 0) CreateObject1 +(@CGUID+111, 142634, 1643, 9042, 9579, '0', 12607, 0, 0, 0, 3335.232666015625, -372.78125, 13.08397769927978515, 1.577361583709716796, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54762); -- Sister Alison (Area: Tidecross - Difficulty: 0) CreateObject1 + +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+111; +INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+0, 0, 0, 0, 0, 0, 1, 0, 0, 9099, 0, 0, 0, ''), -- FX Stalker +(@CGUID+9, 0, 0, 3, 0, 0, 1, 0, 0, 0, 0, 0, 0, '247866'), -- Tidesage Defector - 247866 - Set Health % (Uses Override Points) (No Health Regen) +(@CGUID+12, 0, 0, 0, 0, 0, 0, 0, 720, 0, 0, 0, 0, ''), -- Tidesage Defector +(@CGUID+19, 0, 0, 3, 0, 0, 1, 0, 0, 0, 0, 0, 0, '247866'), -- Tidesage Defector - 247866 - Set Health % (Uses Override Points) (No Health Regen) +(@CGUID+38, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '274175'), -- Umbral Hulk - 274175 - Channel +(@CGUID+45, 0, 0, 0, 0, 0, 1, 0, 0, 12698, 0, 0, 0, ''), -- Drowned Convert +(@CGUID+46, 0, 0, 0, 0, 0, 1, 0, 0, 12698, 0, 0, 0, ''), -- Drowned Convert +(@CGUID+78, 0, 0, 0, 0, 0, 1, 0, 0, 12698, 0, 0, 0, ''), -- Drowned Convert +(@CGUID+80, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '274175'), -- Umbral Hulk - 274175 - Channel +(@CGUID+81, 0, 0, 0, 0, 0, 1, 0, 0, 12698, 0, 0, 0, ''), -- Drowned Convert +(@CGUID+82, 0, 0, 0, 0, 0, 1, 0, 0, 12698, 0, 0, 0, ''), -- Drowned Convert +(@CGUID+83, 0, 0, 0, 0, 0, 1, 0, 0, 12698, 0, 0, 0, ''), -- Drowned Convert +(@CGUID+86, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '274175'), -- Umbral Hulk - 274175 - Channel +(@CGUID+87, 0, 0, 0, 0, 0, 1, 0, 0, 12698, 0, 0, 0, ''), -- Drowned Convert +(@CGUID+89, 0, 0, 0, 0, 0, 1, 0, 0, 12698, 0, 0, 0, ''), -- Drowned Convert +(@CGUID+90, 0, 0, 0, 0, 0, 1, 0, 0, 12698, 0, 0, 0, ''), -- Drowned Convert +(@CGUID+92, 0, 0, 0, 0, 0, 1, 0, 0, 12698, 0, 0, 0, ''); -- Drowned Convert + +SET @MOVERGUID := @CGUID+31; +SET @ENTRY := 148913; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES +(@PATH, 0, 0, 'Umbral Hulk - Patrol'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 3486.382, -430.1076, 6.578022, NULL, 0), +(@PATH, 1, 3487.556, -452.5955, 6.672251, NULL, 6701), +(@PATH, 2, 3486.382, -430.1076, 6.578022, NULL, 0), +(@PATH, 3, 3483.614, -422.7014, 6.617488, NULL, 0), +(@PATH, 4, 3483.675, -413.4358, 6.692812, NULL, 0), +(@PATH, 5, 3484.338, -406.3472, 6.651923, NULL, 0), +(@PATH, 6, 3490.424, -401.4184, 6.541029, NULL, 0), +(@PATH, 7, 3498.718, -397.467, 6.372591, NULL, 0), +(@PATH, 8, 3510.837, -395.4288, 6.608435, NULL, 0), +(@PATH, 9, 3524.405, -396.507, 6.677318, NULL, 0), +(@PATH, 10, 3531.121, -397.4375, 6.592887, NULL, 0), +(@PATH, 11, 3535.847, -398.0156, 6.536415, NULL, 0), +(@PATH, 12, 3540.012, -398.4167, 6.415902, NULL, 0), +(@PATH, 13, 3543.926, -399.2413, 5.983494, NULL, 0), +(@PATH, 14, 3547.694, -401.0677, 5.230433, NULL, 0), +(@PATH, 15, 3549.72, -403.724, 4.411039, NULL, 0), +(@PATH, 16, 3551.854, -409.8177, 2.291289, NULL, 0), +(@PATH, 17, 3552.703, -415.816, 0.7441018, NULL, 0), +(@PATH, 18, 3555.513, -434.0642, 0.5364151, NULL, 0), +(@PATH, 19, 3558.082, -440.3351, 0.5364151, NULL, 0), +(@PATH, 20, 3564.084, -446.5695, 0.3616545, NULL, 0), +(@PATH, 21, 3567.521, -451.5556, 0.1394176, NULL, 0), +(@PATH, 22, 3570.45, -458.0278, 0.1394174, NULL, 0), +(@PATH, 23, 3570.677, -467.1146, 0.1394157, NULL, 0), +(@PATH, 24, 3571.771, -486.2292, 0.1401059, NULL, 5544), +(@PATH, 25, 3570.677, -467.1146, 0.1394157, NULL, 0), +(@PATH, 26, 3570.45, -458.0278, 0.1394174, NULL, 0), +(@PATH, 27, 3567.521, -451.5556, 0.1394176, NULL, 0), +(@PATH, 28, 3564.084, -446.5695, 0.3616545, NULL, 0), +(@PATH, 29, 3558.082, -440.3351, 0.5364151, NULL, 0), +(@PATH, 30, 3555.513, -434.0642, 0.5364151, NULL, 0), +(@PATH, 31, 3552.703, -415.816, 0.7441018, NULL, 0), +(@PATH, 32, 3551.854, -409.8177, 2.291289, NULL, 0), +(@PATH, 33, 3549.72, -403.724, 4.411039, NULL, 0), +(@PATH, 34, 3547.694, -401.0677, 5.230433, NULL, 0), +(@PATH, 35, 3543.926, -399.2413, 5.983494, NULL, 0), +(@PATH, 36, 3540.012, -398.4167, 6.415902, NULL, 0), +(@PATH, 37, 3535.847, -398.0156, 6.536415, NULL, 0), +(@PATH, 38, 3531.121, -397.4375, 6.592887, NULL, 0), +(@PATH, 39, 3524.405, -396.507, 6.677318, NULL, 0), +(@PATH, 40, 3510.837, -395.4288, 6.608435, NULL, 0), +(@PATH, 41, 3498.718, -397.467, 6.372591, NULL, 0), +(@PATH, 42, 3490.424, -401.4184, 6.541029, NULL, 0), +(@PATH, 43, 3484.338, -406.3472, 6.651923, NULL, 0), +(@PATH, 44, 3483.675, -413.4358, 6.692812, NULL, 0), +(@PATH, 45, 3483.614, -422.7014, 6.617488, NULL, 0); + +UPDATE `creature` SET `position_x`= 3486.382, `position_y`= -430.1076, `position_z`= 6.578022, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`= @MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +SET @MOVERGUID := @CGUID+37; +SET @ENTRY := 148912; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0, NULL, 'Drowned Harbinger - Patrol'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 3442.168, -453.0556, 8.88372, NULL, 0), +(@PATH, 1, 3433.097, -453.2222, 10.16915, NULL, 0), +(@PATH, 2, 3427.191, -452.6545, 10.79503, NULL, 0), +(@PATH, 3, 3422.698, -451.151, 10.87794, NULL, 6797), +(@PATH, 4, 3427.191, -452.6545, 10.79503, NULL, 0), +(@PATH, 5, 3433.097, -453.2222, 10.16915, NULL, 0), +(@PATH, 6, 3442.168, -453.0556, 8.88372, NULL, 0), +(@PATH, 7, 3445.714, -453.4653, 8.419151, NULL, 0), +(@PATH, 8, 3456.563, -454.8715, 7.267377, NULL, 0), +(@PATH, 9, 3461.215, -458.4879, 6.851295, NULL, 0), +(@PATH, 10, 3466.98, -465.2899, 6.281713, NULL, 0), +(@PATH, 11, 3478.676, -478.0121, 6.219222, NULL, 7261), +(@PATH, 12, 3466.98, -465.2899, 6.281713, NULL, 0), +(@PATH, 13, 3461.215, -458.4879, 6.851295, NULL, 0), +(@PATH, 14, 3456.563, -454.8715, 7.267377, NULL, 0), +(@PATH, 15, 3445.714, -453.4653, 8.419151, NULL, 0); + +UPDATE `creature` SET `position_x`=3442.168, `position_y`=-453.0556, `position_z`=8.88372, `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +SET @MOVERGUID := @CGUID+49; +SET @ENTRY := 148912; +SET @PATHOFFSET := 1; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0, NULL, 'Drowned Harbinger - Patrol 1'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 3485.125, -395.6545, 6.324142, NULL, 5844), +(@PATH, 1, 3494.936, -393.6736, 6.496639, NULL, 0), +(@PATH, 2, 3515.01, -393.1146, 6.536415, NULL, 0), +(@PATH, 3, 3538.054, -391.7882, 6.536415, NULL, 7810), +(@PATH, 4, 3515.01, -393.1146, 6.536415, NULL, 0), +(@PATH, 5, 3494.936, -393.6736, 6.496639, NULL, 0); + +UPDATE `creature` SET `position_x`=3485.125, `position_y`=-395.6545, `position_z`=6.324142, `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +SET @MOVERGUID := @CGUID+77; +SET @ENTRY := 148912; +SET @PATHOFFSET := 2; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0, NULL, 'Drowned Harbinger - Patrol 2'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 3603.43, -430.0816, 5.454015, NULL, 0), +(@PATH, 1, 3602.587, -435.5851, 5.458654, NULL, 0), +(@PATH, 2, 3601.346, -440.1719, 5.465244, NULL, 0), +(@PATH, 3, 3599.982, -446.3351, 5.675014, NULL, 0), +(@PATH, 4, 3601.011, -451.2066, 5.982798, NULL, 0), +(@PATH, 5, 3603.968, -455.934, 6.28244, NULL, 0), +(@PATH, 6, 3606.841, -459.6858, 6.552619, NULL, 0), +(@PATH, 7, 3611.72, -464.4392, 6.578382, NULL, 0), +(@PATH, 8, 3614.392, -466.8507, 6.581097, NULL, 6621), +(@PATH, 9, 3606.841, -459.6858, 6.552619, NULL, 0), +(@PATH, 10, 3603.968, -455.934, 6.28244, NULL, 0), +(@PATH, 11, 3601.011, -451.2066, 5.982798, NULL, 0), +(@PATH, 12, 3599.982, -446.3351, 5.675014, NULL, 0), +(@PATH, 13, 3601.346, -440.1719, 5.465244, NULL, 0), +(@PATH, 14, 3602.587, -435.5851, 5.458654, NULL, 0), +(@PATH, 15, 3603.43, -430.0816, 5.454015, NULL, 0), +(@PATH, 16, 3601.494, -425.2847, 5.454006, NULL, 6398); + +UPDATE `creature` SET `position_x`=3603.43, `position_y`=-430.0816, `position_z`=5.454015, `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=@MOVERGUID; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(@MOVERGUID, @MOVERGUID, 0, 0, 515, 0, 0), +(@MOVERGUID, @CGUID+76, 3, 315, 515, 0, 0), +(@MOVERGUID, @CGUID+72, 3, 45, 515, 0, 0); + +SET @MOVERGUID := @CGUID+94; +SET @ENTRY := 148911; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0, NULL, 'Drowned Convert - Patrol'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 3622.667, -422.1458, 5.454006, NULL, 6486), +(@PATH, 1, 3611.716, -413.4688, 5.454006, NULL, 6654); + +UPDATE `creature` SET `position_x`=3622.667, `position_y`=-422.1458, `position_z`=5.454006, `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +SET @MOVERGUID := @CGUID+108; +SET @ENTRY := 148911; +SET @PATHOFFSET := 1; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0, NULL, 'Drowned Convert - Patrol 1'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 3646.755, -479.5878, 7.627628, NULL, 6189), +(@PATH, 1, 3654.741, -483.5208, 7.536415, NULL, 7295); + +UPDATE `creature` SET `position_x`=3646.755, `position_y`=-479.5878, `position_z`=7.627628, `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +SET @MOVERGUID := @CGUID+105; +SET @ENTRY := 148911; +SET @PATHOFFSET := 2; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0, NULL, 'Drowned Convert - Patrol 2'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 3621.039, -520.1146, 6.094358, NULL, 0), +(@PATH, 1, 3613.695, -523.2871, 5.133794, NULL, 0), +(@PATH, 2, 3606.798, -525.4323, 3.980617, NULL, 0), +(@PATH, 3, 3600.898, -525.382, 2.982262, NULL, 0), +(@PATH, 4, 3595.688, -524.1059, 2.063748, NULL, 0), +(@PATH, 5, 3590.925, -522.0729, 1.078846, NULL, 0), +(@PATH, 6, 3586.143, -519.5, 0.4526107, NULL, 7055), +(@PATH, 7, 3590.925, -522.0729, 1.078846, NULL, 0), +(@PATH, 8, 3595.688, -524.1059, 2.063748, NULL, 0), +(@PATH, 9, 3600.898, -525.382, 2.982262, NULL, 0), +(@PATH, 10, 3606.798, -525.4323, 3.980617, NULL, 0), +(@PATH, 11, 3613.663, -523.2952, 5.076515, NULL, 0), +(@PATH, 12, 3621.039, -520.1146, 6.094358, NULL, 0), +(@PATH, 13, 3625.23, -516.8038, 6.426283, NULL, 7033); + +UPDATE `creature` SET `position_x`=3621.039, `position_y`=-520.1146, `position_z`=6.094358, `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +SET @MOVERGUID := @CGUID+99; +SET @ENTRY := 148911; +SET @PATHOFFSET := 3; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0, NULL, 'Drowned Convert - Patrol 3'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 3631.347, -464.1927, 7.994929, NULL, 0), +(@PATH, 1, 3627.323, -468.0208, 7.068693, NULL, 6123), +(@PATH, 2, 3631.347, -464.1927, 7.994929, NULL, 0), +(@PATH, 3, 3635.127, -459.0851, 9.153891, NULL, 0), +(@PATH, 4, 3637.539, -454.0851, 10.26638, NULL, 0), +(@PATH, 5, 3637.977, -448.6111, 11.71906, NULL, 0), +(@PATH, 6, 3638.346, -442.6389, 13.06978, NULL, 0), +(@PATH, 7, 3639.938, -438.5191, 13.96375, NULL, 5757), +(@PATH, 8, 3638.346, -442.6389, 13.06978, NULL, 0), +(@PATH, 9, 3637.977, -448.6111, 11.71906, NULL, 0), +(@PATH, 10, 3637.539, -454.0851, 10.26638, NULL, 0), +(@PATH, 11, 3635.127, -459.0851, 9.153891, NULL, 0); + +UPDATE `creature` SET `position_x`=3631.347, `position_y`=-464.1927, `position_z`=7.994929, `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +SET @MOVERGUID := @CGUID+10; +SET @ENTRY := 148911; +SET @PATHOFFSET := 4; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0, NULL, 'Drowned Convert - Patrol 4'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 3462.529, -421.7396, 6.29723, NULL, 0), +(@PATH, 1, 3466.652, -418.066, 6.228662, NULL, 0), +(@PATH, 2, 3470.368, -411.8941, 6.247163, NULL, 0), +(@PATH, 3, 3472.653, -407.1788, 6.246072, NULL, 0), +(@PATH, 4, 3474.062, -402.8941, 6.224865, NULL, 7296), +(@PATH, 5, 3472.653, -407.1788, 6.246072, NULL, 0), +(@PATH, 6, 3470.368, -411.8941, 6.247163, NULL, 0), +(@PATH, 7, 3466.652, -418.066, 6.228662, NULL, 0), +(@PATH, 8, 3462.529, -421.7396, 6.29723, NULL, 0), +(@PATH, 9, 3456.827, -426.2517, 6.783375, NULL, 0), +(@PATH, 10, 3453.452, -425.2726, 6.884391, NULL, 7340); + +UPDATE `creature` SET `position_x`=3462.529, `position_y`=-421.7396, `position_z`=6.29723, `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +SET @MOVERGUID := @CGUID+1; +SET @ENTRY := 148911; +SET @PATHOFFSET := 5; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0, NULL, 'Drowned Convert - Patrol 5'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 3443.961, -423.6771, 7.942665, NULL, 7381), +(@PATH, 1, 3448.2, -415.8023, 7.987992, NULL, 6190); + +UPDATE `creature` SET `position_x`=3443.961, `position_y`=-423.6771, `position_z`=7.942665, `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +SET @ENTRY := 148912; +UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` IN(@ENTRY); +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(@ENTRY, 0, 0, 0, '', 25, 0, 100, 0, 0, 0, 0, 0, 11, 264940, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On reset - Self: Cast spell Call of the Abyss 264940 on Self'), +(@ENTRY, 0, 1, 0, '', 25, 0, 100, 0, 0, 0, 0, 0, 11, 271028, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On reset - Self: Cast spell Call of the Deep 271028 on Self'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 22 AND `SourceGroup` IN(1, 2) AND `SourceEntry` = @ENTRY; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `Comment`) VALUES +(22, 1, @ENTRY, 0, 0, 58, 1, 0, 0, 0, 'abyss', 0, 'Scripted creature has StringId ''abyss'''), +(22, 2, @ENTRY, 0, 0, 58, 1, 0, 0, 0, 'deep', 0, 'Scripted creature has StringId ''deep'''); + +UPDATE `creature` SET `StringId`='abyss' WHERE `guid` IN(@CGUID+47, @CGUID+85, @CGUID+96); +UPDATE `creature` SET `StringId`='deep' WHERE `guid` IN(@CGUID+15, @CGUID+42, @CGUID+48, @CGUID+62, @CGUID+71, @CGUID+98); |