spells_us.txt data format

lordkazan · #1 02-19-2006, 01:43 PM

I've been searching around for documentation of the spells_us.txt data format but i've come up pretty much empty. I need to know every column. I have a SQL table that i based off eqcaster.exe's output - but it cannot handle the number of spells in the abandoned spells_en.txt not to mention to new completey spells_us.txt [that contains twice the number of spells] - the auto_increment column is database purposes only, the rest of it is fields from the file

anyone got the documentation on how to translate the file directly? spells email me at thekazan AT gmail DOT com - thanks!

Code:

CREATE TABLE `spells` (
  `eq_spells_id` int(11) unsigned NOT NULL auto_increment,
  `Spell Name` tinytext,
  `Description 1` tinytext,
  `Description 2` tinytext,
  `Description 3` tinytext,
  `Description 4` tinytext,
  `Description 5` tinytext,
  `Description 6` tinytext,
  `Description 7` tinytext,
  `Description 8` tinytext,
  `Description 9` tinytext,
  `Description 10` tinytext,
  `Description 11` tinytext,
  `Description 12` tinytext,
  `Extra` tinytext,
  `Mana Drain` int(11) NOT NULL default '0',
  `WAR` int(8) unsigned NOT NULL default '255',
  `CLR` int(8) unsigned NOT NULL default '255',
  `PAL` int(8) unsigned NOT NULL default '255',
  `RNG` int(8) unsigned NOT NULL default '255',
  `SHD` int(8) unsigned NOT NULL default '255',
  `DRU` int(8) unsigned NOT NULL default '255',
  `MNK` int(8) unsigned NOT NULL default '255',
  `BRD` int(8) unsigned NOT NULL default '255',
  `ROG` int(8) unsigned NOT NULL default '255',
  `SHM` int(8) unsigned NOT NULL default '255',
  `NEC` int(8) unsigned NOT NULL default '255',
  `WIZ` int(8) unsigned NOT NULL default '255',
  `MAG` int(8) unsigned NOT NULL default '255',
  `ENC` int(8) unsigned NOT NULL default '255',
  `BST` int(8) unsigned NOT NULL default '255',
  `Casting Time` float NOT NULL default '0',
  `Fizzle Time` float NOT NULL default '0',
  `Recovery Time` float NOT NULL default '0',
  `Indoor/Outdoor` tinytext,
  `Time` tinytext,
  `Location` tinytext,
  `Skill` tinytext,
  `Duration` int(11) NOT NULL default '0',
  `Dur Formula` int(11) NOT NULL default '0',
  `AoE Duration` int(11) NOT NULL default '0',
  `Pos/Neg` int(11) NOT NULL default '0',
  `Category` tinytext,
  `Attrib 1` tinytext,
  `Min 1` int(11) NOT NULL default '0',
  `Max 1` int(11) NOT NULL default '0',
  `Calc 1` tinytext,
  `Attrib 2` tinytext,
  `Min 2` int(11) NOT NULL default '0',
  `Max 2` int(11) NOT NULL default '0',
  `Calc 2` tinytext,
  `Attrib 3` tinytext,
  `Min 3` int(11) NOT NULL default '0',
  `Max 3` int(11) NOT NULL default '0',
  `Calc 3` tinytext,
  `Attrib 4` tinytext,
  `Min 4` int(11) NOT NULL default '0',
  `Max 4` int(11) NOT NULL default '0',
  `Calc 4` tinytext,
  `Attrib 5` tinytext,
  `Min 5` int(11) NOT NULL default '0',
  `Max 5` int(11) NOT NULL default '0',
  `Calc 5` tinytext,
  `Attrib 6` tinytext,
  `Min 6` int(11) NOT NULL default '0',
  `Max 6` int(11) NOT NULL default '0',
  `Calc 6` tinytext,
  `Attrib 7` tinytext,
  `Min 7` int(11) NOT NULL default '0',
  `Max 7` int(11) NOT NULL default '0',
  `Calc 7` tinytext,
  `Attrib 8` tinytext,
  `Min 8` int(11) NOT NULL default '0',
  `Max 8` int(11) NOT NULL default '0',
  `Calc 8` tinytext,
  `Attrib 9` tinytext,
  `Min 9` int(11) NOT NULL default '0',
  `Max 9` int(11) NOT NULL default '0',
  `Calc 9` tinytext,
  `Attrib 10` tinytext,
  `Min 10` int(11) NOT NULL default '0',
  `Max 10` int(11) NOT NULL default '0',
  `Calc 10` tinytext,
  `Attrib 11` tinytext,
  `Min 11` int(11) NOT NULL default '0',
  `Max 11` int(11) NOT NULL default '0',
  `Calc 11` tinytext,
  `Attrib 12` tinytext,
  `Min 12` int(11) NOT NULL default '0',
  `Max 12` int(11) NOT NULL default '0',
  `Calc 12` tinytext,
  `Reagent 1` tinytext,
  `Quantity 1` int(11) NOT NULL default '0',
  `Reageant 2` tinytext,
  `Quantity 2` int(11) NOT NULL default '0',
  `Reageant 3` tinytext,
  `Quantity 3` int(11) NOT NULL default '0',
  `Reageant 4` tinytext,
  `Quantity 4` int(11) NOT NULL default '0',
  `Focus 1` tinytext,
  `Focus 2` tinytext,
  `Focus 3` tinytext,
  `Focus 4` tinytext,
  `Resistance` tinytext,
  `Target` tinytext,
  `Resist Adj` int(11) NOT NULL default '0',
  `Gem` int(11) NOT NULL default '0',
  `Range` float NOT NULL default '0',
  `AoE Range` float NOT NULL default '0',
  `Back Range` float NOT NULL default '0',
  `Up Range` float NOT NULL default '0',
  `Spell ID` int(11) unsigned NOT NULL default '0',
  `You Cast` tinytext,
  `Someone Casts` tinytext,
  `Cast on You` tinytext,
  `Cast on Someone` tinytext,
  `Spell Fades` tinytext,
  PRIMARY KEY  (`eq_spells_id`)
) TYPE=MyISAM;