Example #1
0
/**
* displayEvents - Displays the events database table in
* a nicely formatted html table.
*/
function displayPastEvents()
{
    global $sql;
    global $text;
    global $time;
    $pages = new Paginator();
    $array = array('latest' => array(EB_EVENTS_L4, 'EventID'), 'name' => array(EB_EVENTS_L5, TBL_EVENTS . '.Name'), 'game' => array(EB_EVENTS_L6, TBL_GAMES . '.Name'), 'type' => array(EB_EVENTS_L7, TBL_EVENTS . '.Type'), 'start' => array(EB_EVENTS_L8, TBL_EVENTS . '.StartDateTime'));
    if (!isset($_GET['gameid'])) {
        $_GET['gameid'] = "All";
    }
    $gameid = eb_sanitize($_GET['gameid']);
    if (!isset($_GET['matchtype'])) {
        $_GET['matchtype'] = "All";
    }
    $matchtype = eb_sanitize($_GET['matchtype']);
    if (!isset($_GET['orderby'])) {
        $_GET['orderby'] = 'game';
    }
    $orderby = eb_sanitize($_GET['orderby']);
    $sort = "ASC";
    if (isset($_GET["sort"]) && !empty($_GET["sort"])) {
        $sort = $_GET["sort"] == "ASC" ? "DESC" : "ASC";
    }
    $game_string = $gameid == "All" ? "" : "   AND (" . TBL_EVENTS . ".Game = '{$gameid}')";
    $matchtype_string = $matchtype == "All" ? "" : "   AND (" . TBL_GAMES . ".MatchTypes LIKE '%{$matchtype}%')";
    // Drop down list to select Games to display
    $q_Games = "SELECT DISTINCT " . TBL_GAMES . ".*" . " FROM " . TBL_GAMES . ", " . TBL_EVENTS . " WHERE (" . TBL_EVENTS . ".Game = " . TBL_GAMES . ".GameID)" . $matchtype_string . " ORDER BY Name";
    $result_Games = $sql->db_Query($q_Games);
    $numGames = mysql_numrows($result_Games);
    // Drop down list to select Match type to display
    $q_mt = "SELECT " . TBL_GAMES . ".*" . " FROM " . TBL_GAMES . ", " . TBL_EVENTS . " WHERE (" . TBL_EVENTS . ".Game = " . TBL_GAMES . ".GameID)" . $game_string;
    $result_mt = $sql->db_Query($q_mt);
    $num_mt = mysql_numrows($result_mt);
    $gmatchtypes = '';
    for ($i = 0; $i < $num_mt; $i++) {
        $gmatchtypes .= ',' . mysql_result($result_mt, $i, TBL_GAMES . ".MatchTypes");
    }
    $text .= '<form id="submitform" action="' . htmlspecialchars($_SERVER['PHP_SELF']) . '" method="get">';
    $text .= '<div>';
    $text .= '<table class="table_left">';
    $text .= '<tr>';
    // Games drop down
    $text .= '<td>' . EB_EVENTS_L9 . '<br />';
    $text .= '<select class="tbox" name="gameid" onchange="this.form.submit()">';
    $text .= '<option value="All" ' . ($gameid == "All" ? 'selected="selected"' : '') . '>' . EB_EVENTS_L10 . '</option>';
    for ($i = 0; $i < $numGames; $i++) {
        $gName = mysql_result($result_Games, $i, TBL_GAMES . ".Name");
        $gid = mysql_result($result_Games, $i, TBL_GAMES . ".GameID");
        $text .= '<option value="' . $gid . '" ' . ($gameid == $gid ? 'selected="selected"' : '') . '>' . htmlspecialchars($gName) . '</option>';
    }
    $text .= '</select>';
    $text .= '</td>';
    // Match Types drop down
    $text .= '<td>' . EB_EVENTS_L32 . '<br />';
    $text .= '<select class="tbox" name="matchtype" onchange="this.form.submit()">';
    $text .= '<option value="All" ' . ($matchtype == "All" ? 'selected="selected"' : '') . '>' . EB_EVENTS_L10 . '</option>';
    $gmatchtypes = explode(",", $gmatchtypes);
    $gmatchtypes = array_unique($gmatchtypes);
    sort($gmatchtypes);
    foreach ($gmatchtypes as $gmatchtype) {
        if ($gmatchtype != '') {
            $text .= '<option value="' . $gmatchtype . '" ' . ($gmatchtype == $matchtype ? 'selected="selected"' : '') . '>' . htmlspecialchars($gmatchtype) . '</option>';
        }
    }
    $text .= '</select>';
    $text .= '</td>';
    $text .= '</tr>';
    $text .= '</table>';
    $game_string = $gameid == "All" ? "" : "   AND (" . TBL_EVENTS . ".Game = '{$gameid}')";
    $matchtype_string = $matchtype == "All" ? "" : "   AND (" . TBL_EVENTS . ".MatchType = '{$matchtype}')";
    $q = "SELECT count(*) " . " FROM " . TBL_EVENTS . " WHERE (" . TBL_EVENTS . ".Status = 'finished')" . $game_string . $matchtype_string;
    $result = $sql->db_Query($q);
    $totalItems = mysql_result($result, 0);
    $pages->items_total = $totalItems;
    $pages->mid_range = eb_PAGINATION_MIDRANGE;
    $pages->paginate();
    $orderby_array = $array["{$orderby}"];
    $q = "SELECT " . TBL_EVENTS . ".*, " . TBL_GAMES . ".*" . " FROM " . TBL_EVENTS . ", " . TBL_GAMES . " WHERE (" . TBL_EVENTS . ".Status = 'finished')" . "   AND (" . TBL_EVENTS . ".Game = " . TBL_GAMES . ".GameID)" . $game_string . $matchtype_string . " ORDER BY {$orderby_array['1']} {$sort}, EventID DESC" . " {$pages->limit}";
    $result = $sql->db_Query($q);
    $numEvents = mysql_numrows($result);
    if (!$result || $numEvents < 0) {
        /* Error occurred, return given name by default */
        $text .= EB_EVENTS_L11 . '</div>';
        $text .= '</form><br/>';
    } else {
        if ($numEvents == 0) {
            $text .= EB_EVENTS_L12 . '</div>';
            $text .= '</form><br/>';
        } else {
            // Paginate & Sorting
            $items = '';
            foreach ($array as $opt => $opt_array) {
                $items .= $opt == $orderby ? '<option selected="selected" value="' . $opt . '">' . $opt_array[0] . '</option>' : '<option value="' . $opt . '">' . $opt_array[0] . '</option>';
            }
            // Paginate
            $text .= '<span class="paginate" style="float:left;">' . $pages->display_pages() . '</span>';
            $text .= '<span style="float:right">';
            // Sort By
            $text .= EB_PGN_L6;
            $text .= '<select class="tbox" name="orderby" onchange="this.form.submit()">';
            $text .= $items;
            $text .= '</select>';
            // Up/Down arrow
            $text .= '<input type="hidden" id="sort" name="sort" value=""/>';
            if ($sort == "ASC") {
                $text .= '<a href="javascript:buttonval(\'ASC\');" title="Ascending"><img src="' . e_PLUGIN . 'ebattles/images/sort_asc.gif" alt="Asc" style="vertical-align:middle; border:0"/></a>';
            } else {
                $text .= '<a href="javascript:buttonval(\'DESC\');" title="Descending"><img src="' . e_PLUGIN . 'ebattles/images/sort_desc.gif" alt="Desc" style="vertical-align:middle; border:0"/></a>';
            }
            $text .= '&nbsp;&nbsp;&nbsp;';
            // Go To Page
            $text .= $pages->display_jump_menu();
            $text .= '&nbsp;&nbsp;&nbsp;';
            // Items per page
            $text .= $pages->display_items_per_page();
            $text .= '</span>';
            $text .= '</div>';
            $text .= '</form><br/><br/>';
            /* Display table contents */
            $text .= '<table class="eb_table" style="width:95%"><tbody>';
            $text .= '<tr>
		<th class="eb_th2">' . EB_EVENTS_L13 . '</th>
		<th colspan="2" class="eb_th2">' . EB_EVENTS_L14 . '</th>
		<th class="eb_th2">' . EB_EVENTS_L15 . '</th>
		<th class="eb_th2">' . EB_EVENTS_L16 . '</th>
		<th class="eb_th2">' . EB_EVENTS_L17 . '</th>
		<th class="eb_th2">' . EB_EVENTS_L18 . '</th>
		<th class="eb_th2">' . EB_EVENTS_L19 . '</th>
		<th class="eb_th2">' . EB_EVENTS_L34 . '</th>
		</tr>';
            for ($i = 0; $i < $numEvents; $i++) {
                $gName = mysql_result($result, $i, TBL_GAMES . ".Name");
                $gIcon = mysql_result($result, $i, TBL_GAMES . ".Icon");
                $event_id = mysql_result($result, $i, TBL_EVENTS . ".EventID");
                $event = new Event($event_id);
                if ($event->getField('StartDateTime') != 0) {
                    $startdatetime_local = $event->getField('StartDateTime') + TIMEOFFSET;
                    $date_start = date("d M Y", $startdatetime_local);
                } else {
                    $date_start = "-";
                }
                if ($event->getField('EndDateTime') != 0) {
                    $enddatetime_local = $event->getField('EndDateTime') + TIMEOFFSET;
                    $date_end = date("d M Y", $enddatetime_local);
                } else {
                    $date_end = "-";
                }
                /* Nbr players */
                $q_2 = "SELECT COUNT(*) as NbrPlayers" . " FROM " . TBL_PLAYERS . " WHERE (Event = '{$event_id}')";
                $result_2 = $sql->db_Query($q_2);
                $row = mysql_fetch_array($result_2);
                $nbrplayers = $row['NbrPlayers'];
                /* Nbr Teams */
                $q_2 = "SELECT COUNT(*) as NbrTeams" . " FROM " . TBL_TEAMS . " WHERE (" . TBL_TEAMS . ".Event = '{$event_id}')";
                $result_2 = $sql->db_Query($q_2);
                $row = mysql_fetch_array($result_2);
                $nbrTeams = $row['NbrTeams'];
                /* Nbr matches */
                $q_2 = "SELECT COUNT(DISTINCT " . TBL_MATCHS . ".MatchID) as NbrMatches" . " FROM " . TBL_MATCHS . ", " . TBL_SCORES . " WHERE (Event = '{$event_id}')" . " AND (" . TBL_MATCHS . ".Status = 'active')" . " AND (" . TBL_SCORES . ".MatchID = " . TBL_MATCHS . ".MatchID)";
                $result_2 = $sql->db_Query($q_2);
                $row = mysql_fetch_array($result_2);
                $nbrmatches = $row['NbrMatches'];
                switch ($event->getField('Type')) {
                    case "One Player Ladder":
                    case "One Player Tournament":
                        $nbrTeamPlayers = $nbrplayers;
                        break;
                    case "Team Ladder":
                        $nbrTeamPlayers = $nbrTeams . '/' . $nbrplayers;
                        break;
                    case "Clan Ladder":
                    case "Clan Tournament":
                        $nbrTeamPlayers = $nbrTeams;
                        break;
                    default:
                }
                $text .= '<tr>
			<td class="eb_td"><a href="' . e_PLUGIN . 'ebattles/eventinfo.php?eventid=' . $event_id . '">' . $event->getField('Name') . '</a></td>
			<td class="eb_td"><img ' . getGameIconResize($gIcon) . '/></td>
			<td class="eb_td">' . $gName . '</td>
			<td class="eb_td">' . ($event->getField('MatchType') != '' ? $event->getField('MatchType') . ' - ' : '') . $event->eventTypeToString() . '</td>
			<td class="eb_td">' . $date_start . '</td>
			<td class="eb_td">' . $date_end . '</td>
			<td class="eb_td">' . $nbrTeamPlayers . '</td>
			<td class="eb_td">' . $nbrmatches . '</td>
			<td class="eb_td">' . $event->eventStatusToString() . '</td>
			</tr>';
            }
            $text .= '</tbody></table><br />';
            $text .= '<div>';
            $text .= ebImageLink('back_to_events', '', e_PLUGIN . 'ebattles/events.php', '', 'action_back.gif', EB_EVENTP_L3 . ' ' . EB_EVENTP_L4, 'jq-button');
            $text .= '</div>';
        }
    }
}
Example #2
0
<?php

/**
* embedded brackets
*
*/
require_once "../../class2.php";
require_once e_PLUGIN . "ebattles/include/main.php";
require_once e_PLUGIN . "ebattles/include/event.php";
/*******************************************************************
********************************************************************/
$text = '';
$text .= '<html>';
$text .= '<head>';
$text .= '<link rel="stylesheet" type="text/css" href="./css/brackets.css" />';
$text .= '</head>';
$text .= '<body>';
$event_id = intval($_GET['eventid']);
if (!$event_id) {
    header("Location: ./events.php");
    exit;
}
$event = new Event($event_id);
list($bracket_html) = $event->brackets(false, 0, 'elimination');
$text .= $bracket_html;
$ns->tablerender($event->getField('Name') . " ({$egame} - " . $event->eventTypeToString() . ")", $text);
?>

function user_form($action, $players_id, $players_name, $event_id, $match_id, $allowDraw, $allowForfeit, $allowScore, $userclass, $date_scheduled, $user_player)
{
    global $sql;
    global $text;
    global $tp;
    global $time;
    /* Event Info */
    $event = new Event($event_id);
    if (e_WYSIWYG) {
        $insertjs = "rows='5'";
    } else {
        require_once e_HANDLER . "ren_help.php";
        $insertjs = "rows='5' onselect='storeCaret(this);' onclick='storeCaret(this);' onkeyup='storeCaret(this);'";
    }
    /*
    //dbg form
    echo "<br>_POST: ";
    var_dump($_POST);
    echo "<br>_GET: ";
    var_dump($_GET);
    */
    $match_str = '';
    $matchreport_str = EB_MATCHR_L31;
    if ($action == 'matchedit') {
        $matchreport_str = EB_MATCHR_L46;
        $text .= '<div>';
        $text .= EB_MATCHR_L45 . " {$match_id}<br />";
        $text .= '<img src="' . e_PLUGIN . 'ebattles/images/exclamation.png"/>';
        $text .= EB_MATCHR_L47;
        $text .= '</div><br />';
    }
    if ($action == 'matchschedulededit') {
        $matchreport_str = EB_MATCHR_L46;
        $text .= '<div>';
        $text .= EB_MATCHR_L45 . " {$match_id}<br />";
        $text .= '</div><br />';
    }
    if ($action == 'matchschedule') {
        $matchreport_str = EB_MATCHR_L48;
    }
    if ($match_id) {
        $match_str = '&amp;matchid=' . $match_id;
    }
    if ($action) {
        $action_str = '&amp;actionid=' . $action;
    }
    // Assign values to POST if not set
    // fm: check might not be correct here
    // should check if $action=='matchedit') only?
    if (!isset($_POST['time_reported']) || $action == 'matchscheduledreport') {
        $_POST['time_reported'] = $time;
    }
    $time_reported = $_POST['time_reported'];
    if (!isset($_POST['reported_by'])) {
        $_POST['reported_by'] = USERID;
    }
    $reported_by = $_POST['reported_by'];
    if (isset($_POST['match_comment'])) {
        $comment = $tp->toDB($_POST['match_comment']);
    } else {
        $comment = '';
    }
    for ($matchMap = 0; $matchMap < min($numMaps, $event->getField('MaxMapsPerMatch')); $matchMap++) {
        if (!isset($_POST['map' . $matchMap])) {
            $_POST['map' . $matchMap] = 0;
        }
    }
    // if vars are not set, set them as empty.
    if (!isset($_POST['nbr_players'])) {
        $_POST['nbr_players'] = 2;
    }
    if (!isset($_POST['nbr_teams'])) {
        $_POST['nbr_teams'] = 2;
    }
    // This form should only be used for 2 teams matches (1v1, 2v2, ...)
    // now to output the form HTML.
    $max_nbr_players = count($players_id) - 1;
    $nbr_players = $_POST['nbr_players'];
    $nbr_teams = $_POST['nbr_teams'];
    $nbr_players_per_team = $_POST['nbr_players'] / $_POST['nbr_teams'];
    $i = 1;
    // player index
    for ($t = 1; $t <= $nbr_teams; $t++) {
        if (!isset($_POST['rank' . $t])) {
            $_POST['rank' . $t] = 'Team #' . $t;
        }
        for ($p = 1; $p <= $nbr_players_per_team; $p++) {
            if (!isset($_POST['team' . $i])) {
                $_POST['team' . $i] = 'Team #' . $t;
            }
            if (!isset($_POST['score' . $i])) {
                $_POST['score' . $i] = 0;
            }
            if (!isset($_POST['faction' . $i])) {
                $_POST['faction' . $i] = 0;
            }
            $i++;
        }
    }
    $result = 1;
    if ($_POST['rank1'] == 'Team #2' && $_POST['rank2'] == 'Team #1') {
        $result = 2;
    }
    if ($_POST['draw2'] == 1) {
        $result = 3;
    }
    if ($_POST['rank1'] == 'Team #2' && $_POST['rank2'] == 'Team #1' && $_POST['forfeit2'] == 1) {
        $result = 4;
    }
    if ($_POST['rank1'] == 'Team #1' && $_POST['rank2'] == 'Team #2' && $_POST['forfeit2'] == 1) {
        $result = 5;
    }
    if (!isset($_POST['result'])) {
        $_POST['result'] = $result;
    }
    //var_dump($result);
    /////////////////
    /// MAIN FORM ///
    /////////////////
    $text .= '<form id="matchreportform" action="' . htmlspecialchars($_SERVER['PHP_SELF']) . '?eventid=' . $event_id . $match_str . $action_str . '" method="post">';
    $text .= '<div>';
    // TABLE - Match result
    if ($nbr_players > 2) {
        $array_result = array(1 => array(EB_MATCHR_L60, true), 2 => array(EB_MATCHR_L61, true), 3 => array(EB_MATCHR_L62, $allowDraw == TRUE ? true : false), 4 => array(EB_MATCHR_L63, $allowForfeit == TRUE ? true : false), 5 => array(EB_MATCHR_L64, $allowForfeit == TRUE ? true : false));
    } else {
        $array_result = array(1 => array(EB_MATCHR_L65, true), 2 => array(EB_MATCHR_L66, true), 3 => array(EB_MATCHR_L67, $allowDraw == TRUE ? true : false), 4 => array(EB_MATCHR_L68, $allowForfeit == TRUE ? true : false), 5 => array(EB_MATCHR_L69, $allowForfeit == TRUE ? true : false));
    }
    if ($action != 'matchschedule' && $action != 'matchschedulededit') {
        $text .= '<table id="matchresult_selectresult" class="table_left"><tbody>';
        $text .= '<tr>';
        $text .= '<td>' . EB_MATCHR_L59 . '</td>';
        $text .= '<td>';
        $text .= '<select class="tbox" name="result">';
        foreach ($array_result as $opt => $opt_array) {
            if ($opt_array[1] == true) {
                $selected_str = $_POST['result'] == $opt ? 'selected="selected"' : '';
                $text .= '<option value="' . $opt . '" ' . $selected_str . '>' . $opt_array[0] . '</option>';
            }
        }
        $text .= '</select>';
        $text .= '</td>';
        $text .= '</tr>';
        $text .= '</tbody></table>';
    }
    // TABLE - Players/Teams Selection
    //----------------------------------
    // List of all Factions
    $q_Factions = "SELECT " . TBL_FACTIONS . ".*" . " FROM " . TBL_FACTIONS . " WHERE (" . TBL_FACTIONS . ".Game = '" . $event->getField('Game') . "')";
    $result_Factions = $sql->db_Query($q_Factions);
    $numFactions = mysql_numrows($result_Factions);
    $disable_input = $action == 'matchscheduledreport' ? 1 : 0;
    if ($action != 'matchschedulededit') {
        // TABLE - Teams
        //$text .= EB_MATCHR_L20;
        $text .= '<table id="matchresult_teams" style="text-align:center" class="table_left">';
        $text .= '<thead>';
        $text .= '<tr>';
        $text .= '<th class="eb_th1"></th>';
        // Team #
        $text .= '<th class="eb_th1"></th>';
        // Player #
        $text .= '<th class="eb_th1"></th>';
        // Name
        if ($action != 'matchschedule' && $action != 'matchschedulededit' && $allowScore == TRUE) {
            $text .= '<th class="eb_th1">' . EB_MATCHR_L26 . '</th>';
        }
        // Score
        if ($action != 'matchschedule' && $action != 'matchschedulededit' && $numFactions > 0) {
            $text .= '<th class="eb_th1">' . EB_MATCHR_L41 . '</th>';
        }
        // Faction
        $text .= '</tr>';
        $text .= '</thead>';
        $text .= '<tbody>';
        $p = 1;
        // player index
        for ($t = 1; $t <= $nbr_teams; $t++) {
            if ($nbr_players > 2) {
                $p = 1;
            }
            // reset player number
            $text .= '<tr>';
            $text .= '<td>';
            $text .= $nbr_players > 2 ? EB_MATCHR_L10 . $t : '';
            $text .= '</td>';
            $text .= '</tr>';
            for ($i = 1; $i <= $nbr_players; $i++) {
                if ($_POST['team' . $i] == 'Team #' . $t) {
                    $text .= '<tr>';
                    $text .= '<td>';
                    $text .= '<input type="hidden" name="team' . $i . '" value="Team #' . $t . '"/>';
                    $text .= '</td>';
                    $text .= '<td>' . EB_MATCHR_L23 . $p . ':&nbsp;</td>';
                    $match_winner = 0;
                    if ($event->getField('match_report_userclass') == eb_UC_MATCH_WINNER && $userclass == eb_UC_EVENT_PLAYER && $i == 1 && $user_player != 0) {
                        $match_winner = 1;
                        $_POST['player' . $i] = $user_player;
                    }
                    if ($disable_input == 1 || $match_winner == 1) {
                        for ($j = 1; $j <= $max_nbr_players + 1; $j++) {
                            if (strtolower($_POST['player' . $i]) == strtolower($players_id[$j - 1])) {
                                $text .= '<td><input type="hidden" name="player' . $i . '" value="' . $players_id[$j - 1] . '"/>';
                                $text .= $players_name[$j - 1] . '</td>';
                            }
                        }
                    } else {
                        $text .= '<td><select class="tbox" name="player' . $i . '">';
                        for ($j = 1; $j <= $max_nbr_players + 1; $j++) {
                            $text .= '<option value="' . $players_id[$j - 1] . '"';
                            if (strtolower($_POST['player' . $i]) == strtolower($players_id[$j - 1])) {
                                $text .= ' selected="selected"';
                            }
                            $text .= '>' . $players_name[$j - 1] . '</option>';
                        }
                        $text .= '</select></td>';
                    }
                    if ($action != 'matchschedule' && $action != 'matchschedulededit') {
                        if ($allowScore == TRUE) {
                            $text .= '<td>';
                            $text .= '<input class="tbox" type="text" size="3" name="score' . $i . '" value="' . $_POST['score' . $i] . '"/>';
                            $text .= '</td>';
                        }
                        if ($numFactions > 0) {
                            $text .= '<td><select class="tbox" name="faction' . $i . '">';
                            $text .= '<option value="0"';
                            $text .= '>' . EB_MATCHR_L43 . '</option>';
                            for ($faction = 1; $faction <= $numFactions; $faction++) {
                                $fID = mysql_result($result_Factions, $faction - 1, TBL_FACTIONS . ".FactionID");
                                $fIcon = mysql_result($result_Factions, $faction - 1, TBL_FACTIONS . ".Icon");
                                $fName = mysql_result($result_Factions, $faction - 1, TBL_FACTIONS . ".Name");
                                $text .= '<option value="' . $fID . '"';
                                if (strtolower($_POST['faction' . $i]) == $fID) {
                                    $text .= ' selected="selected"';
                                }
                                $text .= '>' . $fName . '</option>';
                            }
                            $text .= '</select></td>';
                        }
                    }
                    $p++;
                    $text .= '</tr>';
                }
            }
        }
        $text .= '</tbody>';
        $text .= '</table>';
        $text .= '<br />';
        // Map Selection
        //----------------------------------
        // List of all Maps
        $q_Maps = "SELECT " . TBL_MAPS . ".*" . " FROM " . TBL_MAPS . " WHERE (" . TBL_MAPS . ".Game = '" . $event->getField('Game') . "')";
        $result_Maps = $sql->db_Query($q_Maps);
        $numMaps = mysql_numrows($result_Maps);
        if ($numMaps > 0) {
            $text .= EB_MATCHR_L42;
            $text .= '<table id="matchresult_selectMap" class="table_left"><tbody>';
            for ($matchMap = 0; $matchMap < min($numMaps, $event->getField('MaxMapsPerMatch')); $matchMap++) {
                $text .= '<tr>';
                $text .= '<td><select class="tbox" name="map' . $matchMap . '">';
                $text .= '<option value="0"';
                $text .= '>' . EB_MATCHR_L43 . '</option>';
                for ($map = 0; $map < $numMaps; $map++) {
                    $mID = mysql_result($result_Maps, $map, TBL_MAPS . ".MapID");
                    $mImage = mysql_result($result_Maps, $map, TBL_MAPS . ".Image");
                    $mName = mysql_result($result_Maps, $map, TBL_MAPS . ".Name");
                    $mDescrition = mysql_result($result_Maps, $map, TBL_MAPS . ".Description");
                    $text .= '<option value="' . $mID . '"';
                    if (strtolower($_POST['map' . $matchMap]) == $mID) {
                        $text .= ' selected="selected"';
                    }
                    $text .= '>' . $mName . '</option>';
                }
                $text .= '</select></td>';
                $text .= '</tr>';
            }
            $text .= '</tbody></table>';
            $text .= '<br />';
        }
    }
    if ($action != 'matchschedule' && $action != 'matchschedulededit') {
        // Comments
        //----------------------------------
        $text .= '<br />';
        $text .= '<div style="display:table; margin-left:auto; margin-right:auto;">';
        $text .= EB_MATCHR_L30 . '<br />';
        $text .= '<textarea class="tbox" id="match_comment" name="match_comment" style="width:400px" cols="70" ' . $insertjs . '>' . $comment . '</textarea>';
        if (!e_WYSIWYG) {
            $text .= '<br />' . display_help("helpb", "comment");
        }
        $text .= '</div>';
        $text .= '<br />';
    }
    if ($action == 'matchschedule' || $action == 'matchschedulededit') {
        //<!-- Date Selection -->
        $text .= EB_MATCHR_L49;
        $text .= '
		<table>
		<tr>
		<td>
		<table>
		<tr>
		<td>
		<div><input class="tbox timepicker" type="text" name="date_scheduled" id="f_date"  value="' . $date_scheduled . '" readonly="readonly" /></div>
		</td>
		<td>
		<div><input class="eb_button" type="button" value="' . EB_MATCHR_L51 . '" onclick="clearDate(this.form);"/></div>
		</td>
		</tr>
		</table>
		</td>
		</tr>
		</table>
		';
    }
    $text .= '<div style="display:table; margin-left:auto; margin-right:auto;">';
    $text .= '<input type="hidden" name="nbr_players" value="' . $nbr_players . '"/>';
    $text .= '<input type="hidden" name="nbr_teams" value="' . $nbr_teams . '"/>';
    $text .= '<input type="hidden" name="userclass" value="' . $userclass . '"/>';
    $text .= '<input type="hidden" name="reported_by" value="' . $reported_by . '"/>';
    $text .= '<input type="hidden" name="time_reported" value="' . $time_reported . '"/>';
    $text .= '<input class="eb_button" type="submit" value="' . $matchreport_str . '" name="submit_match"/>';
    $text .= '<span id="ajaxSpinnerContainer">
	<img src="' . e_PLUGIN . 'ebattles/images/ajax-loader.gif" title="working..." alt="working..."/>
	' . EB_EVENTM_L157 . '
	</span>';
    $text .= '</div>';
    $text .= '</div>';
    $text .= '</form>';
}
Example #4
0
function displayRecentEvents()
{
    global $pref;
    global $sql;
    global $text;
    global $time;
    $pages = new Paginator();
    // how many rows to show per page
    $rowsPerPage = $pref['eb_default_items_per_page'];
    if (!isset($_GET['gameid'])) {
        $_GET['gameid'] = "All";
    }
    $gameid = eb_sanitize($_GET['gameid']);
    if (!isset($_GET['matchtype'])) {
        $_GET['matchtype'] = "All";
    }
    $matchtype = eb_sanitize($_GET['matchtype']);
    $game_string = $gameid == "All" ? "" : "   AND (" . TBL_EVENTS . ".Game = '{$gameid}')";
    $matchtype_string = $matchtype == "All" ? "" : "   AND (" . TBL_GAMES . ".MatchTypes LIKE '%{$matchtype}%')";
    // Drop down list to select Games to display
    $q_Games = "SELECT DISTINCT " . TBL_GAMES . ".*" . " FROM " . TBL_GAMES . ", " . TBL_EVENTS . " WHERE (" . TBL_EVENTS . ".Game = " . TBL_GAMES . ".GameID)" . $matchtype_string . " ORDER BY Name";
    $result_Games = $sql->db_Query($q_Games);
    $numGames = mysql_numrows($result_Games);
    if ($numGames > 0) {
        //$text .= '<div>'.$uname.'&nbsp;'.EB_USER_L35.'</div>';
        // Display list of games icons
        $games_links_list = '<div class="spacer">';
        for ($i = 0; $i < $numGames; $i++) {
            $gname = mysql_result($result_Games, $i, TBL_GAMES . ".Name");
            $gicon = mysql_result($result_Games, $i, TBL_GAMES . ".Icon");
            $gid = mysql_result($result_Games, $i, TBL_GAMES . ".GameID");
            if ($gameid == "All") {
                $gname_selected = EB_EVENTS_L10;
            }
            if ($gid == $gameid) {
                $gname_selected = $gname;
            }
            $games_links_list .= '<a href="' . e_PLUGIN . 'ebattles/events.php?gameid=' . $gid . '"><img ' . getGameIconResize($gicon) . ' title="' . $gname . '"/></a>';
            $games_links_list .= '&nbsp;';
        }
        $games_links_list .= '<br /><b>' . $gname_selected . '</b></div><br />';
    }
    $text .= $games_links_list;
    // Drop down list to select Match type to display
    $q_mt = "SELECT " . TBL_GAMES . ".*" . " FROM " . TBL_GAMES . ", " . TBL_EVENTS . " WHERE (" . TBL_EVENTS . ".Game = " . TBL_GAMES . ".GameID)" . $game_string;
    $result_mt = $sql->db_Query($q_mt);
    $num_mt = mysql_numrows($result_mt);
    $gmatchtypes = '';
    for ($i = 0; $i < $num_mt; $i++) {
        $gmatchtypes .= ',' . mysql_result($result_mt, $i, TBL_GAMES . ".MatchTypes");
    }
    $text .= '<form id="submitformrecent" action="' . htmlspecialchars($_SERVER['PHP_SELF']) . '" method="get">';
    $text .= '<div>';
    $text .= '<table class="table_left">';
    $text .= '<tr>';
    // Match Types drop down
    $text .= '<td>' . EB_EVENTS_L32 . '<br />';
    $text .= '<select class="tbox" name="matchtype" onchange="this.form.submit()">';
    $text .= '<option value="All" ' . ($matchtype == "All" ? 'selected="selected"' : '') . '>' . EB_EVENTS_L10 . '</option>';
    $gmatchtypes = explode(",", $gmatchtypes);
    $gmatchtypes = array_unique($gmatchtypes);
    sort($gmatchtypes);
    foreach ($gmatchtypes as $gmatchtype) {
        if ($gmatchtype != '') {
            $text .= '<option value="' . $gmatchtype . '" ' . ($gmatchtype == $matchtype ? 'selected="selected"' : '') . '>' . htmlspecialchars($gmatchtype) . '</option>';
        }
    }
    $text .= '</select>';
    $text .= '</td>';
    $text .= '</tr>';
    $text .= '</table>';
    $game_string = $gameid == "All" ? "" : "   AND (" . TBL_EVENTS . ".Game = '{$gameid}')";
    $matchtype_string = $matchtype == "All" ? "" : "   AND (" . TBL_EVENTS . ".MatchType = '{$matchtype}')";
    $q = "SELECT " . TBL_EVENTS . ".*, " . TBL_GAMES . ".*" . " FROM " . TBL_EVENTS . ", " . TBL_GAMES . " WHERE (" . TBL_EVENTS . ".Status = 'finished')" . "   AND (" . TBL_EVENTS . ".Game = " . TBL_GAMES . ".GameID)" . $game_string . $matchtype_string . " LIMIT 0, {$rowsPerPage}";
    $result = $sql->db_Query($q);
    $numEvents = mysql_numrows($result);
    if (!$result || $numEvents < 0) {
        /* Error occurred, return given name by default */
        $text .= EB_EVENTS_L11 . '</div>';
        $text .= '</form><br/>';
    } else {
        if ($numEvents == 0) {
            $text .= EB_EVENTS_L12 . '</div>';
            $text .= '</form><br/>';
        } else {
            $text .= '</div>';
            $text .= '</form><br/><br/>';
            /* Display table contents */
            $text .= '<table class="eb_table" style="width:95%"><tbody>';
            $text .= '<tr>
		<th class="eb_th2">' . EB_EVENTS_L13 . '</th>';
            if ($gameid == "All") {
                $text .= '<th colspan="2" class="eb_th2">' . EB_EVENTS_L14 . '</th>';
            }
            $text .= '
		<th class="eb_th2">' . EB_EVENTS_L15 . '</th>
		<th class="eb_th2">' . EB_EVENTS_L16 . '</th>
		<th class="eb_th2">' . EB_EVENTS_L17 . '</th>
		<th class="eb_th2">' . EB_EVENTS_L18 . '</th>
		<th class="eb_th2">' . EB_EVENTS_L19 . '</th>
		<th class="eb_th2">' . EB_EVENTS_L34 . '</th>
		</tr>';
            for ($i = 0; $i < $numEvents; $i++) {
                $gName = mysql_result($result, $i, TBL_GAMES . ".Name");
                $gIcon = mysql_result($result, $i, TBL_GAMES . ".Icon");
                $event_id = mysql_result($result, $i, TBL_EVENTS . ".EventID");
                $event = new Event($event_id);
                if ($event->getField('StartDateTime') != 0) {
                    $startdatetime_local = $event->getField('StartDateTime') + TIMEOFFSET;
                    $date_start = date("d M Y", $startdatetime_local);
                } else {
                    $date_start = "-";
                }
                if ($event->getField('EndDateTime') != 0) {
                    $enddatetime_local = $event->getField('EndDateTime') + TIMEOFFSET;
                    $date_end = date("d M Y", $enddatetime_local);
                } else {
                    $date_end = "-";
                }
                /* Nbr players */
                $q_2 = "SELECT COUNT(*) as NbrPlayers" . " FROM " . TBL_PLAYERS . " WHERE (Event = '{$event_id}')";
                $result_2 = $sql->db_Query($q_2);
                $row = mysql_fetch_array($result_2);
                $nbrplayers = $row['NbrPlayers'];
                /* Nbr Teams */
                $q_2 = "SELECT COUNT(*) as NbrTeams" . " FROM " . TBL_TEAMS . " WHERE (" . TBL_TEAMS . ".Event = '{$event_id}')";
                $result_2 = $sql->db_Query($q_2);
                $row = mysql_fetch_array($result_2);
                $nbrTeams = $row['NbrTeams'];
                /* Nbr matches */
                $q_2 = "SELECT COUNT(DISTINCT " . TBL_MATCHS . ".MatchID) as NbrMatches" . " FROM " . TBL_MATCHS . ", " . TBL_SCORES . " WHERE (Event = '{$event_id}')" . " AND (" . TBL_MATCHS . ".Status = 'active')" . " AND (" . TBL_SCORES . ".MatchID = " . TBL_MATCHS . ".MatchID)";
                $result_2 = $sql->db_Query($q_2);
                $row = mysql_fetch_array($result_2);
                $nbrmatches = $row['NbrMatches'];
                switch ($event->getField('Type')) {
                    case "One Player Ladder":
                    case "One Player Tournament":
                        $nbrTeamPlayers = $nbrplayers;
                        break;
                    case "Team Ladder":
                        $nbrTeamPlayers = $nbrTeams . '/' . $nbrplayers;
                        break;
                    case "Clan Ladder":
                    case "Clan Tournament":
                        $nbrTeamPlayers = $nbrTeams;
                        break;
                    default:
                }
                $text .= '<tr>
			<td class="eb_td"><a href="' . e_PLUGIN . 'ebattles/eventinfo.php?eventid=' . $event_id . '">' . $event->getField('Name') . '</a></td>';
                if ($gameid == "All") {
                    $text .= '<td class="eb_td"><img ' . getGameIconResize($gIcon) . '/></td>
				<td class="eb_td">' . $gName . '</td>';
                }
                $text .= '
			<td class="eb_td">' . ($event->getField('MatchType') != '' ? $event->getField('MatchType') . ' - ' : '') . $event->eventTypeToString() . '</td>
			<td class="eb_td">' . $date_start . '</td>
			<td class="eb_td">' . $date_end . '</td>
			<td class="eb_td">' . $nbrTeamPlayers . '</td>
			<td class="eb_td">' . $nbrmatches . '</td>
			<td class="eb_td">' . $event->eventStatusToString() . '</td>
			</tr>';
            }
            $text .= '</tbody></table><br />';
            $text .= '<div>';
            $text .= ebImageLink('link_to_eventspast', '', e_PLUGIN . 'ebattles/eventspast.php', '', 'action_back.gif', EB_EVENTS_L21, 'jq-button');
            $text .= '</div>';
        }
    }
}
Example #5
0
 $a = new MPQFile($tmpname, true, $debug);
 $init = $a->getState();
 if ($init == false) {
     $text .= "Error parsing uploaded file, make sure it is a valid MPQ archive!<br />\n";
 } else {
     if ($a->getFileType() == "SC2replay") {
         $b = $a->parseReplay();
         $parseDurationString .= sprintf("Parsed replay in %d ms.<br />\n", (microtime_float() - $start) * 1000);
         $players = $b->getPlayers();
         $recorder = $b->getRecorder();
         $error_str = '';
         if ($event_id) {
             $event = new Event($event_id);
             $match = new Match();
             // Check if replay->TeamSize == event->MatchType
             if ($b->getTeamSize() != $event->getField('MatchType')) {
                 $error_str .= '<li>' . EB_SUBMITREPLAY_L3 . '</li>';
             }
             // Check if winner is known
             if (!$b->isWinnerKnown()) {
                 $error_str .= '<li>' . EB_SUBMITREPLAY_L4 . '</li>';
             }
             // Check if the replay has already been submitted.
             $q2 = "SELECT " . TBL_MATCHS . ".*" . " FROM " . TBL_MATCHS . " WHERE (" . TBL_MATCHS . ".TimePlayed = '" . $b->getCtime() . "')";
             $result2 = $sql->db_Query($q2);
             $num_rows = mysql_numrows($result2);
             if ($num_rows != 0) {
                 $error_str .= '<li>' . EB_SUBMITREPLAY_L7 . '</li>';
             }
             $match->setField('Event', $event_id);
             $match->setField('ReportedBy', USERID);
Example #6
0
    $pid = $_POST['player'];
    // Player can quit an event if he has not played yet
    // TODO - can quit if event not started.
    $q = "SELECT DISTINCT " . TBL_PLAYERS . ".*" . " FROM " . TBL_PLAYERS . ", " . TBL_SCORES . " WHERE (" . TBL_PLAYERS . ".PlayerID = '{$pid}')" . " AND (" . TBL_SCORES . ".Player = " . TBL_PLAYERS . ".PlayerID)";
    $result = $sql->db_Query($q);
    $nbrscores = mysql_numrows($result);
    if ($nbrscores == 0) {
        deletePlayer($pid);
        $event->setFieldDB('IsChanged', 1);
    }
    header("Location: eventinfo.php?eventid={$event_id}");
}
if (isset($_POST['checkinevent'])) {
    $pid = $_POST['player'];
    checkinPlayer($pid);
    if ($event->getField('FixturesEnable') == TRUE && $event->getField('Status') == 'active') {
        $event->brackets(true);
    }
    $event->setFieldDB('IsChanged', 1);
    header("Location: eventinfo.php?eventid={$event_id}");
}
if (isset($_POST['teamcheckinevent'])) {
    $team_id = $_POST['team'];
    checkinTeam($team_id);
    if ($event->getField('FixturesEnable') == TRUE && $event->getField('Status') == 'active') {
        $event->brackets(true);
    }
    $event->setFieldDB('IsChanged', 1);
    header("Location: eventinfo.php?eventid={$event_id}");
}
if (isset($_POST['joinevent'])) {
Example #7
0
 function challengeDecline()
 {
     global $sql;
     global $tp;
     global $time;
     global $pref;
     // Get info about the challenge
     $q = "SELECT DISTINCT " . TBL_CHALLENGES . ".*, " . TBL_USERS . ".*, " . TBL_EVENTS . ".*, " . TBL_GAMES . ".*" . " FROM " . TBL_CHALLENGES . ", " . TBL_USERS . ", " . TBL_EVENTS . ", " . TBL_GAMES . " WHERE (" . TBL_CHALLENGES . ".ChallengeID = '" . $this->fields['ChallengeID'] . "')" . " AND (" . TBL_USERS . ".user_id = " . TBL_CHALLENGES . ".ReportedBy)" . " AND (" . TBL_CHALLENGES . ".Event = " . TBL_EVENTS . ".EventID)" . " AND (" . TBL_EVENTS . ".Game = " . TBL_GAMES . ".GameID)";
     $result = $sql->db_Query($q);
     $numChallenges = mysql_numrows($result);
     if ($numChallenges > 0) {
         $cReportedBy = mysql_result($result, 0, TBL_USERS . ".user_id");
         $cReportedByNickName = mysql_result($result, 0, TBL_USERS . ".user_name");
         $cReportedByEmail = mysql_result($result, 0, TBL_USERS . ".user_email");
         $event_id = mysql_result($result, 0, TBL_EVENTS . ".EventID");
         $event = new Event($event_id);
         $subject = SITENAME . " " . EB_CHALLENGE_L29;
         $message = EB_CHALLENGE_L30 . $cReportedByNickName . EB_CHALLENGE_L31 . USERNAME . EB_CHALLENGE_L32 . $event->getField('Name') . EB_CHALLENGE_L33;
         $fromid = 0;
         $sendto = $cReportedBy;
         $sendtoemail = $cReportedByEmail;
         if (check_class($pref['eb_pm_notifications_class'])) {
             // Send PM
             sendNotification($sendto, $subject, $message, $fromid);
         }
         if (check_class($pref['eb_email_notifications_class'])) {
             // Send email
             require_once e_HANDLER . "mail.php";
             sendemail($sendtoemail, $subject, $message);
         }
     }
     $this->deleteChallenge();
 }
Example #8
0
<script type="text/javascript" src="' . e_PLUGIN . 'ebattles/js/slider.js"></script>
';
$event_id = intval($_GET['eventid']);
if (!$event_id) {
    header("Location: ./events.php");
    exit;
}
$q = "SELECT " . TBL_EVENTS . ".*, " . TBL_GAMES . ".*, " . TBL_USERS . ".*" . " FROM " . TBL_EVENTS . ", " . TBL_GAMES . ", " . TBL_USERS . " WHERE (" . TBL_EVENTS . ".EventID = '{$event_id}')" . "   AND (" . TBL_EVENTS . ".Game = " . TBL_GAMES . ".GameID)" . "   AND (" . TBL_USERS . ".user_id = " . TBL_EVENTS . ".Owner)";
$result = $sql->db_Query($q);
$event = new Event($event_id);
$egame = mysql_result($result, 0, TBL_GAMES . ".Name");
$egameid = mysql_result($result, 0, TBL_GAMES . ".GameID");
$egameicon = mysql_result($result, 0, TBL_GAMES . ".Icon");
$eowner = mysql_result($result, 0, TBL_USERS . ".user_id");
$eownername = mysql_result($result, 0, TBL_USERS . ".user_name");
$eventIsChanged = $event->getField('IsChanged');
$eventStatus = $event->getField('Status');
$rounds = unserialize($event->getFieldHTML('Rounds'));
$eMaxNumberPlayers = $event->getField('MaxNumberPlayers');
$type = $event->getField('Type');
$competition_type = $event->getCompetitionType();
/* Nbr players */
$q = "SELECT COUNT(*) as NbrPlayers" . " FROM " . TBL_PLAYERS . " WHERE (" . TBL_PLAYERS . ".Event = '{$event_id}')";
$result = $sql->db_Query($q);
$row = mysql_fetch_array($result);
$nbr_players = $row['NbrPlayers'];
$q = "SELECT " . TBL_PLAYERS . ".*" . " FROM " . TBL_PLAYERS . " WHERE (" . TBL_PLAYERS . ".Event = '{$event_id}')" . " AND (" . TBL_PLAYERS . ".CheckedIn = '1')" . " AND (" . TBL_PLAYERS . ".Seed <= '{$eMaxNumberPlayers}')";
$result = $sql->db_Query($q);
$nbr_players_checked_in = mysql_numrows($result);
/* Nbr Teams */
$q = "SELECT COUNT(*) as NbrTeams" . " FROM " . TBL_TEAMS . " WHERE (Event = '{$event_id}')";
Example #9
0
 function addMember($user, $notify)
 {
     global $sql;
     global $time;
     $div_id = $this->fields['DivisionID'];
     $game_id = $this->fields['Game'];
     $q = "SELECT " . TBL_USERS . ".*" . " FROM " . TBL_USERS . " WHERE (" . TBL_USERS . ".user_id = '{$user}')";
     $result = $sql->db_Query($q);
     $Name = mysql_result($result, 0, TBL_USERS . ".user_name");
     $UniqueGameID = "";
     $gamerID = updateGamer($user, $game_id, $Name, $UniqueGameID);
     $q = " INSERT INTO " . TBL_MEMBERS . "(Division,User,timestamp)\r\n\t\tVALUES ({$div_id},{$user},{$time})";
     $sql->db_Query($q);
     // User will automatically be signed up to all current events this division participates in
     $q_2 = "SELECT " . TBL_TEAMS . ".*, " . TBL_EVENTS . ".*" . " FROM " . TBL_TEAMS . ", " . TBL_EVENTS . " WHERE (" . TBL_TEAMS . ".Division = '{$div_id}')" . " AND (" . TBL_TEAMS . ".Event = " . TBL_EVENTS . ".EventID)" . " AND (" . TBL_EVENTS . ".Status != 'finished')";
     $result_2 = $sql->db_Query($q_2);
     $num_rows_2 = mysql_numrows($result_2);
     if ($num_rows_2 > 0) {
         for ($j = 0; $j < $num_rows_2; $j++) {
             $event_id = mysql_result($result_2, $j, TBL_EVENTS . ".EventID");
             $event = new Event($event_id);
             $team_id = mysql_result($result_2, $j, TBL_TEAMS . ".TeamID");
             $team_banned = mysql_result($result_2, $j, TBL_TEAMS . ".Banned");
             // Verify there is no other player for that user/event/team
             $q = "SELECT COUNT(*) as NbrPlayers" . " FROM " . TBL_PLAYERS . " WHERE (Event = '{$event_id}')" . " AND (Team = '{$team_id}')" . " AND (User = "******")";
             $result = $sql->db_Query($q);
             $row = mysql_fetch_array($result);
             $nbrplayers = $row['NbrPlayers'];
             if ($nbrplayers == 0) {
                 $q = " INSERT INTO " . TBL_PLAYERS . "(Event,Gamer,Team,ELORanking,TS_mu,TS_sigma,G2_r,G2_RD,G2_sigma,Joined,Banned)\r\n\t\t\t\t\tVALUES ({$event_id}, {$gamerID}, {$team_id}, " . $event->getField('ELO_default') . ", " . $event->getField('TS_default_mu') . ", " . $event->getField('TS_default_sigma') . "," . $event->fields['G2_default_r'] . "," . $event->fields['G2_default_RD'] . "," . $event->fields['G2_default_sigma'] . ",{$time}, {$team_banned})";
                 $sql->db_Query($q);
                 $event->setFieldDB('IsChanged', 1);
             }
         }
     }
     if ($notify) {
         list($cname, $ctag, $cid) = $this->getClanInfo();
         $sendto = $user;
         $subject = SITENAME . " " . $cname;
         $message = EB_CLANM_L39 . $username . EB_CLANM_L40 . $cname . EB_CLANM_L41 . EB_CLANM_L43;
         sendNotification($sendto, $subject, $message, $fromid = 0);
         // Send email
         $message = EB_CLANM_L39 . $username . EB_CLANM_L39 . $cname . EB_CLANM_L42 . SITEURLBASE . e_PLUGIN_ABS . "ebattles/claninfo.php?clanid=" . $cid . EB_CLANM_L43;
         require_once e_HANDLER . "mail.php";
         sendemail($useremail, $subject, $message);
     }
 }
Example #10
0
                $prank_txt = EB_EVENT_L54;
            } else {
                $prank_txt = "#{$prank}";
            }
            $text .= '<option value="' . $pid . '">' . $pclantag . $pname . ' (' . $prank_txt . ')</option>';
        }
    }
    $text .= '
	</select>
	</td>
	</tr>
	<tr>
	<td>
	';
    $reported_by = USERID;
    $text .= '<div>';
    $text .= '<input type="hidden" name="EventID" value="' . $event_id . '"/>';
    $text .= '<input type="hidden" name="reported_by" value="' . $reported_by . '"/>';
    $text .= '
	</div>
	' . ebImageTextButton('qrsubmitloss', 'flag_red.png', EB_MATCHQL_L6) . '
	</td>
	</tr>
	</table>
	</form>
	</div>
	';
}
$ns->tablerender($event->getField('Name') . " ({$egame} - " . $event->eventTypeToString() . ") - " . EB_MATCHQL_L1, $text);
require_once FOOTERF;
exit;
Example #11
0
require_once e_PLUGIN . "ebattles/include/clan.php";
/*******************************************************************
********************************************************************/
// Specify if we use WYSIWYG for text areas
global $e_wysiwyg;
$e_wysiwyg = "match_comment";
// set $e_wysiwyg before including HEADERF
$event_id = intval($_GET['eventid']);
$match_id = intval($_GET['matchid']);
$action = eb_sanitize($_GET['actionid']);
if (!$event_id) {
    header("Location: ./events.php");
    exit;
}
$event = new Event($event_id);
$type = $event->getField('Type');
$competition_type = $event->getCompetitionType();
$matchtype = $event->getField('MatchType');
//------------ event permissions --------------
$event_permissions = $event->get_permissions(USERID);
$userclass = $event_permissions['userclass'];
$can_report = $event_permissions['can_report'];
$can_schedule = $event_permissions['can_schedule'];
switch ($event->getMatchPlayersType()) {
    case 'Players':
        $q = "SELECT " . TBL_PLAYERS . ".*, " . TBL_USERS . ".*, " . TBL_GAMERS . ".*" . " FROM " . TBL_PLAYERS . ", " . TBL_GAMERS . ", " . TBL_USERS . " WHERE (" . TBL_PLAYERS . ".Event = '{$event_id}')" . " AND (" . TBL_PLAYERS . ".Banned != 1)" . " AND (" . TBL_PLAYERS . ".Gamer = " . TBL_GAMERS . ".GamerID)" . " AND (" . TBL_USERS . ".user_id = " . TBL_GAMERS . ".User)" . " ORDER BY " . TBL_GAMERS . ".UniqueGameID";
        $result = $sql->db_Query($q);
        $num_rows = mysql_numrows($result);
        if (!$result) {
            die('Invalid query: ' . mysql_error());
        }
Example #12
0
function SubmitTeamChallenge($event_id, $challengerpuid, $challengedtid)
{
    global $sql;
    global $text;
    global $tp;
    global $time;
    global $pref;
    $event = new Event($event_id);
    // Challenger Info
    // Attention here, we use user_id, so there has to be 1 user for 1 player
    $q = "SELECT " . TBL_PLAYERS . ".*, " . TBL_USERS . ".*" . " FROM " . TBL_PLAYERS . ", " . TBL_GAMERS . ", " . TBL_USERS . " WHERE (" . TBL_PLAYERS . ".Event = '{$event_id}')" . "   AND (" . TBL_PLAYERS . ".Gamer = " . TBL_GAMERS . ".GamerID)" . "   AND (" . TBL_USERS . ".user_id = " . TBL_GAMERS . ".User)" . "   AND (" . TBL_USERS . ".user_id = '{$challengerpuid}')";
    $result = $sql->db_Query($q);
    $challengerpid = mysql_result($result, 0, TBL_PLAYERS . ".PlayerID");
    $challengertid = mysql_result($result, 0, TBL_PLAYERS . ".Team");
    list($challengertclan, $challengertclantag, $challengertclanid) = getClanInfo($challengertid);
    // Challenged Info
    // Nothing needed here
    // ...
    $challenge_times = '';
    for ($date = 1; $date <= $event->getField('MaxDatesPerChallenge'); $date++) {
        $challenge_date = $_POST['date' . $date];
        $challenge_time_local = strtotime($challenge_date);
        $challenge_time_local = $challenge_time_local - TIMEOFFSET;
        // Convert to GMT time
        if ($date > 1) {
            $challenge_times .= ',';
        }
        $challenge_times .= $challenge_time_local;
    }
    // comments
    //----------------------------------
    $comments = $tp->toDB($_POST['challenge_comments']);
    $time_reported = $time;
    // Create Challenge ------------------------------------------
    $q = "INSERT INTO " . TBL_CHALLENGES . "(Event,ChallengerTeam,ChallengedTeam,ReportedBy,TimeReported,Comments,Status,MatchDates)\r\n\tVALUES (\r\n\t'{$event_id}',\r\n\t'{$challengertid}',\r\n\t'{$challengedtid}',\r\n\t'{$challengerpuid}',\r\n\t'{$time_reported}',\r\n\t'{$comments}',\r\n\t'requested',\r\n\t'{$challenge_times}'\r\n\t)";
    $result = $sql->db_Query($q);
    // Send PM
    $fromid = 0;
    $subject = SITENAME . " " . EB_CHALLENGE_L23;
    // All members of the challenged division will receive the PM
    $q = "SELECT " . TBL_TEAMS . ".*, " . TBL_MEMBERS . ".*, " . TBL_USERS . ".*" . " FROM " . TBL_TEAMS . ", " . TBL_USERS . ", " . TBL_MEMBERS . " WHERE (" . TBL_TEAMS . ".TeamID = '{$challengedtid}')" . " AND (" . TBL_MEMBERS . ".Division = " . TBL_TEAMS . ".Division)" . " AND (" . TBL_USERS . ".user_id = " . TBL_MEMBERS . ".User)";
    $result = $sql->db_Query($q);
    $num_rows = mysql_numrows($result);
    if ($num_rows > 0) {
        for ($j = 0; $j < $num_rows; $j++) {
            $challengedpname = mysql_result($result, $j, TBL_USERS . ".user_name");
            $challengedpemail = mysql_result($result, $j, TBL_USERS . ".user_email");
            $message = EB_CHALLENGE_L24 . $challengedpname . EB_CHALLENGE_L25 . $challengertclan . EB_CHALLENGE_L26 . $event->getField('Name') . EB_CHALLENGE_L27;
            if (check_class($pref['eb_pm_notifications_class'])) {
                $sendto = mysql_result($result, $j, TBL_USERS . ".user_id");
                sendNotification($sendto, $subject, $message, $fromid);
            }
            if (check_class($pref['eb_email_notifications_class'])) {
                // Send email
                require_once e_HANDLER . "mail.php";
                sendemail($challengedpemail, $subject, $message);
            }
        }
    }
}
Example #13
0
 $prating = 0;
 $prating_votes = 0;
 for ($scoreIndex = 0; $scoreIndex < $numScores; $scoreIndex++) {
     $sid = mysql_result($result_Scores, $scoreIndex, TBL_SCORES . ".ScoreID");
     // Get user rating.
     $rate = $rater->GetRating("ebscores", $sid);
     $prating += $rate[0] * ($rate[1] + $rate[2] / 10);
     $prating_votes += $rate[0];
 }
 if ($prating_votes != 0) {
     $prating /= $prating_votes;
 }
 $rating = displayRating($prating, $prating_votes);
 $text .= '<tr>';
 $text .= '<td class="eb_td">';
 $text .= '<a href="' . e_PLUGIN . 'ebattles/eventinfo.php?eventid=' . $event_id . '">' . $event->getField('Name') . '</a>';
 $text .= '</td>';
 //$text .= '<td class="eb_td">';
 //$text .= '<img '.getGameIconResize($gIcon).'/> '.$gName;
 //$text .= '</td>';
 $text .= '<td class="eb_td">';
 $text .= $pRank;
 $text .= '</td>';
 $text .= '<td class="eb_td">';
 $text .= $pWinLoss;
 $text .= '</td>';
 $text .= '<td class="eb_td">';
 $text .= $rating;
 $text .= '</td>';
 $text .= '<td class="eb_td">';
 $text .= $event->eventStatusToString();
Example #14
0
/* Nbr players */
$q = "SELECT COUNT(*) as NbrPlayers" . " FROM " . TBL_PLAYERS . " WHERE (" . TBL_PLAYERS . ".Event = '" . $event_id . "')";
$result = $sql->db_Query($q);
$row = mysql_fetch_array($result);
$nbrplayers = $row['NbrPlayers'];
/* Nbr Teams */
$q = "SELECT COUNT(*) as NbrTeams" . " FROM " . TBL_TEAMS . " WHERE (Event = '" . $event_id . "')";
$result = $sql->db_Query($q);
$row = mysql_fetch_array($result);
$nbrteams = $row['NbrTeams'];
$update_matchupsfile = 0;
$can_manage = 0;
if (check_class($pref['eb_mod_class'])) {
    $can_manage = 1;
}
if (USERID == $event->getField('Owner')) {
    $can_manage = 1;
}
if ($action == 'create' && check_class($pref['eb_events_create_class'])) {
    $can_manage = 1;
}
if ($can_manage == 0) {
    header("Location: ./eventinfo.php?eventid={$event_id}");
    exit;
}
$event->setFieldDB('IsChanged', 1);
if (isset($_POST['eventpublish'])) {
    /* Event Status */
    $event->setFieldDB('Status', 'signup');
    //echo "-- eventpublish --<br />";
    header("Location: eventmanage.php?eventid={$event_id}");
Example #15
0
$event = new Event($event_id);
//------------ permissions --------------
$permissions = $event->get_permissions(USERID);
$userclass = $permissions['userclass'];
$can_approve = $permissions['can_approve'];
$can_report = $permissions['can_report'];
$can_schedule = $permissions['can_schedule'];
$can_report_quickloss = $permissions['can_report_quickloss'];
$can_submit_replay = $permissions['can_submit_replay'];
$can_challenge = $permissions['can_challenge'];
$egame = mysql_result($result, 0, TBL_GAMES . ".Name");
$egameid = mysql_result($result, 0, TBL_GAMES . ".GameID");
$egameicon = mysql_result($result, 0, TBL_GAMES . ".Icon");
$eowner = mysql_result($result, 0, TBL_USERS . ".user_id");
$eownername = mysql_result($result, 0, TBL_USERS . ".user_name");
$eventIsChanged = $event->getField('IsChanged');
$eventStatus = $event->getField('Status');
$rounds = unserialize($event->getFieldHTML('Rounds'));
$eMaxNumberPlayers = $event->getField('MaxNumberPlayers');
$type = $event->getField('Type');
$competition_type = $event->getCompetitionType();
/* Nbr players */
$q = "SELECT COUNT(*) as NbrPlayers" . " FROM " . TBL_PLAYERS . " WHERE (" . TBL_PLAYERS . ".Event = '{$event_id}')";
$result = $sql->db_Query($q);
$row = mysql_fetch_array($result);
$nbr_players = $row['NbrPlayers'];
$q = "SELECT " . TBL_PLAYERS . ".*" . " FROM " . TBL_PLAYERS . " WHERE (" . TBL_PLAYERS . ".Event = '{$event_id}')" . " AND (" . TBL_PLAYERS . ".CheckedIn = '1')" . " AND (" . TBL_PLAYERS . ".Seed <= '{$eMaxNumberPlayers}')";
$result = $sql->db_Query($q);
$nbr_players_checked_in = mysql_numrows($result);
/* Nbr Teams */
$q = "SELECT COUNT(*) as NbrTeams" . " FROM " . TBL_TEAMS . " WHERE (Event = '{$event_id}')";
function user_form($action, $players_id, $players_name, $event_id, $match_id, $allowDraw, $allowForfeit, $allowScore, $userclass, $date_scheduled, $user_player)
{
    global $sql;
    global $text;
    global $tp;
    global $time;
    /* Event Info */
    $event = new Event($event_id);
    if (e_WYSIWYG) {
        $insertjs = "rows='5'";
    } else {
        require_once e_HANDLER . "ren_help.php";
        $insertjs = "rows='5' onselect='storeCaret(this);' onclick='storeCaret(this);' onkeyup='storeCaret(this);'";
    }
    /*
    //dbg form
    echo "<br>_POST: ";
    var_dump($_POST);
    echo "<br>_GET: ";
    var_dump($_GET);
    */
    $match_str = '';
    $matchreport_str = EB_MATCHR_L31;
    if ($action == 'matchedit') {
        $matchreport_str = EB_MATCHR_L46;
        $text .= '<div>';
        $text .= EB_MATCHR_L45 . " {$match_id}<br />";
        $text .= '<img src="' . e_PLUGIN . 'ebattles/images/exclamation.png"/>';
        $text .= EB_MATCHR_L47;
        $text .= '</div><br />';
    }
    if ($action == 'matchschedulededit') {
        $matchreport_str = EB_MATCHR_L46;
        $text .= '<div>';
        $text .= EB_MATCHR_L45 . " {$match_id}<br />";
        $text .= '</div><br />';
    }
    if ($action == 'matchschedule') {
        $matchreport_str = EB_MATCHR_L48;
    }
    if ($match_id) {
        $match_str = '&amp;matchid=' . $match_id;
    }
    if ($action) {
        $action_str = '&amp;actionid=' . $action;
    }
    // Assign values to POST if not set
    // fm: check might not be correct here
    // should check if $action=='matchedit') only?
    if (!isset($_POST['time_reported']) || $action == 'matchscheduledreport') {
        $_POST['time_reported'] = $time;
    }
    $time_reported = $_POST['time_reported'];
    if (!isset($_POST['reported_by'])) {
        $_POST['reported_by'] = USERID;
    }
    $reported_by = $_POST['reported_by'];
    if (isset($_POST['match_comment'])) {
        $comment = $tp->toDB($_POST['match_comment']);
    } else {
        $comment = '';
    }
    for ($matchMap = 0; $matchMap < min($numMaps, $event->getField('MaxMapsPerMatch')); $matchMap++) {
        if (!isset($_POST['map' . $matchMap])) {
            $_POST['map' . $matchMap] = 0;
        }
    }
    // if vars are not set, set them as empty.
    if (!isset($_POST['nbr_players'])) {
        $_POST['nbr_players'] = 2;
    }
    if (!isset($_POST['nbr_teams'])) {
        $_POST['nbr_teams'] = 2;
    }
    // now to output the form HTML.
    $max_nbr_players = count($players_id) - 1;
    $nbr_players = $_POST['nbr_players'];
    $nbr_teams = $_POST['nbr_teams'];
    if (isset($_POST['addPlayer'])) {
        $nbr_players++;
    }
    if (isset($_POST['removePlayer'])) {
        $nbr_players--;
    }
    if ($nbr_players > $max_nbr_players) {
        $nbr_players = $max_nbr_players;
    }
    if ($nbr_players < 2) {
        $nbr_players = 2;
    }
    $_POST['nbr_players'] = $nbr_players;
    for ($i = 1; $i <= $nbr_players; $i++) {
        if (!isset($_POST['player' . $i])) {
            $_POST['player' . $i] = $players_id[0];
        }
        //debug - echo "Player #".$i.": ".$_POST['player'.$i]."<br />";
    }
    if (isset($_POST['addTeam'])) {
        $nbr_teams++;
    }
    if (isset($_POST['removeTeam'])) {
        $nbr_teams--;
    }
    if ($nbr_teams > $max_nbr_players) {
        $nbr_teams = $max_nbr_players;
    }
    if ($nbr_teams < 2) {
        $nbr_teams = 2;
    }
    $_POST['nbr_teams'] = $nbr_teams;
    for ($i = 1; $i <= $nbr_players; $i++) {
        if (!isset($_POST['team' . $i])) {
            $_POST['team' . $i] = 'Team #' . $i;
        }
        if (!isset($_POST['score' . $i])) {
            $_POST['score' . $i] = 0;
        }
        if (!isset($_POST['faction' . $i])) {
            $_POST['faction' . $i] = 0;
        }
    }
    for ($i = 1; $i <= $nbr_teams; $i++) {
        if (!isset($_POST['rank' . $i])) {
            $_POST['rank' . $i] = 'Team #' . $i;
        }
    }
    //[dbg]$text .= "nbr_players = $nbr_players, nbr_teams = $nbr_teams<br>";
    /////////////////
    /// MAIN FORM ///
    /////////////////
    $text .= '<form id="matchreportform" action="' . htmlspecialchars($_SERVER['PHP_SELF']) . '?eventid=' . $event_id . $match_str . $action_str . '" method="post">';
    $text .= '<div>';
    // TABLE - Player/Teams Add/Remove
    //----------------------------------
    if ($action != 'matchscheduledreport' && $action != 'matchschedulededit') {
        $text .= EB_MATCHR_L15;
        $text .= '<table id="matchresult_nbrPlayersTeams"><tbody>';
        // Nbr of Players
        $text .= '<tr><td>' . $nbr_players . '&nbsp;' . EB_MATCHR_L21 . '</td>';
        $text .= '<td><input type="hidden" name="nbr_players" value="' . $_POST['nbr_players'] . '"/>';
        // Add Player
        if ($nbr_players < $max_nbr_players) {
            $text .= '<input class="eb_button" type="submit" value="' . EB_MATCHR_L16 . '" name="addPlayer"/></td>';
        } else {
            $text .= '<input class="button_disabled" type="submit" value="' . EB_MATCHR_L16 . '" name="addPlayer" disabled="disabled"/></td>';
        }
        // Remove Player
        if ($nbr_players > 2) {
            $text .= '<td><input class="eb_button" type="submit" value="' . EB_MATCHR_L17 . '" name="removePlayer"/></td>';
        } else {
            $text .= '<td><input class="button_disabled" type="submit" value="' . EB_MATCHR_L17 . '" name="removePlayer" disabled="disabled"/></td>';
        }
        $text .= '</tr>';
        // Nbr of Teams
        $text .= '<tr><td>' . $nbr_teams . '&nbsp;' . EB_MATCHR_L22 . '</td>';
        $text .= '<td><input type="hidden" name="nbr_teams" value="' . $_POST['nbr_teams'] . '"/>';
        // Add Team
        if ($nbr_teams < $nbr_players) {
            $text .= '<input class="eb_button" type="submit" value="' . EB_MATCHR_L18 . '" name="addTeam"/></td>';
        } else {
            $text .= '<input class="button_disabled" type="submit" value="' . EB_MATCHR_L18 . '" name="addTeam" disabled="disabled"/></td>';
        }
        // Remove Team
        if ($nbr_teams > 2) {
            $text .= '<td><input class="eb_button" type="submit" value="' . EB_MATCHR_L19 . '" name="removeTeam"/></td>';
        } else {
            $text .= '<td><input class="button_disabled" type="submit" value="' . EB_MATCHR_L19 . '" name="removeTeam" disabled="disabled"/></td>';
        }
        $text .= '</tr>';
        $text .= '</tbody></table>';
        //$text .= '<p><input class="inspector" type="button" value="Inspect" onclick="junkdrawer.inspectListOrder(\'matchresultlist\')"/></p>';
        $text .= '<br />';
    }
    // TABLE - Players/Teams Selection
    //----------------------------------
    // List of all Factions
    $q_Factions = "SELECT " . TBL_FACTIONS . ".*" . " FROM " . TBL_FACTIONS . " WHERE (" . TBL_FACTIONS . ".Game = '" . $event->getField('Game') . "')";
    $result_Factions = $sql->db_Query($q_Factions);
    $numFactions = mysql_numrows($result_Factions);
    $disable_input = $action == 'matchscheduledreport' ? 1 : 0;
    if ($action != 'matchscheduledreport') {
        $text .= EB_MATCHR_L20;
    }
    $text .= '<table id="matchresult_selectPlayersTeams"><tbody>';
    $text .= '<tr><td></td><td>' . EB_MATCHR_L38 . '</td>';
    $text .= '<td>' . EB_MATCHR_L25 . '</td>';
    if ($action != 'matchschedule' && $action != 'matchschedulededit' && $allowScore == TRUE) {
        $text .= '<td>' . EB_MATCHR_L26 . '</td>';
    }
    if ($action != 'matchschedule' && $action != 'matchschedulededit' && $numFactions > 0) {
        $text .= '<td>' . EB_MATCHR_L41 . '</td>';
    }
    $text .= '</tr>';
    for ($i = 1; $i <= $nbr_players; $i++) {
        $text .= '<tr><td>' . EB_MATCHR_L23 . $i . ':&nbsp;</td>';
        $match_winner = 0;
        if ($event->getField('match_report_userclass') == eb_UC_MATCH_WINNER && $i == 1 && $user_player != 0) {
            $match_winner = 1;
            $_POST['player' . $i] = $user_player;
        }
        if ($disable_input == 1 || $match_winner == 1) {
            for ($j = 1; $j <= $max_nbr_players + 1; $j++) {
                if (strtolower($_POST['player' . $i]) == strtolower($players_id[$j - 1])) {
                    $text .= '<td><input type="hidden" name="player' . $i . '" value="' . $players_id[$j - 1] . '"/>';
                    $text .= $players_name[$j - 1] . '</td>';
                }
            }
        } else {
            $text .= '<td><select class="tbox" name="player' . $i . '">';
            for ($j = 1; $j <= $max_nbr_players + 1; $j++) {
                $text .= '<option value="' . $players_id[$j - 1] . '"';
                if (strtolower($_POST['player' . $i]) == strtolower($players_id[$j - 1])) {
                    $text .= ' selected="selected"';
                }
                $text .= '>' . $players_name[$j - 1] . '</option>';
            }
            $text .= '</select></td>';
        }
        if ($disable_input == 1) {
            for ($j = 1; $j <= $nbr_teams; $j++) {
                if (strtolower($_POST['team' . $i]) == 'team #' . $j) {
                    $text .= '<td><input type="hidden" name="team' . $j . '" value="Team #' . $j . '"/>';
                    $text .= EB_MATCHR_L29 . $j . '</td>';
                }
            }
        } else {
            $text .= '<td><select class="tbox" name="team' . $i . '">';
            for ($j = 1; $j <= $nbr_teams; $j++) {
                $text .= '<option value="Team #' . $j . '"';
                if (strtolower($_POST['team' . $i]) == 'team #' . $j) {
                    $text .= ' selected="selected"';
                }
                $text .= '>' . EB_MATCHR_L29 . $j . '</option>';
            }
            $text .= '</select></td>';
        }
        if ($action != 'matchschedule' && $action != 'matchschedulededit') {
            if ($allowScore == TRUE) {
                $text .= '<td>';
                $text .= '<input class="tbox" type="text" size="3" name="score' . $i . '" value="' . $_POST['score' . $i] . '"/>';
                $text .= '</td>';
            }
            if ($numFactions > 0) {
                $text .= '<td><select class="tbox" name="faction' . $i . '">';
                $text .= '<option value="0"';
                $text .= '>' . EB_MATCHR_L43 . '</option>';
                for ($faction = 1; $faction <= $numFactions; $faction++) {
                    $fID = mysql_result($result_Factions, $faction - 1, TBL_FACTIONS . ".FactionID");
                    $fIcon = mysql_result($result_Factions, $faction - 1, TBL_FACTIONS . ".Icon");
                    $fName = mysql_result($result_Factions, $faction - 1, TBL_FACTIONS . ".Name");
                    $text .= '<option value="' . $fID . '"';
                    if (strtolower($_POST['faction' . $i]) == $fID) {
                        $text .= ' selected="selected"';
                    }
                    $text .= '>' . $fName . '</option>';
                }
                $text .= '</select></td>';
            }
        }
        $text .= '</tr>';
    }
    $text .= '</tbody></table>';
    $text .= '<br />';
    if ($action != 'matchschedule' && $action != 'matchschedulededit') {
        // TABLE - Teams Rank Selection
        //----------------------------------
        $text .= EB_MATCHR_L24;
        $text .= '<table id="matchresult_rankTeams"><tbody>';
        $text .= '<tr><td></td><td>' . EB_MATCHR_L25 . '</td>';
        if ($allowDraw == TRUE) {
            $text .= '<td>' . EB_MATCHR_L27 . '</td>';
        }
        if ($allowForfeit == TRUE) {
            $text .= '<td>' . EB_MATCHR_L57 . '</td>';
        }
        $text .= '</tr>';
        for ($i = 1; $i <= $nbr_teams; $i++) {
            $text .= '<tr>';
            $text .= '<td>';
            $text .= EB_MATCHR_L28 . $i . ':';
            $text .= '</td>';
            $text .= '<td><select class="tbox" name="rank' . $i . '" id="rank' . $i . '" onchange = "SwitchSelected(' . $i . ')">';
            for ($j = 1; $j <= $nbr_teams; $j++) {
                $text .= '<option value="Team #' . $j . '"';
                if (strtolower($_POST['rank' . $i]) == 'team #' . $j) {
                    $text .= ' selected="selected"';
                }
                $text .= '>' . EB_MATCHR_L29 . $j . '</option>';
            }
            $text .= '</select></td>';
            if ($allowDraw == TRUE) {
                $text .= '<td>';
                if ($i > 1) {
                    $text .= '<input class="tbox" type="checkbox" name="draw' . $i . '" value="1"';
                    if (strtolower($_POST['draw' . $i]) != "") {
                        $text .= ' checked="checked"';
                    }
                    $text .= '/>';
                }
                $text .= '</td>';
            }
            if ($allowForfeit == TRUE) {
                $text .= '<td>';
                if ($i > 1) {
                    $text .= '<input class="tbox" type="checkbox" name="forfeit' . $i . '" value="1"';
                    if (strtolower($_POST['forfeit' . $i]) != "") {
                        $text .= ' checked="checked"';
                    }
                    $text .= '/>';
                }
                $text .= '</td>';
            }
            $text .= '</tr>';
        }
        $text .= '</tbody></table>';
    }
    // Map Selection
    //----------------------------------
    // List of all Maps
    $q_Maps = "SELECT " . TBL_MAPS . ".*" . " FROM " . TBL_MAPS . " WHERE (" . TBL_MAPS . ".Game = '" . $event->getField('Game') . "')";
    $result_Maps = $sql->db_Query($q_Maps);
    $numMaps = mysql_numrows($result_Maps);
    if ($numMaps > 0) {
        $text .= EB_MATCHR_L42;
        $text .= '<table id="matchresult_selectMap" class="table_left"><tbody>';
        for ($matchMap = 0; $matchMap < min($numMaps, $event->getField('MaxMapsPerMatch')); $matchMap++) {
            $text .= '<tr>';
            $text .= '<td><select class="tbox" name="map' . $matchMap . '">';
            $text .= '<option value="0"';
            $text .= '>' . EB_MATCHR_L43 . '</option>';
            for ($map = 0; $map < $numMaps; $map++) {
                $mID = mysql_result($result_Maps, $map, TBL_MAPS . ".MapID");
                $mImage = mysql_result($result_Maps, $map, TBL_MAPS . ".Image");
                $mName = mysql_result($result_Maps, $map, TBL_MAPS . ".Name");
                $mDescrition = mysql_result($result_Maps, $map, TBL_MAPS . ".Description");
                $text .= '<option value="' . $mID . '"';
                if (strtolower($_POST['map' . $matchMap]) == $mID) {
                    $text .= ' selected="selected"';
                }
                $text .= '>' . $mName . '</option>';
            }
            $text .= '</select></td>';
            $text .= '</tr>';
        }
        $text .= '</tbody></table>';
        $text .= '<br />';
    }
    if ($action != 'matchschedule' && $action != 'matchschedulededit') {
        // Comments
        //----------------------------------
        $text .= '<br />';
        $text .= '<div style="display:table; margin-left:auto; margin-right:auto;">';
        $text .= EB_MATCHR_L30 . '<br />';
        $text .= '<textarea class="tbox" id="match_comment" name="match_comment" style="width:400px" cols="70" ' . $insertjs . '>' . $comment . '</textarea>';
        if (!e_WYSIWYG) {
            $text .= '<br />' . display_help("helpb", "comment");
        }
        $text .= '</div>';
        $text .= '<br />';
    }
    if ($action == 'matchschedule' || $action == 'matchschedulededit') {
        //<!-- Date Selection -->
        $text .= EB_MATCHR_L49;
        $text .= '
		<table>
		<tr>
		<td>
		<table>
		<tr>
		<td>
		<div><input class="tbox timepicker" type="text" name="date_scheduled" id="f_date"  value="' . $date_scheduled . '" readonly="readonly" /></div>
		</td>
		<td>
		<div><input class="eb_button" type="button" value="' . EB_MATCHR_L51 . '" onclick="clearDate(this.form);"/></div>
		</td>
		</tr>
		</table>
		</td>
		</tr>
		</table>
		';
    }
    $text .= '<div style="display:table; margin-left:auto; margin-right:auto;">';
    $text .= '<input type="hidden" name="nbr_players" value="' . $nbr_players . '"/>';
    $text .= '<input type="hidden" name="nbr_teams" value="' . $nbr_teams . '"/>';
    $text .= '<input type="hidden" name="userclass" value="' . $userclass . '"/>';
    $text .= '<input type="hidden" name="reported_by" value="' . $reported_by . '"/>';
    $text .= '<input type="hidden" name="time_reported" value="' . $time_reported . '"/>';
    $text .= '<input class="eb_button" type="submit" value="' . $matchreport_str . '" name="submit_match"/>';
    $text .= '<span id="ajaxSpinnerContainer">
	<img src="' . e_PLUGIN . 'ebattles/images/ajax-loader.gif" title="working..." alt="working..."/>
	' . EB_EVENTM_L157 . '
	</span>';
    $text .= '</div>';
    $text .= '</div>';
    $text .= '</form>';
}
Example #17
0
 function get_permissions($user_id)
 {
     global $sql;
     global $pref;
     $userclass = 0;
     $can_edit = 0;
     $can_approve = 0;
     $can_report = 0;
     $can_schedule = 0;
     $can_delete = 0;
     $can_submit_media = 0;
     $can_delete_media = 0;
     $match_id = $this->fields['MatchID'];
     $event_id = $this->fields['Event'];
     $event = new Event($event_id);
     $type = $event->getField('Type');
     $competition_type = $event->getCompetitionType();
     $mStatus = $this->fields['Status'];
     $reported_by = $this->fields['ReportedBy'];
     // Is the user a moderator?
     $q_Mods = "SELECT " . TBL_EVENTMODS . ".*" . " FROM " . TBL_EVENTMODS . " WHERE (" . TBL_EVENTMODS . ".Event = '{$event_id}')" . "   AND (" . TBL_EVENTMODS . ".User = "******")";
     $result_Mods = $sql->db_Query($q_Mods);
     $numMods = mysql_numrows($result_Mods);
     switch ($event->getMatchPlayersType()) {
         case 'Players':
             $reporter_matchteam = 0;
             $q_Reporter = "SELECT DISTINCT " . TBL_SCORES . ".*" . " FROM " . TBL_MATCHS . ", " . TBL_SCORES . ", " . TBL_PLAYERS . ", " . TBL_GAMERS . ", " . TBL_USERS . " WHERE (" . TBL_MATCHS . ".MatchID = '{$match_id}')" . " AND (" . TBL_SCORES . ".MatchID = " . TBL_MATCHS . ".MatchID)" . " AND (" . TBL_PLAYERS . ".PlayerID = " . TBL_SCORES . ".Player)" . " AND (" . TBL_PLAYERS . ".Gamer = " . TBL_GAMERS . ".GamerID)" . " AND (" . TBL_GAMERS . ".User = '******')";
             $result_Reporter = $sql->db_Query($q_Reporter);
             $numRows = mysql_numrows($result_Reporter);
             if ($numRows > 0) {
                 $reporter_matchteam = mysql_result($result_Reporter, 0, TBL_SCORES . ".Player_MatchTeam");
             }
             // Is the user an opponent of the reporter?
             $q_Opps = "SELECT DISTINCT " . TBL_SCORES . ".*" . " FROM " . TBL_MATCHS . ", " . TBL_SCORES . ", " . TBL_PLAYERS . ", " . TBL_GAMERS . ", " . TBL_USERS . " WHERE (" . TBL_MATCHS . ".MatchID = '{$match_id}')" . " AND (" . TBL_SCORES . ".MatchID = " . TBL_MATCHS . ".MatchID)" . " AND (" . TBL_PLAYERS . ".PlayerID = " . TBL_SCORES . ".Player)" . " AND (" . TBL_SCORES . ".Player_MatchTeam != '{$reporter_matchteam}')" . " AND (" . TBL_PLAYERS . ".Gamer = " . TBL_GAMERS . ".GamerID)" . " AND (" . TBL_GAMERS . ".User = "******")";
             $result_Opps = $sql->db_Query($q_Opps);
             $numOpps = mysql_numrows($result_Opps);
             break;
         case 'Teams':
             $reporter_matchteam = 0;
             $q_Reporter = "SELECT DISTINCT " . TBL_SCORES . ".*" . " FROM " . TBL_MATCHS . ", " . TBL_SCORES . ", " . TBL_TEAMS . ", " . TBL_PLAYERS . ", " . TBL_GAMERS . ", " . TBL_USERS . " WHERE (" . TBL_MATCHS . ".MatchID = '{$match_id}')" . " AND (" . TBL_SCORES . ".MatchID = " . TBL_MATCHS . ".MatchID)" . " AND (" . TBL_TEAMS . ".TeamID = " . TBL_SCORES . ".Team)" . " AND (" . TBL_PLAYERS . ".Team = " . TBL_TEAMS . ".TeamID)" . " AND (" . TBL_PLAYERS . ".Gamer = " . TBL_GAMERS . ".GamerID)" . " AND (" . TBL_GAMERS . ".User = '******')";
             $result_Reporter = $sql->db_Query($q_Reporter);
             $numRows = mysql_numrows($result_Reporter);
             if ($numRows > 0) {
                 $reporter_matchteam = mysql_result($result_Reporter, 0, TBL_SCORES . ".Player_MatchTeam");
             }
             // Is the user an opponent of the reporter?
             $q_Opps = "SELECT DISTINCT " . TBL_SCORES . ".*" . " FROM " . TBL_MATCHS . ", " . TBL_SCORES . ", " . TBL_TEAMS . ", " . TBL_PLAYERS . ", " . TBL_GAMERS . ", " . TBL_USERS . " WHERE (" . TBL_MATCHS . ".MatchID = '{$match_id}')" . " AND (" . TBL_SCORES . ".MatchID = " . TBL_MATCHS . ".MatchID)" . " AND (" . TBL_SCORES . ".Player_MatchTeam != '{$reporter_matchteam}')" . " AND (" . TBL_TEAMS . ".TeamID = " . TBL_SCORES . ".Team)" . " AND (" . TBL_PLAYERS . ".Team = " . TBL_TEAMS . ".TeamID)" . " AND (" . TBL_PLAYERS . ".Gamer = " . TBL_GAMERS . ".GamerID)" . " AND (" . TBL_GAMERS . ".User = "******")";
             $result_Opps = $sql->db_Query($q_Opps);
             $numOpps = mysql_numrows($result_Opps);
             //dbg: echo "numOpps: $numOpps, mt: $reporter_matchteam<br />";
             break;
         default:
     }
     // Is the user a player in the match & not banned?
     switch ($event->getMatchPlayersType()) {
         case 'Players':
             $q_UserPlayers = "SELECT DISTINCT " . TBL_SCORES . ".*" . " FROM " . TBL_MATCHS . ", " . TBL_SCORES . ", " . TBL_PLAYERS . ", " . TBL_GAMERS . ", " . TBL_USERS . " WHERE (" . TBL_MATCHS . ".MatchID = '" . $match_id . "')" . " AND (" . TBL_SCORES . ".MatchID = " . TBL_MATCHS . ".MatchID)" . " AND (" . TBL_PLAYERS . ".PlayerID = " . TBL_SCORES . ".Player)" . " AND (" . TBL_PLAYERS . ".Banned != 1)" . " AND (" . TBL_PLAYERS . ".Gamer = " . TBL_GAMERS . ".GamerID)" . " AND (" . TBL_GAMERS . ".User = "******")";
             $result_UserPlayers = $sql->db_Query($q_UserPlayers);
             $numUserPlayers = mysql_numrows($result_UserPlayers);
             //dbg: echo "numUserPlayers: $numUserPlayers<br>";
             break;
         case 'Teams':
             $q_UserPlayers = "SELECT DISTINCT " . TBL_SCORES . ".*" . " FROM " . TBL_MATCHS . ", " . TBL_SCORES . ", " . TBL_TEAMS . ", " . TBL_PLAYERS . ", " . TBL_GAMERS . ", " . TBL_USERS . " WHERE (" . TBL_MATCHS . ".MatchID = '" . $match_id . "')" . " AND (" . TBL_SCORES . ".MatchID = " . TBL_MATCHS . ".MatchID)" . " AND (" . TBL_TEAMS . ".TeamID = " . TBL_SCORES . ".Team)" . " AND (" . TBL_TEAMS . ".Banned != 1)" . " AND (" . TBL_PLAYERS . ".Team = " . TBL_TEAMS . ".TeamID)" . " AND (" . TBL_PLAYERS . ".Banned != 1)" . " AND (" . TBL_PLAYERS . ".Gamer = " . TBL_GAMERS . ".GamerID)" . " AND (" . TBL_GAMERS . ".User = "******")";
             $result_UserPlayers = $sql->db_Query($q_UserPlayers);
             $numUserPlayers = mysql_numrows($result_UserPlayers);
             //dbg: echo "numUserPlayers: $numUserPlayers<br>";
             break;
         default:
     }
     if ($user_id == $reported_by && $mStatus == 'pending') {
         $can_edit = 1;
     }
     if (check_class($pref['eb_mod_class'])) {
         $can_delete = 1;
     }
     if ($user_id == $event->getField('Owner')) {
         $userclass |= eb_UC_EVENT_OWNER;
         $can_delete = 1;
         $can_approve = 1;
         $can_report = 1;
         $can_schedule = 1;
         $can_edit = 1;
         $can_submit_media = 1;
         $can_delete_media = 1;
     }
     if ($numMods > 0) {
         $userclass |= eb_UC_EB_MODERATOR;
         $can_delete = 1;
         $can_approve = 1;
         $can_report = 1;
         $can_schedule = 1;
         $can_edit = 1;
         $can_submit_media = 1;
         $can_delete_media = 1;
     }
     if (check_class($pref['eb_mod_class'])) {
         $userclass |= eb_UC_EB_MODERATOR;
         $can_approve = 1;
         $can_report = 1;
         $can_schedule = 1;
         $can_edit = 1;
         $can_submit_media = 1;
         $can_delete_media = 1;
     }
     if ($numOpps > 0) {
         $userclass |= eb_UC_EVENT_PLAYER;
         $can_approve = 1;
     }
     if ($numUserPlayers > 0) {
         $can_report = 1;
     }
     if ($numPlayed > 0 && check_class($pref['eb_media_submit_class'])) {
         $can_submit_media = 1;
     }
     if ($userclass < $event->getField('MatchesApproval')) {
         $can_approve = 0;
     }
     if ($event->getField('MatchesApproval') == eb_UC_NONE) {
         $can_approve = 0;
     }
     if ($mStatus != 'pending') {
         $can_approve = 0;
     }
     if ($mStatus != 'scheduled') {
         $can_report = 0;
     }
     if ($can_edit == 1) {
         if ($competition_type == 'Tournament' && $mStatus != 'scheduled') {
             $can_edit = 0;
         }
     }
     //echo "m($match_id).perm.can_report=$can_report<br>";
     $permissions = array();
     $permissions['userclass'] = $userclass;
     $permissions['can_edit'] = $can_edit;
     $permissions['can_approve'] = $can_approve;
     $permissions['can_report'] = $can_report;
     $permissions['can_schedule'] = $can_schedule;
     $permissions['can_delete'] = $can_delete;
     $permissions['can_submit_media'] = $can_submit_media;
     $permissions['can_delete_media'] = $can_delete_media;
     //echo "match $match_id permissions:<br>";
     //var_dump($permissions);
     return $permissions;
 }
Example #18
0
function updateStats($event_id, $time, $serialize = TRUE)
{
    global $sql;
    global $pref;
    $rater = new rater();
    $file = e_PLUGIN . 'ebattles/cache/sql_cache_event_' . $event_id . '.txt';
    $id = array();
    $uid = array();
    $team = array();
    $name = array();
    $avatar = array();
    $games_played = array();
    $ELO = array();
    $Skill = array();
    $G2 = array();
    $win = array();
    $loss = array();
    $draw = array();
    $windrawloss = array();
    $streaks = array();
    $victory_ratio = array();
    $victory_percent = array();
    $unique_opponents = array();
    $opponentsELO = array();
    $score = array();
    $oppscore = array();
    $scorediff = array();
    $points = array();
    $forfeits = array();
    $forfeits_percent = array();
    $banned = array();
    $rating = array();
    $games_played_score = array();
    $ELO_score = array();
    $Skill_score = array();
    $G2_score = array();
    $win_score = array();
    $loss_score = array();
    $draw_score = array();
    $windrawloss_score = array();
    $victory_ratio_score = array();
    $victory_percent_score = array();
    $unique_opponents_score = array();
    $opponentsELO_score = array();
    $streak_score = array();
    $score_score = array();
    $oppscore_score = array();
    $scorediff_score = array();
    $points_score = array();
    $forfeits_score = array();
    $forfeits_percent_score = array();
    /* Event Info */
    $event = new Event($event_id);
    $type = $event->getField('Type');
    $competition_type = $event->getCompetitionType();
    $hide_ratings_column = $event->getField('hide_ratings_column');
    if ($event->getField('RankingType') == "Classic") {
        $hide_ratings_column = TRUE;
    }
    // Update Players stats
    $q_Players = "SELECT " . TBL_PLAYERS . ".*, " . TBL_USERS . ".*" . " FROM " . TBL_PLAYERS . ", " . TBL_GAMERS . ", " . TBL_USERS . " WHERE (" . TBL_PLAYERS . ".Event = '{$event_id}')" . " AND (" . TBL_PLAYERS . ".Gamer = " . TBL_GAMERS . ".GamerID)" . " AND (" . TBL_USERS . ".user_id = " . TBL_GAMERS . ".User)";
    $result_Players = $sql->db_Query($q_Players);
    $numPlayers = mysql_numrows($result_Players);
    $players_rated = 0;
    for ($player = 0; $player < $numPlayers; $player++) {
        // For each player
        $pid = mysql_result($result_Players, $player, TBL_PLAYERS . ".PlayerID");
        $puid = mysql_result($result_Players, $player, TBL_USERS . ".user_id");
        $gamer_id = mysql_result($result_Players, $player, TBL_PLAYERS . ".Gamer");
        $gamer = new Gamer($gamer_id);
        $pname = $gamer->getField('Name');
        $pavatar = mysql_result($result_Players, $player, TBL_USERS . ".user_image");
        $pteam = mysql_result($result_Players, $player, TBL_PLAYERS . ".Team");
        $pgames_played = mysql_result($result_Players, $player, TBL_PLAYERS . ".GamesPlayed");
        $pELO = mysql_result($result_Players, $player, TBL_PLAYERS . ".ELORanking");
        $pTS_mu = mysql_result($result_Players, $player, TBL_PLAYERS . ".TS_mu");
        $pTS_sigma = mysql_result($result_Players, $player, TBL_PLAYERS . ".TS_sigma");
        $pSkill = $pTS_mu - 3 * $pTS_sigma;
        $pG2_r = mysql_result($result_Players, $player, TBL_PLAYERS . ".G2_r");
        $pG2_RD = mysql_result($result_Players, $player, TBL_PLAYERS . ".G2_RD");
        $pG2 = $pG2_r - 2 * $pG2_RD;
        $pwin = mysql_result($result_Players, $player, TBL_PLAYERS . ".Win");
        $pdraw = mysql_result($result_Players, $player, TBL_PLAYERS . ".Draw");
        $ploss = mysql_result($result_Players, $player, TBL_PLAYERS . ".Loss");
        $pstreak = mysql_result($result_Players, $player, TBL_PLAYERS . ".Streak");
        $pstreak_worst = mysql_result($result_Players, $player, TBL_PLAYERS . ".Streak_Worst");
        $pstreak_best = mysql_result($result_Players, $player, TBL_PLAYERS . ".Streak_Best");
        $pwindrawloss = $pwin . "/" . $pdraw . "/" . $ploss;
        $pwinloss = $pwin . "/" . $ploss;
        $pvictory_ratio = $ploss > 0 ? $pwin / $ploss : $pwin;
        //fm- draw here???
        $pvictory_percent = $pwin + $pdraw + $ploss > 0 ? 100 * $pwin / ($pwin + $pdraw + $ploss) : 0;
        $pscore = mysql_result($result_Players, $player, TBL_PLAYERS . ".Score");
        $poppscore = mysql_result($result_Players, $player, TBL_PLAYERS . ".ScoreAgainst");
        $ppoints = mysql_result($result_Players, $player, TBL_PLAYERS . ".Points");
        $pforfeits = mysql_result($result_Players, $player, TBL_PLAYERS . ".Forfeits");
        $pforfeits_percent = $pgames_played > 0 ? 100 * $pforfeits / $pgames_played : 0;
        $pbanned = mysql_result($result_Players, $player, TBL_PLAYERS . ".Banned");
        $popponentsELO = 0;
        $popponents = 0;
        $prating = 0;
        $prating_votes = 0;
        // Unique Opponents
        // Find all matches played by current player
        $q_Matches = "SELECT " . TBL_MATCHS . ".*, " . TBL_SCORES . ".*, " . TBL_PLAYERS . ".*" . " FROM " . TBL_MATCHS . ", " . TBL_SCORES . ", " . TBL_PLAYERS . " WHERE (" . TBL_SCORES . ".MatchID = " . TBL_MATCHS . ".MatchID)" . " AND (" . TBL_MATCHS . ".Status = 'active')" . " AND (" . TBL_PLAYERS . ".PlayerID = " . TBL_SCORES . ".Player)" . " AND (" . TBL_PLAYERS . ".PlayerID = '{$pid}')";
        $result_Matches = $sql->db_Query($q_Matches);
        $numMatches = mysql_numrows($result_Matches);
        $players = array();
        if ($numMatches > 0) {
            for ($match = 0; $match < $numMatches; $match++) {
                // For each match played by current player
                $mID = mysql_result($result_Matches, $match, TBL_MATCHS . ".MatchID");
                $mplayermatchteam = mysql_result($result_Matches, $match, TBL_SCORES . ".Player_MatchTeam");
                // Find all scores/players(+users) for that match
                $q_Scores = "SELECT " . TBL_MATCHS . ".*, " . TBL_SCORES . ".*, " . TBL_PLAYERS . ".*, " . TBL_USERS . ".*" . " FROM " . TBL_MATCHS . ", " . TBL_SCORES . ", " . TBL_PLAYERS . ", " . TBL_GAMERS . ", " . TBL_USERS . " WHERE (" . TBL_MATCHS . ".MatchID = '{$mID}')" . " AND (" . TBL_SCORES . ".MatchID = " . TBL_MATCHS . ".MatchID)" . " AND (" . TBL_PLAYERS . ".PlayerID = " . TBL_SCORES . ".Player)" . " AND (" . TBL_PLAYERS . ".Gamer = " . TBL_GAMERS . ".GamerID)" . " AND (" . TBL_USERS . ".user_id = " . TBL_GAMERS . ".User)";
                $result_Scores = $sql->db_Query($q_Scores);
                $numScores = mysql_numrows($result_Scores);
                for ($scoreIndex = 0; $scoreIndex < $numScores; $scoreIndex++) {
                    $osid = mysql_result($result_Scores, $scoreIndex, TBL_SCORES . ".ScoreID");
                    $ouid = mysql_result($result_Scores, $scoreIndex, TBL_USERS . ".user_id");
                    $oplayermatchteam = mysql_result($result_Scores, $scoreIndex, TBL_SCORES . ".Player_MatchTeam");
                    $oELO = mysql_result($result_Scores, $scoreIndex, TBL_PLAYERS . ".ELORanking");
                    if ($oplayermatchteam != $mplayermatchteam) {
                        $players[] = "{$ouid}";
                        $popponentsELO += $oELO;
                        $popponents += 1;
                    }
                    if ($ouid == $puid) {
                        // Get user rating.
                        $rate = $rater->GetRating("ebscores", $osid);
                        $prating += $rate[0] * ($rate[1] + $rate[2] / 10);
                        $prating_votes += $rate[0];
                    }
                }
            }
        }
        $punique_opponents = count(array_unique($players));
        if ($popponents != 0) {
            $popponentsELO /= $popponents;
        }
        if ($prating_votes != 0) {
            $prating /= $prating_votes;
        }
        // For display
        $id[] = $pid;
        $uid[] = $puid;
        $name[] = $pname;
        $avatar[] = $pavatar;
        $team[] = $pteam;
        $games_played[] = $pgames_played;
        $ELO[] = $pELO;
        $Skill[] = max(0, number_format($pSkill, 0));
        $G2[] = number_format($pG2_r, 0) . " +/- " . number_format($pG2_RD, 0);
        $win[] = $pwin;
        $loss[] = $ploss;
        $draw[] = $pdraw;
        $streaks[] = $pstreak . "|" . $pstreak_best . "|" . $pstreak_worst;
        $windrawloss[] = $pwindrawloss;
        $victory_ratio[] = $pwinloss;
        $victory_percent[] = number_format($pvictory_percent, 2) . "%";
        $unique_opponents[] = $punique_opponents;
        $opponentsELO[] = floor($popponentsELO);
        $score[] = $pgames_played > 0 ? number_format($pscore / $pgames_played, 2) : 0;
        $oppscore[] = $pgames_played > 0 ? number_format($poppscore / $pgames_played, 2) : 0;
        $scorediff[] = $pgames_played > 0 ? number_format(($pscore - $poppscore) / $pgames_played, 2) : 0;
        $points[] = $ppoints;
        $forfeits[] = $pforfeits;
        $forfeits_percent[] = number_format($pforfeits_percent, 2) . "%";
        $banned[] = $pbanned;
        $rating[] = displayRating($prating, $prating_votes);
        // Actual score (not for display)
        $games_played_score[] = $pgames_played;
        $ELO_score[] = $pELO;
        $Skill_score[] = $pSkill;
        $G2_score[] = $pG2;
        $win_score[] = $pwin;
        $loss_score[] = $ploss;
        $draw_score[] = $pdraw;
        $windrawloss_score[] = $pwin - $ploss;
        //fm - ???
        $victory_ratio_score[] = $pvictory_ratio;
        $victory_percent_score[] = $pvictory_percent;
        $unique_opponents_score[] = $punique_opponents;
        $opponentsELO_score[] = $popponentsELO;
        $streaks_score[] = $pstreak_best;
        //max(0,$pstreak_best + $pstreak_worst); //fmarc- TBD
        $score_score[] = $pgames_played > 0 ? $pscore / $pgames_played : 0;
        $oppscore_score[] = $pgames_played > 0 ? -$poppscore / $pgames_played : 0;
        $scorediff_score[] = $pgames_played > 0 ? ($pscore - $poppscore) / $pgames_played : 0;
        $points_score[] = $ppoints;
        $forfeits_score[] = -$pforfeits;
        $forfeits_percent_score[] = -$pforfeits_percent;
        if ($pgames_played >= $event->getField('nbr_games_to_rank') && $pbanned == 0) {
            $players_rated++;
        }
    }
    $rating_max = 0;
    $q_Categories = "SELECT " . TBL_STATSCATEGORIES . ".*" . " FROM " . TBL_STATSCATEGORIES . " WHERE (" . TBL_STATSCATEGORIES . ".Event = '{$event_id}')" . " ORDER BY " . TBL_STATSCATEGORIES . ".CategoryMaxValue DESC";
    $result_Categories = $sql->db_Query($q_Categories);
    $numCategories = mysql_numrows($result_Categories);
    $stat_cat_header = array();
    $stat_min = array();
    $stat_max = array();
    $stat_a = array();
    $stat_b = array();
    $stat_score = array();
    $stat_display = array();
    $cat_index = 0;
    $categories = array();
    for ($category = 0; $category < $numCategories; $category++) {
        $cat_name = mysql_result($result_Categories, $category, TBL_STATSCATEGORIES . ".CategoryName");
        $cat_minpoints = mysql_result($result_Categories, $category, TBL_STATSCATEGORIES . ".CategoryMinValue");
        $cat_maxpoints = mysql_result($result_Categories, $category, TBL_STATSCATEGORIES . ".CategoryMaxValue");
        $cat_InfoOnly = mysql_result($result_Categories, $category, TBL_STATSCATEGORIES . ".InfoOnly");
        if ($cat_maxpoints > 0) {
            //dbg- echo "$cat_name<br>";
            $display_cat = 1;
            switch ($cat_name) {
                case "ELO":
                    $cat_header_title = EB_STATS_L1;
                    $cat_header_text = EB_STATS_L2;
                    $min = min($ELO_score);
                    $max = max($ELO_score);
                    $stat_score[$cat_index] = $ELO_score;
                    $stat_display[$cat_index] = $ELO;
                    break;
                case "Skill":
                    $cat_header_title = EB_STATS_L3;
                    $cat_header_text = EB_STATS_L4;
                    $min = min($Skill_score);
                    $max = max($Skill_score);
                    $stat_score[$cat_index] = $Skill_score;
                    $stat_display[$cat_index] = $Skill;
                    break;
                case "Glicko2":
                    $cat_header_title = EB_STATS_L41;
                    $cat_header_text = EB_STATS_L42;
                    $min = min($G2_score);
                    $max = max($G2_score);
                    $stat_score[$cat_index] = $G2_score;
                    $stat_display[$cat_index] = $G2;
                    break;
                case "GamesPlayed":
                    $cat_header_title = EB_STATS_L5;
                    $cat_header_text = EB_STATS_L6;
                    $min = 0;
                    //min($games_played_score);
                    $max = max($games_played);
                    $stat_score[$cat_index] = $games_played_score;
                    $stat_display[$cat_index] = $games_played;
                    break;
                case "VictoryRatio":
                    $cat_header_title = EB_STATS_L7;
                    $cat_header_text = EB_STATS_L8;
                    $min = 0;
                    //min($victory_ratio_score);
                    $max = max($victory_ratio_score);
                    $stat_score[$cat_index] = $victory_ratio_score;
                    $stat_display[$cat_index] = $victory_ratio;
                    break;
                case "VictoryPercent":
                    $cat_header_title = EB_STATS_L9;
                    $cat_header_text = EB_STATS_L10;
                    $min = 0;
                    //min($victory_percent_score);
                    $max = max($victory_percent_score);
                    $stat_score[$cat_index] = $victory_percent_score;
                    $stat_display[$cat_index] = $victory_percent;
                    break;
                case "WinDrawLoss":
                    $cat_header_title = EB_STATS_L11;
                    $cat_header_text = EB_STATS_L12;
                    $min = min($windrawloss_score);
                    $max = max($windrawloss_score);
                    $stat_score[$cat_index] = $windrawloss_score;
                    $stat_display[$cat_index] = $windrawloss;
                    break;
                case "UniqueOpponents":
                    $cat_header_title = EB_STATS_L13;
                    $cat_header_text = EB_STATS_L14;
                    $min = 0;
                    //min($unique_opponents_score);
                    $max = max($unique_opponents_score);
                    $stat_score[$cat_index] = $unique_opponents_score;
                    $stat_display[$cat_index] = $unique_opponents;
                    break;
                case "OpponentsELO":
                    $cat_header_title = EB_STATS_L15;
                    $cat_header_text = EB_STATS_L16;
                    $min = min($opponentsELO_score);
                    $max = max($opponentsELO_score);
                    $stat_score[$cat_index] = $opponentsELO_score;
                    $stat_display[$cat_index] = $opponentsELO;
                    break;
                case "Streaks":
                    $cat_header_title = EB_STATS_L17;
                    $cat_header_text = EB_STATS_L18;
                    $min = min($streaks_score);
                    $max = max($streaks_score);
                    $stat_score[$cat_index] = $streaks_score;
                    $stat_display[$cat_index] = $streaks;
                    break;
                case "Score":
                    $cat_header_title = EB_STATS_L19;
                    $cat_header_text = EB_STATS_L20;
                    $min = min($score_score);
                    $max = max($score_score);
                    $stat_score[$cat_index] = $score_score;
                    $stat_display[$cat_index] = $score;
                    break;
                case "ScoreAgainst":
                    $cat_header_title = EB_STATS_L21;
                    $cat_header_text = EB_STATS_L22;
                    $min = min($oppscore_score);
                    $max = max($oppscore_score);
                    $stat_score[$cat_index] = $oppscore_score;
                    $stat_display[$cat_index] = $oppscore;
                    break;
                case "ScoreDiff":
                    $cat_header_title = EB_STATS_L23;
                    $cat_header_text = EB_STATS_L24;
                    $min = min($scorediff_score);
                    $max = max($scorediff_score);
                    $stat_score[$cat_index] = $scorediff_score;
                    $stat_display[$cat_index] = $scorediff;
                    break;
                case "Points":
                    $cat_header_title = EB_STATS_L25;
                    $cat_header_text = EB_STATS_L26;
                    $min = min($points_score);
                    $max = max($points_score);
                    $stat_score[$cat_index] = $points_score;
                    $stat_display[$cat_index] = $points;
                    break;
                case "Forfeits":
                    $cat_header_title = EB_STATS_L43;
                    $cat_header_text = EB_STATS_L44;
                    $min = min($forfeits_score);
                    $max = max($forfeits_score);
                    $stat_score[$cat_index] = $forfeits_score;
                    $stat_display[$cat_index] = $forfeits;
                    break;
                case "ForfeitsPercent":
                    $cat_header_title = EB_STATS_L45;
                    $cat_header_text = EB_STATS_L46;
                    $min = min($forfeits_percent_score);
                    $max = max($forfeits_percent_score);
                    $stat_score[$cat_index] = $forfeits_percent_score;
                    $stat_display[$cat_index] = $forfeits_percent;
                    break;
                default:
                    $display_cat = 0;
            }
            if ($display_cat == 1) {
                $stat_InfoOnly[$cat_index] = $cat_InfoOnly;
                switch ($event->getField('RankingType')) {
                    case "CombinedStats":
                        if ($cat_InfoOnly == TRUE) {
                            $cat_header = '<b title="' . $cat_header_title . '">' . $cat_header_text . '</b>';
                        } else {
                            $categories[] = $cat_index;
                            $cat_header = '<b title="' . $cat_header_title . ' [' . number_format($cat_maxpoints, 2) . ' ' . EB_STATS_L27 . ']">' . $cat_header_text . '</b>';
                            /*
                            $cat_header = '
                            <b title="'.$cat_header_title.'">'.$cat_header_text.'</b>
                            <br /><div class="smalltext">['.number_format ($cat_maxpoints,2).'&nbsp;'.EB_STATS_L27.']</div>
                            ';
                            */
                            // a = (ymax-ymin)/(xmax-xmin)
                            // b = ymin - a.xmin
                            if ($max == $min) {
                                $a = 0;
                                $b = $cat_maxpoints;
                            } else {
                                $a = ($cat_maxpoints - $cat_minpoints) / ($max - $min);
                                $b = $cat_minpoints - $a * $min;
                            }
                            $stat_min[$cat_index] = $min;
                            $stat_max[$cat_index] = $max;
                            $stat_a[$cat_index] = $a;
                            $stat_b[$cat_index] = $b;
                            $rating_max += $cat_maxpoints;
                        }
                        break;
                    case "Classic":
                        if ($cat_InfoOnly == TRUE) {
                            $cat_header = '<span title="' . $cat_header_title . '">' . $cat_header_text . '</span>';
                        } else {
                            $cat_header = '<b title="' . $cat_header_title . '">' . $cat_header_text . '</b>';
                            $categories[] = $cat_index;
                        }
                        break;
                    default:
                }
                $stat_cat_header[$cat_index] = $cat_header;
                $cat_index++;
            }
        }
    }
    $numDisplayedCategories = $cat_index;
    $ranks = getRanking($stat_score, $categories);
    $stats = array("0" => array('header', '<b>' . EB_STATS_L28 . '</b>', '<b>' . EB_STATS_L29 . '</b>'));
    // user rating not shown
    // $stats[0][] = '<b>'.EB_STATS_L30.'</b>';
    if ($hide_ratings_column == FALSE) {
        $stats[0][] = '<b title="' . EB_STATS_L31 . ' [' . number_format($rating_max, 2) . ' ' . EB_STATS_L27 . ']">' . EB_STATS_L32 . '</b>';
    }
    //$stats[0][] = '<b title="'.EB_STATS_L31.'">'.EB_STATS_L32.'</b><br /><div class="smalltext">['.number_format ($rating_max,2).'&nbsp;'.EB_STATS_L27.']</div>';
    for ($category = 0; $category < $numDisplayedCategories; $category++) {
        $stats[0][] = $stat_cat_header[$category];
    }
    // Challenge column
    $stats[0][] = "<b>" . EB_CHALLENGE_L1 . "<b>";
    switch ($event->getField('RankingType')) {
        case "CombinedStats":
            $OverallScoreThreshold = 0;
            $final_score = array();
            for ($player = 0; $player < $numPlayers; $player++) {
                $OverallScore[$player] = 0;
                if ($games_played[$player] >= $event->getField('nbr_games_to_rank') && $banned[$player] == 0) {
                    for ($category = 0; $category < $numDisplayedCategories; $category++) {
                        if ($stat_InfoOnly[$category] == FALSE) {
                            $final_score[$category][$player] = $stat_a[$category] * $stat_score[$category][$player] + $stat_b[$category];
                            $OverallScore[$player] += $final_score[$category][$player];
                        }
                    }
                } else {
                    for ($category = 0; $category < $numDisplayedCategories; $category++) {
                        $final_score[$category][$player] = 0;
                    }
                }
                $q_update = "UPDATE " . TBL_PLAYERS . " SET OverallScore = '" . floatToSQL($OverallScore[$player]) . "' WHERE (PlayerID = '{$id[$player]}') AND (Event = '{$event_id}')";
                $result_update = $sql->db_Query($q_update);
            }
            break;
        case "Classic":
            $OverallScoreThreshold = $numPlayers;
            for ($player = 0; $player < $numPlayers; $player++) {
                if ($games_played[$player] >= $event->getField('nbr_games_to_rank') && $banned[$player] == 0) {
                    $OverallScore[$player] = array_search($player, $ranks, false) + $numPlayers + 1;
                } else {
                    $OverallScore[$player] = array_search($player, $ranks, false);
                }
                //dbg: echo "<br>Player $player ($name[$player]), os: $OverallScore[$player]";
                $q_update = "UPDATE " . TBL_PLAYERS . " SET OverallScore = '" . floatToSQL($OverallScore[$player]) . "' WHERE (PlayerID = '{$id[$player]}') AND (Event = '{$event_id}')";
                $result_update = $sql->db_Query($q_update);
            }
            break;
        default:
    }
    // Build results table
    //--------------------
    $q_Players = "SELECT *" . " FROM " . TBL_PLAYERS . " WHERE (Event = '{$event_id}')" . " ORDER BY " . TBL_PLAYERS . ".OverallScore DESC, " . TBL_PLAYERS . ".GamesPlayed DESC, " . TBL_PLAYERS . ".ELORanking DESC, " . TBL_PLAYERS . ".Banned ASC";
    $result_Players = $sql->db_Query($q_Players);
    $ranknumber = 1;
    for ($player = 0; $player < $numPlayers; $player++) {
        $pid = mysql_result($result_Players, $player, TBL_PLAYERS . ".PlayerID");
        $puid = mysql_result($result_Players, $player, TBL_PLAYERS . ".User");
        $prank = mysql_result($result_Players, $player, TBL_PLAYERS . ".Rank");
        $prankdelta = mysql_result($result_Players, $player, TBL_PLAYERS . ".RankDelta");
        $pstreak = mysql_result($result_Players, $player, TBL_PLAYERS . ".Streak");
        // Find index of player
        $index = array_search($pid, $id);
        $prank_side_image = "";
        if ($banned[$index] == 1) {
            $rank = '<span title="' . EB_STATS_L33 . '"><img class="eb_image" src="' . e_PLUGIN . 'ebattles/images/user_delete.ico" alt="' . EB_STATS_L34 . '" title="' . EB_STATS_L34 . '"/></span>';
            $prankdelta_string = "";
            $q_update = "UPDATE " . TBL_PLAYERS . " SET Rank = 0 WHERE (PlayerID = '{$pid}') AND (Event = '{$event_id}')";
            $result_update = $sql->db_Query($q_update);
        } elseif ($OverallScore[$index] <= $OverallScoreThreshold) {
            $rank = '<span title="' . EB_STATS_L35 . '">' . EB_STATS_L36 . '</span>';
            $prankdelta_string = "";
            $q_update = "UPDATE " . TBL_PLAYERS . " SET Rank = 0 WHERE (PlayerID = '{$pid}') AND (Event = '{$event_id}')";
            $result_update = $sql->db_Query($q_update);
        } else {
            $rank = $ranknumber;
            $ranknumber++;
            // increases $ranknumber by 1
            $q_update = "UPDATE " . TBL_PLAYERS . " SET Rank = {$rank} WHERE (PlayerID = '{$pid}') AND (Event = '{$event_id}')";
            $result_update = $sql->db_Query($q_update);
            $new_rankdelta = $prank - $rank;
            if ($new_rankdelta != 0) {
                $prankdelta += $new_rankdelta;
                $q_update = "UPDATE " . TBL_PLAYERS . " SET RankDelta = {$prankdelta} WHERE (PlayerID = '{$pid}') AND (Event = '{$event_id}')";
                $result_update = $sql->db_Query($q_update);
            }
            if ($new_rankdelta != 0 && $rank == 1 && $competition_type == 'Ladder') {
                // Award: player took 1st place
                $q_Awards = "INSERT INTO " . TBL_AWARDS . "(Player,Type,timestamp)\r\n\t\t\t\tVALUES ({$pid},'PlayerTookFirstPlace',{$time})";
                $result_Awards = $sql->db_Query($q_Awards);
            }
            if ($new_rankdelta != 0 && ($prank > 10 || $prank == 0) && $rank <= 10 && $competition_type == 'Ladder') {
                // Award: player enters top 10
                $q_Awards = "INSERT INTO " . TBL_AWARDS . "(Player,Type,timestamp)\r\n\t\t\t\tVALUES ({$pid},'PlayerInTopTen',{$time})";
                $result_Awards = $sql->db_Query($q_Awards);
            }
            $q_Awards = "SELECT " . TBL_AWARDS . ".*, " . TBL_PLAYERS . ".*" . " FROM " . TBL_AWARDS . ", " . TBL_PLAYERS . " WHERE (" . TBL_AWARDS . ".Player = " . TBL_PLAYERS . ".PlayerID)" . " AND (" . TBL_PLAYERS . ".PlayerID = '{$pid}')" . " ORDER BY " . TBL_AWARDS . ".timestamp DESC";
            $result_Awards = $sql->db_Query($q_Awards);
            $numAwards = mysql_numrows($result_Awards);
            if ($numAwards > 0) {
                $paward = mysql_result($result_Awards, 0, TBL_AWARDS . ".AwardID");
                $pawardType = mysql_result($result_Awards, 0, TBL_AWARDS . ".Type");
            }
            if ($rank == 1) {
                $prank_side_image = '<img class="eb_image" src="' . e_PLUGIN . 'ebattles/images/awards/award_star_gold_3.png" alt="' . EB_AWARD_L3 . '" title="' . EB_AWARD_L3 . '"/>';
            } else {
                if ($rank <= 10 && ($rank + $prankdelta > min(10, $numPlayers) || $rank + $prankdelta == 0)) {
                    $prank_side_image = '<img class="eb_image" src="' . e_PLUGIN . 'ebattles/images/awards/award_star_bronze_3.png" alt="' . EB_AWARD_L5 . '" title="' . EB_AWARD_L5 . '"/>';
                } else {
                    if ($numAwards > 0 && $pawardType != 'PlayerTookFirstPlace' && $pawardType != 'PlayerInTopTen' && $pstreak >= 5) {
                        switch ($pawardType) {
                            case 'PlayerStreak5':
                                if ($pstreak >= 5) {
                                    $award = EB_AWARD_L6;
                                    $prank_side_image = '<img class="eb_image" src="' . e_PLUGIN . 'ebattles/images/awards/medal_bronze_3.png" alt="' . EB_AWARD_L7 . '" title="' . EB_AWARD_L7 . '"/>';
                                }
                                break;
                            case 'PlayerStreak10':
                                if ($pstreak >= 10) {
                                    $award = EB_AWARD_L8;
                                    $prank_side_image = '<img class="eb_image" src="' . e_PLUGIN . 'ebattles/images/awards/medal_silver_3.png" alt="' . EB_AWARD_L9 . '" title="' . EB_AWARD_L9 . '"/>';
                                }
                                break;
                            case 'PlayerStreak25':
                                if ($pstreak >= 25) {
                                    $award = EB_AWARD_L10;
                                    $prank_side_image = '<img class="eb_image" src="' . e_PLUGIN . 'ebattles/images/awards/medal_gold_3.png" alt="' . EB_AWARD_L11 . '" title="' . EB_AWARD_L11 . '"/>';
                                }
                                break;
                        }
                    } else {
                        if ($prankdelta > 0) {
                            $prank_side_image = '<img class="eb_image" src="' . e_PLUGIN . 'ebattles/images/arrow_up.gif" alt="+' . $prankdelta . '" title="+' . $prankdelta . '"/>';
                        } else {
                            if ($prankdelta < 0 && $rank + $prankdelta != 0) {
                                $prank_side_image = '<img class="eb_image" src="' . e_PLUGIN . 'ebattles/images/arrow_down.gif" alt="' . $prankdelta . '" title="' . $prankdelta . '"/>';
                            } else {
                                if ($rank + $prankdelta == 0) {
                                    $prank_side_image = '<img class="eb_image" src="' . e_PLUGIN . 'ebattles/images/arrow_up.gif" alt="Up" title="' . EB_STATS_L37 . '"/>';
                                }
                            }
                        }
                    }
                }
            }
        }
        list($pclan, $pclantag, $pclanid) = getClanInfo($team[$index]);
        if (strcmp(USERID, $puid) == 0) {
            $stats_row = array("row_highlight");
        } else {
            $stats_row = array("row");
        }
        $stats_row[] = "<b>{$rank}</b> {$prank_side_image}";
        $image = "";
        if ($pref['eb_avatar_enable_playersstandings'] == 1) {
            if ($avatar[$index]) {
                $image = '<img ' . getAvatarResize(avatar($avatar[$index])) . '/>';
            } else {
                if ($pref['eb_avatar_default_image'] != '') {
                    $image = '<img ' . getAvatarResize(getImagePath($pref['eb_avatar_default_image'], 'avatars')) . '/>';
                }
            }
        }
        $stats_row[] = $image . '&nbsp;<a href="' . e_PLUGIN . 'ebattles/userinfo.php?user='******'"><b>' . $pclantag . $name[$index] . '</b></a>';
        // user rating not shown
        //$stats_row[] = $rating[$index];
        if ($hide_ratings_column == FALSE) {
            $stats_row[] = number_format($OverallScore[$index], 2);
        }
        for ($category = 0; $category < $numDisplayedCategories; $category++) {
            if ($stat_InfoOnly[$category] == TRUE || $event->getField('RankingType') == "Classic") {
                $stats_row[] = $stat_display[$category][$index];
            } else {
                $stats_row[] = $stat_display[$category][$index] . '<br /><div class="smalltext">[' . number_format($final_score[$category][$index], 2) . ']</div>';
            }
        }
        // Add challenge button here
        $challenge_text = ' <a href="javascript:challenge_player_js(\'' . $pid . '\');" title="' . EB_CHALLENGE_L1 . ' ' . $pclantag . $name[$index] . '"><img class="eb_image" src="' . e_PLUGIN . 'ebattles/images/challenge.png" alt="' . EB_CHALLENGE_L1 . ' ' . $pclantag . $name[$index] . '"/></a>';
        $stats_row[] = $challenge_text;
        $stats[] = $stats_row;
    }
    /*
    // debug print array
    print_r($stats);
    print_r($stat_score);
    echo "<br>";
    print_r($ranks);
    */
    if ($serialize) {
        // Serialize results array
        $OUTPUT = serialize($stats);
        $fp = fopen($file, "w");
        // open file with Write permission
        if ($fp == FALSE) {
            // handle error
            $error .= EB_STATS_L38;
            echo $error;
            exit;
        }
        fputs($fp, $OUTPUT);
        fclose($fp);
        /*
        $stats = unserialize(implode('',file($file)));
        foreach ($stats as $id=>$row)
        {
        print $row['category_name']."<br />";
        }
        */
    }
}
Example #19
0
}
if (isset($_POST['challenge_accept'])) {
    // Verify form
    $error_str = '';
    if (!empty($error_str)) {
        // show form again
        $text .= $challenge->challengeConfirmForm();
        // errors have occured, halt execution and show form again.
        $text .= '<div class="eb_errors">' . EB_MATCHR_L14;
        $text .= '<ul>' . $error_str . '</ul></div>';
    } else {
        $challenge->challengeAccept();
        $text .= EB_CHALLENGE_L22;
        $text .= '<br />';
        $text .= '<br />' . EB_CHALLENGE_L13 . ' [<a href="' . e_PLUGIN . 'ebattles/eventinfo.php?eventid=' . $event_id . '">' . EB_CHALLENGE_L14 . '</a>]<br />';
    }
}
if (isset($_POST['challenge_decline'])) {
    $challenge->challengeDecline();
    $text .= EB_EVENT_L69;
    $text .= '<br />';
    $text .= '<br />' . EB_CHALLENGE_L13 . ' [<a href="' . e_PLUGIN . 'ebattles/eventinfo.php?eventid=' . $event_id . '">' . EB_CHALLENGE_L14 . '</a>]<br />';
}
$ns->tablerender($event->getField('Name') . " (" . $event->eventTypeToString() . ") - " . EB_CHALLENGE_L1, $text);
require_once FOOTERF;
exit;
?>



Example #20
0
require_once e_PLUGIN . "ebattles/include/main.php";
require_once e_PLUGIN . "ebattles/include/match.php";
require_once e_PLUGIN . "ebattles/include/event.php";
/*******************************************************************
********************************************************************/
require_once HEADERF;
global $sql;
$text = '';
/* Event Name */
$event_id = intval($_GET['eventid']);
if (!$event_id) {
    header("Location: ./events.php");
    exit;
}
if (!isset($_POST['deletematch'])) {
    $text .= '<br />' . EB_MATCHDEL_L2 . '<br />';
} else {
    $event = new Event($event_id);
    $match_id = $_POST['matchid'];
    $match = new Match($match_id);
    $match->delete();
    if ($event->getField('FixturesEnable') == TRUE) {
        $event->brackets(true);
    }
    $text .= '<br />' . EB_MATCHDEL_L3 . '<br />';
    header("Location: eventinfo.php?eventid={$event_id}");
}
$text .= '<br />' . EB_MATCHDEL_L4 . ' [<a href="' . e_PLUGIN . 'ebattles/eventinfo.php?eventid=' . $event_id . '">' . EB_MATCHDEL_L5 . '</a>]<br />';
$ns->tablerender(EB_MATCHDEL_L1, $text);
require_once FOOTERF;
exit;
Example #21
0
$text .= '</ul>';
$text .= '<div id="tabs-1">';
// Did the user play in that match
$q = "SELECT DISTINCT " . TBL_SCORES . ".*" . " FROM " . TBL_MATCHS . ", " . TBL_SCORES . ", " . TBL_PLAYERS . ", " . TBL_GAMERS . ", " . TBL_USERS . " WHERE (" . TBL_MATCHS . ".MatchID = '{$match_id}')" . " AND (" . TBL_SCORES . ".MatchID = " . TBL_MATCHS . ".MatchID)" . " AND (" . TBL_PLAYERS . ".PlayerID = " . TBL_SCORES . ".Player)" . " AND (" . TBL_PLAYERS . ".Gamer = " . TBL_GAMERS . ".GamerID)" . " AND (" . TBL_GAMERS . ".User = "******")";
$result = $sql->db_Query($q);
$nbr_players = mysql_numrows($result);
if ($nbr_players > 0) {
    $uteam = mysql_result($result, 0, TBL_SCORES . ".Player_MatchTeam");
}
// Get event information
$q = "SELECT " . TBL_EVENTS . ".*, " . TBL_GAMES . ".*, " . TBL_MATCHS . ".*, " . TBL_USERS . ".*" . " FROM " . TBL_EVENTS . ", " . TBL_GAMES . ", " . TBL_MATCHS . ", " . TBL_USERS . " WHERE (" . TBL_MATCHS . ".MatchID = '{$match_id}')" . "   AND (" . TBL_EVENTS . ".EventID = " . TBL_MATCHS . ".Event)" . "   AND (" . TBL_EVENTS . ".Game = " . TBL_GAMES . ".GameID)" . "   AND (" . TBL_USERS . ".user_id = " . TBL_MATCHS . ".ReportedBy)";
$result = $sql->db_Query($q);
$event_id = mysql_result($result, 0, TBL_EVENTS . ".EventID");
$event = new Event($event_id);
$match = new Match($match_id);
$type = $event->getField('Type');
$competition_type = $event->getCompetitionType();
$gName = mysql_result($result, 0, TBL_GAMES . ".Name");
$mStatus = mysql_result($result, 0, TBL_MATCHS . ".Status");
$reported_by = mysql_result($result, 0, TBL_MATCHS . ".ReportedBy");
$reported_by_name = mysql_result($result, 0, TBL_USERS . ".user_name");
$matchMaps = explode(",", mysql_result($result, 0, TBL_MATCHS . ".Maps"));
$mTimeScheduled = mysql_result($result, 0, TBL_MATCHS . ".TimeScheduled");
$mTimeScheduled_local = $mTimeScheduled + TIMEOFFSET;
$dateScheduled = date("d M Y, h:i A", $mTimeScheduled_local);
$categoriesToShow = array();
$q_Categories = "SELECT " . TBL_STATSCATEGORIES . ".*" . " FROM " . TBL_STATSCATEGORIES . " WHERE (" . TBL_STATSCATEGORIES . ".Event = '{$event_id}')";
$result_Categories = $sql->db_Query($q_Categories);
$numCategories = mysql_numrows($result_Categories);
for ($category = 0; $category < $numCategories; $category++) {
    $cat_name = mysql_result($result_Categories, $category, TBL_STATSCATEGORIES . ".CategoryName");