Aggra Quest Giver FIX

[pedroevil51]

Aggra was not giving the quest
http://www.wowhead.com/quest=29335
http://www.wowhead.com/quest=29327

INSERT INTO creature_involvedrelation
(id, quest)
VALUES (54312, 29335)

INSERT INTO creature_involvedrelation
(id, quest)
VALUES (54312, 29327)

Should work fine now.

 

[eyerobot]

That's an important fix. Thank you.
Here i used an export from Heidisql because it includes a delete query. I did this by right clicking the entries selected and chose export, And also selected export Delete Insert on heidi befor hitting ok.

Above this editor i selected the # button, Which allows me to format my code seperately from my statements.

DELETE FROM `creature_involvedrelation` WHERE `id`=54312 AND `quest`=29327;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (54312, 29327);
DELETE FROM `creature_involvedrelation` WHERE `id`=54312 AND `quest`=29335;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (54312, 29335);

And it looks like this.
If you don't have delete insert as one of your options, It is because you are using an outdated version of Heidisql, Or some other editor. But I suggest Heidisql.

 

[ExO]

Applied, thanks!