5QkC8h53

1INSERT INTO `items` (`name`, `hidden_search`, `lifespan_minutes`, `code`, `type`, `rarity`, `hunt_use`, `desc`, `level`, `big_image`, `gang_made`, `mod1`, `mod2`, `mod3`, `mod4`, `upgrades`, `armor_bonus`, `damage_bonus`, `min_damage`, `max_damage`, `dodge_bonus`, `speed_bonus`, `accuracy_bonus`, `gun_bonus`, `melee_bonus`, `proj_bonus`, `def_bonus`, `sell_price`, `heal_amount`, `exp_amount`, `focus_amount`, `ability_amount`, `forge_points`, `ability`, `ability_level`) VALUES ('Homemade Pie', '0', NULL, '3cektShWisKoWUgsIWp6', 'Special', 'Epic', '0', 'A fresh-out-of-the-forge homemade pie made with very questionable ingredients. You might need a really strong stomach for this one..', '60', 'big_homemadepie.png', '0', 'None', 'None', 'None', 'None', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '', '-1');
2INSERT INTO `variables` (`name`, `value`, `timestamp`) VALUES ('phantom_excludes', 'Snow Boom, Sweet Embrace, Alypss Armor', '');
3INSERT INTO `items` (`name`, `hidden_search`, `lifespan_minutes`, `code`, `type`, `rarity`, `hunt_use`, `desc`, `level`, `big_image`, `gang_made`, `mod1`, `mod2`, `mod3`, `mod4`, `upgrades`, `armor_bonus`, `damage_bonus`, `min_damage`, `max_damage`, `dodge_bonus`, `speed_bonus`, `accuracy_bonus`, `gun_bonus`, `melee_bonus`, `proj_bonus`, `def_bonus`, `sell_price`, `heal_amount`, `exp_amount`, `focus_amount`, `ability_amount`, `forge_points`, `ability`, `ability_level`) VALUES ('Sweet Embrace', '0', '120', 'swctShWisKoWUgsIWp6', 'Melee Weapon', 'Godlike', '0', 'A Candy Cane with a very pointy end... how festive.', '75', 'big_sweetembrace.png', '0', 'None', 'None', 'None', 'None', '', '0', '0', '110', '121', '0', '75', '38', '0', '65', '0', '18', '200', '0', '0', '0', '0', '3', '', '-1');
4INSERT INTO `items` (`name`, `hidden_search`, `lifespan_minutes`, `code`, `type`, `rarity`, `hunt_use`, `desc`, `level`, `big_image`, `gang_made`, `mod1`, `mod2`, `mod3`, `mod4`, `upgrades`, `armor_bonus`, `damage_bonus`, `min_damage`, `max_damage`, `dodge_bonus`, `speed_bonus`, `accuracy_bonus`, `gun_bonus`, `melee_bonus`, `proj_bonus`, `def_bonus`, `sell_price`, `heal_amount`, `exp_amount`, `focus_amount`, `ability_amount`, `forge_points`, `ability`, `ability_level`) VALUES ('Snow Boom', '0', '120', 'sbbtShWisKoWUgsIWp6', 'Gun', 'Godlike', '0', 'Make many thing go boom boom', '75', 'big_snowboom.png', '0', 'None', 'None', 'None', 'None', '', '0', '0', '90', '99', '0', '90', '90', '90', '0', '0', '90', '200', '0', '0', '0', '0', '3', '', '-1');
5UPDATE `items` SET `lifespan_minutes` = '120' WHERE `items`.`name` = 'Snow Boom';
6INSERT INTO `items` (`name`, `hidden_search`, `lifespan_minutes`, `code`, `type`, `rarity`, `hunt_use`, `desc`, `level`, `big_image`, `gang_made`, `mod1`, `mod2`, `mod3`, `mod4`, `upgrades`, `armor_bonus`, `damage_bonus`, `min_damage`, `max_damage`, `dodge_bonus`, `speed_bonus`, `accuracy_bonus`, `gun_bonus`, `melee_bonus`, `proj_bonus`, `def_bonus`, `sell_price`, `heal_amount`, `exp_amount`, `focus_amount`, `ability_amount`, `forge_points`, `ability`, `ability_level`) VALUES ('Pie Mix', '0', NULL, 'cc4d88g68st6MtrlAld0', 'Material', 'Normal', '0', 'This item is a material that can be used as a component when crafting certain recipes in the Shadow Facility.', '0', 'big_upgrade.png', '0', 'None', 'None', 'None', 'None', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0', '3', '', '-1');
7INSERT INTO `items` (`name`, `hidden_search`, `lifespan_minutes`, `code`, `type`, `rarity`, `hunt_use`, `desc`, `level`, `big_image`, `gang_made`, `mod1`, `mod2`, `mod3`, `mod4`, `upgrades`, `armor_bonus`, `damage_bonus`, `min_damage`, `max_damage`, `dodge_bonus`, `speed_bonus`, `accuracy_bonus`, `gun_bonus`, `melee_bonus`, `proj_bonus`, `def_bonus`, `sell_price`, `heal_amount`, `exp_amount`, `focus_amount`, `ability_amount`, `forge_points`, `ability`, `ability_level`) VALUES ('Flour', '0', NULL, 'ff4d88g68st6MtrlAld0', 'Material', 'Normal', '0', 'This item is a material that can be used as a component when crafting certain recipes in the Shadow Facility.', '0', 'big_upgrade.png', '0', 'None', 'None', 'None', 'None', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '25', '0', '0', '0', '0', '3', '', '-1');
8INSERT INTO `shadow_recipes` (`id`, `name`, `rarity`, `type`, `in_draw`, `potential_result`, `description`, `required_items`, `optional_items`, `optional_limit`, `target_item`, `create_item`, `forge_points_required`, `crafting_level_required`, `crafting_skill_bonus`, `per_optional_bonus`) VALUES (NULL, 'Homemade Pie', 'Event', 'Crafting', '0', '0', '', 'Pie Mix#Pie Mix#Flour#Bonding Paste', '', '0', '', 'Homemade Pie', '0', '2', '45', '0');
9UPDATE `items` SET `lifespan_minutes`='120' WHERE `name`='Alypss Armor';
10
11
12# raids
13
14-- phpMyAdmin SQL Dump
15-- version 4.7.9
16-- https://www.phpmyadmin.net/
17--
18-- Host: 127.0.0.1:3306
19-- Generation Time: Dec 21, 2018 at 10:14 AM
20-- Server version: 5.7.21
21-- PHP Version: 7.2.6
22
23SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
24SET AUTOCOMMIT = 0;
25START TRANSACTION;
26SET time_zone = "+00:00";
27
28
29/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
30/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
31/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
32/*!40101 SET NAMES utf8mb4 */;
33
34--
35-- Database: `legacy_gamedata`
36--
37
38-- --------------------------------------------------------
39
40--
41-- Table structure for table `raids`
42--
43
44DROP TABLE IF EXISTS `raids`;
45CREATE TABLE IF NOT EXISTS `raids` (
46  `id` int(255) NOT NULL AUTO_INCREMENT,
47  `name` varchar(80) NOT NULL,
48  `description` text NOT NULL,
49  `event` int(1) NOT NULL DEFAULT '0',
50  `hidden` int(1) NOT NULL DEFAULT '0',
51  `min_level` int(3) NOT NULL DEFAULT '1',
52  `public_instance` int(1) NOT NULL DEFAULT '0',
53  `start_x` int(3) NOT NULL DEFAULT '0',
54  `start_y` int(3) NOT NULL DEFAULT '0',
55  `start_z` int(3) NOT NULL DEFAULT '0',
56  `success_message` varchar(200) NOT NULL DEFAULT 'You have completed your journey.',
57  `on_raid_success` text NOT NULL,
58  `on_raid_success_quest` varchar(30) NOT NULL,
59  `hourly_rewards` text NOT NULL,
60  `daily_rewards` text NOT NULL,
61  `weekly_rewards` text NOT NULL,
62  `common_rewards` text NOT NULL,
63  `base_xp_reward` int(20) NOT NULL DEFAULT '0',
64  `base_credits_reward` int(20) NOT NULL DEFAULT '0',
65  PRIMARY KEY (`id`),
66  UNIQUE KEY `name` (`name`)
67) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
68
69--
70-- Dumping data for table `raids`
71--
72
73INSERT INTO `raids` (`id`, `name`, `description`, `event`, `hidden`, `min_level`, `public_instance`, `start_x`, `start_y`, `start_z`, `success_message`, `on_raid_success`, `on_raid_success_quest`, `hourly_rewards`, `daily_rewards`, `weekly_rewards`, `common_rewards`, `base_xp_reward`, `base_credits_reward`) VALUES
74(1, 'Unknown', 'You were pulled into the void and suddenly appeared in what seems like the wasteland. But something is different.. explore to find answers.', 0, 1, 1, 1, 0, 9, 0, 'You have completed your journey.', 'addAchievement:observerVentrixShadow', 'ovs2', '', '', '', '', 0, 0),
75(3, 'Trials of the Observers', 'Complete the trials set forth by the Observers in order to discover their true identity and harness their true power.', 0, 1, 1, 0, 12, 6, 0, 'You have completed your journey.', '', '', '', '', '', '', 0, 0),
76(4, 'A Very Merry Realm', 'Discover the truth behind Santa\'s Toy Factory and whether or not it really is the happiest place to work in. Answer the age-old question: is Santa Claus real?', 1, 0, 70, 0, 2, 2, 0, 'You discovered the truth about Santa Claus.. that he was some kind of godlike creature called Klaus. The question remains though - where did he come from?', '', '', '1000:Bronze Ticket', '1:Gold Ticket#1000:Silver Ticket', '1000:Gold Ticket', '', 1002, 5002);
77
78-- --------------------------------------------------------
79
80--
81-- Table structure for table `raid_ai`
82--
83
84DROP TABLE IF EXISTS `raid_ai`;
85CREATE TABLE IF NOT EXISTS `raid_ai` (
86  `id` bigint(20) NOT NULL AUTO_INCREMENT,
87  `name` varchar(30) NOT NULL,
88  `icon` varchar(120) NOT NULL,
89  `image` varchar(100) NOT NULL,
90  `max_hp` int(11) NOT NULL DEFAULT '50',
91  `level` int(11) NOT NULL DEFAULT '10',
92  `boss` int(1) NOT NULL DEFAULT '0',
93  `armor` varchar(45) NOT NULL DEFAULT '',
94  `weapon1` varchar(45) NOT NULL DEFAULT '',
95  `weapon2` varchar(45) NOT NULL DEFAULT '',
96  `misc1` varchar(45) NOT NULL DEFAULT '',
97  `misc2` varchar(45) NOT NULL DEFAULT '',
98  `drops` text NOT NULL,
99  `default_player_cannot_move` int(2) NOT NULL DEFAULT '0',
100  PRIMARY KEY (`id`)
101) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
102
103--
104-- Dumping data for table `raid_ai`
105--
106
107INSERT INTO `raid_ai` (`id`, `name`, `icon`, `image`, `max_hp`, `level`, `boss`, `armor`, `weapon1`, `weapon2`, `misc1`, `misc2`, `drops`, `default_player_cannot_move`) VALUES
108(1, 'Brotherhood Avatar', '', 'groups/78.png', 300, 100, 1, '', '', '', '', '', '', 0),
109(2, 'Slum Thug', '', 'groups/7.png', 300, 50, 1, '', '', '', '', '', '', 0),
110(3, '???', '', 'raids/npc/male_husk.png', 10, 1, 0, 'Coat', 'Broken Bottle', 'Broken Bottle', '', '', '', 0),
111(4, '???', '', 'raids/npc/female_husk.png', 10, 1, 0, 'Coat', 'Broken Bottle', 'Broken Bottle', '', '', '', 0),
112(5, 'Observer: Ventrix', '', 'hunting/i_observer.png', 500, 80, 1, '', '', '', '', '', '', 0),
113(6, 'Residential Guard', '', 'groups/13.png', 300, 80, 1, '', '', '', '', '', '', 0),
114(7, 'Hive Riot Police', '', 'groups/24.png', 300, 80, 1, '', '', '', '', '', '', 0),
115(8, 'Senate Guard', '', 'groups/34.png', 300, 80, 1, '', '', '', '', '', '', 0),
116(9, 'Chamber Guard', '', 'groups/44.png', 300, 80, 1, '', '', '', '', '', '', 0),
117(10, 'Guard Dog', '', 'groups/52.png', 300, 80, 1, '', '', '', '', '', '', 0),
118(11, 'Blood Crazed', '', 'groups/62.png', 300, 80, 1, '', '', '', '', '', '', 0),
119(12, 'Sanctuary Guard', '', 'groups/75.png', 300, 80, 1, '', '', '', '', '', '', 0),
120(13, 'Void Pit', '', 'raids/trials/npc/void pit.png', 10, 10, 1, '', '', '', '', '', '', 0),
121(14, 'Klauz', '', 'raids/npc/christmas/santa.png', 300, 85, 1, 'Hellforged Armor', 'Snow Boom', 'Sweet Embrace', '', '', '1:Fire Crystal Shard#2:Snow Boom#2:Sweet Embrace#1000:Large Power Cell', 0),
122(15, 'Feral Reindeer', '', 'raids/npc/christmas/reindeer.png', 60, 20, 0, '', '', '', '', '', '', 0),
123(16, 'Mimic', 'raids/npc/christmas/mimic_icon.png', 'raids/npc/christmas/mimic.png', 100, 40, 0, '', '', '', '', '', '25:Pie Mix#25:Flour', 1),
124(17, 'Little Helper', '', 'raids/npc/christmas/little_helper.png', 150, 60, 1, '', '', '', '', '', '', 0),
125(18, 'Nutcracker', '', 'raids/npc/christmas/nutcracker.png', 180, 75, 1, '', '', '', '', '', '', 1),
126(19, 'Frost Knight', '', 'raids/npc/christmas/knight.png', 240, 80, 1, '', '', '', '', '', '3:Abstruse Crystal', 1),
127(20, 'Granny H', '', 'raids/npc/christmas/granny.png', 400, 90, 1, 'Alypss Armor', 'Snow Boom', 'Infinite Void Bow', 'Scout Drones', 'Scout Drones', '1:Toolbox#1:Abyss Crystal Fragment#2:Alypss Armor#4:Titan Guard#5:Crystal Sword#5:Rail Gun#5:Crystal Bombs#6:Amulet#1000:Godlike Blueprint', 0);
128
129-- --------------------------------------------------------
130
131--
132-- Table structure for table `raid_flags`
133--
134
135DROP TABLE IF EXISTS `raid_flags`;
136CREATE TABLE IF NOT EXISTS `raid_flags` (
137  `raid_id` int(255) NOT NULL,
138  `flag` varchar(200) NOT NULL,
139  `expires` float NOT NULL DEFAULT '0',
140  `on_flag` text NOT NULL,
141  `on_expiry` text NOT NULL,
142  PRIMARY KEY (`raid_id`,`flag`)
143) ENGINE=MyISAM DEFAULT CHARSET=latin1;
144
145-- --------------------------------------------------------
146
147--
148-- Table structure for table `raid_instances`
149--
150
151DROP TABLE IF EXISTS `raid_instances`;
152CREATE TABLE IF NOT EXISTS `raid_instances` (
153  `id` bigint(20) NOT NULL AUTO_INCREMENT,
154  `raid_id` int(255) NOT NULL,
155  `leader` varchar(10) DEFAULT NULL,
156  `status` int(1) NOT NULL DEFAULT '0',
157  PRIMARY KEY (`id`),
158  UNIQUE KEY `UNIQUE` (`leader`),
159  UNIQUE KEY `map_id` (`raid_id`,`leader`)
160) ENGINE=InnoDB AUTO_INCREMENT=327 DEFAULT CHARSET=latin1;
161
162-- --------------------------------------------------------
163
164--
165-- Table structure for table `raid_instance_ai`
166--
167
168DROP TABLE IF EXISTS `raid_instance_ai`;
169CREATE TABLE IF NOT EXISTS `raid_instance_ai` (
170  `id` bigint(20) NOT NULL AUTO_INCREMENT,
171  `entity_id` varchar(30) NOT NULL,
172  `name` varchar(30) NOT NULL,
173  `instance_id` bigint(20) NOT NULL,
174  `ai_id` int(255) NOT NULL,
175  `hp` int(11) NOT NULL DEFAULT '50',
176  `max_hp` int(11) NOT NULL DEFAULT '50',
177  `level` int(11) NOT NULL DEFAULT '10',
178  `state` int(2) NOT NULL DEFAULT '0',
179  `x` int(3) NOT NULL DEFAULT '0',
180  `y` int(3) NOT NULL DEFAULT '0',
181  `z` int(3) NOT NULL DEFAULT '0',
182  `hidden` int(2) NOT NULL DEFAULT '0',
183  `dest_x` int(3) NOT NULL,
184  `dest_y` int(3) NOT NULL,
185  `dest_z` int(3) NOT NULL DEFAULT '0',
186  `hostile` int(1) NOT NULL DEFAULT '1',
187  `player_cannot_move` int(1) NOT NULL DEFAULT '0',
188  `interact` varchar(40) NOT NULL DEFAULT '',
189  `patrol_route` varchar(300) NOT NULL,
190  `patrol_index` int(3) NOT NULL,
191  `on_interact` text NOT NULL,
192  `on_defeat` text NOT NULL,
193  `on_destination` text NOT NULL,
194  PRIMARY KEY (`id`),
195  KEY `INDEX` (`instance_id`),
196  KEY `entity_id` (`entity_id`,`instance_id`)
197) ENGINE=InnoDB AUTO_INCREMENT=5311 DEFAULT CHARSET=latin1;
198
199-- --------------------------------------------------------
200
201--
202-- Table structure for table `raid_instance_flags`
203--
204
205DROP TABLE IF EXISTS `raid_instance_flags`;
206CREATE TABLE IF NOT EXISTS `raid_instance_flags` (
207  `instance_id` int(255) NOT NULL,
208  `account` varchar(40) NOT NULL,
209  `flag` varchar(200) NOT NULL,
210  `created` int(11) NOT NULL,
211  `updated` int(11) NOT NULL,
212  `counter` int(10) NOT NULL DEFAULT '1',
213  PRIMARY KEY (`instance_id`,`account`,`flag`),
214  UNIQUE KEY `account` (`account`,`flag`)
215) ENGINE=MyISAM DEFAULT CHARSET=latin1;
216
217-- --------------------------------------------------------
218
219--
220-- Table structure for table `raid_instance_tiles`
221--
222
223DROP TABLE IF EXISTS `raid_instance_tiles`;
224CREATE TABLE IF NOT EXISTS `raid_instance_tiles` (
225  `instance_id` int(255) NOT NULL,
226  `x` int(4) NOT NULL,
227  `y` int(4) NOT NULL,
228  `z` int(4) NOT NULL,
229  `hidden` int(2) NOT NULL DEFAULT '0',
230  `wall` int(2) NOT NULL DEFAULT '0',
231  `objective_id` int(255) NOT NULL DEFAULT '0',
232  `objective_hp` int(6) NOT NULL DEFAULT '0',
233  `objective_max_hp` int(6) NOT NULL DEFAULT '100',
234  `movable` int(1) NOT NULL DEFAULT '0',
235  `search_items` text NOT NULL,
236  `teleports` int(1) NOT NULL DEFAULT '0',
237  `teleport_x` int(4) NOT NULL,
238  `teleport_y` int(4) NOT NULL,
239  `teleport_z` int(4) NOT NULL,
240  `interact` varchar(40) NOT NULL,
241  `on_interact` text NOT NULL,
242  `on_tile_enter` text NOT NULL,
243  `on_move` text NOT NULL COMMENT 'When pushed or somehow moved',
244  PRIMARY KEY (`instance_id`,`x`,`y`,`z`) USING BTREE
245) ENGINE=MyISAM DEFAULT CHARSET=latin1;
246
247-- --------------------------------------------------------
248
249--
250-- Table structure for table `raid_maps`
251--
252
253DROP TABLE IF EXISTS `raid_maps`;
254CREATE TABLE IF NOT EXISTS `raid_maps` (
255  `raid_id` int(255) NOT NULL,
256  `z` int(3) NOT NULL DEFAULT '0' COMMENT 'which z-level/room does this represent for the raid',
257  `map_image` varchar(200) NOT NULL,
258  `columns` int(4) NOT NULL DEFAULT '15',
259  `rows` int(4) NOT NULL DEFAULT '15',
260  `static_walls` text NOT NULL,
261  `static_floors` text NOT NULL COMMENT 'use either this or walls',
262  PRIMARY KEY (`raid_id`,`z`)
263) ENGINE=MyISAM DEFAULT CHARSET=latin1;
264
265--
266-- Dumping data for table `raid_maps`
267--
268
269INSERT INTO `raid_maps` (`raid_id`, `z`, `map_image`, `columns`, `rows`, `static_walls`, `static_floors`) VALUES
270(1, 0, 'map-alt.png', 15, 15, '', '0,9#1,9#2,9#3,9#4,9#5,9#6,9#7,9#8,9#9,9#10,9#11,9#7,7#8,7#7,8#8,8#7,9#8,9#7,10#8,10#7,11#8,11#11,8#11,7#11,6#11,5#11,4#11,3#11,2#10,4#10,3#10,2#12,4#12,3#12,2'),
271(3, 0, 'trials/big_map.png', 25, 25, '21,11#22,11#21,12#22,10#20,13#21,13#20,14#20,15#19,16#22,9#13,12#14,12#13,13#14,13#14,14#12,12#15,13#13,14#15,12#10,1#10,2#10,3#14,1#14,2#14,3#11,5#13,5#9,0#15,0#9,4#15,4#10,5#14,5#7,15#7,16#7,17#7,18#7,19#7,20#7,21#7,22#7,23#7,24#0,14#1,15#2,16#0,17#1,17#5,15#6,14#4,16#5,17#6,17#3,18#3,20#3,22#4,23#5,24#2,23#1,24#0,23#6,23#2,17#4,17', ''),
272(4, 0, 'christmas/winter_is_coming.png', 15, 15, '0,0#2,3#2,4#3,4#2,5#3,5#9,14#10,14#11,13#11,14#12,12#12,13#12,14#13,11#13,12#13,13#13,14#14,12#14,13#14,14#4,11#4,12#4,13#5,10#6,11#6,12#6,13#5,13#12,11#11,12#9,6#8,7#8,8#10,7#10,8#8,9#10,9#12,8#12,9#10,3#10,4#12,3#12,4#11,5', '');
273
274-- --------------------------------------------------------
275
276--
277-- Table structure for table `raid_maps_ai_data`
278--
279
280DROP TABLE IF EXISTS `raid_maps_ai_data`;
281CREATE TABLE IF NOT EXISTS `raid_maps_ai_data` (
282  `id` int(255) NOT NULL AUTO_INCREMENT,
283  `entity_id` varchar(30) NOT NULL COMMENT 'Unique id per raid to identify specific ai for specific commands',
284  `raid_id` int(255) NOT NULL,
285  `state` int(3) NOT NULL DEFAULT '0',
286  `x` int(3) NOT NULL,
287  `y` int(3) NOT NULL,
288  `z` int(3) NOT NULL DEFAULT '0',
289  `hidden` int(2) NOT NULL DEFAULT '0',
290  `dest_x` int(3) NOT NULL DEFAULT '0',
291  `dest_y` int(3) NOT NULL DEFAULT '0',
292  `dest_z` int(3) NOT NULL DEFAULT '0',
293  `ai_id` int(255) NOT NULL,
294  `ai_count` int(3) NOT NULL DEFAULT '0',
295  `hostile` int(1) NOT NULL DEFAULT '1',
296  `player_cannot_move` int(11) NOT NULL DEFAULT '0' COMMENT 'If 1, player cannot move until this npc is removed from the square',
297  `interact` varchar(40) NOT NULL DEFAULT '',
298  `patrol_route` varchar(300) NOT NULL,
299  `on_interact` text NOT NULL,
300  `on_defeat` text NOT NULL,
301  PRIMARY KEY (`id`),
302  KEY `map_id` (`raid_id`),
303  KEY `y` (`y`,`z`,`x`),
304  KEY `map_id_2` (`raid_id`),
305  KEY `entity_id` (`entity_id`,`raid_id`)
306) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=latin1;
307
308--
309-- Dumping data for table `raid_maps_ai_data`
310--
311
312INSERT INTO `raid_maps_ai_data` (`id`, `entity_id`, `raid_id`, `state`, `x`, `y`, `z`, `hidden`, `dest_x`, `dest_y`, `dest_z`, `ai_id`, `ai_count`, `hostile`, `player_cannot_move`, `interact`, `patrol_route`, `on_interact`, `on_defeat`) VALUES
313(1, '', 1, 0, 7, 7, 0, 0, 0, 0, 0, 3, 2, 1, 0, '', '', '', ''),
314(2, '', 1, 0, 8, 11, 0, 0, 0, 0, 0, 4, 2, 1, 0, '', '', '', ''),
315(3, '', 1, 0, 11, 3, 0, 0, 0, 0, 0, 5, 1, 0, 0, 'Observe', '', 'endRaidSuccess', ''),
316(4, '', 2, 0, 0, 2, 2, 0, 0, 0, 0, 2, 1, 1, 0, '', '', '', ''),
317(5, '', 3, 0, 21, 3, 0, 0, 0, 0, 0, 8, 1, 1, 0, 'Talk', '', 'checkFlag:npc2##flag:npc3##endCondition', ''),
318(6, '', 3, 0, 23, 3, 0, 0, 0, 0, 0, 10, 1, 1, 0, 'Talk', '', 'checkFlag:npc4##flag:npc5##endCondition', ''),
319(7, '', 3, 0, 23, 5, 0, 0, 0, 0, 0, 2, 1, 1, 0, '', '', '', ''),
320(8, '', 3, 0, 21, 5, 0, 0, 0, 0, 0, 7, 1, 1, 0, 'Talk', '', 'checkFlag:npc1##flag:npc2##endCondition', ''),
321(9, '', 3, 0, 23, 7, 0, 0, 0, 0, 0, 12, 1, 1, 0, 'Talk', '', 'checkFlag:npc5##flag:npc6##flag:task1Completed##sendClientMsg:Correct##endCondition', ''),
322(10, '', 3, 0, 21, 7, 0, 0, 0, 0, 0, 1, 1, 1, 0, 'Talk', '', '', ''),
323(11, '', 3, 0, 19, 3, 0, 0, 0, 0, 0, 6, 1, 1, 0, 'Talk', '', 'flag:npc1', ''),
324(12, '', 3, 0, 19, 5, 0, 0, 0, 0, 0, 11, 1, 1, 0, '', '', '', ''),
325(13, '', 3, 0, 19, 7, 0, 0, 0, 0, 0, 9, 1, 1, 0, 'Talk', '', 'checkFlag:npc3##flag:npc4##endCondition', ''),
326(14, '', 3, 1, 17, 17, 0, 0, 0, 0, 0, 13, 1, 0, 0, '', 's,s,s,s,s,s,e,e,e,e,e,e,n,n,n,n,n,n,w,w,w,w,w,w', '', ''),
327(15, '', 3, 1, 17, 20, 0, 0, 0, 0, 0, 13, 1, 0, 0, '', 's,s,s,e,e,e,e,e,e,n,n,n,n,n,n,w,w,w,w,w,w,s,s,s', '', ''),
328(16, '', 3, 1, 17, 23, 0, 0, 0, 0, 0, 13, 1, 0, 0, '', 'e,e,e,e,e,e,n,n,n,n,n,n,w,w,w,w,w,w,s,s,s,s,s,s', '', ''),
329(17, '', 3, 1, 23, 17, 0, 0, 0, 0, 0, 13, 1, 0, 0, '', 'w,w,w,w,w,w,s,s,s,s,s,s,e,e,e,e,e,e,n,n,n,n,n,n', '', ''),
330(18, '', 3, 1, 23, 20, 0, 0, 0, 0, 0, 13, 1, 0, 0, '', 'n,n,n,w,w,w,w,w,w,s,s,s,s,s,s,e,e,e,e,e,e,n,n,n', '', ''),
331(19, '', 3, 1, 23, 23, 0, 0, 0, 0, 0, 13, 1, 0, 0, '', 'n,n,n,n,n,n,w,w,w,w,w,w,s,s,s,s,s,s,e,e,e,e,e,e', '', ''),
332(20, '', 3, 1, 20, 19, 0, 0, 0, 0, 0, 13, 1, 0, 0, '', 'e,s,s,w,w,n,n,e', '', ''),
333(21, '', 3, 1, 20, 21, 0, 0, 0, 0, 0, 13, 1, 0, 0, '', 'w,n,n,e,e,s,s,w', '', ''),
334(22, '', 4, 0, 9, 8, 0, 0, 0, 0, 0, 14, 1, 1, 0, '', '', '', 'endRaidSuccess##showTile:9,,7##teachRecipe:Homemade Pie##sendClientMsg:<font class=warOther>You defeat what many thought was Santa Claus but was in fact a weird creature whose true form revealed itself as his body disappears.</font>'),
335(23, '', 4, 0, 11, 10, 0, 0, 0, 0, 0, 18, 1, 1, 1, '', '', '', ''),
336(24, '', 4, 0, 9, 10, 0, 0, 0, 0, 0, 18, 1, 1, 1, 'Talk', '', 'sendClientMsg:The.. key.. lies.. in.. his.. reci..', ''),
337(25, '', 4, 0, 4, 4, 0, 0, 0, 0, 0, 15, 1, 1, 0, '', '', '', ''),
338(26, '', 4, 0, 1, 4, 0, 0, 0, 0, 0, 15, 1, 1, 0, '', '', '', ''),
339(27, '', 4, 0, 1, 6, 0, 0, 0, 0, 0, 15, 1, 1, 0, '', '', '', ''),
340(28, '', 4, 0, 3, 3, 0, 0, 0, 0, 0, 15, 1, 1, 0, '', '', '', ''),
341(29, '', 4, 0, 3, 6, 0, 0, 0, 0, 0, 15, 1, 1, 0, '', '', '', ''),
342(31, '', 4, 0, 0, 7, 0, 0, 0, 0, 0, 16, 1, 1, 1, '', '', '', 'flag:mimicKilled3'),
343(32, '', 4, 0, 7, 14, 0, 0, 0, 0, 0, 16, 1, 1, 1, '', '', '', 'flag:mimicKilled2'),
344(33, '', 4, 0, 14, 7, 0, 0, 0, 0, 0, 16, 1, 1, 1, '', '', '', 'flag:mimicKilled1'),
345(34, '', 4, 0, 13, 7, 0, 0, 0, 0, 0, 17, 1, 1, 0, 'Talk', '', 'sendClientMsg:This thing scares me.. and so does he. Our powers are not enough. But I fear he is a harbinger for something ..else.', 'flag:elfKilled1'),
346(35, '', 4, 0, 7, 13, 0, 0, 0, 0, 0, 17, 1, 1, 0, 'Talk', '', 'sendClientMsg:We were brought here from a different world to help with his facade.. he is an imposter.', 'flag:elfKilled2'),
347(36, '', 4, 0, 0, 8, 0, 0, 0, 0, 0, 17, 1, 1, 0, 'Talk', '', 'sendClientMsg:This land is wicked and true evil roams it. We are too powerless. Please help us.', 'flag:elfKilled3'),
348(37, '', 4, 0, 7, 10, 0, 0, 0, 0, 0, 18, 1, 1, 1, '', '', '', ''),
349(38, '', 4, 0, 8, 11, 0, 0, 0, 0, 0, 18, 1, 1, 1, 'Talk', '', 'sendClientMsg:I.. am.. not.. in.. control.', ''),
350(39, '', 4, 0, 10, 11, 0, 0, 0, 0, 0, 18, 1, 1, 1, '', '', '', ''),
351(40, '', 4, 0, 9, 12, 0, 0, 0, 0, 0, 18, 1, 1, 1, 'Talk', '', 'sendClientMsg:I.. am.. drifting.', ''),
352(41, 'granny', 4, 0, 5, 11, 0, 1, 0, 0, 0, 20, 1, 1, 0, '', '', '', 'endRaidSuccess');
353
354-- --------------------------------------------------------
355
356--
357-- Table structure for table `raid_maps_tiles_data`
358--
359
360DROP TABLE IF EXISTS `raid_maps_tiles_data`;
361CREATE TABLE IF NOT EXISTS `raid_maps_tiles_data` (
362  `raid_id` int(255) NOT NULL,
363  `x` int(4) NOT NULL,
364  `y` int(4) NOT NULL,
365  `z` int(4) NOT NULL DEFAULT '0',
366  `hidden` int(2) NOT NULL DEFAULT '0',
367  `wall` int(2) NOT NULL DEFAULT '0',
368  `objective_id` int(255) NOT NULL DEFAULT '0',
369  `objective_max_hp` int(6) NOT NULL DEFAULT '100',
370  `movable` int(1) NOT NULL DEFAULT '0',
371  `search_items` text NOT NULL,
372  `teleports` int(1) NOT NULL DEFAULT '0',
373  `teleport_x` int(4) NOT NULL,
374  `teleport_y` int(4) NOT NULL,
375  `teleport_z` int(4) NOT NULL,
376  `interact` varchar(40) NOT NULL,
377  `on_interact` text NOT NULL,
378  `on_tile_enter` text NOT NULL,
379  `on_move` text NOT NULL COMMENT 'When pushed or somehow moved',
380  PRIMARY KEY (`raid_id`,`x`,`y`,`z`)
381) ENGINE=MyISAM DEFAULT CHARSET=latin1;
382
383--
384-- Dumping data for table `raid_maps_tiles_data`
385--
386
387INSERT INTO `raid_maps_tiles_data` (`raid_id`, `x`, `y`, `z`, `hidden`, `wall`, `objective_id`, `objective_max_hp`, `movable`, `search_items`, `teleports`, `teleport_x`, `teleport_y`, `teleport_z`, `interact`, `on_interact`, `on_tile_enter`, `on_move`) VALUES
388(1, 1, 9, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:This is your future.##flag:done', ''),
389(1, 3, 9, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:This is also your past.', ''),
390(1, 7, 7, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:Those who are left alive.. will no longer be alive.', ''),
391(1, 8, 11, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:This is what you will become.\r\n', ''),
392(1, 11, 8, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:We do not interfere.', ''),
393(1, 11, 7, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:We only observe.', ''),
394(1, 11, 6, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:But now you have observed.', ''),
395(1, 11, 5, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:Will you interfere?', ''),
396(1, 11, 4, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:Tell me...', ''),
397(1, 11, 3, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:..<font class=itemPhantom><b>Observer</b></font>.', ''),
398(3, 10, 0, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'spawnObjective:2', ''),
399(3, 10, 4, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'spawnObjective:3', ''),
400(3, 14, 0, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'spawnObjective:5', ''),
401(3, 14, 4, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'spawnObjective:4', ''),
402(3, 18, 19, 0, 0, 0, 6, 100, 1, '', 0, 0, 0, 0, '', '', '', ''),
403(3, 1, 18, 0, 0, 0, 7, 100, 0, '', 1, 5, 21, 0, '', '', '', ''),
404(3, 1, 20, 0, 0, 0, 7, 100, 0, '', 1, 1, 19, 0, '', '', '', ''),
405(3, 0, 19, 0, 0, 0, 7, 100, 0, '', 1, 1, 23, 0, '', '', '', ''),
406(3, 2, 19, 0, 0, 0, 7, 100, 0, '', 1, 3, 16, 0, '', '', '', ''),
407(3, 0, 21, 0, 0, 0, 7, 100, 0, '', 1, 1, 19, 0, '', '', '', ''),
408(3, 2, 21, 0, 0, 0, 7, 100, 0, '', 1, 3, 19, 0, '', '', '', ''),
409(3, 1, 22, 0, 0, 0, 7, 100, 0, '', 1, 2, 18, 0, '', '', '', ''),
410(3, 4, 19, 0, 0, 0, 7, 100, 0, '', 1, 3, 24, 0, '', '', '', ''),
411(3, 6, 19, 0, 0, 0, 7, 100, 0, '', 1, 3, 16, 0, '', '', '', ''),
412(3, 4, 21, 0, 0, 0, 7, 100, 0, '', 1, 5, 23, 0, '', '', '', ''),
413(3, 6, 21, 0, 0, 0, 7, 100, 0, '', 1, 2, 22, 0, '', '', '', ''),
414(3, 5, 22, 0, 0, 0, 7, 100, 0, '', 1, 5, 19, 0, '', '', '', ''),
415(3, 5, 18, 0, 0, 0, 7, 100, 0, '', 1, 4, 20, 0, '', '', '', ''),
416(3, 5, 20, 0, 0, 0, 7, 100, 0, '', 1, 3, 21, 0, '', '', '', ''),
417(3, 3, 17, 0, 0, 0, 7, 100, 0, '', 1, 0, 22, 0, '', '', '', ''),
418(3, 4, 24, 0, 0, 0, 7, 100, 0, '', 1, 3, 16, 0, '', '', '', ''),
419(3, 2, 24, 0, 0, 0, 0, 100, 0, '', 1, 5, 16, 0, '', '', '', ''),
420(3, 6, 16, 0, 0, 0, 0, 100, 0, '', 1, 1, 16, 0, '', '', '', ''),
421(3, 0, 15, 0, 0, 0, 0, 100, 0, '', 1, 3, 16, 0, '', '', '', ''),
422(3, 0, 16, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'flag:task3Secret\r\n', ''),
423(4, 5, 11, 0, 0, 0, 8, 100, 0, '', 0, 0, 0, 0, 'Desecrate', 'despawnObjective##showAI:granny', '', ''),
424(4, 14, 11, 0, 0, 0, 10, 100, 0, '', 0, 0, 0, 0, 'Eat (+60HP)', 'checkFlag:elfKilled1##sendClientMsg:You eat the cane but you feel nothing from it.. almost as if the source of its magic is gone.##elseCondition##checkFlag:mimicKilled1##sendClientMsg:The disappearance of a nearby mimic strengthens the effect of this candy cane.##heal:100##elseCondition##heal:60##endCondition##endCondition##despawnObjective', '', ''),
425(4, 9, 11, 0, 0, 0, 10, 100, 0, '', 0, 0, 0, 0, 'Eat (+60HP)', 'checkFlag:elfKilled2##sendClientMsg:You eat the cane but you feel nothing from it.. almost as if the source of its magic is gone.##elseCondition##checkFlag:mimicKilled2##sendClientMsg:The disappearance of a nearby mimic strengthens the effect of this candy cane.##heal:100##elseCondition##heal:60##endCondition##endCondition##despawnObjective', '', ''),
426(4, 2, 10, 0, 0, 0, 10, 100, 0, '', 0, 0, 0, 0, 'Eat (+60HP)', 'checkFlag:elfKilled3##sendClientMsg:You eat the cane but you feel nothing from it.. almost as if the source of its magic is gone.##elseCondition##checkFlag:mimicKilled3##sendClientMsg:The disappearance of a nearby mimic strengthens the effect of this candy cane.##heal:100##elseCondition##heal:60##endCondition##endCondition##despawnObjective', '', ''),
427(4, 7, 0, 0, 0, 0, 9, 100, 0, '', 0, 0, 0, 0, 'Open', 'sendClientMsg: You find a note that says \\\"We have left some canes that should replenish your health, should you need it!\\\" - The Elves.##despawnObjective', '', ''),
428(4, 9, 7, 0, 1, 0, 11, 100, 0, '', 0, 0, 0, 0, '', '', 'checkBuff:holidaySpirit##despawnObjective:11,,2##spawnAI:19,,11,,2##showTile:5,,12##spawnObjective:16##sendClientMsg:Somewhere in the distance you hear the sound of ice cracking.##elseCondition##sendClientMsg:Nothing happens as you step on the strange platform.##endCondition', ''),
429(4, 5, 12, 0, 1, 0, 12, 100, 0, '', 1, 11, 2, 0, '', '', '', ''),
430(4, 11, 3, 0, 0, 0, 14, 100, 0, '', 0, 0, 0, 0, '', '', '', ''),
431(4, 11, 4, 0, 0, 0, 15, 100, 0, '', 1, 5, 11, 0, '', '', 'sendClientMsg:Your holiday spirit intensifies as you step inside the crashed sleigh. You are suddenly whisked off to a special location.', ''),
432(4, 11, 2, 0, 0, 1, 13, 100, 0, '', 0, 0, 0, 0, '', '', '', '');
433
434-- --------------------------------------------------------
435
436--
437-- Table structure for table `raid_objectives`
438--
439
440DROP TABLE IF EXISTS `raid_objectives`;
441CREATE TABLE IF NOT EXISTS `raid_objectives` (
442  `id` int(255) NOT NULL AUTO_INCREMENT,
443  `name` varchar(40) NOT NULL,
444  `image` varchar(200) NOT NULL,
445  PRIMARY KEY (`id`)
446) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
447
448--
449-- Dumping data for table `raid_objectives`
450--
451
452INSERT INTO `raid_objectives` (`id`, `name`, `image`) VALUES
453(1, 'Strange Hive', 'warfare/strangehive.gif'),
454(2, 'Platform', 'raids/objectives/trials/knowledge.png'),
455(3, 'Platform', 'raids/objectives/trials/strength.png'),
456(4, 'Platform', 'raids/objectives/trials/history.png'),
457(5, 'Platform', 'raids/objectives/trials/courage.png'),
458(6, 'Strange Platform', 'raids/objectives/trials/sequence_platform4.png'),
459(7, 'Teleporter', 'raids/objectives/trials/teleporter.png'),
460(8, 'Strange Grave', 'raids/objectives/christmas/grave.png'),
461(9, 'Gift', 'raids/objectives/christmas/gift.png'),
462(10, 'Candy Cane', 'raids/objectives/christmas/candy_cane.png'),
463(11, 'Platform', 'raids/objectives/christmas/nose_meh.png'),
464(12, 'Portal', 'raids/objectives/christmas/portal.png'),
465(13, 'Ice Block', 'raids/objectives/christmas/frozen.png'),
466(14, 'Snow Trail', 'raids/objectives/christmas/snow_trail.png'),
467(15, 'Crashed Sleigh', 'raids/objectives/christmas/crashed_sleigh.png'),
468(16, 'Activated Platform', 'raids/objectives/christmas/nose_activated.png');
469
470-- --------------------------------------------------------
471
472--
473-- Table structure for table `raid_players`
474--
475
476DROP TABLE IF EXISTS `raid_players`;
477CREATE TABLE IF NOT EXISTS `raid_players` (
478  `id` bigint(20) NOT NULL AUTO_INCREMENT,
479  `account` varchar(10) DEFAULT NULL,
480  `instance_id` bigint(20) NOT NULL,
481  `team` int(4) NOT NULL DEFAULT '1',
482  `x` int(3) NOT NULL DEFAULT '0',
483  `y` int(3) NOT NULL DEFAULT '0',
484  `z` int(3) NOT NULL DEFAULT '0',
485  `last_active` datetime NOT NULL,
486  `rewards` text NOT NULL,
487  PRIMARY KEY (`id`),
488  UNIQUE KEY `UNIQUE` (`account`),
489  KEY `INDEX` (`instance_id`)
490) ENGINE=InnoDB AUTO_INCREMENT=365 DEFAULT CHARSET=latin1;
491
492-- --------------------------------------------------------
493
494--
495-- Table structure for table `raid_player_rewards`
496--
497
498DROP TABLE IF EXISTS `raid_player_rewards`;
499CREATE TABLE IF NOT EXISTS `raid_player_rewards` (
500  `account_id` bigint(20) NOT NULL,
501  `raid_id` int(255) NOT NULL,
502  `time_taken_secs` int(40) NOT NULL DEFAULT '0',
503  `rewards_to_claim` text NOT NULL,
504  `hourly_cooldown` int(1) NOT NULL DEFAULT '0',
505  `daily_cooldown` int(1) NOT NULL DEFAULT '0',
506  `weekly_cooldown` int(1) NOT NULL DEFAULT '0',
507  `claimed` int(1) NOT NULL DEFAULT '0',
508  PRIMARY KEY (`account_id`,`raid_id`)
509) ENGINE=MyISAM DEFAULT CHARSET=latin1;
510
511--
512-- Dumping data for table `raid_player_rewards`
513--
514
515INSERT INTO `raid_player_rewards` (`account_id`, `raid_id`, `time_taken_secs`, `rewards_to_claim`, `hourly_cooldown`, `daily_cooldown`, `weekly_cooldown`, `claimed`) VALUES
516(1, 4, 0, '', 1, 1, 1, 1);
517COMMIT;
518
519/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
520/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
521/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;