scriptdev2/scriptdev2 — pull request #55 by evil-at-wow (2013-04-03 20:43:17+00:00)
Title: Some improvements to the Archaedas encounter in Uldaman.

* Spawn the Ancient Treasure chest when the boss dies.
* Correct the aura spell to be removed when he awakes.
* Add emote when he awakes.

My sniffs tell me the aura that makes him look frozen is not the one the script was expecting (that's the one for all the little adds).

Suggested TBC-DB update for those willing to test (submitted to be in the next update pack):
```sql
-- Archaedas has identical data in both creature_addon and creature_template_addon.
-- Remove the first in favor of the second.
DELETE FROM creature_addon WHERE guid = 33537;

-- Archaedas is missing an aura to make him look like a statue initially.
UPDATE creature_template_addon SET auras = '16245' WHERE entry = 2748;

-- Add missing spawn for the Ancient Treasure, but initially despawned.
-- Defeating Archaedas should spawn the object.
-- Note: the position data is obviously from sniffs, but the 1 hour despawn
-- timer is guesswork and in sync with other dungeon chests.
DELETE FROM gameobject WHERE id = 141979;
INSERT INTO gameobject (guid, id, map, spawnMask, position_x, position_y, position_z, orientation, rotation0, rotation1, rotation2, rotation3, spawntimesecs, animprogress, state) VALUES
(101391, 141979, 70, 1, 153.39, 289.091, -52.2262, 2.68781, 0, 0, 0, 0, -3600, 255, 1);