1 files changed, 22 insertions, 0 deletions
diff --git a/html/import/import_killsmatrix.php b/html/import/import_killsmatrix.php
new file mode 100755
index 0000000..433a659
--- /dev/null
+++ b/html/import/import_killsmatrix.php
@@ -0,0 +1,22 @@
+<?php
+	$sql_killmatrix = "SELECT 	col2 AS killer, 
+										col4 AS killed, 
+										COUNT(*) AS kills 
+							FROM 		uts_temp_$uid 
+							WHERE 	col1 = 'kill' 
+								OR		col1 = 'teamkill'
+							GROUP BY col2, col4";
+						
+	$q_killmatrix = mysql_query($sql_killmatrix) or die(mysql_error());
+	while ($r_killmatrix = mysql_fetch_array($q_killmatrix)) {
+		
+		$sql =	"	INSERT
+						INTO		uts_killsmatrix
+						SET		matchid 	=	'$matchid',
+									killer	=	'". $r_killmatrix['killer'] ."',
+									victim	=	'". $r_killmatrix['killed'] ."',
+									kills		=	'". $r_killmatrix['kills'] ."';";
+		mysql_query($sql) or die(mysql_error());
+
+	}
+?>