public static List <ModerationTicket> ReadTickets()
{
List <ModerationTicket> tickets = new List <ModerationTicket>();
using (DatabaseConnection dbClient = Alias.Server.DatabaseManager.GetConnection())
{
using (MySqlDataReader Reader = dbClient.DataReader("SELECT * FROM `support_tickets` WHERE `state` != 0"))
{
while (Reader.Read())
{
string senderUsername = "******";
string reportedUsername = "******";
string modUsername = "";
ModerationTicket ticket = new ModerationTicket()
{
Id = Reader.GetInt32("id"),
State = ModerationTicketStates.GetStateFromInt(Reader.GetInt32("state")),
Timestamp = Reader.GetInt32("timestamp"),
Priority = Reader.GetInt32("score"),
SenderId = Reader.GetInt32("sender_id"),
SenderUsername = senderUsername,
ReportedId = Reader.GetInt32("reported_id"),
ReportedUsername = reportedUsername,
ModId = Reader.GetInt32("mod_id"),
ModUsername = modUsername,
Message = Reader.GetString("issue"),
Type = ModerationTicketTypes.GetTypeFromInt(Reader.GetInt32("type")),
RoomId = Reader.GetInt32("room_id"),
Category = Reader.GetInt32("category")
};
if (ticket.ModId <= 0)
{
ticket.ModUsername = "";
ticket.State = ModerationTicketState.OPEN;
}
tickets.Add(ticket);
}
}
}
return(tickets);
}
