diff options
Diffstat (limited to 'html/import/import_playerstuff.php')
| -rwxr-xr-x | html/import/import_playerstuff.php | 182 |
1 files changed, 182 insertions, 0 deletions
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();
+
+
+?>
|