under OnPlayerConnect
CheckPlayerBan(playerid)
{
format(BanInfo[playerid][bip],20,"%s",ReturnPlayerIp(playerid));
new ORM:ormid2 = BanInfo[playerid][ORM_ID] = orm_create("pbans", c_handle);
orm_addvar_string(ormid2, BanInfo[playerid][bname], 25, "pBanned");
orm_addvar_string(ormid2, BanInfo[playerid][badmin], 25, "pBannedBy");
orm_addvar_string(ormid2, BanInfo[playerid][btime], 30, "pBanTime");
orm_addvar_string(ormid2, BanInfo[playerid][bdate], 30, "pBanDate");
orm_addvar_string(ormid2, BanInfo[playerid][bip], 20, "IP");
orm_addvar_string(ormid2, BanInfo[playerid][breason], 128, "pBanReason");
orm_setkey(ormid2, "IP");
orm_select(ormid2, "pbancheck", "d", playerid);
return 1;
}
forward pbancheck(playerid);
public pbancheck(playerid)
{
if(playerid != INVALID_PLAYER_ID) // if the player is still connected
{
switch(orm_errno(BanInfo[playerid][ORM_ID]))
{
case ERROR_OK:
{
new string[128];
format(string, sizeof(string), "%s, you were banned by %s for %s. Time: %s, %s", GetPlayerNameEx(playerid), BanInfo[playerid][badmin], BanInfo[playerid][breason], BanInfo[playerid][bdate], BanInfo[playerid][btime]);
SendClientMessage(playerid, COLOR_WHITE, " ");
SendClientMessage(playerid, COLOR_WHITE, " ");
SendClientMessage(playerid, COLOR_RED,string);
SendClientMessage(playerid, COLOR_CYAN2, "To play again visit: www.paruni.com");
SendClientMessage(playerid, COLOR_CYAN2, "This connection has been put on record.");
new query2[128];
mysql_format(c_handle,query2, sizeof(query2), "UPDATE pbans SET pBanEvade = %d WHERE `pBanned` = '%e'", 1, GetPlayerNameEx(playerid));
mysql_tquery(c_handle, query2, "SendQuery", "");
printf("%s Has Been Blocked From Connecting To The Server. IP: %s",GetPlayerNameEx(playerid),ReturnPlayerIp(playerid));
PlayerPlaySound(playerid, 1062, 0.0, 0.0, 0.0);
orm_destroy(BanInfo[playerid][ORM_ID]);
for(new bInfo:e; e < bInfo; ++e)
{
BanInfo[playerid][e] = 0;
}
KickEx(playerid);
}
case ERROR_NO_DATA:
{
orm_destroy(BanInfo[playerid][ORM_ID]);
new query[128];
mysql_format(c_handle,query, sizeof(query), "SELECT * FROM `tban` WHERE `IP` = '%e' OR `Name` = '%e'", ReturnPlayerIp(playerid), GetPlayerNameEx(playerid));
mysql_tquery(c_handle, query, "tbancheck", "i", playerid);
}
case ERROR_INVALID:
{
CheckPlayerBan(playerid);
}
}
}
return 1;
}