function fullmetagame($event)
{
$decks = $event->getDecks();
$players = array();
foreach ($decks as $deck) {
$info = array("player" => $deck->playername, "deckname" => $deck->name, "archetype" => $deck->archetype, "medal" => $deck->medal, "id" => $deck->id);
$arr = deckInfo($deck);
$info["colors"] = $arr[1];
if ($info['medal'] == "dot") {
$info['medal'] = "z";
}
$players[] = $info;
}
$db = Database::getConnection();
$succ = $db->query("CREATE TEMPORARY TABLE meta(\n\t\tplayer VARCHAR(40), deckname VARCHAR(40), archetype VARCHAR(20),\n\t\tcolors VARCHAR(10), medal VARCHAR(10), id BIGINT UNSIGNED,\n srtordr TINYINT UNSIGNED DEFAULT 0)");
$succ or die($db->error);
$stmt = $db->prepare("INSERT INTO meta(player, deckname, archetype,\tcolors, medal, id)\n VALUES(?, ?, ?, ?, ?, ?)");
for ($ndx = 0; $ndx < sizeof($players); $ndx++) {
$stmt->bind_param("sssssd", $players[$ndx]['player'], $players[$ndx]['deckname'], $players[$ndx]['archetype'], $players[$ndx]['colors'], $players[$ndx]['medal'], $players[$ndx]['id']);
$stmt->execute() or die($stmt->error);
}
$stmt->close();
$result = $db->query("SELECT colors, COUNT(player) AS cnt FROM meta GROUP BY(colors)");
$stmt = $db->prepare("UPDATE meta SET srtordr = ? WHERE colors = ?");
while ($row = $result->fetch_assoc()) {
$stmt->bind_param("ds", $row['cnt'], $row['colors']);
$stmt->execute() or die($stmt->error);
}
$stmt->close();
$result->close();
$result = $db->query("SELECT player, deckname, archetype, colors, medal, id, srtordr\n\t\tFROM meta ORDER BY srtordr DESC, colors, medal, player");
$color = "orange";
echo "<table style=\"border-width: 0px;\" align=\"center\">";
$hg = headerColor();
echo "<tr style=\"background-color: {$hg}\">";
echo "<td colspan=5 align=\"center\"><b>Metagame Breakdown</td></tr>\n";
while ($row = $result->fetch_assoc()) {
if ($row['colors'] != $color) {
$bg = rowColor();
$color = $row['colors'];
echo "<tr style=\"background-color: {$bg};\"><td>";
echo "<img src=\"/images/rename/{$color}.gif\"> </td>\n";
echo "<td colspan=4 align=\"left\"><i>{$row['srtordr']} Players ";
#echo "<img src=\"/images/rename/$color.gif\">\n";
echo "</td></tr>\n";
}
echo "<tr style=\"background-color: {$bg};\"><td></td>\n";
echo "<td align=\"left\">";
if ($row['medal'] != "z") {
echo "<img src=\"/images/{$row['medal']}.gif\"> ";
}
echo "</td>\n<td align=\"left\">";
echo "<a href=\"profile.php?player={$row['player']}\">";
echo "{$row['player']}</a></td>\n";
echo "<td align=\"left\">";
echo "<a href=\"deck.php?mode=view&id={$row['id']}\">";
echo "{$row['deckname']}</a></td>\n";
echo "<td align=\"right\">{$row['archetype']}</td></tr>\n";
}
$result->close();
echo "</table>\n";
}
function matchTable($player, $limit = 0)
{
if (!isset($_POST['format'])) {
$_POST['format'] = "%";
}
if (!isset($_POST['series'])) {
$_POST['series'] = "%";
}
if (!isset($_POST['season'])) {
$_POST['season'] = "%";
}
if (!isset($_POST['opp'])) {
$_POST['opp'] = "%";
}
$matches = $player->getFilteredMatches($_POST['format'], $_POST['series'], $_POST['season'], $_POST['opp']);
$hc = headerColor();
echo "<table style=\"border-width: 0px\" width=600>\n";
echo "<tr style=\"background-color: {$hc};\"><td><b>Event</td><td align=\"center\"><b>Round</td>";
echo "<td><b>Opponent</td>\n";
echo "<td><b>Deck</td>\n";
echo "<td align=\"center\"><b>Rating</td>\n";
echo "<td align=\"center\"><b>Result</td></tr>\n";
$oldname = "";
foreach ($matches as $match) {
$rnd = $match->round;
if ($match->timing == 2 && $match->type == "Single Elimination") {
$rnd = "T" . pow(2, $match->rounds + 1 - $match->round);
}
$opp = $match->otherPlayer($player->name);
$res = "Draw";
$color = "#FF9900";
if ($match->playerWon($player->name)) {
$res = "Win";
$color = "#009900";
}
if ($match->playerLost($player->name)) {
$res = "Loss";
$color = "#FF0000";
}
$opponent = new Player($opp);
$event = $match->getEvent();
$oppRating = $opponent->getRating("Composite", $event->start);
$oppDeck = $opponent->getDeckEvent($event->name);
$deckStr = "No Deck Found";
if (!is_null($oppDeck)) {
$deckStr = "<a href=\"deck.php?mode=view&id={$oppDeck->id}\">" . "{$oppDeck->name}</a>";
}
if ($oldname != $event->name) {
$bg = rowColor();
echo "<tr style=\"background-color: {$bg}\"><td>{$event->name}</td>";
} else {
echo "<tr style=\"background-color: {$bg};\"><td></td>\n";
}
$oldname = $event->name;
echo "<td align=\"center\">{$rnd}</td>\n";
echo "<td><a href=\"profile.php?player={$opp}\">{$opp}</a></td>\n";
echo "<td>{$deckStr}</td>\n";
echo "<td align=\"center\">{$oppRating}</td>\n";
echo "<td align=\"center\"><b><font color=\"{$color}\">{$res}</font>";
echo "</td></tr>\n";
}
echo "</table>";
}
