· 5 years ago · Apr 12, 2020, 12:04 AM
1CREATE TABLE IF NOT EXISTS `players` (
2`ID` int(11) NOT NULL,
3 `Username` varchar(35) NOT NULL,
4 `LastSeen` varchar(30) NOT NULL,
5 `OnlineID` int(4) NOT NULL,
6 `Lozinka` varchar(128) NOT NULL,
7 `Akcenat` varchar(12) NOT NULL,
8 `Stil` int(11) NOT NULL,
9 `OzenjenZa` varchar(30) NOT NULL DEFAULT 'Niko',
10 `CistacX` float NOT NULL,
11 `CistacY` float NOT NULL,
12 `CistacZ` float NOT NULL,
13 `Kuca` int(11) NOT NULL,
14 `Stan` int(11) NOT NULL,
15 `Firma` int(11) NOT NULL,
16 `Auto1` int(11) NOT NULL,
17 `Auto2` int(11) NOT NULL,
18 `Auto3` int(11) NOT NULL,
19 `Auto4` int(11) NOT NULL,
20 `PSTiket` int(11) NOT NULL,
21 `SlotVozila` int(11) NOT NULL,
22 `SlotVozila3` int(11) NOT NULL,
23 `Taziran` int(11) NOT NULL,
24 `Ucijenjen` int(11) NOT NULL,
25 `Zabe` int(11) NOT NULL,
26 `Ranac` int(11) NOT NULL,
27 `Kanistar` int(11) NOT NULL,
28 `Skill1` int(11) NOT NULL,
29 `Skill2` int(11) NOT NULL,
30 `Skill3` int(11) NOT NULL,
31 `Skill4` int(11) NOT NULL,
32 `Skill5` int(11) NOT NULL,
33 `Skill6` int(11) NOT NULL,
34 `Skill7` int(11) NOT NULL,
35 `Skill8` int(11) NOT NULL,
36 `TrazioZabe` int(11) NOT NULL,
37 `ZGSupporternovi` int(11) NOT NULL,
38 `ZGSLozinka` int(11) NOT NULL,
39 `ZGSSlot` int(11) NOT NULL,
40 `ZGSLose` int(11) NOT NULL,
41 `Umirovljenik` int(11) NOT NULL,
42 `Promoternovi` int(11) NOT NULL,
43 `ZGAdminnovi` int(11) NOT NULL,
44 `ZGALozinka` int(11) NOT NULL,
45 `ZGASlot` int(11) NOT NULL,
46 `Boja` int(11) NOT NULL,
47 `Level` int(11) NOT NULL,
48 `ProdajaOruzja` int(11) NOT NULL,
49 `Iskustvo` int(11) NOT NULL,
50 `Mute` int(11) NOT NULL,
51 `MuteProvjera` int(11) NOT NULL,
52 `Spol` int(11) NOT NULL,
53 `Registracija` int(11) NOT NULL,
54 `Spawn` int(11) NOT NULL,
55 `Sati` int(11) NOT NULL,
56 `Droga` int(11) NOT NULL,
57 `Materijali` int(11) NOT NULL,
58 `Event` int(11) NOT NULL,
59 `Zatvoren` int(11) NOT NULL,
60 `Posao` int(11) NOT NULL,
61 `Imenik` int(11) NOT NULL,
62 `Banka` int(11) NOT NULL,
63 `Novac` int(11) NOT NULL,
64 `Zatvor` int(11) NOT NULL,
65 `Kazino` int(11) NOT NULL,
66 `Zeljezo` int(11) NOT NULL,
67 `Ciscenje` int(11) NOT NULL,
68 `Sjeme` int(11) NOT NULL,
69 `DrogaObrada` int(11) NOT NULL,
70 `SadiDrogu` int(11) NOT NULL,
71 `Beri` int(11) NOT NULL,
72 `Interijer` int(11) NOT NULL,
73 `Skin` int(11) NOT NULL,
74 `Rank` int(11) NOT NULL,
75 `Razlog` int(11) NOT NULL,
76 `Wanted` int(11) NOT NULL,
77 `Clan` int(11) NOT NULL,
78 `Lidernovi` int(11) NOT NULL,
79 `Zlato` int(11) NOT NULL,
80 `Boombox` int(11) NOT NULL,
81 `MP3` int(11) NOT NULL,
82 `Zabrana` int(11) NOT NULL,
83 `Radio` int(11) NOT NULL,
84 `Broj` int(11) NOT NULL,
85 `Tiket` int(11) NOT NULL,
86 `Liderzaduzenje` int(11) NOT NULL,
87 `Supporterzaduzenje` int(11) NOT NULL,
88 `Promoterzaduzenje` int(11) NOT NULL,
89 `SpecTeam` int(11) NOT NULL,
90 `SpecZaduzenje` int(11) NOT NULL,
91 `Sok` int(11) NOT NULL,
92 `Kruh` int(11) NOT NULL,
93 `Jogurt` int(11) NOT NULL,
94 `Cips` int(11) NOT NULL,
95 `Secer` int(11) NOT NULL,
96 `Mljeko` int(11) NOT NULL,
97 `MobKredit` int(11) NOT NULL,
98 `Kosa` int(11) NOT NULL,
99 `Kazna` int(11) NOT NULL,
100 `Magarac` int(11) NOT NULL,
101 `Kapa` int(11) NOT NULL,
102 `Naocale` int(11) NOT NULL,
103 `Kredit` int(11) NOT NULL,
104 `Pinkod` int(11) NOT NULL,
105 `Vip` int(11) NOT NULL,
106 `Vip_Warn` int(11) NOT NULL DEFAULT '0',
107 `VipTime` int(11) NOT NULL,
108 `Zakljucan` int(11) NOT NULL,
109 `SkrivenBroj` int(11) NOT NULL,
110 `Paket` int(11) NOT NULL,
111 `Roadblock` int(11) NOT NULL,
112 `Roadblock2` int(11) NOT NULL,
113 `Alat` int(11) NOT NULL,
114 `Upaljac` int(11) NOT NULL,
115 `Cigare` int(11) NOT NULL,
116 `OruzjeInv` int(11) NOT NULL,
117 `MunicijaInv` int(11) NOT NULL,
118 `Ozenjen` int(11) NOT NULL,
119 `Upozorenja` int(11) NOT NULL,
120 `Tutorial` int(11) NOT NULL,
121 `Placa` int(11) NOT NULL,
122 `Osiguranje` int(11) NOT NULL,
123 `Putovnica` int(11) NOT NULL,
124 `DozvolaOruzje` int(11) NOT NULL,
125 `DozvolaBrod` int(11) NOT NULL,
126 `DozvolaAvion` int(11) NOT NULL,
127 `DozvolaAuto` int(11) NOT NULL,
128 `pAccountProvalaa` int(11) NOT NULL,
129 `pGaraza` int(11) NOT NULL DEFAULT '-1',
130 `Lotto1` int(11) NOT NULL,
131 `Lotto2` int(11) NOT NULL,
132 `Lotto3` int(11) NOT NULL,
133 `Lotto4` int(11) NOT NULL,
134 `Lotto5` int(11) NOT NULL,
135 `Lotto6` int(11) NOT NULL,
136 `Lotto7` int(11) NOT NULL,
137 `Supporter` int(11) NOT NULL,
138 `Lider` int(11) NOT NULL,
139 `ZGAdmin` int(11) NOT NULL,
140 `Objekat1` int(11) NOT NULL,
141 `Objekat2` int(11) NOT NULL,
142 `Muzika` int(11) NOT NULL,
143 `pTogPhone` int(11) NOT NULL,
144 `pAccountProvala` int(11) NOT NULL,
145 `pRPPoen` int(11) NOT NULL,
146 `GMuteProvjera` int(11) NOT NULL,
147 `pAdBan` int(11) NOT NULL,
148 `GMute` int(11) NOT NULL,
149 `pAskqBan` int(11) NOT NULL,
150 `Razlog_Jail` varchar(128) NOT NULL,
151 `pSuppAFK` int(11) NOT NULL,
152 `WarID` int(11) NOT NULL,
153 `WarTim` tinyint(3) unsigned NOT NULL DEFAULT '0',
154 `WarUbistva` smallint(5) unsigned NOT NULL DEFAULT '0',
155 `WarSmrti` smallint(5) unsigned NOT NULL DEFAULT '0',
156 `askqban` smallint(5) unsigned NOT NULL DEFAULT '0',
157 `smsadban` smallint(5) unsigned NOT NULL DEFAULT '0',
158 `scban` smallint(5) unsigned NOT NULL DEFAULT '0',
159 `lban` smallint(5) unsigned NOT NULL DEFAULT '0',
160 `supafk` int(11) NOT NULL,
161 `supduty` int(11) NOT NULL,
162 `supporuke` int(11) NOT NULL,
163 `supreset` date NOT NULL,
164 `dilertimer` int(11) NOT NULL,
165 `uzeopaketic` tinyint(1) NOT NULL DEFAULT '0',
166 `gchat` int(11) NOT NULL DEFAULT '0',
167 `autoopomena1` smallint(6) NOT NULL,
168 `autoopomena2` smallint(6) NOT NULL,
169 `autoopomena3` smallint(6) NOT NULL,
170 `autoopomena4` smallint(6) NOT NULL,
171 `sledeciticket` int(11) NOT NULL,
172 `ticketopomena` int(11) NOT NULL,
173 `razlogzatvora` varchar(20) NOT NULL DEFAULT 'n',
174 `AdminZaduzenje` int(11) NOT NULL DEFAULT '0',
175 `zatvorioadmin` varchar(35) NOT NULL,
176 `zgaduty` int(11) NOT NULL,
177 `zgsduty` int(11) NOT NULL,
178 `ZCoin` int(11) NOT NULL,
179 `TDM` int(11) NOT NULL,
180 `SkyFall` int(11) NOT NULL,
181 `LastObject` int(11) NOT NULL,
182 `Derby` int(11) NOT NULL,
183 `ZGDJ` int(11) NOT NULL,
184 `RPPoeni` int(11) NOT NULL,
185 `TD` int(11) NOT NULL,
186 `Tempomat` int(11) NOT NULL,
187 `Auto5` int(11) NOT NULL DEFAULT '-1',
188 `UserIP` varchar(45) NOT NULL,
189 `Email` varchar(80) NOT NULL,
190 `Datum` varchar(15) NOT NULL,
191 `Rodjendan` int(11) NOT NULL,
192 `ZGClan` int(11) NOT NULL,
193 `ZGLider` int(11) NOT NULL,
194 `Sneg` int(11) NOT NULL DEFAULT '0',
195 `ONeaktivnost` int(11) NOT NULL DEFAULT '0',
196 `NGodina` int(11) NOT NULL DEFAULT '0',
197 `obavestenje` varchar(158) NOT NULL,
198 `naslov` varchar(18) NOT NULL,
199 `PokrenutWar` tinyint(1) NOT NULL DEFAULT '0',
200 `praviOnSati` mediumint(9) NOT NULL DEFAULT '0',
201 `otkljucaniAch` tinyint(1) NOT NULL DEFAULT '0',
202 `LiveEventZaduzenje` tinyint(1) NOT NULL DEFAULT '0',
203 `ProveraZaduzenje` tinyint(1) NOT NULL DEFAULT '0',
204 `Parkour` smallint(6) NOT NULL DEFAULT '0',
205 `obradjenadroga` mediumint(9) NOT NULL DEFAULT '0',
206 `neobradjenadroga` mediumint(9) NOT NULL DEFAULT '0',
207 `vrecicedroge` tinyint(4) NOT NULL DEFAULT '0',
208 `laboratorija` tinyint(4) NOT NULL DEFAULT '0',
209 `imanjeID` smallint(6) NOT NULL DEFAULT '-1',
210 `playerTrees` mediumint(9) NOT NULL DEFAULT '0',
211 `playerFruit` mediumint(9) NOT NULL DEFAULT '0',
212 `WarnReason` varchar(200) NOT NULL DEFAULT '0/0/0000 - 00:00 Razlog:Nema. Admin:Niko',
213 `WarnReason2` varchar(200) NOT NULL DEFAULT '0/0/0000 - 00:00 Razlog:Nema. Admin:Niko',
214 `VehicleDon` tinyint(4) NOT NULL DEFAULT '0',
215 `OruzjeInv2` tinyint(4) NOT NULL DEFAULT '0',
216 `MunicijaInv2` mediumint(9) NOT NULL DEFAULT '0',
217 `DJZaduzenje` int(11) NOT NULL DEFAULT '0',
218 `SuppZaduzenje` mediumint(9) NOT NULL DEFAULT '0',
219 `SuppHelped` mediumint(9) NOT NULL DEFAULT '0',
220 `goliOtokTimes` int(11) NOT NULL DEFAULT '0',
221 `Kills` int(11) NOT NULL DEFAULT '0',
222 `Deaths` int(11) NOT NULL DEFAULT '0'
223) ENGINE=InnoDB AUTO_INCREMENT=166794 DEFAULT CHARSET=utf8mb4;