MySQL /setlevel Command! - Not Working! -
nGen.SoNNy - 29.04.2012
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 );
}
Re: MySQL /setlevel Command! - Not Working! -
[DeNi(T)hi] - 29.04.2012
Admin command?
Re: MySQL /setlevel Command! - Not Working! -
fordawinzz - 29.04.2012
pawn Code:
format(query, sizeof(query), "UPDATE `Users` SET `Admin` = %d WHERE `Name` = '%s'", i_L, PlayerName2(u_P));
Re: MySQL /setlevel Command! - Not Working! -
nGen.SoNNy - 29.04.2012
i will try this
Re: MySQL /setlevel Command! - Not Working! -
iRemix - 29.04.2012
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.
Re: MySQL /setlevel Command! - Not Working! -
nGen.SoNNy - 29.04.2012
Thx

+1 rep