· 9 years ago · Jan 15, 2017, 05:12 AM
1/*
2Navicat MySQL Data Transfer
3
4
5Source Server : dungeonrealms
6Source Server Version : 50532
7Source Host : 74.50.87.131:3306
8Source Database : mumoxx_dungeonrealms
9
10Target Server Type : MYSQL
11Target Server Version : 50532
12File Encoding : 65001
13
14
15Date: 2014-11-02 16:50:37
16*/
17
18SET FOREIGN_KEY_CHECKS=0;
19
20-- ----------------------------
21-- Table structure for `ban_list`
22-- ----------------------------
23DROP TABLE IF EXISTS `ban_list`;
24CREATE TABLE `ban_list` (
25 `pname` char(18) NOT NULL,
26 `unban_date` datetime DEFAULT NULL,
27 `ban_reason` text,
28 `who_banned` char(18) DEFAULT NULL,
29 `ban_date` datetime DEFAULT NULL,
30 `unban_reason` text,
31 `who_unbanned` char(18) DEFAULT NULL,
32 `rank` char(12) DEFAULT NULL,
33 `ban_count` tinyint(4) DEFAULT NULL,
34 `perm` varchar(2) DEFAULT NULL,
35 `ip` text,
36 PRIMARY KEY (`pname`)
37) ENGINE=InnoDB DEFAULT CHARSET=latin1;
38
39
40-- ----------------------------
41-- Records of ban_list
42-- ----------------------------
43
44
45-- ----------------------------
46-- Table structure for `bank_database`
47-- ----------------------------
48DROP TABLE IF EXISTS `bank_database`;
49CREATE TABLE `bank_database` (
50 `p_name` varchar(18) NOT NULL,
51 `content` longtext,
52 `level` int(11) DEFAULT NULL,
53 `money` int(11) DEFAULT NULL,
54 PRIMARY KEY (`p_name`)
55) ENGINE=InnoDB DEFAULT CHARSET=latin1;
56
57-- ----------------------------
58-- Records of bank_database
59-- ----------------------------
60
61
62-- ----------------------------
63-- Table structure for `guilds`
64-- ----------------------------
65DROP TABLE IF EXISTS `guilds`;
66CREATE TABLE `guilds` (
67 `guild_name` varchar(16) NOT NULL,
68 `guild_handle` varchar(3) DEFAULT NULL,
69 `guild_color` int(11) DEFAULT NULL,
70 `guild_server_num` int(11) DEFAULT NULL,
71 `members` longtext,
72 `motd` longtext,
73 `unlawful_kills` int(11) DEFAULT NULL,
74 `lawful_kills` int(11) DEFAULT NULL,
75 `deaths` int(11) DEFAULT NULL,
76 `mob_kills` int(11) DEFAULT NULL,
77 `money` int(11) DEFAULT NULL,
78 `duel_wins` int(11) DEFAULT NULL,
79 `duel_lose` int(11) DEFAULT NULL,
80 `biography` text,
81 `guild_banner` tinytext,
82 `perm_unlawful_kills` int(11) DEFAULT NULL,
83 `perm_lawful_kills` int(11) DEFAULT NULL,
84 `perm_deaths` int(11) DEFAULT NULL,
85 `perm_mob_kills` int(11) DEFAULT NULL,
86 `perm_money` int(11) DEFAULT NULL,
87 `perm_duel_wins` int(11) DEFAULT NULL,
88 `perm_duel_lose` int(11) DEFAULT NULL,
89 PRIMARY KEY (`guild_name`)
90) ENGINE=InnoDB DEFAULT CHARSET=latin1;
91
92-- ----------------------------
93-- Records of guilds
94-- ----------------------------
95
96-- ----------------------------
97-- Table structure for `hearthstone`
98-- ----------------------------
99DROP TABLE IF EXISTS `hearthstone`;
100CREATE TABLE `hearthstone` (
101 `p_name` varchar(16) NOT NULL,
102 `location_name` varchar(16) NOT NULL,
103 `timer` int(11) NOT NULL,
104 PRIMARY KEY (`p_name`),
105 UNIQUE KEY `hearthstone_player_username` (`p_name`)
106) ENGINE=InnoDB DEFAULT CHARSET=utf8;
107
108-- ----------------------------
109-- Records of hearthstone
110-- ----------------------------
111
112
113-- ----------------------------
114-- Table structure for `instance`
115-- ----------------------------
116DROP TABLE IF EXISTS `instance`;
117CREATE TABLE `instance` (
118 `instance_template` varchar(18) NOT NULL,
119 `times` longtext,
120 PRIMARY KEY (`instance_template`)
121) ENGINE=InnoDB DEFAULT CHARSET=latin1;
122
123-- ----------------------------
124-- Records of instance
125-- ----------------------------
126
127
128-- ----------------------------
129-- Table structure for `logs`
130-- ----------------------------
131DROP TABLE IF EXISTS `logs`;
132CREATE TABLE `logs` (
133 `id` int(11) NOT NULL AUTO_INCREMENT,
134 `type` text NOT NULL,
135 `player` text NOT NULL,
136 `time` text NOT NULL,
137 `data` text,
138 PRIMARY KEY (`id`)
139) ENGINE=InnoDB DEFAULT CHARSET=latin1;
140
141-- ----------------------------
142-- Records of logs
143-- ----------------------------
144
145-- ----------------------------
146-- Table structure for `mute_map`
147-- ----------------------------
148DROP TABLE IF EXISTS `mute_map`;
149CREATE TABLE `mute_map` (
150 `pname` char(18) NOT NULL,
151 `unmute` mediumtext,
152 `who_muted` char(18) DEFAULT NULL,
153 PRIMARY KEY (`pname`)
154) ENGINE=InnoDB DEFAULT CHARSET=latin1;
155
156-- ----------------------------
157-- Records of mute_map
158-- ----------------------------
159
160-- ----------------------------
161-- Table structure for `perm_statistics`
162-- ----------------------------
163DROP TABLE IF EXISTS `perm_statistics`;
164CREATE TABLE `perm_statistics` (
165 `pname` char(18) NOT NULL,
166 `unlawful_kills` int(11) DEFAULT NULL,
167 `lawful_kills` int(11) DEFAULT NULL,
168 `deaths` int(11) DEFAULT NULL,
169 `mob_kills` int(11) DEFAULT NULL,
170 `money` int(11) DEFAULT NULL,
171 `duel_wins` int(11) DEFAULT NULL,
172 `duel_lose` int(11) DEFAULT NULL,
173 PRIMARY KEY (`pname`)
174) ENGINE=InnoDB DEFAULT CHARSET=latin1;
175
176-- ----------------------------
177-- Records of perm_statistics
178-- ----------------------------
179
180-- ----------------------------
181-- Table structure for `player_database`
182-- ----------------------------
183DROP TABLE IF EXISTS `player_database`;
184CREATE TABLE `player_database` (
185 `p_name` varchar(16) NOT NULL,
186 `uniqueid` varchar(8) DEFAULT NULL,
187 `guild_name` varchar(16) DEFAULT NULL,
188 `hp` int(11) DEFAULT NULL,
189 `level` int(11) DEFAULT NULL,
190 `food_level` int(11) DEFAULT NULL,
191 `inventory` longtext,
192 `location` longtext,
193 `first_login` mediumtext,
194 `combat_log` bit(1) DEFAULT NULL,
195 `last_login_time` mediumtext,
196 `rank` tinytext,
197 `server_num` int(11) DEFAULT '-2',
198 `align_status` varchar(16) DEFAULT NULL,
199 `align_time` mediumtext,
200 `toggles` text,
201 `pets` text,
202 `buddy_list` text,
203 `ignore_list` text,
204 `realm_tier` int(11) DEFAULT NULL,
205 `realm_title` tinytext,
206 `realm_loaded` tinyint(1) DEFAULT NULL,
207 `noob_player` tinyint(1) DEFAULT NULL,
208 `last_server` tinytext,
209 `ecash` int(11) DEFAULT NULL,
210 `ip` text,
211 `sdays_left` tinyint(3) DEFAULT NULL,
212 `portal_shards` text,
213 `saved_gear` text,
214 `mule_inventory` text,
215 `biography` text,
216 `achievments` longtext,
217 `lost_gear` tinytext,
218 `online_today` bit(1) DEFAULT NULL,
219 `ecash_storage` longtext,
220 `player_level` int(11) DEFAULT '1',
221 `player_xp` int(11) DEFAULT '0',
222 `can_join` bit(1) NOT NULL DEFAULT b'1',
223 `web_toggles` text,
224 `playercode` text,
225 `login_delay` bigint(8) DEFAULT '0',
226 `allocated_str` int(4) DEFAULT '0',
227 `allocated_dex` int(4) DEFAULT '0',
228 `allocated_vit` int(4) DEFAULT '0',
229 `allocated_int` int(4) DEFAULT '0',
230 `resets` int(3) DEFAULT '0',
231 PRIMARY KEY (`p_name`)
232) ENGINE=InnoDB DEFAULT CHARSET=latin1;
233
234-- ----------------------------
235-- Records of player_database
236-- ----------------------------
237
238-- ----------------------------
239-- Table structure for `quests`
240-- ----------------------------
241DROP TABLE IF EXISTS `quests`;
242CREATE TABLE `quests` (
243 `id` int(11) NOT NULL AUTO_INCREMENT,
244 `name` text NOT NULL,
245 `data` text NOT NULL,
246 `quest_text` text NOT NULL,
247 PRIMARY KEY (`id`)
248) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
249
250-- ----------------------------
251-- Records of quests
252-- ----------------------------
253INSERT INTO `quests` VALUES ('1', 'Quest with all possible options', '{\"activation\":[{\"type\":\"TALK_TO_NPC\",\"bonus\":[\"Asdf\"]},{\"type\":\"REACH_LEVEL\",\"bonus\":[\"43\"]},{\"type\":\"PICKUP_ITEM\",\"bonus\":[\"3\"]},{\"type\":\"COMPLETE_QUEST\",\"bonus\":[\"1\"]},{\"type\":\"TALK_TO_NPC\",\"bonus\":[\"Shanker\"]},{\"type\":\"ENTER_AREA\",\"bonus\":[\"dungeonrealms\",\"harrisonfields\"]}],\"available\":[{\"type\":\"FINISH_QUEST\",\"bonus\":[\"1\"]},{\"type\":\"TALK_TO_NPC\",\"bonus\":[\"Ronald\"]},{\"type\":\"MIN_LEVEL\",\"bonus\":[\"50\"]},{\"type\":\"MAX_LEVEL\",\"bonus\":[\"60\"]},{\"type\":\"ITEM_REQUIRED\",\"bonus\":[\"4\",\"10\"]}],\"acception\":[{\"type\":\"TELEPORT_PLAYER\",\"bonus\":[\"76\",\"45\",\"12\"]},{\"type\":\"RUN_COMMAND\",\"bonus\":[\"PLAYER\",\"\\/gl Hello\"]},{\"type\":\"APPLY_EFFECT\",\"bonus\":[\"1\",\"10\",\"1\"]},{\"type\":\"GIVE_ITEM\",\"bonus\":[\"4\",\"32\"]}],\"complete\":[{\"type\":\"TALK_TO_NPC\",\"bonus\":[\"Arnold\"]},{\"type\":\"LEVEL_REQUIRED\",\"bonus\":[\"32\"]},{\"type\":\"ITEM_REQUIRED\",\"bonus\":[\"2\",\"17\",\"TRUE\"]},{\"type\":\"ENEMY_KILLED\",\"bonus\":[\"Vampire\",\"20\"]},{\"type\":\"ENEMY_AREA_KILLED\",\"bonus\":[\"dungeonrealms\",\"hell\",\"10\"]}],\"completion\":[{\"type\":\"TELEPORT_PLAYER\",\"bonus\":[\"78\",\"56\",\"23\"]},{\"type\":\"RUN_COMMAND\",\"bonus\":[\"SERVER\",\"\\/kick %p\"]},{\"type\":\"APPLY_EFFECT\",\"bonus\":[\"1\",\"10\",\"1\"]}],\"prize\":[{\"type\":\"GIVE_XP\",\"bonus\":[\"5000\"]},{\"type\":\"GIVE_LEVELS\",\"bonus\":[\"5\"]},{\"type\":\"GIVE_ITEM\",\"bonus\":[\"5\",\"64\"]}],\"properties\":[{\"type\":\"DAILY_QUEST\"},{\"type\":\"QUEST_TIMER\",\"bonus\":[\"30\"]},{\"type\":\"CANT_LEAVE_AREA\",\"bonus\":[\"dungeonrealms\",\"cyrennica\"]}],\"suggestions\":[{\"type\":\"SUGGESTED_LEVEL\",\"bonus\":[\"10\"]},{\"type\":\"SUGGESTED_PARTY_SIZE\",\"bonus\":[\"3\"]}]}', 'ASDF!');
254INSERT INTO `quests` VALUES ('7', 'Farmer in Distress', '{\"activation\":[{\"type\":\"TALK_TO_NPC\",\"bonus\":[\"Mariandu\"]}],\"available\":[],\"acception\":[],\"complete\":[{\"type\":\"ENEMY_AREA_KILLED\",\"bonus\":[\"DungeonRealms\",\"plainsofcyrenne\",\"20\"]}],\"completion\":[{\"type\":\"APPLY_EFFECT\",\"bonus\":[\"1\",\"\",\"1\"]},{\"type\":\"TELEPORT_PLAYER\",\"bonus\":[\"-616\",\"63\",\"485\"]},{\"type\":\"RUN_COMMAND\",\"bonus\":[\"SERVER\",\"\\/tellraw %p {\\\"text\\\":\\\"\\\",\\\"extra\\\":[{\\\"text\\\":\\\"Farmer James: \\\"},{\\\"text\\\":\\\"Thank you for helping me kill the bandits!\\\",\\\"color\\\":\\\"green\\\"}]}\"]}],\"prize\":[{\"type\":\"GIVE_XP\",\"bonus\":[\"75\"]},{\"type\":\"GIVE_ITEM\",\"bonus\":[\"1\",\"20\"]}],\"properties\":[{\"type\":\"DAILY_QUEST\"}],\"suggestions\":[{\"type\":\"SUGGESTED_LEVEL\",\"bonus\":[\"1\",\"5\"]}]}', 'Welcome traveler, I hope you can help me. My farm has been getting attacked by bandits. Please slay 20 of them.');
255INSERT INTO `quests` VALUES ('13', 'New Quest', '', '');
256
257-- ----------------------------
258-- Table structure for `reports`
259-- ----------------------------
260DROP TABLE IF EXISTS `reports`;
261CREATE TABLE `reports` (
262 `id` int(11) NOT NULL AUTO_INCREMENT,
263 `type` char(18) DEFAULT NULL,
264 `reporter` char(18) DEFAULT NULL,
265 `offender` char(18) DEFAULT NULL,
266 `report` text,
267 `server` varchar(4) DEFAULT NULL,
268 `time` datetime DEFAULT NULL,
269 `cords` text,
270 `complete` tinyint(1) NOT NULL DEFAULT '0',
271 PRIMARY KEY (`id`)
272) ENGINE=InnoDB DEFAULT CHARSET=latin1;
273
274-- ----------------------------
275-- Records of reports
276-- ----------------------------
277
278-- ----------------------------
279-- Table structure for `server`
280-- ----------------------------
281DROP TABLE IF EXISTS `server`;
282CREATE TABLE `server` (
283 `id` int(11) NOT NULL,
284 `max_players` int(11) NOT NULL,
285 `online_players` int(11) NOT NULL,
286 `world_name` varchar(255) NOT NULL,
287 `status` varchar(19) NOT NULL,
288 PRIMARY KEY (`id`)
289) ENGINE=InnoDB DEFAULT CHARSET=utf8;
290
291-- ----------------------------
292-- Records of server
293-- ----------------------------
294INSERT INTO `server` VALUES ('0', '225', '0', '', '');
295INSERT INTO `server` VALUES ('1', '300', '67', '', '');
296INSERT INTO `server` VALUES ('2', '225', '29', '', '');
297INSERT INTO `server` VALUES ('3', '225', '23', '', '');
298INSERT INTO `server` VALUES ('4', '225', '37', '', '');
299INSERT INTO `server` VALUES ('5', '100', '1', '', '');
300INSERT INTO `server` VALUES ('9', '225', '0', '', '');
301INSERT INTO `server` VALUES ('10', '225', '0', '', '');
302INSERT INTO `server` VALUES ('11', '225', '0', '', '');
303INSERT INTO `server` VALUES ('99', '225', '0', '', '');
304INSERT INTO `server` VALUES ('100', '255', '1', '', '');
305INSERT INTO `server` VALUES ('2001', '225', '0', '', '');
306
307-- ----------------------------
308-- Table structure for `shop_database`
309-- ----------------------------
310DROP TABLE IF EXISTS `shop_database`;
311CREATE TABLE `shop_database` (
312 `p_name` varchar(18) NOT NULL,
313 `server_num` int(11) DEFAULT NULL,
314 `level` int(11) DEFAULT NULL,
315 `collection_bin` longtext,
316 `shop_backup` longtext,
317 PRIMARY KEY (`p_name`)
318) ENGINE=InnoDB DEFAULT CHARSET=latin1;
319
320-- ----------------------------
321-- Records of shop_database
322-- ----------------------------
323;
324
325-- ----------------------------
326-- Table structure for `statistics`
327-- ----------------------------
328DROP TABLE IF EXISTS `statistics`;
329CREATE TABLE `statistics` (
330 `pname` char(18) NOT NULL,
331 `unlawful_kills` int(11) DEFAULT NULL,
332 `lawful_kills` int(11) DEFAULT NULL,
333 `deaths` int(11) DEFAULT NULL,
334 `mob_kills` int(11) DEFAULT NULL,
335 `money` int(11) DEFAULT NULL,
336 `duel_wins` int(11) DEFAULT NULL,
337 `duel_lose` int(11) DEFAULT NULL,
338 `hasHorse` bit(1) NOT NULL DEFAULT b'0',
339 `hasMule` bit(1) NOT NULL DEFAULT b'0',
340 PRIMARY KEY (`pname`)
341) ENGINE=InnoDB DEFAULT CHARSET=latin1;
342
343-- ----------------------------
344-- Records of statistics
345-- ----------------------------
346
347
348-- ----------------------------
349-- Table structure for `statistics_old`
350-- ----------------------------
351DROP TABLE IF EXISTS `statistics_old`;
352CREATE TABLE `statistics_old` (
353 `pname` char(18) NOT NULL,
354 `unlawful_kills` int(11) DEFAULT NULL,
355 `lawful_kills` int(11) DEFAULT NULL,
356 `deaths` int(11) DEFAULT NULL,
357 `mob_kills` int(11) DEFAULT NULL,
358 `money` int(11) DEFAULT NULL,
359 PRIMARY KEY (`pname`)
360) ENGINE=InnoDB DEFAULT CHARSET=latin1;
361
362-- ----------------------------
363-- Records of statistics_old
364-- ----------------------------