t

USE [Pangya]
GO
/****** Object:  StoredProcedure [dbo].[USP_FIRST_CREATION]    Script Date: 22/04/2019 15:50:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[USP_FIRST_CREATION]
	@UID INT,
	@CHAR_TYPEID INT,
	@HAIRCOLOUR TINYINT,
	@NICKNAME VARCHAR(50)
AS
BEGIN
	SET NOCOUNT ON;

	DECLARE @CODE TINYINT
	DECLARE @DATETIME DATETIME
	DECLARE @ITEM_ID BIGINT
	DECLARE @CID INT = 0
	DECLARE @MAIL_INDEX INT = 0
	DECLARE @DATENOW DATE = CONVERT (DATE, GETDATE())
	-- NICKNAME
	DECLARE @NICK VARCHAR(20)
	SELECT @NICK = RTRIM(LTRIM(@NICKNAME))

	DECLARE @CLUB_INDEX INT = 0
	DECLARE @CHAR_INDEX INT = 0

	IF EXISTS (SELECT 1 FROM [dbo].Pangya_Member WHERE UID = @UID AND FirstSet = 0) BEGIN
		UPDATE [dbo].Pangya_Member SET FirstSet = 1, Nickname = @NICK WHERE UID = @UID

		-- Pangya Equip
		INSERT INTO [dbo].Pangya_User_Equip(UID) VALUES (@UID)

		-- Insert Default Item
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436207622, 50); -- Lucky Necklace
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 402653188, 50);
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 402653189, 50);
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 402653195, 50);
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 402653194, 50);
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 402653185, 50);
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 402653184, 50);
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 402653190, 50);
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 402653193, 50);
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 467664918, 1); -- Assist

		-- Insert Ball
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 335544320, 1);

		-- Insert Club
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 268435541, 1);
		SELECT @CLUB_INDEX = SCOPE_IDENTITY()

		-- Insert Club_Info
		INSERT INTO [dbo].Pangya_Club_Info(ITEM_ID, C0_SLOT,C1_SLOT, C2_SLOT, C3_SLOT, C4_SLOT, CLUB_POINT, CLUB_WORK_COUNT, CLUB_SLOT_CANCEL, CLUB_POINT_TOTAL_LOG, CLUB_UPGRADE_PANG_LOG ) values (@CLUB_INDEX, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

		-- Insert Character
		INSERT INTO [dbo].Pangya_Character(UID,TYPEID,HAIR_COLOR,GIFT_FLAG) VALUES (@UID, @CHAR_TYPEID, @HAIRCOLOUR, 1)

        SET @CHAR_INDEX = SCOPE_IDENTITY()

		SET @CID = (SELECT CID FROM [dbo].Pangya_Character WHERE UID = @UID AND TYPEID = @CHAR_TYPEID)
		INSERT INTO [dbo].Pangya_Character_Equip(UID, CHAR_IDX) VALUES(@UID, @CID)

		-- ADICIONA OS ITENS DO NURI
        IF(@CHAR_TYPEID = 67108864) BEGIN
		-- ELF
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134359054);
		-- ASA
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134309904);

		--Add SSAF NURI
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134252550);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134348802);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134258713);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134283289);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134242340);
        END

		-- ADICIONA OS ITENS DA HANA
        IF(@CHAR_TYPEID = 67108865) BEGIN
		-- ELF
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134621198);
		-- ASA
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134580240);
       --Add SSAF HANA
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134537257);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134506504);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134610946);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134496315);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134512660);
        END

		-- ADICIONA OS ITENS DA CECILIA
        IF(@CHAR_TYPEID = 67108867) BEGIN
		-- ELF
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135145486);
		-- ASA
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135120912);
        --Add SSAF CECILIA
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135061539);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135036938);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135135234);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135020588);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135045140);
        END

		-- ADICIONA OS ITENS DO AZER
        IF(@CHAR_TYPEID = 67108866) BEGIN
		-- ELF
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134899726);
		-- ASA
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134842384);
         --Add SSAF AZER
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134776839);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134873090);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134782995);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134799381);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 134758430);
        END
		-- ADICIONA OS ITENS DO MAX
        IF(@CHAR_TYPEID = 67108868) BEGIN
		-- ELF
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135432206);
		-- ASA
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135366672);
        --Add SSAF MAX
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135290895);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135397378);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135299097);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135307291);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135282727);
        END

		-- ADICIONA OS ITENS DA KOOH
        IF(@CHAR_TYPEID = 67108869) BEGIN
		-- ELF
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135702542);
		-- ASA
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135661584);
        --Add SSAF MAX
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135585833);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135561231);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135692290);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135544885);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135569427);
        END

		-- ADICIONA OS ITENS DA ARIN
        IF(@CHAR_TYPEID = 67108870) BEGIN
		-- ELF
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135923726);
		-- ASA
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135858192);
       --Add SSAF ARIN
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135831597);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135815174);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135905283);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135807032);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 135823373);
        END

		-- ADICIONA OS ITENS DO KAZ
        IF(@CHAR_TYPEID = 67108871) BEGIN
		-- ELF
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136210446);
		-- ASA
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136194064);
        --Add SSAF KAZ
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136069142);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136085509);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136183810);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136110097);
        END
		-- ADICIONA OS ITENS DA LUCIA
        IF(@CHAR_TYPEID = 67108872) BEGIN
		-- ELF
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136456206);
		-- ASA
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136398864);
		--Add SSAF LUCIA
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136372233);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136347656);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136314882);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136331277);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136355845);
        END

		-- ADICIONA OS ITENS DA NELL
        IF(@CHAR_TYPEID = 67108873) BEGIN
		-- ELF
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136718350);
		-- ASA
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136661008);
        --Add SSAF LUCIA
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136634369);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136609793);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136577024);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136593409);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136617985);
        END

	    -- ADICIONA OS ITENS DA SPIKA
        IF(@CHAR_TYPEID = 67108874) BEGIN
		-- ELF
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136980494);
		-- ASA
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136923154);
        --Add SSAF SPIKA
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136896516);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136871940);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136839171);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136855557);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 136880130);
        END

		-- ADICIONA OS ITENS DO NURI (R)
        IF(@CHAR_TYPEID = 67108875) BEGIN
		-- ELF
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 137234437);
		-- ASA
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 137185283);
         --Add SSAF NURI R
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 137134080);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 137117697);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 137142273);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 137158656);

        END

		-- ADICIONA OS ITENS DA HANA (R)
        IF(@CHAR_TYPEID = 67108876) BEGIN
		-- ELF
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 137488393);
		-- ASA
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 137447437);
         --Add SSAF NURI R
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 137455624);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 137117697);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 137142273);

		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 137158656);

        END


		-- ADICIONA OS ITENS DA CECILIA (R)
        IF(@CHAR_TYPEID = 67108878) BEGIN
		-- ELF
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 138029062);
		-- ASA
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID) VALUES (@UID, 138004493);
        END

		-- Update Equip
		UPDATE DBO.Pangya_User_Equip
		SET BALL_ID = 335544320,
				CLUB_ID = @CLUB_INDEX,
				CHARACTER_ID = @CID
		WHERE UID = @UID

		-- Insert User Statistic
        INSERT INTO [DBO].Pangya_User_Statistics(UID, Pang, Game_Level) VALUES (@UID, 1500000, 10)

		-- Insert Into Macro
		INSERT INTO [dbo].Pangya_Game_Macro(UID) VALUES (@UID)

		-- Insert Personal
		INSERT INTO [DBO].Pangya_Personal(UID, CookieAmt) VALUES (@UID, 250000)

		-- Calliper
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436207680, 2000);

		-- Booster
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436207633, 1000);

		-- Auto comander
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208031, 500);

		-- Card Remover
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436207810, 10);

		-- SSC Ticket
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436207863, 100);

		-- Moeda do Memorial Premium
		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 436208242, 150);


		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 402653231, 20);


		INSERT INTO [dbo].Pangya_Warehouse(UID,TYPEID,C0) VALUES (@UID, 402653200, 600);


		-- Mascot Fire Spirit
		 SET @DATETIME = DATEADD(DAY, 30, GETDATE())
	     INSERT INTO DBO.Pangya_Mascot(UID, MASCOT_TYPEID, DateEnd) VALUES (@UID, 1073741854, @DATETIME)
	     SET @ITEM_ID = SCOPE_IDENTITY()
		 UPDATE [dbo].Pangya_User_Equip SET MASCOT_ID = @ITEM_ID WHERE UID = @UID
		 -- BLACK PAPEL CADDIE
	     INSERT INTO DBO.Pangya_Caddie(UID, TYPEID,cLevel, EXP) VALUES (@UID, 1073741854, 0, 0)
	     SET @ITEM_ID = SCOPE_IDENTITY()
		 UPDATE [dbo].Pangya_User_Equip SET CADDIE = @ITEM_ID WHERE UID = @UID

		SET @CODE = 1;
	END ELSE BEGIN
		SET @CODE = 5;
	END

	SELECT @CODE AS CODE

END