forward ActivatePromo(playerid,code[]);
public ActivatePromo(playerid,code[])
{
	new rows,fields;
	cache_get_data(rows, fields);
	//printf("Не существует 2");
	if(!rows) return SendClientMessage(playerid,-1,""cError"{FFFFFF}промокода не существует.");
	new typepriz,amountpriz,nactivations,string[512],activate,block2,data[24],typetext[34],typetext1[24];
	new year,month,day;
	new current_date = getdate(year, month, day);
	for(new i; i < rows; i++)
	{
		typepriz = cache_get_row_int(i, 5, connects);
		amountpriz = cache_get_row_int(i, 6, connects);
		nactivations = cache_get_row_int(i, 3, connects);
		activate = cache_get_row_int(i, 1, connects);
		block2 = cache_get_row_int(i, 2, connects);
		cache_get_row(i, 4, data, connects, 24);
		switch(typepriz)
		{
			case 1: typetext = "VIP аккаунт сроком на",typetext1 = "дней",PlayerInfo[playerid][pDonateRank] = 1,PlayerInfo[playerid][pDonateRankTime] = current_date + amountpriz;
			case 2: typetext = "Игровая валюта в количестве",typetext1 = "$",GiveMoney(playerid,amountpriz);
			case 3: typetext = "DonateMoney в количестве",typetext1 = "DM",PlayerInfo[playerid][pDonatemoney2] += amountpriz;
		}
	}
	if(block2 > 0) return SendClientMessage(playerid,-1,""cError"{FFFFFF}промокод заблокирован.");
	if(activate != 0)
	{
		format(string,sizeof(string),"{FFFFFF}Промокод '%s' {FFFFFF}уже активирован {65A0D0}%s\n{FFFFFF}К сожалению, Вы опоздали. Но ничего, получится в другой раз..",code,data);
		ShowPlayerDialog(playerid,D_NULL,DIALOG_STYLE_MSGBOX,"{FE0000}Ошибка",string,"Закрыть","");
		return true;
	}
	else
	{
		format(string,sizeof(string),"INSERT INTO `promo_activations` (`account_id`,`name_promo`) VALUES ('%d','%s')",PlayerInfo[playerid][pID],code);
		mysql_function_query(connects, string, false, "", "");
		SendClientMessage(playerid,COLOR_ORANGE,"Поздравляем! Вы активировали промокод!");
		format(string,sizeof(string),"Промокод содержал: %s %d%s",typetext,amountpriz,typetext1),SendClientMessage(playerid,COLOR_ORANGE,string);
		nactivations--;
		format(string, sizeof(string), "UPDATE promo SET `nactivations`='%d' WHERE name='%s'", nactivations, code);
		mysql_function_query(connects, string, false, "", "");
	}
	if(nactivations == 0)
	{
		format(string, sizeof(string), "UPDATE promo SET `activate`='1' WHERE name='%s'",code);
		mysql_function_query(connects, string, false, "", "");
		//return SendClientMessage(playerid,-1,""cError"{FFFFFF}количество активаций для промокода исчерпано.");
		return true;
	}
	DeletePVar(playerid,"CODE");
	return 1;
}