Windows Updating items in-game through the database

[Nikkster]

Hello, I ran into a little issue here; it doesn't work to modify any items in the game through the database (even if the player is logged out). It works certainly to add an item or delete an item, but you can not modify the count-column. How can this be solved?

 

[RoHaN-OTs]

Need help with this too~

 

[Nikkster]

This shouldn't be that difficult? =(

 

[RoHaN-OTs]

bump

 

[Nikkster]

Bump

 

[RoHaN-OTs]

it does remove from player_items.. but after player logs on it just resets.

 

[Magich]

Look, it works, but the player needs to be logged out when you remove the item from the db

 

[RoHaN-OTs]

Look, it works, but the player needs to be logged out when you remove the item from the db

Hello, I ran into a little issue here; it doesn't work to modify any items in the game through the database (even if the player is logged out). It works certainly to add an item or delete an item, but you can not modify the count-column. How can this be solved?

Thanks anyways ..

 

[Magich]

Oh sorry, didn't realize and I also made another mistake, I tried with my server which is OpenTibia and not TFS... I'm gonna check right now with TFS and tell you what happens
EDIT: in TFS works as well Which TFS version are you using if you are using TFS?

 

[RoHaN-OTs]

Oh sorry, didn't realize and I also made another mistake, I tried with my server which is OpenTibia and not TFS... I'm gonna check right now with TFS and tell you what happens

it probably works on TFS. We are using Avesta

 

[Nikkster]

Oh sorry, didn't realize and I also made another mistake, I tried with my server which is OpenTibia and not TFS... I'm gonna check right now with TFS and tell you what happens
EDIT: in TFS works as well Which TFS version are you using if you are using TFS?

Did you try to edit the count column? Because adding or removing the entire field does actually work for us.

 

[Magich]

I didn't read carefully, but, hopefully, I found a way to solve this (normally editing the count doesn't work for me either):
You have to enter the db and from the sql tab enter this bit of code:

UPDATE  `DBNAME`.`player_items` SET  `count` = COUNT, `attributes` = '0x0f0COUNT' WHERE  `player_items`.`player_id` =PLAYERID AND  `player_items`.`sid` =SID;

Replace DBNAME with the name of your database, COUNT with the count number, COUNT again with the count number, PLAYERID with player id and SID with sid.
If you wanted to change from 1 to 3 items and dbname was tfs, player id was 2 and sid was 106 then it'd be:

UPDATE  `tfs`.`player_items` SET  `count` = 3, `attributes` = '0x0f03' WHERE  `player_items`.`player_id` =2 AND  `player_items`.`sid` =106;

Hope to have been clear and to have helped too