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";