internal bool CheckIfIsBanned(string userName, string ip, string machineid)
{
if (_bannedUsernames.Contains(userName))
{
ModerationBan moderationBan = (ModerationBan)_bannedUsernames[userName];
if (!moderationBan.Expired)
return true;
}
else
{
if (_bannedIPs.Contains(ip))
{
ModerationBan moderationBan2 = (ModerationBan)_bannedIPs[ip];
if (!moderationBan2.Expired)
return true;
}
else
{
if (!_bannedMachines.ContainsKey(machineid))
return false;
ModerationBan moderationBan3 = _bannedMachines[machineid];
if (!moderationBan3.Expired)
return true;
}
}
return false;
}
/// <summary>
/// Gets the ban reason.
/// </summary>
/// <param name="userName">The username.</param>
/// <param name="ip">The ip.</param>
/// <param name="machineid">The machineid.</param>
/// <returns>System.String.</returns>
internal string GetBanReason(string userName, string ip, string machineid)
{
if (_bannedUsernames.Contains(userName))
{
ModerationBan moderationBan = (ModerationBan) _bannedUsernames[userName];
if (!moderationBan.Expired)
return moderationBan.ReasonMessage;
}
else
{
if (_bannedIPs.Contains(ip))
{
ModerationBan moderationBan2 = (ModerationBan) _bannedIPs[ip];
if (!moderationBan2.Expired)
return moderationBan2.ReasonMessage;
}
else
{
if (!_bannedMachines.ContainsKey(machineid))
return string.Empty;
ModerationBan moderationBan3 = _bannedMachines[machineid];
if (!moderationBan3.Expired)
return moderationBan3.ReasonMessage;
}
}
return string.Empty;
}
/// <summary>
/// Loads the bans.
/// </summary>
/// <param name="dbClient">The database client.</param>
internal void LoadBans(IQueryAdapter dbClient)
{
_bannedUsernames.Clear();
_bannedIPs.Clear();
_bannedMachines.Clear();
dbClient.SetQuery("SELECT bantype,value,reason,expire FROM users_bans");
DataTable table = dbClient.GetTable();
double num = Yupi.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;
switch (a)
{
case "user":
type = ModerationBanType.UserName;
break;
case "ip":
type = ModerationBanType.Ip;
break;
default:
type = ModerationBanType.Machine;
break;
}
ModerationBan moderationBan = new ModerationBan(type, text, reasonMessage, num2);
if (!(num2 > num))
continue;
switch (moderationBan.Type)
{
case ModerationBanType.UserName:
if (!_bannedUsernames.Contains(text))
_bannedUsernames.Add(text, moderationBan);
break;
case ModerationBanType.Ip:
if (!_bannedIPs.Contains(text))
_bannedIPs.Add(text, moderationBan);
break;
default:
if (!_bannedMachines.ContainsKey(text))
_bannedMachines.Add(text, moderationBan);
break;
}
}
}
/// <summary>
/// Bans the user.
/// </summary>
/// <param name="client">The client.</param>
/// <param name="moderator">The moderator.</param>
/// <param name="lengthSeconds">The length seconds.</param>
/// <param name="reason">The reason.</param>
/// <param name="ipBan">if set to <c>true</c> [ip ban].</param>
/// <param name="machine">if set to <c>true</c> [machine].</param>
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 typeStr = "user";
double num = Yupi.GetUnixTimeStamp() + lengthSeconds;
if (ipBan)
{
type = ModerationBanType.Ip;
using (IQueryAdapter queryReactor = Yupi.GetDatabaseManager().GetQueryReactor())
{
queryReactor.SetQuery("SELECT ip_last FROM users WHERE username = @name LIMIT 1");
queryReactor.AddParameter("name", text);
text = queryReactor.GetString();
}
typeStr = "ip";
}
if (machine)
{
type = ModerationBanType.Machine;
typeStr = "machine";
text = client.MachineId;
}
ModerationBan moderationBan = new ModerationBan(type, text, reason, num);
switch (moderationBan.Type)
{
case ModerationBanType.Ip:
if (_bannedIPs.Contains(text)) _bannedIPs[text] = moderationBan;
else _bannedIPs.Add(text, moderationBan);
break;
case ModerationBanType.Machine:
if (_bannedMachines.ContainsKey(text)) _bannedMachines[text] = moderationBan;
else _bannedMachines.Add(text, moderationBan);
break;
default:
if (_bannedUsernames.Contains(text)) _bannedUsernames[text] = moderationBan;
else _bannedUsernames.Add(text, moderationBan);
break;
}
using (IQueryAdapter queryreactor2 = Yupi.GetDatabaseManager().GetQueryReactor())
{
queryreactor2.SetQuery(
"INSERT INTO users_bans (bantype,value,reason,expire,added_by,added_date) VALUES (@rawvar,@var,@reason,@num,@mod,@time)");
queryreactor2.AddParameter("rawvar", typeStr);
queryreactor2.AddParameter("var", text);
queryreactor2.AddParameter("reason", reason);
queryreactor2.AddParameter("num", num);
queryreactor2.AddParameter("mod", moderator);
queryreactor2.AddParameter("time", DateTime.Now.ToLongDateString());
queryreactor2.RunQuery();
}
if (ipBan)
{
DataTable dataTable;
using (IQueryAdapter queryreactor3 = Yupi.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 = Yupi.GetDatabaseManager().GetQueryReactor())
{
foreach (DataRow dataRow in dataTable.Rows)
queryreactor4.RunFastQuery(
$"UPDATE users_info SET bans = bans + 1 WHERE user_id = {Convert.ToUInt32(dataRow["id"])}");
}
}
BanUser(client, moderator, lengthSeconds, reason, false, false);
return;
}
using (IQueryAdapter queryreactor5 = Yupi.GetDatabaseManager().GetQueryReactor())
queryreactor5.RunFastQuery(
$"UPDATE users_info SET bans = bans + 1 WHERE user_id = {client.GetHabbo().Id}");
client.Disconnect("banned");
}
