ELSE
BEGIN
SET @extname='Not Found'
SELECT @extname=strName FROM ITEM WHERE Num=@dwid
END
INSERT INTO INVENTORY_EDIT (dwid,stacksize,durability,strUserId,Slot,ItemName,extname) values(@dwid,@stacksize1,@dur,@strUserId,(@i-1) / 8,@extname,@name )
SET @i=@i+8
END
SELECT * FROM INVENTORY_EDIT WHERE strUserId=@strUserId ORDER BY Slot
END
GO |
