yZ3vspQ6

1/*
2	Yet Another House System by rootcause
3
4	Current Version: 1.3
5	Topic: http://forum.sa-mp.com/showthread.php?p=3409290
6
7	Changelog (v1.3):
8	- Added house selling, you can put your houses for sale. When your house is bought by an another player, you'll receive your money.
9	- Added a house buying limiter, a player can't buy more than LIMIT_PER_PLAYER houses. Set LIMIT_PER_PLAYER to 0 if you want no limits.
10	- Internal changes like replacing GetPlayerName with Player_GetName or replacing the DIALOG_HOUSE+x format with e_dialogids enum.
11	
12	Fordította zsoolt997 a Magyar SA:MP közösségének - 2016. 09. 03.
13*/
14
15#define USE_FOREACH_INSTEAD_YSI //szedd le a kommentet, ha foreachet akarsz használni
16
17#define 	FILTERSCRIPT
18#include 	<a_samp>
19#include    <a_mysql>
20#include    <streamer>
21#include    <sscanf2>
22
23#if defined USE_FOREACH_INSTEAD_YSI
24	#include 	<foreach>
25#else
26	#include    <YSI\y_iterate>
27#endif
28
29#include    <zcmd>
30
31#define     MAX_HOUSES          (100)
32#define     MAX_HOUSE_NAME      (48)
33#define     MAX_HOUSE_PASSWORD  (16)
34#define     MAX_HOUSE_ADDRESS   (48)
35#define     MAX_INT_NAME        (32)
36#define     INVALID_HOUSE_ID    (-1)
37#define     HOUSE_COOLDOWN      (6)
38#define     LIMIT_PER_PLAYER    (3)
39
40#define		SQL_HOST			"127.0.0.1"
41#define		SQL_USER			"root"
42#define		SQL_PASSWORD		""
43#define		SQL_DBNAME			"housedb"
44
45enum    _:e_lockmodes
46{
47	LOCK_MODE_NOLOCK,
48	LOCK_MODE_PASSWORD,
49	LOCK_MODE_KEYS,
50	LOCK_MODE_OWNER
51}
52
53enum    _:e_selectmodes
54{
55	SELECT_MODE_NONE,
56	SELECT_MODE_EDIT,
57	SELECT_MODE_SELL
58}
59
60enum	_:e_dialogids
61{
62	DIALOG_BUY_HOUSE = 7500,
63	DIALOG_HOUSE_PASSWORD,
64	DIALOG_HOUSE_MENU,
65	DIALOG_HOUSE_NAME,
66	DIALOG_HOUSE_NEW_PASSWORD,
67	DIALOG_HOUSE_LOCK,
68	DIALOG_SAFE_MENU,
69	DIALOG_SAFE_TAKE,
70	DIALOG_SAFE_PUT,
71	DIALOG_GUNS_MENU,
72	DIALOG_GUNS_TAKE,
73	DIALOG_FURNITURE_MENU,
74	DIALOG_FURNITURE_BUY,
75	DIALOG_FURNITURE_SELL,
76	DIALOG_VISITORS_MENU,
77	DIALOG_VISITORS,
78	DIALOG_KEYS_MENU,
79	DIALOG_KEYS,
80	DIALOG_SAFE_HISTORY,
81	DIALOG_MY_KEYS,
82	DIALOG_BUY_HOUSE_FROM_OWNER,
83	DIALOG_SELL_HOUSE,
84	DIALOG_SELLING_PRICE
85}
86
87enum    e_house
88{
89	Name[MAX_HOUSE_NAME],
90	Owner[MAX_PLAYER_NAME],
91	Password[MAX_HOUSE_PASSWORD],
92	Address[MAX_HOUSE_ADDRESS],
93	Float: houseX,
94	Float: houseY,
95	Float: houseZ,
96	Price,
97	SalePrice,
98	Interior,
99	LockMode,
100	SafeMoney,
101	LastEntered,
102	Text3D:HouseLabel,
103	HousePickup,
104	HouseIcon,
105	bool: Save
106};
107
108enum    e_interior
109{
110	IntName[MAX_INT_NAME],
111	Float: intX,
112	Float: intY,
113	Float: intZ,
114	intID,
115	Text3D:intLabel,
116	intPickup
117};
118
119enum    e_furnituredata
120{
121	ModelID,
122	Name[32],
123	Price
124};
125
126enum    e_furniture
127{
128	SQLID,
129	HouseID,
130	ArrayID,
131	Float: furnitureX,
132	Float: furnitureY,
133	Float: furnitureZ,
134	Float: furnitureRX,
135	Float: furnitureRY,
136	Float: furnitureRZ
137};
138
139enum    e_sazone
140{
141    SAZONE_NAME[28],
142    Float: SAZONE_AREA[6]
143};
144
145new
146	SQLHandle,
147	HouseTimer = -1,
148 	HouseData[MAX_HOUSES][e_house],
149	Iterator: Houses<MAX_HOUSES>,
150	Iterator: HouseKeys[MAX_PLAYERS]<MAX_HOUSES>,
151	InHouse[MAX_PLAYERS] = {INVALID_HOUSE_ID, ...},
152	SelectMode[MAX_PLAYERS] = {SELECT_MODE_NONE, ...},
153	LastVisitedHouse[MAX_PLAYERS] = {INVALID_HOUSE_ID, ...},
154	ListPage[MAX_PLAYERS] = {0, ...},
155	bool: EditingFurniture[MAX_PLAYERS] = {false, ...};
156
157new
158    HouseInteriors[][e_interior] = {
159    // int name, x, y, z, intid
160		{"Interior 1", 2233.4900, -1114.4435, 1050.8828, 5},
161		{"Interior 2", 2196.3943, -1204.1359, 1049.0234, 6},
162		{"Interior 3", 2318.1616, -1026.3762, 1050.2109, 9},
163		{"Interior 4", 421.8333, 2536.9814, 10.0000, 10},
164		{"Interior 5", 225.5707, 1240.0643, 1082.1406, 2},
165		{"Interior 6", 2496.2087, -1692.3149, 1014.7422, 3},
166		{"Interior 7", 226.7545, 1114.4180, 1080.9952, 5},
167		{"Interior 8", 2269.9636, -1210.3275, 1047.5625, 10}
168    };
169
170new
171	HouseFurnitures[][e_furnituredata] = {
172	// modelid, furniture name, price
173	    {3111, "Tervrajz", 500},
174	    {2894, "Könyv", 20},
175	    {2277, "Cicás kép", 100},
176	    {1753, "Bőr kanapé", 150},
177	    {1703, "Fekete kanapé", 200},
178	    {1255, "Napozóágy", 75},
179	    {19581, "Serpenyő", 10},
180	    {19584, "Lábas", 12},
181	    {19590, "Woozie kardja", 1000},
182	    {19525, "Esküvői torta", 50},
183	    {1742, "Könyvespolc", 80},
184	    {1518, "TV 1", 130},
185	    {19609, "Dobfelszerelés", 500},
186		{19787, "Kicsi LCD TV", 2000},
187		{19786, "Nagy LCD TV", 4000},
188		{2627, "Futópad", 130}
189	};
190
191new
192	SAZones[][e_sazone] = {
193		{"The Big Ear",	                {-410.00,1403.30,-3.00,-137.90,1681.20,200.00}},
194		{"Aldea Malvada",               {-1372.10,2498.50,0.00,-1277.50,2615.30,200.00}},
195		{"Angel Pine",                  {-2324.90,-2584.20,-6.10,-1964.20,-2212.10,200.00}},
196		{"Arco del Oeste",              {-901.10,2221.80,0.00,-592.00,2571.90,200.00}},
197		{"Avispa Country Club",         {-2646.40,-355.40,0.00,-2270.00,-222.50,200.00}},
198		{"Avispa Country Club",         {-2831.80,-430.20,-6.10,-2646.40,-222.50,200.00}},
199		{"Avispa Country Club",         {-2361.50,-417.10,0.00,-2270.00,-355.40,200.00}},
200		{"Avispa Country Club",         {-2667.80,-302.10,-28.80,-2646.40,-262.30,71.10}},
201		{"Avispa Country Club",         {-2470.00,-355.40,0.00,-2270.00,-318.40,46.10}},
202		{"Avispa Country Club",         {-2550.00,-355.40,0.00,-2470.00,-318.40,39.70}},
203		{"Vissza o Beyond",               {-1166.90,-2641.10,0.00,-321.70,-1856.00,200.00}},
204		{"Battery Point",               {-2741.00,1268.40,-4.50,-2533.00,1490.40,200.00}},
205		{"Bayside",                     {-2741.00,2175.10,0.00,-2353.10,2722.70,200.00}},
206		{"Bayside Marina",              {-2353.10,2275.70,0.00,-2153.10,2475.70,200.00}},
207		{"Beacon Hill",                 {-399.60,-1075.50,-1.40,-319.00,-977.50,198.50}},
208		{"Blackfield",                  {964.30,1203.20,-89.00,1197.30,1403.20,110.90}},
209		{"Blackfield",                  {964.30,1403.20,-89.00,1197.30,1726.20,110.90}},
210		{"Blackfield Chapel",           {1375.60,596.30,-89.00,1558.00,823.20,110.90}},
211		{"Blackfield Chapel",           {1325.60,596.30,-89.00,1375.60,795.00,110.90}},
212		{"Blackfield Intersection",     {1197.30,1044.60,-89.00,1277.00,1163.30,110.90}},
213		{"Blackfield Intersection",     {1166.50,795.00,-89.00,1375.60,1044.60,110.90}},
214		{"Blackfield Intersection",     {1277.00,1044.60,-89.00,1315.30,1087.60,110.90}},
215		{"Blackfield Intersection",     {1375.60,823.20,-89.00,1457.30,919.40,110.90}},
216		{"Blueberry",                   {104.50,-220.10,2.30,349.60,152.20,200.00}},
217		{"Blueberry",                   {19.60,-404.10,3.80,349.60,-220.10,200.00}},
218		{"Blueberry Acres",             {-319.60,-220.10,0.00,104.50,293.30,200.00}},
219		{"Caligula's Palace",           {2087.30,1543.20,-89.00,2437.30,1703.20,110.90}},
220		{"Caligula's Palace",           {2137.40,1703.20,-89.00,2437.30,1783.20,110.90}},
221		{"Calton Heights",              {-2274.10,744.10,-6.10,-1982.30,1358.90,200.00}},
222		{"Chinatown",                   {-2274.10,578.30,-7.60,-2078.60,744.10,200.00}},
223		{"City Hall",                   {-2867.80,277.40,-9.10,-2593.40,458.40,200.00}},
224		{"Come-A-Lot",                  {2087.30,943.20,-89.00,2623.10,1203.20,110.90}},
225		{"Commerce",                    {1323.90,-1842.20,-89.00,1701.90,-1722.20,110.90}},
226		{"Commerce",                    {1323.90,-1722.20,-89.00,1440.90,-1577.50,110.90}},
227		{"Commerce",                    {1370.80,-1577.50,-89.00,1463.90,-1384.90,110.90}},
228		{"Commerce",                    {1463.90,-1577.50,-89.00,1667.90,-1430.80,110.90}},
229		{"Commerce",                    {1583.50,-1722.20,-89.00,1758.90,-1577.50,110.90}},
230		{"Commerce",                    {1667.90,-1577.50,-89.00,1812.60,-1430.80,110.90}},
231		{"Conference Center",           {1046.10,-1804.20,-89.00,1323.90,-1722.20,110.90}},
232		{"Conference Center",           {1073.20,-1842.20,-89.00,1323.90,-1804.20,110.90}},
233		{"Cranberry Station",           {-2007.80,56.30,0.00,-1922.00,224.70,100.00}},
234		{"Creek",                       {2749.90,1937.20,-89.00,2921.60,2669.70,110.90}},
235		{"Dillimore",                   {580.70,-674.80,-9.50,861.00,-404.70,200.00}},
236		{"Doherty",                     {-2270.00,-324.10,-0.00,-1794.90,-222.50,200.00}},
237		{"Doherty",                     {-2173.00,-222.50,-0.00,-1794.90,265.20,200.00}},
238		{"Downtown",                    {-1982.30,744.10,-6.10,-1871.70,1274.20,200.00}},
239		{"Downtown",                    {-1871.70,1176.40,-4.50,-1620.30,1274.20,200.00}},
240		{"Downtown",                    {-1700.00,744.20,-6.10,-1580.00,1176.50,200.00}},
241		{"Downtown",                    {-1580.00,744.20,-6.10,-1499.80,1025.90,200.00}},
242		{"Downtown",                    {-2078.60,578.30,-7.60,-1499.80,744.20,200.00}},
243		{"Downtown",                    {-1993.20,265.20,-9.10,-1794.90,578.30,200.00}},
244		{"Downtown Los Santos",         {1463.90,-1430.80,-89.00,1724.70,-1290.80,110.90}},
245		{"Downtown Los Santos",         {1724.70,-1430.80,-89.00,1812.60,-1250.90,110.90}},
246		{"Downtown Los Santos",         {1463.90,-1290.80,-89.00,1724.70,-1150.80,110.90}},
247		{"Downtown Los Santos",         {1370.80,-1384.90,-89.00,1463.90,-1170.80,110.90}},
248		{"Downtown Los Santos",         {1724.70,-1250.90,-89.00,1812.60,-1150.80,110.90}},
249		{"Downtown Los Santos",         {1370.80,-1170.80,-89.00,1463.90,-1130.80,110.90}},
250		{"Downtown Los Santos",         {1378.30,-1130.80,-89.00,1463.90,-1026.30,110.90}},
251		{"Downtown Los Santos",         {1391.00,-1026.30,-89.00,1463.90,-926.90,110.90}},
252		{"Downtown Los Santos",         {1507.50,-1385.20,110.90,1582.50,-1325.30,335.90}},
253		{"East Beach",                  {2632.80,-1852.80,-89.00,2959.30,-1668.10,110.90}},
254		{"East Beach",                  {2632.80,-1668.10,-89.00,2747.70,-1393.40,110.90}},
255		{"East Beach",                  {2747.70,-1668.10,-89.00,2959.30,-1498.60,110.90}},
256		{"East Beach",                  {2747.70,-1498.60,-89.00,2959.30,-1120.00,110.90}},
257		{"East Los Santos",             {2421.00,-1628.50,-89.00,2632.80,-1454.30,110.90}},
258		{"East Los Santos",             {2222.50,-1628.50,-89.00,2421.00,-1494.00,110.90}},
259		{"East Los Santos",             {2266.20,-1494.00,-89.00,2381.60,-1372.00,110.90}},
260		{"East Los Santos",             {2381.60,-1494.00,-89.00,2421.00,-1454.30,110.90}},
261		{"East Los Santos",             {2281.40,-1372.00,-89.00,2381.60,-1135.00,110.90}},
262		{"East Los Santos",             {2381.60,-1454.30,-89.00,2462.10,-1135.00,110.90}},
263		{"East Los Santos",             {2462.10,-1454.30,-89.00,2581.70,-1135.00,110.90}},
264		{"Easter Basin",                {-1794.90,249.90,-9.10,-1242.90,578.30,200.00}},
265		{"Easter Basin",                {-1794.90,-50.00,-0.00,-1499.80,249.90,200.00}},
266		{"Easter Bay Airport",          {-1499.80,-50.00,-0.00,-1242.90,249.90,200.00}},
267		{"Easter Bay Airport",          {-1794.90,-730.10,-3.00,-1213.90,-50.00,200.00}},
268		{"Easter Bay Airport",          {-1213.90,-730.10,0.00,-1132.80,-50.00,200.00}},
269		{"Easter Bay Airport",          {-1242.90,-50.00,0.00,-1213.90,578.30,200.00}},
270		{"Easter Bay Airport",          {-1213.90,-50.00,-4.50,-947.90,578.30,200.00}},
271		{"Easter Bay Airport",          {-1315.40,-405.30,15.40,-1264.40,-209.50,25.40}},
272		{"Easter Bay Airport",          {-1354.30,-287.30,15.40,-1315.40,-209.50,25.40}},
273		{"Easter Bay Airport",          {-1490.30,-209.50,15.40,-1264.40,-148.30,25.40}},
274		{"Easter Bay Chemicals",        {-1132.80,-768.00,0.00,-956.40,-578.10,200.00}},
275		{"Easter Bay Chemicals",        {-1132.80,-787.30,0.00,-956.40,-768.00,200.00}},
276		{"El Castillo del Diablo",      {-464.50,2217.60,0.00,-208.50,2580.30,200.00}},
277		{"El Castillo del Diablo",      {-208.50,2123.00,-7.60,114.00,2337.10,200.00}},
278		{"El Castillo del Diablo",      {-208.50,2337.10,0.00,8.40,2487.10,200.00}},
279		{"El Corona",                   {1812.60,-2179.20,-89.00,1970.60,-1852.80,110.90}},
280		{"El Corona",                   {1692.60,-2179.20,-89.00,1812.60,-1842.20,110.90}},
281		{"El Quebrados",                {-1645.20,2498.50,0.00,-1372.10,2777.80,200.00}},
282		{"Esplanade East",              {-1620.30,1176.50,-4.50,-1580.00,1274.20,200.00}},
283		{"Esplanade East",              {-1580.00,1025.90,-6.10,-1499.80,1274.20,200.00}},
284		{"Esplanade East",              {-1499.80,578.30,-79.60,-1339.80,1274.20,20.30}},
285		{"Esplanade North",             {-2533.00,1358.90,-4.50,-1996.60,1501.20,200.00}},
286		{"Esplanade North",             {-1996.60,1358.90,-4.50,-1524.20,1592.50,200.00}},
287		{"Esplanade North",             {-1982.30,1274.20,-4.50,-1524.20,1358.90,200.00}},
288		{"Fallen Tree",                 {-792.20,-698.50,-5.30,-452.40,-380.00,200.00}},
289		{"Fallow Bridge",               {434.30,366.50,0.00,603.00,555.60,200.00}},
290		{"Fern Ridge",                  {508.10,-139.20,0.00,1306.60,119.50,200.00}},
291		{"Financial",                   {-1871.70,744.10,-6.10,-1701.30,1176.40,300.00}},
292		{"Fisher's Lagoon",             {1916.90,-233.30,-100.00,2131.70,13.80,200.00}},
293		{"Flint Intersection",          {-187.70,-1596.70,-89.00,17.00,-1276.60,110.90}},
294		{"Flint Range",                 {-594.10,-1648.50,0.00,-187.70,-1276.60,200.00}},
295		{"Fort Carson",                 {-376.20,826.30,-3.00,123.70,1220.40,200.00}},
296		{"Foster Valley",               {-2270.00,-430.20,-0.00,-2178.60,-324.10,200.00}},
297		{"Foster Valley",               {-2178.60,-599.80,-0.00,-1794.90,-324.10,200.00}},
298		{"Foster Valley",               {-2178.60,-1115.50,0.00,-1794.90,-599.80,200.00}},
299		{"Foster Valley",               {-2178.60,-1250.90,0.00,-1794.90,-1115.50,200.00}},
300		{"Frederick Bridge",            {2759.20,296.50,0.00,2774.20,594.70,200.00}},
301		{"Gant Bridge",                 {-2741.40,1659.60,-6.10,-2616.40,2175.10,200.00}},
302		{"Gant Bridge",                 {-2741.00,1490.40,-6.10,-2616.40,1659.60,200.00}},
303		{"Ganton",                      {2222.50,-1852.80,-89.00,2632.80,-1722.30,110.90}},
304		{"Ganton",                      {2222.50,-1722.30,-89.00,2632.80,-1628.50,110.90}},
305		{"Garcia",                      {-2411.20,-222.50,-0.00,-2173.00,265.20,200.00}},
306		{"Garcia",                      {-2395.10,-222.50,-5.30,-2354.00,-204.70,200.00}},
307		{"Garver Bridge",               {-1339.80,828.10,-89.00,-1213.90,1057.00,110.90}},
308		{"Garver Bridge",               {-1213.90,950.00,-89.00,-1087.90,1178.90,110.90}},
309		{"Garver Bridge",               {-1499.80,696.40,-179.60,-1339.80,925.30,20.30}},
310		{"Glen Park",                   {1812.60,-1449.60,-89.00,1996.90,-1350.70,110.90}},
311		{"Glen Park",                   {1812.60,-1100.80,-89.00,1994.30,-973.30,110.90}},
312		{"Glen Park",                   {1812.60,-1350.70,-89.00,2056.80,-1100.80,110.90}},
313		{"Green Palms",                 {176.50,1305.40,-3.00,338.60,1520.70,200.00}},
314		{"Greenglass College",          {964.30,1044.60,-89.00,1197.30,1203.20,110.90}},
315		{"Greenglass College",          {964.30,930.80,-89.00,1166.50,1044.60,110.90}},
316		{"Hampton Barns",               {603.00,264.30,0.00,761.90,366.50,200.00}},
317		{"Hankypanky Point",            {2576.90,62.10,0.00,2759.20,385.50,200.00}},
318		{"Harry Gold Parkway",          {1777.30,863.20,-89.00,1817.30,2342.80,110.90}},
319		{"Hashbury",                    {-2593.40,-222.50,-0.00,-2411.20,54.70,200.00}},
320		{"Hilltop Farm",                {967.30,-450.30,-3.00,1176.70,-217.90,200.00}},
321		{"Hunter Quarry",               {337.20,710.80,-115.20,860.50,1031.70,203.70}},
322		{"Idlewood",                    {1812.60,-1852.80,-89.00,1971.60,-1742.30,110.90}},
323		{"Idlewood",                    {1812.60,-1742.30,-89.00,1951.60,-1602.30,110.90}},
324		{"Idlewood",                    {1951.60,-1742.30,-89.00,2124.60,-1602.30,110.90}},
325		{"Idlewood",                    {1812.60,-1602.30,-89.00,2124.60,-1449.60,110.90}},
326		{"Idlewood",                    {2124.60,-1742.30,-89.00,2222.50,-1494.00,110.90}},
327		{"Idlewood",                    {1971.60,-1852.80,-89.00,2222.50,-1742.30,110.90}},
328		{"Jefferson",                   {1996.90,-1449.60,-89.00,2056.80,-1350.70,110.90}},
329		{"Jefferson",                   {2124.60,-1494.00,-89.00,2266.20,-1449.60,110.90}},
330		{"Jefferson",                   {2056.80,-1372.00,-89.00,2281.40,-1210.70,110.90}},
331		{"Jefferson",                   {2056.80,-1210.70,-89.00,2185.30,-1126.30,110.90}},
332		{"Jefferson",                   {2185.30,-1210.70,-89.00,2281.40,-1154.50,110.90}},
333		{"Jefferson",                   {2056.80,-1449.60,-89.00,2266.20,-1372.00,110.90}},
334		{"Julius Thruway East",         {2623.10,943.20,-89.00,2749.90,1055.90,110.90}},
335		{"Julius Thruway East",         {2685.10,1055.90,-89.00,2749.90,2626.50,110.90}},
336		{"Julius Thruway East",         {2536.40,2442.50,-89.00,2685.10,2542.50,110.90}},
337		{"Julius Thruway East",         {2625.10,2202.70,-89.00,2685.10,2442.50,110.90}},
338		{"Julius Thruway North",        {2498.20,2542.50,-89.00,2685.10,2626.50,110.90}},
339		{"Julius Thruway North",        {2237.40,2542.50,-89.00,2498.20,2663.10,110.90}},
340		{"Julius Thruway North",        {2121.40,2508.20,-89.00,2237.40,2663.10,110.90}},
341		{"Julius Thruway North",        {1938.80,2508.20,-89.00,2121.40,2624.20,110.90}},
342		{"Julius Thruway North",        {1534.50,2433.20,-89.00,1848.40,2583.20,110.90}},
343		{"Julius Thruway North",        {1848.40,2478.40,-89.00,1938.80,2553.40,110.90}},
344		{"Julius Thruway North",        {1704.50,2342.80,-89.00,1848.40,2433.20,110.90}},
345		{"Julius Thruway North",        {1377.30,2433.20,-89.00,1534.50,2507.20,110.90}},
346		{"Julius Thruway South",        {1457.30,823.20,-89.00,2377.30,863.20,110.90}},
347		{"Julius Thruway South",        {2377.30,788.80,-89.00,2537.30,897.90,110.90}},
348		{"Julius Thruway West",         {1197.30,1163.30,-89.00,1236.60,2243.20,110.90}},
349		{"Julius Thruway West",         {1236.60,2142.80,-89.00,1297.40,2243.20,110.90}},
350		{"Juniper Hill",                {-2533.00,578.30,-7.60,-2274.10,968.30,200.00}},
351		{"Juniper Hollow",              {-2533.00,968.30,-6.10,-2274.10,1358.90,200.00}},
352		{"K.A.C.C. Military Fuels",     {2498.20,2626.50,-89.00,2749.90,2861.50,110.90}},
353		{"Kincaid Bridge",              {-1339.80,599.20,-89.00,-1213.90,828.10,110.90}},
354		{"Kincaid Bridge",              {-1213.90,721.10,-89.00,-1087.90,950.00,110.90}},
355		{"Kincaid Bridge",              {-1087.90,855.30,-89.00,-961.90,986.20,110.90}},
356		{"King's",                      {-2329.30,458.40,-7.60,-1993.20,578.30,200.00}},
357		{"King's",                      {-2411.20,265.20,-9.10,-1993.20,373.50,200.00}},
358		{"King's",                      {-2253.50,373.50,-9.10,-1993.20,458.40,200.00}},
359		{"LVA Freight Depot",           {1457.30,863.20,-89.00,1777.40,1143.20,110.90}},
360		{"LVA Freight Depot",           {1375.60,919.40,-89.00,1457.30,1203.20,110.90}},
361		{"LVA Freight Depot",           {1277.00,1087.60,-89.00,1375.60,1203.20,110.90}},
362		{"LVA Freight Depot",           {1315.30,1044.60,-89.00,1375.60,1087.60,110.90}},
363		{"LVA Freight Depot",           {1236.60,1163.40,-89.00,1277.00,1203.20,110.90}},
364		{"Las Barrancas",               {-926.10,1398.70,-3.00,-719.20,1634.60,200.00}},
365		{"Las Brujas",                  {-365.10,2123.00,-3.00,-208.50,2217.60,200.00}},
366		{"Las Colinas",                 {1994.30,-1100.80,-89.00,2056.80,-920.80,110.90}},
367		{"Las Colinas",                 {2056.80,-1126.30,-89.00,2126.80,-920.80,110.90}},
368		{"Las Colinas",                 {2185.30,-1154.50,-89.00,2281.40,-934.40,110.90}},
369		{"Las Colinas",                 {2126.80,-1126.30,-89.00,2185.30,-934.40,110.90}},
370		{"Las Colinas",                 {2747.70,-1120.00,-89.00,2959.30,-945.00,110.90}},
371		{"Las Colinas",                 {2632.70,-1135.00,-89.00,2747.70,-945.00,110.90}},
372		{"Las Colinas",                 {2281.40,-1135.00,-89.00,2632.70,-945.00,110.90}},
373		{"Las Payasadas",               {-354.30,2580.30,2.00,-133.60,2816.80,200.00}},
374		{"Las Venturas Airport",        {1236.60,1203.20,-89.00,1457.30,1883.10,110.90}},
375		{"Las Venturas Airport",        {1457.30,1203.20,-89.00,1777.30,1883.10,110.90}},
376		{"Las Venturas Airport",        {1457.30,1143.20,-89.00,1777.40,1203.20,110.90}},
377		{"Las Venturas Airport",        {1515.80,1586.40,-12.50,1729.90,1714.50,87.50}},
378		{"Last Dime Motel",             {1823.00,596.30,-89.00,1997.20,823.20,110.90}},
379		{"Leafy Hollow",                {-1166.90,-1856.00,0.00,-815.60,-1602.00,200.00}},
380		{"Liberty City",                {-1000.00,400.00,1300.00,-700.00,600.00,1400.00}},
381		{"Lil' Probe Inn",              {-90.20,1286.80,-3.00,153.80,1554.10,200.00}},
382		{"Linden Side",                 {2749.90,943.20,-89.00,2923.30,1198.90,110.90}},
383		{"Linden Station",              {2749.90,1198.90,-89.00,2923.30,1548.90,110.90}},
384		{"Linden Station",              {2811.20,1229.50,-39.50,2861.20,1407.50,60.40}},
385		{"Little Mexico",               {1701.90,-1842.20,-89.00,1812.60,-1722.20,110.90}},
386		{"Little Mexico",               {1758.90,-1722.20,-89.00,1812.60,-1577.50,110.90}},
387		{"Los Flores",                  {2581.70,-1454.30,-89.00,2632.80,-1393.40,110.90}},
388		{"Los Flores",                  {2581.70,-1393.40,-89.00,2747.70,-1135.00,110.90}},
389		{"Los Santos International",    {1249.60,-2394.30,-89.00,1852.00,-2179.20,110.90}},
390		{"Los Santos International",    {1852.00,-2394.30,-89.00,2089.00,-2179.20,110.90}},
391		{"Los Santos International",    {1382.70,-2730.80,-89.00,2201.80,-2394.30,110.90}},
392		{"Los Santos International",    {1974.60,-2394.30,-39.00,2089.00,-2256.50,60.90}},
393		{"Los Santos International",    {1400.90,-2669.20,-39.00,2189.80,-2597.20,60.90}},
394		{"Los Santos International",    {2051.60,-2597.20,-39.00,2152.40,-2394.30,60.90}},
395		{"Marina",                      {647.70,-1804.20,-89.00,851.40,-1577.50,110.90}},
396		{"Marina",                      {647.70,-1577.50,-89.00,807.90,-1416.20,110.90}},
397		{"Marina",                      {807.90,-1577.50,-89.00,926.90,-1416.20,110.90}},
398		{"Market",                      {787.40,-1416.20,-89.00,1072.60,-1310.20,110.90}},
399		{"Market",                      {952.60,-1310.20,-89.00,1072.60,-1130.80,110.90}},
400		{"Market",                      {1072.60,-1416.20,-89.00,1370.80,-1130.80,110.90}},
401		{"Market",                      {926.90,-1577.50,-89.00,1370.80,-1416.20,110.90}},
402		{"Market Station",              {787.40,-1410.90,-34.10,866.00,-1310.20,65.80}},
403		{"Martin Bridge",               {-222.10,293.30,0.00,-122.10,476.40,200.00}},
404		{"Missionary Hill",             {-2994.40,-811.20,0.00,-2178.60,-430.20,200.00}},
405		{"Montgomery",                  {1119.50,119.50,-3.00,1451.40,493.30,200.00}},
406		{"Montgomery",                  {1451.40,347.40,-6.10,1582.40,420.80,200.00}},
407		{"Montgomery Intersection",     {1546.60,208.10,0.00,1745.80,347.40,200.00}},
408		{"Montgomery Intersection",     {1582.40,347.40,0.00,1664.60,401.70,200.00}},
409		{"Mulholland",                  {1414.00,-768.00,-89.00,1667.60,-452.40,110.90}},
410		{"Mulholland",                  {1281.10,-452.40,-89.00,1641.10,-290.90,110.90}},
411		{"Mulholland",                  {1269.10,-768.00,-89.00,1414.00,-452.40,110.90}},
412		{"Mulholland",                  {1357.00,-926.90,-89.00,1463.90,-768.00,110.90}},
413		{"Mulholland",                  {1318.10,-910.10,-89.00,1357.00,-768.00,110.90}},
414		{"Mulholland",                  {1169.10,-910.10,-89.00,1318.10,-768.00,110.90}},
415		{"Mulholland",                  {768.60,-954.60,-89.00,952.60,-860.60,110.90}},
416		{"Mulholland",                  {687.80,-860.60,-89.00,911.80,-768.00,110.90}},
417		{"Mulholland",                  {737.50,-768.00,-89.00,1142.20,-674.80,110.90}},
418		{"Mulholland",                  {1096.40,-910.10,-89.00,1169.10,-768.00,110.90}},
419		{"Mulholland",                  {952.60,-937.10,-89.00,1096.40,-860.60,110.90}},
420		{"Mulholland",                  {911.80,-860.60,-89.00,1096.40,-768.00,110.90}},
421		{"Mulholland",                  {861.00,-674.80,-89.00,1156.50,-600.80,110.90}},
422		{"Mulholland Intersection",     {1463.90,-1150.80,-89.00,1812.60,-768.00,110.90}},
423		{"North Rock",                  {2285.30,-768.00,0.00,2770.50,-269.70,200.00}},
424		{"Ocean Docks",                 {2373.70,-2697.00,-89.00,2809.20,-2330.40,110.90}},
425		{"Ocean Docks",                 {2201.80,-2418.30,-89.00,2324.00,-2095.00,110.90}},
426		{"Ocean Docks",                 {2324.00,-2302.30,-89.00,2703.50,-2145.10,110.90}},
427		{"Ocean Docks",                 {2089.00,-2394.30,-89.00,2201.80,-2235.80,110.90}},
428		{"Ocean Docks",                 {2201.80,-2730.80,-89.00,2324.00,-2418.30,110.90}},
429		{"Ocean Docks",                 {2703.50,-2302.30,-89.00,2959.30,-2126.90,110.90}},
430		{"Ocean Docks",                 {2324.00,-2145.10,-89.00,2703.50,-2059.20,110.90}},
431		{"Ocean Flats",                 {-2994.40,277.40,-9.10,-2867.80,458.40,200.00}},
432		{"Ocean Flats",                 {-2994.40,-222.50,-0.00,-2593.40,277.40,200.00}},
433		{"Ocean Flats",                 {-2994.40,-430.20,-0.00,-2831.80,-222.50,200.00}},
434		{"Octane Springs",              {338.60,1228.50,0.00,664.30,1655.00,200.00}},
435		{"Old Venturas Strip",          {2162.30,2012.10,-89.00,2685.10,2202.70,110.90}},
436		{"Palisades",                   {-2994.40,458.40,-6.10,-2741.00,1339.60,200.00}},
437		{"Palomino Creek",              {2160.20,-149.00,0.00,2576.90,228.30,200.00}},
438		{"Paradiso",                    {-2741.00,793.40,-6.10,-2533.00,1268.40,200.00}},
439		{"Pershing Square",             {1440.90,-1722.20,-89.00,1583.50,-1577.50,110.90}},
440		{"Pilgrim",                     {2437.30,1383.20,-89.00,2624.40,1783.20,110.90}},
441		{"Pilgrim",                     {2624.40,1383.20,-89.00,2685.10,1783.20,110.90}},
442		{"Pilson Intersection",         {1098.30,2243.20,-89.00,1377.30,2507.20,110.90}},
443		{"Pirates in Men's Pants",      {1817.30,1469.20,-89.00,2027.40,1703.20,110.90}},
444		{"Playa del Seville",           {2703.50,-2126.90,-89.00,2959.30,-1852.80,110.90}},
445		{"Prickle Pine",                {1534.50,2583.20,-89.00,1848.40,2863.20,110.90}},
446		{"Prickle Pine",                {1117.40,2507.20,-89.00,1534.50,2723.20,110.90}},
447		{"Prickle Pine",                {1848.40,2553.40,-89.00,1938.80,2863.20,110.90}},
448		{"Prickle Pine",                {1938.80,2624.20,-89.00,2121.40,2861.50,110.90}},
449		{"Queens",                      {-2533.00,458.40,0.00,-2329.30,578.30,200.00}},
450		{"Queens",                      {-2593.40,54.70,0.00,-2411.20,458.40,200.00}},
451		{"Queens",                      {-2411.20,373.50,0.00,-2253.50,458.40,200.00}},
452		{"Randolph Industrial Estate",  {1558.00,596.30,-89.00,1823.00,823.20,110.90}},
453		{"Redsands East",               {1817.30,2011.80,-89.00,2106.70,2202.70,110.90}},
454		{"Redsands East",               {1817.30,2202.70,-89.00,2011.90,2342.80,110.90}},
455		{"Redsands East",               {1848.40,2342.80,-89.00,2011.90,2478.40,110.90}},
456		{"Redsands West",               {1236.60,1883.10,-89.00,1777.30,2142.80,110.90}},
457		{"Redsands West",               {1297.40,2142.80,-89.00,1777.30,2243.20,110.90}},
458		{"Redsands West",               {1377.30,2243.20,-89.00,1704.50,2433.20,110.90}},
459		{"Redsands West",               {1704.50,2243.20,-89.00,1777.30,2342.80,110.90}},
460		{"Regular Tom",                 {-405.70,1712.80,-3.00,-276.70,1892.70,200.00}},
461		{"Richman",                     {647.50,-1118.20,-89.00,787.40,-954.60,110.90}},
462		{"Richman",                     {647.50,-954.60,-89.00,768.60,-860.60,110.90}},
463		{"Richman",                     {225.10,-1369.60,-89.00,334.50,-1292.00,110.90}},
464		{"Richman",                     {225.10,-1292.00,-89.00,466.20,-1235.00,110.90}},
465		{"Richman",                     {72.60,-1404.90,-89.00,225.10,-1235.00,110.90}},
466		{"Richman",                     {72.60,-1235.00,-89.00,321.30,-1008.10,110.90}},
467		{"Richman",                     {321.30,-1235.00,-89.00,647.50,-1044.00,110.90}},
468		{"Richman",                     {321.30,-1044.00,-89.00,647.50,-860.60,110.90}},
469		{"Richman",                     {321.30,-860.60,-89.00,687.80,-768.00,110.90}},
470		{"Richman",                     {321.30,-768.00,-89.00,700.70,-674.80,110.90}},
471		{"Robada Intersection",         {-1119.00,1178.90,-89.00,-862.00,1351.40,110.90}},
472		{"Roca Escalante",              {2237.40,2202.70,-89.00,2536.40,2542.50,110.90}},
473		{"Roca Escalante",              {2536.40,2202.70,-89.00,2625.10,2442.50,110.90}},
474		{"Rockshore East",              {2537.30,676.50,-89.00,2902.30,943.20,110.90}},
475		{"Rockshore West",              {1997.20,596.30,-89.00,2377.30,823.20,110.90}},
476		{"Rockshore West",              {2377.30,596.30,-89.00,2537.30,788.80,110.90}},
477		{"Rodeo",                       {72.60,-1684.60,-89.00,225.10,-1544.10,110.90}},
478		{"Rodeo",                       {72.60,-1544.10,-89.00,225.10,-1404.90,110.90}},
479		{"Rodeo",                       {225.10,-1684.60,-89.00,312.80,-1501.90,110.90}},
480		{"Rodeo",                       {225.10,-1501.90,-89.00,334.50,-1369.60,110.90}},
481		{"Rodeo",                       {334.50,-1501.90,-89.00,422.60,-1406.00,110.90}},
482		{"Rodeo",                       {312.80,-1684.60,-89.00,422.60,-1501.90,110.90}},
483		{"Rodeo",                       {422.60,-1684.60,-89.00,558.00,-1570.20,110.90}},
484		{"Rodeo",                       {558.00,-1684.60,-89.00,647.50,-1384.90,110.90}},
485		{"Rodeo",                       {466.20,-1570.20,-89.00,558.00,-1385.00,110.90}},
486		{"Rodeo",                       {422.60,-1570.20,-89.00,466.20,-1406.00,110.90}},
487		{"Rodeo",                       {466.20,-1385.00,-89.00,647.50,-1235.00,110.90}},
488		{"Rodeo",                       {334.50,-1406.00,-89.00,466.20,-1292.00,110.90}},
489		{"Royal Casino",                {2087.30,1383.20,-89.00,2437.30,1543.20,110.90}},
490		{"San Andreas Sound",           {2450.30,385.50,-100.00,2759.20,562.30,200.00}},
491		{"Santa Flora",                 {-2741.00,458.40,-7.60,-2533.00,793.40,200.00}},
492		{"Santa Maria Beach",           {342.60,-2173.20,-89.00,647.70,-1684.60,110.90}},
493		{"Santa Maria Beach",           {72.60,-2173.20,-89.00,342.60,-1684.60,110.90}},
494		{"Shady Cabin",                 {-1632.80,-2263.40,-3.00,-1601.30,-2231.70,200.00}},
495		{"Shady Creeks",                {-1820.60,-2643.60,-8.00,-1226.70,-1771.60,200.00}},
496		{"Shady Creeks",                {-2030.10,-2174.80,-6.10,-1820.60,-1771.60,200.00}},
497		{"Sobell Rail Yards",           {2749.90,1548.90,-89.00,2923.30,1937.20,110.90}},
498		{"Spinybed",                    {2121.40,2663.10,-89.00,2498.20,2861.50,110.90}},
499		{"Starfish Casino",             {2437.30,1783.20,-89.00,2685.10,2012.10,110.90}},
500		{"Starfish Casino",             {2437.30,1858.10,-39.00,2495.00,1970.80,60.90}},
501		{"Starfish Casino",             {2162.30,1883.20,-89.00,2437.30,2012.10,110.90}},
502		{"Temple",                      {1252.30,-1130.80,-89.00,1378.30,-1026.30,110.90}},
503		{"Temple",                      {1252.30,-1026.30,-89.00,1391.00,-926.90,110.90}},
504		{"Temple",                      {1252.30,-926.90,-89.00,1357.00,-910.10,110.90}},
505		{"Temple",                      {952.60,-1130.80,-89.00,1096.40,-937.10,110.90}},
506		{"Temple",                      {1096.40,-1130.80,-89.00,1252.30,-1026.30,110.90}},
507		{"Temple",                      {1096.40,-1026.30,-89.00,1252.30,-910.10,110.90}},
508		{"The Camel's Toe",             {2087.30,1203.20,-89.00,2640.40,1383.20,110.90}},
509		{"The Clown's Pocket",          {2162.30,1783.20,-89.00,2437.30,1883.20,110.90}},
510		{"The Emerald Isle",            {2011.90,2202.70,-89.00,2237.40,2508.20,110.90}},
511		{"The Farm",                    {-1209.60,-1317.10,114.90,-908.10,-787.30,251.90}},
512		{"The Four Dragons Casino",     {1817.30,863.20,-89.00,2027.30,1083.20,110.90}},
513		{"The High Roller",             {1817.30,1283.20,-89.00,2027.30,1469.20,110.90}},
514		{"The Mako Span",               {1664.60,401.70,0.00,1785.10,567.20,200.00}},
515		{"The Panopticon",              {-947.90,-304.30,-1.10,-319.60,327.00,200.00}},
516		{"The Pink Swan",               {1817.30,1083.20,-89.00,2027.30,1283.20,110.90}},
517		{"The Sherman Dam",             {-968.70,1929.40,-3.00,-481.10,2155.20,200.00}},
518		{"The Strip",                   {2027.40,863.20,-89.00,2087.30,1703.20,110.90}},
519		{"The Strip",                   {2106.70,1863.20,-89.00,2162.30,2202.70,110.90}},
520		{"The Strip",                   {2027.40,1783.20,-89.00,2162.30,1863.20,110.90}},
521		{"The Strip",                   {2027.40,1703.20,-89.00,2137.40,1783.20,110.90}},
522		{"The Visage",                  {1817.30,1863.20,-89.00,2106.70,2011.80,110.90}},
523		{"The Visage",                  {1817.30,1703.20,-89.00,2027.40,1863.20,110.90}},
524		{"Unity Station",               {1692.60,-1971.80,-20.40,1812.60,-1932.80,79.50}},
525		{"Valle Ocultado",              {-936.60,2611.40,2.00,-715.90,2847.90,200.00}},
526		{"Verdant Bluffs",              {930.20,-2488.40,-89.00,1249.60,-2006.70,110.90}},
527		{"Verdant Bluffs",              {1073.20,-2006.70,-89.00,1249.60,-1842.20,110.90}},
528		{"Verdant Bluffs",              {1249.60,-2179.20,-89.00,1692.60,-1842.20,110.90}},
529		{"Verdant Meadows",             {37.00,2337.10,-3.00,435.90,2677.90,200.00}},
530		{"Verona Beach",                {647.70,-2173.20,-89.00,930.20,-1804.20,110.90}},
531		{"Verona Beach",                {930.20,-2006.70,-89.00,1073.20,-1804.20,110.90}},
532		{"Verona Beach",                {851.40,-1804.20,-89.00,1046.10,-1577.50,110.90}},
533		{"Verona Beach",                {1161.50,-1722.20,-89.00,1323.90,-1577.50,110.90}},
534		{"Verona Beach",                {1046.10,-1722.20,-89.00,1161.50,-1577.50,110.90}},
535		{"Vinewood",                    {787.40,-1310.20,-89.00,952.60,-1130.80,110.90}},
536		{"Vinewood",                    {787.40,-1130.80,-89.00,952.60,-954.60,110.90}},
537		{"Vinewood",                    {647.50,-1227.20,-89.00,787.40,-1118.20,110.90}},
538		{"Vinewood",                    {647.70,-1416.20,-89.00,787.40,-1227.20,110.90}},
539		{"Whitewood Estates",           {883.30,1726.20,-89.00,1098.30,2507.20,110.90}},
540		{"Whitewood Estates",           {1098.30,1726.20,-89.00,1197.30,2243.20,110.90}},
541		{"Willowfield",                 {1970.60,-2179.20,-89.00,2089.00,-1852.80,110.90}},
542		{"Willowfield",                 {2089.00,-2235.80,-89.00,2201.80,-1989.90,110.90}},
543		{"Willowfield",                 {2089.00,-1989.90,-89.00,2324.00,-1852.80,110.90}},
544		{"Willowfield",                 {2201.80,-2095.00,-89.00,2324.00,-1989.90,110.90}},
545		{"Willowfield",                 {2541.70,-1941.40,-89.00,2703.50,-1852.80,110.90}},
546		{"Willowfield",                 {2324.00,-2059.20,-89.00,2541.70,-1852.80,110.90}},
547		{"Willowfield",                 {2541.70,-2059.20,-89.00,2703.50,-1941.40,110.90}},
548		{"Yellow Bell Station",         {1377.40,2600.40,-21.90,1492.40,2687.30,78.00}},
549		{"Los Santos",                  {44.60,-2892.90,-242.90,2997.00,-768.00,900.00}},
550		{"Las Venturas",                {869.40,596.30,-242.90,2997.00,2993.80,900.00}},
551		{"Bone County",                 {-480.50,596.30,-242.90,869.40,2993.80,900.00}},
552		{"Tierra Robada",               {-2997.40,1659.60,-242.90,-480.50,2993.80,900.00}},
553		{"Tierra Robada",               {-1213.90,596.30,-242.90,-480.50,1659.60,900.00}},
554		{"San Fierro",                  {-2997.40,-1115.50,-242.90,-1213.90,1659.60,900.00}},
555		{"Red County",                  {-1213.90,-768.00,-242.90,2997.00,596.30,900.00}},
556		{"Flint County",                {-1213.90,-2892.90,-242.90,44.60,-768.00,900.00}},
557		{"Whetstone",                   {-2997.40,-2892.90,-242.90,-1213.90,-1115.50,900.00}}
558	};
559
560new
561	LockNames[4][32] = {"{2ECC71}Nyitva", "{E74C3C}Jelszó szükséges", "{E74C3C}Kulcs szükséges", "{E74C3C}Csak Tulaj"},
562	TransactionNames[2][12] = {"{E74C3C}Ki", "{2ECC71}Be"};
563
564stock LoadHouseKeys(playerid)
565{
566    Iter_Clear(HouseKeys[playerid]);
567    
568    new query[72];
569    mysql_format(SQLHandle, query, sizeof(query), "SELECT * FROM housekeys WHERE Player='%e'", Player_GetName(playerid));
570	mysql_tquery(SQLHandle, query, "GiveHouseKeys", "i", playerid);
571	return 1;
572}
573
574stock GetZoneName(Float: x, Float: y, Float: z)
575{
576	new zone[28];
577 	for(new i = 0; i < sizeof(SAZones); i++)
578 	{
579		if(x >= SAZones[i][SAZONE_AREA][0] && x <= SAZones[i][SAZONE_AREA][3] && y >= SAZones[i][SAZONE_AREA][1] && y <= SAZones[i][SAZONE_AREA][4] && z >= SAZones[i][SAZONE_AREA][2] && z <= SAZones[i][SAZONE_AREA][5])
580		{
581		    strcat(zone, SAZones[i][SAZONE_NAME]);
582		    return zone;
583		}
584	}
585
586	strcat(zone, "Ismeretlen");
587	return zone;
588}
589
590stock GetCityName(Float: x, Float: y, Float: z)
591{
592	new city[28];
593	for(new i = 356; i < sizeof(SAZones); i++)
594	{
595		if(x >= SAZones[i][SAZONE_AREA][0] && x <= SAZones[i][SAZONE_AREA][3] && y >= SAZones[i][SAZONE_AREA][1] && y <= SAZones[i][SAZONE_AREA][4] && z >= SAZones[i][SAZONE_AREA][2] && z <= SAZones[i][SAZONE_AREA][5])
596		{
597		    strcat(city, SAZones[i][SAZONE_NAME]);
598		    return city;
599		}
600	}
601
602	strcat(city, "San Andreas");
603	return city;
604}
605
606stock convertNumber(value)
607{
608	// http://forum.sa-mp.com/showthread.php?p=843781#post843781
609    new string[24];
610    format(string, sizeof(string), "%d", value);
611
612    for(new i = (strlen(string) - 3); i > (value < 0 ? 1 : 0) ; i -= 3)
613    {
614        strins(string[i], ",", 0);
615    }
616
617    return string;
618}
619
620stock RemovePlayerWeapon(playerid, weapon)
621{
622    new weapons[13], ammo[13];
623    for(new i; i < 13; i++) GetPlayerWeaponData(playerid, i, weapons[i], ammo[i]);
624    ResetPlayerWeapons(playerid);
625    for(new i; i < 13; i++)
626    {
627        if(weapons[i] == weapon) continue;
628        GivePlayerWeapon(playerid, weapons[i], ammo[i]);
629    }
630
631    return 1;
632}
633
634stock GetXYInFrontOfPlayer(playerid, &Float:x, &Float:y, Float:distance)
635{
636	new Float: a;
637	GetPlayerPos(playerid, x, y, a);
638	GetPlayerFacingAngle(playerid, a);
639	if (GetPlayerVehicleID(playerid)) GetVehicleZAngle(GetPlayerVehicleID(playerid), a);
640	x += (distance * floatsin(-a, degrees));
641	y += (distance * floatcos(-a, degrees));
642}
643
644stock Player_GetName(playerid)
645{
646	new name[MAX_PLAYER_NAME];
647	GetPlayerName(playerid, name, MAX_PLAYER_NAME);
648	return name;
649}
650
651stock SendToHouse(playerid, id)
652{
653    if(!Iter_Contains(Houses, id)) return 0;
654    SetPVarInt(playerid, "HousePickupCooldown", gettime() + HOUSE_COOLDOWN);
655    InHouse[playerid] = id;
656	SetPlayerVirtualWorld(playerid, id);
657 	SetPlayerInterior(playerid, HouseInteriors[ HouseData[id][Interior] ][intID]);
658  	SetPlayerPos(playerid, HouseInteriors[ HouseData[id][Interior] ][intX], HouseInteriors[ HouseData[id][Interior] ][intY], HouseInteriors[ HouseData[id][Interior] ][intZ]);
659
660	new string[128];
661	format(string, sizeof(string), "Üdvözlünk %s házában, a %s{FFFFFF}-ban/ben!", HouseData[id][Owner], HouseData[id][Name]);
662	SendClientMessage(playerid, 0xFFFFFFFF, string);
663
664	if(!strcmp(HouseData[id][Owner], Player_GetName(playerid)))
665	{
666		HouseData[id][LastEntered] = gettime();
667		HouseData[id][Save] = true;
668		SendClientMessage(playerid, 0xFFFFFFFF, "Használd a {3498DB}/house {FFFFFF}parancsot a menü megtekintéséhez.");
669	}
670
671	if(HouseData[id][LockMode] == LOCK_MODE_NOLOCK && LastVisitedHouse[playerid] != id)
672	{
673	    new query[128];
674	    mysql_format(SQLHandle, query, sizeof(query), "INSERT INTO housevisitors SET HouseID=%d, Visitor='%e', Date=UNIX_TIMESTAMP()", id, Player_GetName(playerid));
675		mysql_tquery(SQLHandle, query, "", "");
676		LastVisitedHouse[playerid] = id;
677	}
678
679	return 1;
680}
681
682stock ShowHouseMenu(playerid)
683{
684	if(strcmp(HouseData[ InHouse[playerid] ][Owner], Player_GetName(playerid))) return SendClientMessage(playerid, 0xE74C3CFF, "Nem a tiéd a ház.");
685
686	new string[256], id = InHouse[playerid];
687	format(string, sizeof(string), "Ház név: %s\nJelszó: %s\nZárva: %s\nHáz széf {2ECC71}($%s)\nBútorok\nFegyverek\nLátogatók\nKulcsok\nMindenki kirúgása\nHáz eladása", HouseData[id][Name], HouseData[id][Password], LockNames[ HouseData[id][LockMode] ], convertNumber(HouseData[id][SafeMoney]));
688	ShowPlayerDialog(playerid, DIALOG_HOUSE_MENU, DIALOG_STYLE_LIST, HouseData[id][Name], string, "Select", "Close");
689	return 1;
690}
691
692stock ResetHouse(id)
693{
694    if(!Iter_Contains(Houses, id)) return 0;
695	format(HouseData[id][Name], MAX_HOUSE_NAME, "Eladó ház");
696	format(HouseData[id][Owner], MAX_PLAYER_NAME, "-");
697	format(HouseData[id][Password], MAX_HOUSE_PASSWORD, "-");
698	HouseData[id][LockMode] = LOCK_MODE_NOLOCK;
699	HouseData[id][SalePrice] = HouseData[id][SafeMoney] = HouseData[id][LastEntered] = 0;
700    HouseData[id][Save] = true;
701
702    new label[200];
703    format(label, sizeof(label), "{2ECC71}Eladó ház (ID: %d)\n{FFFFFF}%s\n{F1C40F}Ár: {2ECC71}$%s", id, HouseInteriors[ HouseData[id][Interior] ][IntName], convertNumber(HouseData[id][Price]));
704	UpdateDynamic3DTextLabelText(HouseData[id][HouseLabel], 0xFFFFFFFF, label);
705	Streamer_SetIntData(STREAMER_TYPE_PICKUP, HouseData[id][HousePickup], E_STREAMER_MODEL_ID, 1273);
706	Streamer_SetIntData(STREAMER_TYPE_MAP_ICON, HouseData[id][HouseIcon], E_STREAMER_TYPE, 31);
707
708    foreach(new i : Player)
709    {
710        if(InHouse[i] == id)
711        {
712            SetPVarInt(i, "HousePickupCooldown", gettime() + HOUSE_COOLDOWN);
713        	SetPlayerVirtualWorld(i, 0);
714	        SetPlayerInterior(i, 0);
715	        SetPlayerPos(i, HouseData[id][houseX], HouseData[id][houseY], HouseData[id][houseZ]);
716	        InHouse[i] = INVALID_HOUSE_ID;
717        }
718
719        if(Iter_Contains(HouseKeys[i], id)) Iter_Remove(HouseKeys[i], id);
720   	}
721
722    new query[64], data[e_furniture];
723    mysql_format(SQLHandle, query, sizeof(query), "DELETE FROM houseguns WHERE HouseID=%d", id);
724    mysql_tquery(SQLHandle, query, "", "");
725
726    for(new i, maxval = Streamer_GetUpperBound(STREAMER_TYPE_OBJECT); i <= maxval; ++i)
727    {
728        if(!IsValidDynamicObject(i)) continue;
729		Streamer_GetArrayData(STREAMER_TYPE_OBJECT, i, E_STREAMER_EXTRA_ID, data);
730		if(data[SQLID] > 0 && data[HouseID] == id) DestroyDynamicObject(i);
731    }
732
733    mysql_format(SQLHandle, query, sizeof(query), "DELETE FROM housefurnitures WHERE HouseID=%d", id);
734    mysql_tquery(SQLHandle, query, "", "");
735
736    mysql_format(SQLHandle, query, sizeof(query), "DELETE FROM housevisitors WHERE HouseID=%d", id);
737    mysql_tquery(SQLHandle, query, "", "");
738
739    mysql_format(SQLHandle, query, sizeof(query), "DELETE FROM housekeys WHERE HouseID=%d", id);
740    mysql_tquery(SQLHandle, query, "", "");
741
742    mysql_format(SQLHandle, query, sizeof(query), "DELETE FROM housesafelogs WHERE HouseID=%d", id);
743    mysql_tquery(SQLHandle, query, "", "");
744	return 1;
745}
746
747stock SaveHouse(id)
748{
749    if(!Iter_Contains(Houses, id)) return 0;
750	new query[256];
751	mysql_format(SQLHandle, query, sizeof(query), "UPDATE houses SET HouseName='%e', HouseOwner='%e', HousePassword='%e', HouseSalePrice=%d, HouseLock=%d, HouseMoney=%d, LastEntered=%d WHERE ID=%d",
752	HouseData[id][Name], HouseData[id][Owner], HouseData[id][Password], HouseData[id][SalePrice], HouseData[id][LockMode], HouseData[id][SafeMoney], HouseData[id][LastEntered], id);
753	mysql_tquery(SQLHandle, query, "", "");
754	HouseData[id][Save] = false;
755	return 1;
756}
757
758stock UpdateHouseLabel(id)
759{
760	if(!Iter_Contains(Houses, id)) return 0;
761	new label[256];
762	if(!strcmp(HouseData[id][Owner], "-")) {
763		format(label, sizeof(label), "{2ECC71}Eladó ház (ID: %d)\n{FFFFFF}%s\n{F1C40F}Ár: {2ECC71}$%s", id, HouseInteriors[ HouseData[id][Interior] ][IntName], convertNumber(HouseData[id][Price]));
764	}else{
765		if(HouseData[id][SalePrice] > 0) {
766		    format(label, sizeof(label), "{E67E22}%s háza eladó (ID: %d)\n{FFFFFF}%s\n{FFFFFF}%s\n{F1C40F}Ár: {2ECC71}$%s", HouseData[id][Owner], id, HouseData[id][Name], HouseInteriors[ HouseData[id][Interior] ][IntName], convertNumber(HouseData[id][SalePrice]));
767		}else{
768			format(label, sizeof(label), "{E67E22}%s háza (ID: %d)\n{FFFFFF}%s\n{FFFFFF}%s\n%s\n{FFFFFF}%s", HouseData[id][Owner], id, HouseData[id][Name], HouseInteriors[ HouseData[id][Interior] ][IntName], LockNames[ HouseData[id][LockMode] ], HouseData[id][Address]);
769		}
770	}
771
772	UpdateDynamic3DTextLabelText(HouseData[id][HouseLabel], 0xFFFFFFFF, label);
773	return 1;
774}
775
776stock House_PlayerInit(playerid)
777{
778    InHouse[playerid] = LastVisitedHouse[playerid] = INVALID_HOUSE_ID;
779    ListPage[playerid] = SelectMode[playerid] = SELECT_MODE_NONE;
780    EditingFurniture[playerid] = false;
781    LoadHouseKeys(playerid);
782	return 1;
783}
784
785stock OwnedHouses(playerid)
786{
787	#if LIMIT_PER_PLAYER != 0
788    new count;
789    
790	foreach(new i : Houses) if(!strcmp(HouseData[i][Owner], Player_GetName(playerid), true)) count++;
791	return count;
792	#else
793	return 0;
794	#endif
795}
796
797forward ResetAndSaveHouses();
798forward LoadHouses();
799forward LoadFurnitures();
800forward GiveHouseKeys(playerid);
801forward HouseSaleMoney(playerid);
802
803public ResetAndSaveHouses()
804{
805	foreach(new i : Houses)
806	{
807	    if(HouseData[i][LastEntered] > 0 && gettime()-HouseData[i][LastEntered] > 604800) ResetHouse(i);
808	    if(HouseData[i][Save]) SaveHouse(i);
809	}
810
811	return 1;
812}
813
814public LoadHouses()
815{
816	new rows = cache_num_rows();
817 	if(rows)
818  	{
819   		new id, loaded, for_sale, label[256];
820		while(loaded < rows)
821		{
822  			id = cache_get_field_content_int(loaded, "ID");
823	    	cache_get_field_content(loaded, "HouseName", HouseData[id][Name], .max_len = MAX_HOUSE_NAME);
824		    cache_get_field_content(loaded, "HouseOwner", HouseData[id][Owner], .max_len = MAX_PLAYER_NAME);
825		    cache_get_field_content(loaded, "HousePassword", HouseData[id][Password], .max_len = MAX_HOUSE_PASSWORD);
826		    HouseData[id][houseX] = cache_get_field_content_float(loaded, "HouseX");
827		    HouseData[id][houseY] = cache_get_field_content_float(loaded, "HouseY");
828		    HouseData[id][houseZ] = cache_get_field_content_float(loaded, "HouseZ");
829		    HouseData[id][Price] = cache_get_field_content_int(loaded, "HousePrice");
830		    HouseData[id][SalePrice] = cache_get_field_content_int(loaded, "HouseSalePrice");
831		    HouseData[id][Interior] = cache_get_field_content_int(loaded, "HouseInterior");
832		    HouseData[id][LockMode] = cache_get_field_content_int(loaded, "HouseLock");
833		    HouseData[id][SafeMoney] = cache_get_field_content_int(loaded, "HouseMoney");
834		    HouseData[id][LastEntered] = cache_get_field_content_int(loaded, "LastEntered");
835			format(HouseData[id][Address], MAX_HOUSE_ADDRESS, "%d, %s, %s", id, GetZoneName(HouseData[id][houseX], HouseData[id][houseY], HouseData[id][houseZ]), GetCityName(HouseData[id][houseX], HouseData[id][houseY], HouseData[id][houseZ]));
836
837	        if(strcmp(HouseData[id][Owner], "-")) {
838	            if(HouseData[id][SalePrice] > 0) {
839	                for_sale = 1;
840				    format(label, sizeof(label), "{E67E22}%s háza eladó (ID: %d)\n{FFFFFF}%s\n{FFFFFF}%s\n{F1C40F}Ár: {2ECC71}$%s", HouseData[id][Owner], id, HouseData[id][Name], HouseInteriors[ HouseData[id][Interior] ][IntName], convertNumber(HouseData[id][SalePrice]));
841				}else{
842				    for_sale = 0;
843					format(label, sizeof(label), "{E67E22}%s háza (ID: %d)\n{FFFFFF}%s\n{FFFFFF}%s\n%s\n{FFFFFF}%s", HouseData[id][Owner], id, HouseData[id][Name], HouseInteriors[ HouseData[id][Interior] ][IntName], LockNames[ HouseData[id][LockMode] ], HouseData[id][Address]);
844				}
845			}else{
846			    for_sale = 1;
847         		format(label, sizeof(label), "{2ECC71}Eladó ház (ID: %d)\n{FFFFFF}%s\n{F1C40F}Ár: {2ECC71}$%s", id, HouseInteriors[ HouseData[id][Interior] ][IntName], convertNumber(HouseData[id][Price]));
848	        }
849
850			HouseData[id][HousePickup] = CreateDynamicPickup((!for_sale) ? 19522 : 1273, 1, HouseData[id][houseX], HouseData[id][houseY], HouseData[id][houseZ]);
851			HouseData[id][HouseIcon] = CreateDynamicMapIcon(HouseData[id][houseX], HouseData[id][houseY], HouseData[id][houseZ], (!for_sale) ? 32 : 31, 0);
852			HouseData[id][HouseLabel] = CreateDynamic3DTextLabel(label, 0xFFFFFFFF, HouseData[id][houseX], HouseData[id][houseY], HouseData[id][houseZ]+0.35, 15.0, .testlos = 1);
853			Iter_Add(Houses, id);
854		    loaded++;
855	    }
856
857	    printf(" [House System] %d ház betöltve.", loaded);
858	}
859
860	return 1;
861}
862
863public LoadFurnitures()
864{
865	new rows = cache_num_rows();
866 	if(rows)
867  	{
868   		new id, loaded, data[e_furniture];
869     	while(loaded < rows)
870      	{
871       		data[SQLID] = cache_get_field_content_int(loaded, "ID");
872         	data[HouseID] = cache_get_field_content_int(loaded, "HouseID");
873         	data[ArrayID] = cache_get_field_content_int(loaded, "FurnitureID");
874          	data[furnitureX] = cache_get_field_content_float(loaded, "FurnitureX");
875           	data[furnitureY] = cache_get_field_content_float(loaded, "FurnitureY");
876            data[furnitureZ] = cache_get_field_content_float(loaded, "FurnitureZ");
877            data[furnitureRX] = cache_get_field_content_float(loaded, "FurnitureRX");
878            data[furnitureRY] = cache_get_field_content_float(loaded, "FurnitureRY");
879            data[furnitureRZ] = cache_get_field_content_float(loaded, "FurnitureRZ");
880
881			id = CreateDynamicObject(
882   				HouseFurnitures[ data[ArrayID] ][ModelID],
883       			data[furnitureX], data[furnitureY], data[furnitureZ],
884          		data[furnitureRX], data[furnitureRY], data[furnitureRZ],
885				cache_get_field_content_int(loaded, "FurnitureVW"), cache_get_field_content_int(loaded, "FurnitureInt")
886			);
887
888			Streamer_SetArrayData(STREAMER_TYPE_OBJECT, id, E_STREAMER_EXTRA_ID, data);
889   			loaded++;
890 		}
891
892 		printf(" [House System] %d bútor betöltve.", loaded);
893   	}
894
895	return 1;
896}
897
898public GiveHouseKeys(playerid)
899{
900	if(!IsPlayerConnected(playerid)) return 1;
901	new rows = cache_num_rows();
902 	if(rows)
903  	{
904   		new loaded;
905     	while(loaded < rows)
906      	{
907       		Iter_Add(HouseKeys[playerid], cache_get_field_content_int(loaded, "HouseID"));
908   			loaded++;
909 		}
910   	}
911
912	return 1;
913}
914
915public HouseSaleMoney(playerid)
916{
917    new rows = cache_num_rows();
918 	if(rows)
919  	{
920   		new new_owner[MAX_PLAYER_NAME], price, string[128];
921		for(new i; i < rows; i++)
922		{
923	    	cache_get_field_content(i, "NewOwner", new_owner);
924		    price = cache_get_field_content_int(i, "Price");
925
926			format(string, sizeof(string), "Eladtad a házad %s-nek/nak $%s-ért. (Tranzakció ID: #%d)", new_owner, convertNumber(price), cache_get_field_content_int(i, "ID"));
927			SendClientMessage(playerid, -1, string);
928			GivePlayerMoney(playerid, price);
929	    }
930
931		new query[128];
932	    mysql_format(SQLHandle, query, sizeof(query), "DELETE FROM housesales WHERE OldOwner='%e'", Player_GetName(playerid));
933	    mysql_tquery(SQLHandle, query, "", "");
934	}
935
936	return 1;
937}
938
939public OnFilterScriptInit()
940{
941	for(new i; i < MAX_HOUSES; ++i)
942	{
943		HouseData[i][HouseLabel] = Text3D:INVALID_3DTEXT_ID;
944		HouseData[i][HousePickup] = -1;
945		HouseData[i][HouseIcon] = -1;
946		HouseData[i][Save] = false;
947	}
948
949	for(new i; i < sizeof(HouseInteriors); ++i)
950	{
951	    HouseInteriors[i][intLabel] = CreateDynamic3DTextLabel("Kijárat", 0xE67E22FF, HouseInteriors[i][intX], HouseInteriors[i][intY], HouseInteriors[i][intZ]+0.35, 10.0, .testlos = 1, .interiorid = HouseInteriors[i][intID]);
952		HouseInteriors[i][intPickup] = CreateDynamicPickup(1318, 1, HouseInteriors[i][intX], HouseInteriors[i][intY], HouseInteriors[i][intZ], .interiorid = HouseInteriors[i][intID]);
953	}
954
955	Iter_Init(HouseKeys);
956	DisableInteriorEnterExits();
957	SQLHandle = mysql_connect(SQL_HOST, SQL_USER, SQL_DBNAME, SQL_PASSWORD);
958	mysql_log(LOG_ERROR | LOG_WARNING, LOG_TYPE_HTML);
959	if(mysql_errno() != 0) return print(" [House System] Nem lehetett csatlakozni a MySQL adatbázishoz.");
960
961	/* Create Tables */
962	new query[1024];
963	strcat(query, "CREATE TABLE IF NOT EXISTS `houses` (\
964	  `ID` int(11) NOT NULL,\
965	  `HouseName` varchar(48) NOT NULL default 'Eladó ház',\
966	  `HouseOwner` varchar(24) NOT NULL default '-',\
967	  `HousePassword` varchar(16) NOT NULL default '-',\
968	  `HouseX` float NOT NULL,\
969	  `HouseY` float NOT NULL,\
970	  `HouseZ` float NOT NULL,\
971	  `HousePrice` int(11) NOT NULL,\
972	  `HouseInterior` tinyint(4) NOT NULL default '0',\
973	  `HouseLock` tinyint(4) NOT NULL default '0',\
974	  `HouseMoney` int(11) NOT NULL default '0',"
975 	);
976
977 	strcat(query, "`LastEntered` int(11) NOT NULL,\
978		  PRIMARY KEY  (`ID`),\
979		  UNIQUE KEY `ID_2` (`ID`),\
980		  KEY `ID` (`ID`)\
981		) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
982	);
983
984	mysql_tquery(SQLHandle, query, "", "");
985
986	mysql_tquery(SQLHandle, "CREATE TABLE IF NOT EXISTS `housefurnitures` (\
987	  `ID` int(11) NOT NULL auto_increment,\
988	  `HouseID` int(11) NOT NULL,\
989	  `FurnitureID` tinyint(11) NOT NULL,\
990	  `FurnitureX` float NOT NULL,\
991	  `FurnitureY` float NOT NULL,\
992	  `FurnitureZ` float NOT NULL,\
993	  `FurnitureRX` float NOT NULL,\
994	  `FurnitureRY` float NOT NULL,\
995	  `FurnitureRZ` float NOT NULL,\
996	  `FurnitureVW` int(11) NOT NULL,\
997	  `FurnitureInt` int(11) NOT NULL,\
998	  PRIMARY KEY  (`ID`)\
999	) ENGINE=MyISAM DEFAULT CHARSET=utf8;", "", "");
1000
1001	mysql_tquery(SQLHandle, "CREATE TABLE IF NOT EXISTS `houseguns` (\
1002	  `HouseID` int(11) NOT NULL,\
1003	  `WeaponID` tinyint(4) NOT NULL,\
1004	  `Ammo` int(11) NOT NULL,\
1005	  UNIQUE KEY `HouseID_2` (`HouseID`,`WeaponID`),\
1006	  KEY `HouseID` (`HouseID`),\
1007	  CONSTRAINT `houseguns_ibfk_1` FOREIGN KEY (`HouseID`) REFERENCES `houses` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE\
1008	) ENGINE=InnoDB DEFAULT CHARSET=utf8;", "", "");
1009
1010	mysql_tquery(SQLHandle, "CREATE TABLE IF NOT EXISTS `housevisitors` (\
1011	  `HouseID` int(11) NOT NULL,\
1012	  `Visitor` varchar(24) NOT NULL,\
1013	  `Date` int(11) NOT NULL\
1014	) ENGINE=MyISAM DEFAULT CHARSET=utf8;", "", "");
1015
1016	mysql_tquery(SQLHandle, "CREATE TABLE IF NOT EXISTS `housekeys` (\
1017	  `HouseID` int(11) NOT NULL,\
1018	  `Player` varchar(24) NOT NULL,\
1019	  `Date` int(11) NOT NULL\
1020	) ENGINE=MyISAM DEFAULT CHARSET=utf8;", "", "");
1021
1022	mysql_tquery(SQLHandle, "CREATE TABLE IF NOT EXISTS `housesafelogs` (\
1023	  `HouseID` int(11) NOT NULL,\
1024	  `Type` int(11) NOT NULL,\
1025	  `Amount` int(11) NOT NULL,\
1026	  `Date` int(11) NOT NULL\
1027	) ENGINE=MyISAM DEFAULT CHARSET=utf8;", "", "");
1028	
1029	mysql_tquery(SQLHandle, "CREATE TABLE IF NOT EXISTS `housesales` (\
1030	  `ID` int(11) NOT NULL AUTO_INCREMENT,\
1031	  `OldOwner` varchar(24) NOT NULL,\
1032	  `NewOwner` varchar(24) NOT NULL,\
1033	  `Price` int(11) NOT NULL,\
1034	  PRIMARY KEY (`ID`)\
1035	) ENGINE=MyISAM DEFAULT CHARSET=utf8;", "", "");
1036
1037	// 1.3 update, add HouseSalePrice to the houses table
1038	if(!fexist("house_updated.txt"))
1039	{
1040		mysql_tquery(SQLHandle, "ALTER TABLE houses ADD HouseSalePrice INT(11) NOT NULL AFTER HousePrice");
1041		
1042		new File: updateFile = fopen("house_updated.txt", io_append);
1043		if(updateFile)
1044		{
1045		    fwrite(updateFile, "Ne töröld ezt a fájlt.");
1046			fclose(updateFile);
1047		}
1048	}
1049	
1050	/* Loading & Stuff */
1051	mysql_tquery(SQLHandle, "SELECT * FROM houses", "LoadHouses", "");
1052	mysql_tquery(SQLHandle, "SELECT * FROM housefurnitures", "LoadFurnitures", "");
1053	foreach(new i : Player) House_PlayerInit(i);
1054
1055	HouseTimer = SetTimer("ResetAndSaveHouses", 10 * 60000, true);
1056	return 1;
1057}
1058
1059public OnFilterScriptExit()
1060{
1061	foreach(new i : Houses) if(HouseData[i][Save]) SaveHouse(i);
1062	KillTimer(HouseTimer);
1063	return 1;
1064}
1065
1066public OnPlayerConnect(playerid)
1067{
1068    House_PlayerInit(playerid);
1069	return 1;
1070}
1071
1072public OnPlayerSpawn(playerid)
1073{
1074	InHouse[playerid] = INVALID_HOUSE_ID;
1075	
1076	new query[128];
1077	mysql_format(SQLHandle, query, sizeof(query), "SELECT * FROM housesales WHERE OldOwner='%e'", Player_GetName(playerid));
1078	mysql_tquery(SQLHandle, query, "HouseSaleMoney", "i", playerid);
1079	return 1;
1080}
1081
1082public OnPlayerPickUpDynamicPickup(playerid, pickupid)
1083{
1084	if(GetPVarInt(playerid, "HousePickupCooldown") < gettime())
1085	{
1086	    if(InHouse[playerid] == INVALID_HOUSE_ID) {
1087			foreach(new i : Houses)
1088			{
1089			    if(pickupid == HouseData[i][HousePickup])
1090			    {
1091			        SetPVarInt(playerid, "HousePickupCooldown", gettime() + HOUSE_COOLDOWN);
1092			        SetPVarInt(playerid, "PickupHouseID", i);
1093			        
1094					if(!strcmp(HouseData[i][Owner], "-")) {
1095						new string[64];
1096						format(string, sizeof(string), "Eladó ház!\n\nÁr: {2ECC71}$%s", convertNumber(HouseData[i][Price]));
1097						ShowPlayerDialog(playerid, DIALOG_BUY_HOUSE, DIALOG_STYLE_MSGBOX, "Eladó ház", string, "Megveszem", "Bezárás");
1098					}else{
1099					    if(HouseData[i][SalePrice] > 0 && strcmp(HouseData[i][Owner], Player_GetName(playerid)))
1100					    {
1101                            new string[64];
1102							format(string, sizeof(string), "Eladó ház!\n\nÁr: {2ECC71}$%s", convertNumber(HouseData[i][SalePrice]));
1103							ShowPlayerDialog(playerid, DIALOG_BUY_HOUSE_FROM_OWNER, DIALOG_STYLE_MSGBOX, "Eladó ház", string, "Megveszem", "Bezárás");
1104							return 1;
1105					    }
1106					    
1107					    switch(HouseData[i][LockMode])
1108					    {
1109					        case LOCK_MODE_NOLOCK: SendToHouse(playerid, i);
1110					        case LOCK_MODE_PASSWORD: ShowPlayerDialog(playerid, DIALOG_HOUSE_PASSWORD, DIALOG_STYLE_INPUT, "Ház jelszó", "Ez a ház jelszóval van védve.\n\nÍrd be a ház jelszavát:", "Kész", "Bezárás");
1111							case LOCK_MODE_KEYS:
1112							{
1113							    new gotkeys = Iter_Contains(HouseKeys[playerid], i);
1114							    if(!gotkeys) if(!strcmp(HouseData[i][Owner], Player_GetName(playerid))) gotkeys = 1;
1115
1116								if(gotkeys) {
1117									SendToHouse(playerid, i);
1118								}else{
1119								    SendClientMessage(playerid, 0xE74C3CFF, "Nincs kulcsod a házhoz, nem tudsz bemenni.");
1120								}
1121							}
1122
1123					        case LOCK_MODE_OWNER:
1124					        {
1125								if(!strcmp(HouseData[i][Owner], Player_GetName(playerid))) {
1126								    SetPVarInt(playerid, "HousePickupCooldown", gettime() + HOUSE_COOLDOWN);
1127						            SendToHouse(playerid, i);
1128								}else{
1129								    SendClientMessage(playerid, 0xE74C3CFF, "Sajnálom, csak a tulaj mehet be a házba.");
1130								}
1131					        }
1132					    }
1133					}
1134
1135			        return 1;
1136			    }
1137			}
1138		}else{
1139			for(new i; i < sizeof(HouseInteriors); ++i)
1140			{
1141			    if(pickupid == HouseInteriors[i][intPickup])
1142			    {
1143			        SetPVarInt(playerid, "HousePickupCooldown", gettime() + HOUSE_COOLDOWN);
1144			        SetPlayerVirtualWorld(playerid, 0);
1145			        SetPlayerInterior(playerid, 0);
1146			        SetPlayerPos(playerid, HouseData[ InHouse[playerid] ][houseX], HouseData[ InHouse[playerid] ][houseY], HouseData[ InHouse[playerid] ][houseZ]);
1147			        InHouse[playerid] = INVALID_HOUSE_ID;
1148			        return 1;
1149			    }
1150			}
1151		}
1152	}
1153
1154	return 1;
1155}
1156
1157public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
1158{
1159	if(dialogid == DIALOG_BUY_HOUSE)
1160	{
1161		if(!response) return 1;
1162		new id = GetPVarInt(playerid, "PickupHouseID");
1163		if(!IsPlayerInRangeOfPoint(playerid, 2.0, HouseData[id][houseX], HouseData[id][houseY], HouseData[id][houseZ])) return SendClientMessage(playerid, 0xE74C3CFF, "You're not near any house.");
1164        #if LIMIT_PER_PLAYER > 0
1165		if(OwnedHouses(playerid) + 1 > LIMIT_PER_PLAYER) return SendClientMessage(playerid, 0xE74C3CFF, "Nem tudsz több házat vásárolni.");
1166		#endif
1167		if(HouseData[id][Price] > GetPlayerMoney(playerid)) return SendClientMessage(playerid, 0xE74C3CFF, "Ezt a házat nem engedheted meg magadnak.");
1168		if(strcmp(HouseData[id][Owner], "-")) return SendClientMessage(playerid, 0xE74C3CFF, "Már valaki birtokolja ezt a házat.");
1169		GivePlayerMoney(playerid, -HouseData[id][Price]);
1170		GetPlayerName(playerid, HouseData[id][Owner], MAX_PLAYER_NAME);
1171		HouseData[id][LastEntered] = gettime();
1172		HouseData[id][Save] = true;
1173
1174		UpdateHouseLabel(id);
1175		Streamer_SetIntData(STREAMER_TYPE_PICKUP, HouseData[id][HousePickup], E_STREAMER_MODEL_ID, 19522);
1176		Streamer_SetIntData(STREAMER_TYPE_MAP_ICON, HouseData[id][HouseIcon], E_STREAMER_TYPE, 32);
1177		SendToHouse(playerid, id);
1178		return 1;
1179	}
1180
1181	if(dialogid == DIALOG_HOUSE_PASSWORD)
1182	{
1183	    if(!response) return 1;
1184	    new id = GetPVarInt(playerid, "PickupHouseID");
1185		if(!IsPlayerInRangeOfPoint(playerid, 2.0, HouseData[id][houseX], HouseData[id][houseY], HouseData[id][houseZ])) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy ház közelében.");
1186		if(!(1 <= strlen(inputtext) <= MAX_HOUSE_PASSWORD)) return ShowPlayerDialog(playerid, DIALOG_HOUSE_PASSWORD, DIALOG_STYLE_INPUT, "Ház jelszó", "Ez a ház jelszóval van védve.\n\nÍrd be a ház jelszavát:\n\n{E74C3C}A jelszó vagy túl rövid vagy túl hosszú.", "Próbáld úrja", "Bezárás");
1187		if(strcmp(HouseData[id][Password], inputtext)) return ShowPlayerDialog(playerid, DIALOG_HOUSE_PASSWORD, DIALOG_STYLE_INPUT, "Ház jelszó", "Ez a ház jelszóval van védve.\n\nÍrd be a ház jelszavát:\n\n{E74C3C}Rossz jelszó.", "Próbáld úrja", "Bezárás");
1188		SendToHouse(playerid, id);
1189		return 1;
1190	}
1191
1192	if(dialogid == DIALOG_HOUSE_MENU)
1193	{
1194	    if(!response) return 1;
1195	    new id = InHouse[playerid];
1196	    if(id == INVALID_HOUSE_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy házban.");
1197		if(strcmp(HouseData[id][Owner], Player_GetName(playerid))) return SendClientMessage(playerid, 0xE74C3CFF, "Nem a tiéd ez a ház.");
1198
1199		if(listitem == 0) ShowPlayerDialog(playerid, DIALOG_HOUSE_NAME, DIALOG_STYLE_INPUT, "Ház név", "Írd be a ház új nevét:", "Változtat", "Vissza");
1200		if(listitem == 1) ShowPlayerDialog(playerid, DIALOG_HOUSE_NEW_PASSWORD, DIALOG_STYLE_INPUT, "Ház jelszó", "Írd be a ház új jelszavát:", "Változtat", "Vissza");
1201		if(listitem == 2) ShowPlayerDialog(playerid, DIALOG_HOUSE_LOCK, DIALOG_STYLE_LIST, "Ház zárás", "Nyitva\nJelszóval védve\nCsak kulcs\nCsak tulaj", "Változtat", "Vissza");
1202		if(listitem == 3)
1203		{
1204		    if(HouseData[id][SalePrice] > 0)
1205			{
1206				SendClientMessage(playerid, 0xE74C3CFF, "Ezt a lehetőséget nem használhatod, amíg a ház eladó.");
1207				return ShowHouseMenu(playerid);
1208			}
1209			
1210		    new string[144];
1211		    format(string, sizeof(string), "Pénz kivétel {2ECC71}($%s)\nPénz berakás {2ECC71}($%s)\nSzéf történet\nSzéf történet törlése", convertNumber(HouseData[id][SafeMoney]), convertNumber(GetPlayerMoney(playerid)));
1212			ShowPlayerDialog(playerid, DIALOG_SAFE_MENU, DIALOG_STYLE_LIST, "Ház széf", string, "Választ", "Vissza");
1213		}
1214
1215		if(listitem == 4)
1216		{
1217		    if(HouseData[id][SalePrice] > 0)
1218			{
1219				SendClientMessage(playerid, 0xE74C3CFF, "Ezt a lehetőséget nem használhatod, amíg a ház eladó.");
1220				return ShowHouseMenu(playerid);
1221			}
1222			
1223			ShowPlayerDialog(playerid, DIALOG_FURNITURE_MENU, DIALOG_STYLE_LIST, "Bútorok", "Bútor vétel\nBútor szerkesztés\nBútor eladása\nÖsszes bútor eladása", "Választ", "Vissza");
1224		}
1225		
1226		if(listitem == 5) ShowPlayerDialog(playerid, DIALOG_GUNS_MENU, DIALOG_STYLE_LIST, "Fegyverek", "Fegyver berakás\nFegyver kivétel", "Választ", "Vissza");
1227        if(listitem == 6)
1228		{
1229		    ListPage[playerid] = 0;
1230			ShowPlayerDialog(playerid, DIALOG_VISITORS_MENU, DIALOG_STYLE_LIST, "Látogatók", "Látogató történet\nLátogató történet törlése", "Választ", "Vissza");
1231		}
1232
1233		if(listitem == 7)
1234		{
1235		    ListPage[playerid] = 0;
1236			ShowPlayerDialog(playerid, DIALOG_KEYS_MENU, DIALOG_STYLE_LIST, "Kulcsok", "Kulcs tulajdonosok\nKulcsok törlése", "Választ", "Vissza");
1237		}
1238
1239		if(listitem == 8)
1240		{
1241		    new string[128];
1242		    format(string, sizeof(string), "Ház tulajdonos %s mindenkit kirúgott a házból.", HouseData[id][Owner]);
1243
1244			foreach(new i : Player)
1245			{
1246			    if(i == playerid) continue;
1247			    if(InHouse[i] == id)
1248			    {
1249		            SetPVarInt(i, "HousePickupCooldown", gettime() + HOUSE_COOLDOWN);
1250		        	SetPlayerVirtualWorld(i, 0);
1251			        SetPlayerInterior(i, 0);
1252			        SetPlayerPos(i, HouseData[id][houseX], HouseData[id][houseY], HouseData[id][houseZ]);
1253			        InHouse[i] = INVALID_HOUSE_ID;
1254			        SendClientMessage(i, -1, string);
1255			    }
1256			}
1257
1258			SendClientMessage(playerid, -1, "Mindenkit kirúgtál a házból.");
1259		}
1260
1261		if(listitem == 9)
1262		{
1263		    new string[128];
1264		    format(string, sizeof(string), "Azonnali eladás\t{2ECC71}$%s\n%s", convertNumber(floatround(HouseData[id][Price]*0.85)), (HouseData[id][SalePrice] > 0) ? ("Ház eladásának visszavonása") : ("Ház eladása"));
1265			ShowPlayerDialog(playerid, DIALOG_SELL_HOUSE, DIALOG_STYLE_TABLIST, "Ház eladás", string, "Választ", "Vissza");
1266		}
1267
1268		return 1;
1269	}
1270
1271	if(dialogid == DIALOG_HOUSE_NAME)
1272	{
1273	    if(!response) return ShowHouseMenu(playerid);
1274        new id = InHouse[playerid];
1275        if(id == INVALID_HOUSE_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy házban.");
1276		if(strcmp(HouseData[id][Owner], Player_GetName(playerid))) return SendClientMessage(playerid, 0xE74C3CFF, "Nem a tiéd a ház.");
1277		if(!(1 <= strlen(inputtext) <= MAX_HOUSE_NAME)) return ShowPlayerDialog(playerid, DIALOG_HOUSE_NAME, DIALOG_STYLE_INPUT, "Ház név", "Írd be a ház új nevét:\n\n{E74C3C}A név vagy túl hosszú vagy túl rövid.", "Változtat", "Vissza");
1278        format(HouseData[id][Name], MAX_HOUSE_NAME, "%s", inputtext);
1279        HouseData[id][Save] = true;
1280
1281        UpdateHouseLabel(id);
1282        ShowHouseMenu(playerid);
1283	    return 1;
1284	}
1285
1286	if(dialogid == DIALOG_HOUSE_NEW_PASSWORD)
1287	{
1288	    if(!response) return ShowHouseMenu(playerid);
1289        new id = InHouse[playerid];
1290        if(id == INVALID_HOUSE_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy házban.");
1291		if(strcmp(HouseData[id][Owner], Player_GetName(playerid))) return SendClientMessage(playerid, 0xE74C3CFF, "Nem a tiéd a ház.");
1292		if(!(1 <= strlen(inputtext) <= MAX_HOUSE_PASSWORD)) return ShowPlayerDialog(playerid, DIALOG_HOUSE_NEW_PASSWORD, DIALOG_STYLE_INPUT, "Ház Jelszó", "Írd be a ház új jelszavát:\n\n{E74C3C}A jelszó vagy túl hosszú vagy túl rövid.", "Változtat", "Vissza");
1293        format(HouseData[id][Password], MAX_HOUSE_PASSWORD, "%s", inputtext);
1294        HouseData[id][Save] = true;
1295        ShowHouseMenu(playerid);
1296	    return 1;
1297	}
1298
1299	if(dialogid == DIALOG_HOUSE_LOCK)
1300	{
1301	    if(!response) return ShowHouseMenu(playerid);
1302        new id = InHouse[playerid];
1303        if(id == INVALID_HOUSE_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy házban.");
1304		if(strcmp(HouseData[id][Owner], Player_GetName(playerid))) return SendClientMessage(playerid, 0xE74C3CFF, "Nem a tiéd a ház.");
1305		HouseData[id][LockMode] = listitem;
1306		HouseData[id][Save] = true;
1307
1308		UpdateHouseLabel(id);
1309        ShowHouseMenu(playerid);
1310	    return 1;
1311	}
1312
1313	if(dialogid == DIALOG_SAFE_MENU)
1314	{
1315	    if(!response) return ShowHouseMenu(playerid);
1316	    new id = InHouse[playerid];
1317        if(id == INVALID_HOUSE_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy házban.");
1318		if(strcmp(HouseData[id][Owner], Player_GetName(playerid))) return SendClientMessage(playerid, 0xE74C3CFF, "Nem a tiéd a ház.");
1319		if(HouseData[id][SalePrice] > 0) return SendClientMessage(playerid, 0xE74C3CFF, "Ezt a lehetőséget nem használhatod, amíg a ház eladó.");
1320		if(listitem == 0) ShowPlayerDialog(playerid, DIALOG_SAFE_TAKE, DIALOG_STYLE_INPUT, "Széf: Pénz kivétel", "Írd be az összeget, amit ki szeretnél venni a széfből:", "Kivesz", "Vissza");
1321		if(listitem == 1) ShowPlayerDialog(playerid, DIALOG_SAFE_PUT, DIALOG_STYLE_INPUT, "Széf: Pénz berakás", "Írd be az összeget, amit be szeretnél rakni a széfbe:", "Berak", "Vissza");
1322        if(listitem == 2)
1323        {
1324			ListPage[playerid] = 0;
1325
1326            new query[200], Cache: safelog;
1327		    mysql_format(SQLHandle, query, sizeof(query), "SELECT Type, Amount, FROM_UNIXTIME(Date, '%%d/%%m/%%Y %%H:%%i') as TransactionDate FROM housesafelogs WHERE HouseID=%d ORDER BY Date DESC LIMIT 0, 15", id);
1328			safelog = mysql_query(SQLHandle, query);
1329			new rows = cache_num_rows();
1330			if(rows) {
1331			    new list[1024], date[20];
1332			    format(list, sizeof(list), "Action\tDate\n");
1333			    for(new i; i < rows; ++i)
1334			    {
1335		        	cache_get_field_content(i, "TransactionDate", date);
1336			        format(list, sizeof(list), "%s%s $%s\t{FFFFFF}%s\n", list, TransactionNames[ cache_get_field_content_int(i, "Type") ], convertNumber(cache_get_field_content_int(i, "Amount")), date);
1337			    }
1338
1339			    ShowPlayerDialog(playerid, DIALOG_SAFE_HISTORY, DIALOG_STYLE_TABLIST_HEADERS, "Széf történet (1. oldal)", list, "Következő", "Előző");
1340			}else{
1341				SendClientMessage(playerid, 0xE74C3CFF, "Nincsen széf történet.");
1342			}
1343
1344		    cache_delete(safelog);
1345        }
1346
1347        if(listitem == 3)
1348		{
1349		    new query[64];
1350		    mysql_format(SQLHandle, query, sizeof(query), "DELETE FROM housesafelogs WHERE HouseID=%d", id);
1351    		mysql_tquery(SQLHandle, query, "", "");
1352    		ShowHouseMenu(playerid);
1353		}
1354
1355		return 1;
1356	}
1357
1358	if(dialogid == DIALOG_SAFE_TAKE)
1359	{
1360	    if(!response) return ShowHouseMenu(playerid);
1361        new id = InHouse[playerid];
1362        if(id == INVALID_HOUSE_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy házban.");
1363		if(strcmp(HouseData[id][Owner], Player_GetName(playerid))) return SendClientMessage(playerid, 0xE74C3CFF, "Nem a tiéd a ház.");
1364		if(HouseData[id][SalePrice] > 0) return SendClientMessage(playerid, 0xE74C3CFF, "Ezt a lehetőséget nem használhatod, amíg a ház eladó.");
1365        new amount = strval(inputtext);
1366		if(!(1 <= amount <= 10000000)) return ShowPlayerDialog(playerid, DIALOG_SAFE_TAKE, DIALOG_STYLE_INPUT, "Széf: Pénz kivétel", "Írd be az összeget, amit ki szeretnél venni a széfből:\n\n{E74C3C}Hibás összeg. Egyszerre $1 - $10,000,000 között vehetsz ki a széfből.", "Kivesz", "Vissza");
1367		if(amount > HouseData[id][SafeMoney]) return ShowPlayerDialog(playerid, DIALOG_SAFE_TAKE, DIALOG_STYLE_INPUT, "Széf: Pénz kivétel", "Írd be az összeget, amit ki szeretnél venni a széfből:\n\n{E74C3C}Nincs ennyi pénz a széfedben.", "Kivesz", "Vissza");
1368        new query[128];
1369		mysql_format(SQLHandle, query, sizeof(query), "INSERT INTO housesafelogs SET HouseID=%d, Type=0, Amount=%d, Date=UNIX_TIMESTAMP()", id, amount);
1370		mysql_tquery(SQLHandle, query, "", "");
1371
1372		GivePlayerMoney(playerid, amount);
1373		HouseData[id][SafeMoney] -= amount;
1374		HouseData[id][Save] = true;
1375		ShowHouseMenu(playerid);
1376	    return 1;
1377	}
1378
1379	if(dialogid == DIALOG_SAFE_PUT)
1380	{
1381	    if(!response) return ShowHouseMenu(playerid);
1382        new id = InHouse[playerid];
1383        if(id == INVALID_HOUSE_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy házban.");
1384		if(strcmp(HouseData[id][Owner], Player_GetName(playerid))) return SendClientMessage(playerid, 0xE74C3CFF, "Nem a tiéd a ház.");
1385        new amount = strval(inputtext);
1386		if(!(1 <= amount <= 10000000)) return ShowPlayerDialog(playerid, DIALOG_SAFE_PUT, DIALOG_STYLE_INPUT, "Széf: Pénz berakás", "Írd be az összeget, amit be szeretnél rakni a széfbe:\n\n{E74C3C}Hibás összeg. Egyszerre $1 - $10,000,000 között rakhatsz be a széfbe.", "Berak", "Vissza");
1387		if(amount > GetPlayerMoney(playerid)) return ShowPlayerDialog(playerid, DIALOG_SAFE_PUT, DIALOG_STYLE_INPUT, "Széf: Pénz berakás", "Írd be az összeget, amit be szeretnél rakni a széfbe:\n\n{E74C3C}Nincs nálad ennyi készpénz.", "Berak", "Vissza");
1388        new query[128];
1389		mysql_format(SQLHandle, query, sizeof(query), "INSERT INTO housesafelogs SET HouseID=%d, Type=1, Amount=%d, Date=UNIX_TIMESTAMP()", id, amount);
1390		mysql_tquery(SQLHandle, query, "", "");
1391
1392		GivePlayerMoney(playerid, -amount);
1393		HouseData[id][SafeMoney] += amount;
1394		HouseData[id][Save] = true;
1395		ShowHouseMenu(playerid);
1396	    return 1;
1397	}
1398
1399	if(dialogid == DIALOG_GUNS_MENU)
1400	{
1401		if(!response) return ShowHouseMenu(playerid);
1402		new id = InHouse[playerid];
1403        if(id == INVALID_HOUSE_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy házban.");
1404		if(strcmp(HouseData[id][Owner], Player_GetName(playerid))) return SendClientMessage(playerid, 0xE74C3CFF, "Nem a tiéd a ház.");
1405		if(listitem == 0)
1406		{
1407			if(GetPlayerWeapon(playerid) == 0) return SendClientMessage(playerid, 0xE74C3CFF, "Nem rakhatod be az öklödet a széfbe.");
1408			new query[128], weapon = GetPlayerWeapon(playerid), ammo = GetPlayerAmmo(playerid);
1409            RemovePlayerWeapon(playerid, weapon);
1410			mysql_format(SQLHandle, query, sizeof(query), "INSERT INTO houseguns VALUES (%d, %d, %d) ON DUPLICATE KEY UPDATE Ammo=Ammo+%d", id, weapon, ammo, ammo);
1411			mysql_tquery(SQLHandle, query, "", "");
1412			ShowHouseMenu(playerid);
1413		}
1414
1415		if(listitem == 1)
1416		{
1417		    new query[80], Cache: weapons;
1418		    mysql_format(SQLHandle, query, sizeof(query), "SELECT WeaponID, Ammo FROM houseguns WHERE HouseID=%d ORDER BY WeaponID ASC", id);
1419			weapons = mysql_query(SQLHandle, query);
1420			new rows = cache_num_rows();
1421			if(rows) {
1422			    new list[512], weapname[32];
1423			    format(list, sizeof(list), "#\tFegyver név\tLőszer\n");
1424			    for(new i; i < rows; ++i)
1425			    {
1426			        GetWeaponName(cache_get_field_content_int(i, "WeaponID"), weapname, sizeof(weapname));
1427			        format(list, sizeof(list), "%s%d\t%s\t%s\n", list, i+1, weapname, convertNumber(cache_get_field_content_int(i, "Ammo")));
1428			    }
1429
1430			    ShowPlayerDialog(playerid, DIALOG_GUNS_TAKE, DIALOG_STYLE_TABLIST_HEADERS, "Ház fegyverek", list, "Take", "Vissza");
1431			}else{
1432				SendClientMessage(playerid, 0xE74C3CFF, "Nincs fegyver a házban.");
1433			}
1434
1435		    cache_delete(weapons);
1436		}
1437
1438		return 1;
1439	}
1440
1441	if(dialogid == DIALOG_GUNS_TAKE)
1442	{
1443		if(!response) return ShowHouseMenu(playerid);
1444		new id = InHouse[playerid];
1445        if(id == INVALID_HOUSE_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy házban.");
1446		if(strcmp(HouseData[id][Owner], Player_GetName(playerid))) return SendClientMessage(playerid, 0xE74C3CFF, "Nem a tiéd a ház.");
1447  		new query[96], Cache: weapon;
1448    	mysql_format(SQLHandle, query, sizeof(query), "SELECT WeaponID, Ammo FROM houseguns WHERE HouseID=%d ORDER BY WeaponID ASC LIMIT %d, 1", id, listitem);
1449		weapon = mysql_query(SQLHandle, query);
1450		new rows = cache_num_rows();
1451		if(rows) {
1452  			new string[64], weapname[32], weaponid = cache_get_field_content_int(0, "WeaponID");
1453  			GetWeaponName(weaponid, weapname, sizeof(weapname));
1454  			GivePlayerWeapon(playerid, weaponid, cache_get_field_content_int(0, "Ammo"));
1455			format(string, sizeof(string), "Kivettél a házből egy %s-t.", weapname);
1456			SendClientMessage(playerid, 0xFFFFFFFF, string);
1457			mysql_format(SQLHandle, query, sizeof(query), "DELETE FROM houseguns WHERE HouseID=%d AND WeaponID=%d", id, weaponid);
1458			mysql_tquery(SQLHandle, query, "", "");
1459		}else{
1460			SendClientMessage(playerid, 0xE74C3CFF, "Nincs fegyver a házban.");
1461		}
1462
1463		cache_delete(weapon);
1464		return 1;
1465	}
1466
1467    if(dialogid == DIALOG_FURNITURE_MENU)
1468	{
1469	    if(!response) return ShowHouseMenu(playerid);
1470        new id = InHouse[playerid];
1471        if(id == INVALID_HOUSE_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy házban.");
1472		if(strcmp(HouseData[id][Owner], Player_GetName(playerid))) return SendClientMessage(playerid, 0xE74C3CFF, "Nem a tiéd a ház.");
1473		if(HouseData[id][SalePrice] > 0) return SendClientMessage(playerid, 0xE74C3CFF, "Ezt a lehetőséget nem használhatod, amíg a ház eladó.");
1474
1475		if(listitem == 0)
1476		{
1477		    new list[512];
1478		    format(list, sizeof(list), "#\tBútor név\tÁr\n");
1479		    for(new i; i < sizeof(HouseFurnitures); ++i)
1480		    {
1481		        format(list, sizeof(list), "%s%d\t%s\t$%s\n", list, i+1, HouseFurnitures[i][Name], convertNumber(HouseFurnitures[i][Price]));
1482		    }
1483
1484		    ShowPlayerDialog(playerid, DIALOG_FURNITURE_BUY, DIALOG_STYLE_TABLIST_HEADERS, "Bútor vétel", list, "Megvesz", "Vissza");
1485		}
1486
1487		if(listitem == 1)
1488		{
1489			SelectMode[playerid] = SELECT_MODE_EDIT;
1490		    SelectObject(playerid);
1491		    SendClientMessage(playerid, 0xFFFFFFFF, "Kattints arra a bútorra, amit szerkeszteni szeretnél.");
1492		}
1493
1494		if(listitem == 2)
1495		{
1496		    SelectMode[playerid] = SELECT_MODE_SELL;
1497		    SelectObject(playerid);
1498		    SendClientMessage(playerid, 0xFFFFFFFF, "Kattints arra a bútorra, amit elszeretnél adni.");
1499		}
1500
1501		if(listitem == 3)
1502		{
1503		    new money, sold, data[e_furniture], query[64];
1504		    for(new i; i < Streamer_GetUpperBound(STREAMER_TYPE_OBJECT); ++i)
1505		    {
1506		        if(!IsValidDynamicObject(i)) continue;
1507				Streamer_GetArrayData(STREAMER_TYPE_OBJECT, i, E_STREAMER_EXTRA_ID, data);
1508				if(data[SQLID] > 0 && data[HouseID] == id)
1509				{
1510				    sold++;
1511				    money += HouseFurnitures[ data[ArrayID] ][Price];
1512					DestroyDynamicObject(i);
1513				}
1514		    }
1515
1516		    new string[64];
1517		    format(string, sizeof(string), "Eladva %d bútor összesen $%s-ért.", sold, convertNumber(money));
1518		    SendClientMessage(playerid, -1, string);
1519		    GivePlayerMoney(playerid, money);
1520
1521		    mysql_format(SQLHandle, query, sizeof(query), "DELETE FROM housefurnitures WHERE HouseID=%d", id);
1522		    mysql_tquery(SQLHandle, query, "", "");
1523		}
1524
1525	    return 1;
1526	}
1527
1528	if(dialogid == DIALOG_FURNITURE_BUY)
1529	{
1530	    if(!response) return ShowHouseMenu(playerid);
1531        new id = InHouse[playerid];
1532        if(id == INVALID_HOUSE_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy házban.");
1533		if(strcmp(HouseData[id][Owner], Player_GetName(playerid))) return SendClientMessage(playerid, 0xE74C3CFF, "Nem a tiéd a ház.");
1534		if(HouseData[id][SalePrice] > 0) return SendClientMessage(playerid, 0xE74C3CFF, "Ezt a lehetőséget nem használhatod, amíg a ház eladó.");
1535		if(HouseFurnitures[listitem][Price] > GetPlayerMoney(playerid)) return SendClientMessage(playerid, 0xE74C3CFF, "Ezt a bútort nem engedheted meg magadnak.");
1536		GivePlayerMoney(playerid, -HouseFurnitures[listitem][Price]);
1537		new Float: x, Float: y, Float: z;
1538		GetPlayerPos(playerid, x, y, z);
1539        GetXYInFrontOfPlayer(playerid, x, y, 3.0);
1540        new objectid = CreateDynamicObject(HouseFurnitures[listitem][ModelID], x, y, z, 0.0, 0.0, 0.0, GetPlayerVirtualWorld(playerid), GetPlayerInterior(playerid)), query[256];
1541		mysql_format(SQLHandle, query, sizeof(query), "INSERT INTO housefurnitures SET HouseID=%d, FurnitureID=%d, FurnitureX=%f, FurnitureY=%f, FurnitureZ=%f, FurnitureVW=%d, FurnitureInt=%d", id, listitem, x, y, z, GetPlayerVirtualWorld(playerid), GetPlayerInterior(playerid));
1542        new Cache: add = mysql_query(SQLHandle, query), data[e_furniture];
1543        data[SQLID] = cache_insert_id();
1544		data[HouseID] = id;
1545        data[ArrayID] = listitem;
1546		data[furnitureX] = x;
1547		data[furnitureY] = y;
1548		data[furnitureZ] = z;
1549		data[furnitureRX] = 0.0;
1550		data[furnitureRY] = 0.0;
1551		data[furnitureRZ] = 0.0;
1552		cache_delete(add);
1553		Streamer_SetArrayData(STREAMER_TYPE_OBJECT, objectid, E_STREAMER_EXTRA_ID, data);
1554		
1555		EditingFurniture[playerid] = true;
1556		EditDynamicObject(playerid, objectid);
1557		return 1;
1558	}
1559
1560	if(dialogid == DIALOG_FURNITURE_SELL)
1561	{
1562	    if(!response) return 1;
1563        new id = InHouse[playerid];
1564        if(id == INVALID_HOUSE_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy házban.");
1565		if(strcmp(HouseData[id][Owner], Player_GetName(playerid))) return SendClientMessage(playerid, 0xE74C3CFF, "Nem a tiéd a ház.");
1566		if(HouseData[id][SalePrice] > 0) return SendClientMessage(playerid, 0xE74C3CFF, "Ezt a lehetőséget nem használhatod, amíg a ház eladó.");
1567		new objectid = GetPVarInt(playerid, "SelectedFurniture"), query[64], data[e_furniture];
1568		Streamer_GetArrayData(STREAMER_TYPE_OBJECT, objectid, E_STREAMER_EXTRA_ID, data);
1569		GivePlayerMoney(playerid, HouseFurnitures[ data[ArrayID] ][Price]);
1570		mysql_format(SQLHandle, query, sizeof(query), "DELETE FROM housefurnitures WHERE ID=%d", data[SQLID]);
1571		mysql_tquery(SQLHandle, query, "", "");
1572		DestroyDynamicObject(objectid);
1573		DeletePVar(playerid, "SelectedFurniture");
1574		return 1;
1575	}
1576
1577	if(dialogid == DIALOG_VISITORS_MENU)
1578	{
1579		if(!response) return ShowHouseMenu(playerid);
1580		new id = InHouse[playerid];
1581        if(id == INVALID_HOUSE_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy házban.");
1582		if(strcmp(HouseData[id][Owner], Player_GetName(playerid))) return SendClientMessage(playerid, 0xE74C3CFF, "Nem a tiéd a ház.");
1583		if(listitem == 0)
1584		{
1585		    new query[200], Cache: visitors;
1586		    mysql_format(SQLHandle, query, sizeof(query), "SELECT Visitor, FROM_UNIXTIME(Date, '%%d/%%m/%%Y %%H:%%i') as VisitDate FROM housevisitors WHERE HouseID=%d ORDER BY Date DESC LIMIT 0, 15", id);
1587			visitors = mysql_query(SQLHandle, query);
1588			new rows = cache_num_rows();
1589			if(rows) {
1590			    new list[1024], visitor_name[MAX_PLAYER_NAME], visit_date[20];
1591			    format(list, sizeof(list), "Látogató neve\tMikor\n");
1592			    for(new i; i < rows; ++i)
1593			    {
1594			        cache_get_field_content(i, "Visitor", visitor_name);
1595			        cache_get_field_content(i, "VisitDate", visit_date);
1596			        format(list, sizeof(list), "%s%s\t%s\n", list, visitor_name, visit_date);
1597			    }
1598
1599			    ShowPlayerDialog(playerid, DIALOG_VISITORS, DIALOG_STYLE_TABLIST_HEADERS, "Ház látogatói (1. oldal)", list, "Következő", "Előző");
1600			}else{
1601				SendClientMessage(playerid, 0xE74C3CFF, "Még nem volt látogatód.");
1602			}
1603
1604		    cache_delete(visitors);
1605		}
1606
1607		if(listitem == 1)
1608		{
1609		    new query[64];
1610		    mysql_format(SQLHandle, query, sizeof(query), "DELETE FROM housevisitors WHERE HouseID=%d", id);
1611    		mysql_tquery(SQLHandle, query, "", "");
1612    		ShowHouseMenu(playerid);
1613		}
1614
1615		return 1;
1616	}
1617
1618	if(dialogid == DIALOG_VISITORS)
1619	{
1620		if(!response) {
1621			ListPage[playerid]--;
1622			if(ListPage[playerid] < 0)
1623			{
1624			    ListPage[playerid] = 0;
1625			    ShowHouseMenu(playerid);
1626			    return 1;
1627			}
1628		}else{
1629		    ListPage[playerid]++;
1630		}
1631
1632		new id = InHouse[playerid];
1633        if(id == INVALID_HOUSE_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy házban.");
1634		if(strcmp(HouseData[id][Owner], Player_GetName(playerid))) return SendClientMessage(playerid, 0xE74C3CFF, "Nem a tiéd a ház.");
1635  		new query[200], Cache: visitors;
1636    	mysql_format(SQLHandle, query, sizeof(query), "SELECT Visitor, FROM_UNIXTIME(Date, '%%d/%%m/%%Y %%H:%%i') as VisitDate FROM housevisitors WHERE HouseID=%d ORDER BY Date DESC LIMIT %d, 15", id, ListPage[playerid]*15);
1637		visitors = mysql_query(SQLHandle, query);
1638		new rows = cache_num_rows();
1639		if(rows) {
1640  			new list[1024], visitor_name[MAX_PLAYER_NAME], visit_date[20];
1641	    	format(list, sizeof(list), "Látogató neve\tMikor\n");
1642		    for(new i; i < rows; ++i)
1643		    {
1644      			cache_get_field_content(i, "Visitor", visitor_name);
1645	        	cache_get_field_content(i, "VisitDate", visit_date);
1646		        format(list, sizeof(list), "%s%s\t%s\n", list, visitor_name, visit_date);
1647		    }
1648
1649			new title[32];
1650			format(title, sizeof(title), "Ház látogatói (%d. oldal)", ListPage[playerid]+1);
1651			ShowPlayerDialog(playerid, DIALOG_VISITORS, DIALOG_STYLE_TABLIST_HEADERS, title, list, "Következő", "Előző");
1652		}else{
1653			SendClientMessage(playerid, 0xE74C3CFF, "Még nem volt látogatód.");
1654			ListPage[playerid] = 0;
1655   			ShowHouseMenu(playerid);
1656		}
1657
1658		cache_delete(visitors);
1659		return 1;
1660	}
1661
1662	if(dialogid == DIALOG_KEYS_MENU)
1663	{
1664		if(!response) return ShowHouseMenu(playerid);
1665		new id = InHouse[playerid];
1666        if(id == INVALID_HOUSE_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy házban.");
1667		if(strcmp(HouseData[id][Owner], Player_GetName(playerid))) return SendClientMessage(playerid, 0xE74C3CFF, "Nem a tiéd a ház.");
1668		if(listitem == 0)
1669		{
1670		    new query[200], Cache: keyowners;
1671		    mysql_format(SQLHandle, query, sizeof(query), "SELECT Player, FROM_UNIXTIME(Date, '%%d/%%m/%%Y %%H:%%i') as KeyDate FROM housekeys WHERE HouseID=%d ORDER BY Date DESC LIMIT %d, 15", id, ListPage[playerid]*15);
1672			keyowners = mysql_query(SQLHandle, query);
1673			new rows = cache_num_rows();
1674			if(rows) {
1675			    new list[1024], key_name[MAX_PLAYER_NAME], key_date[20];
1676			    format(list, sizeof(list), "Kulcs tulaj\tKulcs odaadva\n");
1677			    for(new i; i < rows; ++i)
1678			    {
1679			        cache_get_field_content(i, "Player", key_name);
1680			        cache_get_field_content(i, "KeyDate", key_date);
1681			        format(list, sizeof(list), "%s%s\t%s\n", list, key_name, key_date);
1682			    }
1683
1684			    ShowPlayerDialog(playerid, DIALOG_KEYS, DIALOG_STYLE_TABLIST_HEADERS, "Kulcs tulajok (1. oldal)", list, "Következő", "Előző");
1685			}else{
1686				SendClientMessage(playerid, 0xE74C3CFF, "Nincsen kulcs tulaj.");
1687			}
1688
1689		    cache_delete(keyowners);
1690		}
1691
1692		if(listitem == 1)
1693		{
1694		    foreach(new i : Player)
1695		    {
1696		        if(Iter_Contains(HouseKeys[i], id)) Iter_Remove(HouseKeys[i], id);
1697		    }
1698
1699		    new query[64];
1700		    mysql_format(SQLHandle, query, sizeof(query), "DELETE FROM housekeys WHERE HouseID=%d", id);
1701    		mysql_tquery(SQLHandle, query, "", "");
1702    		ShowHouseMenu(playerid);
1703		}
1704
1705		return 1;
1706	}
1707
1708	if(dialogid == DIALOG_KEYS)
1709	{
1710	    if(!response) {
1711			ListPage[playerid]--;
1712			if(ListPage[playerid] < 0)
1713			{
1714			    ListPage[playerid] = 0;
1715			    ShowHouseMenu(playerid);
1716			    return 1;
1717			}
1718		}else{
1719		    ListPage[playerid]++;
1720		}
1721
1722		new id = InHouse[playerid];
1723        if(id == INVALID_HOUSE_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy házban.");
1724		if(strcmp(HouseData[id][Owner], Player_GetName(playerid))) return SendClientMessage(playerid, 0xE74C3CFF, "Nem a tiéd a ház.");
1725        new query[200], Cache: keyowners;
1726  		mysql_format(SQLHandle, query, sizeof(query), "SELECT Player, FROM_UNIXTIME(Date, '%%d/%%m/%%Y %%H:%%i') as KeyDate FROM housekeys WHERE HouseID=%d ORDER BY Date DESC LIMIT %d, 15", id, ListPage[playerid]*15);
1727		keyowners = mysql_query(SQLHandle, query);
1728		new rows = cache_num_rows();
1729		if(rows) {
1730  			new list[1024], key_name[MAX_PLAYER_NAME], key_date[20];
1731	    	format(list, sizeof(list), "Kulcs tulaj\tKulcs odaadva\n");
1732		    for(new i; i < rows; ++i)
1733		    {
1734      			cache_get_field_content(i, "Player", key_name);
1735	        	cache_get_field_content(i, "KeyDate", key_date);
1736		        format(list, sizeof(list), "%s%s\t%s\n", list, key_name, key_date);
1737		    }
1738
1739            new title[32];
1740			format(title, sizeof(title), "Kulcs tulajok (%d. oldal)", ListPage[playerid]+1);
1741			ShowPlayerDialog(playerid, DIALOG_KEYS, DIALOG_STYLE_TABLIST_HEADERS, title, list, "Következő", "Előző");
1742		}else{
1743		    ListPage[playerid] = 0;
1744   			ShowHouseMenu(playerid);
1745			SendClientMessage(playerid, 0xE74C3CFF, "Nincsen kulcs tulaj.");
1746		}
1747
1748		cache_delete(keyowners);
1749	    return 1;
1750	}
1751
1752	if(dialogid == DIALOG_SAFE_HISTORY)
1753	{
1754	    if(!response) {
1755			ListPage[playerid]--;
1756			if(ListPage[playerid] < 0)
1757			{
1758			    ListPage[playerid] = 0;
1759			    ShowHouseMenu(playerid);
1760			    return 1;
1761			}
1762		}else{
1763		    ListPage[playerid]++;
1764		}
1765
1766		new id = InHouse[playerid];
1767        if(id == INVALID_HOUSE_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy házban.");
1768		if(strcmp(HouseData[id][Owner], Player_GetName(playerid))) return SendClientMessage(playerid, 0xE74C3CFF, "Nem a tiéd a ház.");
1769        new query[200], Cache: safelog;
1770  		mysql_format(SQLHandle, query, sizeof(query), "SELECT Type, Amount, FROM_UNIXTIME(Date, '%%d/%%m/%%Y %%H:%%i') as TransactionDate FROM housesafelogs WHERE HouseID=%d ORDER BY Date DESC LIMIT %d, 15", id, ListPage[playerid]*15);
1771		safelog = mysql_query(SQLHandle, query);
1772		new rows = cache_num_rows();
1773		if(rows) {
1774  			new list[1024], date[20];
1775	    	format(list, sizeof(list), "Tevékenység\tMikor\n");
1776		    for(new i; i < rows; ++i)
1777		    {
1778	        	cache_get_field_content(i, "TransactionDate", date);
1779		        format(list, sizeof(list), "%s%s $%s\t{FFFFFF}%s\n", list, TransactionNames[ cache_get_field_content_int(i, "Type") ], convertNumber(cache_get_field_content_int(i, "Amount")), date);
1780		    }
1781
1782            new title[32];
1783			format(title, sizeof(title), "Széf történet (%d. oldal)", ListPage[playerid]+1);
1784			ShowPlayerDialog(playerid, DIALOG_SAFE_HISTORY, DIALOG_STYLE_TABLIST_HEADERS, title, list, "Következő", "Előző");
1785		}else{
1786			SendClientMessage(playerid, 0xE74C3CFF, "Nincs széf történet.");
1787		}
1788
1789		cache_delete(safelog);
1790	    return 1;
1791	}
1792
1793	if(dialogid == DIALOG_MY_KEYS)
1794	{
1795	    if(!response) {
1796			ListPage[playerid]--;
1797			if(ListPage[playerid] < 0)
1798			{
1799			    ListPage[playerid] = 0;
1800			    return 1;
1801			}
1802		}else{
1803		    ListPage[playerid]++;
1804		}
1805
1806        new query[200], Cache: mykeys;
1807	    mysql_format(SQLHandle, query, sizeof(query), "SELECT HouseID, FROM_UNIXTIME(Date, '%%d/%%m/%%Y %%H:%%i') as KeyDate FROM housekeys WHERE Player='%e' ORDER BY Date DESC LIMIT %d, 15", Player_GetName(playerid), ListPage[playerid]*15);
1808		mykeys = mysql_query(SQLHandle, query);
1809
1810		new rows = cache_num_rows();
1811		if(rows) {
1812  			new list[1024], id, key_date[20];
1813	   		format(list, sizeof(list), "Ház információ\tKulcs odaadva\n");
1814		    for(new i; i < rows; ++i)
1815		    {
1816		        id = cache_get_field_content_int(i, "HouseID");
1817	       		cache_get_field_content(i, "KeyDate", key_date);
1818		        format(list, sizeof(list), "%s%s háza %s\t%s\n", list, HouseData[id][Owner], HouseData[id][Name], key_date);
1819		    }
1820
1821            new title[32];
1822			format(title, sizeof(title), "Kulcsaim (%d. oldal)", ListPage[playerid]+1);
1823			ShowPlayerDialog(playerid, DIALOG_MY_KEYS, DIALOG_STYLE_TABLIST_HEADERS, title, list, "Következő", "Előző");
1824		}else{
1825		    ListPage[playerid] = 0;
1826			SendClientMessage(playerid, 0xE74C3CFF, "Nincs kulcsod.");
1827		}
1828
1829		cache_delete(mykeys);
1830	    return 1;
1831	}
1832	
1833	if(dialogid == DIALOG_BUY_HOUSE_FROM_OWNER)
1834	{
1835		if(!response) return 1;
1836		new id = GetPVarInt(playerid, "PickupHouseID");
1837		if(!IsPlayerInRangeOfPoint(playerid, 2.0, HouseData[id][houseX], HouseData[id][houseY], HouseData[id][houseZ])) return SendClientMessage(playerid, 0xE74C3CFF, "You're not near any house.");
1838        #if LIMIT_PER_PLAYER > 0
1839		if(OwnedHouses(playerid) + 1 > LIMIT_PER_PLAYER) return SendClientMessage(playerid, 0xE74C3CFF, "Nem tudsz több házat vásárolni.");
1840		#endif
1841		if(HouseData[id][SalePrice] > GetPlayerMoney(playerid)) return SendClientMessage(playerid, 0xE74C3CFF, "Ezt a házat nem engedheted meg magadnak.");
1842		if(HouseData[id][SalePrice] < 1) return SendClientMessage(playerid, 0xE74C3CFF, "Már valaki birtokolja ezt a házat.");
1843  		new old_owner[MAX_PLAYER_NAME], price = HouseData[id][SalePrice], owner_id = INVALID_PLAYER_ID;
1844  		format(old_owner, MAX_PLAYER_NAME, "%s", HouseData[id][Owner]);
1845  		
1846		foreach(new i : Player)
1847		{
1848			if(!strcmp(HouseData[id][Owner], Player_GetName(i)))
1849			{
1850				owner_id = i;
1851				break;
1852			}
1853		}
1854		
1855		GivePlayerMoney(playerid, -HouseData[id][SalePrice]);
1856		GetPlayerName(playerid, HouseData[id][Owner], MAX_PLAYER_NAME);
1857  		HouseData[id][LastEntered] = gettime();
1858  		HouseData[id][SalePrice] = 0;
1859		HouseData[id][Save] = true;
1860
1861		UpdateHouseLabel(id);
1862		Streamer_SetIntData(STREAMER_TYPE_PICKUP, HouseData[id][HousePickup], E_STREAMER_MODEL_ID, 19522);
1863		Streamer_SetIntData(STREAMER_TYPE_MAP_ICON, HouseData[id][HouseIcon], E_STREAMER_TYPE, 32);
1864		SendToHouse(playerid, id);
1865		
1866		foreach(new i : Player)
1867	    {
1868	        if(i == playerid) continue;
1869	        if(InHouse[i] == id)
1870	        {
1871	            SetPVarInt(i, "HousePickupCooldown", gettime() + HOUSE_COOLDOWN);
1872	        	SetPlayerVirtualWorld(i, 0);
1873		        SetPlayerInterior(i, 0);
1874		        SetPlayerPos(i, HouseData[id][houseX], HouseData[id][houseY], HouseData[id][houseZ]);
1875		        InHouse[i] = INVALID_HOUSE_ID;
1876	        }
1877
1878	        if(Iter_Contains(HouseKeys[i], id)) Iter_Remove(HouseKeys[i], id);
1879	   	}
1880
1881	    new query[128];
1882	    if(IsPlayerConnected(owner_id)) {
1883	        GivePlayerMoney(owner_id, price);
1884
1885			new string[128];
1886			format(string, sizeof(string), "%s(%d) megvásárolta a házad $%s-ért.", HouseData[id][Owner], playerid, convertNumber(price));
1887			SendClientMessage(owner_id, -1, string);
1888	    }else{
1889	        mysql_format(SQLHandle, query, sizeof(query), "INSERT INTO housesales SET OldOwner='%e', NewOwner='%e', Price=%d", old_owner, HouseData[id][Owner], price);
1890	    	mysql_tquery(SQLHandle, query, "", "");
1891	    }
1892	    
1893	    mysql_format(SQLHandle, query, sizeof(query), "DELETE FROM housevisitors WHERE HouseID=%d", id);
1894	    mysql_tquery(SQLHandle, query, "", "");
1895
1896	    mysql_format(SQLHandle, query, sizeof(query), "DELETE FROM housekeys WHERE HouseID=%d", id);
1897	    mysql_tquery(SQLHandle, query, "", "");
1898
1899	    mysql_format(SQLHandle, query, sizeof(query), "DELETE FROM housesafelogs WHERE HouseID=%d", id);
1900	    mysql_tquery(SQLHandle, query, "", "");
1901		return 1;
1902	}
1903
1904	if(dialogid == DIALOG_SELL_HOUSE)
1905	{
1906	    if(!response) return ShowHouseMenu(playerid);
1907        new id = InHouse[playerid];
1908        if(id == INVALID_HOUSE_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy házban.");
1909		if(strcmp(HouseData[id][Owner], Player_GetName(playerid))) return SendClientMessage(playerid, 0xE74C3CFF, "Nem a tiéd a ház.");
1910		if(listitem == 0)
1911		{
1912		    new money = floatround(HouseData[id][Price] * 0.85) + HouseData[id][SafeMoney];
1913		    GivePlayerMoney(playerid, money);
1914			ResetHouse(id);
1915		}
1916		
1917		if(listitem == 1)
1918		{
1919		    if(HouseData[id][SalePrice] > 0) {
1920			    HouseData[id][SalePrice] = 0;
1921			    HouseData[id][Save] = true;
1922
1923			    UpdateHouseLabel(id);
1924				Streamer_SetIntData(STREAMER_TYPE_PICKUP, HouseData[id][HousePickup], E_STREAMER_MODEL_ID, 19522);
1925				Streamer_SetIntData(STREAMER_TYPE_MAP_ICON, HouseData[id][HouseIcon], E_STREAMER_TYPE, 32);
1926			    SendClientMessage(playerid, -1, "A házad többé nem eladó.");
1927			}else{
1928				if(HouseData[id][SafeMoney] > 0) return SendClientMessage(playerid, 0xE74C3CFF, "Nem tudod eladni a házad amíg a széf nem üres.");
1929				ShowPlayerDialog(playerid, DIALOG_SELLING_PRICE, DIALOG_STYLE_INPUT, "Ház eladás", "Mennyit kérsz a házadért?", "Eladás", "Mégse");
1930			}
1931		}
1932		
1933	    return 1;
1934	}
1935	
1936	if(dialogid == DIALOG_SELLING_PRICE)
1937	{
1938	    if(!response) return ShowHouseMenu(playerid);
1939        new id = InHouse[playerid];
1940        if(id == INVALID_HOUSE_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy házban.");
1941		if(strcmp(HouseData[id][Owner], Player_GetName(playerid))) return SendClientMessage(playerid, 0xE74C3CFF, "Nem a tiéd a ház.");
1942        new amount = strval(inputtext);
1943		if(!(1 <= amount <= 10000000)) return ShowPlayerDialog(playerid, DIALOG_SELLING_PRICE, DIALOG_STYLE_INPUT, "Ház eladás", "{E74C3C}Minimum $1, maximum $100,000,000.\n\n{FFFFFF}Mennyit kérsz a házadért?", "Eladás", "Mégse");
1944		HouseData[id][SalePrice] = amount;
1945		HouseData[id][Save] = true;
1946		
1947		UpdateHouseLabel(id);
1948		Streamer_SetIntData(STREAMER_TYPE_PICKUP, HouseData[id][HousePickup], E_STREAMER_MODEL_ID, 1273);
1949		Streamer_SetIntData(STREAMER_TYPE_MAP_ICON, HouseData[id][HouseIcon], E_STREAMER_TYPE, 31);
1950		
1951		new string[128];
1952		format(string, sizeof(string), "Eladóvá tetted a házad $%s-ért.", convertNumber(amount));
1953		SendClientMessage(playerid, -1, string);
1954	    return 1;
1955	}
1956	
1957	return 0;
1958}
1959
1960public OnPlayerSelectDynamicObject(playerid, objectid, modelid, Float: x, Float: y, Float: z)
1961{
1962	switch(SelectMode[playerid])
1963	{
1964	    case SELECT_MODE_EDIT:
1965		{
1966			EditingFurniture[playerid] = true;
1967			EditDynamicObject(playerid, objectid);
1968		}
1969		
1970	    case SELECT_MODE_SELL:
1971	    {
1972	        CancelEdit(playerid);
1973			
1974			new data[e_furniture], string[128];
1975			SetPVarInt(playerid, "SelectedFurniture", objectid);
1976			Streamer_GetArrayData(STREAMER_TYPE_OBJECT, objectid, E_STREAMER_EXTRA_ID, data);
1977			format(string, sizeof(string), "Elszeretnéd adni a bútorod?\nKapni fogsz érte{2ECC71}$%s-t.", convertNumber(HouseFurnitures[ data[ArrayID] ][Price]));
1978			ShowPlayerDialog(playerid, DIALOG_FURNITURE_SELL, DIALOG_STYLE_MSGBOX, "Eladás megerősítése", string, "Eladás", "Bezárás");
1979		}
1980	}
1981
1982    SelectMode[playerid] = SELECT_MODE_NONE;
1983	return 1;
1984}
1985
1986public OnPlayerEditDynamicObject(playerid, objectid, response, Float: x, Float: y, Float: z, Float: rx, Float: ry, Float: rz)
1987{
1988	if(EditingFurniture[playerid])
1989	{
1990		switch(response)
1991		{
1992		    case EDIT_RESPONSE_CANCEL:
1993		    {
1994		        new data[e_furniture];
1995		        Streamer_GetArrayData(STREAMER_TYPE_OBJECT, objectid, E_STREAMER_EXTRA_ID, data);
1996		        SetDynamicObjectPos(objectid, data[furnitureX], data[furnitureY], data[furnitureZ]);
1997		        SetDynamicObjectRot(objectid, data[furnitureRX], data[furnitureRY], data[furnitureRZ]);
1998		        
1999		        EditingFurniture[playerid] = false;
2000		    }
2001
2002			case EDIT_RESPONSE_FINAL:
2003			{
2004			    new data[e_furniture], query[256];
2005			    Streamer_GetArrayData(STREAMER_TYPE_OBJECT, objectid, E_STREAMER_EXTRA_ID, data);
2006			    data[furnitureX] = x;
2007			    data[furnitureY] = y;
2008			    data[furnitureZ] = z;
2009	            data[furnitureRX] = rx;
2010	            data[furnitureRY] = ry;
2011	            data[furnitureRZ] = rz;
2012	            SetDynamicObjectPos(objectid, data[furnitureX], data[furnitureY], data[furnitureZ]);
2013		        SetDynamicObjectRot(objectid, data[furnitureRX], data[furnitureRY], data[furnitureRZ]);
2014		        Streamer_SetArrayData(STREAMER_TYPE_OBJECT, objectid, E_STREAMER_EXTRA_ID, data);
2015
2016		        mysql_format(SQLHandle, query, sizeof(query), "UPDATE housefurnitures SET FurnitureX=%f, FurnitureY=%f, FurnitureZ=%f, FurnitureRX=%f, FurnitureRY=%f, FurnitureRZ=%f WHERE ID=%d", data[furnitureX], data[furnitureY], data[furnitureZ], data[furnitureRX], data[furnitureRY], data[furnitureRZ], data[SQLID]);
2017		        mysql_tquery(SQLHandle, query, "", "");
2018		        
2019		        EditingFurniture[playerid] = false;
2020			}
2021		}
2022	}
2023	
2024	return 1;
2025}
2026
2027/* ============ Player Commands ============ */
2028CMD:house(playerid, params[])
2029{
2030	if(InHouse[playerid] == INVALID_HOUSE_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy házban.");
2031	ShowHouseMenu(playerid);
2032	return 1;
2033}
2034
2035CMD:myhousekeys(playerid, params[])
2036{
2037    new query[200], Cache: mykeys;
2038    mysql_format(SQLHandle, query, sizeof(query), "SELECT HouseID, FROM_UNIXTIME(Date, '%%d/%%m/%%Y %%H:%%i') as KeyDate FROM housekeys WHERE Player='%e' ORDER BY Date DESC LIMIT 0, 15", Player_GetName(playerid));
2039	mykeys = mysql_query(SQLHandle, query);
2040	ListPage[playerid] = 0;
2041
2042	new rows = cache_num_rows();
2043	if(rows) {
2044 		new list[1024], id, key_date[20];
2045   		format(list, sizeof(list), "Ház információ\tKulcs odaadva\n");
2046	    for(new i; i < rows; ++i)
2047	    {
2048	        id = cache_get_field_content_int(i, "HouseID");
2049       		cache_get_field_content(i, "KeyDate", key_date);
2050	        format(list, sizeof(list), "%s%s háza %s\t%s\n", list, HouseData[id][Owner], HouseData[id][Name], key_date);
2051	    }
2052
2053		ShowPlayerDialog(playerid, DIALOG_MY_KEYS, DIALOG_STYLE_TABLIST_HEADERS, "Kulcsaim (1. oldal)", list, "Következő", "Close");
2054	}else{
2055		SendClientMessage(playerid, 0xE74C3CFF, "Nincs kulcsod egy házhoz se.");
2056	}
2057
2058	cache_delete(mykeys);
2059	return 1;
2060}
2061
2062CMD:givehousekeys(playerid, params[])
2063{
2064    if(InHouse[playerid] == INVALID_HOUSE_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy házban.");
2065    new id, houseid = InHouse[playerid];
2066	if(strcmp(HouseData[houseid][Owner], Player_GetName(playerid))) return SendClientMessage(playerid, 0xE74C3CFF, "Nem a tiéd a ház.");
2067	if(sscanf(params, "u", id)) return SendClientMessage(playerid, 0xE74C3CFF, "Használat: /givehousekeys [ Játékos ]");
2068	if(id == INVALID_PLAYER_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Hibás játékos.");
2069	if(id == playerid) return SendClientMessage(playerid, 0xE74C3CFF, "Te vagy a Tulaj, nincs szükséged kulcsra.");
2070	if(Iter_Contains(HouseKeys[id], houseid)) return SendClientMessage(playerid, 0xE74C3CFF, "Ennek a játékosnak már van kulcsa a házadhoz.");
2071	Iter_Add(HouseKeys[id], houseid);
2072	
2073	new query[128];
2074	mysql_format(SQLHandle, query, sizeof(query), "INSERT INTO housekeys SET HouseID=%d, Player='%e', Date=UNIX_TIMESTAMP()", houseid, Player_GetName(id));
2075	mysql_tquery(SQLHandle, query, "", "");
2076
2077	format(query, sizeof(query), "Kulcsot adtál %s-nek/nak a házadhoz.", Player_GetName(id));
2078	SendClientMessage(playerid, -1, query);
2079	format(query, sizeof(query), "Most már van kulcsod %s házához, %s.", HouseData[houseid][Owner], HouseData[houseid][Name]);
2080	SendClientMessage(id, -1, query);
2081	return 1;
2082}
2083
2084CMD:takehousekeys(playerid, params[])
2085{
2086    if(InHouse[playerid] == INVALID_HOUSE_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy házban.");
2087    new id, houseid = InHouse[playerid];
2088	if(strcmp(HouseData[houseid][Owner], Player_GetName(playerid))) return SendClientMessage(playerid, 0xE74C3CFF, "Nem a tiéd a ház.");
2089	if(sscanf(params, "u", id)) return SendClientMessage(playerid, 0xE74C3CFF, "Használat: /takehousekeys [ Játékos ]");
2090	if(id == INVALID_PLAYER_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Hibás játékos.");
2091	if(id == playerid) return SendClientMessage(playerid, 0xE74C3CFF, "Te vagy a Tulaj, nincs szükséged kulcsra..");
2092	if(!Iter_Contains(HouseKeys[id], houseid)) return SendClientMessage(playerid, 0xE74C3CFF, "Ennek a játékosnak nincs kulcs a házadhoz.");
2093	Iter_Remove(HouseKeys[id], houseid);
2094	
2095	new query[128];
2096	mysql_format(SQLHandle, query, sizeof(query), "DELETE FROM housekeys WHERE HouseID=%d AND Player='%e'", houseid, Player_GetName(id));
2097	mysql_tquery(SQLHandle, query, "", "");
2098
2099	format(query, sizeof(query), "Elvetted %s-től/tól a házadhoz tartozó kulcsokat.", Player_GetName(id));
2100	SendClientMessage(playerid, -1, query);
2101	format(query, sizeof(query), "Tulajdonos %s elvette a kulcsaidat a házához, %s.", HouseData[houseid][Owner], HouseData[houseid][Name]);
2102	SendClientMessage(id, -1, query);
2103	return 1;
2104}
2105
2106CMD:kickfromhouse(playerid, params[])
2107{
2108    if(InHouse[playerid] == INVALID_HOUSE_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Nem vagy házban.");
2109    new id, houseid = InHouse[playerid];
2110	if(strcmp(HouseData[houseid][Owner], Player_GetName(playerid))) return SendClientMessage(playerid, 0xE74C3CFF, "Nem a tiéd a ház.");
2111	if(sscanf(params, "u", id)) return SendClientMessage(playerid, 0xE74C3CFF, "Használat: /kickfromhouse [ Játékos ]");
2112	if(id == INVALID_PLAYER_ID) return SendClientMessage(playerid, 0xE74C3CFF, "Hibás játékos.");
2113	if(id == playerid) return SendClientMessage(playerid, 0xE74C3CFF, "Magadat nem tudod kirúgni a házból.");
2114	if(InHouse[id] != houseid) return SendClientMessage(playerid, 0xE74C3CFF, "Ez a játékos nincs a házban.");
2115    SendClientMessage(playerid, -1, "Játékos kirúgva a házból.");
2116	SendClientMessage(id, -1, "Kirúgott a ház tulajdonosa a házból.");
2117	SetPVarInt(id, "HousePickupCooldown", gettime() + HOUSE_COOLDOWN);
2118	SetPlayerVirtualWorld(id, 0);
2119 	SetPlayerInterior(id, 0);
2120 	SetPlayerPos(id, HouseData[houseid][houseX], HouseData[houseid][houseY], HouseData[houseid][houseZ]);
2121 	InHouse[id] = INVALID_HOUSE_ID;
2122	return 1;
2123}
2124
2125/* ============ Admin Commands ============ */
2126CMD:createhouse(playerid, params[])
2127{
2128	if(!IsPlayerAdmin(playerid)) return SendClientMessage(playerid, 0xE74C3CFF, "Ezt a parancsot nem használhatod.");
2129	new interior, price;
2130	if(sscanf(params, "ii", price, interior)) return SendClientMessage(playerid, 0xE74C3CFF, "Használat: /createhouse [ Ár ] [ Interior ID ]");
2131    if(!(0 <= interior <= sizeof(HouseInteriors)-1)) return SendClientMessage(playerid, 0xE74C3CFF, "Ez az interior nem létezik.");
2132	new id = Iter_Free(Houses);
2133	if(id == -1) return SendClientMessage(playerid, 0xE74C3CFF, "Nem tudsz több házat létrehozni.");
2134	SetPVarInt(playerid, "HousePickupCooldown", gettime() + HOUSE_COOLDOWN);
2135	format(HouseData[id][Name], MAX_HOUSE_NAME, "Eladó ház");
2136	format(HouseData[id][Owner], MAX_PLAYER_NAME, "-");
2137	format(HouseData[id][Password], MAX_HOUSE_PASSWORD, "-");
2138	GetPlayerPos(playerid, HouseData[id][houseX], HouseData[id][houseY], HouseData[id][houseZ]);
2139	HouseData[id][Price] = price;
2140	HouseData[id][Interior] = interior;
2141	HouseData[id][LockMode] = LOCK_MODE_NOLOCK;
2142	HouseData[id][SalePrice] = HouseData[id][SafeMoney] = HouseData[id][LastEntered] = 0;
2143	format(HouseData[id][Address], MAX_HOUSE_ADDRESS, "%d, %s, %s", id, GetZoneName(HouseData[id][houseX], HouseData[id][houseY], HouseData[id][houseZ]), GetCityName(HouseData[id][houseX], HouseData[id][houseY], HouseData[id][houseZ]));
2144    HouseData[id][Save] = true;
2145
2146    new label[200];
2147    format(label, sizeof(label), "{2ECC71}Eladó ház (ID: %d)\n{FFFFFF}%s\n{F1C40F}Ár: {2ECC71}$%s", id, HouseInteriors[interior][IntName], convertNumber(price));
2148	HouseData[id][HouseLabel] = CreateDynamic3DTextLabel(label, 0xFFFFFFFF, HouseData[id][houseX], HouseData[id][houseY], HouseData[id][houseZ]+0.35, 15.0, .testlos = 1);
2149	HouseData[id][HousePickup] = CreateDynamicPickup(1273, 1, HouseData[id][houseX], HouseData[id][houseY], HouseData[id][houseZ]);
2150	HouseData[id][HouseIcon] = CreateDynamicMapIcon(HouseData[id][houseX], HouseData[id][houseY], HouseData[id][houseZ], 31, 0);
2151
2152	new query[256];
2153	mysql_format(SQLHandle, query, sizeof(query), "INSERT INTO houses SET ID=%d, HouseX=%f, HouseY=%f, HouseZ=%f, HousePrice=%d, HouseInterior=%d", id, HouseData[id][houseX], HouseData[id][houseY], HouseData[id][houseZ], price, interior);
2154	mysql_tquery(SQLHandle, query, "", "");
2155	Iter_Add(Houses, id);
2156	return 1;
2157}
2158
2159CMD:gotohouse(playerid, params[])
2160{
2161    if(!IsPlayerAdmin(playerid)) return SendClientMessage(playerid, 0xE74C3CFF, "Ezt a parancsot nem használhatod.");
2162	new id;
2163	if(sscanf(params, "i", id)) return SendClientMessage(playerid, 0xE74C3CFF, "Használat: /gotohouse [ Ház ID ]");
2164	if(!Iter_Contains(Houses, id)) return SendClientMessage(playerid, 0xE74C3CFF, "Ez a ház nem létezik.");
2165	SetPVarInt(playerid, "HousePickupCooldown", gettime() + HOUSE_COOLDOWN);
2166	SetPlayerPos(playerid, HouseData[id][houseX], HouseData[id][houseY], HouseData[id][houseZ]);
2167	SetPlayerInterior(playerid, 0);
2168	SetPlayerVirtualWorld(playerid, 0);
2169	return 1;
2170}
2171
2172CMD:hsetinterior(playerid, params[])
2173{
2174    if(!IsPlayerAdmin(playerid)) return SendClientMessage(playerid, 0xE74C3CFF, "Ezt a parancsot nem használhatod.");
2175	new id, interior;
2176	if(sscanf(params, "ii", id, interior)) return SendClientMessage(playerid, 0xE74C3CFF, "Használat: /hsetinterior [ Ház ID ] [ Interior ID ]");
2177	if(!Iter_Contains(Houses, id)) return SendClientMessage(playerid, 0xE74C3CFF, "Ez a ház nem létezik.");
2178	if(!(0 <= interior <= sizeof(HouseInteriors)-1)) return SendClientMessage(playerid, 0xE74C3CFF, "Ez az interior nem létezik.");
2179	HouseData[id][Interior] = interior;
2180
2181	new query[64];
2182	mysql_format(SQLHandle, query, sizeof(query), "UPDATE houses SET HouseInterior=%d WHERE ID=%d", interior, id);
2183	mysql_tquery(SQLHandle, query, "", "");
2184
2185	UpdateHouseLabel(id);
2186	SendClientMessage(playerid, -1, "Interior frissítve.");
2187	return 1;
2188}
2189
2190CMD:hsetprice(playerid, params[])
2191{
2192    if(!IsPlayerAdmin(playerid)) return SendClientMessage(playerid, 0xE74C3CFF, "Ezt a parancsot nem használhatod.");
2193	new id, price;
2194	if(sscanf(params, "ii", id, price)) return SendClientMessage(playerid, 0xE74C3CFF, "Használat: /hsetprice [ Ház ID ] [ Ár ]");
2195	if(!Iter_Contains(Houses, id)) return SendClientMessage(playerid, 0xE74C3CFF, "Ez a ház nem létezik.");
2196	HouseData[id][Price] = price;
2197
2198	new query[64];
2199	mysql_format(SQLHandle, query, sizeof(query), "UPDATE houses SET HousePrice=%d WHERE ID=%d", price, id);
2200	mysql_tquery(SQLHandle, query, "", "");
2201
2202	UpdateHouseLabel(id);
2203	SendClientMessage(playerid, -1, "Ár frissítve.");
2204	return 1;
2205}
2206
2207CMD:resethouse(playerid, params[])
2208{
2209    if(!IsPlayerAdmin(playerid)) return SendClientMessage(playerid, 0xE74C3CFF, "Ezt a parancsot nem használhatod.");
2210	new id;
2211	if(sscanf(params, "i", id)) return SendClientMessage(playerid, 0xE74C3CFF, "Használat: /resethouse [ Ház ID ]");
2212	if(!Iter_Contains(Houses, id)) return SendClientMessage(playerid, 0xE74C3CFF, "Ez a ház nem létezik.");
2213	ResetHouse(id);
2214	SendClientMessage(playerid, -1, "Ház visszaállítva.");
2215	return 1;
2216}
2217
2218CMD:deletehouse(playerid, params[])
2219{
2220    if(!IsPlayerAdmin(playerid)) return SendClientMessage(playerid, 0xE74C3CFF, "Ezt a parancsot nem használhatod.");
2221	new id;
2222	if(sscanf(params, "i", id)) return SendClientMessage(playerid, 0xE74C3CFF, "Használat: /deletehouse [ Ház ID ]");
2223	if(!Iter_Contains(Houses, id)) return SendClientMessage(playerid, 0xE74C3CFF, "Ez a ház nem létezik.");
2224	ResetHouse(id);
2225	DestroyDynamic3DTextLabel(HouseData[id][HouseLabel]);
2226	DestroyDynamicPickup(HouseData[id][HousePickup]);
2227	DestroyDynamicMapIcon(HouseData[id][HouseIcon]);
2228	Iter_Remove(Houses, id);
2229	HouseData[id][HouseLabel] = Text3D:INVALID_3DTEXT_ID;
2230	HouseData[id][HousePickup] = HouseData[id][HouseIcon] = -1;
2231	HouseData[id][Save] = false;
2232
2233	new query[64];
2234	mysql_format(SQLHandle, query, sizeof(query), "DELETE FROM houses WHERE ID=%d", id);
2235	mysql_tquery(SQLHandle, query, "", "");
2236	SendClientMessage(playerid, -1, "Ház törölve.");
2237	return 1;
2238}