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