Frend Williams
Умник
Есть система промокодов в моде, они работают, но почему то не отображаются, когда пытаешься их посмотреть через панель Администратора. Буду благодарен любой помощи!
Код:
case 12:
{
static query_string[] = "SELECT time_promocodes.promo_text, \
time_promocodes.promo_used, \
time_promocodes.promo_exp, \
time_promocodes.promo_money, \
time_promocodes.promo_drivelic, \
time_promocodes.promo_gunlic, \
time_promocodes.promo_boatlic, \
time_promocodes.promo_flylic, \
time_promocodes.promo_skill_silenced, \
time_promocodes.promo_skill_deagle, \
time_promocodes.promo_skill_shotgun, \
time_promocodes.promo_skill_mp5, \
time_promocodes.promo_skill_ak47, \
time_promocodes.promo_skill_m4, \
time_promocodes.promo_skill_rifle \
FROM `time_promocodes`";
mysql_tquery(sql_connection, query_string, "promo_code_list", "i", playerid);
}
Код:
callback: promo_code_list(const playerid)
{
static const header_dialog[] = "{"#cBL"}Название промокода\t\
{"#cBL"}Сколько раз использовали\t\
{"#cBL"}Выдача EXP\t\
{"#cBL"}Количество денег\t\
{"#cBL"}Лицензия на вождение\t\
{"#cBL"}Лицензия на оружие\t\
{"#cBL"}Лицензия на лодки\t\
{"#cBL"}Лицензия на воздушный транпорт\t\
{"#cBL"}Скиллы на USP\t\
{"#cBL"}Скиллы на DEAGLE\t\
{"#cBL"}Скиллы на SHOUTGUN\t\
{"#cBL"}Скиллы на MP5\t\
{"#cBL"}Скиллы на AK-47\t\
{"#cBL"}Скиллы на m4\t\
{"#cBL"}Скиллы на rifle\t";
new
rows = cache_num_rows(),
promo_code_name[32],
promo_code_used,
promo_code_exp,
promo_code_money,
promo_code_lic_drive,
promo_code_lic_gun,
promo_code_lic_boat,
promo_code_lic_fly,
promo_code_skill_usp,
promo_code_skill_deagle,
promo_code_skill_shoutgun,
promo_code_skill_mp5,
promo_code_skill_ak47,
promo_code_skill_m4,
promo_code_skill_rifle,
val_str[11];
static string[1500];
string[0] = EOS;
if(rows)
{
for(new i = 0; i < rows; i++)
{
if(i == 0)
{
strcat(string, header_dialog);
}
cache_get_field_content(i, "promo_text", promo_code_name, sql_connection);
promo_code_used = cache_get_field_content_int(i, "promo_used", sql_connection);
promo_code_exp = cache_get_field_content_int(i, "promo_exp", sql_connection);
promo_code_money = cache_get_field_content_int(i, "promo_money", sql_connection);
promo_code_lic_drive = cache_get_field_content_int(i, "promo_drivelic", sql_connection);
promo_code_lic_gun = cache_get_field_content_int(i, "promo_gunlic", sql_connection);
promo_code_lic_boat = cache_get_field_content_int(i, "promo_boatlic", sql_connection);
promo_code_lic_fly = cache_get_field_content_int(i, "promo_flylic", sql_connection);
promo_code_skill_usp = cache_get_field_content_int(i, "promo_skill_silenced", sql_connection);
promo_code_skill_deagle = cache_get_field_content_int(i, "promo_skill_deagle", sql_connection);
promo_code_skill_shoutgun = cache_get_field_content_int(i, "promo_skill_shoutgun", sql_connection);
promo_code_skill_mp5 = cache_get_field_content_int(i, "promo_skill_mp5", sql_connection);
promo_code_skill_ak47 = cache_get_field_content_int(i, "promo_skill_ak47", sql_connection);
promo_code_skill_m4 = cache_get_field_content_int(i, "promo_skill_m4", sql_connection);
promo_code_skill_rifle = cache_get_field_content_int(i, "promo_skill_rifle", sql_connection);
strcat(string, promo_code_name);
strcat(string, "\t");
valstr(val_str, promo_code_used);
strcat(string, val_str);
strcat(string, "\t\n");
valstr(val_str, promo_code_exp);
strcat(string, val_str);
strcat(string, "\t\n");
valstr(val_str, promo_code_money);
strcat(string, val_str);
strcat(string, "\t\n");
strcat(string, (promo_code_lic_drive == 0) ? ("{FF0000}-") : ("{33AA33}+"));
strcat(string, "\t");
strcat(string, (promo_code_lic_gun == 0) ? ("{FF0000}-") : ("{33AA33}+"));
strcat(string, "\t");
strcat(string, (promo_code_lic_boat == 0) ? ("{FF0000}-") : ("{33AA33}+"));
strcat(string, "\t");
strcat(string, (promo_code_lic_fly == 0) ? ("{FF0000}-") : ("{33AA33}+"));
strcat(string, "\t");
strcat(string, (promo_code_skill_usp == 0) ? ("{FF0000}-") : ("{33AA33}+"));
strcat(string, "\t");
strcat(string, (promo_code_skill_deagle == 0) ? ("{FF0000}-") : ("{33AA33}+"));
strcat(string, "\t");
strcat(string, (promo_code_skill_shoutgun == 0) ? ("{FF0000}-") : ("{33AA33}+"));
strcat(string, "\t");
strcat(string, (promo_code_skill_mp5 == 0) ? ("{FF0000}-") : ("{33AA33}+"));
strcat(string, "\t");
strcat(string, (promo_code_skill_ak47 == 0) ? ("{FF0000}-") : ("{33AA33}+"));
strcat(string, "\t");
strcat(string, (promo_code_skill_m4 == 0) ? ("{FF0000}-") : ("{33AA33}+"));
strcat(string, "\t");
strcat(string, (promo_code_skill_rifle == 0) ? ("{FF0000}-") : ("{33AA33}+"));
strcat(string, "\t");
}
show_dialog(playerid, d_none, DIALOG_STYLE_TABLIST_HEADERS, "{"#cBL"}Лист промокодов", string, "Ок", "");
}
}