$result = $mysqli->query("SELECT * FROM " . $dbprefix . "tournaments ORDER BY startdate DESC");
while ($row = $result->fetch_assoc()) {
$tournamentObj->select($row['tournament_id']);
$memberObj->select($row['member_id']);
$dispManager = $memberObj->getMemberLink();
$dateTimeObj = new DateTime();
$dateTimeObj->setTimestamp($row['startdate']);
$includeTimezone = "";
$dateTimeObj->setTimezone(new DateTimeZone("UTC"));
$dispStartDate = $dateTimeObj->format("M j, Y g:i A");
if ($row['timezone'] != "") {
$dateTimeObj->setTimezone(new DateTimeZone($row['timezone']));
$includeTimezone = " T";
}
$dispStartDate .= $dateTimeObj->format($includeTimezone);
if ($row['startdate'] < time() && $tournamentObj->getTournamentWinner() == 0) {
$dispStatus = "<img src='" . $MAIN_ROOT . "themes/" . $THEME . "/images/bluedot.png' title='Started'>";
} elseif ($row['startdate'] > time()) {
$dispStatus = "<img src='" . $MAIN_ROOT . "themes/" . $THEME . "/images/orangedot.png' title='Forming'>";
} elseif ($row['startdate'] < time() && $tournamentObj->getTournamentWinner() != 0) {
$dispStatus = "<img src='" . $MAIN_ROOT . "themes/" . $THEME . "/images/graydot.png' title='Finished'>";
}
if ($counter == 1) {
$addCSS = " alternateBGColor";
$counter = 0;
} else {
$addCSS = "";
$counter = 1;
}
echo "\n\t\t\t\t<tr>\n\t\t\t\t\t<td class='main " . $addCSS . "'><a href='" . $MAIN_ROOT . "tournaments/view.php?tID=" . $row['tournament_id'] . "'>" . filterText($row['name']) . "</a></td>\n\t\t\t\t\t<td class='main " . $addCSS . "'>" . $dispManager . "</td>\n\t\t\t\t\t<td class='main " . $addCSS . "' align='center'>" . $dispStartDate . "</td>\n\t\t\t\t\t<td class='main " . $addCSS . "' align='center'>" . $dispStatus . "</td>\n\t\t\t\t</tr>\n\t\t\t\n\t\t\t";
}
$intBracketConnectorLeft = $intLeft - $intTeamSeparation * 8 / 2 - 30;
switch ($roundNum) {
case 3:
$intTop += $intMatchDistance * 2;
break;
case 4:
$intTop += $intMatchDistance * 6;
break;
case 5:
$intTop += $intMatchDistance * 14;
break;
case 6:
$intTop += $intMatchDistance * 30;
break;
}
$tournamentWinner = $tournamentObj->getTournamentWinner();
$dispWinner = "Empty Spot";
$dispSeed = "";
if ($tournamentWinner !== false) {
$tournamentObj->objTeam->select($tournamentWinner);
$dispSeed = "#" . $tournamentObj->objTeam->get_info("seed");
if ($tournamentInfo['playersperteam'] == 1) {
$arrWinner = $tournamentObj->getTeamPlayers($tournamentWinner, true);
$tournamentObj->objPlayer->select($arrWinner[0]);
$winnerInfo = $tournamentObj->objPlayer->get_info_filtered();
if ($member->select($winnerInfo['member_id'])) {
$dispWinner = $member->getMemberLink();
} else {
$dispWinner = $winnerInfo['displayname'];
}
} else {
