Hello,
Does anyone know how I get ipban fixed when I'm using http proxy?
When I ip-ban someone all users get banned.
I've 2 columns in my users database,
ip_last and ip_reg. IP_last = users ip and ip_reg the server ip.
Ban code:
Is there a way to ban people with the ip_last column?
Does anyone know how I get ipban fixed when I'm using http proxy?
When I ip-ban someone all users get banned.
I've 2 columns in my users database,
ip_last and ip_reg. IP_last = users ip and ip_reg the server ip.
Ban code:
PHP:
internal class ModerationBanManager
{
private Hashtable bannedIPs = new Hashtable();
private Hashtable bannedUsernames = new Hashtable();
internal ModerationBanManager()
{
}
internal void BanUser(GameClient Client, string Moderator, double LengthSeconds, string Reason, bool IpBan)
{
IQueryAdapter adapter;
ModerationBanType uSERNAME = ModerationBanType.USERNAME;
string username = Client.GetHabbo().Username;
string query = "user";
double expire = ButterflyEnvironment.GetUnixTimestamp() + LengthSeconds;
if (IpBan)
{
uSERNAME = ModerationBanType.IP;
username = Client.GetConnection().getIp();
query = "ip";
}
ModerationBan ban = new ModerationBan(uSERNAME, username, Reason, expire);
if (ban.Type == ModerationBanType.IP)
{
if (this.bannedIPs.ContainsKey(username))
{
this.bannedIPs[username] = ban;
}
else
{
this.bannedIPs.Add(username, ban);
}
}
else if (this.bannedUsernames.ContainsKey(username))
{
this.bannedUsernames[username] = ban;
}
else
{
this.bannedUsernames.Add(username, ban);
}
using (adapter = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
{
adapter.setQuery(string.Concat(new object[] { "INSERT INTO bans (bantype,value,reason,expire,added_by,added_date) VALUES (@rawvar,@var,@reason,'", expire, "',@mod,'", DateTime.Now.ToLongDateString(), "')" }));
adapter.addParameter("rawvar", query);
adapter.addParameter("var", username);
adapter.addParameter("reason", Reason);
adapter.addParameter("mod", Moderator);
adapter.runQuery();
}
Is there a way to ban people with the ip_last column?