wfb0kjyA

1#define MAX_HOUSES 100
2
3
4enum hInfo
5{
6hId,
7hSavininkas[MAX_PLAYER_NAME],
8hNuomininkas[MAX_PLAYER_NAME],
9hKaina[3],
10hInterjeras,
11hPinigai,
12hSlaptazodis,
13hMeskeres[2],
14hGinklai[5],
15hGinkluKiekis[5],
16hNarkotikai[3],
17hNarkotikuKiekis[3],
18Float:hPos[3],
19
20hCp,
21Text3D:h3D
22}
23new HouseInfo[MAX_HOUSES][hInfo];
24
25
26stock SaveHouses();
27{
28new string[128];
29for(new all = 1; all < MAX_HOUSES; all ++)
30{
31if(HouseInfo[all][vId] == 0) continue;
32HouseInfo[0][hId] += 1;
33format(string,sizeof(string),"UPDATE houses SET `Savininkas` = '%s', `Nuomininkas` = '%s' WHERE `ID` = '%d'",HouseInfo[all][hSavininkas],HouseInfo[all][hNuomininkas], all);
34mysql_query(string);
35format(string,sizeof(string),"UPDATE houses SET `NamoKaina` = '%d', `NamoPardavimoKaina` = '%d',`NuomosKaina` = '%d', `Interjeras` = '%d',`Pinigai` = '%d' WHERE `ID` = '%d'",HouseInfo[all][hKaina][0],HouseInfo[all][hKaina][1],HouseInfo[all][hKaina][2],HouseInfo[all][hInterjeras],HouseInfo[all][hPinigai], all);
36mysql_query(string);
37format(string,sizeof(string),"UPDATE houses SET `Slaptazodis` = '%d', `Meskere1` = '%d', `Meskere2` = '%d' WHERE `ID` = ;'%d'",HouseInfo[all][hSlaptazodis],HouseInfo[all][hMeskere][0],HouseInfo[all][hMeskere][1], all);
38mysql_query(string);
39format(string,sizeof(string),"UPDATE houses SET `Ginklas1` = '%d', `Ginklas2` = '%d', `Ginklas3`, `Ginklas4` = '%d', `Ginklas5` = '%d' WHERE `ID` = '%d'",HouseInfo[all][hGinklai][0],HouseInfo[all][hGinklai][1],HouseInfo[all][hGinklai][2],HouseInfo[all][hGinklai][3],HouseInfo[all][hGinklai][4], all);
40mysql_query(string);
41format(string,sizeof(string),"UPDATE houses SET `Ginklo1K` = '%d', `Ginklo2K` = '%d', `Ginklo3K`, `Ginklo4K` = '%d', `Ginklo5K` = '%d' WHERE `ID` = '%d'",HouseInfo[all][hGinkluKiekis][0],HouseInfo[all][hGinkluKiekis][1],HouseInfo[all][hGinkluKiekis][2],HouseInfo[all][hGinkluKiekis][3],HouseInfo[all][hGinkluKiekis][4], all);
42mysql_query(string);
43format(string,sizeof(string),"UPDATE houses SET `Narkotikai1` = '%d', `Narkotikai2` = '%d', `Narkotikai3` WHERE `ID` = '%d'",HouseInfo[all][hNarkotikai][0],HouseInfo[all][hNarkotikai][1],HouseInfo[all][hNarkotikai][2], all);
44mysql_query(string);
45format(string,sizeof(string),"UPDATE houses SET `Narkotiku1K` = '%d', `Narkotiku2K` = '%d', `Narkotiku3K` WHERE `ID` = '%d'",HouseInfo[all][hNarkotikuKiekis][0],HouseInfo[all][hNarkotikuKiekis][1],HouseInfo[all][hNarkotikuKiekis][2], all);
46mysql_query(string);
47}
48format(string,sizeof(string),"Išsaugota %d namų!",HouseInfo[0][hId]);
49print(string);
50HouseInfo[0][hId] = 0;
51return 1;
52}
53
54stock LoadHouses
55{
56for(new all = 1; all < MAX_HOUSES; all ++)
57{
58new string[128];
59format(string,sizeof(string),"SELECT FROM `houses` WHERE `ID` = '%d'",all);
60mysql_query(string);
61mysql_store_result();
62new mconnect = mysql_num_rows();
63mysql_free_result();
64if(mconnect == 0) continue;
65while(mysql_retrieve_row())
66{
67mysql_fetch_field_row(string,"ID"); HouseInfo[all][hId] = strval(string);
68mysql_fetch_field_row(string,"Savininkas"); format(HouseInfo[all][hSavininkas], 21,"%s",string);
69mysql_fetch_field_row(string,"Nuomininkas"); format(HouseInfo[all][hNuomininkas], 21,"%s",string);
70mysql_fetch_field_row(string,"NamoKaina"); HouseInfo[all][hKaina][0] = strval(string);
71mysql_fetch_field_row(string,"NamoPardavimoKaina"); HouseInfo[all][hKaina][1] = strval(string);
72mysql_fetch_field_row(string,"NuomosKaina"); HouseInfo[all][hKaina][2] = strval(string);
73mysql_fetch_field_row(string,"Interjeras"); HouseInfo[all][hInterjeras] = strval(string);
74mysql_fetch_field_row(string,"Pinigai"); HouseInfo[all][hPinigai] = strval(string);
75mysql_fetch_field_row(string,"Slaptazodis"); HouseInfo[all][hSlaptazodis] = strval(string);
76mysql_fetch_field_row(string,"Meskere1"); HouseInfo[all][hMeskere][0] = strval(string);
77mysql_fetch_field_row(string,"Meskere2"); HouseInfo[all][hMeskere][1] = strval(string);
78mysql_fetch_field_row(string,"Ginklas1"); HouseInfo[all][hGinklai][0] = strval(string);
79mysql_fetch_field_row(string,"Ginklas2"); HouseInfo[all][hGinklai][1] = strval(string);
80mysql_fetch_field_row(string,"Ginklas3"); HouseInfo[all][hGinklai][2] = strval(string);
81mysql_fetch_field_row(string,"Ginklas4"); HouseInfo[all][hGinklai][3] = strval(string);
82mysql_fetch_field_row(string,"Ginklas5"); HouseInfo[all][hGinklai][4] = strval(string);
83mysql_fetch_field_row(string,"Ginklo1K"); HouseInfo[all][hGinkluKiekis][0] = strval(string);
84mysql_fetch_field_row(string,"Ginklo2K"); HouseInfo[all][hGinkluKiekis][1] = strval(string);
85mysql_fetch_field_row(string,"Ginklo3K"); HouseInfo[all][hGinkluKiekis][2] = strval(string);
86mysql_fetch_field_row(string,"Ginklo4K"); HouseInfo[all][hGinkluKiekis][3] = strval(string);
87mysql_fetch_field_row(string,"Ginklo5K"); HouseInfo[all][hGinkluKiekis][4] = strval(string);
88mysql_fetch_field_row(string,"Narkotikai1"); HouseInfo[all][hNarkotikai][0] = strval(string);
89mysql_fetch_field_row(string,"Narkotikai2"); HouseInfo[all][hNarkotikai][1] = strval(string);
90mysql_fetch_field_row(string,"Narkotikai3"); HouseInfo[all][hNarkotikai][2] = strval(string);
91mysql_fetch_field_row(string,"Narkotiku1K"); HouseInfo[all][hNarkotikuKiekis][0] = strval(string);
92mysql_fetch_field_row(string,"Narkotiku2K"); HouseInfo[all][hNarkotikuKiekis][1] = strval(string);
93mysql_fetch_field_row(string,"Narkotiku3K"); HouseInfo[all][hNarkotikuKiekis][2] = strval(string);
94
95mysql_fetch_field_row(string,"X"); HouseInfo[all][hPos][1] = floatstr(string);
96mysql_fetch_field_row(string,"Y"); HouseInfo[all][hPos][1] = floatstr(string);
97mysql_fetch_field_row(string,"Z"); HouseInfo[all][hPos][1] = floatstr(string);
98CreateHousePickWith3DLabel(false,all);
99HouseInfo[0][hId] += 1;
100}
101}
102format(string,sizeof(string),"Užkrauta %d namų!",HouseInfo[0][hId]);
103print(string);
104HouseInfo[0][hId] = 0;
105return 1;
106}
107
108stock CreateHousePick(bool:Trinamas,id)
109{
110if(Trinamas == true)
111{
112DestroyDynamicPickup(HouseInfo[id][hCp]);
113CreateHouse3DTextLabel(id,false);
114}
115else CreateHouse3DTextLabel(id,true);
116if(!strcmp(HouseInfo[id][hSavininkas],"PARDUODAMAS")) HouseInfo[id][hCp] = CreateDynamicPickup(1273,1,HouseInfo[id][hPos][0],HouseInfo[id][hPos][1], HouseInfo[id][hPos][2],-1,-1,-1, 300.00);
117else HouseInfo[id][hCp] = CreateDynamicPickup(1272,1,HouseInfo[id][hPos][0],HouseInfo[id][hPos][1], HouseInfo[id][hPos][2],-1,-1,-1, 300.00);
118return 1;
119}
120
121stock CreateHouse3DTextLabel(id,bool:kurti)
122{
123if(!strcmp(HouseInfo[id][hSavininkas],"PARDUODAMAS")) format(string,sizeof(string),"Namas parduodamas!\nKaina: %d€\nInterjeras: %d",HouseInfo[id][hKaina][0],HouseInfo[id][hInterjeras]);
124else
125{
126if(HouseInfo[id][hKaina][1] != 0) format(string,sizeof(string),"\tNamas parduodamas!\nPardavimo kaina %d€ (namo vertė: %d€)\n\tNamo pardavėjas: %s\n\t\tInterjeras: %d",HouseInfo[id][hKaina][1],HouseInfo[id][hKaina][0],HouseInfo[id][hSavininkas],HouseInfo[id][hInterjeras]);
127else
128{
129format(string,sizeof(string),"Name gyvena %s",HouseInfo[id][hSavininkas]);
130if(!strcmp(HouseInfo[id][hNuomininkas],"NERA")) format(string,sizeof(string),"%s!\nNamo vertė: %d€",string,HouseInfo[id][hKaina][0]);
131else format(string,sizeof(string),"%s ir %s!\nNamo vertė: %d€",string,HouseInfo[id][hNuomininkas],HouseInfo[id][hKaina][0]);
132}
133}
134if(kurti == true) HouseInfo[id][h3D] = Create3DTextLabel(string, SĖKMINGA,HouseInfo[id][hPos][0],HouseInfo[id][hPos][1], HouseInfo[id][hPos][2],10.00,0,0);
135else Update3DTextLabelText(HouseInfo[id][h3D],SĖKMINGA,string);
136return 1;
137}
138
139/*CREATE TABLE IF NOT EXISTS `houses` (
140  `ID` int(5) NOT NULL,
141  `Savininkas` varchar(21) NOT NULL,
142  `Nuomininkas` varchar(21) NOT NULL,
143  `NamoKaina` int(11) NOT NULL,
144  `NamoPardavimoKaina` int(11) NOT NULL,
145  `NuomosKaina` int(7) NOT NULL,
146  `Interjeras` int(3) NOT NULL,
147  `Pinigai` int(11) NOT NULL,
148  `Slaptazodis` int(5) NOT NULL,
149  `Meskere1` int(2) NOT NULL,
150  `Meskere2` int(2) NOT NULL,
151  `Ginklas1` int(11) NOT NULL,
152  `Ginklas2` int(11) NOT NULL,
153  `Ginklas3` int(11) NOT NULL,
154  `Ginklas4` int(11) NOT NULL,
155  `Ginklas5` int(11) NOT NULL,
156  `Ginklo1K` int(11) NOT NULL,
157  `Ginklo2K` int(11) NOT NULL,
158  `Ginklo3K` int(11) NOT NULL,
159  `Ginklp4K` int(11) NOT NULL,
160  `Ginklo5K` int(11) NOT NULL,
161  `Narkotikai1` int(11) NOT NULL,
162  `Narkotikai2` int(11) NOT NULL,
163  `Narkotikai3` int(11) NOT NULL,
164  `Narkotiku1K` int(11) NOT NULL,
165  `Narkotiku2K` int(11) NOT NULL,
166  `Narkotiku3K` int(11) NOT NULL,
167  `X` FLOAT NOT NULL,
168  `Y` FLOAT NOT NULL,
169  `Z` FLOAT NOT NULL
170  ) ENGINE=InnoDB DEFAULT CHARSET=latin1; */