Page 1 of 1

Census - Joining quest with questgiver

Posted: Fri Dec 09, 2016 6:43 pm
by Gangrenous
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...

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
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.

Re: Census - Joining quest with questgiver

Posted: Fri Dec 09, 2016 7:21 pm
by Jabantiz
Sorry never tried because the last time I looked into quest giver info on the census it was just an id and useless for us, if it has been updated with more info I can take a look but I am not to good with their search strings.

Re: Census - Joining quest with questgiver

Posted: Fri Dec 09, 2016 9:11 pm
by Gangrenous
They really suck, so I gave up doing it that way. Well just started extending your quest parser and will just do a lookup of the quest giver in that. Trying to pull more information for the quest, experience, coinage, quest giver. It would really help to save time doing this many quest.