[TonyNames]

Hi there.

Whenever i create a faction it saves into the MySQL but everytime i do /makeleader it wont enter the faction like the faction dosent exist all i say is

Quote:

Admin %s has just given you leader rank in faction .

Here is the whole command

Код:

CMD:makeleader(playerid, params[])
{
	if(!CheckAdmin(playerid, HIGH_ADMIN_LEVEL)) return NotAuthMSG(playerid);
	new id, faction;
	if(sscanf(params,"ud",id,faction)) return SyntaxMSG(playerid, "/makeleader [playerid] [factionid(/factions)]");
	if(!PlayerIsOn(id)) return NotConnectedMSG(playerid);
	format(msg, sizeof(msg), "AdmCmd: %s has just given %s leader rank in faction %s.", GetName(playerid), GetName(id), GetShortFactionName(faction));
	AMSG(COLOR_LIGHTRED, msg);
	format(msg, sizeof(msg), "Admin %s has just given you leader rank in faction %s.", GetName(playerid), GetShortFactionName(faction));
	SCM(id, COLOR_LIGHTRED, msg);
	PlayerInfo[id][pRank] = Factions[faction][fLeaderRank];
	PlayerInfo[id][pFaction] = faction; 
	PlayerInfo[id][pBadgeNumber] = randomEx(23465, 99999);
	return 1;
}

Do i need a query or something?

P.S. how do i make it to a pawn code on the forums? instead of just [code]

[TonyNames]

shall i make a query like this?Ё

Код:

	format(query, sizeof(query), "UPDATE `factions` SET `leaderrank` = %d WHERE `id` = %d", rank, Factions[factionid][fID]);
	mysql_function_query(dbHandle, query, false, "", "");
	return 1;

[TonyNames]

i'm a bit confused about this one

Код:

format(query, sizeof(query), "UPDATE `factions` SET `leaderrank` = %d WHERE `id` = %d", rank, Factions[factionid][fID]);
	mysql_function_query(dbHandle, query, false, "", "");
	return 1;

[TunisianoGamer]

I think there is nothing wrong with that query . You should test it

[TonyNames]

But it gives me undefined symbol ''rank''

[TunisianoGamer]

Quote:

New rank = Factions[faction][fLeaderRank]; format(query, sizeof(query), "UPDATE `factions` SET `leaderrank` = %d WHERE `id` = %d", rank, Factions[factionid][fID]); mysql_function_query(dbHandle, query, false, "", "");

return 1;