Bug quest Pyrewood's fall 7.0

[eyerobot]

Bug quest Pyrewood's fall 7.0 Position fix included

[Name, Type] Pyrewood's fall, quest, pyrewood village, silverpine
[What it does] The torch does not give quest credit when used on the buildings.
[What it should do] The torch should give quest credit for burning the three buildings in pyrewood.
http://wowwiki.wikia.com/wiki/Quest:Pyrewood's_Fall

Here is a fix for the position of trigger npc's for this quest

DELETE FROM `emucoach-world`.`creature` WHERE  `guid`=609767;
REPLACE INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (31424, 45937, 0, 130, 5476, 1, 65535, 0, 0, -337.348, 1560.33, 26.1294, 3.05499, 90, 0, 0, 84, 0, 0, 0, 0, 0, 0);
REPLACE INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (31425, 45938, 0, 130, 5476, 1, 65535, 0, 0, -389.978, 1504.39, 20.7252, 4.72003, 300, 0, 0, 84, 0, 0, 0, 0, 0, 0);
REPLACE INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (31426, 45939, 0, 130, 5478, 1, 65535, 0, 0, -381.403, 1614.92, 20.6422, 1.47633, 300, 0, 0, 84, 0, 0, 0, 0, 0, 0);

 

[ExO]

It's mainly just about adding invisible triggers, and a condition to the spell(s) to target the npcs, so upon spell hit -> killcredit complete. (Now you have a description in case you wanted to hear more about the fixing also)
Will look at it today.

 

[eyerobot]

It sounds simple enough, Until you realize you can't find the spell 85600 anywhere in the database. So i have no idea how to check what it's target is.

So i'm guessing it's all hardcoded into the server, Since i can't find it in the database.

The target npc's are in place, The spell visual activates. But when the spell procs it gives an invalid target warning.

 

[ExO]

The quest is now working as intended, fixed.

It sounds simple enough, Until you realize you can't find the spell 85600 anywhere in the database. So i have no idea how to check what it's target is.

So i'm guessing it's all hardcoded into the server, Since i can't find it in the database.

The target npc's are in place, The spell visual activates. But when the spell procs it gives an invalid target warning.

Actually you can mess with such a thing in conditions table. I'll gladly show you my fix if you wanna learn;
(Just pm me)

 

[eyerobot]

Thank you, i sent you a pm about that.
Excuse the semi rant, I hate the current table names, They don't make much sense anymore.
I'm trying to decide on an sql tool to use in linux. In windows it was heidsql, So hopefully i can find something useful.

Edit.. If anyone else is looking for a linux replacement for heidisql, This one is almost identical, And has a lot more functions. Also it's free.
http://dbeaver.jkiss.org/download/

 

[eyerobot]

Thanks for the information about the conditions table. I took the time to locate all the trigger npc's for this quest, And moved them into their proper places, They were in wrong buildings, and gave quest credit out of order.

The code fix is on my first post.