diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2020_02_21_01_world.sql | 169 |
1 files changed, 169 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_02_21_01_world.sql b/sql/updates/world/3.3.5/2020_02_21_01_world.sql new file mode 100644 index 00000000000..6e2ec655157 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_02_21_01_world.sql @@ -0,0 +1,169 @@ +-- +UPDATE `creature_model_info` SET `DisplayID_Other_Gender`=29243 WHERE `DisplayID` IN (16431); +UPDATE `spell_dbc` SET `Effect1`=6, `EffectDieSides1`=1, `EffectImplicitTargetA1`=1, `EffectImplicitTargetB1`=1, `EffectApplyAuraName1`=56, `EffectMiscValue1`=25868 WHERE `id`=46248; +UPDATE `spell_dbc` SET `Effect1`=6, `EffectDieSides1`=1, `EffectImplicitTargetA1`=1, `EffectImplicitTargetB1`=1, `EffectApplyAuraName1`=56, `EffectMiscValue1`=25869 WHERE `id`=46249; +UPDATE `spell_dbc` SET `Effect1`=6, `EffectDieSides1`=1, `EffectImplicitTargetA1`=1, `EffectImplicitTargetB1`=1, `EffectApplyAuraName1`=56, `EffectMiscValue1`=25870 WHERE `id`=46250; +UPDATE `spell_dbc` SET `Effect1`=6, `EffectDieSides1`=1, `EffectImplicitTargetA1`=1, `EffectImplicitTargetB1`=1, `EffectApplyAuraName1`=56, `EffectMiscValue1`=25871 WHERE `id`=46252; +UPDATE `spell_dbc` SET `Effect1`=6, `EffectDieSides1`=1, `EffectImplicitTargetA1`=1, `EffectImplicitTargetB1`=1, `EffectApplyAuraName1`=56, `EffectMiscValue1`=25872 WHERE `id`=46253; +UPDATE `spell_dbc` SET `Effect1`=6, `EffectDieSides1`=1, `EffectImplicitTargetA1`=1, `EffectImplicitTargetB1`=1, `EffectApplyAuraName1`=56, `EffectMiscValue1`=25873 WHERE `id`=46254; +UPDATE `spell_dbc` SET `Effect1`=6, `EffectDieSides1`=1, `EffectImplicitTargetA1`=1, `EffectImplicitTargetB1`=1, `EffectApplyAuraName1`=56, `EffectMiscValue1`=25874 WHERE `id`=46255; +UPDATE `spell_dbc` SET `Effect1`=6, `EffectDieSides1`=1, `EffectImplicitTargetA1`=1, `EffectImplicitTargetB1`=1, `EffectApplyAuraName1`=56, `EffectMiscValue1`=25875 WHERE `id`=46256; +UPDATE `spell_dbc` SET `Effect1`=6, `EffectDieSides1`=1, `EffectImplicitTargetA1`=1, `EffectImplicitTargetB1`=1, `EffectApplyAuraName1`=56, `EffectMiscValue1`=25876 WHERE `id`=46257; +UPDATE `spell_dbc` SET `Effect1`=6, `EffectDieSides1`=1, `EffectImplicitTargetA1`=1, `EffectImplicitTargetB1`=1, `EffectApplyAuraName1`=56, `EffectMiscValue1`=25877 WHERE `id`=46258; +UPDATE `spell_dbc` SET `Effect1`=6, `EffectDieSides1`=1, `EffectImplicitTargetA1`=1, `EffectImplicitTargetB1`=1, `EffectApplyAuraName1`=56, `EffectMiscValue1`=25878 WHERE `id`=46259; + +UPDATE `creature` SET `modelid`=0 WHERE `id` IN (16781); +-- Human +DELETE FROM `creature_addon` WHERE `guid` IN (213796, 212850, 94697, 213103, 94645, 213801, 212599, 213097, 94661, 152407, 212291, 94590, 94563, 213814, 212041, 78651, 94617, 213731, 211793, 213791, 94646, 94584, 85193, 94741, 94743, 85195, 165585, 213100, 94591, 212538, 94699, 94614, 94637, 94638, 213808, 94604, 212601, 94544, 213794, 165586); +INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES +(213796,4097,"46254"),(212850,4097,"46254"),(94697, 4097,"46254"), +(213103,4097,"46254"),(94645, 4097,"46254"),(213801,4097,"46254"),(212599,4097,"46254"), +(213097,4097,"46254"),(94661, 4097,"46254"),(152407,4097,"46254"),(212291,4097,"46254"), +(94590, 4097,"46254"),(94563, 4097,"46254"),(213814,4097,"46254"),(212041,4097,"46254"), +(78651, 4097,"46254"),(94617, 4097,"46254"),(213731,4097,"46254"),(211793,4097,"46254"), +(213791,4097,"46254"),(94646, 4097,"46254"),(94584, 4097,"46254"),(85193, 4097,"46254"), +(94741, 4097,"46254"),(94743, 4097,"46254"),(85195, 4097,"46254"),(165585,4097,"46254"), +(213100,4097,"46254"),(94591, 4097,"46254"),(212538,4097,"46254"),(94699, 4097,"46254"), +(94614, 4097,"46254"),(94637, 4097,"46254"),(94638, 4097,"46254"),(213808,4097,"46254"), +(94604, 4097,"46254"),(212601,4097,"46254"),(94544, 4097,"46254"),(213794,4097,"46254"), +(165586,4097,"46254"); +-- Dwarf +DELETE FROM `creature_addon` WHERE `guid` IN (94592, 94633, 94672, 94740, 213732, 94610, 94715, 94580, 94561, 94560, 213105, 94674, 212541, 212598, 94583, 94601, 94742, 94621, 211792, 94727, 94548, 94739, 94550, 213797, 213802, 213807, 213738, 213813, 94673, 94713, 213728, 94670, 94529, 94701, 213115, 212290, 78650, 213098, 85192, 165584); +INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES +(94592, 4097,"46250"),(94633, 4097,"46250"),(94672, 4097,"46250"),(94740, 4097,"46250"), +(213732,4097,"46250"),(94610, 4097,"46250"),(94715, 4097,"46250"),(94580, 4097,"46250"), +(94561, 4097,"46250"),(94560, 4097,"46250"),(213105,4097,"46250"),(94674, 4097,"46250"), +(212541,4097,"46250"),(212598,4097,"46250"),(94583, 4097,"46250"),(94601, 4097,"46250"), +(94742, 4097,"46250"),(94621, 4097,"46250"),(211792,4097,"46250"),(94727, 4097,"46250"), +(94548, 4097,"46250"),(94739, 4097,"46250"),(94550, 4097,"46250"),(213797,4097,"46250"), +(213802,4097,"46250"),(213807,4097,"46250"),(213738,4097,"46250"),(213813,4097,"46250"), +(94673, 4097,"46250"),(94713, 4097,"46250"),(213728,4097,"46250"),(94670, 4097,"46250"), +(94529, 4097,"46250"),(94701, 4097,"46250"),(213115,4097,"46250"),(212290,4097,"46250"), +(78650, 4097,"46250"),(213098,4097,"46250"),(85192, 4097,"46250"),(165584,4097,"46250"); +-- Night Elf +DELETE FROM `creature_addon` WHERE `guid` IN (94613, 94647, 94619, 212039, 211794, 94744, 94706, 85194, 213729, 213803, 213737, 213747, 94728, 94558, 212848, 213748, 213793, 212540, 94664, 212289, 213815, 94622, 94702); +INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES +(94613, 4097,"46255"),(94647, 4097,"46255"),(94619, 4097,"46255"),(212039,4097,"46255"), +(211794,4097,"46255"),(94744, 4097,"46255"),(94706, 4097,"46255"),(85194, 4097,"46255"), +(213729,4097,"46255"),(213803,4097,"46255"),(213737,4097,"46255"),(213747,4097,"46255"), +(94728, 4097,"46255"),(94558, 4097,"46255"),(212848,4097,"46255"),(213748,4097,"46255"), +(213793,4097,"46255"),(212540,4097,"46255"),(94664, 4097,"46255"),(212289,4097,"46255"), +(213815,4097,"46255"),(94622, 4097,"46255"),(94702, 4097,"46255"); +-- Orc +DELETE FROM `creature_addon` WHERE `guid` IN (94654, 94723, 94656, 94628, 94594, 210984, 211543, 94685, 211544, 211520, 211541, 94534, 210685, 210411, 94573, 94725, 94642, 94724, 94678, 210414, 94736, 94598, 202748, 209929, 94565, 210426, 94532, 94570, 94630, 94667, 94530, 202715, 211259, 94595, 209669, 211256, 210946); +INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES +(94654, 4097,"46256"),(94723, 4097,"46256"),(94656, 4097,"46256"),(94628, 4097,"46256"), +(94594, 4097,"46256"),(210984,4097,"46256"),(211543,4097,"46256"),(94685, 4097,"46256"), +(211544,4097,"46256"),(211520,4097,"46256"),(211541,4097,"46256"),(94534, 4097,"46256"), +(210685,4097,"46256"),(210411,4097,"46256"),(94573, 4097,"46256"),(94725, 4097,"46256"), +(94642, 4097,"46256"),(94724, 4097,"46256"),(94678, 4097,"46256"),(210414,4097,"46256"), +(94736, 4097,"46256"),(94598, 4097,"46256"),(202748,4097,"46256"),(209929,4097,"46256"), +(94565, 4097,"46256"),(210426,4097,"46256"),(94532, 4097,"46256"),(94570, 4097,"46256"), +(94630, 4097,"46256"),(94667, 4097,"46256"),(94530, 4097,"46256"),(202715,4097,"46256"), +(211259,4097,"46256"),(94595, 4097,"46256"),(209669,4097,"46256"),(211256,4097,"46256"), +(210946,4097,"46256"); +-- Tauren +DELETE FROM `creature_addon` WHERE `guid` IN (210427, 94569, 94695, 94721, 11001, 94726, 210413, 94625, 209926, 94588, 94644, 94564, 202714, 94531, 94677, 202742, 202760, 94538, 94643, 210683, 211521, 94665, 210947, 94708, 94629, 94650, 211257, 209928, 94691, 209667, 94693, 202754); +INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES +(210427,4097,"46257"),(94569, 4097,"46257"),(94695, 4097,"46257"),(94721, 4097,"46257"), +(11001, 4097,"46257"),(94726, 4097,"46257"),(210413,4097,"46257"),(94625, 4097,"46257"), +(209926,4097,"46257"),(94588, 4097,"46257"),(94644, 4097,"46257"),(94564, 4097,"46257"), +(202714,4097,"46257"),(94531, 4097,"46257"),(94677, 4097,"46257"),(202742,4097,"46257"), +(202760,4097,"46257"),(94538, 4097,"46257"),(94643, 4097,"46257"),(210683,4097,"46257"), +(211521,4097,"46257"),(94665, 4097,"46257"),(210947,4097,"46257"),(94708, 4097,"46257"), +(94629, 4097,"46257"),(94650, 4097,"46257"),(211257,4097,"46257"),(209928,4097,"46257"), +(94691, 4097,"46257"),(209667,4097,"46257"),(94693, 4097,"46257"),(202754,4097,"46257"); +-- Undead +DELETE FROM `creature_addon` WHERE `guid` IN (94596, 209666, 202743, 94682, 94574, 94572, 202747, 202762, 210415, 211260, 94660, 94731, 202717, 94631, 94694, 202761, 202753, 94535, 211542, 94581, 94627, 210949, 210428, 210412, 94542, 94730, 94679); +INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES +(94596, 4097,"46259"),(209666,4097,"46259"),(202743,4097,"46259"),(94682, 4097,"46259"), +(94574, 4097,"46259"),(94572, 4097,"46259"),(202747,4097,"46259"),(202762,4097,"46259"), +(210415,4097,"46259"),(211260,4097,"46259"),(94660, 4097,"46259"),(94731, 4097,"46259"), +(202717,4097,"46259"),(94631, 4097,"46259"),(94694, 4097,"46259"),(202761,4097,"46259"), +(202753,4097,"46259"),(94535, 4097,"46259"),(211542,4097,"46259"),(94581, 4097,"46259"), +(94627, 4097,"46259"),(210949,4097,"46259"),(210428,4097,"46259"),(210412,4097,"46259"), +(94542, 4097,"46259"),(94730, 4097,"46259"),(94679, 4097,"46259"); +-- Troll +DELETE FROM `creature_addon` WHERE `guid` IN (94666, 94696, 211540, 202716, 94651, 94720, 94681, 210983, 94729, 94586, 94626, 94546, 94686, 94597, 94668, 94615, 94687, 94719, 211523, 94732, 202759, 210684, 94541, 94611, 94688, 94566, 94689, 94684, 94533, 94709, 211258, 94632, 202755, 202741, 94659, 94698, 94718, 94653); +INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES +(94666, 4097,"46258"),(94696, 4097,"46258"),(211540,4097,"46258"),(202716,4097,"46258"), +(94651, 4097,"46258"),(94720, 4097,"46258"),(94681, 4097,"46258"),(210983,4097,"46258"), +(94729, 4097,"46258"),(94586, 4097,"46258"),(94626, 4097,"46258"),(94546, 4097,"46258"), +(94686, 4097,"46258"),(94597, 4097,"46258"),(94668, 4097,"46258"),(94615, 4097,"46258"), +(94687, 4097,"46258"),(94719, 4097,"46258"),(211523,4097,"46258"),(94732, 4097,"46258"), +(202759,4097,"46258"),(210684,4097,"46258"),(94541, 4097,"46258"),(94611, 4097,"46258"), +(94688, 4097,"46258"),(94566, 4097,"46258"),(94689, 4097,"46258"),(94684, 4097,"46258"), +(94533, 4097,"46258"),(94709, 4097,"46258"),(211258,4097,"46258"),(94632, 4097,"46258"), +(202755,4097,"46258"),(202741,4097,"46258"),(94659, 4097,"46258"),(94698, 4097,"46258"), +(94718, 4097,"46258"),(94653, 4097,"46258"); +-- Gnome +DELETE FROM `creature_addon` WHERE `guid` IN (202764, 94635, 94639, 94599, 94582, 94648, 213099, 94618, 78649, 94745, 94662, 94600, 94669, 94676, 94609, 94717, 94549, 213806, 94607, 94705, 212602, 213792, 94636, 213116, 94714, 94577, 94640, 94675, 212539, 94634, 94623, 94608, 94603, 94552, 94543, 212040, 213816, 213104, 94578, 212849, 94539); +INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES +(202764,4097,"46252"),(94635, 4097,"46252"),(94639, 4097,"46252"),(94599, 4097,"46252"), +(94582, 4097,"46252"),(94648, 4097,"46252"),(213099,4097,"46252"),(94618, 4097,"46252"), +(78649, 4097,"46252"),(94745, 4097,"46252"),(94662, 4097,"46252"),(94600, 4097,"46252"), +(94669, 4097,"46252"),(94676, 4097,"46252"),(94609, 4097,"46252"),(94717, 4097,"46252"), +(94549, 4097,"46252"),(213806,4097,"46252"),(94607, 4097,"46252"),(94705, 4097,"46252"), +(212602,4097,"46252"),(213792,4097,"46252"),(94636, 4097,"46252"),(213116,4097,"46252"), +(94714, 4097,"46252"),(94577, 4097,"46252"),(94640, 4097,"46252"),(94675, 4097,"46252"), +(212539,4097,"46252"),(94634, 4097,"46252"),(94623, 4097,"46252"),(94608, 4097,"46252"), +(94603, 4097,"46252"),(94552, 4097,"46252"),(94543, 4097,"46252"),(212040,4097,"46252"), +(213816,4097,"46252"),(213104,4097,"46252"),(94578, 4097,"46252"),(212849,4097,"46252"), +(94539, 4097,"46252"); +-- Draenei +DELETE FROM `creature_addon` WHERE `guid` IN (94602, 213790, 94616, 213746, 94536, 213739, 212292, 94663, 94576, 94606, 94540, 211791, 94589, 94712, 94620, 94585, 213809, 213800, 212600, 212847, 94559, 213733, 202765, 94575, 213114, 94747, 94746, 94703, 94671, 152406, 213795, 94562); +INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES +(94602, 4097,"46249"),(213790,4097,"46249"),(94616, 4097,"46249"),(213746,4097,"46249"), +(94536, 4097,"46249"),(213739,4097,"46249"),(212292,4097,"46249"),(94663, 4097,"46249"), +(94576, 4097,"46249"),(94606, 4097,"46249"),(94540, 4097,"46249"),(211791,4097,"46249"), +(94589, 4097,"46249"),(94712, 4097,"46249"),(94620, 4097,"46249"),(94585, 4097,"46249"), +(213809,4097,"46249"),(213800,4097,"46249"),(212600,4097,"46249"),(212847,4097,"46249"), +(94559, 4097,"46249"),(213733,4097,"46249"),(202765,4097,"46249"),(94575, 4097,"46249"), +(213114,4097,"46249"),(94747, 4097,"46249"),(94746, 4097,"46249"),(94703, 4097,"46249"), +(94671, 4097,"46249"),(152406,4097,"46249"),(213795,4097,"46249"),(94562, 4097,"46249"); +-- Blood Elf +DELETE FROM `creature_addon` WHERE `guid` IN (94680, 94593, 94655, 94624, 209668, 202746, 94587, 94707, 94612, 94518, 94658, 94545, 94547, 94567, 94568, 94571, 94690, 211522, 210950, 94537, 210682, 209670, 202752, 202749, 202744, 94641, 94652, 94657, 94737, 94722, 94683, 94692); +INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES +(94680, 4097,"46248"),(94593, 4097,"46248"),(94655, 4097,"46248"),(94624, 4097,"46248"), +(209668,4097,"46248"),(202746,4097,"46248"),(94587, 4097,"46248"),(94707, 4097,"46248"), +(94612, 4097,"46248"),(94518, 4097,"46248"),(94658, 4097,"46248"),(94545, 4097,"46248"), +(94547, 4097,"46248"),(94567, 4097,"46248"),(94568, 4097,"46248"),(94571, 4097,"46248"), +(94690, 4097,"46248"),(211522,4097,"46248"),(210950,4097,"46248"),(94537, 4097,"46248"), +(210682,4097,"46248"),(209670,4097,"46248"),(202752,4097,"46248"),(202749,4097,"46248"), +(202744,4097,"46248"),(94641, 4097,"46248"),(94652, 4097,"46248"),(94657, 4097,"46248"), +(94737, 4097,"46248"),(94722, 4097,"46248"),(94683, 4097,"46248"),(94692, 4097,"46248"); +-- Goblin +DELETE FROM `creature_addon` WHERE `guid` IN (212042, 210948, 209927, 213106, 213113); +INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES +(212042,4097,"46253"),(210948,4097,"46253"),(209927,4097,"46253"),(213106,4097,"46253"), +(213113,4097,"46253"); + +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=16781; +DELETE FROM `smart_scripts` WHERE `entryorguid`=16781 AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(16781, 0, 0, 0, 1, 0, 100, 0, 240000, 480000, 240000, 480000, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Midsummer Celebrant- OOC - Say text Horde'), +(16781, 0, 1, 0, 1, 0, 100, 0, 240000, 480000, 240000, 480000, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Midsummer Celebrant- OOC - Say text Alliance'), +(16781, 0, 2, 0, 1, 0, 100, 0, 240000, 480000, 240000, 480000, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Midsummer Celebrant- OOC - Say text Gnome'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry` IN (16781); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(22, 1, 16781, 0, 0, 1, 1, 46256, 0, 0, 0, 0, 0, '', 'Celebrant - Only run SAI if Has the aura 46256'), +(22, 1, 16781, 0, 1, 1, 1, 46257, 0, 0, 0, 0, 0, '', 'Celebrant - Only run SAI if Has the aura 46257'), +(22, 1, 16781, 0, 2, 1, 1, 46259, 0, 0, 0, 0, 0, '', 'Celebrant - Only run SAI if Has the aura 46259'), +(22, 1, 16781, 0, 3, 1, 1, 46258, 0, 0, 0, 0, 0, '', 'Celebrant - Only run SAI if Has the aura 46258'), +(22, 1, 16781, 0, 4, 1, 1, 46248, 0, 0, 0, 0, 0, '', 'Celebrant - Only run SAI if Has the aura 46248'), +(22, 2, 16781, 0, 0, 1, 1, 46254, 0, 0, 0, 0, 0, '', 'Celebrant - Only run SAI if Has the aura 46254'), +(22, 2, 16781, 0, 1, 1, 1, 46250, 0, 0, 0, 0, 0, '', 'Celebrant - Only run SAI if Has the aura 46250'), +(22, 2, 16781, 0, 2, 1, 1, 46255, 0, 0, 0, 0, 0, '', 'Celebrant - Only run SAI if Has the aura 46255'), +(22, 2, 16781, 0, 3, 1, 1, 46252, 0, 0, 0, 0, 0, '', 'Celebrant - Only run SAI if Has the aura 46252'), +(22, 2, 16781, 0, 4, 1, 1, 46249, 0, 0, 0, 0, 0, '', 'Celebrant - Only run SAI if Has the aura 46249'), +(22, 3, 16781, 0, 0, 1, 1, 46253, 0, 0, 0, 0, 0, '', 'Celebrant - Only run SAI if Has the aura 46253'); + +DELETE FROM `creature_text` WHERE `CreatureID` IN (16781); +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(16781, 0, 0, "The Horde fires will never be extinguished!", 12, 1, 100, 4, 0, 0, 24534, 0, "Midsummer Celebrant Horde"), +(16781, 0, 1, "I'd like to see the Alliance try to steal our flame.", 12, 1, 100, 1, 0, 0, 24533, 0, "Midsummer Celebrant Horde"), +(16781, 1, 0, "The Horde have tried to steal our flames. I hope we return the favor.", 12, 7, 100, 1, 0, 0, 24531, 0, "Midsummer Celebrant Alliance"), +(16781, 1, 1, "The Alliance fires burn strong and true!", 12, 7, 100, 4, 0, 0, 24532, 0, "Midsummer Celebrant Alliance"), +(16781, 2, 0, "Midsummer Fire Festival is a great time to celebrate the summer!", 12, 0, 100, 4, 0, 0, 24535, 0, "Midsummer Celebrant Goblin"), +(16781, 2, 1, "I love the firework show at the end of Midsummer Firefestival.", 12, 0, 100, 1, 0, 0, 24536, 0, "Midsummer Celebrant Goblin"); |