· 6 years ago · Apr 24, 2019, 11:56 AM
1-- phpMyAdmin SQL Dump
2-- version 4.0.10deb1ubuntu0.1
3-- http://www.phpmyadmin.net
4--
5-- Palvelin: localhost
6-- Luontiaika: 24.04.2019 klo 02:04
7-- Palvelimen versio: 5.5.62-0ubuntu0.14.04.1
8-- PHP:n versio: 5.5.9-1ubuntu4.27
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-- Tietokanta: `banlist`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Rakenne taululle `amx_admins_servers`
27--
28
29CREATE TABLE IF NOT EXISTS `amx_admins_servers` (
30 `admin_id` int(11) NOT NULL,
31 `server_id` int(11) NOT NULL,
32 `custom_flags` varchar(32) DEFAULT NULL,
33 `use_static_bantime` enum('yes','no') DEFAULT 'yes',
34 UNIQUE KEY `custom_flags` (`custom_flags`),
35 UNIQUE KEY `use_static_bantime` (`use_static_bantime`)
36) ENGINE=MyISAM DEFAULT CHARSET=utf8;
37
38--
39-- Vedos taulusta `amx_admins_servers`
40--
41
42INSERT INTO `amx_admins_servers` (`admin_id`, `server_id`, `custom_flags`, `use_static_bantime`) VALUES
43(1, 1, NULL, 'yes'),
44(1, 2, '', 'no');
45
46-- --------------------------------------------------------
47
48--
49-- Rakenne taululle `amx_amxadmins`
50--
51
52CREATE TABLE IF NOT EXISTS `amx_amxadmins` (
53 `id` int(12) NOT NULL AUTO_INCREMENT,
54 `username` varchar(32) NOT NULL,
55 `password` varchar(50) NOT NULL,
56 `access` varchar(32) NOT NULL,
57 `flags` varchar(32) NOT NULL,
58 `steamid` varchar(32) NOT NULL,
59 `nickname` varchar(32) NOT NULL,
60 `icq` int(9) NOT NULL,
61 `ashow` int(11) NOT NULL,
62 `created` int(11) NOT NULL,
63 `expired` int(11) NOT NULL,
64 `days` int(11) NOT NULL,
65 PRIMARY KEY (`id`),
66 KEY `steamid` (`steamid`)
67) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
68
69--
70-- Vedos taulusta `amx_amxadmins`
71--
72
73INSERT INTO `amx_amxadmins` (`id`, `username`, `password`, `access`, `flags`, `steamid`, `nickname`, `icq`, `ashow`, `created`, `expired`, `days`) VALUES
74(1, 'STEAM_0:1:10086423', '81dee785b1f726bfe27c250d5192988e', 'abcdefghijklmnopqrstu', 'ce', 'STEAM_0:1:453829412', 'DateN', 0, 1, 1555757834, 0, 0),
75(7, 'krMM', 'b2baf08fb2b61e4ab7b67afb594b1864', 'abcdefghijklmnopqrstu', 'ce', 'STEAM_0:0:53463601', 'krMM', 0, 0, 1556051363, 0, 0),
76(3, 'testike', 'c458164a4987a55cb2849bc26e09d381', 'bit', 'a', 'testike', 'testike', 0, 1, 1555889855, 1561419480, 64);
77
78-- --------------------------------------------------------
79
80--
81-- Rakenne taululle `amx_bans`
82--
83
84CREATE TABLE IF NOT EXISTS `amx_bans` (
85 `bid` int(11) NOT NULL AUTO_INCREMENT,
86 `player_ip` varchar(32) NOT NULL,
87 `player_id` varchar(35) NOT NULL,
88 `player_nick` varchar(100) NOT NULL DEFAULT 'Unknown',
89 `admin_ip` varchar(32) NOT NULL,
90 `admin_id` varchar(35) DEFAULT 'Unknown',
91 `admin_nick` varchar(100) NOT NULL DEFAULT 'Unknown',
92 `ban_type` varchar(10) NOT NULL DEFAULT 'S',
93 `ban_reason` varchar(100) NOT NULL,
94 `cs_ban_reason` varchar(100) NOT NULL,
95 `ban_created` int(11) NOT NULL,
96 `ban_length` int(11) NOT NULL,
97 `server_ip` varchar(32) NOT NULL,
98 `server_name` varchar(100) NOT NULL DEFAULT 'Unknown',
99 `ban_kicks` int(11) DEFAULT '0',
100 `expired` int(1) DEFAULT '0',
101 `imported` int(1) DEFAULT '0',
102 PRIMARY KEY (`bid`),
103 UNIQUE KEY `ban_kicks` (`ban_kicks`),
104 UNIQUE KEY `expired` (`expired`),
105 UNIQUE KEY `imported` (`imported`),
106 KEY `player_id` (`player_id`)
107) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
108
109-- --------------------------------------------------------
110
111--
112-- Rakenne taululle `amx_bans_edit`
113--
114
115CREATE TABLE IF NOT EXISTS `amx_bans_edit` (
116 `id` int(11) NOT NULL AUTO_INCREMENT,
117 `bid` int(11) DEFAULT NULL,
118 `edit_time` int(11) DEFAULT NULL,
119 `admin_nick` varchar(32) DEFAULT 'unknown',
120 `edit_reason` varchar(255) DEFAULT NULL,
121 PRIMARY KEY (`id`),
122 UNIQUE KEY `id` (`id`),
123 UNIQUE KEY `bid` (`bid`),
124 UNIQUE KEY `edit_time` (`edit_time`),
125 UNIQUE KEY `admin_nick` (`admin_nick`),
126 UNIQUE KEY `edit_reason` (`edit_reason`)
127) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
128
129-- --------------------------------------------------------
130
131--
132-- Rakenne taululle `amx_bbcode`
133--
134
135CREATE TABLE IF NOT EXISTS `amx_bbcode` (
136 `id` int(11) NOT NULL AUTO_INCREMENT,
137 `open_tag` varchar(32) NOT NULL,
138 `close_tag` varchar(32) NOT NULL,
139 `url` varchar(32) NOT NULL,
140 `name` varchar(32) NOT NULL,
141 PRIMARY KEY (`id`)
142) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
143
144--
145-- Vedos taulusta `amx_bbcode`
146--
147
148INSERT INTO `amx_bbcode` (`id`, `open_tag`, `close_tag`, `url`, `name`) VALUES
149(1, '[b]', '[/b]', 'bold.png', 'bold'),
150(2, '[i]', '[/i]', 'italic.png', 'italic'),
151(3, '[u]', '[/u]', 'underline.png', 'underline'),
152(4, '[center]', '[/center]', 'center.png', 'center');
153
154-- --------------------------------------------------------
155
156--
157-- Rakenne taululle `amx_comments`
158--
159
160CREATE TABLE IF NOT EXISTS `amx_comments` (
161 `id` int(11) NOT NULL AUTO_INCREMENT,
162 `name` varchar(35) NOT NULL,
163 `comment` text NOT NULL,
164 `email` varchar(100) NOT NULL,
165 `addr` varchar(32) NOT NULL,
166 `date` int(11) NOT NULL,
167 `bid` int(11) NOT NULL,
168 PRIMARY KEY (`id`)
169) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
170
171-- --------------------------------------------------------
172
173--
174-- Rakenne taululle `amx_files`
175--
176
177CREATE TABLE IF NOT EXISTS `amx_files` (
178 `id` int(11) NOT NULL AUTO_INCREMENT,
179 `upload_time` int(11) NOT NULL,
180 `down_count` int(11) NOT NULL,
181 `bid` int(11) NOT NULL,
182 `demo_file` varchar(100) NOT NULL,
183 `demo_real` varchar(100) NOT NULL,
184 `file_size` int(11) NOT NULL,
185 `comment` text NOT NULL,
186 `name` varchar(64) NOT NULL,
187 `email` varchar(64) NOT NULL,
188 `addr` varchar(32) NOT NULL,
189 PRIMARY KEY (`id`)
190) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
191
192-- --------------------------------------------------------
193
194--
195-- Rakenne taululle `amx_flagged`
196--
197
198CREATE TABLE IF NOT EXISTS `amx_flagged` (
199 `fid` int(11) NOT NULL AUTO_INCREMENT,
200 `player_ip` varchar(32) DEFAULT NULL,
201 `player_id` varchar(35) DEFAULT NULL,
202 `player_nick` varchar(100) DEFAULT 'Unknown',
203 `admin_ip` varchar(32) DEFAULT NULL,
204 `admin_id` varchar(35) DEFAULT NULL,
205 `admin_nick` varchar(100) DEFAULT 'Unknown',
206 `reason` varchar(100) DEFAULT NULL,
207 `created` int(11) DEFAULT NULL,
208 `length` int(11) DEFAULT NULL,
209 `server_ip` varchar(100) DEFAULT NULL,
210 PRIMARY KEY (`fid`),
211 KEY `player_id` (`player_id`)
212) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
213
214-- --------------------------------------------------------
215
216--
217-- Rakenne taululle `amx_levels`
218--
219
220CREATE TABLE IF NOT EXISTS `amx_levels` (
221 `level` int(12) NOT NULL,
222 `bans_add` enum('yes','no') NOT NULL DEFAULT 'no',
223 `bans_edit` enum('yes','no','own') NOT NULL DEFAULT 'no',
224 `bans_delete` enum('yes','no','own') NOT NULL DEFAULT 'no',
225 `bans_unban` enum('yes','no','own') NOT NULL DEFAULT 'no',
226 `bans_import` enum('yes','no') NOT NULL DEFAULT 'no',
227 `bans_export` enum('yes','no') NOT NULL DEFAULT 'no',
228 `amxadmins_view` enum('yes','no') NOT NULL DEFAULT 'no',
229 `amxadmins_edit` enum('yes','no') NOT NULL DEFAULT 'no',
230 `webadmins_view` enum('yes','no') NOT NULL DEFAULT 'no',
231 `webadmins_edit` enum('yes','no') NOT NULL DEFAULT 'no',
232 `websettings_view` enum('yes','no') NOT NULL DEFAULT 'no',
233 `websettings_edit` enum('yes','no') NOT NULL DEFAULT 'no',
234 `permissions_edit` enum('yes','no') NOT NULL DEFAULT 'no',
235 `prune_db` enum('yes','no') NOT NULL DEFAULT 'no',
236 `servers_edit` enum('yes','no') NOT NULL DEFAULT 'no',
237 `ip_view` enum('yes','no') NOT NULL DEFAULT 'no',
238 PRIMARY KEY (`level`)
239) ENGINE=MyISAM DEFAULT CHARSET=utf8;
240
241--
242-- Vedos taulusta `amx_levels`
243--
244
245INSERT INTO `amx_levels` (`level`, `bans_add`, `bans_edit`, `bans_delete`, `bans_unban`, `bans_import`, `bans_export`, `amxadmins_view`, `amxadmins_edit`, `webadmins_view`, `webadmins_edit`, `websettings_view`, `websettings_edit`, `permissions_edit`, `prune_db`, `servers_edit`, `ip_view`) VALUES
246(1, 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes');
247
248-- --------------------------------------------------------
249
250--
251-- Rakenne taululle `amx_logs`
252--
253
254CREATE TABLE IF NOT EXISTS `amx_logs` (
255 `id` int(11) NOT NULL AUTO_INCREMENT,
256 `timestamp` int(11) NOT NULL,
257 `ip` varchar(32) NOT NULL,
258 `username` varchar(32) NOT NULL,
259 `action` varchar(64) NOT NULL,
260 `remarks` varchar(256) NOT NULL,
261 PRIMARY KEY (`id`)
262) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=40 ;
263
264--
265-- Vedos taulusta `amx_logs`
266--
267
268INSERT INTO `amx_logs` (`id`, `timestamp`, `ip`, `username`, `action`, `remarks`) VALUES
269(1, 1555756643, '85.76.42.75', 'admin', 'Install', 'Installation AMXBans Gm 1.6'),
270(2, 1555756778, '85.76.42.75', 'admin', 'Webadmin config', 'Edited user: admin (id: 1) changed password'),
271(3, 1555757834, '85.76.42.75', 'admin', 'AMXXAdmin config', 'Added admin: STEAM_0:1:10086423'),
272(4, 1555757933, '85.76.42.75', 'admin', 'Websetting config', 'Changed'),
273(5, 1555758017, '85.76.42.75', 'admin', 'Websetting config', 'Changed'),
274(6, 1555758027, '85.76.42.75', 'admin', 'Websetting config', 'Changed'),
275(7, 1555758080, '85.76.42.75', 'admin', 'Websetting config', 'Changed'),
276(8, 1555758087, '85.76.42.75', 'admin', 'Websetting config', 'Changed'),
277(9, 1555758108, '85.76.42.75', 'admin', 'Websetting config', 'Changed'),
278(10, 1555758120, '85.76.42.75', 'admin', 'Websetting config', 'Changed'),
279(11, 1555758128, '85.76.42.75', 'admin', 'Websetting config', 'Changed'),
280(12, 1555758131, '85.76.42.75', 'admin', 'Websetting config', 'Changed'),
281(13, 1555758171, '85.76.42.75', 'admin', 'Websetting config', 'Changed'),
282(14, 1555758190, '85.76.42.75', 'admin', 'Websetting config', 'Changed'),
283(15, 1555759671, '85.76.42.75', 'admin', 'Websetting config', 'Changed'),
284(16, 1555759697, '85.76.42.75', 'admin', 'Websetting config', 'Changed'),
285(17, 1555761655, '85.76.42.75', 'admin', 'Websetting config', 'Changed'),
286(18, 1555761660, '85.76.42.75', 'admin', 'Websetting config', 'Changed'),
287(19, 1555761676, '85.76.42.75', 'admin', 'Websetting config', 'Changed'),
288(20, 1555761680, '85.76.42.75', 'admin', 'Websetting config', 'Changed'),
289(21, 1555761817, '85.76.42.75', 'admin', 'Websetting config', 'Changed'),
290(22, 1555761821, '85.76.42.75', 'admin', 'Websetting config', 'Changed'),
291(23, 1555762054, '85.76.42.75', 'admin', 'Websetting config', 'Changed'),
292(24, 1555762067, '85.76.42.75', 'admin', 'Websetting config', 'Changed'),
293(25, 1555889377, '85.76.42.9', 'admin', 'Login failed', 'login failed (try: 1/3)'),
294(26, 1555889384, '85.76.42.9', 'admin', 'Login failed', 'login failed (try: 2/3)'),
295(27, 1555889591, '83.166.60.207', 'admin', 'AMXXAdmin config', 'Edited admin: STEAM_0:0:53463601 (nick: krMM)'),
296(28, 1555889597, '83.166.60.207', 'admin', 'AMXXAdmin config', 'Edited admin: STEAM_0:0:53463601 (nick: krMM)'),
297(29, 1555959020, '83.166.60.207', 'admin', 'AMXXAdmin config', 'Deleted admin: STEAM_0:0:53463601'),
298(30, 1555959052, '83.166.60.207', 'admin', 'AMXXAdmin config', 'Edited admin: krMM (nick: krMM)'),
299(31, 1556051204, '83.166.60.207', 'admin', 'AMXXAdmin config', 'Edited admin: krMM (nick: krMM)'),
300(32, 1556051206, '83.166.60.207', 'admin', 'AMXXAdmin config', 'Deleted admin: krMM'),
301(33, 1556051310, '83.166.60.207', 'admin', 'AMXXAdmin config', 'Edited admin: krMM (nick: krMM)'),
302(34, 1556051311, '83.166.60.207', 'admin', 'AMXXAdmin config', 'Deleted admin: krMM'),
303(35, 1556051352, '83.166.60.207', 'admin', 'AMXXAdmin config', 'Deleted admin: krMM'),
304(36, 1556058969, '85.76.42.9', 'admin', 'Login failed', 'login failed (try: 1/3)'),
305(37, 1556058981, '85.76.42.9', 'admin', 'Login failed', 'login failed (try: 2/3)'),
306(38, 1556059051, '85.76.42.9', 'admin', 'Server Admin config', 'Edited admins on server: [E]esti Laskurid | Surf [FastDL]'),
307(39, 1556059109, '85.76.42.9', 'admin', 'AMXXAdmin config', 'Edited admin: STEAM_0:1:10086423 (nick: DateN)');
308
309-- --------------------------------------------------------
310
311--
312-- Rakenne taululle `amx_modulconfig`
313--
314
315CREATE TABLE IF NOT EXISTS `amx_modulconfig` (
316 `id` int(11) NOT NULL AUTO_INCREMENT,
317 `menuname` varchar(32) NOT NULL,
318 `name` varchar(32) NOT NULL,
319 `index` varchar(32) NOT NULL,
320 `activ` int(1) DEFAULT '1',
321 PRIMARY KEY (`id`),
322 UNIQUE KEY `activ` (`activ`)
323) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
324
325--
326-- Vedos taulusta `amx_modulconfig`
327--
328
329INSERT INTO `amx_modulconfig` (`id`, `menuname`, `name`, `index`, `activ`) VALUES
330(1, '_MENUIMPORTEXPORT', 'iexport', '', 1);
331
332-- --------------------------------------------------------
333
334--
335-- Rakenne taululle `amx_reasons`
336--
337
338CREATE TABLE IF NOT EXISTS `amx_reasons` (
339 `id` int(11) NOT NULL AUTO_INCREMENT,
340 `reason` varchar(100) NOT NULL,
341 `static_bantime` int(11) DEFAULT '0',
342 PRIMARY KEY (`id`),
343 UNIQUE KEY `static_bantime` (`static_bantime`)
344) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
345
346-- --------------------------------------------------------
347
348--
349-- Rakenne taululle `amx_reasons_set`
350--
351
352CREATE TABLE IF NOT EXISTS `amx_reasons_set` (
353 `id` int(11) NOT NULL AUTO_INCREMENT,
354 `setname` varchar(32) NOT NULL,
355 PRIMARY KEY (`id`)
356) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
357
358-- --------------------------------------------------------
359
360--
361-- Rakenne taululle `amx_reasons_to_set`
362--
363
364CREATE TABLE IF NOT EXISTS `amx_reasons_to_set` (
365 `id` int(11) NOT NULL AUTO_INCREMENT,
366 `setid` int(11) DEFAULT NULL,
367 `reasonid` int(11) DEFAULT NULL,
368 PRIMARY KEY (`id`),
369 UNIQUE KEY `setid` (`setid`),
370 UNIQUE KEY `reasonid` (`reasonid`)
371) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
372
373-- --------------------------------------------------------
374
375--
376-- Rakenne taululle `amx_serverinfo`
377--
378
379CREATE TABLE IF NOT EXISTS `amx_serverinfo` (
380 `id` int(11) NOT NULL AUTO_INCREMENT,
381 `timestamp` int(11) NOT NULL,
382 `hostname` varchar(100) NOT NULL DEFAULT 'Unknown',
383 `address` varchar(100) NOT NULL,
384 `gametype` varchar(32) NOT NULL,
385 `rcon` varchar(32) NOT NULL,
386 `amxban_version` varchar(32) NOT NULL,
387 `amxban_motd` varchar(250) NOT NULL,
388 `motd_delay` int(10) DEFAULT '10',
389 `amxban_menu` int(10) DEFAULT '1',
390 `reasons` int(10) NOT NULL,
391 `timezone_fixx` int(11) DEFAULT '0',
392 PRIMARY KEY (`id`),
393 UNIQUE KEY `motd_delay` (`motd_delay`),
394 UNIQUE KEY `amxban_menu` (`amxban_menu`),
395 UNIQUE KEY `timezone_fixx` (`timezone_fixx`)
396) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
397
398--
399-- Vedos taulusta `amx_serverinfo`
400--
401
402INSERT INTO `amx_serverinfo` (`id`, `timestamp`, `hostname`, `address`, `gametype`, `rcon`, `amxban_version`, `amxban_motd`, `motd_delay`, `amxban_menu`, `reasons`, `timezone_fixx`) VALUES
403(1, 1556059714, '[E]esti Laskurid | Public [FreeViP]', '195.181.241.202:27015', 'cstrike', '', '1.6', '', 10, 1, 0, 0);
404
405-- --------------------------------------------------------
406
407--
408-- Rakenne taululle `amx_smilies`
409--
410
411CREATE TABLE IF NOT EXISTS `amx_smilies` (
412 `id` int(5) NOT NULL AUTO_INCREMENT,
413 `code` varchar(32) NOT NULL,
414 `url` varchar(32) NOT NULL,
415 `name` varchar(32) NOT NULL,
416 PRIMARY KEY (`id`)
417) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
418
419--
420-- Vedos taulusta `amx_smilies`
421--
422
423INSERT INTO `amx_smilies` (`id`, `code`, `url`, `name`) VALUES
424(1, ':D', 'big_smile.png', 'Big Grin'),
425(2, '8)', 'cool.png', 'Cool'),
426(3, ':/', 'hmm.png', 'Hmm'),
427(4, 'lol', 'lol.png', 'lol'),
428(5, ':(', 'mad.png', 'Mad'),
429(6, ':|', 'neutral.png', 'Neutral'),
430(7, ':roll:', 'roll.png', 'RollEyes'),
431(8, ':*(', 'sad.png', 'Sad'),
432(9, ':)', 'smile.png', 'Smilie'),
433(10, ':P', 'tongue.png', 'Tongue'),
434(11, ';)', 'wink.png', 'Wink'),
435(12, ':O', 'yikes.png', 'Yikes');
436
437-- --------------------------------------------------------
438
439--
440-- Rakenne taululle `amx_usermenu`
441--
442
443CREATE TABLE IF NOT EXISTS `amx_usermenu` (
444 `id` int(11) NOT NULL AUTO_INCREMENT,
445 `pos` int(11) NOT NULL,
446 `activ` tinyint(1) NOT NULL DEFAULT '1',
447 `lang_key` varchar(64) NOT NULL,
448 `url` varchar(64) NOT NULL,
449 `lang_key2` varchar(64) NOT NULL,
450 `url2` varchar(64) NOT NULL,
451 PRIMARY KEY (`id`)
452) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
453
454--
455-- Vedos taulusta `amx_usermenu`
456--
457
458INSERT INTO `amx_usermenu` (`id`, `pos`, `activ`, `lang_key`, `url`, `lang_key2`, `url2`) VALUES
459(1, 1, 1, '_HOME', 'index.php', '_HOME', 'index.php'),
460(2, 2, 1, '_BANLIST', 'ban_list.php', '_BANLIST', 'ban_list.php'),
461(3, 3, 1, '_ADMLIST', 'admin_list.php', '_ADMLIST', 'admin_list.php'),
462(4, 4, 1, '_SEARCH', 'search.php', '_SEARCH', 'search.php'),
463(5, 5, 1, '_SERVER', 'view.php', '_SERVER', 'view.php'),
464(6, 6, 1, '_LOGIN', 'login.php', '_LOGOUT', 'logout.php');
465
466-- --------------------------------------------------------
467
468--
469-- Rakenne taululle `amx_webadmins`
470--
471
472CREATE TABLE IF NOT EXISTS `amx_webadmins` (
473 `id` int(12) NOT NULL AUTO_INCREMENT,
474 `username` varchar(32) NOT NULL,
475 `password` varchar(32) NOT NULL,
476 `level` int(11) NOT NULL DEFAULT '99',
477 `logcode` varchar(64) NOT NULL,
478 `email` varchar(64) NOT NULL,
479 `last_action` int(11) NOT NULL,
480 `try` int(1) DEFAULT '0',
481 PRIMARY KEY (`id`),
482 UNIQUE KEY `username` (`username`),
483 UNIQUE KEY `email` (`email`),
484 UNIQUE KEY `try` (`try`)
485) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
486
487--
488-- Vedos taulusta `amx_webadmins`
489--
490
491INSERT INTO `amx_webadmins` (`id`, `username`, `password`, `level`, `logcode`, `email`, `last_action`, `try`) VALUES
492(1, 'admin', 'c65b34f215837a1b6d96f95259d7a6c3', 1, 'vgl3oa90un5u8g18rhqlki9531', 'admin@domain.com', 1556059028, 0);
493
494-- --------------------------------------------------------
495
496--
497-- Rakenne taululle `amx_webconfig`
498--
499
500CREATE TABLE IF NOT EXISTS `amx_webconfig` (
501 `id` int(11) NOT NULL AUTO_INCREMENT,
502 `cookie` varchar(32) NOT NULL,
503 `bans_per_page` int(11) NOT NULL,
504 `design` varchar(32) NOT NULL,
505 `banner` varchar(64) NOT NULL,
506 `banner_url` varchar(128) DEFAULT NULL,
507 `default_lang` varchar(32) NOT NULL,
508 `start_page` varchar(64) NOT NULL,
509 `show_comment_count` int(1) NOT NULL DEFAULT '1',
510 `show_demo_count` int(1) NOT NULL DEFAULT '1',
511 `show_kick_count` int(1) NOT NULL DEFAULT '1',
512 `demo_all` int(1) DEFAULT '0',
513 `comment_all` int(1) DEFAULT '0',
514 `use_capture` int(1) NOT NULL DEFAULT '1',
515 `max_file_size` int(11) NOT NULL DEFAULT '2',
516 `file_type` varchar(64) NOT NULL DEFAULT 'dem,zip,rar,jpg,gif',
517 `auto_prune` int(1) DEFAULT '0',
518 `max_offences` smallint(6) DEFAULT '10',
519 `max_offences_reason` varchar(128) DEFAULT 'max offences reached',
520 `use_demo` int(1) NOT NULL DEFAULT '1',
521 `use_comment` int(1) NOT NULL DEFAULT '1',
522 PRIMARY KEY (`id`),
523 UNIQUE KEY `banner_url` (`banner_url`),
524 UNIQUE KEY `demo_all` (`demo_all`),
525 UNIQUE KEY `comment_all` (`comment_all`),
526 UNIQUE KEY `auto_prune` (`auto_prune`),
527 UNIQUE KEY `max_offences` (`max_offences`),
528 UNIQUE KEY `max_offences_reason` (`max_offences_reason`)
529) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
530
531--
532-- Vedos taulusta `amx_webconfig`
533--
534
535INSERT INTO `amx_webconfig` (`id`, `cookie`, `bans_per_page`, `design`, `banner`, `banner_url`, `default_lang`, `start_page`, `show_comment_count`, `show_demo_count`, `show_kick_count`, `demo_all`, `comment_all`, `use_capture`, `max_file_size`, `file_type`, `auto_prune`, `max_offences`, `max_offences_reason`, `use_demo`, `use_comment`) VALUES
536(1, 'amxbans', 50, 'white-blue', 'amxbans.png', 'http://195.181.241.202/bans/', 'english', 'ban_list.php', 1, 1, 1, 0, 0, 1, 2, 'dem,zip,rar,jpg,gif,png', 0, 10, 'max offences reached', 1, 1);
537
538/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
539/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
540/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;