PageRenderTime 455ms CodeModel.GetById 26ms RepoModel.GetById 0ms app.codeStats 0ms

/html/import.php

https://github.com/graywh/utstats
PHP | 824 lines | 750 code | 49 blank | 25 comment | 94 complexity | 5d0c013952aa86e8c6083234985e9f80 MD5 | raw file
    

  1. <?php

    2. 

  2. function add_info($name, $value) {

    3. 

  3. 	if ($value == '' or $value === NULL) return('');

    4. 

  4. 	return(htmlentities($name) ." ". htmlentities($value) ."<br />");

    5. 

  5. }

    6. 

  6. 

    7. 

  7. ?>

    8. 

  8. <?php

    9. 

  9. @ignore_user_abort(true);

    10. 

  10. @set_time_limit(0);

    11. 

  11. if (isset($_REQUEST['rememberkey'])) setcookie('uts_importkey', $_REQUEST['key'], time()+60*60*24*30*365);

    12. 

  12. if (isset($_COOKIE['uts_importkey'])) $adminkey = $_REQUEST['uts_importkey'];

    13. 

  13. require ("includes/config.php");

    14. 

  14. require ("includes/functions.php");

    15. 

  15. 

    16. 

  16. $compatible_actor_versions = array('0.4.0', '0.4.1', '0.4.2', 'beta 4.0', 'beta 4.1', 'beta 4.2');

    17. 

  17. 

    18. 

  18. 

    19. 

  19. // Get key from web browser

    20. 

  20. if (isset($_REQUEST['key'])) $adminkey = $_REQUEST['key'];

    21. 

  21. if (!isset($adminkey)) $adminkey = '';

    22. 

  22. 

    23. 

  23. // Debugging mode?

    24. 

  24. $debug = isset($_REQUEST['debug']) ? $_REQUEST['debug'] : false;

    25. 

  25. 

    26. 

  26. // Output HTML?

    27. 

  27. $html = isset($_REQUEST['html']) ? $_REQUEST['html'] : true;

    28. 

  28. 

    29. 

  29. // Were running from the command line (cron-jobs)

    30. 

  30. if (php_sapi_name() == 'cli' or !isset($_SERVER['SERVER_PORT']) or !$_SERVER['SERVER_PORT'])  {

    31. 

  31. 	// No password needed when in cli mode.

    32. 

  32. 	$adminkey = $import_adminkey;

    33. 

  33. 	// There is no time limit when running the cli. And no page to reload :)

    34. 

  34. 	$import_reload_after = 0;

    35. 

  35. 	// No browser, no HTML

    36. 

  36. 	$html = false;

    37. 

  37. 	// Chdir to our homedir

    38. 

  38. 	if (!empty($import_homedir)) chdir($import_homedir);

    39. 

  39. }

    40. 

  40. 

    41. 

  41. if ($html) include ("includes/header.php");

    42. 

  42. 

    43. 

  43. 

    44. 

  44. if ($html) {

    45. 

  45. 	echo'<table border="0" cellpadding="1" cellspacing="2" width="720">

    46. 

  46. 	<tr>

    47. 

  47. 		<td class="heading" align="center" colspan="2">Importing Latest Log Files</td>

    48. 

  48. 	</tr>';

    49. 

  49. }

    50. 

  50. 

    51. 

  51. 

    52. 

  52. IF (empty($import_adminkey)) {

    53. 

  53. 	if ($html) echo'<tr><td class="smheading" align="left" width="150">Error:</td><td class="grey" align="left">';

    54. 

  54. 	echo "\$import_adminkey not set in config.php!\n";

    55. 

  55. 	if ($html) {

    56. 

  56. 		echo '</td></tr></table>';

    57. 

  57. 		include("includes/footer.php");

    58. 

  58. 	}

    59. 

  59. 	return;

    60. 

  60. }

    61. 

  61. 

    62. 

  62. IF (!empty($adminkey) and $adminkey != $import_adminkey) {

    63. 

  63. 	if ($html) echo'<tr><td class="smheading" align="left" width="150">Error:</td><td class="grey" align="left">';

    64. 

  64. 	echo "Keys do not match\n";

    65. 

  65. 	$adminkey = '';

    66. 

  66. 	if (!$html) return;

    67. 

  67. }

    68. 

  68. 

    69. 

  69. IF (empty($adminkey)) {

    70. 

  70. 	if (!$html) die('Please provide the adminkey' ."\n");

    71. 

  71. 	echo'<tr>

    72. 

  72. 		  <td class="smheading" align="left" width="150">Enter Admin key:</td>

    73. 

  73. 		  <td class="grey" align="left"><form NAME="adminkey" ACTION="import.php">

    74. 

  74. 		  <input TYPE="text" NAME="key" MAXLENGTH="35" SIZE="20" CLASS="searchform">

    75. 

  75. 		  <input TYPE="submit" VALUE="Submit" CLASS="searchformb">

    76. 

  76. 		  <input TYPE="checkbox" NAME="rememberkey"> Remember the key

    77. 

  77. 		  </form></td>

    78. 

  78. 		</tr></table>';

    79. 

  79. 	include("includes/footer.php");

    80. 

  80. 	return;

    81. 

  81. }

    82. 

  82. 

    83. 

  83. 

    84. 

  84. IF (!@is_dir('logs')) {

    85. 

  85. 	if ($html) echo'<tr><td class="smheading" align="left" width="150">Error:</td><td class="grey" align="left">';

    86. 

  86. 	echo "Can't find the logs directory!\n";

    87. 

  87. 	if ($html) echo "<br>";

    88. 

  88. 	echo "Current working directory is: ". getcwd() ."\n";

    89. 

  89. 	if ($html) echo "<br>";

    90. 

  90. 	if (!$html) echo "You forgot to cd to my home directory? Take a look at \$import_homedir in config.php.\n";

    91. 

  91. 	if ($html) {

    92. 

  92. 		echo '</td></tr></table>';

    93. 

  93. 		include("includes/footer.php");

    94. 

  94. 	}

    95. 

  95. 	return;

    96. 

  96. }

    97. 

  97. 

    98. 

  98. 

    99. 

  99. 

    100. 

  100. if ($html) echo'</table><br>';

    101. 

  101. echo "\n";

    102. 

  102. 

    103. 

  103. $start_time = time();

    104. 

  104. $files = isset($_REQUEST['files']) ? $_REQUEST['files'] : 0;

    105. 

  105. $elapsed = isset($_REQUEST['elapsed']) ? $_REQUEST['elapsed'] : 0;

    106. 

  106. 

    107. 

  107. if ($ftp_use and !isset($_GET['no_ftp'])) {

    108. 

  108. 	include("includes/ftp.php");

    109. 

  109. 	$elapsed = $elapsed - (time() - $start_time);

    110. 

  110. }

    111. 

  111. 

    112. 

  112. 

    113. 

  113. $logdir = opendir('logs');

    114. 

  114. 

    115. 

  115. while (false !== ($filename = readdir($logdir)))

    116. 

  116. {

    117. 

  117. // Our (self set) timelimit exceeded => reload the page to prevent srcipt abort

    118. 

  118. 	if (!empty($import_reload_after) and $start_time + $import_reload_after <= time()) {

    119. 

  119. 		if (!$html) die('Time limit exceeded - unable to reload page (no HTML output)' ."\n");

    120. 

  120. 

    121. 

  121. 		$elapsed = $elapsed + time() - $start_time;

    122. 

  122. 		$target = $PHP_SELF ."?key=". urlencode($adminkey) ."&amp;".str_rand()."=".str_rand()."&amp;no_ftp=1&amp;debug=$debug&amp;files=$files&amp;elapsed=$elapsed";

    123. 

  123. 		echo '<meta http-equiv="refresh" content="2;URL='. $target .'">';

    124. 

  124. 

    125. 

  125. 		echo'<br /><table border="0" cellpadding="1" cellspacing="2" width="720">

    126. 

  126. 		  <tr>

    127. 

  127. 			<td class="heading" align="center" colspan="2">Maximum execution time exeeded; restarting ...</td>

    128. 

  128. 		  </tr>

    129. 

  129. 		  </table>';

    130. 

  130. 

    131. 

  131. 		include("includes/footer.php");

    132. 

  132. 		return;

    133. 

  133. 	}

    134. 

  134. 

    135. 

  135. 	$oldfilename = $filename;

    136. 

  136. 	$filename = 'logs/' . $filename;

    137. 

  137. 	$backupfilename = 'logs/backup/' . $oldfilename;

    138. 

  138. 

    139. 

  139. 	// UTDC log: Move to logs/utdc/

    140. 

  140. 	if		($import_utdc_download_enable

    141. 

  141. 		and substr($filename, strlen($filename) - strlen($import_utdc_log_extension)) == $import_utdc_log_extension

    142. 

  142. 		and substr($oldfilename, 0, strlen($import_utdc_log_start)) == $import_utdc_log_start) {

    143. 

  143. 			if ($import_utdc_log_compress == 'no') $import_utdc_log_compress = 'yes';

    144. 

  144. 			if ($html) {

    145. 

  145. 				echo'<table class="box" border="0" cellpadding="1" cellspacing="2">

    146. 

  146. 				<tr>

    147. 

  147. 					<td class="smheading" align="center" height="25" width="550" colspan="2">UTDC log: '.$oldfilename.'</td>

    148. 

  148. 				</tr>

    149. 

  149. 				<tr>

    150. 

  150. 					<td class="smheading" align="left" width="350">';

    151. 

  151. 			} else {

    152. 

  152. 				echo "UTDC log: $oldfilename:\n";

    153. 

  153. 			}

    154. 

  154. 			echo 'Moving to logs/utdc/: ';

    155. 

  155. 			if ($html) echo '</td><td class="grey" align="left" width="200">';

    156. 

  156. 			echo backup_logfile($import_utdc_log_compress, $filename, 'logs/utdc/'.$oldfilename, true) . "\n";

    157. 

  157. 			if ($html) echo '</td></tr></table><br />';

    158. 

  158. 			echo "\n\n";

    159. 

  159. 			unlink($filename);

    160. 

  160. 			continue;

    161. 

  161. 	}

    162. 

  162. 

    163. 

  163. 	// AnthChecker log: Move to logs/ac/

    164. 

  164. 	if		($import_ac_download_enable

    165. 

  165. 		and substr($filename, strlen($filename) - strlen($import_ac_log_extension)) == $import_ac_log_extension

    166. 

  166. 		and substr($oldfilename, 0, strlen($import_ac_log_start)) == $import_ac_log_start) {

    167. 

  167. 			if ($import_ac_log_compress == 'no') $import_ac_log_compress = 'yes';

    168. 

  168. 			if ($html) {

    169. 

  169. 				echo'<table class="box" border="0" cellpadding="1" cellspacing="2">

    170. 

  170. 				<tr>

    171. 

  171. 					<td class="smheading" align="center" height="25" width="550" colspan="2">AC log: '.$oldfilename.'</td>

    172. 

  172. 				</tr>

    173. 

  173. 				<tr>

    174. 

  174. 					<td class="smheading" align="left" width="350">';

    175. 

  175. 			} else {

    176. 

  176. 				echo "AC log: $oldfilename:\n";

    177. 

  177. 			}

    178. 

  178. 			echo 'Moving to logs/ac/: ';

    179. 

  179. 			if ($html) echo '</td><td class="grey" align="left" width="200">';

    180. 

  180. 			echo backup_logfile($import_ac_log_compress, $filename, 'logs/ac/'.$oldfilename, true) . "\n";

    181. 

  181. 			if ($html) echo '</td></tr></table><br />';

    182. 

  182. 			echo "\n\n";

    183. 

  183. 			unlink($filename);

    184. 

  184. 			continue;

    185. 

  185. 	}

    186. 

  186. 	

    187. 

  187. 	if(substr($filename, strlen($filename) - strlen($import_log_extension)) != $import_log_extension) 	continue;

    188. 

  188. 	if(substr($oldfilename, 0, strlen($import_log_start)) != $import_log_start) continue;

    189. 

  189. 

    190. 

  190. 	// Create a unique ID

    191. 

  191. 	$uid = str_rand();

    192. 

  192. 

    193. 

  193. 	// Check if there are any logs to do ...

    194. 

  194. 

    195. 

  195. 	// Create our temp Table

    196. 

  196. 

    197. 

  197. 	for (;;) {

    198. 

  198. 		$sql = "CREATE ". ($import_use_temporary_tables ? 'TEMPORARY ' : '') ."TABLE `uts_temp_$uid` (

    199. 

  199. 		`id` mediumint(5) NOT NULL,

    200. 

  200. 		`col0` char(20) NOT NULL default '',

    201. 

  201. 		`col1` char(120) NOT NULL default '',

    202. 

  202. 		`col2` char(120) NOT NULL default '',

    203. 

  203. 		`col3` char(120) NOT NULL default '',

    204. 

  204. 		`col4` char(120) NOT NULL default '',

    205. 

  205. 		KEY `part1` (`col1` (20),`col2` (20)),

    206. 

  206. 		KEY `part2` (`col0` (20),`col1` (20),`col2` (20)),

    207. 

  207. 		KEY `full` (`col0` (20),`col1` (20),`col2` (20),`col3` (20),`col4` (20))

    208. 

  208. 		) TYPE=". ($import_use_heap_tables ? 'HEAP' : 'MyISAM') .";";

    209. 

  209. 

    210. 

  210. 		$result = mysql_query($sql);

    211. 

  211. 		if ($result) break;

    212. 

  212. 

    213. 

  213. 		if (mysql_errno() == 1044 and $import_use_temporary_tables) {

    214. 

  214. 			echo "<br><strong>WARNING: Unable to create temporary table (". mysql_error() .")<br>";

    215. 

  215. 			echo "I'll retry without using MySQL's temporary table feature (see \$import_use_temporary_tables in config.php for details).<br><br></strong>";

    216. 

  216. 			$import_use_temporary_tables = false;

    217. 

  217. 			continue;

    218. 

  218. 		}

    219. 

  219. 		die("<br><strong>Unable to create the temporary table - are you allowed to create tables in this database?<br><br></strong>");

    220. 

  220. 	}

    221. 

  221. 	$id = 0;

    222. 

  222. 

    223. 

  223. 	if ($html) {

    224. 

  224. 		echo'<table class="box" border="0" cellpadding="1" cellspacing="2">

    225. 

  225. 		<tr>

    226. 

  226. 			<td class="smheading" align="center" height="25" width="550" colspan="2">Importing '.$oldfilename.'</td>

    227. 

  227. 		</tr>

    228. 

  228. 		<tr>

    229. 

  229. 			<td class="smheading" align="left" width="350">';

    230. 

  230. 	} else {

    231. 

  231. 		echo "Importing $oldfilename:\n";

    232. 

  232. 	}

    233. 

  233. 	echo 'Creating Temp MySQL Table: ';

    234. 

  234. 	if ($html) echo '</td><td class="grey" align="left" width="200">';

    235. 

  235. 	echo "uts_temp_$uid\n";

    236. 

  236. 	if ($html) echo '</td></tr><tr><td class="smheading" align="left" width="350">';

    237. 

  237. 	echo 'Backing Up Log File: ';

    238. 

  238. 	if ($html) echo '</td><td class="grey" align="left" width="200">';

    239. 

  239. 

    240. 

  240. 	// Copy the file to backup folder first

    241. 

  241. 	echo backup_logfile($import_log_backup, $filename, $backupfilename, true) . "\n";

    242. 

  242. 

    243. 

  243. 	if ($html) echo '</td><tr><td class="smheading" align="left" width="350">';

    244. 

  244. 	echo 'Player Data Moved to Temp MySQL: ';

    245. 

  245. 	if ($html) echo '</td>';

    246. 

  246. 

    247. 

  247. 	// Create sql for NGLog

    248. 

  248. 	$row = 1;

    249. 

  249. 	$handle = fopen("$filename", "r");

    250. 

  250. 

    251. 

  251. 	while (($data = my_fgets($handle, 5000)) !== FALSE) {

    252. 

  252. 		if ($debug) debug_output('Raw input         ', $data);

    253. 

  253. 		$data = preg_replace('/[\x00]/', '', $data);

    254. 

  254. 		if ($debug) debug_output('After preg_replace', $data);

    255. 

  255. 		$data = explode("\t", $data);

    256. 

  256. 

    257. 

  257. 		$num = count($data);

    258. 

  258. 		$row++;

    259. 

  259. 		for ($c=0; $c < 1; $c++) {

    260. 

  260. 

    261. 

  261. 			$col0 = addslashes($data[0]);

    262. 

  262. 			$col1 = addslashes($data[1]);

    263. 

  263. 			$col2 = addslashes($data[2]);

    264. 

  264. 			$col3 = addslashes($data[3]);

    265. 

  265. 			$col4 = addslashes($data[4]);

    266. 

  266. 

    267. 

  267. 			$col0 = trim($col0, " \n\r");

    268. 

  268. 			$col1 = trim($col1, " \n\r");

    269. 

  269. 			$col2 = trim($col2, " \n\r");

    270. 

  270. 			$col3 = trim($col3, " \n\r");

    271. 

  271. 			$col4 = trim($col4, " \n\r");

    272. 

  272. 

    273. 

  273. 			$id++;

    274. 

  274. 			mysql_query("INSERT INTO uts_temp_$uid VALUES ($id, '$col0', '$col1', '$col2', '$col3', '$col4');") or die(mysql_error());

    275. 

  275. 	   }

    276. 

  276. 	}

    277. 

  277. 	fclose($handle);

    278. 

  278. 	$files++;

    279. 

  279. 

    280. 

  280. 	if ($html) echo'<td class="grey" align="left" width="200">';

    281. 

  281. 	echo "Yes\n";

    282. 

  282. 

    283. 

  283. 

    284. 

  284. 

    285. 

  285. 	$log_incompatible = false;

    286. 

  286. 	$actor_version = 'unknown';

    287. 

  287. 	$qm_logtype = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'info' AND col2 = 'Log_Standard'");

    288. 

  288. 	if ($qm_logtype['col3'] == 'UTStats') {

    289. 

  289. 		$qm_logversion = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'info' AND col2 = 'Log_Version'");

    290. 

  290. 		$actor_version = $qm_logversion['col3'];

    291. 

  291. 	}

    292. 

  292. 

    293. 

  293. 	if (!in_array($actor_version, $compatible_actor_versions)) {

    294. 

  294. 		if ($import_incompatible_logs) {

    295. 

  295. 			if ($html) echo '</td></tr><tr><td class="smheading" align="left" width="350" style="background-color: red;">';

    296. 

  296. 			echo "WARNING: ";

    297. 

  297. 			if ($html) echo '</td><td class="grey" align="left" width="200" style="background-color: red;">';

    298. 

  298. 			echo "This logfile was created using an incompatible UTStats server actor version ($actor_version). You may experience strange results and/or bugs!\n";

    299. 

  299. 		} else {

    300. 

  300. 			$log_incompatible = true;

    301. 

  301. 		}

    302. 

  302. 	}

    303. 

  303. 

    304. 

  304. 

    305. 

  305. 	if ($html) echo '</td></tr><tr><td class="smheading" align="left" width="350">';

    306. 

  306. 	echo "Match Data Created: ";

    307. 

  307. 	if ($html) echo '</td><td class="grey" align="left" width="200">';

    308. 

  308. 

    309. 

  309. 	// Get the match table info

    310. 

  310. 	$qm_time = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'info' AND col2 = 'Absolute_Time'");

    311. 

  311. 	$qm_servername = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'info' AND col2 = 'Server_ServerName'");

    312. 

  312. 	$qm_serverip = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'info' AND col2 = 'True_Server_IP'");

    313. 

  313. 	$qm_serverport = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'info' AND col2 = 'Server_Port'");

    314. 

  314. 	$qm_gamename = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'game' AND col2 = 'GameName'");

    315. 

  315. 

    316. 

  316. 	#$qm_gamestart = small_query("SELECT col0 FROM uts_temp_$uid WHERE col1 = 'game' AND col2 = 'realstart'");

    317. 

  317. 	$qm_gamestart = small_query("SELECT col0 FROM uts_temp_$uid WHERE col1 = 'player' AND col2 = 'Rename'");

    318. 

  318. 	$qm_gameend = small_query("SELECT col0 FROM uts_temp_$uid WHERE col1 = 'game_end'");

    319. 

  319. 

    320. 

  320. 	$qm_insta = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'game' AND col2 = 'insta'");

    321. 

  321. 	$qm_tournament = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'game' AND col2 = 'TournamentMode'");

    322. 

  322. 	$qm_teamgame = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'game' AND col2 = 'TeamGame'");

    323. 

  323. 	$qm_mapname = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'map' AND col2 = 'Title'");

    324. 

  324. 	$qm_mapfile = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'map' AND col2 = 'Name'");

    325. 

  325. 	$qm_frags = small_query("SELECT SUM(col4) AS frags FROM uts_temp_$uid WHERE col1 = 'stat_player' AND col2 = 'frags'");

    326. 

  326. 	$qm_kills = small_query("SELECT SUM(col4) AS kills FROM uts_temp_$uid WHERE col1 = 'stat_player' AND col2 = 'kills'");

    327. 

  327. 	$qm_suicides = small_query("SELECT SUM(col4) AS suicides FROM uts_temp_$uid WHERE col1 = 'stat_player' AND col2 = 'suicides'");

    328. 

  328. 	$qm_deaths = small_query("SELECT SUM(col4) AS deaths FROM uts_temp_$uid WHERE col1 = 'stat_player' AND col2 = 'deaths'");

    329. 

  329. 	$qm_teamkills = small_query("SELECT SUM(col4) AS teamkills FROM uts_temp_$uid WHERE col1 = 'stat_player' AND col2 = 'teamkills'");

    330. 

  330. 	$qm_ass_obj = small_query("SELECT COUNT(col1) AS ass_obj FROM uts_temp_$uid WHERE col1 = 'assault_obj'");

    331. 

  331. 

    332. 

  332. 	$qm_playercount = small_count("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'player' AND col2 = 'rename' GROUP BY col3");

    333. 

  333. 

    334. 

  334. 	$s_frags = $qm_frags[frags];

    335. 

  335. 	$s_suicides = $qm_suicides[suicides];

    336. 

  336. 	$s_deaths = $qm_deaths[deaths];

    337. 

  337. 

    338. 

  338. 	// Add teamkills only if its a team game, else add them to kills total

    339. 

  339. 	IF ($qm_teamgame[col3] == "True") {

    340. 

  340. 		$s_kills = $qm_kills[kills];

    341. 

  341. 		$s_teamkills = $qm_teamkills[teamkills];

    342. 

  342. 	} else {

    343. 

  343. 		$s_kills = $qm_kills[kills]+$qm_teamkills[teamkills];

    344. 

  344. 		$s_teamkills = 0;

    345. 

  345. 	}

    346. 

  346. 	// Check if anything happened, if it didnt stop everything now

    347. 

  347. 	IF ($qm_kills[kills] == 0 && $qm_deaths[deaths] == 0 && $qm_ass_obj[ass_obj] == 0)  {

    348. 

  348. 		echo "No (Empty Match)\n";

    349. 

  349. 		if ($html) echo '</td></tr>';

    350. 

  350. 	} elseIF ($qm_playercount < 2)  {

    351. 

  351. 		echo "No (Not Enough Players)\n";

    352. 

  352. 		if ($html) echo '</td></tr>';

    353. 

  353. 	} elseIF ($log_incompatible)  {

    354. 

  354. 		echo "No (Logfile incompatible [created by UTStats $actor_version])\n";

    355. 

  355. 		if ($html) echo '</td></tr>';

    356. 

  356. 	} elseIF ($import_ignore_if_gametime_less_than != 0 and ceil(($qm_gameend[col0] - $qm_gamestart[col0]) / 60) < $import_ignore_if_gametime_less_than)  {

    357. 

  357. 		echo "No (game too short [". ceil(($qm_gameend[col0] - $qm_gamestart[col0]) / 60) ." &lt; $import_ignore_if_gametime_less_than minutes])\n";

    358. 

  358. 		if ($html) echo '</td></tr>';

    359. 

  359. 	} else {

    360. 

  360. 

    361. 

  361. 		$sql_mutators = "SELECT col3 FROM uts_temp_$uid WHERE col1 = 'game' AND col2 = 'GoodMutator'";

    362. 

  362. 		$q_mutators = mysql_query($sql_mutators);

    363. 

  363. 		while ($r_mutators = mysql_fetch_array($q_mutators)) {

    364. 

  364. 			$qm_mutators .= "".$r_mutators[col3].", ";

    365. 

  365. 		}

    366. 

  366. 

    367. 

  367. 

    368. 

  368. 		$qm_serveran = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'info' AND col2 = 'Server_AdminName'");

    369. 

  369. 		$qm_serverae = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'info' AND col2 = 'Server_AdminEmail'");

    370. 

  370. 		$qm_serverm1 = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'info' AND col2 = 'Server_MOTDLine1'");

    371. 

  371. 		$qm_serverm2 = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'info' AND col2 = 'Server_MOTDLine2'");

    372. 

  372. 		$qm_serverm3 = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'info' AND col2 = 'Server_MOTDLine3'");

    373. 

  373. 		$qm_serverm4 = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'info' AND col2 = 'Server_MOTDLine4'");

    374. 

  374. 

    375. 

  375. 		$qm_gameinfotl = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'game' AND col2 = 'TimeLimit'");

    376. 

  376. 		$qm_gameinfofl = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'game' AND col2 = 'FragLimit'");

    377. 

  377. 		$qm_gameinfogt = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'game' AND col2 = 'GoalTeamScore'");

    378. 

  378. 		$qm_gameinfomp = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'game' AND col2 = 'MaxPlayers'");

    379. 

  379. 		$qm_gameinfoms = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'game' AND col2 = 'MaxSpectators'");

    380. 

  380. 		$qm_gameinfogs = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'game' AND col2 = 'GameSpeed'");

    381. 

  381. 		$qm_gameinfout = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'game' AND col2 = 'UseTranslocator'");

    382. 

  382. 		$qm_gameinfoff = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'game' AND col2 = 'FriendlyFireScale'");

    383. 

  383. 		$qm_gameinfows = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'game' AND col2 = 'WeaponsStay'");

    384. 

  384. 

    385. 

  385. 		$gametime = $qm_time[col3];

    386. 

  386. 		$servername = addslashes($qm_servername[col3]);

    387. 

  387. 		$serverip = $qm_serverip[col3];

    388. 

  388. 		$serverport = $qm_serverport[col3];

    389. 

  389. 		$gamename = addslashes($qm_gamename[col3]);

    390. 

  390. 		$servergametime = get_dp($qm_gameend[col0] - $qm_gamestart[col0]);

    391. 

  391. 

    392. 

  392. 

    393. 

  393. 		$tournament = $qm_tournament[col3];

    394. 

  394. 		$teamgame = $qm_teamgame[col3];

    395. 

  395. 		$mapname = addslashes($qm_mapname[col3]);

    396. 

  396. 		$mapfile = addslashes($qm_mapfile[col3]);

    397. 

  397. 

    398. 

  398. 		// Lazy Hack for unknown gametypes

    399. 

  399. 		$unknowngt = substr("$mapfile", 0, 3);	// Gets first 3 characters

    400. 

  400. 

    401. 

  401. 		IF ($unknowngt == "JB-") {

    402. 

  402. 			$gamename = "JailBreak";

    403. 

  403. 			$teamgame = 'True';

    404. 

  404. 		}

    405. 

  405. 

    406. 

  406. 

    407. 

  407. 		// Append insta to game if it was an insta game

    408. 

  408. 		IF ($qm_insta[col3] == "True") { $gameinsta = 1; $gamename = "$gamename (insta)"; } else { $gameinsta = 0; }

    409. 

  409. 

    410. 

  410. 		// Get the unique ID of this gametype.

    411. 

  411. 		// Create a new one if it has none yet.

    412. 

  412. 		$r_gid = small_query("SELECT id FROM uts_games WHERE gamename = '$gamename'");

    413. 

  413. 		if ($r_gid) {

    414. 

  414. 			$gid = $r_gid['id'];

    415. 

  415. 		} else {

    416. 

  416. 			mysql_query("INSERT INTO uts_games SET gamename = '$gamename', name = '$gamename'") or die(mysql_error());

    417. 

  417. 			$gid = mysql_insert_id();

    418. 

  418. 		}

    419. 

  419. 

    420. 

  420. 

    421. 

  421. 		// Check wheter we want to override the gametype for this match

    422. 

  422. 		// (Useful if we want a server to have separate stats for one server or if we want to

    423. 

  423. 		// combine DM and TDM rankings or ...)

    424. 

  424. 

    425. 

  425. 		// Read all rules

    426. 

  426. 		if (!isset($overriderules)) {

    427. 

  427. 			$overriderules = array();

    428. 

  428. 			$sql_overriderules = "SELECT id, serverip, gamename, mutator, gid FROM uts_gamestype ORDER BY id ASC;";

    429. 

  429. 			$q_overriderules = mysql_query($sql_overriderules);

    430. 

  430. 			while ($r_overriderules = mysql_fetch_array($q_overriderules)) {

    431. 

  431. 				$overriderules[$r_overriderules['id']]['serverip'] = $r_overriderules['serverip'];

    432. 

  432. 				$overriderules[$r_overriderules['id']]['gamename'] = $r_overriderules['gamename'];

    433. 

  433. 				$overriderules[$r_overriderules['id']]['mutator'] = $r_overriderules['mutator'];

    434. 

  434. 				$overriderules[$r_overriderules['id']]['gid'] = $r_overriderules['gid'];

    435. 

  435. 			}

    436. 

  436. 		}

    437. 

  437. 

    438. 

  438. 		// Check if one of our overriderules applies to this match

    439. 

  439. 		foreach($overriderules as $rule) {

    440. 

  440. 			if ($rule['serverip'] != '*' and $rule['serverip'] != "$serverip:$serverport") continue;

    441. 

  441. 			if ($rule['gamename'] != '*' and $rule['gamename'] != $gamename) continue;

    442. 

  442. 			if ($rule['mutator'] != '*' and stristr($qm_mutators, $rule['mutator']) === false) continue;

    443. 

  443. 			$gid = $rule['gid'];

    444. 

  444. 			break;

    445. 

  445. 		}

    446. 

  446. 

    447. 

  447. 

    448. 

  448. 		$qm_firstblood = small_query("SELECT col2 FROM uts_temp_$uid WHERE col1 = 'first_blood'");

    449. 

  449. 

    450. 

  450. 		$firstblood = addslashes($qm_firstblood[col2]);

    451. 

  451. 

    452. 

  452. 

    453. 

  453. 		$serverinfo = addslashes("Admin: $qm_serveran[col3]<br />Email: $qm_serverae[col3] <br /><br />

    454. 

  454. 		<u>MOTD</u><br />$qm_serverm1[col3]<br />$qm_serverm2[col3]<br />$qm_serverm3[col3]<br />$qm_serverm4[col3]");

    455. 

  455. 

    456. 

  456. 

    457. 

  457. 		$gameinfo = addslashes(	add_info('Time Limit:', $qm_gameinfotl[col3]) .

    458. 

  458. 										add_info('Frag Limit:', $qm_gameinfofl[col3]) .

    459. 

  459. 										add_info('Goal Team Score:', $qm_gameinfogt[col3]) .

    460. 

  460. 										add_info('Max Players:', $qm_gameinfomp[col3]) .

    461. 

  461. 										add_info('Max Specs:', $qm_gameinfoms[col3]) .

    462. 

  462. 										add_info('Game Speed:', $qm_gameinfogs[col3]) .

    463. 

  463. 										add_info('Translocator:', $qm_gameinfout[col3]) .

    464. 

  464. 										add_info('Friendly Fire:', $qm_gameinfoff[col3]) .

    465. 

  465. 										add_info('Weapon Stay:', $qm_gameinfows[col3]) .

    466. 

  466. 										add_info('UTStats Actor Version:', $actor_version));

    467. 

  467. 

    468. 

  468. 		// Tidy Up The Info

    469. 

  469. 

    470. 

  470. 		$mutators = substr("$qm_mutators", 0, -2);		// remove trailing ,

    471. 

  471. 		$mutators = un_ut($mutators);				// Remove Class and BotPack. etc

    472. 

  472. 		$mutators = addslashes($mutators);

    473. 

  473. 

    474. 

  474. 		$gametime = utdate($gametime);

    475. 

  475. 

    476. 

  476. 

    477. 

  477. 		// Get Teams Info

    478. 

  478. 		$sql_tinfo = "SELECT col4 FROM uts_temp_$uid WHERE col1 = 'player' AND col2 = 'TeamName'  GROUP BY col4 ORDER BY col4 ASC";

    479. 

  479. 		$q_tinfo = mysql_query($sql_tinfo) or die(mysql_error());

    480. 

  480. 

    481. 

  481. 		$t0info = 0;

    482. 

  482. 		$t1info = 0;

    483. 

  483. 		$t2info = 0;

    484. 

  484. 		$t3info = 0;

    485. 

  485. 

    486. 

  486. 		while ($r_tinfo = mysql_fetch_array($q_tinfo)) {

    487. 

  487. 		      IF ($r_tinfo[col4] == "Red") { $t0info = 1; }

    488. 

  488. 		      IF ($r_tinfo[col4] == "Blue") { $t1info = 1; }

    489. 

  489. 		      IF ($r_tinfo[col4] == "Green") { $t2info = 1; }

    490. 

  490. 		      IF ($r_tinfo[col4] == "Gold") { $t3info = 1; }

    491. 

  491. 		}

    492. 

  492. 

    493. 

  493. 		// Get Teamscores

    494. 

  494. 		$sql_tscore = "SELECT col2 AS team, col3 AS score FROM uts_temp_$uid WHERE col1 = 'teamscore'";

    495. 

  495. 		$q_tscore = mysql_query($sql_tscore) or die(mysql_error());

    496. 

  496. 

    497. 

  497. 		$t0score = 0;

    498. 

  498. 		$t1score = 0;

    499. 

  499. 		$t2score = 0;

    500. 

  500. 		$t3score = 0;

    501. 

  501. 

    502. 

  502. 		while ($r_tscore = mysql_fetch_array($q_tscore)) {

    503. 

  503. 			if ($r_tscore['team'] == "0") $t0score = $r_tscore['score'];

    504. 

  504. 			if ($r_tscore['team'] == "1") $t1score = $r_tscore['score'];

    505. 

  505. 			if ($r_tscore['team'] == "2") $t2score = $r_tscore['score'];

    506. 

  506. 			if ($r_tscore['team'] == "3") $t3score = $r_tscore['score'];

    507. 

  507. 		}

    508. 

  508. 

    509. 

  509. 

    510. 

  510. // Insert Server Info Into Database

    511. 

  511. $sql_serverinfo = "INSERT INTO uts_match (id, time, servername, serverip, gamename, gid, gametime, mutators, insta, tournament, teamgame, mapname, mapfile, serverinfo, gameinfo, frags, kills, suicides, teamkills, deaths,

    512. 

  512. t0, t1, t2, t3, t0score, t1score, t2score, t3score)

    513. 

  513. VALUES ('0', '$gametime', '$servername', '$serverip:$serverport', '$gamename', '$gid', '$servergametime', '$mutators', '$gameinsta', '$tournament',

    514. 

  514. '$teamgame', '$mapname', '$mapfile', '$serverinfo', '$gameinfo', '$s_frags', '$s_kills', '$s_suicides', '$s_teamkills', '$s_deaths',

    515. 

  515. $t0info, $t1info, $t2info, $t3info, $t0score, $t1score, $t2score, $t3score);";

    516. 

  516. 

    517. 

  517. 		$q_serverinfo = mysql_query($sql_serverinfo) or die(mysql_error());

    518. 

  518. 		$matchid = mysql_insert_id();			// Get our Match ID

    519. 

  519. 

    520. 

  520. 

    521. 

  521. 

    522. 

  522. 		echo "Yes (ID: $matchid)\n";

    523. 

  523. 		if ($html) echo '</td></tr>';

    524. 

  524. 

    525. 

  525. 		// Process Player Stuff

    526. 

  526. 		$playerid2pid = array();

    527. 

  527. 		$ignored_players = array();

    528. 

  528. 		$imported_players = array();

    529. 

  529. 

    530. 

  530. 		if ($html) echo '<tr><td class="smheading" align="left" width="350">';

    531. 

  531. 		echo "Importing Players: ";

    532. 

  532. 		if ($html) echo '</td><td class="grey" align="left" width="200">';

    533. 

  533. 

    534. 

  534. 		// Get List of Player IDs and Process What They Have Done

    535. 

  535. 		$sql_player = "SELECT DISTINCT col4 FROM uts_temp_$uid WHERE col1 = 'player' AND col2 = 'rename' AND col4 <> ''";

    536. 

  536. 		$q_player = mysql_query($sql_player) or die(mysql_error());

    537. 

  537. 		while ($r_player = mysql_fetch_array($q_player)) {

    538. 

  538. 			$playerid = $r_player[col4];

    539. 

  539. 

    540. 

  540. 			// Get players last name used

    541. 

  541. 			$r_player2 = small_query("SELECT col3 FROM uts_temp_$uid WHERE col1 = 'player' AND col2 = 'rename' AND col4 = $playerid ORDER BY id DESC LIMIT 0,1");

    542. 

  542. 			$playername = addslashes($r_player2[col3]);

    543. 

  543. 

    544. 

  544. 

    545. 

  545. 			// Are they a Bot

    546. 

  546. 			$r_player1 = small_query("SELECT col4 FROM uts_temp_$uid WHERE col1 = 'player' AND col2 = 'IsABot' AND col3 = $playerid ORDER BY id DESC LIMIT 0,1");

    547. 

  547. 			$isabot = $r_player1[col4];

    548. 

  548. 			// This player is a bot

    549. 

  549. 			if ($isabot == 'True' and $import_ignore_bots) {

    550. 

  550. 				$ignored_players[] = $playername;

    551. 

  551. 				// We do not want to know who killed and who was killed by this bot...

    552. 

  552. 				mysql_query("DELETE FROM uts_temp_$uid WHERE (col1 = 'kill' OR col1 = 'teamkill') AND (col2 = '$playerid' OR col4 = '$playerid');") or die(mysql_error());

    553. 

  553. 				if ($html) echo "<span style='text-decoration: line-through;'>";

    554. 

  554. 				echo "Bot:$playername ";

    555. 

  555. 				if ($html) echo "</span>";

    556. 

  556. 				continue;

    557. 

  557. 			}

    558. 

  558. 

    559. 

  559. 			// Get players last team

    560. 

  560. 			$r_player3 = small_query("SELECT col4 FROM uts_temp_$uid WHERE col1 = 'player' AND col2 = 'TeamChange' AND col3 = $playerid ORDER BY id DESC LIMIT 0,1");

    561. 

  561. 			$playerteam = $r_player3[col4];

    562. 

  562. 

    563. 

  563. 			//$qc_kills = small_query("SELECT col4 FROM uts_temp_$uid WHERE col1 = 'stat_player' AND col2 = 'kills'AND col3 = $playerid");

    564. 

  564. 			//$qc_teamkills = small_query("SELECT col4 FROM uts_temp_$uid WHERE col1 = 'stat_player' AND col2 = 'teamkills' AND col3 = $playerid");

    565. 

  565. 			//$qc_deaths = small_query("SELECT col4 FROM uts_temp_$uid WHERE col1 = 'stat_player' AND col2 = 'deaths' AND col3 = $playerid");

    566. 

  566. 			//$qc_suicides = small_query("SELECT col4 FROM uts_temp_$uid WHERE col1 = 'stat_player' AND col2 = 'suicides' AND col3 = $playerid");

    567. 

  567. 			//$qc_score = small_query("SELECT col4 FROM uts_temp_$uid WHERE col1 = 'stat_player' AND col2 = 'deaths' AND col3 = $playerid");

    568. 

  568. 

    569. 

  569. 			// Player had no events => ignore

    570. 

  570. 			//IF (($qc_kills[col4] + $qc_deaths[col4] + $qc_teamkills[col4] + $qc_suicides[col4]) == 0 && $qc_score[col4] == 0) {

    571. 

  571. 			//	$ignored_players[] = $playername;

    572. 

  572. 			//	continue;

    573. 

  573. 			//}

    574. 

  574. 			

    575. 

  575. 			// Player was a spectator

    576. 

  576. 			$qc_spectate = small_query("SELECT count(col1) as cnt FROM uts_temp_$uid WHERE col1 = 'player' AND col2 = 'Connect' AND col4 = $playerid");

    577. 

  577. 			IF ($qc_spectate[cnt] == 0) {

    578. 

  578. 				$ignored_players[] = $playername;

    579. 

  579. 				continue;

    580. 

  580. 			}

    581. 

  581. 

    582. 

  582. 			// Process all the other player information

    583. 

  583. 			include("import/import_playerstuff.php");

    584. 

  584. 

    585. 

  585. 			if ($playerbanned) {

    586. 

  586. 				// Banned players don't have a rank.

    587. 

  587. 				mysql_query("DELETE FROM uts_rank WHERE pid = $pid");

    588. 

  588. 

    589. 

  589. 				if ($import_ban_type == 2) {

    590. 

  590. 					// We do not want to know who killed and who was killed by this banned player

    591. 

  591. 					$ignored_players[] = $playername;

    592. 

  592. 					mysql_query("DELETE FROM uts_temp_$uid WHERE (col1 = 'kill' OR col1 = 'teamkill') AND (col2 = $playerid OR col4 = $playerid);") or die(mysql_error());

    593. 

  593. 					if ($html) echo "<span style='text-decoration: line-through;'>";

    594. 

  594. 					echo "Banned:$playername ";

    595. 

  595. 					if ($html) echo "</span>";

    596. 

  596. 					continue;

    597. 

  597. 				}

    598. 

  598. 			}

    599. 

  599. 

    600. 

  600. 			// Get Gametype specific stuff done

    601. 

  601. 			IF ($gamename == "Assault" || $gamename == "Assault (insta)") { include("import/import_ass.php"); }

    602. 

  602. 			IF ($gamename == "Capture the Flag" || $gamename == "Capture the Flag (insta)") { include("import/import_ctf.php"); }

    603. 

  603. 			IF ($gamename == "Domination" || $gamename == "Domination (insta)") { include("import/import_dom.php"); }

    604. 

  604. 			IF ($gamename == "Tournament Team Game" || $gamename == "Tournament Team Game (insta)") { include("import/import_tdm.php"); }

    605. 

  605. 			IF ($gamename == "JailBreak" || $gamename == "JailBreak (insta)") { include("import/import_jailbreak.php"); }

    606. 

  606. 			IF ($gamename == "Last Man Standing" || $gamename == "Last Man Standing (insta)") { include("import/import_lms.php"); }

    607. 

  607. 

    608. 

  608. 			// Do the rankings

    609. 

  609. 			include("import/import_ranking.php");

    610. 

  610. 

    611. 

  611. 			if ($playerbanned) {

    612. 

  612. 					if ($html) echo "<span style='font-style: italic;'>";

    613. 

  613. 					echo "Banned:";

    614. 

  614. 			}

    615. 

  615. 			echo $playername.' ';

    616. 

  616. 			if ($playerbanned and $html) echo "</span>";

    617. 

  617. 			$imported_players[] = $playername;

    618. 

  618. 		}

    619. 

  619. 		if ($html) echo '</td></tr>';

    620. 

  620. 		// Check if theres any players left, if none or one delete the match (its possible ...)

    621. 

  621. 		$final_pcount = small_count("SELECT id FROM uts_player WHERE matchid = $matchid");

    622. 

  622. 

    623. 

  623. 		IF ($final_pcount == NULL || $final_pcount == 1) {

    624. 

  624. 			echo'<tr>

    625. 

  625. 				<td class="smheading" align="left" width="350">Deleting Match:</td>

    626. 

  626. 				<td class="grey" align="left" width="200">0 or 1 Player Entries Left</td>

    627. 

  627. 			</tr>';

    628. 

  628. 

    629. 

  629. 			$sql_radjust = "SELECT pid, gid, rank FROM uts_player WHERE matchid = $matchid";

    630. 

  630. 			$q_radjust = mysql_query($sql_radjust) or die(mysql_error());

    631. 

  631. 			while ($r_radjust = mysql_fetch_array($q_radjust)) {

    632. 

  632. 				$pid = $r_radjust[pid];

    633. 

  633. 				$gid = $r_radjust[gid];

    634. 

  634. 				$rank = $r_radjust[rank];

    635. 

  635. 

    636. 

  636. 				$sql_crank = small_query("SELECT id, rank, matches FROM uts_rank WHERE pid = $pid AND gid = $gid");

    637. 

  637. 				if (!$sql_crank) continue;

    638. 

  638. 

    639. 

  639. 				$rid = $sql_crank[id];

    640. 

  640. 				$newrank = $sql_crank[rank]-$rank;

    641. 

  641. 				$oldrank = $sql_crank[rank];

    642. 

  642. 				$matchcount = $sql_crank[matches]-1;

    643. 

  643. 

    644. 

  644. 				mysql_query("UPDATE uts_rank SET rank = $newrank, prevrank = $oldrank, matches = $matchcount WHERE id = $rid") or die(mysql_error());

    645. 

  645. 			}

    646. 

  646. 			mysql_query("DELETE FROM uts_rank WHERE matches = 0") or die(mysql_error());

    647. 

  647. 

    648. 

  648. 			$rem_mrecord = "DELETE FROM uts_match WHERE id = $matchid";

    649. 

  649. 			mysql_query($rem_mrecord);

    650. 

  650. 			$rem_precord = "DELETE FROM uts_player WHERE matchid = $matchid";

    651. 

  651. 			mysql_query($rem_precord);

    652. 

  652. 		} else {

    653. 

  653. 			// Make our weapons statistics

    654. 

  654. 			echo "\n";

    655. 

  655. 			if ($html) echo '<tr><td class="smheading" align="left" width="350">';

    656. 

  656. 			echo "Importing weapon statistics: ";

    657. 

  657. 			if ($html) echo '</td><td class="grey" align="left" width="200">';

    658. 

  658. 			include("import/import_weapons.php");

    659. 

  659. 			echo "Done\n";

    660. 

  660. 			if ($html) echo '</td></tr>';

    661. 

  661. 

    662. 

  662. 			// Make our kills matrix stuff ...

    663. 

  663. 			if ($html) echo '<tr><td class="smheading" align="left" width="350">';

    664. 

  664. 			echo "Building kills matrix: ";

    665. 

  665. 			if ($html) echo '</td><td class="grey" align="left" width="200">';

    666. 

  666. 			include("import/import_killsmatrix.php");

    667. 

  667. 			echo "Done\n";

    668. 

  668. 

    669. 

  669. 

    670. 

  670. 			if ($html) echo '</td></tr><tr><td class="smheading" align="left" width="350">';

    671. 

  671. 			echo "Combining Duplicate Player Entries: ";

    672. 

  672. 			if ($html) echo '</td><td class="grey" align="left" width="200">';

    673. 

  673. 

    674. 

  674. 			// Combine duplicate player entries ... very intensive :(

    675. 

  675. 			include("import/import_pcleanup.php");

    676. 

  676. 

    677. 

  677. 			echo "Done\n";

    678. 

  678. 			if ($html) echo'</td></tr>';

    679. 

  679. 

    680. 

  680. 

    681. 

  681. 			$updategameinfo = false;

    682. 

  682. 			if (count($ignored_players) > 0) {

    683. 

  683. 				// Maybe we imported the player and ignored another record of him?

    684. 

  684. 				$ignored_players = array_unique($ignored_players);

    685. 

  685. 				foreach($ignored_players as $t_id => $t_name) {

    686. 

  686. 					if (in_array($t_name, $imported_players)) unset($ignored_players[$t_id]);

    687. 

  687. 				}

    688. 

  688. 				if (count($ignored_players) > 0) {

    689. 

  689. 					$gameinfo .= addslashes(add_info('Ignored Players:', implode(', ', $ignored_players)));

    690. 

  690. 					$updategameinfo = true;

    691. 

  691. 				}

    692. 

  692. 			}

    693. 

  693. 			if ($updategameinfo) {

    694. 

  694. 				mysql_query("UPDATE uts_match SET gameinfo = '$gameinfo' WHERE id = '$matchid'");

    695. 

  695. 				$updategameinfo = false;

    696. 

  696. 			}

    697. 

  697. 		}

    698. 

  698. 	}

    699. 

  699. 

    700. 

  700. 	// Delete Temp MySQL Table

    701. 

  701. 	$droptable = "DROP TABLE uts_temp_$uid";

    702. 

  702. 	mysql_query($droptable) or die(mysql_error());

    703. 

  703. 

    704. 

  704. 	if ($html) echo'<tr><td class="smheading" align="left" width="350">';

    705. 

  705. 	echo "Deleting Temp MySQL Table: ";

    706. 

  706. 	if ($html) echo '</td><td class="grey" align="left" width="200">';

    707. 

  707. 	echo "uts_temp_$uid\n";

    708. 

  708. 	if ($html) echo '</td></tr></table><br />';

    709. 

  709. 	echo "\n\n";

    710. 

  710. 

    711. 

  711.   // Clear variables

    712. 

  712. 

    713. 

  713. 	$asscode = "";

    714. 

  714. 	$assteam = "";

    715. 

  715. 	$asswin = "";

    716. 

  716. 	$avgping = "";

    717. 

  717. 	$data = "";

    718. 

  718. 	$domplayer = "";

    719. 

  719. 	$droptable = "";

    720. 

  720. 	$firstblood = "";

    721. 

  721. 	$gameinfo = "";

    722. 

  722. 	$gameinsta = "";

    723. 

  723. 	$gamename = "";

    724. 

  724. 	$gametime = "";

    725. 

  725. 	$highping = "";

    726. 

  726. 	$unknowngt = "";

    727. 

  727. 	$lowping = "";

    728. 

  728. 	$mapname = "";

    729. 

  729. 	$mapfile = "";

    730. 

  730. 	$matchid = "";

    731. 

  731. 	$mutators = "";

    732. 

  732. 	$num = "";

    733. 

  733. 	$playerid = "";

    734. 

  734. 	$playerfragscnt = "";

    735. 

  735. 	$playername = "";

    736. 

  736. 	$playerecordid = "";

    737. 

  737. 	$playerteam = "";

    738. 

  738. 	$qm_mutators = "";

    739. 

  739. 	$row = 1;

    740. 

  740. 	$servername = "";

    741. 

  741. 	$serverinfo = "";

    742. 

  742. 	$serverip = "";

    743. 

  743. 	$serverport = "";

    744. 

  744. 	$suicidecnt = "";

    745. 

  745. 	$t0info = "";

    746. 

  746. 	$t1info = "";

    747. 

  747. 	$t2info = "";

    748. 

  748. 	$t3info = "";

    749. 

  749. 	$t0score = "";

    750. 

  750. 	$t1score = "";

    751. 

  751. 	$t2score = "";

    752. 

  752. 	$t3score = "";

    753. 

  753. 	$teamgame = "";

    754. 

  754. 	$tournament = "";

    755. 

  755. 

    756. 

  756. // Delete log file

    757. 

  757. 	unlink($filename);

    758. 

  758. }

    759. 

  759. closedir($logdir);

    760. 

  760. 

    761. 

  761. if ($html) echo '<br />';

    762. 

  762. echo "\n";

    763. 

  763. 

    764. 

  764. // Import stats

    765. 

  765. if ($files != 0) {

    766. 

  766. 	$elapsed = $elapsed + time() - $start_time;

    767. 

  767. 	if ($html) echo '<p class="pages">';

    768. 

  768. 	echo "Processed $files ". ($files == 1 ? 'file' : 'files') ." in $elapsed ". ($elapsed == 1 ? 'second' : 'seconds') ." ";

    769. 

  769. 	echo "(". get_dp($elapsed / $files) ." seconds/file)\n";

    770. 

  770. 	if ($html) echo '</p><br />';

    771. 

  771. }

    772. 

  772. 

    773. 

  773. 

    774. 

  774. // Optimise database

    775. 

  775. if (rand(0, 5) == 0) {

    776. 

  776. 	if ($html) echo '<p class="pages">';

    777. 

  777. 	echo "Optimizing tables... ";

    778. 

  778. 	mysql_query("OPTIMIZE TABLE uts_match, uts_player, uts_rank, uts_killsmatrix, uts_weaponstats, uts_pinfo;") or die(mysql_error());

    779. 

  779. 	echo "Done\n";

    780. 

  780. 	if ($html) echo '</p>';

    781. 

  781. }

    782. 

  782. 

    783. 

  783. // Analyze Key distribution

    784. 

  784. if (rand(0, 10) == 0) {

    785. 

  785. 	if ($html) echo '<p class="pages">';

    786. 

  786. 	echo "Analyzing tables... ";

    787. 

  787. 	mysql_query("ANALYZE TABLE uts_match, uts_player, uts_rank, uts_killsmatrix, uts_weaponstats, uts_pinfo;") or die(mysql_error());

    788. 

  788. 	echo "Done\n";

    789. 

  789. 	if ($html) echo '</p>';

    790. 

  790. }

    791. 

  791. 

    792. 

  792. 

    793. 

  793. // Purge old logs

    794. 

  794. if ($purged = (purge_backups('logs/backup', $import_log_backups_purge_after))) {

    795. 

  795. 	if ($html) echo '<p class="pages">';

    796. 

  796. 	echo "Purged $purged old logfiles\n";

    797. 

  797. 	if ($html) echo '</p>';

    798. 

  798. }

    799. 

  799. 

    800. 

  800. // Purge old utdc logs

    801. 

  801. if ($import_utdc_download_enable) {

    802. 

  802. 	if ($purged = (purge_backups('logs/utdc', $import_utdc_log_purge_after))) {

    803. 

  803. 		if ($html) echo '<p class="pages">';

    804. 

  804. 		echo "Purged $purged old UTDC logfiles\n";

    805. 

  805. 		if ($html) echo '</p>';

    806. 

  806. 	}

    807. 

  807. }

    808. 

  808. 

    809. 

  809. // Purge old AnthChecker logs

    810. 

  810. if ($import_ac_download_enable) {

    811. 

  811. 	if ($purged = (purge_backups('logs/ac', $import_ac_log_purge_after))) {

    812. 

  812. 		if ($html) echo '<p class="pages">';

    813. 

  813. 		echo "Purged $purged old AC logfiles\n";

    814. 

  814. 		if ($html) echo '</p>';

    815. 

  815. 	}

    816. 

  816. }

    817. 

  817. 

    818. 

  818. echo "\n\n";

    819. 

  819. if ($html) echo '<br /><table border="0" cellpadding="1" cellspacing="2" width="720"><tr><td class="heading" align="center" colspan="2">';

    820. 

  820. echo "Import Script Completed\n";

    821. 

  821. if ($html) echo '</td></tr></table>';

    822. 

  822. 

    823. 

  823. if ($html) include("includes/footer.php");

    824. 

  824. ?>

    825. 

  825.