|
You last visited: Today at 20:51
Advertisement
Inception/Krustenkäse Source
Discussion on Inception/Krustenkäse Source within the Flyff PServer Guides & Releases forum part of the Flyff Private Server category.
01/27/2013, 14:54
|
#76
|
elite*gold: 0 
Join Date: Nov 2012
Posts: 142
Received Thanks: 41
|
Quote:
Originally Posted by Pixelfehler
The Treasure-System workt fine but the Ondrop funktion its not correctly.
|
i think his system has no OnDrop function for the treasure system right? 
|
|
|
|
02/16/2013, 17:23
|
#77
|
elite*gold: 0
Join Date: Aug 2009
Posts: 228
Received Thanks: 26
|
Possible database for inv tabbed? This it's official db for inv.
Quote:
|
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
|
Credits for jtb1!
|
|
|
|
|
02/16/2013, 17:57
|
#78
|
elite*gold: 4
Join Date: Mar 2010
Posts: 3,148
Received Thanks: 1,535
|
Quote:
Originally Posted by julioclitwin
Possible database for inv tabbed? This it's official db for inv.
Credits for jtb1!
|
no, in this source the databaseserver things are not coded for tabbed inventory. and this inventory is not 100%bugfree(server crashes).
|
|
|
|
|
07/01/2014, 12:00
|
#79
|
elite*gold: 0
Join Date: Jan 2014
Posts: 32
Received Thanks: 1
|
someone has database for this?
|
|
|
|
|
12/30/2015, 14:13
|
#80
|
elite*gold: 0
Join Date: Aug 2005
Posts: 231
Received Thanks: 66
|
reupload pls
|
|
|
|
Similar Threads
|
Inception
08/23/2010 - Movies & Series - 28 Replies
http://www.abload.de/img/mv5bmjaxmzy3njcxnf5bmldei c.jpg
IMDB-Link
YouTube - 'Inception' Teaser
|
All times are GMT +2. The time now is 20:51.
|
|
