function processConnectToContestRequest($request) { $prfx = DB_PREFIX; //find user in table $row = Data::getRow(sprintf("SELECT {$prfx}user.*, {$prfx}contest.settings\r\n FROM {$prfx}user\r\n LEFT JOIN {$prfx}contest\r\n ON {$prfx}user.contest_id = {$prfx}contest.id\r\n WHERE login=%s AND contest_id=%s", Data::quote_smart($request->login), Data::quote_smart($request->contestID))); //test if there is at least one user if (!$row) { throwBusinessLogicError(12); } //test password if ($row['password'] !== $request->password) { throwBusinessLogicError(12); } //get contest settings and contest time $settings = Data::_unserialize($row['settings'], null); if (is_null($row['contest_start'])) { $now = getdate(); $now = $now[0]; $q = Data::composeUpdateQuery('user', array('contest_start' => DatePHPToMySQL($now)), "id={$row['id']}"); Data::submitModificationQuery($q); $row['contest_start'] = $now; } $contest_time = getCurrentContestTime($settings, DateMySQLToPHP($row['contest_start']), DateMySQLToPHP($row['contest_finish'])); if ($contest_time['interval'] === 'before' && $row['user_type'] === 'Participant') { throwBusinessLogicError(19); } //start new session $session_id = RequestUtils::createSession($row['id']); //get finish time if (is_null($settings)) { $finish_time = 0; } elseif ($settings->contestTiming->selfContestStart) { $finish_time = $row['contest_start'] + 60 * $settings->contestTiming->maxContestDuration; } else { $finish_time = $settings->finish; } if (is_null($finish_time)) { $finish_time = 0; } $res = new ConnectToContestResponse(); $res->sessionID = $session_id; $res->finishTime = $finish_time; $res->user = new UserDescription(); $res->user->userID = (int) $row['id']; $res->user->login = $request->login; $res->user->dataValue = Data::_unserialize($row['user_data'], array()); $res->user->userType = $row['user_type']; return $res; }
/** * Created by IntelliJ IDEA. * User: Посетитель * Date: 17.04.2009 * Time: 15:57:17 * To change this template use File | Settings | File Templates. */ function processStopContestRequest($request) { $user_row = RequestUtils::testSession($request->sessionID); $requested_contest_id = $user_row['contest_id']; if ($requested_contest_id <= 0) { throwBusinessLogicError(0); } $settings = Data::_unserialize($user_row['settings']); if (!$settings->contestTiming->selfContestStart) { throwBusinessLogicError(0); } $time = getCurrentContestTime($settings, DateMySQLToPHP($user_row['contest_start']), DateMySQLToPHP($user_row['contest_finish'])); if ($time['interval'] === 'before') { throwBusinessLogicError(19); } if ($time['interval'] === 'after') { throwBusinessLogicError(20); } $now = getdate(); $now = $now[0]; Data::submitModificationQuery(Data::composeUpdateQuery('user', array('contest_finish' => DatePHPToMySQL($now)), "id={$user_row['id']}")); }
function processSubmitSolutionRequest($request) { $prfx = DB_PREFIX; //get user_id or die, if session is invalid $userRow = RequestUtils::testSession($request->sessionID); $user_id = $userRow['id']; //authorize user for this operation // get contest ID $user_type = $userRow['user_type']; //get problem row $problem_row = Data::getRow(sprintf("SELECT * FROM {$prfx}problem WHERE id=%s", Data::quote_smart($request->problemID))); if (!$problem_row) { throwBusinessLogicError(4); } //get contest id of a problem $problem_contest_id = $problem_row['contest_id']; //test if we have rights to submit solution for the contest $contest_id = RequestUtils::getRequestedContest($problem_contest_id, $userRow['contest_id'], $user_type); if ($contest_id < 0) { throwBusinessLogicError(0); } //get all settings $contest_settings = Data::_unserialize($userRow['settings']); //test submission time $cur_time = getCurrentContestTime($contest_settings, DateMySQLToPHP($userRow['contest_start']), DateMySQLToPHP($userRow['contest_finish'])); if ($cur_time['interval'] === 'before') { throwBusinessLogicError(19); } if ($cur_time['interval'] === 'after') { throwBusinessLogicError(20); } $problem_settings = Data::_unserialize($problem_row['contest_settings']); //test that not all submission attempts were used $hist = Data::getRow(sprintf("SELECT COUNT(*) AS cnt FROM {$prfx}submission_history WHERE (problem_id=%s) AND (user_id=%s)", Data::quote_smart($request->problemID), Data::quote_smart($user_id))); if ($hist >= getSetting($contest_settings->problemsDefaultSettings->sendCount, $problem_settings->sendCount)) { throwBusinessLogicError(21); } //save submission result in history $cur_php_time = getdate(); $col_value = array(); $col_value['problem_id'] = $request->problemID; $col_value['user_id'] = $user_id; $col_value['submission'] = serialize($request->problemResult); $col_value['result'] = null; //serialize($check_result); $col_value['submission_time'] = DatePHPToMySQL($cur_php_time[0]); //TODO implement asynchronous plugin //get problem and create plugin $problem = new Problem(getProblemFile($request->problemID)); $plugin_alias = $problem->getServerPlugin(); require_once getServerPluginFile(); require_once getServerPluginFile($plugin_alias); $plugin = new $plugin_alias($problem); //check solution $last_result = $plugin->checkSolution(Data::getInsertedID(), $request->problemResult); $col_value['result'] = serialize($last_result); Data::submitModificationQuery(Data::composeInsertQuery('submission_history', $col_value)); //get result for result table and store in user $all_results = Data::_unserialize($userRow['results']); $user_result = ResultUtils::getUserResults($user_id, $request->problemID, getSetting($contest_settings->problemsDefaultSettings->tableResultChoice, $problem_settings->tableResultChoice), getSetting($contest_settings->problemsDefaultSettings->resultTransition, $problem_settings->resultTransition), $plugin, $last_result); //update user result for results table $all_results[$request->problemID] = $user_result; Data::submitModificationQuery(Data::composeUpdateQuery('user', array('results' => serialize($all_results)), 'id=' . Data::quote_smart($user_id))); //return submission result $res = new AcceptedResponse(); return $res; }