Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Tools
Reload this Page New Tool Idea

Development::Tools 3rd Party Tools for EQEMu (DB management tools, front ends, etc...)

Reply
Page 2 of 2 1 2
 
Thread Tools Display Modes
  #16  
Old 09-11-2008, 12:24 AM
AndMetal
Developer
  
Join Date: Mar 2007
Location: Ohio
Posts: 648
Default
As far as I know, 13th-Floor is the most comprehensive. Comparing Lucy/Allakhazam's Item DB Stats to the 13th-Floor's (EQItems) Item DB Stats, it's 69933 vs 70180. As far as extracting the info, they're pretty much the same:
Lucy
HTML Code:
  <tr><td align="center"><table width="95%" class="spellview">
  <tr>
    <td width="20%" class="spelllabel">AkzID</td>
    <td width="30%">76356</td>
    <td width="20%" class="spelllabel">aagi</td>

    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">ac</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">accuracy</td>
    <td width="30%">0</td>

  </tr>
  <tr>
    <td width="20%" class="spelllabel">acha</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">adex</td>
    <td width="30%">0</td>
  </tr>

  <tr>
    <td width="20%" class="spelllabel">aint</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">artifact</td>
    <td width="30%">0</td>
  </tr>
  <tr>

    <td width="20%" class="spelllabel">asta</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">astr</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">attack</td>

    <td width="30%">0</td>
    <td width="20%" class="spelllabel">attuneable</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">aug1type</td>
    <td width="30%">0</td>

    <td width="20%" class="spelllabel">aug1unk2</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">aug1vis</td>
    <td width="30%">1</td>
    <td width="20%" class="spelllabel">aug2type</td>

    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">aug2unk2</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">aug2vis</td>
    <td width="30%">1</td>

  </tr>
  <tr>
    <td width="20%" class="spelllabel">aug3type</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">aug3unk2</td>
    <td width="30%">0</td>
  </tr>

  <tr>
    <td width="20%" class="spelllabel">aug3vis</td>
    <td width="30%">1</td>
    <td width="20%" class="spelllabel">aug4type</td>
    <td width="30%">0</td>
  </tr>
  <tr>

    <td width="20%" class="spelllabel">aug4unk2</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">aug4vis</td>
    <td width="30%">1</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">aug5type</td>

    <td width="30%">0</td>
    <td width="20%" class="spelllabel">aug5unk2</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">aug5vis</td>
    <td width="30%">1</td>

    <td width="20%" class="spelllabel">augdistill</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">augres</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">augvalue</td>

    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">avoidance</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">awis</td>
    <td width="30%">0</td>

  </tr>
  <tr>
    <td width="20%" class="spelllabel">backstabdmg</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">bagsize</td>
    <td width="30%">0</td>
  </tr>

  <tr>
    <td width="20%" class="spelllabel">bagslots</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">bagtype</td>
    <td width="30%">0</td>
  </tr>
  <tr>

    <td width="20%" class="spelllabel">bagwr</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">banedmgamnt2</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">banedmgamt</td>

    <td width="30%">0</td>
    <td width="20%" class="spelllabel">banedmgbody</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">banedmgrace</td>
    <td width="30%">0</td>

    <td width="20%" class="spelllabel">bardtype</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">bardvalue</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">benefit</td>

    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">booktype</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">bookunk</td>
    <td width="30%">0</td>

  </tr>
  <tr>
    <td width="20%" class="spelllabel">casttime</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">casttime0</td>
    <td width="30%">0</td>
  </tr>

  <tr>
    <td width="20%" class="spelllabel">casttime1</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">casttime2</td>
    <td width="30%">0</td>
  </tr>
  <tr>

    <td width="20%" class="spelllabel">casttime3</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">casttime4</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">charges0</td>

    <td width="30%">1</td>
    <td width="20%" class="spelllabel">charges1</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">charges2</td>
    <td width="30%">0</td>

    <td width="20%" class="spelllabel">charges3</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">charges4</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">charmfile</td>

    <td width="30%">LONGalethVeredeth</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">clairvoyance</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">classes</td>
    <td width="30%">65535</td>

  </tr>
  <tr>
    <td width="20%" class="spelllabel">color</td>
    <td width="30%">4278190080</td>
    <td width="20%" class="spelllabel">combateffects</td>
    <td width="30%">0</td>
  </tr>

  <tr>
    <td width="20%" class="spelllabel">cost</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">cr</td>
    <td width="30%">0</td>
  </tr>
  <tr>

    <td width="20%" class="spelllabel">crr</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">damage</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">damageshield</td>

    <td width="30%">0</td>
    <td width="20%" class="spelllabel">deity</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">delay</td>
    <td width="30%">0</td>

    <td width="20%" class="spelllabel">dmgplusamnt</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">dmgplustype</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">dotshielding</td>

    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">dr</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">dsmitigation</td>
    <td width="30%">0</td>

  </tr>
  <tr>
    <td width="20%" class="spelllabel">effecttype</td>
    <td width="30%"></td>
    <td width="20%" class="spelllabel">effecttype0</td>
    <td width="30%">3</td>
  </tr>

  <tr>
    <td width="20%" class="spelllabel">effecttype1</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">effecttype2</td>
    <td width="30%">0</td>
  </tr>
  <tr>

    <td width="20%" class="spelllabel">effecttype3</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">effecttype4</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">efflevel0</td>

    <td width="30%">0</td>
    <td width="20%" class="spelllabel">efflevel1</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">efflevel2</td>
    <td width="30%">0</td>

    <td width="20%" class="spelllabel">efflevel3</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">efflevel4</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">elemdmgamt</td>

    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">elemdmgtype</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">endur</td>
    <td width="30%">0</td>

  </tr>
  <tr>
    <td width="20%" class="spelllabel">endurregen</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">evoid</td>
    <td width="30%">0</td>
  </tr>

  <tr>
    <td width="20%" class="spelllabel">evolvl</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">evomax</td>
    <td width="30%">0</td>
  </tr>
  <tr>

    <td width="20%" class="spelllabel">factionamt1</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">factionamt2</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">factionamt3</td>

    <td width="30%">0</td>
    <td width="20%" class="spelllabel">factionamt4</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">factionmod1</td>
    <td width="30%">0</td>

    <td width="20%" class="spelllabel">factionmod2</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">factionmod3</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">factionmod4</td>

    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">filename</td>
    <td width="30%"></td>
    <td width="20%" class="spelllabel">focusid</td>
    <td width="30%"></td>

  </tr>
  <tr>
    <td width="20%" class="spelllabel">fr</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">fvnodrop</td>
    <td width="30%"></td>
  </tr>

  <tr>
    <td width="20%" class="spelllabel">guildfavor</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">haste</td>
    <td width="30%">0</td>
  </tr>
  <tr>

    <td width="20%" class="spelllabel">healamt</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">heroic_agi</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">heroic_cha</td>

    <td width="30%">0</td>
    <td width="20%" class="spelllabel">heroic_dex</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">heroic_int</td>
    <td width="30%">0</td>

    <td width="20%" class="spelllabel">heroic_sta</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">heroic_str</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">heroic_wis</td>

    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">hp</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">icon</td>
    <td width="30%">2253</td>

  </tr>
  <tr>
    <td width="20%" class="spelllabel">id</td>
    <td width="30%">64275</td>
    <td width="20%" class="spelllabel">idfile</td>
    <td width="30%">IT63</td>
  </tr>

  <tr>
    <td width="20%" class="spelllabel">itemclass</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">itemtype</td>
    <td width="30%">11</td>
  </tr>
  <tr>

    <td width="20%" class="spelllabel">ldonprice</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">ldonsold</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">ldontheme</td>

    <td width="30%">0</td>
    <td width="20%" class="spelllabel">level</td>
    <td width="30%"></td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">level0</td>
    <td width="30%">0</td>

    <td width="20%" class="spelllabel">level1</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">level2</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">level3</td>

    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">level4</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">light</td>
    <td width="30%">0</td>

  </tr>
  <tr>
    <td width="20%" class="spelllabel">lore</td>
    <td width="30%">Legends of Norrath: Galeth Veredeth</td>
    <td width="20%" class="spelllabel">loreitem</td>
    <td width="30%">0</td>
  </tr>

  <tr>
    <td width="20%" class="spelllabel">magic</td>
    <td width="30%">1</td>
    <td width="20%" class="spelllabel">mana</td>
    <td width="30%">0</td>
  </tr>
  <tr>

    <td width="20%" class="spelllabel">manaregen</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">material</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">maxcharges</td>

    <td width="30%"></td>
    <td width="20%" class="spelllabel">mr</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">name</td>
    <td width="30%">Legends of Norrath: Galeth Veredeth</td>

    <td width="20%" class="spelllabel">nodrop</td>
    <td width="30%">1</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">nopet</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">norent</td>

    <td width="30%">1</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">notransfer</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">pendinglore</td>
    <td width="30%"></td>

  </tr>
  <tr>
    <td width="20%" class="spelllabel">pointtype</td>
    <td width="30%"></td>
    <td width="20%" class="spelllabel">potionbelt</td>
    <td width="30%">0</td>
  </tr>

  <tr>
    <td width="20%" class="spelllabel">potionbeltslots</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">power</td>
    <td width="30%">0</td>
  </tr>
  <tr>

    <td width="20%" class="spelllabel">pr</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">procrate0</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">procrate1</td>

    <td width="30%">0</td>
    <td width="20%" class="spelllabel">procrate2</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">procrate3</td>
    <td width="30%">0</td>

    <td width="20%" class="spelllabel">procrate4</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">procratemod</td>
    <td width="30%"></td>
    <td width="20%" class="spelllabel">purity</td>

    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">questitem</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">races</td>
    <td width="30%">65535</td>

  </tr>
  <tr>
    <td width="20%" class="spelllabel">range</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">recastdelay</td>
    <td width="30%">0</td>
  </tr>

  <tr>
    <td width="20%" class="spelllabel">recasttype</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">reclevel</td>
    <td width="30%">0</td>
  </tr>
  <tr>

    <td width="20%" class="spelllabel">recskill</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">regen</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">reqlevel</td>

    <td width="30%">0</td>
    <td width="20%" class="spelllabel">shielding</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">size</td>
    <td width="30%">1</td>

    <td width="20%" class="spelllabel">skillmodtype</td>
    <td width="30%">-1</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">skillmodvalue</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">slots</td>

    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">spelldmg</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">spellid</td>
    <td width="30%"></td>

  </tr>
  <tr>
    <td width="20%" class="spelllabel">spellid0</td>
    <td width="30%">7799</td>
    <td width="20%" class="spelllabel">spellid1</td>
    <td width="30%">-1</td>
  </tr>

  <tr>
    <td width="20%" class="spelllabel">spellid2</td>
    <td width="30%">-1</td>
    <td width="20%" class="spelllabel">spellid3</td>
    <td width="30%">-1</td>
  </tr>
  <tr>

    <td width="20%" class="spelllabel">spellid4</td>
    <td width="30%">-1</td>
    <td width="20%" class="spelllabel">spellshield</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">ss0</td>

    <td width="30%">Claim Reward</td>
    <td width="20%" class="spelllabel">ss1</td>
    <td width="30%"></td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">ss2</td>
    <td width="30%"></td>

    <td width="20%" class="spelllabel">ss3</td>
    <td width="30%"></td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">ss4</td>
    <td width="30%"></td>
    <td width="20%" class="spelllabel">stackable</td>

    <td width="30%"></td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">stacksize</td>
    <td width="30%">1</td>
    <td width="20%" class="spelllabel">strikethrough</td>
    <td width="30%">0</td>

  </tr>
  <tr>
    <td width="20%" class="spelllabel">stunresist</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">summoned</td>
    <td width="30%"></td>
  </tr>

  <tr>
    <td width="20%" class="spelllabel">time2</td>
    <td width="30%"></td>
    <td width="20%" class="spelllabel">tradeskills</td>
    <td width="30%">0</td>
  </tr>
  <tr>

    <td width="20%" class="spelllabel">tribute</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">unknown01</td>
    <td width="30%"></td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">unknown02</td>

    <td width="30%">0</td>
    <td width="20%" class="spelllabel">unknown03</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">unknown04</td>
    <td width="30%">0</td>

    <td width="20%" class="spelllabel">unknown05</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">unknown06</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">unknown07</td>

    <td width="30%">1065353216</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">unknown08</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">unknown09</td>
    <td width="30%">70</td>

  </tr>
  <tr>
    <td width="20%" class="spelllabel">unknown10</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">unknown13</td>
    <td width="30%">0</td>
  </tr>

  <tr>
    <td width="20%" class="spelllabel">unknown16</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">unknown18</td>
    <td width="30%">0</td>
  </tr>
  <tr>

    <td width="20%" class="spelllabel">unknown19</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">unknown22</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">unknown26</td>

    <td width="30%">0</td>
    <td width="20%" class="spelllabel">unknown28</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">unknown33</td>
    <td width="30%">0</td>

    <td width="20%" class="spelllabel">unknown34</td>
    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">unknown36</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">unknown37</td>

    <td width="30%">0</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">unknown39</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">unknown40</td>
    <td width="30%">0</td>

  </tr>
  <tr>
    <td width="20%" class="spelllabel">unknown42</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">unknown43</td>
    <td width="30%">0</td>
  </tr>

  <tr>
    <td width="20%" class="spelllabel">unknown44</td>
    <td width="30%">0</td>
    <td width="20%" class="spelllabel">unknown45</td>
    <td width="30%">-1</td>
  </tr>
  <tr>

    <td width="20%" class="spelllabel">unknown46</td>
    <td width="30%">-1</td>
    <td width="20%" class="spelllabel">unknown47</td>
    <td width="30%">-1</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">unknown48</td>

    <td width="30%">-1</td>
    <td width="20%" class="spelllabel">updated</td>
    <td width="30%">2008-09-02 18:12:50</td>
  </tr>
  <tr>
    <td width="20%" class="spelllabel">weight</td>
    <td width="30%">1</td>

    <td width="20%" class="spelllabel">zeros</td>
    <td width="30%"></td>
  </tr>
13th-Floor
HTML Code:
<tr><td class="spelllabel" valign="top">itemclass</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">name</td><td class="spelldata" valign="top">Legends of Norrath: Galeth Veredeth</td></tr>
<tr><td class="spelllabel" valign="top">lore</td><td class="spelldata" valign="top">Legends of Norrath: Galeth Veredeth</td><td class="spelllabel" valign="top">lorefile</td><td class="spelldata" valign="top"></td></tr>
<tr><td class="spelllabel" valign="top">idfile</td><td class="spelldata" valign="top">IT63</td><td class="spelllabel" valign="top">id</td><td class="spelldata" valign="top">64275</td></tr>
<tr><td class="spelllabel" valign="top">weight</td><td class="spelldata" valign="top">1</td><td class="spelllabel" valign="top">norent</td><td class="spelldata" valign="top">1</td></tr>

<tr><td class="spelllabel" valign="top">nodrop</td><td class="spelldata" valign="top">1</td><td class="spelllabel" valign="top">size</td><td class="spelldata" valign="top">1</td></tr>
<tr><td class="spelllabel" valign="top">slots</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">price</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">icon</td><td class="spelldata" valign="top">2253</td><td class="spelllabel" valign="top">UNK013</td><td class="spelldata" valign="top">1</td></tr>
<tr><td class="spelllabel" valign="top">UNK014</td><td class="spelldata" valign="top">1</td><td class="spelllabel" valign="top">benefitflag</td><td class="spelldata" valign="top">0</td></tr>

<tr><td class="spelllabel" valign="top">tradeskills</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">cr</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">dr</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">pr</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">mr</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">fr</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">svcorruption</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">astr</td><td class="spelldata" valign="top">0</td></tr>

<tr><td class="spelllabel" valign="top">asta</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">aagi</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">adex</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">acha</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">aint</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">awis</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">hp</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">mana</td><td class="spelldata" valign="top">0</td></tr>

<tr><td class="spelllabel" valign="top">endur</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">ac</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">classes</td><td class="spelldata" valign="top">65535</td><td class="spelllabel" valign="top">races</td><td class="spelldata" valign="top">65535</td></tr>
<tr><td class="spelllabel" valign="top">deity</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">skillmodvalue</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">UNK038</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">skillmodtype</td><td class="spelldata" valign="top">-1</td></tr>

<tr><td class="spelllabel" valign="top">banedmgrace</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">banedmgbody</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">banedmgraceamt</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">banedmgamt</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">magic</td><td class="spelldata" valign="top">1</td><td class="spelllabel" valign="top">casttime_</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">reqlevel</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">reclevel</td><td class="spelldata" valign="top">0</td></tr>

<tr><td class="spelllabel" valign="top">recskill</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">bardtype</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">bardvalue</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">light</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">delay</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">elemdmgtype</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">elemdmgamt</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">range</td><td class="spelldata" valign="top">0</td></tr>

<tr><td class="spelllabel" valign="top">damage</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">color</td><td class="spelldata" valign="top">4278190080</td></tr>
<tr><td class="spelllabel" valign="top">itemtype</td><td class="spelldata" valign="top">11</td><td class="spelllabel" valign="top">material</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">UNK060</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">UNK061</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">sellrate</td><td class="spelldata" valign="top">1.0</td><td class="spelllabel" valign="top">combateffects</td><td class="spelldata" valign="top">0</td></tr>

<tr><td class="spelllabel" valign="top">shielding</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">stunresist</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">strikethrough</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">extradmgskill</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">extradmgamt</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">spellshield</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">avoidance</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">accuracy</td><td class="spelldata" valign="top">0</td></tr>

<tr><td class="spelllabel" valign="top">charmfileid</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">factionmod1</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">factionamt1</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">factionmod2</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">factionamt2</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">factionmod3</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">factionamt3</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">factionmod4</td><td class="spelldata" valign="top">0</td></tr>

<tr><td class="spelllabel" valign="top">factionamt4</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">charmfile</td><td class="spelldata" valign="top">LONGalethVeredeth</td></tr>
<tr><td class="spelllabel" valign="top">augtype</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">augrestrict</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">augdistiller</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">augslot1type</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">augslot1visible</td><td class="spelldata" valign="top">1</td><td class="spelllabel" valign="top">augslot1unk2</td><td class="spelldata" valign="top">0</td></tr>

<tr><td class="spelllabel" valign="top">augslot2type</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">augslot2visible</td><td class="spelldata" valign="top">1</td></tr>
<tr><td class="spelllabel" valign="top">augslot2unk2</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">augslot3type</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">augslot3visible</td><td class="spelldata" valign="top">1</td><td class="spelllabel" valign="top">augslot3unk2</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">augslot4type</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">augslot4visible</td><td class="spelldata" valign="top">1</td></tr>

<tr><td class="spelllabel" valign="top">augslot4unk2</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">augslot5type</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">augslot5visible</td><td class="spelldata" valign="top">1</td><td class="spelllabel" valign="top">augslot5unk2</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">pointtype</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">ldontheme</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">ldonprice</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">UNK098</td><td class="spelldata" valign="top">70</td></tr>

<tr><td class="spelllabel" valign="top">ldonsold</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">bagtype</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">bagslots</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">bagsize</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">bagwr</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">book</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">booktype</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">filename</td><td class="spelldata" valign="top"></td></tr>

<tr><td class="spelllabel" valign="top">loregroup</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">artifactflag</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">UNK109</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">favor</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">guildfavor</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">fvnodrop</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">dotshielding</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">attack</td><td class="spelldata" valign="top">0</td></tr>

<tr><td class="spelllabel" valign="top">regen</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">manaregen</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">enduranceregen</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">haste</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">damageshield</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">UNK120</td><td class="spelldata" valign="top">-1</td></tr>
<tr><td class="spelllabel" valign="top">UNK121</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">attuneable</td><td class="spelldata" valign="top">0</td></tr>

<tr><td class="spelllabel" valign="top">nopet</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">UNK124</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">potionbelt</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">potionbeltslots</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">stacksize</td><td class="spelldata" valign="top">1</td><td class="spelllabel" valign="top">notransfer</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">UNK129</td><td class="spelldata" valign="top">9380</td><td class="spelllabel" valign="top">questitemflag</td><td class="spelldata" valign="top">0</td></tr>

<tr><td class="spelllabel" valign="top">UNK131</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">UNK132</td><td class="spelldata" valign="top">0000000000000000000</td></tr>
<tr><td class="spelllabel" valign="top">clickeffect</td><td class="spelldata" valign="top">7799</td><td class="spelllabel" valign="top">clicktype</td><td class="spelldata" valign="top">3</td></tr>
<tr><td class="spelllabel" valign="top">clicklevel2</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">clicklevel</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">maxcharges</td><td class="spelldata" valign="top">1</td><td class="spelllabel" valign="top">casttime</td><td class="spelldata" valign="top">0</td></tr>

<tr><td class="spelllabel" valign="top">recastdelay</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">recasttype</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">clickunk5</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">clickname</td><td class="spelldata" valign="top">Claim Reward</td></tr>
<tr><td class="spelllabel" valign="top">clickunk7</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">proceffect</td><td class="spelldata" valign="top">-1</td></tr>
<tr><td class="spelllabel" valign="top">proctype</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">proclevel2</td><td class="spelldata" valign="top">0</td></tr>

<tr><td class="spelllabel" valign="top">proclevel</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">procunk1</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">procunk2</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">procunk3</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">procunk4</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">procrate</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">procname</td><td class="spelldata" valign="top"></td><td class="spelllabel" valign="top">procunk7</td><td class="spelldata" valign="top">-1</td></tr>

<tr><td class="spelllabel" valign="top">worneffect</td><td class="spelldata" valign="top">-1</td><td class="spelllabel" valign="top">worntype</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">wornlevel2</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">wornlevel</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">wornunk1</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">wornunk2</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">wornunk3</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">wornunk4</td><td class="spelldata" valign="top">0</td></tr>

<tr><td class="spelllabel" valign="top">wornunk5</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">wornname</td><td class="spelldata" valign="top"></td></tr>
<tr><td class="spelllabel" valign="top">wornunk7</td><td class="spelldata" valign="top">-1</td><td class="spelllabel" valign="top">focuseffect</td><td class="spelldata" valign="top">-1</td></tr>
<tr><td class="spelllabel" valign="top">focustype</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">focuslevel2</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">focuslevel</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">focusunk1</td><td class="spelldata" valign="top">0</td></tr>

<tr><td class="spelllabel" valign="top">focusunk2</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">focusunk3</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">focusunk4</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">focusunk5</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">focusname</td><td class="spelldata" valign="top"></td><td class="spelllabel" valign="top">focusunk7</td><td class="spelldata" valign="top">-1</td></tr>
<tr><td class="spelllabel" valign="top">scrolleffect</td><td class="spelldata" valign="top">-1</td><td class="spelllabel" valign="top">scrolltype</td><td class="spelldata" valign="top">0</td></tr>

<tr><td class="spelllabel" valign="top">scrolllevel2</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">scrolllevel</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">scrollunk1</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">scrollunk2</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">scrollunk3</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">scrollunk4</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">scrollunk5</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">scrollname</td><td class="spelldata" valign="top"></td></tr>

<tr><td class="spelllabel" valign="top">scrollunk7</td><td class="spelldata" valign="top">-1</td><td class="spelllabel" valign="top">UNK193</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">purity</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">dsmitigation</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">heroic_str</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">heroic_int</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">heroic_wis</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">heroic_agi</td><td class="spelldata" valign="top">0</td></tr>

<tr><td class="spelllabel" valign="top">heroic_dex</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">heroic_sta</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">heroic_cha</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">healamt</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">spelldmg</td><td class="spelldata" valign="top">0</td><td class="spelllabel" valign="top">clairvoyance</td><td class="spelldata" valign="top">0</td></tr>
<tr><td class="spelllabel" valign="top">backstabdmg</td><td class="spelldata" valign="top">0</td></tr>
The only real difference is the column names.

Something you might want to look into is the utils/load_13thfloor_items.pl file included with the server source. The current items DB was basically imported from 13th-Floor, the only issue is that 13th-Floor now has newer columns that aren't in our items table (yet), so the script doesn't really work anymore. And since you have to have Perl in order to run the server anyway, it makes sense to create/modify a script in Perl, since it is also cross-platform compatible.

Anyways, I hope this helps.
__________________
GM-Impossible of 'A work in progress'
A non-legit PEQ DB server
How to create your own non-legit server

My Contributions to the Wiki
Reply With Quote
  #17  
Old 09-11-2008, 08:27 AM
nosfentora
Discordant
  
Join Date: Oct 2004
Location: In a house
Posts: 377
Default
That does help, actually, thanks!

any other sites (like raidloot, allakhazam, etc etc) would help too.
Reply With Quote
Reply
Page 2 of 2 1 2

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

   

All times are GMT -4. The time now is 04:11 AM.

EQEmulator - Archive - Top

 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3