19 #ifndef _GVMD_MANAGE_SQL_TICKETS_H 20 #define _GVMD_MANAGE_SQL_TICKETS_H 27 #define TICKET_SQL_RESULT_MAY_HAVE_TICKETS \ 28 "(SELECT EXISTS (SELECT * FROM tickets" \ 29 " WHERE id IN (SELECT ticket FROM ticket_results" \ 30 " WHERE result = results.id" \ 31 " AND result_location" \ 32 " = " G_STRINGIFY (LOCATION_TABLE) ")))" void tickets_remove_task(task_t task)
Remove a task from all tickets.
Definition: manage_sql_tickets.c:1600
int delete_ticket(const char *ticket_id, int ultimate)
Delete a ticket.
Definition: manage_sql_tickets.c:703
void tickets_remove_report(report_t report)
Remove a report from all tickets.
Definition: manage_sql_tickets.c:1612
void tickets_restore_task(task_t task)
Adjust tickets for task being restored.
Definition: manage_sql_tickets.c:1681
void tickets_remove_tasks_user(user_t user)
Remove all of a user's tasks from all tickets.
Definition: manage_sql_tickets.c:1633
int restore_ticket(const char *ticket_id)
Try restore a ticket.
Definition: manage_sql_tickets.c:844
void inherit_tickets(user_t user, user_t inheritor)
Change ownership of tickets, for user deletion.
Definition: manage_sql_tickets.c:1577
void check_tickets(task_t task)
Check if tickets have been resolved.
Definition: manage_sql_tickets.c:1464
user_t ticket_assigned_to(ticket_t ticket)
Return user that ticket is assigned to.
Definition: manage_sql_tickets.c:607
void empty_trashcan_tickets()
Empty ticket trashcans.
Definition: manage_sql_tickets.c:1429
gchar * ticket_nvt_name(ticket_t ticket)
Return NVT name of ticket.
Definition: manage_sql_tickets.c:621
void delete_tickets_user(user_t user)
Delete all tickets owner by a user.
Definition: manage_sql_tickets.c:1545
void tickets_trash_task(task_t task)
Adjust tickets for task being moved to trash.
Definition: manage_sql_tickets.c:1651
user_t ticket_owner(ticket_t ticket)
Return owner of ticket.
Definition: manage_sql_tickets.c:593