item slots in sql DB

[shadowscreen]

Hi all

 

 

well I'm here because i have kind of a problem.

 

I changed the slots on my server using following SQL statements.

// updating weapons
UPDATE item_db_re
SET slots = 4
WHERE type = 4

//updating armors
UPDATE item_db_re
SET slots = 2
WHERE type = 5

//setting shields back to 1 slot
UPDATE item_db_re
SET slots = 1
WHERE type = 5
AND equip_locations = 32

then i converted everything into a csv and made a itemslotcounttable.txt out of it wich is working fine!

Every slot is displayed properly but they are not actually there.

 

I also checked the DB and the slots are fine aswell...

 

Thanks in advance and best regards

 

*Edit*

 

Im using the renewal DB but changed it in both item_db and item_db_re to be sure.

 

 

 

 

------Solved it!--------

 

Well I actually was kinda stupid!

I didn't know that i had to turn on use_sql_db  in the inter_athena.conf

Edited December 15, 2013 by shadowscreen