· 8 years ago · Jan 24, 2018, 05:56 AM
1-- dump by formatme
2-- https://citizenhack.me/drama/
3
4-- --------------------------------------------------------
5-- Host: 127.0.0.1
6-- Server version: 10.1.6-MariaDB - mariadb.org binary distribution
7-- Server OS: Win64
8-- HeidiSQL Version: 9.3.0.4984
9-- --------------------------------------------------------
10
11/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
12/*!40101 SET NAMES utf8mb4 */;
13/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
14/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
15
16-- Dumping database structure for badmin
17CREATE DATABASE IF NOT EXISTS `badmin` /*!40100 DEFAULT CHARACTER SET latin1 */;
18USE `badmin`;
19
20
21-- Dumping structure for table badmin.ba_bans
22CREATE TABLE IF NOT EXISTS `ba_bans` (
23 `steamid` bigint(20) NOT NULL,
24 `ip` varchar(39) NOT NULL,
25 `name` varchar(255) NOT NULL,
26 `reason` varchar(255) NOT NULL,
27 `a_steamid` bigint(20) NOT NULL,
28 `a_name` varchar(255) NOT NULL,
29 `ban_time` int(11) NOT NULL,
30 `ban_len` int(11) NOT NULL,
31 `unban_time` int(11) NOT NULL,
32 `unban_reason` varchar(255) DEFAULT NULL
33) ENGINE=MyISAM DEFAULT CHARSET=latin1;
34
35-- Dumping data for table badmin.ba_bans: 0 rows
36/*!40000 ALTER TABLE `ba_bans` DISABLE KEYS */;
37/*!40000 ALTER TABLE `ba_bans` ENABLE KEYS */;
38
39
40-- Dumping structure for table badmin.ba_cheaters
41CREATE TABLE IF NOT EXISTS `ba_cheaters` (
42 `steamid` bigint(20) NOT NULL,
43 `date` int(11) NOT NULL,
44 `infractions` text NOT NULL,
45 `screengrab` longblob NOT NULL
46) ENGINE=MyISAM DEFAULT CHARSET=latin1;
47
48-- Dumping data for table badmin.ba_cheaters: 0 rows
49/*!40000 ALTER TABLE `ba_cheaters` DISABLE KEYS */;
50/*!40000 ALTER TABLE `ba_cheaters` ENABLE KEYS */;
51
52
53-- Dumping structure for table badmin.ba_hashlog
54CREATE TABLE IF NOT EXISTS `ba_hashlog` (
55 `steamid` bigint(20) NOT NULL,
56 `lastseen` int(11) NOT NULL,
57 `hashid` char(64) NOT NULL,
58 PRIMARY KEY (`steamid`,`hashid`)
59) ENGINE=MyISAM DEFAULT CHARSET=latin1;
60
61-- Dumping data for table badmin.ba_hashlog: 0 rows
62/*!40000 ALTER TABLE `ba_hashlog` DISABLE KEYS */;
63/*!40000 ALTER TABLE `ba_hashlog` ENABLE KEYS */;
64
65
66-- Dumping structure for table badmin.ba_iplog
67CREATE TABLE IF NOT EXISTS `ba_iplog` (
68 `steamid` bigint(20) NOT NULL,
69 `lastseen` int(11) NOT NULL,
70 `ip` varchar(30) NOT NULL,
71 PRIMARY KEY (`steamid`,`ip`)
72) ENGINE=MyISAM DEFAULT CHARSET=latin1;
73
74-- Dumping data for table badmin.ba_iplog: 0 rows
75/*!40000 ALTER TABLE `ba_iplog` DISABLE KEYS */;
76/*!40000 ALTER TABLE `ba_iplog` ENABLE KEYS */;
77
78
79-- Dumping structure for table badmin.ba_keys
80CREATE TABLE IF NOT EXISTS `ba_keys` (
81 `Date` int(11) NOT NULL,
82 `Key` varchar(64) NOT NULL,
83 PRIMARY KEY (`Date`,`Key`)
84) ENGINE=MyISAM DEFAULT CHARSET=latin1;
85
86-- Dumping data for table badmin.ba_keys: 0 rows
87/*!40000 ALTER TABLE `ba_keys` DISABLE KEYS */;
88/*!40000 ALTER TABLE `ba_keys` ENABLE KEYS */;
89
90
91-- Dumping structure for table badmin.ba_ranks
92CREATE TABLE IF NOT EXISTS `ba_ranks` (
93 `steamid` bigint(20) NOT NULL,
94 `sv_id` varchar(50) NOT NULL,
95 `rank` tinyint(4) NOT NULL,
96 `expire_rank` tinyint(4) NOT NULL,
97 `expire_time` int(11) NOT NULL,
98 PRIMARY KEY (`sv_id`,`steamid`)
99) ENGINE=MyISAM DEFAULT CHARSET=latin1;
100
101-- Dumping data for table badmin.ba_ranks: 0 rows
102/*!40000 ALTER TABLE `ba_ranks` DISABLE KEYS */;
103/*!40000 ALTER TABLE `ba_ranks` ENABLE KEYS */;
104
105
106-- Dumping structure for table badmin.ba_server_vars
107CREATE TABLE IF NOT EXISTS `ba_server_vars` (
108 `sv_uid` bigint(20) NOT NULL,
109 `var` varchar(50) NOT NULL,
110 `data` text NOT NULL,
111 PRIMARY KEY (`sv_uid`,`var`)
112) ENGINE=MyISAM DEFAULT CHARSET=latin1;
113
114-- Dumping data for table badmin.ba_server_vars: 83 rows
115/*!40000 ALTER TABLE `ba_server_vars` DISABLE KEYS */;
116INSERT INTO `ba_server_vars` (`sv_uid`, `var`, `data`) VALUES
117 (2402779306, 'sv_id', 'RP'),
118 (2402779306, 'motd', 'http://superiorservers.co/forums/index.php?/topic/3345-info-darkrp-motd/'),
119 (1631183238, 'sv_id', 'RP'),
120 (1631183238, 'adminroom', '{v3112.0388183594,-2559.4626464844,760.03125;}'),
121 (1439138578, 'sv_id', 'RP'),
122 (1439138578, 'adminroom', '{v-2234.0561523438,-2553.8786621094,2848.03125;}'),
123 (1439138578, 'motd', 'http://superiorservers.co/forums/index.php?/topic/3164-buildrp-motd-wip/'),
124 (373215504, 'sv_id', 'DZ'),
125 (626174185, 'sv_id', 'RP'),
126 (626174185, 'motd', 'http://www.superiorservers.co/forums/index.php?/topic/550-purgerp-motd/'),
127 (3160144211, 'sv_id', 'RP'),
128 (3160144211, 'motd', 'http://superiorservers.co/forums/index.php?/topic/3345-info-darkrp-motd/'),
129 (3160144211, 'adminroom', '{v-1797.6447753906,-1459.7502441406,-2026.96875;}'),
130 (2402779306, 'adminroom', '{v-1964.5075683594,-1603.2209472656,-2026.96875;}'),
131 (1503444667, 'sv_id', 'ZS'),
132 (3820012772, 'sv_id', 'MG'),
133 (626174185, 'adminroom', '{v-1620.3804931641,155.23602294922,1680.03125;}'),
134 (1631183238, 'motd', 'http://superiorservers.co/forums/'),
135 (1631183238, 'jailroom', '{v-5808.1123046875,-1727.3570556641,-676.66174316406;}'),
136 (3160144211, 'jailroom', '{v-5843.9873046875,-1700.0659179688,-676.66174316406;}'),
137 (2402779306, 'jailroom', '{v-5955.7241210938,-1640.767578125,-676.66174316406;}'),
138 (1872847141, 'sv_id', 'RP'),
139 (1872847141, 'motd', 'http://portal.superiorservers.co/darkrp/rules.php'),
140 (1872847141, 'adminroom', '{v-18.006568908691,-1026.92578125,-1271.96875;}'),
141 (1872847141, 'jailroom', '{v-5838.302734375,-1720.6884765625,-676.66174316406;}'),
142 (355685891, 'sv_id', 'RP'),
143 (670377264, 'sv_id', 'RP'),
144 (670377264, 'motd', 'http://portal.superiorservers.co/darkrp/rules.php'),
145 (4138217631, 'sv_id', 'RP'),
146 (4138217631, 'motd', 'http://google.com'),
147 (2737997100, 'sv_id', 'RP'),
148 (2737997100, 'adminroom', '{v42.11157989502,-1182.1411132812,-1271.96875;}'),
149 (2737997100, 'jailroom', '{v-5983.5073242188,-1745.9582519531,-676.66174316406;}'),
150 (2737997100, 'motd', 'http://portal.superiorservers.co/darkrp/rules.php'),
151 (976999574, 'motd', 'http://worldsbiggestpacman.com/play/#-14,-16'),
152 (3542923870, 'sv_id', 'DEV'),
153 (3230680013, 'sv_id', 'MG'),
154 (2604486280, 'sv_id', 'MG'),
155 (3791095085, 'sv_id', 'MG'),
156 (3812087126, 'sv_id', 'MG'),
157 (393802053, 'sv_id', 'MG'),
158 (1991217285, 'sv_id', 'MG'),
159 (1840829109, 'sv_id', 'RK'),
160 (3249741514, 'sv_id', 'RP'),
161 (3249741514, 'motd', 'http://superiorservers.co/portal/rp_rules.php'),
162 (3249741514, 'adminroom', '{v-1.6267499923706,-1036.0638427734,-1271.96875;}'),
163 (3249741514, 'jailroom', '{v-5928.6948242188,-1757.7625732422,-676.66174316406;}'),
164 (2352613305, 'sv_id', 'RP'),
165 (268367792, 'sv_id', 'RP'),
166 (268367792, 'motd', 'http://portal.superiorservers.co/darkrp/rules.php'),
167 (268367792, 'adminroom', '{v2.8972434997559,-1033.5462646484,-1271.96875;}'),
168 (268367792, 'jailroom', '{v-6036.2680664062,-1588.8415527344,-676.66174316406;}'),
169 (670377264, 'adminroom', '{v-41.880130767822,-1018.1391601562,-1271.96875;}'),
170 (670377264, 'jailroom', '{v-5890.2265625,-1632.365234375,-676.66174316406;}'),
171 (2352613305, 'adminroom', '{v-57.604621887207,-1044.5614013672,-1271.96875;}'),
172 (2352613305, 'jailroom', '{v-5927.6103515625,-1687.0061035156,-676.66174316406;}'),
173 (2352613305, 'motd', 'http://portal.superiorservers.co/darkrp/rules.php'),
174 (3777901765, 'sv_id', 'RP'),
175 (3777901765, 'motd', 'http://portal.superiorservers.co/darkrp/rules.php'),
176 (3777901765, 'adminroom', '{v-31.559541702271,-1068.2854003906,-1271.96875;}'),
177 (3777901765, 'jailroom', '{v-5859.5795898438,-1654.1475830078,-676.66174316406;}'),
178 (4066953433, 'sv_id', 'MG'),
179 (344537317, 'sv_id', 'MG'),
180 (3949661607, 'sv_id', 'MG'),
181 (3843611242, 'sv_id', 'RP'),
182 (3843611242, 'adminroom', '{v12.772783279419,-1191.7110595703,-1271.96875;}'),
183 (3843611242, 'jailroom', '{v-6034.6723632813,-1539.9251708984,-676.66174316406;}'),
184 (3843611242, 'motd', 'http://portal.superiorservers.co/darkrp/rules.php'),
185 (2081524688, 'sv_id', 'RP'),
186 (2081524688, 'adminroom', '{v13.5163230896,-1060.2637939453,-1271.96875;}'),
187 (2081524688, 'jailroom', '{v-6014.9975585938,-1683.8203125,-676.66174316406;}'),
188 (231214202, 'sv_id', 'RP'),
189 (231214202, 'adminroom', '{v64.563026428223,-1058.341796875,-1271.96875;}'),
190 (231214202, 'jailroom', '{v-5902.703125,-1791.1955566406,-676.66174316406;}'),
191 (231214202, 'motd', 'http://portal.superiorservers.co/darkrp/rules.php'),
192 (2293410421, 'sv_id', 'MG'),
193 (3651884439, 'sv_id', 'RP'),
194 (3651884439, 'motd', 'https://portal.superiorservers.co/darkrp/rules.php'),
195 (3651884439, 'adminroom', '{v-9.191743850708,-1003.5335083008,-1271.96875;}'),
196 (3651884439, 'jailroom', '{v-5914.8676757813,-1744.6976318359,-676.66174316406;}'),
197 (1312048318, 'sv_id', 'RP'),
198 (1312048318, 'adminroom', '{v-29.274299621582,-1047.1986083984,-1271.96875;}'),
199 (1312048318, 'jailroom', '{v-5868.671875,-1682.2652587891,-676.66174316406;}');
200/*!40000 ALTER TABLE `ba_server_vars` ENABLE KEYS */;
201
202
203-- Dumping structure for table badmin.ba_users
204CREATE TABLE IF NOT EXISTS `ba_users` (
205 `steamid` bigint(20) NOT NULL,
206 `name` varchar(255) NOT NULL,
207 `firstjoined` int(11) DEFAULT NULL,
208 `lastseen` int(11) NOT NULL,
209 `playtime` int(11) DEFAULT NULL,
210 PRIMARY KEY (`steamid`),
211 KEY `steamid` (`steamid`)
212) ENGINE=MyISAM DEFAULT CHARSET=latin1;
213
214-- Dumping data for table badmin.ba_users: 0 rows
215/*!40000 ALTER TABLE `ba_users` DISABLE KEYS */;
216/*!40000 ALTER TABLE `ba_users` ENABLE KEYS */;
217
218
219-- Dumping structure for table badmin.steamgroupawards
220CREATE TABLE IF NOT EXISTS `steamgroupawards` (
221 `SteamID64` bigint(20) DEFAULT NULL,
222 `InSteamGroup` tinyint(1) DEFAULT '1',
223 `AwardGiven` tinyint(1) DEFAULT '0',
224 `NextAskTime` bigint(20) DEFAULT '1'
225) ENGINE=MyISAM DEFAULT CHARSET=utf8;
226
227-- Dumping data for table badmin.steamgroupawards: 0 rows
228/*!40000 ALTER TABLE `steamgroupawards` DISABLE KEYS */;
229/*!40000 ALTER TABLE `steamgroupawards` ENABLE KEYS */;
230/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
231/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
232/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;