CREATE TABLE IF NOT EXISTS `admins` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
`date_created` datetime NOT NULL,
`last_updated` datetime NOT NULL,
`username` varchar(16) NOT NULL,
`password` varchar(64) NOT NULL,
`theme` varchar(64) NOT NULL DEFAULT 'default',
`language` varchar(64) NOT NULL DEFAULT 'english',
`email_address` varchar(255) NOT NULL,
`first_name` varchar(128) NOT NULL,
`last_name` varchar(128) NOT NULL,
PRIMARY KEY (`id`),
KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `configuration` (
`last_updated_by` int(10) unsigned NOT NULL,
`last_updated` datetime NOT NULL,
`config_setting` varchar(64) NOT NULL,
`config_value` varchar(255) NOT NULL,
KEY `config_setting` (`config_setting`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `default_games` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cloudid` int(10) unsigned NOT NULL,
`port` smallint(5) unsigned NOT NULL,
`maxplayers` smallint(4) unsigned NOT NULL,
`startup` tinyint(1) unsigned NOT NULL DEFAULT '1',
`steam` tinyint(1) unsigned NOT NULL DEFAULT '0',
`cfg_separator` varchar(1) NOT NULL,
`gameq_name` varchar(64) NOT NULL,
`name` varchar(64) NOT NULL,
`intname` varchar(12) NOT NULL,
`working_dir` varchar(64) NOT NULL,
`pid_file` varchar(64) NOT NULL,
`banned_chars` varchar(64) NOT NULL,
`cfg_ip` varchar(64) NOT NULL,
`cfg_port` varchar(64) NOT NULL,
`cfg_maxplayers` varchar(64) NOT NULL,
`cfg_map` varchar(64) NOT NULL,
`cfg_hostname` varchar(64) NOT NULL,
`cfg_rcon` varchar(64) NOT NULL,
`cfg_password` varchar(64) NOT NULL,
`map` varchar(255) NOT NULL,
`hostname` varchar(255) NOT NULL,
`config_file` varchar(255) NOT NULL,
`steam_name` varchar(255) NOT NULL,
`description` varchar(600) NOT NULL,
`install_mirrors` varchar(600) NOT NULL,
`install_cmd` varchar(600) NOT NULL,
`update_cmd` varchar(600) NOT NULL,
`simplecmd` varchar(600) NOT NULL,
PRIMARY KEY (`id`),
KEY `intname` (`intname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `network` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`parentid` int(10) unsigned NOT NULL,
`is_local` tinyint(1) unsigned NOT NULL DEFAULT '0',
`login_user` blob NOT NULL,
`login_pass` blob NOT NULL,
`login_port` blob NOT NULL,
`ip` varchar(20) NOT NULL,
`os` varchar(64) NOT NULL,
`location` varchar(128) NOT NULL,
`datacenter` varchar(128) NOT NULL,
`homedir` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `parentid` (`parentid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `default_startup` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`defid` int(10) unsigned NOT NULL,
`sort_order` smallint(5) unsigned NOT NULL,
`single` tinyint(1) unsigned NOT NULL,
`usr_edit` tinyint(1) unsigned NOT NULL DEFAULT '0',
`cmd_item` varchar(128) NOT NULL,
`cmd_value` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `defid` (`defid`),
KEY `cmd_item` (`cmd_item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `plugins` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`active` tinyint(1) unsigned NOT NULL DEFAULT '1',
`date_installed` datetime NOT NULL,
`description` text NOT NULL,
`intname` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `active` (`active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `resellers` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
`date_created` datetime NOT NULL,
`last_updated` datetime NOT NULL,
`language` varchar(64) NOT NULL DEFAULT 'english',
`username` varchar(16) NOT NULL,
`password` varchar(64) NOT NULL,
`email_address` varchar(255) NOT NULL,
`first_name` varchar(128) NOT NULL,
`last_name` varchar(128) NOT NULL,
PRIMARY KEY (`id`),
KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `servers` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL,
`netid` int(10) unsigned NOT NULL,
`defid` int(10) unsigned NOT NULL,
`port` smallint(5) unsigned NOT NULL,
`maxplayers` smallint(4) unsigned NOT NULL,
`startup` tinyint(1) unsigned NOT NULL DEFAULT '1',
`type` enum('game','voice') NOT NULL DEFAULT 'game',
`status` enum('none','installing','updating','failed','complete') NOT NULL DEFAULT 'none',
`date_created` datetime NOT NULL,
`last_updated` datetime NOT NULL,
`token` varchar(32) NOT NULL,
`map` varchar(255) NOT NULL,
`rcon` varchar(255) NOT NULL,
`hostname` varchar(255) NOT NULL,
`sv_password` varchar(255) NOT NULL,
`working_dir` varchar(255) NOT NULL,
`pid_file` varchar(255) NOT NULL,
`update_cmd` varchar(600) NOT NULL,
`simplecmd` varchar(600) NOT NULL,
`description` varchar(600) NOT NULL,
PRIMARY KEY (`id`),
KEY `type` (`type`),
KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `servers_startup` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`srvid` int(10) unsigned NOT NULL,
`sort_order` smallint(5) unsigned NOT NULL,
`single` tinyint(1) unsigned NOT NULL,
`usr_edit` tinyint(1) unsigned NOT NULL DEFAULT '0',
`cmd_item` varchar(128) NOT NULL,
`cmd_value` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `cmd_item` (`cmd_item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `templates` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`netid` int(10) unsigned NOT NULL,
`cfgid` int(10) unsigned NOT NULL,
`steam_percent` tinyint(3) unsigned NOT NULL,
`date_created` datetime NOT NULL,
`is_default` tinyint(1) unsigned NOT NULL DEFAULT '0',
`status` enum('none','running','steam_running','failed','tpl_running','complete') NOT NULL DEFAULT 'none',
`token` varchar(32) NOT NULL,
`description` varchar(255) NOT NULL,
`file_path` varchar(400) NOT NULL,
PRIMARY KEY (`id`),
KEY `is_default` (`is_default`),
KEY `cfgid` (`cfgid`),
KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
`active` tinyint(1) unsigned NOT NULL DEFAULT '1',
`perm_ftp` tinyint(1) unsigned NOT NULL DEFAULT '1',
`perm_files` tinyint(1) unsigned NOT NULL DEFAULT '1',
`perm_startup` tinyint(1) unsigned NOT NULL DEFAULT '1',
`perm_startup_see` tinyint(1) unsigned NOT NULL DEFAULT '1',
`perm_chpass` tinyint(1) unsigned NOT NULL DEFAULT '1',
`perm_updetails` tinyint(1) unsigned NOT NULL DEFAULT '1',
`date_created` datetime NOT NULL,
`last_updated` datetime NOT NULL,
`theme` varchar(64) NOT NULL DEFAULT 'default',
`language` varchar(64) NOT NULL DEFAULT 'english',
`username` varchar(16) NOT NULL,
`password` varchar(64) NOT NULL,
`email_address` varchar(255) NOT NULL,
`first_name` varchar(128) NOT NULL,
`last_name` varchar(128) NOT NULL,
PRIMARY KEY (`id`),
KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `default_games` (`id`, `cloudid`, `port`, `maxplayers`, `startup`, `steam`, `cfg_separator`, `gameq_name`, `name`, `intname`, `working_dir`, `pid_file`, `banned_chars`, `cfg_ip`, `cfg_port`, `cfg_maxplayers`, `cfg_map`, `cfg_hostname`, `cfg_rcon`, `cfg_password`, `map`, `hostname`, `config_file`, `steam_name`, `description`, `install_mirrors`, `install_cmd`, `update_cmd`, `simplecmd`) VALUES
(1, 2, 27015, 24, 1, 1, ' ', 'source', 'Counter-Strike: 1.6', 'cs_16', '', '', '+- ', 'ip', 'port', 'maxplayers', 'map', 'hostname', 'rcon_password', 'sv_password', 'de_dust2', 'New GamePanelX Server', 'cstrike/cfg/server.cfg', 'cstrike', 'The original Counter-Strike', '', '', './steam -command update -game cstrike -dir .', ''),
(2, 4, 3784, 8, 0, 0, '=', 'ventrilo', 'Ventrilo', 'vent', '', 'ventrilo_srv.pid', '', 'Intf', 'Port', 'MaxClients', '', 'Name', 'AdminPassword', 'Password', '', 'New GamePanelX Server', '', '', 'Voice Communication Server', '', '', '', './ventrilo_srv -d'),
(3, 3, 27015, 24, 1, 1, ' ', 'source', 'Counter-Strike: Condition Zero', 'cs_cz', 'czero', '', '+- ', 'ip', 'port', 'maxplayers', 'map', 'hostname', 'rcon_password', 'sv_password', 'de_dust2_cz', 'New GamePanelX Server', 'cstrike/cfg/server.cfg', 'czero', 'Update of CS:1.6 with bots and missions', '', '', './steam -command update -game czero -dir .', './hlds_run -game cstrike +ip %IP% +port %PORT% +map de_dust +maxplayers 16'),
(4, 1, 27015, 24, 1, 1, ' ', 'source', 'Counter-Strike: Source', 'cs_s', 'css', '', '+- ', 'ip', 'port', 'maxplayers', 'map', 'hostname', 'rcon_password', 'sv_password', 'de_dust2', 'New GamePanelX Server', 'cstrike/cfg/server.cfg', 'Counter-Strike Source', 'Source version of Counter-Strike', '', '', './steam -command update -game ''Counter-Strike Source'' -dir .', ''),
(5, 7, 27015, 24, 1, 2, ' ', 'source', 'Counter-Strike: GO', 'cs_go', 'csgo', '', '+- ', 'ip', 'port', 'maxplayers', 'map', 'hostname', 'rcon_password', 'sv_password', 'de_dust2', 'New GamePanelX Server', 'cfg/server.cfg', '740', 'test GOOOOO', '', '', 'export LD_LIBRARY_PATH=linux32/ && STEAMEXE=steamcmd ./steam.sh +runscript update.txt', ''),
(6, 8, 27015, 24, 1, 1, ' ', 'tf2', 'Team Fortress 2', 'tf2', 'orangebox', '', '+- ', 'ip', 'port', 'maxplayers', 'map', 'hostname', 'rcon_password', 'sv_password', 'cp_badlands', 'New GamePanelX Server', '', 'tf', '', '', '', './steam -command update -game tf -dir .', ''),
(7, 6, 25565, 24, 0, 0, '=', 'minecraft', 'Minecraft', 'mcraft', '', '', '', 'server-ip', 'server-port', 'max-players', 'level-name', 'motd', 'rcon.password', '', '', 'New GamePanelX Server', 'Server.Properties', '', 'CraftBukkit Minecraft Server', 'http://dl.bukkit.org/latest-rb/craftbukkit.jar', 'mv craftbukkit* craftbukkit.jar', '', 'java -Xincgc -Xmx1000M -jar craftbukkit.jar nogui'),
(8, 9, 7777, 50, 0, 0, ' ', 'samp', 'GTA: San Andreas MP', 'gta_samp', '', '', '', 'bind', 'port', 'maxplayers', 'mapname', 'hostname', 'rcon_password', 'password', '', 'New GamePanelX Server', 'server.cfg', '', '', 'http://files.sa-mp.com/samp03asvr_R4.tar.gz', 'tar -zxvf samp03asvr_R4.tar.gz\nrm -f samp03asvr_R4.tar.gz && mv samp03/* .\nrmdir samp03\nrand_pass=$(tr -dc "[:alpha:]" < /dev/urandom | head -c 8)\nsed -i s/rcon_password\\ changeme/rcon_password\\ \\$rand_pass/g server.cfg\nsed -i s/hostname\\ SA\\-MP\\ 0\\.3\\ Server/hostname\\ New\\ GamePanelX\\ Server/g server.cfg', '', './samp03svr'),
(9, 5, 16567, 32, 0, 0, ' ', 'bf2', 'Battlefield 2', 'bf2', '', '', '', 'sv.serverIP', 'sv.serverPort', 'sv.maxPlayers', '', 'sv.serverName', '', 'sv.password', '', '', '', '', 'Next iteration in the Battlefield series', '', '', '', './start.sh');
INSERT INTO `default_startup` (`id`, `defid`, `sort_order`, `single`, `usr_edit`, `cmd_item`, `cmd_value`) VALUES
('', 4, 0, 0, 0, './srcds_run', ''),
('', 4, 1, 0, 0, '-game', 'cstrike'),
('', 4, 2, 0, 0, '-ip', '%IP%'),
('', 4, 3, 0, 0, '-port', '%PORT%'),
('', 4, 4, 0, 0, '+maxplayers', '%MAXPLAYERS%'),
('', 4, 5, 0, 1, '+map', '%MAP%'),
('', 4, 6, 0, 0, '-tickrate', '66'),
('', 4, 7, 0, 1, '+mp_dynamicpricing', '0'),
('', 1, 0, 0, 0, './hlds_run', ''),
('', 1, 1, 0, 0, '-game', 'cstrike'),
('', 1, 2, 0, 0, '+ip', '%IP%'),
('', 1, 3, 0, 0, '+port', '%PORT%'),
('', 1, 4, 0, 0, '+maxplayers', '%MAXPLAYERS%'),
('', 1, 5, 0, 1, '+map', '%MAP%'),
('', 5, 0, 0, 0, './srcds_run', ''),
('', 5, 1, 0, 0, '-game', 'csgo'),
('', 5, 2, 0, 0, '-ip', '%IP%'),
('', 5, 3, 0, 0, '-port', '%PORT%'),
('', 5, 4, 0, 1, '+map', '%MAP%'),
('', 5, 6, 0, 0, '+mapgroup', 'mg_bomb'),
('', 5, 7, 0, 0, '-tickrate', '66'),
('', 5, 8, 0, 0, '+maxplayers', '%MAXPLAYERS%'),
('', 5, 9, 0, 0, '-maxplayers_override', '%MAXPLAYERS%'),
('', 5, 10, 0, 0, '+net_public_adr', '%IP%'),
('', 5, 11, 0, 0, '+game_type', '0'),
('', 5, 12, 0, 0, '+game_mode', '1'),
('', 5, 13, 0, 0, '+sv_steamgroup_exclusive', '1'),
('', 5, 14, 0, 0, '-console', ''),
('', 5, 15, 0, 0, '-usercon', ''),
('', 5, 5, 0, 0, '+sv_pure', '0'),
('', 6, 1, 1, 0, './srcds_run', ''),
('', 6, 2, 0, 0, '-game', 'tf'),
('', 6, 3, 0, 0, '-ip', '%IP%'),
('', 6, 4, 0, 0, '-port', '%PORT%'),
('', 6, 5, 0, 0, '+maxplayers', '%MAXPLAYERS%'),
('', 6, 6, 0, 0, '+map', '%MAP%'),
('', 3, 0, 0, 0, './hlds_run', ''),
('', 3, 0, 0, 0, '-game', 'czero'),
('', 3, 0, 0, 0, '+ip', '%IP%'),
('', 3, 0, 0, 0, '+port', '%PORT%'),
('', 3, 0, 0, 0, '+maxplayers', '%MAXPLAYERS%'),
('', 3, 0, 0, 1, '+map', '%MAP%');
Alles anzeigen