/html/import/import_killsmatrix.php
PHP | 22 lines | 19 code | 3 blank | 0 comment | 1 complexity | f5d2f38419a70e898b9ef2087752ab4d MD5 | raw file
- <?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());
-
- }
- ?>