diff options
| author | Matthijs Kuiper <info@matthijskuiper.nl> | 2017-02-04 16:05:45 +0100 |
|---|---|---|
| committer | Matthijs Kuiper <info@matthijskuiper.nl> | 2017-02-04 16:05:45 +0100 |
| commit | 40dfa7d5c0dc8e4cb2c95e403b6b4b2c4bf70644 (patch) | |
| tree | 6ac6279ac26749ffe7ca0ae9603fbcae2e757e6e /html/import/import_killsmatrix.php | |
Original UTStats beta 4.2.84.2.8
Diffstat (limited to 'html/import/import_killsmatrix.php')
| -rwxr-xr-x | html/import/import_killsmatrix.php | 22 |
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());
+
+ }
+?>
|