Horde Cloth Quartermasters

TrinityCore Development TrinityCore Code Discussion
1

Trinity Revision: 9cc7f25b9ab0 Database Version: TDB 335.11.40

Tested and works

source wowhead archive

This is my fix for the 2 Cloth quartermasters in OG giving opposite rep for these quests.

[CODE]-- corrected quests in Creature_involvedrelation
– Horde npcs 14726 Rashona Straglash
UPDATE creature_involvedrelation SET quest=7824 WHERE id=14726 AND quest=7836;
UPDATE creature_questrelation SET quest=7824 WHERE id=14726 AND quest=7836;
UPDATE creature_involvedrelation SET quest=7832 WHERE id=14726 AND quest=7837;
UPDATE creature_questrelation SET quest= 7832 WHERE id=14726 AND quest=7837;

– NPC 14727 Vehena
UPDATE creature_involvedrelation SET quest=7836 WHERE id=14727 AND quest=7832;
UPDATE creature_questrelation SET quest=7836 WHERE id=14727 AND quest=7832;
UPDATE creature_involvedrelation SET quest=7837 WHERE id=14727 AND quest=7824;
UPDATE creature_questrelation SET quest=7837 WHERE id=14727 AND quest=7824;[/sql][/CODE]

2

This is posted in the tracker also, there were more found. Sources are old db, and wowhead archive.

Trinity Revision: fd5ab977742f+ Database Version: TDB 335.11.42

Addon- AH Bot

OS -Win7

Tested: yes

[CODE]-- corrected quests in creature_involvedrelation and creature_questrelation
– Horde npcs 14726 Rashona Straglash
UPDATE creature_involvedrelation SET quest = 7824 WHERE id =14726 AND quest =7836;
UPDATE creature_questrelation SET quest = 7824 WHERE id =14726 AND quest =7836;
UPDATE creature_involvedrelation SET quest = 7832 WHERE id =14726 AND quest =7837;
UPDATE creature_questrelation SET quest = 7832 WHERE id =14726 AND quest =7837;
– NPC 14727 Vehena
UPDATE creature_involvedrelation SET quest = 7836 WHERE id =14727 AND quest =7832;
UPDATE creature_questrelation SET quest = 7836 WHERE id =14727 AND quest =7832;
UPDATE creature_involvedrelation SET quest = 7837 WHERE id =14727 AND quest =7824;
UPDATE creature_questrelation SET quest = 7837 WHERE id =14727 AND quest =7824;
– Alliance npcs 14725 Raedon Dustriker
UPDATE creature_involvedrelation SET quest = 10352 WHERE id =14725 AND quest =7792;
UPDATE creature_questrelation SET quest = 10352 WHERE id =14725 AND quest =7792;
UPDATE creature_involvedrelation SET quest = 10354 WHERE id =14725 AND quest =7798;
UPDATE creature_questrelation SET quest = 10354 WHERE id =14725 AND quest =7798;
– NPC 20604 Dugiru
UPDATE creature_involvedrelation SET quest = 7792 WHERE id =20604 AND quest =10352;
UPDATE creature_questrelation SET quest = 7792 WHERE id =20604 AND quest =10352;
UPDATE creature_involvedrelation SET quest = 7798 WHERE id =20604 AND quest =10354;
UPDATE creature_questrelation SET quest = 7798 WHERE id =20604 AND quest =10354;
– NPC 14723 Mistina Steelshield
UPDATE creature_involvedrelation SET quest = 7802 WHERE id =14723 AND quest =7807;
UPDATE creature_questrelation SET quest = 7802 WHERE id =14723 AND quest =7807;
UPDATE creature_involvedrelation SET quest = 7803 WHERE id =14723 AND quest =7808;
UPDATE creature_questrelation SET quest = 7803 WHERE id =14723 AND quest =7808;
– NPC 14724 Bublo Acerbus
UPDATE creature_involvedrelation SET quest = 7807 WHERE id =14724 AND quest =7802;
UPDATE creature_questrelation SET quest = 7807 WHERE id =14724 AND quest =7802;
UPDATE creature_involvedrelation SET quest = 7808 WHERE id =14724 AND quest =7803;
UPDATE creature_questrelation SET quest = 7808 WHERE id =14724 AND quest =7803;

[/sql][/CODE]