vgaqcuqg

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', 'Phantom', '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', 'Phantom', '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
11DROP TABLE IF EXISTS `raids`;
12CREATE TABLE IF NOT EXISTS `raids` (
13  `id` int(40) NOT NULL AUTO_INCREMENT,
14  `name` varchar(80) NOT NULL,
15  `description` text NOT NULL,
16  `event` int(1) NOT NULL DEFAULT '0',
17  `hidden` int(1) NOT NULL DEFAULT '0',
18  `min_level` int(3) NOT NULL DEFAULT '1',
19  `public_instance` int(1) NOT NULL DEFAULT '0',
20  `start_x` int(3) NOT NULL DEFAULT '0',
21  `start_y` int(3) NOT NULL DEFAULT '0',
22  `start_z` int(3) NOT NULL DEFAULT '0',
23  `success_message` varchar(200) NOT NULL DEFAULT 'You have completed your journey.',
24  `on_raid_success` text NOT NULL,
25  `on_raid_success_quest` varchar(30) NOT NULL,
26  `hourly_rewards` text NOT NULL,
27  `daily_rewards` text NOT NULL,
28  `weekly_rewards` text NOT NULL,
29  `common_rewards` text NOT NULL,
30  `base_xp_reward` int(20) NOT NULL DEFAULT '0',
31  `base_credits_reward` int(20) NOT NULL DEFAULT '0',
32  PRIMARY KEY (`id`),
33  UNIQUE KEY `name` (`name`)
34) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
35
36
37INSERT 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
38(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),
39(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),
40(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);
41
42DROP TABLE IF EXISTS `raid_ai`;
43CREATE TABLE IF NOT EXISTS `raid_ai` (
44  `id` bigint(20) NOT NULL AUTO_INCREMENT,
45  `name` varchar(30) NOT NULL,
46  `icon` varchar(120) NOT NULL,
47  `image` varchar(100) NOT NULL,
48  `max_hp` int(11) NOT NULL DEFAULT '50',
49  `level` int(11) NOT NULL DEFAULT '10',
50  `boss` int(1) NOT NULL DEFAULT '0',
51  `armor` varchar(45) NOT NULL DEFAULT '',
52  `weapon1` varchar(45) NOT NULL DEFAULT '',
53  `weapon2` varchar(45) NOT NULL DEFAULT '',
54  `misc1` varchar(45) NOT NULL DEFAULT '',
55  `misc2` varchar(45) NOT NULL DEFAULT '',
56  `drops` text NOT NULL,
57  `default_player_cannot_move` int(2) NOT NULL DEFAULT '0',
58  PRIMARY KEY (`id`)
59) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
60
61
62INSERT INTO `raid_ai` (`id`, `name`, `icon`, `image`, `max_hp`, `level`, `boss`, `armor`, `weapon1`, `weapon2`, `misc1`, `misc2`, `drops`, `default_player_cannot_move`) VALUES
63(1, 'Brotherhood Avatar', '', 'groups/78.png', 300, 100, 1, '', '', '', '', '', '', 0),
64(2, 'Slum Thug', '', 'groups/7.png', 300, 50, 1, '', '', '', '', '', '', 0),
65(3, '???', '', 'raids/npc/male_husk.png', 10, 1, 0, 'Coat', 'Broken Bottle', 'Broken Bottle', '', '', '', 0),
66(4, '???', '', 'raids/npc/female_husk.png', 10, 1, 0, 'Coat', 'Broken Bottle', 'Broken Bottle', '', '', '', 0),
67(5, 'Observer: Ventrix', '', 'hunting/i_observer.png', 500, 80, 1, '', '', '', '', '', '', 0),
68(6, 'Residential Guard', '', 'groups/13.png', 300, 80, 1, '', '', '', '', '', '', 0),
69(7, 'Hive Riot Police', '', 'groups/24.png', 300, 80, 1, '', '', '', '', '', '', 0),
70(8, 'Senate Guard', '', 'groups/34.png', 300, 80, 1, '', '', '', '', '', '', 0),
71(9, 'Chamber Guard', '', 'groups/44.png', 300, 80, 1, '', '', '', '', '', '', 0),
72(10, 'Guard Dog', '', 'groups/52.png', 300, 80, 1, '', '', '', '', '', '', 0),
73(11, 'Blood Crazed', '', 'groups/62.png', 300, 80, 1, '', '', '', '', '', '', 0),
74(12, 'Sanctuary Guard', '', 'groups/75.png', 300, 80, 1, '', '', '', '', '', '', 0),
75(13, 'Void Pit', '', 'raids/trials/npc/void pit.png', 10, 10, 1, '', '', '', '', '', '', 0),
76(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),
77(15, 'Feral Reindeer', '', 'raids/npc/christmas/reindeer.png', 60, 20, 0, '', '', '', '', '', '', 0),
78(16, 'Mimic', 'raids/npc/christmas/mimic_icon.png', 'raids/npc/christmas/mimic.png', 100, 40, 0, '', '', '', '', '', '25:Pie Mix#25:Flour', 1),
79(17, 'Little Helper', '', 'raids/npc/christmas/little_helper.png', 150, 60, 1, '', '', '', '', '', '', 0),
80(18, 'Nutcracker', '', 'raids/npc/christmas/nutcracker.png', 180, 75, 1, '', '', '', '', '', '', 1),
81(19, 'Frost Knight', '', 'raids/npc/christmas/knight.png', 240, 80, 1, '', '', '', '', '', '3:Abstruse Crystal', 1),
82(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);
83
84DROP TABLE IF EXISTS `raid_flags`;
85CREATE TABLE IF NOT EXISTS `raid_flags` (
86  `raid_id` int(40) NOT NULL,
87  `flag` varchar(200) NOT NULL,
88  `expires` float NOT NULL DEFAULT '0',
89  `on_flag` text NOT NULL,
90  `on_expiry` text NOT NULL,
91  PRIMARY KEY (`raid_id`,`flag`)
92) ENGINE=MyISAM DEFAULT CHARSET=latin1;
93
94DROP TABLE IF EXISTS `raid_instances`;
95CREATE TABLE IF NOT EXISTS `raid_instances` (
96  `id` bigint(20) NOT NULL AUTO_INCREMENT,
97  `raid_id` int(40) NOT NULL,
98  `leader` varchar(10) DEFAULT NULL,
99  `status` int(1) NOT NULL DEFAULT '0',
100  PRIMARY KEY (`id`),
101  UNIQUE KEY `UNIQUE` (`leader`),
102  UNIQUE KEY `map_id` (`raid_id`,`leader`)
103) ENGINE=InnoDB AUTO_INCREMENT=346 DEFAULT CHARSET=latin1;
104
105DROP TABLE IF EXISTS `raid_instance_ai`;
106CREATE TABLE IF NOT EXISTS `raid_instance_ai` (
107  `id` bigint(20) NOT NULL AUTO_INCREMENT,
108  `entity_id` varchar(30) NOT NULL,
109  `name` varchar(30) NOT NULL,
110  `instance_id` bigint(20) NOT NULL,
111  `ai_id` int(255) NOT NULL,
112  `hp` int(11) NOT NULL DEFAULT '50',
113  `max_hp` int(11) NOT NULL DEFAULT '50',
114  `level` int(11) NOT NULL DEFAULT '10',
115  `state` int(2) NOT NULL DEFAULT '0',
116  `x` int(3) NOT NULL DEFAULT '0',
117  `y` int(3) NOT NULL DEFAULT '0',
118  `z` int(3) NOT NULL DEFAULT '0',
119  `hidden` int(2) NOT NULL DEFAULT '0',
120  `dest_x` int(3) NOT NULL,
121  `dest_y` int(3) NOT NULL,
122  `dest_z` int(3) NOT NULL DEFAULT '0',
123  `hostile` int(1) NOT NULL DEFAULT '1',
124  `player_cannot_move` int(1) NOT NULL DEFAULT '0',
125  `interact` varchar(40) NOT NULL DEFAULT '',
126  `patrol_route` varchar(300) NOT NULL,
127  `patrol_index` int(3) NOT NULL,
128  `on_interact` text NOT NULL,
129  `on_defeat` text NOT NULL,
130  `on_destination` text NOT NULL,
131  PRIMARY KEY (`id`),
132  KEY `INDEX` (`instance_id`),
133  KEY `entity_id` (`entity_id`,`instance_id`)
134) ENGINE=InnoDB AUTO_INCREMENT=5676 DEFAULT CHARSET=latin1;
135
136DROP TABLE IF EXISTS `raid_instance_flags`;
137CREATE TABLE IF NOT EXISTS `raid_instance_flags` (
138  `instance_id` int(255) NOT NULL,
139  `account` varchar(40) NOT NULL,
140  `flag` varchar(200) NOT NULL,
141  `created` int(11) NOT NULL,
142  `updated` int(11) NOT NULL,
143  `counter` int(10) NOT NULL DEFAULT '1',
144  PRIMARY KEY (`instance_id`,`account`,`flag`),
145  UNIQUE KEY `account` (`account`,`flag`)
146) ENGINE=MyISAM DEFAULT CHARSET=latin1;
147
148DROP TABLE IF EXISTS `raid_instance_tiles`;
149CREATE TABLE IF NOT EXISTS `raid_instance_tiles` (
150  `instance_id` int(255) NOT NULL,
151  `x` int(4) NOT NULL,
152  `y` int(4) NOT NULL,
153  `z` int(4) NOT NULL,
154  `hidden` int(2) NOT NULL DEFAULT '0',
155  `wall` int(2) NOT NULL DEFAULT '0',
156  `objective_id` int(255) NOT NULL DEFAULT '0',
157  `objective_hp` int(6) NOT NULL DEFAULT '0',
158  `objective_max_hp` int(6) NOT NULL DEFAULT '100',
159  `movable` int(1) NOT NULL DEFAULT '0',
160  `search_items` text NOT NULL,
161  `teleports` int(1) NOT NULL DEFAULT '0',
162  `teleport_x` int(4) NOT NULL,
163  `teleport_y` int(4) NOT NULL,
164  `teleport_z` int(4) NOT NULL,
165  `interact` varchar(40) NOT NULL,
166  `on_interact` text NOT NULL,
167  `on_tile_enter` text NOT NULL,
168  `on_move` text NOT NULL,
169  PRIMARY KEY (`instance_id`,`x`,`y`,`z`)
170) ENGINE=MyISAM DEFAULT CHARSET=latin1;
171
172DROP TABLE IF EXISTS `raid_maps`;
173CREATE TABLE IF NOT EXISTS `raid_maps` (
174  `raid_id` int(40) NOT NULL,
175  `z` int(3) NOT NULL DEFAULT '0',
176  `map_image` varchar(200) NOT NULL,
177  `columns` int(4) NOT NULL DEFAULT '15',
178  `rows` int(4) NOT NULL DEFAULT '15',
179  `static_walls` text NOT NULL,
180  `static_floors` text NOT NULL,
181  PRIMARY KEY (`raid_id`,`z`)
182) ENGINE=MyISAM DEFAULT CHARSET=latin1;
183
184INSERT INTO `raid_maps` (`raid_id`, `z`, `map_image`, `columns`, `rows`, `static_walls`, `static_floors`) VALUES
185(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'),
186(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', ''),
187(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', '');
188
189DROP TABLE IF EXISTS `raid_maps_ai_data`;
190CREATE TABLE IF NOT EXISTS `raid_maps_ai_data` (
191  `id` int(255) NOT NULL AUTO_INCREMENT,
192  `entity_id` varchar(30) NOT NULL,
193  `raid_id` int(255) NOT NULL,
194  `state` int(3) NOT NULL DEFAULT '0',
195  `x` int(3) NOT NULL,
196  `y` int(3) NOT NULL,
197  `z` int(3) NOT NULL DEFAULT '0',
198  `hidden` int(2) NOT NULL DEFAULT '0',
199  `dest_x` int(3) NOT NULL DEFAULT '0',
200  `dest_y` int(3) NOT NULL DEFAULT '0',
201  `dest_z` int(3) NOT NULL DEFAULT '0',
202  `ai_id` int(255) NOT NULL,
203  `ai_count` int(3) NOT NULL DEFAULT '0',
204  `hostile` int(1) NOT NULL DEFAULT '1',
205  `player_cannot_move` int(11) NOT NULL DEFAULT '0',
206  `interact` varchar(40) NOT NULL DEFAULT '',
207  `patrol_route` varchar(300) NOT NULL,
208  `on_interact` text NOT NULL,
209  `on_defeat` text NOT NULL,
210  PRIMARY KEY (`id`),
211  KEY `map_id` (`raid_id`),
212  KEY `y` (`y`,`z`,`x`),
213  KEY `map_id_2` (`raid_id`),
214  KEY `entity_id` (`entity_id`,`raid_id`)
215) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=latin1;
216
217INSERT 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
218(1, '', 1, 0, 7, 7, 0, 0, 0, 0, 0, 3, 2, 1, 0, '', '', '', ''),
219(2, '', 1, 0, 8, 11, 0, 0, 0, 0, 0, 4, 2, 1, 0, '', '', '', ''),
220(3, '', 1, 0, 11, 3, 0, 0, 0, 0, 0, 5, 1, 0, 0, 'Observe', '', 'endRaidSuccess', ''),
221(4, '', 2, 0, 0, 2, 2, 0, 0, 0, 0, 2, 1, 1, 0, '', '', '', ''),
222(5, '', 3, 0, 21, 3, 0, 0, 0, 0, 0, 8, 1, 1, 0, 'Talk', '', 'checkFlag:npc2##flag:npc3##endCondition', ''),
223(6, '', 3, 0, 23, 3, 0, 0, 0, 0, 0, 10, 1, 1, 0, 'Talk', '', 'checkFlag:npc4##flag:npc5##endCondition', ''),
224(7, '', 3, 0, 23, 5, 0, 0, 0, 0, 0, 2, 1, 1, 0, '', '', '', ''),
225(8, '', 3, 0, 21, 5, 0, 0, 0, 0, 0, 7, 1, 1, 0, 'Talk', '', 'checkFlag:npc1##flag:npc2##endCondition', ''),
226(9, '', 3, 0, 23, 7, 0, 0, 0, 0, 0, 12, 1, 1, 0, 'Talk', '', 'checkFlag:npc5##flag:npc6##flag:task1Completed##sendClientMsg:Correct##endCondition', ''),
227(10, '', 3, 0, 21, 7, 0, 0, 0, 0, 0, 1, 1, 1, 0, 'Talk', '', '', ''),
228(11, '', 3, 0, 19, 3, 0, 0, 0, 0, 0, 6, 1, 1, 0, 'Talk', '', 'flag:npc1', ''),
229(12, '', 3, 0, 19, 5, 0, 0, 0, 0, 0, 11, 1, 1, 0, '', '', '', ''),
230(13, '', 3, 0, 19, 7, 0, 0, 0, 0, 0, 9, 1, 1, 0, 'Talk', '', 'checkFlag:npc3##flag:npc4##endCondition', ''),
231(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', '', ''),
232(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', '', ''),
233(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', '', ''),
234(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', '', ''),
235(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', '', ''),
236(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', '', ''),
237(20, '', 3, 1, 20, 19, 0, 0, 0, 0, 0, 13, 1, 0, 0, '', 'e,s,s,w,w,n,n,e', '', ''),
238(21, '', 3, 1, 20, 21, 0, 0, 0, 0, 0, 13, 1, 0, 0, '', 'w,n,n,e,e,s,s,w', '', ''),
239(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>'),
240(23, '', 4, 0, 11, 10, 0, 0, 0, 0, 0, 18, 1, 1, 1, '', '', '', ''),
241(24, '', 4, 0, 9, 10, 0, 0, 0, 0, 0, 18, 1, 1, 1, 'Talk', '', 'sendClientMsg:The.. key.. lies.. in.. his.. reci..', ''),
242(25, '', 4, 0, 4, 4, 0, 0, 0, 0, 0, 15, 1, 1, 0, '', '', '', ''),
243(26, '', 4, 0, 1, 4, 0, 0, 0, 0, 0, 15, 1, 1, 0, '', '', '', ''),
244(27, '', 4, 0, 1, 6, 0, 0, 0, 0, 0, 15, 1, 1, 0, '', '', '', ''),
245(28, '', 4, 0, 3, 3, 0, 0, 0, 0, 0, 15, 1, 1, 0, '', '', '', ''),
246(29, '', 4, 0, 3, 6, 0, 0, 0, 0, 0, 15, 1, 1, 0, '', '', '', ''),
247(31, '', 4, 0, 0, 7, 0, 0, 0, 0, 0, 16, 1, 1, 1, '', '', '', 'flag:mimicKilled3'),
248(32, '', 4, 0, 7, 14, 0, 0, 0, 0, 0, 16, 1, 1, 1, '', '', '', 'flag:mimicKilled2'),
249(33, '', 4, 0, 14, 7, 0, 0, 0, 0, 0, 16, 1, 1, 1, '', '', '', 'flag:mimicKilled1'),
250(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'),
251(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'),
252(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'),
253(37, '', 4, 0, 7, 10, 0, 0, 0, 0, 0, 18, 1, 1, 1, '', '', '', ''),
254(38, '', 4, 0, 8, 11, 0, 0, 0, 0, 0, 18, 1, 1, 1, 'Talk', '', 'sendClientMsg:I.. am.. not.. in.. control.', ''),
255(39, '', 4, 0, 10, 11, 0, 0, 0, 0, 0, 18, 1, 1, 1, '', '', '', ''),
256(40, '', 4, 0, 9, 12, 0, 0, 0, 0, 0, 18, 1, 1, 1, 'Talk', '', 'sendClientMsg:I.. am.. drifting.', ''),
257(41, 'granny', 4, 0, 5, 11, 0, 1, 0, 0, 0, 20, 1, 1, 0, '', '', '', 'removeBuff:holidaySpirit##endRaidSuccess');
258
259DROP TABLE IF EXISTS `raid_maps_tiles_data`;
260CREATE TABLE IF NOT EXISTS `raid_maps_tiles_data` (
261  `raid_id` int(255) NOT NULL,
262  `x` int(4) NOT NULL,
263  `y` int(4) NOT NULL,
264  `z` int(4) NOT NULL DEFAULT '0',
265  `hidden` int(2) NOT NULL DEFAULT '0',
266  `wall` int(2) NOT NULL DEFAULT '0',
267  `objective_id` int(255) NOT NULL DEFAULT '0',
268  `objective_max_hp` int(6) NOT NULL DEFAULT '100',
269  `movable` int(1) NOT NULL DEFAULT '0',
270  `search_items` text NOT NULL,
271  `teleports` int(1) NOT NULL DEFAULT '0',
272  `teleport_x` int(4) NOT NULL,
273  `teleport_y` int(4) NOT NULL,
274  `teleport_z` int(4) NOT NULL,
275  `interact` varchar(40) NOT NULL,
276  `on_interact` text NOT NULL,
277  `on_tile_enter` text NOT NULL,
278  `on_move` text NOT NULL,
279  PRIMARY KEY (`raid_id`,`x`,`y`,`z`)
280) ENGINE=MyISAM DEFAULT CHARSET=latin1;
281
282INSERT 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
283(1, 1, 9, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:This is your future.##flag:done', ''),
284(1, 3, 9, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:This is also your past.', ''),
285(1, 7, 7, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:Those who are left alive.. will no longer be alive.', ''),
286(1, 8, 11, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:This is what you will become.\r\n', ''),
287(1, 11, 8, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:We do not interfere.', ''),
288(1, 11, 7, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:We only observe.', ''),
289(1, 11, 6, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:But now you have observed.', ''),
290(1, 11, 5, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:Will you interfere?', ''),
291(1, 11, 4, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:Tell me...', ''),
292(1, 11, 3, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'sendClientMsg:..<font class=itemPhantom><b>Observer</b></font>.', ''),
293(3, 10, 0, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'spawnObjective:2', ''),
294(3, 10, 4, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'spawnObjective:3', ''),
295(3, 14, 0, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'spawnObjective:5', ''),
296(3, 14, 4, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'spawnObjective:4', ''),
297(3, 18, 19, 0, 0, 0, 6, 100, 1, '', 0, 0, 0, 0, '', '', '', ''),
298(3, 1, 18, 0, 0, 0, 7, 100, 0, '', 1, 5, 21, 0, '', '', '', ''),
299(3, 1, 20, 0, 0, 0, 7, 100, 0, '', 1, 1, 19, 0, '', '', '', ''),
300(3, 0, 19, 0, 0, 0, 7, 100, 0, '', 1, 1, 23, 0, '', '', '', ''),
301(3, 2, 19, 0, 0, 0, 7, 100, 0, '', 1, 3, 16, 0, '', '', '', ''),
302(3, 0, 21, 0, 0, 0, 7, 100, 0, '', 1, 1, 19, 0, '', '', '', ''),
303(3, 2, 21, 0, 0, 0, 7, 100, 0, '', 1, 3, 19, 0, '', '', '', ''),
304(3, 1, 22, 0, 0, 0, 7, 100, 0, '', 1, 2, 18, 0, '', '', '', ''),
305(3, 4, 19, 0, 0, 0, 7, 100, 0, '', 1, 3, 24, 0, '', '', '', ''),
306(3, 6, 19, 0, 0, 0, 7, 100, 0, '', 1, 3, 16, 0, '', '', '', ''),
307(3, 4, 21, 0, 0, 0, 7, 100, 0, '', 1, 5, 23, 0, '', '', '', ''),
308(3, 6, 21, 0, 0, 0, 7, 100, 0, '', 1, 2, 22, 0, '', '', '', ''),
309(3, 5, 22, 0, 0, 0, 7, 100, 0, '', 1, 5, 19, 0, '', '', '', ''),
310(3, 5, 18, 0, 0, 0, 7, 100, 0, '', 1, 4, 20, 0, '', '', '', ''),
311(3, 5, 20, 0, 0, 0, 7, 100, 0, '', 1, 3, 21, 0, '', '', '', ''),
312(3, 3, 17, 0, 0, 0, 7, 100, 0, '', 1, 0, 22, 0, '', '', '', ''),
313(3, 4, 24, 0, 0, 0, 7, 100, 0, '', 1, 3, 16, 0, '', '', '', ''),
314(3, 2, 24, 0, 0, 0, 0, 100, 0, '', 1, 5, 16, 0, '', '', '', ''),
315(3, 6, 16, 0, 0, 0, 0, 100, 0, '', 1, 1, 16, 0, '', '', '', ''),
316(3, 0, 15, 0, 0, 0, 0, 100, 0, '', 1, 3, 16, 0, '', '', '', ''),
317(3, 0, 16, 0, 0, 0, 0, 100, 0, '', 0, 0, 0, 0, '', '', 'flag:task3Secret\r\n', ''),
318(4, 5, 11, 0, 0, 0, 8, 100, 0, '', 0, 0, 0, 0, 'Desecrate', 'despawnObjective##showAI:granny', '', ''),
319(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', '', ''),
320(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', '', ''),
321(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', '', ''),
322(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', '', ''),
323(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', ''),
324(4, 5, 12, 0, 1, 0, 12, 100, 0, '', 1, 11, 2, 0, '', '', '', ''),
325(4, 11, 3, 0, 0, 0, 14, 100, 0, '', 0, 0, 0, 0, '', '', '', ''),
326(4, 11, 4, 0, 0, 0, 15, 100, 0, '', 1, 5, 11, 0, '', '', '', ''),
327(4, 11, 2, 0, 0, 1, 13, 100, 0, '', 0, 0, 0, 0, '', '', '', '');
328
329DROP TABLE IF EXISTS `raid_objectives`;
330CREATE TABLE IF NOT EXISTS `raid_objectives` (
331  `id` int(255) NOT NULL AUTO_INCREMENT,
332  `name` varchar(40) NOT NULL,
333  `image` varchar(200) NOT NULL,
334  PRIMARY KEY (`id`)
335) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
336
337INSERT INTO `raid_objectives` (`id`, `name`, `image`) VALUES
338(1, 'Strange Hive', 'warfare/strangehive.gif'),
339(2, 'Platform', 'raids/objectives/trials/knowledge.png'),
340(3, 'Platform', 'raids/objectives/trials/strength.png'),
341(4, 'Platform', 'raids/objectives/trials/history.png'),
342(5, 'Platform', 'raids/objectives/trials/courage.png'),
343(6, 'Strange Platform', 'raids/objectives/trials/sequence_platform4.png'),
344(7, 'Teleporter', 'raids/objectives/trials/teleporter.png'),
345(8, 'Strange Grave', 'raids/objectives/christmas/grave.png'),
346(9, 'Gift', 'raids/objectives/christmas/gift.png'),
347(10, 'Candy Cane', 'raids/objectives/christmas/candy_cane.png'),
348(11, 'Platform', 'raids/objectives/christmas/nose_meh.png'),
349(12, 'Portal', 'raids/objectives/christmas/portal.png'),
350(13, 'Ice Block', 'raids/objectives/christmas/frozen.png'),
351(14, 'Snow Trail', 'raids/objectives/christmas/snow_trail.png'),
352(15, 'Crashed Sleigh', 'raids/objectives/christmas/crashed_sleigh.png'),
353(16, 'Activated Platform', 'raids/objectives/christmas/nose_activated.png');
354
355DROP TABLE IF EXISTS `raid_players`;
356CREATE TABLE IF NOT EXISTS `raid_players` (
357  `id` bigint(20) NOT NULL AUTO_INCREMENT,
358  `account` varchar(10) DEFAULT NULL,
359  `instance_id` bigint(20) NOT NULL,
360  `team` int(4) NOT NULL DEFAULT '1',
361  `x` int(3) NOT NULL DEFAULT '0',
362  `y` int(3) NOT NULL DEFAULT '0',
363  `z` int(3) NOT NULL DEFAULT '0',
364  `last_active` datetime NOT NULL,
365  `rewards` text NOT NULL,
366  PRIMARY KEY (`id`),
367  UNIQUE KEY `UNIQUE` (`account`),
368  KEY `INDEX` (`instance_id`)
369) ENGINE=InnoDB AUTO_INCREMENT=384 DEFAULT CHARSET=latin1;
370
371DROP TABLE IF EXISTS `raid_player_rewards`;
372CREATE TABLE IF NOT EXISTS `raid_player_rewards` (
373  `account_id` bigint(20) NOT NULL,
374  `raid_id` int(255) NOT NULL,
375  `time_taken_secs` int(40) NOT NULL DEFAULT '0',
376  `rewards_to_claim` text NOT NULL,
377  `hourly_cooldown` int(1) NOT NULL DEFAULT '0',
378  `daily_cooldown` int(1) NOT NULL DEFAULT '0',
379  `weekly_cooldown` int(1) NOT NULL DEFAULT '0',
380  `claimed` int(1) NOT NULL DEFAULT '0',
381  `raid_completed` int(1) NOT NULL DEFAULT '0',
382  PRIMARY KEY (`account_id`,`raid_id`)
383) ENGINE=MyISAM DEFAULT CHARSET=latin1;
384COMMIT;
385
386
387
388UPDATE `raid_ai` SET `drops` = '100:Pie Mix#100:Flour' WHERE `raid_ai`.`id` = 17;
389UPDATE `raid_ai` SET `drops` = '40:Pie Mix#40:Flour#50:Charcoal' WHERE `raid_ai`.`id` = 16;
390UPDATE `raid_ai` SET `drops` = '4:Artificial Wood' WHERE `raid_ai`.`id` = 18;
391UPDATE `raid_ai` SET `drops` = '3:Abstruse Crystal' WHERE `raid_ai`.`id` = 19;
392UPDATE `raid_maps_tiles_data` SET `interact` = 'Eat' WHERE `raid_maps_tiles_data`.`raid_id` = 4 AND `raid_maps_tiles_data`.`x` = 14 AND `raid_maps_tiles_data`.`y` = 11 AND `raid_maps_tiles_data`.`z` = 0;
393UPDATE `raid_maps_tiles_data` SET `interact` = 'Eat' WHERE `raid_maps_tiles_data`.`raid_id` = 4 AND `raid_maps_tiles_data`.`x` = 9 AND `raid_maps_tiles_data`.`y` = 11 AND `raid_maps_tiles_data`.`z` = 0;
394UPDATE `raid_maps_tiles_data` SET `interact` = 'Eat' WHERE `raid_maps_tiles_data`.`raid_id` = 4 AND `raid_maps_tiles_data`.`x` = 2 AND `raid_maps_tiles_data`.`y` = 10 AND `raid_maps_tiles_data`.`z` = 0;
395UPDATE `raid_maps_ai_data` SET `on_defeat` = 'endRaidSuccess##showTile:9,,7##teachRecipe:Homemade Pie##hideAI:elf1##hideAI:elf2##hideAI:elf3##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>' WHERE `raid_maps_ai_data`.`id` = 22;
396UPDATE `raid_maps_ai_data` SET `entity_id` = 'elf1' WHERE `raid_maps_ai_data`.`id` = 34;
397UPDATE `raid_maps_ai_data` SET `entity_id` = 'elf2' WHERE `raid_maps_ai_data`.`id` = 35;
398UPDATE `raid_maps_ai_data` SET `entity_id` = 'elf3' WHERE `raid_maps_ai_data`.`id` = 36;
399
400
401UPDATE `raid_ai` SET `drops` = '2:Fire Crystal Shard#5:Snow Boom#5:Sweet Embrace#1000:Large Power Cell' WHERE `raid_ai`.`id` = 14;
402ALTER TABLE `raid_instance_ai` DROP `id`;
403ALTER TABLE `raid_instance_ai` ADD PRIMARY KEY( `entity_id`, `instance_id`);
404ALTER TABLE `raid_player_rewards` ADD `completions` INT(10) NOT NULL DEFAULT '0' AFTER `raid_id`;
405UPDATE `raid_maps_ai_data` SET `on_defeat` = 'removeBuff:holidaySpirit##endRaidSuccess##sendClientMsg:<font class=itemPhantom>You use the last of your Holiday Spirit as you defeat the weird Granny ghost.</font>##sendClientMsg:<font class=itemPhantom>However, as she disappears, she utters a few words that you cannot quite understand yet..' WHERE `raid_maps_ai_data`.`id` = 41;
406ALTER TABLE `accountdb` ADD `trinkets` TEXT NOT NULL AFTER `option_turn_link`;
407CREATE TABLE `legacy_gamedata`.`trinkets` ( `id` INT(40) NOT NULL AUTO_INCREMENT , `name` VARCHAR(50) NOT NULL , `description` TEXT NOT NULL , `image` VARCHAR(50) NOT NULL , `type` VARCHAR(15) NOT NULL DEFAULT 'normal' , PRIMARY KEY (`id`)) ENGINE = MyISAM;
408INSERT INTO `trinkets` (`id`, `name`, `description`, `image`, `type`) VALUES (NULL, 'Klauz\'s Snow Globe', 'A snow globe commemorating your successful adventures in <font class=colortext>A Very Merry Realm</font>.', 'snow_globe.png', 'raid');
409UPDATE `trinkets` SET `name` = 'Grandma\'s Snow Globe' WHERE `trinkets`.`id` = 1;
410ALTER TABLE `accountdb` ADD `option_trinkets` VARCHAR(40) NOT NULL DEFAULT '0,0,0' AFTER `trinkets`;
411ALTER TABLE `raids` ADD `base_boon_xp_reward` INT(6) NOT NULL DEFAULT '25' AFTER `base_credits_reward`;
412INSERT INTO `trinkets` (`id`, `name`, `description`, `image`, `type`) VALUES (NULL, 'Krampus Klauz\'s Hood', 'This hood was once worn by Krampus Klauz, a monster who disguised himself as the popular myth Santa Claus. A strange energy emanates from within it.', 'krampus_hood.png', 'raid');
413ALTER TABLE `raid_players` ADD `trinkets` TEXT NOT NULL AFTER `rewards`;
414ALTER TABLE `raid_player_rewards` ADD `trinkets_to_claim` VARCHAR(40) NOT NULL AFTER `rewards_to_claim`;
415UPDATE `raid_maps_ai_data` SET `on_defeat` = 'removeBuff:holidaySpirit##endRaidSuccess##sendClientMsg:<font class=itemPhantom>You use the last of your Holiday Spirit as you defeat the weird Granny ghost.</font>##checkCompletions:9##addTrinket:1##endCondition' WHERE `raid_maps_ai_data`.`id` = 41;
416UPDATE `raid_maps_ai_data` SET `entity_id` = 'klauz' WHERE `raid_maps_ai_data`.`id` = 22;
417INSERT INTO `raid_ai` (`id`, `name`, `icon`, `image`, `max_hp`, `level`, `boss`, `armor`, `weapon1`, `weapon2`, `misc1`, `misc2`, `drops`, `default_player_cannot_move`) VALUES (NULL, 'Krampus Klauz', '', 'raids/npc/christmas/santa_true_form.png', '300', '85', '1', 'Hellforged Armor', 'Snow Boom', 'Sweet Embrace', '', '', '2:Fire Crystal Shard#5:Snow Boom#5:Sweet Embrace#1000:Large Power Cell', '0');
418INSERT 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 (NULL, 'krampus', '4', '0', '9', '8', '0', '1', '0', '0', '0', '21', '1', '1', '0', '', '', '', 'endRaidSuccess##showTile:9,,7##teachRecipe:Homemade Pie##hideAI:elf1##hideAI:elf2##hideAI:elf3##sendClientMsg:<font class=warOther>You defeat the true form of the creature that called itself Klauz.. Krampus Klauz.</font>');
419INSERT 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 ('4', '9', '8', '0', '0', '0', '0', '100', '0', '', '0', '', '', '', '', '', 'checkCompletions:20##hideAI:klauz##showAI:krampus##sendClientMsg:<font class=itemGodlike>After your numerous victories in this realm, Klauz drops his facade and reveals his true self.</font>##endCondition', '');
420UPDATE `raid_maps_ai_data` SET `on_defeat` = 'endRaidSuccess##showTile:9,,7##teachRecipe:Homemade Pie##hideAI:elf1##hideAI:elf2##hideAI:elf3##sendClientMsg:<font class=warOther>You defeat the true form of the creature that called itself Klauz.. Krampus Klauz.</font>##checkChanceCompletions:5,,1,,0.5,,20##addTrinket:2##endCondition' WHERE `raid_maps_ai_data`.`id` = 42;
421UPDATE `raid_maps_ai_data` SET `on_defeat` = 'endRaidSuccess##showTile:9,,7##teachRecipe:Homemade Pie##hideAI:elf1##hideAI:elf2##hideAI:elf3##sendClientMsg:<font class=warOther>You defeat the true form of the creature that called itself Klauz.. Krampus Klauz.</font>##checkChanceCompletions:5,,2,,0.5,,20##addTrinket:2##endCondition' WHERE `raid_maps_ai_data`.`id` = 42;
422UPDATE `raid_maps_ai_data` SET `on_defeat` = 'endRaidSuccess##showTile:9,,7##teachRecipe:Homemade Pie##hideAI:elf1##hideAI:elf2##hideAI:elf3##sendClientMsg:<font class=warOther>You defeat Santa Claus but you cannot help shake a strange feeling as he disappears...</font>' WHERE `raid_maps_ai_data`.`id` = 22;