Custom Quest Help

[CursedOne]

Hey everyone!
I've been wanting to start a WoW server for myself for a long time.
One of the main things I want to do is make a complete quest line (HUGE) taking you through different dungeons etc.
The only thing is that I don't have the knowledge with the database to create a custom quest using ArcEMU.
I've looked for a few decent tutorials but I couldn't find any around that actually help me.

I was wondering if anyone knows of a program that I could use or know of a tutorial of some sort

I'm using an ArcEmu 3.3.5 Emulator if that helps.

Any help at all would be appreciated.
Thanks

[stoneharry]

The ArcEmu wiki should give you all the information you need, for this specific question:

Quests - ArcEmu-Wiki (scroll down)

[CursedOne]

Thank you for that it really helped +rep

I have a few other questions I might as well add to this thread.

I know that I can spawn NPC's in game but how do I make it so that they get saved to the database so when the server restarts they stay where I spawned them?
Also once I spawn an NPC do they get a unique ID that I can use for quests?

And when it asks for a zone/map ID in the db for quests is that where the quest objectives are?
Example - I have the quest being picked up in stormwind but the objective is to kill stuff in goldshire. Would I use goldshires or stormwinds id?

[stoneharry]

.npc spawn npcid
^
Should automatically stay saved, if not .npc spawn npcid 1

Do .npc info on a npc, the SQLID is the GUID of the creature - this is what identifies it from another. In a Lua script where you have the arguments (pUnit, Event), pUnit is a pointer to the guid of the unit.

I don't see MapID in the Quests structure from quickly looking, but the zoneID defines what it should display as in your quest log. If you put the ID of goldshire, then in your quests it will show:

- Goldshire
--- YourQuestHere
- Any Other Zones That Player Has Quests For
--- Those quests under tabs as well

[CursedOne]

.npc spawn npcid
^
Should automatically stay saved, if not .npc spawn npcid 1

Do .npc info on a npc, the SQLID is the GUID of the creature - this is what identifies it from another. In a Lua script where you have the arguments (pUnit, Event), pUnit is a pointer to the guid of the unit.

I don't see MapID in the Quests structure from quickly looking, but the zoneID defines what it should display as in your quest log. If you put the ID of goldshire, then in your quests it will show:

- Goldshire
--- YourQuestHere
- Any Other Zones That Player Has Quests For
--- Those quests under tabs as well

Okay thanks mate helped loads!
Once ive spread my rep around i'll be sure to give you some more