View Single Post
  #1  
Old 10-18-2011, 09:36 AM
Aeryn
Fire Beetle
 
Join Date: Jun 2011
Posts: 20
Default EQitems Ammo/Power source

Hi
Just a quick question on 13thflloor items

Is there a easy way to alter the slot id for ammo/power source?
As there db seems to be reversed
Anything in game the should be ammo shows as a power source. and vice versa

ie arrow item id 8005
slot id on eqitems = 4194304 but should be 2097152

i know this has something to do with when the power source slot was brought in

i can run various sqls to alter one id to the other, just could be a few combinations.

Just didnt know if i missing something obvious, or there is a sql that could do all in one run
Reply With Quote