super Arbeit die du da geleistet hast !
von wo werden die Bizz Daten bezogen im script sehe ich das er es aus der DB auslesen will.
Jedoch ist in der DB keine Tabelle namens Bizz mitgefeiert worden.
die Rede ist von 'Bizz' nicht 'sBizz'
denn leider hat sich der Motorradhelm laden verirrt...
wer suchet der findet
CREATE TABLE IF NOT EXISTS `bizz` (
`bid` int(11) NOT NULL AUTO_INCREMENT,
`id` int(2) NOT NULL,
`bowned` int(2) NOT NULL,
`bowner` varchar(28) NOT NULL,
`bmessage` varchar(28) NOT NULL,
`bextortion` varchar(28) NOT NULL,
`bentrancex` varchar(50) NOT NULL,
`bentrancey` varchar(50) NOT NULL,
`bentrancez` varchar(50) NOT NULL,
`bexitx` varchar(50) NOT NULL,
`bexity` varchar(50) NOT NULL,
`bexitz` varchar(50) NOT NULL,
`bexitr` varchar(50) NOT NULL,
`blevelneeded` int(11) NOT NULL,
`bbuyprice` int(11) NOT NULL,
`bentrancecost` int(11) NOT NULL,
`btill` int(11) NOT NULL,
`blocked` int(11) NOT NULL,
`binterior` int(11) NOT NULL,
`bproducts` int(11) NOT NULL,
`bmaxproducts` int(11) NOT NULL,
`bpriceprod` int(11) NOT NULL,
`bdate` int(11) NOT NULL,
PRIMARY KEY (`bid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
--
-- Daten für Tabelle `bizz`
--
INSERT INTO `bizz` (`bid`, `id`, `bowned`, `bowner`, `bmessage`, `bextortion`, `bentrancex`, `bentrancey`, `bentrancez`, `bexitx`, `bexity`, `bexitz`, `bexitr`, `blevelneeded`, `bbuyprice`, `bentrancecost`, `btill`, `blocked`, `binterior`, `bproducts`, `bmaxproducts`, `bpriceprod`, `bdate`) VALUES
(1, 0, 0, 'Zu Verkaufen', 'TriadenTanke', 'Niemand', '1368.000000', '-1279.000000', '13.000000', '296.000000', '-108.000000', '1001.000000', '0.000000', 4, 500000, 150, 0, 0, 6, 236, 500, 6, 195),
(2, 1, 0, 'Zu Verkaufen', 'Ghost_Waffenladen', 'Niemand', '-2288.000000', '-79.000000', '35.000000', '314.000000', '-141.000000', '999.000000', '0.000000', 5, 300000, 150, 0, 0, 7, 400, 500, 50, 0),
(3, 2, 0, 'Zu Verkaufen', 'HardRockCafé', 'Niemand', '1498.000000', '-1583.000000', '13.000000', '-794.000000', '490.000000', '1376.000000', '0.000000', 5, 200000, 150, 0, 0, 1, 500, 500, 1, 199),
(4, 3, 0, 'Zu Verkaufen', 'Yakuza Gunshop', 'Niemand', '2177.000000', '961.000000', '10.000000', '316.000000', '-167.000000', '999.000000', '0.000000', 3, 200000, 50, 0, 0, 6, 484, 500, 100, 183),
(5, 4, 0, 'Zu Verkaufen', 'Rockys-Casino', 'Niemand', '1731.000000', '-1180.000000', '23.000000', '1133.000000', '-15.000000', '1000.000000', '0.000000', 3, 200000, 0, 0, 0, 12, 471, 500, 10, 68),
(6, 5, 0, 'Zu Verkaufen', 'Sex Shop 1', 'Niemand', '1940.000000', '-2115.000000', '13.000000', '-103.000000', '-24.000000', '1000.000000', '0.000000', 5, 200000, 100, 0, 0, 3, 500, 500, 1, 67),
(7, 6, 0, 'Zu Verkaufen', 'Sex Shop 2', 'Niemand', '1087.000000', '-922.000000', '43.000000', '-103.000000', '-24.000000', '1000.000000', '0.000000', 5, 200000, 150, 0, 0, 3, 483, 500, 1, 184),
(8, 7, 0, 'Zu Verkaufen', 'Beach PNS', 'Niemand', '488.872802', '-1730.095214', '11.577300', '487.733001', '-1739.099365', '11.506400', '172.948501', 5, 200000, 100, 0, 0, 3, 500, 500, 1, 190),
(9, 8, 0, 'Zu Verkaufen', '-> Ballas PNS <-', 'Niemand', '1024.935424', '-1035.510498', '32.027099', '1025.035644', '-1024.955810', '32.472900', '359.138793', 5, 200000, 100, 0, 0, 3, 500, 500, 10, 89),
(10, 9, 0, 'Zu Verkaufen', 'Mara Salvatrucha PNS ', 'Niemand', '2075.000000', '-1831.000000', '13.000000', '2066.843017', '-1831.395996', '13.918190', '89.470802', 5, 200000, 150, 0, 0, 3, 500, 500, 1, 195),
(11, 10, 0, 'Zu Verkaufen', 'Los Santos HelmShop', 'Niemand', '461.000000', '-1500.000000', '31.000000', '226.000000', '-7.000000', '1002.000000', '0.000000', 5, 200000, 100, 0, 0, 5, 255, 500, 1, 197);
-- --------------------------------------------------------