kikote300

Ha aki te lo mando en limpio INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextID0`, `BroadcastTextID1`, `BroadcastTextID2`, `BroadcastTextID3`, `BroadcastTextID4`, `BroadcastTextID5`, `BroadcastTextID6`, `BroadcastTextID7`, `VerifiedBuild`) VALUES ('101727', '0', '0', '0', '0', '0', '0', '0', '0', '101727', '101727', '0', '0', '0', '0', '0', '0', '0'); DELETE FROM `gossip_menu` WHERE `MenuId` IN (1017220); INSERT INTO `gossip_menu` (`MenuId`, `TextId`, `VerifiedBuild`) VALUES ('1017220', '101727', '0'); DELETE FROM conditions WHERE SourceTypeOrReferenceId=15 AND SourceGroup = 101722; INSERT INTO`conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES ('15', '101722', '0', '0', '1', '47', '0', '40241', '8', '0', '0', '0', '0', '', 'Only see the gossip with quest 40241'), ('15', '101722', '0', '0', '2', '47', '0', '40200', '8', '0', '0', '0', '0', '', 'Only see the gossip with quest 40200'); DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (101722); INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `OptionBroadcastTextID`) VALUES (101722, 0, 0, 1, 1, 1017220, 0, 0, 0,"", 101722), (101722, 1, 1, 3, 128, 0, 0, 0, 0,"", 87415); UPDATE creature_template SET gossip_menu_id = 101722, npcflag = 131, AIName="SmartAI" WHERE entry = 98725; UPDATE creature_template SET gossip_menu_id = 101722, npcflag = 131, AIName="SmartAI" WHERE entry = 115287; DELETE FROM `smart_scripts` WHERE `entryorguid` IN (115287,98725); INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param_string`, `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 ('115287', '0', '0', '1', '62', '0', '100', '0', '101722', '0', '0', '0', '', '33', '99199', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'Give Killcredit Quest ID 40241'), ('98725', '0', '0', '1', '62', '0', '100', '0', '101722', '0', '0', '0', '', '33', '99199', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'Give KillCredit Quest ID 40200');

INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextID0`, `BroadcastTextID1`, `BroadcastTextID2`, `BroadcastTextID3`, `BroadcastTextID4`, `BroadcastTextID5`, `BroadcastTextID6`, `BroadcastTextID7`, `VerifiedBuild`) VALUES ('101727', '0', '0', '0', '0', '0', '0', '0', '0', '101727', '101727', '0', '0', '0', '0', '0', '0', '0');

DELETE FROM `gossip_menu` WHERE `MenuId` IN (1017220); INSERT INTO `gossip_menu` (`MenuId`, `TextId`, `VerifiedBuild`) VALUES ('1017220', '101727', '0');

DELETE FROM conditions WHERE SourceTypeOrReferenceId=15 AND SourceGroup = 101722; INSERT INTO`conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES ('15', '101722', '0', '0', '1', '47', '0', '40241', '8', '0', '0', '0', '0', '', 'Only see the gossip with quest 40241'), ('15', '101722', '0', '0', '2', '47', '0', '40200', '8', '0', '0', '0', '0', '', 'Only see the gossip with quest 40200'); DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (101722); INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `OptionBroadcastTextID`) VALUES (101722, 0, 0, 1, 1, 1017220, 0, 0, 0,"", 101722), (101722, 1, 1, 3, 128, 0, 0, 0, 0,"", 87415); UPDATE creature_template SET gossip_menu_id = 101722, npcflag = 131, AIName="SmartAI" WHERE entry = 98725; UPDATE creature_template SET gossip_menu_id = 101722, npcflag = 131, AIName="SmartAI" WHERE entry = 115287; DELETE FROM `smart_scripts` WHERE `entryorguid` IN (115287,98725); INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param_string`, `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 ('115287', '0', '0', '1', '62', '0', '100', '0', '101722', '0', '0', '0', '', '33', '99199', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'Give Killcredit Quest ID 40241'), ('98725', '0', '0', '1', '62', '0', '100', '0', '101722', '0', '0', '0', '', '33', '99199', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', 'Give KillCredit Quest ID 40200'); No me a dado tiempo de terminar mas, si me da tiempo lo termino cuando llegue de trabajar Texto faltante en la mision una vez que la das click al gossip tiene que salir este texto. Leather pet toys? let's see, now... a new leash might be nice. And I know de pets would appreciate a nice , soft bed to rest on. I've always dreamed of fashioning a hoop for them to jump through. Preferably something we can light on fire. Dat would be quite de trick!

Los NPC que tienen que tener el scripname son la ID 98725 y 115287 UPDATE `creature_template` SET `ScriptName`='npc_prof_pe' WHERE (`entry`='115287'); UPDATE `creature_template` SET `ScriptName`='npc_prof_pe' WHERE (`entry`='98725'); #define GOSSIP_NAMHA "Namha told me you had some new pet toy ideas?" class npc_prof_pe : public CreatureScript { public: npc_prof_pe() : CreatureScript("npc_prof_pe") {} bool OnGossipHello(Player* player, Creature* creature) { if (creature->IsQuestGiver()) player->PrepareQuestMenu(creature->GetGUID()); if (creature->IsVendor()) AddGossipItemFor(player, GOSSIP_ICON_VENDOR, GOSSIP_TEXT_BROWSE_GOODS, GOSSIP_SENDER_MAIN, GOSSIP_ACTION_TRADE); if (player->GetQuestStatus(40241) || player->GetQuestStatus(40200)){ AddGossipItemFor(player, GOSSIP_ICON_CHAT, GOSSIP_NAMHA, GOSSIP_SENDER_MAIN, GOSSIP_ACTION_INFO_DEF + 1); } SendGossipMenuFor(player, player->GetGossipTextId(creature), creature->GetGUID()); return true; } void SendActionMenu(Player* player, Creature* creature, uint32 action) { switch (action) { case GOSSIP_ACTION_TRADE: player->GetSession()->SendListInventory(creature->GetGUID()); break; case GOSSIP_ACTION_INFO_DEF + 1: player->KilledMonsterCredit(99199); CloseGossipMenuFor(player); break; } } bool OnGossipSelect(Player* player, Creature* creature, uint32 sender, uint32 action) { ClearGossipMenuFor(player); switch (sender) { case GOSSIP_SENDER_MAIN: SendActionMenu(player, creature, action); break; case GOSSIP_SENDER_CHECK: SendActionMenu(player, creature, action); break; } return true; } };

Falta para poder entregar la misión INSERT INTO `creature_questender` (`id`, `quest`) VALUES ('93541', '40159');

INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES ('91808', '129921', '0', '3', '1', '1', '0', '1', '1', '');

https://es.wowhead.com/quest=40991/apertura-de-la-cocina-de-pruebas DELETE FROM gameobject_questitem WHERE GameObjectEntry = 246710; INSERT INTO `gameobject_questitem` (`GameObjectEntry`, `Idx`, `ItemId`, `VerifiedBuild`) VALUES ('246710', '0', '133912', '26822'); DELETE FROM gameobject_loot_template WHERE Entry = 246710; INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES ('246710', '133912', '0', '100', '1', '1', '0', '5', '5', ''); DELETE FROM gameobject_template WHERE entry = 246710; INSERT INTO `gameobject_template` ('entry') VALUES ('246710'); UPDATE `gameobject_template` SET `type`= 3, `displayId`='10803',`name`='Nomi\'s Silver Mackerel',`IconName`='questinteract', `castBarCaption`='Retrieving',`size`='0.8', `Data0`='43', `Data1`='246710',`Data14`='23645',`Data30`='64377',`VerifiedBuild`='26822' WHERE (`entry`='246710'); UPDATE `gameobject` SET `id`='246710', `map`='1220', `zoneId`='0', `areaId`='0', `spawnMask`='1', `phaseUseFlags`='0', `PhaseId`='0', `PhaseGroup`='0', `terrainSwapMap`='-1', `position_x`='-949.521', `position_y`='4550.39', `position_z`='729.972', `orientation`='5.06586', `rotation0`='0', `rotation1`='0', `rotation2`='0.571771', `rotation3`='-0.820413', `spawntimesecs`='7200', `animprogress`='255', `state`='1', `isActive`='0', `ScriptName`='', `VerifiedBuild`='22624' WHERE (`id`='246710');

Hola buenas lo he puesto un poco mas limpio el código . Esto es para el NPC Nomi que no le funciona la tienda no se abre. DELETE FROM npc_vendor WHERE entry = 101846; INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `OverrideGoldCost`, `type`, `BonusListIDs`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES ('101846', '0', '133810', '0', '0', '0', '-1', '1', NULL, '0', '0', '0'), ('101846', '0', '133812', '0', '0', '0', '-1', '1', NULL, '0', '0', '0'), ('101846', '0', '133813', '0', '0', '0', '-1', '1', NULL, '0', '0', '0'), ('101846', '0', '133814', '0', '0', '0', '-1', '1', NULL, '0', '0', '0'), ('101846', '0', '133815', '0', '0', '0', '-1', '1', NULL, '0', '0', '0'), ('101846', '0', '133818', '0', '0', '0', '-1', '1', NULL, '0', '0', '0'), ('101846', '0', '133826', '0', '0', '0', '-1', '1', NULL, '0', '0', '0'), ('101846', '0', '133828', '0', '0', '0', '-1', '1', NULL, '0', '0', '0'), ('101846', '0', '133846', '0', '0', '0', '-1', '1', NULL, '0', '0', '0'); UPDATE creature_template SET type_flags = 134217728, type_flags2=16384, type = 7, unit_flags = 33536, unit_flags2 = 2048,npcflag = 131,faction = 35 WHERE entry = 101846 __________________________________________________________________________________________________________________________________ Esto es para la Quest de Maestro de vuelo Quest ID (43341) DELETE FROM quest_poi WHERE QuestID = 43341; INSERT INTO `quest_poi` (`QuestID`, `BlobIndex`, `Idx1`, `ObjectiveIndex`, `QuestObjectiveID`, `QuestObjectID`, `MapID`, `WorldMapAreaId`, `Floor`, `Priority`, `Flags`, `WorldEffectID`, `PlayerConditionID`, `WoDUnk1`, `AlwaysAllowMergingBlobs`, `VerifiedBuild`) VALUES ('43341', '0', '0', '-1', '0', '0', '1220', '1014', '10', '0', '0', '0', '0', '1004341', '0', '22908'), ('43341', '0', '1', '32', '0', '0', '1220', '1014', '10', '0', '2', '0', '0', '0', '0', '22908'); DELETE FROM quest_poi_points WHERE QuestID = 43341; INSERT INTO `quest_poi_points` (`QuestID`, `Idx1`, `Idx2`, `X`, `Y`, `VerifiedBuild`) VALUES ('43341', '1', '0', '-847', '4639', '22908'), ('43341', '0', '0', '-848', '4639', '22908'); DELETE FROM quest_objectives WHERE QuestID = 43341; INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `Order`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES ('285211', '43341', '6', '4', '-1', '1948', '3000', '0', '0', '0', 'Earn friendly reputation with the Valarjar in Stormheim', '25996'), ('285210', '43341', '6', '3', '-1', '1883', '3000', '0', '0', '0', 'Earn friendly reputation with the Dreamweavers in Val\'sharah', '25996'), ('285209', '43341', '6', '2', '-1', '1828', '3000', '0', '0', '0', 'Earn friendly reputation with the Highmountain Tribe', '25996'), ('285208', '43341', '6', '1', '-1', '1900', '3000', '0', '0', '0', 'Earn friendly reputation with the Court of Farondis in Azsuna', '25996'), ('286697', '43341', '6', '0', '-1', '1859', '3000', '0', '0', '0', 'Earn friendly reputation with the Nightfallen in Suramar', '25996'); UPDATE `creature_questender` SET `id`='90417', `quest`='43341' WHERE (`id`='90417') AND (`quest`='43341'); UPDATE `creature_queststarter` SET `id`='90417', `quest`='43341' WHERE (`id`='90417') AND (`quest`='43341');

UPDATE `quest_template_locale` SET `ID`='27522', `locale`='deDE', `LogTitle`='Prügelstrafe', `LogDescription`='Schlagt mindestens 6 Belagerungsingenieure der Geißel nieder, um an Informationen über Gidwins Verbleib und seinen Entführer zu gelangen.', `QuestDescription`='Uns Paladinen bringt man bei, unseren Feinden gerecht und ruhig entgegenzutreten, aber dies ist ein Notfall. Außerdem habe ich noch nie auf meine Lehrer gehört.$B$BIch werde versuchen, im Pestwald mehr über Giddy herauszufinden. Kümmert Ihr Euch um die Geißel nordöstlich von hier, auf der anderen Seite dieses Turms. Die Untoten fürchten den Tod nicht, aber schlagt sie lang genug, dann verplappern sie sich vielleicht und geben uns Hinweise auf Gidwins Aufenthaltsort.', `AreaDescription`='', `PortraitGiverText`='', `PortraitGiverName`='', `PortraitTurnInText`='', `PortraitTurnInName`='', `QuestCompletionLog`='', `VerifiedBuild`='25549' WHERE (`ID`='27522') AND (`locale`='deDE'); UPDATE `quest_template_locale` SET `ID`='27522', `locale`='esES', `LogTitle`='Sácaselo a golpes', `LogDescription`='Golpea al menos a 6 ingenieros de asedio de la Plaga para averiguar detalles del paradero de Gidwin y su captor.', `QuestDescription`='A nosotros los paladines normalmente se nos enseña a mostrar buen juicio y control cuando nos enfrentamos a nuestros enemigos, pero esto es una emergencia y, total, nunca les hice mucho caso a mis instructores.$B$BVoy a ir al Bosque de la Peste y averiguar todo lo que pueda sobre Giddy. Ocúpate de la Plaga en el noroeste, al otro lado de esta torre. Los no-muertos no le temen a la muerte pero, si les pegas lo suficiente, puede que se les suelte la lengua y así consigamos saber algo sobre dónde está Gidwin.', `AreaDescription`='', `PortraitGiverText`='', `PortraitGiverName`='', `PortraitTurnInText`='', `PortraitTurnInName`='', `QuestCompletionLog`='', `VerifiedBuild`='25549' WHERE (`ID`='27522') AND (`locale`='esES'); UPDATE `quest_template_locale` SET `ID`='27522', `locale`='esMX', `LogTitle`='Sácaselo a golpes', `LogDescription`='Golpea al menos a 6 ingenieros de asedio de la Plaga para averiguar detalles del paradero de Gidwin y su captor.', `QuestDescription`='A nosotros los paladines normalmente se nos enseña a mostrar buen juicio y control cuando nos enfrentamos a nuestros enemigos, pero esto es una emergencia y, total, nunca les hice mucho caso a mis instructores.$B$BVoy a ir al Bosque de la Peste y averiguar todo lo que pueda sobre Giddy. Ocúpate de la Plaga en el noroeste, al otro lado de esta torre. Los no-muertos no le temen a la muerte pero, si les pegas lo suficiente, puede que se les suelte la lengua y así consigamos saber algo sobre dónde está Gidwin.', `AreaDescription`='', `PortraitGiverText`='', `PortraitGiverName`='', `PortraitTurnInText`='', `PortraitTurnInName`='', `QuestCompletionLog`='', `VerifiedBuild`='25549' WHERE (`ID`='27522') AND (`locale`='esMX'); UPDATE `quest_template_locale` SET `ID`='27522', `locale`='frFR', `LogTitle`='Leur faire lâcher le morceau', `LogDescription`='Tabassez au moins 6 Ingénieurs de machines de siège du Fléau pour obtenir des informations sur la position de Gidwin et son ravisseur.', `QuestDescription`='Nous autres paladins, apprenons en général à faire preuve de jugement et de contrôle face à nos adversaires. Mais nous sommes confrontés à une urgence et je n’ai jamais vraiment porté attention à ce que me racontaient mes entraîneurs, de toute façon !$b$bJe vais me rendre à Pestebois et voir ce que je peux découvrir à propos de Giddy. Occupez-vous du Fléau au nord-est, de l’autre côté de cette tour. Les morts-vivants ne craignent pas la mort, mais si on les tabasse suffisamment, il leur arrive de lâcher le morceau… Nous pourrions ainsi obtenir des indices sur la position de Gidwin.', `AreaDescription`='', `PortraitGiverText`='', `PortraitGiverName`='', `PortraitTurnInText`='', `PortraitTurnInName`='', `QuestCompletionLog`='', `VerifiedBuild`='25549' WHERE (`ID`='27522') AND (`locale`='frFR'); UPDATE `quest_template_locale` SET `ID`='27522', `locale`='koKR', `LogTitle`='극단적인 심문 방법', `LogDescription`='스컬지 공성 기술병을 적어도 6명 이상 혼쭐을 내주고 기드윈의 위치와 기드윈을 잡아간 자에 대한 정보를 알아내야 합니다.', `QuestDescription`='적들을 상대할 때 우리 성기사들은 보통 냉철한 판단력과 자제력을 유지하라는 가르침을 받지만, 이번은 비상 상황이오. 하긴, 상급 성기사들이 이런 일에 대해 가르치는 동안 나는 그다지 귀를 기울인 적도 없었지.$b$b우선 내가 역병숲으로 들어가 기드윈에게 무슨 일이 생긴 건지 알아보겠소. 당신은 북동쪽으로 가서 탑 반대편에 있는 스컬지를 상대해 주시오. 언데드는 죽는 일을 두려워하지는 않지만, 적당히 두들겨 맞고 나면, 실수로라도 정보를 흘릴지 모르오. 그러면 기드윈이 어디에 잡혀 있는지 단서를 얻게 될 수도 있지.', `AreaDescription`='', `PortraitGiverText`='', `PortraitGiverName`='', `PortraitTurnInText`='', `PortraitTurnInName`='', `QuestCompletionLog`='', `VerifiedBuild`='25549' WHERE (`ID`='27522') AND (`locale`='koKR'); UPDATE `quest_template_locale` SET `ID`='27522', `locale`='ruRU', `LogTitle`='Выбей из них дурь', `LogDescription`='Избейте не менее 6 инженеров Плети, чтобы выяснить, кто похитил Гидвина и где он сейчас находится.', `QuestDescription`='Нас, паладинов, учат держать себя в руках и сохранять хладнокровие в бою, но это особый случай – и, кроме того, я никогда не слушал учителей.$B$BЯ пойду в Чумной лес и выясню, что стало с Гидди. А ты разберись со слугами Плети, которые находятся к северо-востоку отсюда, за этой башней. Нежить не боится смерти, но если избить этих мертвяков как следует, то они могут проболтаться, где сейчас находится Гидвин.', `AreaDescription`='', `PortraitGiverText`='', `PortraitGiverName`='', `PortraitTurnInText`='', `PortraitTurnInName`='', `QuestCompletionLog`='', `VerifiedBuild`='25549' WHERE (`ID`='27522') AND (`locale`='ruRU'); UPDATE `quest_template_locale` SET `ID`='27522', `locale`='zhCN', `LogTitle`='不打不成招', `LogDescription`='殴打至少6名天灾攻城技师，找出吉德文的下落，并搞清楚是谁抓了他。', `QuestDescription`='我们圣骑士通常受到的教育是要在作战时谨慎判断形势，控制自己的行为，但眼下的情况非常紧急，再说我从来都没有认真听过导师的教诲。$b$b我要进入病木林，看看我能帮吉德文做些什么。你去东北边对付那些亡灵，就在这座塔的另一侧。亡灵不惧怕死亡，但是如果你把它们揍得够狠，也许它们会透露只言片语，为我们提供找到吉德文的线索。', `AreaDescription`='', `PortraitGiverText`='', `PortraitGiverName`='', `PortraitTurnInText`='', `PortraitTurnInName`='', `QuestCompletionLog`='', `VerifiedBuild`='25549' WHERE (`ID`='27522') AND (`locale`='zhCN'); UPDATE `quest_template_locale` SET `ID`='27522', `locale`='zhTW', `LogTitle`='給他們點教訓', `LogDescription`='打敗6名天譴攻城工程師以獲得基德溫的所在地，以及挾持他的人。', `QuestDescription`='我們聖騎士總是被教導要運用判斷力和自我控制來面對敵人，但這是個緊急情況，而且我也沒什麼理會我的訓練師。$b$b我要前往病木林找找看有沒有什麼能幫助基德溫的。你則去料理東北方那些天譴軍團，就在塔的另外一側。這些不死族不怕死，但是如果你給他們嚐的苦頭夠多，也許他們就會鬆口說些什麼，這樣我們就有線索能找到基德溫了。', `AreaDescription`='', `PortraitGiverText`='', `PortraitGiverName`='', `PortraitTurnInText`='', `PortraitTurnInName`='', `QuestCompletionLog`='', `VerifiedBuild`='25549' WHERE (`ID`='27522') AND (`locale`='zhTW');

Path_id 2102191154 es igual al npc de la x,y,z 697,395|| 2808,11|| 125,835 || 0,191975 Path_id 2102191153 es igual al npc de la x.y.z 713,269|| 2812,85|| 126,479|| 5,5599 Path_id 2102191152 es igual a los npc de la x.y.z 672,418 || 2819,46 || 125,409 || 5,28284 676,461 || 2794,53 || 125,256 || 1,51196 656,616 || 2756,59 || 125,944 || 0,16107 593,498 || 2762,59 || 125,25 || 4,79413 605,534 || 2824,02 || 125,265 || 2,9296

https://firestorm-servers.com/es/report/see_report/64962 UPDATE `creature_questender` SET `id`='45417', `quest`='27522' WHERE (`id`='45417') AND (`quest`='27522'); UPDATE `creature_queststarter` SET `id`='45729', `quest`='27522' WHERE (`id`='45729') AND (`quest`='27522'); UPDATE `quest_objectives` SET `ID`='265859', `QuestID`='27522', `Type`='0', `Order`='0', `StorageIndex`='0', `ObjectID`='17878', `Amount`='6', `Flags`='0', `Flags2`='0', `ProgressBarWeight`='0', `Description`='Scourge Siege Engineer beaten', `VerifiedBuild`='25996' WHERE (`ID`='265859'); UPDATE `quest_objectives` SET `ID`='265860', `QuestID`='27522', `Type`='0', `Order`='1', `StorageIndex`='1', `ObjectID`='45845', `Amount`='1', `Flags`='0', `Flags2`='0', `ProgressBarWeight`='0', `Description`='Discover Gidwin\'s location', `VerifiedBuild`='25996' WHERE (`ID`='265860'); UPDATE `quest_objectives` SET `ID`='265861', `QuestID`='27522', `Type`='0', `Order`='2', `StorageIndex`='2', `ObjectID`='45846', `Amount`='1', `Flags`='0', `Flags2`='0', `ProgressBarWeight`='0', `Description`='Discover Gidwin\'s captor', `VerifiedBuild`='25996' WHERE (`ID`='265861'); UPDATE `quest_template_addon` SET `ID`='27522', `MaxLevel`='0', `AllowableClasses`='0', `SourceSpellID`='0', `PrevQuestID`='27489', `NextQuestID`='27524', `ExclusiveGroup`='0', `RewardMailTemplateID`='0', `RewardMailDelay`='0', `RequiredSkillID`='0', `RequiredSkillPoints`='0', `RequiredMinRepFaction`='0', `RequiredMaxRepFaction`='0', `RequiredMinRepValue`='0', `RequiredMaxRepValue`='0', `ProvidedItemCount`='0', `SpecialFlags`='0', `ScriptName`='' WHERE (`ID`='27522'); UPDATE `quest_poi` SET `QuestID`='27522', `BlobIndex`='0', `Idx1`='0', `ObjectiveIndex`='-1', `QuestObjectiveID`='0', `QuestObjectID`='0', `MapID`='0', `WorldMapAreaId`='23', `Floor`='0', `Priority`='0', `Flags`='0', `WorldEffectID`='0', `PlayerConditionID`='0', `WoDUnk1`='0', `AlwaysAllowMergingBlobs`='0', `VerifiedBuild`='25937' WHERE (`QuestID`='27522') AND (`BlobIndex`='0') AND (`Idx1`='0'); UPDATE `quest_poi` SET `QuestID`='27522', `BlobIndex`='0', `Idx1`='1', `ObjectiveIndex`='0', `QuestObjectiveID`='265859', `QuestObjectID`='17878', `MapID`='0', `WorldMapAreaId`='23', `Floor`='0', `Priority`='0', `Flags`='0', `WorldEffectID`='0', `PlayerConditionID`='0', `WoDUnk1`='0', `AlwaysAllowMergingBlobs`='0', `VerifiedBuild`='25937' WHERE (`QuestID`='27522') AND (`BlobIndex`='0') AND (`Idx1`='1'); UPDATE `quest_poi` SET `QuestID`='27522', `BlobIndex`='0', `Idx1`='2', `ObjectiveIndex`='1', `QuestObjectiveID`='265860', `QuestObjectID`='45845', `MapID`='0', `WorldMapAreaId`='23', `Floor`='0', `Priority`='0', `Flags`='0', `WorldEffectID`='0', `PlayerConditionID`='0', `WoDUnk1`='0', `AlwaysAllowMergingBlobs`='0', `VerifiedBuild`='25937' WHERE (`QuestID`='27522') AND (`BlobIndex`='0') AND (`Idx1`='2'); UPDATE `quest_poi` SET `QuestID`='27522', `BlobIndex`='0', `Idx1`='3', `ObjectiveIndex`='2', `QuestObjectiveID`='265861', `QuestObjectID`='45846', `MapID`='0', `WorldMapAreaId`='23', `Floor`='0', `Priority`='0', `Flags`='0', `WorldEffectID`='0', `PlayerConditionID`='0', `WoDUnk1`='0', `AlwaysAllowMergingBlobs`='0', `VerifiedBuild`='25937' WHERE (`QuestID`='27522') AND (`BlobIndex`='0') AND (`Idx1`='3'); UPDATE `quest_poi` SET `QuestID`='27522', `BlobIndex`='0', `Idx1`='4', `ObjectiveIndex`='32', `QuestObjectiveID`='0', `QuestObjectID`='0', `MapID`='0', `WorldMapAreaId`='23', `Floor`='0', `Priority`='0', `Flags`='0', `WorldEffectID`='0', `PlayerConditionID`='0', `WoDUnk1`='473680', `AlwaysAllowMergingBlobs`='0', `VerifiedBuild`='25937' WHERE (`QuestID`='27522') AND (`BlobIndex`='0') AND (`Idx1`='4'); UPDATE `quest_poi` SET `QuestID`='27522', `BlobIndex`='1', `Idx1`='2', `ObjectiveIndex`='0', `QuestObjectiveID`='265860', `QuestObjectID`='45845', `MapID`='0', `WorldMapAreaId`='23', `Floor`='0', `Priority`='0', `Flags`='1', `WorldEffectID`='0', `PlayerConditionID`='0', `WoDUnk1`='0', `AlwaysAllowMergingBlobs`='0', `VerifiedBuild`='22908' WHERE (`QuestID`='27522') AND (`BlobIndex`='1') AND (`Idx1`='2'); UPDATE `quest_poi` SET `QuestID`='27522', `BlobIndex`='2', `Idx1`='3', `ObjectiveIndex`='0', `QuestObjectiveID`='265861', `QuestObjectID`='45846', `MapID`='0', `WorldMapAreaId`='23', `Floor`='0', `Priority`='0', `Flags`='1', `WorldEffectID`='0', `PlayerConditionID`='0', `WoDUnk1`='0', `AlwaysAllowMergingBlobs`='0', `VerifiedBuild`='22908' WHERE (`QuestID`='27522') AND (`BlobIndex`='2') AND (`Idx1`='3'); UPDATE `quest_poi` SET `QuestID`='27522', `BlobIndex`='6', `Idx1`='1', `ObjectiveIndex`='-1', `QuestObjectiveID`='0', `QuestObjectID`='0', `MapID`='0', `WorldMapAreaId`='23', `Floor`='0', `Priority`='0', `Flags`='1', `WorldEffectID`='0', `PlayerConditionID`='0', `WoDUnk1`='0', `AlwaysAllowMergingBlobs`='0', `VerifiedBuild`='22908' WHERE (`QuestID`='27522') AND (`BlobIndex`='6') AND (`Idx1`='1');

INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES ('2102191154', '2', '712.671', '2812.81', '126.307', '0', '0', '0', '0', '100', '0'); INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES ('2102191154', '1', '707.966', '2807.7', '126.213', '0', '0', '0', '0', '100', '0'); INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES ('2102191153', '2', '703.133', '2802.56', '126.247', '0', '0', '0', '0', '100', '0'); INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES ('2102191153', '1', '698.986', '2801.67', '125.259', '0', '0', '0', '0', '100', '0'); INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES ('2102191152', '17', '673.519', '2799.51', '125.253', '0', '0', '0', '0', '100', '0'); INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES ('2102191152', '16', '673.411', '2785.42', '125.25', '0', '0', '0', '0', '100', '0'); INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES ('2102191152', '15', '669.339', '2768.3', '125.25', '0', '0', '0', '0', '100', '0'); INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES ('2102191152', '14', '654.233', '2756.87', '125.25', '0', '0', '0', '0', '100', '0'); INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES ('2102191152', '13', '636.866', '2754.18', '125.25', '0', '0', '0', '0', '100', '0'); INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES ('2102191152', '12', '620.609', '2756.19', '125.25', '0', '0', '0', '0', '100', '0'); INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES ('2102191152', '11', '600.026', '2765.29', '125.25', '0', '0', '0', '0', '100', '0'); INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES ('2102191152', '10', '593.255', '2786.95', '125.25', '0', '0', '0', '0', '100', '0'); INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES ('2102191152', '9', '599.253', '2805.74', '125.25', '0', '0', '0', '0', '100', '0'); INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES ('2102191152', '8', '603.759', '2815.55', '125.251', '0', '0', '0', '0', '100', '0'); INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES ('2102191152', '7', '617.113', '2832.32', '125.255', '0', '0', '0', '0', '100', '0'); INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES ('2102191152', '6', '631.812', '2838.55', '125.25', '0', '0', '0', '0', '100', '0'); INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES ('2102191152', '5', '645.612', '2843.56', '125.251', '0', '0', '0', '0', '100', '0'); INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES ('2102191152', '4', '659.143', '2844.68', '125.251', '0', '0', '0', '0', '100', '0'); INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES ('2102191152', '3', '672.283', '2843.32', '125.25', '0', '0', '0', '0', '100', '0'); INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES ('2102191152', '2', '680.808', '2829.33', '125.25', '0', '0', '0', '0', '100', '0'); INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES ('2102191152', '1', '674.34', '2811.18', '125.249', '0', '0', '0', '0', '100', '0'); La GUID es de los Creature_template ID 114766 INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES ('@GUID', '2102191152', '0', '0', '0', '0', '0', '0', '0', NULL); INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES ('@GUID', '2102191152', '0', '0', '0', '0', '0', '0', '0', NULL); INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES ('@GUID', '2102191152', '0', '0', '0', '0', '0', '0', '0', NULL); INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES ('@GUID', '2102191152', '0', '0', '0', '0', '0', '0', '0', NULL); INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES ('@GUID', '2102191152', '0', '0', '0', '0', '0', '0', '0', NULL); INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES ('@GUID', '2102191154', '0', '0', '0', '0', '0', '0', '0', NULL); INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES ('@GUID', '2102191153', '0', '0', '0', '0', '0', '0', '0', NULL);

los mobs estaban al lvl 1 y sin vida y le he tenido que modificar la vida y el daño como el official y también meterle sus Spawns. correspondientes. UPDATE `skinning_loot_template` SET `Entry`='112956', `Item`='129867', `Reference`='0', `Chance`='1', `QuestRequired`='0', `LootMode`='1', `GroupId`='0', `MinCount`='1', `MaxCount`='1', `Comment`='' WHERE (`Entry`='112956') AND (`Item`='129867'); UPDATE `skinning_loot_template` SET `Entry`='116961', `Item`='129867', `Reference`='0', `Chance`='3', `QuestRequired`='0', `LootMode`='1', `GroupId`='0', `MinCount`='1', `MaxCount`='1', `Comment`='' WHERE (`Entry`='116961') AND (`Item`='129867'); INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES ('102287', '129867', '0', '3', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES ('118255', '129867', '0', '3', '0', '1', '0', '1', '1', ''); UPDATE `creature_template` SET `entry`='116961', `difficulty_entry_1`='0', `difficulty_entry_2`='0', `difficulty_entry_3`='0', `KillCredit1`='0', `KillCredit2`='0', `modelid1`='20595', `modelid2`='0', `modelid3`='0', `modelid4`='0', `name`='Mature Bone Crawler', `femaleName`='', `subname`='', `TitleAlt`=NULL, `IconName`=NULL, `gossip_menu_id`='0', `minlevel`='110', `maxlevel`='110', `HealthScalingExpansion`='6', `RequiredExpansion`='0', `VignetteID`='0', `faction`='1768', `npcflag`='0', `speed_walk`='1', `speed_run`='1.14286', `scale`='1', `rank`='0', `dmgschool`='0', `BaseAttackTime`='2000', `RangeAttackTime`='2000', `BaseVariance`='1', `RangeVariance`='1', `unit_class`='1', `unit_flags`='32768', `unit_flags2`='2048', `unit_flags3`='0', `dynamicflags`='0', `family`='0', `trainer_type`='0', `trainer_class`='0', `trainer_race`='0', `type`='3', `type_flags`='2097228', `type_flags2`='0', `lootid`='0', `pickpocketloot`='0', `skinloot`='116961', `resistance1`='0', `resistance2`='0', `resistance3`='0', `resistance4`='0', `resistance5`='0', `resistance6`='0', `spell1`='0', `spell2`='0', `spell3`='0', `spell4`='0', `spell5`='0', `spell6`='0', `spell7`='0', `spell8`='0', `VehicleId`='0', `mingold`='0', `maxgold`='0', `AIName`='', `MovementType`='0', `InhabitType`='3', `HoverHeight`='1', `HealthModifier`='10', `HealthModifierExtra`='1', `ManaModifier`='1', `ManaModifierExtra`='1', `ArmorModifier`='1', `DamageModifier`='1', `ExperienceModifier`='1', `RacialLeader`='0', `movementId`='0', `RegenHealth`='1', `mechanic_immune_mask`='0', `flags_extra`='0', `ScriptName`='', `VerifiedBuild`='25549' WHERE (`entry`='116961'); INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ( '116961', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '-1058.68', '3041.52', '-14.4638', '5.2334', '300', '0', '0', '10392670', '0', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ( '116961', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '-1070.84', '3105.03', '-10.3046', '1.98264', '300', '0', '0', '10392670', '0', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ( '116961', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '-1058.6', '3096.56', '-10.222', '5.57427', '300', '0', '0', '10392670', '0', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` (, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ( '116961', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '-1071.89', '3032.88', '-14.2161', '0.967905', '300', '0', '0', '10392670', '0', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('116961', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '-1101.74', '2992.55', '-12.4465', '1.67241', '300', '0', '0', '10392670', '0', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ( '116961', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '-1111.91', '2959.44', '-12.2471', '1.06765', '300', '0', '0', '10392670', '0', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ( '116961', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '-1083.46', '2922.63', '-15.4471', '1.95672', '300', '0', '0', '10392670', '0', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ( '116961', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '-1078.22', '2886.11', '-14.956', '1.69754', '300', '0', '0', '10392670', '0', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('116961', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '-1034.87', '2754.39', '2.82059', '5.90335', '300', '0', '0', '10392670', '0', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ( '116961', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '-1055.7', '2773.02', '4.0475', '4.98522', '300', '0', '0', '10392670', '0', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ( '116961', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '-985.259', '2789.54', '3.89157', '0.168369', '300', '0', '0', '10392670', '0', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('116961', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '-1019.79', '2772.96', '3.18113', '1.50747', '300', '0', '0', '10392670', '0', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ( '116961', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '-1006.19', '2773.98', '4.01796', '5.9489', '300', '0', '0', '10392670', '0', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ( '116961', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '-1038.41', '2807.17', '13.1657', '4.10871', '300', '0', '0', '10392670', '0', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('116961', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '-1026.09', '2825.78', '13.523', '2.09338', '300', '0', '0', '10392670', '0', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ( '116961', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '-998.936', '2831.99', '9.11941', '2.06903', '300', '0', '0', '10392670', '0', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ( '116961', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '-995.284', '2820.08', '9.37404', '3.33117', '300', '0', '0', '10392670', '0', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('116961', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '-971.586', '2819.84', '8.95011', '2.36905', '300', '0', '0', '10392670', '0', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ( '116961', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '-959.558', '2807.18', '10.9013', '2.44831', '300', '0', '0', '10392670', '0', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ( '116961', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '-937.297', '2797.41', '19.537', '1.61343', '300', '0', '0', '10392670', '0', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ( '116961', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '-945.522', '2783.24', '19.1779', '3.39063', '300', '0', '0', '10392670', '0', '0', '0', '0', '0', '0', '0', '', '0'); UPDATE `creature_template` SET `entry`='112956', `difficulty_entry_1`='0', `difficulty_entry_2`='0', `difficulty_entry_3`='0', `KillCredit1`='0', `KillCredit2`='0', `modelid1`='64304', `modelid2`='0', `modelid3`='0', `modelid4`='0', `name`='Shimmering Manaspine', `femaleName`='', `subname`='', `TitleAlt`=NULL, `IconName`='', `gossip_menu_id`='0', `minlevel`='110', `maxlevel`='110', `HealthScalingExpansion`='6', `RequiredExpansion`='0', `VignetteID`='0', `faction`='190', `npcflag`='0', `speed_walk`='1', `speed_run`='1.14286', `scale`='1', `rank`='4', `dmgschool`='0', `BaseAttackTime`='2000', `RangeAttackTime`='2000', `BaseVariance`='1', `RangeVariance`='1', `unit_class`='1', `unit_flags`='32832', `unit_flags2`='2048', `unit_flags3`='0', `dynamicflags`='0', `family`='0', `trainer_type`='0', `trainer_class`='0', `trainer_race`='0', `type`='1', `type_flags`='2097225', `type_flags2`='0', `lootid`='112956', `pickpocketloot`='0', `skinloot`='112956', `resistance1`='0', `resistance2`='0', `resistance3`='0', `resistance4`='0', `resistance5`='0', `resistance6`='0', `spell1`='0', `spell2`='0', `spell3`='0', `spell4`='0', `spell5`='0', `spell6`='0', `spell7`='0', `spell8`='0', `VehicleId`='0', `mingold`='0', `maxgold`='0', `AIName`='', `MovementType`='0', `InhabitType`='3', `HoverHeight`='1', `HealthModifier`='90', `HealthModifierExtra`='1', `ManaModifier`='1', `ManaModifierExtra`='1', `ArmorModifier`='10', `DamageModifier`='3', `ExperienceModifier`='1', `RacialLeader`='0', `movementId`='0', `RegenHealth`='1', `mechanic_immune_mask`='0', `flags_extra`='0', `ScriptName`='', `VerifiedBuild`='25549' WHERE (`entry`='112956'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ( '112956', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '716.487', '2794.78', '126.188', '1.30157', '300', '0', '0', '93534032', '0', '0', '0', '0', '0', '0', '0', '', '0'); UPDATE `creature_template` SET `entry`='114766', `difficulty_entry_1`='0', `difficulty_entry_2`='0', `difficulty_entry_3`='0', `KillCredit1`='0', `KillCredit2`='0', `modelid1`='66246', `modelid2`='66547', `modelid3`='0', `modelid4`='0', `name`='Terrace Grove-Tender', `femaleName`='', `subname`='', `TitleAlt`=NULL, `IconName`='', `gossip_menu_id`='0', `minlevel`='110', `maxlevel`='110', `HealthScalingExpansion`='6', `RequiredExpansion`='0', `VignetteID`='0', `faction`='2824', `npcflag`='0', `speed_walk`='1', `speed_run`='1.14286', `scale`='1', `rank`='1', `dmgschool`='0', `BaseAttackTime`='2000', `RangeAttackTime`='2000', `BaseVariance`='1', `RangeVariance`='1', `unit_class`='8', `unit_flags`='32768', `unit_flags2`='2048', `unit_flags3`='0', `dynamicflags`='0', `family`='0', `trainer_type`='0', `trainer_class`='0', `trainer_race`='0', `type`='7', `type_flags`='2097224', `type_flags2`='0', `lootid`='0', `pickpocketloot`='0', `skinloot`='0', `resistance1`='0', `resistance2`='0', `resistance3`='0', `resistance4`='0', `resistance5`='0', `resistance6`='0', `spell1`='0', `spell2`='0', `spell3`='0', `spell4`='0', `spell5`='0', `spell6`='0', `spell7`='0', `spell8`='0', `VehicleId`='50000', `mingold`='70000', `maxgold`='0', `AIName`='', `MovementType`='0', `InhabitType`='3', `HoverHeight`='1', `HealthModifier`='17.4', `HealthModifierExtra`='1', `ManaModifier`='1', `ManaModifierExtra`='1', `ArmorModifier`='1', `DamageModifier`='1', `ExperienceModifier`='1', `RacialLeader`='0', `movementId`='159', `RegenHealth`='1', `mechanic_immune_mask`='0', `flags_extra`='0', `ScriptName`='', `VerifiedBuild`='25549' WHERE (`entry`='114766'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '730.027', '2895.85', '124.842', '1.00388', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '713.808', '2853.13', '124.842', '0.728912', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '684.463', '2839.37', '125.25', '5.71619', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '658.379', '2889.36', '127.412', '0.79096', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '650.834', '2875.64', '127.206', '1.69417', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '652.886', '2859.1', '126.046', '1.69417', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '655.673', '2828.82', '125.25', '1.91801', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '675.854', '2820.36', '125.25', '1.13104', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '676.461', '2794.53', '125.256', '1.51196', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '656.616', '2756.59', '125.944', '0.16107', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '593.498', '2762.59', '125.25', '4.79413', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '605.534', '2824.02', '125.265', '2.9296', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '645.061', '2802.91', '125.303', '4.12654', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '641.39', '2806.45', '125.303', '2.93588', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '645.807', '2800.12', '125.303', '3.7951', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '687.689', '2781.26', '125.25', '4.27577', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '697.395', '2808.11', '125.835', '0.191975', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '713.269', '2812.85', '126.479', '5.5599', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '779.943', '2909.76', '126.523', '2.9014', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '771.469', '2903.32', '126.523', '2.40267', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '549.99', '2739.81', '121.201', '3.79675', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '490.051', '2712.45', '118.804', '2.0084', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '501.309', '2754.96', '121.308', '5.89455', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '562.236', '2788.7', '127.525', '2.71761', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '550.197', '2776.67', '127.411', '2.43016', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '537.549', '2778.2', '127.411', '1.53716', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '720.823', '2876.2', '131.36', '2.28172', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` ( `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114766', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '757.212', '2914.59', '124.842', '0.176851', '300', '0', '0', '14466603', '1', '0', '0', '0', '0', '0', '0', '', '0'); UPDATE `creature_template` SET `entry`='114770', `difficulty_entry_1`='0', `difficulty_entry_2`='0', `difficulty_entry_3`='0', `KillCredit1`='0', `KillCredit2`='0', `modelid1`='19285', `modelid2`='0', `modelid3`='0', `modelid4`='0', `name`='Shadescale Wyrm', `femaleName`='', `subname`='', `TitleAlt`=NULL, `IconName`='', `gossip_menu_id`='0', `minlevel`='110', `maxlevel`='110', `HealthScalingExpansion`='6', `RequiredExpansion`='0', `VignetteID`='0', `faction`='2824', `npcflag`='0', `speed_walk`='1', `speed_run`='1.14286', `scale`='1', `rank`='3', `dmgschool`='0', `BaseAttackTime`='2000', `RangeAttackTime`='2000', `BaseVariance`='1', `RangeVariance`='1', `unit_class`='8', `unit_flags`='32768', `unit_flags2`='2048', `unit_flags3`='0', `dynamicflags`='0', `family`='0', `trainer_type`='0', `trainer_class`='0', `trainer_race`='0', `type`='1', `type_flags`='2097224', `type_flags2`='0', `lootid`='0', `pickpocketloot`='0', `skinloot`='0', `resistance1`='0', `resistance2`='0', `resistance3`='0', `resistance4`='0', `resistance5`='0', `resistance6`='0', `spell1`='0', `spell2`='0', `spell3`='0', `spell4`='0', `spell5`='0', `spell6`='0', `spell7`='0', `spell8`='0', `VehicleId`='0', `mingold`='50000', `maxgold`='70000', `AIName`='', `MovementType`='0', `InhabitType`='3', `HoverHeight`='1', `HealthModifier`='20', `HealthModifierExtra`='1', `ManaModifier`='1', `ManaModifierExtra`='1', `ArmorModifier`='1', `DamageModifier`='1', `ExperienceModifier`='1', `RacialLeader`='0', `movementId`='0', `RegenHealth`='1', `mechanic_immune_mask`='0', `flags_extra`='0', `ScriptName`='', `VerifiedBuild`='25549' WHERE (`entry`='114770'); INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114770', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '591.979', '2722.14', '125.009', '1.859', '300', '0', '0', '16628280', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114770', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '604.88', '2710.86', '124.67', '2.89887', '300', '0', '0', '16628280', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114770', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '717.311', '2832.6', '125.383', '1.10816', '300', '0', '0', '16628280', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114770', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '703.206', '2811.29', '125.833', '1.90848', '300', '0', '0', '16628280', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114770', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '725.914', '2843.57', '124.354', '5.31397', '300', '0', '0', '16628280', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114770', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '683.144', '2855.45', '125.258', '2.98683', '300', '0', '0', '16628280', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114770', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '660.347', '2859.07', '125.251', '3.51305', '300', '0', '0', '16628280', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114770', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '614.463', '2768.44', '125.25', '5.4412', '300', '0', '0', '16628280', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114770', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '642.728', '2732.51', '125.25', '5.31161', '300', '0', '0', '16628280', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114770', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '616.702', '2722.7', '125.935', '3.58138', '300', '0', '0', '16628280', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114770', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '638.612', '2830.19', '125.25', '3.8492', '300', '0', '0', '16628280', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114770', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '611.847', '2813.47', '125.25', '4.49872', '300', '0', '0', '16628280', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114770', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '699.523', '2859.57', '125.229', '2.78656', '300', '0', '0', '16628280', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114770', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '604.559', '2731.36', '125.466', '0.37381', '300', '0', '0', '16628280', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114770', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '615.356', '2731.35', '125.74', '5.67682', '300', '0', '0', '16628280', '1', '0', '0', '0', '0', '0', '0', '', '0'); INSERT INTO `creature` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES ('114770', '1220', '0', '0', '1', '0', '0', '0', '-1', '0', '0', '723.958', '2826.77', '121.796', '0.693469', '300', '0', '0', '16628280', '1', '0', '0', '0', '0', '0', '0', '', '0');