initial DB NewChar Stat

USE [SRO_VT_SHARD]GO
/****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 08/27/2014 03:25:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
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 


----------------------------------------------------------------------------- 
-- 1. ij¸¯ÅÍ ½½·Ô ³Ñ¹ö°¡ 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, PKPenaltyPoint, TotalPK) 
VALUES (@RefCharID, @CharName, @CharScale, 119, 119, 26265, 932, -106.760178, 1474, 2094, 109,
GetDate(), 1, 1, 10000000, 297, 10000000, 200,200, 1, 1, 1, 1, 50, 0, 0) 

SET @NewCharID = @@IDENTITY 
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0) 
BEGIN 
-- ij¸¯ÅÍ »ý¼º ½ÇÆÐ! 
ROLLBACK TRANSACTION 
RETURN -5 
END 




-- start by novice. 
-- A??¦ Slot ¾E¾´´U.. ±×³E 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, 
*/ 

DECLARE @ItemID BIGINT 
SET @ItemID = 0 
-- »ó°© 
IF (@RefMailID <> 0) 
BEGIN 
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 1, @RefMailID, @DurMail 
IF (@ItemID <= 0) 
BEGIN 
ROLLBACK TRANSACTION 
RETURN -8 
END 
END 
-- ¹ÙÁö 
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 
-- ¹æÆÐ 
IF (@RefShield <> 0) 
BEGIN 
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @RefShield, @DurShield 
IF (@ItemID <= 0) 
BEGIN 
ROLLBACK TRANSACTION 
RETURN -12 
END 
END 
-- Ȥ½Ã default·Î ¼±ÅÃÇÑ ¹«±â°¡ È°À̶ó¸é È*»ì 250°³µéÀÌ È°Åëµµ ÇÔ²² ÁØ´Ù. ÁÒÄ¡? 
IF (@DefaultArrow <> 0) 
BEGIN 
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @DefaultArrow, 250 
IF (@ItemID <= 0) 
BEGIN 
ROLLBACK TRANSACTION 
RETURN -13 
END 
END




----------------------------------------------------------------------------- 
-- 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) 


BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_PREMIUM_VIETNAM_GOLDTIME_PLUS',1,1 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_COS_P_GHOST_SCROLL',0,0 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HP_SUPERSET_5_BAG',1000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_MP_SUPERSET_5_BAG',1000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_SPEED_UP_BASIC',20,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RESURRECTION_60P_SCROLL',5,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',10,1




INSERT INTO SRO_VT_ACCOUNT.dbo.SK_Silk (JID, silk_own, silk_gift, silk_point) VALUES (@UserJID, 0, 0, 0); 
END


-- Quick Slot Á¤º¸ ÀúÀå¿ë!!! 
exec _AddNewClientConfig @NewCharID -- by novice...... for saving client configurations... 


COMMIT TRANSACTION 

RETURN @NewCharID