30.06.2015, 10:29
Код:
INSERT INTO `houses` (`ID`, `Entrancex`, `Entrancey`, `Entrancez`, `Exitx`, `Exity`, `Exitz`, `Owner`, `Discription`, `Value`, `Hel`, `Arm`, `Interior`, `Lockk`, `Owned`, `Rent`, `Rentabil`, `Takings`, `Level`, `Virtual`) VALUES (1, 1421.85, -885.64, 50.6647, 225.94, 1022.69, 1084.01, 'The State', '>>>> <<<<<', 5000000, 0, 0, 7, 0, 0, 1, 0, 15, 5, 0)
ID = 1
Entrancex = 1421.85
Entrancey = -885.64
etc etc
That said, theres some things to take into account:
- You prolly already have a house with ID 1, so instead, omit ID, and it should auto_increment it (assuming its a properlly set up database table)
- "Discription" seems like a typo, it should prolly be "Description"
- "Lockk" should prolly be "Lock"
Try this:
Код:
INSERT INTO `houses` (`Entrancex`, `Entrancey`, `Entrancez`, `Exitx`, `Exity`, `Exitz`, `Owner`, `Description`, `Value`, `Hel`, `Arm`, `Interior`, `Lock`, `Owned`, `Rent`, `Rentabil`, `Takings`, `Level`, `Virtual`) VALUES (1421.85, -885.64, 50.6647, 225.94, 1022.69, 1084.01, 'The State', '>>>> <<<<<', 5000000, 0, 0, 7, 0, 0, 1, 0, 15, 5, 0)