[Jokers98s]

To ban an player offline

used cache_get_value_name too but still the value of the targetip is null

PHP Code:

CMD:oban(playerid, params[])
{
    if(pInfo[playerid][AdminLvl] < 1) return -1; 
    if(pInfo[playerid][AdminLvl] >= 4) 
    {
        new target[MAX_NICK_LENGTH + 1], reason[50], time;
        if(sscanf(params, "s[20]dS(No reason given)[50]", target, time, reason)) return SendClientMessage(playerid, COLOR_RED, "USAGE: /oban [NAME] [DAYS] [REASON]") ;
        if(time < 0 || time > 365) return SendClientMessage(playerid, COLOR_RED, "ERROR: "COL_GREY"Invalid ban time, must be between 0 ~ 365 (0 = permanent ban).") ;
        new query[65];
        mysql_format(gSQL, query, sizeof query, "SELECT * FROM `Users` WHERE `Name` = '%e'", target);
        if(mysql_tquery(gSQL, query, "OnAccountExist", "i", playerid))
        {
            new str[144], expiretime = (gettime() + (((time * 24) * 60) * 60));
            if(time > 0) format(str, sizeof str, "* ADMIN %s has offline banned %s for \"%s\" till %s.", pName[playerid], target, reason, ReturnDate(expiretime));
            else format(str, sizeof str, "* ADMIN %s has permanently offline banned %s for \"%s\".", pName[playerid], target, reason);
            SendClientMessageToAll(COLOR_PINK, str);
            mysql_format(gSQL, query, sizeof(query), "SELECT * FROM `Users` WHERE `Name` = '%s'", target);
            mysql_tquery(gSQL, query);
            new targetip[12];
            cache_get_value(0, "IP", targetip);
            SendClientMessage(playerid,COLOR_RED,targetip);
            OfflineBanPlayer(targetip, target, pName[playerid], reason, (!time) ? 0 : expiretime);
        }
        else
        {
            SendClientMessage(playerid, COLOR_RED, "ERROR: "COL_GREY"That account doesn't exist.");    
        }
    } 


[Dayrion]

mysql_tquery: Sends a query which will be executed in another thread and call a callback (if there was one specified) when the execution is successfully finished. - click here
mysql_query: This native sends a non-threaded query to the MySQL server. The SA:MP server (the main PAWN thread) waits until the query has been executed and then returns the stored cache handle. - Click here

Simply use mysql_query (don't forget to delete cache when you don't code anymore to treated) or create public forwarded functions with your actually code.

[Meller]

also, an ip can extend up to 16.

255.255.255.255 = (3*4)+3 = 15 + 1 ( for \0 )

[Jokers98s]

Sorry got my mistake thanks rep++ for both