|
Originally Posted by davedevils, post: 1680, member: 1
Bonsoir je viens poster la sql officiel v17 pour l'inventaire :)
Je suis en train d'adapter les sources pour celui ci
TblrowInventory (stoquer les item)
Code:
/****** Object: Table [dbo].[tblRowInventory] Script Date: 04/21/2011 16:55:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblRowInventory]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tblRowInventory](
[m_idPlayer] [char](7) NOT NULL,
[serverindex] [char](2) NOT NULL,
[dwItemId] [int] NOT NULL,
[dwInvenIndex] [int] NOT NULL,
[nItemNum] [int] NOT NULL,
[nUniqueNum] [bigint] NOT NULL,
[nAbilityOption] [int] NULL,
[nItemResist] [int] NULL,
[nResistAbilityOption] [int] NULL,
[dwFlag] [int] NULL,
[bCharged] [int] NULL,
[dwKeepTime] [int] NULL,
[nRandomOptItemId] [bigint] NULL,
[nHitPoint] [int] NOT NULL CONSTRAINT [DF_Row_ADDR] DEFAULT ((0)),
[nRepairNumber] [int] NOT NULL CONSTRAINT [DF_tblRowInv_nRepa_6418C597] DEFAULT ((0)),
[nRepair] [int] NOT NULL CONSTRAINT [DF_tblRowInv_nRepa_650CE9D0] DEFAULT ((0)),
[nUltimatePiercingSize] [int] NOT NULL CONSTRAINT [DF_tblRowInv_nUlti_66010E09] DEFAULT ((0)),
[dwUltimatePiercingId1] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwUlt_66F53242] DEFAULT ((0)),
[dwUltimatePiercingId2] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwUlt_67E9567B] DEFAULT ((0)),
[dwUltimatePiercingId3] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwUlt_68DD7AB4] DEFAULT ((0)),
[dwUltimatePiercingId4] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwUlt_69D19EED] DEFAULT ((0)),
[dwUltimatePiercingId5] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwUlt_6AC5C326] DEFAULT ((0)),
[nGeneralPiercingSize] [int] NOT NULL CONSTRAINT [DF_tblRowInv_nGene_6BB9E75F] DEFAULT ((0)),
[dwGeneralPiercingId1] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwGen_6CAE0B98] DEFAULT ((0)),
[dwGeneralPiercingId2] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwGen_6DA22FD1] DEFAULT ((0)),
[dwGeneralPiercingId3] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwGen_6E96540A] DEFAULT ((0)),
[dwGeneralPiercingId4] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwGen_6F8A7843] DEFAULT ((0)),
[dwGeneralPiercingId5] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwGen_707E9C7C] DEFAULT ((0)),
[dwGeneralPiercingId6] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwGen_7172C0B5] DEFAULT ((0)),
[dwGeneralPiercingId7] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwGen_7266E4EE] DEFAULT ((0)),
[dwGeneralPiercingId8] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwGen_735B0927] DEFAULT ((0)),
[dwGeneralPiercingId9] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwGen_744F2D60] DEFAULT ((0)),
[dwGeneralPiercingId10] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwGen_75435199] DEFAULT ((0)),
[dwGeneralPiercingKeepTime1] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwGen_763775D2] DEFAULT ((0)),
[dwGeneralPiercingKeepTime2] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwGen_772B9A0B] DEFAULT ((0)),
[dwGeneralPiercingKeepTime3] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwGen_781FBE44] DEFAULT ((0)),
[dwGeneralPiercingKeepTime4] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwGen_7913E27D] DEFAULT ((0)),
[dwGeneralPiercingKeepTime5] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwGen_7A0806B6] DEFAULT ((0)),
[dwGeneralPiercingKeepTime6] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwGen_7AFC2AEF] DEFAULT ((0)),
[dwGeneralPiercingKeepTime7] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwGen_7BF04F28] DEFAULT ((0)),
[dwGeneralPiercingKeepTime8] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwGen_7CE47361] DEFAULT ((0)),
[dwGeneralPiercingKeepTime9] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwGen_7DD8979A] DEFAULT ((0)),
[dwGeneralPiercingKeepTime10] [int] NOT NULL CONSTRAINT [DF_tblRowInv_dwGen_7ECCBBD3] DEFAULT ((0)),
[nIsRarePet] [int] NOT NULL CONSTRAINT [DF_tblRowInv_nIsRa_7FC0E00C] DEFAULT ((0)),
[nRarePetKind] [int] NOT NULL CONSTRAINT [DF_tblRowInv_nRare_00B50445] DEFAULT ((0)),
[nRarePetLevel] [int] NOT NULL CONSTRAINT [DF_tblRowInv_nRare_01A9287E] DEFAULT ((0)),
[nRarePetExp] [int] NOT NULL CONSTRAINT [DF_tblRowInv_nRare_029D4CB7] DEFAULT ((0)),
[nRarePetEnergy] [int] NOT NULL CONSTRAINT [DF_tblRowInv_nRare_039170F0] DEFAULT ((0)),
[nRarePetLife] [int] NOT NULL CONSTRAINT [DF_tblRowInv_nRare_04859529] DEFAULT ((0)),
[nRarePetAvailLevel1] [int] NOT NULL CONSTRAINT [DF_tblRowInv_nRare_0579B962] DEFAULT ((0)),
[nRarePetAvailLevel2] [int] NOT NULL CONSTRAINT [DF_tblRowInv_nRare_066DDD9B] DEFAULT ((0)),
[nRarePetAvailLevel3] [int] NOT NULL CONSTRAINT [DF_tblRowInv_nRare_076201D4] DEFAULT ((0)),
[nRarePetAvailLevel4] [int] NOT NULL CONSTRAINT [DF_tblRowInv_nRare_0856260D] DEFAULT ((0)),
[nRarePetAvailLevel5] [int] NOT NULL CONSTRAINT [DF_tblRowInv_nRare_094A4A46] DEFAULT ((0)),
[szRarePetName] [varchar](64) NOT NULL CONSTRAINT [DF_tblRowInv_szRar_0A3E6E7F] DEFAULT ((0)),
[nSerialNumberStatus] [int] NOT NULL CONSTRAINT [DF_tblRowInv_nSeri_0B3292B8] DEFAULT ((0)),
[chState] [char](1) NOT NULL CONSTRAINT [DF_tblRowInv_chSta_0C26B6F1] DEFAULT ('T')
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[tblRowInventory]') AND name = N'IDX_CL_tblRowInventory_m_idPlayer_Serverindex_dwInvenIndex')
CREATE CLUSTERED INDEX [IDX_CL_tblRowInventory_m_idPlayer_Serverindex_dwInvenIndex] ON [dbo].[tblRowInventory]
(
[m_idPlayer] ASC,
[serverindex] ASC,
[dwInvenIndex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[tblRowInventory]') AND name = N'IDX_CL_tblRowInventory_dwItemId')
CREATE NONCLUSTERED INDEX [IDX_CL_tblRowInventory_dwItemId] ON [dbo].[tblRowInventory]
(
[dwItemId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
uspRowInventoryInsert (prosedure pour ajouter un item)
Code:
/****** Object: StoredProcedure [dbo].[uspRowInventoryInsert] 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].[uspRowInventoryInsert]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[uspRowInventoryInsert]
@m_idPlayer char(7)
,@serverindex char(2)
,@dwItemId int
,@dwInvenIndex int
,@nItemNum int
,@nUniqueNum bigint
,@szItemName varchar(64) = ''''
,@nAbilityOption int = 0
,@nItemResist int = 0
,@nResistAbilityOption int = 0
,@dwFlag int = 0
,@bCharged int = 0
,@dwKeepTime int = 0
,@nRandomOptItemId bigint = 0
,@nHitPoint int = 0
,@nRepairNumber int = 0
,@nRepair int = 0
,@nUltimatePiercingSize int = 0
,@dwUltimatePiercingId1 int = 0
,@dwUltimatePiercingId2 int = 0
,@dwUltimatePiercingId3 int = 0
,@dwUltimatePiercingId4 int = 0
,@dwUltimatePiercingId5 int = 0
,@nGeneralPiercingSize int = 0
,@dwGeneralPiercingId1 int = 0
,@dwGeneralPiercingId2 int = 0
,@dwGeneralPiercingId3 int = 0
,@dwGeneralPiercingId4 int = 0
,@dwGeneralPiercingId5 int = 0
,@dwGeneralPiercingId6 int = 0
,@dwGeneralPiercingId7 int = 0
,@dwGeneralPiercingId8 int = 0
,@dwGeneralPiercingId9 int = 0
,@dwGeneralPiercingId10 int = 0
,@dwGeneralPiercingKeepTime1 int = 0
,@dwGeneralPiercingKeepTime2 int = 0
,@dwGeneralPiercingKeepTime3 int = 0
,@dwGeneralPiercingKeepTime4 int = 0
,@dwGeneralPiercingKeepTime5 int = 0
,@dwGeneralPiercingKeepTime6 int = 0
,@dwGeneralPiercingKeepTime7 int = 0
,@dwGeneralPiercingKeepTime8 int = 0
,@dwGeneralPiercingKeepTime9 int = 0
,@dwGeneralPiercingKeepTime10 int = 0
,@nIsRarePet int = 0
,@nRarePetKind int = 0
,@nRarePetLevel int = 0
,@nRarePetExp int = 0
,@nRarePetEnergy int = 0
,@nRarePetLife int = 0
,@nRarePetAvailLevel1 int = 0
,@nRarePetAvailLevel2 int = 0
,@nRarePetAvailLevel3 int = 0
,@nRarePetAvailLevel4 int = 0
,@nRarePetAvailLevel5 int = 0
,@szRarePetName varchar(64) = ''''
,@nSerialNumberStatus int = 0
,@chState char(1) = ''T''
as
set nocount on
set xact_abort on
INSERT INTO tblRowInventory
(
m_idPlayer
,serverindex
,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
,chState
)
VALUES
(
@m_idPlayer
,@serverindex
,@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
,@chState
)
'
END
GO
uspRowInventoryLoad(permet de charger l'inventaire)
Code:
/****** 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
GO
uspRowInventoryDelete (supprimer un item)
Code:
/****** Object: StoredProcedure [dbo].[uspRowInventoryDelete] Script Date: 04/21/2011 16:52:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[uspRowInventoryDelete]') 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].[uspRowInventoryDelete]
@m_idPlayer char(7),
@serverindex char(2)
as
set nocount on
set xact_abort on
delete tblRowInventory where m_idPlayer = @m_idPlayer and serverindex = @serverindex and chState = ''F''
'
END
GO
|
The Treasure-System workt fine but the Ondrop funktion its not correctly.