Item Change and itemid

[GMCronus]

this is the thing. i have char item change in my server.

This only change Type and TypeID.

Any way to make a trigger to let's say

IF (@ActionType = 121)
begin
Update PS_GameData.dbo.UserStoredItems SET ItemID= Type and TypeID;
END

i know this isnt going to work LOL but i have a problem telling sql to add both type number and TypeID number to make ItemID

anyone that know sql that much?

Thanks

[killer2p]

itemID is type and type id combined
GM 5 loop example 40255

[nubness]

SET ItemID = Type * 1000 + TypeID