SQL Query Request

[sobek07]

I need a sql query again PP


I need to change all CC (2160) at count 100 to count 1 (2160)


I would be really thankful

 

[nclx]

UPDATE player_items SET count = 1 WHERE itemtype = 2160 AND count = 100;

Only players... if you want to do it in the entire OTS, don't forget to alter tile_items and player_depotitems too.