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.

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 Npc_spawn_rulesTable 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.