internal void LoadBans(IQueryAdapter dbClient)
{
this.bannedUsernames.Clear();
this.bannedIPs.Clear();
this.bannedMachines.Clear();
dbClient.setQuery("SELECT bantype,value,reason,expire FROM bans");
DataTable table = dbClient.getTable();
double num = (double)MercuryEnvironment.GetUnixTimestamp();
foreach (DataRow dataRow in table.Rows)
{
string text = (string)dataRow["value"];
string reasonMessage = (string)dataRow["reason"];
double num2 = (double)dataRow["expire"];
string a = (string)dataRow["bantype"];
ModerationBanType type;
if (a == "user")
{
type = ModerationBanType.USERNAME;
}
else
{
if (a == "ip")
{
type = ModerationBanType.IP;
}
else
{
type = ModerationBanType.MACHINE;
}
}
ModerationBan moderationBan = new ModerationBan(type, text, reasonMessage, num2);
if (num2 > num)
{
if (moderationBan.Type == ModerationBanType.USERNAME)
{
if (!this.bannedUsernames.Contains(text))
{
this.bannedUsernames.Add(text, moderationBan);
}
}
else
{
if (moderationBan.Type == ModerationBanType.IP)
{
if (!this.bannedIPs.Contains(text))
{
this.bannedIPs.Add(text, moderationBan);
}
}
else
{
if (!this.bannedMachines.ContainsKey(text))
{
this.bannedMachines.Add(text, moderationBan);
}
}
}
}
}
}
internal void BanUser(GameClient Client, string Moderator, double LengthSeconds, string Reason, bool IpBan, bool Machine)
{
ModerationBanType type = ModerationBanType.USERNAME;
string text = Client.GetHabbo().Username;
string query = "user";
double num = (double)MercuryEnvironment.GetUnixTimestamp() + LengthSeconds;
if (IpBan)
{
type = ModerationBanType.IP;
using (IQueryAdapter queryreactor = MercuryEnvironment.GetDatabaseManager().getQueryreactor())
{
queryreactor.setQuery("SELECT ip_last FROM users WHERE username='******' LIMIT 1");
text = queryreactor.getString();
}
query = "ip";
}
if (Machine)
{
type = ModerationBanType.MACHINE;
query = "machine";
text = Client.MachineId;
}
ModerationBan moderationBan = new ModerationBan(type, text, Reason, num);
if (moderationBan.Type == ModerationBanType.IP)
{
if (this.bannedIPs.Contains(text))
{
this.bannedIPs[text] = moderationBan;
}
else
{
this.bannedIPs.Add(text, moderationBan);
}
}
else
{
if (moderationBan.Type == ModerationBanType.MACHINE)
{
if (this.bannedMachines.ContainsKey(text))
{
this.bannedMachines[text] = moderationBan;
}
else
{
this.bannedMachines.Add(text, moderationBan);
}
}
else
{
if (this.bannedUsernames.Contains(text))
{
this.bannedUsernames[text] = moderationBan;
}
else
{
this.bannedUsernames.Add(text, moderationBan);
}
}
}
using (IQueryAdapter queryreactor2 = MercuryEnvironment.GetDatabaseManager().getQueryreactor())
{
queryreactor2.setQuery(string.Concat(new object[]
{
"INSERT INTO bans (bantype,value,reason,expire,added_by,added_date) VALUES (@rawvar,@var,@reason,'",
num,
"',@mod,'",
DateTime.Now.ToLongDateString(),
"')"
}));
queryreactor2.addParameter("rawvar", query);
queryreactor2.addParameter("var", text);
queryreactor2.addParameter("reason", Reason);
queryreactor2.addParameter("mod", Moderator);
queryreactor2.runQuery();
}
if (IpBan)
{
DataTable dataTable = null;
using (IQueryAdapter queryreactor3 = MercuryEnvironment.GetDatabaseManager().getQueryreactor())
{
queryreactor3.setQuery("SELECT id FROM users WHERE ip_last = @var");
queryreactor3.addParameter("var", text);
dataTable = queryreactor3.getTable();
}
if (dataTable != null)
{
using (IQueryAdapter queryreactor4 = MercuryEnvironment.GetDatabaseManager().getQueryreactor())
{
foreach (DataRow dataRow in dataTable.Rows)
{
queryreactor4.runFastQuery("UPDATE user_info SET bans = bans + 1 WHERE user_id = " + Convert.ToUInt32(dataRow["id"]));
}
}
}
this.BanUser(Client, Moderator, LengthSeconds, Reason, false, false);
return;
}
using (IQueryAdapter queryreactor5 = MercuryEnvironment.GetDatabaseManager().getQueryreactor())
{
queryreactor5.runFastQuery("UPDATE user_info SET bans = bans + 1 WHERE user_id = " + Client.GetHabbo().Id);
}
Client.Disconnect();
}
