[tristantio]

I never really used Magelo back in the day - what features would be expected?

For my existing auction tracker (http://ahungry.com/eqauctions/) I imported an item list into a mySQL database (pruning out most the non-p99 era items) and also wrote the logic for the decimal to bitmask conversions for what classes/races can use items.

If there was a large interest in it, I could write a Magelo style program to allow you to set up your character with their equipped items.

If anyone is interested in the bitmask code for your own usage (to save some time) here is a snippet (written in PHP) of the class/slots and their corresponding decimal number:

 $classes = array(
         'WAR' => 1,
         'CLR' => 2,
         'PAL' => 4,
         'RNG' => 8,
         'SHD' => 16, 
         'DRU' => 32, 
         'MNK' => 64, 
         'BRD' => 128,
         'ROG' => 256,
         'SHM' => 512,
         'NEC' => 1024,
         'WIZ' => 2048,
         'MAG' => 4096,
         'ENC' => 8192
      );  

 $races = array(
         'HUM' => 1,
         'BAR' => 2,
         'ERU' => 4,
         'ELF' => 8,
         'HIE' => 16,
         'DEF' => 32,
         'HEF' => 64,
         'DWF' => 128,
         'TRL' => 256,
         'OGR' => 512,
         'HFL' => 1024,
         'GNM' => 2048,
         'IKS' => 4096
      );

$slots = array(
         'HUM' => 1,
         'EAR' => 2,
         'HEAD' => 4,
         'FACE' => 8,
         'EAR' => 16,
         'NECK' => 32,
         'SHOULDERS' => 64,
         'ARMS' => 128,
         'BACK' => 256,
         'WRIST' => 512,
         'WRIST' => 1024,
         'RANGE' => 2048,
         'HANDS' => 4096,
         'PRIMARY' => 8192,
         'SECONDARY' => 16384,
         'FINGERS' => 32768,
         'FINGERS' => 65536,
         'CHEST' => 131072,
         'LEGS' => 262144,
         'FEET' => 524288,
         'WAIST' => 1048576
      );

and the code to compare vs the decimal values stored for the item's fields is simply a bitwise AND (&) operator.