public static bool IsIPBanned(string ip)
{
bool yes = false;
int now = UnixTimestamp();
IDataReader DBQuery;
if (EBConfig.UseMysql)
{
DBQuery = EBData.DBMysql.QueryReader("SELECT IP FROM BannedIP WHERE IP = @0 AND (UnbanDate>@1 OR UnbanDate = 0)", ip, now).Reader;
}
else
{
DBQuery = EBData.DBSqlite.QueryReader("SELECT IP FROM BannedIP WHERE IP = @0 AND (UnbanDate>@1 OR UnbanDate = 0)", ip, now).Reader;
}
while (DBQuery.Read())
{
if (ip == DBQuery.Get <string>("IP"))
{
yes = true;
break;
}
}
if (!EBConfig.UseMysql)
{
EBData.DBSqlite.Dispose();
}
else
{
EBData.DBMysql.Close();
}
DBQuery.Dispose();
return(yes);
}
public static bool IsPlayerMuted(string plName)
{
bool yes = false;
int now = UnixTimestamp();
IDataReader DBQuery;
if (EBConfig.UseMysql)
{
DBQuery = EBData.DBMysql.QueryReader("SELECT Player FROM MutedPlayer WHERE LOWER(Player) = @0 AND (UnmuteDate>@1 OR UnmuteDate = 0)", plName.ToLower(), now).Reader;
}
else
{
DBQuery = EBData.DBSqlite.QueryReader("SELECT Player FROM MutedPlayer WHERE LOWER(Player) = @0 AND (UnmuteDate>@1 OR UnmuteDate = 0)", plName.ToLower(), now).Reader;
}
while (DBQuery.Read())
{
if (plName.ToLower() == DBQuery.Get <string>("Player").ToLower())
{
yes = true;
break;
}
}
if (!EBConfig.UseMysql)
{
EBData.DBSqlite.Dispose();
}
else
{
EBData.DBMysql.Close();
}
DBQuery.Dispose();
return(yes);
}
public static string[] IPBanInfo(string ip)
{
string[] baninfo = new string[6];
if (!IsValidIP(ip.Replace("*", "255")))
{
return(baninfo);
}
int now = UnixTimestamp();
string[] ipnets = ip.Split('.');
IDataReader DBQuery;
if (EBConfig.UseMysql)
{
DBQuery = EBData.DBMysql.QueryReader("SELECT * FROM BannedIP WHERE UnbanDate>@0 OR UnbanDate = 0", now).Reader;
}
else
{
DBQuery = EBData.DBSqlite.QueryReader("SELECT * FROM BannedIP WHERE UnbanDate>@0 OR UnbanDate = 0", now).Reader;
}
while (DBQuery.Read())
{
string ipban = DBQuery.Get <string>("IP");
string[] nets = ipban.Split('.');
if (nets[0] == ipnets[0] || nets[0] == "*")
{
if (nets[1] == ipnets[1] || nets[1] == "*")
{
if (nets[2] == ipnets[2] || nets[2] == "*")
{
if (nets[3] == ipnets[3] || nets[3] == "*")
{
baninfo[0] = "banned";
baninfo[1] = DBQuery.Get <string>("IP");
baninfo[2] = DBQuery.Get <int>("BanDate").ToString();
baninfo[3] = DBQuery.Get <int>("UnbanDate").ToString();
baninfo[4] = DBQuery.Get <string>("BannedBy");
baninfo[5] = DBQuery.Get <string>("Reason");
break;
}
}
}
}
}
if (!EBConfig.UseMysql)
{
EBData.DBSqlite.Dispose();
}
else
{
EBData.DBMysql.Close();
}
DBQuery.Dispose();
return(baninfo);
}
public static string[] PlayerBanInfo(string plName)
{
string[] baninfo = new string[6];
int now = UnixTimestamp();
IDataReader DBQuery;
if (EBConfig.UseMysql)
{
DBQuery = EBData.DBMysql.QueryReader("SELECT * FROM BannedPlayer WHERE UnbanDate>@0 OR UnbanDate = 0", now).Reader;
}
else
{
DBQuery = EBData.DBSqlite.QueryReader("SELECT * FROM BannedPlayer WHERE UnbanDate>@0 OR UnbanDate = 0", now).Reader;
}
while (DBQuery.Read())
{
string plBanned = DBQuery.Get <string>("Player");
if (plBanned.ToLower() == plName.ToLower())
{
baninfo[0] = "banned";
baninfo[1] = DBQuery.Get <string>("Player");
baninfo[2] = DBQuery.Get <int>("BanDate").ToString();
baninfo[3] = DBQuery.Get <int>("UnbanDate").ToString();
baninfo[4] = DBQuery.Get <string>("BannedBy");
baninfo[5] = DBQuery.Get <string>("Reason");
break;
}
}
if (!EBConfig.UseMysql)
{
EBData.DBSqlite.Dispose();
}
else
{
EBData.DBMysql.Close();
}
DBQuery.Dispose();
return(baninfo);
}