addsop

[Troy Lewis]

Всем привет! У меня в моде есть команда '/addhouse', когда я создаю дом, то почему-то сам дом не записывается в базу данных. Есть команда '/addshop', но при создании бизнес записывается в БД, а дома нет.

/addhouse:

CMD:addhouse(playerid, params[])
{
    if(User[playerid][pAdmin] < 8 || !GetPVarInt(playerid, "Dostup")) return true;
	if(sscanf(params, "dd",params[0],params[1]))
	{
		SendClientMessage(playerid, COLOR_WHITE, "Введите: /addhouse [класс] [цена]");
		SendClientMessage(playerid,-1,"0 - [Трейлер] | 1 - [D] | 2 - [C] | 3 - [B] | 4 - [A]");
		return true;
	}
	new Float: posX, Float: posY, Float: posZ;
	GetPlayerPos(playerid, posX, posY, posZ);
	static const fmt_query[] = "INSERT INTO `house` (`hEntrancex`, `hEntrancey`,`hEntrancez`, `hLock`,`hKlass`) VALUES ('%f', '%f', '%f', '1','%i')";
	new query[sizeof(fmt_query)+(-2+8)+(-2+8)+(-2+8)+(-2+1)];
	mysql_format(dbHandle, query, sizeof(query), fmt_query,posX,posY,posZ,params[0]);
	mysql_tquery(dbHandle, query, "", "");
	TotalHouse++;
	HouseInfo[TotalHouse][hID] = TotalHouse;
	HouseInfo[TotalHouse][hEntrancex] = posX;
	HouseInfo[TotalHouse][hEntrancey] = posY;
	HouseInfo[TotalHouse][hEntrancez] = posZ;
	HouseInfo[TotalHouse][hLock] = 1;
	HouseInfo[TotalHouse][hKlass] = params[0];
	HouseInfo[TotalHouse][hValue] = params[1];
	HouseInfo[TotalHouse][hWorld] = TotalHouse;
	if(HouseInfo[TotalHouse][hKlass] == 0)
	{
		HouseInfo[TotalHouse][hInt] = 10;
		HouseInfo[TotalHouse][hExitx] = -1112.1641;
		HouseInfo[TotalHouse][hExity] = 22.7571;
		HouseInfo[TotalHouse][hExitz] = 1401.6219;
	}
	else if(HouseInfo[TotalHouse][hKlass] == 1)
	{
		HouseInfo[TotalHouse][hInt] = 6;
		HouseInfo[TotalHouse][hExitx] = -68.8618;
		HouseInfo[TotalHouse][hExity] = 1352.2183;
		HouseInfo[TotalHouse][hExitz] = 1080.2109;
	}
	else if(HouseInfo[TotalHouse][hKlass] == 2)
	{
		HouseInfo[TotalHouse][hInt] = 5;
		HouseInfo[TotalHouse][hExitx] = 22.7405;
		HouseInfo[TotalHouse][hExity] = 1404.3799;
		HouseInfo[TotalHouse][hExitz] = 1084.4297;
	}
	else if(HouseInfo[TotalHouse][hKlass] == 3)
	{
		HouseInfo[TotalHouse][hInt] = 12;
		HouseInfo[TotalHouse][hExitx] = 2324.3367;
		HouseInfo[TotalHouse][hExity] = -1148.6296;
		HouseInfo[TotalHouse][hExitz] = 1050.7101;
	}
	else
	{
		HouseInfo[TotalHouse][hInt] = 5;
		HouseInfo[TotalHouse][hExitx] = 140.2206;
		HouseInfo[TotalHouse][hExity] = 1367.2734;
		HouseInfo[TotalHouse][hExitz] = 1083.8612;
	}
	HouseInfo[TotalHouse][hPickup] = CreateDynamicPickup(1273, 23, HouseInfo[TotalHouse][hEntrancex], HouseInfo[TotalHouse][hEntrancey], HouseInfo[TotalHouse][hEntrancez],-1);
	HouseInfo[TotalHouse][hMIcon] = CreateDynamicMapIcon(HouseInfo[TotalHouse][hEntrancex], HouseInfo[TotalHouse][hEntrancey], HouseInfo[TotalHouse][hEntrancez], 31, COLOR_WHITE, 0, -1, -1);
	SendClientMessage(playerid,COLOR_WHITE,"Вы создали дом. Используйте /sethousecarpos (Указать позицию авто)");
	BuyHouse(TotalHouse);
	return true;
}

/addshop:

CMD:addshop(playerid, params[])
{
    if(User[playerid][pAdmin] < 6 || !GetPVarInt(playerid, "Dostup")) return true;
	if(sscanf(params, "ds[64]",params[0],params[1])) return SendClientMessage(playerid, COLOR_WHITE, "Введите: /addshop [цена] [название]");
	new Float: posX, Float: posY, Float: posZ;
	GetPlayerPos(playerid, posX, posY, posZ);
	mysql_format(dbHandle,QUERY,256, "INSERT INTO `bizz` (`bEntranceX`, `bEntranceY`,`bEntranceZ`, `bLocked`,`bMafia`) VALUES ('%f', '%f', '%f', '1','0')",posX,posY,posZ);
	mysql_tquery(dbHandle,QUERY,"","");
	TotalBizz++;
	BizzInfo[TotalBizz][bID] = TotalBizz;
	BizzInfo[TotalBizz][bVirtualWorld] = TotalBizz;
	BizzInfo[TotalBizz][bEntranceX] = posX;
	BizzInfo[TotalBizz][bEntranceY] = posY;
	BizzInfo[TotalBizz][bEntranceZ] = posZ;
	BizzInfo[TotalBizz][bLocked] = 1;
	BizzInfo[TotalBizz][bBuyPrice] = params[0];
	BizzInfo[TotalBizz][bType] = 3;
	BizzInfo[TotalBizz][bInterior] = 6;
	BizzInfo[TotalBizz][bExitX] = -2240.4685;
	BizzInfo[TotalBizz][bExitY] = 137.0604;
	BizzInfo[TotalBizz][bExitZ] = 1035.4140;
	BizzInfo[TotalBizz][bBarX] = -2236.1130;
	BizzInfo[TotalBizz][bBarY] = 130.1580;
	BizzInfo[TotalBizz][bBarZ] = 1035.4141;
	BizzInfo[TotalBizz][bPrice] = 0;
	strmid(BizzInfo[TotalBizz][bMessage],params[1], 0, strlen(params[1]), 64);
	strmid(BizzInfo[TotalBizz][bNameStavka],"-", 0, strlen("-"), 64);
	BizzInfo[TotalBizz][bEnterPic] = CreateDynamicPickup(1318, 23, BizzInfo[TotalBizz][bEntranceX], BizzInfo[TotalBizz][bEntranceY], BizzInfo[TotalBizz][bEntranceZ],-1);
	BizzInfo[TotalBizz][bExitPic] = CreateDynamicPickup(1318, 23, BizzInfo[TotalBizz][bExitX], BizzInfo[TotalBizz][bExitY], BizzInfo[TotalBizz][bExitZ],BizzInfo[TotalBizz][bVirtualWorld]);
	PickupX[playerid] = BizzInfo[TotalBizz][bEntranceX], PickupY[playerid] = BizzInfo[TotalBizz][bEntranceY];
	oldpickup[playerid] = BizzInfo[TotalBizz][bEnterPic];
	timepickup[playerid] = 3;
	format(YCMDstr, sizeof(YCMDstr), "{76A44B}Бизнес: {FEE600}""%s""\n{76A44B}Продаётся", BizzInfo[TotalBizz][bMessage], BizzInfo[TotalBizz][bBuyPrice]);
	BizzInfo[TotalBizz][bLabel] = CreateDynamic3DTextLabel(YCMDstr, COLOR_GREEN,BizzInfo[TotalBizz][bEntranceX], BizzInfo[TotalBizz][bEntranceY], BizzInfo[TotalBizz][bEntranceZ],20.0);
	SendClientMessage(playerid,COLOR_WHITE,"Вы создали 24-7..");
	return true;
}