I have a couple questions on this matter that are related.
I'm revamping PoK to be all merchants and lining them up according to class, armor/weapon/jewelry types and scattering them about to fit all budgets. The absolute class specifics were easy. Ranger was class 8 for example. but i been browsing through the DB finding a wide range of classes. It appears there are unique class ID's for items that can be used by MAG/ENC, ROG/RNG/SHM, WAR/PAL, PAL/SK or any combination thereof. Is there a formula or a table for these combinations? I'm trying to break it down in reverse. (Sorting by class and eyeballing what EQ classes they are for so i know what to put on what merchant) I'm using MS Access for this specific reason on its own crash database hehe
Second question (better yet) I don't own or even know C. I tried using the PHP/Apache item editor just for browsing but after a week i still couldn't get it to work. I'm still learning SQL and think i'll tackle one project at a time :P It's been many years since i even wrote something in basic. but i was wondering if anyone made an offline browser that reads and searches items.txt similar to 13thfloor that wouldn't mind sharing