[GUIDE] Databases and their uses

[Minip2hn]

:wave:Well, first of all, i made this thread for all of you lazy slackers who cba to test things in the database.

anyways, here it comes. Arcemu Database tables!

note: the ones with ''Do NOT touch'' are auto-updating or client side.

and 2nd note: my fingers hurt.

DATABASE-CHARACTERS
 
Account_data - Do NOT touch.
 
Account_forced_permissions - Do NOT touch
 
Accounts - use this to create new accounts, also all accounts are listed here.
 
Arenateams - You can use this to create arena teams, or delete them, easier to use an in-game command.
 
Auctions - Lists all the items that are in the auction house.
 
Banned_names - you can list here names that you do not want to see on players.
 
Character_achievement - lists all the achievements that people currently have.
 
Character_achievement_progress - Lists the progress of player's achievements.
 
Characters - Shows you all the characters that are on the server, you can modify their race,class,gender,gold... etc. there.
 
Characters_insert_queue - do NOT touch.
 
Charters - lists all the current guild&arena charters on your server.
 
Clientaddons - here you will see what addons are currently being used on your server, and you can also ban addons.
 
Command_Overrides - Not for amateurs.
 
Corpses - lists all the corpses currently visible in the game.
 
gm_tickets - lists all the GM tickets currently pending.
 
groups - lists all the parties that exist, online and offline.
 
guild_bankitems - lists all the items in guild banks.
 
guild_banklogs - lists all the guild bank logs of ur server.
 
guild_banktabs - lists all the guild bank tabs the guilds have in ur server.
 
guild_data - do NOT touch.
 
guild_logs - the guild calendar system, all events will be listed here.
 
guild_ranks - lists all the guild ranks on your server.
 
guilds - lists all the guilds on your server.
 
instanceids - lists all the active instances (non-resetted)
 
instances - pretty much same as instanceids, but shows kills too.
 
ipbans - shows all the ip-s that are banned from ur server.
 
mailbox - shows all the letters in players' mailboxes.
 
mailbox_insert_queue - shows the letters being delivered to mailboxes.
 
playercooldowns - lists the spell cooldowns of players. useful with hackers.
 
playeritems - shows ALL the items that people currently have in their bags, on them, or in their banks.
 
playeritems_insert_queue - do NOT touch. outdated.
 
playerpets - shows all the pets that players have on your server, you can add pets there too.
 
playerpetspells - do NOT touch.
 
playersummons - lists all the times that a gm has summoned a normal player.(bugged in some servers.)
 
playersummonspells - lists the spells you can summon other players with.
 
questlog - lists everyone's questlogs.
 
server_settings - lists all the updates that are done, and what will be done.
 
social_friends - lists all the people and the people who they have on their friends list
 
social_ignore - lists all the people and the people who they have on their ignore list.
 
Tutorials - Lists all the tutorials.
 
 
DATABASE - World
 
ai_agents - lists all the npcs with AI on.
 
ai_threattospellid - lists all the AINPCS and their threat to certain spells.
 
areatriggers - lists all the areatriggers. DO NOT MESS WITH THIS!
 
auctionhouse - lists all the active auctions
 
banned_phrases - lists all the banned words in chat.
 
clientaddons - name says it all.
 
command_overrides - do NOT tinker.
 
creature_formations - lists all the NPCS moving in a formation.
 
creature_names - lists all the NPC names
 
creature_names_localized - used to change NPC names to different languages.(localize em.)
 
creature_proto - lists all the NPC stats.
 
creature_quest_finisher - lists all the NPC-s that finish quests.
 
creature_quest_starter - lists all the NPC-s that start Quests.
 
creature_spawns - lists all the spawns of NPC-s(currently active)
 
creature_staticspawns - lists the self spawned non-moving NPCS.
 
creature_timed_emotes - lets u set an NPC to /yawn at 23:00 for example.
 
creature_waypoints - lists all the waypoints of moving NPC-s.
 
fishing - shows the fishing spots and their needed skill levels.
 
gameobject_names - lists all the names of the gameobjects.
 
gameobject_names_localized - lets you change the ''language'' of an object.
 
gameobject_quest_finisher - lists the quest-finishing gameobjects.
 
gameobject_quest_item_binding - lists the gameobjects that add items to players(quest)
 
gameobject_quest_pickup_binding - lists all the gameobjects that a player needs to pick up during a quest.
 
gameobject_quest_starter - lists all the gameobjects that start a quest.
 
gameobject_spawns - lists all the spawned gameobjects.
 
gameobject_static_spawns - SHOULD list all the go-s a GM spawned.
 
graveyards - name says it all.
 
instance_bosses - lists all the instance bosses currently engaged.
 
item_quest_association - lets you associate items to quests.(ex. pendant of myzrael)
 
item_randomprop_groups - lists all the items that you can find in a chest while in a group.
 
item_randomsuffix_groups - do NOT touch.
 
itempages - lists all the book pages etc.
 
itempages_localized - lets you translate in-game books.
 
itempetfood - lists all the items pets can eat.
 
items - lists all the items in your db.
 
items_localized - lets you translate item names.
 
loot_creatures - lists all the loot you can get from creatures.
 
loot_disenchanting - lists all you can get from disenchanting.
 
loot_fishing - lists all you can get from fishing
 
loot_items - lists the items you can get from chests.
 
loot_milling - lists all the items you can get from milling.
 
loot_pickpocket - lists all the items you can pickpocket.
 
loot_prospecting - lists all the items you can get from prospecting ores.
 
loot_skinning - lists all the stuff you can get from skinning
 
map_checkpoint - outdated table. don't touch.
 
npc_gossip_textid - lists the textid's npc-s will use when communicating.
 
npc_monstersay - lists all what monsters jam out of their mouth.
 
npc_text - lists the texts that npcs use.
 
npc_text_localized - lets you translate the npc texts.
 
petdefaultspells - name says it all.
 
playercreateinfo - lists all the stats that the player begins with upon creation.
 
playercreateinfo_bars - do NOT touch unless u know that.
 
playercreateinfo_items - lists the items that players start with.
 
playercreateinfo_skills - lists all the skills that players start with.
 
playercreateinfo_spells - lists the spells that players begin with.
 
professiondiscoveries - lists the skills&spells that you get upon learning a profession.
 
quests - lists all the quests.
 
quests_localized - lets you translate the quests.
 
recall- lists all the recall locations.
 
reputation_creature_onkill - lists all the creatures and how much rep they give per faction.
 
reputation_faction_onkill - lists the factions and how much rep you lose/gain per kill
 
reputation_instance_onkill - lists the instance mobs and the rep amount u get from em.
 
spell_coef_override - do NOT touch.
 
spell_disable - do not touch.
 
spell_disable_trainers - do NOT touch.
 
spell_effects_override - sigh. do not touch.
 
spell_proc - inexperience may cause ur database to die.
 
spellfixes - lets you modify spells.
 
spelloverride - do NOT touch.
 
zoneguards - lists all the zones and their guardian NPC-s
 
teleport_coords - used to change the locations of teleport spells.
 
totemspells - lists the spells that totems cast.
 
trainer_defs - lists all the trainers and what their default settings.
 
trainer_spells - lists all the spells that trainers teach.
 
trainerspellsoverride - do NOT touch.
 
transport_creatures - do NOT touch.
 
transport_data - shows all the zeppelins,boats,etc...
 
unit_display_sizes - shows the native sizes of displays.
 
weather - shows all zones and their probability of getting some weather.
 
vendors - shows all the npc-s that sell something and what they are selling.
 
wordfilter_character_names - This aint for you, its Client side.
 
wordfilter_chat - Client side
 
worldbroadcast - lets you set a text to auto broadcast, and the % of time also.
 
worldbroadcast_localized - lets you translate worldbroadcasts.
 
worldmap_info - gives all the zones, and their info.
 
worldmap_info_localized - lets you translate worldmap info.
 
worldstring_tables - lists all the texts a player will see in the game.
 
worldstring_tables_localized - lets you translate the texts of ''worldstring_tables''

[Minip2hn]

cmon, share ur opinion with the rest of the world, feel free to comment!

[Tornad0z]

This might be helpful for people that is not very known with SQL

[Minip2hn]

This might be helpful for people that is not very known with SQL

thats the point

[sasoritail]

yupp this is really good for newbies in SQL!
Good Guide!
+Rep when i can.

[sasoritail]

and 2nd note: my fingers hurt.

thats how it is when ur a poster

nice guide.
and sorry for double post but one thing about the Quote:

LOLROFLMAO!!!!
nice guide

[Sounddead]

For the DO NOT TOUCH parts, does that just mean that you don't know what they are for? Because I touch some of them

[Minip2hn]

For the DO NOT TOUCH parts, does that just mean that you don't know what they are for? Because I touch some of them

do not touch parts are only to be touched if you can get the point of the database.

[sasoritail]

do not touch parts are only to be touched if you can get the point of the database.

true m8... true

[decades]

Ty! it helps me alot

[allycrusher]

Nice job.. good guide