Проблема с записью номеров.

[PING-WIN 0]

Моя проблема заключается в том,что в БД не записываются данные.

Вот код и скриншоты БД:

 

Спойлер

	case D_VEHNUMBER+2:
		{
			if(!response) return 1;
			
			if(PI[playerid][PlayerCarID] == INVALID_VEHICLE_ID) return SendClientMessage(playerid, COLOR_RED, "Сначала необходимо загрузить транспорт в игру: /fixcar");
			
			if(strcmp(C_DATA[playerid][c_number], "None",true)) return SendClientMessage(playerid, COLOR_RED, "У Вас уже имеются номера на автомобиле");
			if(nomercar[playerid] > gettime()) return SendClientMessage(playerid,COLOR_RED,""cER"Номера можно ставить раз в 10 минут");
			
			mysql_tquery(dbHandle, "SELECT number FROM ownable_numbers f JOIN ( SELECT RAND( ) * ( SELECT MAX( id ) FROM ownable_numbers ) AS max_id) AS m WHERE f.id >= m.max_id AND is_used =0 ORDER BY f.id ASC LIMIT 1","DPSNumber_C","i",playerid);
		}

publics: DPSNumber_C(playerid)
{
	new r,f;
	cache_get_data(r,f);
	
	if(r == 0) return 1;
	
	new local_string[10];
	cache_get_field_content(0, "number", local_string, dbHandle, 10); 
	
	global_string = "";
	format(global_string, 120, "UPDATE `ownable_numbers` SET is_used = 1 WHERE number = '%s'",local_string);
	mysql_tquery(dbHandle, global_string,"", "");
	
	global_string = "";
	format(global_string, sizeof(global_string), "{FFFFFF}Место регистрации: {63BD4E}Пункт выдачи номеров{FFFFFF}\nНомер вашего авто: {63BD4E}%s", local_string);
	ShowPlayerDialog(playerid, D_NULL, DIALOG_STYLE_MSGBOX, "{"#cSV"}Получение номера", global_string, "Закрыть", "");
	foreach(new i: Player)
	{
		if(PlayerLogged[i] == false) continue;
		if(IsADps(i)) SendMes(i, 0x3399FFFF, "[Пункт выдачи номеров] %s[%i] зарегистрировал номер на авто #1 [%s]", GetName(playerid), playerid, local_string);
	}
	new strings[74];
	format(strings, sizeof strings, "{78A94D}%s", local_string);
	strmid(C_DATA[playerid][c_number], local_string, 0, strlen(local_string), 64);
	TransferMoney(playerid, -1, 5000);
	nomercar[playerid] = gettime() + 300;
	if(VehicleLabel[PI[playerid][PlayerCarID]] != Text3D:INVALID_3DTEXT_ID) UpdateVehicleLabel(PI[playerid][PlayerCarID], 0xFFFFFFFF, strings);
	SetPlayerCarNumber(playerid);
	SavePlayerCar(playerid);
	return 1;
}

Спойлер

 

В моем случае донат номера выдаются,но они сохраняются в `ownable_cars`  `c_number`.

Вот код:

Спойлер

	case D_DONATE+17:
		{
			if(!response) return callcmd::donate(playerid);
			new fletter[5], sletter[5], tletter[5], rnumber[10], cnumber[15], figures[10], labelcar[65];
			GetPVarString(playerid, "FirstLetter", fletter, sizeof fletter);
			GetPVarString(playerid, "SecondLetter", sletter, sizeof sletter);
			GetPVarString(playerid, "ThirdLetter", tletter, sizeof tletter);
			GetPVarString(playerid, "Region", rnumber, sizeof rnumber);
			GetPVarString(playerid, "ColorNumber", cnumber, sizeof cnumber);
			GetPVarString(playerid, "figures", figures, sizeof figures);
			
			format(labelcar, 64, "%s%s%s%s %s| %sRUS", fletter, figures, sletter, tletter, cnumber, rnumber);

			format(global_string, sizeof(global_string), "SELECT `c_number` FROM `ownable_cars` WHERE `c_number` = '%s'", labelcar);
			mysql_tquery(dbHandle, global_string,"DonateNumber_C","i",playerid);
			
			return 1;
		}

publics:DonateNumber_C(playerid)
{
	new r,f;
	cache_get_data(r,f);
	
	if(r > 0)
	{
		DeletePVar(playerid, "FirstLetter"); DeletePVar(playerid, "SecondLetter"); DeletePVar(playerid, "ThirdLetter");
		DeletePVar(playerid, "Region"); DeletePVar(playerid, "ColorNumber"); DeletePVar(playerid, "figures");
		SendClientMessage(playerid, COLOR_RED, "Номер уже используется, придумайте новый и повторите попытку..");
		return 1;
	}
	if(strcmp(C_DATA[playerid][c_number],"None",true))
	{
		global_string = "";
		format(global_string, 120, "UPDATE `ownable_numbers` SET is_used = 0 WHERE number = '%s'",C_DATA[playerid][c_number]);
		mysql_tquery(dbHandle, global_string,"", "");
	}
	
	new fletter[5], sletter[5], tletter[5], rnumber[10], cnumber[15], figures[10], labelcar[65], string[80];
	GetPVarString(playerid, "FirstLetter", fletter, sizeof fletter);
	GetPVarString(playerid, "SecondLetter", sletter, sizeof sletter);
	GetPVarString(playerid, "ThirdLetter", tletter, sizeof tletter);
	GetPVarString(playerid, "Region", rnumber, sizeof rnumber);
	GetPVarString(playerid, "ColorNumber", cnumber, sizeof cnumber);
	GetPVarString(playerid, "figures", figures, sizeof figures);
	
	format(labelcar, 64, "%s%s%s%s %s| %sRUS", fletter, figures, sletter, tletter, cnumber, rnumber);
	format(string, sizeof string, "{78A94D}%s", labelcar);

	strmid(C_DATA[playerid][c_number], labelcar, 0, strlen(labelcar), 150);

	MysqlUpdatePlayerInt(playerid,"credits",PI[playerid][pFolgersCoins]-150);
	PI[playerid][pFolgersCoins] -= 150;
	SendClientMessage(playerid, COLOR_YELLOW, ""cDA"Вы успешно приобрели новый номер для автомобиля!");

	DeletePVar(playerid, "FirstLetter"); DeletePVar(playerid, "SecondLetter"); DeletePVar(playerid, "ThirdLetter");
	DeletePVar(playerid, "Region"); DeletePVar(playerid, "ColorNumber"); DeletePVar(playerid, "figures");

	if(VehicleLabel[PI[playerid][PlayerCarID]] != Text3D:INVALID_3DTEXT_ID) UpdateVehicleLabel(PI[playerid][PlayerCarID], 0xFFFFFFFF, string);
	
	SetPlayerCarNumber(playerid);
	
	SavePlayerCar(playerid);
	return 1;
}

 

 

 

 

 

 

Изменено 29 мая, 2019 пользователем PING-WIN