Ошибка запроса.

[chevacheva]

Приветствую, форумчане. Ошибка запроса мускул в системе домов.

Спойлер

format(query,sizeof(query),"INSERT INTO `houses` (`hEnterX`,`hEnterY`,`hEnterZ`,`hExitX`,`hExitY`,`hExitZ`,`hPrice`,`hInt`,`hClass`)\
			 VALUES ('%f','%f','%f','%f','%f','%f','%i','%i','%i')",
        hEnterX,hEnterY,hEnterZ,ExitX,ExitY,ExitZ,params[1],Interior,params[0]);

Спойлер

Ошибка в mysql:ID 1064 | Ошибка: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''0.0' at line 1 | Функция:  | Запрос: INSERT INTO `houses` (`hEnterX`,`hEnterY`,`hEnterZ`,`hExitX`,`hExitY`,`hExitZ`,`hPrice`,`hInt`,`hClass`)VALUES ('0.000000','0.0 |

Спойлер

CREATE TABLE IF NOT EXISTS `houses` (
  `hID` int(11) NOT NULL,
  `hOwned` varchar(32) NOT NULL,
  `hOwner` varchar(28) NOT NULL,
  `hEnterX` float NOT NULL,
  `hEnterY` float NOT NULL,
  `hEnterZ` float NOT NULL,
  `hExitX` float NOT NULL,
  `hExitY` float NOT NULL,
  `hExitZ` float NOT NULL,
  `hLevel` int(11) NOT NULL,
  `hPrice` int(11) NOT NULL,
  `hLock` int(11) NOT NULL,
  `hTakings` int(11) NOT NULL,
  `hInt` int(11) NOT NULL,
  `hHel` int(11) NOT NULL,
  `hClass` int(11) NOT NULL,
  `hIconID` int(11) NOT NULL,
  `hPickupID` int(11) NOT NULL,
  `Text3D:hTextID` varchar(10) NOT NULL
) ENGINE=InnoDB;