По создании дома.

[igor_chupin]

Вот например в NextGo я перевел все на mysql и столкнулся с такой проблемой, при создании дома у меня не идет запись на mysql.
Код создания дома

if(strcmp(cmd, "/addhouse", true) == 0)
	{
		if (Player[playerid][pAdmin] !=9) return send(playerid,COLOR_RED,UnAdminMes);
		if(AdminDuty[playerid] == 0 && Player[playerid][pAdmin] != 9) return send(playerid, 0xff0000ff, UnAdminDuty);
		new level,Float:XX,Float:YY,Float:ZZ,int,class[64];
		if(HouseInfo[params[0]][hClass] == 1) class = "Бомж класс";
		if(HouseInfo[params[0]][hClass] == 2) class = "Эконом класс";
		if(HouseInfo[params[0]][hClass] == 3) class = "Стандарт класс";
		if(HouseInfo[params[0]][hClass] == 4) class = "Премиум класс";
		if(HouseInfo[params[0]][hClass] == 5) class = "VIP класс";
		if(HouseInfo[params[0]][hClass] == 6) class = "Элита класс";
		if(HouseInfo[params[0]][hClass] == 7) class = "Донат класс";
		if(sscanf(params, "d", params[0])) return send(playerid, COLOR_LIGHTBLUE, "[КОМАНДЫ]{FFFFFF} /addhouse [Класс]");
		if(params[0] > 6 || params[0] < 1) return send(playerid,COLOR_RED,""vError"Используй значеие от 1 до 7!");
		if(params[0] == 1)
		{
			level = 1;
			XX = 243.7219;
			YY = 304.7986;
			ZZ = 999.1484;
			int = 1;
		}
		if(params[0] == 2)
		{
			level = 3;
			XX = 266.8805;
			YY = 304.8064;
			ZZ = 998.6119;
			int = 2;
		}
		if(params[0] == 3)
		{
			level = 5;
			XX = 2365.2104492188;
			YY = -1135.6337890625;
			ZZ = 1050.8825683594;
			int = 8;
		}
		if(params[0] == 4)
		{
			level = 7;
			XX = 2317.7861328125;
			YY = -1026.9718017578;
			ZZ = 1050.2177734375;
			int = 9;
		}
		if(params[0] == 5)
		{
			level = 10;
			XX = 2237.5236816406;
			YY = -1081.6125488281;
			ZZ = 1049.0234375;
			int = 2;
		}
		if(params[0] == 6)
		{
			level = 12;
			XX = 235.4220;
			YY = 1187.3510;
			ZZ = 1080.2578;
			int = 3;
		}
		new Float:X,Float:Y,Float:Z;
		GetPlayerPos(playerid,X,Y,Z);
		HOME += 1;
		HouseInfo[HOME][hEnterX] = X;
		HouseInfo[HOME][hEnterY] = Y;
		HouseInfo[HOME][hEnterZ] = Z;
		HouseInfo[HOME][hLvl] = level;
		HouseInfo[HOME][hPrice] = HouseInfo[HOME][hLvl]*100000;
		HouseInfo[HOME][hMats] = 0;
		HouseInfo[HOME][hDrugs] = 0;
		HouseInfo[HOME][hHel] = 0;
		HouseInfo[HOME][hArm] = 0;
		HouseInfo[HOME][hOwned] = 0;
		HouseInfo[HOME][hID] = HOME;
		HouseInfo[HOME][hOwner][0] = 0;
		HouseInfo[HOME][hExitX] = XX;
		HouseInfo[HOME][hExitY] = YY;
		HouseInfo[HOME][hExitZ] = ZZ;
		HouseInfo[HOME][hInt] = int;
		HouseInfo[HOME][hLock] = 0;
		HouseInfo[HOME][hClass] = params[0];
		strmid(HouseInfo[HOME][hOwner], "The State", 0, strlen("The State"), 255);
		new text[600],query[1028];
		format(query, sizeof(query), "INSERT INTO `house` (`EnterX`, `EnterY`, `EnterZ`, `ExitX`, `ExitY`, `ExitZ`, `Int`, `Owned`, `Owner`, `Price`, `Lock`, `Lvl`, `Mats`, `Drugs`, `Hel`, `Arm`, `Class`)\
		VALUE ('%f', '%f', '%f', '%f', '%f', '%f', '%i', '0', 'The State', '%i', '0', '%i', '0', '0', '0', '0', '%i')", X, Y, Z, XX, YY, ZZ,int,HouseInfo[HOME][hLvl]*100000,level,params[0]);
		mysql_query(query);
		f(text,"{33ccff}[{ffff00}Дом{33ccff}]{46E9FF}\nАдрес: {FFFF00} %d{46E9FF}\nЦена: {FFFF00}%d{33aa33}${46E9FF}\n Класс дома: {7CFC00}%s{FFFF00}\n{46E9FF}Уровень дома: {7CFC00}%d{FFFF00}",HouseInfo[HOME][hID],HouseInfo[HOME][hPrice],class,HouseInfo[HOME][hLvl]);
		HouseInfo[HOME][hLabel] = Create3DTextLabel(string,COLOR_GREEN,HouseInfo[HOME][hEnterX], HouseInfo[HOME][hEnterY], HouseInfo[HOME][hEnterZ]+1.2,15.0,0);
		HouseInfo[idx][hMIcon] = CreateDynamicMapIcon(HouseInfo[idx][hEnterX], HouseInfo[idx][hEnterY], HouseInfo[idx][hEnterZ], 31, COLOR_WHITE, 0, -1, -1, 400.0);
		HouseInfo[HOME][hPickup] = CreateDynamicPickup(1273, 23, HouseInfo[HOME][hEnterX], HouseInfo[HOME][hEnterY], HouseInfo[HOME][hEnterZ],-1);
		SaveHouses();
		SaveStuff();
		UpdateHouse(HOME);
		f(string,"Создан дом ID:[%d] Price:[%d] LvL:[%d]",HouseInfo[HOME][hID],HouseInfo[HOME][hPrice],HouseInfo[HOME][hLvl]);
		return	send(playerid, COLOR_WHITE, string);
	}

Теперь Sql база данных.

CREATE TABLE `house` (
  `ID` int(4) NOT NULL auto_increment,
  `EnterX` float NOT NULL,
  `EnterY` float NOT NULL,
  `EnterZ` float NOT NULL,
  `ExitX` float NOT NULL,
  `ExitY` float NOT NULL,
  `ExitZ` float NOT NULL,
  `Int` int(3) NOT NULL,
  `Owned` int(2) NOT NULL default '0',
  `Owner` varchar(25) collate cp1251_bin NOT NULL default 'The State',
  `Price` int(10) NOT NULL,
  `Lock` int(2) NOT NULL default '1',
  `Lvl` int(3) NOT NULL default '0',
  `Mats` int(10) NOT NULL default '0',
  `Drugs` int(10) NOT NULL default '0',
  `Heal` int(2) NOT NULL default '0',
  `Arm` int(2) NOT NULL default '0',
  `Class` int(2) NOT NULL,
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 COLLATE=cp1251_bin AUTO_INCREMENT=351 ;

За правильный код я вам скину 20 рублей на wm, и дам 5 +. Заранее спасибо.