[sanrock]

pawn Код:

CMD:setlevel(playerid, params[])
{
    new iD, Level, query[300], pName[24], gMessage[250], gVictim[24];
    if (AdminLevel[playerid] >= 5)
    {
        if(sscanf(params, "ui", iD, Level))
        SendClientMessage(playerid, COLOR_RED, "Usage: /setlevel [playerid] [level]");
        else if(iD == playerid)
        SendClientMessage(playerid, COLOR_RED, "You cannot use that command on yourself");
        else if(!IsPlayerConnected(iD))
        SendClientMessage(playerid, COLOR_RED, "That player is offline.");
        else
        {
            GetPlayerName(playerid, pName, sizeof(pName));
            GetPlayerName(iD, gVictim, sizeof(gVictim));
            format(query, sizeof(query), "UPDATE `playerdata` SET `level` = '%d' WHERE `user` ='%s'", AdminLevel[playerid], gVictim);
            mysql_query(query);

            format(gMessage, sizeof(gMessage), "You have set %s an admin. Level: %d", gVictim, Level);
            SendClientMessage(playerid, COLOR_RED, gMessage);
        }
    }
    else
    {
        SendClientMessage(playerid, COLOR_RED, "You are not high enough admin to use this.");
        }
    return 1;
}

When I try it someone it doesn't set there level it does nothing to them.

[pointer*]

pawn Код:

format(query, sizeof(query), "UPDATE `playerdata` SET `level` = '%d' WHERE `user` ='%s'", Level, gVictim);

[sanrock]

Didn't work

[pointer*]

Try

pawn Код:

format(query, sizeof(query), "UPDATE `playerdata` SET `level` = '%d' WHERE `user` = '%s'", Level, gVictim);

Otherwise enable the mysql_log using "mysql_debug(1);" in OnGameModeInit and post here the log