[SQL] Register Proc for automatically adding cookies
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.
Code:
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.
Re: [Release] Register Proc for automatically adding cookies
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.
Re: [Release] Register Proc for automatically adding cookies
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
Re: [Release] Register Proc for automatically adding cookies
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.
Re: [Release] Register Proc for automatically adding cookies
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.
Re: [Release] Register Proc for automatically adding cookies
how to Register Proc for automatically adding pang money
Re: [Release] Register Proc for automatically adding cookies
You can edit the ProcEventRookieF procedure and add an UPDATE statement somewhere at the end:
Code:
UPDATE dbo.Pangya_User_Statistics SET Pang = 500000 WHERE UID = @uid
Re: [Release] Register Proc for automatically adding cookies
Quote:
Originally Posted by
Tsukasa
You can edit the ProcEventRookieF procedure and add an UPDATE statement somewhere at the end:
Code:
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.
Re: [Release] Register Proc for automatically adding cookies
Quote:
Originally Posted by
malcomtidus
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):
Code:
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. :)
Re: [Release] Register Proc for automatically adding cookies
Quote:
Originally Posted by
Tsukasa
You can edit the ProcEventRookieF procedure and add an UPDATE statement somewhere at the end:
Code:
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.
Code:
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.
Re: [Release] Register Proc for automatically adding cookies
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.
Re: [Release] Register Proc for automatically adding cookies
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.
Re: [Release] Register Proc for automatically adding cookies
Quote:
Originally Posted by
Tsukasa
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):
Code:
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. :thumbup:
Re: [Release] Register Proc for automatically adding cookies
Quote:
Originally Posted by
X_Sarah_X
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.
Code:
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 :thumbup: :thumbup:
