Classes in the items DB

[sylverwolf]

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

[garim12]

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:

Berserker   32768
Bard          128
Beastlord   16384

Cleric          2
Druid          32
Enchanter    8192

Magician     4096
Monk           64
Necromancer  1024

Paladin         4
Ranger          8
Rogue         256

Shadowknight   16
Shaman        512
Warrior         1

Wizard       2048

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

[sylverwolf]

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

thx