[nGen.SoNNy]

Hi! I want to make a /setlevel command on mysql but it's not working It's not writing in database!
If somebody have another command post here please

pawn Code:

CMD:setlevel( playerid, params[ ] )
{
    new u_P, i_L, string[ 128 ];
    if( IsPlayerAdmin( playerid ) == 0 ) return SendError( playerid, "Only admins can use that command!");
    if( sscanf( params, "ud", u_P, i_L ) ) return SendUsage( playerid, "/setlevel [playerid] [level]" );
    if( u_P == INVALID_PLAYER_ID ) return SendError( playerid, "Player Is Not Connected!" );
    if( i_L < 0 || i_L > 10 ) return SendError( playerid, "Invalid Admin Level!(Max: 10)" );
    AccInfo[ u_P ][ Admin ] = i_L;
    if ( i_L == 0 ){
    format( string, sizeof( string ), "Administrator %s has deleted you Admin account!", PlayerName2( playerid ) );
    return SendClientMessage( u_P, ABLUE, string );}
    format( string, sizeof( string ), "Administrator %s has set your Admin level to %d!", PlayerName2( playerid ), i_L );
    SendClientMessage( u_P, ~1, string );
    format( string, sizeof( string ), "You have set %s Admin level to %d!", u_P, i_L );
    SendClientMessage( playerid, ~1, string );
    if(AccInfo[playerid][Logged] == 1)
    {
        new query[200];
        format(query, sizeof(query), "UPDATE `Users` SET `Admin` = %d WHERE `Name` = %s", i_L, PlayerName2(u_P));
        mysql_query(query);
    }
    return ( 1 );
}

[[DeNi(T)hi]]

Admin command?

[fordawinzz]

pawn Code:

format(query, sizeof(query), "UPDATE `Users` SET `Admin` = %d WHERE `Name` = '%s'", i_L, PlayerName2(u_P));

[nGen.SoNNy]

i will try this

[iRemix]

Try this:

pawn Code:

COMMAND:setlevel(playerid, params[])
{
    new iD, Level, gQuery[250], pName[24], gMessage[250], gVictim[24];
    if(IsPlayerAdmin(playerid) == 1)
    {
        if(sscanf(params, "ui", iD, Level)) return SendClientMessage(playerid, 0xFF0000FF, "* Usage: /setlevel [playerid] [level]");
        else if(iD == playerid) return SendClientMessage(playerid, 0xFF0000FF, "* You cannot use that command on yourself");
        else if(!IsPlayerConnected(iD)) return SendClientMessage(playerid, 0xFF0000FF, "* That player is offline.");
        else
        {
            GetPlayerName(playerid, pName, sizeof(pName));
            GetPlayerName(iD, gVictim, sizeof(gVictim));
            format(gQuery, sizeof(gQuery), "UPDATE Users SET Admin = '%i' WHERE Name = '%s'", Level, pName);
            mysql_query(gQuery);
            
            format(gMessage, sizeof(gMessage), "* You have set %s an admin. Level: %i", gVictim, Level);
            SendClientMessage(playerid, 0xFFFFFFFF, gMessage);
            
            format(gMessage, sizeof(gMessage), "* You have been set as a level %i admin.", Level);
            SendClientMessage(playerid, 0xFFFFFFFF, gMessage);
            
            AccountInfo[iD][Admin] = Level;
        }
    }
    else
    {
        SendClientMessage(playerid, 0xFF0000FF, "* You are not an admin.");
    }
    return 1;
}

Please change the variables to what they are in your script, although that should work with the correct variables.

[nGen.SoNNy]

Thx +1 rep