Chamber of Battle in Lower Blackrock Spire is spawned with UBRS Mobs

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...

[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]

[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]