PageRenderTime 48ms CodeModel.GetById 25ms RepoModel.GetById 0ms app.codeStats 0ms

/html/import/import_ass.php

https://github.com/graywh/utstats
PHP | 34 lines | 22 code | 8 blank | 4 comment | 2 complexity | c1318b695bd828107148382b3f4c8c35 MD5 | raw file
  1. <?php
  2. // Who did the objectives
  3. $r_assobj = small_query("SELECT count(id) AS assobjcount FROM uts_temp_$uid WHERE col1 = 'assault_obj' AND col2 = $playerid");
  4. $assobjcount = $r_assobj[assobjcount];
  5. $upd_assobj = "UPDATE uts_player SET ass_obj = $assobjcount WHERE id = $playerecordid";
  6. mysql_query($upd_assobj) or die(mysql_error());
  7. // Get assault game code (unique code give for the 2 games played)
  8. $r_asscode = small_query("SELECT col2 FROM uts_temp_$uid WHERE col1 = 'assault_gamecode' LIMIT 0,1");
  9. $asscode = $r_asscode[col2];
  10. $updateasscode = "UPDATE uts_match SET assaultid = '$asscode' WHERE id = $matchid";
  11. mysql_query($updateasscode) or die(mysql_error());
  12. // Get Which Teams Attacking
  13. $r_assteam = small_query("SELECT col2 FROM uts_temp_$uid WHERE col1 = 'assault_attacker' LIMIT 0,1");
  14. $assteam = $r_assteam[col2];
  15. $updateassteam = "UPDATE uts_match SET ass_att = $assteam WHERE id = $matchid;";
  16. mysql_query($updateassteam) or die(mysql_error());
  17. // Did they do it?
  18. $sql_asswin = "SELECT col0 FROM uts_temp_$uid WHERE col1 = 'game_end' AND col2 = 'Assault succeeded!' LIMIT 0,1";
  19. $q_asswin = mysql_query($sql_asswin) or die(mysql_error());
  20. $asswin = 0;
  21. while ($r_asswin = mysql_fetch_array($q_asswin)) {
  22. IF ($r_asswin[col0] != NULL ) { $asswin = 1; }
  23. }
  24. $updateasswin = "UPDATE uts_match SET ass_win = $asswin WHERE id = $matchid;";
  25. mysql_query($updateasswin) or die(mysql_error());
  26. ?>