From 40dfa7d5c0dc8e4cb2c95e403b6b4b2c4bf70644 Mon Sep 17 00:00:00 2001
From: Matthijs Kuiper <info@matthijskuiper.nl>
Date: Sat, 4 Feb 2017 16:05:45 +0100
Subject: Original UTStats beta 4.2.8

---
 html/pages/admin/recalcranking.php | 77 ++++++++++++++++++++++++++++++++++++++
 1 file changed, 77 insertions(+)
 create mode 100755 html/pages/admin/recalcranking.php

(limited to 'html/pages/admin/recalcranking.php')

diff --git a/html/pages/admin/recalcranking.php b/html/pages/admin/recalcranking.php
new file mode 100755
index 0000000..1cbc865
--- /dev/null
+++ b/html/pages/admin/recalcranking.php
@@ -0,0 +1,77 @@
+<?php
+if (empty($import_adminkey) or isset($_REQUEST['import_adminkey']) or $import_adminkey != $adminkey) die('bla');
+	
+$options['title'] = 'Recalculate Rankings';
+$options['requireconfirmation'] = false;
+$i = 0;
+$options['vars'][$i]['name'] = 'start';
+$options['vars'][$i]['type'] = 'static';
+$options['vars'][$i]['options'] = 'No|Yes';
+$options['vars'][$i]['exitif'] = 'No';
+$options['vars'][$i]['prompt'] = 'Are you sure';
+$options['vars'][$i]['caption'] = 'Sure:';
+$i++;
+
+$results = adminselect($options);
+
+if ($results['start'] != 'Yes') {
+	include('pages/admin/main.php');
+	exit;
+}
+@ignore_user_abort(true);
+@set_time_limit(0);
+
+
+echo'<br><table border="0" cellpadding="1" cellspacing="2" width="600">
+<tr>
+	<td class="smheading" align="center" colspan="2">Recalculating Rankings</td>
+</tr>';
+
+echo'<tr>
+	<td class="smheading" align="left" width="200">Deleting rankings</td>';
+
+	mysql_query("TRUNCATE uts_rank") or die(mysql_error());	
+
+	echo'<td class="grey" align="left" width="400">Done</td>';
+
+echo'</tr>
+<tr>
+	<td class="smheading" align="left">Recalculating Rankings:</td>';
+	echo'<td class="grey" align="left">';
+	$playerbanned = false;
+	$q_pm = mysql_query(	"	SELECT 	p.id, 
+												p.matchid, 
+												p.pid, 
+												p.gid,
+												m.gamename
+									FROM 		uts_player p, 
+												uts_pinfo pi,
+												uts_match m
+									WHERE 	pi.id = p.pid 
+										AND 	pi.banned <> 'Y' 
+										AND	m.id = p.matchid
+									ORDER BY p.matchid ASC, 
+												p.playerid ASC");
+	$i = 0;
+	while ($r_pm = mysql_fetch_array($q_pm)) {
+		$i++;
+		if ($i%50 == 0) {
+			echo '. ';
+			flush();
+		}
+		$playerecordid = $r_pm['id'];
+		$matchid = $r_pm['matchid'];
+		$pid = $r_pm['pid'];
+		$gid = $r_pm['gid'];
+		$gamename = $r_pm['gamename'];
+//		echo "$pid|$gid|$matchid<br>";
+		include('import/import_ranking.php');
+	}
+	echo 'Done</td>
+</tr>
+
+<tr>
+	<td class="smheading" align="center" colspan="2">Rankings recalculated - <a href="./admin.php?key='.$_REQUEST[key].'">Go Back To Admin Page</a></td>
+</tr></table>';
+
+?>
-- 
cgit