GTAONLINE.PL :: lss-domt xyzzyrp

Witaj

mam straszny problem na gamemodzie xyzzyrp. Chodzi dok?adniej o to, ?e nie da si? kupi? dom?w. W bazie danych jest wszystko napisane DOK?ADNIE CO I JAK. I nie wiem co za to odpowiada. lss-domy w??czone DB jak i DB2 pod??czone. Wszystko robi?em zgodnie a na serwerze nadal nie ma dom?w, kt?re mo?na kupi? .

Na dole jest to co jest w tabeli.

Cytat:

CREATE TABLE `lss_domy` (
`id` int(10) UNSIGNED NOT NULL,
`descr` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
`i` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'interior w ktorym jest wejscie i wyjscie z domu',
`vwe` int(11) NOT NULL DEFAULT '0' COMMENT 'vw wejscia (prawie zawsze 0)',
`vwi` int(11) DEFAULT NULL COMMENT 'VW wnetrza (nadawane automatycznie, tu mozna wymusic)',
`drzwi` varchar(32) CHARACTER SET ascii NOT NULL COMMENT 'x,y,z miejsce w ktorym bedzie pickup wchodzenia',
`punkt_wyjscia` varchar(64) NOT NULL COMMENT 'x,y,z,[rz] miejsce gdzie przeniesie po wyjsciu',
`interiorid` int(10) UNSIGNED DEFAULT NULL COMMENT 'numer wnetrza z tablicy pbp_interiory',
`ownerid` int(10) UNSIGNED DEFAULT NULL COMMENT 'numer wlasciciela z tablicy players',
`zamkniety` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0=zawsze otwarty',
`koszt` smallint(5) UNSIGNED NOT NULL DEFAULT '100',
`paidTo` date DEFAULT NULL,
`updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'uzywane do wykrywania zaktualizowanych przez panel domow',
`active` tinyint(3) UNSIGNED NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Zrzut danych tabeli `lss_domy`
--

INSERT INTO `lss_domy` (`id`, `descr`, `i`, `vwe`, `vwi`, `drzwi`, `punkt_wyjscia`, `interiorid`, `ownerid`, `zamkniety`, `koszt`, `paidTo`, `updated`, `active`) VALUES
(1, 'Dom pietrowy', 0, 0, 1001, '2486.2,-1644.5,14.18', '2486.57,-1649.31,13.48,183', 35, NULL, 1, 3500, NULL, '2017-08-21 10:07:09', 1),
(2, 'Dom jednopokojowy', 0, 0, 1002, '2498.38,-1642.26,14.11', '2498.05,-1646.31,13.54,171', 35, NULL, 1, 2000, NULL, '2013-08-06 21:18:29', 1),
(3, 'Dom jednorodzinny', 0, 0, 1003, '2513.73,-1650.26,14.36', '2509.79,-1653.42,13.69,138', 15, NULL, 1, 2500, NULL, '2013-06-23 16:50:47', 1),
(7, 'Rezydencja', 0, 0, 1007, '1122.71,-2037.05,69.89', '1126.84,-2036.97,69.88, 270', 50, 9, 0, 20000, '2017-09-04', '2017-08-21 14:54:42', 1),
(1132, 'Dom jednorodzinny', 0, 0, 1132, '2018.24,-1703.30,14.23', '2018.24,-1703.30,14.23, 270', 6, NULL, 0, 3800, NULL, '2013-03-17 23:08:22', 1),
(1122, 'Melina', 0, 0, NULL, '2465.31,-2020.79,14.12', '2465.48,-2018.88,13.55,357.5', 5, NULL, 0, 3000, NULL, '2013-02-02 23:08:06', 1),
(1123, 'Melina', 0, 0, NULL, '2483.36,-1995.34,13.83', '2483.37,-1996.68,13.83,180.4', 15, NULL, 1, 2700, NULL, '2013-07-28 17:10:40', 1),
(1124, 'Skromne mieszkanie', 0, 0, 1124, '2507.74,-2021.05,14.21', '2508.02,-2019.10,13.55,358.7', 21, NULL, 1, 2600, NULL, '2013-08-08 08:42:01', 1),
(8, 'Ekstrawagancki domek', 0, 0, 1008, '1093.97,-807.13,107.42', '1093.52,-803.79,107.42,8.5', 27, NULL, 1, 4500, NULL, '2017-08-21 10:07:09', 1),
(9, 'Dom jednopokojowy', 0, 0, 1009, '2514.32, -1691.62, 14.05', ' 2513.02, -1690.20, 13.54, 48', 4, NULL, 1, 2000, NULL, '2013-06-08 00:37:09', 1),
(10, 'Dom pietrowy', 0, 0, 1010, '2495.39, -1691.14, 14.77', '2495.31, -1687.91, 13.52, 0', 7, NULL, 1, 3500, NULL, '2013-07-28 17:10:40', 1),
(11, 'Dom jednorodzinny', 0, 0, 1011, '2459.47, -1691.66, 13.55', '2459.50, -1689.46, 13.54, 0', 5, NULL, 1, 2500, NULL, '2013-08-06 21:18:29', 1),
(12, 'Dom na plazy', 0, 0, 1012, '315.89, -1769.43, 4.62', '315.94, -1771.31, 4.69, 180', 35, NULL, 1, 3000, NULL, '2017-08-21 10:07:09', 1),
(13, 'Dom jednorodzinny', 0, 0, 1013, '254.40, -1367.16, 53.11', '255.71, -1366.24, 53.11, 306', 35, NULL, 0, 2500, NULL, '2017-08-21 10:07:09', 1),
(14, 'Dom jednorodzinny', 0, 0, 1014, '693.76, -1645.83, 4.09', '696.33, -1645.95, 3.57, 270', 35, NULL, 0, 2500, NULL, '2013-08-06 21:18:29', 1),
(15, 'Dom jednopokojowy', 0, 0, 1015, '1804.16, -2124.90, 13.94', '1804.00, -2122.83, 13.55, 0', 36, NULL, 1, 2000, NULL, '2013-04-08 22:06:09', 1),
(16, 'Dom jednorodzinny', 0, 0, 1016, '2000.03, -1114.05, 27.12', '2000.06, -1116.35, 26.81, 180', 37, NULL, 0, 2700, NULL, '2017-08-21 10:07:09', 1),
(17, 'Dom pietrowy', 0, 0, 1017, '2842.12, -1334.79, 14.74', ' 2848.33, -1334.29, 11.09, 270', 35, NULL, 1, 2500, NULL, '2013-03-28 23:06:50', 1),
(18, 'Dom pietrowy', 0, 0, 1018, '2207.44, -1100.47, 31.55', '2204.31, -1103.38, 29.11, 151', 35, NULL, 0, 2300, NULL, '2013-01-24 23:05:24', 1),
(38, 'Willa na skarpie', 0, 0, 1038, '1332.12, -633.50, 109.13', '1331.20, -630.84, 109.13, 0', 14, NULL, 0, 3500, NULL, '2017-08-21 10:07:09', 1),
(39, 'Apartament u Gigolo', 0, 0, 1039, '1497.00, -687.89, 95.56', '1496.98, -689.53, 94.94, 180', 27, 8, 1, 5000, '2017-08-29', '2017-08-21 14:59:50', 1),
(52, 'Dom jednorodzinny', 0, 0, 1052, '2851.85, -1365.98, 14.17', ' 2857.23, -1366.00, 12.47, 270', 36, NULL, 0, 3000, NULL, '2012-12-11 23:08:04', 1),
(53, 'Dom pietrowy', 0, 0, 1053, '2808.02, -1190.89, 25.34', '2808.04, -1189.20, 25.35, 0', 36, NULL, 0, 3500, NULL, '2013-08-06 21:18:29', 1),
(54, 'Dom pietrowy', 0, 0, 1054, '2808.04, -1175.91, 25.38', '2808.04, -1177.79, 25.37, 180', 36, NULL, 0, 3200, NULL, '2013-08-06 21:18:29', 1),
(55, 'Apartament BOSS\'a', 0, 0, 1055, '691.58, -1275.91, 13.56', '689.78, -1275.94, 13.56, 90', 27, NULL, 1, 5000, NULL, '2017-08-21 10:07:09', 1),
(56, 'Mieszkanie osiedlowe', 0, 0, 1056, '846.73, -1717.28, 14.93', '848.66, -1717.30, 14.93, 270``', 15, NULL, 1, 2500, NULL, '2012-11-20 14:45:42', 1),
(57, 'Mieszkanie osiedlowe', 0, 0, 1057, '850.67, -1686.17, 14.94', '852.89, -1686.26, 14.95, 270', 15, NULL, 1, 2500, NULL, '2013-04-09 22:06:15', 1),
(58, 'Mieszkanie osiedlowe', 0, 0, 1058, '865.27, -1633.85, 14.93', '865.35, -1635.80, 14.93, 180', 15, NULL, 1, 2500, NULL, '2012-11-21 23:01:32', 1),
(59, 'Mieszkanie osiedlowe', 0, 0, 1059, '936.83, -1612.71, 14.94', '937.01, -1614.84, 14.95, 180', 36, NULL, 0, 2500, NULL, '2013-03-06 23:06:12', 1),
(60, 'Mieszkanie osiedlowe', 0, 0, 1060, '965.11, -1612.61, 14.94', '965.10, -1614.81, 14.95, 180', 36, NULL, 0, 2500, NULL, '2013-03-18 23:08:25', 1),
(61, 'Mieszkanie osiedlowe', 0, 0, 1061, '987.50, -1624.53, 14.93', '985.12, -1624.60, 14.93, 90', 13, NULL, 1, 2500, NULL, '2013-07-03 19:14:26', 1),
(62, 'Mieszkanie osiedlowe', 0, 0, 1062, '987.52, -1704.31, 14.93', '984.79, -1704.47, 14.93, 90', 13, NULL, 0, 2500, NULL, '2013-04-19 22:08:22', 1),
(173, 'Dom pietrowy przy plazy', 0, 0, 1173, '263.94, -1765.46, 4.76', '264.05, -1767.38, 4.75, 180', 13, NULL, 0, 3000, NULL, '2013-04-11 22:08:59', 1),
(1133, 'Dom jednorodzinny', 0, 0, 1133, '2018.05,-1629.92,14.04', '2017.15,-1629.73,13.55, 90', 2, NULL, 1, 3300, NULL, '2013-03-10 23:07:11', 1),
(1134, 'Dom jednorodzinny', 0, 0, 1134, '2065.10,-1703.48,14.15', '2066.10,-1703.47,14.15, 270', 5, NULL, 1, 3900, NULL, '2013-07-18 17:55:02', 1),
(1135, 'Dom nad marin?', 0, 0, 1135, '692.87,-1602.77,15.05', '692.86,-1601.66,15.05,1.3', 38, NULL, 0, 4500, NULL, '2013-07-03 19:14:26', 1),
(1137, 'Skromne mieszkanie', 0, 0, NULL, '1761.25,-2125.45,14.06', '1761.13,-2124.16,13.88,5.9', 15, NULL, 1, 2700, NULL, '2013-04-17 22:08:12', 1),
(1175, 'Domek \'szafarza\'', 0, 0, 1175, '2186.54,-997.33,66.47', '2180.09,-996.63,62.92, 79', 14, NULL, 0, 6554, NULL, '2013-03-18 23:08:25', 1),
(89, 'Dom jednopokojowy', 0, 0, 1089, '160.63, -102.69, 4.90', '161.84, -102.50, 4.90, 270', 13, NULL, 0, 2500, NULL, '2013-02-20 23:00:56', 1),
(90, 'Dom jednopokojowy', 0, 0, 1090, '201.43, -94.97, 1.55', '201.41, -96.49, 1.55, 180', 5, NULL, 1, 2500, NULL, '2013-06-08 00:37:09', 1),
(91, 'Dom pustelnika', 0, 0, 1091, '870.44, -24.94, 63.98', '868.98, -27.98, 63.20, 180', 4, NULL, 0, 4000, NULL, '2013-04-09 22:06:15', 1),
(1131, 'Dom jednorodzinny', 0, 0, 1131, '2263.95,-1469.34,24.37', '2263.89,-1470.31,23.79, 180', 3, NULL, 1, 3000, NULL, '2013-01-15 23:09:12', 1),
(94, 'Dom jednorodzinny', 0, 0, 1094, '1106.54, -299.76, 74.54', '1103.80, -299.59, 73.99, 90', 13, NULL, 0, 3200, NULL, '2012-11-20 14:45:42', 1),
(1130, 'Dom jednorodzinny', 0, 0, 1130, '2247.67,-1469.34,24.48', '2247.87,-1470.12,24.03, 180', 3, NULL, 1, 2800, NULL, '2013-02-25 23:01:08', 1),
(172, 'Dom przy plazy', 0, 0, 1172, '295.35, -1764.12, 4.87', '295.31, -1765.27, 4.55, 180', 5, NULL, 0, 2500, NULL, '2013-03-06 23:06:12', 1),
(138, 'Dom zlodzieja', 0, 0, 1138, '835.97, -894.87, 68.77', '836.92, -893.48, 68.77, 325', 38, NULL, 0, 3500, NULL, '2017-08-21 10:07:09', 1),
(139, 'Dom z basenem', 0, 0, 1139, '700.30, -1060.26, 49.42', '698.35, -1059.10, 49.42, 55', 5, NULL, 0, 3000, NULL, '2013-04-01 22:06:59', 1),
(140, 'Dom w Vinewood', 0, 0, 1040, '1421.81, -886.23, 50.69', '1421.98, -884.21, 50.61, 0', 37, NULL, 1, 3000, NULL, '2017-08-21 10:07:09', 1),
(141, 'Dom przy skarpie', 0, 0, 1141, '937.86, -848.72, 93.58', '937.13, -847.04, 93.84, 27', 35, NULL, 1, 3200, NULL, '2013-04-12 22:09:01', 1),
(151, 'Apartament Czysciocha', 0, 0, 1151, '167.89, -1308.27, 70.35', '166.38, -1308.25, 70.35, 90', 14, NULL, 0, 5000, NULL, '2017-08-21 10:07:09', 1),
(1129, 'Dom jednorodzinny', 0, 0, 1129, '2232.60,-1469.34,24.58', '2232.59,-1470.31,24.06, 180', 21, NULL, 0, 3200, NULL, '2013-03-02 23:04:07', 1),
(152, 'Dom na palach', 0, 0, 1152, '1535.77, -885.30, 57.66', '1537.46, -883.70, 57.66, 315', 15, NULL, 1, 3000, NULL, '2013-07-03 19:14:26', 1),
(153, 'Dom pietrowy z garazem', 0, 0, 1153, '1112.64, -742.12, 100.13', '1110.72, -742.16, 100.13, 90', 35, NULL, 0, 3200, NULL, '2013-07-03 19:14:26', 1),
(154, 'Willa Astronauty', 0, 0, NULL, '980.47, -677.27, 121.98', '979.03,-674.45,121.98,32.3', 27, NULL, 0, 5000, NULL, '2013-08-06 21:18:29', 1),
(163, 'Dom jednorodzinny', 0, 0, 1163, '2203.11, -89.23, 28.15', '2204.56, -89.23, 28.15, 270', 15, NULL, 0, 2500, NULL, '2013-07-08 17:36:23', 1),
(1125, 'Skromne mieszkanie', 0, 0, 1125, '2016.54,-1641.66,14.11', '2014.50,-1641.50,13.78,92.1', 21, NULL, 1, 2700, NULL, '2013-07-08 17:36:23', 1),
(1121, 'Willa na wzgorzu', 0, 0, 1121, '300.12,-1154.55,81.32', '299.16,-1155.65,80.91,134.4', 27, NULL, 0, 5000, NULL, '2017-08-21 10:07:09', 1),
(1136, 'Dom na wsi', 0, 0, 1136, '2199.95,-37.36,28.15', '2201.75,-37.32,28.15, 270', 38, NULL, 0, 4000, NULL, '2013-07-08 17:36:23', 1),
(1126, 'Dom jednorodzinny', 0, 0, 1126, '2230.44,-1397.24,24.57', '2230.32,-1396.41,24.00, 0', 1, NULL, 0, 2900, NULL, '2013-03-14 23:07:21', 1),
(1127, 'Dom jednorodzinny', 0, 0, 1127, '2243.51,-1397.24,24.57', '2243.41,-1396.44,24.00, 0', 3, NULL, 1, 3100, NULL, '2013-02-25 23:01:08', 1),
(1128, 'Dom jednorodzinny', 0, 0, 1128, '2256.45,-1397.24,24.57', '2256.57,-1396.36,24.00, 0', 1, NULL, 1, 2900, NULL, '2013-04-30 19:33:08', 1),
(174, 'Dom przy plazy z basenem', 0, 0, 1174, '167.77, -1758.99, 6.80', '166.21, -1758.94, 6.80, 90', 14, NULL, 0, 2600, NULL, '2013-08-06 21:18:29', 1),
(1138, 'Rezydencja', 0, 0, NULL, '251.38,-1220.25,76.10', '252.20,-1221.37,75.59,218.3', 27, NULL, 0, 4500, NULL, '2017-08-21 10:07:09', 1),
(1139, 'Dom jednorodzinny', 0, 0, 1139, '1854.07,-1914.26,15.26', '1853.96,-1916.79,15.04, 180', 6, NULL, 0, 3400, NULL, '2013-02-21 23:00:58', 1),
(1140, 'Dom jednorodzinny', 0, 0, 1140, '1872.24,-1911.79,15.26,355.9', '1872.06,-1914.39,15.03, 180', 6, NULL, 0, 3800, NULL, '2013-03-02 23:04:07', 1),
(1141, 'Dom jednorodzinny', 0, 0, 1141, '1891.86,-1914.44,15.26,6.2', '1891.83,-1917.10,15.03, 180', 2, NULL, 1, 3200, NULL, '2013-02-15 23:07:29', 1),
(1142, 'Dom jednorodzinny', 0, 0, 1142, '1913.49,-1911.90,15.26', '1913.45,-1914.56,15.03, 180', 1, NULL, 1, 3500, NULL, '2012-11-20 14:45:42', 1),
(1143, 'Dom jednorodzinny', 0, 0, 1143, '1938.54,-1911.29,15.26', '1935.87,-1911.35,15.03, 90', 3, NULL, 1, 3000, NULL, '2013-03-02 23:04:07', 1),
(1144, 'Dom jednorodzinny', 0, 0, 1144, '2488.36,11.76,28.44', '2488.35,8.65,27.78, 180', 21, NULL, 1, 3700, NULL, '2013-03-13 23:07:19', 1),
(1145, 'Dom jednorodzinny', 0, 0, 1145, '2509.44,11.76,28.44', '2509.55,8.72,27.80, 180', 21, NULL, 0, 3600, NULL, '2013-01-31 23:08:01', 1),
(1146, 'Dom jednorodzinny', 0, 0, 1146, '2411.22,-5.59,27.68', '2410.54,-3.14,26.86, 0', 15, NULL, 0, 3500, NULL, '2013-03-01 23:01:18', 1),
(1147, 'Dom jednorodzinny', 0, 0, 1147, '2411.22,21.77,27.68', '2409.59,26.59,27.68, 0', 13, NULL, 0, 3100, NULL, '2017-08-21 10:07:09', 1),
(1148, 'Dom jednorodzinny', 0, 0, 1148, '2270.49,-7.50,28.15', '2270.29,-11.64,27.43, 180', 36, NULL, 1, 3900, NULL, '2013-07-03 19:14:26', 1),
(1149, 'Dom jednorodzinny', 0, 0, 1149, '2245.47,-1.66,28.15', '2245.50,-5.82,27.45, 180', 21, NULL, 0, 3800, NULL, '2013-03-14 23:07:21', 1),
(1151, 'Dom jednorodzinny', 0, 0, 1176, '2045.45,-1116.65,26.36', '2048.28,-1115.64,25.59, 270', NULL, NULL, 1, 2800, NULL, '2012-11-20 14:45:42', 1),
(1168, 'Melina', 0, 0, NULL, '2625.93,-1098.68,69.36,94.0', '2628.95,-1098.52,69.38,273.1', 15, NULL, 0, 2000, NULL, '2013-03-26 23:06:43', 1),
(1150, 'Dom jednorodzinny', 0, 0, 1175, '2022.88,-1120.27,26.42,0.8', '2022.81,-1121.98,26.20, 180', 6, NULL, 0, 2500, NULL, '2013-08-08 08:42:01', 1),
(1153, 'Dom jednorodzinny', 0, 0, 1153, '2323.85,191.15,28.44', '2326.96,191.18,27.78, 270', 21, NULL, 1, 3800, NULL, '2013-04-08 22:06:09', 1),
(181, 'Dom jednopokojowy', 0, 0, NULL, '142.65,-1470.37,25.21,135.1', '143.82,-1468.42,25.20,319.3', 37, NULL, 0, 3000, NULL, '2013-03-27 23:06:45', 1),
(1152, 'Dom jednorodzinny', 0, 0, 1152, '2364.00,187.19,28.44', '2360.62,187.22,27.72, 90', 21, NULL, 0, 3500, NULL, '2013-04-23 22:03:18', 1),
(1172, 'Ekskluzywny dom', 0, 0, 3138, '1527.78,-772.55,80.58', '1526.73,-773.80,80.33,138.6', 177, NULL, 1, 5000, NULL, '2017-08-21 10:07:09', 1),
(1165, 'Apartament \'Trupa\'', 0, 0, 1165, '891.21,-783.15,101.31', '889.77,-779.72,101.27, 25', 27, NULL, 1, 5000, NULL, '2017-08-21 10:07:09', 1),
(1154, 'Dom jednorodzinny', 0, 0, 1154, '2364.00,166.15,28.44', '2360.64,166.15,27.73, 90', 13, NULL, 1, 4100, NULL, '2013-04-11 22:08:59', 1),
(1155, 'Dom jednorodzinny', 0, 0, 1155, '2323.85,162.22,28.44', '2327.02,162.40,27.77, 270', 6, NULL, 1, 4000, NULL, '2013-03-14 23:07:21', 1),
(180, 'Mieszkanie', 0, 0, NULL, '2797.78,-1245.37,47.39,354.6', '2797.66,-1248.46,46.96,175.5', 37, NULL, 1, 3000, NULL, '2013-04-15 22:08:01', 1),
(179, 'Rezydencja', 0, 0, NULL, '298.85,-1338.50,53.44,209.7', '297.06,-1335.90,53.44,35.5', 27, NULL, 1, 5000, NULL, '2017-08-21 10:07:09', 1),
(182, 'Dom jednopokojowy', 0, 0, NULL, '2427.42,-1135.79,34.71,6.0', '2427.24,-1138.60,34.22,176.1', 8, NULL, 0, 2300, NULL, '2013-02-12 23:07:21', 1),
(183, 'Dom jednorodzinny', 0, 0, 1183, '1285.27,-1091.46,28.26,271.2', '1283.14,-1091.48,28.20,89.5', 38, NULL, 1, 3800, NULL, '2013-04-11 22:08:59', 1),
(184, 'Dom jednorodzinny', 0, 0, NULL, '1241.95,-1075.22,31.55,93.6', '1244.91,-1075.21,31.05,271.0', NULL, NULL, 0, 3500, NULL, '2012-11-20 14:45:42', 1),
(185, 'Melina', 0, 0, NULL, '1954.37,-1075.03,24.80,77.9', '1956.59,-1075.50,24.80,260.0', 4, NULL, 1, 1900, NULL, '2013-08-06 21:18:29', 1),
(1156, 'Melina', 0, 0, NULL, '1959.59,-1070.05,24.80,263.1', '1957.98,-1069.75,24.80,80.1', 4, NULL, 0, 1900, NULL, '2013-08-06 21:18:29', 1),
(1157, 'Dom jednorodzinny', 0, 0, 1157, '1241.95,-1075.12,31.55,94.2', '1244.08,-1075.15,31.49,268.2', 38, NULL, 1, 3800, NULL, '2013-04-13 22:07:46', 1),
(1158, 'Dom luksus', 0, 0, NULL, '228.01,-1405.47,51.61,150.9', '228.77,-1403.71,51.61,334.3', 37, NULL, 1, 4000, NULL, '2013-08-08 08:42:01', 1),
(1159, 'Dom jednorodzinny', 0, 0, 1159, '2203.85,106.15,28.44', '2206.94,106.09,27.78, 270', 13, NULL, 0, 3200, NULL, '2013-07-28 17:10:40', 1),
(1160, 'Dom jednorodzinny', 0, 0, 1160, '2373.85,42.25,28.44', '2376.96,42.20,27.78, 270', 5, NULL, 1, 3400, NULL, '2013-02-14 23:07:26', 1),
(1161, 'Dom jednorodzinny', 0, 0, 1161, '2373.85,22.01,28.44', '2377.07,21.94,27.85, 270', 15, NULL, 0, 3300, NULL, '2013-03-12 23:07:16', 1),
(1162, 'Willa', 0, 0, 1162, '1095.05,-647.91,113.65', '1094.78,-646.56,113.65,3.4', 14, NULL, 1, 6000, NULL, '2017-08-21 10:07:09', 1),
(1163, 'Melina', 0, 0, NULL, '2514.59,-1240.46,39.34', '2514.57,-1242.99,39.02,180', 10, NULL, 0, 2200, NULL, '2012-12-15 23:06:15', 1),
(1164, 'Melina', 0, 0, NULL, '2469.18,-1278.40,30.37,268.6', '2467.13,-1278.04,29.92,92.3', 4, NULL, 0, 1900, NULL, '2013-06-22 17:19:12', 1),
(1166, 'Apartament \'u Szkota\'', 0, 0, 1166, '253.20,-1270.00,74.43', '251.56,-1267.61,72.89, 35', 27, NULL, 0, 5000, NULL, '2017-08-21 10:07:09', 1),
(1169, 'Melina', 0, 0, NULL, '2627.64,-1085.15,69.72,95.4', '2629.79,-1085.18,69.62,265.8', 24, NULL, 0, 2000, NULL, '2013-03-30 23:06:54', 1),
(1170, 'Melina', 0, 0, NULL, '2628.10,-1067.96,69.72,86.4', '2631.48,-1067.87,69.63,266.4', 24, NULL, 0, 2000, NULL, '2013-03-26 23:06:43', 1),
(1171, 'Melina', 0, 0, NULL, '2625.94,-1112.63,68.00,85.8', '2630.44,-1114.21,67.78,261.0', 10, NULL, 1, 2200, NULL, '2013-03-29 23:06:52', 1),
(1173, 'Ekskluzywny dom', 0, 0, 3139, '1535.03,-800.19,72.86', '1532.81,-800.21,72.61,90.8', 178, NULL, 0, 6554, NULL, '2017-08-21 10:07:09', 1),
(1174, 'Willa na wzgorzu', 0, 0, NULL, '1298.57,-797.99,84.14', '1298.57,-799.91,84.14,181.8', 116, 9, 1, 6554, '2017-09-04', '2017-08-21 14:55:03', 1),
(1183, 'Wiejski domek', 0, 0, 1183, '1566.84,23.20,24.16,264.9', '1564.69,23.33,24.16,89.1', 14, NULL, 1, 2500, NULL, '2017-08-21 10:07:09', 1),
(1203, 'Melina', 0, 0, NULL, '1969.35,-1654.67,15.97,358.3', '1969.69,-1656.91,15.97,181.7', 21, NULL, 1, 100, NULL, '2013-06-08 00:37:09', 1),
(1176, 'Dom \'Wally\'ego\'', 0, 0, NULL, '2259.42,-1019.11,59.30', '2258.30,-1024.82,59.28, 135', 5, NULL, 1, 5000, NULL, '2013-01-03 23:05:33', 1),
(1177, 'Dom \'samotnika\'', 0, 0, NULL, '2287.52,-1081.06,48.25', '2292.06,-1082.08,47.60, 258', 4, NULL, 0, 3100, NULL, '2013-04-06 22:05:55', 1),
(1178, 'Dom \'szklarza\'', 0, 0, NULL, '2278.76,-1077.42,48.24', '2274.97,-1074.12,47.68, 53', 8, NULL, 0, 2200, NULL, '2013-04-06 22:05:55', 1),
(1184, 'Dom jednorodzinny', 0, 0, 1184, '207.08,-112.35,4.90', '206.46,-109.56,4.90, 0', 1, NULL, 1, 2500, NULL, '2012-12-13 23:06:10', 1),
(1179, 'Luksusowe mieszkanie', 0, 0, NULL, '1468.67,-906.17,54.84,174.4', '1468.86,-904.18,54.84,354.4', 37, NULL, 0, 6000, NULL, '2013-07-10 19:47:35', 1),
(1180, 'Dom jednorodzinny', 0, 0, 1180, '2308.82,-1714.33,14.98', '2308.70,-1717.19,14.33, 180', 2, NULL, 0, 2800, NULL, '2013-07-03 19:14:26', 1),
(1181, 'Dom jednorodzinny', 0, 0, 1181, '2326.78,-1716.70,14.24', '2326.81,-1718.81,13.55, 180', 2, NULL, 1, 2600, NULL, '2013-06-08 00:37:09', 1),
(1182, 'Dom jednorodzinny', 0, 0, 1182, '2326.88,-1681.91,14.93', '2330.77,-1682.00,14.27, 270', 3, NULL, 0, 3100, NULL, '2013-06-08 00:37:09', 1),
(1198, 'Melina', 0, 0, NULL, '178.27,-120.23,1.55,177.5', '178.35,-117.73,1.55,0.5', 4, NULL, 0, 2000, NULL, '2013-04-02 22:07:02', 1),
(1196, 'Melina', 0, 0, NULL, '2072.50,-1559.31,13.41,179.0', '2072.62,-1557.47,13.41,0.2', 4, NULL, 1, 2100, NULL, '2013-01-13 23:05:57', 1),
(1185, 'Dom jednorodzinny', 0, 0, 1185, '189.43,-120.23,1.55', '189.56,-117.50,1.55, 0', 1, NULL, 0, 2400, NULL, '2013-01-29 23:07:56', 1),
(1186, 'Dom jednorodzinny', 0, 0, 1186, '166.34,-94.97,1.55,9.7', '166.28,-97.41,1.55, 180', 3, NULL, 0, 3000, NULL, '2013-04-02 22:07:02', 1),
(1187, 'Dom jednorodzinny', 0, 0, NULL, '252.89,-92.39,3.54', '249.59,-92.23,2.84, 90', 15, NULL, 0, 3700, NULL, '2013-04-09 22:06:15', 1),
(1188, 'Dom jednorodzinny', 0, 0, NULL, '312.73,-92.43,3.54', '315.83,-92.36,2.87, 270', 5, NULL, 0, 3300, NULL, '2013-03-11 23:07:14', 1),
(1189, 'Dom jednorodzinny', 0, 0, 1189, '312.72,-121.26,3.54', '315.74,-121.40,2.90, 270', 6, NULL, 1, 3500, NULL, '2013-03-22 23:06:33', 1),
(1190, 'Melina', 0, 0, NULL, '2076.15,-1588.67,13.49', '2074.02,-1586.87,13.49, 55', 4, NULL, 1, 2000, NULL, '2013-01-11 23:05:52', 1),
(1191, 'Melina', 0, 0, NULL, '2065.29,-1583.36,13.48', '2067.55,-1585.56,13.49, 224', 4, NULL, 0, 2000, NULL, '2013-01-16 23:09:14', 1),
(1192, 'Melina', 0, 0, 1192, '2066.69,-1554.09,13.44', '2068.64,-1556.29,13.43, 234', 1, NULL, 0, 2300, NULL, '2013-03-30 23:06:54', 1),
(1193, 'Melina', 0, 0, 1193, '2072.27,-1551.42,13.42', '2070.12,-1554.29,13.42, 140', 1, NULL, 1, 2200, NULL, '2013-01-16 23:09:14', 1),
(1194, 'Melina', 0, 0, 1194, '2073.37,-1583.05,13.47', '2071.31,-1585.21,13.49, 150', 1, NULL, 0, 2300, NULL, '2013-07-28 17:10:40', 1),
(1195, 'Melina', 0, 0, NULL, '2066.96,-1562.16,13.43', '2068.81,-1559.27,13.42, 312', 4, NULL, 0, 2100, NULL, '2013-03-30 23:06:54', 1),
(1199, 'Melina', 0, 0, NULL, '166.27,-120.23,1.55,181.2', '166.31,-118.13,1.55,359.9', 10, NULL, 1, 2200, NULL, '2013-06-22 17:19:12', 1),
(1197, 'Apartament \'u Struga\'', 0, 0, NULL, '219.25,-1249.80,78.34', '220.87,-1252.37,78.29, 219', 27, NULL, 1, 5000, NULL, '2013-07-10 19:47:35', 1),
(1201, 'Melina', 0, 0, NULL, '166.29,-96.97,4.90,359.8', '166.21,-98.18,4.90,176.9', 24, NULL, 0, 2000, NULL, '2013-02-19 23:00:53', 1),
(1202, 'Melina', 0, 0, NULL, '166.34,-118.23,4.90,187.3', '166.22,-117.03,4.90,359.4', 15, NULL, 0, 2000, NULL, '2012-12-05 23:07:47', 1),
(1204, 'Melina', 0, 0, NULL, '1973.35,-1654.67,15.97,360.0', '1973.18,-1657.32,15.97,179.4', 21, NULL, 0, 2000, NULL, '2013-02-25 23:01:08', 1),
(1205, 'Melina', 0, 0, NULL, '1969.98,-1671.19,15.97,357.2', '1969.80,-1673.25,15.97,177.2', 4, NULL, 1, 2000, NULL, '2013-03-18 23:08:25', 1),
(1206, 'Melina', 0, 0, NULL, '1974.77,-1671.20,15.97,8.6', '1974.50,-1673.49,15.97,178.9', 4, NULL, 1, 2000, NULL, '2013-04-03 22:07:04', 1),
(1207, 'Melina', 0, 0, NULL, '1978.76,-1671.53,16.19,268.5', '1977.16,-1671.19,16.19,82.8', 4, NULL, 0, 2000, NULL, '2013-03-13 23:07:19', 1),
(1208, 'Melina', 0, 0, NULL, '1970.01,-1671.19,18.55,354.7', '1967.80,-1671.52,17.81,93.0', 4, NULL, 1, 2000, NULL, '2013-03-11 23:07:14', 1),
(1209, 'Melina', 0, 0, NULL, '1978.76,-1671.38,18.55,265.5', '1976.45,-1671.46,18.55,85.5', 4, NULL, 1, 2000, NULL, '2013-03-13 23:07:19', 1),
(1210, 'Domek', 0, 0, 1210, '2013.58,-1656.33,14.14', '2012.49,-1656.15,13.55,84.3', 6, NULL, 1, 2200, NULL, '2013-04-11 22:08:59', 1),
(1211, 'Melina', 0, 0, NULL, '2244.45,-1637.61,16.24,342.9', '2243.90,-1638.90,15.91,162.9', 15, NULL, 0, 2000, NULL, '2013-07-18 17:55:02', 1),
(1212, 'Domek na wsi', 0, 0, NULL, '374.59,-76.71,1.38,0.7', '374.52,-78.15,1.38,176.1', 24, NULL, 0, 2200, NULL, '2013-03-25 23:06:40', 1),
(1221, 'Dom jednorodzinny', 0, 0, 1221, '2209.67,-1240.25,24.48', '2209.81,-1237.40,23.93, 0', 1, NULL, 0, 3700, NULL, '2013-06-08 00:37:09', 1),
(1220, 'Dom jednorodzinny', 0, 0, 1220, '2249.85,-1238.91,25.90', '2250.04,-1235.19,25.51, 0', 6, NULL, 0, 4000, NULL, '2017-08-21 10:07:09', 1),
(1214, 'Stara chata Gulivera', 0, 0, NULL, '920.47,222.38,34.04', '919.38,219.90,34.06, 157', 4, NULL, 1, 1500, NULL, '2013-04-06 22:05:55', 1),
(1213, 'Dom w bloku', 0, 0, NULL, '1972.21,-1633.72,15.97,3.4', '1972.09,-1636.19,15.97,178.1', 15, NULL, 0, 3139, NULL, '2013-02-27 23:01:13', 1),
(1215, 'Stara chata na grobli', 0, 0, NULL, '1337.88,-184.51,17.94', '1336.26,-187.29,17.70, 149', 4, NULL, 1, 1500, NULL, '2013-03-27 23:06:45', 1),
(1216, 'Stara chata Salomona', 0, 0, NULL, '-339.46,195.25,9.75', '-339.03,192.28,9.59, 186', 4, NULL, 0, 1500, NULL, '2013-04-03 22:07:04', 1),
(1217, 'Stara chata rolnika', 0, 0, NULL, '-40.86,-10.69,3.32', '-39.70,-8.07,3.12, 339', 4, NULL, 0, 1500, NULL, '2013-04-02 22:07:02', 1),
(1218, 'Stara chata drwala', 0, 0, NULL, '385.87,-605.72,38.40', '388.73,-606.28,38.19, 251', 4, NULL, 0, 1500, NULL, '2013-06-08 00:37:09', 1),
(1219, 'Stara chata drwala', 0, 0, NULL, '450.19,-376.74,31.76', '452.13,-378.80,30.73, 222', 4, NULL, 0, 1500, NULL, '2013-06-08 00:37:09', 1),
(1222, 'Dom jednorodzinny', 0, 0, 1222, '2191.81,-1239.24,24.49', '2191.78,-1236.17,23.98, 0', 2, NULL, 1, 3800, NULL, '2013-06-08 00:37:09', 1),
(1223, 'Dom jednorodzinny', 0, 0, 1223, '2229.62,-1241.59,25.66', '2229.46,-1239.15,25.39, 0', 1, NULL, 0, 3900, NULL, '2013-06-08 00:37:09', 1),
(1224, 'Dom jednorodzinny', 0, 0, 1224, '2207.93,-1280.82,25.12', '2207.81,-1283.36,24.53, 180', 5, NULL, 0, 4000, NULL, '2013-06-08 00:37:09', 1),
(1225, 'Dom jednorodzinny', 0, 0, 1225, '2230.13,-1280.06,25.63', '2230.18,-1283.62,25.37, 180', 2, NULL, 0, 4000, NULL, '2013-03-12 23:07:16', 1),
(1226, 'Dom jednorodzinny', 0, 0, 1226, '2091.04,-1277.84,26.18', '2090.93,-1281.07,25.59, 180', 2, NULL, 0, 4200, NULL, '2013-04-09 22:06:15', 1),
(1227, 'Dom jednorodzinny', 0, 0, 1227, '2132.31,-1280.05,25.89', '2132.30,-1283.56,25.53, 180', 6, NULL, 1, 4200, NULL, '2013-04-12 22:09:01', 1),
(1228, 'Dom jednorodzinny', 0, 0, 1228, '2153.74,-1243.80,25.37', '2153.82,-1240.10,24.98, 0', 1, NULL, 1, 3700, NULL, '2013-06-08 00:37:09', 1),
(1229, 'Dom jednorodzinny', 0, 0, 1229, '2110.90,-1244.40,25.85', '2110.90,-1241.02,25.51, 0', 5, NULL, 0, 3900, NULL, '2013-07-18 17:55:02', 1),
(1230, 'Dom jednorodzinny', 0, 0, 1230, '2152.21,-1446.39,26.11', '2149.25,-1446.20,25.54, 90', 5, NULL, 1, 3600, NULL, '2013-01-08 15:43:56', 1),
(1231, 'Dom jednorodzinny', 0, 0, 1231, '2150.92,-1419.08,25.92', '2147.87,-1418.96,25.63, 90', 1, NULL, 1, 4100, NULL, '2013-03-07 23:06:14', 1),
(1232, 'Dom jednorodzinny', 0, 0, 1232, '2188.55,-1419.28,26.16', '2191.40,-1419.24,25.73, 270', 1, NULL, 0, 4200, NULL, '2013-07-18 17:55:02', 1),
(1233, 'Dom jednorodzinny', 0, 0, 1233, '2190.45,-1470.36,25.91', '2193.58,-1470.49,25.61, 270', 6, NULL, 0, 3800, NULL, '2013-04-02 22:07:02', 1),
(1234, 'Dom pietrowy', 0, 0, 1234, '2126.68,-1320.87,26.62', '2126.73,-1316.97,25.54, 0', 35, NULL, 1, 3800, NULL, '2013-04-11 12:08:55', 1),
(1235, 'Dom jednorodzinny', 0, 0, 1235, '2148.51,-1320.08,26.07', '2148.84,-1316.49,25.55, 0', 6, NULL, 1, 3300, NULL, '2013-04-05 22:05:36', 1),
(1236, 'Dom jednorodzinny', 0, 0, 1236, '2147.71,-1366.12,25.97', '2147.74,-1369.29,25.54, 180', 3, NULL, 1, 3100, NULL, '2013-03-08 22:16:45', 1),
(1240, 'Wielorodzinna melina', 0, 0, 1240, '2744.22,-1947.37,13.55', '2748.29,-1945.38,13.55, 270', 10, NULL, 0, 4700, NULL, '2017-08-21 10:07:09', 1),
(1237, 'Dom jednorodzinnny', 0, 0, 1237, '1955.12,-1115.39,27.83', '1956.05,-1118.36,26.84, 180', 21, NULL, 0, 3200, NULL, '2013-08-08 08:42:01', 1),
(1239, 'Wielorodzinna melina', 0, 0, 1239, '2744.28,-1941.31,13.55', '2748.41,-1943.59,13.55, 270', 10, NULL, 0, 4700, NULL, '2017-08-21 10:07:09', 1),
(1238, 'Dom jednorodzinnny', 0, 0, 1238, '1906.05,-1112.95,26.66', '1905.91,-1115.86,25.66, 180', 6, NULL, 0, 3500, NULL, '2013-08-08 08:42:01', 1),
(1241, 'Wielorodzinna melina', 0, 0, 1241, '2793.60,-1947.69,13.55', '2790.01,-1945.29,13.55, 90', 10, NULL, 1, 4700, NULL, '2013-08-08 08:41:35', 1),
(1242, 'Wielorodzinna melina', 0, 0, 1242, '2793.59,-1941.63,13.55', '2789.86,-1943.72,13.55, 90', 10, NULL, 1, 4700, NULL, '2013-08-08 08:41:37', 1);

A to skrypt, kt?ry ??czy si? z baz? i daje domy do kupienia, kt?rych kurde kupi? nie mog? ... :<

Cytat:

--[[
Domy do wynajecia

@author Lukasz Biegaj <[email protected]>
@copyright 2010-2013 Lukasz Biegaj <[email protected]>
@license Dual GPLv2/MIT
]]--

domy={}

local function usunDom(id)
if isElement(domy[id].wyjscie) then destroyElement(domy[id].wyjscie) end
if isElement(domy[id].wejscie) then destroyElement(domy[id].wejscie) end
if isElement(domy[id].cs) then destroyElement(domy[id].cs) end
if isElement(domy[id].text) then destroyElement(domy[id].text) end
domy[id]=nil
end

local function dodajDom(v,fast)

if not interiory[v.interiorid] then return false end
-- if tonumber(v.id)==151 then
-- outputChatBox("151")
-- end

if domy[v.id] then
usunDom(v.id)
end

v.drzwi=split(v.drzwi,",")
for ii,vv in ipairs(v.drzwi) do v.drzwi[ii]=tonumber(vv) end
v.punkt_wyjscia=split(v.punkt_wyjscia,",")
for ii,vv in ipairs(v.punkt_wyjscia) do v.punkt_wyjscia[ii]=tonumber(vv) end
local pickupid=1272
if (not v.ownerid) then
pickupid=1273
end
v.wejscie=createPickup ( v.drzwi[1], v.drzwi[2], v.drzwi[3], 3, pickupid, 0)
v.cs=createColSphere(v.drzwi[1],v.drzwi[2],v.drzwi[3], 1)

if (not fast and v.ownerid) then
v.text=createElement("text")
setElementPosition(v.text, v.drzwi[1],v.drzwi[2],v.drzwi[3]+0.5)
-- setElementPosition(v.text, 2903.09,-32.64,-24.62)

-- setElementData(v.text,"text", "dom")
setElementData(v.text,"text", (v.descr or "Dom").."\n"..v.owner_nick)

end
local interior_dimension=v.vwi or 1000+v.id

setElementData(v.cs, "dom", {
["zamkniety"]=v.zamkniety>0 and true or false,
["id"]=v.id,
["koszt"]=v.koszt,
["ownerid"]=v.ownerid,
["owner_nick"]=v.owner_nick,
["descr"]=v.descr or "dom",
["dimension"]=interior_dimension,
["interior"]=interiory[v.interiorid].interior,
["interior_loc"]=interiory[v.interiorid].entrance,
["exit_loc"]=v.punkt_wyjscia,
["paidTo"]=v.paidTo,
["paidTo_dni"]=v.paidTo_dni,
-- ["veha"]=(v.vehicles_allowed and v.vehicles_allowed>0) and true or false
})

-- dodajemy wyjscie
v.wyjscie=createMarker(interiory[v.interiorid].exit[1], interiory[v.interiorid].exit[2], interiory[v.interiorid].exit[3], "arrow",1)
setElementDimension(v.wyjscie, interior_dimension)
setElementInterior(v.wyjscie, interiory[v.interiorid].interior)
setElementData(v.wyjscie,"tpto", v.punkt_wyjscia)

local dbid=v.id
v.id=nil
domy[dbid]=v

return true
end

function domyGetInfo(id)
return domy[id]
end

local function zaladujCzescDomow(procent,fast)
local tt=getTickCount()
i=0
exports.DB2:zapytanie("UPDATE lss_domy SET paidTo=NULL,ownerid=NULL where paidTo<NOW() or paidTo IS NULL")
local dbdomy
if fast then
dbdomy=exports.DB2:pobierzTabeleWynikow("SELECT d.id,d.descr,d.vwi,d.drzwi,d.punkt_wyjscia,d.interiorid,d.ownerid,concat(c.imie,' ',c.nazwisko) owner_nick,d.zamkniety,d.koszt,d.paidTo,datediff(d.paidTo,now()) paidTo_dni FROM lss_domy d LEFT JOIN lss_characters c ON c.id=d.ownerid WHERE d.active=1 AND d.ownerid IS NOT NULL;")
else
dbdomy=exports.DB2:pobierzTabeleWynikow("SELECT d.id,d.descr,d.vwi,d.drzwi,d.punkt_wyjscia,d.interiorid,d.ownerid,concat(c.imie,' ',c.nazwisko) owner_nick,d.zamkniety,d.koszt,d.paidTo,datediff(d.paidTo,now()) paidTo_dni FROM lss_domy d LEFT JOIN lss_characters c ON c.id=d.ownerid WHERE d.active=1;")
end
for __,v in ipairs(dbdomy) do
if math.random(0,100)<=procent then
-- outputChatBox("Wgrywanie domu " .. v.id)
if dodajDom(v,fast) then i=i+1 end
end
end
outputDebugString("Zaladowano domow: " .. i .. " w " .. (getTickCount()-tt) .. "ms")
end
-- setTimer(zaladujCzescDomow, 10*1000*60, 0, 100)
addEventHandler("onResourceStart", resourceRoot, function()
zaladujCzescDomow(100,false)
end)

local function zaladujZmienioneDomy()
local i=0
local dbdomy=exports.DB2:pobierzTabeleWynikow("SELECT d.id,d.descr,d.vwi,d.drzwi,d.punkt_wyjscia,d.interiorid,d.ownerid,concat(c.imie,' ',c.nazwisko) owner_nick,d.zamkniety,d.koszt,d.paidTo,datediff(d.paidTo,now()) paidTo_dni FROM lss_domy d LEFT JOIN lss_characters c ON c.id=d.ownerid WHERE d.active=1 AND timediff(now(),d.updated)<'00:09:00' AND datediff(now(),d.updated)<1")
for __,v in ipairs(dbdomy) do

if dodajDom(v) then i=i+1 end
end
outputDebugString("Zaladowano zmienionych domow: " .. i)
end

setTimer(zaladujZmienioneDomy, 10*1000*5, 0)

function domReload(id)
local dbdom=exports.DB2:pobierzWyniki("SELECT d.id,d.descr,d.vwi,d.drzwi,d.punkt_wyjscia,d.interiorid,d.ownerid,concat(c.imie,' ',c.nazwisko) owner_nick,d.zamkniety,d.koszt,d.paidTo,datediff(d.paidTo,now()) paidTo_dni FROM lss_domy d LEFT JOIN lss_characters c ON c.id=d.ownerid WHERE d.active=1 and d.id=?;",id)
if dbdom then
return dodajDom(dbdom)
end
return false
end