new server checking mechanism, complete recode of major functionsv2.4.0

4 files changed, 188 insertions, 234 deletions

diff --git a/data/masterserver-config.pl b/data/masterserver-config.pl
index 7cae5de..19d166b 100755
--- a/data/masterserver-config.pl
+++ b/data/masterserver-config.pl
@@ -1,7 +1,7 @@
 package MasterServer;
 
 #
-# Last update: Sat 13 May 2017 13:37 GMT+1
+# Last update: 22 Aug 2017
 #
 
 our (%S, $ROOT);
@@ -24,8 +24,9 @@ our %S = (
   masterserver_hostname => "master.333networks.com (333networks MasterServer Template)",
   
   # contact details (shows in TCP requests directly from master to master)
-  masterserver_contact  => 'Darkelarious -- info@333networks.com',
-  masterserver_address  => 'master.333networks.com',
+  masterserver_name     => 'Your Name Here',
+  masterserver_contact  => 'info@example.com',
+  masterserver_address  => 'master.example.com',
   
 ################################################################################
 # Database Login Configuration                                                 #
@@ -73,8 +74,15 @@ our %S = (
   # show only important events
   suppress => "debug beacon uplink secure tcp add update delete",
   
-  # more keywords that can be suppressed: 
-  # applet-rx error info kfstat stat sync-rx sync-tx list ignore dump support
+  # keywords that can be suppressed (from high to low severity): 
+  #   fatal fail error stop
+  #   refused nodevice timeout
+  #   reset warning secure unset
+  #   add update delete
+  #   list uplink
+  #   beacon syncer
+  #   stat kfnew
+  #   info debug
   
 ################################################################################
 # Network settings                                                             #
@@ -108,6 +116,9 @@ our %S = (
   # ignore keys from games that use multiple keys or do not support keys at all
   ignore_beacon_key   => "deusex ut wot rune",
   ignore_browser_key  => "deusex",
+  
+  # some games do not even support the "secure" and "validate" values. Bypass.
+  secure_unsupported  => "tribesv",
 
 ################################################################################
 # Enable settings                                                              #
@@ -122,17 +133,12 @@ our %S = (
   # Synchronization with other 333networks-based masterservers
   sync_enabled  => 1,
 
-  # Beacon Checker query all addresses in the database, requesting "basic" and 
-  # "info". Execute at least twice per hour, to avoid time-outs in own data.
+  # Beacon Checker 
+  # getting server status info from \all\ servers. executed every 15 minutes to
+  # keep information up to date. 
   # disabling breaks support for certain games [like tribesv].
   beacon_checker_enabled  => 1,
 
-  # Collect server information for the 333networks main site. Identical
-  # mechanism as the Beacon Checker. Is used for by 333networks to show
-  # Unreal Tournament information on the site.
-  # NB: with some work it can be adapted to work with any other game. Own risk.
-  utserver_query_enabled  => 0,
-
 ################################################################################
 # Synchronization settings                                                     #
 #                                                                              #
@@ -181,7 +187,7 @@ our %S = (
   # Collect kfstats info
   kfstats_enabled  => 0,
 
-  #kfstats.ini file location
+  # kfstats.ini file location
   kfstats_file =>  "/UT2004/System/KFStats.ini",
   
 ); #end configuration %S
diff --git a/data/sql/tables-Pg.sql b/data/sql/tables-Pg.sql
index b4ddd4d..ab68d61 100755
--- a/data/sql/tables-Pg.sql
+++ b/data/sql/tables-Pg.sql
@@ -1,106 +1,104 @@
 CREATE TABLE appletlist(
-  id              SERIAL    UNIQUE NOT NULL PRIMARY KEY,
-  ip              inet             NOT NULL DEFAULT '0.0.0.0',
-  port            INTEGER          NOT NULL DEFAULT 0,
-  gamename        VARCHAR(50)      NOT NULL DEFAULT ' ',
-  added           timestamptz      NOT NULL DEFAULT NOW(),
-  updated         timestamptz      NOT NULL DEFAULT NOW()
+  id              SERIAL UNIQUE NOT NULL PRIMARY KEY,
+  ip              inet          NOT NULL,
+  hostport        INTEGER       NOT NULL,
+  gamename        TEXT          NOT NULL DEFAULT '',
+  added           timestamptz   NOT NULL DEFAULT NOW(),
+  updated         timestamptz   NOT NULL DEFAULT NOW()
 );
 
 CREATE TABLE serverlist(
-  id              SERIAL    UNIQUE NOT NULL PRIMARY KEY,
-  ip              inet             NOT NULL DEFAULT '0.0.0.0',
-  port            INTEGER          NOT NULL DEFAULT 0,
-  gamename        VARCHAR(50)      NOT NULL DEFAULT ' ',
-  gamever         VARCHAR(50)      NOT NULL DEFAULT ' ',
-  hostname        VARCHAR(200)     NOT NULL DEFAULT ' ',
-  hostport        INTEGER          NOT NULL DEFAULT 0,
-  country         VARCHAR(5),
-  b333ms          BOOLEAN          NOT NULL DEFAULT FALSE,
-  blacklisted     BOOLEAN          NOT NULL DEFAULT FALSE,
-  added           timestamptz      NOT NULL DEFAULT NOW(),
-  beacon          timestamptz      NOT NULL DEFAULT NOW(),
-  updated         timestamptz      NOT NULL DEFAULT NOW()
+  id          SERIAL UNIQUE NOT NULL PRIMARY KEY,
+  ip          inet          NOT NULL,
+  port        INTEGER       NOT NULL DEFAULT 0,
+  gamename    TEXT          NOT NULL DEFAULT '',
+  gamever     TEXT,
+  hostname    TEXT,
+  hostport    INTEGER       DEFAULT 0,
+  country     TEXT,
+  b333ms      BOOLEAN       DEFAULT FALSE,
+  blacklisted BOOLEAN       DEFAULT FALSE,
+  added       timestamptz   NOT NULL DEFAULT NOW(),
+  beacon      timestamptz   NOT NULL DEFAULT NOW(),
+  updated     timestamptz   NOT NULL DEFAULT NOW()
 );
+CREATE INDEX pendingaddress ON serverlist(ip, port);
+CREATE INDEX updateaddress  ON serverlist(ip, hostport);
+CREATE INDEX directbeacons  ON serverlist(gamename, b333ms);
 
 CREATE TABLE games(
-  gamename        VARCHAR(50)        NOT NULL,
-  cipher          VARCHAR(10)        NOT NULL DEFAULT ' ',
-  description     VARCHAR(200)       NOT NULL DEFAULT ' ',
-  default_qport   INTEGER            NOT NULL DEFAULT 0,
-  num_uplink      INTEGER            NOT NULL DEFAULT 0,
-  num_total       INTEGER            NOT NULL DEFAULT 0
+  gamename        TEXT NOT NULL,
+  cipher          TEXT,
+  description     TEXT,
+  default_qport   INTEGER DEFAULT 0,
+  num_uplink      INTEGER DEFAULT 0,
+  num_total       INTEGER DEFAULT 0
 );
+CREATE INDEX gameprops ON games(gamename);
 
 CREATE TABLE pending(
-  id              SERIAL    UNIQUE NOT NULL PRIMARY KEY,
-  ip              inet             NOT NULL DEFAULT '0.0.0.0',
-  beaconport      INTEGER          NOT NULL DEFAULT 0,
-  heartbeat       INTEGER          NOT NULL DEFAULT 0,
-  gamename        VARCHAR(25)      NOT NULL DEFAULT ' ',  
-  secure          VARCHAR(12)      NOT NULL DEFAULT 'wookie',
-  enctype         INTEGER          NOT NULL DEFAULT 0,
-  added           timestamptz      NOT NULL DEFAULT NOW()
+  id        SERIAL UNIQUE NOT NULL PRIMARY KEY,
+  ip        inet          NOT NULL,
+  heartbeat INTEGER       NOT NULL DEFAULT 0,
+  added     timestamptz   NOT NULL DEFAULT NOW()
 );
 
-CREATE TABLE utserver_info(
-  server_id           SERIAL       REFERENCES serverlist(id),
-  minnetver           INTEGER      NOT NULL DEFAULT 400,
-  gamever             INTEGER      NOT NULL DEFAULT 400,
-  location            INTEGER      NOT NULL DEFAULT 0,
-  listenserver        BOOLEAN      NOT NULL DEFAULT TRUE,
-  hostport            INTEGER      NOT NULL DEFAULT 7777,
-  hostname            varchar(200) NOT NULL DEFAULT 'Another UT server',
-  adminname           varchar(200) NOT NULL DEFAULT '',
-  adminemail          varchar(300) NOT NULL DEFAULT '',
-  password            BOOLEAN      NOT NULL DEFAULT FALSE,
-  gametype            varchar(50)  NOT NULL DEFAULT '',
-  gamestyle           varchar(50)  NOT NULL DEFAULT 'Normal',
-  changelevels        BOOLEAN      NOT NULL DEFAULT FALSE,
-  maptitle            varchar(100) NOT NULL DEFAULT 'Unknown',
-  mapname             varchar(100) NOT NULL DEFAULT '',
-  numplayers          INTEGER      NOT NULL DEFAULT 0,
-  maxplayers          INTEGER      NOT NULL DEFAULT 0,
-  minplayers          INTEGER      NOT NULL DEFAULT 0,
-  botskill            varchar(30)  NOT NULL DEFAULT 'Novice',
-  balanceteams        BOOLEAN      NOT NULL DEFAULT FALSE,
-  playersbalanceteams BOOLEAN      NOT NULL DEFAULT FALSE,
-  friendlyfire        varchar(10)  NOT NULL DEFAULT '0%',
-  maxteams            INTEGER      NOT NULL DEFAULT 4,
-  timelimit           INTEGER      NOT NULL DEFAULT 0,
-  goalteamscore       INTEGER      NOT NULL DEFAULT 0,
-  fraglimit           INTEGER      NOT NULL DEFAULT 0,
-  mutators            TEXT         NOT NULL DEFAULT 'None',
-  updated             timestamptz  NOT NULL DEFAULT NOW()
+CREATE TABLE extended_info(
+  server_id           SERIAL REFERENCES serverlist(id),
+  minnetver           TEXT,
+  location            TEXT,
+  listenserver        TEXT,
+  adminname           TEXT,
+  adminemail          TEXT,
+  password            TEXT,
+  gametype            TEXT,
+  gamestyle           TEXT,
+  changelevels        TEXT,
+  maptitle            TEXT,
+  mapname             TEXT,
+  numplayers          INTEGER DEFAULT 0,
+  maxplayers          INTEGER DEFAULT 0,
+  minplayers          INTEGER DEFAULT 0,
+  botskill            TEXT,
+  balanceteams        TEXT,
+  playersbalanceteams TEXT,
+  friendlyfire        TEXT,
+  maxteams            TEXT,
+  timelimit           TEXT,
+  goalteamscore       TEXT,
+  fraglimit           TEXT,
+  mutators            TEXT DEFAULT 'None',
+  updated      timestamptz NOT NULL DEFAULT NOW()
 );
 
-CREATE TABLE utplayer_info(
-  server_id SERIAL        NOT NULL,
-  player    varchar(40)   NOT NULL DEFAULT 'Player',
-  team      INTEGER       NOT NULL DEFAULT 255,
-  frags     INTEGER       NOT NULL DEFAULT 0,
-  mesh      varchar(100)  NOT NULL DEFAULT '',
-  skin      varchar(100)  NOT NULL DEFAULT '',
-  face      varchar(100)  NOT NULL DEFAULT '',
-  ping      INTEGER       NOT NULL DEFAULT 0,
-  ngsecret  varchar(10)   NOT NULL DEFAULT 'false',
-  updated   timestamptz   NOT NULL DEFAULT NOW()
+CREATE TABLE player_info(
+  server_id SERIAL  NOT NULL,
+  player    TEXT    DEFAULT 'Player',
+  team      TEXT,
+  frags     INTEGER DEFAULT 0,
+  mesh      TEXT,
+  skin      TEXT,
+  face      TEXT,
+  ping      INTEGER DEFAULT 0,
+  ngsecret  TEXT,
+  updated   timestamptz NOT NULL DEFAULT NOW()
 );
 
 CREATE TABLE kfstats(
-  UTkey             varchar(34) NOT NULL,
-  Username          varchar(80) NOT NULL DEFAULT '',
-  CurrentVeterancy  varchar(80)          DEFAULT 'None',
-  TotalKills        INTEGER     NOT NULL DEFAULT 0,
-  DecaptedKills     INTEGER     NOT NULL DEFAULT 0,
-  TotalMeleeDamage  INTEGER     NOT NULL DEFAULT 0,
-  MeleeKills        INTEGER     NOT NULL DEFAULT 0,
-  PowerWpnKills     INTEGER     NOT NULL DEFAULT 0,
-  BullpupDamage     INTEGER     NOT NULL DEFAULT 0,
-  StalkerKills      INTEGER     NOT NULL DEFAULT 0,
-  TotalWelded       INTEGER     NOT NULL DEFAULT 0,
-  TotalHealed       INTEGER     NOT NULL DEFAULT 0,
-  TotalPlaytime     INTEGER     NOT NULL DEFAULT 0,
-  GamesWon          INTEGER     NOT NULL DEFAULT 0,
-  GamesLost         INTEGER     NOT NULL DEFAULT 0
+  UTkey             TEXT    NOT NULL,
+  Username          TEXT    DEFAULT ' ',
+  CurrentVeterancy  TEXT    DEFAULT 'None',
+  TotalKills        INTEGER NOT NULL DEFAULT 0,
+  DecaptedKills     INTEGER NOT NULL DEFAULT 0,
+  TotalMeleeDamage  INTEGER NOT NULL DEFAULT 0,
+  MeleeKills        INTEGER NOT NULL DEFAULT 0,
+  PowerWpnKills     INTEGER NOT NULL DEFAULT 0,
+  BullpupDamage     INTEGER NOT NULL DEFAULT 0,
+  StalkerKills      INTEGER NOT NULL DEFAULT 0,
+  TotalWelded       INTEGER NOT NULL DEFAULT 0,
+  TotalHealed       INTEGER NOT NULL DEFAULT 0,
+  TotalPlaytime     INTEGER NOT NULL DEFAULT 0,
+  GamesWon          INTEGER NOT NULL DEFAULT 0,
+  GamesLost         INTEGER NOT NULL DEFAULT 0
 );
+
diff --git a/data/sql/tables-SQLite.sql b/data/sql/tables-SQLite.sql
index 6050acc..80df6b4 100755
--- a/data/sql/tables-SQLite.sql
+++ b/data/sql/tables-SQLite.sql
@@ -1,107 +1,104 @@
 CREATE TABLE appletlist(
-  id              INTEGER          PRIMARY KEY AUTOINCREMENT,
-  ip              VARCHAR(15)      NOT NULL DEFAULT '0.0.0.0',
-  port            INTEGER          NOT NULL DEFAULT 0,
-  gamename        VARCHAR(50)      NOT NULL DEFAULT ' ',
-  added           timestamptz      NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  updated         timestamptz      NOT NULL DEFAULT CURRENT_TIMESTAMP
+  id              INTEGER       PRIMARY KEY AUTOINCREMENT,
+  ip              inet          NOT NULL,
+  hostport        INTEGER       NOT NULL,
+  gamename        TEXT          NOT NULL DEFAULT '',
+  added           timestamptz   NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  updated         timestamptz   NOT NULL DEFAULT CURRENT_TIMESTAMP
 );
 
 CREATE TABLE serverlist(
-  id              INTEGER          PRIMARY KEY AUTOINCREMENT,
-  ip              VARCHAR(15)      NOT NULL DEFAULT '0.0.0.0',
-  port            INTEGER          NOT NULL DEFAULT 0,
-  gamename        VARCHAR(100)     NOT NULL DEFAULT ' ',
-  gamever         VARCHAR(50)      NOT NULL DEFAULT ' ',
-  hostname        VARCHAR(100)     NOT NULL DEFAULT ' ',
-  hostport        INTEGER          NOT NULL DEFAULT 0,
-  country         VARCHAR(5),
-  b333ms          BOOLEAN          NOT NULL DEFAULT 0,
-  blacklisted     BOOLEAN          NOT NULL DEFAULT 0,
-  added           timestamptz      NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  beacon          timestamptz      NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  updated         timestamptz      NOT NULL DEFAULT CURRENT_TIMESTAMP
+  id          INTEGER       PRIMARY KEY AUTOINCREMENT,
+  ip          inet          NOT NULL,
+  port        INTEGER       NOT NULL DEFAULT 0,
+  gamename    TEXT          NOT NULL DEFAULT '',
+  gamever     TEXT,
+  hostname    TEXT,
+  hostport    INTEGER       DEFAULT 0,
+  country     TEXT,
+  b333ms      BOOLEAN       DEFAULT FALSE,
+  blacklisted BOOLEAN       DEFAULT FALSE,
+  added       timestamptz   NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  beacon      timestamptz   NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  updated     timestamptz   NOT NULL DEFAULT CURRENT_TIMESTAMP
 );
+CREATE INDEX pendingaddress ON serverlist(ip, port);
+CREATE INDEX updateaddress  ON serverlist(ip, hostport);
+CREATE INDEX directbeacons  ON serverlist(gamename, b333ms);
 
 CREATE TABLE games(
-  gamename        VARCHAR(50)        NOT NULL,
-  cipher          VARCHAR(10)        NOT NULL DEFAULT ' ',
-  description     VARCHAR(200)       NOT NULL DEFAULT ' ',
-  default_qport   INTEGER            NOT NULL DEFAULT 0,
-  num_uplink      INTEGER            NOT NULL DEFAULT 0,
-  num_total       INTEGER            NOT NULL DEFAULT 0
+  gamename        TEXT NOT NULL,
+  cipher          TEXT,
+  description     TEXT,
+  default_qport   INTEGER DEFAULT 0,
+  num_uplink      INTEGER DEFAULT 0,
+  num_total       INTEGER DEFAULT 0
 );
+CREATE INDEX gameprops ON games(gamename);
 
 CREATE TABLE pending(
-  id              INTEGER          PRIMARY KEY AUTOINCREMENT,
-  ip              VARCHAR(15)      NOT NULL DEFAULT '0.0.0.0',
-  beaconport      INTEGER          NOT NULL DEFAULT 0,
-  heartbeat       INTEGER          NOT NULL DEFAULT 0,
-  gamename        VARCHAR(25)      NOT NULL DEFAULT ' ',  
-  secure          VARCHAR(12)      NOT NULL DEFAULT 'wookie',
-  enctype         INTEGER          NOT NULL DEFAULT 0,
-  added           timestamptz      NOT NULL DEFAULT CURRENT_TIMESTAMP
+  id        INTEGER     PRIMARY KEY AUTOINCREMENT,
+  ip        inet        NOT NULL,
+  heartbeat INTEGER     NOT NULL DEFAULT 0,
+  added     timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP
 );
 
 CREATE TABLE utserver_info(
-  server_id           INTEGER      PRIMARY KEY AUTOINCREMENT,
-  minnetver           INTEGER      NOT NULL DEFAULT 400,
-  gamever             INTEGER      NOT NULL DEFAULT 400,
-  location            INTEGER      NOT NULL DEFAULT 0,
-  listenserver        BOOLEAN      NOT NULL DEFAULT TRUE,
-  hostport            INTEGER      NOT NULL DEFAULT 7777,
-  hostname            varchar(200) NOT NULL DEFAULT 'Another UT server',
-  adminname           varchar(200) NOT NULL DEFAULT '',
-  adminemail          varchar(300) NOT NULL DEFAULT '',
-  password            BOOLEAN      NOT NULL DEFAULT 0,
-  gametype            varchar(50)  NOT NULL DEFAULT '',
-  gamestyle           varchar(50)  NOT NULL DEFAULT 'Normal',
-  changelevels        BOOLEAN      NOT NULL DEFAULT 0,
-  maptitle            varchar(100) NOT NULL DEFAULT 'Unknown',
-  mapname             varchar(100) NOT NULL DEFAULT '',
-  numplayers          INTEGER      NOT NULL DEFAULT 0,
-  maxplayers          INTEGER      NOT NULL DEFAULT 0,
-  minplayers          INTEGER      NOT NULL DEFAULT 0,
-  botskill            varchar(30)  NOT NULL DEFAULT 'Novice',
-  balanceteams        BOOLEAN      NOT NULL DEFAULT 0,
-  playersbalanceteams BOOLEAN      NOT NULL DEFAULT 0,
-  friendlyfire        varchar(10)  NOT NULL DEFAULT '0%',
-  maxteams            INTEGER      NOT NULL DEFAULT 4,
-  timelimit           INTEGER      NOT NULL DEFAULT 0,
-  goalteamscore       INTEGER      NOT NULL DEFAULT 0,
-  fraglimit           INTEGER      NOT NULL DEFAULT 0,
-  mutators            TEXT         NOT NULL DEFAULT 'None',
+  server_id           INTEGER PRIMARY KEY AUTOINCREMENT,
+  minnetver           TEXT,
+  location            TEXT,
+  listenserver        TEXT,
+  adminname           TEXT,
+  adminemail          TEXT,
+  password            TEXT,
+  gametype            TEXT,
+  gamestyle           TEXT,
+  changelevels        TEXT,
+  maptitle            TEXT,
+  mapname             TEXT,
+  numplayers          INTEGER DEFAULT 0,
+  maxplayers          INTEGER DEFAULT 0,
+  minplayers          INTEGER DEFAULT 0,
+  botskill            TEXT,
+  balanceteams        TEXT,
+  playersbalanceteams TEXT,
+  friendlyfire        TEXT,
+  maxteams            TEXT,
+  timelimit           TEXT,
+  goalteamscore       TEXT,
+  fraglimit           TEXT,
+  mutators            TEXT DEFAULT 'None',
   updated             timestamptz  NOT NULL DEFAULT CURRENT_TIMESTAMP,
   FOREIGN KEY(server_id) REFERENCES serverlist(id)
 );
 
 CREATE TABLE utplayer_info(
-  server_id INTEGER,
-  player    varchar(40)   NOT NULL DEFAULT 'Player',
-  team      INTEGER       NOT NULL DEFAULT 255,
-  frags     INTEGER       NOT NULL DEFAULT 0,
-  mesh      varchar(100)  NOT NULL DEFAULT '',
-  skin      varchar(100)  NOT NULL DEFAULT '',
-  face      varchar(100)  NOT NULL DEFAULT '',
-  ping      INTEGER       NOT NULL DEFAULT 0,
-  ngsecret  varchar(10)   NOT NULL DEFAULT 'false',
-  updated   timestamptz   NOT NULL DEFAULT CURRENT_TIMESTAMP
+  server_id INTEGER NOT NULL,
+  player    TEXT    DEFAULT 'Player',
+  team      TEXT,
+  frags     INTEGER DEFAULT 0,
+  mesh      TEXT,
+  skin      TEXT,
+  face      TEXT,
+  ping      INTEGER DEFAULT 0,
+  ngsecret  TEXT,
+  updated   timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP
 );
 
 CREATE TABLE kfstats(
-  UTkey             varchar(34) NOT NULL,
-  Username          varchar(80) NOT NULL DEFAULT '',
-  CurrentVeterancy  varchar(80)          DEFAULT 'None',
-  TotalKills        INTEGER     NOT NULL DEFAULT 0,
-  DecaptedKills     INTEGER     NOT NULL DEFAULT 0,
-  TotalMeleeDamage  INTEGER     NOT NULL DEFAULT 0,
-  MeleeKills        INTEGER     NOT NULL DEFAULT 0,
-  PowerWpnKills     INTEGER     NOT NULL DEFAULT 0,
-  BullpupDamage     INTEGER     NOT NULL DEFAULT 0,
-  StalkerKills      INTEGER     NOT NULL DEFAULT 0,
-  TotalWelded       INTEGER     NOT NULL DEFAULT 0,
-  TotalHealed       INTEGER     NOT NULL DEFAULT 0,
-  TotalPlaytime     INTEGER     NOT NULL DEFAULT 0,
-  GamesWon          INTEGER     NOT NULL DEFAULT 0,
-  GamesLost         INTEGER     NOT NULL DEFAULT 0
+  UTkey             TEXT    NOT NULL,
+  Username          TEXT    DEFAULT ' ',
+  CurrentVeterancy  TEXT    DEFAULT 'None',
+  TotalKills        INTEGER NOT NULL DEFAULT 0,
+  DecaptedKills     INTEGER NOT NULL DEFAULT 0,
+  TotalMeleeDamage  INTEGER NOT NULL DEFAULT 0,
+  MeleeKills        INTEGER NOT NULL DEFAULT 0,
+  PowerWpnKills     INTEGER NOT NULL DEFAULT 0,
+  BullpupDamage     INTEGER NOT NULL DEFAULT 0,
+  StalkerKills      INTEGER NOT NULL DEFAULT 0,
+  TotalWelded       INTEGER NOT NULL DEFAULT 0,
+  TotalHealed       INTEGER NOT NULL DEFAULT 0,
+  TotalPlaytime     INTEGER NOT NULL DEFAULT 0,
+  GamesWon          INTEGER NOT NULL DEFAULT 0,
+  GamesLost         INTEGER NOT NULL DEFAULT 0
 );
diff --git a/data/sql/tables-mysql.sql b/data/sql/tables-mysql.sql
deleted file mode 100755
index 0bdfc02..0000000
--- a/data/sql/tables-mysql.sql
+++ /dev/null
@@ -1,47 +0,0 @@
-CREATE TABLE appletlist(
-  id              INTEGER          NOT NULL AUTO_INCREMENT,
-  ip              VARCHAR(15)      NOT NULL DEFAULT '0.0.0.0',
-  port            INTEGER          NOT NULL DEFAULT 0,
-  gamename        VARCHAR(50)      NOT NULL DEFAULT ' ',
-  added           timestamptz      NOT NULL DEFAULT NOW(),
-  updated         timestamptz      NOT NULL DEFAULT NOW(),
-  PRIMARY KEY (id)
-);
-
-CREATE TABLE serverlist(
-  id              INTEGER          NOT NULL AUTO_INCREMENT,
-  ip              VARCHAR(15)      NOT NULL DEFAULT '0.0.0.0',
-  port            INTEGER          NOT NULL DEFAULT 0,
-  gamename        VARCHAR(50)      NOT NULL DEFAULT ' ',
-  gamever         VARCHAR(50)      NOT NULL DEFAULT ' ',
-  hostname        VARCHAR(100)     NOT NULL DEFAULT ' ',
-  hostport        INTEGER          NOT NULL DEFAULT 0,
-  country         VARCHAR(5),
-  b333ms          BOOLEAN          NOT NULL DEFAULT 0,
-  blacklisted     BOOLEAN          NOT NULL DEFAULT 0,
-  added           TIMESTAMP        NOT NULL DEFAULT NOW(),
-  beacon          TIMESTAMP        NOT NULL DEFAULT NOW(),
-  updated         TIMESTAMP        NOT NULL DEFAULT NOW(),
-  PRIMARY KEY (id)
-);
-
-CREATE TABLE pending(
-  id              INTEGER          NOT NULL AUTO_INCREMENT,
-  ip              VARCHAR(15)      NOT NULL DEFAULT '0.0.0.0',
-  beaconport      INTEGER          NOT NULL DEFAULT 0,
-  heartbeat       INTEGER          NOT NULL DEFAULT 0,
-  gamename        VARCHAR(25)      NOT NULL DEFAULT ' ',  
-  secure          VARCHAR(12)      NOT NULL DEFAULT ' ',
-  enctype         INTEGER          NOT NULL DEFAULT 0,
-  added           TIMESTAMP        NOT NULL DEFAULT NOW(),
-  PRIMARY KEY (id)
-);
-
-CREATE TABLE games(
-  gamename        VARCHAR(50)        NOT NULL,
-  cipher          VARCHAR(10)        NOT NULL DEFAULT ' ',
-  description     VARCHAR(200)       NOT NULL DEFAULT ' ',
-  default_qport   INTEGER            NOT NULL DEFAULT 0,
-  num_uplink      INTEGER            NOT NULL DEFAULT 0,
-  num_total       INTEGER            NOT NULL DEFAULT 0
-);