accounts - Spikeone/WaS_Server GitHub Wiki
This table contains all accounts.
| Field | Type | Can be null | Default |
| id | int(8) | NO | |
| username | varchar(32) | NO | |
| sha_pass | varchar(64) | NO | F3341DBCDDA605B1601524B0D01655750CC60E0D |
| gm_level | int(4) | NO | 0 |
| varchar(64) | YES | NULL | |
| joindate | date(0) | YES | NULL |
| lastip | varchar(32) | YES | NULL |
| lastlogin | date(0) | YES | NULL |
| status | int(4) | NO | 0 |
Unique account id. This account id is used in the characters table to link characters to accounts.
Contains the username which is used to login to the webpage. This is not the characters nickname but they can be the same.
Hashed password of the account. This is also used to login in ingame.
If the account has elaborated rights, this is represented by the gm level. The higher the level is, the more commands can be issued by the user.
E-Mail which is associated with the account and can be used to restore the password or send newsletter.
Date the account was created.
Last ip the account was logged in from.
Last time the user logged in.
This is the status of the account. Following values are currently used:
| Value | Description |
| 0 | Status is active |