MySQL Admin level
#2

MySQL >= R33
Код:
CMD:setadm(playerid, params[])
{
	new TargetID, Level, MySQL_Format[300], Name[24];
	
	if(Variable[playerid][Admin] < 5) return SendClientMessage(playerid, -1, "You are not authorized to use this command!");
	
	if(sscanf(params, "ui", TargetID, Level)) return SendClientMessage(playerid, -1, "/setadm [name/id] [level]");
	
	GetPlayerName(TargetID, Name, 24);
	
	mysql_format(ConnectionDB, MySQL_Format, sizeof MySQL_Format, "UPDATE `table_name` SET `admin_column` = '%i' WHERE `player_name` = '%s'", Level, Name);
	mysql_query(ConnectionDB, MySQL_Format);
	
	return 1;
}
Reply


Messages In This Thread
MySQL Admin level - by Deroxi - 29.05.2016, 15:01
Re: MySQL Admin level - by F1N4L - 29.05.2016, 15:37
Re: MySQL Admin level - by Deroxi - 29.05.2016, 15:43
Re: MySQL Admin level - by luke49 - 29.05.2016, 15:56
Re: MySQL Admin level - by Deroxi - 30.05.2016, 18:46
Re: MySQL Admin level - by F1N4L - 30.05.2016, 18:57
Re: MySQL Admin level - by Deroxi - 30.05.2016, 19:17

Forum Jump:


Users browsing this thread: 1 Guest(s)