Quote:
Originally Posted by arne1288
SourceBans is a GLOBAL ban database, built to work across all your servers, and not built as a "per server" ban system.
Remove SourceBans and use the game engine's own ban system if you want things on a "per server" basis.
|
OR just add:
PHP Code:
while(SQL_FetchRow(hndl))
{
new sid = SQL_FetchInt(hndl, 1);
if(serverID != sid)
{
PlayerStatus[client] = true;
return;
}
}
inside the function
PHP Code:
public VerifyBan(Handle:owner, Handle:hndl, const String:error[], any:userid)
between functions:
PHP Code:
SQL_TQuery(DB, ErrorCheckCallback, Query, client, DBPrio_High);
and:
PHP Code:
FormatEx(buffer, sizeof(buffer), "banid 5 %s", clientAuth);
Then in function:
PHP Code:
public OnClientAuthorized(client, const String:auth[])
modify the FormatEx string from:
PHP Code:
"SELECT bid FROM %s_bans WHERE ((type = 0 AND authid REGEXP '^STEAM_[0-9]:%s$') OR (type = 1 AND ip = '%s')) AND (length = '0' OR ends > UNIX_TIMESTAMP()) AND RemoveType IS NULL"
to:
PHP Code:
"SELECT bid, sid FROM %s_bans WHERE ((type = 0 AND authid REGEXP '^STEAM_[0-9]:%s$') OR (type = 1 AND ip = '%s')) AND (length = '0' OR ends > UNIX_TIMESTAMP()) AND RemoveType IS NULL"
__________________