offunlwarn

CMD:offunlwarn(playerid, params[])
{
    IsAdmin(6);
    else if(!gAdminLogged[playerid]) return SendClientMessage(playerid, COLOR_GREY, YouAreNotLoggedInAsAdmin);
    new playername[MAX_PLAYER_NAME];
    if(sscanf(params, "s[24]", playername)) return SendClientMessage(playerid, COLOR_WHITE, "Введите: /offunlwarn [ник игрока]");
    else if(GetPlayerID(playername) != INVALID_PLAYER_ID) return SendClientMessage(playerid, COLOR_GREY, "Игрок в сети, используйте команду /unlwarn");
    mysql_query_string[0] = EOS;
    format(mysql_query_string, sizeof(mysql_query_string), "SELECT `pMemberWarn` FROM "T_ACCOUNTS" WHERE name = '%s'", playername);
    mysql_tquery(dbHandle, mysql_query_string, "@OnPlayerOffunwarn", "is", playerid, playername);
    return 1;
}

@OnPlayerOffunlwarn(playerid,name[]);
@OnPlayerOffunlwarn(playerid,name[])
{
    new rows,fields;
    cache_get_data(rows,fields);
    if(rows)
    {
        new string[144], fwarns;
        fwarns = cache_get_row_int(0,0);
        if(fwarns <1) return SendClientMessage(playerid,COLOR_GREY,"У данного лидера нет выговоров");
        format(string,sizeof(string),"<ADM> %s[%d] снял выговор лидеру %s в оффлайне",GetName(playerid),playerid,name);
        SendAdminMessage(COLOR_GREY, string);
        mysql_query_string[0] = EOS;
        format(mysql_query_string,150,"UPDATE "T_ACCOUNTS" SET memberwarn = %d WHERE name = '%s'",fwarns-1,name);
        mysql_tquery(dbHandle,mysql_query_string,"","");
    }
    else SendClientMessage(playerid,COLOR_GREY,"Игрок не найден!");
    return 1;
}