If You Not Are New At This,
Just Skip All Steps To StepThree.
StepOne [Noobie]
First Of All, Lunch Your Server.
(Or Just Start MySQL In The Server Folder.)
StepTwo [Noobie]
Log On HeidiSQL (Or Navicat Etc)
[i] Username: root | Password: ascent | Port: 3306 | Hostname / IP: 127.0.0.1 (This If Ure Connecting Local.) |
Press CONNECT !
StepThree [Welcome x]
Go On Ascent!
StepFour
Scroll Down To You Find "Questes" .
StepFive
[b] Go To Database ! [b]
StepSix
Now Start The Tutorial, The WarmUp Has Ended.
You Are Now In The "Questes" Table/Base.
Quote:
Scroll Down To The Bottom.
Now, Just Take Your Finger And Press The "Down Arrow" .
Now A Bunt Of Empety Columms Spawned.
StepSeven
Start Fill The Columms .
Entry:
Set A High Number Like 567567 .
ZoneID:
For The ZoneID, Put A Number For An Area.Example:
If You Put 1, It Will Say This: Your Quest (Dun Morogh).
I Suggest Putting 5,- Witch is blank.
Sort:
This Is Just The Same As ZoneID, Put 5 Or Blank (0)
Flags:
I Really Dont Know, Just Put It Blank (0) . It Dosent Effect Your Quest.
MinLevel:
The Title Tells You, This Is The Min.Level. Put Something From 1-70 (Or Your Level Cap.)
MaxLevel:
The Title Tells You x) , Put The Max Level For This Quest Here.
Type:
0 Solable
1 Group
41 PvP
62 Raid
81 Dungeon
RequiredRace:
1 = Human
2 = Orc
4 = Dwarf
8 = NightElf
16 = Undead
32 = Tauren
64 = Gnome
128 = Troll
512 = BloodElf
1024 = Dranei
690 = All The Hordes Races
1101 = All The Alliance Races
If You Want All Of The Races To Be Able To Pick Up The Quest, Put 1791 Here .
Just Skip The Rest Until You Are At Limittime
LimitTime:
How Much Time You Get Finish The Quest.
SpecialFlags:
Doesnt Seem To Be Special. It Doesnt Effect The Quest, Just Leave It At Blank (0)
PrevQuestId:
Id Of Previous Quest You Most Take, Before Taking This One.
NextQuestId:
Id Of Next Quest You Gets When Uve Finished This One.
SrcItem:
Id Of An Item You Gets When Ure Accepting The Quest.
[b]SrcItemCount:[b]
How Many Of The Items You Gets When Ure Accepting The Quest.
Title:
The Title Of Your Quest.
Details (First Problem In HeidiSQL)
Details In The Quest. Your First Problem Will Come Now: MEMO .
Press On The Text It Stays: MEMO .
Enter Your Details -> The Explanation
Objectives:
A Summary Of Your Text (What He/She Needs To Do.)
(Do The Same As In "Enter Your Details" .
CompletionText:
The Completion Text (Same Progress As "Enter Your Details" .)
[quote]Example:
WOHOOO ! You Made It ! Amazing ! My Silver Hook !
Youre The Best !
IncompleteText:
If You Hasent Completed The Quest, And You Still Have It, And You Go To The Quest Giver,
It Will Tell That You Hasent Finished Your Quest Yet And It Will Show A Gray >Question Mark< Over Its Head.
EndText:
Text That Shows At The Bottom Of The Quest.
Example:
Quote:
Hmm.. Well Done. .
------------------------------------------------------------------
StepEight
You can skip the rest until you are at ReqItemId1
ReqItemId1:
The Item Id Needed To Complete The Quest.
Example, My Quest Was A Silverhook, Right?
1.Go On WowHead.Com Find Item Id. In My Case The Silverhook...
2. Paste The ID Of The Item .
ReqItemCount1-4:
Number Of The Item(s) You Need To Finish.
ReqKillMobOrGOId1-4
Id Of Creatures Who Needs To Be Killed.
ReqKillMobOrGOCount1-4:
Number Of Creatures You Have To Kill.
RewChoiceItemId1-6:
Witch Items You Can Choose About When Ure Finishing The Quest.
*I Am Sorry, I Had To Remove ONE Image*
RewItemCount1-6:
This Is How Much Of Those Items You Picked.
So Say I Picked A Dirk, I Will Get Two Of Them.
RewItemId1-4:
Items You Automatically Gets When Finishing.
RewRepFaction1-2:
The Faction Id Of Reputation You Will Get Finishing The Quest.
Check D0nD4K!NG's Thread With All Faction Ids, Press Here!
RewRepValue1-2:
The Value Your Reputation Will Increase. Can Also Use Negative Numbers To Decrease Reputation.
Check D0nD4K!NG's Thread With All Faction Ids, Press Here!
RewRepLimit:
I Dont Know, All Blizzard Quests Is 0, So We Just Put 0 Too xD
RewMoney:
Amount Of Money You Will Revice, 1 = 1 Copper | 10000 = 1 Gold
RewXP:
Amount Of Xp You Gets, If You Are At Max Level It Will Be Automatically Turned Into Gold ^^ .
Rewspell:
Spell You Will Revice Spell? If Not, Leave Blank.
Castspell:
Spell Id The Char Will Automatically Do When Finish The Quest.
Lets Say I Want My Char To Make Arcane Blast, Go To WowHead.Com Copy Id, And Paste.
Pointmapid:
Honest.. . I Dont Know xD
RequiredMoney:
How Much Money You Need To Finish The Quest.
Skip the rest until your at ExplorerTrigger1-4
Exploretrigger1-4:
Areas You Need To Have Discovered For Finishing The Quest.
RequiredQuest1-4:
Quets (IDs) Requried To Be Done Before This Quest.
ReceiveItemId1-4:
The Id Number Of Item(s) You Will Receive Upon Completing The Quest.
(Used To Give Additional Quest Items For Later Quest Chains).
ReceiveItemCount1-4:
How Many Of The Item(s) You Will Get.
IsRepeatable:
0 = No !
1 = Yes !
------------------------------------------------------------------------------
HALF DONE ! ( I Am Very Hungry After 2 Hours xD )
StepNine
Close The Table (Quests) NB!
Remeber To Save !
If You Cant "Press" The *Save* Button Because Of The Star..
Just Hit The Save Button In The Quest Over, And Then On Your Quest.
------------------------------------------------------------------------------
Open Up creature_quest_starter:
These Coulmms Will Show:
StepTen
ID
Npc Id Who Gonna Have Your Quest.
Quest:
Enter The Quest Id Here ^^
Step 11
Open creature_quest_finisher:
Just Repeat The Quest_Start.
Open Up CreatureLoot !
Index
Find The Higest Number In The Base .
It Was: 619 147 .
Just Put 619 148
EntryId
Id Of NpC Who Gonna Have The Quest Item.
Remember, Ive A Shark, I Just Put Shark Id There xD Or Search For It !
ItemID
Item Drop ! *The SilverHook*
Pcentchance:
Chance For Get Th Item. ( 1000 For First Kill )
Mincount:
This is the minimum of the item the NPC drops. For instance, if you put a 3 here, the minimum it will drop is 3.
Maxcount:
This is the maximum of the item the NPC drops. For instance, if you put a 10 here, the maximum it will drop is 10. So, it will drop 4's 5's and so on. It will not past 10 or 3.
CONGRATULATIONS !
Uve Finished My Second Tutorial.
This Tutorial Took 3 Hours Of My Time.
Now I Gonna Get Some Food xD Havent Ate On 5-6 Hours xD
If I Dont Get + Reputation Now... *Show Claws* ( xD )
Thanks To Eagle And Donki For Their Tutorials ^^
P.S:
Now I Am Really Angry,
You have included 17 images in your message. You are limited to using 16 images so please go back and correct the problem and then continue again.
Typical xD