Minor fixes v14 (Dragon Soul)

Stiga

Gold Supporter
Veteran Member
66
2020
123
Location
France
Faction problems in Dragon Soul

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:

OMGhixD

Gold Supporter
Epic Member
522
2014
58
Wonderful work :)

I have some pinpointers regarding the queries, but its not really a matter on queries that are to be ran once or not be handled by an auto-sql implementation system.

Regardless, Thank you! :D
 

Jenniy

I collect profile flairs.
Silver Supporter
Senior User
351
2020
70
Danke Schön! Thanks for the Queries!
 

Stiga

Gold Supporter
Veteran Member
66
2020
123
Location
France
Edit: Found a couple more incorrect hostile & freindly mobs. Updated SQL in the first post.
 
Last edited:
Top