Please help me with sql script for gift in inventory when new character

MY [WZ_CreateCharacter]

Code: [Select]

USE [MuOnline]
GO
/****** Object:  StoredProcedure [dbo].[WZ_CreateCharacter]    Script Date: 04/19/2019 15:15:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO


ALTER Procedure [dbo].[WZ_CreateCharacter] 

	@AccountID		varchar(10),
	@Name			varchar(10),
	@Class			tinyint
AS
BEGIN

	SET NOCOUNT ON
	SET	XACT_ABORT ON
	DECLARE		@Result		tinyint
	SET @Result = 0x00

	IF EXISTS ( SELECT Name FROM Character WHERE Name = @Name )
	BEGIN
		SET @Result	= 0x01
		GOTO ProcEnd						
	END

	BEGIN TRAN

	IF NOT EXISTS ( SELECT Id FROM  AccountCharacter WHERE Id = @AccountID )
		BEGIN
			INSERT INTO dbo.AccountCharacter(Id, GameID1, GameID2, GameID3, GameID4, GameID5, GameIDC) 
			VALUES(@AccountID, @Name, NULL, NULL, NULL, NULL, NULL)

			SET @Result  = @@Error
		END
	ELSE
		BEGIN
			Declare @g1 varchar(10), @g2 varchar(10), @g3 varchar(10), @g4 varchar(10), @g5 varchar(10)						
			SELECT @g1=GameID1, @g2=GameID2, @g3=GameID3, @g4=GameID4, @g5=GameID5 FROM dbo.AccountCharacter Where Id = @AccountID 			

			IF( ( @g1 Is NULL) OR (Len(@g1) = 0))
				BEGIN
					UPDATE AccountCharacter SET  GameID1 = @Name
					WHERE Id = @AccountID
										
					SET @Result  = @@Error
				END
			ELSE IF( @g2  Is NULL OR Len(@g2) = 0)
				BEGIN
					UPDATE AccountCharacter SET  GameID2 = @Name
					WHERE Id = @AccountID

					SET @Result  = @@Error
				END
			ELSE IF( @g3  Is NULL OR Len(@g3) = 0)
				BEGIN	
					UPDATE AccountCharacter SET  GameID3 = @Name
					WHERE Id = @AccountID

					SET @Result  = @@Error
				END
			ELSE IF( @g4 Is NULL OR Len(@g4) = 0)
				BEGIN
					UPDATE AccountCharacter SET  GameID4 = @Name
					WHERE Id = @AccountID

					SET @Result  = @@Error
				END
			ELSE IF( @g5 Is NULL OR Len(@g5) = 0)
				BEGIN
					UPDATE AccountCharacter SET  GameID5 = @Name
					WHERE Id = @AccountID

					SET @Result  = @@Error
				END	
			ELSE
				BEGIN		
					SET @Result	= 0x03							
					GOTO TranProcEnd								
				END	 
		END

	IF( @Result <> 0 )
		BEGIN
			GOTO TranProcEnd		
		END
	ELSE
		BEGIN
			INSERT INTO dbo.Character(AccountID, Name, cLevel, LevelUpPoint, Class, Strength, Dexterity, Vitality, Energy, Inventory,MagicList,
					Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,  MDate, LDate, Quest, Leadership )
				
			SELECT @AccountID As AccountID, @Name As Name, Level, LevelUpPoint, @Class As Class, 
				Strength, Dexterity, Vitality, Energy, Inventory,MagicList, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,
				getdate() As MDate, getdate() As LDate, Quest, Leadership
			FROM  DefaultClassType WHERE Class = @Class

			SET @Result  = @@Error
		END
		
		 IF NOT EXISTS ( SELECT AccountID FROM T_InGameShop_Point WHERE AccountID = @AccountID )
            BEGIN
               INSERT INTO dbo.T_InGameShop_Point (AccountID, WCoinC, WCoinP, GoblinPoint)
               VALUES (@AccountID, 0, 0, 0)
            END

TranProcEnd:
	IF ( @Result  <> 0 )
		ROLLBACK TRAN
	ELSE
		COMMIT TRAN

ProcEnd:
	SET NOCOUNT OFF
	SET XACT_ABORT OFF

	SELECT
	   CASE @Result
	      WHEN 0x00 THEN 0x01
	      WHEN 0x01 THEN 0x00
	      WHEN 0x03 THEN 0x03
	      ELSE 0x02
	   END AS Result 
END

Please help me with sql script for gift in inventory when new character

MY [WZ_CreateCharacter]

Code: [Select]

USE [MuOnline]
GO
/****** Object:  StoredProcedure [dbo].[WZ_CreateCharacter]    Script Date: 04/19/2019 15:15:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO


ALTER Procedure [dbo].[WZ_CreateCharacter] 

	@AccountID		varchar(10),
	@Name			varchar(10),
	@Class			tinyint
AS
BEGIN

	SET NOCOUNT ON
	SET	XACT_ABORT ON
	DECLARE		@Result		tinyint
	SET @Result = 0x00

	IF EXISTS ( SELECT Name FROM Character WHERE Name = @Name )
	BEGIN
		SET @Result	= 0x01
		GOTO ProcEnd						
	END

	BEGIN TRAN

	IF NOT EXISTS ( SELECT Id FROM  AccountCharacter WHERE Id = @AccountID )
		BEGIN
			INSERT INTO dbo.AccountCharacter(Id, GameID1, GameID2, GameID3, GameID4, GameID5, GameIDC) 
			VALUES(@AccountID, @Name, NULL, NULL, NULL, NULL, NULL)

			SET @Result  = @@Error
		END
	ELSE
		BEGIN
			Declare @g1 varchar(10), @g2 varchar(10), @g3 varchar(10), @g4 varchar(10), @g5 varchar(10)						
			SELECT @g1=GameID1, @g2=GameID2, @g3=GameID3, @g4=GameID4, @g5=GameID5 FROM dbo.AccountCharacter Where Id = @AccountID 			

			IF( ( @g1 Is NULL) OR (Len(@g1) = 0))
				BEGIN
					UPDATE AccountCharacter SET  GameID1 = @Name
					WHERE Id = @AccountID
										
					SET @Result  = @@Error
				END
			ELSE IF( @g2  Is NULL OR Len(@g2) = 0)
				BEGIN
					UPDATE AccountCharacter SET  GameID2 = @Name
					WHERE Id = @AccountID

					SET @Result  = @@Error
				END
			ELSE IF( @g3  Is NULL OR Len(@g3) = 0)
				BEGIN	
					UPDATE AccountCharacter SET  GameID3 = @Name
					WHERE Id = @AccountID

					SET @Result  = @@Error
				END
			ELSE IF( @g4 Is NULL OR Len(@g4) = 0)
				BEGIN
					UPDATE AccountCharacter SET  GameID4 = @Name
					WHERE Id = @AccountID

					SET @Result  = @@Error
				END
			ELSE IF( @g5 Is NULL OR Len(@g5) = 0)
				BEGIN
					UPDATE AccountCharacter SET  GameID5 = @Name
					WHERE Id = @AccountID

					SET @Result  = @@Error
				END	
			ELSE
				BEGIN		
					SET @Result	= 0x03							
					GOTO TranProcEnd								
				END	 
		END

	IF( @Result <> 0 )
		BEGIN
			GOTO TranProcEnd		
		END
	ELSE
		BEGIN
			INSERT INTO dbo.Character(AccountID, Name, cLevel, LevelUpPoint, Class, Strength, Dexterity, Vitality, Energy, Inventory,MagicList,
					Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,  MDate, LDate, Quest, Leadership )
				
			SELECT @AccountID As AccountID, @Name As Name, Level, LevelUpPoint, @Class As Class, 
				Strength, Dexterity, Vitality, Energy, Inventory,MagicList, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY,
				getdate() As MDate, getdate() As LDate, Quest, Leadership
			FROM  DefaultClassType WHERE Class = @Class

			SET @Result  = @@Error
		END
		
		 IF NOT EXISTS ( SELECT AccountID FROM T_InGameShop_Point WHERE AccountID = @AccountID )
            BEGIN
               INSERT INTO dbo.T_InGameShop_Point (AccountID, WCoinC, WCoinP, GoblinPoint)
               VALUES (@AccountID, 0, 0, 0)
            END

TranProcEnd:
	IF ( @Result  <> 0 )
		ROLLBACK TRAN
	ELSE
		COMMIT TRAN

ProcEnd:
	SET NOCOUNT OFF
	SET XACT_ABORT OFF

	SELECT
	   CASE @Result
	      WHEN 0x00 THEN 0x01
	      WHEN 0x01 THEN 0x00
	      WHEN 0x03 THEN 0x03
	      ELSE 0x02
	   END AS Result 
END

[Gracias:]

Gracias:

qq1988620

Para este post, 1 usuario dio las gracias!

MuCore 1.0.8 - Clear Inventory Fix

Started by Joaquin General

Ayuda con el “GIFT” de cash shop

Started by Mu Resplandor Soporte / Ayudas

ZeroEditor V7.0 Season 6/4 + Multilanguage + New Inventory Slots [NUEVO DISEÑO]

Started by Karuritoku « 1 2 3 4 » Compra / Venta de archivos

Fix Expanded Inventory Name Text Position - 1.04E Season 6

Started by emersonx13 Sources Generales