getstat.php

<?php

header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: GET, POST');

//mysql_connect("localhost", "root", "");
//mysql_select_db("exmv6");

mysql_connect("localhost", "roydl7", "lolwtf");
mysql_select_db("exmv6");


$query = array(
"SELECT `playerNick` as itemName, `kills`  as itemValue FROM exm_player_acc_data, exm_player_sts_data WHERE exm_player_acc_data.playerAccID = exm_player_sts_data.accID ORDER BY exm_player_sts_data.`kills` DESC LIMIT 100",
"SELECT `playerNick` as itemName, `deaths` as itemValue FROM exm_player_acc_data, exm_player_sts_data WHERE exm_player_acc_data.playerAccID = exm_player_sts_data.accID ORDER BY exm_player_sts_data.`deaths` DESC LIMIT 100",
"SELECT `playerNick` as itemName, `points` as itemValue FROM exm_player_acc_data, exm_player_sts_data WHERE exm_player_acc_data.playerAccID = exm_player_sts_data.accID ORDER BY exm_player_sts_data.`points` DESC LIMIT 100",
"SELECT `playerNick` as itemName, `cash`   as itemValue FROM exm_player_acc_data, exm_player_sts_data WHERE exm_player_acc_data.playerAccID = exm_player_sts_data.accID AND exm_player_sts_data.timePlayed > 86400 ORDER BY exm_player_sts_data.`cash` DESC LIMIT 100",
"SELECT `playerNick` as itemName, `timePlayed`   as itemValue FROM exm_player_acc_data, exm_player_sts_data WHERE exm_player_acc_data.playerAccID = exm_player_sts_data.accID ORDER BY exm_player_sts_data.`timePlayed` DESC LIMIT 100",
"SELECT `playerNick` as itemName, `kills`/`deaths` as itemValue FROM exm_player_acc_data, exm_player_sts_data WHERE exm_player_acc_data.playerAccID = exm_player_sts_data.accID AND exm_player_sts_data.timePlayed > 86400 ORDER BY exm_player_sts_data.kills/exm_player_sts_data.deaths DESC LIMIT 100",
"SELECT `playerNick` as itemName, `reactionTestWin`  as itemValue FROM exm_player_acc_data, exm_player_sts_data WHERE exm_player_acc_data.playerAccID = exm_player_sts_data.accID ORDER BY exm_player_sts_data.`reactionTestWin` DESC LIMIT 100",
"SELECT * FROM (SELECT exm_player_acc_data.playerNick as itemName, COUNT( * ) as itemValue, exm_player_kd_logs.spawnid as streakID, exm_player_acc_data.playerAccID FROM exm_player_acc_data, `exm_player_kd_logs`, exm_player_sts_data WHERE exm_player_kd_logs.killeraccid = exm_player_acc_data.playerAccId AND exm_player_sts_data.accid = exm_player_acc_data.playerAccId AND exm_player_sts_data.rank > 2 AND spawnid > 0 GROUP BY exm_player_kd_logs.spawnid, exm_player_acc_data.playerAccID ORDER BY COUNT( * )DESC LIMIT 250) AS temp GROUP BY itemName ORDER BY itemValue DESC LIMIT 100"
);



$result = "";
if(isset($_GET['detailed_streaks'])) {

	$query = "SELECT `exm_player_kd_logs`.timestamp, `exm_player_kd_logs`.reason, `exm_player_acc_data`.playerNick, `exm_player_kd_logs`.missionid, `exm_mission_list`.name FROM `exm_player_kd_logs`, `exm_player_acc_data`,`exm_mission_list` WHERE `exm_player_acc_data`.playerAccId = `exm_player_kd_logs`.playeraccid AND `exm_player_kd_logs`.missionid = `exm_mission_list`.id AND spawnid = " . $_GET['detailed_streaks'] . " ORDER BY reason ASC";
	$result = mysql_query($query);
}

else {
	$result = mysql_query($query[$_GET['item']]);
}

$results = array();
while($row = mysql_fetch_assoc($result))
{
	$results[] = $row;
}

echo json_encode($results);
?>