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

Quest - Silithus - Field Duty #266

Open scotty0100 opened 10 years ago

scotty0100 commented 10 years ago

Map & Area: Silithus, Hive Zora

How to replicate the bug: Pick up the quest Field Duty from Windcaller Kaldon in Cenarion Hold

What happens: Captain Blackanvil does not appear in Hive Zora Alliance Camp.

What should happen: Captain Blackanvil should be standing at the camp so you can hand in the quest.

cala commented 10 years ago

I clearly see what quest/event this is. I think the Silithid NPC is already spawned (it should'nt). I look at it later to see if the event can be scripted in DB or if we need SD2.

scotty0100 commented 10 years ago

Looked into this a bit more, there's two versions of this quest for Ally and Horde.

Horde one, their Captain (Krug Skullsplit) is spawned by default and allows you to hand in the papers and continue with the quest line.

For allies the NPC is missing completely, breaking the quest line.

To get this properly fixed I believe we will need SD2, because what's supposed to happen is once you talk to the Captain a giant wasp/insect will appear which the NPCs in the camp and yourself have to kill and only THEN should the hand in be able to happen.

Found a video for the Horde encounter:

https://www.youtube.com/watch?v=h3vA93i9_oU

Alliance NPC is called: Hive'Zora Abomination a giant Wasp.

This SQL fixes Captain Blackhand not appearing which perhaps we could push into the DB so then Alliance can progress as I imagine the SD2 part of it will take a while to get put in;

DELETE FROM creature WHERE guid=590013; INSERT INTO creature VALUES (590013,15440,1,0,0,-7178.99,1395.1,2.53737,2.31928,25,0,0,24000,0,0,0);