From 40dfa7d5c0dc8e4cb2c95e403b6b4b2c4bf70644 Mon Sep 17 00:00:00 2001
From: Matthijs Kuiper <info@matthijskuiper.nl>
Date: Sat, 4 Feb 2017 16:05:45 +0100
Subject: Original UTStats beta 4.2.8

---
 html/import/import_playerstuff.php | 182 +++++++++++++++++++++++++++++++++++++
 1 file changed, 182 insertions(+)
 create mode 100755 html/import/import_playerstuff.php

(limited to 'html/import/import_playerstuff.php')

diff --git a/html/import/import_playerstuff.php b/html/import/import_playerstuff.php
new file mode 100755
index 0000000..73714e4
--- /dev/null
+++ b/html/import/import_playerstuff.php
@@ -0,0 +1,182 @@
+<?php
+	include_once("includes/geoip.inc");
+	$gi = geoip_open("GeoIP.dat",GEOIP_STANDARD);
+
+	// Get the unique ID of this player.
+	// Create a new one if he has none yet.
+	$r_pid = small_query("SELECT id, country, banned FROM uts_pinfo WHERE name = '$playername'");
+	if ($r_pid) {
+		$pid = $r_pid['id'];
+		$pid_country = $r_pid['country'];
+		$playerbanned = ($r_pid['banned'] == 'Y') ? true : false;
+	} else {
+		mysql_query("INSERT INTO uts_pinfo SET name = '$playername'") or die(mysql_error());
+		$pid = mysql_insert_id();
+		$pid_country = false;
+		$playerbanned = false;
+	}
+	$playerid2pid[$playerid] = $pid;
+
+	// Do we import banned players?
+	if ($playerbanned and $import_ban_type == 2) return;
+
+
+	// Did the player do first blood?
+	IF($playerid == $firstblood) {
+		$upd_firstblood = "UPDATE uts_match SET firstblood = '$pid' WHERE id = $matchid";
+		mysql_query($upd_firstblood) or die(mysql_error());
+	}
+
+	// Get player's IP
+	$q_playerip = small_query("SELECT INET_ATON(col4) AS ip FROM uts_temp_$uid WHERE col1 = 'player' AND col2 = 'IP' and col3 = '$playerid' ORDER BY id ASC LIMIT 0,1");
+	$playerip = ($q_playerip) ? $q_playerip['ip'] : 0;
+	if (empty($playerip)) $playerip = 0;
+
+	// Map the IP to a country
+	$playercountry = strtolower(geoip_country_code_by_addr($gi,long2ip($playerip)));
+
+	if ($playercountry != $pid_country)
+	{
+		mysql_query("UPDATE uts_pinfo SET country = '$playercountry' WHERE id = '$pid'") or die(mysql_error());
+	}
+
+
+	// Get Sprees
+	$q_spree_dbl = small_count("SELECT id FROM uts_temp_$uid WHERE col1 = 'spree' AND col2 = 'spree_dbl' AND col3 = '$playerid'");
+	$q_spree_mult = small_count("SELECT id FROM uts_temp_$uid WHERE col1 = 'spree' AND col2 = 'spree_mult' AND col3 = '$playerid'");
+	$q_spree_ult = small_count("SELECT id FROM uts_temp_$uid WHERE col1 = 'spree' AND col2 = 'spree_ult' AND col3 = '$playerid'");
+	$q_spree_mon = small_count("SELECT id FROM uts_temp_$uid WHERE col1 = 'spree' AND col2 = 'spree_mon' AND col3 = '$playerid'");
+
+	$q_spree_kill = small_count("SELECT id FROM uts_temp_$uid WHERE col1 = 'spree' AND col2 = 'spree_kill' AND col3 = '$playerid'");
+	$q_spree_rampage = small_count("SELECT id FROM uts_temp_$uid WHERE col1 = 'spree' AND col2 = 'spree_rampage' AND col3 = '$playerid'");
+	$q_spree_dom = small_count("SELECT id FROM uts_temp_$uid WHERE col1 = 'spree' AND col2 = 'spree_dom' AND col3 = '$playerid'");
+	$q_spree_uns = small_count("SELECT id FROM uts_temp_$uid WHERE col1 = 'spree' AND col2 = 'spree_uns' AND col3 = '$playerid'");
+	$q_spree_god = small_count("SELECT id FROM uts_temp_$uid WHERE col1 = 'spree' AND col2 = 'spree_god' AND col3 = '$playerid'");
+
+
+	// Get Count of Pickups
+	$sql_player7 = "SELECT col2, COUNT(col2) AS pu_count FROM uts_temp_$uid WHERE col1 = 'item_get' AND col3 = $playerid GROUP BY col2";
+	$q_player7 = mysql_query($sql_player7);
+
+	$pu_pads = 0;
+	$pu_armour = 0;
+	$pu_keg = 0;
+	$pu_belt = 0;
+	$pu_amp = 0;
+	$pu_invis = 0;
+
+	while ($r_player7 = mysql_fetch_array($q_player7)) {
+		// Cycle through pickups and see what the player got
+		IF ($r_player7[col2] == "Thigh Pads") { $pu_pads = $r_player7[pu_count]; }
+		IF ($r_player7[col2] == "Body Armor") { $pu_armour = $r_player7[pu_count]; }
+		IF ($r_player7[col2] == "Super Health Pack") { $pu_keg = $r_player7[pu_count]; }
+		IF ($r_player7[col2] == "ShieldBelt") { $pu_belt = $r_player7[pu_count]; }
+		IF ($r_player7[col2] == "Damage Amplifier") { $pu_amp = $r_player7[pu_count]; }
+		IF ($r_player7[col2] == "Invisibility") { $pu_invis = $r_player7[pu_count]; }
+	}
+
+	// Get ping information
+	$r_player9 = small_query("SELECT MIN(col4 * 1) AS lowping, MAX(col4 * 1) AS highping, AVG(col4 * 1) AS avgping FROM uts_temp_$uid WHERE col1 = 'Player' AND col2 = 'Ping' AND col3 = $playerid AND col4 > 0");
+	$lowping = $r_player9[lowping];
+	$highping = $r_player9[highping];
+	$avgping = (int)$r_player9[avgping];
+
+	// People who join at the end error the import, this stops it
+	IF ($lowping == NULL) { $lowping = 0; }
+	IF ($highping == NULL) { $highping = 0; }
+	IF ($avgping == NULL) { $avgping = 0; }
+
+	// Get accuracy, ttl etc
+	$r_acc = 0;
+	$r_deaths = 0;
+	$r_efficiency = 0;
+	$r_frags = 0;
+	$r_kills = 0;
+	$r_teamkills = 0;
+	$r_suicides = 0;
+	$r_tos = 0;
+	$r_ttl = 0;
+
+	$q_acc = small_query("SELECT col4 FROM uts_temp_$uid WHERE col1 = 'stat_player' AND col2 = 'accuracy' AND col3 = $playerid");
+	$q_deaths = small_query("SELECT col4 FROM uts_temp_$uid WHERE col1 = 'stat_player' AND col2 = 'deaths' AND col3 = $playerid");
+	$q_kills = small_query("SELECT col4 FROM uts_temp_$uid WHERE col1 = 'stat_player' AND col2 = 'kills' AND col3 = $playerid");
+	$q_teamkills = small_query("SELECT col4 FROM uts_temp_$uid WHERE col1 = 'stat_player' AND col2 = 'teamkills' AND col3 = $playerid");
+	$q_efficiency = small_query("SELECT col4 FROM uts_temp_$uid WHERE col1 = 'stat_player' AND col2 = 'efficiency' AND col3 = $playerid");
+	$q_suicides = small_query("SELECT col4 FROM uts_temp_$uid WHERE col1 = 'stat_player' AND col2 = 'suicides' AND col3 = $playerid");
+	$q_tos = small_query("SELECT col4 FROM uts_temp_$uid WHERE col1 = 'stat_player' AND col2 = 'time_on_server' AND col3 = $playerid");
+	$q_ttl = small_query("SELECT col4 FROM uts_temp_$uid WHERE col1 = 'stat_player' AND col2 = 'ttl' AND col3 = $playerid");
+	$q_score = small_query("SELECT col4 FROM uts_temp_$uid WHERE col1 = 'stat_player' AND col2 = 'score' AND col3 = $playerid");
+
+	IF ($teamgame == "True") {
+		$r_kills = $q_kills[col4];
+		$r_teamkills = $q_teamkills[col4];
+	}
+	IF ($teamgame == "False") {
+		$r_kills = $q_kills[col4] + $q_teamkills[col4];
+		$r_teamkills = 0;
+	}
+
+	$r_acc = get_dp($q_acc[col4]);
+	$r_efficiency = get_dp($q_efficiency[col4]);
+	$r_deaths = $q_deaths[col4];
+	$r_suicides = $q_suicides[col4];
+	$r_frags = $r_kills-$r_suicides-$r_teamkills;
+
+	$r_tos = get_dp($q_tos[col4]);
+	// time on server can't be longer then the server game time!
+	if ($r_tos > $servergametime) {
+		$r_tos = get_dp($servergametime);
+	}
+	$r_ttl = get_dp($q_ttl[col4]);
+	$r_score = $q_score[col4];
+
+	// Generate player record
+	$sql_playerid = "	INSERT
+							INTO		uts_player
+							SET		matchid = '$matchid',
+										playerid = '$playerid',
+										pid = '$pid',
+										team = '$playerteam',
+										gid = '$gid',
+										insta = '$gameinsta',
+										country = '$playercountry',
+										ip = '$playerip',
+
+
+										spree_double = '$q_spree_dbl',
+										spree_multi = '$q_spree_mult',
+										spree_ultra = '$q_spree_ult',
+										spree_monster = '$q_spree_mon',
+										spree_kill = '$q_spree_kill',
+										spree_rampage = '$q_spree_rampage',
+										spree_dom = '$q_spree_dom',
+										spree_uns = '$q_spree_uns',
+										spree_god = '$q_spree_god',
+
+										pu_pads = '$pu_pads',
+										pu_armour = '$pu_armour',
+										pu_keg = '$pu_keg',
+										pu_belt = '$pu_belt',
+										pu_amp = '$pu_amp',
+										pu_invis = '$pu_invis',
+
+										lowping = '$lowping',
+										highping = '$highping',
+										avgping = '$avgping',
+
+										accuracy = '$r_acc',
+										frags = '$r_frags',
+										deaths = '$r_deaths',
+										kills = '$r_kills',
+										suicides = '$r_suicides',
+										teamkills = '$r_teamkills',
+										eff = '$r_efficiency',
+										gametime = '$r_tos',
+										ttl = '$r_ttl',
+										gamescore= '$r_score'";
+
+	$q_playerid = mysql_query($sql_playerid) or die(mysql_error());
+	$playerecordid = mysql_insert_id();
+
+
+?>
-- 
cgit