Does not save the administrator .... - 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: Does not save the administrator .... (
/showthread.php?tid=589695)
Does not save the administrator .... -
Jimmi - 21.09.2015
Does not save the administrator ....
Код:
if(strcmp(cmd, "/makeadmin", true) == 0)
{
if(IsPlayerConnected(playerid))
{
tmp = strtok(cmdtext, idx);
if(!strlen(tmp))
{
if(PlayerInfo[playerid][pAdmin] == 6)
{
SendClientMessage(playerid, COLOR_GRAD2, "{00FF00}Folosire:{FFFFFF} /makeadmin [playerid/numejucator] [level(1-5)]");
return 1;
}
if(PlayerInfo[playerid][pAdmin] == 7)
{
SendClientMessage(playerid, COLOR_GRAD2, "{00FF00}Folosire:{FFFFFF} /makeadmin [playerid/numejucator] [level(1-7)]");
return 1;
}
if(PlayerInfo[playerid][pAdmin] == 8)
{
SendClientMessage(playerid, COLOR_GRAD2, "{00FF00}Folosire:{FFFFFF} /makeadmin [playerid/numejucator] [level(1-8)]");
return 1;
}
}
new para1;
new level;
para1 = ReturnUser(tmp);
tmp = strtok(cmdtext, idx);
level = strval(tmp);
if(level >= 0 && level <= 8) {} else return 1;
if(PlayerInfo[playerid][pAdmin] == 6 && level > 5)
{
SendClientMessage(playerid, COLOR_GRAD2, "{00FF00}Atentie:{FFFFFF} Pentru ca esti admin 6 nu poti da admin mai mare decat 5 !");
return 1;
}
if(PlayerInfo[playerid][pAdmin] == 7 && level > 8)
{
SendClientMessage(playerid, COLOR_GRAD2, "{00FF00}Atentie:{FFFFFF} Pentru ca esti admin 7 nu poti da admin mai mare decat 7 !");
return 1;
}
if (PlayerInfo[playerid][pAdmin] >= 6 && level <= 5 || PlayerInfo[playerid][pAdmin] >= 7 && level <= 6 || PlayerInfo[playerid][pAdmin] == 8 && level <= 8 || IsPlayerAdmin(playerid))
{
if(IsPlayerConnected(para1))
{
if(para1 != INVALID_PLAYER_ID)
{
GetPlayerName(para1, giveplayer, sizeof(giveplayer));
GetPlayerName(playerid, sendername, sizeof(sendername));
PlayerInfo[para1][pAdmin] = level;
Update(para1, pAdminLevelx);
printf("AdmCmd: %s has promoted %s to a level %d admin.", sendername, giveplayer, level);
format(string, sizeof(string), " Ai fost promovat la rangul de admin de nivelul %d de %s", level, sendername);
SendClientMessage(para1, COLOR_LIGHTBLUE, string);
format(string, sizeof(string), " L-ai promovat pe %s la rangul de admin de nivelul %d.", giveplayer,level);
SendClientMessage(playerid, COLOR_LIGHTBLUE, string);
printf("{0080FF}Comanda{FFFFFF}: Cineva si-a dat admin prin comanda /makeadmin'.");
}
}
}
else
{
SendClientMessage(playerid, COLOR_GRAD1, " Nu ai rangul administrativ necesar!");
}
}
return 1;
}
And:
[21:25:23] [DEBUG] mysql_tquery - connection: 1, query: "", callback: "(null)", format: "(null)"
[21:25:23] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[21:25:23] [ERROR] CMySQLQuery::Execute[] - (error #1065) Query was empty
[21:25:23] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
Код:
case pAdminLevelx:
{
format(var,100,"UPDATE `players` SET `AdminLevel`='%d' WHERE `username`='%s'",PlayerInfo[playerid][pAdmin],playerName);
mysql_tquery(handle,string, "", "");
}
Re: Does not save the administrator .... -
Florentin77 - 21.09.2015
Hello,
As it is written, your query is empty, to correct this, in the Update function:
PHP код:
mysql_format(handle, string, "Your request", ....);
mysql_tquery(handle, string);