Since i didn't find any threads about this on search i decided to make one myself
this guide will assume that you know how to create your own custom NPCs (if you want to use custom ones) I will be using default NPCs so that anyone can work along with me.
First things first!
Open HeidiSQL or what ever program your using!Log in...
Pick world i dont have world i have arcworl well any you have that ends or starts with world...When opened it on the other side there is going to be lots of tables.Dont get stresed if your new to this... Just click on any of the tables and press Q then it should get you to a table name called Quests
Click on it then press Data.Now there is going to be bunch of questes...Now at the topleft corner
Press the + buttion and a new line/table will be in the data =D
Now folow this part
set the fields as follows
entry - 90000
zoneID - 5
flags - 8
minLevel - 1 (or what ever level you want the quest to be available)
questlevel - 5 (or what ever level the quest should be done at)
Type - 0 (zero is normal)
everything else up to Title should be 0
Title - Where's the beef? (this is what is shown in the quest log)
Details - Hey, we want to have a cook out but we have no beef!(back story, small talk, etc..)
Objectives - Slay 5 cows (this is the objective text shown in the quest log)
completiontext - Nice, now we can get some meat for the cook out!(text shown by npc after the quest is complete)
Incompletetext - Whats wrong, dont you like beef? (the text shown by npc befor you finish the quest)
endtext - thats enough, lets eat! (text that shows in quest tracker after quest is complete)
objectivetext1 - cows slain (shows in log, and tracker)
leave 2,3,and 4 blank.. we only have 1 objective
ReqitemID1,2,3,4 - 0
reqitemcount1,2,3,4, - 0
ReqKillMobOrGOId1 - 2442 (thats the cow)
leave 2,3 and 4 - 0
ReqKillMobOrGOCount1 - 5 (how many cows we need to kill)
every thing else 0 untill we get to RewMoney
RewMoney - 1000 (how much copper will be rewarded)
RewXP - 495 (how muxh XP will be rewarded)
everything else 0
find any NPC in game that you would like to start the quest.. select the NPC and type
.quest addstart 90000 (the entry of our quest)
.quest addfinish 90000 (the entry of our quest)
Also pres the Check buttion so it would save in game
To refresh your db in game do .server reload quests
This should be it enjoy
Tell meh was this easy or not :wave: