Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #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
Reply


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 12:42 AM.


 

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