· 10 years ago · Aug 30, 2016, 08:04 PM
1-- phpMyAdmin SQL Dump
2-- version 4.0.10deb1
3-- http://www.phpmyadmin.net
4--
5-- Anamakine: localhost
6-- Üretim Zamanı: 30 Ağu 2016, 22:48:12
7-- Sunucu sürümü: 5.5.49-0ubuntu0.14.04.1
8-- PHP Sürümü: 5.5.9-1ubuntu4.17
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-- Veritabanı: `multicraft_panel`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Tablo için tablo yapısı `command_cache`
27--
28
29CREATE TABLE IF NOT EXISTS `command_cache` (
30 `server_id` int(11) NOT NULL,
31 `command` bigint(20) NOT NULL,
32 `ts` int(11) NOT NULL,
33 `data` text NOT NULL,
34 PRIMARY KEY (`server_id`,`command`)
35) ENGINE=InnoDB DEFAULT CHARSET=utf8;
36
37--
38-- Tablo döküm verisi `command_cache`
39--
40
41INSERT INTO `command_cache` (`server_id`, `command`, `ts`, `data`) VALUES
42(1, 3944796637, 1460483522, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"25";}}s:5:"error";b:0;}'),
43(2, 3944796637, 1467921324, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"50";}}s:5:"error";b:0;}'),
44(3, 3944796637, 1463581308, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:5:"12541";s:10:"maxPlayers";s:2:"30";}}s:5:"error";b:0;}'),
45(4, 3944796637, 1461923144, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"30";}}s:5:"error";b:0;}'),
46(5, 3944796637, 1460560137, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"15";}}s:5:"error";b:0;}'),
47(6, 3944796637, 1461160614, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"30";}}s:5:"error";b:0;}'),
48(7, 3944796637, 1460737503, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:1:"5";}}s:5:"error";b:0;}'),
49(8, 3944796637, 1460805240, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:1:"5";}}s:5:"error";b:0;}'),
50(9, 3944796637, 1460804758, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:1:"5";}}s:5:"error";b:0;}'),
51(10, 3944796637, 1462466300, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"30";}}s:5:"error";b:0;}'),
52(11, 3944796637, 1462287955, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:4:"4106";s:10:"maxPlayers";s:2:"24";}}s:5:"error";b:0;}'),
53(12, 3944796637, 1465049105, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"30";}}s:5:"error";b:0;}'),
54(13, 3944796637, 1464525936, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"50";}}s:5:"error";b:0;}'),
55(14, 3944796637, 1463855904, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"70";}}s:5:"error";b:0;}'),
56(15, 3944796637, 1465120219, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"24";}}s:5:"error";b:0;}'),
57(16, 3944796637, 1463836251, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"22";}}s:5:"error";b:0;}'),
58(17, 3944796637, 1463575492, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:8:"starting";s:7:"players";s:1:"0";s:3:"pid";s:5:"23841";s:10:"maxPlayers";s:2:"32";}}s:5:"error";b:0;}'),
59(18, 3944796637, 1463836260, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"22";}}s:5:"error";b:0;}'),
60(19, 3944796637, 1463582328, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:4:"1231";s:10:"maxPlayers";s:2:"32";}}s:5:"error";b:0;}'),
61(20, 3944796637, 1463650293, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:8:"starting";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"32";}}s:5:"error";b:0;}'),
62(21, 3944796637, 1463651913, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"32";}}s:5:"error";b:0;}'),
63(22, 3944796637, 1463665119, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:1:"5";}}s:5:"error";b:0;}'),
64(23, 3944796637, 1463757813, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:1:"5";}}s:5:"error";b:0;}'),
65(24, 3944796637, 1463816537, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"10";}}s:5:"error";b:0;}'),
66(25, 3944796637, 1463834145, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:1:"5";}}s:5:"error";b:0;}'),
67(26, 3944796637, 1465120146, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:5:"32097";s:10:"maxPlayers";s:2:"22";}}s:5:"error";b:0;}'),
68(27, 3944796637, 1465049097, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"70";}}s:5:"error";b:0;}'),
69(28, 3944796637, 1464367096, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"32";}}s:5:"error";b:0;}'),
70(29, 3944796637, 1464017605, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:1:"2";}}s:5:"error";b:0;}'),
71(30, 3944796637, 1466796264, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"32";}}s:5:"error";b:0;}'),
72(31, 3944796637, 1464973682, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:5:"29425";s:10:"maxPlayers";s:2:"32";}}s:5:"error";b:0;}'),
73(32, 3944796637, 1465421633, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:5:"23456";s:10:"maxPlayers";s:2:"50";}}s:5:"error";b:0;}'),
74(33, 3944796637, 1465322535, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"20";}}s:5:"error";b:0;}'),
75(34, 3944796637, 1465322543, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"20";}}s:5:"error";b:0;}'),
76(35, 3944796637, 1465649054, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"32";}}s:5:"error";b:0;}'),
77(36, 3944796637, 1467725939, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:5:"20870";s:10:"maxPlayers";s:3:"250";}}s:5:"error";b:0;}'),
78(37, 3944796637, 1465636817, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"20";}}s:5:"error";b:0;}'),
79(38, 3944796637, 1467997388, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"50";}}s:5:"error";b:0;}'),
80(39, 3944796637, 1465678566, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"70";}}s:5:"error";b:0;}'),
81(40, 3944796637, 1467307554, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"52";}}s:5:"error";b:0;}'),
82(41, 3944796637, 1466953977, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:4:"2292";s:10:"maxPlayers";s:3:"250";}}s:5:"error";b:0;}'),
83(42, 3944796637, 1466777741, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:3:"250";}}s:5:"error";b:0;}'),
84(43, 3944796637, 1466953970, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:4:"2662";s:10:"maxPlayers";s:3:"250";}}s:5:"error";b:0;}'),
85(44, 3944796637, 1466953985, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:4:"3853";s:10:"maxPlayers";s:3:"250";}}s:5:"error";b:0;}'),
86(45, 3944796637, 1467054381, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:5:"21830";s:10:"maxPlayers";s:1:"5";}}s:5:"error";b:0;}'),
87(46, 3944796637, 1467111486, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:5:"16578";s:10:"maxPlayers";s:1:"5";}}s:5:"error";b:0;}'),
88(47, 3944796637, 1467552826, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:4:"9853";s:10:"maxPlayers";s:2:"50";}}s:5:"error";b:0;}'),
89(48, 3944796637, 1469624887, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"30";}}s:5:"error";b:0;}'),
90(49, 3944796637, 1467902603, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"15";}}s:5:"error";b:0;}'),
91(50, 3944796637, 1467921311, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"50";}}s:5:"error";b:0;}'),
92(51, 3944796637, 1467921327, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:5:"13550";s:10:"maxPlayers";s:3:"250";}}s:5:"error";b:0;}'),
93(52, 3944796637, 1467921315, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:5:"13777";s:10:"maxPlayers";s:1:"8";}}s:5:"error";b:0;}'),
94(53, 3944796637, 1468840862, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:3:"150";}}s:5:"error";b:0;}'),
95(54, 3944796637, 1469968475, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:3:"152";}}s:5:"error";b:0;}'),
96(55, 3944796637, 1467993295, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:5:"18847";s:10:"maxPlayers";s:1:"8";}}s:5:"error";b:0;}'),
97(56, 3944796637, 1467993281, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:8:"stopping";s:7:"players";s:1:"0";s:3:"pid";s:5:"32086";s:10:"maxPlayers";s:2:"32";}}s:5:"error";b:0;}'),
98(57, 3944796637, 1467993273, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"50";}}s:5:"error";b:0;}'),
99(58, 3944796637, 1467993289, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:5:"18869";s:10:"maxPlayers";s:2:"50";}}s:5:"error";b:0;}'),
100(59, 3944796637, 1467988152, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"50";}}s:5:"error";b:0;}'),
101(60, 3944796637, 1468246096, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"32";}}s:5:"error";b:0;}'),
102(61, 3944796637, 1468246111, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:3:"256";}}s:5:"error";b:0;}'),
103(62, 3944796637, 1468051701, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:4:"4705";s:10:"maxPlayers";s:2:"15";}}s:5:"error";b:0;}'),
104(63, 3944796637, 1468159259, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:8:"starting";s:7:"players";s:1:"0";s:3:"pid";s:5:"19132";s:10:"maxPlayers";s:3:"150";}}s:5:"error";b:0;}'),
105(64, 3944796637, 1469372489, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"10";}}s:5:"error";b:0;}'),
106(65, 3944796637, 1468246119, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"32";}}s:5:"error";b:0;}'),
107(66, 3944796637, 1469028644, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:3:"150";}}s:5:"error";b:0;}'),
108(67, 3944796637, 1468246912, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"70";}}s:5:"error";b:0;}'),
109(68, 3944796637, 1468613937, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"70";}}s:5:"error";b:0;}'),
110(69, 3944796637, 1470566536, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"50";}}s:5:"error";b:0;}'),
111(70, 3944796637, 1469028691, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"70";}}s:5:"error";b:0;}'),
112(71, 3944796637, 1469031064, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"70";}}s:5:"error";b:0;}'),
113(72, 3944796637, 1471037329, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"80";}}s:5:"error";b:0;}'),
114(73, 3944796637, 1471004974, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:8:"stopping";s:7:"players";s:1:"5";s:3:"pid";s:5:"11943";s:10:"maxPlayers";s:2:"25";}}s:5:"error";b:0;}'),
115(74, 3944796637, 1469721361, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"50";}}s:5:"error";b:0;}'),
116(75, 3944796637, 1469452585, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:1:"5";}}s:5:"error";b:0;}'),
117(76, 3944796637, 1472224142, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"65";}}s:5:"error";b:0;}'),
118(77, 3944796637, 1470476345, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:5:"19912";s:10:"maxPlayers";s:3:"250";}}s:5:"error";b:0;}'),
119(78, 3944796637, 1470063191, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"22";}}s:5:"error";b:0;}'),
120(79, 3944796637, 1470476329, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:5:"19832";s:10:"maxPlayers";s:3:"250";}}s:5:"error";b:0;}'),
121(80, 3944796637, 1470476320, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:5:"20130";s:10:"maxPlayers";s:2:"20";}}s:5:"error";b:0;}'),
122(81, 3944796637, 1470476338, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:5:"10440";s:10:"maxPlayers";s:2:"50";}}s:5:"error";b:0;}'),
123(82, 3944796637, 1470742261, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"70";}}s:5:"error";b:0;}'),
124(83, 3944796637, 1472586307, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"50";}}s:5:"error";b:0;}'),
125(84, 3944796637, 1471037544, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:3:"100";}}s:5:"error";b:0;}'),
126(85, 3944796637, 1470916609, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:4:"2731";s:10:"maxPlayers";s:2:"50";}}s:5:"error";b:0;}'),
127(86, 3944796637, 1471703264, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"50";}}s:5:"error";b:0;}'),
128(87, 3944796637, 1471089660, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"50";}}s:5:"error";b:0;}'),
129(88, 3944796637, 1471531035, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"50";}}s:5:"error";b:0;}'),
130(89, 3944796637, 1472586307, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:4:"1682";s:10:"maxPlayers";s:1:"2";}}s:5:"error";b:0;}'),
131(90, 3944796637, 1471429226, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:4:"6086";s:10:"maxPlayers";s:3:"250";}}s:5:"error";b:0;}'),
132(91, 3944796637, 1471444501, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"30";}}s:5:"error";b:0;}'),
133(92, 3944796637, 1471444102, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:5:"20764";s:10:"maxPlayers";s:2:"30";}}s:5:"error";b:0;}'),
134(93, 3944796637, 1471429288, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:8:"starting";s:7:"players";s:1:"0";s:3:"pid";s:4:"6432";s:10:"maxPlayers";s:3:"250";}}s:5:"error";b:0;}'),
135(94, 3944796637, 1471444075, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:5:"20682";s:10:"maxPlayers";s:3:"250";}}s:5:"error";b:0;}'),
136(95, 3944796637, 1471444093, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"25";}}s:5:"error";b:0;}'),
137(96, 3944796637, 1471531171, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"70";}}s:5:"error";b:0;}'),
138(97, 3944796637, 1472586307, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"2";s:3:"pid";s:5:"27325";s:10:"maxPlayers";s:2:"32";}}s:5:"error";b:0;}'),
139(98, 3944796637, 1472037880, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"1";s:3:"pid";s:3:"610";s:10:"maxPlayers";s:2:"70";}}s:5:"error";b:0;}'),
140(99, 3944796637, 1472586307, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:5:"25695";s:10:"maxPlayers";s:2:"22";}}s:5:"error";b:0;}'),
141(100, 3944796637, 1472586307, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:5:"11676";s:10:"maxPlayers";s:2:"70";}}s:5:"error";b:0;}'),
142(101, 3944796637, 1472586307, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"stopped";s:7:"players";s:1:"0";s:3:"pid";s:1:"0";s:10:"maxPlayers";s:2:"70";}}s:5:"error";b:0;}'),
143(102, 3944796637, 1472586307, 'a:3:{s:7:"success";b:1;s:4:"data";a:1:{i:0;a:4:{s:6:"status";s:7:"running";s:7:"players";s:1:"0";s:3:"pid";s:5:"25321";s:10:"maxPlayers";s:2:"25";}}s:5:"error";b:0;}');
144
145-- --------------------------------------------------------
146
147--
148-- Tablo için tablo yapısı `config_file`
149--
150
151CREATE TABLE IF NOT EXISTS `config_file` (
152 `id` int(11) NOT NULL AUTO_INCREMENT,
153 `name` varchar(128) NOT NULL,
154 `description` varchar(512) NOT NULL,
155 `file` varchar(256) NOT NULL,
156 `options` text NOT NULL,
157 `type` varchar(32) NOT NULL DEFAULT '',
158 `enabled` int(11) NOT NULL DEFAULT '1',
159 `dir` varchar(128) NOT NULL DEFAULT '',
160 PRIMARY KEY (`id`)
161) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
162
163--
164-- Tablo döküm verisi `config_file`
165--
166
167INSERT INTO `config_file` (`id`, `name`, `description`, `file`, `options`, `type`, `enabled`, `dir`) VALUES
168(1, 'Server Settings', 'Main Minecraft server settings configuration file.', 'server.properties', '{"spawn-monsters":{"name":"Spawn Monsters","select":"bool"},"pvp":{"name":"Player vs Player","select":"bool"},"hellworld":{"name":"Hell World","select":"bool"},"online-mode":{"name":"Online Mode","select":"bool"},"spawn-animals":{"name":"Spawn Animals","select":"bool"},"server-ip":{"visible":false},"server-port":{"visible":false},"max-players":{"visible":false},"level-name":{"visible":false},"spawn-protection":{"name":"Protected Spawn Size","nocreate":true},"white-list":{"name":"Whitelisting","select":"bool"},"allow-nether":{"name":"Allow Nether","select":"bool"},"view-distance":{"name":"View Distance"},"level-seed":{"name":"Level Seed"},"allow-flight":{"name":"Allow Flying","select":"bool"},"gamemode":{"name":"Game Mode","select":{"0":"Survival","1":"Creative"}},"difficulty":{"name":"Difficulty","select":{"0":"Peaceful","1":"Easy","2":"Normal","3":"Hard"},"default":"1"},"motd":{"name":"Server Message"},"*":{"visible":true}}', 'properties', 1, ''),
169(3, 'Operators', 'List of users with operator access to the Minecraft server.', 'ops.txt', '', '', 1, ''),
170(4, 'Banned IPs', 'List of banned IP addresses for this server', 'banned-ips.txt', '', '', 1, ''),
171(5, 'Banned Players', 'List of banned player names for this server.', 'banned-players.txt', '', '', 1, ''),
172(6, 'Whitelisted Players', 'List of players that are allowed to connect. Note that this functionality is already provided by Multicraft.', 'white-list.txt', '', '', 1, ''),
173(7, '{file}', 'Plugin config file: {dir}{file}', '[^.]+.(txt|yml|csv)', '', '', 1, 'plugins/*/'),
174(8, 'Eula', 'Minecraft sözleşmesi.', 'eula.txt', '{"eula":{"name":"Accept Minecraft EULA","select":"bool"}}', 'properties', 1, ''),
175(9, 'BungeeCord Config', 'BungeeCord yapılandırma ayarları', 'config.yml', '', '', 1, '');
176
177-- --------------------------------------------------------
178
179--
180-- Tablo için tablo yapısı `mysql_db`
181--
182
183CREATE TABLE IF NOT EXISTS `mysql_db` (
184 `server_id` int(11) NOT NULL,
185 `name` varchar(128) NOT NULL,
186 `password` varchar(128) NOT NULL,
187 PRIMARY KEY (`server_id`)
188) ENGINE=InnoDB DEFAULT CHARSET=utf8;
189
190--
191-- Tablo döküm verisi `mysql_db`
192--
193
194INSERT INTO `mysql_db` (`server_id`, `name`, `password`) VALUES
195(2, 'dbmc2', 'b796c38fe9'),
196(20, 'dbmc20', '7239e121ad');
197
198-- --------------------------------------------------------
199
200--
201-- Tablo için tablo yapısı `server_config`
202--
203
204CREATE TABLE IF NOT EXISTS `server_config` (
205 `server_id` int(11) NOT NULL,
206 `ip_auth_role` varchar(16) NOT NULL DEFAULT 'guest',
207 `give_role` varchar(16) NOT NULL DEFAULT 'mod',
208 `tp_role` varchar(16) NOT NULL DEFAULT 'mod',
209 `summon_role` varchar(16) NOT NULL DEFAULT 'mod',
210 `chat_role` varchar(16) NOT NULL DEFAULT 'user',
211 `user_jar` int(11) NOT NULL DEFAULT '0',
212 `user_ftp` int(11) NOT NULL DEFAULT '0',
213 `visible` int(11) NOT NULL DEFAULT '1',
214 `user_schedule` int(11) NOT NULL DEFAULT '1',
215 `user_name` int(11) NOT NULL DEFAULT '1',
216 `user_visibility` int(11) NOT NULL DEFAULT '1',
217 `display_ip` varchar(64) NOT NULL DEFAULT '',
218 `user_players` int(11) NOT NULL DEFAULT '0',
219 `user_mysql` int(11) NOT NULL DEFAULT '1',
220 PRIMARY KEY (`server_id`)
221) ENGINE=InnoDB DEFAULT CHARSET=utf8;
222
223--
224-- Tablo döküm verisi `server_config`
225--
226
227INSERT INTO `server_config` (`server_id`, `ip_auth_role`, `give_role`, `tp_role`, `summon_role`, `chat_role`, `user_jar`, `user_ftp`, `visible`, `user_schedule`, `user_name`, `user_visibility`, `display_ip`, `user_players`, `user_mysql`) VALUES
228(83, 'guest', 'mod', 'mod', 'mod', 'user', 1, 0, 1, 1, 1, 1, '', 0, 1),
229(89, 'guest', 'mod', 'mod', 'mod', 'user', 1, 0, 2, 1, 1, 1, '', 0, 1),
230(97, 'guest', 'mod', 'mod', 'mod', 'user', 1, 0, 0, 1, 1, 1, '', 0, 1),
231(99, 'guest', 'mod', 'mod', 'mod', 'user', 1, 0, 1, 1, 1, 1, '', 0, 1),
232(100, 'guest', 'mod', 'mod', 'mod', 'user', 1, 0, 1, 1, 1, 1, '', 0, 1),
233(101, 'guest', 'mod', 'mod', 'mod', 'user', 1, 0, 1, 1, 1, 1, '', 0, 1),
234(102, 'guest', 'mod', 'mod', 'mod', 'user', 1, 0, 1, 1, 1, 1, '', 0, 1);
235
236-- --------------------------------------------------------
237
238--
239-- Tablo için tablo yapısı `user`
240--
241
242CREATE TABLE IF NOT EXISTS `user` (
243 `id` int(11) NOT NULL AUTO_INCREMENT,
244 `name` varchar(128) NOT NULL,
245 `password` varchar(128) NOT NULL,
246 `email` varchar(256) NOT NULL,
247 `global_role` varchar(16) NOT NULL DEFAULT 'none',
248 `api_key` varchar(40) NOT NULL DEFAULT '',
249 `lang` varchar(16) NOT NULL DEFAULT '',
250 `reset_hash` varchar(32) NOT NULL DEFAULT '',
251 PRIMARY KEY (`id`),
252 UNIQUE KEY `idx_usr_uq_name` (`name`),
253 UNIQUE KEY `idx_usr_uq_email` (`email`(128))
254) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=92 ;
255
256--
257-- Tablo döküm verisi `user`
258--
259
260INSERT INTO `user` (`id`, `name`, `password`, `email`, `global_role`, `api_key`, `lang`, `reset_hash`) VALUES
261(1, 'admin', '$1$y55jhuq8$fexQLkqhWhFxf4nYMAfTL/', 'batuoz502@gmail.com', 'none', '33e7df912db44ab895f8', 'tr', ''),
262(17, 'cetin', '$1$gJHlmakE$FpNCaIleEB/peew6jfNJE/', 'yigitcetin3@gmail.com', 'user', '', 'tr', ''),
263(19, 'ahmetbey', '$1$s9GzEVjU$oO0wKdc3EwDh2of0AWKl40', 'ahmetbey@hotmail.com', 'none', '', '', ''),
264(22, 'chiris', '$1$GvA4oxpf$QtykaonrVQ9waZxfYv17a/', 'deneme1922@hotmail.com', 'user', '', 'tr', ''),
265(24, 'Mountcraft', '$1$YxxfejWC$Q9tssm2u.Q7Tc/BHnQGPq.', 'MountBANK02@gmail.com', 'none', '', '', ''),
266(25, 'Selim kına', '$1$Wt71Xuhr$x/gFaht2vX2KqLa4CKmba/', 'mountgaming35@gmail.com', 'none', '', '', ''),
267(26, 'ErkmenReis', '$1$NksRyFee$.hcrsW1NfjhZzdrh08lD21', 'egemenkaragoz@windowslive.com', 'none', '', '', ''),
268(27, 'ahmetmxm7', '$1$+bltCJU7$LIOSQnJCCJT9yQCWaXpt./', 'gereksizozgur112@gmail.com', 'none', '', '', ''),
269(28, 'kaan1072', '$1$D1tXKazz$cJHIqTqbUSVafIptOzRdh1', 'ozbekkaan03@gmail.com', 'none', '', '', ''),
270(29, 'ayax235', '$1$fjnsw3Z/$zmvnVIMRvqulxekvnxxWc0', 'kfgdsffgsdj@hotmail.com', 'none', '', '', ''),
271(30, 'GOLD', '$1$pU4qsxDS$ror1XSGkVWg.OGHUWGGU5.', 'kfsgdsffgsdj@hotmail.com', 'none', '', '', ''),
272(32, 'enesrenta1', '$1$Js+EIRtM$hmpurg4NfnHP3trIpW9Rn0', 'enes_06_06@hotmail.com', 'none', '', '', ''),
273(33, 'emsauce', '$1$1yGBOeTN$BpCWbMXXWLBTVx0whOt0j1', 'huseyingencan43@gmail.com', 'none', '', 'tr', ''),
274(34, 'LegoLasTR34', '$1$7OOSF4Gh$kNnMQLwfuR3fQCCqS.nCJ1', 'abim.lgg4@gmail.com', 'none', '', '', ''),
275(35, 'Shadow', '$1$SqhqFdTF$Q5oipNbi9PFc.JSO6iqcP0', 'Shadow@gmail.com', 'none', '', 'tr', ''),
276(39, 'Berkecan', '$1$es52Hrom$d8tYqjEPrkVZ0q7Yn/6AA0', 'Berke26@gmail.com', 'none', '', 'tr', ''),
277(40, 'yigit1907', '$1$V5/pf80T$U7chfjaeoSOCCDk2KHXJ/1', 'birisi_782@hotmail.com', 'none', '', '', ''),
278(41, 'MuscleMAX', '$1$uhMIW1xR$l4byCb9Pi5HpngM92R6RG.', 'orhan@bolathan.com', 'none', '', 'tr', ''),
279(54, 'MuhammetKayra', '$1$u3XXFJb0$53wzp9RnbSDpfapX4xMyc1', 'mamimamiintro@gmail.com', 'user', '', '', ''),
280(55, 'mctrgaming', '$1$B6eFDap6$FM5XK6Io2jmzlk2uK7bA..', 'mcoyunformu@outlook.com', 'none', '', '', ''),
281(57, 'MrAto', '$1$FDcEKDKq$l37qoL/ho/4iwbYlrVMGT0', 'Skayderr@hotmail.com', 'none', '', '', ''),
282(58, 'Allycaptain', '$1$bkwGq3M6$auZC5cvyNDpEMjGFFd9ec.', 'Ordelamacila00@hotmail.com', 'none', '', '', ''),
283(59, 'eren oyunda', '$1$uLCCLKHV$IQG/mXkH/DZA8m1esofG9/', 'erenkaradag04@gmail.com', 'none', '', 'tr', ''),
284(61, 'YourNameDemir', '$1$VUBvDaw5$M9r2YJhEuuR3/CfkheGzn.', 'demirerol131321@outlook.com', 'none', '', '', ''),
285(62, 'YigitAlkan', '$1$crflHnuj$uhvz161NJ/gqFbnpkIkWD1', 'alkan6092@gmail.com', 'none', '', '', ''),
286(63, 'Cerbrusx', '$1$lyVa2Id9$R2gigNGOdZc.B7srJA2ZS0', 'conconcon256@hotmail.com', 'none', '', '', ''),
287(64, 'umut', '$1$s6tEJ1+s$3CbdeKzhw3UCyJK1lwW3C/', 'asd9024@outlook.com', 'none', '', '', ''),
288(65, 'FatihAtmaca2', '$1$P3c4y3vH$gPbeWjvmFpF9vkP75O2C1/', 'fatihatmaca236@hotmail.com', 'none', '', 'tr', ''),
289(66, 'Bircan55', '$1$JlLNooxJ$7LmhcKky./7LTTyRwHuXM1', 'recoro2069@hotmail.com', 'none', '', '', ''),
290(67, 'bar28', '$1$jri+5kiA$FpFns2O9I3CPwwzwnyJSh/', 'barisyildiz2828@hotmail.com', 'none', '', '', ''),
291(68, 'Denemes', '$1$pmYeAAzZ$Nj8yAV340TkacLsXooTrb/', 'saglammurat68@gmail.com', 'none', '', '', ''),
292(71, 'DTNetwork', '$1$yCGGGPDv$28za6Xbd0tGw7hBmDIkhM0', 'DTnetwork@outlook.com.tr', 'none', '', 'tr', ''),
293(72, 'YGTSERTTAS753', '$1$IxXmJjH+$ifWJhAFwCKhr4/gH55kd0/', 'serttasygt.11@hotmail.com', 'none', '', 'tr', ''),
294(73, 'rewwooV2', '$1$rL2qw0N8$LRBdrJxyWf3FhqCgYSkRH0', 'musti.13@outlook.com', 'none', '', 'tr', ''),
295(74, 'Emirhan1453', '$1$NpBKRsp+$YUvtPQHHA1qjkoW0YzkeA/', 'tamam_lan124@hotmail.com', 'none', '', '', ''),
296(75, 'Furkan02468', '$1$B9kzjZfF$10q6Fta/ES8PDb1BuHDqr.', 'Furkan02468@otlook.com.tr', 'none', '', 'tr', ''),
297(76, 'Ahmets', '$1$QjlXxWtF$RlU7eRK92vZzadcisrVaC.', 'ahmets@hotmail.com', 'user', '', '', ''),
298(78, 'HiddenMC', '$1$13Bb6QbG$Na9Vf2yMNJfTSMe3/t7tY1', 'gokhan-1234561@hotmail.com', 'none', '', '', ''),
299(79, 'Caspone', '$1$1tAWT/gc$vpZg2c3KDxL42bCE8pWvm.', 'yarda.er@gmail.com', 'none', '', '', ''),
300(80, 'kullanici25', '$1$RReQiXYB$ta/YdJxvjBY94KHBcdBMs1', 'kullanici@hotmail.com', 'none', '', '', ''),
301(81, 'ProKatil', '$1$oyetofmY$lp.q9iL5tCXcvR1lz1/KY0', 'bugradogan94@gmail.com', 'none', '', 'tr', ''),
302(82, 'ibrahim1409', '$1$ide07dLD$1Cu20xZX7DHYMXaXkFfrY1', 'gaminghome1409@gmail.com', 'none', '', '', ''),
303(84, 'alperen', '$1$BTTPGvkk$F11csaouc4CmCaFLgQE0m0', 'mlgprostr@hotmail.com', 'user', '', '', ''),
304(85, 'bynoment', '$1$iZXR4dbA$nEir5kIVL10fIAE2VEcX8.', 'gokhansavaskan52@gmail.com', 'none', '', 'tr', ''),
305(86, 'kullanici99', '$1$jTXAldWz$OpbM83fBXGfqQOZaT7QVG1', 'dmert127@gmail.com', 'none', '', '', ''),
306(87, 'enesbardaka42', '$1$7MB9nimb$sbqE20XZoHjF9hvd48yKc/', 'enesemir0652@gmail.com', 'none', '', '', ''),
307(88, 'jonnes', '$1$B2DTPqY/$e4bAhiuFUn9ZtUoeCpPAB1', 'ali_gergin_48@hotmail.com', 'none', '', '', ''),
308(89, 'Cimri', '$1$MiKn2a0+$tcHBgVmOalGZAislrwtty1', 'emirproefe@gmail.com', 'none', '', 'tr', ''),
309(90, 'Ayhan', '$1$0h8JnKBu$upZtcImVRP/Kw4GFyZahh/', 'batuhan.ozturk@mail.ru', 'superuser', '', '', ''),
310(91, 'Ugur51', '$1$IBS5S3PV$wRRrvJzGOuo/eLtuTROtv1', 'armutugur51@gmail.com', 'none', '', '', '');
311
312-- --------------------------------------------------------
313
314--
315-- Tablo için tablo yapısı `user_player`
316--
317
318CREATE TABLE IF NOT EXISTS `user_player` (
319 `user_id` int(11) NOT NULL,
320 `player_id` int(11) NOT NULL,
321 PRIMARY KEY (`player_id`),
322 KEY `user_id` (`user_id`)
323) ENGINE=InnoDB DEFAULT CHARSET=utf8;
324
325-- --------------------------------------------------------
326
327--
328-- Tablo için tablo yapısı `user_server`
329--
330
331CREATE TABLE IF NOT EXISTS `user_server` (
332 `user_id` int(11) NOT NULL,
333 `server_id` int(11) NOT NULL,
334 `role` varchar(16) NOT NULL,
335 PRIMARY KEY (`user_id`,`server_id`),
336 KEY `idx_usrsv_user` (`user_id`),
337 KEY `idx_usrsv_role` (`role`),
338 KEY `idx_usrsv_server` (`server_id`)
339) ENGINE=InnoDB DEFAULT CHARSET=utf8;
340
341--
342-- Tablo döküm verisi `user_server`
343--
344
345INSERT INTO `user_server` (`user_id`, `server_id`, `role`) VALUES
346(1, 83, 'admin'),
347(1, 97, 'admin'),
348(1, 99, 'admin'),
349(54, 102, 'owner'),
350(71, 100, 'owner'),
351(75, 83, 'owner'),
352(80, 89, 'owner'),
353(84, 101, 'owner'),
354(85, 97, 'owner'),
355(86, 99, 'owner');
356
357-- --------------------------------------------------------
358
359--
360-- Tablo için tablo yapısı `version`
361--
362
363CREATE TABLE IF NOT EXISTS `version` (
364 `id` int(11) NOT NULL,
365 `version` int(11) NOT NULL DEFAULT '0',
366 PRIMARY KEY (`id`)
367) ENGINE=InnoDB DEFAULT CHARSET=utf8;
368
369--
370-- Tablo döküm verisi `version`
371--
372
373INSERT INTO `version` (`id`, `version`) VALUES
374(1, 10);
375
376--
377-- Dökümü yapılmış tablolar için kısıtlamalar
378--
379
380--
381-- Tablo kısıtlamaları `user_player`
382--
383ALTER TABLE `user_player`
384 ADD CONSTRAINT `user_player_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
385
386--
387-- Tablo kısıtlamaları `user_server`
388--
389ALTER TABLE `user_server`
390 ADD CONSTRAINT `user_server_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
391
392/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
393/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
394/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;