PHP код:
MySQL R7
#define TABLE_FRAC "`fraction`"
new str[256],
rows,
fields,
buffer[24],
fname[20],
leader[24],
clickFraction[50][MAX_PLAYERS];
forward liderPanel(playerid);
CMD:makeleaders(playerid,params[])
{
if(GetPVarInt(playerid,"Login") != 1) return SendMes(playerid,COLOR_B,"Необходимо авторизоваться!");
if(PlayerInfo[playerid][pAdmin] < 0) return 0;
showLiderPanel(playerid);
return true;
}
showLiderPanel(playerid) {
str = "";
format(str, sizeof str, "SELECT * FROM "TABLE_FRAC"")
mysql_function_query(MYSQL, true, str, "liderPanel", "i", playerid);
return true;
}
public liderPanel(playerid) {
str = "";
cache_get_data(rows, fields);
if (!rows) ShowPlayerDialog(playerid, 0, DIALOG_STYLE_MSGBOX, "{FFFFFF}Панель управления лидерами", "{ffffff}На сервере еще нет созданных фракций", "Выход", "");
for (new i = 0; i != rows; i++) {
cache_get_field_content(i, "ID", buffer); sscanf(buffer, "d", clickFraction[i][playerid]);
cache_get_field_content(i, "Name", fname);
cache_get_field_content(i, "Leader", leader);
format(str, sizeof str, "%s %s - %s\n", str, fname, leader);
}
ShowPlayerDialog(playerid, 150, DIALOG_STYLE_LIST, "{FFFFFF}Панель управления лидерами", str, "Продолжить", "Отмена");
return true;
}