Diverse issues with boss spawn ,loot etc. in Baradin Hold
Occu'thar 52363 / 54229 spawn had spawn 62363 which is an instant kill and no loot template.
Alizabal 55869 (other versions 57270 have no loot template or AIscript) had spawn 65869 which is an instant kill, no AIscript and no loot template.
Argaloth 47120 / 51350 not spawned > so found an unused creature spawn GUID in the range BH. Also added 25man difficulty entry (missing)
Edit: For those who want GUID+1 for the creature spawn (best practice) (see conversation below)
Edit: There may be some problems 10/25 man. I re-entered 25m and the bosses were 10m. If this can't work, I'll just use the 25m variants in both as these bosses are quite easy even with npc bots.
Edit. Retested and working well 10m and 25m. Boss ids remain the same at 10m, but loot is good in 25m. Not perfect but enough.
Occu'thar 52363 / 54229 spawn had spawn 62363 which is an instant kill and no loot template.
Alizabal 55869 (other versions 57270 have no loot template or AIscript) had spawn 65869 which is an instant kill, no AIscript and no loot template.
Argaloth 47120 / 51350 not spawned > so found an unused creature spawn GUID in the range BH. Also added 25man difficulty entry (missing)
SQL:
UPDATE creature SET id = 52363 WHERE `guid`=172161; -- value was 62363 -- Occu'thar 52363 / 54229 spawn
UPDATE creature SET id = 55869 WHERE `guid`=172164; -- value was 65869 -- Alizabal 55869 (other versions 57270 have no loot template or AIscript)
-- 172154 free creature spawn / -- Argaloth 47120 / 51350
UPDATE creature_template SET difficulty_entry_1 = 51350 WHERE `entry`=47120;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (172154, 47120, 757, 5600, 5600, 2, 65535, 0, 0, 269.492, 1138.18, 160.921, 1.57189, 300, 0, 0, 19372500, 0, 0, 0, 0, 0, 0, 0);
Edit: For those who want GUID+1 for the creature spawn (best practice) (see conversation below)
SQL:
SELECT MAX(guid)+1 into @var FROM creature;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (@var, 47120, 757, 5600, 5600, 2, 65535, 0, 0, 269.492, 1138.18, 160.921, 1.57189, 300, 0, 0, 19372500, 0, 0, 0, 0, 0, 0, 0);
Edit: There may be some problems 10/25 man. I re-entered 25m and the bosses were 10m. If this can't work, I'll just use the 25m variants in both as these bosses are quite easy even with npc bots.
Edit. Retested and working well 10m and 25m. Boss ids remain the same at 10m, but loot is good in 25m. Not perfect but enough.
Last edited: