Info on DBstructure (how to create quests, creature, loot manually)

[latruwski]

well there is so much stuff on ascentwiki... i dont get it why people dont use it :-/ we always see the same questions:
how to create a quest?
how to create a creature?
how to make creature drop custom item?
and much more

well seriously use ascentwiki! this is the info for quest for example:

entry 
 Is the ID of the quest
ZoneId 
 ID for sorting the zone in the Questlog.
QuestSort 
 Categorizes the quest (class quest, trade skill quest) 
0 <NOT SET>                       =0
1   Epic                          =1  
21  REUSE - old wailing caverns   =21 
22  Seasonal                      =22 
23  REUSE - old undercity one     =23 
24  Herbalism                     =24 
25  REUSE - old scarlet monastery =25 
41  REUSE - old uldaman           =41 
61  Warlock                       =61 
81  Warrior                       =81 
82  Shaman                        =82 
101 Fishing                       =101
121 Blacksmithing                 =121
141 Paladin                       =141
161 Mage                          =161
162 Rogue                         =162
181 Alchemy                       =181
182 Leatherworking                =182
201 Engineering                   =201
221 Treasure Map                  =221
241 REUSE - old sunken temple     =241
261 Hunter                        =261
262 Priest                        =262
263 Druid                         =263
264 Tailoring                     =264
284 Special                       =284
304 Cooking                       =304
324 First Aid                     =324
344 Legendary                     =344
364 Darkmoon Faire                =364
365 Ahn'Qiraj War                 =365
366 Lunar Festival                =366
367 Reputation                    =367
368 Invasion                      =368
369 Midsummer                     =369
QuestFlags 
   0 => QUEST_FLAG_NONE
  1 => QUEST_FLAG_DELIVER   
  2 => QUEST_FLAG_KILL
  4 => QUEST_FLAG_SPEAKTO
  8 => QUEST_FLAG_REPEATABLE
 16 => QUEST_FLAG_EXPLORATION
 32 => QUEST_FLAG_TIMED
128 => QUEST_FLAG_REPUTATION
MinLevel 
 Min level to access the quest
MaxLevel 
 Level "recommended" to do the quest (shouldn't be called max)
Type 
 Type of the quest
 0 => Normal
 1 => Elite
41 => PvP
62 => Raid
81 => Dungeon
RequiredRaces 
 Races who can take this quest 
0    => All Races
1    => Human
2    => Orc
4    => Dwarf
8    => Night Elf
16   => Undead
32   => Tauren
64   => Gnome
128  => Troll
512  => Blood Elf
1024 => Draenei
RequiredClass 
 Classes who can take this quest
0    => All Classes
1    => Warrior
2    => Paladin
4    => Hunter
8    => Rogue
16   => Priest
64   => Shaman
128  => Mage
256  => Warlock
1024 => Druid
RequiredTradeskill 
 Required Tradeskill to access the quest, tradeskill rank is not implemented on ascent yet (at least on svn).
171  => Alchemy
164  => Blacksmith
333  => Enchanting
202  => Engineering
182  => Herbalism
755  => Jewelcrafting
165  => Leatherworking
186  => Mining
393  => Skinning
197  => Tailoring
185  => Cooking
129  => First Aid
356  => Fishing
762  => Riding
RequiredRepFaction 
 Reputation needed with specific faction to access quest
RequiredRepValue 
 Value of the reputation requiered
3000  => Friendly
9000  => Honored
21000 => Revered
42000 => Exalted
LimitTime 
 Quests that need to be completed in specified time (miliseconds, not yet implemented on ascent)
SpecialFlags 
 ???
PrevQuestId 
 Previous quest in quest chain, not really neccesary.
NextQuestId 
 Quest that will be displayed right after you finish this one (thus, only works if quest finisher starts the next quest).
srcItem 
 Item that is provided by quest giver on quest start
SrcItemCount 
 Count of items You will get on quest start
Title 
 Title of the quest
Details 
 Detail of the quest
Objectives 
 Objectives of the quest
CompletionText 
 Text shown when quest is complete
IncompleteText 
 Text shown when quest is incomplete 
EndText 
 Text shown when quest is finish (like go and see Toto he can have a quest for you - CF NextQuestId)
ObjectiveText1-4 
 Objective displayed on quest log (Usually used for quests requiring to interact with several GOs)
ReqItemId1-4 
 ID of items required to be delivered to quest finisher.
ReqItemCount1-4 
 count of required items.
ReqKillMobOrGOId1-4 
 requiered id of Mob to be killed or GO to be interacted with (GOs are not fully implemented)
ReqKillMobOrGOCount1-4 
 count of mobs to kill, or GOs to interact with.
RewChoiceItemId1-6 
 Item ID's from which player can choose as quest reward.

RewChoiceItemCount1-6 
 Count of each item
RewItemId1-4 
 ID of Item you win when finishing quest (found in items), can be mixed with rewchoiceitems.
RewItemCount1-4 
 ammount of items rewarded.
RewRepFaction1-2 
 ID of faction for which You will get reputation on quest finish
RewRepValue1-2 
 Value of Reputation You will gain on quest finish
RewRepLimit 
 Reputation value on player at which the quest wont give anymore reputation (but will still be attainable/completable).
RewMoney 
 Money you earn when finishing quest
1     = 1 copper
10    = 10 copper
100   = 1 silver
1000  = 10 silver
10000 = 1 gold and so on. 
RewXP 
 XP you win when finishing quest
RewSpell 
 spell you ATTAIN when finishing quest, SHOULD BE AVOIDED (only use it if you know what you are doing) (found in spell112)
CastSpell 
 Spell cast on quest completion (this SHOULD be used for teaching player spells, using the TRAINER spells) (found in spell112)
PointMapId PointX PointY PointOpt 
 Seems of no real use, just for reference.
RequiredMoney 
 Requiered money to complete quest (not yet implemented on svn).
ExploreTrigger1-4 
 Areatriggers players need to go to, for finishing quest (used for exploration quests) (found in areatriggers)
RequiredQuest1-4 
 Quests player must complete before attaining this quest
ReceiveItemId1-4 
 Item you will receive when accepting quest (Should not exist at all, custom server stuff, avoid)
ReceiveItemCount1-4 
 count of item receive
IsRepeatable 
 Repeatable=1, non-repeatable=0, (Repeatable quests are really bad on ascent, they will override every requirement, like level, class, previous quests, tradeskill etc)

creature_names? this is info:

Fieldname Description   entry The entry/ID of the creature. Used to reference records of this table und to spawn creature ingame.   creature_name Name of the creature. Displayed ingame.   subname Subname of the creature. Displayed ingame below the creature_name. Most time function of the Creature.   info_str The MouseFlags   Flags1 - Unknown yet. this is NOT like npcflags in creature_proto   type Type of the Creature. Values:   Value Type   1 Beast   2 Dragonkin   3 Demon   4 Elemental   5 Giant   6 Undead   7 Humanoid   8 Critter   9 Mechanical   10 Not Specified (using by mounts creatures)   11 Totem    Family Family of the creature. Values:   Value Family   1 Wolf   2 Cat   3 Spider   4 Bear   5 Boar   6 Crocolisk   7 Carrion Bird   8 Crab   9 Gorilla   10 [UNUSED]   11 Raptor   12 Tallstrider   13 [UNUSED]   14 [UNUSED]   15 Felhunter   16 Voidwalker   17 Succubus   18 [UNUSED]   19 Doomguard   20 Scorpid   21 Turtle   22 [UNUSED]   23 Imp   24 Bat   25 Hyena   26 Owl   27 Wind Serpent   28 Remote Control   29 Felguard   30 Dragonhawk   31 Ravager   32 Warp Stalker   33 Sporebat   34 Nether Ray   35 Serpent    Rank Rank of the Creature. Values:   Value Rank   0 Normal   1 Elite   2 Rare Elite (?)   3 World Boss   4 Rare    unk4 Need info here. Pls edit if you know.   SpellDataID Need info here. Pls edit if you know.   male_displayid Model ID of the creature if it's male.   female_displayid Model ID of the creature if it's female.   unk2 Need info here. Pls edit if you know.   unk3 Need info here. Pls edit if you know.   Civilian 1-> is Civilian 0->no Civilian   Leader Indicates if Creature is the Leader of a Faction. 1=Leader 0=No Leader. An example would be Thrall.

creature_proto? here we go again:

Fieldname Description   entry The entry/ID of the creature. Used to reference records of this table und to spawn creature ingame.   minlevel Min Level of the Creature.   maxlevel Max Level of the Creature.   faction Faction of the creature.   minhealth Min. health of the creature   maxhealth Max. health of the creature   mana Max. mana of the creature   scale Scale of the creature. Default 1=100%   npcflags Flags of the NPC. Note that most of these also require the gossip flag. Values:   Flag Value   UNIT_NPC_FLAG_NONE 0   UNIT_NPC_FLAG_GOSSIP 1   UNIT_NPC_FLAG_QUESTGIVER 2   UNIT_NPC_FLAG_TRAINER 16   UNIT_NPC_FLAG_VENDOR 128   UNIT_NPC_FLAG_ARMORER 4096   UNIT_NPC_FLAG_TAXIVENDOR 8192   UNIT_NPC_FLAG_SPIRITHEALER 32768   UNIT_NPC_FLAG_INNKEEPER 65536   UNIT_NPC_FLAG_BANKER 131072   UNIT_NPC_FLAG_ARENACHARTER 262144   UNIT_NPC_FLAG_TABARDVENDOR 524288   UNIT_NPC_FLAG_BATTLEFIELDPERSON 1048576   UNIT_NPC_FLAG_AUCTIONEER 2097152   UNIT_NPC_FLAG_STABLE 4194304   UNIT_NPC_FLAG_GUILD_BANK 8388608    attacktime Delay between the attacks in ms   mindamage Minimum damage of the creature   maxdamage Maximum damage of the creature   rangedattacktime Delay between the ranged attacks in ms   rangedmindamage Minimum ranged damage of the creature   rangedmaxdamage Maximum ranged damage of the creature   mountdisplayid Model ID of the mount the npc is on (?). 0 if none.   equipmodel1 Display ID of the item at slot 1   equipinfo1 Please give information, if you know   equipslot1 Please give information, if you know   equipmodel2 Display ID of the item at slot 2   equipinfo2 Please give information, if you know   equipslot2 Please give information, if you know   equipmodel3 Display ID of the item at slot 3   equipinfo3 Please give information, if you know   equipslot3 Please give information, if you know   respawntime Respawntime in ms   armor Armor of the creature   resistance1 Holy Resistance of the creature   resistance2 Fire Resistance of the creature   resistance3 Nature Resistance of the creature   resistance4 Frost Resistance of the creature   resistance5 Shadow Resistance of the creature   resistance6 Arcane Resistance of the creature   combat_reach Distance of the creature in which it can hit you (?)   bonding_radius Aggro radius of the creature (?)   auras auras of the creature, seperator is a comma (,)   boss Indicates if creature is a boss. 1=boss 0=no boss   money money dropped by the creature   invisibility_type Please give information, if you know   death_state Please give information, if you know   walk_speed Same as '.modify speed' value, while walking   run_speed Same as '.modify speed' value, while running   fly_speed Same as '.cheat flyspeed' value, while flying   extra_a9_flags Please give information, if you know

creatureloot? lol:

Name Type Description   index int(11) [primary] Primary key   entryid int(11) The ID of creature as seen in creature_names or creature_proto   percentchance float Percentage chance that this item drops while in normal mode   heroicpercentchance float Percentage chance that this item drops while in heroic mode   mincount int(11) If the item drops, at least this amount will drop   maxcount int(11) If the item drops, the maximum amount that can drop   ffa_loot int(10) Allows all group members to loot this item if >= 1

this is copied from ascentwiki... so as you can see HELL lot of info in there
my question to the community is: Will you guys finally start using AscentWiki !? (i know some alraedy do but all should !)

even the DB structure is in there!

Note: not all columns are known yet... but you can still easely find out what to put in it if you compare to other quests
Note2: the stuff i gave as example is much more organized posted on AscentWiki!

LINK:
Main Page - Ascent Wiki

i am sure AscentWiki can help out for a lot of people so start using it

grtz

[Gadella]

First writter - woohoo! - N1 +rep

[latruwski]

First writter - woohoo! - N1 +rep

well thx lol, but this is more a post asking people to use AscentWiki before posting questions ^^

grtz

[Chrispee]

as always good guides

[latruwski]

as always good guides

well i hope people will start using AscentWiki more now after they read this
thx for the comment

grtz

[latruwski]

omg my topic about ascent legal/illegal got deleted chris :-/ i will never make posts like that again and never ever reply to such posts again >< people dont understand anyway

[Succy]

As Chris said, Good Guide as always. And while I am in your thread... Bye
+Rep x3 for it btw :P

[latruwski]

As Chris said, Good Guide as always. And while I am in your thread... Bye
+Rep x3 for it btw :P

dam i hope you get back soon :-/ you will be big loss to this community
thx for the comment...