As some of you may know, I've been fiddling with a new module for the website. I'm just about finished with it but need some info. I've currently got The Shadow Odyssey Questline and the TSO T3 Shard Armor listed. I've got place holders for TSO Fighter, Healer, Mage, and Scout Gear but need to know what to put under them. Basically, let me know what long questlines that require multiple zones people want to track and what gear you'd like tracked.

For the gear, please list the item name, the zone it drops out of, and whether its for fighter, healer, mage, or scout. For the questlines, just give me the names and I can look them up on eq2.wikia.com. If there is something else that you'd like to see tracked as well, let me know and I'll see how it fits.

This should come in handy once SF comes out but will hopefully be useful before then as well.

Thanks

I still have a thing or two that I'd like to eventually add to this but for now, I think I'm done. It's now available to members in the main menu and is called Zone / Need Tracker.

When you first go into it, click on [Tracked Items] to choose which items you want to track for each of your characters. If your characters aren't listed, click AoV Roster to claim them. Once you've set up the items you want to track, you can click on each of your characters to track the progress.

If you have an item set as Ready/Want that hasn't also been set as Complete/Have, and that item has a Zone, it will show u pin the [Zone / Item Needs] report. The rest is just for you to keep track of stuff for your character.

Let me know what you think. Like I said, there's still a few things I'd like to add but I think I'm going to let us use what I've got for a while before I start adding enhancements.

Check

\aITEM 1708160282 -996361547:Earring of the Void Transfer\/a
Dropped by
Magus Vein'ca (Anchor of Bazzul)
mage

\aITEM -774841730 -2045188570:Charm of the Lost\/a
Dropped by
The Undead Jester (Befallen: Cavern of the Afflicted)
tank

\aITEM 781467272 -685572651:Undead Jester's Cap\/a
Dropped by
The Undead Jester (Befallen: Cavern of the Afflicted)
(apperance maybe?)any

\aITEM 1542762233 1090625407:Gynok's Ring of the Misleading\/a
Dropped by
The Eidolon of Depravity (Befallen: Halls of the Forsaken)
healer

\aITEM 1235180394 -1395208786:Dangling Skull Bone Chip\/a
Dropped by
Dread Exarch Mordek (Befallen: Necrotic Asylum)
scout/fighter

\aITEM -975961101 -1258335292:Living Wall\/a
Dropped by
Coagulation of Flesh and Evil (Befallen: Necrotic Asylum)
fighter

\aITEM 1116516438 -399186902:Gi of the Jarsath Swifttail\/a
Dropped by
Derzitha of the Jarsath (Charasis: Maiden's Chamber)
fighter/scout/priest(or appreance)

\aITEM 2043634222 -237532485:Gift to the Queen\/a
Dropped by
Drusella Sathir (Charasis: Maiden's Chamber)
healer

\aITEM 717281040 -596555433:Ganak's Torque\/a
Dropped by
Praetor of the Phylactery (Charasis: Vault of Eternal Sleep)
fighter/scout

\aITEM 789604956 622541615:The Praetor's Guard\/a
Dropped by
Praetor of the Phylactery (Charasis: Vault of Eternal Sleep)
mage

\aITEM 1459643299 -1322474953:Coil of Vile Spawn\/a
Dropped by
Bbal'Gaz the Enthraller (Chelsith)
mage/crusader

\aITEM 79467794 425894018:Dreadpriest's Ravaging Symbol of Speed\/a
Dropped by
Ka'El Ka'Vrish (Emperor Atrebe's Laboratory: The Fabled City of Kor-sha)
mage/crusader

\aITEM -1374376232 -191074080:Hand of the Enduring Assassin\/a
Dropped by
Ka'El Ka'Vrish (Emperor Atrebe's Laboratory: The Fabled City of Kor-sha)
scout

\aITEM -1253784095 -1786663218:Alegna's Dictionary of Shadows\/a
Dropped by
Nightfall (Emperor's Athenaeum)
scout

\aITEM -1908259085 1375316755:Mhere's Dictionary of Combat\/a
Dropped by
Nightfall (Emperor's Athenaeum)
fighter

\aITEM -1389210615 121173358:Philibauq's Dictionary of Restoration\/a
Dropped by
Nightfall (Emperor's Athenaeum)
healer

\aITEM -564705563 -1256613370:Yxyran's Dictionary of Arcana\/a
Dropped by
Nightfall (Emperor's Athenaeum)
mage

\aITEM -638750072 652336320:Vampire Hunter's Lockbox\/a
Dropped by
Lord Marcus Thex (Evernight Abbey)
(fighter or possibly mage)

\aITEM 624768608 -529115457:Band of the Ancient Kunark Commander\/a
Dropped by
Telvorsinn (Kurn's Tower: Breaching the Void)
fighter

\aITEM 86411383 1854326303:Crystallized Essence of the Void Caster\/a
Dropped by
Yynzik the Scornridden (Kurn's Tower: Breaching the Void)
mage

\aITEM 1962501109 525938077:Crystallized Essence of the Void Mender\/a
Dropped by
Yynzik the Scornridden (Kurn's Tower: Breaching the Void)
healer

\aITEM -1002778641 -2026338613:Crystallized Essence of the Void Stalker\/a
Dropped by
Yynzik the Scornridden (Kurn's Tower: Breaching the Void)
scout

\aITEM -727395697 -1750688853:Crystallized Essence of the Void Striker\/a
Dropped by
Yynzik the Scornridden (Kurn's Tower: Breaching the Void)
fighter

\aITEM -1286527158 -691761947:Saita's Glowing Jewel\/a
Dropped by
an Ancient Void-Touched Wumpus (Kurn's Tower: Breaching the Void)
healer

\aITEM 1230100659 843187305:Choker of Tears and Dreams\/a
Dropped by
Atrocious Amalgam (Miragul's Phylactery: The Anathema)
mage

\aITEM -1283041522 361820302:Darkest Fleck of Umbrage\/a
Dropped by
Patriae Vykel (Miragul's Phylactery: The Anathema)
mage

\aITEM 2055670483 413550738:Links of Overwhelming Resentment\/a
Dropped by
Patriae Vykel (Miragul's Phylactery: The Anathema)
fighter

\aITEM -625825778 -1092649436:Tears of Virulence\/a
Dropped by
Patriae Vykel (Miragul's Phylactery: The Anathema)
mage

\aITEM -1833295871 1500083572:Deepwater Barrier\/a
Dropped by
The Codexicon (Miragul's Phylactery: The Crucible)
crusader

\aITEM -774663725 887937912:Demonstration of Frigid Will\/a
Dropped by
The Codexicon (Miragul's Phylactery: The Crucible)
mage/priest

\aITEM -345344078 -2066953337:Essence of Mastery\/a
Dropped by
The Master (Miragul's Phylactery: The Crucible)
scout

\aITEM 1724907443 64418133:Ring of the Deepest Waters\/a
Dropped by
The Master (Miragul's Phylactery: The Crucible)
fighter

\aITEM 973129434 -1414153585:Shard of the Codexicon\/a
Dropped by
The Codexicon (Miragul's Phylactery: The Crucible)
fighter/scout

\aITEM -1157721601 -1495941620:Wand of Elemental Knowledge\/a
Dropped by
The Codexicon (Miragul's Phylactery: The Crucible)
mage

\aITEM -643360218 -1609760535:Drakota Fang Necklace\/a
Dropped by
Magmadin (Najena's Hollow Tower)
mage

\aITEM 1742204660 -2090443436:Najena's Ring of Readiness\/a
Dropped by
The Reformed Magolemus (Najena's Hollow Tower)
owen

\aITEM 1978585608 1204260724:Symbol of Najenaar Dominance\/a
Dropped by
The Reformed Magolemus (Najena's Hollow Tower)
healer

\aITEM -567908006 2028881690:Sacrificial Drape of the Offering\/a
Dropped by
Tuz'Rak (Nu'roga)
fighter

\aITEM 196938529 535272706:Indestructible Obliterator's Shackle\/a
Dropped by
Ferzhul (Palace of Ferzhul)
Maldormous Exeter (Palace of Ferzhul)
Mewaye (Palace of Ferzhul)
Valdoartus Varsoon (Palace of Ferzhul)
mage

\aITEM 535994949 17763131:Obsession Wristlet\/a
Dropped by
Valdoartus Varsoon (Palace of Ferzhul)
coercer/illusionist

\aITEM 1365583713 1415590199:Plated Vambraces of the Undying\/a
Dropped by
Valdoartus Varsoon (Palace of Ferzhul)
fighter

\aITEM 2011754003 -527159997:Reinforced Void Brute Shackle\/a
Dropped by
Ferzhul (Palace of Ferzhul)
Maldormous Exeter (Palace of Ferzhul)
Mewaye (Palace of Ferzhul)
Valdoartus Varsoon (Palace of Ferzhul)
scout/fighter

\aITEM 764980083 732352653:Robe of the Undying\/a
Dropped by
Valdoartus Varsoon (Palace of Ferzhul)
mage

\aITEM 1546679517 -2017487613:Tracking Eyeball Fingerhoop\/a
Dropped by
Valdoartus Varsoon (Palace of Ferzhul)
fighter/scout

\aITEM -518588732 943715434:Varsoon's Neckguard of Timelessness\/a
Dropped by
Valdoartus Varsoon (Palace of Ferzhul)
fighter

\aITEM -6330411 -349800201:Void-Soaked Peacock Feathers\/a
Dropped by
Valdoartus Varsoon (Palace of Ferzhul)
healer

\aITEM 99704869 100485346:Drape of the Void-Touched\/a
Dropped by
Maldormous Exeter (Palace of Ferzhul)
mage

\aITEM -373528028 -489742003:Forgotten Ring of Souls\/a
Dropped by
Ferzhul (Palace of Ferzhul)
mage

\aITEM 391162446 -1571545472:Imbued Void Capsule\/a
Dropped by
Maldormous Exeter (Palace of Ferzhul)
healer

\aITEM 2103832766 683107992:Seemingly Empty Glass Orb\/a
Dropped by
a deepvoid shadowray (Palace of Ferzhul)
a voidshadow brute (Palace of Ferzhul)
a voidshadow defeater (Palace of Ferzhul)
a voidshadow obliterator (Palace of Ferzhul)
healer

\aITEM 183113597 -974695334:Twisted Ring of Void Essence\/a
Dropped by
Ferzhul (Palace of Ferzhul)
healer

\aITEM 1337083663 -177910572:Powermonger's Lockbox\/a
Dropped by
T'Lon the Powermonger (Ravenscale Repository)
(who knows lol)

\aITEM -1019430867 645114812:Cloak of the Broken Toe Champion\/a
Dropped by
Slamhammer (Runnyeye: The Gathering)
scout

\aITEM -1275686040 1749090571:Cloak of the Grungetalon Champion\/a
Dropped by
Chieftain Kanar (Runnyeye: The Gathering)
fighter

\aITEM 1107174978 -360591285:Cloak of the Runnyeye Champion\/a
Dropped by
Slamhammer (Runnyeye: The Gathering)
priest/pally

\aITEM 1846366382 -1542514489:Cloak of the Sandscrawler Champion\/a
Dropped by
Chieftain Kanar (Runnyeye: The Gathering)
mages/bards/sk

\aITEM -1296654864 -198550402:Bloodthirsty Choker\/a
Dropped by
Terror (Shard of Fear)
any

\aITEM 1805504605 -293429883:Valorous Wings\/a
Dropped by
a doppleganger (The Estate of Unrest)(<---what lootdb.com said, but i dunno)
Mithaniel Marr (Shard of Love: A Moment of Valor)
apperance only

\aITEM -1136430526 1996356593:Carotidcutter\/a
Dropped by
Fallen Emperor Vekin (The Crypt of Agony)
(see, says right there "NOT A MYTH")
(all but decimatr!!)

\aITEM 208242699 1861817281:Burning Lavastud\/a
Dropped by
Firelord Kaern (The Deep Forge)
fighter

\aITEM 1689985518 1785154258:Fungus Spore\/a
Dropped by
Lord Kurpep (The Ruins of Guk: Halls of the Fallen)
fighter

\aITEM 856665968 -111770219:Silver-Plated Bracer\/a
Dropped by
Lord Kurpep (The Ruins of Guk: Halls of the Fallen)
scout/fighter

\aITEM 467955848 1153089159:Woven Gloves\/a
Dropped by
Lord Kurpep (The Ruins of Guk: Halls of the Fallen)
brawlers

\aITEM -1960398312 -222878861:Frenzied Moonstone Ring\/a
Dropped by
Furdip (The Ruins of Guk: The Lower Corridors)
fighter/scout

\aITEM 1439178441 1789703001:Thick Banded Belt\/a
Dropped by
Furdip (The Ruins of Guk: The Lower Corridors)
fighter

\aITEM -1426606283 2049700786:Ferhustr's Furious Rolling-Pin\/a
Dropped by
Lunchmeat (The Ruins of Guk: Ykesha's Outer Stronghold)
healers

\aITEM -137096903 1694766449:Gruuper's Bangle of Incineration\/a
Dropped by
Gruuper Groo (The Ruins of Guk: Ykesha's Outer Stronghold)
mage

\aITEM -1060172301 -1084589322:Bloodgill Belt\/a
Dropped by
Dmeng Bah'Dash (Veksar: The Invasion)
fighter

\aITEM 980552477 -825309080:Earring of Darkfaith\/a
Dropped by
Dmeng Bah'Dash (Veksar: The Invasion)
bards/crusaders

\aITEM 812964204 -1883343964:Ritual Talisman of Fate\/a
Dropped by
Dmeng Bah'Dash (Veksar: The Invasion)
healers

\aITEM 799717432 681221079:Tempered Gold Mask\/a
Dropped by
Dmeng Bah'Dash (Veksar: The Invasion)
mage

\aITEM 1544895902 1071313584:Aidyl's Scaled Sash of Dragon Songs\/a
Dropped by
Garudon (Veksar: The Sunken Theater)
mage/crusaders

Awesome Raymond. I spent some time today getting that list ready to load into the database. I hope to get those items in there shortly after I get home from work. It is, however, a long list so it could take me a bit.

here is a list of all the upgraded jewelry from WoE

Quote::

http://www.lootdb.com/eq2/item/1486777679 \aITEM 1486777679 351878033:Blackflame Ring\/a mage www.lootdb.com/eq2/item/1152028142 \aITEM 1152028142 801348910:Blazing Effigy of Najena's Lava Elemental\/a mage www.lootdb.com/eq2/item/-810243348 \aITEM -810243348 -687881973:Blazing Swiftash Shadow Sash\/a mage www.lootdb.com/eq2/item/1446706202 \aITEM 1446706202 1184917740:Champion's Cape of Unyielding Will\/a fighter www.lootdb.com/eq2/item/-1820719991 \aITEM -1820719991 -1094343628:Circlet of Najena's Assassin\/a fighter/scout www.lootdb.com/eq2/item/764289994 \aITEM 764289994 -1338946494:Cloak of Eternal Night\/a fighter/scout www.lootdb.com/eq2/item/-1973974705 \aITEM -1973974705 1276311793:Cursed Stud of the Abyss\/a fighter www.lootdb.com/eq2/item/413375970 \aITEM 413375970 659594233:Elemental Battlepriest's Drape\/a healer www.lootdb.com/eq2/item/-793083007 \aITEM -793083007 -1928657510:Elemental Chains of Control\/a mage www.lootdb.com/eq2/item/-1054254292 \aITEM -1054254292 -206866891:Empowered Elemental Ring\/a fighter www.lootdb.com/eq2/item/-687168007 \aITEM -687168007 -760031767:Enslaved Wall of Dominated Souls\/a fighter www.lootdb.com/eq2/item/972840614 \aITEM 972840614 1231351515:Flaming Spiked Choker\/a fighter/scout www.lootdb.com/eq2/item/-1071655141 \aITEM -1071655141 550625692:Igneous Rock Choker\/a fighter www.lootdb.com/eq2/item/574110859 \aITEM 574110859 1407268343:Imbued Earring of Flowing Magma\/a mage www.lootdb.com/eq2/item/-1927957797 \aITEM -1927957797 1979148446:Lilioze's Tranquil Earring\/a healer www.lootdb.com/eq2/item/1133549797 \aITEM 1133549797 1709127283:Luminous Loop of Three Elements\/a healer www.lootdb.com/eq2/item/-1708186806 \aITEM -1708186806 949494780:Magmaweave Metallic Belt\/a healer www.lootdb.com/eq2/item/104131979 \aITEM 104131979 -777438468:Marauding Plug of the Flame Warrior\/a fighter/scout www.lootdb.com/eq2/item/-1529539410 \aITEM -1529539410 298848546:Mystical Drape of Najena\/a mage www.lootdb.com/eq2/item/1549908023 \aITEM 1549908023 1738305268:Shimmering Swiftlace Shadow Waist\/a scout?? www.lootdb.com/eq2/item/1275708829 \aITEM 1275708829 -414437792:Smoldering Sapphire Necklace\/a healer www.lootdb.com/eq2/item/-1166999325 \aITEM -1166999325 -133095446:Streaming Volcanic Girdle\/a fighter www.lootdb.com/eq2/item/1105454209 \aITEM 1105454209 2007195860:Tainted Orb of Magma\/a mage www.lootdb.com/eq2/item/-1556361028 \aITEM -1556361028 -336753458:Wall of Raging Winds\/a healer

Thanks for the list Raymond. Unfortunately, the lootdb pages don't have any info about the items. I think we're gonna need to use EQ2I for these instead.

fortunately there is a section right under the item window on lootdb called 'other resourses' with a link directly to EQ2I that works

Jaral wrote:

fortunately there is a section right under the item window on lootdb called 'other resourses' with a link directly to EQ2I that works

This is true. But rather than take the easy route and make EVERYBODY click two links to get there, I'll just do the work myself and put the correct link on the page. I have to look some of them up anyway so I can see what slot they go in. I can guess on most but I'd rather be sure than guess.

Got the shard jewelry in.

Question: Did some of you have the final step of The Shadow Odyssey checked as Ready and then unclick that checkbox or do I have a bug somewhere that's unchecking it? I saw several more characters listed as needing that zone the other day but they aren't listed that way anymore and that checkbox isn't set as Ready anymore. Do I have a bug somewhere?

Thanks

P.S. If you set The Shadow Odyssey as not tracked and then set it back to tracked, that would reset all the Ready flags. If that's what happened then it's working as intended.

P.P.S. I think I just thought up a way around this. Hopefully I'll be able to implement it later today. This was the problem: If you said you were ready for the last step, it would show up in the zone/needs report. If you finished the last step and set the questline as not tracked, but didn't uncheck the box that said you were ready for the step, it would still show up in the zone/needs report. My thinking on this was that if you're not tracking it anymore, you're probably not keeping up with your progress either so I may as well go ahead and reset the ready flag. As Ken suggested, another way would be to just exclude them from the report. At the time, I couldn't come up with a good way to exclude them from the report due to the way the report is written. I think i just came up with a workaround though that I hope to implement soon.

Technobable: MySql stores boolean values as tinyint(1). 0 = False, > 0 = True. All my code currently uses 1 to represent True so all my queries say WHERE field=1 to test for true. When you stop tracking something, I can set all the values to 2 where the value = 1. All my queries will effectively treat this as False since they only know True as 1. If you decide to track the item again, I can set all the values to 1 where value = 2 and restore the previously stored state. Shouldn't be too tough to implement either.

Ok, that seems to have worked. Now if you say you no longer want to track something, it will still keep track of your progress. If you later decide to track it again, the checkboxes should reappear like they were before you stopped tracking the item. While not tracked, it shouldn't show up in the reports. This should work much better.

Just added a T3 Shard Gear Progress Report.

If you want a particular piece, mark it as Ready/Want and it will show up. If you already have an item, mark it as Complete/Have. If you have or want at least one item, your character will show up in the report. If you don't want one of the items, don't mark them as either and the place where the checkbox would be will be blank.

As long as you set the status of your T3 Shard Gear, it will show up in the report even if you are no longer tracking it. This way we can see who has a full set even if they aren't cluttering their page with something they've already completed.

(I set the status for Olias btw while testing.)

just wanted to let you know, you have the flaming spiked choker listed twice under scout woe gear

Jaral wrote:

just wanted to let you know, you have the flaming spiked choker listed twice under scout woe gear

Thank ya! Let me know if ya find anymore that I messed up. There's 173 entries in there right now so I won't be shocked if you find more things I goofed on.

www.lootdb.com/eq2/item/997214058

aITEM 997214058 106305898:Malovari's Misplaced Bauble of Banishment\/a
Dropped by
Zraxth (The Ruins of Guk: Ykesha's Outer Stronghold)

This is a charm that drops in Outer Stronghold that every class may want.

Well all classes except healers unless said healers wants to DPS.

Owen

\aITEM -1055470574 -1186617072:Stone of the Void\/a
Dropped by
Executor Zynos (Anchor of Bazzul)

This an all mages charm.

And Check found a bug. If you add a category (say healer items) and then remove that category it resets all ready/want flags. Even ones outside of that category.

Owen