I want to change one vnum of all the items in player@table to another..
example: change vnum 19 to 16
12/26/2011 09:02.Delta#2
UPDATE player.item_proto SET vnum = 16 WHERE vnum = 19;
don't know if that's what you want.
PS: Backup!
12/26/2011 13:51RumorUS#3
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;