PDA

View Full Version : Classes in the items DB


sylverwolf
06-11-2005, 03:51 PM
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
06-11-2005, 11:32 PM
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
06-12-2005, 02:33 AM
oh boy do i feel dumb hehe. its in bits of course. i must have been tired :P

thx :)