return; } } $db->Query('UPDATE {list_category} SET rgt=rgt+2 WHERE rgt >= ? AND project_id = ?', array($right, $proj->id)); $db->Query('UPDATE {list_category} SET lft=lft+2 WHERE lft >= ? AND project_id = ?', array($right, $proj->id)); $db->Query("INSERT INTO {list_category}\n ( project_id, category_name, show_in_list, category_owner, lft, rgt )\n VALUES (?, ?, 1, ?, ?, ?)", array($proj->id, Post::val('list_name'), Post::val('category_owner', 0) == '' ? '0' : Flyspray::UserNameToId(Post::val('category_owner', 0)), $right, $right + 1)); $_SESSION['SUCCESS'] = L('listitemadded'); break; // ################## // adding a related task entry // ################## // ################## // adding a related task entry // ################## case 'details.add_related': if (!$user->can_edit_task($task)) { Flyspray::show_error(L('nopermission')); //TODO: create a better error message break; } // if the user has not the permission to view all tasks, check if the task // is in tasks allowed to see, otherwise tell that the task does not exist. if (!$user->perms('view_tasks')) { $taskcheck = Flyspray::GetTaskDetails(Post::val('related_task')); if (!$user->can_view_task($taskcheck)) { Flyspray::show_error(L('relatedinvalid')); break; } } $sql = $db->Query('SELECT project_id FROM {tasks}