· 7 years ago · Dec 21, 2018, 02:38 PM
1-- phpMyAdmin SQL Dump
2-- version 4.7.9
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1:3306
6-- Generation Time: Dec 21, 2018 at 02:17 PM
7-- Server version: 5.7.21
8-- PHP Version: 7.2.6
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `legacy_gamedata`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `raids`
29--
30
31DROP TABLE IF EXISTS `raids`;
32CREATE TABLE IF NOT EXISTS `raids` (
33 `id` int(255) NOT NULL AUTO_INCREMENT,
34 `name` varchar(80) NOT NULL,
35 `description` text NOT NULL,
36 `event` int(1) NOT NULL DEFAULT '0',
37 `hidden` int(1) NOT NULL DEFAULT '0',
38 `min_level` int(3) NOT NULL DEFAULT '1',
39 `public_instance` int(1) NOT NULL DEFAULT '0',
40 `start_x` int(3) NOT NULL DEFAULT '0',
41 `start_y` int(3) NOT NULL DEFAULT '0',
42 `start_z` int(3) NOT NULL DEFAULT '0',
43 `success_message` varchar(200) NOT NULL DEFAULT 'You have completed your journey.',
44 `on_raid_success` text NOT NULL,
45 `on_raid_success_quest` varchar(30) NOT NULL,
46 `hourly_rewards` text NOT NULL,
47 `daily_rewards` text NOT NULL,
48 `weekly_rewards` text NOT NULL,
49 `common_rewards` text NOT NULL,
50 `base_xp_reward` int(20) NOT NULL DEFAULT '0',
51 `base_credits_reward` int(20) NOT NULL DEFAULT '0',
52 PRIMARY KEY (`id`),
53 UNIQUE KEY `name` (`name`)
54) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
55
56--
57-- Dumping data for table `raids`
58--
59
60INSERT 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
61(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),
62(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),
63(4, 'A Very Merry Realm', 'An unidentified flying object that previously crashed just outside the hive was identified to be a sleigh. When you went to investigate, you found a heavily injured little elf. His last words were "Ride the sleigh and save us from him.. from the fake Santa."', 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', '', 1500, 15);
64
65-- --------------------------------------------------------
66
67--
68-- Table structure for table `raid_ai`
69--
70
71DROP TABLE IF EXISTS `raid_ai`;
72CREATE TABLE IF NOT EXISTS `raid_ai` (
73 `id` bigint(20) NOT NULL AUTO_INCREMENT,
74 `name` varchar(30) NOT NULL,
75 `icon` varchar(120) NOT NULL,
76 `image` varchar(100) NOT NULL,
77 `max_hp` int(11) NOT NULL DEFAULT '50',
78 `level` int(11) NOT NULL DEFAULT '10',
79 `boss` int(1) NOT NULL DEFAULT '0',
80 `armor` varchar(45) NOT NULL DEFAULT '',
81 `weapon1` varchar(45) NOT NULL DEFAULT '',
82 `weapon2` varchar(45) NOT NULL DEFAULT '',
83 `misc1` varchar(45) NOT NULL DEFAULT '',
84 `misc2` varchar(45) NOT NULL DEFAULT '',
85 `drops` text NOT NULL,
86 `default_player_cannot_move` int(2) NOT NULL DEFAULT '0',
87 PRIMARY KEY (`id`)
88) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
89
90--
91-- Dumping data for table `raid_ai`
92--
93
94INSERT INTO `raid_ai` (`id`, `name`, `icon`, `image`, `max_hp`, `level`, `boss`, `armor`, `weapon1`, `weapon2`, `misc1`, `misc2`, `drops`, `default_player_cannot_move`) VALUES
95(1, 'Brotherhood Avatar', '', 'groups/78.png', 300, 100, 1, '', '', '', '', '', '', 0),
96(2, 'Slum Thug', '', 'groups/7.png', 300, 50, 1, '', '', '', '', '', '', 0),
97(3, '???', '', 'raids/npc/male_husk.png', 10, 1, 0, 'Coat', 'Broken Bottle', 'Broken Bottle', '', '', '', 0),
98(4, '???', '', 'raids/npc/female_husk.png', 10, 1, 0, 'Coat', 'Broken Bottle', 'Broken Bottle', '', '', '', 0),
99(5, 'Observer: Ventrix', '', 'hunting/i_observer.png', 500, 80, 1, '', '', '', '', '', '', 0),
100(6, 'Residential Guard', '', 'groups/13.png', 300, 80, 1, '', '', '', '', '', '', 0),
101(7, 'Hive Riot Police', '', 'groups/24.png', 300, 80, 1, '', '', '', '', '', '', 0),
102(8, 'Senate Guard', '', 'groups/34.png', 300, 80, 1, '', '', '', '', '', '', 0),
103(9, 'Chamber Guard', '', 'groups/44.png', 300, 80, 1, '', '', '', '', '', '', 0),
104(10, 'Guard Dog', '', 'groups/52.png', 300, 80, 1, '', '', '', '', '', '', 0),
105(11, 'Blood Crazed', '', 'groups/62.png', 300, 80, 1, '', '', '', '', '', '', 0),
106(12, 'Sanctuary Guard', '', 'groups/75.png', 300, 80, 1, '', '', '', '', '', '', 0),
107(13, 'Void Pit', '', 'raids/trials/npc/void pit.png', 10, 10, 1, '', '', '', '', '', '', 0),
108(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),
109(15, 'Feral Reindeer', '', 'raids/npc/christmas/reindeer.png', 60, 20, 0, '', '', '', '', '', '', 0),
110(16, 'Mimic', 'raids/npc/christmas/mimic_icon.png', 'raids/npc/christmas/mimic.png', 100, 40, 0, '', '', '', '', '', '25:Pie Mix#25:Flour', 1),
111(17, 'Little Helper', '', 'raids/npc/christmas/little_helper.png', 150, 60, 1, '', '', '', '', '', '', 0),
112(18, 'Nutcracker', '', 'raids/npc/christmas/nutcracker.png', 180, 75, 1, '', '', '', '', '', '', 1),
113(19, 'Frost Knight', '', 'raids/npc/christmas/knight.png', 240, 80, 1, '', '', '', '', '', '3:Abstruse Crystal', 1),
114(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);
115
116-- --------------------------------------------------------
117
118--
119-- Table structure for table `raid_flags`
120--
121
122DROP TABLE IF EXISTS `raid_flags`;
123CREATE TABLE IF NOT EXISTS `raid_flags` (
124 `raid_id` int(255) NOT NULL,
125 `flag` varchar(200) NOT NULL,
126 `expires` float NOT NULL DEFAULT '0',
127 `on_flag` text NOT NULL,
128 `on_expiry` text NOT NULL,
129 PRIMARY KEY (`raid_id`,`flag`)
130) ENGINE=MyISAM DEFAULT CHARSET=latin1;
131
132-- --------------------------------------------------------
133
134--
135-- Table structure for table `raid_instances`
136--
137
138DROP TABLE IF EXISTS `raid_instances`;
139CREATE TABLE IF NOT EXISTS `raid_instances` (
140 `id` bigint(20) NOT NULL AUTO_INCREMENT,
141 `raid_id` int(255) NOT NULL,
142 `leader` varchar(10) DEFAULT NULL,
143 `status` int(1) NOT NULL DEFAULT '0',
144 PRIMARY KEY (`id`),
145 UNIQUE KEY `UNIQUE` (`leader`),
146 UNIQUE KEY `map_id` (`raid_id`,`leader`)
147) ENGINE=InnoDB AUTO_INCREMENT=346 DEFAULT CHARSET=latin1;
148
149-- --------------------------------------------------------
150
151--
152-- Table structure for table `raid_instance_ai`
153--
154
155DROP TABLE IF EXISTS `raid_instance_ai`;
156CREATE TABLE IF NOT EXISTS `raid_instance_ai` (
157 `id` bigint(20) NOT NULL AUTO_INCREMENT,
158 `entity_id` varchar(30) NOT NULL,
159 `name` varchar(30) NOT NULL,
160 `instance_id` bigint(20) NOT NULL,
161 `ai_id` int(255) NOT NULL,
162 `hp` int(11) NOT NULL DEFAULT '50',
163 `max_hp` int(11) NOT NULL DEFAULT '50',
164 `level` int(11) NOT NULL DEFAULT '10',
165 `state` int(2) NOT NULL DEFAULT '0',
166 `x` int(3) NOT NULL DEFAULT '0',
167 `y` int(3) NOT NULL DEFAULT '0',
168 `z` int(3) NOT NULL DEFAULT '0',
169 `hidden` int(2) NOT NULL DEFAULT '0',
170 `dest_x` int(3) NOT NULL,
171 `dest_y` int(3) NOT NULL,
172 `dest_z` int(3) NOT NULL DEFAULT '0',
173 `hostile` int(1) NOT NULL DEFAULT '1',
174 `player_cannot_move` int(1) NOT NULL DEFAULT '0',
175 `interact` varchar(40) NOT NULL DEFAULT '',
176 `patrol_route` varchar(300) NOT NULL,
177 `patrol_index` int(3) NOT NULL,
178 `on_interact` text NOT NULL,
179 `on_defeat` text NOT NULL,
180 `on_destination` text NOT NULL,
181 PRIMARY KEY (`id`),
182 KEY `INDEX` (`instance_id`),
183 KEY `entity_id` (`entity_id`,`instance_id`)
184) ENGINE=InnoDB AUTO_INCREMENT=5676 DEFAULT CHARSET=latin1;
185
186-- --------------------------------------------------------
187
188--
189-- Table structure for table `raid_instance_flags`
190--
191
192DROP TABLE IF EXISTS `raid_instance_flags`;
193CREATE TABLE IF NOT EXISTS `raid_instance_flags` (
194 `instance_id` int(255) NOT NULL,
195 `account` varchar(40) NOT NULL,
196 `flag` varchar(200) NOT NULL,
197 `created` int(11) NOT NULL,
198 `updated` int(11) NOT NULL,
199 `counter` int(10) NOT NULL DEFAULT '1',
200 PRIMARY KEY (`instance_id`,`account`,`flag`),
201 UNIQUE KEY `account` (`account`,`flag`)
202) ENGINE=MyISAM DEFAULT CHARSET=latin1;
203
204-- --------------------------------------------------------
205
206--
207-- Table structure for table `raid_instance_tiles`
208--
209
210DROP TABLE IF EXISTS `raid_instance_tiles`;
211CREATE TABLE IF NOT EXISTS `raid_instance_tiles` (
212 `instance_id` int(255) NOT NULL,
213 `x` int(4) NOT NULL,
214 `y` int(4) NOT NULL,
215 `z` int(4) NOT NULL,
216 `hidden` int(2) NOT NULL DEFAULT '0',
217 `wall` int(2) NOT NULL DEFAULT '0',
218 `objective_id` int(255) NOT NULL DEFAULT '0',
219 `objective_hp` int(6) NOT NULL DEFAULT '0',
220 `objective_max_hp` int(6) NOT NULL DEFAULT '100',
221 `movable` int(1) NOT NULL DEFAULT '0',
222 `search_items` text NOT NULL,
223 `teleports` int(1) NOT NULL DEFAULT '0',
224 `teleport_x` int(4) NOT NULL,
225 `teleport_y` int(4) NOT NULL,
226 `teleport_z` int(4) NOT NULL,
227 `interact` varchar(40) NOT NULL,
228 `on_interact` text NOT NULL,
229 `on_tile_enter` text NOT NULL,
230 `on_move` text NOT NULL
231 PRIMARY KEY (`instance_id`,`x`,`y`,`z`) USING BTREE
232) ENGINE=MyISAM DEFAULT CHARSET=latin1;
233
234-- --------------------------------------------------------
235
236--
237-- Table structure for table `raid_maps`
238--
239
240DROP TABLE IF EXISTS `raid_maps`;
241CREATE TABLE IF NOT EXISTS `raid_maps` (
242 `raid_id` int(255) NOT NULL,
243 `z` int(3) NOT NULL DEFAULT '0'
244 `map_image` varchar(200) NOT NULL,
245 `columns` int(4) NOT NULL DEFAULT '15',
246 `rows` int(4) NOT NULL DEFAULT '15',
247 `static_walls` text NOT NULL,
248 `static_floors` text NOT NULL
249 PRIMARY KEY (`raid_id`,`z`)
250) ENGINE=MyISAM DEFAULT CHARSET=latin1;
251
252--
253-- Dumping data for table `raid_maps`
254--
255
256INSERT INTO `raid_maps` (`raid_id`, `z`, `map_image`, `columns`, `rows`, `static_walls`, `static_floors`) VALUES
257(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'),
258(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', ''),
259(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', '');
260
261-- --------------------------------------------------------
262
263--
264-- Table structure for table `raid_maps_ai_data`
265--
266
267DROP TABLE IF EXISTS `raid_maps_ai_data`;
268CREATE TABLE IF NOT EXISTS `raid_maps_ai_data` (
269 `id` int(255) NOT NULL AUTO_INCREMENT,
270 `entity_id` varchar(30) NOT NULL
271 `raid_id` int(255) NOT NULL,
272 `state` int(3) NOT NULL DEFAULT '0',
273 `x` int(3) NOT NULL,
274 `y` int(3) NOT NULL,
275 `z` int(3) NOT NULL DEFAULT '0',
276 `hidden` int(2) NOT NULL DEFAULT '0',
277 `dest_x` int(3) NOT NULL DEFAULT '0',
278 `dest_y` int(3) NOT NULL DEFAULT '0',
279 `dest_z` int(3) NOT NULL DEFAULT '0',
280 `ai_id` int(255) NOT NULL,
281 `ai_count` int(3) NOT NULL DEFAULT '0',
282 `hostile` int(1) NOT NULL DEFAULT '1',
283 `player_cannot_move` int(11) NOT NULL DEFAULT '0'
284 `interact` varchar(40) NOT NULL DEFAULT '',
285 `patrol_route` varchar(300) NOT NULL,
286 `on_interact` text NOT NULL,
287 `on_defeat` text NOT NULL,
288 PRIMARY KEY (`id`),
289 KEY `map_id` (`raid_id`),
290 KEY `y` (`y`,`z`,`x`),
291 KEY `map_id_2` (`raid_id`),
292 KEY `entity_id` (`entity_id`,`raid_id`)
293) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=latin1;
294
295--
296-- Dumping data for table `raid_maps_ai_data`
297--
298
299INSERT 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
300(1, '', 1, 0, 7, 7, 0, 0, 0, 0, 0, 3, 2, 1, 0, '', '', '', ''),
301(2, '', 1, 0, 8, 11, 0, 0, 0, 0, 0, 4, 2, 1, 0, '', '', '', ''),
302(3, '', 1, 0, 11, 3, 0, 0, 0, 0, 0, 5, 1, 0, 0, 'Observe', '', 'endRaidSuccess', ''),
303(4, '', 2, 0, 0, 2, 2, 0, 0, 0, 0, 2, 1, 1, 0, '', '', '', ''),
304(5, '', 3, 0, 21, 3, 0, 0, 0, 0, 0, 8, 1, 1, 0, 'Talk', '', 'checkFlag:npc2##flag:npc3##endCondition', ''),
305(6, '', 3, 0, 23, 3, 0, 0, 0, 0, 0, 10, 1, 1, 0, 'Talk', '', 'checkFlag:npc4##flag:npc5##endCondition', ''),
306(7, '', 3, 0, 23, 5, 0, 0, 0, 0, 0, 2, 1, 1, 0, '', '', '', ''),
307(8, '', 3, 0, 21, 5, 0, 0, 0, 0, 0, 7, 1, 1, 0, 'Talk', '', 'checkFlag:npc1##flag:npc2##endCondition', ''),
308(9, '', 3, 0, 23, 7, 0, 0, 0, 0, 0, 12, 1, 1, 0, 'Talk', '', 'checkFlag:npc5##flag:npc6##flag:task1Completed##sendClientMsg:Correct##endCondition', ''),
309(10, '', 3, 0, 21, 7, 0, 0, 0, 0, 0, 1, 1, 1, 0, 'Talk', '', '', ''),
310(11, '', 3, 0, 19, 3, 0, 0, 0, 0, 0, 6, 1, 1, 0, 'Talk', '', 'flag:npc1', ''),
311(12, '', 3, 0, 19, 5, 0, 0, 0, 0, 0, 11, 1, 1, 0, '', '', '', ''),
312(13, '', 3, 0, 19, 7, 0, 0, 0, 0, 0, 9, 1, 1, 0, 'Talk', '', 'checkFlag:npc3##flag:npc4##endCondition', ''),
313(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', '', ''),
314(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', '', ''),
315(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', '', ''),
316(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', '', ''),
317(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', '', ''),
318(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', '', ''),
319(20, '', 3, 1, 20, 19, 0, 0, 0, 0, 0, 13, 1, 0, 0, '', 'e,s,s,w,w,n,n,e', '', ''),
320(21, '', 3, 1, 20, 21, 0, 0, 0, 0, 0, 13, 1, 0, 0, '', 'w,n,n,e,e,s,s,w', '', ''),
321(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>'),
322(23, '', 4, 0, 11, 10, 0, 0, 0, 0, 0, 18, 1, 1, 1, '', '', '', ''),
323(24, '', 4, 0, 9, 10, 0, 0, 0, 0, 0, 18, 1, 1, 1, 'Talk', '', 'sendClientMsg:The.. key.. lies.. in.. his.. reci..', ''),
324(25, '', 4, 0, 4, 4, 0, 0, 0, 0, 0, 15, 1, 1, 0, '', '', '', ''),
325(26, '', 4, 0, 1, 4, 0, 0, 0, 0, 0, 15, 1, 1, 0, '', '', '', ''),
326(27, '', 4, 0, 1, 6, 0, 0, 0, 0, 0, 15, 1, 1, 0, '', '', '', ''),
327(28, '', 4, 0, 3, 3, 0, 0, 0, 0, 0, 15, 1, 1, 0, '', '', '', ''),
328(29, '', 4, 0, 3, 6, 0, 0, 0, 0, 0, 15, 1, 1, 0, '', '', '', ''),
329(31, '', 4, 0, 0, 7, 0, 0, 0, 0, 0, 16, 1, 1, 1, '', '', '', 'flag:mimicKilled3'),
330(32, '', 4, 0, 7, 14, 0, 0, 0, 0, 0, 16, 1, 1, 1, '', '', '', 'flag:mimicKilled2'),
331(33, '', 4, 0, 14, 7, 0, 0, 0, 0, 0, 16, 1, 1, 1, '', '', '', 'flag:mimicKilled1'),
332(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'),
333(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'),
334(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'),
335(37, '', 4, 0, 7, 10, 0, 0, 0, 0, 0, 18, 1, 1, 1, '', '', '', ''),
336(38, '', 4, 0, 8, 11, 0, 0, 0, 0, 0, 18, 1, 1, 1, 'Talk', '', 'sendClientMsg:I.. am.. not.. in.. control.', ''),
337(39, '', 4, 0, 10, 11, 0, 0, 0, 0, 0, 18, 1, 1, 1, '', '', '', ''),
338(40, '', 4, 0, 9, 12, 0, 0, 0, 0, 0, 18, 1, 1, 1, 'Talk', '', 'sendClientMsg:I.. am.. drifting.', ''),
339(41, 'granny', 4, 0, 5, 11, 0, 1, 0, 0, 0, 20, 1, 1, 0, '', '', '', 'removeBuff:holidaySpirit##endRaidSuccess');
340
341-- --------------------------------------------------------
342
343--
344-- Table structure for table `raid_maps_tiles_data`
345--
346
347DROP TABLE IF EXISTS `raid_maps_tiles_data`;
348CREATE TABLE IF NOT EXISTS `raid_maps_tiles_data` (
349 `raid_id` int(255) NOT NULL,
350 `x` int(4) NOT NULL,
351 `y` int(4) NOT NULL,
352 `z` int(4) NOT NULL DEFAULT '0',
353 `hidden` int(2) NOT NULL DEFAULT '0',
354 `wall` int(2) NOT NULL DEFAULT '0',
355 `objective_id` int(255) NOT NULL DEFAULT '0',
356 `objective_max_hp` int(6) NOT NULL DEFAULT '100',
357 `movable` int(1) NOT NULL DEFAULT '0',
358 `search_items` text NOT NULL,
359 `teleports` int(1) NOT NULL DEFAULT '0',
360 `teleport_x` int(4) NOT NULL,
361 `teleport_y` int(4) NOT NULL,
362 `teleport_z` int(4) NOT NULL,
363 `interact` varchar(40) NOT NULL,
364 `on_interact` text NOT NULL,
365 `on_tile_enter` text NOT NULL,
366 `on_move` text NOT NULL
367 PRIMARY KEY (`raid_id`,`x`,`y`,`z`)
368) ENGINE=MyISAM DEFAULT CHARSET=latin1;
369
370--
371-- Dumping data for table `raid_maps_tiles_data`
372--
373
374INSERT 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
375(1, 1, 9, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:This is your future.##flag:done', ''),
376(1, 3, 9, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:This is also your past.', ''),
377(1, 7, 7, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:Those who are left alive.. will no longer be alive.', ''),
378(1, 8, 11, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:This is what you will become.\r\n', ''),
379(1, 11, 8, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:We do not interfere.', ''),
380(1, 11, 7, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:We only observe.', ''),
381(1, 11, 6, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:But now you have observed.', ''),
382(1, 11, 5, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:Will you interfere?', ''),
383(1, 11, 4, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:Tell me...', ''),
384(1, 11, 3, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:..<font class=itemPhantom><b>Observer</b></font>.', ''),
385(3, 10, 0, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'spawnObjective:2', ''),
386(3, 10, 4, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'spawnObjective:3', ''),
387(3, 14, 0, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'spawnObjective:5', ''),
388(3, 14, 4, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'spawnObjective:4', ''),
389(3, 18, 19, 0, 0, 0, 6, 100, 1, '', 0, 0, 0, 0, '', '', '', ''),
390(3, 1, 18, 0, 0, 0, 7, 100, 0, '', 1, 5, 21, 0, '', '', '', ''),
391(3, 1, 20, 0, 0, 0, 7, 100, 0, '', 1, 1, 19, 0, '', '', '', ''),
392(3, 0, 19, 0, 0, 0, 7, 100, 0, '', 1, 1, 23, 0, '', '', '', ''),
393(3, 2, 19, 0, 0, 0, 7, 100, 0, '', 1, 3, 16, 0, '', '', '', ''),
394(3, 0, 21, 0, 0, 0, 7, 100, 0, '', 1, 1, 19, 0, '', '', '', ''),
395(3, 2, 21, 0, 0, 0, 7, 100, 0, '', 1, 3, 19, 0, '', '', '', ''),
396(3, 1, 22, 0, 0, 0, 7, 100, 0, '', 1, 2, 18, 0, '', '', '', ''),
397(3, 4, 19, 0, 0, 0, 7, 100, 0, '', 1, 3, 24, 0, '', '', '', ''),
398(3, 6, 19, 0, 0, 0, 7, 100, 0, '', 1, 3, 16, 0, '', '', '', ''),
399(3, 4, 21, 0, 0, 0, 7, 100, 0, '', 1, 5, 23, 0, '', '', '', ''),
400(3, 6, 21, 0, 0, 0, 7, 100, 0, '', 1, 2, 22, 0, '', '', '', ''),
401(3, 5, 22, 0, 0, 0, 7, 100, 0, '', 1, 5, 19, 0, '', '', '', ''),
402(3, 5, 18, 0, 0, 0, 7, 100, 0, '', 1, 4, 20, 0, '', '', '', ''),
403(3, 5, 20, 0, 0, 0, 7, 100, 0, '', 1, 3, 21, 0, '', '', '', ''),
404(3, 3, 17, 0, 0, 0, 7, 100, 0, '', 1, 0, 22, 0, '', '', '', ''),
405(3, 4, 24, 0, 0, 0, 7, 100, 0, '', 1, 3, 16, 0, '', '', '', ''),
406(3, 2, 24, 0, 0, 0, 0, 100, 0, '', 1, 5, 16, 0, '', '', '', ''),
407(3, 6, 16, 0, 0, 0, 0, 100, 0, '', 1, 1, 16, 0, '', '', '', ''),
408(3, 0, 15, 0, 0, 0, 0, 100, 0, '', 1, 3, 16, 0, '', '', '', ''),
409(3, 0, 16, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'flag:task3Secret\r\n', ''),
410(4, 5, 11, 0, 0, 0, 8, 100, 0, '', 0, 0, 0, 0, 'Desecrate', 'despawnObjective##showAI:granny', '', ''),
411(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', '', ''),
412(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', '', ''),
413(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', '', ''),
414(4, 4, 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', '', ''),
415(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', ''),
416(4, 5, 12, 0, 1, 0, 12, 100, 0, '', 1, 11, 2, 0, '', '', '', ''),
417(4, 11, 3, 0, 0, 0, 14, 100, 0, '', 0, 0, 0, 0, '', '', '', ''),
418(4, 11, 4, 0, 0, 0, 15, 100, 0, '', 1, 5, 11, 0, '', '', '', ''),
419(4, 11, 2, 0, 0, 1, 13, 100, 0, '', 0, 0, 0, 0, '', '', '', '');
420
421-- --------------------------------------------------------
422
423--
424-- Table structure for table `raid_objectives`
425--
426
427DROP TABLE IF EXISTS `raid_objectives`;
428CREATE TABLE IF NOT EXISTS `raid_objectives` (
429 `id` int(255) NOT NULL AUTO_INCREMENT,
430 `name` varchar(40) NOT NULL,
431 `image` varchar(200) NOT NULL,
432 PRIMARY KEY (`id`)
433) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
434
435--
436-- Dumping data for table `raid_objectives`
437--
438
439INSERT INTO `raid_objectives` (`id`, `name`, `image`) VALUES
440(1, 'Strange Hive', 'warfare/strangehive.gif'),
441(2, 'Platform', 'raids/objectives/trials/knowledge.png'),
442(3, 'Platform', 'raids/objectives/trials/strength.png'),
443(4, 'Platform', 'raids/objectives/trials/history.png'),
444(5, 'Platform', 'raids/objectives/trials/courage.png'),
445(6, 'Strange Platform', 'raids/objectives/trials/sequence_platform4.png'),
446(7, 'Teleporter', 'raids/objectives/trials/teleporter.png'),
447(8, 'Strange Grave', 'raids/objectives/christmas/grave.png'),
448(9, 'Gift', 'raids/objectives/christmas/gift.png'),
449(10, 'Candy Cane', 'raids/objectives/christmas/candy_cane.png'),
450(11, 'Platform', 'raids/objectives/christmas/nose_meh.png'),
451(12, 'Portal', 'raids/objectives/christmas/portal.png'),
452(13, 'Ice Block', 'raids/objectives/christmas/frozen.png'),
453(14, 'Snow Trail', 'raids/objectives/christmas/snow_trail.png'),
454(15, 'Crashed Sleigh', 'raids/objectives/christmas/crashed_sleigh.png'),
455(16, 'Activated Platform', 'raids/objectives/christmas/nose_activated.png');
456
457-- --------------------------------------------------------
458
459--
460-- Table structure for table `raid_players`
461--
462
463DROP TABLE IF EXISTS `raid_players`;
464CREATE TABLE IF NOT EXISTS `raid_players` (
465 `id` bigint(20) NOT NULL AUTO_INCREMENT,
466 `account` varchar(10) DEFAULT NULL,
467 `instance_id` bigint(20) NOT NULL,
468 `team` int(4) NOT NULL DEFAULT '1',
469 `x` int(3) NOT NULL DEFAULT '0',
470 `y` int(3) NOT NULL DEFAULT '0',
471 `z` int(3) NOT NULL DEFAULT '0',
472 `last_active` datetime NOT NULL,
473 `rewards` text NOT NULL,
474 PRIMARY KEY (`id`),
475 UNIQUE KEY `UNIQUE` (`account`),
476 KEY `INDEX` (`instance_id`)
477) ENGINE=InnoDB AUTO_INCREMENT=384 DEFAULT CHARSET=latin1;
478
479-- --------------------------------------------------------
480
481--
482-- Table structure for table `raid_player_rewards`
483--
484
485DROP TABLE IF EXISTS `raid_player_rewards`;
486CREATE TABLE IF NOT EXISTS `raid_player_rewards` (
487 `account_id` bigint(20) NOT NULL,
488 `raid_id` int(255) NOT NULL,
489 `time_taken_secs` int(40) NOT NULL DEFAULT '0',
490 `rewards_to_claim` text NOT NULL,
491 `hourly_cooldown` int(1) NOT NULL DEFAULT '0',
492 `daily_cooldown` int(1) NOT NULL DEFAULT '0',
493 `weekly_cooldown` int(1) NOT NULL DEFAULT '0',
494 `claimed` int(1) NOT NULL DEFAULT '0',
495 `raid_completed` int(1) NOT NULL DEFAULT '0',
496 PRIMARY KEY (`account_id`,`raid_id`)
497) ENGINE=MyISAM DEFAULT CHARSET=latin1;
498COMMIT;