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_jailbreak.php |
Original UTStats beta 4.2.84.2.8
Diffstat (limited to 'html/import/import_jailbreak.php')
-rwxr-xr-x | html/import/import_jailbreak.php | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/html/import/import_jailbreak.php b/html/import/import_jailbreak.php new file mode 100755 index 0000000..6d6e0da --- /dev/null +++ b/html/import/import_jailbreak.php @@ -0,0 +1,22 @@ +<?php
+// Get team releases
+ $q_releases = small_query("SELECT COUNT(*) AS releases FROM uts_temp_$uid WHERE col1 = 'team_released' AND col3 = $playerid");
+ $r_releases = $q_releases['releases'];
+
+// Get the real suicide count
+// (Jail releases should not be counted as suicides)
+ $q_suicides = small_query("SELECT COUNT(*) AS suicides FROM uts_temp_$uid WHERE col1 = 'suicide' AND col2 = $playerid and col4 <> 'RedeemerDeath' and col4 <> 'JailRelease'");
+ $r_suicides = $q_suicides['suicides'];
+
+ $r_frags = $r_kills - $r_suicides;
+ $r_efficiency = get_dp(($r_kills / ($r_kills + $r_deaths + $r_suicides + $r_teamkills)) * 100);
+
+
+ mysql_query(" UPDATE uts_player
+ SET ass_obj = '$r_releases',
+ suicides = '$r_suicides',
+ frags = '$r_frags',
+ eff = '$r_efficiency'
+ WHERE id = $playerecordid;") or die(mysql_error());
+
+?>
\ No newline at end of file |