It's because what was shared wasn't a query. Just a base outline of what is required.
Add these to character_tbl either by editing the db table through design or using a query.
Code:m_nBPLevel int m_nBPPoints int m_nBPType int m_nBPEnable int, m_szBPEndTime varchar(13)
Essentially, different stuff is ran based on iGu.
Variables that get added to character_str
Code:, @im_nBPLevel int = 0 , @im_nBPPoints int = 0 , @im_nBPType int = 0 , @im_nBPEnable int = 0 , @im_szBPEndTime varchar(13) = 20120202
iGu = S8
Code:, A.m_nBPLevel , A.m_nBPPoints , A.m_nBPType , A.m_nBPEnable , A.m_szBPEndTime
iGu = U1
Code:, m_nBPLevel = @im_nBPLevel , m_nBPPoints = @im_nBPPoints , m_nBPType = @im_nBPType , m_nBPEnable = @im_nBPEnable , m_szBPEndTime = @im_szBPEndTime
iGu = I1
Code:-- within INSERT CHARACTER_TBL at the bottom after idcampus or w/e if you have db edits , m_nBPLevel , m_nBPPoints , m_nBPType , m_nBPEnable , m_szBPEndTime
Code:-- in the values that get inserted in to the character_tbl by default -- Battle Pass , 0 , 0 , 0 , 0 , 20120202
How does this work, I open the battle pass window and it says the battle pass is not activated, it doesn't work after adding items, where should I turn it on thanks
Here we go. duck the PH "Devs"
PHP:USE [CHARACTER_01_DBF] GO /****** Object: Table [dbo].[tblTemporalPresets] Script Date: 8/16/2022 8:27:12 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblTemporalPresets]( [dwWorldID] [int] NULL, [dwSex] [int] NULL, [dwJob] [int] NULL, [szItem] [varchar](max) NULL, [szPet] [varchar](max) NULL, [szExt] [varchar](max) NULL, [szPiercing] [varchar](max) NULL, [szIndex] [varchar](2500) NULL, [szObjIndex] [varchar](2500) NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO
PHP:USE [CHARACTER_01_DBF] GO /****** Object: StoredProcedure [dbo].[uspTemporalPresetsGet] Script Date: 8/16/2022 8:28:00 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[uspTemporalPresetsGet] AS SET NOCOUNT ON SELECT a.[dwWorldID] ,a.[dwSex] ,a.[dwJob] ,a.[szItem] ,a.[szPet] ,a.[szExt] ,a.[szPiercing] ,a.[szIndex] ,a.[szObjIndex] FROM tblTemporalPresets a SET NOCOUNT OFF GO
PHP:USE [CHARACTER_01_DBF] GO /****** Object: StoredProcedure [dbo].[uspTemporalPresetsSave] Script Date: 8/16/2022 8:28:17 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[uspTemporalPresetsSave] [USER=521885]iworld[/USER]ID int, @iSex int, @iJob int, @iszItem varchar(MAX), @iszPet varchar(MAX), @iszExt varchar(MAX), @iszPiercing varchar(MAX), @iszIndex varchar(2500), @iszObjIndex varchar(2500) AS SET NOCOUNT ON IF NOT EXISTS ( SELECT * FROM [dbo].[tblTemporalPresets] WHERE dwWorldID = [USER=521885]iworld[/USER]ID AND dwSex = @iSex AND dwJob = @iJob) BEGIN INSERT INTO [dbo].[tblTemporalPresets] ([dwWorldID], [dwSex], [dwJob], [szItem], [szPet], [szExt], [szPiercing], [szIndex], [szObjIndex]) VALUES [USER=521885]iworld[/USER]ID, @iSex, @iJob, @iszItem, @iszPet, @iszExt, @iszPiercing, @iszIndex, @iszObjIndex) END ELSE BEGIN UPDATE [dbo].[tblTemporalPresets] SET dwWorldID = [USER=521885]iworld[/USER]ID, dwSex = @iSex, dwJob = @iJob, szItem = @iszItem, szPet = @iszPet, szExt = @iszExt, szPiercing = @iszPiercing, szIndex = @iszIndex, szObjIndex = @iszObjIndex WHERE dwWorldID = [USER=521885]iworld[/USER]ID AND dwSex = @iSex AND dwJob = @iJob END SET NOCOUNT OFF GO
Execute
[MENTION=521885]iworld[/MENTION]ID int,
this is an error, how can I break it? Thank you