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
