Тема: @ipban <time> <char Name> (by Griniy, Updated By Empty)

@ipban <time> <char Name> (by Griniy, Updated By Empty)

Автор: ZzAQ: Дата: 06.12.2008

В связи с большими изменениями в структуре SQL запросов в последних ревизиях еА,
Пришлось переделывать многое.
Вот вам поправленный вариант @ipban, прекрасно работает на ревизиях 114хх

Лезим в папку /src/map/ редактируем atcommand.h

AtCommand_ipban, //By [Griniy]

Лезим в /src/map/ редактируем atcommand.c

ACMD_FUNC(ipban); //By [Griniy]

{ AtCommand_ipban,      "@ipban",      20, atcommand_ipban }, //By [Griniy]

//IP ban by [Griniy], updated by [Empty]. Some code merged from charban command by Yor

int atcommand_ipban(const int fd, struct map_session_data* sd, const char* command, const char* message)

{

    char *modif_p, *data, *last_ip;

    int month, value;

    char ip[16];

    nullpo_retr(-1, sd);



    memset(atcmd_output, '\', sizeof(atcmd_output));

    memset(atcmd_player_name, '\', sizeof(atcmd_player_name));



    if (!message || !*message || sscanf(message, "%199s %99[^\n]", atcmd_output, atcmd_player_name) < 2) {

        clif_displaymessage(fd, "Please, enter ban time and a player name (usage: @ipban  ).");

        return -1;

    }

    atcmd_output[sizeof(atcmd_output)-1] = '\';



    modif_p = atcmd_output;

    month = 0;

    while (modif_p[0] != '\') {

        value = atoi(modif_p);

        if (value == 0)

            modif_p++;



        else {

            if (modif_p[0] == '-' || modif_p[0] == '+')

                modif_p++;



            while (modif_p[0] >= '0' && modif_p[0] <= '9') {

                modif_p++;

                if (modif_p[0] == 'm') {

                    month = value;

                    modif_p++;

                } else if (modif_p[0] != '\')

                    modif_p++;

            }

        }

    }

    if (month == 0) {

        clif_displaymessage(fd, msg_table[85]); // Invalid time for ban command.

        return -1;

    }

    if( SQL_ERROR == Sql_Query(mmysql_handle,

        "SELECT `last_ip` From `login`, `char` WHERE login.account_id = char.account_id AND char.name = '%s'", atcmd_player_name ) )

        Sql_ShowDebug(mmysql_handle);



    if( Sql_NumRows(mmysql_handle) == 0 )

    {

        clif_displaymessage(fd, "The character name is unknown. Check and repit");

        Sql_FreeResult(mmysql_handle);

        return -1;

    }



    Sql_NextRow(mmysql_handle);



    Sql_GetData(mmysql_handle, 0, &data, NULL); last_ip = data;

    strcpy(ip, last_ip);

    Sql_FreeResult(mmysql_handle);



    if( SQL_ERROR == Sql_Query(mmysql_handle,"SELECT `rtime` From `ipbanlist` Where `list` = '%s'", ip))

        Sql_ShowDebug(mmysql_handle);



    if( Sql_NumRows(mmysql_handle) > 0 )

    {

        clif_displaymessage(fd, "This Character already in IPban list.");

        Sql_FreeResult(mmysql_handle);

        return -1;

    } else

        Sql_FreeResult(mmysql_handle);



    if( SQL_ERROR == Sql_Query(mmysql_handle,

        "INSERT INTO `ipbanlist` (`list`,`btime`,`rtime`,`reason`) VALUES ('%s', NOW() , NOW() +  INTERVAL %d MONTH ,'AtCommand ban for user name : %s')", ip, month, atcmd_player_name))

        Sql_ShowDebug(mmysql_handle);



    clif_displaymessage(fd, msg_table[88]); // Character name sends to char-server to ask it.

    if (map_nick2sd(atcmd_player_name))

        clif_GM_kick(sd, map_nick2sd(atcmd_player_name));//Kick player



    return 0;

}

Время бана устанавливается в месяцах.
Пример: @ipban +12m Test User

Автор: : Дата: 01.01.1970