What's new

Quest Chains and Area Fix For Sen'jin Village For V7 and V8

ExO

Admin
5,119
2014
1,639
Will be executed once it's clarified that all these Durotar fixes are working well on Emucoach
 

eyerobot

Gold Supporter
Superior Member
916
2015
24
Location
Barryton Michigan USA
These queries are huge, Which makes them hard to figure out. As far as I can tell that first one is only doing this.
UPDATE `quest_template` SET `PrevQuestId` = 25132, `NextQuestIdChain` = 0 WHERE `Id` = 25133;
I used truice v2.0 which is available here https://www.dropbox.com/s/thfwqcbxd3vtw76/Truice_v2.0.0.zip?dl=0. I have it set to only create update queries. Then i click script tab after making changes, and it gives me this query.

Anyway what worries me is you seem to have set them all to nextquestidchain = 0. Which could probably still work, But I don't think it's necessary to remove them. Unless they are just bugging out of course.
 

Taaboy

Silver Supporter
Veteran Member
37
2016
5
Because the trinity core (4.3.4) doesn't have the option in the quest_template_addon table, and the mangos3 has that option only in the quest_template table.
And when i use WowPacketParser from my sniff collection , emucoach table structure doesn't work and i have to fall back onto the trinity core DB structure and modify the collection from there to fit into the emucoach structure. On top of that it is not a big deal to make the query to fit both structures , with update you just need to leave out the tables that don't match up. then test in emucoach then export.

On a side note my DB also runs Mangos0,Mangos1,Mangos2,Mangos3 servers all at the same time, or TCLegacy 4.3.4 or EMUCoach or Ark_Core_ng or TrinityCore Master. 8 Wow DB Collection on top of my sniff WPP DB with TC_master for data imports.

Truice is good for minor fixs but to bulk change from other sources i found it quicker to run query on the DB.

Example :SELECT * FROM `quest_template` WHERE Id in(25133,25165,25167,25168,25169,25170,25171);
 
Top