TobyMarshal
Дебютант
После того как человек активировал промокод , ему пришло определенное количество денег , но после перезахода эти деньги обнуляются .
HTML:
@PromoCodeCheck2(playerid, code[]);
@PromoCodeCheck2(playerid, code[])
{
new rows, fields;
cache_get_data(rows, fields);
if(rows)
{
SendClientMessage(playerid, COLOR_GREY, "[Ошибка] Вы уже указывали данный промокод");
DeletePVar(playerid, "cash_");
DeletePVar(playerid, "code_players_");
DeletePVar(playerid, "code_data_");
DeletePVar(playerid, "used_count_");
return 1;
}
mysql_query_string[0] = EOS;
format(mysql_query_string, sizeof(mysql_query_string), "INSERT INTO "T_PROMOCODE_USED" (idacca,code) VALUE (%d,'%s')", PI[playerid][pID], code);
mysql_tquery(dbHandle, mysql_query_string, "", "");
new cash, code_players, code_data, used_count;
cash = GetPVarInt(playerid, "cash_");
code_players = GetPVarInt(playerid, "code_players_");
code_data = GetPVarInt(playerid, "code_data_");
used_count = GetPVarInt(playerid, "used_count_");
new string[128];
format(string, sizeof(string), "Промокод {FFFF00}%s{FFFFFF} успешно использован. Вам начислено {63BD4E}%i$", code, cash);
SendClientMessage(playerid, COLOR_WHITE, string);
TransferMoney(-1, playerid, cash, "Использовал промокод", 1);
switch(booston)
{
case 0: PI[playerid][pCash] += cash;
case 1: PI[playerid][pCash] += cash*2;
}
code_players --;
used_count ++;
mysql_query_string[0] = EOS;
format(mysql_query_string, 300, "UPDATE "T_PROMOCODE" SET players = %d, used_count = %d WHERE code = '%s'", code_players, used_count, code);
mysql_tquery(dbHandle, mysql_query_string, "", "");
if(code_players == 0)
{
mysql_query_string[0] = EOS;
format(mysql_query_string, 128, "DELETE FROM "T_PROMOCODE" WHERE code = '%s'", code);
mysql_tquery(dbHandle, mysql_query_string, "", "");
}
if(gettime() >= code_data && code_players == 0)
{
mysql_query_string[0] = EOS;
format(mysql_query_string, 128, "DELETE FROM "T_PROMOCODE" WHERE code = '%s'", code);
mysql_tquery(dbHandle, mysql_query_string, "", "");
}
DeletePVar(playerid, "cash_");
DeletePVar(playerid, "code_players_");
DeletePVar(playerid, "code_data_");
DeletePVar(playerid, "used_count_");
return 1;
}
