characters - Spikeone/WaS_Server GitHub Wiki
This table contains all characters.
| Field | Type | Can be null | Default |
| guid | int(32) | NO | |
| account | int(8) | NO | |
| nickname | varchar(20) | NO | |
| race | int(4) | NO | 0 |
| gender | int(1) | NO | 1 |
| level | int(8) | NO | 1 |
| xp | int(8) | NO | 0 |
| money | int(8) | NO | 0 |
| flags1 | int(8) | NO | 0 |
| flags2 | int(8) | NO | 0 |
| pos_x | float(0) | NO | 0 |
| pos_y | float(0) | NO | 0 |
| pos_z | float(0) | NO | 0 |
| rot_x | float(0) | NO | 0 |
| rot_y | float(0) | NO | 0 |
| rot_z | float(0) | NO | 0 |
| map | int(8) | NO | 1 |
This is the unique guid of the character.
This is the link to the account. That way the character which belongs to a account can be found.
This is the nickname of the character which should be displayed ingame. This is not the login name of the account.
This is the characters race. Currently the following values are used:
| Value | Description |
This is the characters gender. Currently the following values are used
| Value | Description |
| 0 | female |
| 1 | male |
This is the characters level.
This is the current experience the character has.
Money the character has.
These are the character flags. Following values are currently used:
| Value | Description |
These are the character flags. Following values are currently used:
| Value | Description |
This position is used when loading the character into the world. That way the player starts where he has last been. The map is used to determin which map the player should load after the login level.