Example #1
0
            session_register("s_user_level");
            $s_user_level = $level;
            //check if selected player can join this tournament
            $query = "select id,teams_per_account,max_chars_per_team,max_teams from tournament_settings where min_player_level_to_join<='{$level}' and max_player_level_to_join>='{$level}' and id='{$selected_tournament}'";
            $result = mysql_query($query, $dbi) or die("Q\t200501180949" . mysql_error($dbi) . $query);
            if (mysql_num_rows($result)) {
                list($id, $teams_per_account, $max_chars_per_team, $max_teams) = mysql_fetch_row($result);
                session_register("s_user_tournament");
                $s_user_tournament = $id;
                session_register("s_user_max_teams");
                $s_user_max_teams = $teams_per_account;
                session_register("s_user_max_team_members");
                $s_user_max_team_members = $max_chars_per_team;
                session_register("s_max_teams");
                $s_max_teams = $max_teams;
                jumpto("index.php");
            } else {
                Alert("Character does not meet the level requirements to join this tournament");
            }
        } else {
            Alert("Character does not exist");
        }
    } else {
        Alert("Account does not exist");
    }
}
?>
<link rel="stylesheet" type="text/css" media="screen" href="../../screen.css">
<style type="text/css">
<!--
.style1 {
        die;
    }
}
//end of delete
if (isset($save) && $save == 1) {
    $save_insert_query = "insert into tournament_settings (tournament_name,min_teams_to_start,max_chars_per_team,min_player_level_to_join,max_player_level_to_join,inscription_starts,inscription_ends,tournament_starts,teams_per_account,cur_match_round,max_teams) values ('{$tournament_settings_tournament_name}','{$tournament_settings_min_teams_to_start}','{$tournament_settings_max_chars_per_team}','{$tournament_settings_min_player_level_to_join}','{$tournament_settings_max_player_level_to_join}','{$tournament_settings_inscription_starts}','{$tournament_settings_inscription_ends}','{$tournament_settings_tournament_starts}','{$tournament_settings_teams_per_account}','{$tournament_settings_cur_match_round}','{$tournament_settings_max_teams}')";
    $save_update_query = "update tournament_settings set tournament_name='{$tournament_settings_tournament_name}',min_teams_to_start='{$tournament_settings_min_teams_to_start}',max_chars_per_team='{$tournament_settings_max_chars_per_team}',min_player_level_to_join='{$tournament_settings_min_player_level_to_join}',max_player_level_to_join='{$tournament_settings_max_player_level_to_join}',inscription_starts='{$tournament_settings_inscription_starts}',inscription_ends='{$tournament_settings_inscription_ends}',tournament_starts='{$tournament_settings_tournament_starts}',teams_per_account='{$tournament_settings_teams_per_account}',cur_match_round='{$tournament_settings_cur_match_round}',max_teams='{$tournament_settings_max_teams}' where id={$id}";
    $mysql_save_insert_error_code = "Q 200902030504_1";
    $mysql_save_update_error_code = "Q 200902030504_2";
    if ($id == 0) {
        $result = mysql_query($save_insert_query, $dbi) or die($mysql_save_insert_error_code);
    } else {
        $result = mysql_query($save_update_query, $dbi) or die($mysql_save_update_error_code);
    }
    //end of update
    jumpto($save_jumpto);
    die;
}
//end of save/update
if (!isset($save)) {
    $tournament_settings_tournament_name = "1 vs 1";
    $tournament_settings_min_teams_to_start = "2";
    $tournament_settings_max_chars_per_team = "1";
    $tournament_settings_min_player_level_to_join = "70";
    $tournament_settings_max_player_level_to_join = "80";
    $tournament_settings_inscription_starts = time();
    $tournament_settings_inscription_ends = time() + 60 * 60 * 24;
    $tournament_settings_tournament_starts = time() + 60 * 60 * 24;
    $tournament_settings_teams_per_account = "1";
    $tournament_settings_cur_match_round = "0";
    $tournament_settings_max_teams = "1000";