CharactersTable: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
Line 1: | Line 1: | ||
This table holds all the characters in the game. This includes players, monsters, bosses. Anything that can be thought of as an 'alive' object. | |||
{| border=1 | |||
|- | |||
! field | |||
! type | |||
! foreign key | |||
! description | |||
|- | |||
| id | |||
| int | |||
| N | |||
| unique character id | |||
|- | |||
| name | |||
| varchar(30) | |||
| N | |||
| Character's first name in the game. | |||
|- | |||
| lastname | |||
| varchar(30) | |||
| N | |||
| The last name of the character. | |||
|- | |||
| old_lastname | |||
| varchar(30) | |||
| N | |||
| The old last name ( used in termination of a marriage ) | |||
|- | |||
| racegender_id | |||
| smallint(5) | |||
| Y | |||
| Key into the [[Race_infoTable]] for the race and gender of this character. | |||
|- | |||
| character_type | |||
| int(10) | |||
| N | |||
| | |||
|- | |||
| base_strength | |||
| float(10,2) | |||
| N | |||
| Character strength (no buffs, but base strength value) | |||
|- | |||
| base_agility | |||
| float(10,2) | |||
| N | |||
| Character agility (no buffs, but base value) | |||
|- | |||
| base_endurance | |||
| float(10,2) | |||
| N | |||
| Character endurance (no buffs, but base value) | |||
|- | |||
| base_intelligence | |||
| float(10,2) | |||
| N | |||
| Character intelligence (no buffs, but base value) | |||
|- | |||
| base_will | |||
| float(10,2) | |||
| N | |||
| Character will (no buffs, but base value) | |||
|- | |||
| base_charisma | |||
| float(10,2) | |||
| N | |||
| Character charisma (no buffs, but base value) | |||
|- | |||
| base_hitpoints_max | |||
| float(10,2) | |||
| N | |||
| The max character hitpoints. If set to 0 it will use an equation to determine the max hitpoints from character skills. | |||
|- | |||
| mod_hitpoints | |||
| float(10,2) | |||
| N | |||
| The character's current hitpoint value. | |||
|- | |||
| base_mana_max | |||
| float(10,2) | |||
| N | |||
| The character's base mana. If set to 0 will use skills to determine max mana. | |||
|- | |||
| mod_mana | |||
| float(10,2) | |||
| N | |||
| The character's current mana value. | |||
|- | |||
| stamina_physical | |||
| float(10,2) | |||
| N | |||
| The character's physical stamina | |||
|- | |||
| stamina_mental | |||
| float(10,2) | |||
| N | |||
| The character's mental stamina. | |||
|- | |||
| money_circles | |||
| int(10) | |||
| N | |||
| The number of circles the character has. | |||
|- | |||
| money_octas | |||
| int(10) | |||
| N | |||
| The number of octas the character has. | |||
|- | |||
| money_hexas | |||
| int(10) | |||
| N | |||
| The number of hexas the character has. | |||
|- | |||
| money_trias | |||
| int(10) | |||
| N | |||
| The number of trias the character has. | |||
|- | |||
| bank_money_circles | |||
| int(10) | |||
| N | |||
| The number of circles the character has (banked). | |||
|- | |||
| bank_money_octas | |||
| int(10) | |||
| N | |||
| The number of octas the character has (banked). | |||
|- | |||
| bank_money_hexas | |||
| int(10) | |||
| N | |||
| The number of hexas the character has (banked). | |||
|- | |||
| bank_money_trias | |||
| int(10) | |||
| N | |||
| The number of trias the character has (banked). | |||
|- | |||
| loc_instance | |||
| int(11) | |||
| N | |||
| Instance number the character is in. | |||
|- | |||
| loc_sector_id | |||
| int(10) | |||
| Y | |||
| The ID of the sector the character is in. | |||
|- | |||
| loc_x | |||
| float(10,2) | |||
| N | |||
| X location of character in world. | |||
|- | |||
| loc_y | |||
| float(10,2) | |||
| N | |||
| Y location of character in world. | |||
|- | |||
| loc_z | |||
| float(10,2) | |||
| N | |||
| Z location of character in world. | |||
|- | |||
| loc_yrot | |||
| float(10,2) | |||
| N | |||
| The direction the character is facing. | |||
|- | |||
| guild_member_of | |||
| int(10) | |||
| Y | |||
| The ID key of the guild this character is a member of. | |||
|- | |||
| guild_level | |||
| tinyint(1) | |||
| N | |||
| The rank this character is in their guild. | |||
|- | |||
| guild_points | |||
| int(10) | |||
| N | |||
| Number of points character has in the guild. | |||
|- | |||
| guild_public_notes | |||
| varchar(255) | |||
| N | |||
| Character's public guild note. | |||
|- | |||
| guild_private_notes | |||
| float(10,2) | |||
| N | |||
| Character's private guild note. | |||
|- | |||
| last_login | |||
| datetime | |||
| N | |||
| The time this character last logged in. | |||
|- | |||
| faction_standings | |||
| blob | |||
| N | |||
| CSV string that holds faction ratings. | |||
|- | |||
| progression_script | |||
| blob | |||
| N | |||
| Script that needs to run on the player when they log back in. | |||
|- | |||
| npc_spawn_rule | |||
| int(10) | |||
| Y | |||
| Key into spawn rules table for the rule to use. | |||
|- | |||
| npc_master_id | |||
| int(10) | |||
| Y | |||
| Key into characters_table to use as the base stats for this character. | |||
|- | |||
| npc_impervious_ind | |||
| char(1) | |||
| N | |||
| Y/N if this character is allowed to be attacked. | |||
|- | |||
| account_id | |||
| int(10) | |||
| Y | |||
| Key into accounts table for the owner of this character ( or npcclient owner ) | |||
|- | |||
| time_connected_sec | |||
| int(10) | |||
| N | |||
| Total time this character has played. | |||
|- | |||
| npc_addl_loot_category_id | |||
| int(10) | |||
| Y | |||
| Used to add additional looting category for this character. | |||
|- | |||
| experience_points | |||
| int(10) | |||
| N | |||
| The amount of experience points this character has | |||
|- | |||
| progression_points | |||
| int(10) | |||
| N | |||
| The current number of progression_points this character has. | |||
|- | |||
| description | |||
| text | |||
| N | |||
| The characters description (bio) | |||
|- | |||
| kill_exp | |||
| int(5) | |||
| N | |||
| The amount of experience this character will give when killed. | |||
|- | |||
| animal_affinity | |||
| text | |||
| N | |||
| ??? | |||
|- | |||
| help_event_flags | |||
| int(11) | |||
| N | |||
| Bit field of which instruction events have played for him. | |||
|- | |||
| creation_time | |||
| timestamp | |||
| N | |||
| The time this character was created. | |||
|- | |||
| banker | |||
| tinyint(1) | |||
| N | |||
| Flag if this is a banker character. | |||
|} | |||
[[Category:Engine documents]] |
Revision as of 23:14, 10 December 2010
This table holds all the characters in the game. This includes players, monsters, bosses. Anything that can be thought of as an 'alive' object.
field | type | foreign key | description |
---|---|---|---|
id | int | N | unique character id |
name | varchar(30) | N | Character's first name in the game. |
lastname | varchar(30) | N | The last name of the character. |
old_lastname | varchar(30) | N | The old last name ( used in termination of a marriage ) |
racegender_id | smallint(5) | Y | Key into the Race_infoTable for the race and gender of this character. |
character_type | int(10) | N | |
base_strength | float(10,2) | N | Character strength (no buffs, but base strength value) |
base_agility | float(10,2) | N | Character agility (no buffs, but base value) |
base_endurance | float(10,2) | N | Character endurance (no buffs, but base value) |
base_intelligence | float(10,2) | N | Character intelligence (no buffs, but base value) |
base_will | float(10,2) | N | Character will (no buffs, but base value) |
base_charisma | float(10,2) | N | Character charisma (no buffs, but base value) |
base_hitpoints_max | float(10,2) | N | The max character hitpoints. If set to 0 it will use an equation to determine the max hitpoints from character skills. |
mod_hitpoints | float(10,2) | N | The character's current hitpoint value. |
base_mana_max | float(10,2) | N | The character's base mana. If set to 0 will use skills to determine max mana. |
mod_mana | float(10,2) | N | The character's current mana value. |
stamina_physical | float(10,2) | N | The character's physical stamina |
stamina_mental | float(10,2) | N | The character's mental stamina. |
money_circles | int(10) | N | The number of circles the character has. |
money_octas | int(10) | N | The number of octas the character has. |
money_hexas | int(10) | N | The number of hexas the character has. |
money_trias | int(10) | N | The number of trias the character has. |
bank_money_circles | int(10) | N | The number of circles the character has (banked). |
bank_money_octas | int(10) | N | The number of octas the character has (banked). |
bank_money_hexas | int(10) | N | The number of hexas the character has (banked). |
bank_money_trias | int(10) | N | The number of trias the character has (banked). |
loc_instance | int(11) | N | Instance number the character is in. |
loc_sector_id | int(10) | Y | The ID of the sector the character is in. |
loc_x | float(10,2) | N | X location of character in world. |
loc_y | float(10,2) | N | Y location of character in world. |
loc_z | float(10,2) | N | Z location of character in world. |
loc_yrot | float(10,2) | N | The direction the character is facing. |
guild_member_of | int(10) | Y | The ID key of the guild this character is a member of. |
guild_level | tinyint(1) | N | The rank this character is in their guild. |
guild_points | int(10) | N | Number of points character has in the guild. |
guild_public_notes | varchar(255) | N | Character's public guild note. |
guild_private_notes | float(10,2) | N | Character's private guild note. |
last_login | datetime | N | The time this character last logged in. |
faction_standings | blob | N | CSV string that holds faction ratings. |
progression_script | blob | N | Script that needs to run on the player when they log back in. |
npc_spawn_rule | int(10) | Y | Key into spawn rules table for the rule to use. |
npc_master_id | int(10) | Y | Key into characters_table to use as the base stats for this character. |
npc_impervious_ind | char(1) | N | Y/N if this character is allowed to be attacked. |
account_id | int(10) | Y | Key into accounts table for the owner of this character ( or npcclient owner ) |
time_connected_sec | int(10) | N | Total time this character has played. |
npc_addl_loot_category_id | int(10) | Y | Used to add additional looting category for this character. |
experience_points | int(10) | N | The amount of experience points this character has |
progression_points | int(10) | N | The current number of progression_points this character has. |
description | text | N | The characters description (bio) |
kill_exp | int(5) | N | The amount of experience this character will give when killed. |
animal_affinity | text | N | ??? |
help_event_flags | int(11) | N | Bit field of which instruction events have played for him. |
creation_time | timestamp | N | The time this character was created. |
banker | tinyint(1) | N | Flag if this is a banker character. |