PageRenderTime 28ms CodeModel.GetById 25ms RepoModel.GetById 0ms app.codeStats 0ms

/Web Files/ASP/includes/admin.process.php

https://code.google.com/p/bf2stats/
PHP | 1397 lines | 1233 code | 99 blank | 65 comment | 141 complexity | 283fc23a9ac642c668a12067a2c7fe06 MD5 | raw file
    

  1. <?php

    2. 

  2. 

    3. 

  3. // MY EDIT LINE: 800 - 812

    4. 

  4. 

    5. 

  5. 

    6. 

  6. // No Direct Access

    7. 

  7. defined( '_BF2_ADMIN' ) or die( 'Restricted access' );

    8. 

  8. 

    9. 

  9. // Build Data Table Array

    10. 

  10. $DataTables = array('army','awards','kills','kits','mapinfo','maps','player','player_history','round_history','servers','unlocks','vehicles','weapons','data','stats');

    11. 

  11. 

    12. 

  12. 

    13. 

  13. // Do Tasks

    14. 

  14. $task = $_POST['task'] ? $_POST['task'] : '';

    15. 

  15. switch ($task) {

    16. 

  16. 	case "saveconfig":

    17. 

  17. 		showHeader('Save Configuration');

    18. 

  18. 		saveConfig();

    19. 

  19. 		break;

    20. 

  20. 	case "testconfig":

    21. 

  21. 		showHeader('Test Configuration');

    22. 

  22. 		testConfig();

    23. 

  23. 		break;

    24. 

  24. 	case "clanmanager":

    25. 

  25. 		showHeader('Clan Manager');

    26. 

  26. 		//processClanManager();

    27. 

  27. 		break;

    28. 

  28. 	case "changerank":

    29. 

  29. 		showHeader('Edit Players');

    30. 

  30. 		processChangeRank();

    31. 

  31. 		break;

    32. 

  32. 	case "banplayers":

    33. 

  33. 		showHeader('Ban Players');

    34. 

  34. 		processBanPlayers();

    35. 

  35. 		break;

    36. 

  36. 	case "unbanplayers":

    37. 

  37. 		showHeader('Un-Ban Players');

    38. 

  38. 		processUnBanPlayers();

    39. 

  39. 		break;

    40. 

  40. 	case "resetunlocks":

    41. 

  41. 		showHeader('Reset Unlocks');

    42. 

  42. 		processResetUnlocks();

    43. 

  43. 		break;

    44. 

  44. 	case "mergeplayers":

    45. 

  45. 		showHeader('Merge Players');

    46. 

  46. 		processMergePlayers();

    47. 

  47. 		break;

    48. 

  48. 	case "deleteplayers":

    49. 

  49. 		showHeader('Delete Players');

    50. 

  50. 		processDeletePlayers();

    51. 

  51. 		break;

    52. 

  52. 	case "installdb":

    53. 

  53. 		showHeader('Install Database');

    54. 

  54. 		processInstallDB();

    55. 

  55. 		break;

    56. 

  56. 	case "upgradedb":

    57. 

  57. 		showHeader('Upgrade Database');

    58. 

  58. 		processUpgradeDB();

    59. 

  59. 		break;

    60. 

  60. 	case "cleardb":

    61. 

  61. 		showHeader('Clear Database');

    62. 

  62. 		processClearDB();

    63. 

  63. 		break;

    64. 

  64. 	case "backupdb":

    65. 

  65. 		showHeader('Backup Database');

    66. 

  66. 		processBackupDB();

    67. 

  67. 		break;

    68. 

  68. 	case "restoredb":

    69. 

  69. 		showHeader('Restore Database');

    70. 

  70. 		processClearDB();

    71. 

  71. 		processRestoreDB();

    72. 

  72. 		break;

    73. 

  73. 	case "validateranks":

    74. 

  74. 		showHeader('Validate Ranks');

    75. 

  75. 		processValidateRanks();

    76. 

  76. 		break;

    77. 

  77. 	case "checkawards":

    78. 

  78. 		showHeader('Check Backend Awards');

    79. 

  79. 		processCheckAwards();

    80. 

  80. 		break;

    81. 

  81. 	case "importlogs":

    82. 

  82. 		showHeader('Import SNAPSHOT Logs');

    83. 

  83. 		processImportLogs();;

    84. 

  84. 		break;

    85. 

  85. 	default:

    86. 

  86. 		showLoginForm();

    87. 

  87. 		break;

    88. 

  88. }

    89. 

  89. 

    90. 

  90. // Tidy up HTML

    91. 

  91. echo "</pre></div>";

    92. 

  92. 

    93. 

  93. function showHeader($str) {

    94. 

  94. 	echo "<div class=\"content-head\"><div class=\"desc-title\">Processing: {$str}</div></div><div class=\"readme\"><pre>";

    95. 

  95. }

    96. 

  96. 

    97. 

  97. 

    98. 

  98. // Display Log Message to Browser

    99. 

  99. function showLog($msg) {

    100. 

  100. 	global $cfg;

    101. 

  101. 	$outmsg = date('Y-m-d H:i:s')." : ".$msg."\n";

    102. 

  102. 	echo $outmsg;

    103. 

  103. 	

    104. 

  104. 	if ($cfg->get('admin_log') != '') {

    105. 

  105. 		$file = @fopen($cfg->get('admin_log'), 'a');

    106. 

  106. 		@fwrite($file, $outmsg);

    107. 

  107. 		@fclose($file);

    108. 

  108. 	}

    109. 

  109. 	

    110. 

  110. 	flush();

    111. 

  111. 	if (ini_get('zlib.output_compression') != 0) { ob_flush(); }

    112. 

  112. }

    113. 

  113. 

    114. 

  114. function saveConfig() {

    115. 

  115. 	$cfg = new Config();

    116. 

  116. 		

    117. 

  117. 	// Store New/Changed config items

    118. 

  118. 	showLog("Saving Config...");

    119. 

  119. 	foreach ($_POST as $item => $val) {

    120. 

  120. 		$key = explode('__', $item);

    121. 

  121. 		if ($key[0] == 'cfg') {

    122. 

  122. 			showLog(" -> Found Key: '{$key[1]}' => '".((is_array($cfg->get($key[1])))?str_replace("\r\n", ",",$val):$val)."' (Old: ".((is_array($cfg->get($key[1])))?implode(',',$cfg->get($key[1])):$cfg->get($key[1])).")...");

    123. 

  123. 			$cfg->set($key[1],$val);

    124. 

  124. 		}

    125. 

  125. 	}

    126. 

  126. 	

    127. 

  127. 	$cfg->Save();

    128. 

  128. }

    129. 

  129. 

    130. 

  130. function testConfig() {

    131. 

  131. 	include('class.validator.php');

    132. 

  132. 	

    133. 

  133. 	DEFINE('__PASS','<b><font color="green">Pass</font></b>');

    134. 

  134. 	DEFINE('__WARN','<b><font color="orange">Warn</font></b>');

    135. 

  135. 	DEFINE('__FAIL','<b><font color="red">Fail</font></b>');

    136. 

  136. 	

    137. 

  137. 	// Define Test Snapshot String (PID: 111)

    138. 

  138. 	$tst_prefix = 'TST'.uniqid(rand());

    139. 

  139. 	$tst_snapshot = $tst_prefix.'\test_map\queryport\29900\mapstart\1157264950.7\mapend\1157266995.57\win\1\gm\0\m\999\v\bf2\pc\1\rwa\2\ra1\0\rs1\25\ra2\2\rs2\0\pID_0\999\name_0\Test Player\t_0\2\a_0\0\ctime_0\1559\c_0\1\ip_0\0\rs_0\24\cs_0\0\ss_0\18\ts_0\6\kills_0\9\deaths_0\17\cpc_0\0\cpn_0\1\cpa_0\0\cpna_0\0\cpd_0\0\ka_0\0\he_0\0\rev_0\0\rsp_0\0\rep_0\0\tre_0\0\drs_0\0\dra_0\4\pa_0\0\tmkl_0\0\tmdg_0\0\tmvd_0\0\su_0\0\ks_0\6\ds_0\6\rank_0\3\ban_0\0\kck_0\0\tco_0\0\tsl_0\1559\tsm_0\0\tlw_0\0\ta0_0\1559\ta1_0\0\ta2_0\0\ta3_0\0\ta4_0\0\ta5_0\0\ta6_0\0\ta7_0\0\ta8_0\0\ta9_0\0\mvns_0\29000037\mvks_0\1\mvns_0\29000113\mvks_0\1\mvns_0\29000069\mvks_0\1\mvns_0\29000081\mvks_0\2\mvns_0\29000108\mvks_0\1\mvns_0\29000080\mvks_0\1\mvns_0\29000089\mvks_0\1\mvns_0\29000041\mvks_0\1\tv0_0\278\tv1_0\0\tv2_0\0\tv3_0\532\tv4_0\227\tv5_0\0\tv6_0\0\tvp_0\17\kv0_0\5\kv1_0\0\kv2_0\0\kv3_0\0\kv4_0\0\kv5_0\0\kv6_0\0\bv0_0\3\bv1_0\0\bv2_0\0\bv3_0\0\bv4_0\0\bv5_0\0\bv6_0\0\kvr0_0\1\kvr1_0\0\kvr2_0\0\kvr3_0\0\kvr4_0\0\kvr5_0\0\kvr6_0\0\tk0_0\736\tk1_0\20\tk2_0\311\tk3_0\0\tk4_0\320\tk5_0\84\tk6_0\29\kk0_0\8\kk1_0\0\kk2_0\0\kk3_0\0\kk4_0\1\kk5_0\0\kk6_0\0\dk0_0\10\dk1_0\1\dk2_0\2\dk3_0\0\dk4_0\2\dk5_0\1\dk6_0\1\tw0_0\11\tw1_0\0\tw2_0\49\tw3_0\28\tw4_0\10\tw5_0\5\tw6_0\54\tw7_0\382\tw8_0\47\te0_0\2\te1_0\0\te3_0\48\te2_0\0\te4_0\0\te5_0\0\te6_0\0\te7_0\0\te8_0\0\kw0_0\0\kw1_0\0\kw2_0\0\kw3_0\0\kw4_0\0\kw5_0\1\kw6_0\0\kw7_0\1\kw8_0\0\ke0_0\1\ke1_0\0\ke3_0\0\ke2_0\0\ke4_0\0\ke5_0\0\bw0_0\1\bw1_0\0\bw2_0\2\bw3_0\1\bw4_0\0\bw5_0\0\bw6_0\3\bw7_0\5\bw8_0\1\be0_0\0\be1_0\0\be3_0\1\be2_0\0\be4_0\0\be5_0\0\be8_0\0\be9_0\0\de6_0\0\de7_0\0\de8_0\0\sw0_0\0\sw1_0\0\sw2_0\26\sw3_0\0\sw4_0\0\sw5_0\15\sw6_0\4\sw7_0\53\sw8_0\0\se0_0\2\se1_0\0\se2_0\0\se3_0\6\se4_0\0\se5_0\0\hw0_0\0\hw1_0\0\hw2_0\3\hw3_0\0\hw4_0\0\hw5_0\5\hw6_0\1\hw7_0\8\hw8_0\0\he0_0\1\he1_0\0\he2_0\0\he3_0\3\he4_0\0\he5_0\0\EOF\1';

    140. 

  140. 	$tst_pid = 999;

    141. 

  141. 	$tst_mapid = 999;

    142. 

  142. 		

    143. 

  143. 	$cfg = new Config();

    144. 

  144. 	$chk = new Validator();

    145. 

  145. 		

    146. 

  146. 	showLog("Testing Config...");

    147. 

  147. 	// Check Config File Write Access

    148. 

  148. 	showLog(" > Checking Config File...");

    149. 

  149. 	if (!$chk->is_sane('_config.php')) {

    150. 

  150. 		showLog("\t - Config File Writable: ".__FAIL);

    151. 

  151. 	} else {

    152. 

  152. 		showLog("\t - Config File Writable: ".__PASS);

    153. 

  153. 	}

    154. 

  154. 	

    155. 

  155. 	// Check Log File Write Access

    156. 

  156. 	showLog(" > Checking Log Files...");

    157. 

  157. 	if (!$chk->is_sane($cfg->get('debug_log'))) {

    158. 

  158. 		showLog("\t - Error Log File Writable: ".__WARN);

    159. 

  159. 	} else {

    160. 

  160. 		showLog("\t - Error Log File Writable: ".__PASS);

    161. 

  161. 	}

    162. 

  162. 	if (!$chk->is_sane($cfg->get('admin_log'))) {

    163. 

  163. 		showLog("\t - Admin Log File Writable: ".__WARN);

    164. 

  164. 	} else {

    165. 

  165. 		showLog("\t - Admin Log File Writable: ".__PASS);

    166. 

  166. 	}

    167. 

  167. 	

    168. 

  168. 	// DB Host Access

    169. 

  169. 	showLog(" > Checking Database Host...");

    170. 

  170. 	if ($chk->is_ipaddress($cfg->get('db_host'))) {

    171. 

  171. 		showLog("\t - Database host (".$cfg->get('db_host').") IP Address valid: ".__PASS);

    172. 

  172. 	} elseif ($chk->is_hostname($cfg->get('db_host'))) {

    173. 

  173. 		showLog("\t - Database host (".$cfg->get('db_host').") appears valid: ".__PASS);

    174. 

  174. 		if(PHP_OS == 'WINNT'){

    175. 

  175. 			showLog("\t - Database host (".$cfg->get('db_host').") resolves: ".__WARN);

    176. 

  176. 		} elseif(!checkdnsrr($cfg->get('db_host'),"ANY")) {

    177. 

  177. 			showLog("\t - Database host (".$cfg->get('db_host').") resolves: ".__PASS);

    178. 

  178. 		} else {

    179. 

  179. 			showLog("\t - Database host (".$cfg->get('db_host').") resolves: ".__FAIL);

    180. 

  180. 		}

    181. 

  181. 	} else {

    182. 

  182. 		if ($cfg->get('db_host') == 'localhost') {

    183. 

  183. 			showLog("\t - Database host (".$cfg->get('db_host').") valid: ".__PASS);

    184. 

  184. 		} elseif(PHP_OS == 'WINNT'){

    185. 

  185. 			showLog("\t - Database host (".$cfg->get('db_host').") resolves: ".__WARN);

    186. 

  186. 		} elseif(!checkdnsrr($cfg->get('db_host'),"ANY")) {

    187. 

  187. 			showLog("\t - Database host (".$cfg->get('db_host').") valid: ".__PASS);

    188. 

  188. 		} else {

    189. 

  189. 			showLog("\t - Database host (".$cfg->get('db_host').") valid: ".__FAIL);

    190. 

  190. 		}

    191. 

  191. 	}

    192. 

  192. 	

    193. 

  193. 	// DB MySQL Access

    194. 

  194. 	showLog(" > Checking Database Config...");

    195. 

  195. 	$connection = @mysql_connect($cfg->get('db_host'), $cfg->get('db_user'), $cfg->get('db_pass'));

    196. 

  196. 	if (!$connection) {

    197. 

  197. 		showLog("\t - Database host (".$cfg->get('db_host').") access: ".__FAIL);

    198. 

  198. 	} else {

    199. 

  199. 		showLog("\t - Database host (".$cfg->get('db_host').") access: ".__PASS);

    200. 

  200. 		

    201. 

  201. 		// DB Access

    202. 

  202. 		$db_selected = @mysql_select_db($cfg->get('db_name'), $connection);

    203. 

  203. 		if (!$db_selected) {

    204. 

  204. 			showLog("\t - Database (".$cfg->get('db_name').") access: ".__FAIL);

    205. 

  205. 		} else {

    206. 

  206. 			showLog("\t - Database (".$cfg->get('db_name').") access: ".__PASS);

    207. 

  207. 			

    208. 

  208. 			// DB Version

    209. 

  209. 			if (getDbVer() != $cfg->get('db_expected_ver')) {

    210. 

  210. 				showLog("\t - Database version (".$cfg->get('db_expected_ver')."): ".__FAIL);

    211. 

  211. 			} else {

    212. 

  212. 				showLog("\t - Database version (".$cfg->get('db_expected_ver')."): ".__PASS);

    213. 

  213. 			}

    214. 

  214. 		}

    215. 

  215. 	}

    216. 

  216. 	

    217. 

  217. 	// Check SNAPSHOT Storage Write Access

    218. 

  218. 	showLog(" > Checking SNAPSHOT Storage Path...");

    219. 

  219. 	if (!$chk->is_sane_dir($cfg->get('stats_logs'))) {

    220. 

  220. 		showLog("\t - SNAPSHOT Path Writable: ".__FAIL);

    221. 

  221. 	} else {

    222. 

  222. 		showLog("\t - SNAPSHOT Path Writable: ".__PASS);

    223. 

  223. 	}

    224. 

  224. 	

    225. 

  225. 	// Check SNAPSHOT Archive Write Access

    226. 

  226. 	showLog(" > Checking SNAPSHOT Archive Storage Path...");

    227. 

  227. 	if (!$chk->is_sane_dir($cfg->get('stats_logs_store'))) {

    228. 

  228. 		showLog("\t - SNAPSHOT Archive Path Writable: ".__FAIL);

    229. 

  229. 	} else {

    230. 

  230. 		showLog("\t - SNAPSHOT Archive Path Writable: ".__PASS);

    231. 

  231. 	}

    232. 

  232. 	

    233. 

  233. 	// Check Admin Backup Write Access

    234. 

  234. 	showLog(" > Checking Backup Storage Path...");

    235. 

  235. 	if (!$chk->is_sane_dir($cfg->get('admin_backup_path'))) {

    236. 

  236. 		showLog("\t - Backup Path Writable: ".__FAIL);

    237. 

  237. 	} else {

    238. 

  238. 		showLog("\t - Backup Path Writable: ".__PASS);

    239. 

  239. 	}

    240. 

  240. 	

    241. 

  241. 	// Check For Required Functions

    242. 

  242. 	showLog(" > Checking Remote URL Functions...");

    243. 

  243. 	if( function_exists('file') && function_exists('fopen') && ini_get('allow_url_fopen') ) {

    244. 

  244. 		showLog("\t - Remote URL Function Exist ('FOPEN'): ".__PASS);

    245. 

  245. 		$doURLChecks = true;

    246. 

  246. 	} elseif( (function_exists('curl_exec')) ) {

    247. 

  247. 		showLog("\t - Remote URL Function Exist ('CURL'): ".__PASS);

    248. 

  248. 		$doURLChecks = true;

    249. 

  249. 	} else {

    250. 

  250. 		showLog("\t - Remote URL Function Exist: ".__WARN);

    251. 

  251. 		$doURLChecks = false;

    252. 

  252. 	}

    253. 

  253. 	

    254. 

  254. 	// Close database connection

    255. 

  255. 	@mysql_close($connection);

    256. 

  256. 	

    257. 

  257. 	if ($doURLChecks) {

    258. 

  258. 		// Check bf2statistics.php Processing

    259. 

  259. 		showLog(" > Checking BF2Statistics Processing...");

    260. 

  260. 		$fh = @fsockopen($_SERVER['HTTP_HOST'], 80);

    261. 

  261. 		if ($fh) {

    262. 

  262. 			fwrite($fh, "POST /ASP/bf2statistics.php HTTP/1.1\r\n");

    263. 

  263. 			fwrite($fh, "HOST: ".$_SERVER['HTTP_HOST']."\r\n");

    264. 

  264. 			fwrite($fh, "User-Agent: GameSpyHTTP/1.0\r\n");

    265. 

  265. 			fwrite($fh, "Content-Type: application/x-www-form-urlencoded\r\n");

    266. 

  266. 			fwrite($fh, "Content-Length: " . strlen($tst_snapshot) . "\r\n\r\n");

    267. 

  267. 			fwrite($fh, $tst_snapshot . "\r\n");

    268. 

  268. 			

    269. 

  269. 			$buffer = "";

    270. 

  270. 			while (!feof($fh)) {

    271. 

  271. 				$buffer .= fgets($fh, 4096);

    272. 

  272. 			}

    273. 

  273. 			fclose($fh);

    274. 

  274. 			

    275. 

  275. 			// Check Response Buffer

    276. 

  276. 			if (preg_match("%^HTTP/1.[01]\s*(\d+) *([^\n\r]*)(.*?)$%is", $buffer, $matches)) {

    277. 

  277. 				$responsecode = $matches[1];

    278. 

  278. 			}

    279. 

  279. 			if ($responsecode != '200') {

    280. 

  280. 				showLog("\t - BF2Statistics Processing Check: ".__FAIL);

    281. 

  281. 			} else {

    282. 

  282. 				showLog("\t - BF2Statistics Processing Check: ".__PASS);

    283. 

  283. 			}

    284. 

  284. 		} else {

    285. 

  285. 			showLog("\t - BF2Statistics Processing Check: ".__FAIL);

    286. 

  286. 		}

    287. 

  287. 		

    288. 

  288. 		// Check .aspx Page Responses

    289. 

  289. 		showLog(" > Checking Gamespy (.aspx) File Basic Response...");

    290. 

  290. 		$url = "http://".$_SERVER['HTTP_HOST']."/ASP/getbackendinfo.aspx";

    291. 

  291. 		$response = getPageContents($url);

    292. 

  292. 		if (trim($response[0]) != 'O') {

    293. 

  293. 			showLog("\t - Gamespy (.aspx) Basic Response: ".__FAIL);

    294. 

  294. 		} else {

    295. 

  295. 			showLog("\t - Gamespy (.aspx) Basic Response: ".__PASS);

    296. 

  296. 		}

    297. 

  297. 		

    298. 

  298. 		showLog(" > Checking Gamespy (.aspx) File Advanced Responses...");

    299. 

  299. 		$url = "http://".$_SERVER['HTTP_HOST']."/ASP/getawardsinfo.aspx?pid={$tst_pid}";

    300. 

  300. 		$response = getPageContents($url);

    301. 

  301. 		if (trim($response[0]) != 'O') {

    302. 

  302. 			showLog("\t - Gamespy (.aspx) Advanced (1) Response: ".__FAIL);

    303. 

  303. 		} else {

    304. 

  304. 			showLog("\t - Gamespy (.aspx) Advanced (1) Response: ".__PASS);

    305. 

  305. 		}

    306. 

  306. 		

    307. 

  307. 		$url = "http://".$_SERVER['HTTP_HOST']."/ASP/getrankinfo.aspx?pid={$tst_pid}";

    308. 

  308. 		$response = getPageContents($url);

    309. 

  309. 		if (trim($response[0]) != 'O') {

    310. 

  310. 			showLog("\t - Gamespy (.aspx) Advanced (2) Response: ".__FAIL);

    311. 

  311. 		} else {

    312. 

  312. 			showLog("\t - Gamespy (.aspx) Advanced (2) Response: ".__PASS);

    313. 

  313. 		}

    314. 

  314. 		

    315. 

  315. 		$url = "http://".$_SERVER['HTTP_HOST']."/ASP/getunlocksinfo.aspx?pid={$tst_pid}";

    316. 

  316. 		$response = getPageContents($url);

    317. 

  317. 		if (trim($response[0]) != 'O') {

    318. 

  318. 			showLog("\t - Gamespy (.aspx) Advanced (3) Response: ".__FAIL);

    319. 

  319. 		} else {

    320. 

  320. 			showLog("\t - Gamespy (.aspx) Advanced (3) Response: ".__PASS);

    321. 

  321. 		}

    322. 

  322. 	}

    323. 

  323. 	

    324. 

  324. 	// Re-Connect to DB (The above scripts sometimes removes it)

    325. 

  325. 	$connection = @mysql_connect($cfg->get('db_host'), $cfg->get('db_user'), $cfg->get('db_pass'));

    326. 

  326. 	@mysql_select_db($cfg->get('db_name'), $connection) or die("Database Error: " . mysql_error());

    327. 

  327. 	

    328. 

  328. 	// Remove Test Server Data

    329. 

  329. 	$query = "DELETE FROM `servers` WHERE prefix = '{$tst_prefix}';";

    330. 

  330. 	$result = mysql_query($query);

    331. 

  331. 	if ($result) {

    332. 

  332. 		showLog(" -> Server Info ({$tst_prefix}) removed from Table (servers).");

    333. 

  333. 	} else {

    334. 

  334. 		showLog(" -> <font color='red'>ERROR:</font> Server Info ({$tst_prefix}) removed from Table (servers)!\n".mysql_error());

    335. 

  335. 	}

    336. 

  336. 	

    337. 

  337. 	// Remove Test Map Data

    338. 

  338. 	$query = "DELETE FROM `mapinfo` WHERE id = {$tst_mapid};";

    339. 

  339. 	$result = mysql_query($query);

    340. 

  340. 	if ($result) {

    341. 

  341. 		showLog(" -> Map Info ({$tst_mapid}) removed from Table (mapinfo).");

    342. 

  342. 	} else {

    343. 

  343. 		showLog(" -> <font color='red'>ERROR:</font> Map Info ({$tst_mapid}) removed from Table (mapinfo)!\n".mysql_error());

    344. 

  344. 	}

    345. 

  345. 	

    346. 

  346. 	$query = "DELETE FROM `round_history` WHERE mapid = {$tst_mapid};";

    347. 

  347. 	$result = mysql_query($query);

    348. 

  348. 	if ($result) {

    349. 

  349. 		showLog(" -> Map Info ({$tst_mapid}) removed from Table (round_history).");

    350. 

  350. 	} else {

    351. 

  351. 		showLog(" -> <font color='red'>ERROR:</font> Map Info ({$tst_mapid}) removed from Table (round_history)!\n".mysql_error());

    352. 

  352. 	}

    353. 

  353. 	showLog("Done! :)");

    354. 

  354. 	showLog("");

    355. 

  355. 	

    356. 

  356. 	// Close database connection

    357. 

  357. 	@mysql_close($connection);

    358. 

  358. 	

    359. 

  359. 	// Remove Test Player Data

    360. 

  360. 	$_POST['selitems'] = array($tst_pid);

    361. 

  361. 	processDeletePlayers();

    362. 

  362. }

    363. 

  363. 

    364. 

  364. function processChangeLeaders() {

    365. 

  365. 	// This script will edits your characters rank and assign awards

    366. 

  366. global $cfg, $DB;

    367. 

  367. 	

    368. 

  368. 	$bco = $_POST['b_commander'];

    369. 

  369. 	$oco = $_POST['o_commander'];

    370. 

  370. 	$bdco = $_POST['b_d_commander'];

    371. 

  371. 	$odco = $_POST['o_d_commander'];

    372. 

  372. 	$bdcor = $_POST['b_d_rank'];

    373. 

  373. 	$odcor = $_POST['o_d_rank'];

    374. 

  374. 	$tour = $_POST['tour'];

    375. 

  375. 	

    376. 

  376. 	$check = $DB->query("SELECT tour FROM tour_leaders WHERE tour='$tour' LIMIT 1");

    377. 

  377. 	if(count($check) > 0){

    378. 

  378. 		$howmany = $check;

    379. 

  379. 		$DB->query("UPDATE `tour_leaders` SET `b_commander`='$bco',`o_commander`='$oco',`b_d_commander`='$bdco',`bdrank`='$bdcor',`o_d_commander`='$odco',`odrank`='$odcor' WHERE (tour='$tour')");

    380. 

  380. 	}else{

    381. 

  381. 		$DB->query("INSERT INTO tour_leaders(tour, b_commander, o_commander, b_d_commander, bdrank, o_d_commander, odrank) VALUES('$tour', '$bco', '$oco', '$bdco', '$bdcor', '$odco', '$odcor') LIMIT 1");

    382. 

  382. 	}

    383. 

  383. 	showLog("Done! :)");

    384. 

  384. }

    385. 

  385. 

    386. 

  386. function processChangeRank() {

    387. 

  387. 	// This script will edits your characters rank and assign awards

    388. 

  388. 	global $cfg, $DB;

    389. 

  389. 	

    390. 

  390. 	$rank = $_POST['selected_rank'];

    391. 

  391. 	$id = $_POST['player'];

    392. 

  392. 	

    393. 

  393. 	$changerank = $DB->query("UPDATE player SET rank='$rank' WHERE id LIKE '$id'");

    394. 

  394. 	showLog("Done! :)");

    395. 

  395. }

    396. 

  396. 

    397. 

  397. function processAddCustomBadge() {

    398. 

  398. 	// This script will edits your characters rank and assign awards

    399. 

  399. 	global $cfg, $DB;

    400. 

  400. 	

    401. 

  401. 	$award = $_POST['selected_badge'];

    402. 

  402. 	$id = $_POST['player'];

    403. 

  403. 	

    404. 

  404. 	$addaward = $DB->query("INSERT INTO custom_awards(pid, award, count, type) VALUES($id, $award, 1, 1)");

    405. 

  405. 	showLog("Done! :)");

    406. 

  406. }

    407. 

  407. 

    408. 

  408. function processAddCustomMedal() {

    409. 

  409. 	// This script will edits your characters rank and assign awards

    410. 

  410. 	global $cfg, $DB;

    411. 

  411. 	

    412. 

  412. 	$award = $_POST['medal'];

    413. 

  413. 	$id = $_POST['player'];

    414. 

  414. 	$count = $_POST['count'];

    415. 

  415. 	

    416. 

  416. 	$check = $DB->query("SELECT count FROM custom_awards WHERE pid='$id' AND award='$award' LIMIT 1");

    417. 

  417. 	if(count($check) > 0){

    418. 

  418. 		$howmany = $check;

    419. 

  419. 		$DB->query("UPDATE `custom_awards` SET `count`=(`count` + ".$count.") WHERE pid='$id' AND award='$award'");

    420. 

  420. 	}else{

    421. 

  421. 		$DB->query("INSERT INTO custom_awards(pid, award, count, type) VALUES($id, $award, $count, 2)");

    422. 

  422. 	}

    423. 

  423. 	showLog("Done! :)");

    424. 

  424. }

    425. 

  425. 

    426. 

  426. function processScoreManager() {

    427. 

  427. 	// This script will edits your characters rank and assign awards

    428. 

  428. 	global $cfg, $DB;

    429. 

  429. 	

    430. 

  430. 	$a = $_POST['tour'];

    431. 

  431. 	$b = $_POST['mapid'];

    432. 

  432. 	$c = $_POST['mapname'];

    433. 

  433. 	$d = $_POST['team'];

    434. 

  434. 	$e = $_POST['tickets'];

    435. 

  435. 	$f = $_POST['ntp'];

    436. 

  436. 	$g = $_POST['oftp'];

    437. 

  437. 	$h = $_POST['ntpp'];

    438. 

  438. 	$i = $_POST['ofpp'];

    439. 

  439. 	

    440. 

  440. 	$DB->query("INSERT INTO scoreboard(tour, number, mapname, winner, tickets, natotp, opfortp, ntpPoints, otpPoints) VALUES('$a', '$b', '$c', '$d', '$e', '$f', '$g', '$h', '$i')");

    441. 

  441. 	showLog("Done! :)");

    442. 

  442. }

    443. 

  443. 

    444. 

  444. function processBanPlayers() {

    445. 

  445. 	// This script will validate the BF2 Gamespy Ranks

    446. 

  446. 	global $cfg;

    447. 

  447. 	$connection = @mysql_connect($cfg->get('db_host'), $cfg->get('db_user'), $cfg->get('db_pass'));

    448. 

  448. 	@mysql_select_db($cfg->get('db_name'), $connection) or die("Database Error: " . mysql_error());

    449. 

  449. 	

    450. 

  450. 	$pids_arr = $_POST['selitems'];

    451. 

  451. 	

    452. 

  452. 	showLog("Banning Players...");

    453. 

  453. 	$query = "SELECT id FROM player";

    454. 

  454. 	if ($pids_arr) {

    455. 

  455. 		$pids = implode(", ", $pids_arr);

    456. 

  456. 		$query .= " WHERE id IN ({$pids})";

    457. 

  457. 	} else {

    458. 

  458. 		showLog("ERROR:<font color='red'>ERROR:</font> No Players Selected!");

    459. 

  459. 		return;

    460. 

  460. 	}

    461. 

  461. 	$result = mysql_query($query);

    462. 

  462. 	if (mysql_num_rows($result)) {

    463. 

  463. 		while ($row = mysql_fetch_array($result)) {

    464. 

  464. 			$pid = $row['id'];

    465. 

  465. 			$query = "UPDATE player SET permban = 1 WHERE (id = {$pid})";

    466. 

  466. 			$updateresult = mysql_query($query);

    467. 

  467. 			if ($updateresult) {

    468. 

  468. 				showLog(" -> Player ({$pid}) Banned");

    469. 

  469. 			} else {

    470. 

  470. 				showLog(" -> <font color='red'>ERROR:</font> Player ({$pid}) *NOT* Banned: ".mysql_error());

    471. 

  471. 			}

    472. 

  472. 		}

    473. 

  473. 	} else {

    474. 

  474. 		showLog("<font color='red'>ERROR:</font>  No Data Found!");

    475. 

  475. 	}

    476. 

  476. 	// Close database connection

    477. 

  477. 	@mysql_close($connection);

    478. 

  478. 	showLog("Done! :)");

    479. 

  479. }

    480. 

  480. 

    481. 

  481. function processUnBanPlayers() {

    482. 

  482. 	// This script will validate the BF2 Gamespy Ranks

    483. 

  483. 	global $cfg;

    484. 

  484. 	$connection = @mysql_connect($cfg->get('db_host'), $cfg->get('db_user'), $cfg->get('db_pass'));

    485. 

  485. 	@mysql_select_db($cfg->get('db_name'), $connection) or die("Database Error: " . mysql_error());

    486. 

  486. 	

    487. 

  487. 	$pids_arr = $_POST['selitems'];

    488. 

  488. 	

    489. 

  489. 	showLog("Un-Banning Players...");

    490. 

  490. 	$query = "SELECT id FROM player";

    491. 

  491. 	if ($pids_arr) {

    492. 

  492. 		$pids = implode(", ", $pids_arr);

    493. 

  493. 		$query .= " WHERE id IN ({$pids})";

    494. 

  494. 	} else {

    495. 

  495. 		showLog("ERROR:<font color='red'>ERROR:</font> No Players Selected!");

    496. 

  496. 		return;

    497. 

  497. 	}

    498. 

  498. 	$result = mysql_query($query);

    499. 

  499. 	if (mysql_num_rows($result)) {

    500. 

  500. 		while ($row = mysql_fetch_array($result)) {

    501. 

  501. 			$pid = $row['id'];

    502. 

  502. 			$query = "UPDATE player SET permban = 0 WHERE (id = {$pid})";

    503. 

  503. 			$updateresult = mysql_query($query);

    504. 

  504. 			if ($updateresult) {

    505. 

  505. 				showLog(" -> Player ({$pid}) Un-Banned");

    506. 

  506. 			} else {

    507. 

  507. 				showLog(" -> <font color='red'>ERROR:</font> Player ({$pid}) *NOT* Un-Banned: ".mysql_error());

    508. 

  508. 			}

    509. 

  509. 		}

    510. 

  510. 	} else {

    511. 

  511. 		showLog("<font color='red'>ERROR:</font>  No Data Found!");

    512. 

  512. 	}

    513. 

  513. 	// Close database connection

    514. 

  514. 	@mysql_close($connection);

    515. 

  515. 	showLog("Done! :)");

    516. 

  516. }

    517. 

  517. 

    518. 

  518. function processResetUnlocks() {

    519. 

  519. 	// This script will validate the BF2 Gamespy Ranks

    520. 

  520. 	global $cfg;

    521. 

  521. 	$connection = @mysql_connect($cfg->get('db_host'), $cfg->get('db_user'), $cfg->get('db_pass'));

    522. 

  522. 	@mysql_select_db($cfg->get('db_name'), $connection) or die("Database Error: " . mysql_error());

    523. 

  523. 	

    524. 

  524. 	$pids_arr = $_POST['selitems'];

    525. 

  525. 	

    526. 

  526. 	showLog("Reseting Player Unlocks...");

    527. 

  527. 	$query = "SELECT id, availunlocks, usedunlocks FROM player";

    528. 

  528. 	if ($pids_arr) {

    529. 

  529. 		$pids = implode(", ", $pids_arr);

    530. 

  530. 		$query .= " WHERE id IN ({$pids})";

    531. 

  531. 	} else {

    532. 

  532. 		showLog("ERROR:<font color='red'>ERROR:</font> No Players Selected!");

    533. 

  533. 		return;

    534. 

  534. 	}

    535. 

  535. 	$result = mysql_query($query);

    536. 

  536. 	if (mysql_num_rows($result)) {

    537. 

  537. 		while ($row = mysql_fetch_array($result)) {

    538. 

  538. 			$pid = $row['id'];

    539. 

  539. 			$unlocks = $row['availunlocks'] + $row['usedunlocks'];

    540. 

  540. 			$used = 0;

    541. 

  541. 			showLog(" -> Found Player ({$pid}) : $unlocks : $used");

    542. 

  542. 			showLog(" -> Reseting Unlocks for Player ({$pid})");

    543. 

  543. 			

    544. 

  544. 			$query = "UPDATE unlocks SET state = 'n' WHERE (id = {$pid})";

    545. 

  545. 			mysql_query($query) or die(mysql_error());

    546. 

  546. 			

    547. 

  547. 			$query = "UPDATE player SET availunlocks = {$unlocks}, usedunlocks = {$used} WHERE id = {$pid}";

    548. 

  548. 			mysql_query($query) or die(mysql_error());

    549. 

  549. 			

    550. 

  550. 			showLog("Done! :)");

    551. 

  551. 		}

    552. 

  552. 	} else {

    553. 

  553. 		showLog("<font color='red'>ERROR:</font>  No Data Found!");

    554. 

  554. 	}

    555. 

  555. 	// Close database connection

    556. 

  556. 	@mysql_close($connection);

    557. 

  557. 	showLog("Done! :)");

    558. 

  558. }

    559. 

  559. 

    560. 

  560. function processDeletePlayers() {

    561. 

  561. 	// This script will permantly delete player data.  Use with EXTREME cation!!

    562. 

  562. 	global $cfg;

    563. 

  563. 	$connection = @mysql_connect($cfg->get('db_host'), $cfg->get('db_user'), $cfg->get('db_pass'));

    564. 

  564. 	@mysql_select_db($cfg->get('db_name'), $connection) or die("Database Error: " . mysql_error());

    565. 

  565. 	

    566. 

  566. 	// Build Data Table Array

    567. 

  567. 	$DataTables = array('army','awards','kills','kits','mapinfo','maps','player','player_history','unlocks','vehicles','weapons');

    568. 

  568. 

    569. 

  569. 	$pids_arr = $_POST['selitems'];

    570. 

  570. 	

    571. 

  571. 	if ($pids_arr) {

    572. 

  572. 		$pids = implode(", ", $pids_arr);

    573. 

  573. 	} else {

    574. 

  574. 		showLog("<font color='red'>ERROR:</font> No Players Selected!");

    575. 

  575. 		return;

    576. 

  576. 	}

    577. 

  577. 	

    578. 

  578. 	showLog("Delete Player Data ({$pids})...");

    579. 

  579. 	foreach ($DataTables as $DataTable) {

    580. 

  580. 		// Check Table Exists

    581. 

  581. 		$query = "SHOW TABLES LIKE '" . $DataTable . "'";

    582. 

  582. 		$result = mysql_query($query);

    583. 

  583. 		if (mysql_num_rows($result)==1) {

    584. 

  584. 			// Table Exists, lets clear it

    585. 

  585. 			$query = "DELETE FROM `" . $DataTable . "` ";

    586. 

  586. 			if ($DataTable == 'kills') {

    587. 

  587. 				$query .= "WHERE ((attacker IN ({$pids})) OR (victim IN ({$pids})));";

    588. 

  588. 			} else {

    589. 

  589. 				$query .= "WHERE id IN ({$pids});";

    590. 

  590. 			}

    591. 

  591. 			$result = mysql_query($query);

    592. 

  592. 			if ($result) {

    593. 

  593. 				showLog(" -> Player(s) removed from Table (" . $DataTable . ").");

    594. 

  594. 			} else {

    595. 

  595. 				showLog(" -> <font color='red'>ERROR:</font> Player(s)  *NOT* removed from Table (" . $DataTable . ")!\n".mysql_error());

    596. 

  596. 			}

    597. 

  597. 		}

    598. 

  598. 	}

    599. 

  599. 	// Close database connection

    600. 

  600. 	@mysql_close($connection);

    601. 

  601. 	showLog("Done! :)");

    602. 

  602. }

    603. 

  603. 

    604. 

  604. function processMergePlayers() {

    605. 

  605. 	// This script will merge 2 player ID's, setting the first one as .  Use with EXTREME cation!!

    606. 

  606. 	global $cfg;

    607. 

  607. 	$connection = @mysql_connect($cfg->get('db_host'), $cfg->get('db_user'), $cfg->get('db_pass'));

    608. 

  608. 	@mysql_select_db($cfg->get('db_name'), $connection) or die("Database Error: " . mysql_error());

    609. 

  609. 	

    610. 

  610. 	// Get PlayerID's

    611. 

  611. 	$pids = array();

    612. 

  612. 	$pids[0] = ($_POST['target_pid'])?$_POST['target_pid']:0;		// Target PID

    613. 

  613. 	$pids[1] = ($_POST['source_pid'])?$_POST['source_pid']:0;		// Source PID

    614. 

  614. 	

    615. 

  615. 	// Check PID Values

    616. 

  616. 	

    617. 

  617. 	if ($pids[0]==0 || $pids[1]==0) {

    618. 

  618. 		showLog("<font color='red'>ERROR:</font> Data input missing!");

    619. 

  619. 		return;

    620. 

  620. 	}

    621. 

  621. 	if ($pids[0] == $pids[1]) {

    622. 

  622. 		showLog("<font color='red'>ERROR:</font> Target &amp; Source are Identical!!");

    623. 

  623. 		return;

    624. 

  624. 	}

    625. 

  625. 	

    626. 

  626. 	// Check Players Exist

    627. 

  627. 	foreach ($pids as $pid) {

    628. 

  628. 		if (!is_numeric($pid)) {

    629. 

  629. 			showLog("<font color='red'>ERROR:</font> PID ({$pid}) is not a valid player!");

    630. 

  630. 			return;

    631. 

  631. 		}

    632. 

  632. 		

    633. 

  633. 		$query = "SELECT id FROM player WHERE id = {$pid}";

    634. 

  634. 		$result = mysql_query($query);

    635. 

  635. 		if (mysql_num_rows($result)==1) {

    636. 

  636. 			$pids_exist = true;

    637. 

  637. 		} else {

    638. 

  638. 			showLog("<<font color='red'>ERROR:</font> PID ({$pid}) is not a valid player!");

    639. 

  639. 			return;

    640. 

  640. 		}

    641. 

  641. 	}

    642. 

  642. 	

    643. 

  643. 	// We are still here, so everything must have checked out

    644. 

  644. 	showLog("Merging Player Data...");

    645. 

  645. 	

    646. 

  646. 	// Note: PID1 -->> PID0.  PID0 becomes the primary and PID1 is removed!  Make sure you get this RIGHT!!!!

    647. 

  647. 	

    648. 

  648. 	// Merge Single-line data tables

    649. 

  649. 	$DataTables = array('army','kits','vehicles','weapons','player');

    650. 

  650. 	foreach ($DataTables as $DataTable) {

    651. 

  651. 		showLog(" -> Merging {$DataTable} table...");

    652. 

  652. 		$query = "SELECT * FROM {$DataTable} WHERE id = {$pids[1]}";

    653. 

  653. 		$result = mysql_query($query);

    654. 

  654. 		if (mysql_num_rows($result)==1) {

    655. 

  655. 			$fieldCount = mysql_num_fields($result);

    656. 

  656. 			$row = mysql_fetch_row($result);

    657. 

  657. 			

    658. 

  658. 			// Build Update Query

    659. 

  659. 			$query = "UPDATE {$DataTable} SET ";

    660. 

  660. 			for( $i = 1; $i < $fieldCount; $i++ ) {

    661. 

  661. 				if (mysql_field_type($result, $i)=='int') {

    662. 

  662. 					if ($DataTable == 'player' && mysql_field_name($result, $i) == 'joined') {

    663. 

  663. 						$query .= "`" . mysql_field_name($result, $i) . "` = " . $row[$i] . ",\n";

    664. 

  664. 					} elseif ($DataTable == 'player' &&  mysql_field_name($result, $i) == 'lastonline') {

    665. 

  665. 						$query .= "`" . mysql_field_name($result, $i) . "` = `" . mysql_field_name($result, $i) . "`,\n";

    666. 

  666. 					} elseif ($DataTable == 'player' &&  mysql_field_name($result, $i) == 'rndscore') {

    667. 

  667. 						$query .= "`" . mysql_field_name($result, $i) . "` = (SELECT IF(" . $row[$i] . " > `" . mysql_field_name($result, $i) . "`, " . $row[$i] . ", `" . mysql_field_name($result, $i) . "`)),\n";

    668. 

  668. 					} else {

    669. 

  669. 						$query .= "`" . mysql_field_name($result, $i) . "` = `" . mysql_field_name($result, $i) . "` + " . $row[$i] . ",\n";

    670. 

  670. 					}

    671. 

  671. 				}

    672. 

  672. 			}

    673. 

  673. 			$query = rtrim($query, ",\n") . "\nWHERE id = {$pids[0]};";

    674. 

  674. 			

    675. 

  675. 			// Update Data

    676. 

  676. 			if (mysql_query($query)) {

    677. 

  677. 				showLog("\t\tSuccess!");

    678. 

  678. 				// Remove Old Data

    679. 

  679. 				$query="DELETE FROM `{$DataTable}` WHERE id = {$pids[1]};";

    680. 

  680. 				if (mysql_query($query)) {

    681. 

  681. 					showLog(" -> Old Player Data ({$DataTable}) Removed.");

    682. 

  682. 				} else {

    683. 

  683. 					showLog("\t\t<font color='red'>ERROR:</font> ".mysql_error());

    684. 

  684. 				}

    685. 

  685. 			} else {

    686. 

  686. 				showLog("\t\t<font color='red'>ERROR:</font> ".mysql_error());

    687. 

  687. 				return;

    688. 

  688. 			}

    689. 

  689. 		} else {

    690. 

  690. 			showLog("\t\tNo Data");

    691. 

  691. 		}

    692. 

  692. 	}

    693. 

  693. 	

    694. 

  694. 	// Reset Unlocks

    695. 

  695. 	showLog(" -> Reseting Unlocks for Player ({$pids[0]})...");

    696. 

  696. 	$query = "UPDATE unlocks SET state = 'n' WHERE (id = {$pids[0]})";

    697. 

  697. 	if (mysql_query($query)) {

    698. 

  698. 		$query = "UPDATE player SET availunlocks = 0, usedunlocks = 0 WHERE id = {$pids[0]}";

    699. 

  699. 		mysql_query($query) or die(mysql_error());

    700. 

  700. 		showLog("\t\tSuccess!");

    701. 

  701. 		

    702. 

  702. 		// Remove Old Unlocks Data

    703. 

  703. 		showLog(" -> Removing Old Unlocks for Player ({$pids[1]})...");

    704. 

  704. 		$query = "DELETE FROM unlocks WHERE (id = {$pids[1]})";

    705. 

  705. 		if (mysql_query($query)) {

    706. 

  706. 			showLog("\t\tUnlocks Removed!");

    707. 

  707. 		} else {

    708. 

  708. 			showLog("\t\t<font color='red'>ERROR:</font> Unlocks Removal Failed!".mysql_error());

    709. 

  709. 		}

    710. 

  710. 	} else {

    711. 

  711. 		showLog("\t\t<font color='red'>ERROR:</font> ".mysql_error());

    712. 

  712. 		return;

    713. 

  713. 	}

    714. 

  714. 	

    715. 

  715. 	// Merge Awards Data

    716. 

  716. 	showLog(" -> Merging Awards table...");

    717. 

  717. 	$query = "SELECT * FROM awards WHERE id = {$pids[1]};";

    718. 

  718. 	$result = mysql_query($query);

    719. 

  719. 	if( mysql_num_rows( $result ) )	{

    720. 

  720. 		while( $rowsrc = mysql_fetch_array( $result ) ) {

    721. 

  721. 			// Check Awards exist

    722. 

  722. 			if ($rowsrc['awd']) {

    723. 

  723. 				$query = "SELECT * FROM awards WHERE id = {$pids[0]} AND awd = " . $rowsrc['awd'] . ";";

    724. 

  724. 				$chkresult = mysql_query($query);

    725. 

  725. 				if( mysql_num_rows( $chkresult ) ) {

    726. 

  726. 					// Update Award

    727. 

  727. 					$rowdest = mysql_fetch_array( $chkresult );

    728. 

  728. 					$query = "UPDATE `awards` SET\n";

    729. 

  729. 					switch ($rowsrc['awd']){

    730. 

  730. 						case 2051902:	// Gold

    731. 

  731. 						case 2051907:	// Silver

    732. 

  732. 						case 2051919:	// Bronze

    733. 

  733. 							$query .= "`level` = `level` + " . $rowsrc['level'] . ",\n";

    734. 

  734. 							break;

    735. 

  735. 						default:

    736. 

  736. 							$query .= "level = " . MAX($rowsrc['level'],$rowdest['level']) . ",\n";

    737. 

  737. 					}

    738. 

  738. 					$query .= "earned = " . MIN($rowsrc['earned'],$rowdest['earned']) . ",\n";

    739. 

  739. 					$query .= "first = " . MIN($rowsrc['first'],$rowdest['first']) . "\n";

    740. 

  740. 					$query .= "WHERE id = {$pids[0]} AND `awd` = " . $rowsrc['awd'] . ";";

    741. 

  741. 					if (mysql_query($query)) {

    742. 

  742. 						showLog("\t\tAward {$rowsrc[awd]} Update Success!");

    743. 

  743. 					} else {

    744. 

  744. 						showLog("\t\t<font color='red'>ERROR:</font> Award {$rowsrc[awd]} Update Failed: ".mysql_error());

    745. 

  745. 					}

    746. 

  746. 				} else {

    747. 

  747. 					// Insert Award

    748. 

  748. 					$query  = "INSERT INTO `awards` SET\n";

    749. 

  749. 					$query .= "`id` = {$pids[0]},\n";

    750. 

  750. 					$query .= "`awd` = " . $rowsrc['awd'] . ",\n";

    751. 

  751. 					$query .= "`level` = " . $rowsrc['level'] . ",\n";

    752. 

  752. 					$query .= "`earned` = " . $rowsrc['earned'] . ",\n";

    753. 

  753. 					$query .= "`first` = " . $rowsrc['first'] . ";";

    754. 

  754. 					if (mysql_query($query)) {

    755. 

  755. 						showLog("\t\tAward {$rowsrc[awd]} Insert Success!");

    756. 

  756. 					} else {

    757. 

  757. 						showLog("\t\t<font color='red'>ERROR:</font> Award {$rowsrc[awd]} Insert Failed: ".mysql_error());

    758. 

  758. 					}

    759. 

  759. 				}

    760. 

  760. 			} else {

    761. 

  761. 				showLog("\t\t<font color='red'>ERROR:</font> Err, that shouldn't have happend! :(");

    762. 

  762. 			}

    763. 

  763. 		}

    764. 

  764. 		showLog("\t\tAwards Table Merged!");

    765. 

  765. 		

    766. 

  766. 		// Remove Old Awards Data

    767. 

  767. 		showLog(" -> Removing Old Awards for Player ({$pids[1]})...");

    768. 

  768. 		$query = "DELETE FROM awards WHERE (id = {$pids[1]})";

    769. 

  769. 		if (mysql_query($query)) {

    770. 

  770. 			showLog("\t\tSuccess!");

    771. 

  771. 		} else {

    772. 

  772. 			showLog("\t\t<font color='red'>ERROR:</font> ".mysql_error());

    773. 

  773. 		}

    774. 

  774. 	}

    775. 

  775. 	

    776. 

  776. 	// Merge Maps Data

    777. 

  777. 	showLog(" -> Merging Maps table...");

    778. 

  778. 	$query = "SELECT * FROM `maps` WHERE `id` = {$pids[1]};";

    779. 

  779. 	$result = mysql_query($query);

    780. 

  780. 	if( mysql_num_rows( $result ) )	{

    781. 

  781. 		while( $rowsrc = mysql_fetch_array( $result ) ) {

    782. 

  782. 			// Check Map exist

    783. 

  783. 			if ($rowsrc['mapid']>=0) {

    784. 

  784. 				$query = "SELECT * FROM `maps` WHERE `id`= {$pids[0]} AND `mapid` = " . $rowsrc['mapid'] . ";";

    785. 

  785. 				$chkresult = mysql_query($query);

    786. 

  786. 				if( mysql_num_rows( $chkresult ) ) {

    787. 

  787. 		// Update Map Data

    788. 

  788. 			$rowdest = mysql_fetch_array( $chkresult );

    789. 

  789. 			$query = "UPDATE `maps` SET\n";

    790. 

  790. 			$query .= "`time` = `time` + " . $rowsrc['time'] . ",\n";

    791. 

  791. 			$query .= "`win` = `win` + " . $rowsrc['win'] . ",\n";

    792. 

  792. 			$query .= "`loss` = `loss` + " . $rowsrc['loss'] . ",\n";

    793. 

  793. 			if ($rowsrc['best'] > $rowdest['best']) {

    794. 

  794. 				$query .= "`best` = " . $rowsrc['best'] . ",\n";

    795. 

  795. 			}

    796. 

  796. 			if ($rowsrc['worst'] < $rowdest['worst']) {

    797. 

  797. 				$query .= "`worst` = `worst` + " . $rowsrc['worst'] . "\n";

    798. 

  798. 			}

    799. 

  799. 			$query .= "WHERE id = {$pids[0]} AND `mapid` = " . $rowsrc['mapid'] . ";";

    800. 

  800. 					if (mysql_query($query)) {

    801. 

  801. 						showLog("\t\tMap {$rowsrc[mapid]} Update Success!");

    802. 

  802. 					} else {

    803. 

  803. 						showLog("\t\t<font color='red'>ERROR:</font> Map {$rowsrc[mapid]} Update Failed: ".mysql_error());

    804. 

  804. 					}

    805. 

  805. 				} else {

    806. 

  806. 					// Insert Map Data

    807. 

  807. 					$query  = "INSERT INTO `maps` SET\n";

    808. 

  808. 					$query .= "`id` = {$pids[0]},\n";

    809. 

  809. 					$query .= "`mapid` = " . $rowsrc['mapid'] . ",\n";

    810. 

  810. 					$query .= "`time` = " . $rowsrc['time'] . ",\n";

    811. 

  811. 					$query .= "`win` = " . $rowsrc['win'] . ",\n";

    812. 

  812. 					$query .= "`loss` = " . $rowsrc['loss'] . ",\n";

    813. 

  813. 					$query .= "`best` = " . $rowsrc['best'] . ",\n";

    814. 

  814. 					$query .= "`worst` = " . $rowsrc['worst'] . ";";

    815. 

  815. 					if (mysql_query($query)) {

    816. 

  816. 						showLog("\t\tMap {$rowsrc[mapid]} Insert Success!");

    817. 

  817. 					} else {

    818. 

  818. 						showLog("\t\t<font color='red'>ERROR:</font> Map {$rowsrc[mapid]} Insert Failed: ".mysql_error());

    819. 

  819. 					}

    820. 

  820. 				}

    821. 

  821. 			} else {

    822. 

  822. 				showLog("\t\t<font color='red'>ERROR:</font> MapID Invalid!");

    823. 

  823. 			}

    824. 

  824. 		}

    825. 

  825. 		showLog("\t\tDone!");

    826. 

  826. 		

    827. 

  827. 		// Remove Old Maps Data

    828. 

  828. 		showLog(" -> Removing Old Maps for Player ({$pids[1]})...");

    829. 

  829. 		$query = "DELETE FROM maps WHERE (id = {$pids[1]})";

    830. 

  830. 		if (mysql_query($query)) {

    831. 

  831. 			showLog("\t\tSuccess!");

    832. 

  832. 		} else {

    833. 

  833. 			showLog("\t\t<font color='red'>ERROR:</font> ".mysql_error());

    834. 

  834. 		}

    835. 

  835. 	}

    836. 

  836. 	

    837. 

  837. 	// Update Kills Data

    838. 

  838. 	showLog(" -> Updating Kills Data...");

    839. 

  839. 	$query = "SELECT * FROM kills WHERE attacker = {$pids[1]};";

    840. 

  840. 	$result = mysql_query($query);

    841. 

  841. 	if( mysql_num_rows( $result ) )	{

    842. 

  842. 		while( $rowsrc = mysql_fetch_array( $result ) ) {

    843. 

  843. 			// Check Kills exist

    844. 

  844. 			if ($rowsrc['victim']) {

    845. 

  845. 				$query = "SELECT * FROM kills WHERE attacker = {$pids[0]} AND victim = " . $rowsrc['victim'] . ";";

    846. 

  846. 				$chkresult = mysql_query($query);

    847. 

  847. 				if( mysql_num_rows( $chkresult ) ) {

    848. 

  848. 					// Update Existing record

    849. 

  849. 					$query = "UPDATE `kills` SET\n";

    850. 

  850. 					$query .= "`count` = `count` + " . $rowsrc['count'] . "\n";

    851. 

  851. 					$query .= "WHERE attacker = {$pids[0]} AND victim = " . $rowsrc['victim'] . ";";

    852. 

  852. 					if (mysql_query($query)) {

    853. 

  853. 						// Success

    854. 

  854. 					} else {

    855. 

  855. 						showLog("\t\t<font color='red'>ERROR:</font> Kills data not updated: ".mysql_error());

    856. 

  856. 					}

    857. 

  857. 				} else {

    858. 

  858. 					// Insert Kills

    859. 

  859. 					$query  = "INSERT INTO `kills` SET\n";

    860. 

  860. 					$query .= "attacker = {$pids[0]},\n";

    861. 

  861. 					$query .= "victim = " . $rowsrc['victim'] . ",\n";

    862. 

  862. 					$query .= "`count` = " . $rowsrc['count'] . ";";

    863. 

  863. 					if (mysql_query($query)) {

    864. 

  864. 						// Success

    865. 

  865. 					} else {

    866. 

  866. 						showLog("\t\t<font color='red'>ERROR:</font> Kills data not inserted: ".mysql_error());

    867. 

  867. 					}

    868. 

  868. 				}

    869. 

  869. 			} else {

    870. 

  870. 				showLog("<font color='red'>#</font>");

    871. 

  871. 			}

    872. 

  872. 		}

    873. 

  873. 		showLog("\t\tKills Done!");

    874. 

  874. 		

    875. 

  875. 		// Remove Old Kills Data

    876. 

  876. 		showLog(" -> Removing Old Kills for Player ({$pids[1]})...");

    877. 

  877. 		$query = "DELETE FROM kills WHERE (attacker = {$pids[1]})";

    878. 

  878. 		if (mysql_query($query)) {

    879. 

  879. 			showLog("\t\tSuccess!");

    880. 

  880. 		} else {

    881. 

  881. 			showLog("\t\t<font color='red'>ERROR:</font> ".mysql_error());

    882. 

  882. 		}

    883. 

  883. 	}

    884. 

  884. 	

    885. 

  885. 	// Update Deaths Data

    886. 

  886. 	showLog(" -> Updating Deaths Data...");

    887. 

  887. 	$query = "SELECT * FROM kills WHERE victim = {$pids[1]};";

    888. 

  888. 	$result = mysql_query($query);

    889. 

  889. 	if( mysql_num_rows( $result ) )	{

    890. 

  890. 		while( $rowsrc = mysql_fetch_array( $result ) ) {

    891. 

  891. 			// Check Deaths exist

    892. 

  892. 			if ($rowsrc['attacker']) {

    893. 

  893. 				$query = "SELECT * FROM kills WHERE attacker = " . $rowsrc['attacker'] . " AND victim = {$pids[0]};;";

    894. 

  894. 				$chkresult = mysql_query($query);

    895. 

  895. 				if( mysql_num_rows( $chkresult ) ) {

    896. 

  896. 					// Update Existing record

    897. 

  897. 					$query = "UPDATE `kills` SET\n";

    898. 

  898. 					$query .= "`count` = `count` + " . $rowsrc['count'] . "\n";

    899. 

  899. 					$query .= "WHERE attacker = " . $rowsrc['attacker'] . " AND victim = {$pids[0]};";

    900. 

  900. 					if (mysql_query($query)) {

    901. 

  901. 						// Success

    902. 

  902. 					} else {

    903. 

  903. 						showLog("\t\t<font color='red'>ERROR:</font> Kills data not updated: ".mysql_error());

    904. 

  904. 					}

    905. 

  905. 				} else {

    906. 

  906. 					// Insert Deaths

    907. 

  907. 					$query  = "INSERT INTO `kills` SET\n";

    908. 

  908. 					$query .= "attacker = " . $rowsrc['attacker'] . ",\n";

    909. 

  909. 					$query .= "victim = {$pids[0]},\n";

    910. 

  910. 					$query .= "`count` = " . $rowsrc['count'] . ";";

    911. 

  911. 					if (mysql_query($query)) {

    912. 

  912. 						// Success

    913. 

  913. 					} else {

    914. 

  914. 						showLog("\t\t<font color='red'>ERROR:</font> Kills data not inserted: ".mysql_error());

    915. 

  915. 					}

    916. 

  916. 				}

    917. 

  917. 			} else {

    918. 

  918. 				showLog("<font color='red'>#</font>");

    919. 

  919. 			}

    920. 

  920. 		}

    921. 

  921. 		showLog("\t\tDeaths Done!");

    922. 

  922. 		

    923. 

  923. 		// Remove Old Deaths Data

    924. 

  924. 		showLog(" -> Removing Old Deaths for Player ({$pids[1]})...");

    925. 

  925. 		$query = "DELETE FROM kills WHERE (victim = {$pids[1]})";

    926. 

  926. 		if (mysql_query($query)) {

    927. 

  927. 			showLog("\t\tSuccess!");

    928. 

  928. 		} else {

    929. 

  929. 			showLog("\t\t<font color='red'>ERROR:</font> ".mysql_error());

    930. 

  930. 		}

    931. 

  931. 	}

    932. 

  932. 	showLog("Done! :)\n");

    933. 

  933. 	// Close database connection

    934. 

  934. 	@mysql_close($connection);

    935. 

  935. 	

    936. 

  936. 	//Validating Rank

    937. 

  937. 	$_POST['selitems'] = array($pids[0]);

    938. 

  938. 	processValidateRanks();

    939. 

  939. 	

    940. 

  940. 	// Ensure Old player does not exist

    941. 

  941. 	$_POST['selitems'] = array($pids[1]);

    942. 

  942. 	processDeletePlayers();

    943. 

  943. 	

    944. 

  944. }

    945. 

  945. 

    946. 

  946. function processInstallDB() {

    947. 

  947. 	// Install Default DB Schema

    948. 

  948. 	$cfg = new Config();

    949. 

  949. 		

    950. 

  950. 	// Store New/Changed config items

    951. 

  951. 	showLog("Saving Config...");

    952. 

  952. 	foreach ($_POST as $item => $val) {

    953. 

  953. 		$key = explode('__', $item);

    954. 

  954. 		if ($key[0] == 'cfg') {

    955. 

  955. 			showLog(" -> Found Key: '{$key[1]}' => '".((is_array($cfg->get($key[1])))?str_replace("\r\n", ",",$val):$val)."' (Old: ".((is_array($cfg->get($key[1])))?implode(',',$cfg->get($key[1])):$cfg->get($key[1])).")...");

    956. 

  956. 			$cfg->set($key[1],$val);

    957. 

  957. 		}

    958. 

  958. 	}

    959. 

  959. 	$cfg->Save();

    960. 

  960. 	

    961. 

  961. 	$connection = @mysql_connect($cfg->get('db_host'), $cfg->get('db_user'), $cfg->get('db_pass'));

    962. 

  962. 	@mysql_select_db($cfg->get('db_name'), $connection) or die("Database Error: " . mysql_error());

    963. 

  963. 	

    964. 

  964. 	// Import Schema

    965. 

  965. 	require('includes/db/sql.dbschema.php');

    966. 

  966. 	

    967. 

  967. 	showLog("Installing Database Schema");

    968. 

  968. 	foreach ($sqlschema as $query) {

    969. 

  969. 		if (mysql_query($query[1])) {

    970. 

  970. 			showLog(" -> ".$query[0]." Installed");

    971. 

  971. 		} else {

    972. 

  972. 			showLog(" -> <font color='red'>ERROR:</font> ".$query[0]." *NOT* Installed: ".mysql_error());

    973. 

  973. 		}

    974. 

  974. 	}

    975. 

  975. 	

    976. 

  976. 	// Import Defaut Data

    977. 

  977. 	require('includes/db/sql.dbdata.php');

    978. 

  978. 	

    979. 

  979. 	$i = 0;

    980. 

  980. 	showLog("Loading Default Database Data");

    981. 

  981. 	foreach ($sqldata as $query) {

    982. 

  982. 		if (mysql_query($query[1])) {

    983. 

  983. 			if ($query[0] == _IPN) {

    984. 

  984. 				if (($i % 100) == 0) {showLog(" -> ".$query[0]." ({$i} records) Loaded");}

    985. 

  985. 				$i++;

    986. 

  986. 			} else {

    987. 

  987. 				showLog(" -> ".$query[0]." Loaded");

    988. 

  988. 			}

    989. 

  989. 		} else {

    990. 

  990. 			showLog(" -> <font color='red'>ERROR:</font> ".$query[0]." *NOT* Loaded: ".mysql_error());

    991. 

  991. 		}

    992. 

  992. 	}

    993. 

  993. 	// Close database connection

    994. 

  994. 	@mysql_close($connection);

    995. 

  995. 	showLog("Done! :)");

    996. 

  996. }

    997. 

  997. 

    998. 

  998. function processUpgradeDB() {

    999. 

  999. 	// Update Scheme to Include EF & AF Booster Pack Info

    1000. 

  1000. 	$cfg = new Config();

    1001. 

  1001. 		

    1002. 

  1002. 	// Store New/Changed config items

    1003. 

  1003. 	showLog("Saving Config...");

    1004. 

  1004. 	foreach ($_POST as $item => $val) {

    1005. 

  1005. 		$key = explode('__', $item);

    1006. 

  1006. 		if ($key[0] == 'cfg') {

    1007. 

  1007. 			showLog(" -> Found Key: '{$key[1]}' => '".((is_array($cfg->get($key[1])))?str_replace("\r\n", ",",$val):$val)."' (Old: ".((is_array($cfg->get($key[1])))?implode(',',$cfg->get($key[1])):$cfg->get($key[1])).")...");

    1008. 

  1008. 			$cfg->set($key[1],$val);

    1009. 

  1009. 		}

    1010. 

  1010. 	}

    1011. 

  1011. 	$cfg->Save();

    1012. 

  1012. 	

    1013. 

  1013. 	// Get DB Version

    1014. 

  1014. 	$curdbver = verCmp(getDbVer());

    1015. 

  1015. 	

    1016. 

  1016. 	// Open Database connection

    1017. 

  1017. 	$connection = @mysql_connect($cfg->get('db_host'), $cfg->get('db_user'), $cfg->get('db_pass'));

    1018. 

  1018. 	@mysql_select_db($cfg->get('db_name'), $connection) or die("Database Error: " . mysql_error());

    1019. 

  1019. 	

    1020. 

  1020. 	// Upgrade Schema

    1021. 

  1021. 	require('includes/db/sql.dbupgrade.php');

    1022. 

  1022. 	

    1023. 

  1023. 	showLog("Upgrading Database Schema");

    1024. 

  1024. 	foreach ($sqlupgrade as $query) {

    1025. 

  1025. 		if ($curdbver < verCmp($query[1])) {

    1026. 

  1026. 			if (mysql_query($query[2])) {

    1027. 

  1027. 				showLog(" -> ".$query[0]." Success");

    1028. 

  1028. 			} else {

    1029. 

  1029. 				showLog(" -> <font color='red'>ERROR:</font> ".$query[0]." *FAILED*: ".mysql_error());

    1030. 

  1030. 			}

    1031. 

  1031. 		} else {

    1032. 

  1032. 			showLog(" -> <font color='blue'>Skipping:</font> ".$query[0]);

    1033. 

  1033. 		}

    1034. 

  1034. 	}

    1035. 

  1035. 	// Close database connection

    1036. 

  1036. 	@mysql_close($connection);

    1037. 

  1037. 	showLog("Done! :)");

    1038. 

  1038. }

    1039. 

  1039. 

    1040. 

  1040. function processClearDB() {

    1041. 

  1041. 	// This script will clear the Gamespy tables.  Use with EXTREME cation!!

    1042. 

  1042. 	global $cfg, $DataTables;

    1043. 

  1043. 	$connection = @mysql_connect($cfg->get('db_host'), $cfg->get('db_user'), $cfg->get('db_pass'));

    1044. 

  1044. 	@mysql_select_db($cfg->get('db_name'), $connection) or die("Database Error: " . mysql_error());

    1045. 

  1045. 	

    1046. 

  1046. 	showLog("Clearing Data Tables");

    1047. 

  1047. 	foreach ($DataTables as $DataTable) {

    1048. 

  1048. 		// Check Table Exists

    1049. 

  1049. 		$query = "SHOW TABLES LIKE '" . $DataTable . "'";

    1050. 

  1050. 		$result = mysql_query($query);

    1051. 

  1051. 		if (mysql_num_rows($result)) {

    1052. 

  1052. 			// Table Exists, lets clear it

    1053. 

  1053. 			$query="TRUNCATE TABLE `" . $DataTable . "`;";

    1054. 

  1054. 			$result = mysql_query($query);

    1055. 

  1055. 			if ($result) {

    1056. 

  1056. 				showLog(" -> Table (" . $DataTable . ") Cleared.");

    1057. 

  1057. 			} else {

    1058. 

  1058. 				showLog(" -> <font color='red'>ERROR:</font> Table (" . $DataTable . ") NOT Cleared!\n".mysql_error());

    1059. 

  1059. 			}

    1060. 

  1060. 		}

    1061. 

  1061. 	}

    1062. 

  1062. 	// Close database connection

    1063. 

  1063. 	@mysql_close($connection);

    1064. 

  1064. 	showLog("Done! :)");

    1065. 

  1065. }

    1066. 

  1066. 

    1067. 

  1067. function processBackupDB() {

    1068. 

  1068. 	// This script will backup the "Gamespy" Data Tabels

    1069. 

  1069. 	global $cfg, $DataTables;

    1070. 

  1070. 	$connection = @mysql_connect($cfg->get('db_host'), $cfg->get('db_user'), $cfg->get('db_pass'));

    1071. 

  1071. 	@mysql_select_db($cfg->get('db_name'), $connection) or die("Database Error: " . mysql_error());

    1072. 

  1072. 		

    1073. 

  1073. 	showLog("Backing Up Data Tables");

    1074. 

  1074. 	

    1075. 

  1075. 	// Create Backup Folder

    1076. 

  1076. 	$backupPath  = chkPath($cfg->get('admin_backup_path'));

    1077. 

  1077. 	$backupPath .= "bak_".date('Ymd_Hi');

    1078. 

  1078. 	mkdir($backupPath, 0666);	// Read and write for owner, nothing for everybody else

    1079. 

  1079. 	showLog(" -> Created Backup Directory: {$backupPath}");

    1080. 

  1080. 		

    1081. 

  1081. 	foreach ($DataTables as $DataTable) {

    1082. 

  1082. 		// Check Table Exists

    1083. 

  1083. 		$query = "SHOW TABLES LIKE '" . $DataTable . "'";

    1084. 

  1084. 		$result = mysql_query($query);

    1085. 

  1085. 		if (mysql_num_rows($result)==1) {

    1086. 

  1086. 			// Table Exists, lets back it up

    1087. 

  1087. 			$backupFile = $backupPath."/".$DataTable.$cfg->get('admin_backup_ext');

    1088. 

  1088. 			$query="SELECT * INTO OUTFILE '{$backupFile}' FROM {$DataTable};";

    1089. 

  1089. 			$result = mysql_query($query);

    1090. 

  1090. 			if ($result) {

    1091. 

  1091. 				showLog(" -> Table (" . $DataTable . ") Backed Up.");

    1092. 

  1092. 			} else {

    1093. 

  1093. 				showLog(" -> <font color='red'>ERROR:</font> Table (" . $DataTable . ") *NOT* Backed Up: ".mysql_error());

    1094. 

  1094. 			}

    1095. 

  1095. 		}

    1096. 

  1096. 	}

    1097. 

  1097. 	// Close database connection

    1098. 

  1098. 	@mysql_close($connection);

    1099. 

  1099. 	showLog("Done! :)");

    1100. 

  1100. }

    1101. 

  1101. 

    1102. 

  1102. function processRestoreDB() {

    1103. 

  1103. 	// This script will backup the "Gamespy" Data Tabels

    1104. 

  1104. 	global $cfg, $DataTables;

    1105. 

  1105. 	$connection = @mysql_connect($cfg->get('db_host'), $cfg->get('db_user'), $cfg->get('db_pass'));

    1106. 

  1106. 	@mysql_select_db($cfg->get('db_name'), $connection) or die("Database Error: " . mysql_error());

    1107. 

  1107. 		

    1108. 

  1108. 	showLog("Restore Data Tables");

    1109. 

  1109. 	

    1110. 

  1110. 	// Check Backup Folder

    1111. 

  1111. 	$backupPath  = chkPath($cfg->get('admin_backup_path'));

    1112. 

  1112. 	$backupPath .= $_POST["backupname"];

    1113. 

  1113. 	showLog(" -> Loaded Backup Directory: {$backupPath}");

    1114. 

  1114. 		

    1115. 

  1115. 	foreach ($DataTables as $DataTable) {

    1116. 

  1116. 		// Check Table Exists

    1117. 

  1117. 		$query = "SHOW TABLES LIKE '" . $DataTable . "'";

    1118. 

  1118. 		$result = mysql_query($query);

    1119. 

  1119. 		if (mysql_num_rows($result)==1) {

    1120. 

  1120. 			// Table Exists

    1121. 

  1121. 			$backupFile = $backupPath."/".$DataTable.$cfg->get('admin_backup_ext');

    1122. 

  1122. 			if (file_exists($backupFile)) {

    1123. 

  1123. 				// File Exists, lets restore it

    1124. 

  1124. 				$query="LOAD DATA INFILE '{$backupFile}' INTO TABLE {$DataTable};";

    1125. 

  1125. 				$result = mysql_query($query);

    1126. 

  1126. 				if ($result) {

    1127. 

  1127. 					showLog(" -> Table (" . $DataTable . ") Restored.");

    1128. 

  1128. 				} else {

    1129. 

  1129. 					showLog(" -> <font color='red'>ERROR:</font> Table (" . $DataTable . ") *NOT* Restored: ".mysql_error());

    1130. 

  1130. 				}

    1131. 

  1131. 			} else {

    1132. 

  1132. 				showLog(" -> <font color='red'>ERROR:</font> Data File (" . $backupFile . ") does *NOT* Exist!!");

    1133. 

  1133. 			}

    1134. 

  1134. 		}

    1135. 

  1135. 	}

    1136. 

  1136. 	// Close database connection

    1137. 

  1137. 	@mysql_close($connection);

    1138. 

  1138. 	showLog("Done! :)");

    1139. 

  1139. }

    1140. 

  1140. 

    1141. 

  1141. function processValidateRanks() {

    1142. 

  1142. 	// This script will validate the BF2 Gamespy Ranks

    1143. 

  1143. 	global $cfg;

    1144. 

  1144. 	$connection = @mysql_connect($cfg->get('db_host'), $cfg->get('db_user'), $cfg->get('db_pass'));

    1145. 

  1145. 	@mysql_select_db($cfg->get('db_name'), $connection) or die("Database Error: " . mysql_error());

    1146. 

  1146. 		

    1147. 

  1147. 	$pids_arr = $_POST['selitems'];

    1148. 

  1148. 	

    1149. 

  1149. 	showLog("Validating Player Ranks");

    1150. 

  1150. 	$query = "SELECT `id`, score, rank FROM player";

    1151. 

  1151. 	if ($pids_arr) {

    1152. 

  1152. 		$pids = implode(", ", $pids_arr);

    1153. 

  1153. 		$query .= " WHERE id IN ({$pids})";

    1154. 

  1154. 	} else {

    1155. 

  1155. 		showLog("<font color='red'>ERROR:</font> No Players Selected!");

    1156. 

  1156. 		return;

    1157. 

  1157. 	}

    1158. 

  1158. 	$result = mysql_query($query);

    1159. 

  1159. 	if (mysql_num_rows($result)>0) {

    1160. 

  1160. 		$expRank = array();

    1161. 

  1161. 		while ($row = mysql_fetch_array($result)) {

    1162. 

  1162. 			$pid = $row['id'];

    1163. 

  1163. 			$score = $row['score'];

    1164. 

  1164. 			$rank  = $row['rank'];

    1165. 

  1165. 			showLog(" -> Found Player ({$pid}) : Score:{$score} : Rank:{$rank}");

    1166. 

  1166. 			

    1167. 

  1167. 			// Verify/Correct Rank

    1168. 

  1168. 			// NOTE: Ranks 1SG/SGM/BG/MG/SMOC/GEN cannot be awarded here.

    1169. 

  1169. 			if ($score >= 200000) {$expRank[0] = 20;$expRank[1] = 20;}

    1170. 

  1170. 			elseif ($score >= 150000) {$expRank[0] = 17;$expRank[1] = 19;}

    1171. 

  1171. 			elseif ($score >= 125000) {$expRank[0] = 16;$expRank[1] = 16;}

    1172. 

  1172. 			elseif ($score >= 115000) {$expRank[0] = 15;$expRank[1] = 15;}

    1173. 

  1173. 			elseif ($score >= 90000) {$expRank[0] = 14;$expRank[1] = 14;}

    1174. 

  1174. 			elseif ($score >= 75000) {$expRank[0] = 13;$expRank[1] = 13;}

    1175. 

  1175. 			elseif ($score >= 60000) {$expRank[0] = 12;$expRank[1] = 12;}

    1176. 

  1176. 			elseif ($score >= 50000) {$expRank[0] = 9;$expRank[1] = 11;}

    1177. 

  1177. 			elseif ($score >= 20000) {$expRank[0] = 7;$expRank[1] = 8;}

    1178. 

  1178. 			elseif ($score >= 8000) {$expRank[0] = 6;$expRank[1] = 6;}

    1179. 

  1179. 			elseif ($score >= 5000) {$expRank[0] = 5;$expRank[1] = 5;}

    1180. 

  1180. 			elseif ($score >= 2500) {$expRank[0] = 4;$expRank[1] = 4;}

    1181. 

  1181. 			elseif ($score >= 800) {$expRank[0] = 3;$expRank[1] = 3;}

    1182. 

  1182. 			elseif ($score >= 500) {$expRank[0] = 2;$expRank[1] = 2;}

    1183. 

  1183. 			elseif ($score >= 150) {$expRank[0] = 1;$expRank[1] = 1;}

    1184. 

  1184. 			else {$expRank[0] = 0;$expRank[1] = 0;}

    1185. 

  1185. 			

    1186. 

  1186. 			// Only update if Rank is less than expected.

    1187. 

  1187. 			if ($rank < $expRank[0] || $rank > $expRank[1]){

    1188. 

  1188. 				// Rank seems to be messed up, will reset to minimum rank for this level

    1189. 

  1189. 				showLog(" -> Rank Correction (".$row['id']."):");

    1190. 

  1190. 				showLog("      Score: ".$score);

    1191. 

  1191. 				showLog("      Expected: ".$expRank[0]."-".$expRank[1]);

    1192. 

  1192. 				showLog("      Found: ".$row['rank']);

    1193. 

  1193. 				showLog("      New Rank: ".$expRank[0]);

    1194. 

  1194. 				

    1195. 

  1195. 				// Update Database

    1196. 

  1196. 				$query = "UPDATE player SET rank = ".$expRank[0]." WHERE id = ".$row['id'];

    1197. 

  1197. 				if (mysql_query($query)) {

    1198. 

  1198. 					showLog(" -> Rank Correction: Success!");

    1199. 

  1199. 				} else {

    1200. 

  1200. 					showLog(" -> Rank Correction: Fail! (".mysql_error().")");

    1201. 

  1201. 				}

    1202. 

  1202. 			}

    1203. 

  1203. 		}

    1204. 

  1204. 		showLog("Done! :)");

    1205. 

  1205. 	} else {

    1206. 

  1206. 		showLog("<font color='red'>ERROR:</font>  No Data Found!");

    1207. 

  1207. 	}

    1208. 

  1208. 	// Close database connection

    1209. 

  1209. 	@mysql_close($connection);

    1210. 

  1210. }

    1211. 

  1211. 

    1212. 

  1212. function processCheckAwards() {

    1213. 

  1213. 	// This script will check for Backend awards

    1214. 

  1214. 	global $cfg;

    1215. 

  1215. 	$connection = @mysql_connect($cfg->get('db_host'), $cfg->get('db_user'), $cfg->get('db_pass'));

    1216. 

  1216. 	@mysql_select_db($cfg->get('db_name'), $connection) or die("Database Error: " . mysql_error());

    1217. 

  1217. 	

    1218. 

  1218. 	// Import Backend Awards Data

    1219. 

  1219. 	require('includes/data.awards.php');

    1220. 

  1220. 	

    1221. 

  1221. 	// Check for Backend Awards Data

    1222. 

  1222. 	if (!isset($backendawardsdata)) {

    1223. 

  1223. $backendawardsdata = array_merge(buildBackendAwardsData('bf2'), buildBackendAwardsData('xpack'));

    1224. 

  1224. 	}

    1225. 

  1225. 	

    1226. 

  1226. 	$startTime = microtime_float();

    1227. 

  1227. 	

    1228. 

  1228. 	$pids_arr = $_POST['selitems'];

    1229. 

  1229. 	

    1230. 

  1230. 	showLog("Checking Player Backend Awards");

    1231. 

  1231. 	$query = "SELECT `id` FROM player";

    1232. 

  1232. 	if ($pids_arr) {

    1233. 

  1233. 		$pids = implode(", ", $pids_arr);

    1234. 

  1234. 		$query .= " WHERE id IN ({$pids})";

    1235. 

  1235. 	} else {

    1236. 

  1236. 		showLog("ERROR:<font color='red'>ERROR:</font> No Players Selected!");

    1237. 

  1237. 		return;

    1238. 

  1238. 	}

    1239. 

  1239. 	$result = mysql_query($query);

    1240. 

  1240. 	if (mysql_num_rows($result)>0) {

    1241. 

  1241. 		while ($rowp = mysql_fetch_array($result)) {

    1242. 

  1242. 			$pid = $rowp['id'];

    1243. 

  1243. 			showLog(" -> Found Player ({$pid})");

    1244. 

  1244. 			

    1245. 

  1245. 			$playerStartTime = microtime_float();

    1246. 

  1246. 			

    1247. 

  1247. 			// Calculate Awards

    1248. 

  1248. 			foreach ($backendawardsdata as $award) {

    1249. 

  1249. 				// Check if Player already has Award

    1250. 

  1250. 				$query = "SELECT awd, level FROM awards WHERE (id = " . $pid . ") AND (awd = {$award[0]})";

    1251. 

  1251. 				$awdresult = mysql_query($query);

    1252. 

  1252. 				if (!$awdresult) {

    1253. 

  1253. 					showLog("<font color='red'>ERROR:</font> " . mysql_error());

    1254. 

  1254. 					showLog("Query String: " . $query);

    1255. 

  1255. 				}

    1256. 

  1256. 				// Check if player has award

    1257. 

  1257. 				if (mysql_num_rows($awdresult)>0) {

    1258. 

  1258. 					$rowawd = mysql_fetch_array($awdresult);

    1259. 

  1259. 				}

    1260. 

  1260. 				

    1261. 

  1261. 				// Check Criteria

    1262. 

  1262. 				$chkcriteria = false;

    1263. 

  1263. 				foreach ($award[3] as $criteria) {

    1264. 

  1264. 					if ($award[2] == 2) {

    1265. 

  1265. 						// Can receive multiple times

    1266. 

  1266. 						if (mysql_num_rows($awdresult)>0) {

    1267. 

  1267. 							$where = str_replace($awards_substr, $rowawd['level']+1, $criteria[3]);

    1268. 

  1268. 						} else {

    1269. 

  1269. 							$where = str_replace($awards_substr, 1, $criteria[3]);

    1270. 

  1270. 						}

    1271. 

  1271. 					} else {

    1272. 

  1272. 						$where = $criteria[3];

    1273. 

  1273. 					}

    1274. 

  1274. 					$query = "SELECT {$criteria[1]} AS checkval FROM {$criteria[0]}\n" .

    1275. 

  1275. 						"WHERE (id = " . $pid . ") AND ({$where})\n" .

    1276. 

  1276. 						"ORDER BY id;";

    1277. 

  1277. 					$chkresult = mysql_query($query);

    1278. 

  1278. 					if (!$chkresult) {

    1279. 

  1279. 						showLog("<font color='red'>ERROR:</font>  ERROR: " . mysql_error() . "\n");

    1280. 

  1280. 						showLog("Query String: " . $query);

    1281. 

  1281. 					}

    1282. 

  1282. 					if (mysql_num_rows($chkresult)>0) {

    1283. 

  1283. 						$rowchk = mysql_fetch_array($chkresult);

    1284. 

  1284. 						if ($rowchk['checkval'] >= $criteria[2]) {

    1285. 

  1285. 							$chkcriteria = true;

    1286. 

  1286. 							break;

    1287. 

  1287. 						} else {

    1288. 

  1288. 							$chkcriteria = false;

    1289. 

  1289. 							break;

    1290. 

  1290. 						}

    1291. 

  1291. 					}

    1292. 

  1292. 				}

    1293. 

  1293. 				

    1294. 

  1294. 				if ($chkcriteria && mysql_num_rows($awdresult) == 0) {

    1295. 

  1295. 					showLog("    - Award Missing ({$award[0]})");

    1296. 

  1296. 					// Insert information

    1297. 

  1297. 					$query = "INSERT INTO awards SET

    1298. 

  1298. 						id = " . $pid . ",

    1299. 

  1299. 						awd = {$award[0]},

    1300. 

  1300. 						level = 1,

    1301. 

  1301. 						earned = " . time() . ",

    1302. 

  1302. 						first = 0;";

    1303. 

  1303. 					if (!mysql_query($query)) {

    1304. 

  1304. 						showLog("<font color='red'>ERROR:</font> " . mysql_error());

    1305. 

  1305. 						showLog("Query String: " . $query);

    1306. 

  1306. 					}

    1307. 

  1307. 				} elseif (!$chkcriteria && mysql_num_rows($awdresult)>0) {

    1308. 

  1308. 					if ($rowawd['awd'] == $award[0]) {

    1309. 

  1309. 						showLog("    - Has Award ({$award[0]}), but does not meet requirements!");

    1310. 

  1310. 						// Delete information

    1311. 

  1311. 						$query = "DELETE FROM awards

    1312. 

  1312. 							WHERE (id = " . $pid . " AND awd = {$award[0]});";

    1313. 

  1313. 						if (!mysql_query($query)) {

    1314. 

  1314. 							showLog("<font color='red'>ERROR:</font> " . mysql_error());

    1315. 

  1315. 							showLog("Query String: " . $query);

    1316. 

  1316. 						}

    1317. 

  1317. 					}

    1318. 

  1318. 				} elseif ($chkcriteria) {

    1319. 

  1319. 					showLog("    - Has Award ({$award[0]}), requirements met!");

    1320. 

  1320. 				}

    1321. 

  1321. 			}

    1322. 

  1322. 			showLog("    Processing Time ({$pid}): " . (microtime_float() - $playerStartTime));

    1323. 

  1323. 		}

    1324. 

  1324. 		showLog("Done! :)");

    1325. 

  1325. 	} else {

    1326. 

  1326. 		showLog("<font color='red'>ERROR:</font>  No Data Found!");

    1327. 

  1327. 	}

    1328. 

  1328. 	// Close database connection

    1329. 

  1329. 	@mysql_close($connection);

    1330. 

  1330. 	showLog("Total Processing Time: " . (microtime_float() - $startTime));

    1331. 

  1331. }

    1332. 

  1332. 

    1333. 

  1333. function processImportLogs() {

    1334. 

  1334. 	// This function will import all existing log files.  This is useful for rebuilding an empty Gamespy database

    1335. 

  1335. 	global $cfg;

    1336. 

  1336. 

    1337. 

  1337. 	// Make Sure Script doesn't timeout

    1338. 

  1338. 	set_time_limit(0);

    1339. 

  1339. 	

    1340. 

  1340. 	// Find Log Files

    1341. 

  1341. 	showLog("Importing Log Files");

    1342. 

  1342. 	$regex = '([0-9]{4})([0-9]{2})([0-9]{2})_([0-9]{4})';

    1343. 

  1343. 		

    1344. 

  1344. 	$dir = opendir(chkPath($cfg->get('stats_logs')));

    1345. 

  1345. 	chdir(chkPath($cfg->get('stats_logs')));

    1346. 

  1346. 	while(($file = readdir($dir)) !== false)

    1347. 

  1347. 	{

    1348. 

  1348. 		if (strpos($file, $cfg->get('stats_ext')))

    1349. 

  1349. 		{

    1350. 

  1350. 			ereg($regex,$file,$sort);

    1351. 

  1351. 			$files[] = $sort[0] . "|" . $file;

    1352. 

  1352. 		}

    1353. 

  1353. 	}

    1354. 

  1354. 	

    1355. 

  1355. 	// Sort Files

    1356. 

  1356. 	sort($files, SORT_STRING);

    1357. 

  1357. 

    1358. 

  1358. 	// Re-post existing log data to bf2statistics

    1359. 

  1359. 	$total = 0;

    1360. 

  1360. 	for ($x = 0; $x < count($files); $x++)

    1361. 

  1361. 	{

    1362. 

  1362. 		$file = explode("|",$files[$x]);

    1363. 

  1363. 		$fh = fsockopen($_SERVER['HTTP_HOST'], 80);

    1364. 

  1364. 		

    1365. 

  1365. 		fwrite($fh, "POST /ASP/bf2statistics.php HTTP/1.1\r\n");

    1366. 

  1366. 		fwrite($fh, "HOST: localhost\r\n");

    1367. 

  1367. 		fwrite($fh, "User-Agent: GameSpyHTTP/1.0\r\n");

    1368. 

  1368. 		fwrite($fh, "Content-Type: application/x-www-form-urlencoded\r\n");

    1369. 

  1369. 		

    1370. 

  1370. 		$filename = @fopen($file[1], 'r');

    1371. 

  1371. 		$data = fread($filename, filesize($file[1]));

    1372. 

  1372. 		@fclose($filename);

    1373. 

  1373. 		

    1374. 

  1374. 		if (strpos($data, '\EOF\1') === false) {

    1375. 

  1375. 			// Older SNAPSHOT.  Insert EOF to ensure bf2statiscs.php processes this...

    1376. 

  1376. 			$data .= '\EOF\1';

    1377. 

  1377. 		}

    1378. 

  1378. 		if (strpos($file[1], "importdata") === false) {

    1379. 

  1379. 			// Make sure we know this is an import of existing log data

    1380. 

  1380. 			$data .= '\import\1';

    1381. 

  1381. 		}

    1382. 

  1382. 		fwrite($fh, "Content-Length: " . strlen($data) . "\r\n\r\n");

    1383. 

  1383. 		fwrite($fh, $data . "\r\n");

    1384. 

  1384. 		fclose($fh);

    1385. 

  1385. 		showLog(" -> Importing $file[1]...done!");

    1386. 

  1386. 		$total++;

    1387. 

  1387. 	}

    1388. 

  1388. 	

    1389. 

  1389. 	showLog("Total files imported: $total");

    1390. 

  1390. }

    1391. 

  1391. 

    1392. 

  1392. function microtime_float() {

    1393. 

  1393. 	list($usec, $sec) = explode(" ", microtime());

    1394. 

  1394. 	return ((float)$usec + (float)$sec);

    1395. 

  1395. }

    1396. 

  1396. 

    1397. 

  1397. ?>

    1398. 

  1398.