AlliedModders - View Single Post

Dr.Mohammad · *Last edited by Dr.Mohammad; 02-24-2018 at 21:18.*

Quote:

Originally Posted by 1337norway

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"

Nice Work

Thank You For Help