|
|
| 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.
| | spam |
| {| 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]]
| |