''); $serverips = array('0' => '*'); while ($r_server = mysql_fetch_array($q_server)) { $servernames[$r_server['id']] = $r_server['servername']; $serverips[$r_server['id']] = $r_server['serverip']; } $sql_games = "SELECT id, gamename, name FROM uts_games ORDER BY gamename ASC"; $q_games = mysql_query($sql_games) or die(mysql_error()); $gamedisplaynames = array('0' => ''); $gamenames = array('0' => '*'); while ($r_games = mysql_fetch_array($q_games)) { $gamenames[$r_games['id']] = $r_games['gamename']; $gamedisplaynames[$r_games['id']] = $r_games['name']; } if (isset($_REQUEST['submit'])) { mysql_query(" INSERT INTO uts_gamestype SET serverip = '". my_addslashes($_REQUEST['serverip']) ."', gamename = '". my_addslashes($_REQUEST['gamename']) ."', mutator = '". my_addslashes($_REQUEST['mutator']) ."', gid = '". my_addslashes($_REQUEST['gid']) ."' ") or die(mysql_error()); if (isset($_REQUEST['update'])) { echo'
'; $where = 'WHERE 1'; if ($_REQUEST['serverip'] != '*') { $where .= " AND m.serverip = '". my_addslashes($_REQUEST['serverip']) ."'"; } if ($_REQUEST['gamename'] != '*') { $gids = array_keys($gamenames, my_stripslashes($_REQUEST['gamename'])); $where .= " AND m.gid IN (".implode(',', $gids).")"; } if ($_REQUEST['mutator'] != '*') { $where .= " AND m.mutators LIKE '%".my_addslashes($_REQUEST['mutator'])."%'"; } mysql_query("UPDATE uts_player p, uts_match m SET p.gid = '". my_addslashes($_REQUEST['gid']) ."' $where AND m.id = p.matchid;") or die(mysql_error()); echo''; mysql_query("UPDATE uts_match m SET m.gid = '". my_addslashes($_REQUEST['gid']) ."' $where;") or die(mysql_error()); echo''; if ($_REQUEST['gamename'] != '*') { $gids[] = $_REQUEST['gid']; $where = "WHERE gid IN (".implode(',', $gids).")"; } else { $where = 'WHERE 1'; } mysql_query("DELETE FROM uts_rank $where;") or die(mysql_error()); $sql_nrank = "SELECT SUM(p.gametime) AS time, p.pid, p.gid, SUM(p.rank) AS rank, COUNT(p.matchid) AS matches FROM uts_player p, uts_pinfo pi $where AND pi.id = p.pid AND pi.banned <> 'Y' GROUP BY p.gid, p.pid"; $q_nrank = mysql_query($sql_nrank) or die(mysql_error()); $num_ranks = 0; while ($r_nrank = mysql_fetch_array($q_nrank)) { mysql_query("INSERT INTO uts_rank SET time = '${r_nrank['time']}', pid = ${r_nrank['pid']}, gid = ${r_nrank['gid']}, rank = '${r_nrank['rank']}', prevrank = '${r_nrank['rank']}', matches = ${r_nrank['matches']}") or die(mysql_error()); $num_ranks++; } echo'

Updating...
Updating Player Records	Done (updated '.mysql_affected_rows().' records)
Updating Matches	Done (updated '.mysql_affected_rows().' matches)
Re-Calcuating Rankings	Done (recalculated '.$num_ranks.' rankings)
Update finished..

'; } } if (isset($_REQUEST['del'])) { mysql_query(" DELETE FROM uts_gamestype WHERE id = '". my_addslashes($_REQUEST['del']) ."' ") or die(mysql_error()); } echo'
'; $sql_gamestype = "SELECT id, serverip, gamename, mutator, gid FROM uts_gamestype ORDER BY id ASC;"; $q_gamestype = mysql_query($sql_gamestype) or die(mysql_error()); $i = 0; while ($r_gamestype = mysql_fetch_array($q_gamestype)) { $i++; $class = ($i%2) ? 'grey' : 'grey2'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } echo '

Current Mappings
Server IP		Game Name		Mutatorlist contains		Game
'.htmlentities($r_gamestype['serverip']).'	+	'.htmlentities($r_gamestype['gamename']).'	+	'.htmlentities($r_gamestype['mutator']).'	=	'.htmlentities($gamedisplaynames[$r_gamestype['gid']]).'	'; echo ''; echo ''; echo ''; echo '

'; echo'
'; $class='grey'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo'

Add new gamestype
If server =	'; echo ''; foreach($serverips as $id => $bla) { echo ''. $serverips[$id]; if (!empty($servernames[$id])) echo ' ('. $servernames[$id] .')'; echo ''; } echo ''; echo '
and gamename =	'; echo ''; foreach($gamenames as $id => $bla) { if ($gamenames[$id] == '(user defined)') continue; echo ''. $gamenames[$id]; if (!empty($gamedisplaynames[$id])) echo ' ('. $gamedisplaynames[$id] .')'; echo ''; } echo ''; echo '
and mutatorlist contains	'; echo ' (case insensitive substring)'; echo '
==> assume gametype:	'; echo ''; foreach($gamenames as $id => $bla) { if ($gamenames[$id] == '*') continue; echo ''. $gamenames[$id]; if (!empty($gamedisplaynames[$id])) echo ' ['. $gamedisplaynames[$id] .']'; echo ''; } echo ''; echo '
Update existing matches:	'; echo ' (this cannot be undone easily!)'; echo '
Go Back To Admin Page

'; ?>