function approve_indentRegistrant($indent_id) { $SQL = "update t_tournaments_indent set"; $SQL .= " player_approved= 1"; $SQL .= " where tour_id ='{$this->tour_id}' and indent_id={$indent_id}"; $this->SimpleDB->connect(); $this->SimpleDB->execute($SQL); $this->SimpleDB->disconnect(); // Move To Player $this->SimpleDB->connect(); $SQL = "select indent_id from t_tournaments_player where indent_id={$indent_id}"; $rst = $this->SimpleDB->query($SQL); if (is_object($rst) && !$rst->next()) { $data = $this->get_registrant($indent_id); $player = new player(); $player->player_id = ""; $player->tour_id = $data[0]['tour_id']; $player->player_members_id = $data[0]['player_members_id'] == "Not IJGC Members" ? " " : $data[0]['player_members_id']; $player->player_name = $data[0]['player_name']; $player->player_age = $data[0]['player_age']; $player->player_birthdate = $data[0]['player_birthdate']; $player->player_parents_name = $data[0]['player_parents_name']; $player->player_contactno = $data[0]['player_contactno']; $player->player_email = $data[0]['player_email']; $player->player_home_address = $data[0]['player_home_address']; $player->player_group = $data[0]['player_group']; $player->indent_id = $data[0]['indent_id']; $player->player_confirmed = 0; $tournaments = new tournaments($this->tour_id); $tournaments->add_player($player); } $this->SimpleDB->disconnect(); }
function showResult(&$smarty) { $tour_id = trim($_REQUEST['id']); $tournaments = new tournaments($tour_id); $datalist = $tournaments->getPositionList(); $smarty->assign('datalist', $datalist); $smarty->assign('course_msg', "There are currently no register player."); //drawresult $select = $_POST['id_round']; $none = true; $data = $tournaments->getRoundList(); $key = 0; $mark = 0; foreach ($data as $var) { switch ($var['round_no']) { case 1: $nama = "First"; break; case 2: $nama = "Second"; break; case 3: $nama = "Third"; break; case 4: $nama = "Fourth"; break; case 5: $nama = "Fifth"; break; default: $nama = ""; break; } $list[$key]['param'] = $nama; $list[$key]['value'] = $var['round_id']; $list[$key]['selected'] = ""; if ($select == $var['round_id']) { $list[$key]['selected'] = "selected"; $none = false; $mark = $key; } $key++; } if ($none) { $list[0]['selected'] = "selected"; } $smarty->assign('list', $list); $tour_fact = new tournament_factory(); $capek = $tour_fact->getTournaments($tour_id); $course_fact = new course_factory(); $course = $course_fact->get_course($capek->course_id); $par = $course->get_detail(); $hole = $par["hole"]; $key = 1; $in_par = 0; $out_par = 0; for ($j = 0; $j <= 18; $j++) { $par = $hole[$j]["par"]; if ($j <= 8) { $out_par += $par; } else { $in_par += $par; } $smarty->assign('hole' . $key . '_par', $par); $key++; } $smarty->assign('out_par', $out_par); $smarty->assign('in_par', $in_par); $smarty->assign('total_par', $in_par + $out_par); $id_round = $list[$mark]['value']; $restlist = $capek->getResultRound($id_round); $smarty->assign('playerlist', $restlist); }
function editScore(&$smarty) { $select = $_POST['id_round']; $none = true; $tournaments = new tournaments(trim($_REQUEST['id'])); $data = $tournaments->getRoundList(); $key = 0; $mark = 0; foreach ($data as $var) { switch ($var['round_no']) { case 1: $nama = "First"; break; case 2: $nama = "Second"; break; case 3: $nama = "Third"; break; case 4: $nama = "Fourth"; break; case 5: $nama = "Fifth"; break; default: $nama = ""; break; } $list[$key]['param'] = $nama; $list[$key]['value'] = $var['round_id']; $list[$key]['selected'] = ""; if ($select == $var['round_id']) { $list[$key]['selected'] = "selected"; $none = false; $mark = $key; } $key++; } if ($none) { $list[0]['selected'] = "selected"; } $smarty->assign('list', $list); // Get Games ID $id_player = $_REQUEST['sid']; $id_round = $list[$mark]['value']; $games_id = $tournaments->getGamesID($id_round, $id_player); $smarty->assign('games_id', $games_id); drawScore($smarty, $games_id); }