コード例 #1
0
    $result = mysql_query($query, $oR3DCQuery->link);
    if ($result === false) {
        exit(_T('IDS_Admin_Tournament_Games_Edit_GAMEIDQUERYFAILED', $config));
    }
    $cnt = mysql_num_rows($result);
    if ($cnt == 0) {
        $__pd['error'] = _T('IDS_Admin_Tournament_Games_Edit_GAMEIDINVALID', $config);
    } else {
        $game = mysql_fetch_array($result, MYSQL_ASSOC);
    }
}
if (!isset($__pd['error'])) {
    // Field settings. Used for validation purposes and setting-up/customising the form.
    $players = get_active_player_list($oR3DCQuery);
    $fields = array();
    $fields['status'] = array('type' => 'string', 'label' => _T('IDS_Admin_Tournament_Games_Edit_STATUS', $config), 'items' => get_all_status_values($config), 'render_type' => 'select');
    $fields['completion_status'] = array('type' => 'string', 'label' => _T('IDS_Admin_Tournament_Games_Edit_COMPLETION', $config), 'items' => get_all_completion_status_values($config), 'render_type' => 'select');
    $__pd['fields'] = $fields;
    $result = check_form_submit($tid, $gid, $fields, $oR3DCQuery);
    if ($result['submit'] == FALSE) {
        $__pd['game'] = $game;
        $__pd['game']['fen'] = $oR3DCQuery->GetInitialGameFEN($config, $gid);
    } elseif ($result['submit'] && count($result['errors']) != 0) {
        $__pd['game'] = $result['new_values'];
        $__pd['errors'] = $result['errors'];
    } else {
        $__pd['game'] = $result['new_values'];
        $__pd['game']['fen'] = $oR3DCQuery->GetInitialGameFEN($config, $gid);
        $__pd['success'] = _T('IDS_Admin_Tournament_Games_Edit_UPDATED', $config);
    }
}
コード例 #2
0
function __get_games($id, $main, $config)
{
    // Get player list, because we want to show the player names.
    $result = mysql_query("SELECT player_id, userid FROM player", $main->link);
    while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
        $players[$row['player_id']] = $row['userid'];
    }
    // Now get all the games for this tournament.
    $query = sprintf("SELECT game.* FROM game, c4m_tournamentgames WHERE tg_tmid = '%s' AND game.game_id = c4m_tournamentgames.tg_gameid", mysql_real_escape_string($id));
    $result = mysql_query($query, $main->link) or die(mysql_error());
    if ($result === false) {
        exit(_T('IDS_Admin_Tournament_Games_GAMESQUERYFAILED', $config));
    }
    $num = mysql_numrows($result);
    $games = array();
    $statuses = get_all_status_values($config);
    $completion_statuses = get_all_completion_status_values($config);
    if ($num != 0) {
        $i = 0;
        while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
            $g = array();
            $g['game_id'] = $row['game_id'];
            $g['white'] = $players[$row['w_player_id']] . '(' . $row['w_player_id'] . ')';
            $g['black'] = $players[$row['b_player_id']] . '(' . $row['b_player_id'] . ')';
            $g['status'] = $statuses[$row['status']];
            $g['completion_status'] = $completion_statuses[$row['completion_status']];
            $g['to_move'] = $row['next_move'] == 'w' ? 'W' : 'B';
            $castle = "";
            if ($row['cast_ws']) {
                $castle .= "%White: Short %";
            }
            if ($row['cast_wl']) {
                $castle .= "%and Long,%";
            }
            if ($row['cast_bs']) {
                $castle .= "% Black: Short%";
            }
            if ($row['cast_bl']) {
                $castle .= "% and Long%";
            }
            $g['castle_status'] = $castle;
            $g['started'] = date('M-d-Y H:i:s', $row['start_time']);
            $g['fen'] = $main->GetInitialGameFEN($config, $row['game_id']);
            $games[] = $g;
        }
    }
    return $games;
}