rendered paste body-- Fix made by Silence.Sys and Yas-- Forgotten Sanctuary Server-- Mangos DatabaseUPDATE `creature_template` SET Faction_A=35, Faction_H=35 WHERE entry IN("23489","23139","23140","22253","23291","23141","22274","22433");UPDATE creature_template SET modelid_A=21274, modelid_H=21274 WHERE entry="23139";DELETE FROM `spell_script_target` WHERE entry=38762;INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES (38762, 1, 21722);DELETE FROM `quest_template` WHERE entry="10854";INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqSourceRef1`, `ReqSourceRef2`, `ReqSourceRef3`, `ReqSourceRef4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (10854, 3520, 62, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 136, 0, 10837, 0, 0, 10858, 31652, 1, 0, 'The Force of Neltharaku', 'Take this enchanted nethervine crystal and make your way back to Dragonmaw Fortress. Once there, seek out the enslaved drakes and invoke the magic of the nethervine crystal. My own energies will pour forth, causing the drakes to break free from the bond of their captors. When you see that the drake has broken free, help it defeat its captor! It will most assuredly be weak from the imprisonment.$B$BRelease all that you can find and return to me, $N.', 'Netharaku, flying high above Netherwing Fields in Shadowmoon Valley, wants you to free 5 Enslaved Netherwing Drakes.', '<Neltharaku laughs.>$B$BThe orcs must have been shocked to see the drakes turn on them in such a manner. Well done, $N. Perhaps you truly are the hero of our flight.', 'Waste no time, we have much work to do!', '', 'Enslaved Netherwing Drake freed', '', '', '', 0, 0, 0, 31652, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21722, 0, 0, 0, 5, 0, 0, 0, 38762, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 75900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);DELETE FROM `creature_template` WHERE entry=21722;INSERT INTO `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `civilian`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `ScriptName`) VALUES (21722, 19980, 0, 19980, 0, 'Enslaved Netherwing Drake', '', 69, 69, 4086, 4086, 0, 0, 20, 62, 62, 0, 1.48, 0, 0, 19, 60, 0, 278, 2000, 0, 32768, 0, 0, 0, 0, 0, 0, 0, 0, 100, 2, 0, 0, 21722, 0, 21722, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 3, 0, 1, 0, 0, '');DELETE FROM `quest_template` WHERE entry=10804;INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqSourceRef1`, `ReqSourceRef2`, `ReqSourceRef3`, `ReqSourceRef4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (10804, 3520, 70, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 136, 0, 0, 0, 0, 10811, 0, 0, 0, 'Kindness', 'Something has them spooked, $r.$B$B<Mordenai points to the nether drakes flying overhead.>$B$BThey won\'t even come down to feed. I have seen several fall to the earth, dead from exhaustion before their bodies hit the ground.$B$BWe must save them! The Rocknail flayers that are found near the crystals are their natural prey. Kill flayers and take their carcasses. Place a carcass in the field and stand extremely still. As long as you do not make any aggressive motions, they will not attack you.', 'Mordenai at Netherwing Fields in Shadowmoon Valley wants you to feed 8 Mature Netherwing Drakes.', 'You are a kind and compassionate $R, friend.', 'I cannot save them by myself, $N!', '', 'Mature Netherwing Drake fed', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21648, 0, 0, 0, 8, 0, 0, 0, 38439, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 75900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);DELETE DROM `gameobject` WHERE id=185915;INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (185915, 530, -5046.166504, 633.327515, 86.501152, 0, 0, 0, 0, 0, 3600, 0, 1);INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (185915, 530, -5006.355957, 712.023865, 82.466621, 0, 0, 0, 0, 0, 3600, 0, 1);INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (185915, 530, -4965.925293, 722.382751, 74.904083, 0, 0, 0, 0, 0, 3600, 0, 1);INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (185915, 530, -4928.299805, 700.212219, 70.563629, 0, 0, 0, 0, 0, 3600, 0, 1);INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (185915, 530, -4908.101563, 706.891052, 71.183426, 0, 0, 0, 0, 0, 3600, 0, 1);INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (185915, 530, -4894.133789, 532.843689, 48.100388, 0, 0, 0, 0, 0, 3600, 0, 1);INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (185915, 530, -4982.105957, 505.234558, 83.747704, 0, 0, 0, 0, 0, 3600, 0, 1);INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (185915, 530, -5036.351563, 448.925629, 85.923676, 0, 0, 0, 0, 0, 3600, 0, 1);INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (185915, 530, -5133.783203, 459.485352, 77.274574, 0, 0, 0, 0, 0, 3600, 0, 1);INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (185915, 530, -5300.918945, 385.069916, 45.738930, 0, 0, 0, 0, 0, 3600, 0, 1);INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (185915, 530, -5313.437988, 388.214142, 42.960541, 0, 0, 0, 0, 0, 3600, 0, 1);INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (185915, 530, -5166.408691, -35.317333, 76.411545, 0, 0, 0, 0, 0, 3600, 0, 1);INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (185915, 530, -5055.169922, 164.784637, 131.919662, 0, 0, 0, 0, 0, 3600, 0, 1);INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (185915, 530, -5042.232910, 390.943939, 170.662506, 0, 0, 0, 0, 0, 3600, 0, 1);INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (185915, 530, -4251.131348, 569.756714, 36.520088, 0, 0, 0, 0, 0, 3600, 0, 1);INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (185915, 530, -4040.998535, 647.220215, 11.413628, 0, 0, 0, 0, 0, 3600, 0, 1);INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (185915, 530, -4270.022461, 744.713135, 69.169479, 0, 0, 0, 0, 0, 3600, 0, 1);INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (185915, 530, -5164.490234, 613.386658, 36.362991, 0, 0, 0, 0, 0, 3600, 0, 1);INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (185915, 530, -4863.710938, 527.598145, -2.472625, 0, 0, 0, 0, 0, 3600, 0, 1);INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (185915, 530, -5177.727539, 416.841980, -10.040807, 0, 0, 0, 0, 0, 3600, 0, 1);INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (185915, 530, -5074.993652, 502.839386, -9.833471, 0, 0, 0, 0, 0, 3600, 0, 1);DELETE FROM `gameobject_loot_template` WHERE (`entry`=22116) AND (`item`=32506);INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrRef`, `QuestChanceOrGroup`, `mincount`, `maxcount`, `freeforall`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (22116, 32506, 100, 100, 1, 1, 0, 0, 0, 0);DELETE FROM `creature_loot_template` WHERE (`entry`=23188) AND (`item`=32509);INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrRef`, `QuestChanceOrGroup`, `mincount`, `maxcount`, `freeforall`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (23188, 32509, 44, 0, 1, 2, 0, 0, 0, 0);DELETE FROM `creature` WHERE id=23188;INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23188, 530, 0, 0, -5129.208496, 665.918762, 71.294724, 5.402382, 120, 0, 0, 5129.208496, 665.918762, 71.294724, 5.402382, 7200, 3155, 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23188, 530, 0, 0, -5263.947754, 535.761169, 37.448822, 4.671960, 120, 0, 0, 5129.208496, 665.918762, 71.294724, 5.402382, 7200, 3155, 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23188, 530, 0, 0, -5173.366797, 402.522980, 73.737633, 3.800167, 120, 0, 0, 5129.208496, 665.918762, 71.294724, 5.402382, 7200, 3155, 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23188, 530, 0, 0, -5206.614258, 266.145569, 70.927269, 4.561219, 120, 0, 0, 5129.208496, 665.918762, 71.294724, 5.402382, 7200, 3155, 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23188, 530, 0, 0, -4853.199219, 418.139465, 59.407196, 2.208949, 120, 0, 0, 5129.208496, 665.918762, 71.294724, 5.402382, 7200, 3155, 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23188, 530, 0, 0, -4945.155762, 574.027588, 70.485054, 3.461659, 120, 0, 0, 5129.208496, 665.918762, 71.294724, 5.402382, 7200, 3155, 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23188, 530, 0, 0, -4978.029785, 696.164673, 83.123734, 3.296726, 120, 0, 0, 5129.208496, 665.918762, 71.294724, 5.402382, 7200, 3155, 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23188, 530, 0, 0, -5136.723633, 716.480835, 72.274681, 5.491913, 120, 0, 0, 5129.208496, 665.918762, 71.294724, 5.402382, 7200, 3155, 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23188, 530, 0, 0, -5036.060547, 326.519775, 181.989090, 0.928751, 120, 0, 0, 5129.208496, 665.918762, 71.294724, 5.402382, 7200, 3155, 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23188, 530, 0, 0, -5031.074707, 487.520477, 84.086136, 3.402752, 120, 0, 0, 5129.208496, 665.918762, 71.294724, 5.402382, 7200, 3155, 0, 0);DELETE FROM `creature` WHERE id=23141;INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23141, 530, 0, 0, -5090.957520, 605.916382, 85.693794, 3.746632, 300, 0, 0, 5090.957520, 605.916382, 85.693794, 3.746632, 5800, 0, 0, 0);DELETE FROM `gameobject_template` WHERE entry=185877;INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `faction`, `flags`, `size`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (185877, 3, 6650, 'Nethercite Deposit', 0, 0, 1, 1652, 22070, 0, 1, 2, 4, 0, 185878, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');DELETE FROM `gameobject_template` WHERE entry=185881INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `faction`, `flags`, `size`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (185881, 3, 678, 'Netherdust Bush', 0, 0, 0.5, 1644, 22071, 0, 1, 1, 1, 0, 185878, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');DELETE FROM `creature_template` WHERE entry=23501INSERT INTO `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `civilian`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `ScriptName`) VALUES (23501, 19400, 0, 19400, 0, 'Netherwing Ray', '', 69, 70, 5400, 5500, 1540, 1578, 0, 14, 14, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 34, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 23501, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1840, 2000, '', 0, 3, 0, 1, 0, 0, '');DELETE FROM `creature` WHERE id=23501;INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23501, 530, 19400, 0, -5045.689941, -75.556602, 69.071800, 0.941637, 300, '0', 0, -5045.689941, -75.556602, 69.071800, 5.732567, '5400', '1540', 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23501, 530, 19400, 0, -5146.082031, -113.055222, 69.059937, 5.732567, 300, '0', 0, -5146.082031, -113.055222, 69.059937, 5.732567, '5460', '1560', 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23501, 530, 19400, 0, -5171.459961, -134.641479, 61.307678, 0.941637, 300, '0', 0, -5171.459961, -134.641479, 61.307678, 0.941637, '5500', '1574', 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23501, 530, 19400, 0, -5171.459961, -134.641479, 61.307678, 1.263651, 300, '0', 0, -5171.459961, -134.641479, 61.307678, 1.263651, '5495', '1540', 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23501, 530, 19400, 0, -5173.949219, -59.765324, 74.045837, 5.732567, 300, '0', 0, -5173.949219, -59.765324, 74.045837, 5.732567, '5400', '1540', 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23501, 530, 19400, 0, -5206.822266, -32.018711, 70.66607, 0.792412, 300, '0', 0, -5206.822266, -32.018711, 70.66607, 0.792412, '5500', '1578', 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23501, 530, 19400, 0, -5250.461426, 17.104691, 53.660793, 0.941637, 300, '0', 0, -5250.461426, 17.104691, 53.660793, 0.941637, '5500', '1540', 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23501, 530, 19400, 0, -5186.445801, 77.305969, 70.128830, 2.779469, 300, '0', 0, -5186.445801, 77.305969, 70.128830, 2.779469, '5500', '1578', 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23501, 530, 19400, 0, -5208.730469, 182.947952, 71.884010, 1.263651, 300, '0', 0, -5208.730469, 182.947952, 71.884010, 1.263651, '5500', '1578', 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23501, 530, 19400, 0, -5237.189941, 263.038483, 71.680183, 0.596062, 300, '0', 0, -5237.189941, 263.038483, 71.680183, 0.596062, '5400', '1540', 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23501, 530, 19400, 0, -5276.522949, 367.326935, 60.675652, 4.758672, 300, '0', 0, -5276.522949, 367.326935, 60.675652, 4.758672, '5400', '1540', 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23501, 530, 19400, 0, -5058.122559, 472.673492, 84.525093, 0.760996, 300, '0', 0, -5058.122559, 472.673492, 84.525093, 0.760996, '5500', '1578', 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23501, 530, 19400, 0, -4998.665039, 462.666260, 87.062973, 1.192966, 300, '0', 0, -4998.665039, 462.666260, 87.062973, 1.192966, '5400', '1540', 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23501, 530, 19400, 0, -4994.798828, 662.093201, 89.570534, 0.596064, 300, '0', 0, -4994.798828, 662.093201, 89.570534, 0.596064, '5500', '1578', 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23501, 530, 19400, 0, -4858.246094, 677.496094, 57.824615, 3.765145, 300, '0', 0, -4858.246094, 677.496094, 57.824615, 3.765145, '5400', '1540', 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23501, 530, 19400, 0, -5007.349609, 366.427734, 170.971085, 2.956183, 300, '0', 0, -5007.349609, 366.427734, 170.971085, 2.956183, '5400', '1540', 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23501, 530, 19400, 0, -5060.676758, 361.793365, 170.647278, 4.326702, 300, '0', 0, -5060.676758, 361.793365, 170.647278, 4.326702, '5500', '1578', 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23501, 530, 19400, 0, -5088.270508, 252.894562, 151.092224, 4.318847, 300, '0', 0, -5088.270508, 252.894562, 151.092224, 4.318847, '5450', '1560', 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23501, 530, 19400, 0, -5001.994141, 294.307739, 83.183624, 5.389342, 300, '0', 0, -5001.994141, 294.307739, 83.183624, 5.389342, '5400', '1540', 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23501, 530, 19400, 0, -4955.270508, 242.273972, 79.245102, 4.199464, 300, '0', 0, -4955.270508, 242.273972, 79.245102, 4.199464, '5450', '1560', 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23501, 530, 19400, 0, -5038.348633, 40.031757, 80.125771, 0.544217, 300, '0', 0, -5038.348633, 40.031757, 80.125771, 0.544217, '5500', '1578', 0, 0);INSERT INTO `creature` (`id`, `map`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `spawn_position_x`, `spawn_position_y`, `spawn_position_z`, `spawn_orientation`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES (23501, 530, 19400, 0, -4907.042480, 42.710014, 47.863628, 3.909653, 300, '0', 0, -4907.042480, 42.710014, 47.863628, 3.909653, '5500', '1578', 0, 0);UPDATE `creature_template` set `mindmg`='1390', `maxdmg`='1790', attackpower='5570' where `entry` in (23501);DELETE FROM `creature_loot_template` WHERE (`entry`=23501) AND (`item`=32427);INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrRef`, `QuestChanceOrGroup`, `mincount`, `maxcount`, `freeforall`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (23501, 32427, 33.5, 50, 1, 2, 0, 0, 0, 0);-- Scriptdev2 DatabaseINSERT INTO `eventai_scripts` (`creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_param1`, `event_param2`, `event_param3`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES ('21722', '10', '0', '100', '100', '38762', '0', '17', '35', '35', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Enslaved Netherwing Drake - change faction');