summaryrefslogtreecommitdiff
path: root/html/import/import_pcleanup.php
diff options
context:
space:
mode:
Diffstat (limited to 'html/import/import_pcleanup.php')
-rwxr-xr-xhtml/import/import_pcleanup.php256
1 files changed, 256 insertions, 0 deletions
diff --git a/html/import/import_pcleanup.php b/html/import/import_pcleanup.php
new file mode 100755
index 0000000..3e1be8a
--- /dev/null
+++ b/html/import/import_pcleanup.php
@@ -0,0 +1,256 @@
+<?php
+$sql_tgame = small_query("SELECT teamgame FROM uts_match WHERE id = $matchid");
+IF($sql_tgame == "True") {
+ $rem_srecord = "DELETE FROM uts_player WHERE matchid = $matchid AND team > 3";
+ mysql_query($rem_srecord);
+}
+
+$cleaned = false;
+// Get list of players
+$sql_pname = "SELECT pid, name FROM uts_player, uts_pinfo AS pi WHERE matchid = $matchid AND pid = pi.id";
+$q_pname = mysql_query($sql_pname);
+while ($r_pname = mysql_fetch_array($q_pname)) {
+ $playername = addslashes($r_pname[name]);
+ $pid = $r_pname['pid'];
+
+
+ // Check if player has more than 1 record
+ $q_ids = mysql_query("SELECT playerid FROM uts_player WHERE pid = '$pid' AND matchid = $matchid");
+
+ IF (mysql_num_rows($q_ids) > 1) {
+ $numrecords = mysql_num_rows($q_ids);
+ echo $r_pname[name] .' ';
+ // get all the ids this player had
+ $playerids = array();
+ while ($r_ids = mysql_fetch_array($q_ids)) {
+ $playerids[] = $r_ids['playerid'];
+ }
+
+ $r_newplayerid = small_query("SELECT (MAX(playerid) + 1) AS newplayerid FROM uts_player WHERE matchid = $matchid");
+ $newplayerid = $r_newplayerid['newplayerid'];
+
+ // Fix the events table
+ foreach ($playerids as $i => $oldplayerid) {
+ mysql_query("UPDATE uts_events SET playerid = $newplayerid WHERE playerid = $oldplayerid AND matchid = $matchid");
+ }
+
+ // Fix matchcount in ranking table
+ // mysql_query("UPDATE uts_rank SET matches = matches - ". ($numrecords - 1) ." WHERE pid = '$pid' AND gid = '$gid'") or die(mysql_error());
+
+ // ***********************
+ // UPDATE THE KILLS MATRIX
+ $sql_kmupdate = " SELECT victim,
+ SUM(kills) AS kills
+ FROM uts_killsmatrix
+ WHERE matchid = $matchid
+ AND killer IN (". implode(",", $playerids) .")
+ GROUP BY victim;";
+
+ $q_kmupdate = mysql_query($sql_kmupdate);
+ while ($r_kmupdate = mysql_fetch_array($q_kmupdate)) {
+ mysql_query(" INSERT
+ INTO uts_killsmatrix
+ SET matchid = $matchid,
+ killer = $newplayerid,
+ victim = ${r_kmupdate['victim']},
+ kills = ${r_kmupdate['kills']};");
+ }
+
+ $sql_kmupdate = " SELECT killer,
+ SUM(kills) AS kills
+ FROM uts_killsmatrix
+ WHERE matchid = $matchid
+ AND victim IN (". implode(",", $playerids) .")
+ GROUP BY killer;";
+
+ $q_kmupdate = mysql_query($sql_kmupdate);
+ while ($r_kmupdate = mysql_fetch_array($q_kmupdate)) {
+ mysql_query(" INSERT
+ INTO uts_killsmatrix
+ SET matchid = $matchid,
+ killer = ${r_kmupdate['killer']},
+ victim = $newplayerid,
+ kills = ${r_kmupdate['kills']};");
+ }
+
+ mysql_query(" DELETE
+ FROM uts_killsmatrix
+ WHERE matchid = $matchid
+ AND (killer IN (". implode(",", $playerids) .")
+ OR victim IN (". implode(",", $playerids) ."));");
+
+
+ // FINISHED UPDATING THE KILLS MATRiX
+ // **********************************
+
+
+ // Get non summed information
+
+ $r_truepinfo1 = small_query("SELECT insta, pid, team, isabot, country, ip, gid FROM uts_player WHERE pid = '$pid' AND matchid = $matchid LIMIT 0,1");
+ // fix rejoin as spec
+ if ($r_treupinfo1['team'] == 255) {
+ $r_trueteam = small_query("SELECT team FROM uts_player WHERE pid = '$pid' AND matchid = $matchid AND team != 255 LIMIT 0,1");
+ if ($r_trueteam['team'] < 255) {
+ $r_truepinfo1['team'] = $r_trueteam['team'];
+ }
+ }
+
+ // Group Player Stuff so we only have 1 player record per match
+ if ($gamename == "Bunny Track") {
+ // In bunnytrack the gamescore is 2000 - fastest time in seconds so use MAX gamescore rather then SUM
+ $r_truepinfo2 = small_query("SELECT
+ SUM(gametime) AS gametime,
+ MAX(gamescore) AS gamescore,
+ AVG(lowping) AS lowping,
+ AVG(highping) AS highping,
+ AVG(avgping) AS avgping,
+ SUM(frags) AS frags,
+ SUM(deaths) AS deaths,
+ SUM(kills) AS kills,
+ SUM(suicides) AS suicides,
+ SUM(teamkills) AS teamkills,
+ AVG(eff) AS eff,
+ AVG(accuracy) AS accuracy,
+ AVG(ttl) AS ttl,
+ SUM(flag_taken) AS flag_taken,
+ SUM(flag_pickedup) AS flag_pickedup,
+ SUM(flag_dropped) AS flag_dropped,
+ SUM(flag_return) AS flag_return,
+ SUM(flag_capture) AS flag_capture,
+ SUM(flag_cover) AS flag_cover,
+ SUM(flag_seal) AS flag_seal,
+ SUM(flag_assist) AS flag_assist,
+ SUM(flag_kill) AS flag_kill,
+ SUM(dom_cp) AS dom_cp,
+ SUM(ass_obj) AS ass_obj,
+ SUM(spree_double) AS spree_double,
+ SUM(spree_triple) AS spree_triple,
+ SUM(spree_multi) AS spree_multi,
+ SUM(spree_mega) AS spree_mega,
+ SUM(spree_ultra) AS spree_ultra,
+ SUM(spree_monster) AS spree_monster,
+ SUM(spree_kill) AS spree_kill,
+ SUM(spree_rampage) AS spree_rampage,
+ SUM(spree_dom) AS spree_dom,
+ SUM(spree_uns) AS spree_uns,
+ SUM(spree_god) AS spree_god,
+ SUM(pu_pads) AS pu_pads,
+ SUM(pu_armour) AS pu_armour,
+ SUM(pu_keg) AS pu_keg,
+ SUM(pu_invis) AS pu_invis,
+ SUM(pu_belt) AS pu_belt,
+ SUM(pu_amp) AS pu_amp,
+ SUM(rank) AS rank
+ FROM uts_player WHERE matchid = $matchid AND pid = '$pid'");
+ }
+ else {
+ $r_truepinfo2 = small_query("SELECT
+ SUM(gametime) AS gametime,
+ SUM(gamescore) AS gamescore,
+ AVG(lowping) AS lowping,
+ AVG(highping) AS highping,
+ AVG(avgping) AS avgping,
+ SUM(frags) AS frags,
+ SUM(deaths) AS deaths,
+ SUM(kills) AS kills,
+ SUM(suicides) AS suicides,
+ SUM(teamkills) AS teamkills,
+ AVG(eff) AS eff,
+ AVG(accuracy) AS accuracy,
+ AVG(ttl) AS ttl,
+ SUM(flag_taken) AS flag_taken,
+ SUM(flag_pickedup) AS flag_pickedup,
+ SUM(flag_dropped) AS flag_dropped,
+ SUM(flag_return) AS flag_return,
+ SUM(flag_capture) AS flag_capture,
+ SUM(flag_cover) AS flag_cover,
+ SUM(flag_seal) AS flag_seal,
+ SUM(flag_assist) AS flag_assist,
+ SUM(flag_kill) AS flag_kill,
+ SUM(dom_cp) AS dom_cp,
+ SUM(ass_obj) AS ass_obj,
+ SUM(spree_double) AS spree_double,
+ SUM(spree_triple) AS spree_triple,
+ SUM(spree_multi) AS spree_multi,
+ SUM(spree_mega) AS spree_mega,
+ SUM(spree_ultra) AS spree_ultra,
+ SUM(spree_monster) AS spree_monster,
+ SUM(spree_kill) AS spree_kill,
+ SUM(spree_rampage) AS spree_rampage,
+ SUM(spree_dom) AS spree_dom,
+ SUM(spree_uns) AS spree_uns,
+ SUM(spree_god) AS spree_god,
+ SUM(pu_pads) AS pu_pads,
+ SUM(pu_armour) AS pu_armour,
+ SUM(pu_keg) AS pu_keg,
+ SUM(pu_invis) AS pu_invis,
+ SUM(pu_belt) AS pu_belt,
+ SUM(pu_amp) AS pu_amp,
+ SUM(rank) AS rank
+ FROM uts_player WHERE matchid = $matchid AND pid = '$pid'");
+ }
+
+ // Remove all of this player's records
+ $rem_precord = "DELETE FROM uts_player WHERE matchid = $matchid AND pid = '$pid'";
+ mysql_query($rem_precord);
+
+ // Add this new record to match
+ $upd_precord = " INSERT
+ INTO uts_player
+ SET matchid = $matchid,
+ insta = '$r_truepinfo1[insta]',
+ playerid = '$newplayerid',
+ pid = '$pid',
+ team = '$r_truepinfo1[team]',
+ isabot = '$r_truepinfo1[isabot]',
+ country = '$r_truepinfo1[country]',
+ ip = '$r_truepinfo1[ip]',
+ gid = '$r_truepinfo1[gid]',
+ gametime = '$r_truepinfo2[gametime]',
+ gamescore = '$r_truepinfo2[gamescore]',
+ lowping = '".(int)$r_truepinfo2[lowping]."',
+ highping = '".(int)$r_truepinfo2[highping]."',
+ avgping = '".(int)$r_truepinfo2[avgping]."',
+ frags = '$r_truepinfo2[frags]',
+ deaths = '$r_truepinfo2[deaths]',
+ kills = '$r_truepinfo2[kills]',
+ suicides = '$r_truepinfo2[suicides]',
+ teamkills = '$r_truepinfo2[teamkills]',
+ eff = '$r_truepinfo2[eff]',
+ accuracy = '$r_truepinfo2[accuracy]',
+ ttl = '$r_truepinfo2[ttl]',
+ flag_taken = '$r_truepinfo2[flag_taken]',
+ flag_dropped = '$r_truepinfo2[flag_dropped]',
+ flag_return = '$r_truepinfo2[flag_return]',
+ flag_capture = '$r_truepinfo2[flag_capture]',
+ flag_cover = '$r_truepinfo2[flag_cover]',
+ flag_seal = '$r_truepinfo2[flag_seal]',
+ flag_assist = '$r_truepinfo2[flag_assist]',
+ flag_kill = '$r_truepinfo2[flag_kill]',
+ flag_pickedup = '$r_truepinfo2[flag_pickedup]',
+ dom_cp = '$r_truepinfo2[dom_cp]',
+ ass_obj = '$r_truepinfo2[ass_obj]',
+ spree_double = '$r_truepinfo2[spree_double]',
+ spree_triple = '$r_truepinfo2[spree_triple]',
+ spree_multi = '$r_truepinfo2[spree_multi]',
+ spree_mega = '$r_truepinfo2[spree_mega]',
+ spree_ultra = '$r_truepinfo2[spree_ultra]',
+ spree_monster = '$r_truepinfo2[spree_monster]',
+ spree_kill = '$r_truepinfo2[spree_kill]',
+ spree_rampage = '$r_truepinfo2[spree_rampage]',
+ spree_dom = '$r_truepinfo2[spree_dom]',
+ spree_uns = '$r_truepinfo2[spree_uns]',
+ spree_god = '$r_truepinfo2[spree_god]',
+ pu_pads = '$r_truepinfo2[pu_pads]',
+ pu_armour = '$r_truepinfo2[pu_armour]',
+ pu_keg = '$r_truepinfo2[pu_keg]',
+ pu_invis = '$r_truepinfo2[pu_invis]',
+ pu_belt = '$r_truepinfo2[pu_belt]',
+ pu_amp = '$r_truepinfo2[pu_amp]',
+ rank = '$r_truepinfo2[rank]';";
+ mysql_query($upd_precord) or die(mysql_error());
+ $cleaned = true;
+ }
+}
+if ($cleaned and $html) echo "<br />";
+?> \ No newline at end of file
generated by cgit (git 2.34.1) at 2025-06-15 14:32:02 +0000