[LF] Need DB developers for the Emucoach repack projects
What's new

Minor fixes v14 (Dragon Soul)

Stiga

Stiga

Gold Supporter
Veteran Member
69
2020
125
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

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

Jenniy

I collect profile flairs.
Gold Supporter
Silver Supporter
MoP Premium
Senior User
354
2020
72
Danke Schön! Thanks for the Queries!
 
Stiga

Stiga

Gold Supporter
Veteran Member
69
2020
125
Location
France
Edit: Found a couple more incorrect hostile & freindly mobs. Updated SQL in the first post.
 
Last edited:
You must log in or register to reply here.
Top