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