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/import/import_killsmatrix.php | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)
 create mode 100755 html/import/import_killsmatrix.php

(limited to 'html/import/import_killsmatrix.php')

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());
+
+	}
+?>
-- 
cgit