PDA

View Full Version : EQitems Ammo/Power source


Aeryn
10-18-2011, 09:36 AM
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