Сортировка

[Gressie]

Используется MySQL R5-R6.

CMD:sort(playerid, params[])
{
	if(!AcceptWrite(playerid)) return 1;
	if(pData[playerid][IsAdmin] <= 3) return 1;
	new nick[32];
	new type[32];
	new src[32];
	new datda;
	if(sscanf(params, "s[64]s[32]d",nick, type,params[1])) return SendClientMessage(playerid, COLOR_WHITE, " Введите: /sort [ключ] [ASC, DESC] [размер 1-30]");
	if(params[1] < 1 && params[1] > 30) return SendClientMessage(playerid,COLOR_GREY," от 1 до 30"),mysql_free_result();
	format(httpquery,sizeof(httpquery),"SELECT * FROM `accounts` ORDER BY `accounts`.`%s` %s LIMIT 0 , %d",nick, type, params[1]);
	mysql_query(httpquery);
	mysql_store_result();
	if(!mysql_fetch_row_format(httpquery)) return SendClientMessage(playerid,COLOR_GREY," Аккаунтов не найдено"),mysql_free_result();
	BaseGetInt(nick,datda);
	BaseGet("Nick",src);
	format(httpquery,sizeof(httpquery),"");
	format(akklogin,sizeof(akklogin),"%s: \t\t\t%d\n",src, datda);
	strcat(httpquery,akklogin);
	while(mysql_next_row())
	{
		BaseGetInt(nick,datda);
		BaseGet("Nick",src);
		format(akklogin,sizeof(akklogin),"%s: \t\t\t%d\n",src, datda);
		strcat(httpquery,akklogin);
	}
	ShowPlayerDialog(playerid,DIALOGINFO,0," ",httpquery,"Закрыть","");
	mysql_free_result();
	return 1;
}

Автор: Голубь ( PovarGek )