/html/import/import_playerstuff.php

<?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 and Head Shots

	$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'");



	$q_headshots = small_count("SELECT id FROM uts_temp_$uid WHERE col1 = 'headshot' AND col2 = '$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;

	$pu_boots = 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]; }

		IF ($r_player7[col2] == "AntiGrav Boots") { $pu_boots = $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]);

	$r_ttl = get_dp($q_ttl[col4]);

	$r_score = $q_score[col4];



  // Get "real" TTL

  $r_ttl = $r_tos / ($r_deaths + $r_suicides + 1);



	// 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',



									headshots = '$q_headshots',

									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',

									pu_boots = '$pu_boots',



									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();





?>