· 10 years ago · Sep 18, 2016, 09:54 AM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 10.1.9-MariaDB - mariadb.org binary distribution
4-- Server OS: Win32
5-- HeidiSQL Version: 9.3.0.4984
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8mb4 */;
10/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
11/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
12
13-- Dumping database structure for rotmgprod
14DROP DATABASE IF EXISTS `rotmgprod`;
15CREATE DATABASE IF NOT EXISTS `rotmgprod` /*!40100 DEFAULT CHARACTER SET latin1 */;
16USE `rotmgprod`;
17
18
19-- Dumping structure for table rotmgprod.accounts
20DROP TABLE IF EXISTS `accounts`;
21CREATE TABLE IF NOT EXISTS `accounts` (
22 `id` bigint(255) NOT NULL AUTO_INCREMENT,
23 `uuid` varchar(128) NOT NULL,
24 `password` varchar(256) NOT NULL,
25 `name` varchar(64) NOT NULL DEFAULT 'DEFAULT',
26 `rank` int(1) NOT NULL DEFAULT '0',
27 `namechosen` tinyint(1) NOT NULL DEFAULT '0',
28 `verified` tinyint(1) NOT NULL DEFAULT '1',
29 `guild` int(11) NOT NULL,
30 `guildRank` int(11) NOT NULL,
31 `guildFame` int(11) NOT NULL DEFAULT '0',
32 `lastip` varchar(128) NOT NULL DEFAULT '',
33 `vaultCount` int(11) NOT NULL DEFAULT '1',
34 `maxCharSlot` int(11) NOT NULL DEFAULT '2',
35 `regTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
36 `guest` tinyint(1) NOT NULL DEFAULT '0',
37 `banned` tinyint(1) NOT NULL DEFAULT '0',
38 `publicMuledump` int(1) NOT NULL DEFAULT '1',
39 `muted` tinyint(1) NOT NULL,
40 `prodAcc` tinyint(1) NOT NULL DEFAULT '0',
41 `locked` varchar(512) NOT NULL,
42 `ignored` varchar(512) NOT NULL,
43 `gifts` varchar(10000) NOT NULL DEFAULT '',
44 `isAgeVerified` tinyint(1) NOT NULL DEFAULT '0',
45 `petYardType` int(11) NOT NULL DEFAULT '1',
46 `ownedSkins` varchar(2048) NOT NULL,
47 `authToken` varchar(128) NOT NULL DEFAULT '',
48 `acceptedNewTos` tinyint(1) NOT NULL DEFAULT '1',
49 `lastSeen` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
50 `accountInUse` tinyint(1) NOT NULL,
51 `enchantmentLevel` smallint(6) NOT NULL,
52 PRIMARY KEY (`id`,`uuid`,`guild`,`lastip`,`banned`)
53) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
54
55-- Dumping data for table rotmgprod.accounts: 2 rows
56/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
57REPLACE INTO `accounts` (`id`, `uuid`, `password`, `name`, `rank`, `namechosen`, `verified`, `guild`, `guildRank`, `guildFame`, `lastip`, `vaultCount`, `maxCharSlot`, `regTime`, `guest`, `banned`, `publicMuledump`, `muted`, `prodAcc`, `locked`, `ignored`, `gifts`, `isAgeVerified`, `petYardType`, `ownedSkins`, `authToken`, `acceptedNewTos`, `lastSeen`, `accountInUse`, `enchantmentLevel`) VALUES
58 (2, 'jens@gmail.com', '8cb2237d0679ca88db6464eac60da96345513964', 'Jens', 3, 1, 1, 1, 0, 7, '', 1, 14, '2016-07-12 19:47:55', 0, 0, 1, 0, 0, '', '', '', 1, 5, '', 'XCCJZIHFEMWLQBAUKPNBANGSQMSSBIYFHDUIDPEIDJWXHMSFWGDRLUQJVJTMQPDWNREMGRQULFXRRILDUNWVFGTMNLNUWSSOFZJPIFYEPIGGWYRMXPSCTIRHYRZVEVYT', 1, '2016-07-13 13:27:43', 0, 0),
59 (3, 'andrewh123987@gmail.com', '3fd49debb4a4200a11fd9e48eab4496030bb2675', 'Andrew', 3, 1, 1, 1, 40, 137, '', 1, 14, '2016-07-12 22:15:37', 0, 0, 1, 0, 0, '2', '', '', 1, 5, '', 'LMXBFNVQJTUNKICWKWKOYQIAECNQQKFMZVVLPSQNHLWMQMWTJHIQDQIUDXXDAFAYOHNPNQHRGXHNUWJSFTGICPJIMAHSVMMBKXYJYHGSARJGJVAHOEXGYRWZYECMJOWT', 1, '2016-07-13 04:21:50', 0, 0);
60/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
61
62
63-- Dumping structure for table rotmgprod.arenalb
64DROP TABLE IF EXISTS `arenalb`;
65CREATE TABLE IF NOT EXISTS `arenalb` (
66 `id` int(11) NOT NULL AUTO_INCREMENT,
67 `wave` int(11) NOT NULL,
68 `accid` int(11) NOT NULL,
69 `charid` int(11) NOT NULL,
70 `petid` int(11) DEFAULT NULL,
71 `time` varchar(256) NOT NULL,
72 `date` datetime NOT NULL,
73 PRIMARY KEY (`id`,`wave`)
74) ENGINE=MyISAM DEFAULT CHARSET=utf8;
75
76-- Dumping data for table rotmgprod.arenalb: 0 rows
77/*!40000 ALTER TABLE `arenalb` DISABLE KEYS */;
78/*!40000 ALTER TABLE `arenalb` ENABLE KEYS */;
79
80
81-- Dumping structure for table rotmgprod.backpacks
82DROP TABLE IF EXISTS `backpacks`;
83CREATE TABLE IF NOT EXISTS `backpacks` (
84 `accId` int(11) NOT NULL,
85 `charId` int(11) NOT NULL,
86 `items` varchar(128) NOT NULL DEFAULT '-1, -1, -1, -1, -1, -1, -1, -1',
87 PRIMARY KEY (`accId`,`charId`)
88) ENGINE=MyISAM DEFAULT CHARSET=utf8;
89
90-- Dumping data for table rotmgprod.backpacks: 3 rows
91/*!40000 ALTER TABLE `backpacks` DISABLE KEYS */;
92REPLACE INTO `backpacks` (`accId`, `charId`, `items`) VALUES
93 (3, 1, '-1, -1, -1, -1, -1, -1, -1, -1'),
94 (3, 5, '-1, -1, -1, -1, -1, -1, -1, -1'),
95 (3, 6, '-1, -1, -1, -1, -1, -1, -1, -1');
96/*!40000 ALTER TABLE `backpacks` ENABLE KEYS */;
97
98
99-- Dumping structure for table rotmgprod.boards
100DROP TABLE IF EXISTS `boards`;
101CREATE TABLE IF NOT EXISTS `boards` (
102 `guildId` int(11) NOT NULL,
103 `text` varchar(1024) NOT NULL,
104 PRIMARY KEY (`guildId`)
105) ENGINE=MyISAM DEFAULT CHARSET=utf8;
106
107-- Dumping data for table rotmgprod.boards: 1 rows
108/*!40000 ALTER TABLE `boards` DISABLE KEYS */;
109REPLACE INTO `boards` (`guildId`, `text`) VALUES
110 (1, '');
111/*!40000 ALTER TABLE `boards` ENABLE KEYS */;
112
113
114-- Dumping structure for table rotmgprod.characters
115DROP TABLE IF EXISTS `characters`;
116CREATE TABLE IF NOT EXISTS `characters` (
117 `id` int(11) NOT NULL AUTO_INCREMENT,
118 `accId` int(11) NOT NULL,
119 `charId` int(11) NOT NULL,
120 `charType` int(11) NOT NULL DEFAULT '782',
121 `level` int(11) NOT NULL DEFAULT '1',
122 `exp` int(11) NOT NULL DEFAULT '0',
123 `fame` int(11) NOT NULL DEFAULT '0',
124 `items` varchar(128) NOT NULL DEFAULT '-1, -1, -1, -1',
125 `hpPotions` int(11) NOT NULL DEFAULT '0',
126 `mpPotions` int(11) NOT NULL DEFAULT '0',
127 `hp` int(11) NOT NULL DEFAULT '1',
128 `mp` int(11) NOT NULL DEFAULT '1',
129 `stats` varchar(128) NOT NULL DEFAULT '1, 1, 1, 1, 1, 1, 1, 1',
130 `dead` tinyint(1) NOT NULL DEFAULT '0',
131 `tex1` int(11) NOT NULL DEFAULT '0',
132 `tex2` int(11) NOT NULL DEFAULT '0',
133 `pet` int(11) NOT NULL DEFAULT '-1',
134 `petId` int(11) NOT NULL DEFAULT '-1',
135 `hasBackpack` int(11) NOT NULL DEFAULT '0',
136 `skin` int(11) NOT NULL DEFAULT '0',
137 `xpBoosterTime` int(11) NOT NULL DEFAULT '0',
138 `ldTimer` int(11) NOT NULL DEFAULT '0',
139 `ltTimer` int(11) NOT NULL DEFAULT '0',
140 `fameStats` varchar(512) NOT NULL,
141 `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
142 `deathTime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
143 `totalFame` int(11) NOT NULL DEFAULT '0',
144 `lastSeen` datetime NOT NULL,
145 `lastLocation` varchar(128) NOT NULL,
146 PRIMARY KEY (`id`,`accId`,`dead`)
147) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
148
149-- Dumping data for table rotmgprod.characters: 19 rows
150/*!40000 ALTER TABLE `characters` DISABLE KEYS */;
151REPLACE INTO `characters` (`id`, `accId`, `charId`, `charType`, `level`, `exp`, `fame`, `items`, `hpPotions`, `mpPotions`, `hp`, `mp`, `stats`, `dead`, `tex1`, `tex2`, `pet`, `petId`, `hasBackpack`, `skin`, `xpBoosterTime`, `ldTimer`, `ltTimer`, `fameStats`, `createTime`, `deathTime`, `totalFame`, `lastSeen`, `lastLocation`) VALUES
152 (1, 0, 1, 782, 1, 0, 0, '2711, 2606, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1', 1, 0, 100, 100, '100, 100, 12, 0, 10, 12, 12, 15', 0, 0, 0, -1, -1, 0, 0, 0, 0, 0, 'AAAAAAABAAAAAAIAAAAAAwAAAsUEAAAAAAUAAAAABgAAAAAHAAAAAAgAAAAACQAAAAAKAAAAAAsAAAAADAAAAAANAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAAAFQAAAAAWAAAAABcAAAAAGAAAAAA=', '2016-07-12 19:33:32', '0000-00-00 00:00:00', 0, '2016-07-13 02:15:19', 'Nexus'),
153 (2, 0, 1, 782, 1, 0, 0, '2711, 2606, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1', 1, 0, 100, 100, '100, 100, 12, 0, 10, 12, 12, 15', 0, 0, 0, -1, -1, 0, 0, 0, 0, 0, 'AAAAAAABAAAAAAIAAAAAAwAAAsUEAAAAAAUAAAAABgAAAAAHAAAAAAgAAAAACQAAAAAKAAAAAAsAAAAADAAAAAANAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAAAFQAAAAAWAAAAABcAAAAAGAAAAAA=', '2016-07-12 19:47:43', '0000-00-00 00:00:00', 0, '2016-07-13 02:15:19', 'Nexus'),
154 (3, 2, 1, 782, 10, 4448, 4, '5782, 2854, 3112, 2984, 2979, -1, -1, -1, -1, -1, -1, -1', 1, 0, -8, 202, '670, 385, 75, 25, 50, 40, 60, 75', 1, 0, 0, -1, -1, 0, 0, 0, 1406, 1406, 'AAAADbUBAAAHUAIAAAAbAwAAa1YEAAAAAAUAAAAABgAAALQHAAAAtAgAAAAFCQAAAAUKAAAAAAsAAAAFDAAAAAQNAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAAIFQAAAAAWAAAAABcAAAAAGAAAAAA=', '2016-07-12 19:49:31', '2016-07-12 21:48:59', 0, '2016-07-13 01:48:56', 'Fun Park'),
155 (4, 2, 2, 782, 1, 0, 0, '2711, 2606, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1', 1, 0, -3, 187, '670, 385, 75, 25, 50, 40, 60, 75', 1, 0, 0, -1, -1, 0, 0, 0, 0, 0, 'AAAAAEoBAAAAEAIAAAABAwAADGAEAAAAAAUAAAAABgAAAAEHAAAAAQgAAAAACQAAAAAKAAAAAAsAAAAADAAAAAANAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAAAFQAAAAAWAAAAABcAAAAAGAAAAAA=', '2016-07-12 21:49:12', '2016-07-12 21:49:39', 0, '2016-07-13 01:49:26', 'Tomb of the Ancients'),
156 (15, 3, 2, 775, 20, 2730, 2, '5782, 2856, 2809, 2323, 2657, 3074, -1, -1, -1, 9069, 2630, -1', 1, 0, 700, 252, '700, 252, 75, 25, 50, 40, 50, 50', 0, 0, 0, -1, 3, 0, 0, 0, 0, 0, 'AAAAAPcBAAAABgIAAAASAwAARwIEAAAAAQUAAAAABgAAAAkHAAAACQgAAAABCQAAAAEKAAAAAAsAAAAADAAAAAENAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAADFQAAAAAWAAAAABcAAAAAGAAAAAA=', '2016-07-12 22:56:45', '0000-00-00 00:00:00', 0, '2016-07-13 03:01:35', 'Heavenly Rift'),
157 (6, 0, 1, 782, 1, 0, 0, '2711, 2606, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1', 1, 0, 100, 100, '100, 100, 12, 0, 10, 12, 12, 15', 0, 0, 0, -1, -1, 0, 0, 0, 0, 0, 'AAAAAAABAAAAAAIAAAAAAwAAAsUEAAAAAAUAAAAABgAAAAAHAAAAAAgAAAAACQAAAAAKAAAAAAsAAAAADAAAAAANAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAAAFQAAAAAWAAAAABcAAAAAGAAAAAA=', '2016-07-12 22:15:19', '0000-00-00 00:00:00', 0, '2016-07-13 02:15:19', 'Nexus'),
158 (19, 3, 5, 798, 20, 5636, 5, '17138, 2650, 2812, 5520, -1, 22461, -1, -1, -1, -1, -1, -1', 0, 0, -23, 0, '770, 252, 50, 40, 50, 75, 50, 50', 1, 167772184, 0, -1, -1, 1, 0, 0, 0, 0, 'AAAAA_8BAAAALwIAAABVAwABAHAEAAAAAAUAAAAABgAAACAHAAAAIggAAAAXCQAAABcKAAAAAAsAAAAADAAAAAANAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAAQFQAAAAAWAAAAABcAAAAAGAAAAAA=', '2016-07-12 23:08:42', '2016-07-13 00:17:29', 0, '2016-07-13 04:17:17', 'The Unspeakable'),
159 (8, 2, 4, 807, 20, 64710, 64, '3292, 6242, 2812, 5520, 5782, -1, -1, -1, 17889, -1, -1, -1', 1, 0, -94, 0, '720, 225, 65, 25, 55, 70, 45, 60', 1, 0, 0, -1, 2, 0, 0, 0, 0, 0, 'AAAAG5oBAAABQAIAAAELAwAB8S4EAAAAAwUAAAAABgAAATYHAAABTggAAAAACQAAAAEKAAAAAAsAAAAADAAAAAUNAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAAaFQAAAAAWAAAAABcAAAAAGAAAAAA=', '2016-07-12 22:21:27', '2016-07-12 22:55:59', 0, '2016-07-13 02:55:52', 'The Shatters'),
160 (17, 3, 3, 797, 20, 0, 0, '5782, 2857, 2812, 5520, -1, -1, -1, -1, -1, -1, -1, -1', 1, 0, 970, 252, '770, 252, 75, 25, 50, 75, 50, 50', 0, 0, 0, -1, 3, 0, 0, 0, 0, 0, 'AAAAAAQBAAAAAAIAAAAHAwAAF8wEAAAAAAUAAAAABgAAAAAHAAAAAAgAAAAACQAAAAAKAAAAAAsAAAAADAAAAAANAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAADFQAAAAAWAAAAABcAAAAAGAAAAAA=', '2016-07-12 23:01:59', '0000-00-00 00:00:00', 0, '2016-07-13 03:06:39', 'Nexus'),
161 (18, 3, 4, 768, 20, 11052, 11, '5782, 2650, 2809, 5520, -1, 2815, 17138, -7527, -1, 2612, 21067, 2812', 1, 0, -9, 0, '720, 252, 50, 25, 75, 40, 50, 75', 1, 0, 0, -1, 3, 0, 0, 0, 0, 0, 'AAAAC-MBAAAAugIAAAAXAwAA3DkEAAAAAQUAAAAABgAAALEHAAAAvwgAAAAjCQAAACQKAAAAAAsAAAAFDAAAAAMNAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAAKFQAAAAAWAAAAABcAAAAAGAAAAAA=', '2016-07-12 23:06:50', '2016-07-12 23:53:27', 0, '2016-07-13 03:53:04', 'The Hive'),
162 (14, 3, 1, 798, 20, 43213, 43, '2827, 2850, 2812, 2323, 3073, 20534, -1, 3077, 5782, -1, -1, -1', 2, 0, -126, 171, '770, 252, 50, 40, 50, 75, 50, 50', 1, 167772188, 167772175, -1, 3, 1, 0, 0, 0, 0, 'AAAAFaEBAAABhAIAAACQAwABrikEAAAACAUAAAAABgAAAGMHAAAAfQgAAAABCQAAAAEKAAAAAAsAAAAADAAAAAUNAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAAZFQAAAAAWAAAAABcAAAAAGAAAAAA=', '2016-07-12 22:24:05', '2016-07-12 22:56:33', 0, '2016-07-13 02:56:31', 'The Shatters'),
163 (16, 2, 5, 768, 20, 5308, 5, '17144, 2650, 5016, 5520, 17314, 5012, 5657, 3293, -1, -1, -1, -1', 1, 0, -3, 0, '720, 252, 50, 25, 75, 40, 50, 75', 1, 0, 167772161, -1, 2, 0, 0, 0, 0, 0, 'AAAAD0kBAAAAQAIAAAAgAwABec0EAAAAAQUAAAAABgAAACIHAAAAJQgAAAARCQAAABEKAAAAAAsAAAAADAAAAAANAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAApFQAAAAAWAAAAABcAAAAAGAAAAAA=', '2016-07-12 22:57:30', '2016-07-13 00:17:35', 0, '2016-07-13 04:17:22', 'The Unspeakable'),
164 (20, 2, 6, 782, 20, 3419, 3, '22460, 2852, 2821, 5520, -1, -1, -1, -1, -1, -1, -1, -1', 1, 0, 870, 254, '670, 385, 75, 25, 50, 40, 60, 75', 0, 0, 0, -1, 2, 0, 0, 0, 0, 0, 'AAAAHg4BAAABeQIAAAAzAwAAl4oEAAAAAgUAAAAABgAAAF8HAAAAaAgAAAAOCQAAAA8KAAAABAsAAAABDAAAAAANAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAAPFQAAAAAWAAAAABcAAAAAGAAAAAA=', '2016-07-12 23:23:15', '0000-00-00 00:00:00', 0, '2016-07-13 13:27:43', 'Nexus'),
165 (21, 3, 6, 782, 20, 0, 0, '3859, 2606, 22463, 2985, -1, -1, -1, -1, -1, -1, -1, -1', 1, 0, 850, 480, '670, 385, 75, 25, 50, 40, 60, 75', 0, 167772167, 0, -1, -1, 1, 0, 0, 0, 0, 'AAAAAQoBAAAAAAIAAAANAwAAF2MEAAAAAAUAAAAABgAAAAAHAAAAAAgAAAAACQAAAAAKAAAAAAsAAAAADAAAAAANAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAABFQAAAAAWAAAAABcAAAAAGAAAAAA=', '2016-07-12 23:25:39', '0000-00-00 00:00:00', 0, '2016-07-13 03:28:08', 'Nexus'),
166 (22, 3, 7, 799, 20, 780, 0, '5782, 2854, 30052, 2989, 22449, 3077, -1, -1, 2793, -1, -1, -1', 1, 0, -106, 312, '770, 252, 50, 30, 55, 40, 75, 45', 1, 0, 0, -1, 3, 0, 0, 0, 0, 0, 'AAAAAc4BAAAAAQIAAAAZAwAAMXQEAAAAAQUAAAAABgAAABYHAAAAGggAAAABCQAAAAEKAAAAAAsAAAAADAAAAAANAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAAGFQAAAAAWAAAAABcAAAAAGAAAAAA=', '2016-07-12 23:28:15', '2016-07-12 23:37:31', 0, '2016-07-13 03:37:27', 'Tomb of the Ancients'),
167 (24, 2, 7, 768, 1, 0, 0, '2580, 2646, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1', 1, 0, 150, 100, '150, 100, 10, 0, 15, 15, 10, 15', 0, 0, 0, -1, -1, 0, 0, 0, 0, 0, 'AAAAAAsBAAAAAAIAAAACAwAACcMEAAAAAAUAAAAABgAAAAAHAAAAAAgAAAAACQAAAAAKAAAAAAsAAAAADAAAAAANAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAABFQAAAAAWAAAAABcAAAAAGAAAAAA=', '2016-07-12 23:45:48', '0000-00-00 00:00:00', 0, '2016-07-13 03:47:16', 'Nexus'),
168 (23, 3, 8, 798, 20, 195, 0, '5782, 2850, 2812, 5520, -1, -1, -1, -1, 2793, -1, -1, -1', 1, 0, -45, 0, '770, 252, 50, 40, 50, 75, 50, 50', 1, 0, 0, -1, 3, 0, 0, 0, 0, 0, 'AAAAAOMBAAAADgIAAAALAwAAGUMEAAAAAAUAAAAABgAAAA0HAAAADQgAAAABCQAAAAEKAAAAAAsAAAAADAAAAAANAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAAAFQAAAAAWAAAAABcAAAAAGAAAAAA=', '2016-07-12 23:37:44', '2016-07-12 23:39:51', 0, '2016-07-13 03:39:51', 'Tomb of the Ancients'),
169 (25, 3, 9, 797, 20, 0, 0, '-1, 2857, 2812, -1, 17138, -1, -1, -1, -1, -1, -1, -1', 1, 0, 770, 252, '770, 252, 75, 25, 50, 75, 50, 50', 0, 0, 0, -1, -1, 0, 0, 0, 0, 0, 'AAAAAyMBAAAAAAIAAAAKAwAAIdEEAAAAAAUAAAAABgAAAAAHAAAAAAgAAAAACQAAAAAKAAAAAAsAAAAADAAAAAANAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAAHFQAAAAAWAAAAABcAAAAAGAAAAAA=', '2016-07-12 23:53:38', '0000-00-00 00:00:00', 0, '2016-07-13 04:02:24', 'Nexus'),
170 (26, 3, 10, 798, 20, 0, 0, '5782, -1, 3169, 5520, 17884, 6229, 20560, 2850, -1, -1, -1, -1', 1, 0, 0, 252, '770, 252, 50, 40, 50, 75, 50, 50', 1, 0, 0, -1, 3, 0, 0, 0, 0, 0, 'AAAAAEcBAAAAAgIAAAABAwAAOZ0EAAAAAAUAAAAABgAAAAIHAAAAAggAAAAACQAAAAAKAAAAAAsAAAAADAAAAAANAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAACFQAAAAAWAAAAABcAAAAAGAAAAAA=', '2016-07-13 00:17:38', '2016-07-13 00:21:53', 0, '2016-07-13 04:21:50', 'Ocean Trench');
171/*!40000 ALTER TABLE `characters` ENABLE KEYS */;
172
173
174-- Dumping structure for table rotmgprod.classstats
175DROP TABLE IF EXISTS `classstats`;
176CREATE TABLE IF NOT EXISTS `classstats` (
177 `accId` int(11) NOT NULL,
178 `objType` int(11) NOT NULL,
179 `bestLv` int(11) NOT NULL DEFAULT '1',
180 `bestFame` int(11) NOT NULL DEFAULT '0',
181 PRIMARY KEY (`accId`,`objType`)
182) ENGINE=MyISAM DEFAULT CHARSET=utf8;
183
184-- Dumping data for table rotmgprod.classstats: 13 rows
185/*!40000 ALTER TABLE `classstats` DISABLE KEYS */;
186REPLACE INTO `classstats` (`accId`, `objType`, `bestLv`, `bestFame`) VALUES
187 (0, 782, 1, 0),
188 (2, 782, 20, 62),
189 (2, 768, 20, 7),
190 (3, 782, 20, 0),
191 (2, 807, 20, 112),
192 (3, 784, 20, 0),
193 (3, 775, 20, 2),
194 (3, 801, 20, 0),
195 (3, 768, 20, 18),
196 (3, 807, 1, 0),
197 (3, 798, 20, 111),
198 (3, 797, 20, 0),
199 (3, 799, 20, 0);
200/*!40000 ALTER TABLE `classstats` ENABLE KEYS */;
201
202
203-- Dumping structure for table rotmgprod.dailyquests
204DROP TABLE IF EXISTS `dailyquests`;
205CREATE TABLE IF NOT EXISTS `dailyquests` (
206 `accId` int(11) NOT NULL,
207 `goals` varchar(512) NOT NULL,
208 `tier` int(11) NOT NULL DEFAULT '1',
209 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
210 PRIMARY KEY (`accId`)
211) ENGINE=InnoDB DEFAULT CHARSET=latin1;
212
213-- Dumping data for table rotmgprod.dailyquests: ~2 rows (approximately)
214/*!40000 ALTER TABLE `dailyquests` DISABLE KEYS */;
215REPLACE INTO `dailyquests` (`accId`, `goals`, `tier`, `time`) VALUES
216 (2, '3149, 2700, 2779, 2660', 1, '2016-07-12 17:00:00'),
217 (3, '2665, 2574, 2784, 2719', 1, '2016-07-12 17:00:00');
218/*!40000 ALTER TABLE `dailyquests` ENABLE KEYS */;
219
220
221-- Dumping structure for table rotmgprod.death
222DROP TABLE IF EXISTS `death`;
223CREATE TABLE IF NOT EXISTS `death` (
224 `accId` int(11) NOT NULL,
225 `chrId` int(11) NOT NULL,
226 `name` varchar(64) NOT NULL DEFAULT 'DEFAULT',
227 `charType` int(11) NOT NULL DEFAULT '782',
228 `tex1` int(11) NOT NULL DEFAULT '0',
229 `tex2` int(11) NOT NULL DEFAULT '0',
230 `skin` int(11) NOT NULL DEFAULT '0',
231 `items` varchar(128) NOT NULL DEFAULT '-1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1',
232 `fame` int(11) NOT NULL DEFAULT '0',
233 `exp` int(11) NOT NULL,
234 `fameStats` varchar(256) NOT NULL,
235 `totalFame` int(11) NOT NULL DEFAULT '0',
236 `firstBorn` tinyint(1) NOT NULL,
237 `killer` varchar(128) NOT NULL,
238 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
239 PRIMARY KEY (`accId`,`chrId`,`time`)
240) ENGINE=MyISAM DEFAULT CHARSET=utf8;
241
242-- Dumping data for table rotmgprod.death: 10 rows
243/*!40000 ALTER TABLE `death` DISABLE KEYS */;
244REPLACE INTO `death` (`accId`, `chrId`, `name`, `charType`, `tex1`, `tex2`, `skin`, `items`, `fame`, `exp`, `fameStats`, `totalFame`, `firstBorn`, `killer`, `time`) VALUES
245 (2, 1, 'Jens', 782, 0, 0, 0, '5782, 2854, 3112, 2984, 2979, -1, -1, -1, -1, -1, -1, -1', 4, 4448, 'AAAADbUBAAAHUAIAAAAbAwAAa1YEAAAAAAUAAAAABgAAALQHAAAAtAgAAAAFCQAAAAUKAAAAAAsAAAAFDAAAAAQNAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAAIFQAAAAAWAAAAABcAAAAAGAAAAAA=', 62, 1, 'Jeffery the Booty Clown', '2016-07-12 21:48:59'),
246 (2, 2, 'Jens', 782, 0, 0, 0, '2711, 2606, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1', 0, 0, 'AAAAAEoBAAAAEAIAAAABAwAADGAEAAAAAAUAAAAABgAAAAEHAAAAAQgAAAAACQAAAAAKAAAAAAsAAAAADAAAAAANAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAAAFQAAAAAWAAAAABcAAAAAGAAAAAA=', 0, 0, '{tombOfTheAncients.Lion_Archer}', '2016-07-12 21:49:39'),
247 (2, 4, 'Jens', 807, 0, 0, 0, '3292, 6242, 2812, 5520, 5782, -1, -1, -1, 17889, -1, -1, -1', 64, 64710, 'AAAAG5oBAAABQAIAAAELAwAB8S4EAAAAAwUAAAAABgAAATYHAAABTggAAAAACQAAAAEKAAAAAAsAAAAADAAAAAUNAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAAaFQAAAAAWAAAAABcAAAAAGAAAAAA=', 112, 1, '{shatters.shtrs_Ice_Adept}', '2016-07-12 22:55:59'),
248 (3, 1, 'Andrew', 798, 167772188, 167772175, 0, '2827, 2850, 2812, 2323, 3073, 20534, -1, 3077, 5782, -1, -1, -1', 43, 43213, 'AAAAFaEBAAABhAIAAACQAwABrikEAAAACAUAAAAABgAAAGMHAAAAfQgAAAABCQAAAAEKAAAAAAsAAAAADAAAAAUNAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAAZFQAAAAAWAAAAABcAAAAAGAAAAAA=', 111, 1, '{shatters.shtrs_Ice_Shield}', '2016-07-12 22:56:33'),
249 (3, 7, 'Andrew', 799, 0, 0, 0, '5782, 2854, 30052, 2989, 22449, 3077, -1, -1, 2793, -1, -1, -1', 0, 780, 'AAAAAc4BAAAAAQIAAAAZAwAAMXQEAAAAAQUAAAAABgAAABYHAAAAGggAAAABCQAAAAEKAAAAAAsAAAAADAAAAAANAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAAGFQAAAAAWAAAAABcAAAAAGAAAAAA=', 0, 0, '{tombOfTheAncients.Nile_Artifact_3}', '2016-07-12 23:37:31'),
250 (3, 8, 'Andrew', 798, 0, 0, 0, '5782, 2850, 2812, 5520, -1, -1, -1, -1, 2793, -1, -1, -1', 0, 195, 'AAAAAOMBAAAADgIAAAALAwAAGUMEAAAAAAUAAAAABgAAAA0HAAAADQgAAAABCQAAAAEKAAAAAAsAAAAADAAAAAANAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAAAFQAAAAAWAAAAABcAAAAAGAAAAAA=', 0, 0, '{tombOfTheAncients.Tomb_Attacker}', '2016-07-12 23:39:51'),
251 (3, 4, 'Andrew', 768, 0, 0, 0, '5782, 2650, 2809, 5520, -1, 2815, 17138, 58009, -1, 2612, 21067, 2812', 11, 11052, 'AAAAC-MBAAAAugIAAAAXAwAA3DkEAAAAAQUAAAAABgAAALEHAAAAvwgAAAAjCQAAACQKAAAAAAsAAAAFDAAAAAMNAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAAKFQAAAAAWAAAAABcAAAAAGAAAAAA=', 18, 0, 'Giant Wasp Warrior', '2016-07-12 23:53:27'),
252 (3, 5, 'Andrew', 798, 167772184, 0, 0, '17138, 2650, 2812, 5520, -1, 22461, -1, -1, -1, -1, -1, -1', 5, 5636, 'AAAAA_8BAAAALwIAAABVAwABAHAEAAAAAAUAAAAABgAAACAHAAAAIggAAAAXCQAAABcKAAAAAAsAAAAADAAAAAANAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAAQFQAAAAAWAAAAABcAAAAAGAAAAAA=', 8, 0, 'Evil Water', '2016-07-13 00:17:29'),
253 (2, 5, 'Jens', 768, 0, 167772161, 0, '17144, 2650, 5016, 5520, 17314, 5012, 5657, 3293, -1, -1, -1, -1', 5, 5308, 'AAAAD0kBAAAAQAIAAAAgAwABec0EAAAAAQUAAAAABgAAACIHAAAAJQgAAAARCQAAABEKAAAAAAsAAAAADAAAAAANAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAApFQAAAAAWAAAAABcAAAAAGAAAAAA=', 7, 0, 'Sorcerer of the Unspeakable', '2016-07-13 00:17:35'),
254 (3, 10, 'Andrew', 798, 0, 0, 0, '5782, -1, 3169, 5520, 17884, 6229, 20560, 2850, -1, -1, -1, -1', 0, 0, 'AAAAAEcBAAAAAgIAAAABAwAAOZ0EAAAAAAUAAAAABgAAAAIHAAAAAggAAAAACQAAAAAKAAAAAAsAAAAADAAAAAANAAAAAA4AAAAADwAAAAAQAAAAABEAAAAAEgAAAAATAAAAABQAAAACFQAAAAAWAAAAABcAAAAAGAAAAAA=', 0, 0, '{oceanTrench.Sea_Mare}', '2016-07-13 00:21:53');
255/*!40000 ALTER TABLE `death` ENABLE KEYS */;
256
257
258-- Dumping structure for table rotmgprod.giftcodes
259DROP TABLE IF EXISTS `giftcodes`;
260CREATE TABLE IF NOT EXISTS `giftcodes` (
261 `code` varchar(128) NOT NULL,
262 `content` varchar(512) NOT NULL
263) ENGINE=InnoDB DEFAULT CHARSET=latin1;
264
265-- Dumping data for table rotmgprod.giftcodes: ~1 rows (approximately)
266/*!40000 ALTER TABLE `giftcodes` DISABLE KEYS */;
267REPLACE INTO `giftcodes` (`code`, `content`) VALUES
268 ('UQNLKITAPIEMNVSISMQOVWEXLVLYM', '{"CharSlots":0,"VaultChests":2,"Fame":6042,"Gold":8925,"Gifts":[4616,4616,4616,4616,5250,5250,5250,5250,5250,5250,5250,5250,5250,3102,3102,18380,18380,18380,18380,18380,18380,18380,18380]}');
269/*!40000 ALTER TABLE `giftcodes` ENABLE KEYS */;
270
271
272-- Dumping structure for table rotmgprod.globalnews
273DROP TABLE IF EXISTS `globalnews`;
274CREATE TABLE IF NOT EXISTS `globalnews` (
275 `slot` int(11) NOT NULL,
276 `linkType` int(11) NOT NULL,
277 `title` varchar(65) NOT NULL,
278 `image` text NOT NULL,
279 `priority` int(11) NOT NULL,
280 `linkDetail` text NOT NULL,
281 `platform` varchar(128) NOT NULL DEFAULT 'kabam.com,kongregate,steam,rotmg',
282 `startTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
283 `endTime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
284 PRIMARY KEY (`slot`)
285) ENGINE=InnoDB DEFAULT CHARSET=latin1;
286
287-- Dumping data for table rotmgprod.globalnews: ~0 rows (approximately)
288/*!40000 ALTER TABLE `globalnews` DISABLE KEYS */;
289/*!40000 ALTER TABLE `globalnews` ENABLE KEYS */;
290
291
292-- Dumping structure for table rotmgprod.guilds
293DROP TABLE IF EXISTS `guilds`;
294CREATE TABLE IF NOT EXISTS `guilds` (
295 `id` int(11) NOT NULL AUTO_INCREMENT,
296 `name` varchar(128) NOT NULL DEFAULT 'DEFAULT_GUILD',
297 `members` varchar(128) NOT NULL,
298 `guildFame` int(11) NOT NULL,
299 `totalGuildFame` int(11) NOT NULL,
300 `level` int(11) NOT NULL DEFAULT '1',
301 PRIMARY KEY (`id`,`members`)
302) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
303
304-- Dumping data for table rotmgprod.guilds: 1 rows
305/*!40000 ALTER TABLE `guilds` DISABLE KEYS */;
306REPLACE INTO `guilds` (`id`, `name`, `members`, `guildFame`, `totalGuildFame`, `level`) VALUES
307 (1, 'Admins', '2,3,', 144, 144, 0);
308/*!40000 ALTER TABLE `guilds` ENABLE KEYS */;
309
310
311-- Dumping structure for table rotmgprod.mysteryboxes
312DROP TABLE IF EXISTS `mysteryboxes`;
313CREATE TABLE IF NOT EXISTS `mysteryboxes` (
314 `id` int(11) NOT NULL,
315 `title` varchar(128) NOT NULL,
316 `weight` int(11) NOT NULL,
317 `description` varchar(128) NOT NULL,
318 `contents` text NOT NULL,
319 `priceAmount` int(11) NOT NULL,
320 `priceCurrency` int(11) NOT NULL,
321 `image` text NOT NULL,
322 `icon` text NOT NULL,
323 `salePrice` int(11) NOT NULL,
324 `saleCurrency` int(11) NOT NULL,
325 `saleEnd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
326 `startTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
327 `boxEnd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
328 PRIMARY KEY (`id`)
329) ENGINE=InnoDB DEFAULT CHARSET=latin1;
330
331-- Dumping data for table rotmgprod.mysteryboxes: ~0 rows (approximately)
332/*!40000 ALTER TABLE `mysteryboxes` DISABLE KEYS */;
333/*!40000 ALTER TABLE `mysteryboxes` ENABLE KEYS */;
334
335
336-- Dumping structure for table rotmgprod.news
337DROP TABLE IF EXISTS `news`;
338CREATE TABLE IF NOT EXISTS `news` (
339 `id` int(11) NOT NULL AUTO_INCREMENT,
340 `icon` varchar(16) NOT NULL DEFAULT 'info',
341 `title` varchar(128) NOT NULL DEFAULT 'Default news title',
342 `text` varchar(128) NOT NULL DEFAULT 'Default news text',
343 `link` varchar(256) NOT NULL DEFAULT 'http://mmoe.net/',
344 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
345 PRIMARY KEY (`id`,`text`)
346) ENGINE=MyISAM DEFAULT CHARSET=utf8;
347
348-- Dumping data for table rotmgprod.news: 0 rows
349/*!40000 ALTER TABLE `news` DISABLE KEYS */;
350/*!40000 ALTER TABLE `news` ENABLE KEYS */;
351
352
353-- Dumping structure for table rotmgprod.packages
354DROP TABLE IF EXISTS `packages`;
355CREATE TABLE IF NOT EXISTS `packages` (
356 `id` int(11) NOT NULL AUTO_INCREMENT,
357 `name` varchar(128) NOT NULL,
358 `maxPurchase` int(11) NOT NULL DEFAULT '-1',
359 `weight` int(11) NOT NULL DEFAULT '0',
360 `contents` text NOT NULL,
361 `bgUrl` varchar(512) NOT NULL,
362 `price` int(11) NOT NULL,
363 `quantity` int(11) NOT NULL DEFAULT '-1',
364 `endDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
365 PRIMARY KEY (`id`)
366) ENGINE=InnoDB DEFAULT CHARSET=latin1;
367
368-- Dumping data for table rotmgprod.packages: ~0 rows (approximately)
369/*!40000 ALTER TABLE `packages` DISABLE KEYS */;
370/*!40000 ALTER TABLE `packages` ENABLE KEYS */;
371
372
373-- Dumping structure for table rotmgprod.pets
374DROP TABLE IF EXISTS `pets`;
375CREATE TABLE IF NOT EXISTS `pets` (
376 `accId` int(11) NOT NULL,
377 `petId` int(11) NOT NULL AUTO_INCREMENT,
378 `objType` smallint(5) NOT NULL,
379 `skinName` varchar(128) NOT NULL,
380 `skin` int(11) NOT NULL,
381 `family` int(11) NOT NULL,
382 `rarity` int(11) NOT NULL,
383 `maxLevel` int(11) NOT NULL DEFAULT '30',
384 `abilities` varchar(128) NOT NULL,
385 `levels` varchar(128) NOT NULL,
386 `xp` varchar(128) NOT NULL DEFAULT '0, 0, 0',
387 PRIMARY KEY (`accId`,`petId`)
388) ENGINE=MyISAM DEFAULT CHARSET=utf8;
389
390-- Dumping data for table rotmgprod.pets: 2 rows
391/*!40000 ALTER TABLE `pets` DISABLE KEYS */;
392REPLACE INTO `pets` (`accId`, `petId`, `objType`, `skinName`, `skin`, `family`, `rarity`, `maxLevel`, `abilities`, `levels`, `xp`) VALUES
393 (2, 2, 32582, '{pets.USA_Eagle_Skin}', 32834, 0, 4, 100, '407, 408, 406', '100,100,100', '55355, 14117, 3700'),
394 (3, 3, 32582, 'Sex Fucker', 32834, 0, 4, 100, '407, 408, 406', '100,100,100', '50355, 10607, 2080');
395/*!40000 ALTER TABLE `pets` ENABLE KEYS */;
396
397
398-- Dumping structure for table rotmgprod.stats
399DROP TABLE IF EXISTS `stats`;
400CREATE TABLE IF NOT EXISTS `stats` (
401 `accId` int(11) NOT NULL,
402 `fame` int(11) NOT NULL,
403 `totalFame` int(11) NOT NULL,
404 `credits` int(11) NOT NULL,
405 `totalCredits` int(11) NOT NULL,
406 `fortuneTokens` int(11) NOT NULL,
407 `totalFortuneTokens` int(11) NOT NULL,
408 `onraneCurrency` int(11) NOT NULL,
409 PRIMARY KEY (`accId`,`fame`,`totalFame`)
410) ENGINE=MyISAM DEFAULT CHARSET=utf8;
411
412-- Dumping data for table rotmgprod.stats: 3 rows
413/*!40000 ALTER TABLE `stats` DISABLE KEYS */;
414REPLACE INTO `stats` (`accId`, `fame`, `totalFame`, `credits`, `totalCredits`, `fortuneTokens`, `totalFortuneTokens`, `onraneCurrency`) VALUES
415 (1, 123456789, 123456789, 123456789, 123456789, 123456789, 123456789, 123456789),
416 (2, 123447633, 1234567970, 1234553981, 1234567789, 1234567764, 1234567789, 123456789),
417 (3, 123451926, 123456926, 123443840, 123456789, 123456786, 123456789, 123456789);
418/*!40000 ALTER TABLE `stats` ENABLE KEYS */;
419
420
421-- Dumping structure for table rotmgprod.thealchemist
422DROP TABLE IF EXISTS `thealchemist`;
423CREATE TABLE IF NOT EXISTS `thealchemist` (
424 `id` int(11) NOT NULL,
425 `title` varchar(512) NOT NULL,
426 `description` varchar(512) DEFAULT NULL,
427 `image` varchar(512) NOT NULL,
428 `icon` varchar(512) NOT NULL,
429 `contents` text NOT NULL,
430 `priceFirstInGold` int(11) NOT NULL DEFAULT '51',
431 `priceFirstInToken` int(11) NOT NULL DEFAULT '1',
432 `priceSecondInGold` int(11) NOT NULL DEFAULT '75',
433 `startTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
434 `endTime` datetime NOT NULL,
435 PRIMARY KEY (`id`)
436) ENGINE=InnoDB DEFAULT CHARSET=latin1;
437
438-- Dumping data for table rotmgprod.thealchemist: ~0 rows (approximately)
439/*!40000 ALTER TABLE `thealchemist` DISABLE KEYS */;
440/*!40000 ALTER TABLE `thealchemist` ENABLE KEYS */;
441
442
443-- Dumping structure for table rotmgprod.unlockedclasses
444DROP TABLE IF EXISTS `unlockedclasses`;
445CREATE TABLE IF NOT EXISTS `unlockedclasses` (
446 `id` int(11) NOT NULL AUTO_INCREMENT,
447 `accId` int(11) NOT NULL,
448 `class` varchar(128) NOT NULL,
449 `available` varchar(128) NOT NULL,
450 PRIMARY KEY (`id`)
451) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;
452
453-- Dumping data for table rotmgprod.unlockedclasses: ~45 rows (approximately)
454/*!40000 ALTER TABLE `unlockedclasses` DISABLE KEYS */;
455REPLACE INTO `unlockedclasses` (`id`, `accId`, `class`, `available`) VALUES
456 (1, 0, 'Rogue', 'restricted'),
457 (2, 0, 'Assassin', 'restricted'),
458 (3, 0, 'Huntress', 'restricted'),
459 (4, 0, 'Mystic', 'restricted'),
460 (5, 0, 'Trickster', 'restricted'),
461 (6, 0, 'Sorcerer', 'restricted'),
462 (7, 0, 'Ninja', 'restricted'),
463 (8, 0, 'Archer', 'restricted'),
464 (9, 0, 'Wizard', 'unrestricted'),
465 (10, 0, 'Priest', 'restricted'),
466 (11, 0, 'Necromancer', 'restricted'),
467 (12, 0, 'Warrior', 'restricted'),
468 (13, 0, 'Knight', 'restricted'),
469 (14, 0, 'Paladin', 'restricted'),
470 (15, 0, 'Samurai', 'restricted'),
471 (16, 2, 'Rogue', 'unrestricted'),
472 (17, 2, 'Assassin', 'unrestricted'),
473 (18, 2, 'Huntress', 'unrestricted'),
474 (19, 2, 'Mystic', 'unrestricted'),
475 (20, 2, 'Trickster', 'unrestricted'),
476 (21, 2, 'Sorcerer', 'unrestricted'),
477 (22, 2, 'Ninja', 'unrestricted'),
478 (23, 2, 'Archer', 'unrestricted'),
479 (24, 2, 'Wizard', 'unrestricted'),
480 (25, 2, 'Priest', 'restricted'),
481 (26, 2, 'Necromancer', 'unrestricted'),
482 (27, 2, 'Warrior', 'unrestricted'),
483 (28, 2, 'Knight', 'unrestricted'),
484 (29, 2, 'Paladin', 'unrestricted'),
485 (30, 2, 'Samurai', 'unrestricted'),
486 (31, 3, 'Rogue', 'restricted'),
487 (32, 3, 'Assassin', 'restricted'),
488 (33, 3, 'Huntress', 'restricted'),
489 (34, 3, 'Mystic', 'unrestricted'),
490 (35, 3, 'Trickster', 'unrestricted'),
491 (36, 3, 'Sorcerer', 'unrestricted'),
492 (37, 3, 'Ninja', 'unrestricted'),
493 (38, 3, 'Archer', 'restricted'),
494 (39, 3, 'Wizard', 'unrestricted'),
495 (40, 3, 'Priest', 'restricted'),
496 (41, 3, 'Necromancer', 'restricted'),
497 (42, 3, 'Warrior', 'restricted'),
498 (43, 3, 'Knight', 'unrestricted'),
499 (44, 3, 'Paladin', 'unrestricted'),
500 (45, 3, 'Samurai', 'unrestricted');
501/*!40000 ALTER TABLE `unlockedclasses` ENABLE KEYS */;
502
503
504-- Dumping structure for table rotmgprod.vaults
505DROP TABLE IF EXISTS `vaults`;
506CREATE TABLE IF NOT EXISTS `vaults` (
507 `accId` int(11) NOT NULL,
508 `chestId` int(11) NOT NULL AUTO_INCREMENT,
509 `items` varchar(128) NOT NULL,
510 PRIMARY KEY (`accId`,`chestId`)
511) ENGINE=MyISAM DEFAULT CHARSET=utf8;
512
513-- Dumping data for table rotmgprod.vaults: 37 rows
514/*!40000 ALTER TABLE `vaults` DISABLE KEYS */;
515REPLACE INTO `vaults` (`accId`, `chestId`, `items`) VALUES
516 (1, 1, '-1, -1, -1, -1, -1, -1, -1, -1'),
517 (2, 1, '-1, -1, -1, -1, -1, -1, -1, -1'),
518 (3, 1, '22450, 5012, 3122, 5520, 6239, -1, -1, -1'),
519 (3, 2, '-1, -1, -1, -1, -1, -1, -1, -1'),
520 (3, 3, '-1, -1, -1, -1, -1, -1, -1, -1'),
521 (3, 4, '-1, -1, -1, -1, -1, -1, -1, -1'),
522 (3, 5, '-1, -1, -1, -1, -1, -1, -1, -1'),
523 (3, 6, '-1, -1, -1, -1, -1, -1, -1, -1'),
524 (3, 7, '-1, -1, -1, -1, -1, -1, -1, -1'),
525 (3, 8, '-1, -1, -1, -1, -1, -1, -1, -1'),
526 (3, 9, '-1, -1, -1, -1, -1, -1, -1, -1'),
527 (3, 10, '-1, -1, -1, -1, -1, -1, -1, -1'),
528 (3, 11, '-1, -1, -1, -1, -1, -1, -1, -1'),
529 (3, 12, '-1, -1, -1, -1, -1, -1, -1, -1'),
530 (3, 13, '-1, -1, -1, -1, -1, -1, -1, -1'),
531 (3, 14, '-1, -1, -1, -1, -1, -1, -1, -1'),
532 (3, 15, '-1, -1, -1, -1, -1, -1, -1, -1'),
533 (3, 16, '-1, -1, -1, -1, -1, -1, -1, -1'),
534 (3, 17, '-1, -1, -1, -1, -1, -1, -1, -1'),
535 (3, 18, '-1, -1, -1, -1, -1, -1, -1, -1'),
536 (3, 19, '-1, -1, -1, -1, -1, -1, -1, -1'),
537 (3, 20, '-1, -1, -1, -1, -1, -1, -1, -1'),
538 (3, 21, '-1, -1, -1, -1, -1, -1, -1, -1'),
539 (3, 22, '-1, -1, -1, -1, -1, -1, -1, -1'),
540 (3, 23, '-1, -1, -1, -1, -1, -1, -1, -1'),
541 (3, 24, '-1, -1, -1, -1, -1, -1, -1, -1'),
542 (3, 25, '-1, -1, -1, -1, -1, -1, -1, -1'),
543 (3, 26, '-1, -1, -1, -1, -1, -1, -1, -1'),
544 (3, 27, '-1, -1, -1, -1, -1, -1, -1, -1'),
545 (3, 28, '-1, -1, -1, -1, -1, -1, -1, -1'),
546 (3, 29, '-1, -1, -1, -1, -1, -1, -1, -1'),
547 (3, 30, '-1, -1, -1, -1, -1, -1, -1, -1'),
548 (3, 31, '-1, -1, -1, -1, -1, -1, -1, -1'),
549 (3, 32, '-1, -1, -1, -1, -1, -1, -1, -1'),
550 (3, 33, '-1, -1, -1, -1, -1, -1, -1, -1'),
551 (3, 34, '-1, -1, -1, -1, -1, -1, -1, -1'),
552 (3, 35, '-1, -1, -1, -1, -1, -1, -1, -1');
553/*!40000 ALTER TABLE `vaults` ENABLE KEYS */;
554/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
555/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
556/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;