· 5 years ago · Mar 23, 2020, 05:46 AM
1-- phpMyAdmin SQL Dump
2-- version 4.2.12deb2+deb8u2
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: May 16, 2018 at 03:12 PM
7-- Server version: 5.5.59-0+deb8u1
8-- PHP Version: 5.6.33-0+deb8u1
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `stttt`
21--
22
23DELIMITER $$
24--
25-- Procedures
26--
27CREATE DEFINER=`root`@`localhost` PROCEDURE `myproc`()
28BEGIN
29DECLARE c INT;
30SET c = 1;
31WHILE c < 1000 DO
32SELECT CONCAT('Loop #:', c) ;
33
34UPDATE clans set cmembers = (select count(*) from playerbase where inclan = c) where cid = c;
35commit;
36
37SET c=c+1;
38
39END WHILE;
40END$$
41
42DELIMITER ;
43
44-- --------------------------------------------------------
45
46--
47-- Table structure for table `admins`
48--
49
50CREATE TABLE IF NOT EXISTS `admins` (
51`accid` int(10) NOT NULL,
52 `aname` varchar(20) DEFAULT NULL,
53 `acountry` varchar(30) DEFAULT NULL
54) ENGINE=InnoDB AUTO_INCREMENT=1319275 DEFAULT CHARSET=latin1;
55
56-- --------------------------------------------------------
57
58--
59-- Table structure for table `bans`
60--
61
62CREATE TABLE IF NOT EXISTS `bans` (
63`bid` int(11) NOT NULL,
64 `b_name` varchar(24) DEFAULT NULL,
65 `b_ip` varchar(16) DEFAULT NULL,
66 `b_admin` varchar(24) DEFAULT NULL,
67 `b_reason` varchar(50) DEFAULT NULL,
68 `b_time` varchar(30) DEFAULT NULL,
69 `expire` int(20) NOT NULL DEFAULT '-1'
70) ENGINE=InnoDB AUTO_INCREMENT=191826 DEFAULT CHARSET=latin1;
71
72-- --------------------------------------------------------
73
74--
75-- Table structure for table `cblacklist`
76--
77
78CREATE TABLE IF NOT EXISTS `cblacklist` (
79 `cid` int(20) NOT NULL,
80 `pid` int(20) NOT NULL
81) ENGINE=InnoDB DEFAULT CHARSET=latin1;
82
83-- --------------------------------------------------------
84
85--
86-- Table structure for table `clanhistory`
87--
88
89CREATE TABLE IF NOT EXISTS `clanhistory` (
90`hid` int(20) NOT NULL,
91 `msg` varchar(144) NOT NULL DEFAULT '',
92 `cid` int(10) NOT NULL,
93 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
94) ENGINE=InnoDB AUTO_INCREMENT=5410 DEFAULT CHARSET=latin1;
95
96-- --------------------------------------------------------
97
98--
99-- Table structure for table `clans`
100--
101
102CREATE TABLE IF NOT EXISTS `clans` (
103`cid` int(20) NOT NULL,
104 `ctag` varchar(5) DEFAULT NULL,
105 `cname` varchar(20) DEFAULT NULL,
106 `cslogan` varchar(70) DEFAULT 'Clan Slogan: None',
107 `cteam` varchar(20) DEFAULT NULL,
108 `cowner` varchar(25) DEFAULT NULL,
109 `cleader` varchar(25) DEFAULT NULL,
110 `cmembers` int(10) NOT NULL DEFAULT '1',
111 `clevel` int(5) NOT NULL DEFAULT '0',
112 `chpoints` int(10) NOT NULL DEFAULT '0',
113 `ckills` int(20) NOT NULL DEFAULT '0',
114 `cdeaths` int(20) NOT NULL DEFAULT '0',
115 `cskin` int(10) NOT NULL,
116 `cwins` int(10) NOT NULL DEFAULT '0',
117 `close` int(10) NOT NULL DEFAULT '0',
118 `perk0` int(20) NOT NULL DEFAULT '0',
119 `perk1` int(20) NOT NULL DEFAULT '0',
120 `perk2` int(20) NOT NULL DEFAULT '0',
121 `perk3` int(20) NOT NULL DEFAULT '0',
122 `perk4` int(20) NOT NULL DEFAULT '0',
123 `perk5` int(20) NOT NULL DEFAULT '0',
124 `perk6` int(20) NOT NULL DEFAULT '0',
125 `perk7` int(20) NOT NULL DEFAULT '0',
126 `top_clanwar` varchar(20) NOT NULL DEFAULT '0',
127 `top_cw_win` int(10) NOT NULL DEFAULT '0',
128 `top_cw_lose` int(10) NOT NULL DEFAULT '0',
129 `lastcw` int(10) DEFAULT '-1',
130 `activity` int(10) NOT NULL DEFAULT '0',
131 `cuseranks` int(20) NOT NULL,
132 `crank0` varchar(20) NOT NULL,
133 `crank1` varchar(20) NOT NULL,
134 `crank2` varchar(20) NOT NULL,
135 `crank3` varchar(20) NOT NULL,
136 `crank4` varchar(20) NOT NULL,
137 `crank5` varchar(20) NOT NULL,
138 `crank6` varchar(20) NOT NULL,
139 `crank7` varchar(20) NOT NULL,
140 `crank8` varchar(20) NOT NULL,
141 `crank9` varchar(20) NOT NULL,
142 `crank10` varchar(20) NOT NULL,
143 `cathp` int(20) DEFAULT '0',
144 `ctoy1` int(11) NOT NULL,
145 `ctoy2` int(11) NOT NULL,
146 `rank` int(3) NOT NULL DEFAULT '0',
147 `rankprog` int(4) NOT NULL DEFAULT '0'
148) ENGINE=InnoDB AUTO_INCREMENT=1757 DEFAULT CHARSET=latin1;
149
150--
151-- Triggers `clans`
152--
153DELIMITER //
154CREATE TRIGGER `OwnerUpdate` BEFORE UPDATE ON `clans`
155 FOR EACH ROW BEGIN
156
157 /* IF OLD.cowner IS NOT NULL THEN
158 SET NEW.cowner = (select playerbase.name from playerbase where playerbase.clanown = NEW.cid LIMIT 1);
159END IF;
160*/
161 SET NEW.cmembers = (select COUNT(id) from playerbase where playerbase.inclan = NEW.cid);
162END
163//
164DELIMITER ;
165
166-- --------------------------------------------------------
167
168--
169-- Table structure for table `clantoys`
170--
171
172CREATE TABLE IF NOT EXISTS `clantoys` (
173`toyid` int(10) NOT NULL,
174 `index` int(2) NOT NULL,
175 `tbone` int(2) NOT NULL,
176 `tx` float NOT NULL,
177 `ty` float NOT NULL,
178 `tz` float NOT NULL,
179 `rtx` float NOT NULL,
180 `rty` float NOT NULL,
181 `rtz` float NOT NULL,
182 `tsx` float NOT NULL,
183 `tsy` float NOT NULL,
184 `tsz` float NOT NULL,
185 `cid` int(8) NOT NULL
186) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=latin1;
187
188-- --------------------------------------------------------
189
190--
191-- Table structure for table `friends`
192--
193
194CREATE TABLE IF NOT EXISTS `friends` (
195`fid` int(20) NOT NULL,
196 `alpha` int(20) NOT NULL,
197 `beta` int(20) NOT NULL,
198 `alphaname` varchar(20) NOT NULL DEFAULT '',
199 `betaname` varchar(20) NOT NULL DEFAULT ''
200) ENGINE=InnoDB AUTO_INCREMENT=621 DEFAULT CHARSET=latin1;
201
202--
203-- Triggers `friends`
204--
205DELIMITER //
206CREATE TRIGGER `friend_added` BEFORE INSERT ON `friends`
207 FOR EACH ROW BEGIN
208
209 SET NEW.alphaname = (select playerbase.name from playerbase where playerbase.id = NEW.alpha);
210 SET NEW.betaname = (select playerbase.name from playerbase where playerbase.id = NEW.beta);
211END
212//
213DELIMITER ;
214
215-- --------------------------------------------------------
216
217--
218-- Table structure for table `name_logs`
219--
220
221CREATE TABLE IF NOT EXISTS `name_logs` (
222`id` int(16) NOT NULL,
223 `accountid` int(20) NOT NULL,
224 `approvedby` int(24) NOT NULL,
225 `new_name` varchar(24) NOT NULL,
226 `old_name` varchar(24) NOT NULL,
227 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
228) ENGINE=InnoDB AUTO_INCREMENT=5197 DEFAULT CHARSET=latin1;
229
230-- --------------------------------------------------------
231
232--
233-- Table structure for table `playerbase`
234--
235
236CREATE TABLE IF NOT EXISTS `playerbase` (
237`id` int(16) NOT NULL,
238 `name` varchar(25) DEFAULT NULL,
239 `ip` varchar(16) DEFAULT NULL,
240 `pass` varchar(129) DEFAULT NULL,
241 `score` int(20) DEFAULT '50',
242 `money` int(20) DEFAULT '0',
243 `adminlvl` int(2) DEFAULT '0',
244 `helper` int(2) DEFAULT '0',
245 `vip` int(2) DEFAULT '0',
246 `kills` int(20) DEFAULT '0',
247 `deaths` int(20) DEFAULT '0',
248 `medkit` int(2) DEFAULT '0',
249 `armourpack` int(2) DEFAULT '0',
250 `gps` tinyint(4) NOT NULL DEFAULT '0',
251 `license` tinyint(4) NOT NULL DEFAULT '1',
252 `laston` varchar(30) DEFAULT '',
253 `hours` int(10) DEFAULT '0',
254 `ddm` int(10) DEFAULT '0',
255 `dcbdm` int(10) DEFAULT '0',
256 `dsdm` int(10) DEFAULT '0',
257 `minutes` int(10) DEFAULT '0',
258 `seconds` int(10) DEFAULT '0',
259 `skin` int(3) DEFAULT '0',
260 `useskin` tinyint(2) DEFAULT '0',
261 `inclan` int(10) DEFAULT '-1',
262 `clanlead` int(10) DEFAULT '-1',
263 `clanown` int(10) DEFAULT '-1',
264 `head` bigint(16) DEFAULT '0',
265 `warnings` int(10) NOT NULL DEFAULT '0',
266 `jailtime` int(10) NOT NULL DEFAULT '0',
267 `dmusickit` int(10) NOT NULL DEFAULT '0',
268 `clancoown` int(2) NOT NULL DEFAULT '0',
269 `crank` int(10) NOT NULL DEFAULT '0',
270 `XP` int(10) NOT NULL DEFAULT '0',
271 `classes` varchar(20) NOT NULL DEFAULT '0',
272 `VPB` float NOT NULL,
273 `spectds` int(2) NOT NULL DEFAULT '1',
274 `cmdtds` int(2) NOT NULL DEFAULT '1',
275 `lastip` varchar(16) NOT NULL DEFAULT 'Not available',
276 `gpci` varchar(128) NOT NULL DEFAULT 'Not available',
277 `acnotification` int(2) NOT NULL DEFAULT '1',
278 `mute` int(32) NOT NULL DEFAULT '0',
279 `namekey` int(2) NOT NULL DEFAULT '0',
280 `vipjoin` int(2) NOT NULL DEFAULT '1',
281 `quests` varchar(5) NOT NULL DEFAULT '0',
282 `spvip` int(3) NOT NULL,
283 `spscr` int(3) NOT NULL,
284 `toggles` varchar(20) NOT NULL DEFAULT '10111111',
285 `dtxt` varchar(17) NOT NULL,
286 `qp` varchar(11) NOT NULL,
287 `stm` int(2) NOT NULL DEFAULT '0',
288 `pst` varchar(4) NOT NULL DEFAULT '000'
289) ENGINE=InnoDB AUTO_INCREMENT=1657663 DEFAULT CHARSET=latin1;
290
291-- --------------------------------------------------------
292
293--
294-- Table structure for table `pubgpickups`
295--
296
297CREATE TABLE IF NOT EXISTS `pubgpickups` (
298`id` int(10) NOT NULL,
299 `x` float NOT NULL,
300 `y` float NOT NULL,
301 `z` float NOT NULL
302) ENGINE=InnoDB AUTO_INCREMENT=860 DEFAULT CHARSET=latin1;
303
304-- --------------------------------------------------------
305
306--
307-- Table structure for table `tournament`
308--
309
310CREATE TABLE IF NOT EXISTS `tournament` (
311`TID` int(20) NOT NULL,
312 `WINNER` int(20) NOT NULL DEFAULT '-1',
313 `ON` int(2) NOT NULL DEFAULT '1',
314 `PHASE` int(10) NOT NULL,
315 `IT` int(11) NOT NULL,
316 `MAX` int(11) NOT NULL,
317 `QT1_0` int(11) NOT NULL DEFAULT '-1',
318 `QT1_1` int(11) NOT NULL DEFAULT '-1',
319 `QT1_2` int(11) NOT NULL DEFAULT '-1',
320 `QT1_3` int(11) NOT NULL DEFAULT '-1',
321 `QT2_0` int(11) NOT NULL DEFAULT '-1',
322 `QT2_1` int(11) NOT NULL DEFAULT '-1',
323 `QT2_2` int(11) NOT NULL DEFAULT '-1',
324 `QT2_3` int(11) NOT NULL DEFAULT '-1',
325 `ST1_0` int(11) NOT NULL DEFAULT '-1',
326 `ST1_1` int(11) NOT NULL DEFAULT '-1',
327 `ST2_0` int(11) NOT NULL DEFAULT '-1',
328 `ST2_1` int(11) NOT NULL DEFAULT '-1',
329 `FT1` int(11) NOT NULL DEFAULT '-1',
330 `FT2` int(11) NOT NULL DEFAULT '-1',
331 `TTAG_0` varchar(6) NOT NULL DEFAULT '',
332 `TTAG_1` varchar(6) NOT NULL DEFAULT '',
333 `TTAG_2` varchar(6) NOT NULL DEFAULT '',
334 `TTAG_3` varchar(6) NOT NULL DEFAULT '',
335 `TTAG_4` varchar(6) NOT NULL DEFAULT '',
336 `TTAG_5` varchar(6) NOT NULL DEFAULT '',
337 `TTAG_6` varchar(6) NOT NULL DEFAULT '',
338 `TTAG_7` varchar(6) NOT NULL DEFAULT '',
339 `STAG_0` varchar(6) NOT NULL DEFAULT '?',
340 `STAG_1` varchar(6) NOT NULL DEFAULT '?',
341 `STAG_2` varchar(6) NOT NULL DEFAULT '?',
342 `STAG_3` varchar(6) NOT NULL DEFAULT '?',
343 `FTAG_1` varchar(6) NOT NULL DEFAULT '?',
344 `FTAG_2` varchar(6) NOT NULL DEFAULT '?',
345 `CM` int(20) NOT NULL DEFAULT '0'
346) ENGINE=InnoDB DEFAULT CHARSET=latin1;
347
348--
349-- Indexes for dumped tables
350--
351
352--
353-- Indexes for table `admins`
354--
355ALTER TABLE `admins`
356 ADD PRIMARY KEY (`accid`);
357
358--
359-- Indexes for table `bans`
360--
361ALTER TABLE `bans`
362 ADD PRIMARY KEY (`bid`);
363
364--
365-- Indexes for table `clanhistory`
366--
367ALTER TABLE `clanhistory`
368 ADD PRIMARY KEY (`hid`);
369
370--
371-- Indexes for table `clans`
372--
373ALTER TABLE `clans`
374 ADD PRIMARY KEY (`cid`);
375
376--
377-- Indexes for table `clantoys`
378--
379ALTER TABLE `clantoys`
380 ADD PRIMARY KEY (`toyid`);
381
382--
383-- Indexes for table `friends`
384--
385ALTER TABLE `friends`
386 ADD PRIMARY KEY (`fid`);
387
388--
389-- Indexes for table `name_logs`
390--
391ALTER TABLE `name_logs`
392 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `accountid_2` (`old_name`);
393
394--
395-- Indexes for table `playerbase`
396--
397ALTER TABLE `playerbase`
398 ADD UNIQUE KEY `id` (`id`);
399
400--
401-- Indexes for table `pubgpickups`
402--
403ALTER TABLE `pubgpickups`
404 ADD PRIMARY KEY (`id`);
405
406--
407-- Indexes for table `tournament`
408--
409ALTER TABLE `tournament`
410 ADD PRIMARY KEY (`TID`);
411
412--
413-- AUTO_INCREMENT for dumped tables
414--
415
416--
417-- AUTO_INCREMENT for table `admins`
418--
419ALTER TABLE `admins`
420MODIFY `accid` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1319275;
421--
422-- AUTO_INCREMENT for table `bans`
423--
424ALTER TABLE `bans`
425MODIFY `bid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=191826;
426--
427-- AUTO_INCREMENT for table `clanhistory`
428--
429ALTER TABLE `clanhistory`
430MODIFY `hid` int(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5410;
431--
432-- AUTO_INCREMENT for table `clans`
433--
434ALTER TABLE `clans`
435MODIFY `cid` int(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1757;
436--
437-- AUTO_INCREMENT for table `clantoys`
438--
439ALTER TABLE `clantoys`
440MODIFY `toyid` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=64;
441--
442-- AUTO_INCREMENT for table `friends`
443--
444ALTER TABLE `friends`
445MODIFY `fid` int(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=621;
446--
447-- AUTO_INCREMENT for table `name_logs`
448--
449ALTER TABLE `name_logs`
450MODIFY `id` int(16) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5197;
451--
452-- AUTO_INCREMENT for table `playerbase`
453--
454ALTER TABLE `playerbase`
455MODIFY `id` int(16) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1657663;
456--
457-- AUTO_INCREMENT for table `pubgpickups`
458--
459ALTER TABLE `pubgpickups`
460MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=860;
461--
462-- AUTO_INCREMENT for table `tournament`
463--
464ALTER TABLE `tournament`
465MODIFY `TID` int(20) NOT NULL AUTO_INCREMENT;
466DELIMITER $$
467--
468-- Events
469--
470CREATE DEFINER=`root`@`localhost` EVENT `Quests System` ON SCHEDULE EVERY 1 DAY STARTS '2018-02-28 00:00:00' ENDS '2026-08-26 00:00:00' ON COMPLETION NOT PRESERVE ENABLE COMMENT 'Quests System' DO UPDATE `playerbase` SET `quests`='00000'$$
471
472DELIMITER ;
473
474/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
475/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
476/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;