vSRO Çözüldü does anyone have the _AddNewChar star lvl 110

USE [SRO_VT_SHARD]

GO

/****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 11/27/2013 09:59:47 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

ALTER PROCEDURE [dbo].[_AddNewChar]

@UserJID INT,

--@CharSlot INT,

@RefCharID INT,

@CharName varchar (64),

@CharScale tinyINT,

@StartRegionID INT,

@StartPos_X real,

@StartPos_Y real,

@StartPos_Z real,

@DefaultTeleport INT,

@RefMailID INT,

@RefPantsID INT,

@RefBootsID INT,

@RefWeaponID INT,

@RefShield INT,

@DurMail tinyINT,

@DurPants tinyINT,

@DurBoots tinyINT,

@DurWeapon tinyINT,

@DurShield tinyINT,

@DefaultArrow INT

AS



SET NOCOUNT ON



DECLARE @Slot INT

DECLARE @temp INT



DECLARE @NewCharID INT

SET @NewCharID = 0



-- Initial Equip Edit by LemoniscooL

DECLARE @RefHandID INT

DECLARE @RefHatID INT

DECLARE @RefShoulderID INT

DECLARE @RefEarringID INT

DECLARE @RefRingID INT

DECLARE @RefNeckID INT

DECLARE @DurHand INT

DECLARE @DurHat INT

DECLARE @DurShoulder INT

DECLARE @DurEarring INT

DECLARE @DurRing INT

DECLARE @DurNeck INT



--Male Clothes Chinese

IF (@RefMailID = 3643) BEGIN

SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_11_A_RARE')

END



--Male Heavy Armor Chinese

IF (@RefMailID = 3637) BEGIN

SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_11_A_RARE')

END



--Male Light Armor Chinese

IF (@RefMailID = 3640) BEGIN

SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_11_A_RARE')

END



--Female Clothes Chinese

IF (@RefMailID = 3652) BEGIN

SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_11_A_RARE')

END



--Female Heavy Armor Chinese

IF (@RefMailID = 3646) BEGIN

SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_11_A_RARE')

END



--Female Light Armor Chinese

IF (@RefMailID = 3649) BEGIN

SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_11_A_RARE')

END



--Male Clothes Europe

IF (@RefMailID = 11623) BEGIN

SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_11_A_RARE')

END



--Male Heavy Armor Europe

IF (@RefMailID = 11617) BEGIN

SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_11_A_RARE')

END



--Male Light Armor Europe

IF (@RefMailID = 11620) BEGIN

SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_11_A_RARE')

END



--Female Clothes Europe

IF (@RefMailID = 11632) BEGIN

SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_11_A_RARE')

END



--Female Heavy Armor Europe

IF (@RefMailID = 11626) BEGIN

SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_11_A_RARE')

END



--Female Light Armor Europe

IF (@RefMailID = 11629) BEGIN

SET @RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_11_AA_A_RARE')

SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_11_BA_A_RARE')

SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_11_FA_A_RARE')

SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_11_HA_A_RARE')

SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_11_LA_A_RARE')

SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_11_SA_A_RARE')

SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_11_A_RARE')

SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_11_A_RARE')

SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_11_A_RARE')

END



--Shield Chinese

IF (@RefShield = 10886) BEGIN

SET @RefShield = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_SHIELD_11_A_RARE')

END



--Shield Europe

IF (@RefShield = 10896) BEGIN

SET @RefShield = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_SHIELD_11_A_RARE')

END



--Blade Chinese

IF (@RefWeaponID = 3633) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_BLADE_11_A_RARE')

END



--Bow Chinese

IF (@RefWeaponID = 3636) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_BOW_11_A_RARE')

END



--Spear Chinese

IF (@RefWeaponID = 3634) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_SPEAR_11_A_RARE')

END



--Sword Chinese

IF (@RefWeaponID = 3632) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_SWORD_11_A_RARE')

END



--Glavie Chinese

IF (@RefWeaponID = 3635) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_TBLADE_11_A_RARE')

END



--Axe Europe

IF (@RefWeaponID = 10890) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_AXE_11_A_RARE')

END



--XBow Europe

IF (@RefWeaponID = 10891) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_CROSSBOW_11_A_RARE')

END



--Dagger Europe

IF (@RefWeaponID = 10887) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_DAGGER_11_A_RARE')

END



--Darkstaff Europe

IF (@RefWeaponID = 10892) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_DARKSTAFF_11_A_RARE')

END



--Harp Europe

IF (@RefWeaponID = 10894) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_HARP_11_A_RARE')

END



--Cleric Rod Europe

IF (@RefWeaponID = 10895) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_STAFF_11_A_RARE')

END



--Sword Europe

IF (@RefWeaponID = 10888) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_SWORD_11_A_RARE')

END



--Staff Europe

IF (@RefWeaponID = 10893) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_TSTAFF_11_A_RARE')

END



--Twohand Sword Europe

IF (@RefWeaponID = 10889) BEGIN

SET @RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_TSWORD_11_A_RARE')

END



--Select Durability

SET @DurHand = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefHandID))

SET @DurMail = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefMailID))

SET @DurBoots = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefBootsID))

SET @DurHat = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefHatID))

SET @DurPants = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefPantsID))

SET @DurShoulder = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefShoulderID))

SET @DurWeapon = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefWeaponID))

SET @DurShield = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefShield))

SET @DurEarring = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefEarringID))

SET @DurRing = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefRingID))

SET @DurNeck = (Select Dur_L from _RefObjItem where ID in (Select Link from _RefObjCommon where ID = @RefNeckID))

-- Initial Equip Edit by LemoniscooL



--set @StartRegionID=25000

-----------------------------------------------------------------------------

-- 1. ??? ?? ??? valid? ???, ??? ???? ??? ?? ????.

-----------------------------------------------------------------------------



-- start by novice.

SELECT @temp = count(CharID) FROM _User WITH (NOLOCK) WHERE UserJID = @UserJID



IF (@temp >= 4)

BEGIN

-- ³Ê¹« ¸¹ÀÚ³ª

RETURN -2

END

-- finish by novice.



-----------------------------------------------------------------------------

-- 2. ij¸¯ÅÍ Ãß°¡Çϱâ

-----------------------------------------------------------------------------

IF (@CharScale > 68) -- 0100 0100 --> 68 ÀÌ´Ù!

BEGIN

-- ij¸¯ÅÍ »ý¼º ½ÇÆÐ! ½ºÄÉÀÏ °ªÀÌ ÀÌ»óÇÏ´Ù!

RETURN -3

END



EXEC @temp = _IsExistingCharName @CharName

IF (@temp <> 0)

BEGIN

-- ÀÌ¹Ì »ç¿ëÁßÀÎ À̸§À̶ó´Âµ¥?

RETURN -4

END



BEGIN TRANSACTION



-- Àδø½Ã½ºÅÛÀÌ Àû¿ëµÇ¸é¼ ¸¶Áö¸·¿¡ WorldID¿Í 1°ªÀ» ´õ ³Ö¾î ÁÖ¾ú´Ù!

INSERT INTO _Char (RefObjID, CharName16, Scale, Strength, Intellect, LatestRegion,PosX, PosY, PosZ, AppointedTeleport, InventorySize,

LastLogout, CurLevel, MaxLevel, RemainGold, RemainStatPoint, RemainSkillPoint, HP, MP, JobLvl_Trader, JobLvl_Hunter, JobLvl_Robber, WorldID, DailyPK)

VALUES (@RefCharID, @CharName, @CharScale, 20, 20, @StartRegionID, @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport, 45,

GetDate(), 1, 1, 25000000, 0, 0, 200,200, 1, 1, 1, 1, 50)



SET @NewCharID = @@IDENTITY

IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)

BEGIN

-- ij¸¯ÅÍ »ý¼º ½ÇÆÐ!

ROLLBACK TRANSACTION

RETURN -5

END

-- start by novice.

-- ÀÌÁ¦ Slot ¾È¾´´Ù.. ±×³É Insert ¸¸..

INSERT INTO _User VALUES (@UserJID, @NewCharID)

-- finish by novice.





-----------------------------------------------------------------------------

-- 3-1. Àåºñ ½½·Ô ä¿ì±â

-- [Àκ¥Å丮 ½½·Ô 96°³] + [Àåºñ½½·Ô 13°³] <- Àκ¥Å丮 È®Àå ¼ºñ½º ÈÄ 48°³¿¡¼ 96°³·Î Áõ°¡!!!(woos0)

-----------------------------------------------------------------------------

--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!

INSERT INTO _Inventory(CharID, Slot, ItemID)

SELECT @NewCharID, cnt, 0

FROM _RefDummySlot with( nolock )

WHERE cnt < 109





IF (@@ERROR <> 0)

BEGIN

-- Àκ¥Å丮 »ý¼º ½ÇÆÐ!

ROLLBACK TRANSACTION

RETURN -7

END

-- PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!



-- ???? ??? ???? ?? ????...

/* ?? ??? ???? ??.

0: EQUIP_SLOT_HELM

1: EQUIP_SLOT_MAIL,

2: EQUIP_SLOT_SHOULDERGUARD,

3: EQUIP_SLOT_GAUNTLET,

4: EQUIP_SLOT_PANTS,

5: EQUIP_SLOT_BOOTS,

6: EQUIP_SLOT_WEAPON,

7: EQUIP_SLOT_SHIELD or ARROW,

8: EQUIP_SLOT_EARRING,

9: EQUIP_SLOT_NECKLACE,

10: EQUIP_SLOT_L_RING,

11: EQUIP_SLOT_R_RING,

*/



-- Initial Equip Edit by LemoniscooL

DECLARE @ItemID BIGINT

SET @ItemID = 0

-- Chest

IF (@RefMailID <> 0) BEGIN

EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 1, @RefMailID, @DurMail

IF (@ItemID <= 0) BEGIN

ROLLBACK TRANSACTION

RETURN -8

END

END

-- Hand

IF (@RefHandID <> 0) BEGIN

EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, @RefHandID, @DurHand

IF (@ItemID <= 0) BEGIN

ROLLBACK TRANSACTION

RETURN -8

END

END

-- Hat

IF (@RefHatID <> 0) BEGIN

EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, @RefHatID, @DurHat

IF (@ItemID <= 0) BEGIN

ROLLBACK TRANSACTION

RETURN -8

END

END

-- Shoulder

IF (@RefShoulderID <> 0) BEGIN

EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, @RefShoulderID, @DurShoulder

IF (@ItemID <= 0) BEGIN

ROLLBACK TRANSACTION

RETURN -8

END

END

-- Pants

IF (@RefPantsID <> 0) BEGIN

EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 4, @RefPantsID, @DurPants

IF (@ItemID <= 0) BEGIN

ROLLBACK TRANSACTION

RETURN -9

END

END

-- Boots

IF (@RefBootsID <> 0) BEGIN

EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 5, @RefBootsID, @DurBoots

IF (@ItemID <= 0) BEGIN

ROLLBACK TRANSACTION

RETURN -10

END

END

-- Weapon

IF (@RefWeaponID <> 0) BEGIN

EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 6, @RefWeaponID, @DurWeapon

IF (@ItemID <= 0) BEGIN

ROLLBACK TRANSACTION

RETURN -11

END

END

-- Shield

IF (@RefShield <> 0) BEGIN

EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @RefShield, @DurShield

IF (@ItemID <= 0) BEGIN

ROLLBACK TRANSACTION

RETURN -12

END

END

-- Arror/Bolt

IF (@DefaultArrow <> 0) BEGIN

EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @DefaultArrow, 250

IF (@ItemID <= 0) BEGIN

ROLLBACK TRANSACTION

RETURN -13

END

END

-- Earring

IF (@RefEarringID <> 0) BEGIN

EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, @RefEarringID, @DurEarring

IF (@ItemID <= 0) BEGIN

ROLLBACK TRANSACTION

RETURN -8

END

END

-- Ring 1

IF (@RefRingID <> 0) BEGIN

EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, @RefRingID, @DurRing

IF (@ItemID <= 0) BEGIN

ROLLBACK TRANSACTION

RETURN -8

END

END

-- Ring 2

IF (@RefRingID <> 0) BEGIN

EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, @RefRingID, @DurRing

IF (@ItemID <= 0) BEGIN

ROLLBACK TRANSACTION

RETURN -8

END

END

-- Necklace

IF (@RefNeckID <> 0) BEGIN

EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, @RefNeckID, @DurNeck

IF (@ItemID <= 0) BEGIN

ROLLBACK TRANSACTION

RETURN -8

END

END

-- Initial Equip Edit by LemoniscooL



-----------------------------------------------------------------------------

-- 3-2. ¾Æ¹ÙŸ Inventory ½½·Ô ä¿ì±â

-- [¾Æ¹ÙŸ Àκ¥Å丮 ½½·Ô 5°³]

-- APPLY_AVATAR_SYSTEMÀÌ Àû¿ëµÇ¸é¼ Ãß°¡µÇ´Â ºÎºÐ

-----------------------------------------------------------------------------

--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!

INSERT INTO _InventoryForAvatar(CharID, Slot, ItemID)

SELECT @NewCharID, cnt, 0

FROM _RefDummySlot with( nolock )

WHERE cnt < 5





IF (@@ERROR <> 0)

BEGIN

-- ¾Æ¹ÙŸ Àκ¥Å丮 »ý¼º ½ÇÆÐ!

ROLLBACK TRANSACTION

RETURN -14

END

--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!



-----------------------------------------------------------------------------

-- default skill³Ö¾îÁÖ±â

-----------------------------------------------------------------------------

DECLARE @country tinyINT

EXEC @country = _GetObjCountry @RefCharID



INSERT INTO _CharSkillMastery (CharID, MasteryID, Level)

SELECT @NewCharID, MasteryID, 0

FROM _RefCharDefault_SkillMastery with(nolock)

WHERE Race = @country or Race = 3

IF (@@error <> 0)

BEGIN

ROLLBACK TRANSACTION

RETURN -15

END

INSERT INTO _CharSkill (CharID,SkillID,Enable)

SELECT @NewCharID, SkillID, 1

FROM _RefCharDefault_Skill with(nolock)

WHERE Race = @country or Race = 3

IF (@@error <> 0)

BEGIN

ROLLBACK TRANSACTION

RETURN -16

END

-----------------------------------------------------------------------------

-- ±âº» Äù½ºÆ® ³Ö¾îÁÖ±â

-----------------------------------------------------------------------------

INSERT INTO _CharQuest (CharID, QuestID, Status, AchievementCount, StartTime, EndTime, QuestData1, QuestData2)

SELECT @NewCharID, ID, 1, 0, getdate(), getdate(), 0, 0

FROM _RefQuest

WHERE CodeName in (SELECT CodeName FROM _RefCharDefault_Quest with(nolock) WHERE (Race = @country or Race = 3) and RequiredLevel = 1 and Service = 1)

IF (@@error <> 0)

BEGIN

ROLLBACK TRANSACTION

RETURN -17

END

-----------------------------------------------------------------------------

-- Static Avatar Initial Record ³Ö±â

-----------------------------------------------------------------------------

INSERT INTO _StaticAvatar(CharID) values(@NewCharID)

IF (@@ERROR <> 0)

BEGIN

ROLLBACK TRANSACTION

RETURN -18

END



-----------------------------------------------------------------------------

-- Trijob ä¿ö³Ö±â!!!!!

-----------------------------------------------------------------------------

INSERT INTO _CharTrijob VALUES (@NewCharID, 0, 1, 0, 0, 0)

IF (@@ERROR <> 0)

BEGIN

-- Àκ¥Å丮 »ý¼º ½ÇÆÐ!

ROLLBACK TRANSACTION

RETURN -19

END



-----------------------------------------------------------------------------

-- CharList¿¡ ID ³Ö¾îÁÖ±â

-----------------------------------------------------------------------------

INSERT _CharNameList VALUES(@CharName, @NewCharID)

UPDATE _Char SET CurLevel = 110, MaxLevel = 110, Strength = 147, Intellect= 147, RemainStatPoint= 330, ExpOffset = 0, RemainGold = 5000000, RemainSkillPoint = 5000000, InventorySize = 109 WHERE _Char.CharID = @NewCharID

UPDATE _Items SET OptLevel=5 WHERE ID64 IN (SELECT ItemID FROM _Inventory WHERE Slot BETWEEN 0 AND 12 AND Slot Not LIKE '8' AND CharID=@NewCharID)

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_REVERSE_RETURN_SCROLL',50,1

exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_RESURRECTION_SCROLL',50,1

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_GLOBAL_CHATTING',50,1

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_COS_P_MYOWON_SCROLL',1,0

IF (@RefCharID >= 1907 AND @RefCharID <= 1919) -- MALE CH

BEGIN

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_NASRUN',1,0

END

ELSE IF (@RefCharID >= 14875 AND @RefCharID <= 14887) -- MALE EU

BEGIN

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_NASRUN',1,0

END

ELSE IF (@RefCharID >= 1920 AND @RefCharID <= 1931) -- FEMALE CH

BEGIN

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_NASRUN',1,0

END

ELSE IF (@RefCharID >= 14888 AND @RefCharID <= 14900) -- FEMALE EU

BEGIN

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_NASRUN',1,0

END







-- Quick Slot Á¤º¸ ÀúÀå¿ë!!!

exec _AddNewClientConfig @NewCharID -- by novice...... for saving client configurations...



COMMIT TRANSACTION



RETURN @NewCharID