Exemplo n.º 1
0
//single elimination,double elimination or round robin
$team_count = $_REQUEST['team_count'];
$court_count = $_REQUEST['court_count'];
$start_date = $_REQUEST['start_date'];
$end_date = $_REQUEST['end_date'];
if (!($token && $event_name && $start_date && $end_date && $tournament_type && $competition_level && $league_level && $team_count && $court_count)) {
    $success = "0";
    $msg = "Incomplete Parameters";
    $data = array();
} else {
    // +-----------------------------------+
    // + STEP 3: perform operations		   +
    // +-----------------------------------+
    $user_id = Users::getUserId($token);
    if ($user_id) {
        $event_id = Tournament::StartEvent($user_id, $competition_level, $league_level, $event_status);
        $sql = "SELECT * FROM event_tournament WHERE user_id=:user_id and event_id=:event_id";
        $sth = $conn->prepare($sql);
        $sth->bindValue('user_id', $user_id);
        $sth->bindValue('event_id', $event_id);
        try {
            $sth->execute();
        } catch (Exception $e) {
        }
        $tour = $sth->fetchAll(PDO::FETCH_ASSOC);
        if (!count($tour)) {
            $sql = "INSERT into event_tournament(id,user_id,event_id,tournament_name,tournament_type,team_count,court_count,start_date,end_date,created_on) \n\t\tVALUES(DEFAULT,:user_id,:event_id,:tournament_name,:tournament_type,:team_count,:court_count,:start_date,:end_date,UTC_TIMESTAMP())";
            $sth = $conn->prepare($sql);
            $sth->bindValue('user_id', $user_id);
            $sth->bindValue('event_id', $event_id);
            $sth->bindValue('tournament_name', $event_name);