Example #1
0
             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}