26 #ifndef _GVMD_MANAGE_SQL_TICKETS_H 27 #define _GVMD_MANAGE_SQL_TICKETS_H 34 #define TICKET_SQL_RESULT_MAY_HAVE_TICKETS \ 35 "(SELECT EXISTS (SELECT * FROM tickets" \ 36 " WHERE id IN (SELECT ticket FROM ticket_results" \ 37 " WHERE result = results.id" \ 38 " AND result_location" \ 39 " = " G_STRINGIFY (LOCATION_TABLE) ")))" void tickets_remove_task(task_t task)
Remove a task from all tickets.
Definition: manage_sql_tickets.c:1595
int delete_ticket(const char *ticket_id, int ultimate)
Delete a ticket.
Definition: manage_sql_tickets.c:696
void tickets_restore_task(task_t task)
Adjust tickets for task being restored.
Definition: manage_sql_tickets.c:1655
void tickets_remove_tasks_user(user_t user)
Remove all of a user's tasks from all tickets.
Definition: manage_sql_tickets.c:1607
int restore_ticket(const char *ticket_id)
Try restore a ticket.
Definition: manage_sql_tickets.c:836
void inherit_tickets(user_t user, user_t inheritor)
Change ownership of tickets, for user deletion.
Definition: manage_sql_tickets.c:1570
void check_tickets(task_t task)
Check if tickets have been resolved.
Definition: manage_sql_tickets.c:1459
user_t ticket_assigned_to(ticket_t ticket)
Return user that ticket is assigned to.
Definition: manage_sql_tickets.c:602
void empty_trashcan_tickets()
Empty ticket trashcans.
Definition: manage_sql_tickets.c:1424
gchar * ticket_nvt_name(ticket_t ticket)
Return NVT name of ticket.
Definition: manage_sql_tickets.c:616
void delete_tickets_user(user_t user)
Delete all tickets owner by a user.
Definition: manage_sql_tickets.c:1538
void tickets_trash_task(task_t task)
Adjust tickets for task being moved to trash.
Definition: manage_sql_tickets.c:1625
user_t ticket_owner(ticket_t ticket)
Return owner of ticket.
Definition: manage_sql_tickets.c:589