function eventList($series = "", $season = "") { $db = Database::getConnection(); $player = Player::getSessionPlayer(); $playerSeries = $player->stewardsSeries(); $seriesEscaped = array(); foreach ($playerSeries as $oneSeries) { $seriesEscaped[] = $db->escape_string($oneSeries); } $seriesString = '"' . implode('","', $seriesEscaped) . '"'; $query = "SELECT e.name AS name, e.format AS format,\n COUNT(DISTINCT n.player) AS players, e.host AS host, e.start AS start,\n e.finalized, e.cohost, e.series\n FROM events e\n LEFT OUTER JOIN entries AS n ON n.event = e.name\n WHERE (e.host = \"{$db->escape_string($player->name)}\"\n OR e.cohost = \"{$db->escape_string($player->name)}\"\n OR e.series IN (" . $seriesString . "))"; if (isset($_GET['format']) && strcmp($_GET['format'], "") != 0) { $query = $query . " AND e.format=\"{$db->escape_string($_GET['format'])}\" "; } if (isset($_GET['series']) && strcmp($_GET['series'], "") != 0) { $query = $query . " AND e.series=\"{$db->escape_string($_GET['series'])}\" "; } if (isset($_GET['season']) && strcmp($_GET['season'], "") != 0) { $query = $query . " AND e.season=\"{$db->escape_string($_GET['season'])}\" "; } $query = $query . " GROUP BY e.name ORDER BY e.start DESC LIMIT 100"; $result = $db->query($query); $seriesShown = array(); $results = array(); while ($thisEvent = $result->fetch_assoc()) { $results[] = $thisEvent; $seriesShown[] = $thisEvent['series']; } if (isset($_GET['series']) && $_GET['series'] != "") { $seriesShown = $playerSeries; } else { $seriesShown = array_unique($seriesShown); } echo "<form action=\"event.php\" method=\"get\">"; echo "<table class=\"form\" style=\"border-width: 0px\" align=\"center\">"; echo "<tr><td colspan=\"2\" align=\"center\"><b>Filters</td></tr>"; echo "<tr><td> </td></tr>"; echo "<tr><th>Format</th><td>"; if (!isset($_GET['format'])) { $_GET['format'] = ''; } formatDropMenu($_GET['format'], 1); echo "</td></tr>"; echo "<tr><th>Series</th><td>"; Series::dropMenu($_GET['series'], 1, $seriesShown); echo "</td></tr>"; echo "<tr><th>Season</th><td>"; seasonDropMenu($_GET['season'], 1); echo "</td></tr>"; echo "<tr><td> </td></tr>"; echo "<tr><td colspan=\"2\" class=\"buttons\">"; if (count($playerSeries) > 0) { echo "<input type=\"submit\" name=\"mode\" value=\"Create New Event\" />\n"; } echo "<input type=\"submit\" name=\"mode\" value=\"Filter Events\" />\n"; echo "</td></tr></table>"; echo "<table style=\"border-width: 0px\" align=\"center\" cellpadding=\"3\">"; echo "<tr><td colspan=\"5\"> </td></tr>"; echo "<tr><td><b>Event</td><td><b>Format</td>"; echo "<td align=\"center\"><b>Players</td>"; echo "<td><b>Host(s)</td>"; echo "<td align=\"center\"><b>Finalized</td></tr>"; foreach ($results as $thisEvent) { $event = new Event($thisEvent['name']); $dateStr = $thisEvent['start']; $dateArr = explode(" ", $dateStr); $date = $dateArr[0]; echo "<tr><td>"; echo $event->linkTo(); echo "</td>"; echo "<td>{$thisEvent['format']}</td>"; echo "<td align=\"center\">{$thisEvent['players']}</td>"; echo "<td>{$thisEvent['host']}"; $ch = $thisEvent['cohost']; if (!is_null($ch) && strcmp($ch, "") != 0) { echo "/{$ch}"; } echo "</td>"; #echo "<td>$date</td>"; echo "<td align=\"center\">"; if ($thisEvent['finalized'] == 1) { echo "✔"; } echo "</td>"; echo "</tr>"; } if ($result->num_rows == 100) { echo "<tr><td colspan=\"5\" width=\"500\"> </td></tr>"; echo "<tr><td colspan=\"5\" align=\"center\">"; echo "<i>This list only shows the 100 most recent results. "; echo "Please use the filters at the top of this page to find older "; echo "results.</i></td></tr>"; } $result->close(); echo "<tr><td colspan=\"5\" width=\"500\"> </td></tr>"; echo "</table></form>"; }