GO
/****** Object: StoredProcedure [dbo].[uspRowInventoryLoad] Script Date: 04/21/2011 16:52:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[uspRowInventoryLoad]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE proc [dbo].[uspRowInventoryLoad]
@m_idPlayer char(7)
,@serverindex char(2)
as
set nocount on
set xact_abort on
select dwItemId
,dwInvenIndex
,nItemNum
,nUniqueNum
,nAbilityOption
,nItemResist
,nResistAbilityOption
,dwFlag
,bCharged
,dwKeepTime
,nRandomOptItemId
,nHitPoint
,nRepairNumber
,nRepair
,nUltimatePiercingSize
,dwUltimatePiercingId1
,dwUltimatePiercingId2
,dwUltimatePiercingId3
,dwUltimatePiercingId4
,dwUltimatePiercingId5
,nGeneralPiercingSize
,dwGeneralPiercingId1
,dwGeneralPiercingId2
,dwGeneralPiercingId3
,dwGeneralPiercingId4
,dwGeneralPiercingId5
,dwGeneralPiercingId6
,dwGeneralPiercingId7
,dwGeneralPiercingId8
,dwGeneralPiercingId9
,dwGeneralPiercingId10
,dwGeneralPiercingKeepTime1
,dwGeneralPiercingKeepTime2
,dwGeneralPiercingKeepTime3
,dwGeneralPiercingKeepTime4
,dwGeneralPiercingKeepTime5
,dwGeneralPiercingKeepTime6
,dwGeneralPiercingKeepTime7
,dwGeneralPiercingKeepTime8
,dwGeneralPiercingKeepTime9
,dwGeneralPiercingKeepTime10
,nIsRarePet
,nRarePetKind
,nRarePetLevel
,nRarePetExp
,nRarePetEnergy
,nRarePetLife
,nRarePetAvailLevel1
,nRarePetAvailLevel2
,nRarePetAvailLevel3
,nRarePetAvailLevel4
,nRarePetAvailLevel5
,szRarePetName
,nSerialNumberStatus
from tblRowInventory (nolock)
where m_idPlayer = @m_idPlayer and serverindex = @serverindex and chState = ''T''
'
END
