[Zeus666]

PHP код:

stock offlineban(player_name, player_banner, reason[], time = 0, system = 0)
{
    if(system == 0)
    {
        if(strlen(reason) > MAX_REASON_LENGTH) return SendClientMessage(player_banner, 0xFFFFFF, ""chat" Sorry, the maximum reason length is "#MAX_REASON_LENGTH" characters!");
        if(gotBanned[player_name] == 0)
        {
            gotBanned[player_name] = 1;
            format(jQuery, MAX_QUERY_LENGTH, "INSERT INTO `"#J_TABLE"` (player_name, user_banned_ip, user_banner, ban_reason, ban_timestamp, ban_time) VALUES ('%s', '%s', 'System', '%s', CURRENT_TIMESTAMP, %d)", jNames[player_banned], jIP[player_banned], reason, time);
            mysql_tquery(handle, jQuery, "", "");
            gotBanned[player_name] = 1;
            printf(jQuery);
        }
    }
    else
    {
        if(strlen(reason) > MAX_REASON_LENGTH) return SendClientMessage(player_banner, 0xFFFFFF, ""chat" Sorry, the maximum reason length is "#MAX_REASON_LENGTH" characters!");
        if(gotBanned[player_name] == 0)
        {
            gotBanned[player_name] = 1;
            format(jQuery, MAX_QUERY_LENGTH, "INSERT INTO `"#J_TABLE"` (player_name, user_banned_ip, user_banner, ban_reason, ban_timestamp, ban_time) VALUES ('%s', '%s', '%s', '%s', CURRENT_TIMESTAMP, %d)", jNames[player_banned], jIP[player_banned], jNames[player_banner], reason, time);
            mysql_tquery(handle, jQuery, "", "");
            printf(jQuery);
            KickEx(player_banned);
        }
    }
    return 1;
} 


PHP код:

CMD:offlinetban(playerid, params[]) 
{ 
    if(pInfo[playerid][pAdminLevel] >= 2) 
    { 
        new ban_target2[24], string[128]; 
          if(sscanf(params, "s[24]", ban_target, ban_time, ban_reason)) return SendClientMessage(playerid, -1,""COL_RED"AdmCmds: /offlineban [Nickname] [Days] [Reason]"); 
        format(string, sizeof(string),"*COL_RED*""%s %s has banned %s for %i days [Reason: %s]",GetAdminName(playerid),PlayerName(playerid),ban_target, ban_time, ban_reason); 
        SendClientMessageToAll(-1, string); 
        offlineban(ban_target2, playerid, ban_reason, ban_time, 1); 
    } 
    else { 
        SendClientMessage(playerid,-1,""COL_RED"EROARE: U aint admin!"); 
    } 
    return 1; 
} 
CMD:offlineban(playerid, params[]) 
{ 
    if(pInfo[playerid][pAdminLevel] >= 2) 
    { 
        new ban_target3[24], string[128]; 
        if(sscanf(params, "s[24]", ban_target3)) return SendClientMessage(playerid, -1,""COL_RED"AdmCmds: /offlineban [Nickname]"); 
        format(string, sizeof(string), ""COL_RED"AdmCmds: %s %s  has  permanent  banned %s [Reason: %s]",GetAdminName(playerid),PlayerName(playerid),ban_target3, ban_reason); 
        SendClientMessageToAll(-1, string); 
        offlineban(ban_target3, playerid, ban_reason, 0, 1); 
    } 
    else { 
        SendClientMessage(playerid,-1,""COL_RED"EROARE: U aint admin"); 
    } 
    return 1; 
} 


My question is, if I ban someone by it's username even if he's not online, how can stock detect his IP from mysql?


ex. in mysql username: Zeus. IP: 160.0.0.0


In Game command: /offlinetban Zeus 5(days) Reason

but how can script detects zeus's IP if he's not online?

[v1k1nG]

You said it yourself!
Using MySql? Saving player account infos? Save the IP too, query the results searching by username get the saved IP address and the job is done.

[Zeus666]

Quote:

Originally Posted by v1k1nG You said it yourself! Using MySql? Saving player account infos? Save the IP too, query the results searching by username get the saved IP address and the job is done.

PHP код:

format(query, sizeof(query), "SELECT IP FROM `users` WHERE `Username`= '%s'", player_name); 


?

[UFF]

Quote:

Originally Posted by Zeus666 PHP код: format(query, sizeof(query), "SELECT IP FROM `users` WHERE `Username`= '%s'", player_name);  ?

Yeah exactly.

[solstice_]

It's best you use mysql_format and escape the string using %e

[Zeus666]

Quote:

Originally Posted by UFF Yeah exactly.

and where should i put query ? and how can I insert IP got from query in the stock offlineban?

[Calisthenics]

The code will not compile as the first parameter of function offlineban takes a string (player's name) as argument but in the function itself, you have it as integer and have variables for it. This will not work for offline, here is what you should do:

• Execute a SELECT query to fetch the last ip used by the said player and pass in mysql_tquery callback parameters (admin's name, reason)
  • No rows? Player does not exist in database
  • Rows found? Retrieve ip, format a new query with all the information you now have and execute the INSERT query.

Before doing anything of it, pass the player's name in sscanf to check if the player is online and inform admins to use the normal commands to avoid more job than really needed.

Your sscanf specifiers are also wrong. You never store to ban_reason or ban_time.