function Delete($id) { $gw = WT_spawn_new_gateway(); if (!$gw->GetAllowed('CONTEST.DELETE')) { return; } $lid = db_field_value('tester_contests', 'lid', "`id`={$id}"); $c = WT_spawn_new_library($lid); if ($c != nil) { $c->PerformContestDeletion($id); } db_delete('tester_contests', "`id`={$id}"); $this->FillData(); }
function Problem_MoveDown($contest_id, $problem_id) { $letter = $this->ProblemLetter($contest_id, $problem_id); $letter = db_field_value('tester_tasks', 'letter', "`contest_id`={$contest_id} AND " . "`problem_id`={$problem_id}"); $count = $this->GetProblemsCountAtContest($contest_id); if ($letter >= $count) { return; } $letter2 = $letter + 1; $id1 = db_field_value('tester_tasks', 'id', "`contest_id`={$contest_id} AND " . "`problem_id`={$problem_id}"); $id2 = db_field_value('tester_tasks', 'id', "`contest_id`={$contest_id} AND " . "`letter`={$letter2}"); db_swap_values('tester_tasks', $id1, $id2, 'letter', $idfield = 'id'); }
function content_id_by_path($path) { $parent = dirname($path); if ($path == '') { return -1; } if ($path == '/') { return 1; } $pid = content_id_by_path($parent); if ($pid == '') { return -1; } $p = basename($path); $r = db_field_value('content', 'id', "`pid`={$pid} AND `path`=\"{$p}\""); if ($r == '') { return -1; } return $r; }
function GetLastCatItemID($cat_id, $uid) { $table = $this->GetSupportTableByCatID($cat_id); return db_field_value($table, 'id', "`uid`={$uid}", 'ORDER BY `timestamp` DESC LIMIT 1'); }
function user_id_by_login($login) { return db_field_value('user', 'id', '`login`="' . addslashes($login) . '"'); }
function Down() { $dataset = db_field_value('dataset_assoc', 'dataset', '`id`=' . $this->id); db_move_down('dataset_assoc', $this->id, '`dataset`=' . $dataset); }
function manage_dataset_refcount($id) { return db_field_value('dataset', 'refcount', "`id`={$id}"); }
function GetFileID($fn) { return db_field_value('storage_volume_' . $this->GetID(), 'id', '`file`="' . addslashes($fn) . '"'); }
function group_users_inside($id) { return db_field_value('group', 'refcount', '`id`=' . $id); }
function ReceiveLastContentId() { $r = db_field_value($this->settings['content'], 'id', '', 'ORDER BY `timestamp` DESC LIMIT 1'); if ($r == '') { return -1; } return $r; }
function db_move_down($table, $id, $clause = '', $idfield = 'id', $orderfield = 'order') { $order = db_field_value($table, $orderfield, "`{$idfield}`={$id}"); if ($order == '') { return false; } $min = db_min($table, 'order', "`{$orderfield}`>{$order}" . (trim($clause) != '' ? ' AND ' . $clause : '')); if ($min == '') { return false; } $next = db_field_value($table, $idfield, "`{$orderfield}`={$min}" . (trim($clause) != '' ? ' AND ' . $clause : '')); if ($next == '') { return false; } return db_swap_values($table, $id, $next, $orderfield, $idfield); }
function SaveSettings() { $settings = unserialize(db_field_value('content', 'settings', '`id`=' . $this->content_id)); $settings['data'] = $this->GetSettings(); $s = '"' . addslashes(serialize($settings)) . '"'; db_update('content', array('settings' => $s), '`id`=' . $this->content_id); }
function manage_setting_used_by_id($id) { return db_field_value('settings', 'used', "`id`={$id}"); }
function manage_template_by_name($name) { global $manage_template_cache; $id = -1; if ($manage_template_cache != nil) { foreach ($manage_template_cache as $_id => $data) { if ($data['name'] == $name) { $id = $_id; break; } } } if ($id < 0) { $id = db_field_value('templates', 'id', '`name`="' . addslashes($name) . '"'); } if ($id == '') { $id = -1; } return manage_spawn_template($id); }