public static int AddTicket(ModerationTicket ticket)
{
using (DatabaseConnection dbClient = Alias.Server.DatabaseManager.GetConnection())
{
dbClient.AddParameter("time", ticket.Timestamp);
dbClient.AddParameter("senderId", ticket.SenderId);
dbClient.AddParameter("reporterID", ticket.ReportedId);
dbClient.AddParameter("issue", ticket.Message);
dbClient.AddParameter("type", ModerationTicketTypes.GetIntFromType(ticket.Type));
dbClient.AddParameter("roomId", ticket.RoomId);
dbClient.AddParameter("category", ticket.Category);
dbClient.Query("INSERT INTO `support_tickets` (`timestamp`, `sender_id`, `reported_id`, `issue`, `type`, `room_id`, `category`) VALUES (@time, @senderId, @reporterId, @issue, @type, @roomId, @category)");
return(dbClient.LastInsertedId());
}
}
