$event_id = intval($_GET['eventid']); if (!$event_id) { header("Location: ./events.php"); exit; } $q = "SELECT " . TBL_EVENTS . ".*, " . TBL_GAMES . ".*, " . TBL_USERS . ".*" . " FROM " . TBL_EVENTS . ", " . TBL_GAMES . ", " . TBL_USERS . " WHERE (" . TBL_EVENTS . ".EventID = '{$event_id}')" . " AND (" . TBL_EVENTS . ".Game = " . TBL_GAMES . ".GameID)" . " AND (" . TBL_USERS . ".user_id = " . TBL_EVENTS . ".Owner)"; $result = $sql->db_Query($q); $event = new Event($event_id); $egame = mysql_result($result, 0, TBL_GAMES . ".Name"); $egameid = mysql_result($result, 0, TBL_GAMES . ".GameID"); $egameicon = mysql_result($result, 0, TBL_GAMES . ".Icon"); $eowner = mysql_result($result, 0, TBL_USERS . ".user_id"); $eownername = mysql_result($result, 0, TBL_USERS . ".user_name"); $eventIsChanged = $event->getField('IsChanged'); $eventStatus = $event->getField('Status'); $rounds = unserialize($event->getFieldHTML('Rounds')); $eMaxNumberPlayers = $event->getField('MaxNumberPlayers'); $type = $event->getField('Type'); $competition_type = $event->getCompetitionType(); /* Nbr players */ $q = "SELECT COUNT(*) as NbrPlayers" . " FROM " . TBL_PLAYERS . " WHERE (" . TBL_PLAYERS . ".Event = '{$event_id}')"; $result = $sql->db_Query($q); $row = mysql_fetch_array($result); $nbr_players = $row['NbrPlayers']; $q = "SELECT " . TBL_PLAYERS . ".*" . " FROM " . TBL_PLAYERS . " WHERE (" . TBL_PLAYERS . ".Event = '{$event_id}')" . " AND (" . TBL_PLAYERS . ".CheckedIn = '1')" . " AND (" . TBL_PLAYERS . ".Seed <= '{$eMaxNumberPlayers}')"; $result = $sql->db_Query($q); $nbr_players_checked_in = mysql_numrows($result); /* Nbr Teams */ $q = "SELECT COUNT(*) as NbrTeams" . " FROM " . TBL_TEAMS . " WHERE (Event = '{$event_id}')"; $result = $sql->db_Query($q); $row = mysql_fetch_array($result);