setlevel mysql command help! - Printable Version
+- SA-MP Forums Archive (
https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (
https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (
https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: setlevel mysql command help! (
/showthread.php?tid=347458)
setlevel mysql command help! -
sanrock - 01.06.2012
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.
Re: setlevel mysql command help! -
pointer* - 01.06.2012
pawn Код:
format(query, sizeof(query), "UPDATE `playerdata` SET `level` = '%d' WHERE `user` ='%s'", Level, gVictim);
Re: setlevel mysql command help! -
sanrock - 01.06.2012
Didn't work
Re: setlevel mysql command help! -
pointer* - 01.06.2012
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