<?php

ob_start("ob_gzhandler");

header("Content-Type: text/plain");

$id = strtoupper($_GET["id"]);

$db_host="127.0.0.1";

$db_user="";

$db_pass="";

$db_name="";

$db_connection = mysql_connect($db_host, $db_user, $db_pass);

if (!$db_connection) {

  exit;

}

mysql_select_db($db_name);

$stats_card_table_query  = "SELECT * FROM `jailbreak_stats-cs` WHERE steamid = '$id'";

$stats_card_table_result = mysql_query($stats_card_table_query);

$stats_card_table_row = mysql_fetch_array($stats_card_table_result, MYSQL_ASSOC);

if(!empty($id) && isset($stats_card_table_row['steamid'][$id])) {

  $stats_name=$stats_card_table_row['nick'];

  $stats_steamid=$id;

  $stats_rank=$stats_card_table_row['position'];

  $totalranks_query = mysql_query("SELECT * FROM `stuff__jailbreak_stats-cs` ORDER BY position DESC LIMIT 1");

  $totalranks = mysql_fetch_array($totalranks_query, MYSQL_ASSOC);

  $stats_kills=$stats_card_table_row['frags'];

  $stats_deaths=$stats_card_table_row['deaths'];

  $stats_shots=$stats_card_table_row['shots'];

  $stats_headshots=$stats_card_table_row['headshots'];

  $stats_money=$stats_card_table_row['bankbalance'];

  echo "$stats_name\",\"$stats_steamid\",\"$stats_rank\",\"{$totalranks['position']}\",\"$stats_kills\",\"$stats_deaths\",\"$stats_shots\",\"$stats_headshots\",\"$stats_money";

}

else {

  mysql_close($db_connection);

  exit();

}

mysql_close($db_connection);

?>