Chucksta

[B][SIZE=3][COLOR="#008000"]Pull Request had been made with the SD2 scripts:[/COLOR][/SIZE][/B] [url]https://github.com/mangoszero/server/pull/275[/url] [B][SIZE=3][COLOR="#008000"]Pull Request has now been made for the SQL scripts:[/COLOR][/SIZE][/B] [url]https://github.com/mangoszero/database/pull/187[/url] They have both now been merged :D ------------------------------------------------------------------------------------ [B][SIZE=3][COLOR="#800080"]IMPLEMENTED SO FAR ON[/COLOR][/SIZE][/B] [B]ZERO, ONE[/B]

That's a very interesting and useful guide :)

***** [B][COLOR="#FF0000"]Eluna scripts to go here[/COLOR][/B] *****

***** [B][COLOR="#FF0000"]SD2 scripts to go here[/COLOR][/B] ***** [PHP] /*###### ## go_corrupted_plant ######*/ enum { FAILED_TO_LOCATE_QUEST = 0, QUEST_CORRUPTED_SONGFLOWER = 1, QUEST_CORRUPTED_NIGHT_DRAGON = 2, QUEST_CORRUPTED_WINDBLOSSOM = 3, QUEST_CORRUPTED_WHIPPER_ROOT = 4, GO_CLEANSED_SONGFLOWER = 164882, SPELL_SONGFLOWER_SERENADE = 15366, GO_CLEANSED_NIGHT_DRAGON = 164881, GO_CLEANSED_WINDBLOSSOM = 164884, GO_CLEANSED_WHIPPER_ROOT = 174687, PLANT_SPAWN_DURATION = 60 }; static const uint32 aCorruptedSongflowerQuestId[] = { 2278, 2523, 3363, 4113, 4116, 4118, 4401, 4464, 4465 }; // Corrupted Songflower static const uint32 aCorruptedNightDragonQuestId[] = { 4119, 4447, 4448, 4462 }; // Corrupted Night Dragon static const uint32 aCorruptedWindblossomQuestId[] = { 996, 998, 1514, 4115, 4221, 4222, 4343, 4403, 4466, 4466, 4467 }; // Corrupted Windblossom static const uint32 aCorruptedWhipperRootQuestId[] = { 4117, 4443, 4444, 4445, 4446, 4461 }; // Corrupted Whipper Root uint32 locateQuestId(uint32 uQuestToSearchFor, uint32 uQuestId) { int index = 0; if (uQuestToSearchFor == QUEST_CORRUPTED_SONGFLOWER) { // check Cleansed Songflower Quest IDs for (index = 0; index { if (uQuestId == aCorruptedSongflowerQuestId[index]) return QUEST_CORRUPTED_SONGFLOWER; } } else if (uQuestToSearchFor == QUEST_CORRUPTED_NIGHT_DRAGON) { // check Cleansed Night Dragon Quest IDs for (int index = 0; index { if (uQuestId == aCorruptedNightDragonQuestId[index]) return QUEST_CORRUPTED_NIGHT_DRAGON; } } else if (uQuestToSearchFor == QUEST_CORRUPTED_WINDBLOSSOM) { // check Cleansed Windblossom Quest IDs for (int index = 0; index { if (uQuestId == aCorruptedWindblossomQuestId[index]) return QUEST_CORRUPTED_WINDBLOSSOM; } } else if (uQuestToSearchFor == QUEST_CORRUPTED_WHIPPER_ROOT) { // check Cleansed Whipper Root Quest IDs for (int index = 0; index { if (uQuestId == aCorruptedWhipperRootQuestId[index]) return QUEST_CORRUPTED_WHIPPER_ROOT; } } return FAILED_TO_LOCATE_QUEST; // quest ID not located } void DespawnCorruptedPlant(GameObject* pGo) { pGo->SetSpawnedByDefault(false); pGo->SetRespawnTime(1); } bool QuestRewarded_go_corrupted_plant(Player* pPlayer, GameObject* pGo, const Quest* pQuest) { // acquire plant's coordinates float fX, fY, fZ; pGo->GetPosition(fX, fY, fZ); uint32 uQuestId = pQuest->GetQuestId(); if (locateQuestId(QUEST_CORRUPTED_SONGFLOWER, uQuestId) == QUEST_CORRUPTED_SONGFLOWER) { // despawn corrupted plant DespawnCorruptedPlant(pGo); // spawn cleansed plant pPlayer->SummonGameObject(GO_CLEANSED_SONGFLOWER, fX, fY, fZ, 0.0f, PLANT_SPAWN_DURATION); } else if (locateQuestId(QUEST_CORRUPTED_NIGHT_DRAGON, uQuestId) == QUEST_CORRUPTED_NIGHT_DRAGON) { // despawn corrupted plant DespawnCorruptedPlant(pGo); // spawn cleansed plant pPlayer->SummonGameObject(GO_CLEANSED_NIGHT_DRAGON, fX, fY, fZ, 0.0f, PLANT_SPAWN_DURATION); } else if (locateQuestId(QUEST_CORRUPTED_WINDBLOSSOM, uQuestId) == QUEST_CORRUPTED_WINDBLOSSOM) { // despawn corrupted plant DespawnCorruptedPlant(pGo); // spawn cleansed plant pPlayer->SummonGameObject(GO_CLEANSED_WINDBLOSSOM, fX, fY, fZ, 0.0f, PLANT_SPAWN_DURATION); } else if (locateQuestId(QUEST_CORRUPTED_WHIPPER_ROOT, uQuestId) == QUEST_CORRUPTED_WHIPPER_ROOT) { // despawn corrupted plant DespawnCorruptedPlant(pGo); // spawn cleansed plant pPlayer->SummonGameObject(GO_CLEANSED_WHIPPER_ROOT, fX, fY, fZ, 0.0f, PLANT_SPAWN_DURATION); } else return false; return true; } // This is only used for the Corrupted Songflower quest; actually for when interacting with the cleansed songflower bool GOUse_go_cleansed_plant(Player* pPlayer, GameObject* pGo) { // cast spell on player pPlayer->CastSpell(pPlayer, SPELL_SONGFLOWER_SERENADE, true); return true; } void AddSC_felwood() { Script* pNewScript; pNewScript = new Script; pNewScript->Name = "go_corrupted_plant"; pNewScript->pQuestRewardedGO = &QuestRewarded_go_corrupted_plant; pNewScript->RegisterSelf(); pNewScript = new Script; pNewScript->Name = "go_cleansed_plant"; pNewScript->pGOUse = &GOUse_go_cleansed_plant; pNewScript->RegisterSelf(); }[/PHP] This script, once completed, will deal with all types of corrupted plants (Felwood quests). [B][COLOR="#0000FF"]FULLY IMPLENTED SO FAR:[/COLOR][/B] [LIST] [*]Corrupted Songflower [*]Corrupted Night Dragon [*]Corrupted Windblossom [*]Corrupted Whipper Root [/LIST] [B][COLOR="#FF0000"]STILL TOO DO[/COLOR][/B][LIST] [*]ALL DONE, TIME TO PR THE FIX :D [/LIST]

***** [B][COLOR="#FF0000"]SQL scripts to go here[/COLOR][/B] ***** Corrupted plants had been made lootable, but it should be the cleansed plants. [B][SIZE=3][COLOR="#0000FF"]Cleansed Windblossom[/COLOR][/SIZE][/B] [B]-- Delete Corrupted Windblossom entries[/B] [COLOR="#0000FF"]DELETE FROM gameobject_loot_template where item = 11950;[/COLOR] -- New [B]gameobject_loot_template[/B] records for Cleansed Windblossom -- Cleansed Windblossom ([B]gameobject_template[/B]: 164884, 173326, 174616, 174617, 174618, 174619, 174620, 174621, 174710, 174711) [COLOR="#0000FF"]INSERT INTO gameobject_loot_template (entry, item, ChanceOrQuestChance, groupid, mincountOrRef, maxcount, condition_id) VALUES (164884, 11950, 100, 0, 1, 3, 0);[/COLOR] -- Replace Cleansed Windblossom [B][B]gameobject_template [/B][/B]records -- the plants will now be lootable [COLOR="#0000FF"]UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 164884, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 164884; UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 173326, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 173326; UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 174616, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 174616; UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 174617, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 174617; UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 174618, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 174618; UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 174619, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 174619; UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 174620, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 174620; UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 174621, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 174621; UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 174710, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 174710; UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 174711, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 174711;[/COLOR] -- Assign a script to each of the corrupted Windblossom gameobject_template records [COLOR="#0000FF"]UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='164887'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='173327'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174599'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174600'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174601'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174602'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174603'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174604'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174708';[/COLOR] -- Delete all cleansed Windblossom [B]gameobject [/B]records (not required because the script spawns them) [COLOR="#0000FF"]DELETE FROM gameobject WHERE id IN (164884, 173326, 174616, 174617, 174618, 174619, 174620, 174621, 174710, 174711);[/COLOR] -- Delete all but one cleansed Windblossom record from [B]gameobject_template [/B](we only need one) [COLOR="#0000FF"]DELETE FROM gameobject_template WHERE entry IN (173326, 174616, 174617, 174618, 174619, 174620, 174621, 174710, 174711);[/COLOR] [B][SIZE=3][COLOR="#0000FF"]Cleansed Night Dragon[/COLOR][/SIZE][/B] [B]-- Delete Corrupted Night Dragon entries[/B] [COLOR="#0000FF"]DELETE FROM gameobject_loot_template where item = 11952;[/COLOR] -- New [B]gameobject_loot_template [/B]records for Cleansed Night Dragon -- Cleansed Night Dragon ([B]gameobject_template[/B]: 164881, 173325, 174609, 174685) [COLOR="#0000FF"]INSERT INTO gameobject_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `condition_id`) VALUES ('164881', '11952', '100', '0', '1', '3', '0');[/COLOR] -- Replace Cleansed Night Dragon [B]gameobject_template [/B]records -- the plants will now be lootable [COLOR="#0000FF"]UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 164881, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 164881; UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 173325, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 173325; UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 174609, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 174609; UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 174685, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 174685;[/COLOR] -- Assign a script to each of the corrupted Night Dragon gameobject_template records [COLOR="#0000FF"]UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='164885'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='173324'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174608'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174684';[/COLOR] -- Delete all cleansed Night Dragon [B]gameobject [/B]records (not required because the script spawns them) [COLOR="#0000FF"]DELETE FROM gameobject WHERE id IN (164881, 173325, 174609, 174685);[/COLOR] -- Delete all but one cleansed Night Dragon record from [B]gameobject_template [/B](we only need one) [COLOR="#0000FF"]DELETE FROM gameobject_template WHERE entry IN (173325, 174609, 174685);[/COLOR] [B][SIZE=3][COLOR="#0000FF"]Cleansed Songflower[/COLOR][/SIZE][/B] -- Assign a script to each of the corrupted songflower gameobject_template records [COLOR="#0000FF"]UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='164886'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='171939'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='171942'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174594'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174595'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174596'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174598'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174712'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174713';[/COLOR] -- Delete the CompleteQuest script (set to 0) for the corrupted songflower quest (the above assigned script will now deal with this) [COLOR="#0000FF"]UPDATE `mangosZero`.`quest_template` SET `CompleteScript`='0' WHERE `entry`='2523';[/COLOR] Delete the dbscripts_on_quest_end record too ???? I am going to script the looting of the cleansed songflower as the DB script is not working. Original record: '164882', '10', '3232', 'Cleansed Songflower', '0', '0', '2', '259', '0', '4059', '0', '0', '0', '0', '0', '0', '0', '15366', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '' -- Assign a script to the cleansed songflower gameobject_template record [COLOR="#0000FF"]UPDATE gameobject_template SET `data2`='0', `data10`='0', `ScriptName`= 'go_cleansed_plant' WHERE `entry`='164882';[/COLOR] -- Delete all cleansed songflower [B]gameobject [/B]records (not required because the script spawns them) [COLOR="#0000FF"]DELETE FROM gameobject WHERE id IN (164882, 171940, 171943, 174610, 174612, 174613, 174614, 174615, 174714, 174715);[/COLOR] -- Delete all but one cleansed songflower record from [B]gameobject_template [/B](we only need one) [COLOR="#0000FF"]DELETE FROM gameobject_template WHERE entry IN (171940, 171943, 174610, 174612, 174613, 174614, 174615, 174714, 174715);[/COLOR] [B][COLOR="#0000FF"]That worked perfectly[/COLOR][/B] :) Corrupted Songflower now completed! [B][SIZE=3][COLOR="#0000FF"]Cleansed Whipper Root[/COLOR][/SIZE][/B] -- Delete Corrupted Windblossom entries [COLOR="#0000FF"]DELETE FROM gameobject_loot_template where item = 11950;[/COLOR] -- [B]REMOVE UNWANTED CLEANSED WHIPPER ROOT RECORDS[/B] (there are 2 of each, but only one of each is needed/correct - see above table) [COLOR="#0000FF"]DELETE FROM gameobject WHERE `guid`='17660';[/COLOR] [COLOR="#0000FF"]DELETE FROM gameobject WHERE `guid`='17662';[/COLOR] [COLOR="#0000FF"]DELETE FROM gameobject WHERE `guid`='17664';[/COLOR] [COLOR="#0000FF"]DELETE FROM gameobject WHERE `guid`='18176';[/COLOR] [COLOR="#0000FF"]DELETE FROM gameobject WHERE `guid`='18178';[/COLOR] [COLOR="#0000FF"]DELETE FROM gameobject WHERE `guid`='18180';[/COLOR] -- [B]New gameobject_loot_template records for Cleansed Whipper Root[/B] -- Cleansed Whipper Root (gameobject_template: 164883, 174622, 174623, 174624, 174625, 174687) [COLOR="#0000FF"]DELETE FROM gameobject_loot_template WHERE item = 11951; INSERT INTO gameobject_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `condition_id`) VALUES ('164883', '11951', '100', '0', '1', '3', '0');[/COLOR] -- Replace Cleansed Whipper Root [B]gameobject_template[/B] records -- the plants will now be lootable [COLOR="#0000FF"]DELETE FROM gameobject_template where name = "Cleansed Whipper Root";[/COLOR] [COLOR="#0000FF"]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`, `mingold`, `maxgold`, `ScriptName`) VALUES ('164883', '3', '3255', 'Cleansed Whipper Root', '0', '0', '2', '43', '164883', '0', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ''),('174622', '3', '3255', 'Cleansed Whipper Root', '0', '0', '2', '43', '174622', '0', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ''),('174623', '3', '3255', 'Cleansed Whipper Root', '0', '0', '2', '43', '174623', '0', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ''),('174624', '3', '3255', 'Cleansed Whipper Root', '0', '0', '2', '43', '174624', '0', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ''),('174625', '3', '3255', 'Cleansed Whipper Root', '0', '0', '2', '43', '174625', '0', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ''),('174687', '3', '3255', 'Cleansed Whipper Root', '0', '0', '2', '43', '174687', '0', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');[/COLOR] -- [B]INCORRECT GUID USED FOR SPAWNING CLEANSED WHIPPER ROOT[/B] [COLOR="#0000FF"]UPDATE dbscripts_on_quest_end SET datalong = 48882 WHERE id = 4443;[/COLOR] -- Assign a script to each of the corrupted Whipper Root gameobject_template records [COLOR="#0000FF"]UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='164888'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='173284'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174605'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174606'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174607'; UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174686';[/COLOR] -- Delete all cleansed songflower gameobject records (not required because the script spawns them) [COLOR="#0000FF"]DELETE FROM gameobject WHERE id IN (164883, 174622, 174623, 174624, 174625, 174687);[/COLOR] -- Delete all but one cleansed songflower record from gameobject_template (we only need one) [COLOR="#0000FF"]DELETE FROM gameobject_template WHERE entry IN (174622, 174623, 174624, 174625, 174687);[/COLOR] -- remove scripts [COLOR="#0000FF"]UPDATE quest_template SET CompleteScript = 0 WHERE entry IN (996, 998, 1514, 2523, 2878, 3363, 4113, 4114, 4115, 4116, 4117, 4118, 4119, 4221, 4222, 4343, 4401, 4403, 4443, 4444, 4445, 4446, 4447, 4448, 4461, 4462, 4464, 4465, 4466, 4467);[/COLOR] -- These are handled by scripdev scripts, therefore can be deleted [COLOR="#0000FF"]DELETE FROM dbscripts_on_quest_end WHERE id IN (996, 998, 1514, 2523, 2878, 3363, 4113, 4114, 4115, 4116, 4117, 4118, 4119, 4221, 4222, 4343, 4401, 4403, 4443, 4444, 4445, 4446, 4447, 4448, 4461, 4462, 4464, 4465, 4466, 4467);[/COLOR]

This should be under scripts, although it will also involve the database (e.g. Stitches' movement). This is also being looked at under Zero: [url]https://www.getmangos.eu/issue.php?issueid=661[/url] [url]https://www.getmangos.eu/issue.php?issueid=338[/url] This could be quite involved, coding wise, but fun, I reckon.

[quote=Xenithar]Good point, if the mob is already there, all it has to do is trigger everything when the mast is used. I saw one of these "mob-triggers" today in LBRS. I was in the area wit the trolls testing some AI and I noticed a small infernal with the warlord. It had the name of a trigger, and turning off GM mode made it invisible.[/quote] Interesting, well I learned some here with your and Evildead's input/findings, thanks :D ------------------------------------------------------------------------------------ [B][SIZE=3][COLOR="#800080"]IMPLEMENTED SO FAR ON[/COLOR][/SIZE][/B] [B]ZERO, ONE, SD3[/B] But I will be changing the script to spawn the invisible creature! ------------------------------------------------------------------------------------- [B][COLOR="#008000"][SIZE=3]Final fix commited:[/SIZE][/COLOR][/B] [url]https://github.com/mangoszero/server/pull/276[/url]

I'll test it out tomorrow with the invisible mob. Antz said he is going to deal with all current PRs by the end of tonight, so I thought it would be good to have this working in one for at least. Using the invisible mob will presumably mean less code for the script, as long as he/she does spawn the pirates. Hmm, actually, if it just requires the spawning of this invisible mob, then that can be done via the database. I'll check it out tomorrow. That's enough for me today... chill time :D

[quote=Evildead]Getting even more funny [url]http://www.wowhead.com/spell=11462[/url] There is another spell, this actually cast the chest and an invisible mob, use gm to see it Sometimes Blizz used some courious methods to create quests. I Guess using the map triggers 11462 the invisible mob cast the mob spawns 11463 11485 11487[/quote] lol, interesting. Thanks for the info :D

Thanks for the info, EvilDead :) I've closed the PR I made for the script, as I have reduced the code used, so I could look into using a spell instead. Right now I have no idea how to do so, but that's half the fun :)

[B][SIZE=3][COLOR="#008000"]Pull Request has now been made for the database side of this fix.[/COLOR][/SIZE][/B] [url]https://github.com/mangoszero/database/pull/185[/url] [B][SIZE=3][COLOR="#008000"]Pull Request has now been made with for the SD2 fix for this issue[/COLOR][/SIZE][/B] [url]https://github.com/mangoszero/server/pull/274[/url] I'll PR the Eluna script tomorrow, along with the ones I forgot to do!

[SIZE=3][COLOR="#FF0000"]Eluna Script to go here[/COLOR][/SIZE] [PHP]--[[ EmuDevs Eluna Lua Engine Eluna Scripts Eluna Wiki -= Script Information =- * Zone: Tanaris * Script Type: Quest (Cuergo's Gold 2882) * Creature: Sailor boys (Treasure Hunting Pirate: 7899, Treasure Hunting Swashbuckler: 7901, Treasure Hunting Buccaneer: 7902) * Game object: Pirate's treasure chest (142194) * Version: tested on Zero --]] -- This creates the table used to localize all variables and functions local CuergoGold = { GO_INCONSPICUOUS_LANDMARK = 142189, NPC_PIRATE = 7899, NPC_SWASHBUCKLER = 7901, NPC_BUCCANEER = 7902, GO_PIRATE_TREASURE = 142194, SPAWN_DURATION = 600000 -- pirates and chest will exist in world for 10 minutes } function CuergoGold.PirateTreasure_OnUse(event, player, go) -- despawn the chest go:Despawn(10) end function SpawnPirates(player, totalPirates) for i = 1, totalPirates, 1 do local X = player:GetX() + math.random(5); local Y = player:GetY() + math.random(5); local Z = player:GetZ(); local pirate = math.random(1,3) if pirate == 1 then player:SummonCreature(CuergoGold.NPC_PIRATE, X, Y, Z, 0, 1, CuergoGold.SPAWN_DURATION) elseif pirate == 2 then player:SummonCreature(CuergoGold.NPC_SWASHBUCKLER, X, Y, Z, 0, 1, CuergoGold.SPAWN_DURATION) else player:SummonCreature(CuergoGold.NPC_BUCCANEER, X, Y, Z, 0, 1, CuergoGold.SPAWN_DURATION) end end end function CuergoGold.InconspicuousLandmark_OnUse(event, player, go) local totalPirates = math.random(4,5) SpawnPirates(player, totalPirates) -- spawn the chest player:SummonGameObject(CuergoGold.GO_PIRATE_TREASURE, -10117.715, -4051.644, 5.407, 0, CuergoGold.SPAWN_DURATION) end -- Register the events RegisterGameObjectGossipEvent(CuergoGold.GO_INCONSPICUOUS_LANDMARK, 1, CuergoGold.InconspicuousLandmark_OnUse) RegisterGameObjectGossipEvent(CuergoGold.GO_PIRATE_TREASURE, 1, CuergoGold.PirateTreasure_OnUse)[/PHP] Script tested in game and working :) Tidy up time!

[SIZE=3][COLOR="#FF0000"]SD2 Script to go here[/COLOR][/SIZE] [B][SIZE=3]tanaris.cpp[/SIZE][/B] [PHP] /*###### ## go_inconspicuous_landmark ## This is for Cuergo's Gold quest ######*/ enum { NPC_TREASURE_HUNTING_PIRATE = 7899, NPC_TREASURE_HUNTING_SWASHBUCKLER = 7901, NPC_TREASURE_HUNTING_BUCCANEER = 7902, GO_PIRATE_TREASURE = 142194, SPAWN_DURATION = 600000 // pirates and chest will exist in world for 10 minutes }; bool GOUse_go_pirate_treasure(Player* pPlayer, GameObject* pGo) { // despawn chest pGo->SetSpawnedByDefault(false); pGo->SetRespawnTime(10); return true; } void SpawnPirates(Player* pPlayer, uint iNumberOfPirates) { for (int i; i { // spawn 4 or 5 sailor boys switch (urand(0, 2)) { case 0: // spawn treasure hunting pirate pPlayer->SummonCreature(NPC_TREASURE_HUNTING_PIRATE, 0.0f, 0.0f, 0.0f, 0.0f, TEMPSUMMON_TIMED_DESPAWN, SPAWN_DURATION); break; case 1: // spawn treasure hunting swashbuckler pPlayer->SummonCreature(NPC_TREASURE_HUNTING_SWASHBUCKLER, 0.0f, 0.0f, 0.0f, 0.0f, TEMPSUMMON_TIMED_DESPAWN, SPAWN_DURATION); break; default: // spawn treasure hunting buccaneer pPlayer->SummonCreature(NPC_TREASURE_HUNTING_BUCCANEER, 0.0f, 0.0f, 0.0f, 0.0f, TEMPSUMMON_TIMED_DESPAWN, SPAWN_DURATION); break; } } } bool GOUse_go_inconspicuous_landmark(Player* pPlayer, GameObject* pGo) { // spawn 4 or 5 sailor boys SpawnPirates(pPlayer, urand(4, 5)); // spawn chest pPlayer->SummonGameObject(GO_PIRATE_TREASURE, -10117.715, -4051.644, 5.407, 0.0f, SPAWN_DURATION); return true; } void AddSC_tanaris() { Script* pNewScript; pNewScript = new Script; pNewScript->Name = "go_pirate_treasure"; pNewScript->pGOUse = &GOUse_go_pirate_treasure; pNewScript->RegisterSelf(); pNewScript = new Script; pNewScript->Name = "go_inconspicuous_landmark"; pNewScript->pGOUse = &GOUse_go_inconspicuous_landmark; pNewScript->RegisterSelf(); pNewScript = new Script; pNewScript->Name = "mob_aquementas"; pNewScript->GetAI = &GetAI_mob_aquementas; pNewScript->RegisterSelf(); pNewScript = new Script; pNewScript->Name = "npc_oox17tn"; pNewScript->GetAI = &GetAI_npc_oox17tn; pNewScript->pQuestAcceptNPC = &QuestAccept_npc_oox17tn; pNewScript->RegisterSelf(); pNewScript = new Script; pNewScript->Name = "npc_stone_watcher_of_norgannon"; pNewScript->pGossipHello = &GossipHello_npc_stone_watcher_of_norgannon; pNewScript->pGossipSelect = &GossipSelect_npc_stone_watcher_of_norgannon; pNewScript->RegisterSelf(); pNewScript = new Script; pNewScript->Name = "npc_tooga"; pNewScript->GetAI = &GetAI_npc_tooga; pNewScript->pQuestAcceptNPC = &QuestAccept_npc_tooga; pNewScript->RegisterSelf(); } [/PHP] This script along with the SQL scripts, resulted in the quest now being completable :D I'll now PR these, then I'll code the Eluna script. Note: for some reason I am unable to add anything else to the above post (SQL scripts). It just lags!

[SIZE=3]***** [B][COLOR="#FF0000"]SQL scripts to go in this post[/COLOR][/B] *****[/SIZE] [B]-- Set the chance for the key to drop to 100%[/B] [COLOR="#0000FF"]UPDATE creature_loot_template SET ChanceOrQuestChance=100 WHERE entry=7899 and item=9275; UPDATE creature_loot_template SET ChanceOrQuestChance=100 WHERE entry=7901 and item=9275; UPDATE creature_loot_template SET ChanceOrQuestChance=100 WHERE entry=7902 and item=9275;[/COLOR] [B]-- add script to the Inconspicuous Landmark game object[/B] [COLOR="#0000FF"]UPDATE gameobject_template SET ScriptName= 'go_inconspicuous_landmark' WHERE entry=142189;[/COLOR] [B]-- add script to the Pirate's Treasure game object[/B] [COLOR="#0000FF"]UPDATE gameobject_template SET ScriptName='go_pirate_treasure' WHERE entry=142194;[/COLOR]

[B][SIZE=4]SCRIPT CONSTRUCTION[/SIZE][/B] On use of the Inconspicuous Landmark ([B]gameobject_template[/B] [B][COLOR="#800080"]entry [/COLOR][/B]142189) 1) Spawn 4 or 5 sailors 2) Spawn chest [B][SIZE=3]The Chest[/SIZE][/B] The chest appears to be: [B]gameobject_template[/B] [B][COLOR="#800080"]entry [/COLOR][/B]142194 [url]http://www.wowwiki.com/Pirate%27s_Treasure[/url]! This has the quest 2391 linked to it. That quest does not exist, in the database or on the net. The chest does not have a [B]gameobject [/B]table entry, therefore it is obviously meant to be spawned, and seeing as it is named the same as the one for this quest, it is more than likely the one we need. [B][SIZE=3]The Pirates[/SIZE][/B] [url]http://www.wowwiki.com/Inconspicuous_Landmark[/url] There are 3 types: [URL="http://www.wowwiki.com/Treasure_Hunting_Pirate?veaction=edit&redlink=1"]Treasure Hunting Pirate[/URL] [B]creature_template[/B] [B][COLOR="#800080"]Entry [/COLOR][/B]7899 [URL="http://www.wowwiki.com/Treasure_Hunting_Swashbuckler?veaction=edit&redlink=1"]Treasure Hunting Swashbuckler[/URL] [B]creature_template[/B] [B][COLOR="#800080"]Entry [/COLOR][/B]7901 [URL="http://www.wowwiki.com/Treasure_Hunting_Buccaneer?veaction=edit&redlink=1"]Treasure Hunting Buccaneer[/URL] [B]creature_template[/B] [B][COLOR="#800080"]Entry [/COLOR][/B]7902 [B][SIZE=3]The Key[/SIZE][/B] Cuergo's Key [B]item_template[/B] [B][COLOR="#800080"]entry [/COLOR][/B]9275 This is currently set to -100 for the drop chance in the [B][COLOR="#800080"]creature_loot_template[/COLOR][/B]!!! It will never drop!!! [url]http://db.vanillagaming.org/?item=9275[/url] --------------------------------------------------------------------------------------- Okay, that's all the information gathered re the database. I reckon the chest record ([B]item_template[/B]) will need altering, seeing as the quest associated with it does not exist, but I'll leave that for now until I have the script running, then I'll know for sure what needs to be done. Coding/scripting time!!!!

I was going to code this up in SD2 first :D I need to sort out the changes to the database first, plus note down all items, objects, creatur I'll probably need to randomise the type of pirate, I'll see if there is more than one version.es I will need for the script. How about this for an idea: Cabin boy, yielding a cutlass ? lol ;) Pirate record + boy modelID

Yeah, looking at the comments, people mention both 4 and 5 pirates. I'll base it on that unless I can confirm otherwise from a more reliable source.

Very strange! Oh well, I'll get it to spawn the pirates on use of the game object, then there will be no more waiting around :) I will no doubt also need to create a new creature entry for the sailor/pirate and assign the loot (key) to it. % chance of drop for the key ????????? If I am reading this right, the chest spawns along with the sailors. Also, it appears that the number of sailors is random. [QUOTE]How to do it: I did it with my 42 druid. What I did was stealth to the "Landmark", then wait til the turtles are far enough so I won't aggro them and begin opening, once it is opened, the chest and the 5 pirates spawned, I shapshifted and ran back towards the mountain to prevent aggroing ANYTHING. I pulled 3 of the 5 pirates and took them down slowly in bear form, then I loot the key from one of the mobs. HOWEVER, the chest and the 2 remaining pirates DESPAWNED. So, I reopened the "Landmark" again, 5 pirates and the chest then respawn, restealthed, then went straight for the chest without pulling any of them. Complete the quest, got my chest, and hearthed out.[/QUOTE] And, OH NO - Spawning and Despawning!!!! -------------------------------------------------------------- Actually, there should be no issue here with the spawning/despawning, because spawning only occurs after the object is interacted with (on use) :D

Yeah, it looks like a script is needed here. The database [B] dbscripts_on_go_template_use[/B] could be used for this, but it looks like it can only spawn one creature: [url]https://github.com/cmangos/issues/wiki/DBScripts[/url]. A script can be coded up and its name entered in the ScriptName field of the Inconspicuous Landmark's gameobject_template record. The reason why the Inconspicuous Landmark could not always be interacted with, is because it is set to auto close after use, so would require a reboot of the server (mangos) for it to be usable again.

Oo, I've not been to Tanaris for a while! To Tanaris we go, and don't spare the horses!!!!! ------------------------------------------------------------------------------------- [url]http://www.wowhead.com/quest=2882/cuergos-gold[/url] [QUOTE]How & Where: To get this chest or quest, you will have to kill pirates East of Tanaris. These pirates are the ones you kill for Steamweedle Port quests, and their location is on the East side of Caverns of Time. Items required: To get the items for the quest, you will have to keep killing the pirates until a Pirate's Footlocker. It has a 3.9% drop rate, these Footlockers will give you map fragments, depending on your luck, you may get Lower Map Fragment OR Middle Map Fragment OR Upper Map Fragmentwhich will combine by right clicking one of them into Cuergo's Treasure Map. Right clicking this Quest Item will begin this quest: Cuergo's Gold For this Quest, you will need to venture all the way south of Tanaris, you will need to swim along the coast and mountains for abit, before reaching the EXACT PLACE where you can get your Cuergo's Hidden Treasure.[/QUOTE] [URL="http://www.wowhead.com/item=9252"]Lower map fragment[/URL] [URL="http://www.wowhead.com/item=9253"]Middle map fragment[/URL] [URL="http://www.wowhead.com/item=9251"]Upper map fragment[/URL] Reward for this quest ([B]item_template[/B]: 9275): [url]http://www.wowwiki.com/Cuergo%27s_Hidden_Treasure[/url] ------------------------------------------------------------------------------- [SIZE=3][B]Confirmed![/B][/SIZE] When you interact with the Inconspicuous Landmark, nothing happens. Inconspicuous Landmark [B]gameobject_template [/B]Entry 142189 ------------------------------------------------------------------------------ The Inconspicuous Landmark may have the wrong object type ([B]gameobject_template [/B][B][COLOR="#800080"]type[/COLOR][/B] field): [url]https://github.com/cmangos/issues/wiki/gameobject_template[/url] I'll look into this further later... neeeeeeeed caffeine hit!!! A quick look, and the Type is fine. All settings appear to be correct. It just needs to have a script assigned to it (coded up) to spawn the sailor boys ;)

[B][COLOR="#008000"][SIZE=3]Pull Request has now been made with the fix for this issue:[/SIZE][/COLOR][/B] [url]https://github.com/mangoszero/database/pull/184[/url] ------------------------------------------------------------------------------------------------- [B][SIZE=3][COLOR="#800080"]IMPLEMENTED SO FAR ON[/COLOR][/SIZE][/B] [B]ZERO, ONE[/B]

[SIZE=3]*****[B][COLOR="#FF0000"] Table of creatures and associated SQL scripts[/COLOR][/B]*****[/SIZE] [table="width: 500, class: grid, align: center"] [tr] [td][B][SIZE=3]Current Creature[/SIZE][/B][/td] [td][/td] [td][/td] [td][B][SIZE=3]Correct Creature[/SIZE][/B][/td] [td][/td] [td][/td] [td][/td] [td][/td] [td][/td] [td][/td] [/tr] [tr] [td][B]Name[/B][/td] [td][B]Entry[/B][/td] [td][B]Guid[/B][/td] [td][B]Name[/B][/td] [td][B]Entry[/B][/td] [td][B]Guid[/B][/td] [td][B][CENTER]X[/CENTER][/B][/td] [td][B][CENTER]Y[/CENTER][/B][/td] [td][B][CENTER]Z[/CENTER][/B][/td] [td][B][CENTER]O[/CENTER][/B][/td] [/tr] [tr] [td]Chromatic Dragonspawn[/td] [td]10447[/td] [td]45814[/td] [td]No creature[/td] [td][/td] [td][/td] [td]-48.1343[/td] [td]-389.362[/td] [td]77.7707[/td] [td]4.70733[/td] [/tr] [tr] [td]Chromatic Dragonspawn[/td] [td]10447[/td] [td]45813[/td] [td]No creature[/td] [td][/td] [td][/td] [td]-58.51[/td] [td]-389[/td] [td]77.95[/td] [td]4.75[/td] [/tr] [tr] [td]Chromatic Dragonspawn[/td] [td]10447[/td] [td]45816[/td] [td]Smolderthorn Berserker[/td] [td]9268[/td] [td][/td] [td]-48.38[/td] [td]-425.97[/td] [td]77.93[/td] [td]1.55[/td] [/tr] [tr] [td]Chromatic Dragonspawn[/td] [td]10447[/td] [td]45815[/td] [td]Spirestone Warlord[/td] [td]9216[/td] [td][/td] [td]-58.4069[/td] [td]-425.825[/td] [td]77.7506[/td] [td]1.59715[/td] [/tr] [tr] [td]Chromatic Dragonspawn[/td] [td]10447[/td] [td]45809[/td] [td]Spirestone Warlord[/td] [td]9216[/td] [td][/td] [td]-52.73[/td] [td]-478.49[/td] [td]78.1[/td] [td]1.346[/td] [/tr] [tr] [td]Chromatic Whelp[/td] [td]10442[/td] [td]45817[/td] [td]Smolderthorn Berserker[/td] [td]9268[/td] [td][/td] [td]-64.069[/td] [td]-480.389[/td] [td]77.914[/td] [td]6.275[/td] [/tr] [tr] [td]Rage Talon Flamescale[/td] [td]10083[/td] [td]45760[/td] [td]Bloodaxe Veteran[/td] [td]9583[/td] [td][/td] [td]-58.001[/td] [td]-480.241[/td] [td]77.914[/td] [td]3.18[/td] [/tr] [tr] [td]Rage Talon Flamescale[/td] [td]10083[/td] [td]45761[/td] [td]Bloodaxe Evoker[/td] [td]9693[/td] [td][/td] [td]-61.127[/td] [td]-474.629[/td] [td]77.914[/td] [td]4.35 [/td] [/tr] [tr] [td]Chromatic Dragonspawn[/td] [td]10447[/td] [td]45811[/td] [td]Spirestone Warlord[/td] [td]9216[/td] [td][/td] [td]-75.999[/td] [td]-515.288[/td] [td]80.924[/td] [td]3.125[/td] [/tr] [tr] [td]Chromatic Whelp[/td] [td]10442[/td] [td]45821[/td] [td]Smolderthorn Berserker[/td] [td]9268[/td] [td][/td] [td]-83.476[/td] [td]-515.330[/td] [td]81.578[/td] [td]6.192[/td] [/tr] [tr] [td]Chromatic Whelp[/td] [td]10442[/td] [td]45820[/td] [td]Smolderthorn Berserker[/td] [td]9268[/td] [td][/td] [td]-41.031[/td] [td]-514.179[/td] [td]88.564[/td] [td]1.256[/td] [/tr] [tr] [td]Chromatic Whelp[/td] [td]10442[/td] [td]45819[/td] [td]Bloodaxe Evoker[/td] [td]9693[/td] [td][/td] [td]-79.694[/td] [td]-510.697[/td] [td]80.464[/td] [td]4.7[/td] [/tr] [tr] [td]Chromatic Dragonspawn[/td] [td]10447[/td] [td]45812[/td] [td]Bloodaxe Veteran[/td] [td]9583[/td] [td][/td] [td]-47.379[/td] [td]-516.18[/td] [td]88.272[/td] [td]4.252[/td] [/tr] [tr] [td]Chromatic Whelp[/td] [td]10442[/td] [td]45822[/td] [td]Bloodaxe Evoker[/td] [td]9693[/td] [td][/td] [td]-55.66[/td] [td]-525.15[/td] [td]85.01[/td] [td]2.49[/td] [/tr] [tr] [td]Rage Talon Flamescale[/td] [td]10083[/td] [td]45759[/td] [td]Smolderthorn Berserker[/td] [td]9268[/td] [td][/td] [td]-49.719[/td] [td]-519.474[/td] [td]87.595[/td] [td]1.028[/td] [/tr] [tr] [td]Rage Talon Flamescale[/td] [td]10083[/td] [td]45759[/td] [td]Bloodaxe Raider[/td] [td]9692[/td] [td][/td] [td]-40.012[/td] [td]-522.6[/td] [td]87.546[/td] [td]2.685[/td] [/tr] [tr] [td]Chromatic Whelp[/td] [td]10442[/td] [td]45818[/td] [td]Bloodaxe Worg[/td] [td]9696[/td] [td][/td] [td]-41.648[/td] [td]-525.099[/td] [td]87.115[/td] [td]2.622[/td] [/tr] [tr] [td]Chromatic Dragonspawn[/td] [td]10447[/td] [td]45810[/td] [td]Bloodaxe Evoker[/td] [td]9693[/td] [td][/td] [td]-37.378[/td] [td]-501.373[/td] [td]79.999[/td] [td]2.252[/td] [/tr] [/table] [B][SIZE=3][COLOR="#008000"]SCRIPTS[/COLOR][/SIZE][/B] [B]-- Delete unwanted creatures[/B] [B][COLOR="#0000FF"]DELETE FROM creature WHERE guid IN (45813, 45814);[/COLOR][/B] [B]-- Replace incorrect creatures with the correct ones[/B] [B][COLOR="#0000FF"]UPDATE creature SET id = 9268, modelid = 7803, curhealth = 8355 WHERE guid = 45816;[/COLOR][/B] [B][COLOR="#0000FF"]UPDATE creature SET id = 9216, modelid = 11582, curhealth = 13936 WHERE guid = 45815;[/COLOR][/B] [B][COLOR="#0000FF"]UPDATE creature SET id = 9216, modelid = 11582, curhealth = 13936, orientation = 1.346 WHERE guid = 45809;[/COLOR][/B] [B][COLOR="#0000FF"]UPDATE creature SET id = 9268, modelid = 7803, curhealth = 8355, position_x = -64.069, position_y = -480.389, position_z = 77.914, orientation = 6.275 WHERE guid = 45817;[/COLOR][/B] [B][COLOR="#0000FF"]UPDATE creature SET id = 9583, modelid = 9633, curhealth = 8569, position_x = -58.001, position_y = -480.241, position_z = 77.914, orientation = 3.18 WHERE guid = 45760;[/COLOR][/B] [B][COLOR="#0000FF"]UPDATE creature SET id = 9693, modelid = 9625, curhealth = 6893, curmana = 2289, position_x = -61.127, position_y = -474.629, position_z = 77.914, orientation = 4.35 WHERE guid = 45761;[/COLOR][/B] [B][COLOR="#0000FF"]UPDATE creature SET id = 9216, modelid = 11582, curhealth = 13936, position_x = -75.999, position_y = -515.288, position_z = 80.924, orientation = 3.125 WHERE guid = 45811;[/COLOR][/B] [B][COLOR="#0000FF"]UPDATE creature SET id = 9268, modelid = 7803, curhealth = 8355, position_x = -83.476, position_y =-515.33, position_z = 81.578, orientation = 6.192 WHERE guid = 45821;[/COLOR][/B] [B][COLOR="#0000FF"]UPDATE creature SET id = 9693, modelid = 9625, curhealth = 6893, curmana = 2289, position_x = -37.378, position_y =-501.373, position_z = 79.999, orientation = 2.252 WHERE guid = 45810;[/COLOR][/B] [B][COLOR="#0000FF"]UPDATE creature SET id = 9693, modelid = 9625, curhealth = 6893, curmana = 2289, position_x = -79.694, position_y =-510.697, position_z = 80.464, orientation = 4.7 WHERE guid = 45819;[/COLOR][/B] [B][COLOR="#0000FF"]UPDATE creature SET id = 9583, modelid = 9633, curhealth = 8569, position_x = -46.917, position_y = -516.565, position_z = 88.245, orientation = 3.804 WHERE guid = 45812;[/COLOR][/B] [B][COLOR="#0000FF"]UPDATE creature SET id = 9693, modelid = 9625, curhealth = 6893, curmana = 2289, position_x = -48.936, position_y = -515.33, position_z = 88.293, orientation = 4.786 WHERE guid = 45822;[/COLOR][/B] [B][COLOR="#0000FF"]UPDATE creature SET id = 9268, modelid = 7803, curhealth = 8355, position_x = -49.719, position_y = -519.474, position_z = 87.595, orientation = 1.028 WHERE guid = 45759;[/COLOR][/B] [B][COLOR="#0000FF"]UPDATE creature SET id = 9692, modelid = 9602, curhealth = 8227, position_x = -40.012, position_y = -519.474, position_z = 87.546, orientation = 2.685 WHERE guid = 45758;[/COLOR][/B] [B][COLOR="#0000FF"]UPDATE creature SET id = 9696, modelid = 741, curhealth = 2660, position_x = -41.648, position_y = -525.099, position_z = 87.115, orientation = 2.622 WHERE guid = 45818;[/COLOR][/B] [B]-- Overlord Wyrmthalak corrected position and orientation[/B] [B][COLOR="#0000FF"]UPDATE creature SET position_x = -24.533, position_y = -486.672, position_z = 90.633, orientation = 3.87 WHERE guid = 45757;[/COLOR][/B] [B]-- Patrolling Smolderthorn Berserker[/B] [B][COLOR="#0000FF"]UPDATE creature SET id = 9268, modelid = 7803, curhealth = 8355, position_x = -41.031, position_y = -514.179, position_z = 88.564, orientation = 4.205, MovementType = 2 WHERE guid = 45820;[/COLOR][/B] [B][COLOR="#0000FF"]DELETE FROM creature_movement WHERE id = 45820; INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES (45820, 1, -41.031502, -514.179016, 88.564003, '5000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.205', '0', '0'); INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES (45820, 2, -47.218548, -523.655396, 87.124512, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES (45820, 3, -51.244236, -527.463501, 85.626396, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES (45820, 4, -57.651527, -528.472656, 84.152359, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES (45820, 5, -74.393326, -524.992676, 82.137222, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES (45820, 6, -78.573311, -522.337830, 82.403702, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES (45820, 7, -82.644424, -507.925446, 80.220604, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES (45820, 8, -81.849724, -494.280884, 77.915787, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES (45820, 9, -79.042076, -489.494568, 77.915787, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES (45820, 10, -59.774261, -487.756592, 77.915787, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES (45820, 11, -50.267139, -490.083221, 77.915787, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES (45820, 12, -40.455597, -498.022491, 79.569664, '10000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.725', '0', '0'); INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES (45820, 13, -50.267139, -490.083221, 77.915787, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES (45820, 14, -59.774261, -487.756592, 77.915787, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES (45820, 15, -79.042076, -489.494568, 77.915787, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES (45820, 16, -81.849724, -494.280884, 77.915787, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES (45820, 17, -82.644424, -507.925446, 80.220604, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES (45820, 18, -78.573311, -522.337830, 82.403702, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES (45820, 19, -74.393326, -524.992676, 82.137222, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES (45820, 20, -57.651527, -528.472656, 84.152359, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES (45820, 21, -51.244236, -527.463501, 85.626396, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES (45820, 22, -47.218548, -523.655396, 87.124512, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES (45820, 23, -41.031502, -514.179016, 88.564003, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');[/COLOR][/B] [B]The above SQL scripts tested and working:[/B] [IMG]http://s21.postimg.org/uelvyqtuf/Chamber_Of_Battle.jpg[/IMG] [IMG]http://s17.postimg.org/ct28dvzvj/Chamber_Of_Battle02.jpg[/IMG]

Confirmed, those mobs should not be there; the ones that should be there are a mix of Bloodaxe Orcs and Spirestone Ogres, as far as I can tell. I'll check some images and vids and replace the current mobs with the correct ones. A good example of what should be there (right at the end of the vid): [url]https://www.youtube.com/watch?v=xdcU1rwKMHI[/url] I'll make a list/table of the current mobs and the mobs that should be there...

[B][COLOR="#008000"]This has been fixed already.[/COLOR][/B] Setting issue to completed.