draw_ranking($players);
}
// started
break;
// case view
// case view
case 'join':
check_banned($_SESSION['playerID']);
$id = $_GET['id'];
$t = mysql_fetch_array(mysql_query("SELECT * FROM tournaments WHERE id = '{$id}'"));
$name = db_output($t['name']);
if (strpos($name, "Finals") > 0) {
echo "<b>Cannot join Finals</b>";
exit;
}
if (joined($id, $_SESSION['playerID'])) {
echo "<b>{$MSG_LANG['tournamentalready']}</b>";
exit;
}
if (get_num($id) == $t['players']) {
echo "<b>{$MSG_LANG['tournament44']}</b>";
exit;
}
if ($me['rating'] < $t['min_rating'] || $me['rating'] > $t['max_rating']) {
echo "<b>{$MSG_LANG['tournamentsorry']}</b>";
exit;
}
include "groups_functions.php";
$uh = get_group($me['playerID']);
$ug = get_groupdata($uh['group_id']);
if ($t['access'] != "" && ($t['access'] == "group" && $uh == false) && ($t['access'] == "group_ag" && $ug['ag'] == 0) && (is_numeric($t['access']) && ($t['access'] = !$uh['group_id']))) {
function joined($id, $player, $return = 0)
{
$query = "SELECT * FROM tournaments WHERE id = '$id'";
$t = mysql_query($query);
$t = mysql_fetch_array($t);
if ($t['players'] == 4)
{
if ($t['player1'] == $player) $return = $t['id'];
if ($t['player2'] == $player) $return = $t['id'];
if ($t['player3'] == $player) $return = $t['id'];
if ($t['player4'] == $player) $return = $t['id'];
}
elseif ($t['players'] == 16)
{
// Holy shit, we got a BIG tournament
$query2 = "SELECT * FROM tournaments WHERE big = '$id'";
$b = mysql_query($query2);
echo mysql_error();
while ($big = mysql_fetch_array($b))
{
if (!isset($return)) $return = 0;
$return = joined($big['id'], $player, $return);
} // while
}
return $return;
}