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) ")))"
user_t ticket_owner(ticket_t ticket)
Return owner of ticket.
Definition: manage_sql_tickets.c:593
int delete_ticket(const char *ticket_id, int ultimate)
Delete a ticket.
Definition: manage_sql_tickets.c:703
int restore_ticket(const char *ticket_id)
Try restore a ticket.
Definition: manage_sql_tickets.c:844
void check_tickets(task_t task)
Check if tickets have been resolved.
Definition: manage_sql_tickets.c:1464
void tickets_trash_task(task_t task)
Adjust tickets for task being moved to trash.
Definition: manage_sql_tickets.c:1651
void tickets_remove_report(report_t report)
Remove a report from all tickets.
Definition: manage_sql_tickets.c:1612
gchar * ticket_nvt_name(ticket_t ticket)
Return NVT name of ticket.
Definition: manage_sql_tickets.c:621
user_t ticket_assigned_to(ticket_t ticket)
Return user that ticket is assigned to.
Definition: manage_sql_tickets.c:607
void tickets_restore_task(task_t task)
Adjust tickets for task being restored.
Definition: manage_sql_tickets.c:1681
void empty_trashcan_tickets()
Empty ticket trashcans.
Definition: manage_sql_tickets.c:1429
void tickets_remove_task(task_t task)
Remove a task from all tickets.
Definition: manage_sql_tickets.c:1600
void tickets_remove_tasks_user(user_t user)
Remove all of a user's tasks from all tickets.
Definition: manage_sql_tickets.c:1633
void inherit_tickets(user_t user, user_t inheritor)
Change ownership of tickets, for user deletion.
Definition: manage_sql_tickets.c:1577
void delete_tickets_user(user_t user)
Delete all tickets owner by a user.
Definition: manage_sql_tickets.c:1545