-- GoatCheez
CREATE PROCEDURE GET_ITEM_NAME
@strRet		char(50) OUTPUT, 
@itemID 	int, 
AS
DECLARE @BaseID int, @ExtTbl tinyint, @ExtId smallint, @Row int
	SET @ExtTbl = 0 SET @ExtId = 0 SET @Row = 0
	SET @BaseID = CAST((SUBSTRING(CAST(@itemID AS varchar(9)),1,6) + '000') AS int)
	SET @ExtId = CAST(SUBSTRING(CAST(@itemID AS varchar(9)),6,3) AS smallint)
	SELECT @Row = COUNT(*) FROM ITEM_BASIC WHERE dwID = @BaseID
	IF @Row = 0
	BEGIN
		SET @strRet = 'Invalid Item'
		RETURN
	END	
	
	SELECT @ExtTbl = byExtIndex FROM ITEM_BASIC WHERE dwID = @BaseID
	
	IF ExtId <= 10
	BEGIN
		IF ExtId > 0
		BEGIN
			SET @strRet = (SELECT szName FROM ITEM_BASIC WHERE dwID = @BaseID) + ' +' + CAST(@ExtId AS varchar(1))
			RETURN
		END
		ELSE
		BEGIN
			SET @strRet = (SELECT szName FROM ITEM_BASIC WHERE dwID = @BaseID)
			RETURN		
		END
	END
	
	IF ExtId <= 250
	BEGIN
		IF ExtId < 100
		BEGIN
			SET @strRet = 'Special' + (SELECT szName FROM ITEM_BASIC WHERE dwID = @BaseID) + ' +' + SUBSTRING(CAST(@ExtId AS varchar(2)),2,1)
			RETURN
		END
		ELSE
		BEGIN
			SET @strRet = 'Special' + (SELECT szName FROM ITEM_BASIC WHERE dwID = @BaseID) + ' +' + SUBSTRING(CAST(@ExtId AS varchar(3)),3,1)
			RETURN
		END
	END
	
	IF ExtId = 1
	BEGIN
		SELECT @strRet = szHeader FROM ITEMEXT1 WHERE dwID = @ExtId
		RETURN
	END
	
	IF ExtId = 2
	BEGIN
		SELECT @strRet =  szHeader FROM ITEMEXT2 WHERE dwID = @ExtId
		RETURN
	END
	
	IF ExtId = 3
	BEGIN
		SELECT @strRet =  szHeader FROM ITEMEXT3 WHERE dwID = @ExtId
		RETURN
	END
	
	IF ExtId = 4
	BEGIN
		SELECT @strRet =  szHeader FROM ITEMEXT4 WHERE dwID = @ExtId
		RETURN
	END
	
	IF ExtId = 5
	BEGIN
		SELECT @strRet =  szHeader FROM ITEMEXT5 WHERE dwID = @ExtId
		RETURN
	END
	
	IF ExtId = 6
	BEGIN
		SELECT @strRet =  szHeader FROM ITEMEXT6 WHERE dwID = @ExtId
		RETURN
	END
	
	IF ExtId = 7
	BEGIN
		SELECT @strRet =  szHeader FROM ITEMEXT7 WHERE dwID = @ExtId
		RETURN
	END
	
	IF ExtId = 8
	BEGIN
		SELECT @strRet =  szHeader FROM ITEMEXT8 WHERE dwID = @ExtId
		RETURN
	END
	
	IF ExtId = 9
	BEGIN
		SELECT @strRet =  szHeader FROM ITEMEXT9 WHERE dwID = @ExtId
		RETURN
	END
	
	IF ExtId = 10
	BEGIN
		SELECT @strRet =  szHeader FROM ITEMEXT10 WHERE dwID = @ExtId
		RETURN
	END
	
	IF ExtId = 11
	BEGIN
		SELECT @strRet =  szHeader FROM ITEMEXT11 WHERE dwID = @ExtId
		RETURN
	END
	
	IF ExtId = 12
	BEGIN
		SELECT @strRet =  szHeader FROM ITEMEXT12 WHERE dwID = @ExtId
		RETURN
	END
	
	IF ExtId = 13
	BEGIN
		SELECT @strRet =  szHeader FROM ITEMEXT13 WHERE dwID = @ExtId
		RETURN
	END
	
	IF ExtId = 14
	BEGIN
		SELECT @strRet =  szHeader FROM ITEMEXT14 WHERE dwID = @ExtId
		RETURN
	END
	
	IF ExtId = 15
	BEGIN
		SELECT @strRet =  szHeader FROM ITEMEXT15 WHERE dwID = @ExtId
		RETURN
	END
	
	IF ExtId = 16
	BEGIN
		SELECT @strRet =  szHeader FROM ITEMEXT16 WHERE dwID = @ExtId
		RETURN
	END
	
	IF ExtId = 17
	BEGIN
		SELECT @strRet =  szHeader FROM ITEMEXT17 WHERE dwID = @ExtId
		RETURN
	END
	
	IF ExtId = 18
	BEGIN
		SELECT @strRet =  szHeader FROM ITEMEXT18 WHERE dwID = @ExtId
		RETURN
	END
	
	IF ExtId = 19
	BEGIN
		SELECT @strRet =  szHeader FROM ITEMEXT19 WHERE dwID = @ExtId
		RETURN
	END
	
	IF ExtId = 20
	BEGIN
		SELECT @strRet =  szHeader FROM ITEMEXT20 WHERE dwID = @ExtId
		RETURN
	END
	
	IF ExtId = 21
	BEGIN
		SELECT @strRet =  szHeader FROM ITEMEXT21 WHERE dwID = @ExtId
		RETURN
	END
	
	IF ExtId = 22
	BEGIN
		SELECT @strRet =  szHeader FROM ITEMEXT22 WHERE dwID = @ExtId
		RETURN
	END
	
	IF ExtId = 23
	BEGIN
		SELECT @strRet =  szHeader FROM ITEMEXT23 WHERE dwID = @ExtId
		RETURN
	END
GO