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

1 files changed, 0 insertions, 47 deletions

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
-);