Navicat Walkthrough

[Xx Killjoy xX]

This post is to help define what the tables in navicat are for I have some that Im not shure of but i might be corrected in comments.




accounts-The accounts on your server.

ai_agents-(Guess) What the AI(Artificial Intelligence) can do.

ai_threattospellid-Not shure

areatriggers- The triggers which activate certain things in the area or transport you

auctionhouse-The auction houses in your server

auctions-The auctions on the auctin house

bids - the bids on the auctions

characters- the created chars on your server

charters-nt shure but has something to do with guilds i think

clientaddons- the addons on your server or in your wow file

command_overrides-Not shure

corspes-the corpes currently in your server

creature_formations- if the npcs are walking together they are in a formation
(guess)

creature_names- the names of creatures on your server

creature_proto-not shure

creature_quest_finisher-the npc which finishes the quest

creature_quest_starter-the npc which starts the quest

creature_spawns-the spawns of the creatures on the server

creature_staticspawns-Not shure

creature_waypoints - Where the npcs move

creature_loot- What items the creature drops when it dies

creaturespawntemplate- the area which it spawns(guess)

finished_quest-the finished ques on the server

fishing-fishing locations

fishing_loot-When you fish it will open a loot if you catch something

gameobject_names- gameobject names ex: forges,tablets,gates ect...

gameobject_questfinsher-say a pot is a qust finisher then thats what it is

gameobject_itembinding- not really shure

gameobject_pickupbinding- same as above not shure

gameobject_starter- a game object which starts a quest

gameobject_spawns- guess) when you activate a gameobject a npc spawns

gameobject_spawnstaticspawns- not shure

gm_tickets- Players send tickets to gms those tickets are listed here

graveyards-the current graveyards in the server

guild_ranks- the ranks of the guild

guilds- the current guids on the server

instances- has nothing in it see world_MAP_INFO

ipbans-if you ban someone their pc has an ip shows it there

itemloot- items that are dropped from npcs

itempages- when looking at a book there are pages those r shown here

items- items on the server

lootandrandomprop- random loot dropping (guess)

mailbox- the mailbox -_-

npc_gossip_textid-when cilvilians randomly talk thats what this is

npc_mostersay- when monsters attack some have a certain saying and its listed
here

npc_text- when you talk to an npc there is text

objectloot- chest loot

petdefaultspells- the spells your pet has started with

player_levelstats- created player stats

playercooldownitems- the coolodwn on items can be changed here

playercooldownsecurity-not shure

playercreateinfo- the creation info for a created char

playercreateinfo_bars- not shure

playercreateinfo_itemscreated player items

playercreateinfo_skills-created player skills

playercreateinfo_spells-created player spells

playeritems- items players have

playerpets- the pets that hunters control or gms using .pet createpet

playerpetspells- the spells your pet has learned

playersummonspells- summoned pet learned spells

prospectingloot-not shure

pvpareas- the pvp areas and regions in Wow

questlog- players quest log

quest-current quest on the server

recall- .recall port locations

reputation- players rep with factions

reputation_creature_onkill- when killing a creature listed in this table you will gain
honor

reputation_faction_onkill- same as above but killing a diffrent faction

reputation_instance_onkill- same as above just getting rep from the current
entered instance

skinningloot- when skinning a creature you receive loot thats what this is

social- the friends and ignore list

spell_disable-disabled spells(guess)

spell_disable_trainers-not shure

spellextra-not shure

spelloverride- not shure

spellprocs-notshure

spells112- spells on the current server

talents- the talents you spend or receive

teleport_coords- same thing as recall

tempdamhe-not shure

totemspells- the spells totem use(ex:the searing totem uses fireballs)

trainers- the trainers on the current server

trainersspelloverride-not shur

transportdata- not shure

tutorials- the begining tutorials

vendors- vendors in the current server

weather-0 the weather effects on servers

world_map info- the instances that are in the game


-Very tired sorry for mispelled stuff and hope it helps soem peeps

[Daxo]

What?
Half of this is "Not sure"

[Xx Killjoy xX]

thats what your here to help with... duh!

[Daxo]

Here is what i know, i just filled in some of yours that said no sure

accounts-The accounts on your server.

ai_agents-(Guess) What the AI(Artificial Intelligence) can do.

ai_threattospellid-Not sure

areatriggers- The triggers which activate certain things in the area or transport you

auctionhouse-The auction houses in your server

auctions-The auctions on the auction house

bids - the bids on the auctions

characters- the created chars on your server

charters- Guild and such charters

clientaddons- the add ons on your server or in your wow file

command_overrides- ???

corspes-the corpes currently in your server

creature_formations- if the npcs are walking together they are in a formation
(guess)

creature_names- the names of creatures on your server

creature_proto- Extra Creature information

creature_quest_finisher-the npc which finishes the quest

creature_quest_starter-the npc which starts the quest

creature_spawns-the spawns of the creatures on the server

creature_staticspawns- ???

creature_waypoints - Where the npcs move

creature_loot- What items the creature drops when it dies

creaturespawntemplate- ??? (Looks like more creature information)

finished_quest-the finished ques on the server

fishing-fishing locations

fishing_loot-When you fish it will open a loot if you catch something

gameobject_names- Every GO in the game

gameobject_questfinsher-say a pot is a quest finisher then thats what it is

gameobject_itembinding- ???

gameobject_pickupbinding- same as above not shure

gameobject_starter- a game object which starts a quest

gameobject_spawns- guess) when you activate a gameobject a npc spawns

gameobject_spawnstaticspawns- ???

gm_tickets- Players send tickets to gms those tickets are listed here

graveyards-the current graveyards in the server

guild_ranks- the ranks of the guild

guilds- the current guids on the server

instances- has nothing in it see world_MAP_INFO

ipbans-if you ban someone their pc has an ip shows it there

itemloot- items that are dropped from npcs

itempages- when looking at a book there are pages those r shown here

items- items on the server

lootandrandomprop- random loot dropping (guess)

mailbox- the mailbox -_-

npc_gossip_textid- when any npc randomly talk thats what this is

npc_mostersay- when monsters attack some have a certain saying and its listed
here

npc_text- when you talk to an npc there is text

objectloot- chest loot

petdefaultspells- the spells your pet has started with

player_levelstats- created player stats

playercooldownitems- the coolodwn on items can be changed here

playercooldownsecurity- ??? ( Im guessing the cooldown counter thing)

playercreateinfo- the creation info for a created char

playercreateinfo_bars- ???

playercreateinfo_itemscreated player items

playercreateinfo_skills-created player skills

playercreateinfo_spells-created player spells

playeritems- items players have

playerpets- the pets that hunters control or gms using .pet createpet

playerpetspells- the spells your pet has learned

playersummonspells- summoned pet learned spells

prospectingloot- Looks useless to me

pvpareas- the pvp areas and regions in Wow

questlog- players quest log

quest-current quest on the server

recall- .recall port locations

reputation- players rep with factions

reputation_creature_onkill- when killing a creature listed in this table you will gain
honor

reputation_faction_onkill- same as above but killing a diffrent faction

reputation_instance_onkill- same as above just getting rep from the current
entered instance

skinningloot- when skinning a creature you receive loot thats what this is

social- the friends and ignore list

spell_disable-disabled spells(guess)

spell_disable_trainers- ???

spellextra- ??? (Im gessing,... here is an example, like when you pyroblast your target burns for an amount of time)

spelloverride- ??? ( Im guessing maybee curing spells ( cure poison, disease , w/e

spellprocs- How often a spell or enchant procs (Guessing)

spells112- spells on the current server

talents- the talents you spend or receive

teleport_coords- same thing as recall

tempdamhe- ???

totemspells- the spells totem use(ex:the searing totem uses fireballs)

trainers- the trainers on the current server

trainersspelloverride- ??? ( Possibly when you learn rank 2 of something it overrides rank 1

transportdata- ???

tutorials- the begining tutorials

vendors- vendors in the current server

weather-0 the weather effects on servers

world_map info- the instances that are in the game