need query for database

[RumorUS]

I need query to update item@player

I want to change one vnum of all the items in player@table to another..

example: change vnum 19 to 16

[.Delta]

UPDATE player.item_proto SET vnum = 16 WHERE vnum = 19;

don't know if that's what you want.

PS: Backup!

[RumorUS]

I think it's correct query but I would need it in "item" table. I want to change the vnum of the armors 11979-11982 but I have players already who own the armors.

I think this would be what I was looking for:

UPDATE player.item SET vnum = 11919 WHERE vnum = 11979;
UPDATE player.item SET vnum = 11929 WHERE vnum = 11980;
UPDATE player.item SET vnum = 11939 WHERE vnum = 11981;
UPDATE player.item SET vnum = 11949 WHERE vnum = 11982;


edit: I got it thx