CharactersTable: Difference between revisions

From PSwiki
Jump to navigation Jump to search
Kuru (talk | contribs)
No edit summary
m Reverted edits by Kuru (Talk) to last revision by Ethryn
Line 1: Line 1:
spam
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.