diff options
10 files changed, 231 insertions, 2 deletions
diff --git a/sql/updates/world/2015_07_12_43_world_2015_06_28_01.sql b/sql/updates/world/2015_07_12_43_world_2015_06_28_01.sql index 850b1f295e8..91320a9b33c 100644 --- a/sql/updates/world/2015_07_12_43_world_2015_06_28_01.sql +++ b/sql/updates/world/2015_07_12_43_world_2015_06_28_01.sql @@ -4,8 +4,8 @@ INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry (13, 1, 51518, 31, 3, 27641), (13, 1, 50087, 31, 3, 27641); ---- DELETE FROM `spelldifficulty_dbc` WHERE `id` = 50044; ---- INSERT INTO `spelldifficulty_dbc` (`id`, `spellid0`, `spellid1`) VALUES (50044, 50044, 59213); +-- DELETE FROM `spelldifficulty_dbc` WHERE `id` = 50044; +-- INSERT INTO `spelldifficulty_dbc` (`id`, `spellid0`, `spellid1`) VALUES (50044, 50044, 59213); UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=27641; diff --git a/sql/updates/world/2015_07_12_53_world_2015_07_12_00.sql b/sql/updates/world/2015_07_12_53_world_2015_07_12_00.sql new file mode 100644 index 00000000000..6b39023b2d5 --- /dev/null +++ b/sql/updates/world/2015_07_12_53_world_2015_07_12_00.sql @@ -0,0 +1,15 @@ +-- +DELETE FROM `gameobject_template` WHERE `entry`=175622; +INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `size`, `data3`, `data6`, `VerifiedBuild`) VALUES +(175622,6,477,'Rookery Egg Spawner',1,15745,-1,-18019); + +SET @ENTRY := 10161; -- NPC entry +SET @SPELL1 := 15750; -- Rookery Whelp Spawn-in Spell +SET @obj := 175622; -- Rookery Egg Spawner +UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='' WHERE `entry`=@ENTRY; +UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry`=@obj; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=1 AND `entryorguid`=@obj; +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`,`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,11,@SPELL1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Rookery Whelp - On spawn - Cast Rookery Whelp Spawn-in Spell'), +(@obj,1,0,0,63,0,100,0,0,0,0,0,99,3,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Rookery Egg Spawner - Jsut created - SET_LOOT_STATE 3'); diff --git a/sql/updates/world/2015_07_12_54_world_2015_07_12_01.sql b/sql/updates/world/2015_07_12_54_world_2015_07_12_01.sql new file mode 100644 index 00000000000..26a5a94bd83 --- /dev/null +++ b/sql/updates/world/2015_07_12_54_world_2015_07_12_01.sql @@ -0,0 +1,3 @@ +-- +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=19 AND `SourceEntry` IN (13410, 13411); +UPDATE `quest_template_addon` SET `AllowableClasses`=32 WHERE `id` IN (13410, 13411); diff --git a/sql/updates/world/2015_07_12_55_world_2015_07_12_02.sql b/sql/updates/world/2015_07_12_55_world_2015_07_12_02.sql new file mode 100644 index 00000000000..1bd9a94034a --- /dev/null +++ b/sql/updates/world/2015_07_12_55_world_2015_07_12_02.sql @@ -0,0 +1,39 @@ +-- +DELETE FROM `gameobject` WHERE `guid`=43131; +UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry` IN (164820, 164821, 164822, 164823, 164824, 164825); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (164819, 164820, 164821, 164822, 164823, 164824, 164825) AND `source_type`=1; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (16481900,16481901,16481902,16481903,16481904,16481905) AND `source_type`=9; +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`, `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 +(164819, 1, 0, 0, 70, 0, 100, 1, 2, 0, 0, 0, 87, 16481900, 16481901, 16481902, 16481903, 16481904, 16481905, 1, 0, 0, 0, 0, 0, 0, 0, 'Dark Keeper Portrait - ON_STATE_CHANGED - Random action list'), +(16481900, 9, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 50, 164820, 999990, 0, 0, 0, 0, 8, 0, 0, 0, 831.54,-339.529,-46.682,0.802851, 'Dark Keeper Portrait - action list - Summon Dark Keeper Nameplate'), +(16481900, 9, 1, 0, 0, 0, 100, 1, 2000, 2000, 0, 0, 106, 16, 0, 0, 0, 0, 0, 20, 164820, 20, 0, 0, 0, 0, 0, 'Dark Keeper Nameplate - action list - Remove flags'), +(16481900, 9, 2, 0, 0, 0, 100, 1, 0, 0, 0, 0, 12, 9437, 8, 0, 0, 0, 0, 8, 0, 0, 0, 914.054688, -164.124573, -49.760696, 2.162512, 'Dark Keeper Portrait - action list - Summon Dark Keeper Vorfalk'), +(16481900, 9, 3, 0, 0, 0, 100, 1, 0, 0, 0, 0, 12, 9445, 8, 0, 0, 0, 0, 8, 0, 0, 0, 916.78241, -163.221985, -49.760696, 2.222960, 'Dark Keeper Portrait - action list - Summon Dark guard'), +(16481900, 9, 4, 0, 0, 0, 100, 1, 0, 0, 0, 0, 12, 9445, 8, 0, 0, 0, 0, 8, 0, 0, 0, 912.515259, -166.480469, -49.760696, 2.222960, 'Dark Keeper Portrait - action list - Summon Dark guard'), +(16481901, 9, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 50, 164821, 999990, 0, 0, 0, 0, 8, 0, 0, 0, 831.54,-339.529,-46.682,0.802851, 'Dark Keeper Portrait - action list - Summon Dark Keeper Nameplate'), +(16481901, 9, 1, 0, 0, 0, 100, 1, 2000, 2000, 0, 0, 106, 16, 0, 0, 0, 0, 0, 20, 164821, 20, 0, 0, 0, 0, 0, 'Dark Keeper Nameplate - action list - Remove flags'), +(16481901, 9, 2, 0, 0, 0, 100, 1, 0, 0, 0, 0, 12, 9438, 8, 0, 0, 0, 0, 8, 0, 0, 0, 812.245789, -348.875336, -50.578079, 0.710542, 'Dark Keeper Portrait - action list - Summon Dark Keeper Bethek'), +(16481901, 9, 3, 0, 0, 0, 100, 1, 0, 0, 0, 0, 12, 9445, 8, 0, 0, 0, 0, 8, 0, 0, 0, 809.894714, -348.221252, -50.578079, 0.713424, 'Dark Keeper Portrait - action list - Summon Dark guard'), +(16481901, 9, 4, 0, 0, 0, 100, 1, 0, 0, 0, 0, 12, 9445, 8, 0, 0, 0, 0, 8, 0, 0, 0, 812.574646, -351.317627, -50.578079, 0.713424, 'Dark Keeper Portrait - action list - Summon Dark guard'), +(16481902, 9, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 50, 164822, 999990, 0, 0, 0, 0, 8, 0, 0, 0, 831.54,-339.529,-46.682,0.802851, 'Dark Keeper Portrait - action list - Summon Dark Keeper Nameplate'), +(16481902, 9, 1, 0, 0, 0, 100, 1, 2000, 2000, 0, 0, 106, 16, 0, 0, 0, 0, 0, 20, 164822, 20, 0, 0, 0, 0, 0, 'Dark Keeper Nameplate - action list - Remove flags'), +(16481902, 9, 2, 0, 0, 0, 100, 1, 0, 0, 0, 0, 12, 9439, 8, 0, 0, 0, 0, 8, 0, 0, 0, 888.483093, -361.707306, -49.935787, 0.612107, 'Dark Keeper Portrait - action list - Summon Dark Keeper Uggel'), +(16481902, 9, 3, 0, 0, 0, 100, 1, 0, 0, 0, 0, 12, 9445, 8, 0, 0, 0, 0, 8, 0, 0, 0, 886.981873, -360.477570, -49.935787, 0.612107, 'Dark Keeper Portrait - action list - Summon Dark guard'), +(16481902, 9, 4, 0, 0, 0, 100, 1, 0, 0, 0, 0, 12, 9445, 8, 0, 0, 0, 0, 8, 0, 0, 0, 888.820007, -363.745789, -49.935787, 0.612107, 'Dark Keeper Portrait - action list - Summon Dark guard'), +(16481903, 9, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 50, 164823, 999990, 0, 0, 0, 0, 8, 0, 0, 0, 831.54,-339.529,-46.682,0.802851, 'Dark Keeper Portrait - action list - Summon Dark Keeper Nameplate'), +(16481903, 9, 1, 0, 0, 0, 100, 1, 2000, 2000, 0, 0, 106, 16, 0, 0, 0, 0, 0, 20, 164823, 20, 0, 0, 0, 0, 0, 'Dark Keeper Nameplate - action list - Remove flags'), +(16481903, 9, 2, 0, 0, 0, 100, 1, 0, 0, 0, 0, 12, 9441, 8, 0, 0, 0, 0, 8, 0, 0, 0, 545.018250, -214.378723, -35.546509, 0.339364, 'Dark Keeper Portrait - action list - Summon Dark Keeper Zimrel'), +(16481903, 9, 3, 0, 0, 0, 100, 1, 0, 0, 0, 0, 12, 9445, 8, 0, 0, 0, 0, 8, 0, 0, 0, 543.336975, -211.983978, -35.511829, 0.401620, 'Dark Keeper Portrait - action list - Summon Dark guard'), +(16481903, 9, 4, 0, 0, 0, 100, 1, 0, 0, 0, 0, 12, 9445, 8, 0, 0, 0, 0, 8, 0, 0, 0, 546.018433, -217.407089, -35.570370, 0.505293, 'Dark Keeper Portrait - action list - Summon Dark guard'), +(16481904, 9, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 50, 164824, 999990, 0, 0, 0, 0, 8, 0, 0, 0, 831.54,-339.529,-46.682,0.802851, 'Dark Keeper Portrait - action list - Summon Dark Keeper Nameplate'), +(16481904, 9, 1, 0, 0, 0, 100, 1, 2000, 2000, 0, 0, 106, 16, 0, 0, 0, 0, 0, 20, 164824, 20, 0, 0, 0, 0, 0, 'Dark Keeper Nameplate - action list - Remove flags'), +(16481904, 9, 2, 0, 0, 0, 100, 1, 0, 0, 0, 0, 12, 9442, 8, 0, 0, 0, 0, 8, 0, 0, 0, 659.373108, 2.659090, -60.058517, 0.990563, 'Dark Keeper Portrait - action list - Summon Dark Keeper Ofgut'), +(16481904, 9, 3, 0, 0, 0, 100, 1, 0, 0, 0, 0, 12, 9445, 8, 0, 0, 0, 0, 8, 0, 0, 0, 658.681152, 5.299511, -60.058456, 0.990563, 'Dark Keeper Portrait - action list - Summon Dark guard'), +(16481904, 9, 4, 0, 0, 0, 100, 1, 0, 0, 0, 0, 12, 9445, 8, 0, 0, 0, 0, 8, 0, 0, 0, 661.902344, 2.769512, -60.058456, 0.990563, 'Dark Keeper Portrait - action list - Summon Dark guard'), +(16481904, 9, 5, 0, 0, 0, 100, 1, 0, 0, 0, 0, 12, 9445, 8, 0, 0, 0, 0, 8, 0, 0, 0, 659.791687, -0.450377, -60.058517, 0.990563, 'Dark Keeper Portrait - action list - Summon Dark guard'), +(16481904, 9, 6, 0, 0, 0, 100, 1, 0, 0, 0, 0, 12, 9445, 8, 0, 0, 0, 0, 8, 0, 0, 0, 656.212524, 2.171975, -60.058456, 0.99056, 'Dark Keeper Portrait - action list - Summon Dark guard'), +(16481905, 9, 0, 0, 0, 0, 100, 1, 0, 0, 0, 0, 50, 164825, 999990, 0, 0, 0, 0, 8, 0, 0, 0, 831.54,-339.529,-46.682,0.802851, 'Dark Keeper Portrait - action list - Summon Dark Keeper Nameplate'), +(16481905, 9, 1, 0, 0, 0, 100, 1, 2000, 2000, 0, 0, 106, 16, 0, 0, 0, 0, 0, 20, 164825, 20, 0, 0, 0, 0, 0, 'Dark Keeper Nameplate - action list - Remove flags'), +(16481905, 9, 2, 0, 0, 0, 100, 1, 0, 0, 0, 0, 12, 9443, 8, 0, 0, 0, 0, 8, 0, 0, 0, 804.041260, -247.344772, -43.302856, 2.606160, 'Dark Keeper Portrait - action list - Summon Dark Keeper Pelver'), +(16481905, 9, 3, 0, 0, 0, 100, 1, 0, 0, 0, 0, 12, 9445, 8, 0, 0, 0, 0, 8, 0, 0, 0, 805.992065, -246.460281, -43.302856, 2.525251, 'Dark Keeper Portrait - action list - Summon Dark guard'), +(16481905, 9, 4, 0, 0, 0, 100, 1, 0, 0, 0, 0, 12, 9445, 8, 0, 0, 0, 0, 8, 0, 0, 0, 803.904053, -249.407654, -43.302856, 2.525251, 'Dark Keeper Portrait - action list - Summon Dark guard'); diff --git a/sql/updates/world/2015_07_12_56_world_2015_07_12_03.sql b/sql/updates/world/2015_07_12_56_world_2015_07_12_03.sql new file mode 100644 index 00000000000..7051069c121 --- /dev/null +++ b/sql/updates/world/2015_07_12_56_world_2015_07_12_03.sql @@ -0,0 +1,25 @@ +-- +UPDATE `creature_text` SET `type`=14 WHERE `Entry` IN (31397) AND `id` IN (5, 6, 7); +UPDATE `smart_scripts` SET `action_type`=83, `action_param1`=1, `target_type`=1, `comment`="Saronite Mine Slave - On Script - remove npc flag" WHERE `entryorguid` IN (3139700) AND `source_type`=9 AND `id` IN (1); +UPDATE `smart_scripts` SET `action_type`=87, `action_param1`=3139700, `action_param2`=3139701 WHERE `entryorguid` IN (31397) AND `source_type`=0 AND `id` IN (0); +DELETE FROM `smart_scripts` WHERE `entryorguid`=3139701 AND `source_type`=9; +DELETE FROM `smart_scripts` WHERE `entryorguid`=3139700 AND `source_type`=9 AND `id`>2; +DELETE FROM `smart_scripts` WHERE `entryorguid`=31397 AND `source_type`=0 AND `id`>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`, `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 +(3139701, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Saronite Mine Slave - action list - close gossip'), +(3139701, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 2, 14, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Saronite Mine Slave - action list - set faction'), +(3139701, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Saronite Mine Slave - action list - say text1'), +(3139701, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Saronite Mine Slave - action list - Attack'), +(3139701, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 8599, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Saronite Mine Slave - action list - cast Enrage'), +(31397, 0, 1, 0, 0, 0, 100, 0, 1000, 1000, 14000, 14000, 11, 3148, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Saronite Mine Slave - IC - cast Head Crack'), +(31397, 0, 2, 0, 1, 0, 15, 0, 10000, 30000, 50000, 70000, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Saronite Mine Slave - OOC - Say text2'), +(3139700, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 69, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 7027.581543, 1894.517334, 529.414001, 0, 'Saronite Mine Slave - action list - move to pos'), +(3139700, 9, 4, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Saronite Mine Slave - action list - despawn'); + +DELETE FROM `creature_text` WHERE `entry` IN(31397) AND `groupid`=1; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`,`BroadcastTextId`) VALUES +(31397,1,0,'Please, no more.',12,1,100,0,0,0,'Saronite Mine Slave', 32506), +(31397,1,1,'Hit me again and you''ll regret it!',12,1,100,0,0,0,'Saronite Mine Slave', 32507), +(31397,1,2,'Ow!',12,1,100,0,0,0,'Saronite Mine Slave', 32508), +(31397,1,3,'I''m sorry. I''ll work harder.',12,1,100,0,0,0,'Saronite Mine Slave', 32509), +(31397,1,4,'Soon the master will reclaim me!',12,1,100,0,0,0,'Saronite Mine Slave', 32510); diff --git a/sql/updates/world/2015_07_12_56_world_2015_07_12_04.sql b/sql/updates/world/2015_07_12_56_world_2015_07_12_04.sql new file mode 100644 index 00000000000..92d33488e9a --- /dev/null +++ b/sql/updates/world/2015_07_12_56_world_2015_07_12_04.sql @@ -0,0 +1,94 @@ +-- +UPDATE `gameobject_template` SET `AIName` = 'SmartGameObjectAI' WHERE `entry`=181058; +UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` IN (16059, 16053, 16051, 16050, 16049, 16052, 16054, 16055, 16058); +DELETE FROM `smart_scripts` WHERE `entryorguid`=181058 AND `source_type`=1; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (18105800, 18105801, 18105802, 18105803, 18105804, 18105805, 18105806, 18105807, 18105808) AND `source_type`=9; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (16059, 16053, 16051, 16050, 16049, 16052, 16054, 16055, 16058) 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`, `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 +(181058, 1, 0, 0, 63, 0, 100, 0, 0, 0, 0, 0, 88, 18105800, 18105801, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Banner of Provocation - Action list - Random Action list'), +(18105800, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 16053, 6, 240000, 0, 0, 0, 8, 0, 0, 0, 581.311523, -198.221954, -53.569504, 0.534245, 'Banner of Provocation - Action list - Summon unit'), +(18105800, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 16050, 6, 240000, 0, 0, 0, 8, 0, 0, 0, 595.331116, -207.562607, -53.427147, 1.512066, 'Banner of Provocation - Action list - Summon unit'), +(18105800, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 16052, 6, 240000, 0, 0, 0, 8, 0, 0, 0, 609.827820, -206.808533, -53.379620, 2.175728, 'Banner of Provocation - Action list - Summon unit'), +(18105800, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 16055, 6, 240000, 0, 0, 0, 8, 0, 0, 0, 618.482727, -196.314209, -53.240608, 2.926569, 'Banner of Provocation - Action list - Summon unit'), +(18105801, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 16051, 6, 240000, 0, 0, 0, 8, 0, 0, 0, 581.311523, -198.221954, -53.569504, 0.534245, 'Banner of Provocation - Action list - Summon unit'), +(18105801, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 16049, 6, 240000, 0, 0, 0, 8, 0, 0, 0, 595.331116, -207.562607, -53.427147, 1.512066, 'Banner of Provocation - Action list - Summon unit'), +(18105801, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 16054, 6, 240000, 0, 0, 0, 8, 0, 0, 0, 609.827820, -206.808533, -53.379620, 2.175728, 'Banner of Provocation - Action list - Summon unit'), +(18105801, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 12, 16058, 6, 240000, 0, 0, 0, 8, 0, 0, 0, 618.482727, -196.314209, -53.240608, 2.926569, 'Banner of Provocation - Action list - Summon unit'), +(181058, 1, 1, 2, 77, 0, 100, 1, 1, 4, 0, 0, 12, 16059, 6, 120000, 0, 0, 0, 8, 0, 0, 0, 606.113098, -199.239075, -53.441307, 0, 'Banner of Provocation - On counter set - Summon unit'), +(181058, 1, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 44, 2, 0, 0, 0, 0, 0, 20, 181059, 90, 0, 0, 0, 0, 0,'Banner of Provocation - On counter set - Set to phase 2'), +-- npc=16059 +(16059, 0, 0, 0, 1, 0, 100, 1, 100, 100, 0, 0, 11, 27578, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'Theldren - IC - Battle Shout'), +(16059, 0, 1, 0, 0, 0, 100, 0, 1000, 1000, 35000, 35000, 11, 27579, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Theldren - IC - Demoralizing Shout'), +(16059, 0, 2, 0, 0, 0, 100, 0, 5000, 5000, 15000, 15000, 11, 27581, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Theldren - IC - Disarm '), +(16059, 0, 3, 0, 2, 0, 100, 1, 20, 35, 0, 0, 11, 15503, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'Theldren - IC - Heal '), +(16059, 0, 4, 0, 0, 0, 100, 0, 7000, 7000, 9000, 9000, 11, 19134, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0,'Theldren - IC - Fear random target '), +(16059, 0, 5, 0, 0, 0, 100, 0, 8000, 8000, 9000, 9000, 11, 27584, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Theldren - IC - Hamstring '), +(16059, 0, 6, 0, 0, 0, 100, 0, 0, 0, 14000, 14000, 11, 27577, 2, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0,'Theldren - IC - Charge random target '), +(16059, 0, 7, 0, 0, 0, 100, 0, 3000, 3000, 12000, 12000, 11, 27580, 2, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Theldren - IC - Mortal Strike '), +(16059, 0, 8, 0, 4, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Theldren - aggro - text'), +(16059, 0, 9, 10, 63, 0, 100, 0, 0, 0, 0, 0, 33, 16166, 0, 0, 0, 0, 0, 18, 90, 0, 0, 0, 0, 0, 0,'Theldren - Just summoned - kill credit'), +(16059, 0, 10, 0, 61, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 60, 0, 0, 0, 0, 0, 0,'Theldren - Just summoned - Attack'), +-- npc=16053 +(16053, 0, 0, 0, 1, 0, 100, 1, 100, 100, 0, 0, 11, 15786, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'Totem'), +(16053, 0, 1, 0, 0, 0, 100, 0, 1000, 1000, 15000, 15000, 11, 27623, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'Fire totem'), +(16053, 0, 2, 0, 0, 0, 100, 0, 5000, 5000, 9000, 9000, 11, 21401, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Frost shhock'), +(16053, 0, 3, 0, 0, 0, 100, 0, 10000, 10000, 15000, 15000, 11, 15503, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'Drink Healing Potion'), +(16053, 0, 4, 0, 0, 0, 100, 0, 7000, 7000, 12000, 12000, 11, 27624, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'Lesser Healing Wave'), +(16053, 0, 5, 0, 63, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 60, 0, 0, 0, 0, 0, 0,'Just summoned - Attack'), +(16053, 0, 6, 0, 6, 0, 100, 0, 0, 0, 0, 0, 63, 1, 1, 0, 0, 0, 0, 20, 181058, 90, 0, 0, 0, 0, 0,'On death - Add +1 to the gob counter'), +-- npc=16051 +(16051, 0, 0, 0, 0, 0, 100, 0, 1000, 1000, 6000, 7000, 11, 15241, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Scorch'), +(16051, 0, 1, 0, 0, 0, 100, 0, 4000, 4000, 8000, 9000, 11, 11829, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Flamestrike'), +(16051, 0, 2, 0, 0, 0, 100, 0, 12000, 15000, 20000, 25000, 11, 13323, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Polymorph'), +(16051, 0, 3, 0, 0, 0, 100, 0, 6000, 8000, 10000, 15000, 11, 17273, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Pyroblast'), +(16051, 0, 4, 0, 63, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 60, 0, 0, 0, 0, 0, 0,'Just summoned - Attack'), +(16051, 0, 5, 0, 6, 0, 100, 0, 0, 0, 0, 0, 63, 1, 1, 0, 0, 0, 0, 20, 181058, 90, 0, 0, 0, 0, 0,'On death - Add +1 to the gob counter'), +-- npc=16050 +(16050, 0, 0, 0, 0, 0, 100, 0, 3000, 3000, 5000, 5000, 11, 27611, 2, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Eviscerate'), +(16050, 0, 1, 0, 0, 0, 100, 0, 1000, 1000, 7000, 7000, 11, 12540, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Gouge'), +(16050, 0, 2, 0, 0, 0, 100, 0, 5000, 5000, 9000, 9000, 11, 27613, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'kick'), +(16050, 0, 3, 0, 0, 0, 100, 0, 5000, 5000, 9000, 9000, 11, 27615, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0,'Kidney Shot'), +(16050, 0, 4, 0, 0, 0, 100, 0, 8000, 8000, 8000, 8000, 11, 14873, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Sinister Strike'), +(16050, 0, 5, 0, 63, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 60, 0, 0, 0, 0, 0, 0,'Just summoned - Attack'), +(16050, 0, 6, 0, 6, 0, 100, 0, 0, 0, 0, 0, 63, 1, 1, 0, 0, 0, 0, 20, 181058, 90, 0, 0, 0, 0, 0,'On death - Add +1 to the gob counter'), +-- npc=16049 +(16049, 0, 0, 0, 0, 0, 100, 0, 5000, 5000, 8000, 8000, 11, 15503, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'Heal'), +(16049, 0, 1, 0, 0, 0, 100, 0, 1000, 1000, 7500, 7500, 11, 11428, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Stuneed'), +(16049, 0, 2, 0, 0, 0, 100, 0, 5000, 5000, 15000, 15000, 11, 27620, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0,'silence'), +(16049, 0, 3, 0, 0, 0, 100, 0, 5000, 5000, 7000, 7000, 11, 27673, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,''), +(16049, 0, 4, 0, 63, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 60, 0, 0, 0, 0, 0, 0,'Just summoned - Attack'), +(16049, 0, 5, 0, 6, 0, 100, 0, 0, 0, 0, 0, 63, 1, 1, 0, 0, 0, 0, 20, 181058, 90, 0, 0, 0, 0, 0,'On death - Add +1 to the gob counter'), +-- npc=16052 +(16052, 0, 0, 0, 0, 0, 100, 0, 5000, 5000, 8000, 8000, 11, 15503, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'Heal'), +(16052, 0, 1, 0, 0, 0, 100, 0, 3000, 3000, 7500, 7500, 11, 27632, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Aimed Shot'), +(16052, 0, 2, 0, 0, 0, 100, 0, 5000, 5000, 9000, 9000, 11, 27634, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Concussive Shot'), +(16052, 0, 3, 0, 0, 0, 100, 0, 5000, 5000, 7000, 7000, 11, 18651, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Multi-Shot'), +(16052, 0, 4, 0, 0, 0, 100, 1, 0, 0, 0, 0, 11, 19561, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'Summon Gnashjaw'), +(16052, 0, 5, 0, 63, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 60, 0, 0, 0, 0, 0, 0,'Just summoned - Attack'), +(16052, 0, 6, 0, 6, 0, 100, 0, 0, 0, 0, 0, 63, 1, 1, 0, 0, 0, 0, 20, 181058, 90, 0, 0, 0, 0, 0,'On death - Add +1 to the gob counter'), +-- npc=16054 +(16054, 0, 0, 0, 0, 0, 100, 0, 5000, 5000, 8000, 8000, 11, 27677, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'Recombobulate'), +(16054, 0, 1, 0, 0, 0, 100, 0, 1000, 1000, 7500, 7500, 11, 27603, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Goblin Dragon Gun'), +(16054, 0, 2, 0, 0, 0, 100, 0, 10000, 10000, 20000, 20000, 11, 8209, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Explosive Sheep'), +(16054, 0, 3, 0, 0, 0, 100, 0, 5000, 5000, 7000, 7000, 11, 19784, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Dark Iron Bomb'), +(16054, 0, 4, 0, 63, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 60, 0, 0, 0, 0, 0, 0,'Just summoned - Attack'), +(16054, 0, 5, 0, 6, 0, 100, 0, 0, 0, 0, 0, 63, 1, 1, 0, 0, 0, 0, 20, 181058, 90, 0, 0, 0, 0, 0,'On death - Add +1 to the gob counter'), +-- npc=16055 +(16055, 0, 0, 0, 0, 0, 100, 0, 5000, 5000, 8000, 8000, 11, 27608, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'Flash Heal'), +(16055, 0, 1, 0, 0, 0, 100, 0, 3000, 3000, 12000, 12000, 11, 20697, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'Power Word: Shield'), +(16055, 0, 2, 0, 0, 0, 100, 0, 10000, 10000, 15000, 15000, 11, 23895, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'Renew'), +(16055, 0, 3, 0, 0, 0, 100, 0, 5000, 5000, 7000, 7000, 11, 30898, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Shadow Word: Pain'), +(16055, 0, 4, 0, 63, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 60, 0, 0, 0, 0, 0, 0,'Just summoned - Attack'), +(16055, 0, 5, 0, 6, 0, 100, 0, 0, 0, 0, 0, 63, 1, 1, 0, 0, 0, 0, 20, 181058, 90, 0, 0, 0, 0, 0,'On death - Add +1 to the gob counter'), +-- npc=16058 +(16058, 0, 0, 0, 0, 0, 100, 0, 5000, 5000, 8000, 8000, 11, 27618, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Blizzard'), +(16058, 0, 1, 0, 0, 0, 100, 0, 3000, 3000, 12000, 12000, 11, 12557, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Cone of Cold'), +(16058, 0, 2, 0, 0, 0, 100, 0, 7000, 7000, 5000, 5000, 11, 36990, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,'Frostbolt'), +(16058, 0, 3, 0, 0, 0, 100, 0, 25000, 25000, 25000, 25000, 11, 45438, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'Ice Block'), +(16058, 0, 4, 0, 63, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 60, 0, 0, 0, 0, 0, 0,'Just summoned - Attack'), +(16058, 0, 5, 0, 6, 0, 100, 0, 0, 0, 0, 0, 63, 1, 1, 0, 0, 0, 0, 20, 181058, 90, 0, 0, 0, 0, 0,'On death - Add +1 to the gob counter'); +DELETE FROM `creature_text` WHERE `entry`=16059; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(16059,0,0, 'I''m going to kick yer ugly head in!',14,0,100,0,0,0,11953,0,''), +(16059,0,1, 'You want a fight? A fight you''ll get!',14,0,100,0,0,0,11952,0,''), +(16059,0,2, 'I crush weaklings like you every day! Bring it on!',14,0,100,0,0,0,11954,0,''); diff --git a/sql/updates/world/2015_07_12_57_world_2015_07_12_05.sql b/sql/updates/world/2015_07_12_57_world_2015_07_12_05.sql new file mode 100644 index 00000000000..a2fb34e9d7d --- /dev/null +++ b/sql/updates/world/2015_07_12_57_world_2015_07_12_05.sql @@ -0,0 +1,34 @@ +-- +UPDATE `smart_scripts` SET `target_type`=15, `target_param2`=50, `target_param3`=0 WHERE `entryorguid`=164911 AND `source_Type`=1 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=11, `target_param2`=50, `target_param3`=0 WHERE `entryorguid`=164911 AND `source_Type`=1 AND `id`=1; +UPDATE `smart_scripts` SET `target_type`=11, `target_param2`=50, `target_param3`=0 WHERE `entryorguid`=164911 AND `source_Type`=1 AND `id`=2; +UPDATE `smart_scripts` SET `target_type`=11, `target_param2`=50, `target_param3`=0 WHERE `entryorguid`=9537 AND `source_Type`=0 AND `id`=4; +UPDATE `smart_scripts` SET `target_type`=11, `target_param2`=50, `target_param3`=0 WHERE `entryorguid`=9537 AND `source_Type`=0 AND `id`=16; +UPDATE `smart_scripts` SET `target_param1`=50 WHERE `entryorguid`=9537 AND `source_Type`=0 AND `id`=18; +UPDATE `smart_scripts` SET `target_type`=11, `target_param2`=50, `target_param3`=0 WHERE `entryorguid`=-71997 AND `source_Type`=0 AND `id`=10; +UPDATE `smart_scripts` SET `target_type`=11, `target_param2`=50, `target_param3`=0 WHERE `entryorguid`=-71997 AND `source_Type`=0 AND `id`=11; +UPDATE `smart_scripts` SET `target_param1`=50 WHERE `entryorguid`=-71997 AND `source_Type`=0 AND `id`=13; +UPDATE `smart_scripts` SET `target_type`=11, `target_param2`=50, `target_param3`=0 WHERE `entryorguid`=-71998 AND `source_Type`=0 AND `id`=10; +UPDATE `smart_scripts` SET `target_type`=11, `target_param2`=50, `target_param3`=0 WHERE `entryorguid`=-71998 AND `source_Type`=0 AND `id`=11; +UPDATE `smart_scripts` SET `target_param1`=50 WHERE `entryorguid`=-71998 AND source_Type=0 AND id=13; +UPDATE `smart_scripts` SET `target_type`=11, `target_param2`=50, `target_param3`=0 WHERE `entryorguid`=-71999 AND `source_Type`=0 AND `id`=10; +UPDATE `smart_scripts` SET `target_type`=11, `target_param2`=50, `target_param3`=0 WHERE `entryorguid`=-71999 AND `source_Type`=0 AND `id`=11; +UPDATE `smart_scripts` SET `target_param1`=50 WHERE `entryorguid`=-71999 AND `source_Type`=0 AND `id`=13; +UPDATE `smart_scripts` SET `action_param6`=2 WHERE `entryorguid`=9537 AND `source_Type`=0 AND `id`=7; +UPDATE `smart_scripts` SET `action_param6`=2 WHERE `entryorguid`=-71997 AND `source_Type`=0 AND `id`=4; +UPDATE `smart_scripts` SET `action_param6`=2 WHERE `entryorguid`=-71998 AND `source_Type`=0 AND `id`=4; +UPDATE `smart_scripts` SET `action_param6`=2 WHERE `entryorguid`=-71999 AND `source_Type`=0 AND `id`=4; +UPDATE `smart_scripts` SET `link`=2 WHERE `entryorguid`=9537 AND `source_Type`=0 AND `id`=1; +UPDATE `smart_scripts` SET `link`=3 WHERE `entryorguid`=-71997 AND `source_Type`=0 AND `id`=1; +UPDATE `smart_scripts` SET `link`=3 WHERE `entryorguid`=-71998 AND `source_Type`=0 AND `id`=1; +UPDATE `smart_scripts` SET `link`=3 WHERE `entryorguid`=-71999 AND `source_Type`=0 AND `id`=1; + +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`IN(9537) AND `id`=2; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`IN(-71997,-71998,-71999) AND `id`=3; +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`, `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 +(9537, 0, 2 ,0, 61, 0, 100, 0, 0, 0, 0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Hurley Blackbreath - On spawn - react passif'), +(-71997, 0, 3 ,0, 61, 0, 100, 0, 0, 0, 0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Blackbreath Crony - On spawn- react passif'), +(-71998, 0, 3 ,0, 61, 0, 100, 0, 0, 0, 0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Blackbreath Crony - On spawn - react passif'), +(-71999, 0, 3 ,0, 61, 0, 100, 0, 0, 0, 0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Blackbreath Crony - On spawn - react passif'); + +UPDATE `creature_template` SET `unit_flags`=33344 WHERE `entry`=9543; diff --git a/sql/updates/world/2015_07_12_58_world_2015_07_12_06.sql b/sql/updates/world/2015_07_12_58_world_2015_07_12_06.sql new file mode 100644 index 00000000000..5a0db2b9ec5 --- /dev/null +++ b/sql/updates/world/2015_07_12_58_world_2015_07_12_06.sql @@ -0,0 +1,3 @@ +-- +UPDATE `gossip_menu_option` SET `action_menu_id`=4382 WHERE `menu_id`=4346 AND `id`=1; +UPDATE `gossip_menu_option` SET `action_menu_id`=4383 WHERE `menu_id`=4346 AND `id`=2; diff --git a/sql/updates/world/2015_07_12_59_world_2015_07_12_07.sql b/sql/updates/world/2015_07_12_59_world_2015_07_12_07.sql new file mode 100644 index 00000000000..8da21d45f1d --- /dev/null +++ b/sql/updates/world/2015_07_12_59_world_2015_07_12_07.sql @@ -0,0 +1,14 @@ +-- +-- UPDATE `creature` SET `phaseMask`=1 WHERE `guid` IN (88806, 88792, 88802, 88788, 88777, 88778, 88804, 88790, 88800, 88786, 88803, 88789, 88797, 88783, 88796, 88782, 88799, 88785, 88784, 88798); +DELETE FROM `creature` WHERE `guid` IN (129856, 129855, 129857, 129858, 129864); + +SET @GUID := 6341; -- 3 free gob guid set by TC +DELETE FROM `gameobject` WHERE `guid`IN (@GUID, @GUID+1, @GUID+2); +INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES +(@GUID+0,196871,571,1,8121.33,794.503,481.288,-1.797,0,0,-0.782608,0.622515,180,100,1), +(@GUID+1,196871,571,1,5644.50,2107.415,798.054,4.5902,0,0,-0.782608,0.622515,180,100,1), +(@GUID+2,196871,571,1,5660.98,2106.137,798.054,4.5902,0,0,-0.782608,0.622515,180,100,1); + +DELETE FROM `gameobject_addon` WHERE `guid` IN (164446,164447, 6135, 6134); +INSERT INTO `gameobject_addon` (`guid`, `invisibilityType`, `invisibilityValue`) VALUES +(@GUID+1,8,1000), (@GUID+2,8,1000), (6135,9,1000), (6134,9,1000); diff --git a/sql/updates/world/2015_07_12_60_world_2015_07_12_08.sql b/sql/updates/world/2015_07_12_60_world_2015_07_12_08.sql new file mode 100644 index 00000000000..c30dfc9c375 --- /dev/null +++ b/sql/updates/world/2015_07_12_60_world_2015_07_12_08.sql @@ -0,0 +1,2 @@ +-- +DELETE FROM `smart_scripts` WHERE `entryorguid`=18759 AND `source_type`=0; |