| Server configuration check |
';
// Check access rights
echo '
| Checking access rights |
';
// directories
foreach (array("logs", "logs/ac", "logs/backup", "logs/utdc", "logs/ace") as $dir)
{
echo '
| ', $dir, ' | ';
if (!file_exists($dir)) {
if (mkdir($dir, 0777)) {
echo '
Created |
';
}
else {
echo '
Not found! | ';
}
}
else if (!is_dir($dir)) {
echo '
Not a directory! | ';
}
else if (!is_writable($dir)) {
if (@chmod($dir, 0777)) {
echo '
SET | ';
}
else {
echo '
Incorrect access rights: ' , substr(sprintf('%o', fileperms($dir)), -4) , ' | ';
}
}
else {
echo '
OK | ';
}
}
// files:
foreach (array("includes/ftptimestamp.php") as $file)
{
echo '
| ', $file, ' | ';
if (!file_exists($file)) {
echo '
Not found! |
';
}
else if (!is_file($file)) {
echo '
Not a file! | ';
}
else if (!is_writable($file)) {
if (@chmod($file, 0777)) {
echo '
SET | ';
}
else {
echo '
Incorrect access rights: ' , substr(sprintf('%o', fileperms($file)), -4) , ' | ';
}
}
else {
echo '
OK | ';
}
}
echo '
* Might not work correctly on Windows systems *
';
// connect to the database and check structure
echo '
| Checking mysql tables |
';
// database creation array
// to add a database simply add $create_table['dbname'] = "database creation sql"
$create_table['uts_events'] = "
CREATE TABLE `uts_events` (
`id` mediumint(10) NOT NULL auto_increment,
`matchid` mediumint(10) NOT NULL default '0',
`playerid` tinyint(3) NOT NULL default '0',
`col0` varchar(20) NOT NULL default '',
`col1` varchar(120) NOT NULL default '',
`col2` varchar(120) NOT NULL default '',
`col3` varchar(120) NOT NULL default '',
`col4` varchar(120) NOT NULL default '',
PRIMARY KEY (`id`)
);
";
$create_table['uts_games'] = "
CREATE TABLE `uts_games` (
`id` tinyint(3) unsigned NOT NULL auto_increment,
`gamename` varchar(100) NOT NULL default '',
`name` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 ;
";
$create_table['uts_gamestype'] = "
CREATE TABLE `uts_gamestype` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`serverip` varchar(21) NOT NULL default '',
`gamename` varchar(100) NOT NULL default '',
`mutator` varchar(100) NOT NULL default '',
`gid` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
";
$create_table['uts_ignoreips'] = "
CREATE TABLE IF NOT EXISTS `uts_ignoreips` (
`ip` bigint(15) NOT NULL default '0',
PRIMARY KEY (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
";
$create_table['uts_killsmatrix'] = "
CREATE TABLE `uts_killsmatrix` (
`matchid` mediumint(8) unsigned NOT NULL default '0',
`killer` tinyint(4) NOT NULL default '0',
`victim` tinyint(4) NOT NULL default '0',
`kills` tinyint(3) unsigned NOT NULL default '0',
KEY `matchid` (`matchid`)
) ENGINE=MyISAM;
";
$create_table['uts_match'] = "
CREATE TABLE `uts_match` (
`id` mediumint(10) NOT NULL auto_increment,
`time` varchar(14) default NULL,
`servername` varchar(100) NOT NULL default '',
`serverip` varchar(21) NOT NULL default '0',
`gamename` varchar(100) NOT NULL default '0',
`gid` tinyint(3) unsigned NOT NULL default '0',
`gametime` float NOT NULL default '0',
`mutators` longtext NOT NULL,
`insta` tinyint(1) NOT NULL default '0',
`tournament` varchar(5) NOT NULL default '',
`teamgame` varchar(5) NOT NULL default '',
`mapname` varchar(100) NOT NULL default '',
`mapfile` varchar(100) NOT NULL default '',
`serverinfo` mediumtext NOT NULL,
`gameinfo` mediumtext NOT NULL,
`firstblood` int(10) unsigned NOT NULL default '0',
`frags` mediumint(5) NOT NULL default '0',
`deaths` mediumint(5) NOT NULL default '0',
`kills` mediumint(5) NOT NULL default '0',
`suicides` mediumint(5) NOT NULL default '0',
`teamkills` mediumint(5) NOT NULL default '0',
`assaultid` varchar(10) NOT NULL default '',
`ass_att` tinyint(1) NOT NULL default '0',
`ass_win` tinyint(4) NOT NULL default '0',
`t0` tinyint(1) NOT NULL default '0',
`t1` tinyint(1) NOT NULL default '0',
`t2` tinyint(1) NOT NULL default '0',
`t3` tinyint(1) NOT NULL default '0',
`t0score` mediumint(5) NOT NULL default '0',
`t1score` mediumint(5) NOT NULL default '0',
`t2score` mediumint(5) NOT NULL default '0',
`t3score` mediumint(5) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `serverip` (`serverip`)
) ENGINE=MyISAM AUTO_INCREMENT=83 ;
";
$create_table['uts_pinfo'] = "
CREATE TABLE `uts_pinfo` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`country` char(2) NOT NULL default '',
`banned` enum('Y','N') NOT NULL default 'N',
PRIMARY KEY (`id`),
KEY `name` (`name`(22))
) ENGINE=MyISAM AUTO_INCREMENT=136 ;
";
$create_table['uts_player'] = "
CREATE TABLE `uts_player` (
`id` mediumint(10) NOT NULL auto_increment,
`matchid` mediumint(10) NOT NULL default '0',
`insta` tinyint(1) NOT NULL default '0',
`playerid` tinyint(3) NOT NULL default '0',
`pid` int(10) unsigned NOT NULL default '0',
`team` tinyint(2) unsigned NOT NULL default '0',
`isabot` tinyint(1) NOT NULL default '0',
`country` char(2) NOT NULL default '',
`ip` int(10) unsigned NOT NULL default '0',
`gid` tinyint(3) unsigned NOT NULL default '0',
`gametime` float NOT NULL default '0',
`gamescore` smallint(5) NOT NULL default '0',
`lowping` smallint(5) unsigned NOT NULL default '0',
`highping` smallint(5) unsigned NOT NULL default '0',
`avgping` smallint(5) unsigned NOT NULL default '0',
`frags` smallint(5) NOT NULL default '0',
`deaths` smallint(5) unsigned NOT NULL default '0',
`kills` smallint(5) unsigned NOT NULL default '0',
`suicides` smallint(5) unsigned NOT NULL default '0',
`teamkills` smallint(5) unsigned NOT NULL default '0',
`eff` float NOT NULL default '0',
`accuracy` float NOT NULL default '0',
`ttl` float NOT NULL default '0',
`flag_taken` smallint(5) unsigned NOT NULL default '0',
`flag_dropped` smallint(5) unsigned NOT NULL default '0',
`flag_return` smallint(5) unsigned NOT NULL default '0',
`flag_capture` tinyint(3) unsigned NOT NULL default '0',
`flag_cover` smallint(5) unsigned NOT NULL default '0',
`flag_seal` smallint(5) unsigned NOT NULL default '0',
`flag_assist` smallint(5) unsigned NOT NULL default '0',
`flag_kill` mediumint(5) unsigned NOT NULL default '0',
`flag_pickedup` smallint(5) unsigned NOT NULL default '0',
`dom_cp` smallint(5) unsigned NOT NULL default '0',
`ass_obj` smallint(5) unsigned NOT NULL default '0',
`spree_double` smallint(5) unsigned NOT NULL default '0',
`spree_triple` smallint(5) unsigned NOT NULL default '0',
`spree_multi` smallint(5) unsigned NOT NULL default '0',
`spree_mega` tinyint(3) unsigned NOT NULL default '0',
`spree_ultra` tinyint(3) unsigned NOT NULL default '0',
`spree_monster` tinyint(3) unsigned NOT NULL default '0',
`spree_kill` smallint(5) unsigned NOT NULL default '0',
`spree_rampage` smallint(5) unsigned NOT NULL default '0',
`spree_dom` tinyint(3) unsigned NOT NULL default '0',
`spree_uns` tinyint(3) unsigned NOT NULL default '0',
`spree_god` smallint(5) unsigned NOT NULL default '0',
`pu_pads` tinyint(3) unsigned NOT NULL default '0',
`pu_armour` tinyint(3) unsigned NOT NULL default '0',
`pu_keg` tinyint(3) unsigned NOT NULL default '0',
`pu_invis` tinyint(3) unsigned NOT NULL default '0',
`pu_belt` tinyint(3) unsigned NOT NULL default '0',
`pu_amp` tinyint(3) unsigned NOT NULL default '0',
`rank` float NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `matchid` (`matchid`,`team`),
KEY `pid` (`pid`),
KEY `gid` (`gid`)
) ENGINE=MyISAM AUTO_INCREMENT=615 ;
";
$create_table['uts_rank'] = "
CREATE TABLE `uts_rank` (
`id` mediumint(10) NOT NULL auto_increment,
`time` float unsigned NOT NULL default '0',
`pid` int(10) unsigned NOT NULL default '0',
`gid` tinyint(3) unsigned NOT NULL default '0',
`rank` float NOT NULL default '0',
`prevrank` float NOT NULL default '0',
`matches` mediumint(5) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `name` (`pid`,`gid`),
KEY `rank` (`rank`),
KEY `gamename` (`gid`,`rank`)
) ENGINE=MyISAM AUTO_INCREMENT=173 ;
";
$create_table['uts_weapons'] = "
CREATE TABLE `uts_weapons` (
`id` tinyint(3) unsigned NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`image` varchar(50) NOT NULL default '',
`sequence` tinyint(3) unsigned NOT NULL default '200',
`hide` enum('N','Y') NOT NULL default 'N',
PRIMARY KEY (`id`),
KEY `name` (`name`(20))
) ENGINE=MyISAM AUTO_INCREMENT=20 ;
";
$create_table['uts_weaponstats'] = "
CREATE TABLE `uts_weaponstats` (
`matchid` mediumint(8) unsigned NOT NULL default '0',
`pid` int(10) unsigned NOT NULL default '0',
`weapon` tinyint(3) unsigned NOT NULL default '0',
`kills` mediumint(8) unsigned NOT NULL default '0',
`shots` int(10) unsigned NOT NULL default '0',
`hits` int(10) unsigned NOT NULL default '0',
`damage` int(10) unsigned NOT NULL default '0',
`acc` float unsigned NOT NULL default '0',
KEY `full` (`matchid`,`pid`)
) ENGINE=MyISAM;
";
foreach ($create_table as $table => $query) {
echo '
| ', $table, ' | ';
if (small_count("SHOW TABLES LIKE '$table'") == 1) {
// database exists, check columns
echo '
OK |
';
}
else {
if (mysql_query($query)) {
echo '
Created | ';
}
else {
echo '
Not found! | ';
}
}
}
echo '
';
// Check the weapons
$create_weapon['Translocator'] = "INSERT INTO `uts_weapons` VALUES (1, 'Translocator', 'trans.jpg', 1, 'N');";
$create_weapon['Impact Hammer'] = "INSERT INTO `uts_weapons` VALUES (2, 'Impact Hammer', 'impact.jpg', 2, 'N');";
$create_weapon['Enforcer'] = "INSERT INTO `uts_weapons` VALUES (3, 'Enforcer', 'enforcer.jpg', 3, 'N');";
$create_weapon['Double Enforcer'] = "INSERT INTO `uts_weapons` VALUES (4, 'Double Enforcer', 'enforcer2.jpg', 4, 'N');";
$create_weapon['GES Bio Rifle'] = "INSERT INTO `uts_weapons` VALUES (5, 'GES Bio Rifle', 'bio.jpg', 5, 'N');";
$create_weapon['Ripper'] = "INSERT INTO `uts_weapons` VALUES (6, 'Ripper', 'ripper.jpg', 6, 'N');";
$create_weapon['Shock Rifle'] = "INSERT INTO `uts_weapons` VALUES (7, 'Shock Rifle', 'shock.jpg', 7, 'N');";
$create_weapon['Enhanced Shock Rifle'] = "INSERT INTO `uts_weapons` VALUES (8, 'Enhanced Shock Rifle', 'ishock.jpg', 8, 'N');";
$create_weapon['Pulse Gun'] = "INSERT INTO `uts_weapons` VALUES (9, 'Pulse Gun', 'pulse.jpg', 9, 'N');";
$create_weapon['Minigun'] = "INSERT INTO `uts_weapons` VALUES (10, 'Minigun', 'minigun.jpg', 10, 'N');";
$create_weapon['Flak Cannon'] = "INSERT INTO `uts_weapons` VALUES (11, 'Flak Cannon', 'flak.jpg', 11, 'N');";
$create_weapon['Rocket Launcher'] = "INSERT INTO `uts_weapons` VALUES (12, 'Rocket Launcher', 'rockets.jpg', 12, 'N');";
$create_weapon['Sniper Rifle'] = "INSERT INTO `uts_weapons` VALUES (13, 'Sniper Rifle', 'sniper.jpg', 13, 'N');";
$create_weapon['Redeemer'] = "INSERT INTO `uts_weapons` VALUES (14, 'Redeemer', 'deemer.jpg', 14, 'N');";
$create_weapon['None'] = "INSERT INTO `uts_weapons` VALUES (15, 'None', 'blank.jpg', 15, 'N');";
$create_weapon['Chainsaw'] = "INSERT INTO `uts_weapons` VALUES (16, 'Chainsaw', 'chainsaw.jpg', 16, 'N');";
echo '
| Checking supported weapons |
';
if (small_count("SHOW TABLES LIKE 'uts_weapons'") != 1) {
// database exists, check columns
echo '
Table uts_weapons does not exist! | ';
}
else {
foreach ($create_weapon as $weapon => $query) {
echo '
| ', $weapon, ' | ';
if (small_count("SELECT id FROM uts_weapons WHERE name = '$weapon' LIMIT 0,1") == 1) {
// database exists, check columns
echo '
OK |
';
}
else {
if (mysql_query($query)) {
echo '
Added | ';
}
else {
echo '
Not found! | ';
}
}
}
}
echo '
';
echo '
| Checking data |
';
echo '
| Fix BT cap times | ';
$q = mysql_query("UPDATE uts_events SET col3 = ROUND(CEILING((col3-1)*100/1.1) / 100, 2), col1 = 'btcap' WHERE col1 = 'cap'");
$affected = mysql_affected_rows();
if ($affected == -1) {
echo '
Failed |
';
}
else {
echo '
| Updated ' . $affected . ' rows. |