/promolist - список промокодов

[Давид Ордян]

/promolist - список промокодов

Спойлер: /promolist

CMDromolist(playerid, params[])
{

new query[115],
Cache: result,
rows,
day_prev,
day_last,
aday_last,
name[21],
list[sizeof query * 25 + 60] = "{"#cW"}Название\t\t{"#cW"}Количество\t{"#cW"}Активировано\n\n{"#cW"}";

mysql_format(mysql, query, sizeof query, "SELECT * FROM promocode WHERE amount > 0 ORDER BY amount DESC");
result = mysql_query(mysql, query, true);

rows = cache_num_rows();

if(cache_num_rows())
{
for(new i; i < rows; i ++)
{
day_prev = cache_get_field_content_int(i, "amount");
day_last = cache_get_field_content_int(i, "usings");
aday_last = cache_get_field_content_int(i, "usings_a");

cache_get_field_content(i, "code", name);

new activations = aday_last - day_last;

format
(
query, sizeof query,
"{"#cW"}%s\t\t%d руб.\t\t\t%d\n",
name,
day_prev,
activations
);

strcat(list, query);
Dialog(playerid, INVALID_DIALOG_ID, DIALOG_STYLE_TABLIST_HEADERS, "{"#cGold"}Список промокодов", list, "Закрыть", "");
}
}
else
{
format(query, sizeof query, "{"#cW"}Список промокодов пуст");
strcat(list, query);
Dialog(playerid, INVALID_DIALOG_ID, DIALOG_STYLE_MSGBOX, "{FF5533}Список промокодов", list, "Закрыть", "");
}

cache_delete(result);

return 1;
}