Db query to change id of items in all ot

[Ancore]

Hi, I wanna change by using a query all the items that has 2095 as item id to item id 3033, just an example

 

[Loney]

UPDATE `player_items` SET `itemtype` = 9999 WHERE `itemtype` = 10000

9999: old id
10000: new id

 

[Ancore]

doesn't work, my players have wailing widows on their legs (was zaoan shoes on the other items.xml) and they don't disappear with this command:

UPDATE `player_items` SET `itemtype` = 11304 WHERE `itemtype` = 11298

 

[Loney]

The server needs to be offline.

 

[Cronox]

Only need players logout he use /closeserver and execute query in database and works
query loney works Ancore only need all your players - offline

 

[azav3]

UPDATE `player_items` SET `itemtype` = 9999 WHERE `itemtype` = 10000

9999: old id
10000: new id

Loney, I am not good at all in SQL, but shouldn't be "9999: new id" and "10000: old id" instead as you said?

 

[Evan]

@up, that's what I think (considering the phrasing of the input). I may be wrong though.

 

[Loney]

Sorry, my wrong