PHP clearByes Examples

Example #1

File: viewbracket.php Project: SymbolixDEV/AL-PHP-Fusion-Addons

<?php

if (!defined("IN_FUSION")) {
    die("access denied");
}
if (!isset($_GET['id']) && !isnum($_GET['id'])) {
    redirect(START_PAGE);
}
$tid = $_GET['id'];
$result = dbquery("SELECT * FROM " . DB_T_TOURS . " WHERE tour_id='" . $tid . "'");
if (dbrows($result)) {
    clearByes($tid);
    $tour = dbarray($result);
    if ($tour['tour_grid'] == "1" && $tour['tour_finished'] == "0") {
        // matches
        $check_r = dbquery("SELECT * FROM " . DB_T_PLAYERS . " WHERE player_tour='" . $tour['tour_id'] . "' AND player_user='******'user_id'] . "' AND player_checkin='1'");
        if (dbrows($check_r)) {
            $check_m = dbquery("SELECT * FROM " . DB_T_MATCHES . " WHERE match_tour='" . $tour['tour_id'] . "' AND match_played='0' AND (match_pl1='" . $userdata['user_id'] . "' OR match_pl2='" . $userdata['user_id'] . "')");
            if (dbrows($check_m)) {
                $nm = dbarray($check_m);
                if ($nm['match_pl1'] == $userdata['user_id']) {
                    if ($nm['match_pl2'] != "0") {
                        $opp = dbarray(dbquery("SELECT user_name FROM " . DB_USERS . " WHERE user_id='" . $nm['match_pl2'] . "'"));
                        $opp_link = "vs <a href='" . BASEDIR . "profile.php?lookup=" . $nm['match_pl2']['user_name'] . "</a>";
                    } else {
                        $opp_link = "wating for an opponent...";
                    }
                } else {
                    if ($nm['match_pl1'] != "0") {
                        $opp = dbarray(dbquery("SELECT user_name FROM " . DB_USERS . " WHERE user_id='" . $nm['match_pl1'] . "'"));
                        $opp_link = "vs <a href='" . BASEDIR . "profile.php?lookup=" . $nm['match_pl1'] . "'>" . $opp['user_name'] . "</a>";

Example #2

File: result.php Project: SymbolixDEV/AL-PHP-Fusion-Addons

    redirect(BASEDIR . "tourney.php?p=result&id=" . $_POST['mid']);
}
if (isset($_POST['add_result'])) {
    $data = dbarray(dbquery("SELECT * FROM " . DB_T_MATCHES . " WHERE match_id='" . $_POST['mid'] . "'"));
    if (isset($_POST['score1']) && isnum($_POST['score1']) && isset($_POST['score2']) && isnum($_POST['score2']) && $_POST['score1'] != $_POST['score2']) {
        if (checkrights("T")) {
            EnterResult($data['match_tour'], $data['match_round'], $data['match_match'], $_POST['score1'], $_POST['score2']);
            clearByes($data['match_tour']);
            redirect(BASEDIR . "tourney.php?p=viewbracket&id=" . $data['match_tour']);
        } elseif ($data['match_pl1'] == $userdata['user_id'] && $_POST['score1'] < $_POST['score2']) {
            EnterResult($data['match_tour'], $data['match_round'], $data['match_match'], $_POST['score1'], $_POST['score2']);
            clearByes($data['match_tour']);
            redirect(BASEDIR . "tourney.php?p=viewbracket&id=" . $data['match_tour']);
        } elseif ($data['match_pl2'] == $userdata['user_id'] && $_POST['score1'] > $_POST['score2']) {
            EnterResult($data['match_tour'], $data['match_round'], $data['match_match'], $_POST['score1'], $_POST['score2']);
            clearByes($data['match_tour']);
            redirect(BASEDIR . "tourney.php?p=viewbracket&id=" . $data['match_tour']);
        } else {
            redirect(FUSION_SELF . "?p=result&id=" . $_GET['id']);
        }
    } else {
        redirect(FUSION_SELF . "?p=result&id=" . $_GET['id']);
    }
}
$result = dbquery("SELECT tm.*, tt.* FROM " . DB_T_MATCHES . " tm LEFT JOIN " . DB_T_TOURS . " tt ON tt.tour_id=tm.match_tour WHERE match_id='" . $_GET['id'] . "'");
if (dbrows($result)) {
    $bye = bye();
    opentable("Enter result");
    $data = dbarray($result);
    // table with match info
    // pl1