Faction problems in Dragon Soul
Twilight Assaulters - some are friendly > moved to hostile otherwise hard to complete the event
Eye of Go'rath - friendly
Wrymrest Captain & Defenders are hostile > moved to friendly
Elementium-gem-cluster:-
Loot https://www.wowhead.com/item=77952/elementium-gem-cluster missing from bosses & chests in Dragon Soul
Dragon Soul bosses on v14 are not dropping elementium-gem-cluster items. Again only tested normal not heroic.
Note: not tested on v14 but this fixed the V13.1 version for the above
Twilight Assaulters - some are friendly > moved to hostile otherwise hard to complete the event
Eye of Go'rath - friendly
SQL:
-- twilight assaulter 56352 56353 56386
UPDATE creature_template SET faction_h = 14 WHERE entry=56352; -- value was 35
UPDATE creature_template SET faction_a = 14 WHERE entry=56352; -- value was 35
UPDATE creature_template SET faction_h = 14 WHERE entry=56353; -- value was 35
UPDATE creature_template SET faction_a = 14 WHERE entry=56353; -- value was 35
UPDATE creature_template SET faction_h = 14 WHERE entry=56386; -- value was 35
UPDATE creature_template SET faction_a = 14 WHERE entry=56386; -- value was 35
-- eye of go'rath
UPDATE creature_template SET faction_h = 14 WHERE entry=57876; -- value was 35
UPDATE creature_template SET faction_a = 14 WHERE entry=57876; -- value was 35
Wrymrest Captain & Defenders are hostile > moved to friendly
SQL:
wyrmcrest captain / defender 57468 57380 / 57334 57348 57469 57471
UPDATE creature_template SET faction_h = 35 WHERE entry=57468; -- value was 2041
UPDATE creature_template SET faction_a = 35 WHERE entry=57468; -- value was 2041
UPDATE creature_template SET faction_h = 35 WHERE entry=57380; -- value was 2041
UPDATE creature_template SET faction_a = 35 WHERE entry=57380; -- value was 2041
UPDATE creature_template SET faction_h = 35 WHERE entry=57334; -- value was 2041
UPDATE creature_template SET faction_a = 35 WHERE entry=57334; -- value was 2041
UPDATE creature_template SET faction_h = 35 WHERE entry=57348; -- value was 2041
UPDATE creature_template SET faction_a = 35 WHERE entry=57348; -- value was 2041
UPDATE creature_template SET faction_h = 35 WHERE entry=57469; -- value was 2041
UPDATE creature_template SET faction_a = 35 WHERE entry=57469; -- value was 2041
UPDATE creature_template SET faction_h = 35 WHERE entry=57471; -- value was 2041
UPDATE creature_template SET faction_a = 35 WHERE entry=57471; -- value was 2041
UPDATE creature_template SET faction_h = 35 WHERE entry=57481; -- value was 2041 Lord Afrasastrasz
UPDATE creature_template SET faction_a = 35 WHERE entry=57481; -- value was 2041 Lord Afrasastrasz
Elementium-gem-cluster:-
Loot https://www.wowhead.com/item=77952/elementium-gem-cluster missing from bosses & chests in Dragon Soul
Dragon Soul bosses on v14 are not dropping elementium-gem-cluster items. Again only tested normal not heroic.
Note: not tested on v14 but this fixed the V13.1 version for the above
SQL:
-- https://www.wowhead.com/item=77952/elementium-gem-cluster
-- https://www.wowhead.com/npc=55265/morchok 57771 57772 57409
DELETE FROM `creature_loot_template` WHERE `entry`=55265 AND `item`=77952;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (55265, 77952, 100, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=57771 AND `item`=77952;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (57771, 77952, 100, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=57772 AND `item`=77952;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (57772, 77952, 100, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=57409 AND `item`=77952;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (57409, 77952, 100, 1, 0, 1, 1);
-- https://www.wowhead.com/npc=55308/warlord-zonozz 55309 55310 55311
DELETE FROM `creature_loot_template` WHERE `entry`=55308 AND `item`=77952;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (55308, 77952, 100, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=55309 AND `item`=77952;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (55309, 77952, 100, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=55310 AND `item`=77952;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (55310, 77952, 100, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=55311 AND `item`=77952;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (55311, 77952, 100, 1, 0, 1, 1);
-- https://www.wowhead.com/npc=55689/hagara-the-stormbinder 55689 57955 57956
DELETE FROM `creature_loot_template` WHERE `entry`=55689 AND `item`=77952;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (55689, 77952, 100, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=57462 AND `item`=77952;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (57462, 77952, 100, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=57955 AND `item`=77952;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (57955, 77952, 100, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=57956 AND `item`=77952;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (57956, 77952, 100, 1, 0, 1, 1);
-- https://www.wowhead.com/npc=56427/warmaster-blackhorn 57699 57847 57848
DELETE FROM `creature_loot_template` WHERE `entry`=56427 AND `item`=77952;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (56427, 77952, 100, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=57699 AND `item`=77952;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (57699, 77952, 100, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=57847 AND `item`=77952;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (57847, 77952, 100, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=57848 AND `item`=77952;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (57848, 77952, 100, 1, 0, 1, 1);
-- https://www.wowhead.com/npc=55312/yorsahj-the-unsleeping 55313 55314 55315
DELETE FROM `creature_loot_template` WHERE `entry`=55312 AND `item`=77952;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (55312, 77952, 100, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=55313 AND `item`=77952;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (55313, 77952, 100, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=55314 AND `item`=77952;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (55314, 77952, 100, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=55315 AND `item`=77952;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (55315, 77952, 100, 1, 0, 1, 1);
-- dragonsoul chests 56576 56577 56578 (chest=210221 210222 210163 209897 209541 209895 209896 210161 210162 210160 209894)
DELETE FROM `gameobject_loot_template` WHERE `entry`=210221 AND `item`=77952;
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (210221, 77952, 100, 1, 0, 1, 1);
DELETE FROM `gameobject_loot_template` WHERE `entry`=210222 AND `item`=77952;
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (210222, 77952, 100, 1, 0, 1, 1);
DELETE FROM `gameobject_loot_template` WHERE `entry`=210163 AND `item`=77952;
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (210163, 77952, 100, 1, 0, 1, 1);
DELETE FROM `gameobject_loot_template` WHERE `entry`=209897 AND `item`=77952;
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (209897, 77952, 100, 1, 0, 1, 1);
DELETE FROM `gameobject_loot_template` WHERE `entry`=209541 AND `item`=77952;
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (209541, 77952, 100, 1, 0, 1, 1);
DELETE FROM `gameobject_loot_template` WHERE `entry`=209895 AND `item`=77952;
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (209895, 77952, 100, 1, 0, 1, 1);
DELETE FROM `gameobject_loot_template` WHERE `entry`=209896 AND `item`=77952;
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (209896, 77952, 100, 1, 0, 1, 1);
DELETE FROM `gameobject_loot_template` WHERE `entry`=210161 AND `item`=77952;
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (210161, 77952, 100, 1, 0, 1, 1);
DELETE FROM `gameobject_loot_template` WHERE `entry`=210162 AND `item`=77952;
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (210162, 77952, 100, 1, 0, 1, 1);
DELETE FROM `gameobject_loot_template` WHERE `entry`=210160 AND `item`=77952;
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (210160, 77952, 100, 1, 0, 1, 1);
DELETE FROM `gameobject_loot_template` WHERE `entry`=209894 AND `item`=77952;
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (209894, 77952, 100, 1, 0, 1, 1);
Last edited: