TFS 0.X SQL Query to change depot items

[Lurk]

Hello, I had some depots in certain towns linked wrong and now a player has different items in different depots at the same city.
Is there a SQL Query that would allow me to send all the items my players have from one depot to another?
Example: I have 30 itens in the depot of town 1 and 50 in the depot of town 2, I'd send them all to town 1 so I'd now have 80 items on depot 1 and 0 on depot 2

I know there are querys like:

DELETE FROM player_depotitems WHERE itemtype = 2160;

I'd need something like

UPDATE player_depotitems SET town_id='0' WHERE player_id>0;

or something like this, the player_depotitems table only has: player_id, sid, pid, itemtype, count, attributes and serial tho, no town..

 

[Infernum]

Set all depot items to town id 0:

UPDATE player_depotitems SET town_id=0 WHERE town_id>0;

Set all depot items from town id X to town id Y:

UPDATE player_depotitems SET town_id=Y WHERE town_id<>X;

 

[Lurk]

but the column town_Id doesn't exist

 

[Infernum]

but the column town_Id doesn't exist

I forgot it uses pid, and I don't remember how it works. I'll mess around and try to figure it out.

 

[Lurk]

aight, thank you. I'll also try to find something and will update here if I find anything