internal void BanUser(GameClient Client, string Moderator, Double LengthSeconds, string Reason, Boolean IpBan, Boolean Machine)
{
ModerationBanType Type = ModerationBanType.USERNAME;
string Var = Client.GetHabbo().Username;
string RawVar = "user";
Double Expire = SilverwaveEnvironment.GetUnixTimestamp() + LengthSeconds;
if (IpBan)
{
Type = ModerationBanType.IP;
using (IQueryAdapter dbClient = SilverwaveEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("SELECT ip_last FROM users WHERE username='******' LIMIT 1");
Var = dbClient.getString();
}
RawVar = "ip";
}
if (Machine)
{
Type = ModerationBanType.MACHINE;
RawVar = "machine";
Var = Client.MachineId;
}
ModerationBan ban = new ModerationBan(Type, Var, Reason, Expire);
if (ban.Type == ModerationBanType.IP)
{
if (bannedIPs.ContainsKey(Var))
bannedIPs[Var] = ban;
else
bannedIPs.Add(Var, ban);
}
else if (ban.Type == ModerationBanType.MACHINE)
{
if (bannedMachines.ContainsKey(Var))
bannedMachines[Var] = ban;
else
bannedMachines.Add(Var, ban);
}
else
{
if (bannedUsernames.ContainsKey(Var))
bannedUsernames[Var] = ban;
else
bannedUsernames.Add(Var, ban);
}
using (IQueryAdapter dbClient = SilverwaveEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("INSERT INTO bans (bantype,value,reason,expire,added_by,added_date) VALUES (@rawvar,@var,@reason,'" + Expire + "',@mod,'" + DateTime.Now.ToLongDateString() + "')");
dbClient.addParameter("rawvar", RawVar);
dbClient.addParameter("var", Var);
dbClient.addParameter("reason", Reason);
dbClient.addParameter("mod", Moderator);
dbClient.runQuery();
}
if (IpBan)
{
DataTable UsersAffected = null;
using (IQueryAdapter dbClient = SilverwaveEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("SELECT id FROM users WHERE ip_last = @var");
dbClient.addParameter("var", Var);
UsersAffected = dbClient.getTable();
}
if (UsersAffected != null)
{
using (IQueryAdapter dbClient = SilverwaveEnvironment.GetDatabaseManager().getQueryreactor())
{
foreach (DataRow Row in UsersAffected.Rows)
{
dbClient.runFastQuery("UPDATE user_info SET bans = bans + 1 WHERE user_id = " + Convert.ToUInt32(Row["id"]));
}
}
}
BanUser(Client, Moderator, LengthSeconds, Reason, false, false);
}
else
{
using (IQueryAdapter dbClient = SilverwaveEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.runFastQuery("UPDATE user_info SET bans = bans + 1 WHERE user_id = " + Client.GetHabbo().Id);
}
Client.Disconnect();
}
}
internal void LoadBans(IQueryAdapter dbClient)
{
bannedUsernames.Clear();
bannedIPs.Clear();
bannedMachines.Clear();
dbClient.setQuery("SELECT bantype,value,reason,expire FROM bans");
DataTable BanData = dbClient.getTable();
double timestmp = SilverwaveEnvironment.GetUnixTimestamp();
string value;
string reason;
string type;
double expires;
foreach (DataRow dRow in BanData.Rows)
{
value = (string)dRow["value"];
reason = (string)dRow["reason"];
expires = (double)dRow["expire"];
type = (string)dRow["bantype"];
ModerationBanType banType;
if (type == "user")
banType = ModerationBanType.USERNAME;
else if (type == "ip")
banType = ModerationBanType.IP;
else
banType = ModerationBanType.MACHINE;
ModerationBan ban = new ModerationBan(banType, value, reason, expires);
if (expires > timestmp)
{
if (ban.Type == ModerationBanType.USERNAME)
{
if (!bannedUsernames.ContainsKey(value))
bannedUsernames.Add(value, ban);
}
else if (ban.Type == ModerationBanType.IP)
{
if (!bannedIPs.ContainsKey(value))
{
bannedIPs.Add(value, ban);
}
}
else
if (!bannedMachines.ContainsKey(value))
bannedMachines.Add(value, ban);
}
}
}
