system_fingerprint_usage Table¶
Records system fingerprint usage during logon - part of anti-cheat/multi-boxing detection.
Schema Summary¶
| Field | Type | Key | Null | Default | Extra |
|---|---|---|---|---|---|
id |
int(10) unsigned | PRI | NO | auto_increment | |
fingerprint |
int(10) unsigned | MUL | NO | ||
account |
int(10) unsigned | MUL | NO | ||
ip |
varchar(16) | MUL | NO | ||
realm |
int(10) unsigned | NO | |||
time |
timestamp | NO | current_timestamp() | ||
architecture |
varchar(16) | YES | |||
cputype |
varchar(64) | YES | |||
activecpus |
int(10) unsigned | YES | |||
totalcpus |
int(10) unsigned | YES | |||
pagesize |
int(10) unsigned | YES |
Field Breakdown¶
id- Primary Key. Row id.fingerprint- System fingerprint hash; the core does not currently implement fingerprinting and always stores0.account- Account using the fingerprint (account.id).ip- Source IP.realm- Realm id.time- Row insert timestamp (each observation is one row).architecture- Machine characteristics collected with the fingerprint.cputype- Machine characteristics collected with the fingerprint.activecpus- Machine characteristics collected with the fingerprint.totalcpus- Machine characteristics collected with the fingerprint.pagesize- Machine characteristics collected with the fingerprint.