} if ($_GET["timeStamp_begin"] != "") { $scoreQuery .= "and timeStamp >= \"" . $_GET["timeStamp_begin"] . "\" "; } if ($_GET["timeStamp_end"] != "") { $scoreQuery .= "and timeStamp <= \"" . $_GET["timeStamp_end"] . "\" "; } $scoreQuery .= " GROUP BY timeStamp, map_scores.match_id;"; // // // $resultSet = $conn->query($scoreQuery); if ($resultSet->rowCount() == 0) { die("<b>No data returned.</b>"); } $resultSet = new ArrayIterator($resultSet->fetchAll()); $redName = $conn->query("SELECT name FROM server_info INNER JOIN match_details ON red_srv=srv_id WHERE match_id = \"" . $_GET["region"] . "-" . $_GET["match_num"] . "\" AND week_num = \"" . $_GET["week_num"] . "\";"); $blueName = $conn->query("SELECT name FROM server_info INNER JOIN match_details ON blue_srv=srv_id WHERE match_id = \"" . $_GET["region"] . "-" . $_GET["match_num"] . "\" AND week_num = \"" . $_GET["week_num"] . "\";"); $greenName = $conn->query("SELECT name FROM server_info INNER JOIN match_details ON green_srv=srv_id WHERE match_id = \"" . $_GET["region"] . "-" . $_GET["match_num"] . "\" AND week_num = \"" . $_GET["week_num"] . "\";"); echo "<center><table border=\"1\"><tr><td style=\"padding:8px\" bgcolor=\"#00cc00\">" . $greenName->fetchColumn() . "</td><td>|</td><td style=\"padding:8px\" bgcolor=\"#3399ff\">" . $blueName->fetchColumn() . "</td><td>|</td><td style=\"padding:8px\" bgcolor=\"#ff5050\">" . $redName->fetchColumn() . "</td></tr></table></center>"; echo "<table><tr><td>"; generate_googleChart(generate_jsontable($resultSet, array("Green PPT", "Blue PPT", "Red PPT")), "PPT", "ppt_chart"); echo "</td><td>"; generate_googleChart(generate_jsontable($resultSet, array("Green Score", "Blue Score", "Red Score")), "Scores", "score_chart"); echo "</td></tr><tr><td>"; generate_googleChart(generate_jsontable($resultSet, array("Green Kills", "Blue Kills", "Red Kills")), "Kills", "kills_chart"); echo "</td><td>"; generate_googleChart(generate_jsontable($resultSet, array("Green Deaths", "Blue Deaths", "Red Deaths")), "Deaths", "deaths_chart"); echo "</td></tr><tr><td>"; generate_googleChart(generate_jsontable($resultSet, array("Green KD%", "Blue KD%", "Red KD%")), "KD Ratio", "kd_chart"); ?>