function moveTask($id, $listId)
{
check_write_access();
$db = DBConnection::instance();
// Check task exists and not in target list
$r = $db->sqa("SELECT * FROM {mytinytodo_todos} WHERE id=?", array($id));
if (!$r || $listId == $r['list_id']) {
return false;
}
// Check target list exists
if (!$db->sq("SELECT COUNT(*) FROM {mytinytodo_lists} WHERE id=?", $listId)) {
return false;
}
$ow = 1 + (int) $db->sq("SELECT MAX(ow) FROM {mytinytodo_todos} WHERE list_id=? AND compl=?", array($listId, $r['compl'] ? 1 : 0));
$db->ex("BEGIN");
$db->ex("UPDATE {mytinytodo_tag2task} SET list_id=? WHERE task_id=?", array($listId, $id));
$db->dq("UPDATE {mytinytodo_todos} SET list_id=?, ow=?, d_edited=? WHERE id=?", array($listId, $ow, time(), $id));
$db->ex("COMMIT");
return true;
}
$t['tags'] = $a['tags'];
}
jsonExit($t);
} elseif (isset($_GET['clearCompletedInList'])) {
check_write_access();
stop_gpc($_POST);
$t = array();
$t['total'] = 0;
$listId = (int) _post('list');
$db->ex("BEGIN");
$db->ex("DELETE FROM {$db->prefix}tag2task WHERE task_id IN (SELECT id FROM {$db->prefix}todolist WHERE list_id=? and compl=1)", array($listId));
$db->ex("DELETE FROM {$db->prefix}todolist WHERE list_id={$listId} and compl=1");
$t['total'] = $db->affected();
$db->ex("COMMIT");
jsonExit($t);
} elseif (isset($_GET['setShowNotesInList'])) {
check_write_access();
$listId = (int) _post('list');
$flag = (int) _post('shownotes');
$bitwise = $flag == 0 ? 'taskview & ~2' : 'taskview | 2';
$db->dq("UPDATE {$db->prefix}lists SET taskview={$bitwise} WHERE id={$listId}");
jsonExit(array('total' => 1));
} elseif (isset($_GET['setHideList'])) {
check_write_access();
$listId = (int) _post('list');
$flag = (int) _post('hide');
$bitwise = $flag == 0 ? 'taskview & ~4' : 'taskview | 4';
$db->dq("UPDATE {$db->prefix}lists SET taskview={$bitwise} WHERE id={$listId}");
jsonExit(array('total' => 1));
}
###################################################################################################
