CharactersTable: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
mNo edit summary |
||
(5 intermediate revisions by 3 users not shown) | |||
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. | |||
{| class="wikitable" | |||
|+ | |||
!UE | |||
!Field | |||
!Type | |||
!Key Type | |||
!Default | |||
!Extra | |||
!Description | |||
|- | |||
| | |||
|id | |||
|int(10) unsigned | |||
|PRI | |||
| | |||
|auto_increment | |||
|unique character id | |||
|- | |||
| | |||
|name | |||
|varchar(30) | |||
|MUL | |||
| | |||
| | |||
|Character's first name in the game. | |||
|- | |||
| | |||
|lastname | |||
|varchar(30) | |||
|MUL | |||
| | |||
| | |||
|The last name of the character. | |||
|- | |||
| | |||
|old_lastname | |||
|varchar(30) | |||
| | |||
| | |||
| | |||
|The old last name ( used in termination of a marriage ) | |||
|- | |||
| | |||
|racegender_id | |||
|smallint(5) unsigned | |||
| | |||
|0 | |||
| | |||
|Key into the Race_infoTable for the race and gender of this character. | |||
|- | |||
| | |||
|character_type | |||
|int(10) unsigned | |||
| | |||
|0 | |||
| | |||
|PLAYER = 0,NPC = 1, PET = 2, MOUNT = 3, MOUNTPET = 4 | |||
|- | |||
| | |||
|base_strength | |||
|float(10,2) | |||
| | |||
|0.00 | |||
| | |||
|Character strength (no buffs, but base strength value) | |||
|- | |||
| | |||
|base_agility | |||
|float(10,2) | |||
| | |||
|0.00 | |||
| | |||
|Character agility (no buffs, but base value) | |||
|- | |||
| | |||
|base_endurance | |||
|float(10,2) | |||
| | |||
|0.00 | |||
| | |||
|Character endurance (no buffs, but base value) | |||
|- | |||
| | |||
|base_intelligence | |||
|float(10,2) | |||
| | |||
|0.00 | |||
| | |||
|Character intelligence (no buffs, but base value) | |||
|- | |||
| | |||
|base_will | |||
|float(10,2) | |||
| | |||
|0.00 | |||
| | |||
|Character will (no buffs, but base value) | |||
|- | |||
| | |||
|base_charisma | |||
|float(10,2) | |||
| | |||
|0.00 | |||
| | |||
|Character charisma (no buffs, but base value) | |||
|- | |||
| | |||
|base_hitpoints_max | |||
|float(10,2) | |||
| | |||
|0.00 | |||
| | |||
|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) | |||
| | |||
|0.00 | |||
| | |||
|The character's current hitpoint value. | |||
|- | |||
| | |||
|base_mana_max | |||
|float(10,2) | |||
| | |||
|0.00 | |||
| | |||
|The character's base mana. If set to 0 will use skills to determine max mana. | |||
|- | |||
| | |||
|mod_mana | |||
|float(10,2) | |||
| | |||
|0.00 | |||
| | |||
|The character's current mana value. | |||
|- | |||
| | |||
|stamina_physical | |||
|float(10,2) | |||
| | |||
|0.00 | |||
| | |||
|The character's physical stamina | |||
|- | |||
| | |||
|stamina_mental | |||
|float(10,2) | |||
| | |||
|0.00 | |||
| | |||
|The character's mental stamina. | |||
|- | |||
| | |||
|money_circles | |||
|int(10) unsigned | |||
| | |||
|0 | |||
| | |||
|The number of circles the character has. | |||
|- | |||
| | |||
|money_octas | |||
|int(10) unsigned | |||
| | |||
|0 | |||
| | |||
|The number of octas the character has. | |||
|- | |||
| | |||
|money_hexas | |||
|int(10) unsigned | |||
| | |||
|0 | |||
| | |||
|The number of hexas the character has. | |||
|- | |||
| | |||
|money_trias | |||
|int(10) unsigned | |||
| | |||
|0 | |||
| | |||
|The number of trias the character has. | |||
|- | |||
| | |||
|bank_money_circles | |||
|int(10) unsigned | |||
| | |||
|0 | |||
| | |||
|The number of circles the character has (banked). | |||
|- | |||
| | |||
|bank_money_octas | |||
|int(10) unsigned | |||
| | |||
|0 | |||
| | |||
|The number of octas the character has (banked). | |||
|- | |||
| | |||
|bank_money_hexas | |||
|int(10) unsigned | |||
| | |||
|0 | |||
| | |||
|The number of hexas the character has (banked). | |||
|- | |||
| | |||
|bank_money_trias | |||
|int(10) unsigned | |||
| | |||
|0 | |||
| | |||
|The number of trias the character has (banked). | |||
|- | |||
| | |||
|loc_instance | |||
|int(11) unsigned | |||
| | |||
|0 | |||
| | |||
|Instance number the character is in. | |||
|- | |||
| | |||
|loc_sector_id | |||
|int(10) unsigned | |||
| | |||
|0 | |||
| | |||
|The ID of the sector the character is in. | |||
|- | |||
| | |||
|loc_x | |||
|float(10,2) | |||
| | |||
|0.00 | |||
| | |||
|X location of character in world. | |||
|- | |||
| | |||
|loc_y | |||
|float(10,2) | |||
| | |||
|0.00 | |||
| | |||
|Y location of character in world. | |||
|- | |||
| | |||
|loc_z | |||
|float(10,2) | |||
| | |||
|0.00 | |||
| | |||
|Z location of character in world. | |||
|- | |||
| | |||
|loc_yrot | |||
|float(10,2) | |||
| | |||
|0.00 | |||
| | |||
|The direction the character is facing. | |||
|- | |||
| | |||
|guild_member_of | |||
|int(10) unsigned | |||
| | |||
|0 | |||
| | |||
|The ID key of the guild this character is a member of. | |||
|- | |||
| | |||
|guild_level | |||
|tinyint(1) unsigned | |||
| | |||
|0 | |||
| | |||
|The rank this character is in their guild. | |||
|- | |||
| | |||
|guild_additional_privileges | |||
|smallint(3) unsigned | |||
| | |||
|0 | |||
| | |||
|Contains a bitfield with the additional priviledges assigned to this char (additional to the guild level it's in) | |||
|- | |||
| | |||
|guild_denied_privileges | |||
|smallint(3) unsigned | |||
| | |||
|0 | |||
| | |||
|Contains a bitfield with the removed priviledges from this char (removed from the guild level it's in) | |||
|- | |||
| | |||
|guild_points | |||
|int(10) unsigned | |||
| | |||
|0 | |||
| | |||
|Number of points character has in the guild. | |||
|- | |||
| | |||
|guild_public_notes | |||
|varchar(255) | |||
| | |||
| | |||
| | |||
|Character's public guild note. | |||
|- | |||
| | |||
|guild_private_notes | |||
|varchar(255) | |||
| | |||
|0 | |||
| | |||
|Character's private guild note. | |||
|- | |||
| | |||
|join_notifications | |||
|tinyint(1) unsigned | |||
| | |||
|0 | |||
| | |||
|Contains a bitfield with the notifications being issued to this client about players login/logoff | |||
|- | |||
| | |||
|last_login | |||
|datetime | |||
| | |||
| | |||
| | |||
|The time this character last logged in. | |||
|- | |||
| | |||
|pet_elapsed_time | |||
|float(10,2) | |||
| | |||
|0.00 | |||
| | |||
| | |||
|- | |||
| | |||
|progression_script | |||
|blob | |||
| | |||
| | |||
| | |||
|Script that needs to run on the player when they log back in. | |||
|- | |||
| | |||
|npc_spawn_rule | |||
|int(10) unsigned | |||
| | |||
|0 | |||
| | |||
|Key into spawn rules table for the rule to use. | |||
|- | |||
| | |||
|npc_master_id | |||
|int(10) unsigned | |||
| | |||
|0 | |||
| | |||
|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) unsigned | |||
|MUL | |||
|0 | |||
| | |||
|Key into accounts table for the owner of this character ( or npcclient owner ) | |||
|- | |||
| | |||
|time_connected_sec | |||
|int(10) unsigned | |||
| | |||
|0 | |||
| | |||
|Total time this character has played. | |||
|- | |||
| | |||
|npc_addl_loot_category_id | |||
|int(10) unsigned | |||
| | |||
|0 | |||
| | |||
|Used to add additional looting category for this character. | |||
|- | |||
| | |||
|experience_points | |||
|int(10) unsigned | |||
| | |||
|0 | |||
| | |||
|The amount of experience points this character has | |||
|- | |||
| | |||
|progression_points | |||
|int(10) unsigned | |||
| | |||
|0 | |||
| | |||
|The current number of progression_points this character has. | |||
|- | |||
| | |||
|description | |||
|text | |||
| | |||
| | |||
| | |||
|The characters description (bio) | |||
|- | |||
| | |||
|description_ooc | |||
|text | |||
| | |||
| | |||
| | |||
|The characters out of character description | |||
|- | |||
| | |||
|creation_info | |||
|text | |||
| | |||
| | |||
| | |||
| | |||
|- | |||
| | |||
|description_life | |||
|text | |||
| | |||
| | |||
| | |||
| | |||
|- | |||
| | |||
|kill_exp | |||
|int(5) | |||
| | |||
|10 | |||
| | |||
|The amount of experience this character will give when killed. | |||
|- | |||
| | |||
|animal_affinity | |||
|text | |||
| | |||
| | |||
| | |||
|??? | |||
|- | |||
| | |||
|help_event_flags | |||
|int(11) unsigned | |||
| | |||
|0 | |||
| | |||
|Bit field of which instruction events have played for him. | |||
|- | |||
|DIF | |||
|creation_time | |||
|timestamp | |||
| | |||
|CURRENT_TIMESTAMP | |||
| | |||
| Nullable used to be 'YES' in PSLegacy. | |||
|- | |||
| | |||
|banker | |||
|tinyint(1) unsigned | |||
| | |||
|0 | |||
| | |||
|Flag if this is a banker character. | |||
|- | |||
| | |||
|statue | |||
|tinyint(1) unsigned | |||
| | |||
|0 | |||
| | |||
|Determines if the character is a statue so will be put in STATUE mode | |||
|} | |||
[[Category:Engine documents]] |
Latest revision as of 14:33, 11 January 2022
This table holds all the characters in the game. This includes players, monsters, bosses. Anything that can be thought of as an 'alive' object.
UE | Field | Type | Key Type | Default | Extra | Description |
---|---|---|---|---|---|---|
id | int(10) unsigned | PRI | auto_increment | unique character id | ||
name | varchar(30) | MUL | Character's first name in the game. | |||
lastname | varchar(30) | MUL | The last name of the character. | |||
old_lastname | varchar(30) | The old last name ( used in termination of a marriage ) | ||||
racegender_id | smallint(5) unsigned | 0 | Key into the Race_infoTable for the race and gender of this character. | |||
character_type | int(10) unsigned | 0 | PLAYER = 0,NPC = 1, PET = 2, MOUNT = 3, MOUNTPET = 4 | |||
base_strength | float(10,2) | 0.00 | Character strength (no buffs, but base strength value) | |||
base_agility | float(10,2) | 0.00 | Character agility (no buffs, but base value) | |||
base_endurance | float(10,2) | 0.00 | Character endurance (no buffs, but base value) | |||
base_intelligence | float(10,2) | 0.00 | Character intelligence (no buffs, but base value) | |||
base_will | float(10,2) | 0.00 | Character will (no buffs, but base value) | |||
base_charisma | float(10,2) | 0.00 | Character charisma (no buffs, but base value) | |||
base_hitpoints_max | float(10,2) | 0.00 | 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) | 0.00 | The character's current hitpoint value. | |||
base_mana_max | float(10,2) | 0.00 | The character's base mana. If set to 0 will use skills to determine max mana. | |||
mod_mana | float(10,2) | 0.00 | The character's current mana value. | |||
stamina_physical | float(10,2) | 0.00 | The character's physical stamina | |||
stamina_mental | float(10,2) | 0.00 | The character's mental stamina. | |||
money_circles | int(10) unsigned | 0 | The number of circles the character has. | |||
money_octas | int(10) unsigned | 0 | The number of octas the character has. | |||
money_hexas | int(10) unsigned | 0 | The number of hexas the character has. | |||
money_trias | int(10) unsigned | 0 | The number of trias the character has. | |||
bank_money_circles | int(10) unsigned | 0 | The number of circles the character has (banked). | |||
bank_money_octas | int(10) unsigned | 0 | The number of octas the character has (banked). | |||
bank_money_hexas | int(10) unsigned | 0 | The number of hexas the character has (banked). | |||
bank_money_trias | int(10) unsigned | 0 | The number of trias the character has (banked). | |||
loc_instance | int(11) unsigned | 0 | Instance number the character is in. | |||
loc_sector_id | int(10) unsigned | 0 | The ID of the sector the character is in. | |||
loc_x | float(10,2) | 0.00 | X location of character in world. | |||
loc_y | float(10,2) | 0.00 | Y location of character in world. | |||
loc_z | float(10,2) | 0.00 | Z location of character in world. | |||
loc_yrot | float(10,2) | 0.00 | The direction the character is facing. | |||
guild_member_of | int(10) unsigned | 0 | The ID key of the guild this character is a member of. | |||
guild_level | tinyint(1) unsigned | 0 | The rank this character is in their guild. | |||
guild_additional_privileges | smallint(3) unsigned | 0 | Contains a bitfield with the additional priviledges assigned to this char (additional to the guild level it's in) | |||
guild_denied_privileges | smallint(3) unsigned | 0 | Contains a bitfield with the removed priviledges from this char (removed from the guild level it's in) | |||
guild_points | int(10) unsigned | 0 | Number of points character has in the guild. | |||
guild_public_notes | varchar(255) | Character's public guild note. | ||||
guild_private_notes | varchar(255) | 0 | Character's private guild note. | |||
join_notifications | tinyint(1) unsigned | 0 | Contains a bitfield with the notifications being issued to this client about players login/logoff | |||
last_login | datetime | The time this character last logged in. | ||||
pet_elapsed_time | float(10,2) | 0.00 | ||||
progression_script | blob | Script that needs to run on the player when they log back in. | ||||
npc_spawn_rule | int(10) unsigned | 0 | Key into spawn rules table for the rule to use. | |||
npc_master_id | int(10) unsigned | 0 | 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) unsigned | MUL | 0 | Key into accounts table for the owner of this character ( or npcclient owner ) | ||
time_connected_sec | int(10) unsigned | 0 | Total time this character has played. | |||
npc_addl_loot_category_id | int(10) unsigned | 0 | Used to add additional looting category for this character. | |||
experience_points | int(10) unsigned | 0 | The amount of experience points this character has | |||
progression_points | int(10) unsigned | 0 | The current number of progression_points this character has. | |||
description | text | The characters description (bio) | ||||
description_ooc | text | The characters out of character description | ||||
creation_info | text | |||||
description_life | text | |||||
kill_exp | int(5) | 10 | The amount of experience this character will give when killed. | |||
animal_affinity | text | ??? | ||||
help_event_flags | int(11) unsigned | 0 | Bit field of which instruction events have played for him. | |||
DIF | creation_time | timestamp | CURRENT_TIMESTAMP | Nullable used to be 'YES' in PSLegacy. | ||
banker | tinyint(1) unsigned | 0 | Flag if this is a banker character. | |||
statue | tinyint(1) unsigned | 0 | Determines if the character is a statue so will be put in STATUE mode |