CharactersTable
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 |