SQL Database ( Command )

[Dalale]

Hello!
Im searching after a command you can execute on the database.

This is what its going to do.


IF player have item id 2285 he will get item id 2276 instead and remove 2285..


hope somone can help me.:thumbup:

 

[Mikuch]

that should be good backup database before doing it

UPDATE player_items SET itemtype = 2276 WHERE itemtype = 2285;
UPDATE tile_items SET itemtype = 2276 WHERE itemtype = 2285;
UPDATE player_depotitems SET itemtype = 2276 WHERE itemtype = 2285;

rep++?

 

[Dalale]

Gonna test it, thank you


EDIT : REP++ it worked

 

[wlj]

good