D1mka5592
Умник
Здравствуйте форумчане, хотелось бы узнать! Что не правильно?
Выдаёт
PHP:
CREATE TABLE IF NOT EXISTS `busines` (
`owned` int(4) NOT NULL,
`owner` varchar(24) COLLATE cp1251_bin NOT NULL DEFAULT 'The State',
`message` varchar(32) NOT NULL,
`extortion` int(32) NOT NULL,
`entrancex` float NOT NULL,
`entrancey` float NOT NULL,
`entrancez` float NOT NULL,
`exitx` float NOT NULL,
`exity` float NOT NULL,
`exitz` float NOT NULL,
`levelneeded` int(11) NOT NULL,
`buyprice` int(11) NOT NULL,
`entrancecost` int(11) NOT NULL,
`till` int(11) NOT NULL,
`locked` enum('0','1') NOT NULL,
`interior` int(11) NOT NULL,
`products` int(11) NOT NULL,
`maxproducts` int(11) NOT NULL,
`priceprod` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_bin;
INSERT INTO `busines`(`owned`, `owner`, `message`, `extortion`, `entrancex`, `entrancey`, `entrancez`, `exitx`, `exity`, `exitz`, `levelneeded`, `buyprice`, `entrancecost`, `till`, `locked`, `interior`, `products`, `maxproducts`, `priceprod`) VALUES
(0, The State, ~w~Gun Shop 1, No-one, 1791.212036, -1164.631713, 23.828100, 2170.278076, 1618.818237, 999.976623, 5, 5000000, 0, 0, 1, 1, 99, 500, 100),
(0, The State, ~w~Gun Shop 2, No-one, -2288.067626, -79.334396, 35.320301, 459.679107, -88.644302, 999.554687, 5, 5000000, 0, 0, 1, 4, 97, 500, 100),
(0, The State, ~w~Restaurant, No-one, 1498.360107, -1583.031860, 13.546895, -794.936218, 490.632385, 1376.195312, 5, 5000000, 0, 0, 1, 1, 100, 500, 100),
(0, The State, ~w~Police Armoury, No-one, 1568.625122, -1690.535766, 5.890600, 246.376007, 109.246002, 1003.218811, 5, 5000000, 0, 0, 1, 10, 500, 500, 100),
(1, Eugen_McLuhan, ~w~City Bank, No-one, 1462.395751, -1012.391174, 26.843799, 2305.688964, -16.088100, 26.749599, 5, 5000000, 0, 0, 1, 0, 99998, 100000, 1);
Код:
#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, The State, ~w~Gun Shop 1, No-one, 1791.212036, -1164.631713, 23.828100, 2170' at line 2
