public static function getTask() { //find records whose record_judger_id = 0 $db = BFL_Database::getInstance(); $stmt = $db->factory('select `record_id`,`record_prob_id` from ' . DB_TABLE_RECORD . ' where `record_judger_id` = 0 order by `record_id` asc'); $stmt->execute(); $task = $stmt->fetch(); if (!$task) { return array(); } $record_meta = new MDL_Record_Meta($task['record_id']); $task['language'] = $record_meta->getVar('lang'); $task['source'] = $record_meta->getVar('source'); $submit_time = $record_meta->getVar('submit_time'); $task['task_name'] = 'vkm_' . $task['record_id']; $prob_names = MDL_Problem_Show::getProblemName($task['record_prob_id']); $task['prob_name'] = $prob_names['prob_name']; unset($task['record_prob_id']); return $task; }
public static function resetRecord($record_id) { $db = BFL_Database::getInstance(); $stmt = $db->update(DB_TABLE_RECORD, '`record_judger_id` = 0', 'where `record_id`=:record_id'); $stmt->bindParam(':record_id', $record_id); $stmt->execute(); $record_meta = new MDL_Record_Meta($record_id); $meta = array('status' => self::STATUS_WAITING, 'result' => '', 'memory' => '0', 'time' => '0', 'score' => 0.0); $record_meta->setVars($meta); }