CharactersTable - Revision history

Grimston at 14:33, 11 January 2022

2022-01-11T14:33:40Z

← Older revision		Revision as of 14:33, 11 January 2022
Line 107:		Line 107:
	\|Character charisma (no buffs, but base value)		\|Character charisma (no buffs, but base value)
	\|-		\|-
	\|~~DIF~~		\|
	\|base_hitpoints_max		\|base_hitpoints_max
	\|float(10,2)		\|float(10,2)
Line 113:		Line 113:
	\|0.00		\|0.00
	\|		\|
	\|The max character hitpoints. If set to 0 it will use an equation to determine the max hitpoints from character skills~~. Nullable used to be 'NO' in PSLegacy~~.		\|The max character hitpoints. If set to 0 it will use an equation to determine the max hitpoints from character skills.
	\|-		\|-
	\|		\|
Line 123:		Line 123:
	\|The character's current hitpoint value.		\|The character's current hitpoint value.
	\|-		\|-
	\|~~DIF~~		\|
	\|base_mana_max		\|base_mana_max
	\|float(10,2)		\|float(10,2)
Line 129:		Line 129:
	\|0.00		\|0.00
	\|		\|
	\|The character's base mana. If set to 0 will use skills to determine max mana~~. Nullable used to be 'NO' in PSLegacy~~.		\|The character's base mana. If set to 0 will use skills to determine max mana.
	\|-		\|-
	\|		\|
Line 339:		Line 339:
	\|The time this character last logged in.		\|The time this character last logged in.
	\|-		\|-
	~~\|OBS~~
	~~\|faction_standings~~
	~~\|blob~~
	\|		\|
			\|pet_elapsed_time
			\|float(10,2)
	\|		\|
			\|0.00
	\|		\|
	\|~~CSV string that holds faction ratings.~~		\|
	\|-		\|-
	\|		\|
Line 379:		Line 379:
	\|Y/N if this character is allowed to be attacked.		\|Y/N if this character is allowed to be attacked.
	\|-		\|-
	\|~~DIF~~		\|
	\|account_id		\|account_id
	\|int(10) unsigned		\|int(10) unsigned
Line 385:		Line 385:
	\|0		\|0
	\|		\|
	\|Key into accounts table for the owner of this character ( or npcclient owner ) ~~Key Type used to be '' in PSLegacy.~~		\|Key into accounts table for the owner of this character ( or npcclient owner )
	\|-		\|-
	\|		\|
Line 433:		Line 433:
	\|		\|
	\|		\|
	\|The characters out of character description		\|The characters out of character description
	\|-		\|-
	\|		\|
Line 475:		Line 475:
	\|Bit field of which instruction events have played for him.		\|Bit field of which instruction events have played for him.
	\|-		\|-
	\|		\|DIF
	\|creation_time		\|creation_time
	\|timestamp		\|timestamp
Line 481:		Line 481:
	\|CURRENT_TIMESTAMP		\|CURRENT_TIMESTAMP
	\|		\|
	\|~~The time this character was created~~.		\| Nullable used to be 'YES' in PSLegacy.
	\|-		\|-
	\|		\|
Line 498:		Line 498:
	\|		\|
	\|Determines if the character is a statue so will be put in STATUE mode		\|Determines if the character is a statue so will be put in STATUE mode
	\|-
	~~\|OBS~~
	~~\|gm_command_log_id~~
	~~\|int(10) unsigned~~
	\|
	\|
	\|
	\|
	\|-
	~~\|OBS~~
	~~\|gm_command_log_id1~~
	~~\|int(10) unsigned~~
	\|
	\|
	\|
	\|
	\|-
	~~\|ADD~~
	~~\|pet_elapsed_time~~
	~~\|float(10,2)~~
	\|
	~~\|0.00~~
	\|
	\|
	\|}		\|}


	[[Category:Engine documents]]		[[Category:Engine documents]]

Grimston at 12:02, 11 January 2022

2022-01-11T12:02:28Z

Show changes

Talad at 23:47, 4 March 2020

2020-03-04T23:47:10Z

← Older revision		Revision as of 23:47, 4 March 2020
Line 35:		Line 35:
	\| int(10)		\| int(10)
	\| N		\| N
	\|		\| PLAYER = 0,NPC = 1, PET = 2, MOUNT = 3, MOUNTPET = 4
	\|-		\|-
	\| base_strength		\| base_strength

Magodra at 14:51, 4 March 2012

2012-03-04T14:51:23Z

← Older revision		Revision as of 14:51, 4 March 2012
Line 210:		Line 210:
	\| int(10)		\| int(10)
	\| Y		\| Y
	\| Key into [[spawn rules table~~\|Npc_spawn_rulesTable~~]] for the rule to use.		\| Key into [[Npc_spawn_rulesTable\|spawn rules table]] for the rule to use.
	\|-		\|-
	\| npc_master_id		\| npc_master_id

Magodra at 14:50, 4 March 2012

2012-03-04T14:50:18Z

← Older revision		Revision as of 14:50, 4 March 2012
Line 210:		Line 210:
	\| int(10)		\| int(10)
	\| Y		\| Y
	\| Key into spawn rules table for the rule to use.		\| Key into [[spawn rules table\|Npc_spawn_rulesTable]] for the rule to use.
	\|-		\|-
	\| npc_master_id		\| npc_master_id

Talad: Reverted edits by Kuru (Talk) to last revision by Ethryn

2010-12-10T23:14:39Z

Reverted edits by Kuru (Talk) to last revision by Ethryn

Show changes

Kuru at 21:18, 10 December 2010

2010-12-10T21:18:37Z

Show changes

Ethryn: add to category (Engine documents)

2010-10-23T00:12:30Z

add to category (Engine documents)

← Older revision		Revision as of 00:12, 23 October 2010
Line 277:		Line 277:
	\| Flag if this is a banker character.		\| Flag if this is a banker character.
	\|}		\|}


			[[Category:Engine documents]]

Talad: Created page with '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 !…'

2010-10-12T22:13:28Z

Created page with '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 !…'

New page

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