echo "</select></td></tr>";
createDateTime("Last seized", "last_flipped_begin", "last_flipped_end");
createDateTime("Claimed at", "claimed_at_begin", "claimed_at_end");
echo "<tr><td>In-game clock time: </td><td><input type=\"number\" min=\"1\" max=\"15\" name=\"tick_timer_begin\" value=\"" . $_GET["tick_timer_begin"] . "\"/></td>\n\t\t\t<td>-</td><td><input type=\"number\"min=\"1\" max=\"15\" name=\"tick_timer_end\" value=\"" . $_GET["tick_timer_end"] . "\"/></td></tr>\n\t\t<tr><td>Objective name: </td><td><input type=\"text\" name=\"obj_name\" value=\"" . $_GET["obj_name"] . "\"/></td></tr>\n\t\t<tr><td>Objective type: </td><td><select name=\"obj_type\">";
generate_option("", "", "obj_type");
generate_option("Camp", "Camp", "obj_type");
generate_option("Tower", "Tower", "obj_type");
generate_option("Keep", "Keep", "obj_type");
generate_option("Castle", "Castle", "obj_type");
echo "</select></td></tr>\n\t\t<tr><td>Map type: </td><td><select name=\"map_type\">";
generate_option("", "All Maps", "map_type");
generate_option("center", "Eternal Battlegrounds", "map_type");
generate_option("greenHome", "Green Borderlands", "map_type");
generate_option("blueHome", "Blue Borderlands", "map_type");
generate_option("redHome", "Red Borderlands", "map_type");
generate_option("home", "All Borderlands", "map_type");
echo "</select></td></tr>\n\t\t<tr><td>Guild name: </td><td><input type=\"text\" name=\"guild_name\" value=\"" . $_GET["guild_name"] . "\"/></td></tr>\n\t\t<tr><td>Guild tag: </td><td><input type=\"text\" name=\"guild_tag\" value=\"" . $_GET["guild_tag"] . "\"/></td></tr>";
echo "</table></div>\n\t<table>\n\t<tr>\n\t<td><input type=\"submit\" value=\"Submit Query\"/></td><td style=\"width:175px\"></td>\n\t</form></td>\n\t<td><form action=\"guild_analyser.php\">\n\t\t<input type=\"submit\" value=\"Reset fields\"/>\n\t</form></td>\n\t</tr>\n\t</table>";
?>
<br/>
<?php
$guildClaimQuery = "SELECT count(*) as \"Number of Claims\", guild_name as \"Guild Name\", guild_tag as \"Guild Tag\"\n\t\tFROM activity_data\n\t\tINNER JOIN server_info ON activity_data.owner_server = server_info.srv_id\n\t\tINNER JOIN objective ON activity_data.obj_id=objective.obj_id\n\t\tINNER JOIN guild ON guild.guild_id = activity_data.guild_id\n\t\tINNER JOIN match_details on match_details.match_id=activity_data.match_id\n\t\tWHERE match_details.start_time = activity_data.start_time and guild_name!=\"\" ";
//automatically eliminate any activity-data without a guild claim
if ($_GET["match_num"] == "" and $_GET["week_num"] == "" and $_GET["obj_owner"] == "" and $_GET["owner_color"] == "" and $_GET["last_flipped_begin"] == "" and $_GET["last_flipped_end"] == "" and $_GET["claimed_at_begin"] == "" and $_GET["claimed_at_end"] == "" and $_GET["tick_timer_begin"] == "" and $_GET["tick_timer_end"] == "" and $_GET["obj_name"] == "" and $_GET["obj_type"] == "" and $_GET["map_type"] == "" and $_GET["guild_name"] == "" and $_GET["guild_tag"] == "" and $_GET["region"] == "") {
die("");
//if the user did not enter any search criteria, stop early
}
check_inputs();
if ($_GET["region"] != "") {
$guildClaimQuery .= "and activity_data.match_id LIKE \"" . $_GET["region"] . "-%\" ";
}
<?php
include 'analyser_header.php';
include 'bootstrap_styling.php';
?>
<html>
<title> Match Details Analyser </title>
<style>body{background:#FFF;}</style>
<body>
<div class="container-fluid col-sm-12">
<?php
echo "<form action=\"match_details_analyser.php\" method=\"GET\">\n\t<table class=\"table-condensed\">";
echo "<tr><td>Region / Match Number:</td><td> <select name=\"region\">";
generate_option("", "", "region");
generate_option("1", "1 (NA)", "region");
generate_option("2", "2 (EU)", "region");
echo "</select><input type=\"number\" min=\"1\" max=\"9\" name=\"match_num\" value=\"" . $_GET["match_num"] . "\"/></td></tr> \n\t\t<tr><td>Week number: </td><td><input type=\"number\" min=\"0\" max=\"52\" name=\"week_num\" value=\"" . $_GET["week_num"] . "\"/></td></tr>\n\t\t<tr><td>Server name: </td><td><input name=\"obj_owner\" value=\"" . $_GET["obj_owner"] . "\"/></td></tr>";
echo "</table>\n\t<table>\n\t<tr>\n\t<td><input type=\"submit\" value=\"Submit Query\"/></td><td style=\"width:175px\"></td>\n\t</form></td>\n\t<td><form action=\"match_details_analyser.php\" method=\"GET\">\n\t\t<input type=\"submit\" value=\"Reset fields\"/>\n\t</form></td>\n\t</tr>\n\t</table>";
?>
</div>
<br/>
<?php
$matchQuery = "SELECT match_id as \"Match ID\", week_num as \"Week Number\",\n\t\t\tstart_time as \"Start Time\", end_time as \"End Time\", s1.name as \"Red Server\", s1_1.name as \"Red Server2\",\n\t\t\ts2.name as \"Blue Server\", s2_1.name as \"Blue Server2\", s3.name as \"Green Server\", s3_1.name as \"Green Server2\",\n\t\t\tgrn_srv_population as \"Green Population\", blu_srv_population as \"Blue Population\", red_srv_population as \"Red Population\",\n\t\t\tgrn_srv2_pop as \"Green Population2\", blu_srv2_pop as \"Blue Population2\", red_srv2_pop as \"Red Population2\"\n\t\t\tFROM match_details\n\t\t\tLEFT JOIN server_info s1_1 on s1_1.srv_id = red_srv2\n\t\t\tLEFT JOIN server_info s2_1 on s2_1.srv_id = blue_srv2\n\t\t\tLEFT JOIN server_info s3_1 on s3_1.srv_id = green_srv2\n\t\t\tINNER JOIN server_info s1 ON s1.srv_id = red_srv\n\t\t\tINNER JOIN server_info s2 ON s2.srv_id = blue_srv\n\t\t\tINNER JOIN server_info s3 ON s3.srv_id = green_srv\n\t\t\tWHERE match_id = match_id ";
//dummy where clause
check_inputs();
if ($_GET["region"] != "") {
$matchQuery .= "and match_id LIKE \"" . $_GET["region"] . "-%\" ";
}
if ($_GET["match_num"] != "") {
$matchQuery .= "and match_id LIKE \"%-" . $_GET["match_num"] . "\" ";
}
