29.05.2016, 15:37
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; }