public void method_3(GameClient Session, int int_0, uint uint_0, string string_0)
{
if (Session.GetHabbo().CurrentRoomId > 0u)
{
RoomData @class = GoldTree.GetGame().GetRoomManager().method_11(Session.GetHabbo().CurrentRoomId);
uint uint_ = 0u;
using (DatabaseClient class2 = GoldTree.GetDatabase().GetClient())
{
class2.AddParamWithValue("message", string_0);
class2.AddParamWithValue("name", @class.Name);
class2.ExecuteQuery(string.Concat(new object[]
{
"INSERT INTO moderation_tickets (score,type,status,sender_id,reported_id,moderator_id,message,room_id,room_name,timestamp) VALUES (1,'",
int_0,
"','open','",
Session.GetHabbo().Id,
"','",
uint_0,
"','0',@message,'",
@class.Id,
"',@name,UNIX_TIMESTAMP())"
}));
class2.ExecuteQuery("UPDATE user_info SET cfhs = cfhs + 1 WHERE user_id = '" + Session.GetHabbo().Id + "' LIMIT 1");
uint_ = (uint)class2.ReadDataRow("SELECT Id FROM moderation_tickets WHERE sender_id = '" + Session.GetHabbo().Id + "' ORDER BY Id DESC LIMIT 1")[0];
}
SupportTicket class3 = new SupportTicket(uint_, 1, int_0, Session.GetHabbo().Id, uint_0, string_0, @class.Id, @class.Name, GoldTree.GetUnixTimestamp(), 0u);
this.Tickets.Add(class3);
this.method_11(class3);
}
}
public ServerMessage method_21(SupportTicket class111_0, RoomData class27_0, double double_0)
{
ServerMessage result;
using (DatabaseClient @class = GoldTree.GetDatabase().GetClient())
{
DataTable dataTable = @class.ReadDataTable(string.Concat(new object[]
{
"SELECT user_id,user_name,hour,minute,message FROM chatlogs WHERE room_id = '",
class27_0.Id,
"' AND timestamp >= '",
double_0 - 300.0,
"' AND timestamp < UNIX_TIMESTAMP() ORDER BY timestamp DESC LIMIT 100"
}));
ServerMessage Message = new ServerMessage(534u);
Message.AppendUInt(class111_0.UInt32_0);
Message.AppendUInt(class111_0.SenderId);
Message.AppendUInt(class111_0.ReportedId);
Message.AppendBoolean(class27_0.IsPublicRoom);
Message.AppendUInt(class27_0.Id);
Message.AppendStringWithBreak(class27_0.Name);
if (dataTable != null)
{
Message.AppendInt32(dataTable.Rows.Count);
IEnumerator enumerator = dataTable.Rows.GetEnumerator();
try
{
while (enumerator.MoveNext())
{
DataRow dataRow = (DataRow)enumerator.Current;
Message.AppendInt32((int)dataRow["hour"]);
Message.AppendInt32((int)dataRow["minute"]);
Message.AppendUInt((uint)dataRow["user_id"]);
Message.AppendStringWithBreak((string)dataRow["user_name"]);
Message.AppendStringWithBreak((string)dataRow["message"]);
}
goto IL_186;
}
finally
{
IDisposable disposable = enumerator as IDisposable;
if (disposable != null)
{
disposable.Dispose();
}
}
}
Message.AppendInt32(0);
IL_186:
result = Message;
}
return result;
}
public void method_11(SupportTicket class111_0)
{
GoldTree.GetGame().GetClientManager().method_22(class111_0.Serialize(), "acc_supporttool");
}
public void method_2(DatabaseClient class6_0)
{
Logging.smethod_0("Loading Current Help Tickets..");
DataTable dataTable = class6_0.ReadDataTable("SELECT Id,score,type,status,sender_id,reported_id,moderator_id,message,room_id,room_name,timestamp FROM moderation_tickets WHERE status = 'open' OR status = 'picked'");
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
SupportTicket @class = new SupportTicket((uint)dataRow["Id"], (int)dataRow["score"], (int)dataRow["type"], (uint)dataRow["sender_id"], (uint)dataRow["reported_id"], (string)dataRow["message"], (uint)dataRow["room_id"], (string)dataRow["room_name"], (double)dataRow["timestamp"], (uint)dataRow["moderator_id"]);
if (dataRow["status"].ToString().ToLower() == "picked")
{
@class.method_0((uint)dataRow["moderator_id"], false);
}
this.Tickets.Add(@class);
}
Logging.WriteLine("completed!");
}
}
public void method_11(SupportTicket class111_0)
{
GoldTree.GetGame().GetClientManager().method_22(class111_0.Serialize(), "acc_supporttool");
}