search

classicdb / database

Classic DB is a content database for CMaNGOS Classic: world, NPCs, objects, quests and so on.
https://github.com/cmangos/mangos-classic
Other
87 stars 59 forks source link

missing creature_template #792

Closed Tobschinski closed 9 years ago

Tobschinski commented 9 years ago

1849 - Dreadwhisper ? - Maggosh

investigate further ...

cala commented 9 years ago

Dreadwhisper is in every DB but Classic DB. Weird. Maggosh is possibly a renamed NPC (ring a bell in my head).

Tobschinski commented 9 years ago

I'm just dumb, Maggosh is Magosh, a level 21 trogg.

cala commented 9 years ago

Below is the entry (stats for Classic):

DELETE FROM `creature_template` WHERE `Entry` = 1849;
INSERT INTO `creature_template` VALUES
(1849, 'Dreadwhisper', '', 58, 58, 4629, 0, 35, 35, 1, 0, 6, 3, 3, 0, 0, 0, 0, 0, 0, 1.2, 1.14286, 1, 4, 1.35, 1, 1, 1, 1, 1, 3876, 3876, 0, 0, 100, 132, 69, 101, 3457, 242, 25, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8388624, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '');

I could not find any data of his spawn point. However, it is still present in the game and wowhead has map and screenshot for it that should allow us to spawn him with an acceptable accuracy: http://www.wowhead.com/npc=1849/dreadwhisper#map http://www.wowhead.com/npc=1849/dreadwhisper#screenshots:id=243137

Tobschinski commented 9 years ago

Faction is 21.

Position: X: 1753.88 Y: -2335.215 Z: 59.89574 Orientation: 2.373648

Since there is absolutely no info about this guy anywhere, I start to believe he was part of the Scourge Invasion and came back with Cataclysm, or was never ingame before.

I know of other rares that never made it into the game pre 4.0, http://www.wowhead.com/npc=62/gug-fatcandle - https://twitter.com/Muffinus/status/454377272774893569

cala commented 9 years ago

He is referenced in the master guide but indeed unknown to me though I spent a lot of time in the Plaguelands, farming Argent Dawn reputation. Also, archives show him only on test realm: http://web.archive.org/web/20070509133014/http://wow.allakhazam.com/dyn/mobs/rare.html

I'm also more and more thinking that only its template should be added...