Classes in the items DB
 

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 :)

I'll answer question one since I don't know any good item editors. I just modify the SQL manually for my own setup.


Classes:
The numbers are added together to handle multiple classes.
Ie,
Magician is 4096
Enchanter is 8192
So Magician and Enchanter is 4096 + 8192 = 12288

oh boy do i feel dumb hehe. its in bits of course. i must have been tired :P

thx :)