1. I have corrected the e-mail settings so that outgoing e-mails from these forums should be sent now. If you tried to Register or Reset your Password, please try again!
    Dismiss Notice

Crowdsource Project: Adventure Report and Tradeskill Report

Discussion in 'EQ2U Players Support & Feedback' started by Feldon, Jan 11, 2019.

  1. Cyrrena

    Cyrrena New Member

    I am still offering my assistance to any of the tradeskill, adventure, books, or any of your other cleanups, Feldon and Pijotre, just email me or Discord me and let me know what you need done.

    ~Cyr
     
    • Like Like x 1
  2. Feldon

    Feldon Administrator Staff Member

    Once it is decided exactly which quests go into each expansion, then the next thing that is needed is the quest ID and any special note that might need to appear next to quests that are class/race/etc. specific.
     
  3. Feldon

    Feldon Administrator Staff Member

    Chaos Descending quests aren't in Census but Prophecy of Power's are. For example:

    http://census.daybreakgames.com/xml/get/eq2/quest/?category=Plane of Magic&c:show=name,crc,level,category&c:limit=200

    Code:
    <quest category="Plane of Magic" name="All's Wells" level="106" crc="542830770" id="542830770"/>
    <quest category="Plane of Magic" name="The River Job" level="106" crc="1305825940" id="1305825940"/>
    <quest category="Plane of Magic" name="Steal It All Back" level="106" crc="785993578" id="785993578"/>
    <quest category="Plane of Magic" name="Vetted Rocks" level="106" crc="3458520844" id="3458520844"/>
    <quest category="Plane of Magic" name="Seeds of Change" level="106" crc="690138667" id="690138667"/>
    <quest category="Plane of Magic" name="The Desired Golden Vessel" level="106" crc="774020950" id="774020950"/>
    <quest category="Plane of Magic" name="The Bloody Brutal Truth" level="106" crc="3224174202" id="3224174202"/>
    <quest category="Plane of Magic" name="Operation Crustacean Station" level="106" crc="721221205" id="721221205"/>
    <quest category="Plane of Magic" name="The Crucible of Purpose" level="106" crc="203687059" id="203687059"/>
    <quest category="Plane of Magic" name="Serving the Mindfold Matriarch" level="106" crc="186922478" id="186922478"/>
    <quest category="Plane of Magic" name="Material Evidence" level="106" crc="2452448340" id="2452448340"/>
    <quest category="Plane of Magic" name="Retaking the Test" level="105" crc="1598489548" id="1598489548"/>
    <quest category="Plane of Magic" name="More Specific Resonance" level="106" crc="3247028499" id="3247028499"/>
    <quest category="Plane of Magic" name="Furthering Education" level="106" crc="1320873805" id="1320873805"/>
    <quest category="Plane of Magic" name="The Majestrix's Trust" level="110" crc="3741163137" id="3741163137"/>
    <quest category="Plane of Magic" name="Cultural Understanding" level="106" crc="1207226171" id="1207226171"/>
    <quest category="Plane of Magic" name="Teacher Conference" level="106" crc="2824114112" id="2824114112"/>
    <quest category="Plane of Magic" name="An Eye for Art" level="106" crc="1898055970" id="1898055970"/>
    <quest category="Plane of Magic" name="The Wick is Curiosity" level="106" crc="2527000627" id="2527000627"/>
    <quest category="Plane of Magic" name="Shape the Future" level="106" crc="828235386" id="828235386"/>
    <quest category="Plane of Magic" name="Stripped By Striplings" level="106" crc="1780823793" id="1780823793"/>
    <quest category="Plane of Magic" name="Crystals in the Rough" level="106" crc="3786027434" id="3786027434"/>
    <quest category="Plane of Magic" name="From Mind to Matter" level="106" crc="189382794" id="189382794"/>
    <quest category="Plane of Magic" name="Scar Treatment" level="106" crc="34960675" id="34960675"/>
    <quest category="Plane of Magic" name="The Seven Keystones to Success" level="106" crc="693066575" id="693066575"/>
    <quest category="Plane of Magic" name="Water Canvas" level="106" crc="3895154840" id="3895154840"/>
    <quest category="Plane of Magic" name="A Subtle Ploy" level="106" crc="2029874299" id="2029874299"/>
    <quest category="Plane of Magic" name="Music From the Elder" level="106" crc="1581804505" id="1581804505"/>
    <quest category="Plane of Magic" name="Terra Forma" level="106" crc="1964131765" id="1964131765"/>
    <quest category="Plane of Magic" name="Specific Resonance" level="106" crc="476868376" id="476868376"/>
    <quest category="Plane of Magic" name="Sphinx Outside the Box" level="106" crc="1783153557" id="1783153557"/>
    <quest category="Plane of Magic" name="The Queen's Favor" level="106" crc="865852526" id="865852526"/>
    <quest category="Plane of Magic" name="Caught Slime-Handed" level="106" crc="2917614258" id="2917614258"/>
    <quest category="Plane of Magic" name="Right in the Nose" level="106" crc="3035442948" id="3035442948"/>
    <quest category="Plane of Magic" name="Perennial Complications" level="106" crc="488769127" id="488769127"/>
    <quest category="Plane of Magic" name="Here Comes the Bribe" level="106" crc="2219221689" id="2219221689"/>
    <quest category="Plane of Magic" name="Nothing Subtle About It" level="106" crc="3225488158" id="3225488158"/>
    <quest category="Plane of Magic" name="Professional Opinion" level="106" crc="3950432278" id="3950432278"/>
    <quest category="Plane of Magic" name="Steal It Back" level="106" crc="888017672" id="888017672"/>
    <quest category="Plane of Magic" name="Reflection of Recollection" level="110" crc="3765650912" id="3765650912"/>
    <quest category="Plane of Magic" name="Take Me to Your Leader" level="106" crc="860172999" id="860172999"/>
    <quest category="Plane of Magic" name="Not for Breakfast" level="106" crc="1139352478" id="1139352478"/>
    <quest category="Plane of Magic" name="Removing Some Competition" level="106" crc="3168471557" id="3168471557"/>
    <quest category="Plane of Magic" name="Dazzle and Delight" level="106" crc="734951860" id="734951860"/>
    <quest category="Plane of Magic" name="Artifact Not Fiction" level="106" crc="3930105460" id="3930105460"/>
    <quest category="Plane of Magic" name="Mindfold Matriarch's Effective Plan" level="107" crc="2504040525" id="2504040525"/>
    <quest category="Plane of Magic" name="Lighter Studies" level="106" crc="1320304867" id="1320304867"/>
    <quest category="Plane of Magic" name="Following a Familiar Face" level="106" crc="2068758881" id="2068758881"/>
    <quest category="Plane of Magic" name="Consoling the Souls" level="106" crc="3846676902" id="3846676902"/>
    <quest category="Plane of Magic" name="Oh Ye, Of Riddle Faith" level="106" crc="491778819" id="491778819"/>
    <quest category="Plane of Magic" name="Fount Duty" level="106" crc="278314355" id="278314355"/>
    <quest category="Plane of Magic" name="Unusual Suspect" level="105" crc="3286900626" id="3286900626"/>
    <quest category="Plane of Magic" name="No Pride to Speak Of" level="106" crc="1254300965" id="1254300965"/>
    <quest category="Plane of Magic" name="The Punishment Due" level="106" crc="2453705008" id="2453705008"/>
    <quest category="Plane of Magic" name="Can't Step in the Same River Twice" level="106" crc="569932009" id="569932009"/>
    <quest category="Plane of Magic" name="Teach a Man to Aetherfish" level="106" crc="3074833288" id="3074833288"/>
    <quest category="Plane of Magic" name="The Candle is Learning" level="106" crc="261597577" id="261597577"/>
    <quest category="Plane of Magic" name="Profit and Loss" level="106" crc="3868850648" id="3868850648"/>
    <quest category="Plane of Magic" name="Counterfeit It to Win It" level="106" crc="3844756674" id="3844756674"/>
    <quest category="Plane of Magic" name="Clean Sweep the Grounds" level="106" crc="3090582898" id="3090582898"/>
    <quest category="Plane of Magic" name="Still Not for Breakfast" level="106" crc="4015493290" id="4015493290"/>
    <quest category="Plane of Magic" name="Koyame's Elemental Study" level="110" crc="714146609" id="714146609"/>
    <quest category="Plane of Magic" name="Riddle Me This" level="106" crc="1524846120" id="1524846120"/>
    <quest category="Plane of Magic" name="The Supreme Art of Teaching" level="106" crc="2022742303" id="2022742303"/>
    <quest category="Plane of Magic" name="Land Development" level="106" crc="1920958892" id="1920958892"/>
    <quest category="Plane of Magic" name="Consoling the Souls: A Contemplation" level="106" crc="2766438794" id="2766438794"/>
    <quest category="Plane of Magic" name="Between a Rock and a Hard Beak" level="106" crc="2102777285" id="2102777285"/>
    <quest category="Plane of Magic" name="The Missing Heart Leaves a Hole" level="106" crc="1459570815" id="1459570815"/>
    <quest category="Plane of Magic" name="Dress Code" level="106" crc="3618881271" id="3618881271"/>
    <quest category="Plane of Magic" name="Seven Tomes and No Sense" level="106" crc="2217433053" id="2217433053"/>
    <quest category="Plane of Magic" name="Forbidden Studies" level="106" crc="968744923" id="968744923"/>
    <quest category="Plane of Magic" name="The Missing Heart Leaves Another Hole" level="106" crc="3015899569" id="3015899569"/>
    <quest category="Plane of Magic" name="Doomsday Prep" level="106" crc="1570124711" id="1570124711"/>
    <quest category="Plane of Magic" name="Light Studies" level="106" crc="2308394143" id="2308394143"/>
    <quest category="Plane of Magic" name="Operation Crustacean Station Continuation" level="106" crc="4045718781" id="4045718781"/>
    <quest category="Plane of Magic" name="Show Not Tell" level="106" crc="206172663" id="206172663"/>
    <quest category="Plane of Magic" name="Green Fruit For Rut Part Deux" level="106" crc="1786874002" id="1786874002"/>
    <quest category="Plane of Magic" name="Art Class Drop Out" level="106" crc="993953225" id="993953225"/>
    <quest category="Plane of Magic" name="Can't Step in the Same River Twice, Twice" level="106" crc="677885406" id="677885406"/>
    <quest category="Plane of Magic" name="Further Applications" level="106" crc="3314601104" id="3314601104"/>
    <quest category="Plane of Magic" name="Consciousness With Objectification" level="106" crc="2065904645" id="2065904645"/>
    <quest category="Plane of Magic" name="Fresh and Greasy" level="106" crc="3013104267" id="3013104267"/>
    <quest category="Plane of Magic" name="The Vexing Golden Coin" level="106" crc="3073101548" id="3073101548"/>
    <quest category="Plane of Magic" name="Joy in Knowledge" level="106" crc="3874753724" id="3874753724"/>
    <quest category="Plane of Magic" name="Crossing At The Crossing" level="106" crc="2502776105" id="2502776105"/>
    <quest category="Plane of Magic" name="Learning Their Place" level="106" crc="2721567859" id="2721567859"/>
    <quest category="Plane of Magic" name="Assumed Identity" level="106" crc="776956466" id="776956466"/>
    <quest category="Plane of Magic" name="Arcana Control" level="106" crc="1579523773" id="1579523773"/>
    <quest category="Plane of Magic" name="Ghost's Lost Score" level="106" crc="4186171905" id="4186171905"/>
    <quest category="Plane of Magic" name="Tending Gardens" level="106" crc="2392111737" id="2392111737"/>
    <quest category="Plane of Magic" name="Green Fruit For Rut" level="106" crc="3019220975" id="3019220975"/>
    <quest category="Plane of Magic" name="Eureka Moment" level="106" crc="2624708736" id="2624708736"/>
    <quest category="Plane of Magic" name="The Mootuingo Objective" level="106" crc="1576781507" id="1576781507"/>
    <quest category="Plane of Magic" name="Sure as Shell" level="106" crc="268066029" id="268066029"/>
    <quest category="Plane of Magic" name="The Starfire Collection" level="106" crc="3597672187" id="3597672187"/>
    <quest category="Plane of Magic" name="Dedication Rewarded" level="106" crc="3647066062" id="3647066062"/>
    <quest category="Plane of Magic" name="Fawning Over Flora" level="106" crc="867271168" id="867271168"/>
    <quest category="Plane of Magic" name="The Mootuingo Job" level="106" crc="1459208600" id="1459208600"/>
    <quest category="Plane of Magic" name="Subtle Differences" level="106" crc="2532511063" id="2532511063"/>
    <quest category="Plane of Magic" name="The Introduction" level="106" crc="3102812499" id="3102812499"/>
    http://census.daybreakgames.com/xml/get/eq2/quest/?name=^Legacy of Power*&c:show=name,crc,level&c:limit=10

    Code:
    <quest name="Legacy of Power: Deep Trouble" level="110" crc="1839262911" id="1839262911"/>
    <quest name="Legacy of Power: Hero's Devotion" level="106" crc="2373256609" id="2373256609"/>
    <quest name="Legacy of Power: Drawn to the Fire" level="110" crc="4246729006" id="4246729006"/>
    <quest name="Legacy of Power: An Innovative Approach" level="110" crc="4201788727" id="4201788727"/>
    <quest name="Legacy of Power: Secrets in an Arcane Land" level="105" crc="343692315" id="343692315"/>
    <quest name="Legacy of Power: Glimpse of the Hereother" level="110" crc="2316878264" id="2316878264"/>
    <quest name="Legacy of Power: Tyrant's Throne" level="110" crc="447208489" id="447208489"/>
    <quest name="Legacy of Power: Realm of the Plaguebringer" level="110" crc="1679204500" id="1679204500"/>
    <quest name="Legacy of Power: Through Storms and Mists" level="110" crc="319918082" id="319918082"/>
    I have to sift through all that to get:

    Code:
    "The Queen's Favor","865852526","1"
    "Light Studies","2308394143","2"
    "Lighter Studies","1320304867","3"
    "Specific Resonance","476868376","4"
    ...
    "Legacy of Power: Secrets in an Arcane Land","343692315","27"
    "Legacy of Power: Hero's Devotion","2373256609","28"
    It just takes time to collate it. Also in the above example, I would want either all 3 factions or just leave them out.
     
    Last edited: Jun 24, 2019
  4. Rosyposy

    Rosyposy Active Member

    I think all three factions need to be included for PoP. The intent appeared to be that a toon would complete all three (but only one of my toons did).
     
    • Informative Informative x 1
  5. Alarra

    Alarra Active Member

    So in order to add factions you would need to add a new column possibly next to the "categoryid" something like "factionid"?
    While allowing it to be null or default value of 0
    Just adding values to the quests in Adventure report maybe.

    Or if you are not importing the categoryid value, you could add a new category like "Legacy of Power - House Yrzu"

    Those screenshots look like phpMyAdmin.
     
  6. Feldon

    Feldon Administrator Staff Member

    Yes it's phpMyAdmin. Adventure Report is not currently built to read anything but quests. Is there a specific quest completion that indicates a certain faction threshold?
     
  7. Rosyposy

    Rosyposy Active Member

    • Informative Informative x 1
  8. Alarra

    Alarra Active Member

    I translate for phpMyAdmin from English to Japanese. I translated around 1/3 to 1/2 of it.
     
    • Appreciation Appreciation x 1
    • Shocked Shocked x 1
  9. candy206039

    candy206039 New Member

    There is a quest missing from the Tradeskill Report for The Shadow Odyssey: Zubzub's initial quest is Buckle Down. That brings The Shadow Odyssey total up to 17.

    (I originally posted this 2019/01)
     
  10. Feldon

    Feldon Administrator Staff Member

    Ok I'm relaunching this thread but as a Google Doc. Please send me a PM to get edit rights to this document.

    Caveat #1: I have cut back the list of quests shown to the mandatory quests. If there is a huge faction grind to get to start the sig line, I only include the last mandatory quest. I am worried about people running Adventure Report on 50 characters and it having to crunch 500 quests x 50 characters = kablooie

    Caveat #2: I don't think Adventure Report supports Collections. Go ahead and put them in the lists and I'll see what I can do.

    EQ2U Adventure Report and Tradeskill Report @ Google Docs
     
  11. Alarra

    Alarra Active Member

    Seems I will have to make a google account, I've only ever made throw away accounts for temporary stuff.
     
  12. Feldon

    Feldon Administrator Staff Member

    I've fixed it so the Google Doc can be edited by guests.
     
    • Like Like x 1
  13. Feldon

    Feldon Administrator Staff Member

    Updated Tradeskill Report for Reign of Shadows, Mischief and Mayhem, Blood of Luclin, Visions of Vetrovia, Renewal of Ro.
     

Share This Page