Difference between revisions of "Database"

From DSP Wiki
Jump to: navigation, search
Line 1: Line 1:
 
A break down of the database tables and what the fields mean.
 
A break down of the database tables and what the fields mean.
 +
 +
===[[Basic database primer]]===
 +
 +
A simple explanation of how a database works, some hurdles and "gotchas" that might crop up, and why things are done the way they are.
  
 
===[[Accounts]]===
 
===[[Accounts]]===
Line 12: Line 16:
  
 
Includes "item_armor," "item_basic," "item_furnishing," "item_latents," "item_mods," "item_puppet," "item_usable," "item_weapon," and "item_weapon_unlocked."
 
Includes "item_armor," "item_basic," "item_furnishing," "item_latents," "item_mods," "item_puppet," "item_usable," "item_weapon," and "item_weapon_unlocked."
Mandatory for all items.  This table defines the basic existence of an item.
 
  
 
===[[Actions]]===
 
===[[Actions]]===
Line 22: Line 25:
 
Includes "mob_spawn_points," "mob_groups," "mob_pools," "mob_droplist," "mob_family_system," "mob_skill," and "nm_spawn_points."
 
Includes "mob_spawn_points," "mob_groups," "mob_pools," "mob_droplist," "mob_family_system," "mob_skill," and "nm_spawn_points."
  
 +
===[[Economy]]===
 +
 +
Includes "auction_house," "delivery_box," "guild_shops," and "synth_recipes."
  
auction_house, bcnm_info, bcnm_instance, bcnm_loot, bcnm_treasure_chests, conquest_system, delivery_box, elevators, exp_base, exp_table, fishing_fish, fishing_lure, fishing_rod, fishing_zone, guild_shops, linkshells, mob_change_skin, npc_list, pet_list, server_variables, skill_caps, skill_ranks, skillchain_damage_modifiers, status_effects, synth_recipes, transport, zone_settings, zone_weather, zonelines
+
bcnm_info, bcnm_instance, bcnm_loot, bcnm_treasure_chests, conquest_system, elevators, exp_base, exp_table, fishing_fish, fishing_lure, fishing_rod, fishing_zone, linkshells, mob_change_skin, npc_list, pet_list, server_variables, skill_caps, skillchain_damage_modifiers, status_effects, transport, zone_settings, zone_weather, zonelines

Revision as of 20:11, 2 February 2013

A break down of the database tables and what the fields mean.

Basic database primer

A simple explanation of how a database works, some hurdles and "gotchas" that might crop up, and why things are done the way they are.

Accounts

Includes "accounts," "accounts_banned," and "accounts_sessions."

Characters

Includes "chars," "char_effects," "char_equip," "char_exp," "char_look," "char_points," "char_profile," "char_skills," "char_stats," "char_storage," "char_titles," "char_vars," and "char_weapon_skill_points."

Items

Includes "item_armor," "item_basic," "item_furnishing," "item_latents," "item_mods," "item_puppet," "item_usable," "item_weapon," and "item_weapon_unlocked."

Actions

Includes "abilities," "blue_spell_list," "blue_spell_mods," "merits," "skill_caps," "skill_ranks," "spell_list," "traits," and "weapon_skills."

Mobs

Includes "mob_spawn_points," "mob_groups," "mob_pools," "mob_droplist," "mob_family_system," "mob_skill," and "nm_spawn_points."

Economy

Includes "auction_house," "delivery_box," "guild_shops," and "synth_recipes."

bcnm_info, bcnm_instance, bcnm_loot, bcnm_treasure_chests, conquest_system, elevators, exp_base, exp_table, fishing_fish, fishing_lure, fishing_rod, fishing_zone, linkshells, mob_change_skin, npc_list, pet_list, server_variables, skill_caps, skillchain_damage_modifiers, status_effects, transport, zone_settings, zone_weather, zonelines