/html/import/import_dom.php
PHP | 17 lines | 13 code | 2 blank | 2 comment | 2 complexity | 86d8dc0772a71b47442748bca2a7d95f MD5 | raw file
- <?php
- // Get dom player scores
- $sql_domplayer = "SELECT col3 FROM uts_temp_$uid WHERE col1 = 'dom_playerscore_update' AND col2 = $playerid ORDER BY id DESC LIMIT 0,1";
- $q_domplayer = mysql_query($sql_domplayer) or die(mysql_error());
- $r_domplayer = mysql_fetch_array($q_domplayer);
- $domplayer = $r_domplayer[col3];
- if ($domplayer == null) $domplayer = 0;
- $updatedomplayer = "UPDATE uts_player SET dom_pts = $domplayer WHERE id = $playerecordid";
- mysql_query($updatedomplayer) or die(mysql_error());
-
- // Who did the control points
- $r_domcp = small_query("SELECT count(id) AS domcpcount FROM uts_temp_$uid WHERE col1 = 'controlpoint_capture' AND col3 = $playerid");
- $domcpcount = $r_domcp[domcpcount];
- $upd_domcp = "UPDATE uts_player SET dom_cp = $domcpcount WHERE id = $playerecordid";
- mysql_query($upd_domcp) or die(mysql_error());
-
- ?>