|
|
Модератор форума: Dimitro |
Форум TrinityCore Патчи / Моды / Фиксы для Trinity фиксы в базу для 4.3.4 часть2 |
фиксы в базу для 4.3.4 часть2 |
firelands-434-fix
Код DELETE FROM `creature` WHERE `id` IN (53520,53375,53698,53693,53487,53691,52530,53369,53680,53734,53896,53900) AND `map`=720; DELETE FROM `gameobject` WHERE `id` IN (209036,208966,201722,209035) AND `map`=720; UPDATE `creature_template` SET `flags_extra`=`flags_extra`|0x80 WHERE `entry` IN (53723,53154,53789,53792,53787,53788); UPDATE `creature_template` SET `minlevel`=88,`maxlevel`=88,`exp`=3,`faction_A`=16,`faction_H`=16,`speed_walk`=3.2,`speed_run`=2,`baseattacktime`=2000,`rangeattacktime`=200 0,`unit_class`=2,`unit_flags`=0x2008140,`unit_flags2`=0x8000800,`VehicleId`=1673,`HoverHeight`=14,`mana_mod_extra`=1.72414 WHERE `entry` IN (52530,54044,54045,54046); UPDATE `creature_template` SET `minlevel`=87,`maxlevel`=87,`exp`=3,`faction_A`=16,`faction_H`=16,`speed_walk`=3.2,`speed_run`=2,`baseattacktime`=2000,`rangeattacktime`=200 0,`unit_flags`=0x8000,`unit_flags2`=0x800,`VehicleId`=1695 WHERE `entry` IN (54056,54057); -- Blazing Monstrosity UPDATE `creature_template` SET `minlevel`=87,`maxlevel`=87,`exp`=3,`faction_A`=16,`faction_H`=16,`speed_walk`=1,`speed_run`=1,`baseattacktime`=2000,`rangeattacktime`=2000, `unit_flags`=0x8000,`unit_flags2`=0x8800 WHERE `entry` IN (53795,54059); -- Egg Pile UPDATE `creature_template` SET `spell1`=100076,`spell2`=100080,`spell3`=100078,`spell4`=100082 WHERE `entry`=53789; UPDATE `creature_template` SET `spell1`=100090,`spell2`=100089,`spell3`=100091,`spell4`=100092 WHERE `entry`=53792; UPDATE `creature_template` SET `minlevel`=85,`maxlevel`=85,`exp`=3,`faction_A`=14,`faction_H`=14,`speed_walk`=1.2,`speed_run`=0.428571,`unit_flags`=0x2000000,`unit_flags2` =0x2000800 WHERE `entry` IN (53787,53788); -- Molten Barrage UPDATE `creature_template` SET `minlevel`=85,`maxlevel`=85,`exp`=3,`faction_A`=16,`faction_H`=16,`speed_walk`=3.2,`speed_run`=2,`unit_flags`=0x8000,`unit_flags2`=0x800,`ba seattacktime`=2000,`rangeattacktime`=2000 WHERE `entry` IN (53794,54058); -- Smouldering Hatchling UPDATE `creature_template` SET `minlevel`=86,`maxlevel`=86,`exp`=3,`faction_A`=16,`faction_H`=16,`speed_walk`=1,`speed_run`=1.14286,`unit_flags`=0,`unit_flags2`=0x800,`bas eattacktime`=2000,`rangeattacktime`=2000,`unit_class`=8,`dynamicflags`=0 WHERE `entry` IN (53793,53973); -- Harbinger of Flame UPDATE `creature_template` SET `difficulty_entry_1`=54044,`difficulty_entry_2`=54045,`difficulty_entry_3`=54046 WHERE `entry`=52530; -- Alysrazor UPDATE `creature_template` SET `difficulty_entry_1`=54056 WHERE `entry`=53786; -- Blazing Monstrosity UPDATE `creature_template` SET `difficulty_entry_1`=54057 WHERE `entry`=53791; -- Blazing Monstrosity UPDATE `creature_template` SET `difficulty_entry_1`=54059 WHERE `entry`=53795; -- Egg Pile UPDATE `creature_template` SET `difficulty_entry_1`=54058 WHERE `entry`=53794; -- Smouldering Hatchling UPDATE `creature_template` SET `difficulty_entry_1`=53973 WHERE `entry`=53793; -- Harbinger of Flame DELETE FROM `creature_template_addon` WHERE `entry` IN (53786,53791,54056,54057,53794,54058,54276,54019,53224,53102,52530,54044,54045,54046,53900,53680,53520,53693,53698); INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES (53786, 0, 0x0, 0x1, '100712 99480'), -- Blazing Monstrosity - Fire Hawk Smoke Cosmetic, Sleep (Ultra-High Priority) (53791, 0, 0x0, 0x1, '100712 99480'), -- Blazing Monstrosity - Fire Hawk Smoke Cosmetic, Sleep (Ultra-High Priority) (54056, 0, 0x0, 0x1, '100712 99480'), -- Blazing Monstrosity - Fire Hawk Smoke Cosmetic, Sleep (Ultra-High Priority) (54057, 0, 0x0, 0x1, '100712 99480'), -- Blazing Monstrosity - Fire Hawk Smoke Cosmetic, Sleep (Ultra-High Priority) (53794, 0, 0x0, 0x1, '100712'), -- Smouldering Hatchling - Fire Hawk Smoke Cosmetic (54058, 0, 0x0, 0x1, '100712'), -- Smouldering Hatchling - Fire Hawk Smoke Cosmetic (54276, 0, 0x0, 0x1, '101112'), -- Cinderslither Snake - Cinderslither Aura (54019, 0, 0x0, 0x1, '100556'), -- Captive Druid of the Talon - Smouldering Roots (53224, 0, 0x0, 0x1, '100743'), -- Flamewaker Taskmaster - Aura of Indomitability (53102, 0, 0x3000000, 0x1, '100712'), -- Inferno Hawk - Fire Hawk Smoke Cosmetic (52530, 0, 0x0, 0x1, '100712'), -- Alysrazor - Fire Hawk Smoke Cosmetic (54044, 0, 0x0, 0x1, '100712'), -- Alysrazor - Fire Hawk Smoke Cosmetic (54045, 0, 0x0, 0x1, '100712'), -- Alysrazor - Fire Hawk Smoke Cosmetic (54046, 0, 0x0, 0x1, '100712'), -- Alysrazor - Fire Hawk Smoke Cosmetic (53900, 0, 0x3000000, 0x1, '100712'), -- Blazing Broodmother - Fire Hawk Smoke Cosmetic (53680, 0, 0x3000000, 0x1, '100712'), -- Blazing Broodmother - Fire Hawk Smoke Cosmetic (53520, 0, 0x0, 0x1, '99327'), -- Plump Lava Worm - Fire Worm Cosmetic (53693, 0, 0x0, 0x1, '99793'), -- Fiery Vortex - Fiery Vortex (53698, 0, 0x0, 0x1, '99817'); -- Fiery Tornado - Fiery Tornado DELETE FROM `vehicle_template_accessory` WHERE `entry` IN (53786,53791); INSERT INTO `vehicle_template_accessory` (`entry`, `accessory_entry`, `minion`, `description`, `summontype`, `summontimer`) VALUES (53786,53789,1,'Blazing Monstrosity',5,0), (53791,53792,1,'Blazing Monstrosity',5,0); DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (53786,53791,53789,53792); INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`cast_flags`) VALUES (53786,98509,1), (53791,98509,1), (53789,93970,1), (53792,93970,1); DELETE FROM `creature_text` WHERE `entry`=53795; INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES (53795, 0, 0, 'The Molten Eggs begin to crack and splinter!', 41, 0, 100, 0, 0, 0, 'Molten Egg - EMOTE_CRACKING_EGGS'); -- ScriptNames and conditions UPDATE `instance_template` SET `script`='instance_firelands' WHERE `map`=720; UPDATE `creature_template` SET `ScriptName`='npc_harbinger_of_flame' WHERE `entry`=53793; UPDATE `creature_template` SET `ScriptName`='npc_blazing_monstrosity' WHERE `entry` IN (53786,53791); UPDATE `creature_template` SET `ScriptName`='npc_molten_barrage' WHERE `entry` IN (53787,53788); UPDATE `creature_template` SET `ScriptName`='npc_egg_pile' WHERE `entry`=53795; DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_alysrazor_cosmetic_egg_xplosion'; DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_alysrazor_turn_monstrosity'; DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_alysrazor_aggro_closest'; DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_alysrazor_fieroblast'; INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (100099,'spell_alysrazor_cosmetic_egg_xplosion'), (100076,'spell_alysrazor_turn_monstrosity'), (100078,'spell_alysrazor_turn_monstrosity'), (100080,'spell_alysrazor_turn_monstrosity'), (100082,'spell_alysrazor_turn_monstrosity'), (100089,'spell_alysrazor_turn_monstrosity'), (100090,'spell_alysrazor_turn_monstrosity'), (100091,'spell_alysrazor_turn_monstrosity'), (100092,'spell_alysrazor_turn_monstrosity'), (100462,'spell_alysrazor_aggro_closest'), (100094,'spell_alysrazor_fieroblast'), (101223,'spell_alysrazor_fieroblast'), (101294,'spell_alysrazor_fieroblast'), (101295,'spell_alysrazor_fieroblast'), (101296,'spell_alysrazor_fieroblast'); DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (100558,100071,100074,100070,100076,100078,100080,100082,100089,100090,100091,100092); INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1` ,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES (13,3,100558,0,0,31,0,3,54019,0,0,0,0,'','Sacrifice to the Flame - Captive Druid of the Talon'), (13,1,100071,0,0,31,0,3,53787,0,0,0,0,'','Molten Barrage'), (13,1,100074,0,0,31,0,3,53788,0,0,0,0,'','Molten Barrage'), (13,2,100070,0,0,31,0,3,53786,0,0,0,0,'','Molten Barrage - Blazing Monstrosity'), (13,2,100070,0,1,31,0,3,53791,0,0,0,0,'','Molten Barrage - Blazing Monstrosity'), (13,2,100070,0,2,31,0,3,53793,0,0,0,0,'','Molten Barrage - Harbinger of Flame'), (13,2,100070,0,3,31,0,3,53795,0,0,0,0,'','Molten Barrage - Egg Pile'), (13,2,100070,0,4,31,0,3,53794,0,0,0,0,'','Molten Barrage - Smouldering Hatchling'), (13,1,100076,0,0,31,0,3,53787,0,0,0,0,'','Left-Side Smack - Molten Barrage'), (13,2,100076,0,1,31,0,3,53786,0,0,0,0,'','Left-Side Smack - Blazing Monstrosity'), (13,1,100078,0,0,31,0,3,53787,0,0,0,0,'','Right-Side Smack - Molten Barrage'), (13,2,100078,0,1,31,0,3,53786,0,0,0,0,'','Right-Side Smack - Blazing Monstrosity'), (13,1,100080,0,0,31,0,3,53787,0,0,0,0,'','Head Bonk - Molten Barrage'), (13,2,100080,0,1,31,0,3,53786,0,0,0,0,'','Head Bonk - Blazing Monstrosity'), (13,1,100082,0,0,31,0,3,53787,0,0,0,0,'','Tickle - Molten Barrage'), (13,2,100082,0,1,31,0,3,53786,0,0,0,0,'','Tickle - Blazing Monstrosity'), (13,1,100089,0,0,31,0,3,53788,0,0,0,0,'','Head Bonk - Molten Barrage'), (13,2,100089,0,1,31,0,3,53791,0,0,0,0,'','Head Bonk - Blazing Monstrosity'), (13,1,100090,0,0,31,0,3,53788,0,0,0,0,'','Left-Side Smack - Molten Barrage'), (13,2,100090,0,1,31,0,3,53791,0,0,0,0,'','Left-Side Smack - Blazing Monstrosity'), (13,1,100091,0,0,31,0,3,53788,0,0,0,0,'','Right-Side Smack - Molten Barrage'), (13,2,100091,0,1,31,0,3,53791,0,0,0,0,'','Right-Side Smack - Blazing Monstrosity'), (13,1,100092,0,0,31,0,3,53788,0,0,0,0,'','Tickle - Molten Barrage'), (13,2,100092,0,1,31,0,3,53791,0,0,0,0,'','Tickle - Blazing Monstrosity'); halls of origination 4.3.4 fix Код DELETE FROM `creature_text` WHERE `entry`=39428; INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES (39428, 0, 0, 'More carrion for the swarm...', 14, 0, 100, 0, 0, 18906, 'Earthrager Ptah - SAY_AGGRO'), (39428, 1, 0, 'Ptah... is... no more...', 14, 0, 100, 0, 0, 18905, 'Earthrager Ptah - SAY_DEATH'); DELETE FROM `spell_script_names` WHERE `spell_id` IN (75540,89881,94974,75519); INSERT INTO `spell_script_names` VALUES (75540,'spell_earthrager_ptah_flame_bolt'), (89881,'spell_earthrager_ptah_flame_bolt'), (75519 ,'spell_earthrager_ptah_explosion'), (94974,'spell_earthrager_ptah_earth_spike'); UPDATE `creature_template` SET `ScriptName`='boss_earthrager_ptah' WHERE `Entry`=39428; DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=89398; INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (13, 6, 89398, 0, 0, 31, 0, 3, 39443, 0, 0, 0, 0, '', 'Earth Spike - Camel'); DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=39443; INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`cast_flags`,`user_type`) VALUES (39443,89397,1,0); -- Jeweled Scarab SAI SET @ENTRY := 40458; UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_p aram3`,`event_param4`,`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 (@ENTRY,0,0,1,54,0,100,0,0,0,0,0,91,9,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Jeweled Scarab - On just summoned - Remove field byte for submerged'), (@ENTRY,0,1,0,61,0,100,0,0,0,0,0,11,65982,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Jeweled Scarab - Linked - Cast emerge'), (@ENTRY,0,2,0,1,0,100,1,2500,2500,2500,2500,49,0,0,0,0,0,0,21,100,0,0,0,0,0,0, 'Jeweled Scarab - OOC (one time) - Attack player in 100 yards'), (@ENTRY,0,3,4,6,0,100,0,0,0,0,0,45,0,1,0,0,0,0,11,39428,100,0,0,0,0,0, 'Jeweled Scarab - On death - Set data 0 - 1'), (@ENTRY,0,4,0,61,0,100,0,0,0,0,0,90,9,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Jeweled Scarab - Linked - Add again byte for submerged'); -- Dustbone Horror SAI SET @ENTRY := 40450; SET @SPELL := 75453; -- Smash UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_p aram3`,`event_param4`,`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 (@ENTRY,0,0,0,54,0,100,0,0,0,0,0,91,9,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Dustbone Horror - On just summoned - Remove field byte 1 for submerged'), (@ENTRY,0,1,0,1,0,100,1,2500,2500,2500,2500,49,0,0,0,0,0,0,21,100,0,0,0,0,0,0, 'Dustbone Horror - OOC (one time) - Attack player in 100 yards'), (@ENTRY,0,2,0,0,0,100,0,10000,12000,10000,12000,11,@SPELL,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Dustbone Horror - Combat - Cast Smash'), (@ENTRY,0,3,4,6,0,100,0,0,0,0,0,45,0,1,0,0,0,0,11,39428,100,0,0,0,0,0, 'Dustbone Horror - On death - Set data 0 - 1'), (@ENTRY,0,4,0,61,0,100,0,0,0,0,0,90,9,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Dustbone Horror - Linked - Add again byte for submerged'); -- Add creature_addon data DELETE FROM `creature_template_addon` WHERE `entry` IN (40458,40450); INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES (40458,0,0,9,1,0,NULL), (40450,0,0,9,1,0,NULL); SET @QUICKSAND := 75548; DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@QUICKSAND; INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_p aram3`,`event_param4`,`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 (@QUICKSAND,0,0,0,54,0,100,0,0,0,0,0,11,40503,0,0,0,0,0,1,0,0,0,0,0,0,0,'Quicksand - On summoned (spawned) - Cast spell'); Добавлено (23.02.2013, 10:10) Код REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `AIName`, `ScriptName`, `WDBVerified`) VALUES (210161, 3, 11020, 'Lesser Cache of the Aspects', '', '', '', 0, 0, 1.5, 0, 0, 0, 0, 0, 0, 57, 210161, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 12340); DELETE FROM `gameobject_loot_template` WHERE (`entry`=210161); INSERT INTO `gameobject_loot_template` VALUES (210161, 78430, 33, 1, 0, 1, 1), (210161, 78492, 33, 1, 0, 1, 1), (210161, 78848, 29, 1, 0, 1, 1), (210161, 78849, 29, 1, 0, 1, 1), (210161, 78847, 29, 1, 0, 1, 1), (210161, 78436, 18, 1, 0, 1, 1), (210161, 78490, 18, 1, 0, 1, 1), (210161, 78432, 18, 1, 0, 1, 1), (210161, 78002, 18, 1, 0, 1, 1), (210161, 78433, 13, 1, 0, 1, 1), (210161, 78001, 13, 1, 0, 1, 1), (210161, 78431, 13, 1, 0, 1, 1), (210161, 77992, 13, 1, 0, 1, 1), (210161, 78000, 8, 1, 0, 1, 1), (210161, 78429, 8, 1, 0, 1, 1), (210161, 77999, 8, 1, 0, 1, 1), (210161, 78493, 5, 1, 0, 1, 1), (210161, 78489, 5, 1, 0, 1, 1), (210161, 78491, 5, 1, 0, 1, 1), (210161, 78434, 5, 1, 0, 1, 1), (210161, 78003, 5, 1, 0, 1, 1), (210161, 78435, 5, 1, 0, 1, 1); REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `AIName`, `ScriptName`, `WDBVerified`) VALUES (210160, 3, 11020, 'Lesser Cache of the Aspects', '', '', '', 0, 0, 1.5, 0, 0, 0, 0, 0, 0, 57, 210160, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 12340); DELETE FROM `gameobject_loot_template` WHERE (`entry`=210160); INSERT INTO `gameobject_loot_template` VALUES (210160, 77952, 33, 1, 0, 1, 1), (210160, 71998, 33, 1, 0, 1, 1), (210160, 78174, 18, 1, 0, 1, 1), (210160, 78184, 18, 1, 0, 1, 1), (210160, 78179, 18, 1, 0, 1, 1), (210160, 77245, 7, 1, 0, 1, 1), (210160, 77244, 7, 1, 0, 1, 1), (210160, 78013, 7, 1, 0, 1, 1), (210160, 77205, 7, 1, 0, 1, 1), (210160, 77242, 7, 1, 0, 1, 1), (210160, 77247, 7, 1, 0, 1, 1), (210160, 77246, 7, 1, 0, 1, 1), (210160, 77223, 7, 1, 0, 1, 1), (210160, 77243, 5, 1, 0, 1, 1), (210160, 77210, 5, 1, 0, 1, 1), (210160, 77211, 5, 1, 0, 1, 1), (210160, 77228, 5, 1, 0, 1, 1), (210160, 78919, 5, 1, 0, 1, 1), (210160, 77208, 3, 1, 0, 1, 1), (210160, 77207, 3, 1, 0, 1, 1), (210160, 77232, 3, 1, 0, 1, 1), (210160, 77231, 3, 1, 0, 1, 1), (210160, 77229, 3, 1, 0, 1, 1), (210160, 77230, 3, 1, 0, 1, 1), (210160, 77209, 3, 1, 0, 1, 1); REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `AIName`, `ScriptName`, `WDBVerified`) VALUES (209895, 3, 11020, 'Greater Cache of the Aspects', '', '', '', 0, 0, 1.5, 0, 0, 0, 0, 0, 0, 57, 209895, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 12340); DELETE FROM `gameobject_loot_template` WHERE (`entry`=209895); INSERT INTO `gameobject_loot_template` VALUES (209895, 77997, 31, 1, 0, 1, 1), (209895, 77998, 31, 1, 0, 1, 1), (209895, 78462, 8, 1, 0, 1, 1), (209895, 78463, 8, 1, 0, 1, 1), (209895, 78461, 8, 1, 0, 1, 1), (209895, 77996, 8, 1, 0, 1, 1), (209895, 78465, 5, 1, 0, 1, 1), (209895, 78464, 5, 1, 0, 1, 1), (209895, 77995, 5, 1, 0, 1, 1), (209895, 77994, 5, 1, 0, 1, 1); REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `AIName`, `ScriptName`, `WDBVerified`) VALUES (209894, 3, 11020, 'Greater Cache of the Aspects', '', '', '', 0, 0, 1.5, 0, 0, 0, 0, 0, 0, 57, 209894, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 12340); DELETE FROM `gameobject_loot_template` WHERE (`entry`=209894); INSERT INTO `gameobject_loot_template` VALUES (209894, 77952, 33, 1, 0, 1, 1), (209894, 71998, 33, 1, 0, 1, 1), (209894, 77236, 15, 1, 0, 1, 1), (209894, 77200, 15, 1, 0, 1, 1), (209894, 78357, 15, 1, 0, 1, 1), (209894, 77198, 11, 1, 0, 1, 1), (209894, 77197, 11, 1, 0, 1, 1), (209894, 77238, 11, 1, 0, 1, 1), (209894, 77201, 11, 1, 0, 1, 1), (209894, 77237, 8, 1, 0, 1, 1), (209894, 77199, 8, 1, 0, 1, 1), (209894, 77235, 8, 1, 0, 1, 1);
Сообщение # 1 написано 23.02.2013 в 10:10
|
| |||
| |||