PageRenderTime 40ms CodeModel.GetById 15ms RepoModel.GetById 1ms app.codeStats 0ms

/html/import/import_killsmatrix.php

https://github.com/graywh/utstats
PHP | 22 lines | 19 code | 3 blank | 0 comment | 1 complexity | f5d2f38419a70e898b9ef2087752ab4d MD5 | raw file
  1. <?php
  2. $sql_killmatrix = "SELECT col2 AS killer,
  3. col4 AS killed,
  4. COUNT(*) AS kills
  5. FROM uts_temp_$uid
  6. WHERE col1 = 'kill'
  7. OR col1 = 'teamkill'
  8. GROUP BY col2, col4";
  9. $q_killmatrix = mysql_query($sql_killmatrix) or die(mysql_error());
  10. while ($r_killmatrix = mysql_fetch_array($q_killmatrix)) {
  11. $sql = " INSERT
  12. INTO uts_killsmatrix
  13. SET matchid = '$matchid',
  14. killer = '". $r_killmatrix['killer'] ."',
  15. victim = '". $r_killmatrix['killed'] ."',
  16. kills = '". $r_killmatrix['kills'] ."';";
  17. mysql_query($sql) or die(mysql_error());
  18. }
  19. ?>