Census - Joining quest with questgiver
Posted: Fri Dec 09, 2016 6:43 pm
Jabantiz have you ever tried to join the quest table with the questgiver table using the Census? I am not even sure it can be done, I have tried for hours to make this work and it is eluding me. Either I just need to step away from it, or maybe it cannot be done? I have tried a ton of variations, like this...
I am guessing you cannot do it, because the quest_id is a result of questgiver and you cannot query like that. Hell I really like MySQL more and more as I deal with XML.
Code: Select all
http://census.daybreakgames.com/xml/get/eq2/quest?id=1388064732&c:join=questgiver^on:quest.id^to:quest.id^inject_at:questgiver