Item Creation Info

comicmess · #1 06-17-2011, 06:50 AM

Hey guys

So I have been working on this small project for my friends and I in my free time. Today I decided I wanted to start fresh and delete my item thread in my database. Unfortunately I forgot to save any of how a working item's table reads (right now when I open an item that I make in the database with GeorgeS Tools I get a "cannot load this item" while it worked before I deleted the DB, hence why I believe it's just a number I'm filling out wrong) and thusly forgotten how to make a working item.

I checked out the wiki and found some useful info, but even with it (even with the item tags explained) I can't make a working one or find a working example.

Would someone mind just posting an item or two's tables like so?

Code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>
  <head>
    <title>items</title>
    <meta name="GENERATOR" content="HeidiSQL 6.0.0.3603">
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <style type="text/css">
      thead tr {background-color: ActiveCaption; color: CaptionText;}
      th, td {vertical-align: top; font-family: "Tahoma"; font-size: 8pt; padding: 3px; }
      table, td {border: 1px solid silver;}
      table {border-collapse: collapse;}
      thead .col0 {width: 64px;}
      .col0 {text-align: right;}
      thead .col1 {width: 94px;}
      .col1 {text-align: right;}
      thead .col2 {width: 75px;}
      thead .col3 {width: 48px;}
      .col3 {text-align: right;}
      thead .col4 {width: 42px;}
      .col4 {text-align: right;}
      thead .col5 {width: 71px;}
      .col5 {text-align: right;}
      thead .col6 {width: 51px;}
      .col6 {text-align: right;}
      thead .col7 {width: 52px;}
      .col7 {text-align: right;}
      thead .col8 {width: 46px;}
      .col8 {text-align: right;}
      thead .col9 {width: 81px;}
      .col9 {text-align: right;}
      thead .col10 {width: 49px;}
      .col10 {text-align: right;}
      thead .col11 {width: 47px;}
      .col11 {text-align: right;}
      thead .col12 {width: 58px;}
      .col12 {text-align: right;}
      thead .col13 {width: 80px;}
      .col13 {text-align: right;}
      thead .col14 {width: 91px;}
      .col14 {text-align: right;}
      thead .col15 {width: 98px;}
      .col15 {text-align: right;}
      thead .col16 {width: 91px;}
      .col16 {text-align: right;}
      thead .col17 {width: 98px;}
      .col17 {text-align: right;}
      thead .col18 {width: 91px;}
      .col18 {text-align: right;}
      thead .col19 {width: 98px;}
      .col19 {text-align: right;}
      thead .col20 {width: 91px;}
      .col20 {text-align: right;}
      thead .col21 {width: 98px;}
      .col21 {text-align: right;}
      thead .col22 {width: 91px;}
      .col22 {text-align: right;}
      thead .col23 {width: 98px;}
      .col23 {text-align: right;}
      thead .col24 {width: 68px;}
      .col24 {text-align: right;}
      thead .col25 {width: 77px;}
      .col25 {text-align: right;}
      thead .col26 {width: 49px;}
      .col26 {text-align: right;}
      thead .col27 {width: 64px;}
      .col27 {text-align: right;}
      thead .col28 {width: 68px;}
      .col28 {text-align: right;}
      thead .col29 {width: 68px;}
      .col29 {text-align: right;}
      thead .col30 {width: 58px;}
      .col30 {text-align: right;}
      thead .col31 {width: 90px;}
      .col31 {text-align: right;}
      thead .col32 {width: 111px;}
      .col32 {text-align: right;}
      thead .col33 {width: 96px;}
      .col33 {text-align: right;}
      thead .col34 {width: 93px;}
      .col34 {text-align: right;}
      thead .col35 {width: 72px;}
      .col35 {text-align: right;}
      thead .col36 {width: 76px;}
      .col36 {text-align: right;}
      thead .col37 {width: 51px;}
      .col37 {text-align: right;}
      thead .col38 {width: 68px;}
      .col38 {text-align: right;}
      thead .col39 {width: 74px;}
      .col39 {text-align: right;}
      thead .col40 {width: 71px;}
      thead .col41 {width: 79px;}
      thead .col42 {width: 62px;}
      .col42 {text-align: right;}
      thead .col43 {width: 51px;}
      .col43 {text-align: right;}
      thead .col44 {width: 97px;}
      thead .col45 {width: 90px;}
      .col45 {text-align: right;}
      thead .col46 {width: 92px;}
      .col46 {text-align: right;}
      thead .col47 {width: 51px;}
      .col47 {text-align: right;}
      thead .col48 {width: 42px;}
      .col48 {text-align: right;}
      thead .col49 {width: 66px;}
      .col49 {text-align: right;}
      thead .col50 {width: 93px;}
      .col50 {text-align: right;}
      thead .col51 {width: 52px;}
      .col51 {text-align: right;}
      thead .col52 {width: 54px;}
      .col52 {text-align: right;}
      thead .col53 {width: 79px;}
      .col53 {text-align: right;}
      thead .col54 {width: 85px;}
      .col54 {text-align: right;}
      thead .col55 {width: 42px;}
      .col55 {text-align: right;}
      thead .col56 {width: 69px;}
      .col56 {text-align: right;}
      thead .col57 {width: 75px;}
      .col57 {text-align: right;}
      thead .col58 {width: 92px;}
      .col58 {text-align: right;}
      thead .col59 {width: 88px;}
      .col59 {text-align: right;}
      thead .col60 {width: 56px;}
      .col60 {text-align: right;}
      thead .col61 {width: 85px;}
      .col61 {text-align: right;}
      thead .col62 {width: 85px;}
      .col62 {text-align: right;}
      thead .col63 {width: 85px;}
      .col63 {text-align: right;}
      thead .col64 {width: 85px;}
      .col64 {text-align: right;}
      thead .col65 {width: 87px;}
      .col65 {text-align: right;}
      thead .col66 {width: 87px;}
      .col66 {text-align: right;}
      thead .col67 {width: 87px;}
      .col67 {text-align: right;}
      thead .col68 {width: 87px;}
      .col68 {text-align: right;}
      thead .col69 {width: 68px;}
      thead .col70 {width: 83px;}
      .col70 {text-align: right;}
      thead .col71 {width: 42px;}
      .col71 {text-align: right;}
      thead .col72 {width: 72px;}
      .col72 {text-align: right;}
      thead .col73 {width: 55px;}
      .col73 {text-align: right;}
      thead .col74 {width: 69px;}
      .col74 {text-align: right;}
      thead .col75 {width: 42px;}
      .col75 {text-align: right;}
      thead .col76 {width: 56px;}
      .col76 {text-align: right;}
      thead .col77 {width: 47px;}
      .col77 {text-align: right;}
      thead .col78 {width: 57px;}
      thead .col79 {width: 71px;}
      .col79 {text-align: right;}
      thead .col80 {width: 70px;}
      .col80 {text-align: right;}
      thead .col81 {width: 71px;}
      .col81 {text-align: right;}
      thead .col82 {width: 78px;}
      .col82 {text-align: right;}
      thead .col83 {width: 67px;}
      .col83 {text-align: right;}
      thead .col84 {width: 48px;}
      .col84 {text-align: right;}
      thead .col85 {width: 71px;}
      thead .col86 {width: 74px;}
      .col86 {text-align: right;}
      thead .col87 {width: 55px;}
      .col87 {text-align: right;}
      thead .col88 {width: 54px;}
      .col88 {text-align: right;}
      thead .col89 {width: 82px;}
      .col89 {text-align: right;}
      thead .col90 {width: 107px;}
      .col90 {text-align: right;}
      thead .col91 {width: 66px;}
      .col91 {text-align: right;}
      thead .col92 {width: 86px;}
      .col92 {text-align: right;}
      thead .col93 {width: 42px;}
      .col93 {text-align: right;}
      thead .col94 {width: 62px;}
      .col94 {text-align: right;}
      thead .col95 {width: 60px;}
      .col95 {text-align: right;}
      thead .col96 {width: 102px;}
      .col96 {text-align: right;}
      thead .col97 {width: 42px;}
      .col97 {text-align: right;}
      thead .col98 {width: 69px;}
      .col98 {text-align: right;}
      thead .col99 {width: 54px;}
      .col99 {text-align: right;}
      thead .col100 {width: 56px;}
      .col100 {text-align: right;}
      thead .col101 {width: 65px;}
      .col101 {text-align: right;}
      thead .col102 {width: 59px;}
      .col102 {text-align: right;}
      thead .col103 {width: 66px;}
      .col103 {text-align: right;}
      thead .col104 {width: 63px;}
      .col104 {text-align: right;}
      thead .col105 {width: 69px;}
      .col105 {text-align: right;}
      thead .col106 {width: 46px;}
      .col106 {text-align: right;}
      thead .col107 {width: 86px;}
      .col107 {text-align: right;}
      thead .col108 {width: 90px;}
      .col108 {text-align: right;}
      thead .col109 {width: 66px;}
      .col109 {text-align: right;}
      thead .col110 {width: 76px;}
      .col110 {text-align: right;}
      thead .col111 {width: 76px;}
      .col111 {text-align: right;}
      thead .col112 {width: 92px;}
      .col112 {text-align: right;}
      thead .col113 {width: 75px;}
      .col113 {text-align: right;}
      thead .col114 {width: 97px;}
      .col114 {text-align: right;}
      thead .col115 {width: 75px;}
      .col115 {text-align: right;}
      thead .col116 {width: 54px;}
      .col116 {text-align: right;}
      thead .col117 {width: 60px;}
      .col117 {text-align: right;}
      thead .col118 {width: 66px;}
      .col118 {text-align: right;}
      thead .col119 {width: 66px;}
      .col119 {text-align: right;}
      thead .col120 {width: 80px;}
      .col120 {text-align: right;}
      thead .col121 {width: 66px;}
      .col121 {text-align: right;}
      thead .col122 {width: 66px;}
      .col122 {text-align: right;}
      thead .col123 {width: 73px;}
      .col123 {text-align: right;}
      thead .col124 {width: 84px;}
      .col124 {text-align: right;}
      thead .col125 {width: 80px;}
      .col125 {text-align: right;}
      thead .col126 {width: 76px;}
      .col126 {text-align: right;}
      thead .col127 {width: 66px;}
      .col127 {text-align: right;}
      thead .col128 {width: 66px;}
      .col128 {text-align: right;}
      thead .col129 {width: 80px;}
      .col129 {text-align: right;}
      thead .col130 {width: 56px;}
      .col130 {text-align: right;}
      thead .col131 {width: 138px;}
      thead .col132 {width: 71px;}
      thead .col133 {width: 66px;}
      .col133 {text-align: right;}
      thead .col134 {width: 74px;}
      .col134 {text-align: right;}
      thead .col135 {width: 76px;}
      .col135 {text-align: right;}
      thead .col136 {width: 98px;}
      .col136 {text-align: right;}
      thead .col137 {width: 71px;}
      .col137 {text-align: right;}
      thead .col138 {width: 79px;}
      .col138 {text-align: right;}
      thead .col139 {width: 73px;}
      .col139 {text-align: right;}
      thead .col140 {width: 66px;}
      thead .col141 {width: 66px;}
      .col141 {text-align: right;}
      thead .col142 {width: 78px;}
      .col142 {text-align: right;}
      thead .col143 {width: 71px;}
      .col143 {text-align: right;}
      thead .col144 {width: 77px;}
      .col144 {text-align: right;}
      thead .col145 {width: 71px;}
      .col145 {text-align: right;}
      thead .col146 {width: 66px;}
      .col146 {text-align: right;}
      thead .col147 {width: 81px;}
      .col147 {text-align: right;}
      thead .col148 {width: 74px;}
      .col148 {text-align: right;}
      thead .col149 {width: 80px;}
      .col149 {text-align: right;}
      thead .col150 {width: 74px;}
      .col150 {text-align: right;}
      thead .col151 {width: 66px;}
      .col151 {text-align: right;}
      thead .col152 {width: 76px;}
      .col152 {text-align: right;}
      thead .col153 {width: 82px;}
      .col153 {text-align: right;}
      thead .col154 {width: 76px;}
      .col154 {text-align: right;}
      thead .col155 {width: 66px;}
      .col155 {text-align: right;}
      thead .col156 {width: 81px;}
      .col156 {text-align: right;}
      thead .col157 {width: 74px;}
      .col157 {text-align: right;}
      thead .col158 {width: 80px;}
      .col158 {text-align: right;}
      thead .col159 {width: 74px;}
      .col159 {text-align: right;}
      thead .col160 {width: 66px;}
      .col160 {text-align: right;}
      thead .col161 {width: 72px;}
      thead .col162 {width: 67px;}
      thead .col163 {width: 84px;}
      thead .col164 {width: 60px;}
      thead .col165 {width: 66px;}
      .col165 {text-align: right;}
      thead .col166 {width: 60px;}
      thead .col167 {width: 66px;}
      .col167 {text-align: right;}
      thead .col168 {width: 88px;}
      .col168 {text-align: right;}
      thead .col169 {width: 66px;}
      .col169 {text-align: right;}
      thead .col170 {width: 66px;}
      .col170 {text-align: right;}
      thead .col171 {width: 92px;}
      .col171 {text-align: right;}
      thead .col172 {width: 92px;}
      .col172 {text-align: right;}
      thead .col173 {width: 92px;}
      .col173 {text-align: right;}
      thead .col174 {width: 92px;}
      .col174 {text-align: right;}
      thead .col175 {width: 92px;}
      .col175 {text-align: right;}
      thead .col176 {width: 66px;}
      .col176 {text-align: right;}
      thead .col177 {width: 66px;}
      .col177 {text-align: right;}
      thead .col178 {width: 93px;}
      .col178 {text-align: right;}
      thead .col179 {width: 66px;}
      thead .col180 {width: 70px;}
      .col180 {text-align: right;}
      thead .col181 {width: 70px;}
      thead .col182 {width: 70px;}
      .col182 {text-align: right;}
      thead .col183 {width: 72px;}
      .col183 {text-align: right;}
      thead .col184 {width: 72px;}
      .col184 {text-align: right;}
      thead .col185 {width: 72px;}
      .col185 {text-align: right;}
      thead .col186 {width: 72px;}
      .col186 {text-align: right;}
      thead .col187 {width: 72px;}
      thead .col188 {width: 72px;}
      .col188 {text-align: right;}
      thead .col189 {width: 75px;}
      .col189 {text-align: right;}
      thead .col190 {width: 75px;}
      .col190 {text-align: right;}
      thead .col191 {width: 75px;}
      .col191 {text-align: right;}
      thead .col192 {width: 75px;}
      .col192 {text-align: right;}
      thead .col193 {width: 75px;}
      .col193 {text-align: right;}
      thead .col194 {width: 75px;}
      thead .col195 {width: 75px;}
      .col195 {text-align: right;}
      thead .col196 {width: 77px;}
      .col196 {text-align: right;}
      thead .col197 {width: 77px;}
      .col197 {text-align: right;}
      thead .col198 {width: 77px;}
      .col198 {text-align: right;}
      thead .col199 {width: 77px;}
      .col199 {text-align: right;}
      thead .col200 {width: 77px;}
      .col200 {text-align: right;}
      thead .col201 {width: 77px;}
      thead .col202 {width: 77px;}
      .col202 {text-align: right;}
      thead .col203 {width: 75px;}
      .col203 {text-align: right;}
      thead .col204 {width: 75px;}
      .col204 {text-align: right;}
      thead .col205 {width: 75px;}
      .col205 {text-align: right;}
      thead .col206 {width: 75px;}
      .col206 {text-align: right;}
      thead .col207 {width: 75px;}
      .col207 {text-align: right;}
      thead .col208 {width: 75px;}
      thead .col209 {width: 75px;}
      .col209 {text-align: right;}
      thead .col210 {width: 66px;}
      .col210 {text-align: right;}
      thead .col211 {width: 56px;}
      .col211 {text-align: right;}
      thead .col212 {width: 90px;}
      .col212 {text-align: right;}
      thead .col213 {width: 73px;}
      thead .col214 {width: 75px;}
      thead .col215 {width: 78px;}
      thead .col216 {width: 80px;}
      thead .col217 {width: 78px;}
      thead .col218 {width: 85px;}
      .col218 {text-align: right;}
      thead .col219 {width: 76px;}
      .col219 {text-align: right;}
      thead .col220 {width: 75px;}
      .col220 {text-align: right;}
      thead .col221 {width: 78px;}
      .col221 {text-align: right;}
      thead .col222 {width: 77px;}
      .col222 {text-align: right;}
      thead .col223 {width: 81px;}
      .col223 {text-align: right;}
      thead .col224 {width: 78px;}
      .col224 {text-align: right;}
      thead .col225 {width: 80px;}
      .col225 {text-align: right;}
      thead .col226 {width: 73px;}
      .col226 {text-align: right;}
      thead .col227 {width: 73px;}
      .col227 {text-align: right;}
      thead .col228 {width: 71px;}
      .col228 {text-align: right;}
      thead .col229 {width: 72px;}
      .col229 {text-align: right;}
      thead .col230 {width: 75px;}
      .col230 {text-align: right;}
      thead .col231 {width: 105px;}
      .col231 {text-align: right;}
      thead .col232 {width: 66px;}
      .col232 {text-align: right;}
      thead .col233 {width: 69px;}
      .col233 {text-align: right;}
      thead .col234 {width: 88px;}
      .col234 {text-align: right;}
      thead .col235 {width: 91px;}
      .col235 {text-align: right;}
      thead .col236 {width: 65px;}
      thead .col237 {width: 86px;}
      .col237 {text-align: right;}
      thead .col238 {width: 105px;}
      .col238 {text-align: right;}
      thead .col239 {width: 76px;}
      .col239 {text-align: right;}
      thead .col240 {width: 112px;}
      .col240 {text-align: right;}
      thead .col241 {width: 130px;}
      .col241 {text-align: right;}
      thead .col242 {width: 79px;}
      .col242 {text-align: right;}
      thead .col243 {width: 101px;}
      .col243 {text-align: right;}
      thead .col244 {width: 78px;}
      .col244 {text-align: right;}
      thead .col245 {width: 72px;}
      .col245 {text-align: right;}
      thead .col246 {width: 73px;}
      .col246 {text-align: right;}
      thead .col247 {width: 73px;}
      .col247 {text-align: right;}
      thead .col248 {width: 73px;}
      .col248 {text-align: right;}
      thead .col249 {width: 73px;}
      .col249 {text-align: right;}
      thead .col250 {width: 73px;}
      .col250 {text-align: right;}
      thead .col251 {width: 76px;}
      thead .col252 {width: 73px;}
      .col252 {text-align: right;}
      thead .col253 {width: 66px;}
      .col253 {text-align: right;}
    </style>
  </head>

  <body>

    <table caption="items (1 rows)">
      <thead>
        <tr>
          <th class="col0">id</th>
          <th class="col1">minstatus</th>
          <th class="col2">Name</th>
          <th class="col3">aagi</th>
          <th class="col4">ac</th>
          <th class="col5">accuracy</th>
          <th class="col6">acha</th>
          <th class="col7">adex</th>
          <th class="col8">aint</th>
          <th class="col9">artifactflag</th>
          <th class="col10">asta</th>
          <th class="col11">astr</th>
          <th class="col12">attack</th>
          <th class="col13">augrestrict</th>
          <th class="col14">augslot1type</th>
          <th class="col15">augslot1visible</th>
          <th class="col16">augslot2type</th>
          <th class="col17">augslot2visible</th>
          <th class="col18">augslot3type</th>
          <th class="col19">augslot3visible</th>
          <th class="col20">augslot4type</th>
          <th class="col21">augslot4visible</th>
          <th class="col22">augslot5type</th>
          <th class="col23">augslot5visible</th>
          <th class="col24">augtype</th>
          <th class="col25">avoidance</th>
          <th class="col26">awis</th>
          <th class="col27">bagsize</th>
          <th class="col28">bagslots</th>
          <th class="col29">bagtype</th>
          <th class="col30">bagwr</th>
          <th class="col31">banedmgamt</th>
          <th class="col32">banedmgraceamt</th>
          <th class="col33">banedmgbody</th>
          <th class="col34">banedmgrace</th>
          <th class="col35">bardtype</th>
          <th class="col36">bardvalue</th>
          <th class="col37">book</th>
          <th class="col38">casttime</th>
          <th class="col39">casttime_</th>
          <th class="col40">charmfile</th>
          <th class="col41">charmfileid</th>
          <th class="col42">classes</th>
          <th class="col43">color</th>
          <th class="col44">combateffects</th>
          <th class="col45">extradmgskill</th>
          <th class="col46">extradmgamt</th>
          <th class="col47">price</th>
          <th class="col48">cr</th>
          <th class="col49">damage</th>
          <th class="col50">damageshield</th>
          <th class="col51">deity</th>
          <th class="col52">delay</th>
          <th class="col53">augdistiller</th>
          <th class="col54">dotshielding</th>
          <th class="col55">dr</th>
          <th class="col56">clicktype</th>
          <th class="col57">clicklevel2</th>
          <th class="col58">elemdmgtype</th>
          <th class="col59">elemdmgamt</th>
          <th class="col60">endur</th>
          <th class="col61">factionamt1</th>
          <th class="col62">factionamt2</th>
          <th class="col63">factionamt3</th>
          <th class="col64">factionamt4</th>
          <th class="col65">factionmod1</th>
          <th class="col66">factionmod2</th>
          <th class="col67">factionmod3</th>
          <th class="col68">factionmod4</th>
          <th class="col69">filename</th>
          <th class="col70">focuseffect</th>
          <th class="col71">fr</th>
          <th class="col72">fvnodrop</th>
          <th class="col73">haste</th>
          <th class="col74">clicklevel</th>
          <th class="col75">hp</th>
          <th class="col76">regen</th>
          <th class="col77">icon</th>
          <th class="col78">idfile</th>
          <th class="col79">itemclass</th>
          <th class="col80">itemtype</th>
          <th class="col81">ldonprice</th>
          <th class="col82">ldontheme</th>
          <th class="col83">ldonsold</th>
          <th class="col84">light</th>
          <th class="col85">lore</th>
          <th class="col86">loregroup</th>
          <th class="col87">magic</th>
          <th class="col88">mana</th>
          <th class="col89">manaregen</th>
          <th class="col90">enduranceregen</th>
          <th class="col91">material</th>
          <th class="col92">maxcharges</th>
          <th class="col93">mr</th>
          <th class="col94">nodrop</th>
          <th class="col95">norent</th>
          <th class="col96">pendingloreflag</th>
          <th class="col97">pr</th>
          <th class="col98">procrate</th>
          <th class="col99">races</th>
          <th class="col100">range</th>
          <th class="col101">reclevel</th>
          <th class="col102">recskill</th>
          <th class="col103">reqlevel</th>
          <th class="col104">sellrate</th>
          <th class="col105">shielding</th>
          <th class="col106">size</th>
          <th class="col107">skillmodtype</th>
          <th class="col108">skillmodvalue</th>
          <th class="col109">slots</th>
          <th class="col110">clickeffect</th>
          <th class="col111">spellshield</th>
          <th class="col112">strikethrough</th>
          <th class="col113">stunresist</th>
          <th class="col114">summonedflag</th>
          <th class="col115">tradeskills</th>
          <th class="col116">favor</th>
          <th class="col117">weight</th>
          <th class="col118">UNK012</th>
          <th class="col119">UNK013</th>
          <th class="col120">benefitflag</th>
          <th class="col121">UNK054</th>
          <th class="col122">UNK059</th>
          <th class="col123">booktype</th>
          <th class="col124">recastdelay</th>
          <th class="col125">recasttype</th>
          <th class="col126">guildfavor</th>
          <th class="col127">UNK123</th>
          <th class="col128">UNK124</th>
          <th class="col129">attuneable</th>
          <th class="col130">nopet</th>
          <th class="col131">updated</th>
          <th class="col132">comment</th>
          <th class="col133">UNK127</th>
          <th class="col134">pointtype</th>
          <th class="col135">potionbelt</th>
          <th class="col136">potionbeltslots</th>
          <th class="col137">stacksize</th>
          <th class="col138">notransfer</th>
          <th class="col139">stackable</th>
          <th class="col140">UNK134</th>
          <th class="col141">UNK137</th>
          <th class="col142">proceffect</th>
          <th class="col143">proctype</th>
          <th class="col144">proclevel2</th>
          <th class="col145">proclevel</th>
          <th class="col146">UNK142</th>
          <th class="col147">worneffect</th>
          <th class="col148">worntype</th>
          <th class="col149">wornlevel2</th>
          <th class="col150">wornlevel</th>
          <th class="col151">UNK147</th>
          <th class="col152">focustype</th>
          <th class="col153">focuslevel2</th>
          <th class="col154">focuslevel</th>
          <th class="col155">UNK152</th>
          <th class="col156">scrolleffect</th>
          <th class="col157">scrolltype</th>
          <th class="col158">scrolllevel2</th>
          <th class="col159">scrolllevel</th>
          <th class="col160">UNK157</th>
          <th class="col161">serialized</th>
          <th class="col162">verified</th>
          <th class="col163">serialization</th>
          <th class="col164">source</th>
          <th class="col165">UNK033</th>
          <th class="col166">lorefile</th>
          <th class="col167">UNK014</th>
          <th class="col168">svcorruption</th>
          <th class="col169">UNK038</th>
          <th class="col170">UNK060</th>
          <th class="col171">augslot1unk2</th>
          <th class="col172">augslot2unk2</th>
          <th class="col173">augslot3unk2</th>
          <th class="col174">augslot4unk2</th>
          <th class="col175">augslot5unk2</th>
          <th class="col176">UNK120</th>
          <th class="col177">UNK121</th>
          <th class="col178">questitemflag</th>
          <th class="col179">UNK132</th>
          <th class="col180">clickunk5</th>
          <th class="col181">clickunk6</th>
          <th class="col182">clickunk7</th>
          <th class="col183">procunk1</th>
          <th class="col184">procunk2</th>
          <th class="col185">procunk3</th>
          <th class="col186">procunk4</th>
          <th class="col187">procunk6</th>
          <th class="col188">procunk7</th>
          <th class="col189">wornunk1</th>
          <th class="col190">wornunk2</th>
          <th class="col191">wornunk3</th>
          <th class="col192">wornunk4</th>
          <th class="col193">wornunk5</th>
          <th class="col194">wornunk6</th>
          <th class="col195">wornunk7</th>
          <th class="col196">focusunk1</th>
          <th class="col197">focusunk2</th>
          <th class="col198">focusunk3</th>
          <th class="col199">focusunk4</th>
          <th class="col200">focusunk5</th>
          <th class="col201">focusunk6</th>
          <th class="col202">focusunk7</th>
          <th class="col203">scrollunk1</th>
          <th class="col204">scrollunk2</th>
          <th class="col205">scrollunk3</th>
          <th class="col206">scrollunk4</th>
          <th class="col207">scrollunk5</th>
          <th class="col208">scrollunk6</th>
          <th class="col209">scrollunk7</th>
          <th class="col210">UNK193</th>
          <th class="col211">purity</th>
          <th class="col212">evolvinglevel</th>
          <th class="col213">clickname</th>
          <th class="col214">procname</th>
          <th class="col215">wornname</th>
          <th class="col216">focusname</th>
          <th class="col217">scrollname</th>
          <th class="col218">dsmitigation</th>
          <th class="col219">heroic_str</th>
          <th class="col220">heroic_int</th>
          <th class="col221">heroic_wis</th>
          <th class="col222">heroic_agi</th>
          <th class="col223">heroic_dex</th>
          <th class="col224">heroic_sta</th>
          <th class="col225">heroic_cha</th>
          <th class="col226">heroic_pr</th>
          <th class="col227">heroic_dr</th>
          <th class="col228">heroic_fr</th>
          <th class="col229">heroic_cr</th>
          <th class="col230">heroic_mr</th>
          <th class="col231">heroic_svcorrup</th>
          <th class="col232">healamt</th>
          <th class="col233">spelldmg</th>
          <th class="col234">clairvoyance</th>
          <th class="col235">backstabdmg</th>
          <th class="col236">created</th>
          <th class="col237">elitematerial</th>
          <th class="col238">ldonsellbackrate</th>
          <th class="col239">scriptfileid</th>
          <th class="col240">expendablearrow</th>
          <th class="col241">powersourcecapacity</th>
          <th class="col242">bardeffect</th>
          <th class="col243">bardeffecttype</th>
          <th class="col244">bardlevel2</th>
          <th class="col245">bardlevel</th>
          <th class="col246">bardunk1</th>
          <th class="col247">bardunk2</th>
          <th class="col248">bardunk3</th>
          <th class="col249">bardunk4</th>
          <th class="col250">bardunk5</th>
          <th class="col251">bardname</th>
          <th class="col252">bardunk7</th>
          <th class="col253">UNK214</th>
        </tr>
      </thead>
      <tbody>
        <tr>
          <td class="col0">1003</td>
          <td class="col1">0</td>
          <td class="col2">Sword</td>
          <td class="col3">0</td>
          <td class="col4">0</td>
          <td class="col5">0</td>
          <td class="col6">0</td>
          <td class="col7">0</td>
          <td class="col8">0</td>
          <td class="col9">0</td>
          <td class="col10">0</td>
          <td class="col11">0</td>
          <td class="col12">0</td>
          <td class="col13">0</td>
          <td class="col14">1</td>
          <td class="col15">0</td>
          <td class="col16">0</td>
          <td class="col17">0</td>
          <td class="col18">0</td>
          <td class="col19">(NULL)</td>
          <td class="col20">0</td>
          <td class="col21">(NULL)</td>
          <td class="col22">0</td>
          <td class="col23">(NULL)</td>
          <td class="col24">0</td>
          <td class="col25">0</td>
          <td class="col26">0</td>
          <td class="col27">1</td>
          <td class="col28">0</td>
          <td class="col29">0</td>
          <td class="col30">0</td>
          <td class="col31">0</td>
          <td class="col32">0</td>
          <td class="col33">0</td>
          <td class="col34">0</td>
          <td class="col35">0</td>
          <td class="col36">0</td>
          <td class="col37">0</td>
          <td class="col38">0</td>
          <td class="col39">0</td>
          <td class="col40"></td>
          <td class="col41"></td>
          <td class="col42">0</td>
          <td class="col43">0</td>
          <td class="col44"></td>
          <td class="col45">0</td>
          <td class="col46">0</td>
          <td class="col47">0</td>
          <td class="col48">0</td>
          <td class="col49">12</td>
          <td class="col50">0</td>
          <td class="col51">0</td>
          <td class="col52">20</td>
          <td class="col53">0</td>
          <td class="col54">0</td>
          <td class="col55">0</td>
          <td class="col56">0</td>
          <td class="col57">0</td>
          <td class="col58">0</td>
          <td class="col59">0</td>
          <td class="col60">0</td>
          <td class="col61">0</td>
          <td class="col62">0</td>
          <td class="col63">0</td>
          <td class="col64">0</td>
          <td class="col65">0</td>
          <td class="col66">0</td>
          <td class="col67">0</td>
          <td class="col68">0</td>
          <td class="col69"></td>
          <td class="col70">0</td>
          <td class="col71">0</td>
          <td class="col72">0</td>
          <td class="col73">0</td>
          <td class="col74">0</td>
          <td class="col75">0</td>
          <td class="col76">0</td>
          <td class="col77">550</td>
          <td class="col78">IT63</td>
          <td class="col79">0</td>
          <td class="col80">0</td>
          <td class="col81">0</td>
          <td class="col82">0</td>
          <td class="col83">0</td>
          <td class="col84">0</td>
          <td class="col85">Wrong.</td>
          <td class="col86">0</td>
          <td class="col87">0</td>
          <td class="col88">0</td>
          <td class="col89">0</td>
          <td class="col90">0</td>
          <td class="col91">0</td>
          <td class="col92">0</td>
          <td class="col93">0</td>
          <td class="col94">0</td>
          <td class="col95">255</td>
          <td class="col96">0</td>
          <td class="col97">0</td>
          <td class="col98">0</td>
          <td class="col99">0</td>
          <td class="col100">0</td>
          <td class="col101">0</td>
          <td class="col102">0</td>
          <td class="col103">0</td>
          <td class="col104">0</td>
          <td class="col105">0</td>
          <td class="col106">0</td>
          <td class="col107">0</td>
          <td class="col108">0</td>
          <td class="col109">16384</td>
          <td class="col110">0</td>
          <td class="col111">0</td>
          <td class="col112">0</td>
          <td class="col113">0</td>
          <td class="col114">0</td>
          <td class="col115">0</td>
          <td class="col116">0</td>
          <td class="col117">0</td>
          <td class="col118">0</td>
          <td class="col119">0</td>
          <td class="col120">0</td>
          <td class="col121">0</td>
          <td class="col122">0</td>
          <td class="col123">0</td>
          <td class="col124">0</td>
          <td class="col125">0</td>
          <td class="col126">0</td>
          <td class="col127">0</td>
          <td class="col128">0</td>
          <td class="col129">0</td>
          <td class="col130">0</td>
          <td class="col131">0000-00-00 00:00:00</td>
          <td class="col132"></td>
          <td class="col133">0</td>
          <td class="col134">0</td>
          <td class="col135">0</td>
          <td class="col136">0</td>
          <td class="col137">0</td>
          <td class="col138">0</td>
          <td class="col139">0</td>
          <td class="col140"></td>
          <td class="col141">0</td>
          <td class="col142">0</td>
          <td class="col143">0</td>
          <td class="col144">0</td>
          <td class="col145">0</td>
          <td class="col146">0</td>
          <td class="col147">0</td>
          <td class="col148">0</td>
          <td class="col149">0</td>
          <td class="col150">0</td>
          <td class="col151">0</td>
          <td class="col152">0</td>
          <td class="col153">0</td>
          <td class="col154">0</td>
          <td class="col155">0</td>
          <td class="col156">0</td>
          <td class="col157">0</td>
          <td class="col158">0</td>
          <td class="col159">0</td>
          <td class="col160">0</td>
          <td class="col161">(NULL)</td>
          <td class="col162">(NULL)</td>
          <td class="col163">(NULL)</td>
          <td class="col164"></td>
          <td class="col165">0</td>
          <td class="col166"></td>
          <td class="col167">0</td>
          <td class="col168">0</td>
          <td class="col169">0</td>
          <td class="col170">0</td>
          <td class="col171">0</td>
          <td class="col172">0</td>
          <td class="col173">0</td>
          <td class="col174">0</td>
          <td class="col175">0</td>
          <td class="col176">0</td>
          <td class="col177">0</td>
          <td class="col178">0</td>
          <td class="col179"></td>
          <td class="col180">0</td>
          <td class="col181"></td>
          <td class="col182">0</td>
          <td class="col183">0</td>
          <td class="col184">0</td>
          <td class="col185">0</td>
          <td class="col186">0</td>
          <td class="col187"></td>
          <td class="col188">0</td>
          <td class="col189">0</td>
          <td class="col190">0</td>
          <td class="col191">0</td>
          <td class="col192">0</td>
          <td class="col193">0</td>
          <td class="col194"></td>
          <td class="col195">0</td>
          <td class="col196">0</td>
          <td class="col197">0</td>
          <td class="col198">0</td>
          <td class="col199">0</td>
          <td class="col200">0</td>
          <td class="col201"></td>
          <td class="col202">0</td>
          <td class="col203">0</td>
          <td class="col204">0</td>
          <td class="col205">0</td>
          <td class="col206">0</td>
          <td class="col207">0</td>
          <td class="col208"></td>
          <td class="col209">0</td>
          <td class="col210">0</td>
          <td class="col211">0</td>
          <td class="col212">0</td>
          <td class="col213"></td>
          <td class="col214"></td>
          <td class="col215"></td>
          <td class="col216"></td>
          <td class="col217"></td>
          <td class="col218">0</td>
          <td class="col219">0</td>
          <td class="col220">0</td>
          <td class="col221">0</td>
          <td class="col222">0</td>
          <td class="col223">0</td>
          <td class="col224">0</td>
          <td class="col225">0</td>
          <td class="col226">0</td>
          <td class="col227">0</td>
          <td class="col228">0</td>
          <td class="col229">0</td>
          <td class="col230">0</td>
          <td class="col231">0</td>
          <td class="col232">0</td>
          <td class="col233">0</td>
          <td class="col234">0</td>
          <td class="col235">0</td>
          <td class="col236"></td>
          <td class="col237">0</td>
          <td class="col238">0</td>
          <td class="col239">0</td>
          <td class="col240">0</td>
          <td class="col241">0</td>
          <td class="col242">0</td>
          <td class="col243">0</td>
          <td class="col244">0</td>
          <td class="col245">0</td>
          <td class="col246">0</td>
          <td class="col247">0</td>
          <td class="col248">0</td>
          <td class="col249">0</td>
          <td class="col250">0</td>
          <td class="col251"></td>
          <td class="col252">0</td>
          <td class="col253">0</td>
        </tr>
      </tbody>
    </table>

    <p>
      <em>generated 2011-06-17 03:47:25      by <a href="http://www.heidisql.com/">HeidiSQL 6.0.0.3603</a></em>
    </p>

  </body>
</html>

PS. I'm a little new to this database thing, but I'm a fast enough learner. I could not find any item creator tools, simply item editor tools. In other words, I could copy items, but once I unfortunately deleted all of them, I couldn't make any from there without the proper data.

Thanks guys

comicmess · #2 06-17-2011, 04:01 PM

Sorry for the double post, but I just realized that I probably posted this in the wrong subforum. I do apologize for the inconvenience :\

EDIT: As an example, though, here is the info I have for a cloth cap, yet it's still not working. Am I missing a piece of data here?

HTML Code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>
  <head>
    <title>items</title>
    <meta name="GENERATOR" content="HeidiSQL 6.0.0.3603">
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <style type="text/css">
      thead tr {background-color: ActiveCaption; color: CaptionText;}
      th, td {vertical-align: top; font-family: "Tahoma"; font-size: 8pt; padding: 3px; }
      table, td {border: 1px solid silver;}
      table {border-collapse: collapse;}
      thead .col0 {width: 64px;}
      .col0 {text-align: right;}
      thead .col1 {width: 94px;}
      .col1 {text-align: right;}
      thead .col2 {width: 82px;}
      thead .col3 {width: 48px;}
      .col3 {text-align: right;}
      thead .col4 {width: 42px;}
      .col4 {text-align: right;}
      thead .col5 {width: 71px;}
      .col5 {text-align: right;}
      thead .col6 {width: 51px;}
      .col6 {text-align: right;}
      thead .col7 {width: 52px;}
      .col7 {text-align: right;}
      thead .col8 {width: 46px;}
      .col8 {text-align: right;}
      thead .col9 {width: 81px;}
      .col9 {text-align: right;}
      thead .col10 {width: 49px;}
      .col10 {text-align: right;}
      thead .col11 {width: 47px;}
      .col11 {text-align: right;}
      thead .col12 {width: 58px;}
      .col12 {text-align: right;}
      thead .col13 {width: 80px;}
      .col13 {text-align: right;}
      thead .col14 {width: 91px;}
      .col14 {text-align: right;}
      thead .col15 {width: 98px;}
      .col15 {text-align: right;}
      thead .col16 {width: 91px;}
      .col16 {text-align: right;}
      thead .col17 {width: 98px;}
      .col17 {text-align: right;}
      thead .col18 {width: 91px;}
      .col18 {text-align: right;}
      thead .col19 {width: 98px;}
      .col19 {text-align: right;}
      thead .col20 {width: 91px;}
      .col20 {text-align: right;}
      thead .col21 {width: 98px;}
      .col21 {text-align: right;}
      thead .col22 {width: 91px;}
      .col22 {text-align: right;}
      thead .col23 {width: 98px;}
      .col23 {text-align: right;}
      thead .col24 {width: 68px;}
      .col24 {text-align: right;}
      thead .col25 {width: 77px;}
      .col25 {text-align: right;}
      thead .col26 {width: 49px;}
      .col26 {text-align: right;}
      thead .col27 {width: 64px;}
      .col27 {text-align: right;}
      thead .col28 {width: 68px;}
      .col28 {text-align: right;}
      thead .col29 {width: 68px;}
      .col29 {text-align: right;}
      thead .col30 {width: 58px;}
      .col30 {text-align: right;}
      thead .col31 {width: 90px;}
      .col31 {text-align: right;}
      thead .col32 {width: 111px;}
      .col32 {text-align: right;}
      thead .col33 {width: 96px;}
      .col33 {text-align: right;}
      thead .col34 {width: 93px;}
      .col34 {text-align: right;}
      thead .col35 {width: 72px;}
      .col35 {text-align: right;}
      thead .col36 {width: 76px;}
      .col36 {text-align: right;}
      thead .col37 {width: 51px;}
      .col37 {text-align: right;}
      thead .col38 {width: 68px;}
      .col38 {text-align: right;}
      thead .col39 {width: 74px;}
      .col39 {text-align: right;}
      thead .col40 {width: 71px;}
      thead .col41 {width: 79px;}
      thead .col42 {width: 66px;}
      .col42 {text-align: right;}
      thead .col43 {width: 95px;}
      .col43 {text-align: right;}
      thead .col44 {width: 97px;}
      thead .col45 {width: 90px;}
      .col45 {text-align: right;}
      thead .col46 {width: 92px;}
      .col46 {text-align: right;}
      thead .col47 {width: 54px;}
      .col47 {text-align: right;}
      thead .col48 {width: 42px;}
      .col48 {text-align: right;}
      thead .col49 {width: 66px;}
      .col49 {text-align: right;}
      thead .col50 {width: 93px;}
      .col50 {text-align: right;}
      thead .col51 {width: 52px;}
      .col51 {text-align: right;}
      thead .col52 {width: 54px;}
      .col52 {text-align: right;}
      thead .col53 {width: 79px;}
      .col53 {text-align: right;}
      thead .col54 {width: 85px;}
      .col54 {text-align: right;}
      thead .col55 {width: 42px;}
      .col55 {text-align: right;}
      thead .col56 {width: 69px;}
      .col56 {text-align: right;}
      thead .col57 {width: 75px;}
      .col57 {text-align: right;}
      thead .col58 {width: 92px;}
      .col58 {text-align: right;}
      thead .col59 {width: 88px;}
      .col59 {text-align: right;}
      thead .col60 {width: 56px;}
      .col60 {text-align: right;}
      thead .col61 {width: 85px;}
      .col61 {text-align: right;}
      thead .col62 {width: 85px;}
      .col62 {text-align: right;}
      thead .col63 {width: 85px;}
      .col63 {text-align: right;}
      thead .col64 {width: 85px;}
      .col64 {text-align: right;}
      thead .col65 {width: 87px;}
      .col65 {text-align: right;}
      thead .col66 {width: 87px;}
      .col66 {text-align: right;}
      thead .col67 {width: 87px;}
      .col67 {text-align: right;}
      thead .col68 {width: 87px;}
      .col68 {text-align: right;}
      thead .col69 {width: 68px;}
      thead .col70 {width: 83px;}
      .col70 {text-align: right;}
      thead .col71 {width: 42px;}
      .col71 {text-align: right;}
      thead .col72 {width: 72px;}
      .col72 {text-align: right;}
      thead .col73 {width: 55px;}
      .col73 {text-align: right;}
      thead .col74 {width: 69px;}
      .col74 {text-align: right;}
      thead .col75 {width: 42px;}
      .col75 {text-align: right;}
      thead .col76 {width: 56px;}
      .col76 {text-align: right;}
      thead .col77 {width: 54px;}
      .col77 {text-align: right;}
      thead .col78 {width: 57px;}
      thead .col79 {width: 71px;}
      .col79 {text-align: right;}
      thead .col80 {width: 70px;}
      .col80 {text-align: right;}
      thead .col81 {width: 71px;}
      .col81 {text-align: right;}
      thead .col82 {width: 78px;}
      .col82 {text-align: right;}
      thead .col83 {width: 67px;}
      .col83 {text-align: right;}
      thead .col84 {width: 48px;}
      .col84 {text-align: right;}
      thead .col85 {width: 82px;}
      thead .col86 {width: 74px;}
      .col86 {text-align: right;}
      thead .col87 {width: 55px;}
      .col87 {text-align: right;}
      thead .col88 {width: 54px;}
      .col88 {text-align: right;}
      thead .col89 {width: 82px;}
      .col89 {text-align: right;}
      thead .col90 {width: 107px;}
      .col90 {text-align: right;}
      thead .col91 {width: 66px;}
      .col91 {text-align: right;}
      thead .col92 {width: 86px;}
      .col92 {text-align: right;}
      thead .col93 {width: 42px;}
      .col93 {text-align: right;}
      thead .col94 {width: 62px;}
      .col94 {text-align: right;}
      thead .col95 {width: 60px;}
      .col95 {text-align: right;}
      thead .col96 {width: 102px;}
      .col96 {text-align: right;}
      thead .col97 {width: 42px;}
      .col97 {text-align: right;}
      thead .col98 {width: 69px;}
      .col98 {text-align: right;}
      thead .col99 {width: 54px;}
      .col99 {text-align: right;}
      thead .col100 {width: 56px;}
      .col100 {text-align: right;}
      thead .col101 {width: 65px;}
      .col101 {text-align: right;}
      thead .col102 {width: 59px;}
      .col102 {text-align: right;}
      thead .col103 {width: 66px;}
      .col103 {text-align: right;}
      thead .col104 {width: 63px;}
      .col104 {text-align: right;}
      thead .col105 {width: 69px;}
      .col105 {text-align: right;}
      thead .col106 {width: 46px;}
      .col106 {text-align: right;}
      thead .col107 {width: 86px;}
      .col107 {text-align: right;}
      thead .col108 {width: 90px;}
      .col108 {text-align: right;}
      thead .col109 {width: 66px;}
      .col109 {text-align: right;}
      thead .col110 {width: 76px;}
      .col110 {text-align: right;}
      thead .col111 {width: 76px;}
      .col111 {text-align: right;}
      thead .col112 {width: 92px;}
      .col112 {text-align: right;}
      thead .col113 {width: 75px;}
      .col113 {text-align: right;}
      thead .col114 {width: 97px;}
      .col114 {text-align: right;}
      thead .col115 {width: 75px;}
      .col115 {text-align: right;}
      thead .col116 {width: 54px;}
      .col116 {text-align: right;}
      thead .col117 {width: 60px;}
      .col117 {text-align: right;}
      thead .col118 {width: 66px;}
      .col118 {text-align: right;}
      thead .col119 {width: 66px;}
      .col119 {text-align: right;}
      thead .col120 {width: 80px;}
      .col120 {text-align: right;}
      thead .col121 {width: 66px;}
      .col121 {text-align: right;}
      thead .col122 {width: 66px;}
      .col122 {text-align: right;}
      thead .col123 {width: 73px;}
      .col123 {text-align: right;}
      thead .col124 {width: 84px;}
      .col124 {text-align: right;}
      thead .col125 {width: 80px;}
      .col125 {text-align: right;}
      thead .col126 {width: 76px;}
      .col126 {text-align: right;}
      thead .col127 {width: 66px;}
      .col127 {text-align: right;}
      thead .col128 {width: 66px;}
      .col128 {text-align: right;}
      thead .col129 {width: 80px;}
      .col129 {text-align: right;}
      thead .col130 {width: 56px;}
      .col130 {text-align: right;}
      thead .col131 {width: 138px;}
      thead .col132 {width: 71px;}
      thead .col133 {width: 66px;}
      .col133 {text-align: right;}
      thead .col134 {width: 74px;}
      .col134 {text-align: right;}
      thead .col135 {width: 76px;}
      .col135 {text-align: right;}
      thead .col136 {width: 98px;}
      .col136 {text-align: right;}
      thead .col137 {width: 71px;}
      .col137 {text-align: right;}
      thead .col138 {width: 79px;}
      .col138 {text-align: right;}
      thead .col139 {width: 73px;}
      .col139 {text-align: right;}
      thead .col140 {width: 66px;}
      thead .col141 {width: 66px;}
      .col141 {text-align: right;}
      thead .col142 {width: 78px;}
      .col142 {text-align: right;}
      thead .col143 {width: 71px;}
      .col143 {text-align: right;}
      thead .col144 {width: 77px;}
      .col144 {text-align: right;}
      thead .col145 {width: 71px;}
      .col145 {text-align: right;}
      thead .col146 {width: 66px;}
      .col146 {text-align: right;}
      thead .col147 {width: 81px;}
      .col147 {text-align: right;}
      thead .col148 {width: 74px;}
      .col148 {text-align: right;}
      thead .col149 {width: 80px;}
      .col149 {text-align: right;}
      thead .col150 {width: 74px;}
      .col150 {text-align: right;}
      thead .col151 {width: 66px;}
      .col151 {text-align: right;}
      thead .col152 {width: 76px;}
      .col152 {text-align: right;}
      thead .col153 {width: 82px;}
      .col153 {text-align: right;}
      thead .col154 {width: 76px;}
      .col154 {text-align: right;}
      thead .col155 {width: 66px;}
      .col155 {text-align: right;}
      thead .col156 {width: 81px;}
      .col156 {text-align: right;}
      thead .col157 {width: 74px;}
      .col157 {text-align: right;}
      thead .col158 {width: 80px;}
      .col158 {text-align: right;}
      thead .col159 {width: 74px;}
      .col159 {text-align: right;}
      thead .col160 {width: 66px;}
      .col160 {text-align: right;}
      thead .col161 {width: 72px;}
      thead .col162 {width: 129px;}
      thead .col163 {width: 84px;}
      thead .col164 {width: 60px;}
      thead .col165 {width: 66px;}
      .col165 {text-align: right;}
      thead .col166 {width: 60px;}
      thead .col167 {width: 66px;}
      .col167 {text-align: right;}
      thead .col168 {width: 88px;}
      .col168 {text-align: right;}
      thead .col169 {width: 66px;}
      .col169 {text-align: right;}
      thead .col170 {width: 66px;}
      .col170 {text-align: right;}
      thead .col171 {width: 92px;}
      .col171 {text-align: right;}
      thead .col172 {width: 92px;}
      .col172 {text-align: right;}
      thead .col173 {width: 92px;}
      .col173 {text-align: right;}
      thead .col174 {width: 92px;}
      .col174 {text-align: right;}
      thead .col175 {width: 92px;}
      .col175 {text-align: right;}
      thead .col176 {width: 66px;}
      .col176 {text-align: right;}
      thead .col177 {width: 66px;}
      .col177 {text-align: right;}
      thead .col178 {width: 93px;}
      .col178 {text-align: right;}
      thead .col179 {width: 66px;}
      thead .col180 {width: 70px;}
      .col180 {text-align: right;}
      thead .col181 {width: 70px;}
      thead .col182 {width: 70px;}
      .col182 {text-align: right;}
      thead .col183 {width: 72px;}
      .col183 {text-align: right;}
      thead .col184 {width: 72px;}
      .col184 {text-align: right;}
      thead .col185 {width: 72px;}
      .col185 {text-align: right;}
      thead .col186 {width: 72px;}
      .col186 {text-align: right;}
      thead .col187 {width: 72px;}
      thead .col188 {width: 72px;}
      .col188 {text-align: right;}
      thead .col189 {width: 75px;}
      .col189 {text-align: right;}
      thead .col190 {width: 75px;}
      .col190 {text-align: right;}
      thead .col191 {width: 75px;}
      .col191 {text-align: right;}
      thead .col192 {width: 75px;}
      .col192 {text-align: right;}
      thead .col193 {width: 75px;}
      .col193 {text-align: right;}
      thead .col194 {width: 75px;}
      thead .col195 {width: 75px;}
      .col195 {text-align: right;}
      thead .col196 {width: 77px;}
      .col196 {text-align: right;}
      thead .col197 {width: 77px;}
      .col197 {text-align: right;}
      thead .col198 {width: 77px;}
      .col198 {text-align: right;}
      thead .col199 {width: 77px;}
      .col199 {text-align: right;}
      thead .col200 {width: 77px;}
      .col200 {text-align: right;}
      thead .col201 {width: 77px;}
      thead .col202 {width: 77px;}
      .col202 {text-align: right;}
      thead .col203 {width: 75px;}
      .col203 {text-align: right;}
      thead .col204 {width: 75px;}
      .col204 {text-align: right;}
      thead .col205 {width: 75px;}
      .col205 {text-align: right;}
      thead .col206 {width: 75px;}
      .col206 {text-align: right;}
      thead .col207 {width: 75px;}
      .col207 {text-align: right;}
      thead .col208 {width: 75px;}
      thead .col209 {width: 75px;}
      .col209 {text-align: right;}
      thead .col210 {width: 66px;}
      .col210 {text-align: right;}
      thead .col211 {width: 56px;}
      .col211 {text-align: right;}
      thead .col212 {width: 90px;}
      .col212 {text-align: right;}
      thead .col213 {width: 73px;}
      thead .col214 {width: 75px;}
      thead .col215 {width: 78px;}
      thead .col216 {width: 80px;}
      thead .col217 {width: 78px;}
      thead .col218 {width: 85px;}
      .col218 {text-align: right;}
      thead .col219 {width: 76px;}
      .col219 {text-align: right;}
      thead .col220 {width: 75px;}
      .col220 {text-align: right;}
      thead .col221 {width: 78px;}
      .col221 {text-align: right;}
      thead .col222 {width: 77px;}
      .col222 {text-align: right;}
      thead .col223 {width: 81px;}
      .col223 {text-align: right;}
      thead .col224 {width: 78px;}
      .col224 {text-align: right;}
      thead .col225 {width: 80px;}
      .col225 {text-align: right;}
      thead .col226 {width: 73px;}
      .col226 {text-align: right;}
      thead .col227 {width: 73px;}
      .col227 {text-align: right;}
      thead .col228 {width: 71px;}
      .col228 {text-align: right;}
      thead .col229 {width: 72px;}
      .col229 {text-align: right;}
      thead .col230 {width: 75px;}
      .col230 {text-align: right;}
      thead .col231 {width: 105px;}
      .col231 {text-align: right;}
      thead .col232 {width: 66px;}
      .col232 {text-align: right;}
      thead .col233 {width: 69px;}
      .col233 {text-align: right;}
      thead .col234 {width: 88px;}
      .col234 {text-align: right;}
      thead .col235 {width: 91px;}
      .col235 {text-align: right;}
      thead .col236 {width: 65px;}
      thead .col237 {width: 86px;}
      .col237 {text-align: right;}
      thead .col238 {width: 105px;}
      .col238 {text-align: right;}
      thead .col239 {width: 76px;}
      .col239 {text-align: right;}
      thead .col240 {width: 112px;}
      .col240 {text-align: right;}
      thead .col241 {width: 130px;}
      .col241 {text-align: right;}
      thead .col242 {width: 79px;}
      .col242 {text-align: right;}
      thead .col243 {width: 101px;}
      .col243 {text-align: right;}
      thead .col244 {width: 78px;}
      .col244 {text-align: right;}
      thead .col245 {width: 72px;}
      .col245 {text-align: right;}
      thead .col246 {width: 73px;}
      .col246 {text-align: right;}
      thead .col247 {width: 73px;}
      .col247 {text-align: right;}
      thead .col248 {width: 73px;}
      .col248 {text-align: right;}
      thead .col249 {width: 73px;}
      .col249 {text-align: right;}
      thead .col250 {width: 73px;}
      .col250 {text-align: right;}
      thead .col251 {width: 76px;}
      thead .col252 {width: 73px;}
      .col252 {text-align: right;}
      thead .col253 {width: 66px;}
      .col253 {text-align: right;}
    </style>
  </head>

  <body>

    <table caption="items (1 rows)">
      <thead>
        <tr>
          <th class="col0">id</th>
          <th class="col1">minstatus</th>
          <th class="col2">Name</th>
          <th class="col3">aagi</th>
          <th class="col4">ac</th>
          <th class="col5">accuracy</th>
          <th class="col6">acha</th>
          <th class="col7">adex</th>
          <th class="col8">aint</th>
          <th class="col9">artifactflag</th>
          <th class="col10">asta</th>
          <th class="col11">astr</th>
          <th class="col12">attack</th>
          <th class="col13">augrestrict</th>
          <th class="col14">augslot1type</th>
          <th class="col15">augslot1visible</th>
          <th class="col16">augslot2type</th>
          <th class="col17">augslot2visible</th>
          <th class="col18">augslot3type</th>
          <th class="col19">augslot3visible</th>
          <th class="col20">augslot4type</th>
          <th class="col21">augslot4visible</th>
          <th class="col22">augslot5type</th>
          <th class="col23">augslot5visible</th>
          <th class="col24">augtype</th>
          <th class="col25">avoidance</th>
          <th class="col26">awis</th>
          <th class="col27">bagsize</th>
          <th class="col28">bagslots</th>
          <th class="col29">bagtype</th>
          <th class="col30">bagwr</th>
          <th class="col31">banedmgamt</th>
          <th class="col32">banedmgraceamt</th>
          <th class="col33">banedmgbody</th>
          <th class="col34">banedmgrace</th>
          <th class="col35">bardtype</th>
          <th class="col36">bardvalue</th>
          <th class="col37">book</th>
          <th class="col38">casttime</th>
          <th class="col39">casttime_</th>
          <th class="col40">charmfile</th>
          <th class="col41">charmfileid</th>
          <th class="col42">classes</th>
          <th class="col43">color</th>
          <th class="col44">combateffects</th>
          <th class="col45">extradmgskill</th>
          <th class="col46">extradmgamt</th>
          <th class="col47">price</th>
          <th class="col48">cr</th>
          <th class="col49">damage</th>
          <th class="col50">damageshield</th>
          <th class="col51">deity</th>
          <th class="col52">delay</th>
          <th class="col53">augdistiller</th>
          <th class="col54">dotshielding</th>
          <th class="col55">dr</th>
          <th class="col56">clicktype</th>
          <th class="col57">clicklevel2</th>
          <th class="col58">elemdmgtype</th>
          <th class="col59">elemdmgamt</th>
          <th class="col60">endur</th>
          <th class="col61">factionamt1</th>
          <th class="col62">factionamt2</th>
          <th class="col63">factionamt3</th>
          <th class="col64">factionamt4</th>
          <th class="col65">factionmod1</th>
          <th class="col66">factionmod2</th>
          <th class="col67">factionmod3</th>
          <th class="col68">factionmod4</th>
          <th class="col69">filename</th>
          <th class="col70">focuseffect</th>
          <th class="col71">fr</th>
          <th class="col72">fvnodrop</th>
          <th class="col73">haste</th>
          <th class="col74">clicklevel</th>
          <th class="col75">hp</th>
          <th class="col76">regen</th>
          <th class="col77">icon</th>
          <th class="col78">idfile</th>
          <th class="col79">itemclass</th>
          <th class="col80">itemtype</th>
          <th class="col81">ldonprice</th>
          <th class="col82">ldontheme</th>
          <th class="col83">ldonsold</th>
          <th class="col84">light</th>
          <th class="col85">lore</th>
          <th class="col86">loregroup</th>
          <th class="col87">magic</th>
          <th class="col88">mana</th>
          <th class="col89">manaregen</th>
          <th class="col90">enduranceregen</th>
          <th class="col91">material</th>
          <th class="col92">maxcharges</th>
          <th class="col93">mr</th>
          <th class="col94">nodrop</th>
          <th class="col95">norent</th>
          <th class="col96">pendingloreflag</th>
          <th class="col97">pr</th>
          <th class="col98">procrate</th>
          <th class="col99">races</th>
          <th class="col100">range</th>
          <th class="col101">reclevel</th>
          <th class="col102">recskill</th>
          <th class="col103">reqlevel</th>
          <th class="col104">sellrate</th>
          <th class="col105">shielding</th>
          <th class="col106">size</th>
          <th class="col107">skillmodtype</th>
          <th class="col108">skillmodvalue</th>
          <th class="col109">slots</th>
          <th class="col110">clickeffect</th>
          <th class="col111">spellshield</th>
          <th class="col112">strikethrough</th>
          <th class="col113">stunresist</th>
          <th class="col114">summonedflag</th>
          <th class="col115">tradeskills</th>
          <th class="col116">favor</th>
          <th class="col117">weight</th>
          <th class="col118">UNK012</th>
          <th class="col119">UNK013</th>
          <th class="col120">benefitflag</th>
          <th class="col121">UNK054</th>
          <th class="col122">UNK059</th>
          <th class="col123">booktype</th>
          <th class="col124">recastdelay</th>
          <th class="col125">recasttype</th>
          <th class="col126">guildfavor</th>
          <th class="col127">UNK123</th>
          <th class="col128">UNK124</th>
          <th class="col129">attuneable</th>
          <th class="col130">nopet</th>
          <th class="col131">updated</th>
          <th class="col132">comment</th>
          <th class="col133">UNK127</th>
          <th class="col134">pointtype</th>
          <th class="col135">potionbelt</th>
          <th class="col136">potionbeltslots</th>
          <th class="col137">stacksize</th>
          <th class="col138">notransfer</th>
          <th class="col139">stackable</th>
          <th class="col140">UNK134</th>
          <th class="col141">UNK137</th>
          <th class="col142">proceffect</th>
          <th class="col143">proctype</th>
          <th class="col144">proclevel2</th>
          <th class="col145">proclevel</th>
          <th class="col146">UNK142</th>
          <th class="col147">worneffect</th>
          <th class="col148">worntype</th>
          <th class="col149">wornlevel2</th>
          <th class="col150">wornlevel</th>
          <th class="col151">UNK147</th>
          <th class="col152">focustype</th>
          <th class="col153">focuslevel2</th>
          <th class="col154">focuslevel</th>
          <th class="col155">UNK152</th>
          <th class="col156">scrolleffect</th>
          <th class="col157">scrolltype</th>
          <th class="col158">scrolllevel2</th>
          <th class="col159">scrolllevel</th>
          <th class="col160">UNK157</th>
          <th class="col161">serialized</th>
          <th class="col162">verified</th>
          <th class="col163">serialization</th>
          <th class="col164">source</th>
          <th class="col165">UNK033</th>
          <th class="col166">lorefile</th>
          <th class="col167">UNK014</th>
          <th class="col168">svcorruption</th>
          <th class="col169">UNK038</th>
          <th class="col170">UNK060</th>
          <th class="col171">augslot1unk2</th>
          <th class="col172">augslot2unk2</th>
          <th class="col173">augslot3unk2</th>
          <th class="col174">augslot4unk2</th>
          <th class="col175">augslot5unk2</th>
          <th class="col176">UNK120</th>
          <th class="col177">UNK121</th>
          <th class="col178">questitemflag</th>
          <th class="col179">UNK132</th>
          <th class="col180">clickunk5</th>
          <th class="col181">clickunk6</th>
          <th class="col182">clickunk7</th>
          <th class="col183">procunk1</th>
          <th class="col184">procunk2</th>
          <th class="col185">procunk3</th>
          <th class="col186">procunk4</th>
          <th class="col187">procunk6</th>
          <th class="col188">procunk7</th>
          <th class="col189">wornunk1</th>
          <th class="col190">wornunk2</th>
          <th class="col191">wornunk3</th>
          <th class="col192">wornunk4</th>
          <th class="col193">wornunk5</th>
          <th class="col194">wornunk6</th>
          <th class="col195">wornunk7</th>
          <th class="col196">focusunk1</th>
          <th class="col197">focusunk2</th>
          <th class="col198">focusunk3</th>
          <th class="col199">focusunk4</th>
          <th class="col200">focusunk5</th>
          <th class="col201">focusunk6</th>
          <th class="col202">focusunk7</th>
          <th class="col203">scrollunk1</th>
          <th class="col204">scrollunk2</th>
          <th class="col205">scrollunk3</th>
          <th class="col206">scrollunk4</th>
          <th class="col207">scrollunk5</th>
          <th class="col208">scrollunk6</th>
          <th class="col209">scrollunk7</th>
          <th class="col210">UNK193</th>
          <th class="col211">purity</th>
          <th class="col212">evolvinglevel</th>
          <th class="col213">clickname</th>
          <th class="col214">procname</th>
          <th class="col215">wornname</th>
          <th class="col216">focusname</th>
          <th class="col217">scrollname</th>
          <th class="col218">dsmitigation</th>
          <th class="col219">heroic_str</th>
          <th class="col220">heroic_int</th>
          <th class="col221">heroic_wis</th>
          <th class="col222">heroic_agi</th>
          <th class="col223">heroic_dex</th>
          <th class="col224">heroic_sta</th>
          <th class="col225">heroic_cha</th>
          <th class="col226">heroic_pr</th>
          <th class="col227">heroic_dr</th>
          <th class="col228">heroic_fr</th>
          <th class="col229">heroic_cr</th>
          <th class="col230">heroic_mr</th>
          <th class="col231">heroic_svcorrup</th>
          <th class="col232">healamt</th>
          <th class="col233">spelldmg</th>
          <th class="col234">clairvoyance</th>
          <th class="col235">backstabdmg</th>
          <th class="col236">created</th>
          <th class="col237">elitematerial</th>
          <th class="col238">ldonsellbackrate</th>
          <th class="col239">scriptfileid</th>
          <th class="col240">expendablearrow</th>
          <th class="col241">powersourcecapacity</th>
          <th class="col242">bardeffect</th>
          <th class="col243">bardeffecttype</th>
          <th class="col244">bardlevel2</th>
          <th class="col245">bardlevel</th>
          <th class="col246">bardunk1</th>
          <th class="col247">bardunk2</th>
          <th class="col248">bardunk3</th>
          <th class="col249">bardunk4</th>
          <th class="col250">bardunk5</th>
          <th class="col251">bardname</th>
          <th class="col252">bardunk7</th>
          <th class="col253">UNK214</th>
        </tr>
      </thead>
      <tbody>
        <tr>
          <td class="col0">456451</td>
          <td class="col1">0</td>
          <td class="col2">Cloth Cap</td>
          <td class="col3">0</td>
          <td class="col4">2</td>
          <td class="col5">0</td>
          <td class="col6">0</td>
          <td class="col7">0</td>
          <td class="col8">0</td>
          <td class="col9">0</td>
          <td class="col10">0</td>
          <td class="col11">0</td>
          <td class="col12">0</td>
          <td class="col13">0</td>
          <td class="col14">0</td>
          <td class="col15">0</td>
          <td class="col16">0</td>
          <td class="col17">0</td>
          <td class="col18">0</td>
          <td class="col19">1</td>
          <td class="col20">0</td>
          <td class="col21">1</td>
          <td class="col22">0</td>
          <td class="col23">1</td>
          <td class="col24">0</td>
          <td class="col25">0</td>
          <td class="col26">0</td>
          <td class="col27">0</td>
          <td class="col28">0</td>
          <td class="col29">0</td>
          <td class="col30">0</td>
          <td class="col31">0</td>
          <td class="col32">0</td>
          <td class="col33">0</td>
          <td class="col34">0</td>
          <td class="col35">0</td>
          <td class="col36">0</td>
          <td class="col37">0</td>
          <td class="col38">0</td>
          <td class="col39">0</td>
          <td class="col40"></td>
          <td class="col41"></td>
          <td class="col42">65535</td>
          <td class="col43">4278190080</td>
          <td class="col44"></td>
          <td class="col45">0</td>
          <td class="col46">0</td>
          <td class="col47">200</td>
          <td class="col48">0</td>
          <td class="col49">0</td>
          <td class="col50">0</td>
          <td class="col51">0</td>
          <td class="col52">0</td>
          <td class="col53">0</td>
          <td class="col54">0</td>
          <td class="col55">0</td>
          <td class="col56">0</td>
          <td class="col57">0</td>
          <td class="col58">0</td>
          <td class="col59">0</td>
          <td class="col60">0</td>
          <td class="col61">0</td>
          <td class="col62">0</td>
          <td class="col63">0</td>
          <td class="col64">0</td>
          <td class="col65">0</td>
          <td class="col66">0</td>
          <td class="col67">0</td>
          <td class="col68">0</td>
          <td class="col69"></td>
          <td class="col70">-1</td>
          <td class="col71">0</td>
          <td class="col72">0</td>
          <td class="col73">0</td>
          <td class="col74">0</td>
          <td class="col75">0</td>
          <td class="col76">0</td>
          <td class="col77">639</td>
          <td class="col78">IT63</td>
          <td class="col79">0</td>
          <td class="col80">10</td>
          <td class="col81">0</td>
          <td class="col82">0</td>
          <td class="col83">0</td>
          <td class="col84">0</td>
          <td class="col85">Cloth Cap</td>
          <td class="col86">0</td>
          <td class="col87">0</td>
          <td class="col88">0</td>
          <td class="col89">0</td>
          <td class="col90">0</td>
          <td class="col91">0</td>
          <td class="col92">0</td>
          <td class="col93">0</td>
          <td class="col94">1</td>
          <td class="col95">1</td>
          <td class="col96">0</td>
          <td class="col97">0</td>
          <td class="col98">0</td>
          <td class="col99">65535</td>
          <td class="col100">0</td>
          <td class="col101">0</td>
          <td class="col102">0</td>
          <td class="col103">0</td>
          <td class="col104">1</td>
          <td class="col105">0</td>
          <td class="col106">1</td>
          <td class="col107">-1</td>
          <td class="col108">0</td>
          <td class="col109">4</td>
          <td class="col110">-1</td>
          <td class="col111">0</td>
          <td class="col112">0</td>
          <td class="col113">0</td>
          <td class="col114">0</td>
          <td class="col115">0</td>
          <td class="col116">0</td>
          <td class="col117">2</td>
          <td class="col118">0</td>
          <td class="col119">0</td>
          <td class="col120">0</td>
          <td class="col121">0</td>
          <td class="col122">0</td>
          <td class="col123">0</td>
          <td class="col124">0</td>
          <td class="col125">0</td>
          <td class="col126">0</td>
          <td class="col127">0</td>
          <td class="col128">0</td>
          <td class="col129">0</td>
          <td class="col130">0</td>
          <td class="col131">0000-00-00 00:00:00</td>
          <td class="col132">Fix</td>
          <td class="col133">0</td>
          <td class="col134">0</td>
          <td class="col135">0</td>
          <td class="col136">0</td>
          <td class="col137">1</td>
          <td class="col138">0</td>
          <td class="col139">0</td>
          <td class="col140">0</td>
          <td class="col141">0</td>
          <td class="col142">-1</td>
          <td class="col143">0</td>
          <td class="col144">0</td>
          <td class="col145">0</td>
          <td class="col146">0</td>
          <td class="col147">-1</td>
          <td class="col148">0</td>
          <td class="col149">0</td>
          <td class="col150">0</td>
          <td class="col151">0</td>
          <td class="col152">0</td>
          <td class="col153">0</td>
          <td class="col154">0</td>
          <td class="col155">0</td>
          <td class="col156">-1</td>
          <td class="col157">0</td>
          <td class="col158">0</td>
          <td class="col159">0</td>
          <td class="col160">0</td>
          <td class="col161">(NULL)</td>
          <td class="col162">2011-06-17 13:49:32</td>
          <td class="col163">(NULL)</td>
          <td class="col164"></td>
          <td class="col165">0</td>
          <td class="col166"></td>
          <td class="col167">1</td>
          <td class="col168">0</td>
          <td class="col169">0</td>
          <td class="col170">0</td>
          <td class="col171">0</td>
          <td class="col172">0</td>
          <td class="col173">0</td>
          <td class="col174">0</td>
          <td class="col175">0</td>
          <td class="col176">-1</td>
          <td class="col177">0</td>
          <td class="col178">1</td>
          <td class="col179">0</td>
          <td class="col180">0</td>
          <td class="col181">0</td>
          <td class="col182">-1</td>
          <td class="col183">0</td>
          <td class="col184">0</td>
          <td class="col185">0</td>
          <td class="col186">0</td>
          <td class="col187">0</td>
          <td class="col188">-1</td>
          <td class="col189">0</td>
          <td class="col190">0</td>
          <td class="col191">0</td>
          <td class="col192">0</td>
          <td class="col193">0</td>
          <td class="col194">0</td>
          <td class="col195">-1</td>
          <td class="col196">0</td>
          <td class="col197">0</td>
          <td class="col198">0</td>
          <td class="col199">0</td>
          <td class="col200">0</td>
          <td class="col201">0</td>
          <td class="col202">-1</td>
          <td class="col203">0</td>
          <td class="col204">0</td>
          <td class="col205">0</td>
          <td class="col206">0</td>
          <td class="col207">0</td>
          <td class="col208">0</td>
          <td class="col209">-1</td>
          <td class="col210">0</td>
          <td class="col211">0</td>
          <td class="col212">0</td>
          <td class="col213"></td>
          <td class="col214"></td>
          <td class="col215"></td>
          <td class="col216"></td>
          <td class="col217"></td>
          <td class="col218">0</td>
          <td class="col219">0</td>
          <td class="col220">0</td>
          <td class="col221">0</td>
          <td class="col222">0</td>
          <td class="col223">0</td>
          <td class="col224">0</td>
          <td class="col225">0</td>
          <td class="col226">0</td>
          <td class="col227">0</td>
          <td class="col228">0</td>
          <td class="col229">0</td>
          <td class="col230">0</td>
          <td class="col231">0</td>
          <td class="col232">0</td>
          <td class="col233">0</td>
          <td class="col234">0</td>
          <td class="col235">0</td>
          <td class="col236">Als</td>
          <td class="col237">0</td>
          <td class="col238">0</td>
          <td class="col239">0</td>
          <td class="col240">0</td>
          <td class="col241">0</td>
          <td class="col242">-1</td>
          <td class="col243">0</td>
          <td class="col244">0</td>
          <td class="col245">0</td>
          <td class="col246">0</td>
          <td class="col247">0</td>
          <td class="col248">0</td>
          <td class="col249">0</td>
          <td class="col250">0</td>
          <td class="col251">0</td>
          <td class="col252">-1</td>
          <td class="col253">0</td>
        </tr>
      </tbody>
    </table>
  </body>
</html>

lerxst2112 · #3 06-17-2011, 05:10 PM

Is there a reason you deleted your items table? If I was you I'd source it back in and use Georges tool to copy and modify the items you want. That's really the easiest way I've found.

comicmess · #4 06-17-2011, 05:26 PM

My reason was I wanted to start from scratch; most if not all of the items I will be using in the game will need to be custom-created for the experience I'd like, but if there is no way around it I probably will source it back in.

lerxst2112 · #5 06-17-2011, 05:55 PM

Well, if nothing else you could delete all but one item that you use as a base to copy from.

It's up to you, but it seems like adding your new items to an existing table would be easier than deleting everything and hoping you caught all the cases of hard coded item IDs in the server code and all the references to item IDs in loot tables, starting items, tribute items, etc.

comicmess · #6 06-17-2011, 06:29 PM

You're right, and so I just created a new DB and sourced the item file over. Problem solved!