[SQL] Register Proc for automatically adding cookies

[X_Sarah_X]

This is a small release for a change I made in the Account Registration procedure that will add a specified amount of cookies to the account created.
It works flawlessly in my case, due to the fact that upon logging in the first time, the character will automatically use the same nickname as your accountname.

USE [ini3_py_account]
GO
/****** Object:  StoredProcedure [dbo].[SP_PANGYA_REGIST]    Script Date: 02/05/2011 20:02:14 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[SP_PANGYA_REGIST]

@idcard	CHAR(13),
@sex 		BIT,
@birthday 	VARCHAR(50),
@zipcode	CHAR(5),
@id		VARCHAR(32),
@pswd		VARCHAR(32)

AS

IF NOT EXISTS(	SELECT UserID FROM Ini3_UserLogin WHERE UserID = @id AND VisaIDCard = @idcard)
       BEGIN
	INSERT INTO Ini3_UserLogin(UserID, Password, Birthday, Sex, VisaIDCard, Confirm18, UserName, ZipCode)
	VALUES (@id, @pswd, CONVERT(DATETIME,@birthday), @sex, @idcard, '0', @id, @zipcode)
	
	-- Registration Done, adding cookies procedure below
	
	
	DECLARE @UserName varchar(32)
	DECLARE @UserIdx int
	
		-- Static sitecode, is always 'ini3'
	DECLARE @siteCode varchar(5)
	SET @siteCode = N'ini3'

	-- Get the nickname and the idx for the specified user from the game-server database...
	SELECT @UserName = [UserID], @UserIdx = [idx] FROM [ini3_py_account].[dbo].[Ini3_UserLogin]
	WHERE userid = @id;
	
	-- Check whether we have previous records for this user...
	SELECT UserNo, UserID FROM [INI3BILL_DB].[dbo].TAccountMst
	WHERE UserNo = @UserIdx
	AND UserID = @id
	
	IF @@ROWCOUNT = 0
		-- User never got cookies so we need to create a new row for him...
		INSERT INTO [INI3BILL_DB].[dbo].TAccountMst ([SiteCode], [UserNo], [UserID], [UserName], [CookieAmt])
		VALUES ( @siteCode, @UserIdx, @id, @UserName, '250000')
	ELSE
		-- User has cookies so we can simply update the old value
		UPDATE [INI3BILL_DB].[dbo].TAccountMst SET [CookieAmt] = [CookieAmt] + '250000', [UpdDate] = CURRENT_TIMESTAMP
		WHERE [UserNo] = @UserIdx AND [UserID] = @id
       END

As you see, in my procedure i set it to add 250K cookies to new accounts. You can change this to any value you want, however.

[MentaL]

[malcomtidus]

This is a very nice Proc, Sarah. I'd totally use this if my server were public and not just for my friends - as I give out cookies when they pull off awesome shots.

[X_Sarah_X]

I'm using it on my server as we speak, and for the 20-30 accounts that registered over the first day we went live, it worked like a charm! :)

When we were in beta phase I manually added cookies to their accounts upon request and got sick of doing it every time lol

[malcomtidus]

Oh no, I hear you there about the getting sick of manual adds haha :)

This is definitely a good proc for someone who has a server like yours.

[Tsukasa]

Why aren't you just simply executing the stored procedure the cookie part is from within SP_PANGYA_REGIST?

Seems much more straight forward, apart from the fact that changes to the proc will also be reflected by the procedures that are invoking it.

[xmens008]

how to Register Proc for automatically adding pang money

[Tsukasa]

You can edit the ProcEventRookieF procedure and add an UPDATE statement somewhere at the end:

UPDATE dbo.Pangya_User_Statistics SET Pang = 500000 WHERE UID = @uid

[malcomtidus]

You can edit the ProcEventRookieF procedure and add an UPDATE statement somewhere at the end:

UPDATE dbo.Pangya_User_Statistics SET Pang = 500000 WHERE UID = @uid

Tsukasa, would I also be able to make this SP hand out an item to new registers? I'm not sure how I would go about doing it - I'm okay at SQL but not great. I'd want to give new RookieF's 36 Nitro Pang Masteries (436207621) to get them off the ground in Pang terms.

[Tsukasa]

Tsukasa, would I also be able to make this SP hand out an item to new registers? I'm not sure how I would go about doing it - I'm okay at SQL but not great. I'd want to give new RookieF's 36 Nitro Pang Masteries (436207621) to get them off the ground in Pang terms.

Yes, absolutely. That's exactly what the procedure ProcEventRookieF does in the first place. It's the procedure that puts a few boosters into every new players inventory.

If you edit the procedure you'll see statements like this one (Note: I already modified this one to be your 36x Nitro Pang Mastery):

INSERT dbo.PangYa_Item_WareHouse(UID,typeid,valid,regdate,Gift_flag,flag,ApplyTime,Enddate,C0,C1,C2,C3,C4,Purchase,ItemType)   
VALUES(@uid, 436207621, 1, @nowDate, 1, 1, @nowDate, @nowDate, 36, 0, 0, 0, 0, 0, 0)

Simply copy & paste it, change the item ID to what you want, note that C0 is the quantity (which should be > 0), apply the changes to the procedure and you should be good to go.

As some people here will probably note you should be wary of the ItemType - but you can ignore this for the time being. :)

[X_Sarah_X]

You can edit the ProcEventRookieF procedure and add an UPDATE statement somewhere at the end:

UPDATE dbo.Pangya_User_Statistics SET Pang = 500000 WHERE UID = @uid

I have to disagree with this solution.

It will work, but the way I do it makes more sense to me, since the pang adding is already in another procedure.

USE [Pangya_S4_TH]
GO
/****** Object:  StoredProcedure [dbo].[ProcAssignFirstUserDB]    Script Date: 02/10/2011 21:41:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROC [dbo].[ProcAssignFirstUserDB] (  
		  @PARTS1 INT  
		, @PARTS2 INT  
		, @PARTS3 INT  
		, @PARTS4 INT  
		, @PARTS5 INT  
		, @PARTS6 INT  
		, @PARTS7 INT  
		, @PARTS8 INT  
		, @PARTS9 INT  
		, @PARTS10 INT  
		, @PARTS11 INT  
		, @PARTS12 INT  
		, @PARTS13 INT  
		, @PARTS14 INT  
		, @PARTS15 INT  
		, @PARTS16 INT  
		, @PARTS17 INT  
		, @PARTS18 INT  
		, @PARTS19 INT  
		, @PARTS20 INT  
		, @PARTS21 INT  
		, @PARTS22 INT  
		, @PARTS23 INT  
		, @PARTS24 INT  
		, @CHARTYPE INT  
		, @HAIR TINYINT  
		, @SHIRTS TINYINT  
		, @UID INT  
		, @USERID VARCHAR(32)  
) -- WITH ENCRYPTION

/*************************************************************************************************
2009-05-26, GOMI97
-@@IDENTITY 패치
   120   		--SET @DEFAULT_CHR = @@IDENTITY  
   127   		SET @DEFAULT_CAD  = @@IDENTITY         
   132   		SELECT @ERR = CASE WHEN (@@ERROR != 0) THEN @ERR + 1 ELSE 0 END, @DEFAULT_CLUB = @@IDENTITY 
*************************************************************************************************/
AS  
BEGIN 
 
SET NOCOUNT ON   
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED  
  
DECLARE @DEFAULT_CHR INT     
 --, @DEFAULT_CAD INT    
   , @DEFAULT_BALL INT     
   , @DEFAULT_CLUB INT     
  
DECLARE @PREVCOUNT INT         
DECLARE @SEX TINYINT    
DECLARE @ERR INT -- GOMI97      


SET @DEFAULT_CHR = 0
 --, @DEFAULT_CAD INT    
SET @DEFAULT_BALL = 0     
SET @DEFAULT_CLUB =0
  
SET @PREVCOUNT = 0
SET @SEX  = 0
SET @ERR  = 0 
  
	--2007-08-09 BY AMY PROC_EVENT_INVITE_NEWUSER2007        
	SELECT @SEX = SEX   
	FROM DBO.PANGYA_MEMBER_INFO   
	WHERE UID = @UID              
	  
	SELECT @PREVCOUNT = COUNT(UID)   
	FROM DBO.PANGYA_USER_STATISTICS   
	WHERE UID = @UID         
	  
	IF( @PREVCOUNT > 0) BEGIN         
	  UPDATE DBO.PANGYA_MEMBER_INFO    
	  SET FIRSTSET = 1   
	  WHERE UID = @UID
	    
	  RETURN ;         
	END ELSE BEGIN 
		-- 2009-02-27, GOMI97
		BEGIN TRAN
		 
		-- #1.		
		INSERT INTO DBO.PANGYA_USER_STATISTICS (UID, PANG)  
		VALUES(@UID, 500000)		SELECT @ERR = CASE WHEN (@@ERROR != 0) THEN @ERR + 1 ELSE 0 END  
		
		-- #2    
		INSERT INTO DBO.PANGYA_TROPHY_STAT(UID)  
		VALUES(@UID)
		SELECT @ERR = CASE WHEN (@@ERROR != 0) THEN @ERR + 1 ELSE 0 END           
	        
		-- DEFAULT 캐릭터 제공         
		INSERT INTO DBO.PANGYA_CHARACTER_INFORMATION  
		   (TYPEID, UID  
			, PARTS_1, PARTS_2, PARTS_3, PARTS_4, PARTS_5  
			, PARTS_6, PARTS_7, PARTS_8, PARTS_9, PARTS_10  
			, PARTS_11, PARTS_12, PARTS_13, PARTS_14, PARTS_15  
			, PARTS_16, PARTS_17, PARTS_18, PARTS_19, PARTS_20  
			, PARTS_21, PARTS_22, PARTS_23, PARTS_24  
			, DEFAULT_HAIR, DEFAULT_SHIRTS, GIFT_FLAG)   
		VALUES (@CHARTYPE, @UID,   
			 @PARTS1, @PARTS2, @PARTS3, @PARTS4, @PARTS5  
		   , @PARTS6, @PARTS7, @PARTS8, @PARTS9, @PARTS10  
		   , @PARTS11, @PARTS12, @PARTS13, @PARTS14, @PARTS15  
		   , @PARTS16, @PARTS17, @PARTS18, @PARTS19, @PARTS20  
		   , @PARTS21, @PARTS22, @PARTS23, @PARTS24  
		   , @HAIR, @SHIRTS, 1)
		SELECT @ERR = CASE WHEN (@@ERROR != 0) THEN @ERR + 1 ELSE 0 END         

		-- 2009-02-21, gomi97
		SET @DEFAULT_CHR = SCOPE_IDENTITY()


		     
		        
		---- CADDIE       
		--INSERT INTO PANGYA_CADDIE_INFO(UID,TYPEID,GIFT_FLAG) VALUES(@UID,'469762048',1)         
		--SET @DEFAULT_CAD  = @@IDENTITY         
		        
		-- CLUB  
		INSERT INTO DBO.PANGYA_ITEM_WAREHOUSE(UID, TYPEID, REGDATE, GIFT_FLAG)  
		VALUES(@UID, 268435456, GETDATE(), 1)  
		SELECT @ERR = CASE WHEN (@@ERROR != 0) THEN @ERR + 1 ELSE 0 END, @DEFAULT_CLUB = SCOPE_IDENTITY() 

		-- BALL  
		INSERT INTO DBO.PANGYA_ITEM_WAREHOUSE(UID, TYPEID, REGDATE, GIFT_FLAG)   
		VALUES(@UID, 335544320, GETDATE(), 1)
		SELECT @ERR = CASE WHEN (@@ERROR != 0) THEN @ERR + 1 ELSE 0 END          
		  
		-- NECKLACE      
		INSERT INTO DBO.PANGYA_ITEM_WAREHOUSE(UID, TYPEID, REGDATE, GIFT_FLAG)   
		VALUES(@UID, 436207622, GETDATE(), 1)
		SELECT @ERR = CASE WHEN (@@ERROR != 0) THEN @ERR + 1 ELSE 0 END          
		      
		-- EQUIP     
		INSERT INTO DBO.PANGYA_USER_EQUIP(UID, CLUB_ID, CHARACTER_ID, BALL_TYPE, CLUB_SLOT_1)         
		VALUES(@UID, @DEFAULT_CLUB, @DEFAULT_CHR, 335544320, 268435456)
		SELECT @ERR = CASE WHEN (@@ERROR != 0) THEN @ERR + 1 ELSE 0 END        
		
		IF @ERR = 0 BEGIN
			COMMIT TRAN
		END ELSE BEGIN
			ROLLBACK TRAN
		END        
		-- FIRSTSET  
		UPDATE DBO.PANGYA_MEMBER_INFO    
		SET FIRSTSET = 1   
		WHERE UID = @UID          
	    
	        
		--IF(@RET <> 1)  
		--  RAISERROR('ERR:000 - (PROCASSIGNFRISTUSERDB) ERROR %D ',10,1, @UID) WITH LOG         
		  
		 /**************************************  
		 * DEFAULT SHOWROOM INSERT 080422 LJW  
		 ***************************************/  
		 EXEC DBO.USP_ROOM_DEFAULT_ITEM @UID  
		   
		 -- EVENT ROOKIEF         
		 EXEC DBO.PROCEVENTROOKIEF @UID  
		 -- EVENT MOBILE PANG         
		 --EXEC DBO.PROCEVENTINSERTMOBILEPANG @USERID  
		 -- EVENT ONPLAYER - 5000 PANG  GIFT
		 --EXEC DBO.PROCEVENTINSERT_ONPLAYER @USERID, @UID  
		 -- EVENT NETPOWER - 10000 PANG  GIFT
		 --EXEC PROCEVENTINSERT_NETPOWER @USERID, @UID  
		 -- EVENT IGHTYMAC_S3 - 5000 PANG GIFT  
		 --EXEC DBO.PROCEVENTINSERT_MIGHTYMAC_S3 @USERID, @UID         
		 -- EVENT EMART  
		 --EXEC DBO.PROCEVENTGIFT_EMART @USERID  
		 -- EVENT PARTYNGIFT  GIFT
		 --EXEC DBO.PROCEVENT_PARTYNGIFT_NEW @USERID, @UID          
		 -- EVENT BELLCASH  GIFT 
		 --EXEC DBO.PROCEVENT_BELLCASH_NEW @USERID, @UID        
		 --EXEC DBO.PROCEVENT_PANGCARD2006 @USERID, @UID        
		 EXEC DBO.PROCCHECKBIRTHDAYEVENT @UID -- 생일축하 (메일), @userid 제외함  
		        
		-- EXEC DBO.PROC_EVENT_INVITE_NEWUSER2007 @UID, @SEX            
		-- EXEC DBO.PROCEVENT_3YEAR_AZTEC @UID        
		-- EXEC DBO.PROCEVENT_PARANOPEN @USERID , @UID -- GIFT         
		-- EXEC DBO.PROCEVENT_HELLO2007_NOMANNER @UID        
		-- EXEC DBO.PROCEVENT_HELLO2007_AZTEC @UID        
		-- EXEC PROCEVENT_HANGAWI_2006_KR @UID, @USERID   -- 2006-09-28  BY RYU        
		-- EXEC DBO.PROCEVENT_CHERRYBLOSSOM_AZTEC @UID        
		-- EXEC DBO.PROCEVENT_POINT20070508 @UID        
		-- EXEC DBO.PROCEVENT_POINT20070611 @UID        
		-- EXEC PROCEVENT_HANGAWII2007 @UID -- 20070907 BY AMY    
		-- EXEC DBO.PROCEVENT_HALLOWEEN2007_AZTEC @UID                
		-- EXEC USP_EVENT_EXAM2007_TISSUEFORK @UID   

		-- EXEC USP_EVENT_S4_ATTEND @UID   
		-- EXEC USP_EVENT_NEWYEAR2008_MANNER @UID      
		--EXEC DBO.USP_EVENT_S4_RU @UID, @CHARTYPE  
		--EXEC USP_EVENT_4thANNIVERSARY @UID  
		         
		--EXEC DBO.PROCEVENT_ONCASH_10000PANG @USERID, @UID         
--		EXEC PROCEVENT_POINT @UID  
--		EXEC USP_EVENT_S4_ATTEND2 @UID   
--		EXEC DBO.USP_EVENT_POINT_ATTEND @UID  
--		EXEC DBO.USP_EVENT_COMEBACK @UID
		
		/******youly start****/
		
--		declare @s_no char(21) 
--
--		if exists (select * from pangya_member_info b
--			inner join tz_psp_event c
--			on b.uid = c.uid 
--			where b.userid = @userid 
--			and c.gift_yn is null ) begin 
--			
--			select 
--				@userid = b.userid 
--				, @s_no = c.s_no 
--			from 
--				pangya_member_info b 
--			inner join ta_psp_serial c
--			on b.uid = c.uid 
--			where b.userid = @userid 
--				
--			update tz_psp_event set char_date = getdate() where uid = (select uid from pangya_member_info where userid = @userid)
--			
--			EXEC DBO.USP_PSP_EVENT @USERID, @S_NO 	
--				
--		end 
		
		/******youly end ****/ 
		  
		        
	END  
   
END

You will see that this value is by default set to "3000". Just change it to the amount you want.

[Tsukasa]

It honestly doesn't matter, both do exactly the same. :)

If we're talking about preferences: I find it a bit more convenient to have most of the modifications for new players in one procedure (RookieF) instead of spreading it over a few different ones, it vastly reduces the clutter.

[X_Sarah_X]

You're right, it doesn't really matter how you do it. I think the difference is one of those things based on personal preferences.

[malcomtidus]

Yes, absolutely. That's exactly what the procedure ProcEventRookieF does in the first place. It's the procedure that puts a few boosters into every new players inventory.

If you edit the procedure you'll see statements like this one (Note: I already modified this one to be your 36x Nitro Pang Mastery):

INSERT dbo.PangYa_Item_WareHouse(UID,typeid,valid,regdate,Gift_flag,flag,ApplyTime,Enddate,C0,C1,C2,C3,C4,Purchase,ItemType)   
VALUES(@uid, 436207621, 1, @nowDate, 1, 1, @nowDate, @nowDate, 36, 0, 0, 0, 0, 0, 0)

Simply copy & paste it, change the item ID to what you want, note that C0 is the quantity (which should be > 0), apply the changes to the procedure and you should be good to go.

As some people here will probably note you should be wary of the ItemType - but you can ignore this for the time being. :)

Hey, thanks for the help Tsukasa. :) Works on new accounts like a charm, and gives me a place to jump off in learning SQL.

[xmens008]

I have to disagree with this solution.

It will work, but the way I do it makes more sense to me, since the pang adding is already in another procedure.

USE [Pangya_S4_TH]
GO
/****** Object:  StoredProcedure [dbo].[ProcAssignFirstUserDB]    Script Date: 02/10/2011 21:41:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROC [dbo].[ProcAssignFirstUserDB] (  
		  @PARTS1 INT  
		, @PARTS2 INT  
		, @PARTS3 INT  
		, @PARTS4 INT  
		, @PARTS5 INT  
		, @PARTS6 INT  
		, @PARTS7 INT  
		, @PARTS8 INT  
		, @PARTS9 INT  
		, @PARTS10 INT  
		, @PARTS11 INT  
		, @PARTS12 INT  
		, @PARTS13 INT  
		, @PARTS14 INT  
		, @PARTS15 INT  
		, @PARTS16 INT  
		, @PARTS17 INT  
		, @PARTS18 INT  
		, @PARTS19 INT  
		, @PARTS20 INT  
		, @PARTS21 INT  
		, @PARTS22 INT  
		, @PARTS23 INT  
		, @PARTS24 INT  
		, @CHARTYPE INT  
		, @HAIR TINYINT  
		, @SHIRTS TINYINT  
		, @UID INT  
		, @USERID VARCHAR(32)  
) -- WITH ENCRYPTION

/*************************************************************************************************
2009-05-26, GOMI97
-@@IDENTITY 패치
   120   		--SET @DEFAULT_CHR = @@IDENTITY  
   127   		SET @DEFAULT_CAD  = @@IDENTITY         
   132   		SELECT @ERR = CASE WHEN (@@ERROR != 0) THEN @ERR + 1 ELSE 0 END, @DEFAULT_CLUB = @@IDENTITY 
*************************************************************************************************/
AS  
BEGIN 
 
SET NOCOUNT ON   
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED  
  
DECLARE @DEFAULT_CHR INT     
 --, @DEFAULT_CAD INT    
   , @DEFAULT_BALL INT     
   , @DEFAULT_CLUB INT     
  
DECLARE @PREVCOUNT INT         
DECLARE @SEX TINYINT    
DECLARE @ERR INT -- GOMI97      


SET @DEFAULT_CHR = 0
 --, @DEFAULT_CAD INT    
SET @DEFAULT_BALL = 0     
SET @DEFAULT_CLUB =0
  
SET @PREVCOUNT = 0
SET @SEX  = 0
SET @ERR  = 0 
  
	--2007-08-09 BY AMY PROC_EVENT_INVITE_NEWUSER2007        
	SELECT @SEX = SEX   
	FROM DBO.PANGYA_MEMBER_INFO   
	WHERE UID = @UID              
	  
	SELECT @PREVCOUNT = COUNT(UID)   
	FROM DBO.PANGYA_USER_STATISTICS   
	WHERE UID = @UID         
	  
	IF( @PREVCOUNT > 0) BEGIN         
	  UPDATE DBO.PANGYA_MEMBER_INFO    
	  SET FIRSTSET = 1   
	  WHERE UID = @UID
	    
	  RETURN ;         
	END ELSE BEGIN 
		-- 2009-02-27, GOMI97
		BEGIN TRAN
		 
		-- #1.		
		INSERT INTO DBO.PANGYA_USER_STATISTICS (UID, PANG)  
		VALUES(@UID, 500000)		SELECT @ERR = CASE WHEN (@@ERROR != 0) THEN @ERR + 1 ELSE 0 END  
		
		-- #2    
		INSERT INTO DBO.PANGYA_TROPHY_STAT(UID)  
		VALUES(@UID)
		SELECT @ERR = CASE WHEN (@@ERROR != 0) THEN @ERR + 1 ELSE 0 END           
	        
		-- DEFAULT 캐릭터 제공         
		INSERT INTO DBO.PANGYA_CHARACTER_INFORMATION  
		   (TYPEID, UID  
			, PARTS_1, PARTS_2, PARTS_3, PARTS_4, PARTS_5  
			, PARTS_6, PARTS_7, PARTS_8, PARTS_9, PARTS_10  
			, PARTS_11, PARTS_12, PARTS_13, PARTS_14, PARTS_15  
			, PARTS_16, PARTS_17, PARTS_18, PARTS_19, PARTS_20  
			, PARTS_21, PARTS_22, PARTS_23, PARTS_24  
			, DEFAULT_HAIR, DEFAULT_SHIRTS, GIFT_FLAG)   
		VALUES (@CHARTYPE, @UID,   
			 @PARTS1, @PARTS2, @PARTS3, @PARTS4, @PARTS5  
		   , @PARTS6, @PARTS7, @PARTS8, @PARTS9, @PARTS10  
		   , @PARTS11, @PARTS12, @PARTS13, @PARTS14, @PARTS15  
		   , @PARTS16, @PARTS17, @PARTS18, @PARTS19, @PARTS20  
		   , @PARTS21, @PARTS22, @PARTS23, @PARTS24  
		   , @HAIR, @SHIRTS, 1)
		SELECT @ERR = CASE WHEN (@@ERROR != 0) THEN @ERR + 1 ELSE 0 END         

		-- 2009-02-21, gomi97
		SET @DEFAULT_CHR = SCOPE_IDENTITY()


		     
		        
		---- CADDIE       
		--INSERT INTO PANGYA_CADDIE_INFO(UID,TYPEID,GIFT_FLAG) VALUES(@UID,'469762048',1)         
		--SET @DEFAULT_CAD  = @@IDENTITY         
		        
		-- CLUB  
		INSERT INTO DBO.PANGYA_ITEM_WAREHOUSE(UID, TYPEID, REGDATE, GIFT_FLAG)  
		VALUES(@UID, 268435456, GETDATE(), 1)  
		SELECT @ERR = CASE WHEN (@@ERROR != 0) THEN @ERR + 1 ELSE 0 END, @DEFAULT_CLUB = SCOPE_IDENTITY() 

		-- BALL  
		INSERT INTO DBO.PANGYA_ITEM_WAREHOUSE(UID, TYPEID, REGDATE, GIFT_FLAG)   
		VALUES(@UID, 335544320, GETDATE(), 1)
		SELECT @ERR = CASE WHEN (@@ERROR != 0) THEN @ERR + 1 ELSE 0 END          
		  
		-- NECKLACE      
		INSERT INTO DBO.PANGYA_ITEM_WAREHOUSE(UID, TYPEID, REGDATE, GIFT_FLAG)   
		VALUES(@UID, 436207622, GETDATE(), 1)
		SELECT @ERR = CASE WHEN (@@ERROR != 0) THEN @ERR + 1 ELSE 0 END          
		      
		-- EQUIP     
		INSERT INTO DBO.PANGYA_USER_EQUIP(UID, CLUB_ID, CHARACTER_ID, BALL_TYPE, CLUB_SLOT_1)         
		VALUES(@UID, @DEFAULT_CLUB, @DEFAULT_CHR, 335544320, 268435456)
		SELECT @ERR = CASE WHEN (@@ERROR != 0) THEN @ERR + 1 ELSE 0 END        
		
		IF @ERR = 0 BEGIN
			COMMIT TRAN
		END ELSE BEGIN
			ROLLBACK TRAN
		END        
		-- FIRSTSET  
		UPDATE DBO.PANGYA_MEMBER_INFO    
		SET FIRSTSET = 1   
		WHERE UID = @UID          
	    
	        
		--IF(@RET <> 1)  
		--  RAISERROR('ERR:000 - (PROCASSIGNFRISTUSERDB) ERROR %D ',10,1, @UID) WITH LOG         
		  
		 /**************************************  
		 * DEFAULT SHOWROOM INSERT 080422 LJW  
		 ***************************************/  
		 EXEC DBO.USP_ROOM_DEFAULT_ITEM @UID  
		   
		 -- EVENT ROOKIEF         
		 EXEC DBO.PROCEVENTROOKIEF @UID  
		 -- EVENT MOBILE PANG         
		 --EXEC DBO.PROCEVENTINSERTMOBILEPANG @USERID  
		 -- EVENT ONPLAYER - 5000 PANG  GIFT
		 --EXEC DBO.PROCEVENTINSERT_ONPLAYER @USERID, @UID  
		 -- EVENT NETPOWER - 10000 PANG  GIFT
		 --EXEC PROCEVENTINSERT_NETPOWER @USERID, @UID  
		 -- EVENT IGHTYMAC_S3 - 5000 PANG GIFT  
		 --EXEC DBO.PROCEVENTINSERT_MIGHTYMAC_S3 @USERID, @UID         
		 -- EVENT EMART  
		 --EXEC DBO.PROCEVENTGIFT_EMART @USERID  
		 -- EVENT PARTYNGIFT  GIFT
		 --EXEC DBO.PROCEVENT_PARTYNGIFT_NEW @USERID, @UID          
		 -- EVENT BELLCASH  GIFT 
		 --EXEC DBO.PROCEVENT_BELLCASH_NEW @USERID, @UID        
		 --EXEC DBO.PROCEVENT_PANGCARD2006 @USERID, @UID        
		 EXEC DBO.PROCCHECKBIRTHDAYEVENT @UID -- 생일축하 (메일), @userid 제외함  
		        
		-- EXEC DBO.PROC_EVENT_INVITE_NEWUSER2007 @UID, @SEX            
		-- EXEC DBO.PROCEVENT_3YEAR_AZTEC @UID        
		-- EXEC DBO.PROCEVENT_PARANOPEN @USERID , @UID -- GIFT         
		-- EXEC DBO.PROCEVENT_HELLO2007_NOMANNER @UID        
		-- EXEC DBO.PROCEVENT_HELLO2007_AZTEC @UID        
		-- EXEC PROCEVENT_HANGAWI_2006_KR @UID, @USERID   -- 2006-09-28  BY RYU        
		-- EXEC DBO.PROCEVENT_CHERRYBLOSSOM_AZTEC @UID        
		-- EXEC DBO.PROCEVENT_POINT20070508 @UID        
		-- EXEC DBO.PROCEVENT_POINT20070611 @UID        
		-- EXEC PROCEVENT_HANGAWII2007 @UID -- 20070907 BY AMY    
		-- EXEC DBO.PROCEVENT_HALLOWEEN2007_AZTEC @UID                
		-- EXEC USP_EVENT_EXAM2007_TISSUEFORK @UID   

		-- EXEC USP_EVENT_S4_ATTEND @UID   
		-- EXEC USP_EVENT_NEWYEAR2008_MANNER @UID      
		--EXEC DBO.USP_EVENT_S4_RU @UID, @CHARTYPE  
		--EXEC USP_EVENT_4thANNIVERSARY @UID  
		         
		--EXEC DBO.PROCEVENT_ONCASH_10000PANG @USERID, @UID         
--		EXEC PROCEVENT_POINT @UID  
--		EXEC USP_EVENT_S4_ATTEND2 @UID   
--		EXEC DBO.USP_EVENT_POINT_ATTEND @UID  
--		EXEC DBO.USP_EVENT_COMEBACK @UID
		
		/******youly start****/
		
--		declare @s_no char(21) 
--
--		if exists (select * from pangya_member_info b
--			inner join tz_psp_event c
--			on b.uid = c.uid 
--			where b.userid = @userid 
--			and c.gift_yn is null ) begin 
--			
--			select 
--				@userid = b.userid 
--				, @s_no = c.s_no 
--			from 
--				pangya_member_info b 
--			inner join ta_psp_serial c
--			on b.uid = c.uid 
--			where b.userid = @userid 
--				
--			update tz_psp_event set char_date = getdate() where uid = (select uid from pangya_member_info where userid = @userid)
--			
--			EXEC DBO.USP_PSP_EVENT @USERID, @S_NO 	
--				
--		end 
		
		/******youly end ****/ 
		  
		        
	END  
   
END

You will see that this value is by default set to "3000". Just change it to the amount you want.

thank you