I want to create a house
#4

Код:
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)
Just use that string, run it as a query in the database, the keys and values are matching pairs, so for example:
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)
Reply


Messages In This Thread
I want to create a house - by Sn4ke2 - 30.06.2015, 09:13
Re: I want to create a house - by Suicidal.Banana - 30.06.2015, 09:31
Re: I want to create a house - by Sn4ke2 - 30.06.2015, 10:10
Re: I want to create a house - by Suicidal.Banana - 30.06.2015, 10:29
Re: I want to create a house - by Sn4ke2 - 30.06.2015, 10:37
Re: I want to create a house - by xRoy - 30.06.2015, 10:44
Re: I want to create a house - by Sn4ke2 - 30.06.2015, 10:57
Re: I want to create a house - by Suicidal.Banana - 30.06.2015, 11:28
Re: I want to create a house - by Sn4ke2 - 30.06.2015, 11:47
Re: I want to create a house - by Sn4ke2 - 30.06.2015, 12:03

Forum Jump:


Users browsing this thread: 1 Guest(s)