$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); } }
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; }