[Jimmi]

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, "", "");
				}

[Florentin77]

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);