header('Content-Type: application/x-javascript; charset=utf8');
include('/var/www/forum/library/config.php');
$name = isset($_GET['name']) ? $_GET['name'] : '';
if (!empty($name)) {
mysql_connect($config['db']['host'], $config['db']['username'], $config['db']['password']);
mysql_select_db($config['db']['dbname2']);
mysql_query ('set character_set_results="utf8"');
$sql = "SELECT `stats_players`.`uuid`, `stats_players`.`name`, `stats_players`.`online`, `stats_players`.`first_login`, `stats_players`.`logins`, `stats_players`.`login_time`, `stats_players`.`playtime`, `stats_players`.`longest_session`, `stats_hook_vault`.`group`, `stats_hook_vault`.`balance` FROM `stats_players` LEFT JOIN `stats_hook_vault` ON `stats_players`.`player_id` = `stats_hook_vault`.`player_id` WHERE `stats_players`.`name` = '{$name}'";
$query = mysql_query($sql);
$data = mysql_fetch_array($query);
// echo json_encode(array('status' => 'successful', 'uuid' => $data['uuid'], 'online' => $data['online'], 'first_login' => $data['first_login'], 'logins' => $data['logins'], 'login_time' => $data['login_time'], 'playtime' => $data['playtime'], 'longest_session' => $data['longest_session'], 'group' => $data['group'], 'balance' => $data['balance']));
$jsonData = json_encode(array('status' => 'successful', 'uuid' => $data['uuid'], 'online' => $data['online'], 'first_login' => $data['first_login'], 'logins' => $data['logins'], 'login_time' => $data['login_time'], 'playtime' => $data['playtime'], 'longest_session' => $data['longest_session'], 'group' => $data['group'], 'balance' => $data['balance']));
// если у нас данные получены в json уже, то мы их конвертируем и работаем с ними как с массивом
echo (json_decode($jsonData));
}
else {
echo json_encode(array('status' => 'error'));
}