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_ctf.php | |
Original UTStats beta 4.2.84.2.8
Diffstat (limited to 'html/import/import_ctf.php')
| -rwxr-xr-x | html/import/import_ctf.php | 43 |
1 files changed, 43 insertions, 0 deletions
diff --git a/html/import/import_ctf.php b/html/import/import_ctf.php new file mode 100755 index 0000000..206cbb0 --- /dev/null +++ b/html/import/import_ctf.php @@ -0,0 +1,43 @@ +<?php
+// Get Player Flag Events Count
+ $sql_playerctf = "SELECT col1, COUNT(col1) AS flag_count FROM uts_temp_$uid WHERE (col1 LIKE 'flag_%' OR col1 = 'cover' OR col1 = 'seal') AND col2 = $playerid GROUP BY col1";
+ $q_playerctf = mysql_query($sql_playerctf);
+
+ $flag_taken = 0;
+ $flag_dropped = 0;
+ $flag_return = 0;
+ $flag_capture = 0;
+ $flag_cover = 0;
+ $flag_seal = 0;
+ $flag_assist = 0;
+ $flag_kill = 0;
+ $flag_pickedup = 0;
+
+ while ($r_playerctf = mysql_fetch_array($q_playerctf)) {
+
+ // Cycle through events and see what the player got
+
+ IF ($r_playerctf[col1] == "flag_taken") { $flag_taken = $r_playerctf[flag_count]; }
+ IF ($r_playerctf[col1] == "flag_dropped") { $flag_dropped = $r_playerctf[flag_count]; }
+ IF ($r_playerctf[col1] == "flag_returned") { $flag_return = $r_playerctf[flag_count]; }
+ IF ($r_playerctf[col1] == "flag_captured") { $flag_capture = $r_playerctf[flag_count]; }
+ IF ($r_playerctf[col1] == "flag_cover" or $r_playerctf[col1] == "Flag_cover" or $r_playerctf[col1] == "cover") { $flag_cover = $r_playerctf[flag_count]; }
+ IF ($r_playerctf[col1] == "flag_seal" or $r_playerctf[col1] == "Flag_seal" or $r_playerctf[col1] == "seal") { $flag_seal = $r_playerctf[flag_count]; }
+ IF ($r_playerctf[col1] == "flag_assist" or $r_playerctf[col1] == "Flag_assist") { $flag_assist = $r_playerctf[flag_count]; }
+ IF ($r_playerctf[col1] == "flag_kill" or $r_playerctf[col1] == "Flag_kill") { $flag_kill = $r_playerctf[flag_count]; }
+ IF ($r_playerctf[col1] == "flag_pickedup" or $r_playerctf[col1] == "flag_pickedup") { $flag_pickedup = $r_playerctf[flag_count]; }
+ }
+
+ $sql_playerflags = " UPDATE uts_player
+ SET flag_taken = $flag_taken,
+ flag_dropped = $flag_dropped,
+ flag_return = $flag_return,
+ flag_capture = $flag_capture,
+ flag_cover = $flag_cover,
+ flag_seal = $flag_seal,
+ flag_assist = $flag_assist,
+ flag_kill = $flag_kill,
+ flag_pickedup = $flag_pickedup
+ WHERE id = $playerecordid";
+ mysql_query($sql_playerflags) or die(mysql_error());
+?>
|