AshXveUN

1-- phpMyAdmin SQL Dump
2-- version 4.0.5
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1:3306
6
7-- Generation Time: Aug 20, 2014 at 06:18 PM
8-- Server version: 5.5.33
9-- PHP Version: 5.4.19
10
11SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
12SET time_zone = "+00:00";
13
14
15/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
16/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
17/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
18/*!40101 SET NAMES utf8 */;
19
20--
21-- Database: `grandot`
22--
23CREATE DATABASE IF NOT EXISTS `grandot` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
24USE `grandot`;
25
26-- --------------------------------------------------------
27
28--
29-- Table structure for table `accounts`
30--
31-- Creation: Jul 23, 2014 at 12:49 PM
32--
33
34DROP TABLE IF EXISTS `accounts`;
35CREATE TABLE IF NOT EXISTS `accounts` (
36  `id` int(11) NOT NULL AUTO_INCREMENT,
37  `name` varchar(32) NOT NULL DEFAULT '',
38  `password` varchar(255) NOT NULL,
39  `salt` varchar(40) NOT NULL DEFAULT '',
40  `premdays` int(11) NOT NULL DEFAULT '0',
41  `lastday` int(10) unsigned NOT NULL DEFAULT '0',
42  `email` varchar(255) NOT NULL DEFAULT '',
43  `key` varchar(20) NOT NULL DEFAULT '0',
44  `blocked` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'internal usage',
45  `warnings` int(11) NOT NULL DEFAULT '0',
46  `group_id` int(11) NOT NULL DEFAULT '1',
47  `page_lastday` int(11) NOT NULL,
48  `email_new` varchar(255) NOT NULL,
49  `email_new_time` int(15) NOT NULL,
50  `created` int(11) NOT NULL DEFAULT '0',
51  `rlname` varchar(255) NOT NULL DEFAULT '',
52  `location` varchar(255) NOT NULL DEFAULT '',
53  `page_access` int(11) NOT NULL DEFAULT '0',
54  `email_code` varchar(255) NOT NULL DEFAULT '0',
55  `next_email` int(11) NOT NULL DEFAULT '0',
56  `premium_points` int(11) NOT NULL DEFAULT '0',
57  `vote` int(11) NOT NULL,
58  `create_date` int(11) NOT NULL DEFAULT '0',
59  `create_ip` int(11) NOT NULL DEFAULT '0',
60  `last_post` int(11) NOT NULL DEFAULT '0',
61  `flag` varchar(80) NOT NULL DEFAULT '',
62  PRIMARY KEY (`id`),
63  UNIQUE KEY `name` (`name`)
64) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9601880 ;
65
66--
67-- Dumping data for table `accounts`
68--
69
70INSERT INTO `accounts` (`id`, `name`, `password`, `salt`, `premdays`, `lastday`, `email`, `key`, `blocked`, `warnings`, `group_id`, `page_lastday`, `email_new`, `email_new_time`, `created`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `premium_points`, `vote`, `create_date`, `create_ip`, `last_post`, `flag`) VALUES
71(1, '1', 'Mo3mo3123', '', 65535, 1408498575, '', '0', 0, 0, 1, 1405050629, '', 0, 0, '', '', 3, '0', 0, 0, 0, 0, 0, 0, 'unknown'),
72(1147766, '7852299', 'mizo123', '', 332, 1408493478, 'mizorayes_47@hotmail.com', '0', 0, 0, 1, 1405497137, '', 0, 1404867351, '', 'eg', 3, '0', 0, 6526, 0, 0, 0, 1408509794, 'eg');
73
74--
75-- Triggers `accounts`
76--
77DROP TRIGGER IF EXISTS `ondelete_accounts`;
78DELIMITER //
79CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts`
80 FOR EACH ROW BEGIN
81    DELETE FROM `bans` WHERE `account` = OLD.`id`;
82END
83//
84DELIMITER ;
85
86-- --------------------------------------------------------
87
88--
89-- Table structure for table `account_viplist`
90--
91-- Creation: Jul 23, 2014 at 12:49 PM
92--
93
94DROP TABLE IF EXISTS `account_viplist`;
95CREATE TABLE IF NOT EXISTS `account_viplist` (
96  `account_id` int(11) NOT NULL,
97  `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
98  `player_id` int(11) NOT NULL,
99  UNIQUE KEY `account_id_2` (`account_id`,`player_id`),
100  KEY `account_id` (`account_id`),
101  KEY `player_id` (`player_id`),
102  KEY `world_id` (`world_id`)
103) ENGINE=InnoDB DEFAULT CHARSET=latin1;
104
105--
106-- RELATIONS FOR TABLE `account_viplist`:
107--   `account_id`
108--       `accounts` -> `id`
109--   `player_id`
110--       `players` -> `id`
111--
112
113-- --------------------------------------------------------
114
115--
116-- Table structure for table `anti_cheat`
117--
118-- Creation: Jul 23, 2014 at 12:49 PM
119-- Last update: Aug 03, 2014 at 08:43 AM
120-- Last check: Aug 03, 2014 at 08:43 AM
121--
122
123DROP TABLE IF EXISTS `anti_cheat`;
124CREATE TABLE IF NOT EXISTS `anti_cheat` (
125  `player_id` int(11) NOT NULL,
126  `killer_id` int(11) NOT NULL,
127  `time` int(11) NOT NULL
128) ENGINE=MyISAM DEFAULT CHARSET=latin1;
129
130-- --------------------------------------------------------
131
132--
133-- Table structure for table `auction_system`
134--
135-- Creation: Jul 23, 2014 at 12:49 PM
136-- Last update: Jul 24, 2014 at 10:44 PM
137-- Last check: Jul 24, 2014 at 10:44 PM
138--
139
140DROP TABLE IF EXISTS `auction_system`;
141CREATE TABLE IF NOT EXISTS `auction_system` (
142  `id` int(11) NOT NULL AUTO_INCREMENT,
143  `player` int(11) DEFAULT NULL,
144  `item_id` int(11) DEFAULT NULL,
145  `item_name` varchar(255) DEFAULT NULL,
146  `count` int(11) DEFAULT NULL,
147  `cost` int(11) DEFAULT NULL,
148  `date` int(11) DEFAULT NULL,
149  `auction_balance` int(11) NOT NULL,
150  PRIMARY KEY (`id`)
151) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;
152
153--
154-- Dumping data for table `auction_system`
155--
156
157INSERT INTO `auction_system` (`id`, `player`, `item_id`, `item_name`, `count`, `cost`, `date`, `auction_balance`) VALUES
158(16, 6, 2035, 'Donation Coin', 1, 2000000, 1406218830, 0);
159
160-- --------------------------------------------------------
161
162--
163-- Table structure for table `bans`
164--
165-- Creation: Jul 23, 2014 at 12:49 PM
166--
167
168DROP TABLE IF EXISTS `bans`;
169CREATE TABLE IF NOT EXISTS `bans` (
170  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
171  `type` tinyint(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',
172  `value` int(10) unsigned NOT NULL COMMENT 'ip address (integer), player guid or account number',
173  `param` int(10) unsigned NOT NULL DEFAULT '4294967295' COMMENT 'used only for ip banishment mask (integer)',
174  `active` tinyint(1) NOT NULL DEFAULT '1',
175  `expires` int(11) NOT NULL,
176  `added` int(10) unsigned NOT NULL,
177  `admin_id` int(10) unsigned NOT NULL DEFAULT '0',
178  `comment` text NOT NULL,
179  `reason` int(10) unsigned NOT NULL DEFAULT '0',
180  `action` int(10) unsigned NOT NULL DEFAULT '0',
181  `statement` varchar(255) NOT NULL DEFAULT '',
182  PRIMARY KEY (`id`),
183  KEY `type` (`type`,`value`),
184  KEY `active` (`active`)
185) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
186
187--
188-- Dumping data for table `bans`
189--
190
191INSERT INTO `bans` (`id`, `type`, `value`, `param`, `active`, `expires`, `added`, `admin_id`, `comment`, `reason`, `action`, `statement`) VALUES
192(1, 4, 9601824, 169, 1, -1, 1408223551, 6, 'Threatening not only the game-master, but the fucking owner.', 16, 0, ''),
193(2, 1, 32684097, 4294967295, 0, 1408309951, 1408223551, 6, 'Threatening not only the game-master, but the fucking owner.', 16, 0, ''),
194(3, 2, 9601824, 3600, 0, 23, 1408223669, 0, '6', 2, 0, ''),
195(4, 2, 9601824, 7200, 0, 23, 1408225479, 0, '6', 2, 0, '');
196
197-- --------------------------------------------------------
198
199--
200-- Table structure for table `bounty_hunters`
201--
202-- Creation: Jul 23, 2014 at 12:49 PM
203-- Last update: Jul 23, 2014 at 12:49 PM
204--
205
206DROP TABLE IF EXISTS `bounty_hunters`;
207CREATE TABLE IF NOT EXISTS `bounty_hunters` (
208  `id` int(11) NOT NULL AUTO_INCREMENT,
209  `fp_id` int(11) NOT NULL,
210  `sp_id` int(11) NOT NULL,
211  `k_id` int(11) NOT NULL,
212  `added` int(15) NOT NULL,
213  `prize` bigint(20) NOT NULL,
214  `killed` int(11) NOT NULL,
215  `kill_time` int(15) NOT NULL,
216  `player_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL,
217  `hunted_by` varchar(255) CHARACTER SET latin1 NOT NULL,
218  `killed_by` varchar(255) CHARACTER SET latin1 NOT NULL,
219  PRIMARY KEY (`id`)
220) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;
221
222--
223-- Dumping data for table `bounty_hunters`
224--
225
226INSERT INTO `bounty_hunters` (`id`, `fp_id`, `sp_id`, `k_id`, `added`, `prize`, `killed`, `kill_time`, `player_name`, `hunted_by`, `killed_by`) VALUES
227(11, 0, 0, 0, 1405663057, 100000, 0, 0, 'Merk', '[ADMIN] Wezza', ''),
228(10, 0, 0, 0, 1405663028, 1000000, 0, 0, 'Magezza', '[ADMIN] Wezza', '');
229
230-- --------------------------------------------------------
231
232--
233-- Table structure for table `castle`
234--
235-- Creation: Aug 12, 2014 at 03:19 AM
236-- Last update: Aug 13, 2014 at 03:55 AM
237--
238
239DROP TABLE IF EXISTS `castle`;
240CREATE TABLE IF NOT EXISTS `castle` (
241  `test` int(11) NOT NULL,
242  `guildid` int(11) NOT NULL,
243  `time` int(11) NOT NULL
244) ENGINE=MyISAM DEFAULT CHARSET=utf8;
245
246--
247-- Dumping data for table `castle`
248--
249
250INSERT INTO `castle` (`test`, `guildid`, `time`) VALUES
251(0, 7, 1407900359);
252
253-- --------------------------------------------------------
254
255--
256-- Table structure for table `cs`
257--
258-- Creation: Aug 20, 2014 at 04:21 PM
259-- Last update: Aug 20, 2014 at 04:21 PM
260--
261
262DROP TABLE IF EXISTS `cs`;
263CREATE TABLE IF NOT EXISTS `cs` (
264  `guild_id` int(11) NOT NULL,
265  `player_id` int(11) NOT NULL,
266  `team` int(11) NOT NULL,
267  `alive` int(11) NOT NULL,
268  `Player_Deny_Spells` int(11) NOT NULL,
269  `Player_Cs_Status` int(11) NOT NULL
270) ENGINE=MyISAM DEFAULT CHARSET=latin1;
271
272-- --------------------------------------------------------
273
274--
275-- Table structure for table `ctf`
276--
277-- Creation: Aug 20, 2014 at 04:21 PM
278-- Last update: Aug 20, 2014 at 04:21 PM
279--
280
281DROP TABLE IF EXISTS `ctf`;
282CREATE TABLE IF NOT EXISTS `ctf` (
283  `guild_id` int(11) NOT NULL,
284  `player_id` int(11) NOT NULL,
285  `killer_guild` int(11) NOT NULL,
286  `killer` int(11) NOT NULL,
287  `date` int(11) NOT NULL,
288  `result1` int(11) NOT NULL,
289  `result2` int(11) NOT NULL,
290  `team` int(11) NOT NULL,
291  `name` varchar(255) NOT NULL
292) ENGINE=MyISAM DEFAULT CHARSET=latin1;
293
294-- --------------------------------------------------------
295
296--
297-- Table structure for table `deaths_in_wars`
298--
299-- Creation: Jul 23, 2014 at 12:49 PM
300-- Last update: Jul 23, 2014 at 12:49 PM
301--
302
303DROP TABLE IF EXISTS `deaths_in_wars`;
304CREATE TABLE IF NOT EXISTS `deaths_in_wars` (
305  `guild_id` int(11) NOT NULL,
306  `player_id` int(11) NOT NULL,
307  `killer_guild` int(11) NOT NULL,
308  `killer` int(11) NOT NULL,
309  `date` int(11) NOT NULL,
310  `result1` int(11) NOT NULL,
311  `result2` int(11) NOT NULL
312) ENGINE=MyISAM DEFAULT CHARSET=latin1;
313
314-- --------------------------------------------------------
315
316--
317-- Table structure for table `environment_killers`
318--
319-- Creation: Jul 23, 2014 at 12:49 PM
320--
321
322DROP TABLE IF EXISTS `environment_killers`;
323CREATE TABLE IF NOT EXISTS `environment_killers` (
324  `kill_id` int(11) NOT NULL,
325  `name` varchar(255) NOT NULL,
326  KEY `kill_id` (`kill_id`)
327) ENGINE=InnoDB DEFAULT CHARSET=latin1;
328
329--
330-- RELATIONS FOR TABLE `environment_killers`:
331--   `kill_id`
332--       `killers` -> `id`
333--
334
335--
336-- Dumping data for table `environment_killers`
337--
338
339INSERT INTO `environment_killers` (`kill_id`, `name`) VALUES
340(238, 'a frost dragon'),
341(239, 'a dragon lord'),
342(240, 'a frost dragon'),
343(241, 'Orshabaal'),
344(242, 'the Old Widow'),
345(243, 'a hellhound'),
346(244, 'a terra commander'),
347(245, 'a terra commander'),
348(246, 'Orshabaal'),
349(247, 'a forgotten scarab'),
350(248, 'a yeti'),
351(249, 'a yeti'),
352(250, 'a enlightened of the cult'),
353(251, 'an acolyte of the cult'),
354(252, 'a ghoul'),
355(253, 'a demon skeleton'),
356(254, 'a hydra'),
357(255, 'a grim reaper'),
358(256, 'a zombie'),
359(257, 'a werewolf'),
360(258, 'a arkhothep'),
361(259, 'a thalas'),
362(260, 'a nightmare'),
363(261, 'a dark torturer'),
364(262, 'a warlock'),
365(263, 'a forgotten scarab'),
366(264, 'a ancient scarab'),
367(265, 'a djini'),
368(266, 'a aladin'),
369(267, 'a sultan'),
370(268, 'a aladin'),
371(269, 'a demon'),
372(270, 'a fire elemental'),
373(271, 'a banshee'),
374(272, 'a grim reaper'),
375(273, 'a demon'),
376(274, 'a banshee'),
377(275, 'a fire elemental'),
378(276, 'a banshee'),
379(277, 'a demon'),
380(278, 'a fire elemental'),
381(279, 'a aladin'),
382(280, 'a jasmine'),
383(281, 'Orshabaal'),
384(282, 'Minishabaal'),
385(283, 'a sea serpent'),
386(284, 'a hellhound'),
387(285, 'a black knight boss'),
388(286, 'a grim reaper'),
389(287, 'a aladin'),
390(288, 'a jasmine'),
391(289, 'a aladin'),
392(290, 'a jasmine'),
393(291, 'Orshabaal'),
394(292, 'a diabolic imp'),
395(293, 'Minishabaal'),
396(294, 'a woodmonster'),
397(295, 'a sea serpent'),
398(296, 'a energy master'),
399(297, 'a tree monster'),
400(298, 'a wisp'),
401(299, 'a undead dragon'),
402(300, 'a warlock'),
403(301, 'Fluffy'),
404(302, 'Orshabaal'),
405(303, 'Ferumbras King'),
406(304, 'a yeti'),
407(305, 'Orshabaal'),
408(306, 'a yeti'),
409(307, 'a earth elemental'),
410(308, 'Morgaroth'),
411(309, 'a thuls son'),
412(310, 'a frost dragon'),
413(311, 'a dragon lord'),
414(312, 'a demon'),
415(313, 'fire'),
416(314, 'Fluffy'),
417(315, 'a hellfire fighter'),
418(316, 'a undead dragon'),
419(317, 'a massive water elemental'),
420(318, 'a massive water elemental'),
421(319, 'Orshabaal'),
422(320, 'a demon'),
423(321, 'a demon'),
424(322, 'Orshabaal'),
425(323, 'a demon'),
426(324, 'Pelle the smithing master'),
427(325, 'a juggernaut'),
428(326, 'Svein, he is Pelle the smithing masters slave'),
429(327, 'Orshabaal'),
430(328, 'a massive water elemental'),
431(329, 'a aladin'),
432(330, 'a aladin'),
433(331, 'Apocalypse'),
434(332, 'Morgaroth'),
435(333, 'a forgotten scarab'),
436(334, 'Morgaroth'),
437(335, 'Apocalypse'),
438(336, 'Apocalypse'),
439(337, 'Morgaroth'),
440(338, 'a demon'),
441(339, 'gnorre chyllson'),
442(340, 'Apocalypse'),
443(341, 'Morgaroth'),
444(342, 'Orshabaal of Braveness'),
445(343, 'Orshabaal'),
446(344, 'a aladin'),
447(345, 'a aladin'),
448(346, 'a jasmines tiger'),
449(347, 'a aladin'),
450(348, 'colerian the barbarian'),
451(349, 'a jasmine'),
452(350, 'a forgotten scarab'),
453(351, 'a aladin'),
454(352, 'a undead dragon'),
455(353, 'a warlock'),
456(354, 'a diabolic imp'),
457(355, 'a lost soul'),
458(356, 'a banshee'),
459(357, 'a spectre'),
460(358, 'Orshabaal'),
461(359, 'a demon'),
462(360, 'Orshabaal'),
463(361, 'a demon'),
464(362, 'a banshee'),
465(363, 'a demon'),
466(364, 'Orshabaal'),
467(365, 'a demon'),
468(366, 'a banshee'),
469(367, 'a thoughened juggernaut'),
470(368, 'a thoughened juggernaut'),
471(369, 'a jasmines tiger'),
472(370, 'a aladin'),
473(371, 'a dragon lord'),
474(372, 'a dragon lord'),
475(373, 'a dragon lord'),
476(374, 'a dragon lord'),
477(375, 'a aladin'),
478(376, 'a aladin'),
479(377, 'a aladin'),
480(378, 'a fire elemental'),
481(379, 'a demon'),
482(380, 'a jasmine'),
483(381, 'a aladin'),
484(382, 'a forgotten scarab'),
485(383, 'a yeti'),
486(384, 'a aladin'),
487(385, 'a dragon lord'),
488(386, 'achad'),
489(387, 'a aladin'),
490(388, 'Fluffy'),
491(389, 'a warlock'),
492(390, 'Orshabaal'),
493(391, 'a undead dragon'),
494(529, 'Orshabaal'),
495(530, 'a undead dragon'),
496(531, 'a djini'),
497(532, 'a aladin'),
498(533, 'a grim reaper'),
499(534, 'a sultan'),
500(535, 'a aladin'),
501(536, 'a jasmine'),
502(537, 'a dragon lord'),
503(538, 'a djini'),
504(539, 'a aladin'),
505(540, 'a thuls son'),
506(541, 'the jafar'),
507(542, 'a banshee'),
508(543, 'a demon'),
509(544, 'a undead dragon'),
510(545, 'a warlock'),
511(546, 'a diabolic imp'),
512(547, 'a banshee'),
513(548, 'a spectre'),
514(549, 'a lost soul'),
515(550, 'a hydra'),
516(551, 'a warlock'),
517(552, 'a lich'),
518(553, 'a serpent spawn'),
519(554, 'a bonebeast'),
520(555, 'a warlock'),
521(556, 'a ancient scarab'),
522(557, 'a grim reaper'),
523(558, 'a dragon lord'),
524(559, 'a frost dragon'),
525(560, 'a hero'),
526(561, 'a jasmine'),
527(562, 'a aladin'),
528(563, 'a jasmine'),
529(564, 'a aladin'),
530(565, 'a juggernaut'),
531(566, 'a demon'),
532(567, 'a fire elemental'),
533(568, 'a fire elemental'),
534(569, 'a fire devil'),
535(570, 'a dragon lord'),
536(571, 'a fire elemental'),
537(572, 'a warlock'),
538(573, 'gnorre chyllson'),
539(574, 'gnorre chyllson'),
540(575, 'a spectre'),
541(576, 'gnorre chyllson'),
542(577, 'a war golem'),
543(578, 'Orshabaal'),
544(579, 'a yeti'),
545(580, 'a black knight boss'),
546(581, 'Orshabaal'),
547(582, 'Minishabaal'),
548(583, 'a djini'),
549(584, 'Orshabaal'),
550(585, 'a demon'),
551(586, 'Morgaroth'),
552(587, 'a demon'),
553(588, 'a aladin'),
554(589, 'a demon'),
555(590, 'Orshabaal'),
556(591, 'a juggernaut'),
557(592, 'Orshabaal'),
558(593, 'Ferumbras'),
559(594, 'a undead dragon'),
560(595, 'a demon'),
561(596, 'a undead dragon'),
562(597, 'Ferumbras'),
563(598, 'a aladin'),
564(599, 'a aladin'),
565(600, 'a jasmine'),
566(601, 'a grim reaper'),
567(602, 'a experienced warlock'),
568(603, 'a warlock'),
569(604, 'a undead dragon'),
570(605, 'a demon'),
571(606, 'a dragon lord'),
572(607, 'a fire elemental'),
573(608, 'a demon'),
574(609, 'a aladin'),
575(610, 'a aladin'),
576(611, 'Orshabaal'),
577(612, 'Minishabaal'),
578(613, 'a jasmines tiger'),
579(614, 'a aladin'),
580(615, 'a aladin'),
581(616, 'a jasmine'),
582(617, 'a crazy hammerman'),
583(618, 'a sea serpent'),
584(619, 'deathbringer'),
585(620, 'a yeti'),
586(621, 'a demon'),
587(622, 'Orshabaal'),
588(623, 'gnorre chyllson'),
589(624, 'a dark torturer'),
590(625, 'Pelle the smithing master'),
591(626, 'Svein, he is Pelle the smithing masters slave'),
592(627, 'a vampire overlord'),
593(628, 'the occultist'),
594(629, 'the occultist'),
595(630, 'a vampire overlord'),
596(631, 'a vampire overlord'),
597(632, 'a frost dragon'),
598(633, 'a hydra'),
599(634, 'a sultan'),
600(635, 'a hydra'),
601(636, 'Orshabaal'),
602(637, 'the handmaiden'),
603(638, 'a undead dragon'),
604(639, 'a lost soul'),
605(640, 'a massive water elemental'),
606(641, 'a aladin'),
607(642, 'a aladin'),
608(643, 'a forgotten scarab'),
609(644, 'a jasmine'),
610(645, 'a crazy hammerman'),
611(646, 'a aladin'),
612(647, 'a aladin'),
613(648, 'a aladin'),
614(649, 'a jasmine'),
615(650, 'a aladin'),
616(651, 'a jasmine'),
617(652, 'an ice golem'),
618(653, 'level 1 energy'),
619(654, 'Orshabaal'),
620(655, 'a juggernaut'),
621(656, 'Orshabaal'),
622(657, 'a demon'),
623(658, 'Orshabaal'),
624(659, 'Orshabaal'),
625(660, 'a juggernaut'),
626(661, 'Orshabaal'),
627(662, 'a demon'),
628(663, 'Orshabaal'),
629(664, 'a juggernaut'),
630(665, 'a undead dragon'),
631(666, 'a dragon lord'),
632(667, 'Morgaroth'),
633(668, 'Orshabaal of Braveness'),
634(670, 'Orshabaal of Braveness'),
635(671, 'Apocalypse'),
636(672, 'Morgaroth'),
637(673, 'a demon'),
638(674, 'Morgaroth'),
639(675, 'a demon'),
640(676, 'a massive water elemental'),
641(677, 'a massive energy elemental'),
642(678, 'a earth elemental'),
643(679, 'a hand of cursed fate'),
644(680, 'a earth elemental'),
645(681, 'a vampire overlord'),
646(682, 'a zombie'),
647(683, 'a grim reaper'),
648(684, 'a mutated tiger'),
649(685, 'a zombie'),
650(686, 'a werewolf'),
651(687, 'a grim reaper'),
652(688, 'a woodmonster'),
653(689, 'a scarecrow'),
654(690, 'a aladin'),
655(691, 'a jasmine'),
656(692, 'a yeti'),
657(693, 'a fire elemental'),
658(694, 'a demon'),
659(695, 'a fire elemental'),
660(696, 'a fire elemental'),
661(697, 'a dragon lord'),
662(698, 'a demon'),
663(699, 'a banshee'),
664(700, 'a fire elemental'),
665(701, 'a stormer'),
666(702, 'a crazy hammerman'),
667(703, 'a stormer'),
668(704, 'a crazy hammerman'),
669(705, 'a thoughened juggernaut'),
670(706, 'a Master Ghost'),
671(707, 'a little blazing fire elemental'),
672(708, 'a blazing fire elemental'),
673(709, 'a blazing fire elemental'),
674(710, 'a blazing fire elemental'),
675(711, 'a little blazing fire elemental'),
676(712, 'a mine mage'),
677(713, 'a mine mage'),
678(714, 'a mine guard'),
679(715, 'a mine mage'),
680(716, 'a mine mage'),
681(717, 'a mine mage'),
682(718, 'a mine guard'),
683(719, 'a mine mage'),
684(720, 'a mine guard'),
685(721, 'a thoughened juggernaut'),
686(722, 'a stormer'),
687(723, 'a thoughened juggernaut'),
688(724, 'a Master Ghost'),
689(725, 'a thoughened juggernaut'),
690(726, 'a stormer'),
691(759, 'a aladin'),
692(760, 'a jasmine'),
693(761, 'a aladin'),
694(762, 'a demon'),
695(763, 'a warlock'),
696(764, 'a demon'),
697(765, 'a fire elemental'),
698(766, 'the handmaiden'),
699(767, 'a undead dragon'),
700(768, 'a demon'),
701(769, 'a fire elemental'),
702(770, 'a dragon lord'),
703(771, 'Orshabaal'),
704(772, 'a juggernaut'),
705(773, 'a banshee'),
706(774, 'a demon'),
707(775, 'a banshee'),
708(776, 'a demon'),
709(777, 'a fire elemental'),
710(778, 'a fire elemental'),
711(779, 'a fire elemental'),
712(780, 'a fire elemental'),
713(781, 'a warlock'),
714(782, 'a fire elemental'),
715(783, 'a fire elemental'),
716(784, 'a behemoth'),
717(785, 'a fire elemental'),
718(786, 'a fire elemental'),
719(787, 'a fire elemental'),
720(788, 'a demon'),
721(789, 'a aladin'),
722(790, 'a level 1 earth'),
723(791, 'a aladin'),
724(792, 'a jasmine'),
725(793, 'a jasmine'),
726(794, 'a aladin'),
727(795, 'a dragon lord'),
728(796, 'a level 1 fire'),
729(797, 'Orshabaal'),
730(798, 'a hellhound'),
731(799, 'a forgotten scarab'),
732(800, 'a ancient scarab'),
733(801, 'a ancient scarab'),
734(802, 'a ancient scarab'),
735(803, 'Morgaroth'),
736(804, 'a forgotten scarab'),
737(805, 'a ancient scarab'),
738(806, 'a ancient scarab'),
739(807, 'a forgotten scarab'),
740(808, 'a ancient scarab'),
741(809, 'a ancient scarab'),
742(810, 'a hydra'),
743(811, 'gnorre chyllson'),
744(812, 'a aladin'),
745(813, 'a vampire overlord'),
746(814, 'a grim reaper'),
747(815, 'a zombie'),
748(816, 'a mutated tiger'),
749(817, 'a werewolf'),
750(818, 'a aladin'),
751(819, 'a warlock'),
752(820, 'a experienced warlock'),
753(821, 'a experienced warlock'),
754(822, 'a warlock'),
755(823, 'a fire elemental'),
756(824, 'Orshabaal'),
757(825, 'Minishabaal'),
758(826, 'a demon'),
759(827, 'a demon'),
760(828, 'a aladin'),
761(831, 'a forgotten scarab'),
762(832, 'a aladin'),
763(833, 'a jasmine'),
764(835, 'gnorre chyllson'),
765(836, 'a grim reaper'),
766(837, 'a warlock'),
767(838, 'a diabolic imp'),
768(839, 'a frost dragon'),
769(840, 'a braindeath'),
770(841, 'a braindeath'),
771(842, 'a elder beholder'),
772(843, 'a elder beholder'),
773(844, 'a braindeath'),
774(845, 'a demon'),
775(846, 'a banshee'),
776(847, 'a fire elemental'),
777(848, 'a fire elemental'),
778(849, 'a fire elemental'),
779(850, 'a demon'),
780(851, 'a banshee'),
781(852, 'a fire elemental'),
782(853, 'a fire elemental'),
783(854, 'gnorre chyllson'),
784(855, 'a war golem'),
785(856, 'a black knight boss'),
786(857, 'a aladin'),
787(858, 'a queen worm'),
788(859, 'the jafar'),
789(860, 'the jafar'),
790(861, 'a forgotten scarab'),
791(862, 'a ancient scarab'),
792(863, 'the jafar'),
793(864, 'a aladin'),
794(865, 'a grim reaper'),
795(866, 'a grim reaper'),
796(867, 'a mutated tiger'),
797(868, 'Ghazbaran'),
798(869, 'Ghazbaran'),
799(870, 'Ghazbaran'),
800(871, 'Ghazbaran'),
801(872, 'Ghazbaran'),
802(873, 'Svein, he is Pelle the smithing masters slave'),
803(874, 'Pelle the smithing master'),
804(875, 'a mine guard'),
805(876, 'a mine mage'),
806(877, 'a forgotten scarab'),
807(878, 'a ancient scarab'),
808(879, 'a ancient scarab'),
809(880, 'a braindeath'),
810(881, 'a demon'),
811(882, 'a fire elemental'),
812(883, 'an infected'),
813(884, 'a demon'),
814(885, 'a dragon lord'),
815(886, 'a grim reaper'),
816(887, 'a sultan'),
817(888, 'Ghazbaran'),
818(900, 'a djini'),
819(901, 'a aladin'),
820(902, 'a crazy hammerman'),
821(903, 'a experienced warlock'),
822(904, 'a sea serpent'),
823(905, 'a hydra'),
824(906, 'a hydra'),
825(907, 'a djini'),
826(908, 'a aladin'),
827(909, 'a aladin'),
828(910, 'a aladin'),
829(911, 'a djini'),
830(912, 'a aladin'),
831(913, 'a aladin'),
832(914, 'a djini'),
833(915, 'a djini'),
834(916, 'a aladin'),
835(918, 'a aladin'),
836(919, 'a djini'),
837(921, 'a thuls father'),
838(922, 'a hydra'),
839(923, 'a djini'),
840(924, 'a wyrm'),
841(925, 'a dragon lord'),
842(926, 'a wyrm'),
843(928, 'a demon'),
844(929, 'a warlock'),
845(930, 'a dragon lord'),
846(931, 'a fire elemental'),
847(932, 'a fire elemental'),
848(933, 'a banshee'),
849(934, 'a fire elemental'),
850(935, 'a fire elemental'),
851(936, 'a banshee'),
852(937, 'a warlock'),
853(938, 'a dragon lord'),
854(939, 'a demon'),
855(940, 'a fire elemental'),
856(941, 'a fire elemental'),
857(942, 'a fire elemental'),
858(943, 'a djini'),
859(944, 'a aladin'),
860(945, 'a grim reaper'),
861(946, 'a yeti'),
862(947, 'a djini'),
863(948, 'a sultan'),
864(949, 'a aladin'),
865(950, 'a dragon'),
866(951, 'a dragon lord'),
867(952, 'a djini'),
868(953, 'a fire elemental'),
869(954, 'a demon'),
870(955, 'a dragon lord'),
871(956, 'a djini'),
872(957, 'a aladin'),
873(958, 'a aladin'),
874(959, 'a djini'),
875(960, 'a djini'),
876(961, 'a jasmines tiger'),
877(962, 'a aladin'),
878(963, 'a aladin'),
879(964, 'a djini'),
880(965, 'a hero'),
881(966, 'a hydra'),
882(967, 'a djini'),
883(968, 'a demon'),
884(969, 'a dragon lord'),
885(970, 'a fire elemental'),
886(971, 'a fire elemental'),
887(972, 'a dragon lord'),
888(973, 'a fire elemental'),
889(974, 'a demon'),
890(975, 'a demon'),
891(976, 'a dragon lord'),
892(977, 'a fire elemental'),
893(978, 'a fire elemental'),
894(979, 'a fire elemental'),
895(980, 'a fire elemental'),
896(981, 'a banshee'),
897(982, 'a demon'),
898(983, 'a fire elemental'),
899(984, 'a demon'),
900(985, 'a banshee'),
901(986, 'a fire elemental'),
902(987, 'gnorre chyllson'),
903(988, 'a aladin'),
904(989, 'a banshee'),
905(990, 'a djini'),
906(991, 'a demon'),
907(992, 'a aladin'),
908(993, 'a djini'),
909(995, 'a djini'),
910(996, 'a djini'),
911(997, 'a sultan'),
912(998, 'a aladin'),
913(999, 'a aladin'),
914(1000, 'a aladin'),
915(1001, 'a bog raider'),
916(1002, 'a sultan'),
917(1003, 'a djini'),
918(1004, 'a hydra'),
919(1005, 'Ghazbaran'),
920(1006, 'a frost dragon'),
921(1007, 'gnorre chyllson'),
922(1008, 'a djini'),
923(1009, 'gnorre chyllson'),
924(1010, 'Orshabaal'),
925(1011, 'a demon'),
926(1012, 'a dark torturer'),
927(1013, 'a demon'),
928(1014, 'a diabolic imp'),
929(1015, 'a stormer'),
930(1016, 'a Master Ghost'),
931(1017, 'a thoughened juggernaut'),
932(1018, 'a Master Ghost'),
933(1019, 'a thoughened juggernaut'),
934(1020, 'a stormer'),
935(1021, 'a Master Ghost'),
936(1022, 'a stormer'),
937(1023, 'a stormer'),
938(1024, 'a thoughened juggernaut'),
939(1025, 'a crazy hammerman'),
940(1026, 'a Master Ghost'),
941(1027, 'a sultan'),
942(1028, 'a forgotten scarab'),
943(1029, 'Orshabaal'),
944(1030, 'a demon'),
945(1031, 'a demon'),
946(1032, 'a fire elemental'),
947(1033, 'a aladin'),
948(1034, 'a grim reaper'),
949(1035, 'Pelle the smithing master'),
950(1036, 'Svein, he is Pelle the smithing masters slave'),
951(1037, 'the handmaiden'),
952(1038, 'Orshabaal'),
953(1039, 'a vampire overlord'),
954(1040, 'the occultist'),
955(1041, 'the hag'),
956(1042, 'Orshabaal'),
957(1043, 'a demon'),
958(1044, 'a fire devil'),
959(1045, 'a grim reaper'),
960(1046, 'a thuls son'),
961(1047, 'a black knight'),
962(1048, 'a warlock'),
963(1049, 'a hellfire fighter'),
964(1050, 'a warlock'),
965(1051, 'a demon'),
966(1052, 'a frost dragon'),
967(1053, 'a thuls son'),
968(1054, 'a aladin'),
969(1055, 'a jasmine'),
970(1056, 'a aladin'),
971(1057, 'a jasmine'),
972(1058, 'a jasmine'),
973(1059, 'a aladin'),
974(1060, 'a forgotten scarab'),
975(1061, 'a jasmine'),
976(1062, 'a aladin'),
977(1063, 'a aladin'),
978(1064, 'a jasmine'),
979(1065, 'a aladin'),
980(1066, 'a warlock'),
981(1067, 'a hellfire fighter'),
982(1068, 'a hellfire fighter'),
983(1069, 'a arkhothep'),
984(1070, 'a warlock'),
985(1071, 'a demon'),
986(1072, 'a dragon lord'),
987(1073, 'a fire elemental'),
988(1074, 'a lich'),
989(1075, 'a warlock'),
990(1076, 'a hellfire fighter'),
991(1077, 'a thalas'),
992(1078, 'a arkhothep'),
993(1079, 'a braindeath'),
994(1080, 'the jafar'),
995(1081, 'a fire elemental'),
996(1082, 'a demon'),
997(1083, 'a dragon lord'),
998(1084, 'a thuls son'),
999(1085, 'a warlock'),
1000(1086, 'a stone golem'),
1001(1087, 'a hellspawn'),
1002(1088, 'a thul'),
1003(1089, 'a thuls son'),
1004(1090, 'the jafar'),
1005(1091, 'a queen worm'),
1006(1092, 'a aladin'),
1007(1093, 'a black knight boss'),
1008(1094, 'a hydra lord'),
1009(1095, 'a vampire bride'),
1010(1096, 'a hellspawn'),
1011(1097, 'a vampire'),
1012(1098, 'a grim reaper'),
1013(1099, 'the spirit of earth'),
1014(1100, 'a zombie'),
1015(1101, 'a queen worm'),
1016(1102, 'a aladin'),
1017(1103, 'Orshabaal'),
1018(1104, 'a demon'),
1019(1105, 'a demon'),
1020(1106, 'a demon'),
1021(1107, 'Orshabaal'),
1022(1108, 'a demon'),
1023(1109, 'a demon'),
1024(1110, 'a demon'),
1025(1111, 'a demon'),
1026(1112, 'a demon'),
1027(1113, 'a demon'),
1028(1114, 'Orshabaal'),
1029(1115, 'Orshabaal'),
1030(1116, 'Apocalypse'),
1031(1117, 'Morgaroth'),
1032(1118, 'a demon'),
1033(1119, 'a aladin'),
1034(1120, 'Apocalypse'),
1035(1121, 'Morgaroth'),
1036(1122, 'a demon'),
1037(1123, 'a demon'),
1038(1124, 'a demon'),
1039(1125, 'a demon'),
1040(1126, 'a demon'),
1041(1127, 'a demon'),
1042(1128, 'a djini'),
1043(1129, 'a djini'),
1044(1130, 'Orshabaal'),
1045(1131, 'a demon'),
1046(1132, 'a demon'),
1047(1133, 'a demon'),
1048(1134, 'a demon'),
1049(1135, 'a demon'),
1050(1138, 'a demon'),
1051(1139, 'a demon'),
1052(1140, 'a warlock'),
1053(1141, 'a demon'),
1054(1142, 'Ferumbras'),
1055(1143, 'a warlock'),
1056(1144, 'the jafar'),
1057(1145, 'the jafar'),
1058(1146, 'a vampire overlord'),
1059(1147, 'a experienced warlock'),
1060(1148, 'a demon'),
1061(1149, 'the handmaiden'),
1062(1150, 'a undead dragon'),
1063(1151, 'a fire elemental'),
1064(1152, 'a undead dragon'),
1065(1153, 'the handmaiden'),
1066(1154, 'a demon'),
1067(1155, 'a dragon lord'),
1068(1156, 'a fire elemental'),
1069(1157, 'a fire elemental'),
1070(1158, 'Orshabaal'),
1071(1159, 'a demon'),
1072(1160, 'a demon'),
1073(1161, 'Orshabaal'),
1074(1162, 'a demon'),
1075(1163, 'Orshabaal'),
1076(1164, 'a demon'),
1077(1165, 'Orshabaal'),
1078(1166, 'Svein, he is Pelle the smithing masters slave'),
1079(1167, 'Svein, he is Pelle the smithing masters slave'),
1080(1168, 'Pelle the smithing master'),
1081(1169, 'Svein, he is Pelle the smithing masters slave'),
1082(1170, 'Pelle the smithing master'),
1083(1171, 'Svein, he is Pelle the smithing masters slave'),
1084(1172, 'Orshabaal'),
1085(1173, 'Orshabaal'),
1086(1174, 'a demon'),
1087(1175, 'Orshabaal'),
1088(1176, 'a vampire overlord'),
1089(1177, 'a vampire overlord'),
1090(1178, 'the occultist'),
1091(1179, 'a experienced warlock'),
1092(1180, 'a experienced warlock'),
1093(1181, 'a vampire overlord'),
1094(1182, 'the occultist'),
1095(1183, 'a aladin'),
1096(1184, 'a jasmine'),
1097(1185, 'a jasmine'),
1098(1186, 'a aladin'),
1099(1187, 'a jasmine'),
1100(1188, 'a aladin'),
1101(1189, 'a braindeath'),
1102(1190, 'gnorre chyllson'),
1103(1191, 'gnorre chyllson'),
1104(1192, 'a black knight boss'),
1105(1193, 'a warlock'),
1106(1194, 'a djini'),
1107(1195, 'a sultan'),
1108(1196, 'a warlock'),
1109(1197, 'a aladin'),
1110(1198, 'a undead dragon'),
1111(1199, 'a demon'),
1112(1200, 'a dragon lord'),
1113(1201, 'a fire elemental'),
1114(1202, 'a zombie'),
1115(1203, 'a grim reaper'),
1116(1204, 'a werewolf'),
1117(1206, 'the jafar'),
1118(1207, 'the jafar'),
1119(1209, 'the jafar'),
1120(1210, 'the jafar'),
1121(1211, 'a demon'),
1122(1212, 'gnorre chyllson'),
1123(1213, 'a juggernaut'),
1124(1214, 'a dark torturer'),
1125(1216, 'a black knight boss'),
1126(1218, 'a black knight boss'),
1127(1220, 'a elder beholder'),
1128(1221, 'a black knight boss'),
1129(1222, 'the jafar'),
1130(1224, 'a vampire overlord'),
1131(1225, 'a war golem'),
1132(1226, 'Orshabaal'),
1133(1227, 'a vampire bride'),
1134(1228, 'a war golem'),
1135(1229, 'Orshabaal'),
1136(1230, 'a queen worm'),
1137(1231, 'a vampire overlord'),
1138(1232, 'svoren the mad'),
1139(1233, 'a smoker'),
1140(1234, 'a black knight boss'),
1141(1235, 'Protector'),
1142(1236, 'a warlock'),
1143(1237, 'a hellhound'),
1144(1238, 'Fluffy'),
1145(1239, 'a juggernaut'),
1146(1240, 'Ferumbras'),
1147(1241, 'a demon'),
1148(1242, 'a sultan'),
1149(1243, 'a smoker'),
1150(1244, 'a smoker'),
1151(1245, 'a smoker'),
1152(1246, 'a smoker'),
1153(1247, 'a scarecrow'),
1154(1248, 'a woodmonster'),
1155(1249, 'a ice demon'),
1156(1250, 'a giant snow bear'),
1157(1251, 'an ice guard'),
1158(1252, 'a fire elemental'),
1159(1253, 'a demon'),
1160(1254, 'the jafar'),
1161(1255, 'a mutated rat'),
1162(1256, 'a zombie'),
1163(1257, 'a grim reaper'),
1164(1258, 'Orshabaal'),
1165(1259, 'a grim reaper'),
1166(1260, 'a zombie'),
1167(1261, 'a mutated tiger'),
1168(1262, 'a mutated rat'),
1169(1263, 'a zombie'),
1170(1264, 'a grim reaper'),
1171(1265, 'a werewolf'),
1172(1266, 'Orshabaal'),
1173(1267, 'a warlock'),
1174(1268, 'a diabolic imp'),
1175(1269, 'a serpent spawn'),
1176(1270, 'a dipthrah'),
1177(1271, 'a earth elemental'),
1178(1272, 'a grim reaper'),
1179(1273, 'a jasmine'),
1180(1274, 'a jasmine'),
1181(1275, 'avalanche'),
1182(1276, 'a demon'),
1183(1277, 'a hellhound'),
1184(1278, 'Orshabaal'),
1185(1279, 'Bones'),
1186(1280, 'a hellhound'),
1187(1281, 'a yeti'),
1188(1282, 'Orshabaal of Braveness'),
1189(1284, 'a forgotten scarab'),
1190(1285, 'a ancient scarab'),
1191(1286, 'a sultan'),
1192(1287, 'a jasmine'),
1193(1288, 'Orshabaal'),
1194(1289, 'the Old Widow'),
1195(1290, 'a sultan'),
1196(1291, 'a massive water elemental'),
1197(1292, 'a black knight'),
1198(1293, 'a sultan'),
1199(1294, 'a grim reaper'),
1200(1295, 'Orshabaal'),
1201(1296, 'a juggernaut'),
1202(1297, 'a demon'),
1203(1298, 'Orshabaal'),
1204(1299, 'Minishabaal'),
1205(1300, 'Orshabaal'),
1206(1301, 'Orshabaal'),
1207(1302, 'Minishabaal'),
1208(1303, 'a dark torturer'),
1209(1304, 'a undead dragon'),
1210(1305, 'a lost soul'),
1211(1306, 'an ice guard'),
1212(1307, 'a ice demon'),
1213(1308, 'a ice giant'),
1214(1309, 'Orshabaal'),
1215(1310, 'Orshabaal'),
1216(1311, 'a experienced warlock'),
1217(1312, 'a warlock'),
1218(1313, 'a experienced warlock'),
1219(1314, 'Orshabaal'),
1220(1315, 'a hydra'),
1221(1316, 'a serpent spawn'),
1222(1317, 'Ghazbaran'),
1223(1318, 'Ghazbaran'),
1224(1319, 'a dragon lord'),
1225(1320, 'Ghazbaran'),
1226(1321, 'a banshee'),
1227(1322, 'a demon'),
1228(1323, 'a juggernaut'),
1229(1324, 'a demon'),
1230(1325, 'a grim reaper'),
1231(1326, 'a hydra lord'),
1232(1327, 'a black knight boss'),
1233(1328, 'a vampire overlord'),
1234(1329, 'a queen worm'),
1235(1330, 'Orshabaal of Braveness'),
1236(1332, 'Orshabaal of Braveness'),
1237(1333, 'Orshabaal'),
1238(1334, 'Orshabaal of Braveness'),
1239(1336, 'a bog raider'),
1240(1337, 'a jasmines tiger'),
1241(1339, 'a massive water elemental'),
1242(1340, 'a warlock'),
1243(1341, 'Orshabaal'),
1244(1342, 'a demon'),
1245(1343, 'a experienced warlock'),
1246(1344, 'a warlock'),
1247(1345, 'a fire elemental'),
1248(1346, 'a demon'),
1249(1347, 'Orshabaal'),
1250(1348, 'a demon'),
1251(1349, 'a grim reaper'),
1252(1350, 'a demon'),
1253(1351, 'a warlock'),
1254(1352, 'a demon'),
1255(1353, 'a hellfire fighter'),
1256(1354, 'a warlock'),
1257(1355, 'a dark torturer'),
1258(1356, 'a nightmare'),
1259(1357, 'Morgaroth'),
1260(1358, 'a aladin'),
1261(1359, 'a jasmines tiger'),
1262(1360, 'a zombie'),
1263(1361, 'a grim reaper'),
1264(1362, 'a mutated tiger'),
1265(1363, 'a mutated rat'),
1266(1364, 'a mine guard'),
1267(1365, 'a mine mage'),
1268(1366, 'a mine guard'),
1269(1367, 'a mine mage'),
1270(1368, 'a Master Ghost'),
1271(1369, 'a frost dragon'),
1272(1370, 'a dragon lord'),
1273(1371, 'Orshabaal'),
1274(1372, 'Ferumbras'),
1275(1373, 'a grim reaper'),
1276(1374, 'a grim reaper'),
1277(1376, 'a thuls son'),
1278(1377, 'a thul'),
1279(1378, 'a thul'),
1280(1379, 'a sultan'),
1281(1380, 'Orshabaal'),
1282(1381, 'Orshabaal'),
1283(1382, 'a demon'),
1284(1383, 'a demon'),
1285(1384, 'a banshee'),
1286(1385, 'a demon'),
1287(1386, 'Orshabaal'),
1288(1387, 'a demon'),
1289(1388, 'a demon'),
1290(1389, 'a demon'),
1291(1390, 'a banshee'),
1292(1391, 'a thuls father'),
1293(1392, 'gnorre chyllson'),
1294(1393, 'a queen worm'),
1295(1394, 'Orshabaal'),
1296(1395, 'Apocalypse'),
1297(1396, 'a demon'),
1298(1397, 'a demon'),
1299(1398, 'a blazing fire elemental'),
1300(1399, 'Orshabaal'),
1301(1400, 'a demon'),
1302(1401, 'a demon'),
1303(1402, 'a aladin'),
1304(1403, 'a demon'),
1305(1404, 'a djini'),
1306(1405, 'a black knight boss'),
1307(1406, 'a jasmine'),
1308(1407, 'Orshabaal'),
1309(1408, 'a djini'),
1310(1409, 'a sultan'),
1311(1410, 'the Old Widow'),
1312(1411, 'a djini'),
1313(1412, 'a sultan'),
1314(1413, 'a aladin'),
1315(1414, 'the Old Widow'),
1316(1415, 'a squirrel'),
1317(1416, 'a woodmonster'),
1318(1417, 'a scarecrow'),
1319(1418, 'a ice troll'),
1320(1419, 'a ice giant'),
1321(1420, 'a frost dragon'),
1322(1421, 'the hairy one'),
1323(1422, 'a hydra lord'),
1324(1423, 'a hydra lord'),
1325(1424, 'Orshabaal'),
1326(1425, 'a demon'),
1327(1426, 'Minishabaal'),
1328(1427, 'a zombie'),
1329(1428, 'a grim reaper'),
1330(1429, 'a mutated tiger'),
1331(1430, 'a werewolf'),
1332(1431, 'a zombie'),
1333(1432, 'a zombie'),
1334(1433, 'a zombie'),
1335(1434, 'a grim reaper'),
1336(1435, 'a vampire overlord'),
1337(1436, 'a vampire overlord'),
1338(1437, 'a yeti'),
1339(1438, 'Apocalypse'),
1340(1439, 'Apocalypse'),
1341(1440, 'Morgaroth'),
1342(1441, 'Apocalypse'),
1343(1442, 'Morgaroth'),
1344(1443, 'a aladin'),
1345(1444, 'a jasmine'),
1346(1445, 'Pelle the smithing master'),
1347(1446, 'Orshabaal'),
1348(1447, 'Svein, he is Pelle the smithing masters slave'),
1349(1448, 'a juggernaut'),
1350(1449, 'a demon'),
1351(1450, 'Orshabaal'),
1352(1451, 'a demon'),
1353(1452, 'a juggernaut'),
1354(1453, 'the handmaiden'),
1355(1454, 'Orshabaal'),
1356(1455, 'a juggernaut'),
1357(1456, 'Death'),
1358(1458, 'a medusa'),
1359(1459, 'a vampire overlord'),
1360(1460, 'a frost dragon'),
1361(1461, 'a castle wizard'),
1362(1462, 'a castle guard'),
1363(1463, 'a castle defender'),
1364(1464, 'a castle defender'),
1365(1465, 'a castle defender'),
1366(1466, 'a blazing fire elemental'),
1367(1467, 'Orshabaal'),
1368(1468, 'a little blazing fire elemental'),
1369(1469, 'a medusa'),
1370(1470, 'a medusa'),
1371(1471, 'a thuls son'),
1372(1472, 'a braindeath'),
1373(1473, 'a elder beholder'),
1374(1474, 'a yeti'),
1375(1475, 'Orshabaal'),
1376(1476, 'a demon'),
1377(1477, 'Orshabaal'),
1378(1478, 'a demon'),
1379(1480, 'a zombie'),
1380(1481, 'a zombie'),
1381(1482, 'a zombie'),
1382(1483, 'a vampire overlord'),
1383(1484, 'a vampire overlord'),
1384(1486, 'avalanche'),
1385(1487, 'a hellfire fighter'),
1386(1488, 'a warlock'),
1387(1489, 'a thalas'),
1388(1490, 'a arkhothep'),
1389(1491, 'a dark torturer'),
1390(1492, 'a nightmare'),
1391(1493, 'a lich'),
1392(1494, 'a queen worm'),
1393(1495, 'a black knight boss'),
1394(1496, 'the jafar'),
1395(1497, 'a grim reaper'),
1396(1498, 'the jago'),
1397(1499, 'a nightmare'),
1398(1500, 'a djini'),
1399(1501, 'a mine mage'),
1400(1502, 'a mine guard'),
1401(1503, 'Morgaroth'),
1402(1504, 'a dipthrah'),
1403(1505, 'a serpent spawn'),
1404(1506, 'a priestess'),
1405(1507, 'a blazing fire elemental'),
1406(1508, 'Orshabaal'),
1407(1509, 'a demon'),
1408(1510, 'a little blazing fire elemental'),
1409(1511, 'a squirrel'),
1410(1512, 'Orshabaal'),
1411(1513, 'a hellhound'),
1412(1514, 'a queen worm'),
1413(1516, 'a level 3 fire'),
1414(1517, 'a vampire overlord'),
1415(1518, 'a aladin'),
1416(1519, 'a queen worm'),
1417(1520, 'a queen worm'),
1418(1522, 'a bog raider'),
1419(1523, 'a crazy hammerman'),
1420(1524, 'a experienced warlock'),
1421(1525, 'a hellhound'),
1422(1526, 'a stone golem'),
1423(1527, 'a experienced warlock'),
1424(1528, 'a crazy hammerman'),
1425(1529, 'a hellhound'),
1426(1530, 'a stone golem'),
1427(1531, 'a queen worm'),
1428(1532, 'a queen worm'),
1429(1533, 'a sultan'),
1430(1534, 'a aladin'),
1431(1535, 'a zombie'),
1432(1536, 'a vampire overlord'),
1433(1537, 'a lost soul'),
1434(1538, 'a bonebeast'),
1435(1539, 'deathbringer'),
1436(1540, 'a zombie'),
1437(1541, 'a grim reaper'),
1438(1542, 'a mutated tiger'),
1439(1543, 'a vampire overlord'),
1440(1544, 'Morgaroth'),
1441(1545, 'Orshabaal'),
1442(1546, 'a dark torturer'),
1443(1547, 'a diabolic imp'),
1444(1548, 'a jasmine'),
1445(1549, 'a aladin'),
1446(1550, 'Orshabaal of Braveness'),
1447(1551, 'Orshabaal'),
1448(1552, 'a massive energy elemental'),
1449(1553, 'a blazing fire elemental'),
1450(1554, 'a massive water elemental'),
1451(1555, 'a hydra'),
1452(1556, 'a hydra'),
1453(1557, 'a serpent spawn'),
1454(1558, 'a dragon lord'),
1455(1559, 'a dragon lord'),
1456(1560, 'a demon'),
1457(1561, 'a demon'),
1458(1562, 'a fire elemental'),
1459(1563, 'a fire elemental'),
1460(1564, 'a grim reaper'),
1461(1565, 'a zombie'),
1462(1566, 'a jasmines tiger'),
1463(1567, 'a aladin'),
1464(1568, 'a jasmine'),
1465(1569, 'a hellfire fighter'),
1466(1570, 'a warlock'),
1467(1571, 'a grim reaper'),
1468(1572, 'a demon'),
1469(1573, 'a queen worm'),
1470(1574, 'a dragon lord'),
1471(1575, 'a banshee'),
1472(1576, 'a demon'),
1473(1577, 'a braindeath'),
1474(1578, 'a demon'),
1475(1579, 'a demon'),
1476(1580, 'a demon'),
1477(1581, 'a ancient scarab'),
1478(1582, 'a jasmines tiger'),
1479(1583, 'a level 1 earth'),
1480(1584, 'a ancient scarab'),
1481(1585, 'a aladin'),
1482(1586, 'a hellfire fighter'),
1483(1587, 'a zombie'),
1484(1588, 'a bonebeast'),
1485(1589, 'a necromancer'),
1486(1590, 'a bonebeast'),
1487(1591, 'a juggernaut'),
1488(1592, 'the Old Widow'),
1489(1593, 'a aladin'),
1490(1594, 'a djini'),
1491(1595, 'a sultan'),
1492(1596, 'a demon'),
1493(1597, 'a hellhound'),
1494(1598, 'a giant spider'),
1495(1599, 'a hellspawn'),
1496(1600, 'an infected'),
1497(1601, 'an infected'),
1498(1602, 'a frost dragon'),
1499(1603, 'a dragon lord'),
1500(1604, 'a dragon lord'),
1501(1605, 'a aladin'),
1502(1606, 'a warlock'),
1503(1607, 'a stone golem'),
1504(1608, 'a aladin'),
1505(1609, 'a jasmines tiger'),
1506(1610, 'a grim reaper'),
1507(1611, 'a sultan'),
1508(1612, 'a frost dragon'),
1509(1613, 'a frost dragon'),
1510(1614, 'a frost dragon'),
1511(1615, 'a frost dragon'),
1512(1616, 'a frost dragon'),
1513(1617, 'a aladin'),
1514(1618, 'a aladin'),
1515(1619, 'a jasmines tiger'),
1516(1620, 'a sultan'),
1517(1621, 'a frost dragon'),
1518(1622, 'a hellspawn'),
1519(1623, 'a aladin'),
1520(1624, 'a aladin'),
1521(1625, 'a hydra'),
1522(1626, 'a grim reaper'),
1523(1627, 'a dragon'),
1524(1628, 'a serpent spawn'),
1525(1629, 'a hydra'),
1526(1630, 'a aladin'),
1527(1631, 'a jasmines tiger'),
1528(1632, 'a aladin'),
1529(1633, 'a aladin');
1530
1531-- --------------------------------------------------------
1532
1533--
1534-- Table structure for table `feedback`
1535--
1536-- Creation: Jul 23, 2014 at 12:49 PM
1537-- Last update: Jul 23, 2014 at 12:49 PM
1538--
1539
1540DROP TABLE IF EXISTS `feedback`;
1541CREATE TABLE IF NOT EXISTS `feedback` (
1542  `id` int(11) NOT NULL AUTO_INCREMENT,
1543  `title` varchar(100) NOT NULL,
1544  `text` text NOT NULL,
1545  `name` varchar(50) NOT NULL,
1546  `self` int(1) NOT NULL DEFAULT '0',
1547  `ip` int(10) NOT NULL,
1548  `time` int(10) NOT NULL,
1549  `status` int(1) NOT NULL DEFAULT '0',
1550  `type` tinyint(2) NOT NULL DEFAULT '0',
1551  `response` text NOT NULL,
1552  `OTSTable` int(11) NOT NULL,
1553  UNIQUE KEY `id` (`id`)
1554) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=161 ;
1555
1556-- --------------------------------------------------------
1557
1558--
1559-- Table structure for table `forums`
1560--
1561-- Creation: Jul 23, 2014 at 12:49 PM
1562--
1563
1564DROP TABLE IF EXISTS `forums`;
1565CREATE TABLE IF NOT EXISTS `forums` (
1566  `id` int(11) NOT NULL AUTO_INCREMENT,
1567  `name` varchar(255) DEFAULT NULL,
1568  `description` text,
1569  `closed` int(5) DEFAULT NULL,
1570  `access` int(5) NOT NULL,
1571  PRIMARY KEY (`id`)
1572) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
1573
1574--
1575-- Dumping data for table `forums`
1576--
1577
1578INSERT INTO `forums` (`id`, `name`, `description`, `closed`, `access`) VALUES
1579(2, 'First forum.', 'This is your first forum.', 0, 0);
1580
1581-- --------------------------------------------------------
1582
1583--
1584-- Table structure for table `global_storage`
1585--
1586-- Creation: Jul 23, 2014 at 12:49 PM
1587--
1588
1589DROP TABLE IF EXISTS `global_storage`;
1590CREATE TABLE IF NOT EXISTS `global_storage` (
1591  `key` int(10) unsigned NOT NULL,
1592  `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
1593  `value` varchar(255) NOT NULL DEFAULT '0',
1594  UNIQUE KEY `key` (`key`,`world_id`)
1595) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1596
1597--
1598
1599-- --------------------------------------------------------
1600
1601--
1602-- Table structure for table `guilds`
1603--
1604-- Creation: Jul 23, 2014 at 12:49 PM
1605--
1606
1607DROP TABLE IF EXISTS `guilds`;
1608CREATE TABLE IF NOT EXISTS `guilds` (
1609  `id` int(11) NOT NULL AUTO_INCREMENT,
1610  `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
1611  `name` varchar(255) NOT NULL,
1612  `ownerid` int(11) NOT NULL,
1613  `creationdata` int(11) NOT NULL,
1614  `checkdata` int(11) NOT NULL,
1615  `motd` varchar(255) NOT NULL,
1616  `description` text NOT NULL,
1617  `logo_gfx_name` varchar(255) NOT NULL DEFAULT '',
1618  `invited_to` int(11) NOT NULL,
1619  `invited_by` int(11) NOT NULL,
1620  `in_war_with` int(11) NOT NULL,
1621  `kills` int(11) NOT NULL,
1622  `show` smallint(1) NOT NULL,
1623  `war_time` int(11) NOT NULL,
1624  `guild_logo` mediumblob,
1625  `create_ip` int(11) NOT NULL DEFAULT '0',
1626  `balance` bigint(20) unsigned NOT NULL DEFAULT '0',
1627  PRIMARY KEY (`id`),
1628  UNIQUE KEY `name` (`name`,`world_id`)
1629) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
1630
1631--
1632-- Dumping data for table `guilds`
1633--
1634
1635INSERT INTO `guilds` (`id`, `world_id`, `name`, `ownerid`, `creationdata`, `checkdata`, `motd`, `description`, `logo_gfx_name`, `invited_to`, `invited_by`, `in_war_with`, `kills`, `show`, `war_time`, `guild_logo`, `create_ip`, `balance`) VALUES
1636(7, 0, 'Infamous', 186, 1407591022, 0, '', 'Friends Guild', '', 0, 0, 0, 0, 0, 0, 0x313430373732333539353b646174613a696d6167652f6a7065673b6261736536342c2f396a2f34414151536b5a4a5267414241514141415141424141442f3277434541416b474278515445685155457851564668555847426359467867594742636346787759484263614678305846526359484367674742776c48426359496a45684a536b724c6934754678387a4f444d734e7967744c69734243676f4b4467304f477841514769776b494351734c4377734c4377734c4377734c4377734c4377734c4377734c4377734c4377734c4377734c4377734c4377734c4377734c4377734c4377734c4377734c4377734c502f414142454941514d4177674d4245514143455145444551482f7841416341414143417745424151454141414141414141414141414642674d454277494141516a2f7841424745414143415149444251554543415544416751484141414241674d4145515153495155474d55465245794a68635945484d70476846434e435572484230664269636f4b536f724c683854505351315043777767574a584e306737502f784141624151414341774542415141414141414141414141414141414241454341775547422f2f454144515241414943415149444251634442414d42414141414141414241674d52424345534d55454645794a52595847426b6147787766416a4d74455551754878426c4b4359762f61414177444151414345514d52414438412b59434d494c4c2b47767254444e4174687232767971434339477451415477306773427a365655674a345349483071704157555642426177395142596f4139514236674146746e6644425955355a703044666457374e3671674a4872566c42766b5a547568446d7747666168675364476c7431374d322f577239307a463675415177572b6d436c73467843416e6747757076354d42554f746f7648557766554d5a6764515152575a756e6b7054314a4a576567434a78514279466f41346b5731424a566c7177412f47587362565a466861786d70756175674b556c5353565765315353636c7633616741327156557146396d4736322f664c392b6c565942434e4e6167674b596644446c72666856636b42644962577470666a56514c676f494c634271414a614141323947387347426937535a72636c55617578364b503242566c484a6e4f785252693233392b4d5a6a3279497867685042454a7a45645863616e794668353078436f356d6f316e436d7750684e6d4454784a31353247704e365a565a79376455392f7741336649396a723930445145364477766135714a6f76524a4c4c65374f5a3468777451344975725a5071464e3339394d52676d7350724975615066682f433345664f734a31706a744f6f6c453248594f3173506a346531674e6e467336453935543059666761576c46784f7058617072596e6b7754577a573074362f436f4e434659723041646947674346306f4a4b383849497151462f6147495a53525966735875445769525a432f4b536233503731345659437136314a494e6b665531596b3537536742726a69724d7145646e7747392f44394b686746595631476c5649433843327461716b42474548553142424f71336f41754974716742533331337762433353434d5353415a6e7a456855577849766269784373626446506866534e6564324c57366852654559707476616b324e6e37584548556142414346516446423147757655307843434f666463337a444f7a646e4255642b59552f4f772f4f6e6f563457547a3270314c6c4e52365a4c66304d694d572b3641504d366e3852562b44595837334d38767a66794b386d7a383035484a5150784e51345a6c374562517663614d39577a6a465941356e3034667176366d71384753304e516b6b767a71433862674c4d77506c2b2f6a574d3459593954667852545248757a74743842693435564a793341636665512b38506877386255764b50513664566a574a4c6f6670654b5258554d704256674344794949754350536b7a734a355755554d52683758493466763555456c577041676d46424a5865704143625a67557165756e72622f414a713057536865654f7443536c6968626a35576f4a414d68314e584a4f614148784572497145384d746a346638564242666854577167454d4f764c576f49436b59307143435a4b414a73544f45526e4a73717157506b426570697376434b5754554975543647663437415a7847722b2f694a4d3876676758744758794372476e787078704c6c304f4647626c6a6936764c2b76307776694b2b38757959316937556743516d4e41656a4d686e596a7837342b4662516973436474736d3976657662752f7169585966316b45335552366a6f5664623079705a697661636d634f47312b7a4b2b4b44754d32634d38436764436652682b51714979796d776e586a48357a5a54326668737a5453486d366f505451314b5a4d3134462b666e5169374e5357593842636e3075352f314b4b6c4d6a6753537835415a5557514d334d3844346c623147464a5a4c4f55716d6f2f6e4d576434746e3563354842542b4970572b474d6e58304f6f343148505647762b787a62426e77485a73627441536e6a6b4f712f44556567704731636d64375354796e48792b6a2f41426a54504b43542b394b7a4779746567434756685153565a577151424f305a564971794a514278493666766a5679514e6a314a31766f4b73695543704671784a486167445255693172456f584d49626d334b6f5942614a4c56424264776938616867586c7143435261414b47384d6e63534d38486137662f6254767438624165744d61614f5a4f586c3958794f583270616f3171482f5a372b7862762b42587857494c34316c2f38724373443453544f6f2f416e3455776c757662386b63795533775366584750652b6631464c327659777044683876457a7a535738464f52666b4255574e786a7436665450334c3661437373616c35532b625358796952376d5977463341393257456b6566642f4c2f5454436c6e475061632b797244616c7a57562b666e5564386669414a5154775349742f7146544665422b30576b38324a656e386759796c5959596b316b64586b506d77304a2f75763656575669676e4f5849336a524b3663616f63322f7a35626c4c59757a4a35326244757252364b5a47493449546654715346565235486f615574317359317553336235485670374b6c4b39526c736c752f5a302b4a523276414d4e4b385333796955415834324b693334317470722b4b7544664e69577630696a714c46486c464c35376c62654641304d6a656e7a4970753965427335335a386d726f522f4f6757396a437645324b42754d794952364d772f412f4f755259396a32656d6a6962666f614f78724963496e6567434a6a556b672f4774666e556f4163385971784a527855665370524948786b576c763378715541436c484c70567978584a71514e53435667554c4f416a7361686b42524671414c47484f74716743324b434365415641433174374667346c6c2b34714a2f636530662f46514b36656d686974507a65666873766d6557375776347451342f7744564a6648642f4a43707537692b306e78457050767978442b6c51306e2f414b68566b766f59327978464a2b6566674b66744e6c7a74683050325956503954444d6678724f2b5033474f7a3576642b78664c5033414f3557304f7a6c56474e72456c5434454545664f2f72556165652f437a5874476e4b377950585a2f5966736669704a576b4343393079583541327a74666f4144657462376f31356a2b62374850304f6b6e644b4e6957325838747873334932535150704d673737674c4744396d49634e4f7031506b514b343275315065533446795236587376524b6d43736b76452f6c6b617767467a6255385453423152493376324f7557535469786674443643774870787033533374575254354c2b524c57364e4f6d787062762b4d497a33614d374e686974695761514c59416b36585936447972765732727563767a5049365854502b733455755366384448374c4d523961514f635248774b2f70584d6d65703035704c316d4e4545686f4a49484e5342556c537041725046556b676a453244616e722b64535342636153626e78717941465374725669537359783071514e5556623167554c6548587771414c367251424c45757451426156623045466d4a6566536f417976612b30652f694a4c387058487955664b3964784c68676c35493848624a323379666e4c3734417537553257466a31642f6c45522f3661705561367437343950726b74596e5959784f4a6b655433465655466a59356771362b672f477566723733435369755a3365784e4972616e4f58493666636a445a52624d47484272362b6f3465476c715157716e6e4a32333266587734334858646a59596a6843743369317978504f2f774473415053734c3735577a346d616162545130315864782f4d6a477a68523867414e66494156696c6b75336a6371797a4f656b592b4c666f506e5676437655694b6d33356658382b494532785047464965546a7033694e6236634b6d4b65637047306c7468697a75784e48424e694a47463746566a417463744a7163742b67556b2b4636653145334b6d4566617a6b614f68523156733865532b374f39324d4d6b573138524776335a48742f4e6b66344150617256793471307a5a785562704a442b3153614661516336414b37564a4a77776f4168644c3149414c6245467248303071794a5173343532463962432b6e57726f7344574e57416a4a6f4a4e596a487257426d585954656f417551725545466d4a6461414c51555641487a46545a4933623771736667436174425a6b6b5a3353554b355366524d772f616b2f31553338675834756231327076615234696d506a68367650334b75784a66714978314d682f7742512f4f7156667458764c36706671792f386a6a673349456c6750665045324875723456794f30597276392f4a48714f775a79656958437572357642647769733741585166483555684c68584c4a3234757a726763634e61326c5946706c546265304244477a32755259416453663366304e576973764243355a4d62323537514a355879346655456b646f62354e4f4f5166617463616e777270365852393438497654475673754749735434584579596d465a705864335947797562646d5074414c6f742b476e576e4e56706c703462383339445455365630704b584e2f547a4e466777426a78456475476c6c313468414366486c584a6c504d524f4e66444e767a78394378757a4f547642694a434f3459356f7765724b4951666c4733774e4d567246555256744f3658754e4561724679744d4b4149616b6b35635541524e514251326b46796d2f486c566b534b575055454532314678714b7569514f59545669536f32446170794273454e676461584b467945587143433568785142614171414f316f416f627a7935634a4d663451506951507a7266544c4e735248744b5844705a2b7a4878324d507837586a6c38524838334a726f7966686c376a7a56554d5777392f307751624a6579524470326e2b722f656f72666858764c616d50366b2f7744795864352f7047645769664c47514d3573546134466d49484c5133504c546c53577578336d5473663866636c706d6c352f79424973506a43374b73366c68336b444b75563134356c594458546f654f6c576f306b62346546372b52367654365a3378384d7646354d316a325a37516b62446f737741624d7746723230504b2b6f423130726b36756e75725848794b5756754759766d686d327873355a30614a37324e4c4a744d71734f4975347a63705468786831534e555567713671524b7042766d563736487874547465736c44654f7a4a726169387865437a7350644b4c445a6e793570434e5862764f664e6a72627734566a66714a32764d6d61536d70537a6e4c3877526a4d6446424b38736776326136416346305a67577477766c734c3248486e594773597553776a47636c4635596f626c346f2f54734c4b7a41586b4c4f5351423330634d546638416d5079727253696c44434f44544e79756266584a737a6b4536634b774f6b56356c6f416774556b6e694b4149534b414b754c6a754f465367516f59754c6a787465327650572b7458525970354e4b6b43496c657453427030616461784b6c394c637167676d69464146745671414a464641433137524a387547436a37546a3441452f6a616d394776473336484a37596c2b696f2b6258794d773254672b306b696a5032306a5038416b2f36436d484c775339787a59312f7256663841723767325345787546504a6d487851483852553176777232737271492f7153586f686877457939786d315751424466686637507834556a723874376553663158384855374278424e502f733138556d7675576d3362684a3978625876626c6672352b4e6335584e487148434333446545635168636f746c49507749716a6645796a484836516a4e335742386a57544d3470714f4758466b46546b79635755397134674c47547746527a4e4b31766b2f4e65386530445069357043446c4a4b722f41437233522b462f57757254424b4b527a4e5659334e74486547786c6c5378313042387542706e4f79454d4e535a7147346d38445858447947366e7570666970354c666d7031413647334b7372495933513570376d2f43783764644b794843746c6f4a50685767434a3171514b2b494941317151466a61477034636173695163304e5353415a4d45626e55635456386b6d79684b774b46694a52554545364378464146324e616744753141436a763841706d37426572456572412f39744e365a346932636a744a63553472792b2f38416f543969775a4a646e794837566c50394d672f377a576965564e6567764f50433670662f41466a346c44666242474f5573426f48532f7a48354770726c3453756f682b6f6e357072366c33646e5936347643346d4c587449374d684273534e62722b42485167654e3661684c5a763152667339766973532f2b5a4c335a4a6467376357526a417a665770774a4668496f344f6f3639563548777361354e314d713336487064507159584c5a376850477a68426467317571717a66454b43617853794d4d465950666943454f3861797a4d674941436b446a593569645146385265724f7439533061334a65677862703764784f4f6c6373456a676973446b75586151674e6b7a45327967616e514533587846556c46524b32317174347956392f74733859455041586b5051636c387a2b7457726a314d2b6d4248335633446d786d4666455273466b443978584243794a6137576132687a6141384c7151656f36696d6f76427833533745322b6551426a6c6146326a6d6a644a46346f796d2f67644e434f68476c6263536b68507535516c7546634274416a4934466e42566c4669534742767747704678564a4e59334e7130334c4b52716d45336b5230566d5352535233686b4e6765666952365572784936695461354253475658554d6842485838694f4950676173516658587051425766786f4a426d4e73416465642f6a65724941464c454256695343534f346f416a454e5353615771316b554f3153674378464855415731576744376167425933746a75304a365478412b566d5035307857384c48742b787a645448696e6e7963666f2f3541323063423265476a6132734f496b4839506173772b51577256793865504e47656f722f527a355050775a78766467424a3949414775544f50365744666737664369447754644469793130332b346a4c7461584276495957796c6c414a7344334e4f5242462f64313836316b6c4b4f346c533356626c65712b4f362b676d34746934695a53517941456b477841746f775049693334565353346b6b4d317a645535503132482f647a654763497630714e69724c6d6a6b2b3079584b3569763274564f6f74666f654e637936704b58684f3970727053686d596447784d506a53724b5143622f41466b656a2b494a362b444373484a78356a6b5a746270686e4759755041514c68734d4c76626e715154786b6b504e6a782f5156564a7965575a5362627978463279657a77737372385348596b38536257462f456b675675743367724c5a445a3744743630784f4358436d776d777968534f47614f396c63646265366647783530794b6c5466335a38573063557177427530692b726c6e423774675365794149737a4b536465524a477643714f2f752b524430797435682f594736454d434251766e314a3673654a7053567370764c47564746617846426162414b426f74516d53705a413073763064732f324351483872327a656c372b563659716e304b325232794854635830384b594d4346347141424f3149377164447072556f6b414f4b7553517651424357384b414e53534f736970316b6f417377675541545541664c554143647259664f6a6544672b6f53772b5a72565047505a39785355633866745830523174445a346c6a6d6a2b2b41792f774131724435723836717059615a704b766967342b59757854676e44752f42304d556c2b52414b472f5457316253584d5572664a767978384e6a497474596b534d3671774b35575657484e41636f5966443569745639524a704a35386e2b664949657a5464493472456f2b572b4869594e497a653678476f6a41356b36583850532b566a5556734e30516e624c4d75517a3738346b4e746759635730776b6468794464704962663273707434556a5a7979646d726e677352624f55617158527261736a45452b644c354765464538654241476e45387a7153547a4a50476f794742473970654b4468344550316548544e4b65526b4f69522b647a632b5661314c72356d4e6a7a7343505a4e75724a695a354a524c4a456b51437359325a476374726b7a4b5163746872356972323263434b5677346e75623573665a63634342497741414c656e51556b354e766333786a5a424e616c4d7a61494d524a526b764741766263554f6a4b6542424239526172516547586b736f683355336c535a59347043524c624c6533644a47673176377846645875323438534f522f5552567664793539426a6b5851316d4d67624533317153514a6a45414e2b7457524a516b71514953394147754261794b6e737441484f49784b524b586b6455516357596851504d6e53684c4f79424c4f7946625a573971596a615a696a636d41775757344944544b355a736f497670487a3447787477706d3353585651553578776e2b653061753056394e61737369306e352f787a2b493555734b676966624f485766364d3071695a374d7161363643774a7459453230424e7a797254686b3438574e6c314b78716d314f57486a5050707951742b314445675957466f3851364e326f4b43492b2f59472f65423775586a6d4e7743426f535257326b716c625a77525365552b665431486444544b327a676a46504b66506b765833434a765a76676b305a45434549306a753562696a6b4b4755573935633932767a796b566f71334758444a38746e376e7a4f4e64576f366a754a764334384e2b576559726246774c7a54724447415477516d366931727357343246682f6a65725738454a50686555755438797575307464656f6c56525069586e2b6552735736386b5779746e7a50505a4f7a5a336b484269787346565164446d41554b52787653646a79386d2b6d6a7778772b5a6c2b796364694d62695832686b7a53732f615278727779526477776738795932594471514453746a584a6a3961654d6d68374a78636338516c69594d68463739504268396b6a6d445330737034474530316c41506175384d6a6b783442653065345474662f435632344b68344f39726e533441424a3046576a487249704b66534941337a32494d4c6859634d53544a4b356c6c4a347346377a4d7836737846764254577455754b57544f78634d63446837484d4632657a3835477330736b6e3949505a7236454a6631724739356d615572776a77324a4172413077516e47644b6b6e43494a70394f4e4741423037584271364269427334424a704939653678743174653474364835563374487641386c32726d4e7555616e75396a6a4c47513376705a57505854527655664d47734c712b43573349364f693148665635664e624d3678616434316b4f41446163566a6172496b46794a56695369554838667a6f41317a46346752527649775968465a7946424c454b435346556354706f4b794b6d4d34656261474d6153654559374a497a794c6b6d6449386d6367424c53425459444c5961393370725863706c6f4b344b4e717a4a6250723635325051307a374e727255626f356b746e317a317a732b572b504d483759776b38595354457049476443386661746d6b734c6539646979487644756d783131463636476b763030755038417034596356354a5a392f4d367569314f6b6e782f30316548465a354a5a35396559656c3268487379566f344645754943726e6e6c466b584f7176614749486756494f5974652b6d6f7043454c65305678327a55594a386c2b664e2f41356b495864714c764c70714d452b532f506d2f67466478392f53306b6959796675734130556a4946572f667a4c6e565175587569312b656c7a65314b617a53317838576e7a4b4b32623572503535434f76306c4d6646706379697470506d732b332b4e6764765973474e6b6b784f4562767871476d5267555a6b57774538576131386f73434f4f69614132444d364f63394c2b6e71492b47666e2b66456130647374442b6e713434726e35395050507035726f4a654c78444c4341477571416949636c7a74636e6a62556b5874612b55633954315a567830734c4c6f627434783664463775703139524347676f7531554e32316c59584a5977755854713335415342484f61776249716a4d54773049346e726d2b4f765131357578754f472b764c31382f6d664f6f3653366356612f376d336e332f774137444873624859724479695844642b7773464c4c4b2b55324c4c624b446c4a47675868707834316d355153785062314f6e57314c775778773131366e57387532707471396e4650694959634f477a484c4739394162416e4d32626a7a79692b7474414b6964456b7378334e663657584e4e4e4454756868495931515179787632646a48714f4e696f5538775875777565657468617735746e466e64466b6b6c67734a752f73724579536e4933617139706f564c726d6b424e3778716253616736726364654e553470785258774e6a4673334270456f5949715a5151694b42614e4f64674e433574715235446d546d336b30775a4637524e754c4c504e4947393144476c7a726f5748442b61357630595535544868694c57537a4931506451435041345a42396d474e5479377755427450356761546e764a7362682b3145324a78644352494f6b787835632b465834537553316e4e74547255466a6d52744b45517843326c4e32654d5a7266644a38737476317272365357496e6e2b3036314a3439426d324e7649495a6c49475a58584b34353933675638526d4f6c4e3277566953366e4d306c7a30386e4a726262493747565a414755334246776643756534754c777a304d4a7163654b504946375151452b583774516a5148537756494542776e6855354a796162575a55676b786b61757362534972734c71685a51784843367265354641434c3758735064634e4a306152503777726638417431324f784a597663664e666448642f342f4c477063664f4c2b71424f2b324753585a657a5a586a52704c51717a6c567a61514f534d3172327a4339723862565473366d4c3162726d7372665a2b686c32585242367831545755754c5a2b6776625a6674426870474e79634f67596e556c6f35706f737a45385352474466725856374d696f5375723870667a6a3648613748676f54767136526c2f4f506f4253374f716c6441784b74592f5931754e4f4f6f5831743072657943316c634a4c6c6e3562706c74565258327670367052666834303336705a54587635454d755073374377374e525a6a3034384f764331764373374e656f616a75734c6878763841445038416a426e64323147486148394c68634354792f4a347a384d62592f676878573159496f3237704a756f564c574243683733767746334f766858413752767274746a3358375972433277634874665555337a6a476a3973556b74734c7a35412f59386a4f433375534d3445435848316c2f73414d515674392b39753961314a712b55656536395257753139642f6146647634746f68664634597356747a494231346474486f5272774e6a56754b70787a57326e35477335515379746e3541766265335469564334654f44445267433861466c5a694f4a4c487533387245383731696f766d336b576c504a31734862324b687549705a493738624e634732677665397834634b6d55552b614b4a7463673167742b636445317a4a326d742b2b4278476f344377486b4b6f3659506f573779514d784f394b4c336b776d46527a377a76455a4775654c4b326651366b337931486465724a377a3052706d376d2b4d574b687a4678326c7a6d46737133314f5662364532736244723531684b6d57636d304c593477574d64697243717046354d47624a7859656371547742492f443836764a5952574c7978684a7249315072634b6c41784a3235706a6248335868516a2b5a586348354666685856304435706e6e2b325976455a49674d496a644a463442686d486754625434302b34634c346b63534e7a73693635476b62446e41517034416a38446234696c74564444544f6c325466784a775a4e4b6e576c54744544785541526d4530414f6d5078695178764c4b32564555737873545941584f6731506b4e54565573676c6e5a4364765a7550394d6b2b6b5179726552567572676c47736f4373724433525944537876783031763064463267394e467763564a506638414f5a303942326f394c427763464b4c65664c2b526354326134793475634d4144796b6b30355841374b6e593972616544346f55346675587a7764474862576c72664643684b5875587a5347546648595968324f5544466d777969525477444f6f4e376a6b446e62532b6c787874584c71315571372b2b53337933386566314f4e54724a31366e2b6f535763742b6d2b632f5553747648446d43444352356e654a334278487568314c4e4a4946514539777562433937446764626c7575563072584e7648487a77636658663841494c597532644d734f577a783637664c6f492b496a4a65596f784245677967456a516d784e7232345871585a4f47584754575058317837445053612f553661464559546b6b34536546797a34307476674438624d474c4c4778796b69396a7070622b3436636645366d394932584a7474632f50362f456230735a52693557377a652b632b6563353838354b574b6a4934574a34334a466838644b584e516a756873645a6353686b6d6945674f5942704261343731795165396131374138756c452b474d4d39665133726a44475739782b323176674d4c4759734d67786b723977484a6545584c4e5a5978724c63737875414162383677576c6d6c787a32587a2f414d476c6b5a516a6e426d57324d484e41776245345a6f444a3367436e5a6a7956514146743933694e4b326a4a506b785a7039537444744944687056694352397033346d67436f574d7a716969355967443171434455643558772b453265714a466c6d41374e526453474a4274494f62645470313530736e4a53533639664c4835794e486a476568513242765039496a4562674a4b6f476739316c417464667a4837467051787557553868445a386e5a7a52742f4541663675372b4a46513930536e686a6e6a4d596b53463548564548466d49412f7743664373556d3368444f6343766a5061424672324d556b6e51745a45507875332b4e4e5130566b74337343793173686458627630764859525a3478476a4d596d4b73547049526c4f71697855692f6a65743431756c695771713434345959784f797947614753364f707364547848687a48507972715269706f38644f79644539317935684c5a736b69355935427144645748413246726a70574e6d633459337075486834346636486e5a38786b514538526f615473687773376d6e7537795071695630716777635a545142663841614268424a732f4558763841566f5a52623730597a6934356934346667624774644e5936376f7958526d2b6b746456384a726f77647576745756506f474658437947475443704930392b366a4643325536573432467267393857466856625045355362337a794b322b4b557074724c664c323966594e4741326773706c437249765a4f597958526c4249414e304a39356465493665565a474a6e4f2f2b2b697a59624659654b4b364f6a7869557459452b36537132314677646236303148545068346d7a6c7a3754677275375339724d6f6b6c6b7a5a637a5a75414250586b4c2b6e436d573864547077306d67314e6646434b3333323266762f79557470594f63695149437943776b4b6a6a63755641424e794341645044576c39516e7778396e335a7650544b71757463326b31362f7562426778515561556f596b7577746c54342f45434742537a45456b386c55635353644230462b5a4651326b737374474c6b61627531374870544a6e6e5059494f414c4c4a4b52626c595a463839664b6f2f716f515868575835766b62786359636c7550662f793168634a597771336166654a444d664d734f48674c436c4c4c3532504d6d614a796c76497551377578544b367a7232717637795063703175712f5a50694f484b73314a39434a34774a573866734b67636c73484d304a2f38414c6b426450494e664d6f3838314d5276665556775a586a74776362484930616f6b70567045764734796b787172506c7a3553514d325868377759635161596a4c4b79515563416a51393461456935626f4472594770494c4c3477346d54504b543055636c586f50784e4145324f7779714d774e73756f494e6944344563364147545a30727468424b374b37577a41722f4141324944634f2b434c4773582b37427430416d4f32772b4b66745a6d302b776c2b346738427a50566a71666c585230394d494c50556172532f64494b594c59574c6c476150437a46655446436f38775774656d6e49336369766964324d6648496b6777306c34335278716e465744636d384b7774716c4a62495874706e4a6249326e65375a73574d7776303244566c545077494c4975724b774e6972725a7444596767672b47564672672b46386a7a2f6147695673584a62535835754945473231494135715234635434384b637363576354547773673859323348544237565349737a58796d33446c6532767a706136475564505258384d747869564151434e5151434479745368325538376e7578384b4351356a4d4d7373627876717271794e354d4344386a55454833435963526f6b612b3669716f7678736f734c2b676f4158393874365677693541724e4b36735574624b76494d35766343392b4833545731564c6d7339454a367257516f61692b623547516262784562646c457073716f4c2b664438683836365477306b655971556b33504258326e67477732466c78456b525658517852646f43433873696b4b30596255464265544f50754458576c4e525a464c45655a32657a714c6550764a724336464864446177744c3277377a5a526667446c586c666e725671395448486a38763550563161714f5047756e38677a65585a4b54346938476e614d6f436a55616b4b4f484d364539546571533036654d63796b744d7059787a4e31396e57366b4f4267797869374e37376e336d493075656776657736573854585031736b703933486b76715264474e6667694e574b6e436730697a47456373566c6d7a79456d6a6b68675938493441714d6d633435426d2b5738677765456b6c304c364c47447a6b627571506a716641477277584538475468685a4d74324e7459414d713364796f5158304757356674693275566d6c5a356232766472574946506d4972375669583651786d56636f646d6456766b4f554632796a6f32587a37334c68514146337032492b7a35776c7930624b47526a784f6775703851645067656456726e7849764f504338454748527052633842774835303554566e633370717a75583842694877784a414c52743736664c4d765276782b46693754355755586e566a64476f657a48642f434a42464f755761516758647463703571716e33534f485835557a434b5546675a72676c576e45306d6646497133643155572b3077483431686835463850497659336247484a734a346a35534c2b744e313763783270706332454e7a6f524a6838544564597a4e4b746839325246642f69386a6e317048556257746f356574676e5a4a655a6e6d4d3358614f526f5a445a314e304e7447484a6c504d4870794e5052344c5935582b6a78563072744c6277762f444b794d3679434b51577a45414872714e5257625434734d59556f75446c482f526f6d3655684d62526b334b48542b5530747149634c544f7032626537494e506f48757a7063365156714149635a696b6951764977524634735459446c2b4f6c536b323849724f63594c696b384978666558626f786e61796b57765a49787a4343544b4366456935506961366c4d4f47724235545758643771754e6373626537636e33563359474a63434e4d735950316b6e45322b364439342f4b397a563772595652325735545236612f567a3862664375665265776f653337747a69734b724952685653306263564d724876416e6b3256567344346b63363435374262434a6a47485a574849554147505a4e436a535475777530655570636d7775487659634c334131726f364c48444a76706a376e5537507877546b2b61786a33354e3577553456416f504141664453764f325463707554366d556c78504c4b6d3173583361716c6c6879463341347676487a7257534b706a5068735670574c4c6d4b6530666573597a466845623669416c56492b314964486b38674f3644356e6e54744e664373766d4b577a79384946533758564d685157493049484d667257786b556e78707847496a30393530467564697967332f70422b46512b524b356d6a627837476a7875564a43526c4a494b327663715230345873626677696c6f536365517a4a63526d6b554c51537644494c4d725750354565424669504f75787037453062557978737767306478546a575270724a3877754e784746446e444f56442b386f414f7656626a512b497243555a52336759796a4b4758416f7069524b63306a5a33504575637a664531454a52664d69456f766d5234794e4c61415554556345574b4f4439412b78575254736a44685141564d71746237776c62552b4a466a5850664d357a356b767454774a62444a4f6c77384c6a55666366756b48714d32512b6c623661545538484e3753716a4b6e4c58497a484634365574455a426f47466e485077384454303238724b4f48544750444c6866546b6144755469524a4d78484e472f314a2b7459617239714875796371636c3644746c70413735636f4151642f4e765253455952446d594f544b6247793546754676774a75527776624b65644f3653703858457a683972367150644f714c337973694868746c786c7057596b674d514635446838546330386f724c624f464b3257497869743865396d75626c37494f4777775672356e4f646c354b53414d6f39414c2b4e3635656f735535355849395a326670355555714d756233666f5265304b425a4d424b6a4b47447445704236475a41535045416b672b465978575867626e4c686a6b794c6148733444334d4d37494f4f56774846694e4c473459632b4a4e5a575763457347744d484f4f587a412b77396d6e5a2b496e6a4c68325a514c674544686d356e782b5664485337314f586e39736e516f687751652f503766374e61776d5042554d4f42414939613455344e50444b4648612b4d4c444b4f4a494146576973464a4d464f476a4966374a342b423861767a4b6374774837514e384442682b786a4e707051526363565467573843654139616d75764c79525a5a6859526b63633968616d52596b6a78564142666446732b4d6950454b57632b696b44356b6647717a35466f637a614e6b34596b5a6d3530724a6a55554b6e745432554d71596c42336b73736e696e492b682b524e4d61577a447745746e6b55746e346d344664757565554f565479676c3264785732446241443278737669366978356a72342b644b33552f33495576702f75515069556b61584e594a4e6f77536252742f2f774150574f42772b4b6776336b6d456c76345a4541302f716a62396d6c35726357735747616e69384d73694e4734757241715234455771716254796a4b55564b4c692b544d56474c52576c676c475a456430425047797356342b6c646545754b4f57654e767164646a5548792b4a57325a6970494d51666f7a6b5731584e33744c6a756b486970724f56616b38444e576f6c576c506b7a53734e767a6853696c32797556475a6675746256622b4230726e7575535a364747706734706a58504d714b57596741416b6b3942725645736a4d704b4b797a4238664b374b4a4648316b37736656387a48303431324d634d456b654d636c5a644f552b584d62765a6e73746a4b7a534258574d587a4547776c4a7543757469625a7550445468532b726b34775563387a6f396b31713236566e44737558744e4f726e486f78653377635a59554a3479587431436f3344794a42394b7a746b3148593072697050646241646f4d73647a6f54386830704e79636d4e52696f6f786a652f456e36584b5165386a4c366a7331483547753152346138464b4c584b4c396f783772377a7869444c4936726c39334d5143516541462b4a76706279704c55312b50695855744b57432f46764c41724c4a4c696b6a3075466a547448394c36452b6c4c634d6e736b5a75665567326e7672676f313067787334367649495650394b5a54627a46614b746d6273395253396f634d4f4968774f4d676a45586243524855466d415a43434e535362355438717457384e6f724c7a45364843576464417750496872656f477072556f633436433075584c6c424930462f5731786355644352763345677773654c764e4b734b396e2f346873436267324249384f645a5763574e69384f484f356f3237572b6b474b646f6b584951437936334c41577663454333472b6c2b423956355674626a454c464c597034755663666952676f7a63794e6c636a67714158633350477967324857316131784d374a4764625a32552b41787332466535794e334750326b4f714e36715265334f34355630364c4f6865697a6f4563464c63563059504a306f504a64794138617667766742597643354a4e4f4463504f6c5a51345a62436b34634d74756f3465786647646c74584a657778454472622b4e434a42384644306e7149377069656f6a68706e36417063574d763375324f4d4e696d6b3037504546694f67666979734f6875534435394b364f6d73346f385056486d7531644d3635393475542b5441574167524d51636f4137674a415064766d35644b61696c6b354e733563435442552b4f544d317a7a503430724c6d644f4558776f656661724f7a7648443968557a6b6678456c526679412f794e526f3631777552743278714772593172326950486a5433417133794c7a34426950307638616258526552795a7853636d337a5a7332355958364641794c6c7a4b47594869575076456e6e636a3457726b33796370764a363351317768524651574547367947784a33796e7669344266534b4d7434586b64523851497a2f6455533458584a50792b35304e44464f4d2f59646265583676777a4c6679754b51702f656a4f37506476486b5966766b482b6d544246584d55526d4a476f30317362364468384b364d6d3974784771574530764d57344e6e2f564679652b43656873655774566279584c324a77794756484a624b795841573274324a74666c6f77716b4f52615263336c77596a58437443417253493563544f4773556577596473624c6345664372465553597564327763596b645a4a456e3935577a706b5a43416d596478534362324853395a72392f754c50396f4f4c48504833686f77395058394b314b487a626a673468534370462b4a73655136692f77414b414f4e7671476c6a41313433743655415162616937497873685a47734c473576773548694b4147503261346b776256775458766e6b374e754f76614b5576727a7551623041615a37643931444c436d4f6948666747575733457733766d38636a472f6b7a644b7646345a614c777a494e6e3476685852726d644b7177507879584678546159346d523436504d423142754b704e5a52536179694c646646474848594b543775496a552f7741736a646d332b4c6d6b6231344244554c7765772f55464a4349736530665a33625947547533614d724b747549796e764566304671316f654a6f553130484b6d574f6650384150635a4a68646e794657614e733344516e583438534b366d484864486c65386a4e70533277425732524f53627063387a6d582f757066676b64447634655a6f6d396d30556e6d6e654d677176637544634849426367394c337266547246535874452b305a4b577262584c62374172596578784b384f476a5941734357626f6f393654784a34447849355645374656586e714646457456714d506c312f67326a4359645930574e425a55554b6f36414377487746636c764c7965776a4652574553314249696a436a45504c4b543738784b333147524232533238437135764e6a53566c6e366d635a776444545075316b7437586b41425675423458345734574e5a52576430567975544d5533774f54616a4c79654f502f53527166536e6f53636c6c696b344b44784542776c5561614d6b63694e644c2f7256796839625a6b73324553574248597779744532533977724b474767317462384b7a7a69547958356f7251524d464b694651782b3077756638626d3957346b527773596467626d346d6549776f4343373538374b776a577742755436573636316c4b784a354c71446177456366374b73536b625347614a69677a5a4544735774715143334f3368554c554a7647433363504256786e73346c6c527354424b43696934527839597756526d5a4d7132497a5a736f35676364617433367a686c6536654d6f4137593359784b396e4d69504b6852535743415a574b67736c6753546c754e6257346a6b61757245797267775674754b59474e704649566833626c54636344664c7734633673704a6c576d68683346596e61754142412f77437570345734412b4653694439545378686c4b734156494949504167364545644b6b4438736237377574733348535157505a4876774d65635234432f565464546670666d4b33726d4d565449396d347a6b654650317a48367241724d644b326b6279354337694d55524e486c3469534d2b6f63477566664c62427a74524c5a6f2f58564a6952386267623041666e6b3436534e6d6b6958367373784358377971535341447a734e4f4664654c6c47506d654f736a565a4e2f3274387649756a625448584a783871766b793776473253764e6d51434e654d7477504d6744583079314d6e6a627a4b77584634332f622b665562765a3573346a47676a584c4778592b4241565166794868533272784743523075782b4b64376c30534e55726d6e70696a747a466d4b4356783777553566357a335648397846524a34575359724c77414e6a785a624b4f4367416567412f4f75664a625a485539326950654662786b3878722b6f395265697158444a4d69794846426f7758326d4f56786e6a3255646a7a746d66392b6c6444675565516972484e5a5a62324475654d514d504a4a4b33316e614230554254486b31414e2b4f59465465334f334b737057595a724776694e4c324e735743454242486c5567413557634b335450593934362f6176786f34345432366d6371374b336e4f554847776355626f306361494341624b7167583448674b556259374847413945317856437842694255456761563870734e4c634b305734413262552b4134416141655171364b34424f4d324e4530624c6b58686f62416b61615a536546755671736d5563566746657a375945736d31343259576a77714e4b7835466e44527142356d35386c5055557857746865664d33697443676e2b303763776253777556624c6949727443783632316a59386c6177386946504b31536e676c50422b62354935494a47696c526b64445a6b595759487936655041307a584d617273444f4578643174656e6f7a79682b45386f353246732f74746f344f4d4452735248662b56577a742f6970705055694f7050315453596d656f41784c6531596f63564b495132514d6377734c4b33326774754b332b486c58576f6c4a51546b655331315662766c477638666f4276704d6654386131346f6966643265595578307170324c6b584373332b53482f7448786f6e4c4747577072636c4b4b3876754f76737778684978416451484c7135596664497968504a63756e38787044567035556d643773655556475661584c66506e6e2f414550744a6e5a414f2b4c4873593141766d6d516632336b31395546566c427a574548654b76646c625a536166765533755438615476615434563047614d7550452b70563238326c723234335067504f6a54317163747731467268484b4d31784737723433614372486c4237434d45734e414d386c7a3432484c532f43394f7a33774a315044667443784a45684f55686833546177734c2b37346e543556614e4d6548645a4d4c4e56506a796e6842335a736d6462455855382b482f414435696b725978692f437a705554736d764567744b763153387968342b662b2f77434e5935797a644c434347436b75425657537a764644536f4241544870726572784148734b7551636c616b4358632b627373666c4f676e6a5a5036347a6e5566326d54345676552b6774616a5236334d5431414150656664504334394d754a6944456537494e4a562f6b63616a7934486d44526b4538474d62312b797a46344d6d54433573564430556658715046422f31504e6466437434584e637a6546376a7a4c48736832444e4c744a5a35495a4934384d6a6b6c305a62794f706a56624d4153624d3530345748555558576366494c7265506b6233574267656f417a44326b34474b4b555368686d6b3165505334355a376367626645483036576b73664468386b6561375830305659707765373572372b2f36695a3946694f76372f414170766767636a76726c7354775a704a496f6e484133506f4c67696c6e4a76435a306f3178697054695032343830596b6c462b3862616677692f7a317066565a654470646c7052627a7a66322f32504d546161556d64674562344b666f785963555a47394d77556e2b316a566f38796c69796972737076716c504b3379362f4375584e596b7a6f7779346f47625a784161504d4f68493633484b723138554a656f585672446a4d722b7a3744353856504e79434242354672584872453339315079655a76304f645573567231334b2b2b4f796a4869537969797939344e305032783533312f72384b733756474871592f77424f35322b6e4d34775536705945674467505375644a4e6e5854555546343541794e59676769732b7059397336657746544a414757314655414534794f395754414579437443446d67415a74536378355a55392b4a316b412f6c4f6f38694c6a31725344777a4f785a527175437853797870496875727147552b4246366246436567443141487141505541656f41395141682b30725a7966567a356c4274325a556e5569397756484f784a76356a70542b6873336358794f423235526d4b7454335732504d7a30374a6a2b37387a5851376d4a353961797a7a444d2b474e67792b2b6e7a484d55704a3557556469455846384c354d4962743357574e2f7648583146767a72476538486b6470384e3055765042704f7a5a4c72616b5474486530734a32734d6b52307a6f7958365a6752663530414b4f4232686d777a33306451364f76335855465758346a384b35733474537764437470345943676c4d716d495a6d646951717237787659332f684150466a6f4b637371646471363954545851533262356f304c642f5a5177304b6f4c5a754c45634c32745966776741416541363372534b776378766f7552383368326432304a41486658764a35676350555848773655546a78496d4573504a6d6765306836324672395038416d39547038634c387866573534316e6b4673465064682f466457483851467766682b5659616950397778704a2f77427676525a676249396a36557339304f6f594d49397856435752596d476f41433475477872524d4374617241553864677734715538465a52795437736278484172324d797338467956646457532b7042586d74376e54555850486b78436651576e4130505a2b506a6d5150453675703571622b683648774e6247525a6f4139514236674431414871414558326d37507a434b625777764733515831552b476f493952542b686b73754c4f443235552b474e7136624d793434616361435272446835553377324c6b7a6b4b7a547664785752363270455249535074432f38417638623068427668505336694d5659386c5344465a514f544b667a46573572426e77384c343130487664666136794942775947783862334962773457706579747848614c6c596e356f59525752754239716275787a4d587a50473541444e47514d7747677a71774b6b32353276774637615653554979356c6f7a6365524c734c594d47455170416c723673784a5a325056334f7038427748414143723566554a7a6c4e356b38684f6771656f417a586238437269706f796f73437271434f547265342f717a6a30706178596b4d51784b4f4764594f495a726a5454683436362f41316c4b54786730566134754c30434f5077355a4d79693558583035316e46376c326532566a37322b64456f676e6b4f6e5556516b483479473471557951533656664a424d4d41534c696a694170597241486d4b7370454e416a36484a452b6644794e452f566542384755364d504f74597a614d7051794d3277743979434938616f5275416c5564772f7a44374a2b586c573062457a43554768326a6b44414653434477493142386a576851366f4139514236674262332f414d573865464956564964676a5846374b516538504734466a544f6b6970574935766131736f615a34576337503247575a2f4f757878486a2b4479593734714d4f4c6378774e63574d7545392f6255724541646f6f4143446f522f794c56736d6e754a5367344a706b4f413234304c71305a483851366a7057736f786d7348506a625a51334a476f377637525765494f766b52304e4a573175755747646653366d4e384f4a65384a316b4d6e7141505541656f417a6a326a345a526934574976326b4c71662f31794b523566395a71736b6d68572b546a4a4e4d6f6248784a445a474e77526453654f6e465431506a536c39584139755139704e523369772b6148445a34754b555934426473594d77536878376a2f4938785773586c47656477357333455a6c465a4e4632575a6f7231414a67584678574e57524a5a32504e726c4e444966494b5434494d4b43696e35675847374e384b6c5042666d42736267644c4d4c69727152445142327874366641596431686c49456e645548557154785a4c384c44385254656e7a4b57445075316b42703761385a4432434d6b6375532f6246685a70464e736f7575694d4266577842754e4f4e3935704a37474e69536c73626475747648426a384f732b4861366e526c4f6a6f3174556b484a6866794f68467751616f5a686567436a747643704c42496b68436f564e324e724c62554e72304942394b76584a786b6e486d59366d75466c556f7a35592f4759314a4c6c4a5569354249754e5162615842356975387245316b38464f69555a4e5a4845745844506f70547832487a692f4532746172776c6778757134304c4f304d4d6731304248373170754c6a6a4a784c7135786c773948304c4f786435704d4d4c784d7665746d5674516462634c334246617a6a43364b7963366d3233523253344f7650794e55336432346d4b6944726f7730644f595036486b613531314c726c6a6f65693065736a715963533539562b644176574138656f4139514167653143496d5443454731684f4c2b665a6670566c79464e53384f4c396f7334454f4d684f554665484f2b6c764377316f6c55357853657857712b4e55334b4f2b523032486938777364434f492f4d486d4b356c6b48435747646d71324e6b637843753163434a34486a766c4a4864626a6c59617131756576456378656f6938504a523554466e64764675426b6c584b366b71343542676261486d4479504d57713031315272463551317162697367422b50693071555742734c5a5742713351426c7738317856557a4b55535756417731715369625148326a6842596e6c516a5a504a6a6d317436634f7a7a4d3179693345656c315a5230385762727974586230385656447863793346474b625a6e53344976646d347472626f4b77627938694465586b503769623253374b78496b5737524e5a5a6f2f764a666c2f4574795166456a676167672f5557786472525971464a34484478754c715238775279494f684849696743727666683266427a4b76484c6d7431436b4d52366745567470354b4e69624539664355394e4f4d656544497848586237744869652f6b4e3936345a39455043704170375432514a41485141747759637a7a4676537231324b4f7a464e5451374e3438784e786b434c6d496a3131307472663436552b6e46725a486d5a3132516d2b4f57506566634a744e6c794f47654f52546f51534434366a69434f58674b753347555570497767724b6247366e37305075784e2f4447456a78436c2b4e7041526d50416745637a612b74396265644b323650786546347964505364737456347457577562366a396773576b714b3862426c6267522b66512b464953693476444f2f56624332436e4235544a3671614350375555594a687041435173705272616b4b38624739764e46487252785957544336707a78675659546578584d772b304c477736455848487771333952424e626d4d644a5934767768545a6d4b73796d2b6e432f67663937566e71594b634f4a47756a73634c4f475855623470394b3568324d4654465141746d74727a716367584d4d2b6c51444f63574e4b4151476c477458524955774d32677170445751724762314a6a4a59457a326a375159524844516e363256546d5033592b424a50497365365036756c4f614f6a6a6e7864463954534362507a374c466e6d3750374b47372b5935664854343035624c664176624c66415845656c596d494f326a68644c31494444374839367063486a346f4d78374445534c47364735584d336452312b3632624b43655934384259412f527538547575466d614d6c575643515278467454623076576c4b546d6b2f4d57316b70526f6e4b4c77306d59746c62714b376d476548384433774f4b4853754b66524473554546375a71416e58722b524e56594d436237344e4931696b52514765537a4858555a53654230766363654e4e36536234734843375971676f636157346f37584f5644625457316443375a62486e644b754b537966416671516559436e31754b6a2b7a34426a467a58744e48396d4d3745544a66756a4b77486962676e354434556a723076432f61647a7347637648486f7366505038443358505051674866644163484c66374f5268344d73696b48343157584974486d4c474734556b7830473468414a514c6148552b4a31312b564e616435324f6472556b38726e2f414a446d797044634c6332747772445578555a62472b6a6e4b554e3245324e4c6a684e68654e5151666358776f414654316441574d49644b717744454a30464253526b3238324e66744e704e6d37794c4b564f6c786b424332386750336575397076445274355a4e597645486a794d7632436f794d655a62552b5148366e3430717a6e4d4b6f4e6167676d32334f567a4975554b514c3256626e7a61312f6e55674c3237422f3841714f442f41507959502f367251422b77355542556769344949493844517469476b31686d46426a586f736e7a78387a2f32513d3d, 0, 10080005);
1637
1638--
1639-- Triggers `guilds`
1640--
1641DROP TRIGGER IF EXISTS `oncreate_guilds`;
1642DELIMITER //
1643CREATE TRIGGER `oncreate_guilds` AFTER INSERT ON `guilds`
1644 FOR EACH ROW BEGIN
1645	INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Leader', 3, NEW.`id`);
1646	INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Vice-Leader', 2, NEW.`id`);
1647	INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Member', 1, NEW.`id`);
1648END
1649//
1650DELIMITER ;
1651DROP TRIGGER IF EXISTS `ondelete_guilds`;
1652DELIMITER //
1653CREATE TRIGGER `ondelete_guilds` BEFORE DELETE ON `guilds`
1654 FOR EACH ROW BEGIN
1655	UPDATE `players` SET `guildnick` = '', `rank_id` = 0 WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = OLD.`id`);
1656END
1657//
1658DELIMITER ;
1659
1660-- --------------------------------------------------------
1661
1662--
1663-- Table structure for table `guild_invites`
1664--
1665-- Creation: Jul 23, 2014 at 12:49 PM
1666--
1667
1668DROP TABLE IF EXISTS `guild_invites`;
1669CREATE TABLE IF NOT EXISTS `guild_invites` (
1670  `player_id` int(11) NOT NULL DEFAULT '0',
1671  `guild_id` int(11) NOT NULL DEFAULT '0',
1672  UNIQUE KEY `player_id` (`player_id`,`guild_id`),
1673  KEY `guild_id` (`guild_id`)
1674) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1675
1676--
1677-- RELATIONS FOR TABLE `guild_invites`:
1678--   `player_id`
1679--       `players` -> `id`
1680--   `guild_id`
1681--       `guilds` -> `id`
1682--
1683
1684--
1685-- Dumping data for table `guild_invites`
1686--
1687
1688INSERT INTO `guild_invites` (`player_id`, `guild_id`) VALUES
1689(175, 7);
1690
1691-- --------------------------------------------------------
1692
1693--
1694-- Table structure for table `guild_ranks`
1695--
1696-- Creation: Jul 23, 2014 at 12:49 PM
1697--
1698
1699DROP TABLE IF EXISTS `guild_ranks`;
1700CREATE TABLE IF NOT EXISTS `guild_ranks` (
1701  `id` int(11) NOT NULL AUTO_INCREMENT,
1702  `guild_id` int(11) NOT NULL,
1703  `name` varchar(255) NOT NULL,
1704  `level` int(11) NOT NULL COMMENT '1 - leader, 2 - vice leader, 3 - member',
1705  PRIMARY KEY (`id`),
1706  KEY `guild_id` (`guild_id`)
1707) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;
1708
1709--
1710-- RELATIONS FOR TABLE `guild_ranks`:
1711--   `guild_id`
1712--       `guilds` -> `id`
1713--
1714
1715--
1716-- Dumping data for table `guild_ranks`
1717--
1718
1719INSERT INTO `guild_ranks` (`id`, `guild_id`, `name`, `level`) VALUES
1720(7, 3, 'Leader', 3),
1721(8, 3, 'Vice-Leader', 2),
1722(9, 3, 'Member', 1),
1723(10, 4, 'Deku Scrub', 3),
1724(12, 4, 'Scrub Nugget', 1),
1725(13, 4, 'Bear Scrub', 2),
1726(17, 6, 'Leader', 3),
1727(18, 6, 'Vice-Leader', 2),
1728(19, 6, 'Member', 1),
1729(20, 7, 'Leader', 3),
1730(21, 7, 'Vice-Leader', 2),
1731(22, 7, 'Member', 1),
1732(23, 8, 'Leader', 3),
1733(24, 8, 'Vice-Leader', 2),
1734(25, 8, 'Member', 1),
1735(26, 9, 'Leader', 3),
1736(27, 9, 'Vice-Leader', 2),
1737(28, 9, 'Member', 1);
1738
1739-- --------------------------------------------------------
1740
1741--
1742-- Table structure for table `houses`
1743--
1744-- Creation: Jul 23, 2014 at 12:49 PM
1745--
1746
1747DROP TABLE IF EXISTS `houses`;
1748CREATE TABLE IF NOT EXISTS `houses` (
1749  `id` int(10) unsigned NOT NULL,
1750  `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
1751  `owner` int(11) NOT NULL,
1752  `paid` int(10) unsigned NOT NULL DEFAULT '0',
1753  `warnings` int(11) NOT NULL DEFAULT '0',
1754  `lastwarning` int(10) unsigned NOT NULL DEFAULT '0',
1755  `name` varchar(255) NOT NULL,
1756  `town` int(10) unsigned NOT NULL DEFAULT '0',
1757  `size` int(10) unsigned NOT NULL DEFAULT '0',
1758  `price` int(10) unsigned NOT NULL DEFAULT '0',
1759  `rent` int(10) unsigned NOT NULL DEFAULT '0',
1760  `doors` int(10) unsigned NOT NULL DEFAULT '0',
1761  `beds` int(10) unsigned NOT NULL DEFAULT '0',
1762  `tiles` int(10) unsigned NOT NULL DEFAULT '0',
1763  `guild` tinyint(1) unsigned NOT NULL DEFAULT '0',
1764  `clear` tinyint(1) unsigned NOT NULL DEFAULT '0',
1765  UNIQUE KEY `id` (`id`,`world_id`)
1766) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1767
1768--
1769-- Dumping data for table `houses`
1770--
1771
1772INSERT INTO `houses` (`id`, `world_id`, `owner`, `paid`, `warnings`, `lastwarning`, `name`, `town`, `size`, `price`, `rent`, `doors`, `beds`, `tiles`, `guild`, `clear`) VALUES
1773(186, 0, 0, 0, 0, 0, 'Depot Castle!', 1, 195, 1760000, 15000, 6, 4, 352, 0, 0),
1774(210, 0, 0, 0, 0, 0, 'Donater House', 1, 307, 2675000, 12000, 14, 0, 535, 0, 0),
1775(214, 0, 0, 0, 0, 0, 'Arena House 1', 1, 26, 195000, 5000, 3, 5, 39, 0, 0),
1776(372, 0, 0, 0, 0, 0, 'Donater House 1.', 1, 154, 1355000, 13000, 5, 0, 271, 0, 0),
1777(373, 0, 0, 0, 0, 0, 'Forest House 1', 1, 19, 120000, 8000, 2, 2, 24, 0, 0),
1778(374, 0, 0, 0, 0, 0, 'Forest House 2', 1, 21, 130000, 8000, 2, 1, 26, 0, 0),
1779(375, 0, 0, 0, 0, 0, 'Forest House 3', 1, 18, 115000, 8000, 2, 2, 23, 0, 0),
1780(376, 0, 0, 0, 0, 0, 'Main Forest House', 1, 42, 290000, 14000, 2, 0, 58, 0, 0),
1781(377, 0, 0, 0, 0, 0, 'Forest House 4', 1, 15, 160000, 8000, 2, 2, 32, 0, 0),
1782(378, 0, 0, 0, 0, 0, 'Forest House 5', 1, 20, 130000, 8000, 1, 0, 26, 0, 0),
1783(379, 0, 0, 0, 0, 0, 'Cellar House', 1, 19, 140000, 2500, 1, 8, 28, 0, 0),
1784(391, 0, 0, 0, 0, 0, 'Castle City 1', 1, 15, 95000, 2000, 1, 2, 19, 0, 0),
1785(392, 0, 0, 0, 0, 0, 'Castle City 2', 1, 15, 95000, 2000, 1, 2, 19, 0, 0),
1786(393, 0, 0, 0, 0, 0, 'Castle City 3', 1, 23, 130000, 2400, 1, 2, 26, 0, 0),
1787(394, 0, 0, 0, 0, 0, 'Castle City 4', 1, 23, 130000, 2000, 1, 2, 26, 0, 0),
1788(395, 0, 0, 0, 0, 0, 'Castle City 5', 1, 23, 130000, 2000, 1, 2, 26, 0, 0),
1789(396, 0, 0, 0, 0, 0, 'Castle Flat 1', 1, 6, 45000, 1000, 1, 2, 9, 0, 0),
1790(397, 0, 0, 0, 0, 0, 'Castle Flat 2', 1, 10, 65000, 1000, 1, 2, 13, 0, 0),
1791(398, 0, 0, 0, 0, 0, 'Castle Flat 3', 1, 4, 35000, 1000, 1, 2, 7, 0, 0),
1792(399, 0, 0, 0, 0, 0, 'Castle Flat 4', 1, 6, 45000, 1000, 1, 2, 9, 0, 0),
1793(400, 0, 0, 0, 0, 0, 'Castle Flat 5', 1, 6, 45000, 1000, 1, 2, 9, 0, 0),
1794(401, 0, 0, 0, 0, 0, 'Castle Flat 6', 1, 6, 45000, 1000, 1, 2, 9, 0, 0),
1795(402, 0, 0, 0, 0, 0, 'Castle Flat 7', 1, 6, 45000, 1000, 1, 2, 9, 0, 0),
1796(403, 0, 0, 0, 0, 0, 'Castle Flat 8', 1, 8, 65000, 1000, 1, 4, 13, 0, 0),
1797(404, 0, 0, 0, 0, 0, 'Castle Flat 9', 1, 8, 65000, 1000, 1, 4, 13, 0, 0),
1798(405, 0, 0, 0, 0, 0, 'Castle Flat 11', 1, 10, 65000, 1000, 1, 2, 13, 0, 0),
1799(406, 0, 0, 0, 0, 0, 'Castle Flat 12', 1, 10, 65000, 1000, 1, 2, 13, 0, 0),
1800(407, 0, 0, 0, 0, 0, 'Castle Flat 13', 1, 6, 45000, 1000, 1, 2, 9, 0, 0),
1801(408, 0, 0, 0, 0, 0, 'Castle Flat 14', 1, 6, 45000, 1000, 1, 2, 9, 0, 0),
1802(409, 0, 0, 0, 0, 0, 'Castle Flat 15', 1, 6, 45000, 1000, 1, 2, 9, 0, 0),
1803(410, 0, 0, 0, 0, 0, 'Castle Flat 16', 1, 6, 45000, 1000, 1, 2, 9, 0, 0),
1804(411, 0, 0, 0, 0, 0, 'Castle Flat 17', 1, 10, 65000, 1000, 1, 2, 13, 0, 0),
1805(412, 0, 0, 0, 0, 0, 'Castle Flat 18', 1, 10, 65000, 1000, 1, 2, 13, 0, 0),
1806(413, 0, 0, 0, 0, 0, 'Castle Flat 19', 1, 10, 65000, 1000, 1, 2, 13, 0, 0),
1807(414, 0, 0, 0, 0, 0, 'Castle Flat 20', 1, 10, 65000, 1000, 1, 2, 13, 0, 0),
1808(415, 0, 0, 0, 0, 0, 'Castle Flat 21', 1, 13, 80000, 1000, 1, 2, 16, 0, 0),
1809(416, 0, 0, 0, 0, 0, 'Castle Flat 22', 1, 10, 65000, 1000, 1, 2, 13, 0, 0),
1810(417, 0, 0, 0, 0, 0, 'Castle Flat 23', 1, 7, 50000, 1000, 1, 2, 10, 0, 0),
1811(418, 0, 0, 0, 0, 0, 'Castle Flat 24', 1, 7, 50000, 1000, 1, 2, 10, 0, 0),
1812(419, 0, 0, 0, 0, 0, 'Castle Flat 25', 1, 16, 110000, 1000, 2, 4, 22, 0, 0),
1813(420, 0, 0, 0, 0, 0, 'Castle Flat 26', 1, 14, 85000, 1000, 1, 2, 17, 0, 0),
1814(421, 0, 0, 0, 0, 0, 'Castle Flat 27', 1, 14, 85000, 1000, 1, 2, 17, 0, 0),
1815(422, 0, 0, 0, 0, 0, 'Castle Flat 28', 1, 14, 85000, 1000, 1, 2, 17, 0, 0),
1816(423, 0, 0, 0, 0, 0, 'Castle Flat 29', 1, 18, 105000, 1000, 1, 2, 21, 0, 0),
1817(424, 0, 0, 0, 0, 0, 'Castle Flat 30', 1, 18, 105000, 1000, 1, 2, 21, 0, 0),
1818(425, 0, 0, 0, 0, 0, 'Castle Flat 31', 1, 18, 105000, 1000, 1, 2, 21, 0, 0),
1819(426, 0, 0, 0, 0, 0, 'Castle Flat 32', 1, 14, 85000, 1000, 1, 2, 17, 0, 0),
1820(427, 0, 0, 0, 0, 0, 'Castle Flat 33', 1, 14, 85000, 1000, 1, 2, 17, 0, 0),
1821(428, 0, 0, 0, 0, 0, 'Castle Flat 34', 1, 14, 85000, 1000, 1, 2, 17, 0, 0),
1822(429, 0, 0, 0, 0, 0, 'Castle Flat 35', 1, 18, 105000, 1000, 1, 2, 21, 0, 0),
1823(430, 0, 0, 0, 0, 0, 'Castle Flat 36', 1, 18, 105000, 1000, 1, 2, 21, 0, 0),
1824(431, 0, 0, 0, 0, 0, 'Castle Flat 37', 1, 18, 105000, 1000, 1, 2, 21, 0, 0),
1825(432, 0, 0, 0, 0, 0, 'Castle City 6', 1, 18, 105000, 1000, 1, 2, 21, 0, 0),
1826(433, 0, 0, 0, 0, 0, 'Castle City 7', 1, 18, 105000, 2000, 1, 2, 21, 0, 0),
1827(434, 0, 0, 0, 0, 0, 'Castle Flat 38', 1, 6, 45000, 500, 1, 2, 9, 0, 0),
1828(435, 0, 0, 0, 0, 0, 'Castle Flat 39', 1, 6, 45000, 500, 1, 2, 9, 0, 0),
1829(436, 0, 0, 0, 0, 0, 'Castle City 8', 1, 26, 145000, 2000, 1, 2, 29, 0, 0),
1830(437, 0, 0, 0, 0, 0, 'Castle City 9', 1, 26, 145000, 2000, 1, 2, 29, 0, 0),
1831(438, 0, 0, 0, 0, 0, 'Castle City 10', 1, 23, 130000, 2000, 1, 2, 26, 0, 0),
1832(439, 0, 0, 0, 0, 0, 'Castle City 11', 1, 23, 130000, 2000, 1, 2, 26, 0, 0),
1833(440, 0, 0, 0, 0, 0, 'Castle City 12', 1, 13, 70000, 2000, 1, 0, 14, 0, 0),
1834(441, 0, 0, 0, 0, 0, 'Castle City 13', 1, 13, 70000, 2000, 1, 0, 14, 0, 0),
1835(442, 0, 0, 0, 0, 0, 'Castle City 14', 1, 20, 105000, 2000, 1, 0, 21, 0, 0),
1836(443, 0, 0, 0, 0, 0, 'Castle City 15', 1, 20, 105000, 2000, 1, 0, 21, 0, 0),
1837(444, 0, 0, 0, 0, 0, 'Castle City 16', 1, 19, 110000, 1500, 1, 2, 22, 0, 0),
1838(445, 0, 0, 0, 0, 0, 'Castle City 17', 1, 6, 45000, 900, 1, 2, 9, 0, 0),
1839(446, 0, 0, 0, 0, 0, 'Castle City 18', 1, 19, 110000, 1900, 1, 2, 22, 0, 0),
1840(447, 0, 0, 0, 0, 0, 'Castle City 19', 1, 22, 130000, 2000, 0, 4, 26, 0, 0),
1841(448, 0, 0, 0, 0, 0, 'Castle City 20', 1, 24, 150000, 3000, 3, 0, 30, 0, 0),
1842(449, 0, 0, 0, 0, 0, 'Castle Depot 1', 1, 17, 100000, 1000, 1, 2, 20, 0, 0),
1843(450, 0, 0, 0, 0, 0, 'Castle Depot 2', 1, 20, 115000, 1000, 1, 2, 23, 0, 0),
1844(451, 0, 0, 0, 0, 0, 'Castle Depot 3', 1, 18, 105000, 1000, 1, 2, 21, 0, 0),
1845(452, 0, 0, 0, 0, 0, 'Castle Depot 4', 1, 18, 105000, 1000, 1, 2, 21, 0, 0),
1846(453, 0, 0, 0, 0, 0, 'Castle Depot 5', 1, 18, 105000, 1000, 1, 2, 21, 0, 0),
1847(454, 0, 0, 0, 0, 0, 'Castle City 21', 1, 13, 80000, 1500, 1, 2, 16, 0, 0),
1848(455, 0, 0, 0, 0, 0, 'Castle City 22', 1, 4, 35000, 1500, 1, 2, 7, 0, 0),
1849(456, 0, 0, 0, 0, 0, 'Castle City 23', 1, 13, 80000, 1500, 1, 2, 16, 0, 0),
1850(457, 0, 0, 0, 0, 0, 'Castle City 24', 1, 19, 110000, 1500, 1, 2, 22, 0, 0),
1851(458, 0, 0, 0, 0, 0, 'Castle City 25', 1, 9, 60000, 1500, 1, 2, 12, 0, 0),
1852(459, 0, 0, 0, 0, 0, 'Castle City 26', 1, 13, 80000, 1500, 1, 2, 16, 0, 0),
1853(460, 0, 0, 0, 0, 0, 'Castle City 27', 1, 13, 80000, 1500, 1, 2, 16, 0, 0),
1854(461, 0, 0, 0, 0, 0, 'Castle City 28', 1, 22, 125000, 1500, 1, 2, 25, 0, 0),
1855(462, 0, 0, 0, 0, 0, 'Castle City 29', 1, 16, 95000, 1500, 1, 2, 19, 0, 0),
1856(463, 0, 0, 0, 0, 0, 'Castle City 30', 1, 22, 125000, 1500, 1, 2, 25, 0, 0),
1857(464, 0, 0, 0, 0, 0, 'Castle City 31', 1, 16, 95000, 1500, 1, 2, 19, 0, 0),
1858(465, 0, 0, 0, 0, 0, 'Snowy House 1', 1, 63, 400000, 3000, 0, 2, 80, 0, 0),
1859(466, 0, 0, 0, 0, 0, 'Cold City 1', 1, 66, 355000, 2000, 1, 4, 71, 0, 0),
1860(467, 0, 0, 0, 0, 0, 'Cold City ', 1, 18, 105000, 1500, 1, 2, 21, 0, 0),
1861(468, 0, 0, 0, 0, 0, 'Cold City 3', 1, 18, 105000, 1500, 1, 2, 21, 0, 0),
1862(469, 0, 0, 0, 0, 0, 'Cold City 4', 1, 26, 180000, 1500, 2, 4, 36, 0, 0),
1863(470, 0, 0, 0, 0, 0, 'Cold City 5', 1, 26, 180000, 2200, 2, 4, 36, 0, 0),
1864(471, 0, 0, 0, 0, 0, 'Cold City 6', 1, 26, 180000, 2200, 2, 4, 36, 0, 0),
1865(472, 0, 0, 0, 0, 0, 'Cold City 7', 1, 29, 170000, 1500, 1, 4, 34, 0, 0),
1866(473, 0, 0, 0, 0, 0, 'Cold City 8', 1, 23, 160000, 3000, 3, 4, 32, 0, 0),
1867(474, 0, 0, 0, 0, 0, 'Cold City 9', 1, 23, 160000, 3000, 3, 4, 32, 0, 0),
1868(475, 0, 0, 0, 0, 0, 'Cold City 10', 1, 24, 165000, 1500, 3, 4, 33, 0, 0),
1869(476, 0, 0, 0, 0, 0, 'Cold City 11', 1, 26, 165000, 2000, 3, 4, 33, 0, 0),
1870(477, 0, 0, 0, 0, 0, 'Cold City 12', 1, 19, 110000, 1800, 1, 2, 22, 0, 0),
1871(478, 0, 0, 0, 0, 0, 'Outlaw Camp 1', 1, 26, 165000, 1500, 2, 2, 33, 0, 0),
1872(479, 0, 0, 0, 0, 0, 'Outlaw Camp 2', 1, 12, 85000, 1000, 1, 4, 17, 0, 0),
1873(480, 0, 0, 0, 0, 0, 'Outlaw Camp 3', 1, 40, 270000, 1800, 1, 0, 54, 0, 0),
1874(481, 0, 0, 0, 0, 0, 'Forgotten Village 1', 1, 30, 185000, 5000, 3, 4, 37, 0, 0),
1875(483, 0, 0, 0, 0, 0, 'Forgotten Village 2', 1, 28, 205000, 3000, 1, 2, 41, 0, 0),
1876(484, 0, 0, 0, 0, 0, 'Forgotten Village 3', 1, 25, 145000, 2000, 2, 2, 29, 0, 0),
1877(485, 0, 0, 0, 0, 0, 'Forgotten Village 4', 1, 34, 195000, 2500, 2, 2, 39, 0, 0),
1878(486, 0, 0, 0, 0, 0, 'Forgotten Village 5', 1, 20, 120000, 2400, 2, 2, 24, 0, 0),
1879(487, 0, 0, 0, 0, 0, 'Forgotten Village 6', 1, 25, 165000, 4000, 4, 4, 33, 0, 0),
1880(488, 0, 0, 0, 0, 0, 'Forgotten Village 7', 1, 40, 235000, 3800, 3, 4, 47, 0, 0),
1881(489, 0, 0, 0, 0, 0, 'Forgotten Village 8', 1, 34, 195000, 3500, 3, 2, 39, 0, 0),
1882(490, 0, 0, 0, 0, 0, 'Forgotten Village 9', 1, 29, 210000, 3800, 3, 4, 42, 0, 0),
1883(491, 0, 0, 0, 0, 0, 'Forgotten Village 10', 1, 20, 135000, 4000, 3, 2, 27, 0, 0),
1884(492, 0, 0, 0, 0, 0, 'Forgotten Village 11', 1, 31, 185000, 4000, 2, 4, 37, 0, 0),
1885(493, 0, 0, 0, 0, 0, 'Forgotten Village 12', 1, 27, 165000, 3000, 4, 2, 33, 0, 0),
1886(494, 0, 0, 0, 0, 0, 'Forgotten Village 13', 1, 53, 320000, 5000, 4, 4, 64, 0, 0),
1887(495, 0, 0, 0, 0, 0, 'Forgotten Village 14', 1, 26, 190000, 2700, 2, 4, 38, 0, 0),
1888(496, 0, 0, 0, 0, 0, 'Forgotten Village 15', 1, 29, 185000, 3000, 2, 6, 37, 0, 0),
1889(497, 0, 0, 0, 0, 0, 'Forgotten Village 16', 1, 16, 95000, 1800, 1, 2, 19, 0, 0),
1890(498, 0, 0, 0, 0, 0, 'Forgotten Village 17', 1, 28, 170000, 3700, 3, 2, 34, 0, 0),
1891(499, 0, 0, 0, 0, 0, 'Forgotten Village Swamped', 1, 34, 195000, 4000, 3, 2, 39, 0, 0),
1892(500, 0, 0, 0, 0, 0, 'Forgotten Village 18', 1, 41, 255000, 4600, 4, 4, 51, 0, 0),
1893(501, 0, 0, 0, 0, 0, 'Forgotten Village 19', 1, 25, 145000, 4000, 2, 2, 29, 0, 0),
1894(502, 0, 0, 0, 0, 0, 'Forgotten Village 20', 1, 45, 290000, 5000, 3, 4, 58, 0, 0),
1895(503, 0, 0, 0, 0, 0, 'Forgotten Village 21', 1, 33, 220000, 5000, 3, 2, 44, 0, 0),
1896(504, 0, 0, 0, 0, 0, 'Castle Depot 6', 1, 31, 180000, 2000, 1, 4, 36, 0, 0),
1897(505, 0, 0, 0, 0, 0, 'Castle Depot 7', 1, 31, 180000, 2000, 1, 4, 36, 0, 0),
1898(506, 0, 0, 0, 0, 0, 'Forest Hut 1', 1, 9, 75000, 0, 1, 2, 15, 0, 0),
1899(507, 0, 0, 0, 0, 0, 'Forest Hut 2', 1, 51, 340000, 2800, 5, 2, 68, 0, 0),
1900(508, 0, 0, 0, 0, 0, 'Yalahari 1', 2, 121, 660000, 3000, 5, 8, 132, 0, 0),
1901(509, 0, 0, 0, 0, 0, 'Yalahari 2', 2, 88, 465000, 3000, 2, 4, 93, 0, 0),
1902(510, 0, 0, 0, 0, 0, 'Yalahari 3', 2, 115, 605000, 3500, 4, 4, 121, 0, 0),
1903(511, 0, 0, 0, 0, 0, 'Yalahari 4', 2, 179, 930000, 3400, 4, 6, 186, 0, 0),
1904(512, 0, 0, 0, 0, 0, 'Yalahari 5', 2, 176, 1275000, 3300, 5, 10, 255, 0, 0),
1905(513, 0, 0, 0, 0, 0, 'Yalahari 6', 2, 152, 795000, 3000, 8, 4, 159, 0, 0),
1906(514, 0, 0, 0, 0, 0, 'Yalahari 7', 2, 144, 770000, 2500, 3, 8, 154, 0, 0),
1907(515, 0, 0, 0, 0, 0, 'Yalahari 8', 2, 120, 645000, 4000, 5, 6, 129, 0, 0),
1908(516, 0, 0, 0, 0, 0, 'Yalahari 9', 2, 311, 1975000, 20000, 20, 66, 395, 0, 0),
1909(517, 0, 0, 0, 0, 0, 'Yalahari 10', 2, 237, 1220000, 6000, 3, 5, 244, 0, 0),
1910(518, 0, 0, 0, 0, 0, 'Yalahari 11', 2, 136, 720000, 4000, 5, 4, 144, 0, 0),
1911(519, 0, 0, 0, 0, 0, 'Yalahari 12', 2, 135, 705000, 4500, 4, 4, 141, 0, 0),
1912(520, 0, 0, 0, 0, 0, 'Yalahari 13', 2, 129, 705000, 3500, 5, 8, 141, 0, 0),
1913(521, 0, 0, 0, 0, 0, 'Yalahari 14', 2, 101, 620000, 2300, 7, 20, 124, 0, 0),
1914(522, 0, 0, 0, 0, 0, 'Yalahari 15', 2, 9, 80000, 1000, 1, 6, 16, 0, 0),
1915(523, 0, 0, 0, 0, 0, 'Yalahari 16', 2, 7, 50000, 1000, 1, 2, 10, 0, 0),
1916(524, 0, 0, 0, 0, 0, 'Yalahari 17', 2, 37, 190000, 1000, 1, 0, 38, 0, 0),
1917(525, 0, 0, 0, 0, 0, 'Yalahari 18', 2, 16, 115000, 1000, 1, 6, 23, 0, 0),
1918(526, 0, 0, 0, 0, 0, 'Yalahari 19', 2, 23, 150000, 1000, 1, 6, 30, 0, 0),
1919(527, 0, 0, 0, 0, 0, 'Yalahari 20', 2, 9, 80000, 1000, 1, 6, 16, 0, 0),
1920(528, 0, 0, 0, 0, 0, 'Yalahari 21', 2, 8, 55000, 1000, 1, 2, 11, 0, 0),
1921(529, 0, 0, 0, 0, 0, 'Yalahari 22', 2, 12, 80000, 1000, 1, 4, 16, 0, 0),
1922(530, 0, 0, 0, 0, 0, 'Yalahari 23', 2, 9, 80000, 1000, 1, 6, 16, 0, 0),
1923(531, 0, 0, 0, 0, 0, 'Yalahari 24', 2, 9, 70000, 1000, 1, 4, 14, 0, 0),
1924(532, 0, 0, 0, 0, 0, 'Yalahari 25', 2, 5, 30000, 500, 1, 0, 6, 0, 0),
1925(533, 0, 0, 0, 0, 0, 'Yalahari 26', 2, 53, 285000, 4000, 3, 2, 57, 0, 0),
1926(534, 0, 0, 0, 0, 0, 'Yalahari 27', 2, 62, 340000, 4000, 3, 4, 68, 0, 0),
1927(535, 0, 0, 0, 0, 0, 'Yalahari 28', 2, 98, 515000, 3000, 1, 4, 103, 0, 0),
1928(536, 0, 0, 0, 0, 0, 'Yalahari 29', 2, 97, 520000, 4000, 3, 4, 104, 0, 0),
1929(537, 0, 0, 0, 0, 0, 'Yalahari 30', 2, 82, 470000, 4000, 5, 8, 94, 0, 0),
1930(538, 0, 0, 0, 0, 0, ' Flat 1', 2, 16, 135000, 1000, 1, 10, 27, 0, 0),
1931(539, 0, 0, 0, 0, 0, 'Flat 2', 2, 16, 105000, 1000, 1, 4, 21, 0, 0),
1932(540, 0, 0, 0, 0, 0, 'Flat 3', 2, 17, 130000, 1000, 1, 8, 26, 0, 0),
1933(541, 0, 0, 0, 0, 0, 'Flat 4', 2, 14, 105000, 1000, 1, 6, 21, 0, 0),
1934(542, 0, 0, 0, 0, 0, 'Flat 5', 2, 20, 125000, 1000, 1, 4, 25, 0, 0),
1935(543, 0, 0, 0, 0, 0, 'Flat 6', 2, 16, 105000, 1000, 1, 4, 21, 0, 0),
1936(544, 0, 0, 0, 0, 0, 'Flat 7', 2, 17, 140000, 1000, 1, 10, 28, 0, 0),
1937(545, 0, 0, 0, 0, 0, 'Flat 8', 2, 34, 185000, 2000, 1, 2, 37, 0, 0),
1938(546, 0, 0, 0, 0, 0, 'Flat 9', 2, 24, 135000, 2000, 1, 2, 27, 0, 0),
1939(547, 0, 0, 0, 0, 0, 'Flat 10', 2, 24, 135000, 2000, 1, 2, 27, 0, 0),
1940(548, 0, 0, 0, 0, 0, 'Flat 11', 2, 34, 185000, 2000, 1, 2, 37, 0, 0),
1941(549, 0, 0, 0, 0, 0, 'Cold City Shop 1', 1, 14, 85000, 800, 1, 2, 17, 0, 0),
1942(550, 0, 0, 0, 0, 0, 'Cold City Shop 2', 1, 14, 85000, 800, 0, 2, 17, 0, 0),
1943(551, 0, 0, 0, 0, 0, 'Castle Village', 1, 478, 2895000, 0, 18, 16, 579, 0, 0),
1944(552, 0, 0, 0, 0, 0, 'Farming Village 1', 1, 4, 35000, 400, 1, 2, 7, 0, 0),
1945(553, 0, 0, 0, 0, 0, 'Farming Village 2', 1, 4, 35000, 500, 1, 2, 7, 0, 0),
1946(554, 0, 0, 0, 0, 0, 'Farming Village 3', 1, 7, 50000, 500, 1, 2, 10, 0, 0);
1947
1948-- --------------------------------------------------------
1949
1950--
1951-- Table structure for table `house_auctions`
1952--
1953-- Creation: Jul 23, 2014 at 12:49 PM
1954--
1955
1956DROP TABLE IF EXISTS `house_auctions`;
1957CREATE TABLE IF NOT EXISTS `house_auctions` (
1958  `house_id` int(10) unsigned NOT NULL,
1959  `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
1960  `player_id` int(11) NOT NULL,
1961  `bid` int(10) unsigned NOT NULL DEFAULT '0',
1962  `limit` int(10) unsigned NOT NULL DEFAULT '0',
1963  `endtime` bigint(20) unsigned NOT NULL DEFAULT '0',
1964  UNIQUE KEY `house_id` (`house_id`,`world_id`),
1965  KEY `player_id` (`player_id`)
1966) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1967
1968--
1969-- RELATIONS FOR TABLE `house_auctions`:
1970--   `player_id`
1971--       `players` -> `id`
1972--
1973
1974-- --------------------------------------------------------
1975
1976--
1977-- Table structure for table `house_data`
1978--
1979-- Creation: Jul 23, 2014 at 12:49 PM
1980--
1981
1982DROP TABLE IF EXISTS `house_data`;
1983CREATE TABLE IF NOT EXISTS `house_data` (
1984  `house_id` int(10) unsigned NOT NULL,
1985  `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
1986  `data` longblob NOT NULL,
1987  UNIQUE KEY `house_id` (`house_id`,`world_id`)
1988) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1989
1990-- --------------------------------------------------------
1991
1992--
1993-- Table structure for table `house_lists`
1994--
1995-- Creation: Jul 23, 2014 at 12:49 PM
1996--
1997
1998DROP TABLE IF EXISTS `house_lists`;
1999CREATE TABLE IF NOT EXISTS `house_lists` (
2000  `house_id` int(10) unsigned NOT NULL,
2001  `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
2002  `listid` int(11) NOT NULL,
2003  `list` text NOT NULL,
2004  UNIQUE KEY `house_id` (`house_id`,`world_id`,`listid`)
2005) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2006
2007--
2008-- Dumping data for table `house_lists`
2009--
2010
2011INSERT INTO `house_lists` (`house_id`, `world_id`, `listid`, `list`) VALUES
2012(186, 0, 256, 'Rektcity\nX\nWubcity'),
2013(210, 0, 257, 'Zara''ed'),
2014(374, 0, 256, 'Benjarahn'),
2015(374, 0, 257, 'Maldyn\nMaldori'),
2016(376, 0, 257, 'Micky mouse\nDonald Duck\nMystery'),
2017(551, 0, 256, 'Distant Warrior\nSuperman\nKnight of Awsomeness\n'),
2018(551, 0, 257, 'Jerred\nGangsta Stu\nRobin Hood\nKierkan\nTrent');
2019
2020-- --------------------------------------------------------
2021
2022--
2023-- Table structure for table `killers`
2024--
2025-- Creation: Jul 23, 2014 at 12:49 PM
2026--
2027
2028DROP TABLE IF EXISTS `killers`;
2029CREATE TABLE IF NOT EXISTS `killers` (
2030  `id` int(11) NOT NULL AUTO_INCREMENT,
2031  `death_id` int(11) NOT NULL,
2032  `final_hit` tinyint(1) unsigned NOT NULL DEFAULT '0',
2033  `unjustified` tinyint(1) unsigned NOT NULL DEFAULT '0',
2034  `war` int(11) NOT NULL DEFAULT '0',
2035  PRIMARY KEY (`id`),
2036  KEY `death_id` (`death_id`)
2037) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1634 ;
2038
2039--
2040-- RELATIONS FOR TABLE `killers`:
2041--   `death_id`
2042--       `player_deaths` -> `id`
2043--
2044
2045--
2046-- Dumping data for table `killers`
2047--
2048
2049INSERT INTO `killers` (`id`, `death_id`, `final_hit`, `unjustified`, `war`) VALUES
2050(1633, 999, 1, 0, 0);
2051
2052-- --------------------------------------------------------
2053
2054--
2055-- Table structure for table `l4d`
2056--
2057-- Creation: Aug 20, 2014 at 04:21 PM
2058-- Last update: Aug 20, 2014 at 04:21 PM
2059--
2060
2061DROP TABLE IF EXISTS `l4d`;
2062CREATE TABLE IF NOT EXISTS `l4d` (
2063  `name` varchar(11) CHARACTER SET latin1 NOT NULL
2064) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2065
2066-- --------------------------------------------------------
2067
2068--
2069-- Table structure for table `lottery`
2070--
2071-- Creation: Jul 23, 2014 at 12:49 PM
2072-- Last update: Jul 23, 2014 at 12:49 PM
2073--
2074
2075DROP TABLE IF EXISTS `lottery`;
2076CREATE TABLE IF NOT EXISTS `lottery` (
2077  `id` int(11) NOT NULL AUTO_INCREMENT,
2078  `name` varchar(255) NOT NULL,
2079  `item` varchar(255) NOT NULL,
2080  `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
2081  PRIMARY KEY (`id`)
2082) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
2083
2084--
2085-- Dumping data for table `lottery`
2086--
2087
2088INSERT INTO `lottery` (`id`, `name`, `item`, `world_id`) VALUES
2089(1, 'Nobody', 'nothing', 0);
2090
2091-- --------------------------------------------------------
2092
2093--
2094-- Table structure for table `players`
2095--
2096-- Creation: Jul 23, 2014 at 12:49 PM
2097--
2098
2099DROP TABLE IF EXISTS `players`;
2100CREATE TABLE IF NOT EXISTS `players` (
2101  `id` int(11) NOT NULL AUTO_INCREMENT,
2102  `name` varchar(255) NOT NULL,
2103  `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
2104  `group_id` int(11) NOT NULL DEFAULT '1',
2105  `account_id` int(11) NOT NULL DEFAULT '0',
2106  `level` int(11) NOT NULL DEFAULT '1',
2107  `vocation` int(11) NOT NULL DEFAULT '0',
2108  `health` int(11) NOT NULL DEFAULT '150',
2109  `healthmax` int(11) NOT NULL DEFAULT '150',
2110  `experience` bigint(20) NOT NULL DEFAULT '0',
2111  `lookbody` int(11) NOT NULL DEFAULT '0',
2112  `lookfeet` int(11) NOT NULL DEFAULT '0',
2113  `lookhead` int(11) NOT NULL DEFAULT '0',
2114  `looklegs` int(11) NOT NULL DEFAULT '0',
2115  `looktype` int(11) NOT NULL DEFAULT '136',
2116  `lookaddons` int(11) NOT NULL DEFAULT '0',
2117  `maglevel` int(11) NOT NULL DEFAULT '0',
2118  `mana` int(11) NOT NULL DEFAULT '0',
2119  `manamax` int(11) NOT NULL DEFAULT '0',
2120  `manaspent` int(11) NOT NULL DEFAULT '0',
2121  `soul` int(10) unsigned NOT NULL DEFAULT '0',
2122  `town_id` int(11) NOT NULL DEFAULT '0',
2123  `posx` int(11) NOT NULL DEFAULT '0',
2124  `posy` int(11) NOT NULL DEFAULT '0',
2125  `posz` int(11) NOT NULL DEFAULT '0',
2126  `conditions` blob NOT NULL,
2127  `cap` int(11) NOT NULL DEFAULT '0',
2128  `sex` int(11) NOT NULL DEFAULT '0',
2129  `lastlogin` bigint(20) unsigned NOT NULL DEFAULT '0',
2130  `lastip` int(10) unsigned NOT NULL DEFAULT '0',
2131  `save` tinyint(1) NOT NULL DEFAULT '1',
2132  `skull` tinyint(1) unsigned NOT NULL DEFAULT '0',
2133  `skulltime` int(11) NOT NULL DEFAULT '0',
2134  `rank_id` int(11) NOT NULL DEFAULT '0',
2135  `guildnick` varchar(255) NOT NULL DEFAULT '',
2136  `lastlogout` bigint(20) unsigned NOT NULL DEFAULT '0',
2137  `blessings` tinyint(2) NOT NULL DEFAULT '0',
2138  `balance` bigint(20) NOT NULL DEFAULT '0',
2139  `stamina` bigint(20) NOT NULL DEFAULT '151200000' COMMENT 'stored in miliseconds',
2140  `direction` int(11) NOT NULL DEFAULT '2',
2141  `loss_experience` int(11) NOT NULL DEFAULT '100',
2142  `loss_mana` int(11) NOT NULL DEFAULT '100',
2143  `loss_skills` int(11) NOT NULL DEFAULT '100',
2144  `loss_containers` int(11) NOT NULL DEFAULT '100',
2145  `loss_items` int(11) NOT NULL DEFAULT '100',
2146  `premend` int(11) NOT NULL DEFAULT '0' COMMENT 'NOT IN USE BY THE SERVER',
2147  `online` tinyint(1) NOT NULL DEFAULT '0',
2148  `marriage` int(10) unsigned NOT NULL DEFAULT '0',
2149  `promotion` int(11) NOT NULL DEFAULT '0',
2150  `deleted` tinyint(1) NOT NULL DEFAULT '0',
2151  `description` varchar(255) NOT NULL DEFAULT '',
2152  `fake` int(11) NOT NULL DEFAULT '0',
2153  `created` int(11) NOT NULL DEFAULT '0',
2154  `nick_verify` int(11) NOT NULL DEFAULT '0',
2155  `old_name` varchar(255) NOT NULL DEFAULT '',
2156  `hide_char` int(11) NOT NULL DEFAULT '0',
2157  `comment` text NOT NULL,
2158  `kills` int(11) NOT NULL,
2159  `deaths` int(11) NOT NULL,
2160  `ghostaccess` int(11) NOT NULL,
2161  `exphist_lastexp` bigint(255) NOT NULL DEFAULT '0',
2162  `exphist1` bigint(255) NOT NULL DEFAULT '0',
2163  `exphist2` bigint(255) NOT NULL DEFAULT '0',
2164  `exphist3` bigint(255) NOT NULL DEFAULT '0',
2165  `exphist4` bigint(255) NOT NULL DEFAULT '0',
2166  `exphist5` bigint(255) NOT NULL DEFAULT '0',
2167  `exphist6` bigint(255) NOT NULL DEFAULT '0',
2168  `exphist7` bigint(255) NOT NULL DEFAULT '0',
2169  `onlinetimetoday` bigint(255) NOT NULL DEFAULT '0',
2170  `onlinetime1` bigint(255) NOT NULL DEFAULT '0',
2171  `onlinetime2` bigint(255) NOT NULL DEFAULT '0',
2172  `onlinetime3` bigint(255) NOT NULL DEFAULT '0',
2173  `onlinetime4` bigint(255) NOT NULL DEFAULT '0',
2174  `onlinetime5` bigint(255) NOT NULL DEFAULT '0',
2175  `onlinetime6` bigint(255) NOT NULL DEFAULT '0',
2176  `onlinetime7` bigint(255) NOT NULL DEFAULT '0',
2177  `onlinetimeall` bigint(255) NOT NULL DEFAULT '0',
2178  `create_ip` int(11) NOT NULL DEFAULT '0',
2179  `create_date` int(11) NOT NULL DEFAULT '0',
2180  `auction_balance` int(11) NOT NULL,
2181  PRIMARY KEY (`id`),
2182  UNIQUE KEY `name` (`name`,`deleted`),
2183  KEY `account_id` (`account_id`),
2184  KEY `group_id` (`group_id`),
2185  KEY `online` (`online`),
2186  KEY `deleted` (`deleted`)
2187) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=265 ;
2188
2189--
2190-- RELATIONS FOR TABLE `players`:
2191--   `account_id`
2192--       `accounts` -> `id`
2193--
2194
2195--
2196-- Dumping data for table `players`
2197--
2198
2199INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `fake`, `created`, `nick_verify`, `old_name`, `hide_char`, `comment`, `kills`, `deaths`, `ghostaccess`, `exphist_lastexp`, `exphist1`, `exphist2`, `exphist3`, `exphist4`, `exphist5`, `exphist6`, `exphist7`, `onlinetimetoday`, `onlinetime1`, `onlinetime2`, `onlinetime3`, `onlinetime4`, `onlinetime5`, `onlinetime6`, `onlinetime7`, `onlinetimeall`, `create_ip`, `create_date`, `auction_balance`) VALUES
2200(1, 'Account Manager', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '0', 0, 0, 0, '', 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
2201(6, '[ADMIN] Wezza', 0, 6, 1147766, 205, 5, 1022, 1022, 140980900, 0, 0, 0, 0, 302, 0, 200, 9927, 13827, 0, 100, 1, 846, 692, 7, '', 56360, 0, 1408579672, 1794268880, 1, 0, 0, 0, '', 1408555053, 31, 0, 151200000, 0, 34, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 0, 1404867364, 0, '', 1, '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
2202(31, 'Mage Sample', 0, 1, 1, 1, 1, 200, 200, 0, 116, 94, 105, 1, 154, 0, 0, 35, 35, 0, 100, 1, 831, 702, 7, '', 420, 1, 1407546118, 2866268498, 1, 0, 0, 0, '', 1407546126, 0, 0, 151200000, 0, 16, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 0, 1405050623, 1, '', 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
2203(32, 'Paladin Sample', 0, 1, 1, 1, 2, 200, 200, 0, 119, 0, 114, 113, 152, 0, 0, 35, 35, 0, 100, 1, 831, 702, 7, '', 420, 1, 1406552438, 1794268880, 1, 0, 0, 0, '', 1406552439, 0, 0, 151200000, 0, 16, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 0, 1405050623, 1, '', 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
2204(33, 'Warrior Sample', 0, 1, 1, 1, 3, 200, 200, 0, 67, 114, 0, 113, 251, 0, 0, 35, 35, 0, 100, 1, 831, 702, 7, '', 420, 1, 1406552412, 1794268880, 1, 0, 0, 0, '', 1406552433, 0, 0, 151200000, 0, 16, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 0, 1405050623, 1, '', 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),;
2205
2206--
2207-- Triggers `players`
2208--
2209DROP TRIGGER IF EXISTS `oncreate_players`;
2210DELIMITER //
2211CREATE TRIGGER `oncreate_players` AFTER INSERT ON `players`
2212 FOR EACH ROW BEGIN
2213	INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10);
2214	INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10);
2215	INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10);
2216	INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10);
2217	INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10);
2218	INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10);
2219	INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10);
2220END
2221//
2222DELIMITER ;
2223DROP TRIGGER IF EXISTS `ondelete_players`;
2224DELIMITER //
2225CREATE TRIGGER `ondelete_players` BEFORE DELETE ON `players`
2226 FOR EACH ROW BEGIN
2227	DELETE FROM `bans` WHERE `type` = 2 AND `value` = OLD.`id`;
2228	UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`;
2229END
2230//
2231DELIMITER ;
2232
2233-- --------------------------------------------------------
2234
2235--
2236-- Table structure for table `player_deaths`
2237--
2238-- Creation: Jul 23, 2014 at 12:49 PM
2239--
2240
2241DROP TABLE IF EXISTS `player_deaths`;
2242CREATE TABLE IF NOT EXISTS `player_deaths` (
2243  `id` int(11) NOT NULL AUTO_INCREMENT,
2244  `player_id` int(11) NOT NULL,
2245  `date` bigint(20) unsigned NOT NULL,
2246  `level` int(10) unsigned NOT NULL,
2247  `death` int(11) NOT NULL,
2248  PRIMARY KEY (`id`),
2249  KEY `date` (`date`),
2250  KEY `player_id` (`player_id`)
2251) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1000 ;
2252
2253--
2254-- RELATIONS FOR TABLE `player_deaths`:
2255--   `player_id`
2256--       `players` -> `id`
2257--
2258
2259--
2260-- Dumping data for table `player_deaths`
2261--
2262
2263INSERT INTO `player_deaths` (`id`, `player_id`, `date`, `level`, `death`) VALUES
2264(161, 56, 1405583710, 300, 0);
2265
2266-- --------------------------------------------------------
2267
2268--
2269-- Table structure for table `player_depotitems`
2270--
2271-- Creation: Jul 23, 2014 at 12:49 PM
2272--
2273
2274DROP TABLE IF EXISTS `player_depotitems`;
2275CREATE TABLE IF NOT EXISTS `player_depotitems` (
2276  `player_id` int(11) NOT NULL,
2277  `sid` int(11) NOT NULL COMMENT 'any given range, eg. 0-100 is reserved for depot lockers and all above 100 will be normal items inside depots',
2278  `pid` int(11) NOT NULL DEFAULT '0',
2279  `itemtype` int(11) NOT NULL,
2280  `count` int(11) NOT NULL DEFAULT '0',
2281  `attributes` blob NOT NULL,
2282  UNIQUE KEY `player_id_2` (`player_id`,`sid`),
2283  KEY `player_id` (`player_id`)
2284) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2285
2286--
2287-- RELATIONS FOR TABLE `player_depotitems`:
2288--   `player_id`
2289--       `players` -> `id`
2290--
2291
2292--
2293-- Dumping data for table `player_depotitems`
2294--
2295
2296INSERT INTO `player_depotitems` (`player_id`, `sid`, `pid`, `itemtype`, `count`, `attributes`) VALUES;
2297
2298
2299-- --------------------------------------------------------
2300
2301--
2302-- Table structure for table `player_items`
2303--
2304-- Creation: Jul 23, 2014 at 12:49 PM
2305--
2306
2307DROP TABLE IF EXISTS `player_items`;
2308CREATE TABLE IF NOT EXISTS `player_items` (
2309  `player_id` int(11) NOT NULL DEFAULT '0',
2310  `pid` int(11) NOT NULL DEFAULT '0',
2311  `sid` int(11) NOT NULL DEFAULT '0',
2312  `itemtype` int(11) NOT NULL DEFAULT '0',
2313  `count` int(11) NOT NULL DEFAULT '0',
2314  `attributes` blob NOT NULL,
2315  UNIQUE KEY `player_id_2` (`player_id`,`sid`),
2316  KEY `player_id` (`player_id`)
2317) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2318
2319--
2320-- RELATIONS FOR TABLE `player_items`:
2321--   `player_id`
2322--       `players` -> `id`
2323--
2324
2325
2326-- --------------------------------------------------------
2327
2328--
2329-- Table structure for table `player_killers`
2330--
2331-- Creation: Jul 23, 2014 at 12:49 PM
2332--
2333
2334DROP TABLE IF EXISTS `player_killers`;
2335CREATE TABLE IF NOT EXISTS `player_killers` (
2336  `kill_id` int(11) NOT NULL,
2337  `player_id` int(11) NOT NULL,
2338  KEY `kill_id` (`kill_id`),
2339  KEY `player_id` (`player_id`)
2340) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2341
2342--------------------
2343
2344--
2345-- Table structure for table `player_namelocks`
2346--
2347-- Creation: Jul 23, 2014 at 12:49 PM
2348--
2349
2350DROP TABLE IF EXISTS `player_namelocks`;
2351CREATE TABLE IF NOT EXISTS `player_namelocks` (
2352  `player_id` int(11) NOT NULL DEFAULT '0',
2353  `name` varchar(255) NOT NULL,
2354  `new_name` varchar(255) NOT NULL,
2355  `date` bigint(20) NOT NULL DEFAULT '0',
2356  KEY `player_id` (`player_id`)
2357) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2358
2359--
2360-- RELATIONS FOR TABLE `player_namelocks`:
2361--   `player_id`
2362--       `players` -> `id`
2363--
2364
2365-- --------------------------------------------------------
2366
2367--
2368-- Table structure for table `player_reports`
2369--
2370-- Creation: Aug 07, 2014 at 01:30 AM
2371-- Last update: Aug 20, 2014 at 11:58 PM
2372-- Last check: Aug 12, 2014 at 10:35 PM
2373--
2374
2375DROP TABLE IF EXISTS `player_reports`;
2376CREATE TABLE IF NOT EXISTS `player_reports` (
2377  `id` int(11) NOT NULL AUTO_INCREMENT,
2378  `name` text NOT NULL,
2379  `posx` int(6) NOT NULL,
2380  `posy` int(6) NOT NULL,
2381  `posz` int(6) NOT NULL,
2382  `report_description` text NOT NULL,
2383  `date` text NOT NULL,
2384  `fixed` int(2) NOT NULL,
2385  PRIMARY KEY (`id`)
2386) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=38 ;
2387
2388--
2389-- Dumping data for table `player_reports`
2390--
2391
2392INSERT INTO `player_reports` (`id`, `name`, `posx`, `posy`, `posz`, `report_description`, `date`, `fixed`) VALUES
2393(28, 'Eureka', 1038, 918, 6, 'The fire shield says that it is useable by guardians, heroic guardians, wardens and furious wardens but my warden cannot wear it says cannot dress this object when i try', '08/12/14 10:02:21', 0),
2394(14, 'Kierkan', 2027, 2015, 12, '18:34 You have found a dried grass roof. Inside a chest where Demondras is', '08/07/14 18:34:34', 0),
2395(15, 'Kierkan', 968, 750, 8, 'Rekt and I are stuck at that Djinn spot for the tele scroll quest, where we got stuck last time', '08/08/14 02:05:23', 0),
2396(23, 'Robin Hood', 880, 562, 7, 'We should be able to buy at least a shock arrow as hunters cause the fire arrow doesnt damage alot of the spawns', '08/10/14 12:44:16', 0),
2397(24, 'Jerred', 1313, 859, 7, 'Sorceres need a weapon that can be worn with their spellbooks cause as it is i can only raise my fist skill level', '08/11/14 11:44:42', 0),
2398(25, 'Jerred', 1962, 2236, 8, 'I had a suggestion for Donald the food NPC it would be nice if he sold dragon hams.... Ty for reading!', '08/11/14 15:24:31', 0),
2399(26, 'Jerred', 1800, 1422, 7, 'Helmet of the Ancients doesnt give you mana-shield like the quest sign says it does', '08/11/14 16:22:15', 0),
2400(29, 'Rogue Niggah', 833, 700, 8, 'You need some work', '08/15/14 05:33:12', 0),
2401(30, 'Distant Warrior', 866, 697, 8, 'test', '08/17/14 17:19:34', 0),
2402(31, 'Distant Warrior', 866, 695, 8, 'Make Mining more usefull instead of just for makeing bombs, Mining can sometimes Wake up Stong creatures, Or Help you find Magicle gems that can give you temp HP % Or Temp skills depending on the Gem color, But make sure the Picks are breakable', '08/17/14 17:37:43', 0),
2403(32, 'Distant Warrior', 866, 695, 8, 'Or make make it so you can only mine X amount a Day then have to wait 24 hours. or something around those line.', '08/17/14 17:38:21', 0),
2404(33, 'Distant Warrior', 711, 735, 9, 'the exhaust time on exori gran mas mort is too long.', '08/18/14 06:31:00', 0),
2405(34, 'Distant Warrior', 835, 704, 5, 'Loot seller Buys Floor Tiles', '08/18/14 06:48:34', 0),
2406(35, 'Wayne', 833, 704, 4, 'yahbal', '08/20/14 10:49:56', 0),
2407(36, '[ADMIN] Wezza', 833, 703, 1, 'On reaching level 100, automatically get teleported to the Queen', '08/20/14 10:52:56', 0),
2408(37, 'Wayne', 800, 698, 6, 'a7a', '08/20/14 16:58:32', 0);
2409
2410-- --------------------------------------------------------
2411
2412--
2413-- Table structure for table `player_skills`
2414--
2415-- Creation: Jul 23, 2014 at 12:49 PM
2416--
2417
2418DROP TABLE IF EXISTS `player_skills`;
2419CREATE TABLE IF NOT EXISTS `player_skills` (
2420  `player_id` int(11) NOT NULL DEFAULT '0',
2421  `skillid` tinyint(2) NOT NULL DEFAULT '0',
2422  `value` int(10) unsigned NOT NULL DEFAULT '0',
2423  `count` int(10) unsigned NOT NULL DEFAULT '0',
2424  UNIQUE KEY `player_id_2` (`player_id`,`skillid`),
2425  KEY `player_id` (`player_id`)
2426) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2427
2428--
2429-- RELATIONS FOR TABLE `player_skills`:
2430--   `player_id`
2431--       `players` -> `id`
2432--
2433
2434
2435-- --------------------------------------------------------
2436
2437--
2438-- Table structure for table `player_spells`
2439--
2440-- Creation: Jul 23, 2014 at 12:49 PM
2441--
2442
2443DROP TABLE IF EXISTS `player_spells`;
2444CREATE TABLE IF NOT EXISTS `player_spells` (
2445  `player_id` int(11) NOT NULL,
2446  `name` varchar(255) NOT NULL,
2447  UNIQUE KEY `player_id_2` (`player_id`,`name`),
2448  KEY `player_id` (`player_id`)
2449) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2450
2451--
2452-- RELATIONS FOR TABLE `player_spells`:
2453--   `player_id`
2454--       `players` -> `id`
2455--
2456
2457-- --------------------------------------------------------
2458
2459--
2460-- Table structure for table `player_storage`
2461--
2462-- Creation: Jul 23, 2014 at 12:49 PM
2463--
2464
2465DROP TABLE IF EXISTS `player_storage`;
2466CREATE TABLE IF NOT EXISTS `player_storage` (
2467  `player_id` int(11) NOT NULL DEFAULT '0',
2468  `key` int(10) unsigned NOT NULL DEFAULT '0',
2469  `value` varchar(255) NOT NULL DEFAULT '0',
2470  UNIQUE KEY `player_id_2` (`player_id`,`key`),
2471  KEY `player_id` (`player_id`)
2472) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2473
2474--
2475-- RELATIONS FOR TABLE `player_storage`:
2476--   `player_id`
2477--       `players` -> `id`
2478--
2479
2480
2481--
2482-- Table structure for table `player_viplist`
2483--
2484-- Creation: Jul 23, 2014 at 12:49 PM
2485--
2486
2487DROP TABLE IF EXISTS `player_viplist`;
2488CREATE TABLE IF NOT EXISTS `player_viplist` (
2489  `player_id` int(11) NOT NULL,
2490  `vip_id` int(11) NOT NULL,
2491  UNIQUE KEY `player_id_2` (`player_id`,`vip_id`),
2492  KEY `player_id` (`player_id`),
2493  KEY `vip_id` (`vip_id`)
2494) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2495
2496
2497--
2498-- Table structure for table `posts`
2499--
2500-- Creation: Jul 23, 2014 at 12:49 PM
2501--
2502
2503DROP TABLE IF EXISTS `posts`;
2504CREATE TABLE IF NOT EXISTS `posts` (
2505  `id` int(11) NOT NULL AUTO_INCREMENT,
2506  `title` varchar(255) DEFAULT NULL,
2507  `icon` int(5) DEFAULT NULL,
2508  `date` varchar(45) DEFAULT NULL,
2509  `time` varchar(30) DEFAULT NULL,
2510  `author` varchar(30) DEFAULT NULL,
2511  `board` int(5) DEFAULT NULL,
2512  `thread` int(20) DEFAULT NULL,
2513  `post` text,
2514  `signature` int(5) DEFAULT NULL,
2515  PRIMARY KEY (`id`)
2516) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
2517
2518-- --------------------------------------------------------
2519
2520--
2521-- Table structure for table `server_config`
2522--
2523-- Creation: Jul 23, 2014 at 12:49 PM
2524--
2525
2526DROP TABLE IF EXISTS `server_config`;
2527CREATE TABLE IF NOT EXISTS `server_config` (
2528  `config` varchar(35) NOT NULL DEFAULT '',
2529  `value` varchar(255) NOT NULL DEFAULT '',
2530  UNIQUE KEY `config` (`config`)
2531) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2532
2533--
2534-- Dumping data for table `server_config`
2535--
2536
2537INSERT INTO `server_config` (`config`, `value`) VALUES
2538('db_version', '26'),
2539('encryption', '2'),
2540('password_type', '0'),
2541('vahash_key', 'R48X-UIA3-H743-PQU8');
2542
2543-- --------------------------------------------------------
2544
2545--
2546-- Table structure for table `server_motd`
2547--
2548-- Creation: Jul 23, 2014 at 12:49 PM
2549--
2550
2551DROP TABLE IF EXISTS `server_motd`;
2552CREATE TABLE IF NOT EXISTS `server_motd` (
2553  `id` int(10) unsigned NOT NULL,
2554  `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
2555  `text` text NOT NULL,
2556  UNIQUE KEY `id` (`id`,`world_id`)
2557) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2558
2559--
2560-- Dumping data for table `server_motd`
2561--
2562
2563INSERT INTO `server_motd` (`id`, `world_id`, `text`) VALUES
2564(1, 0, 'Welcome to The Forgotten Server!'),
2565(2, 0, 'Welcome to Grand-OT'),
2566(3, 0, 'Welcome to Grand-OT, we are now running on a dedicated server!');
2567
2568-- --------------------------------------------------------
2569
2570--
2571-- Table structure for table `server_record`
2572--
2573-- Creation: Jul 23, 2014 at 12:49 PM
2574--
2575
2576DROP TABLE IF EXISTS `server_record`;
2577CREATE TABLE IF NOT EXISTS `server_record` (
2578  `record` int(11) NOT NULL,
2579  `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
2580  `timestamp` bigint(20) NOT NULL,
2581  UNIQUE KEY `record` (`record`,`world_id`,`timestamp`)
2582) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2583
2584
2585-- --------------------------------------------------------
2586
2587--
2588-- Table structure for table `server_reports`
2589--
2590-- Creation: Jul 23, 2014 at 12:49 PM
2591--
2592
2593DROP TABLE IF EXISTS `server_reports`;
2594CREATE TABLE IF NOT EXISTS `server_reports` (
2595  `id` int(11) NOT NULL AUTO_INCREMENT,
2596  `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
2597  `player_id` int(11) NOT NULL DEFAULT '1',
2598  `posx` int(11) NOT NULL DEFAULT '0',
2599  `posy` int(11) NOT NULL DEFAULT '0',
2600  `posz` int(11) NOT NULL DEFAULT '0',
2601  `timestamp` bigint(20) NOT NULL DEFAULT '0',
2602  `report` text NOT NULL,
2603  `reads` int(11) NOT NULL DEFAULT '0',
2604  PRIMARY KEY (`id`),
2605  KEY `world_id` (`world_id`),
2606  KEY `reads` (`reads`),
2607  KEY `player_id` (`player_id`)
2608) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
2609
2610--
2611-- RELATIONS FOR TABLE `server_reports`:
2612--   `player_id`
2613--       `players` -> `id`
2614--
2615
2616-- --------------------------------------------------------
2617
2618--
2619-- Table structure for table `threads`
2620--
2621-- Creation: Jul 23, 2014 at 12:49 PM
2622--
2623
2624DROP TABLE IF EXISTS `threads`;
2625CREATE TABLE IF NOT EXISTS `threads` (
2626  `id` int(11) NOT NULL AUTO_INCREMENT,
2627  `name` varchar(255) DEFAULT NULL,
2628  `icon` int(5) DEFAULT NULL,
2629  `closed` int(5) DEFAULT NULL,
2630  `stick` int(5) NOT NULL,
2631  `date` varchar(45) DEFAULT NULL,
2632  `time` varchar(30) DEFAULT NULL,
2633  `author` varchar(30) DEFAULT NULL,
2634  `board` int(5) DEFAULT NULL,
2635  `views` int(20) DEFAULT NULL,
2636  `last` int(40) DEFAULT NULL,
2637  PRIMARY KEY (`id`)
2638) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
2639
2640-- --------------------------------------------------------
2641
2642--
2643-- Table structure for table `tiles`
2644--
2645-- Creation: Jul 23, 2014 at 12:49 PM
2646--
2647
2648DROP TABLE IF EXISTS `tiles`;
2649CREATE TABLE IF NOT EXISTS `tiles` (
2650  `id` int(10) unsigned NOT NULL,
2651  `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
2652  `house_id` int(10) unsigned NOT NULL,
2653  `x` int(5) unsigned NOT NULL,
2654  `y` int(5) unsigned NOT NULL,
2655  `z` tinyint(2) unsigned NOT NULL,
2656  UNIQUE KEY `id` (`id`,`world_id`),
2657  KEY `x` (`x`,`y`,`z`),
2658  KEY `house_id` (`house_id`,`world_id`)
2659) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2660
2661--
2662-- Creation: Jul 23, 2014 at 12:49 PM
2663--
2664
2665DROP TABLE IF EXISTS `tile_items`;
2666CREATE TABLE IF NOT EXISTS `tile_items` (
2667  `tile_id` int(10) unsigned NOT NULL,
2668  `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
2669  `sid` int(11) NOT NULL,
2670  `pid` int(11) NOT NULL DEFAULT '0',
2671  `itemtype` int(11) NOT NULL,
2672  `count` int(11) NOT NULL DEFAULT '0',
2673  `attributes` blob NOT NULL,
2674  UNIQUE KEY `tile_id` (`tile_id`,`world_id`,`sid`),
2675  KEY `sid` (`sid`)
2676) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2677
2678--
2679-- RELATIONS FOR TABLE `tile_items`:
2680--   `tile_id`
2681--       `tiles` -> `id`
2682--
2683
2684
2685--
2686-- Table structure for table `z_bug_tracker`
2687--
2688-- Creation: Jul 23, 2014 at 12:49 PM
2689-- Last update: Jul 23, 2014 at 12:49 PM
2690--
2691
2692DROP TABLE IF EXISTS `z_bug_tracker`;
2693CREATE TABLE IF NOT EXISTS `z_bug_tracker` (
2694  `account` varchar(255) NOT NULL,
2695  `type` int(11) NOT NULL,
2696  `status` int(11) NOT NULL,
2697  `text` text NOT NULL,
2698  `id` int(11) NOT NULL,
2699  `subject` varchar(255) NOT NULL,
2700  `reply` int(11) NOT NULL,
2701  `who` int(11) NOT NULL,
2702  `uid` int(11) NOT NULL AUTO_INCREMENT,
2703  `tag` int(11) NOT NULL,
2704  PRIMARY KEY (`uid`)
2705) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
2706
2707-- --------------------------------------------------------
2708
2709--
2710-- Table structure for table `z_changelog`
2711--
2712-- Creation: Jul 23, 2014 at 12:49 PM
2713--
2714
2715DROP TABLE IF EXISTS `z_changelog`;
2716CREATE TABLE IF NOT EXISTS `z_changelog` (
2717  `id` int(11) NOT NULL AUTO_INCREMENT,
2718  `type` varchar(255) NOT NULL DEFAULT '',
2719  `where` varchar(255) NOT NULL DEFAULT '',
2720  `date` int(11) NOT NULL DEFAULT '0',
2721  `description` varchar(255) NOT NULL,
2722  PRIMARY KEY (`id`)
2723) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
2724
2725--
2726-- Dumping data for table `z_changelog`
2727--
2728
2729INSERT INTO `z_changelog` (`id`, `type`, `where`, `date`, `description`) VALUES
2730(1, 'Add', 'Server', 1404417685, 'Anti Random-pk system. Random pking will lead to 1 level loss per kill. If the player fights back, have killed another player, is in a guild-war with'),
2731(2, 'Add', 'Server', 1404417698, 'Vocation balance. Conquerors lowered a bit (anger system), wardens and hunters weapons made better, attack-speed increased. Wardens spears are now 3 r'),
2732(3, 'Add', 'Server', 1404417710, 'Bug fixes, special class spells change from promotions to normal class, to make the game more intresting in the beginning'),
2733(4, 'Add', 'Server', 1404417717, 'Replaced old spawns, bug fixes'),
2734(5, 'Add', 'Server', 1404896362, 'AOL is now functioning properly alongside with Level 100 protection!'),
2735(6, 'Add', 'Website', 1404896432, 'Website is fixed! Ff anything is missing please consider reporting it back through bugtracker, however our Feedback is not working yet!');
2736
2737-- --------------------------------------------------------
2738
2739--
2740-- Table structure for table `z_forum`
2741--
2742-- Creation: Jul 23, 2014 at 12:49 PM
2743--
2744
2745DROP TABLE IF EXISTS `z_forum`;
2746CREATE TABLE IF NOT EXISTS `z_forum` (
2747  `id` int(11) NOT NULL AUTO_INCREMENT,
2748  `first_post` int(11) NOT NULL DEFAULT '0',
2749  `last_post` int(11) NOT NULL DEFAULT '0',
2750  `section` int(3) NOT NULL DEFAULT '0',
2751  `replies` int(20) NOT NULL DEFAULT '0',
2752  `views` int(20) NOT NULL DEFAULT '0',
2753  `author_aid` int(20) NOT NULL DEFAULT '0',
2754  `author_guid` int(20) NOT NULL DEFAULT '0',
2755  `post_text` text NOT NULL,
2756  `post_topic` varchar(255) NOT NULL,
2757  `post_smile` tinyint(1) NOT NULL DEFAULT '0',
2758  `post_date` int(20) NOT NULL DEFAULT '0',
2759  `last_edit_aid` int(20) NOT NULL DEFAULT '0',
2760  `edit_date` int(20) NOT NULL DEFAULT '0',
2761  `post_ip` varchar(15) NOT NULL DEFAULT '0.0.0.0',
2762  PRIMARY KEY (`id`),
2763  KEY `section` (`section`)
2764) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
2765
2766--
2767-- Dumping data for table `z_forum`
2768--
2769
2770INSERT INTO `z_forum` (`id`, `first_post`, `last_post`, `section`, `replies`, `views`, `author_aid`, `author_guid`, `post_text`, `post_topic`, `post_smile`, `post_date`, `last_edit_aid`, `edit_date`, `post_ip`) VALUES
2771(6, 6, 1405512115, 1, 0, 46, 1147766, 6, '<center><a href="http://s47.photobucket.com/user/Mizo_47/media/Grand-OT%20a%20Roxor%20combination/Grandot.png.html" target="_blank"><img src="http://i47.photobucket.com/albums/f193/Mizo_47/Grand-OT%20a%20Roxor%20combination/Grandot.png" border="0" alt=" photo Grandot.png"/></a>\r\n\r\n</br><b>#1: The Temple</b> - Here you will find all the shops you need. A low-level start-area is located below the temple. In the upper floors, you will find teleports leading to different places, such as the casino, the race-shop and the PvP-arena. The Queen is located on the roof, and this is where you choose your race and get promoted.\r\n</br></br><b>#2: Teleport-room</b> - All semi-hard monsters are located here, and you will find everything from dragons and demons to humanoids and custom monsters. Keep in mind that the stronger monsters and the boss-monsters are located in separate places around the map, and not in the teleport-room.\r\n</br></br><b>#3: Quest-Room</b> - All the quests (except 2 extremly hard high-level quests) are located here. All those quests are linked with the webpage, so all the quests you complete here, will show as completed on your character-information.\r\n</br></br><b>#4: The Depot</b> - Depots in the main floor, training-monks below.\r\n</br></br><b>#5: PvP-Cross</b> - Mainly an area for wars. Many raids are spawning in this area. Below, you will find the Bomb-mines, where you can dig and create powerful bombs.\r\n</br></br><b>#6: Boss-Castle</b> - Here, the bosses are located. Only those who have chosen their race can enter here. All bosses are marked with a red skull. A bit to the left, you will find the advanced quest-room, which contains the 2 most advanced quest in-game.\r\n</br></br><b>#7: Woods</b> - Huge area which only those who have chosen their race can enter to. Underground you will find the best hunting-places in-game, so as a high-level, you should level in the woods, and not in the teleport-room. Good war-area with a lot of possibilities. Leads to the small villages around the map and also some small quests.\r\n</br></br><b>#8: Southern Village</b> - Big village with alot of small, but very detailed houses. Plenty of depots and shops.\r\n</br></br><b>#9: Ferumbras Street</b> - Few houses and shops are located here. Only promoted players can enter, and underground you will find the home of the Ferumbras.\r\n</br></br><b>#10: The Guild-Hall</b> - The only guild-hall in-game. Very expensive, but if you have a strong guild with good economy, this is a must!\r\n</br></br><b>#11: Darkshadow Keep</b> - A small keep with different shops and a few depot-lockers. A few houses are located here, and usually a group of friends tries to conquer this keep by buying all the houses.\r\n</br></br><b>#12: Gold-shire Village</b> - Huge village surrounded by castle-walls and water. Many houses and shops. North-east, you will find the Castle of Kings while you must enter the underground to find the depots.\r\n</br></br><b>#13: Mountains of Evil</b> - Evil creatures has taken over these mountains. You are advised to stay away.\r\n</br></br><b>#14: Donation-Island</b> - As a thank for a donation, you can own this island. A big castle will be yours, with NPCs, training-monks and hunting grounds.\r\n</br></br><b>#15: Northwind Village</b> - A small village up in the north. Shops, depots and houses are what you will find here. Further north, you will find some hunting-grounds for high-levels.\r\n</br></br><b>#16: Northwind Caves</b> - Different caves. Mainly consisting of Yetis, Ice Witches and Senior Frost-dragons.\r\n</br></br><b>#17: The Boat</b> - Steer the boat through the icy water to get to the Northwind Village. </br></br></center>', 'Custom Map', 0, 1405512115, 1147766, 1408284074, '::1'),
2772(7, 7, 1406759888, 5, 0, 26, 1147766, 6, 'You got bored from playing GrandOT? Tell us why\r\nYou found bugs that people abuse, or normal bugs? Report them and earn rewards!', 'Feeling bored?!', 0, 1406759888, 0, 0, '41.130.213.100'),
2773(8, 8, 1407118963, 1, 0, 31, 1147766, 6, '<br><center><img src="http://grand-ot.com/images/LETTERS/C.GIF" alt="Just in case" title="Tooltip"/>urrently we are upgrading to 8.60 version, which gives the server even more stability!!\r\nIf it is the OT''s version that stopping you from playing, don''t worry anymore, you can start leveling already while we upgrade to 8.60, stay tuned!!!</center>', 'Upgrading to 8.60', 0, 1407118963, 1147766, 1407823160, '196.205.190.249'),
2774(9, 9, 1407757668, 3, 0, 4, 9601816, 158, 'We need to hook up and do some of the group hunting quests.', 'Infamous!', 0, 1407757668, 0, 0, '24.67.157.88'),
2775(10, 10, 1407780603, 1, 0, 16, 1147766, 6, '<br>\r\n<center><img src="http://grand-ot.com/images/LETTERS/W.GIF" alt="Just in case" title="Tooltip"/>e are about to increase the maximum level before starting your PVP-E journey to <b>420</b>, stay tuned!</center>', 'Maximum level?', 0, 1407780603, 1147766, 1407884528, '41.130.232.65'),
2776(12, 12, 1408280504, 1, 0, 11, 1147766, 6, '<br><center><img src="http://grand-ot.com/images/LETTERS/R.GIF" alt="R" title="Tooltip"/>andom pk-ing will lead to 1 level loss per kill. \r\nIf the player fights back, killed another player, is in a guild-war with you, is in an event or is fighting for the castle, you will of course not lose any levels.</center>', 'Anti Random-pk system.', 0, 1408280504, 1147766, 1408280641, '196.205.190.93'),
2777(13, 13, 1408324398, 5, 0, 3, 9230957, 15, '~ I created this account when this server first started up and I just checked my account and it says my characters name is (Hamed) and that is not what my characters name was originally. I don''t know what''s going on, but i''m confused.', 'Hamed is my name???', 0, 1408324398, 0, 0, '98.93.240.176'),
2778(14, 14, 1408434489, 1, 0, 9, 1147766, 6, '<br>\r\n\r\n<center><img src="http://grand-ot.com/images/LETTERS/W.GIF" alt="W" title="Tooltip"/>e have added a new VIP-City, full with hunting spots and quests to do, all rares, we made sure to make everything balanced, so there''s no advantage to those who purchase premium days in relation with being "Over powered", everything is mixed in a balanced way, and if you have any complain just put it in a !report, enjoy the new update!</center>', 'Version 8.5.1', 0, 1408434489, 1147766, 1408434542, '41.196.141.225'),
2779(15, 15, 1408509794, 1, 0, 11, 1147766, 6, '<br>\r\n<center><img src="http://grand-ot.com/images/LETTERS/S.GIF" alt="S" title="Tooltip"/>ince we updated the server 2 days ago, we thought of updating the website as well, enjoy the full-detailed website which includes almost all information regarding how to survive on Grand-OT.\r\n<br>\r\n<img src="http://grand-ot.com/images/LETTERS/w.GIF" alt="W" title="Tooltip"/>e are moving our data center a.k.a Dedicated server to a more stable and secure place. European players, it is the time to play on a Lag-free server!, and to the USA players, you''re not affected by this, keep the smile coming!\r\n</center>', 'Updates and moving to new Data center!', 0, 1408509794, 1147766, 1408552473, '41.130.235.197');
2780
2781-- --------------------------------------------------------
2782
2783--
2784-- Table structure for table `z_monsters`
2785--
2786-- Creation: Jul 23, 2014 at 12:49 PM
2787-- Last update: Jul 23, 2014 at 12:49 PM
2788--
2789
2790DROP TABLE IF EXISTS `z_monsters`;
2791CREATE TABLE IF NOT EXISTS `z_monsters` (
2792  `hide_creature` tinyint(1) NOT NULL DEFAULT '0',
2793  `name` varchar(255) NOT NULL,
2794  `mana` int(11) NOT NULL,
2795  `exp` int(11) NOT NULL,
2796  `health` int(11) NOT NULL,
2797  `speed_lvl` int(11) NOT NULL DEFAULT '1',
2798  `use_haste` tinyint(1) NOT NULL,
2799  `voices` text NOT NULL,
2800  `immunities` varchar(255) NOT NULL,
2801  `summonable` tinyint(1) NOT NULL,
2802  `convinceable` tinyint(1) NOT NULL,
2803  `race` varchar(255) NOT NULL,
2804  `gfx_name` varchar(255) NOT NULL
2805) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2806
2807-- --------------------------------------------------------
2808
2809--
2810-- Table structure for table `z_news_big`
2811--
2812-- Creation: Jul 23, 2014 at 12:49 PM
2813-- Last update: Jul 23, 2014 at 12:49 PM
2814--
2815
2816DROP TABLE IF EXISTS `z_news_big`;
2817CREATE TABLE IF NOT EXISTS `z_news_big` (
2818  `hide_news` tinyint(1) NOT NULL DEFAULT '0',
2819  `date` int(11) NOT NULL DEFAULT '0',
2820  `author` varchar(255) NOT NULL,
2821  `author_id` int(11) NOT NULL,
2822  `image_id` int(3) NOT NULL DEFAULT '0',
2823  `topic` varchar(255) NOT NULL,
2824  `text` text NOT NULL
2825) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2826
2827-- --------------------------------------------------------
2828
2829--
2830-- Table structure for table `z_news_tickers`
2831--
2832-- Creation: Jul 23, 2014 at 12:49 PM
2833-- Last update: Jul 23, 2014 at 12:50 PM
2834--
2835
2836DROP TABLE IF EXISTS `z_news_tickers`;
2837CREATE TABLE IF NOT EXISTS `z_news_tickers` (
2838  `date` int(11) NOT NULL DEFAULT '1',
2839  `author` int(11) NOT NULL,
2840  `image_id` int(3) NOT NULL DEFAULT '0',
2841  `text` text NOT NULL,
2842  `hide_ticker` tinyint(1) NOT NULL
2843) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2844
2845--
2846-- Dumping data for table `z_news_tickers`
2847--
2848
2849INSERT INTO `z_news_tickers` (`date`, `author`, `image_id`, `text`, `hide_ticker`) VALUES
2850(1404848454, 1, 1, 'Grand-OT is officially online, please report any bugs!', 0);
2851
2852-- --------------------------------------------------------
2853
2854--
2855-- Table structure for table `z_ots_comunication`
2856--
2857-- Creation: Jul 23, 2014 at 12:49 PM
2858-- Last update: Aug 20, 2014 at 04:46 PM
2859-- Last check: Aug 20, 2014 at 01:43 PM
2860--
2861
2862DROP TABLE IF EXISTS `z_ots_comunication`;
2863CREATE TABLE IF NOT EXISTS `z_ots_comunication` (
2864  `id` int(11) NOT NULL AUTO_INCREMENT,
2865  `name` varchar(255) NOT NULL,
2866  `type` varchar(255) NOT NULL,
2867  `action` varchar(255) NOT NULL,
2868  `param1` varchar(255) NOT NULL,
2869  `param2` varchar(255) NOT NULL,
2870  `param3` varchar(255) NOT NULL,
2871  `param4` varchar(255) NOT NULL,
2872  `param5` varchar(255) NOT NULL,
2873  `param6` varchar(255) NOT NULL,
2874  `param7` varchar(255) NOT NULL,
2875  `delete_it` int(2) NOT NULL DEFAULT '1',
2876  PRIMARY KEY (`id`)
2877) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=141 ;
2878
2879-- --------------------------------------------------------
2880
2881--
2882-- Table structure for table `z_polls`
2883--
2884-- Creation: Jul 23, 2014 at 12:49 PM
2885-- Last update: Jul 23, 2014 at 12:50 PM
2886--
2887
2888DROP TABLE IF EXISTS `z_polls`;
2889CREATE TABLE IF NOT EXISTS `z_polls` (
2890  `id` int(11) NOT NULL AUTO_INCREMENT,
2891  `question` varchar(255) NOT NULL,
2892  `end` int(11) NOT NULL,
2893  `start` int(11) NOT NULL,
2894  `answers` int(11) NOT NULL,
2895  `votes_all` int(11) NOT NULL,
2896  PRIMARY KEY (`id`)
2897) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
2898
2899
2900
2901-- --------------------------------------------------------
2902
2903--
2904-- Table structure for table `z_polls_answers`
2905--
2906-- Creation: Jul 23, 2014 at 12:49 PM
2907-- Last update: Jul 23, 2014 at 12:50 PM
2908--
2909
2910DROP TABLE IF EXISTS `z_polls_answers`;
2911CREATE TABLE IF NOT EXISTS `z_polls_answers` (
2912  `poll_id` int(11) NOT NULL,
2913  `answer_id` int(11) NOT NULL,
2914  `answer` varchar(255) NOT NULL,
2915  `votes` int(11) NOT NULL
2916) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2917
2918--
2919-- Dumping data for table `z_polls_answers`
2920--
2921
2922INSERT INTO `z_polls_answers` (`poll_id`, `answer_id`, `answer`, `votes`) VALUES
2923(1, 1, 'INDEED!', 0),
2924(1, 2, 'Just, no!', 0),
2925(1, 1, 'INDEED!', 0),
2926(1, 2, 'Just, no!', 0);
2927
2928-- --------------------------------------------------------
2929
2930--
2931-- Table structure for table `z_shop_history_item`
2932--
2933-- Creation: Jul 23, 2014 at 12:49 PM
2934-- Last update: Aug 20, 2014 at 04:46 PM
2935--
2936
2937DROP TABLE IF EXISTS `z_shop_history_item`;
2938CREATE TABLE IF NOT EXISTS `z_shop_history_item` (
2939  `id` int(11) NOT NULL AUTO_INCREMENT,
2940  `to_name` varchar(255) NOT NULL DEFAULT '0',
2941  `to_account` int(11) NOT NULL DEFAULT '0',
2942  `from_nick` varchar(255) NOT NULL,
2943  `from_account` int(11) NOT NULL DEFAULT '0',
2944  `price` int(11) NOT NULL DEFAULT '0',
2945  `offer_id` int(11) NOT NULL DEFAULT '0',
2946  `trans_state` varchar(255) NOT NULL,
2947  `trans_start` int(11) NOT NULL DEFAULT '0',
2948  `trans_real` int(11) NOT NULL DEFAULT '0',
2949  PRIMARY KEY (`id`)
2950) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=141 ;
2951
2952
2953-- --------------------------------------------------------
2954
2955--
2956-- Table structure for table `z_shop_history_pacc`
2957--
2958-- Creation: Jul 23, 2014 at 12:49 PM
2959-- Last update: Jul 23, 2014 at 12:49 PM
2960--
2961
2962DROP TABLE IF EXISTS `z_shop_history_pacc`;
2963CREATE TABLE IF NOT EXISTS `z_shop_history_pacc` (
2964  `id` int(11) NOT NULL AUTO_INCREMENT,
2965  `to_name` varchar(255) NOT NULL DEFAULT '0',
2966  `to_account` int(11) NOT NULL DEFAULT '0',
2967  `from_nick` varchar(255) NOT NULL,
2968  `from_account` int(11) NOT NULL DEFAULT '0',
2969  `price` int(11) NOT NULL DEFAULT '0',
2970  `pacc_days` int(11) NOT NULL DEFAULT '0',
2971  `trans_state` varchar(255) NOT NULL,
2972  `trans_start` int(11) NOT NULL DEFAULT '0',
2973  `trans_real` int(11) NOT NULL DEFAULT '0',
2974  PRIMARY KEY (`id`)
2975) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
2976
2977-- --------------------------------------------------------
2978
2979--
2980-- Table structure for table `z_shop_offer`
2981--
2982-- Creation: Jul 23, 2014 at 12:49 PM
2983-- Last update: Aug 19, 2014 at 08:51 AM
2984--
2985
2986DROP TABLE IF EXISTS `z_shop_offer`;
2987CREATE TABLE IF NOT EXISTS `z_shop_offer` (
2988  `id` int(11) NOT NULL AUTO_INCREMENT,
2989  `points` int(11) NOT NULL DEFAULT '0',
2990  `itemid1` int(11) NOT NULL DEFAULT '0',
2991  `count1` int(11) NOT NULL DEFAULT '0',
2992  `itemid2` int(11) NOT NULL DEFAULT '0',
2993  `count2` int(11) NOT NULL DEFAULT '0',
2994  `offer_type` varchar(255) DEFAULT NULL,
2995  `offer_description` text NOT NULL,
2996  `offer_name` varchar(255) NOT NULL,
2997  `pid` int(11) NOT NULL DEFAULT '0',
2998  PRIMARY KEY (`id`)
2999) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;
3000
3001--
3002-- Dumping data for table `z_shop_offer`
3003--
3004
3005INSERT INTO `z_shop_offer` (`id`, `points`, `itemid1`, `count1`, `itemid2`, `count2`, `offer_type`, `offer_description`, `offer_name`, `pid`) VALUES
3006(1, 10, 7425, 1, 0, 0, 'item', 'Best Club for Conquerors 103 in attack, 45 in defense. It has an extra death-attack which can deal magnificent ammount of extra damage.', 'Conquerors Taurus Mace', 0),
3007(2, 10, 2445, 1, 0, 0, 'item', 'Best club for Guardians 65 in attack, 65 in defense.', 'Guardians Crystal Mace', 0),
3008(3, 10, 8926, 1, 0, 0, 'item', 'Best Axe for Conquerors 103 in attack, 45 in defense. It has an extra ice-attack which can deal magnificent ammount of extra damage.', 'Conquerors Iced Halberd', 0),
3009(4, 10, 7405, 1, 0, 0, 'item', 'Best Sword for Conquerors 103 in attack, 45 in defense. It has an extra energy-attack which can deal magnificent ammount of extra damage.', 'Conquerors Havoc Blade', 0),
3010(5, 10, 7435, 1, 0, 0, 'item', 'Best Axe for Guardians 65 in attack, 65 in defense.', 'Guardians Splitter Axe', 0),
3011(6, 10, 2446, 1, 0, 0, 'item', 'Best Sword for Guardians 65 in attack, 65 in defense.', 'Guardians Pharaoh Sword', 0),
3012(7, 10, 7367, 1, 0, 0, 'item', 'Best weapon for Wardens Spear with 140 attacking dammage.', 'Wardens enchanted spear', 0),
3013(8, 10, 8857, 1, 0, 0, 'item', 'Best weapon for Hunters 26% extra hit-chance. 26 extra attack on your ammunition and 9 range.', 'Hunters Silkweaver Bow', 0),
3014(9, 10, 2184, 1, 0, 0, 'item', 'Best weapon for Druids This wand will deal up to 600 damage against monsters, and 300 on players.', 'Druids Crystal Wand', 0),
3015(10, 15, 8890, 1, 0, 0, 'item', 'Best armor for Sorcerers. Gives more speed, 18 magic levels and more mana-regain.', 'Sorcerers Robe of the Underworld', 0),
3016(11, 15, 8891, 1, 0, 0, 'item', 'Best armor for Hunters Gives more speed, 15 distance skills, more mana regain and 20% more max mana.', 'Hunters Paladin Armor', 0),
3017(12, 15, 2486, 1, 0, 0, 'item', 'Best armor for Conquerors Gives alot of speed and 32 extra melee skills. (all types)', 'Conquerors Noble Armor', 0),
3018(13, 15, 8886, 1, 0, 0, 'item', 'Best armor for Guardians Gives 20 shielding skills, 15% protection against all elements and 30% more max health.', 'Guardians Molten Plate', 0),
3019(14, 15, 8868, 1, 0, 0, 'item', 'Best armor for Druids Gives more mana regain, 15 magic levels and 40% more max mana.', 'Druids Wise Cape', 0),
3020(15, 15, 8880, 1, 0, 0, 'item', 'Best armor for Wardens Gives 21 distance skills, 20% more max mana and 20% more max health.', 'Wardens Swamplair Armor', 0),
3021(16, 5, 8905, 1, 0, 0, 'item', 'Best shield for Guardians 60 in defense, and 15% protection against all elements.', 'Guardians Rainbow Shield', 0),
3022(17, 5, 8902, 1, 0, 0, 'item', 'Best weapon for Sorcerers Adds 15 magic-levels.', 'Sorcerers Spellbook of Mind Control', 0),
3023(18, 5, 2196, 99999999, 0, 0, 'item', 'This amulet prevents all loot-drop on death, and lasts forever!', 'Forever Amulet of Loss', 0),
3024(19, 3, 2160, 100, 0, 0, 'item', '100x Crystal Coins', '100x Crystal Coins', 0),
3025(21, 10, 7727, 1, 0, 0, 'item', 'Teleports you to your registered Temple.', 'Teleportation Scroll', 0),
3026(22, 7, 6132, 1, 0, 0, 'item', 'Soft Boots, faster regeneration.', 'Soft Boots', 0),
3027(23, 4, 10518, 1, 0, 0, 'item', 'Demon Backpack (36 slots)', 'Demon Backpack (36 Slots)', 0),
3028(24, 7, 5941, 1, 0, 0, 'item', 'Sex Changer (Use on yourself, one time only)', 'Sex Changer', 0),
3029(25, 7, 2319, 1, 0, 0, 'item', '15 Days Premium.. (Access VIP-City, full of hunting spots, massive teleport room) *Click on item to activate* *VIP Teleport is located between 2 Yalahari statues east of Main temple*', '15 Premium Days', 0),
3030(26, 12, 5785, 1, 0, 0, 'item', '30 Days Premium.. (Access VIP-City, full of hunting spots, massive teleport room) *Click on item to activate*\r\n\r\n*VIP Teleport is located between 2 Yalahari statues east of Main temple*', '30 Days Premium', 0),
3031(27, 23, 9693, 1, 0, 0, 'item', 'Get all addons in a single doll-click!', 'Addon Doll', 0);
3032
3033-- --------------------------------------------------------
3034
3035--
3036-- Table structure for table `z_spells`
3037--
3038-- Creation: Jul 23, 2014 at 12:49 PM
3039-- Last update: Jul 23, 2014 at 01:17 PM
3040--
3041
3042DROP TABLE IF EXISTS `z_spells`;
3043CREATE TABLE IF NOT EXISTS `z_spells` (
3044  `name` varchar(255) NOT NULL,
3045  `spell` varchar(255) NOT NULL,
3046  `spell_type` varchar(255) NOT NULL,
3047  `mana` int(11) NOT NULL DEFAULT '0',
3048  `lvl` int(11) NOT NULL DEFAULT '0',
3049  `mlvl` int(11) NOT NULL DEFAULT '0',
3050  `soul` int(11) NOT NULL DEFAULT '0',
3051  `pacc` varchar(255) NOT NULL,
3052  `vocations` varchar(255) NOT NULL,
3053  `conj_count` int(11) NOT NULL DEFAULT '0',
3054  `hide_spell` int(11) NOT NULL DEFAULT '0'
3055) ENGINE=MyISAM DEFAULT CHARSET=latin1;
3056
3057--
3058-- Dumping data for table `z_spells`
3059--
3060
3061INSERT INTO `z_spells` (`name`, `spell`, `spell_type`, `mana`, `lvl`, `mlvl`, `soul`, `pacc`, `vocations`, `conj_count`, `hide_spell`) VALUES
3062('Conjure Arrow', 'exevo con', 'conjure', 100, 13, 0, 1, 'no', '', 10, 0),
3063('Food', 'exevo pan', 'conjure', 120, 14, 0, 1, 'no', '', 0, 0),
3064('Poisoned Arrow', 'exevo con pox', 'conjure', 130, 16, 0, 2, 'no', '', 7, 0),
3065('Conjure Bolt', 'exevo con mort', 'conjure', 140, 17, 0, 2, 'no', '', 5, 0),
3066('Conjure Sniper Arrow', 'exevo con hur', 'conjure', 160, 24, 0, 3, 'no', '', 5, 0),
3067('Explosive Arrow', 'exevo con flam', 'conjure', 290, 25, 0, 3, 'no', '', 8, 0),
3068('Conjure Piercing Bolt', 'exevo con grav', 'conjure', 180, 33, 0, 3, 'no', '', 5, 0),
3069('Enchant Staff', 'exeta vis', 'conjure', 80, 41, 0, 0, 'no', '', 0, 0),
3070('Poison Field', 'adevo grav pox', 'conjure', 200, 14, 0, 1, 'no', '', 3, 0),
3071('Light Magic Missile', 'adori min vis', 'conjure', 120, 15, 0, 1, 'no', '', 10, 0),
3072('Fire Field', 'adevo grav flam', 'conjure', 4000, 15, 0, 1, 'no', '', 2, 0),
3073('Fireball', 'adori flam', 'conjure', 460, 27, 0, 3, 'no', '', 5, 0),
3074('Energy Field', 'adevo grav vis', 'conjure', 320, 18, 0, 2, 'no', '', 3, 0),
3075('Stalagmite', 'adori tera', 'conjure', 400, 24, 0, 2, 'no', '', 10, 0),
3076('Great Fireball', 'adori mas flam', 'conjure', 530, 30, 0, 3, 'no', '', 4, 0),
3077('Heavy Magic Missile', 'adori vis', 'conjure', 350, 25, 0, 2, 'no', '', 10, 0),
3078('Poison Bomb', 'adevo mas pox', 'conjure', 520, 25, 0, 2, 'no', '', 2, 0),
3079('Firebomb', 'adevo mas flam', 'conjure', 8000, 27, 0, 4, 'no', '', 2, 0),
3080('Soulfire', 'adevo res flam', 'conjure', 600, 27, 0, 3, 'no', '', 3, 0),
3081('Poison Wall', 'adevo mas grav pox', 'conjure', 640, 29, 0, 3, 'no', '', 4, 0),
3082('Explosion', 'adevo mas hur', 'conjure', 570, 31, 0, 4, 'no', '', 6, 0),
3083('Fire Wall', 'adevo mas grav flam', 'conjure', 780, 33, 0, 4, 'no', '', 4, 0),
3084('Energybomb', 'adevo mas vis', 'conjure', 880, 37, 0, 5, 'no', '', 2, 0),
3085('Energy Wall', 'adevo mas grav vis', 'conjure', 1000, 41, 0, 5, 'no', '', 4, 0),
3086('Sudden Death', 'adori gran mort', 'conjure', 985, 45, 0, 5, 'no', '', 3, 0),
3087('Antidote Rune', 'adana pox', 'conjure', 200, 15, 0, 1, 'no', '', 1, 0),
3088('Intense Healing Rune', 'adura gran', 'conjure', 240, 15, 0, 2, 'no', '', 1, 0),
3089('Ultimate Healing Rune', 'adura vita', 'conjure', 400, 24, 0, 3, 'no', '', 1, 0),
3090('Convince Creature', 'adeta sio', 'conjure', 200, 16, 0, 3, 'no', '', 1, 0),
3091('Animate Dead', 'adana mort', 'conjure', 600, 27, 0, 5, 'no', '', 1, 0),
3092('Chameleon', 'adevo ina', 'conjure', 600, 27, 0, 2, 'no', '', 1, 0),
3093('Destroy Field', 'adito grav', 'conjure', 120, 17, 0, 2, 'no', '', 3, 0),
3094('Desintegrate', 'adito tera', 'conjure', 200, 21, 0, 3, 'no', '', 3, 0),
3095('Magic Wall', 'adevo grav tera', 'conjure', 750, 32, 0, 5, 'no', '', 3, 0),
3096('Wild Growth', 'adevo grav vita', 'conjure', 600, 27, 0, 5, 'no', '', 2, 0),
3097('Paralyze', 'adana ani', 'conjure', 1400, 54, 0, 3, 'no', '', 1, 0),
3098('Avalanche', 'adori mas frigo', 'conjure', 530, 30, 0, 3, 'no', '', 4, 0),
3099('Stone Shower', 'adori mas tera', 'conjure', 430, 28, 0, 3, 'no', '', 4, 0),
3100('Thunderstorm', 'adori mas vis', 'conjure', 430, 28, 0, 3, 'no', '', 4, 0),
3101('Blank Rune', 'adori blank', 'instant', 50, 1, 1, 0, 'no', '', 0, 0),
3102('Death Strike', 'exori mort', 'instant', 20, 16, 0, 0, 'no', '', 0, 0),
3103('Flame Strike', 'exori flam', 'instant', 20, 12, 0, 0, 'no', '', 0, 0),
3104('Energy Strike', 'exori vis', 'instant', 20, 12, 0, 0, 'no', '', 0, 0),
3105('Whirlwind Throw', 'exori hur', 'instant', 40, 15, 0, 0, 'no', '', 0, 0),
3106('Fire Wave', 'exevo flam hur', 'instant', 25, 30, 0, 0, 'no', '', 0, 0),
3107('Ethereal Spear', 'exori con', 'instant', 35, 23, 0, 0, 'no', '', 0, 0),
3108('Energy Beam', 'exevo vis lux', 'instant', 40, 23, 0, 0, 'no', '', 0, 0),
3109('Great Energy Beam', 'exevo gran vis lux', 'instant', 110, 29, 0, 0, 'no', '', 0, 0),
3110('Groundshaker', 'exori mas', 'instant', 160, 33, 0, 0, 'no', '', 0, 0),
3111('Berserk', 'exori', 'instant', 115, 30, 0, 0, 'no', '', 0, 0),
3112('Energy Wave', 'exevo mort hur', 'instant', 200, 38, 0, 0, 'no', '', 0, 0),
3113('Rage of the Skies', 'exevo gran mas vis', 'instant', 650, 55, 0, 0, 'no', '', 0, 0),
3114('Fierce Berserk', 'exori gran', 'instant', 0, 70, 0, 0, 'no', '', 0, 0),
3115('Hells Core', 'exevo gran mas flam', 'instant', 1200, 60, 0, 0, 'no', '', 0, 0),
3116('Divine Missile', 'exori san', 'instant', 20, 30, 0, 0, 'no', '', 0, 0),
3117('Divine Wave', 'exori san hur', 'instant', 350, 100, 0, 0, 'no', '', 0, 0),
3118('Divine Caldera', 'exevo mas san', 'instant', 160, 50, 0, 0, 'no', '', 0, 0),
3119('Ice Strike', 'exori frigo', 'instant', 20, 15, 0, 0, 'no', '', 0, 0),
3120('Ice Wave', 'exevo frigo hur', 'instant', 25, 30, 0, 0, 'no', '', 0, 0),
3121('Terra Strike', 'exori tera', 'instant', 20, 13, 0, 0, 'no', '', 0, 0),
3122('Terra Wave', 'exevo tera hur', 'instant', 200, 38, 0, 0, 'no', '', 0, 0),
3123('Light Healing', 'exura', 'instant', 25, 9, 0, 0, 'no', '', 0, 0),
3124('Antidote', 'exana pox', 'instant', 30, 10, 0, 0, 'no', '', 0, 0),
3125('Intense Healing', 'exura gran', 'instant', 70, 11, 0, 0, 'no', '', 0, 0),
3126('Heal Friend', 'exura sio', 'instant', 300, 18, 0, 0, 'no', '', 0, 0),
3127('Heal Mana Friend', 'mana sio', 'instant', 400, 18, 0, 0, 'no', '', 0, 0),
3128('Ultimate Healing', 'exura vita', 'instant', 160, 20, 0, 0, 'no', '', 0, 0),
3129('Mass Healing', 'exura gran mas res', 'instant', 0, 100, 0, 0, 'no', '', 0, 0),
3130('Mass Mana', 'exura gran mas mana', 'instant', 500, 36, 0, 0, 'no', '', 0, 0),
3131('Divine Healing', 'exura san', 'instant', 210, 35, 0, 0, 'no', '', 0, 0),
3132('Wound Cleansing', 'exana mort', 'instant', 65, 30, 0, 0, 'no', '', 0, 0),
3133('Light', 'utevo lux', 'instant', 20, 8, 0, 0, 'no', '', 0, 0),
3134('Magic Rope', 'exani tera', 'instant', 20, 9, 0, 0, 'no', '', 0, 0),
3135('Levitate', 'exani hur', 'instant', 200, 50, 0, 0, 'no', '', 0, 0),
3136('Great Light', 'utevo gran lux', 'instant', 60, 13, 0, 0, 'no', '', 0, 0),
3137('Magic Shield', 'utamo vita', 'instant', 50, 14, 0, 0, 'no', '', 0, 0),
3138('Haste', 'utani hur', 'instant', 60, 14, 0, 0, 'no', '', 0, 0),
3139('Charge', 'utani tempo hur', 'instant', 100, 25, 0, 0, 'no', '', 0, 0),
3140('Challenge', 'exeta res', 'instant', 30, 20, 0, 0, 'no', '', 0, 0),
3141('Strong Haste', 'utani gran hur', 'instant', 100, 20, 0, 0, 'no', '', 0, 0),
3142('Creature Illusion', 'utevo res ina', 'instant', 100, 23, 0, 0, 'no', '', 0, 0),
3143('Ultimate Light', 'utevo vis lux', 'instant', 140, 26, 0, 0, 'no', '', 0, 0),
3144('Wild Growth', 'exevo grav vita', 'instant', 350, 27, 0, 0, 'no', '', 0, 0),
3145('Protector', 'utamo tempo', 'instant', 200, 55, 0, 0, 'no', '', 0, 0),
3146('Blood Rage', 'utito tempo', 'instant', 290, 60, 0, 0, 'no', '', 0, 0),
3147('Train Party', 'utito mas sio', 'instant', 0, 100, 0, 0, 'no', '', 0, 0),
3148('Protect Party', 'utamo mas sio', 'instant', 0, 100, 0, 0, 'no', '', 0, 0),
3149('Heal Party', 'utura mas sio', 'instant', 0, 100, 0, 0, 'no', '', 0, 0),
3150('Enchant Party', 'utori mas sio', 'instant', 0, 100, 0, 0, 'no', '', 0, 0),
3151('Summon Creature', 'utevo res', 'instant', 0, 25, 0, 0, 'no', '', 0, 0),
3152('Undead Legion', 'exana mas mort', 'instant', 500, 30, 0, 0, 'no', '', 0, 0),
3153('Apocalypse', 'exevo mas lux', 'instant', 0, 40, 0, 0, 'no', '', 0, 0),
3154('Demonic Area', 'exevo mas mort', 'instant', 0, 100, 0, 0, 'no', '', 0, 0),
3155('Death Flames', 'exevo mas mort flam', 'instant', 0, 100, 1, 0, 'no', '', 0, 0),
3156('Stay Away', 'exori gran mas mort', 'instant', 0, 100, 1, 0, 'no', '', 0, 0),
3157('Untouchable', 'exori defendo', 'instant', 0, 100, 1, 0, 'no', '', 0, 0),
3158('Refero', 'exori refero', 'instant', 0, 100, 1, 0, 'no', '', 0, 0),
3159('Damage Reflection', 'utamo mort', 'instant', 0, 100, 1, 0, 'no', '', 0, 0),
3160('Holy Death', 'exevo gran mas san', 'instant', 0, 100, 1, 0, 'no', '', 0, 0),
3161('Holy Paralyze', 'utana ani', 'instant', 0, 100, 1, 0, 'no', '', 0, 0),
3162('Holy Cammoflauge', 'utana camo', 'instant', 500, 100, 1, 0, 'no', '', 0, 0),
3163('Cancel Invisibility', 'utana ina', 'instant', 100, 100, 0, 0, 'no', '', 0, 0),
3164('Invisibility', 'utana vid', 'instant', 0, 100, 0, 0, 'no', '', 0, 0);
3165
3166--
3167-- Constraints for dumped tables
3168--
3169
3170--
3171-- Constraints for table `account_viplist`
3172--
3173ALTER TABLE `account_viplist`
3174  ADD CONSTRAINT `account_viplist_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
3175  ADD CONSTRAINT `account_viplist_ibfk_2` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
3176
3177--
3178-- Constraints for table `environment_killers`
3179--
3180ALTER TABLE `environment_killers`
3181  ADD CONSTRAINT `environment_killers_ibfk_1` FOREIGN KEY (`kill_id`) REFERENCES `killers` (`id`) ON DELETE CASCADE;
3182
3183--
3184-- Constraints for table `guild_invites`
3185--
3186ALTER TABLE `guild_invites`
3187  ADD CONSTRAINT `guild_invites_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE,
3188  ADD CONSTRAINT `guild_invites_ibfk_2` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;
3189
3190--
3191-- Constraints for table `guild_ranks`
3192--
3193ALTER TABLE `guild_ranks`
3194  ADD CONSTRAINT `guild_ranks_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;
3195
3196--
3197-- Constraints for table `house_auctions`
3198--
3199ALTER TABLE `house_auctions`
3200  ADD CONSTRAINT `house_auctions_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE,
3201  ADD CONSTRAINT `house_auctions_ibfk_2` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
3202
3203--
3204-- Constraints for table `house_data`
3205--
3206ALTER TABLE `house_data`
3207  ADD CONSTRAINT `house_data_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE;
3208
3209--
3210-- Constraints for table `house_lists`
3211--
3212ALTER TABLE `house_lists`
3213  ADD CONSTRAINT `house_lists_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE;
3214
3215--
3216-- Constraints for table `killers`
3217--
3218ALTER TABLE `killers`
3219  ADD CONSTRAINT `killers_ibfk_1` FOREIGN KEY (`death_id`) REFERENCES `player_deaths` (`id`) ON DELETE CASCADE;
3220
3221--
3222-- Constraints for table `players`
3223--
3224ALTER TABLE `players`
3225  ADD CONSTRAINT `players_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE;
3226
3227--
3228-- Constraints for table `player_deaths`
3229--
3230ALTER TABLE `player_deaths`
3231  ADD CONSTRAINT `player_deaths_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
3232
3233--
3234-- Constraints for table `player_depotitems`
3235--
3236ALTER TABLE `player_depotitems`
3237  ADD CONSTRAINT `player_depotitems_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
3238
3239--
3240-- Constraints for table `player_items`
3241--
3242ALTER TABLE `player_items`
3243  ADD CONSTRAINT `player_items_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
3244
3245--
3246-- Constraints for table `player_killers`
3247--
3248ALTER TABLE `player_killers`
3249  ADD CONSTRAINT `player_killers_ibfk_1` FOREIGN KEY (`kill_id`) REFERENCES `killers` (`id`) ON DELETE CASCADE,
3250  ADD CONSTRAINT `player_killers_ibfk_2` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
3251
3252--
3253-- Constraints for table `player_namelocks`
3254--
3255ALTER TABLE `player_namelocks`
3256  ADD CONSTRAINT `player_namelocks_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
3257
3258--
3259-- Constraints for table `player_skills`
3260--
3261ALTER TABLE `player_skills`
3262  ADD CONSTRAINT `player_skills_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
3263
3264--
3265-- Constraints for table `player_spells`
3266--
3267ALTER TABLE `player_spells`
3268  ADD CONSTRAINT `player_spells_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
3269
3270--
3271-- Constraints for table `player_storage`
3272--
3273ALTER TABLE `player_storage`
3274  ADD CONSTRAINT `player_storage_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
3275
3276--
3277-- Constraints for table `player_viplist`
3278--
3279ALTER TABLE `player_viplist`
3280  ADD CONSTRAINT `player_viplist_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE,
3281  ADD CONSTRAINT `player_viplist_ibfk_2` FOREIGN KEY (`vip_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
3282
3283--
3284-- Constraints for table `server_reports`
3285--
3286ALTER TABLE `server_reports`
3287  ADD CONSTRAINT `server_reports_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
3288
3289--
3290-- Constraints for table `tiles`
3291--
3292ALTER TABLE `tiles`
3293  ADD CONSTRAINT `tiles_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE;
3294
3295--
3296-- Constraints for table `tile_items`
3297--
3298ALTER TABLE `tile_items`
3299  ADD CONSTRAINT `tile_items_ibfk_1` FOREIGN KEY (`tile_id`) REFERENCES `tiles` (`id`) ON DELETE CASCADE;
3300
3301/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
3302/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
3303/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;