[Problem]Vsro client stuck at Requesting User Confirmation

I finally got my client and server running. but when i type in my info to try to login i get at the bottom requesting user confirmation and it just disappears after a while. Don't know what to do please help

I read somewhere that it was an ip problem but which ip and how do i fix it what do i change

SRO_VT_ACCOUNT-dbo._PrivilegedIP-type your ip numerically,like that
[Only registered and activated users can see links. Click Here To Register...]

It is like that
but still doesn't work

if i am set myself as a regular player no a GM it works but other than that it doesn't

guess you're writing your ip range,you gotta write exactly same ip at the both places,So if its 1.2.3.4 you gotta write same thing at the 2nd line.

I got it to work to log in by setting it my public ip not my local. although i used Chernobyl's guide([Only registered and activated users can see links. Click Here To Register...]) on the bottom of that page.

Although now when i log in it works but when i try to create a new character shard manager freaks out and tells me cannot create character

Show me exact error and i'm gonna try to help

notify Schedule Manager : Now working.. ! - SCHEDULE_DEF_EGYPT_TEMPLE_HAROERIS_AND_SETH - 58 2012-10-19 21:32:44 984
notify Schedule Manager : Now working.. ! - SCHEDULE_DEF_BATTLE_ARENA_MATCH_POINT - 359 2012-10-19 21:32:45 156
notify Schedule Manager : Now working.. ! - SCHEDULE_DEF_BATTLE_ARENA_MATCH_FLAG - 245 2012-10-19 21:32:45 156
fatal Failed to insert new user [user id: geodude, jid: 1427, return: -2] 2012-10-19 21:41:42 859
fatal Query Error!!! Query Result : -1, Query : {?=CALL _AddNewChar (1427, 1911,'Rice_Cakes',68,25256,960.000000,20.000000,42 0.000000,2094,3643,3644,3645,3633,10886,39,39,39,6 9,46,0)} 2012-10-19 21:42:30 906
fatal SQL Error State:23000, Native Error Code: 223, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "FK__User__AccountJID". The conflict occurred in database "SRO_VT_SHARD_INIT", table "dbo 2012-10-19 21:42:30 921
fatal {?=CALL _AddNewChar (1427, 1911,'Rice_Cakes',68,25256,960.000000,20.000000,42 0.000000,2094,3643,3644,3645,3633,10886,39,39,39,6 9,46,0)} 2012-10-19 21:42:30 937
fatal SQL Error State:01000, Native Error Code: E25, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. 2012-10-19 21:42:30 968
fatal {?=CALL _AddNewChar (1427, 1911,'Rice_Cakes',68,25256,960.000000,20.000000,42 0.000000,2094,3643,3644,3645,3633,10886,39,39,39,6 9,46,0)} 2012-10-19 21:42:30 968
fatal Failed To execute _AddNewChar ! [jid: 1427, odbc err: -1] 2012-10-19 21:42:30 984
fatal Failed To create new character! [jid: 1427, error code: 0] 2012-10-19 21:42:30 984
fatal Cannot find SuspectedUserJID.txt file! 2012-10-19 21:42:54 796

SRO_VT_SHARD-Programmability-StoredProcedures-Modify AddNewChar and replace this with yours.
Sorry i don't know how to dp spoiler lol


USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 20.10.2012 16:50:30 ******/
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)
VALUES (@RefCharID, @CharName, @CharScale, 20, 20, @StartRegionID, @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport, 45,
GetDate(), 1, 1, 20000, 0, 0, 200,200, 1, 1, 1, 1)

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,
*/

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)

exec _ADD_ITEM_EXTERN '@CharName','ITEM_ETC_SCROLL_RETURN_NEWBIE_01',20, 1
exec _ADD_ITEM_EXTERN '@CharName','ITEM_EVENT_COS_P_GOLDPIG_SCROLL',1,1
exec _ADD_ITEM_EXTERN '@CharName','ITEM_EVENT_DAMAGE_ABS_20P_SCROLL',5,1
exec _ADD_ITEM_EXTERN '@CharName','ITEM_EVENT_DAMAGE_INC_20P_SCROLL',5,1
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_EVENT_RESURRECTION_100P_SCROLL', 3,1
exec _ADD_ITEM_EXTERN '@CharName','ITEM_EVENT_REVERSE_RETURN_SCROLL',3,1

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

--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_COS_P_GOLDPIG_SCROLL',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_NASRUN',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_NASRUN',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_PREMIUM_GLOBAL_SILVERTIME',1, 1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_HALLOWEEN',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_HALLOWEEN_HAT',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_HALLOWEEN_ATTACH',1 ,1
-- END



SELECT @temp = count(CharID) FROM _User WITH (NOLOCK) WHERE UserJID = @UserJID
IF (@temp = 1)
BEGIN
UPDATE _Char SET RemainGold=800000, RemainSkillPoint=100000 WHERE _Char.CharID = @NewCharID
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_DAMAGE_ABS_20P_SCROLL',5,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_DAMAGE_INC_20P_SCROLL',5,1

--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_CAMPAIGN_GOLD_TIME_7D', 1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_COS_C_PEGASUS_SCROLL',5,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HP_SUPERSET_5_BAG',100,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_MP_SUPERSET_5_BAG',100,1

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_ARCHEMY_POTION_SPEED_11',5,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_GACHA_CARD',5,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_REVERSE_RETURN_SCROLL',5,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RESURRECTION_100P_SCROLL',5, 1


--IF @RefCharID<=14887 AND @RefCharID>=14875 -- European Male Gear
--BEGIN
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_EVENT_WINTER',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_EVENT_WINTER_ATTACH ',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_EVENT_WINTER_HAT',1 ,1


--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_M_LIGHT_HA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_M_LIGHT_SA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_M_LIGHT_BA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_M_LIGHT_LA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_M_LIGHT_AA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_M_LIGHT_FA_SET',1,1
--accessories
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_NECKLACE_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_RING_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_RING_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_EARRING_10_C_RARE',1,1
--weapons
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_TSTAFF_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_TSWORD_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_SHIELD_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_STAFF_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_SWORD_09_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_DARKSTAFF_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_HARP_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_CROSSBOW_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_DAGGER_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_AXE_10_C_RARE',1,1
--END

-- IF @RefCharID<=14900 AND @RefCharID>=14888 -- European Women Gear
--BEGIN
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_EVENT_WINTER',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_EVENT_WINTER_ATTACH ',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_EVENT_WINTER_HAT',1 ,1


--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_W_LIGHT_HA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_W_LIGHT_SA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_W_LIGHT_BA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_W_LIGHT_LA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_W_LIGHT_AA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_EU_W_LIGHT_FA_SET',1,1
--accessories
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_NECKLACE_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_RING_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_RING_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_EARRING_10_C_RARE',1,1
--weapons
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_TSTAFF_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_TSWORD_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_SHIELD_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_STAFF_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_SWORD_09_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_DARKSTAFF_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_HARP_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_CROSSBOW_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_DAGGER_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_EU_AXE_10_C_RARE',1,1
-- END

-- IF @RefCharID<=1919 AND @RefCharID>=1907 -- Chinesse Male Gear
--BEGIN
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_EVENT_WINTER',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_EVENT_WINTER_ATTACH ',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_EVENT_WINTER_HAT',1 ,1

--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_M_LIGHT_HA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_M_LIGHT_SA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_M_LIGHT_BA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_M_LIGHT_LA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_M_LIGHT_AA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_M_LIGHT_FA_SET',1,1
--accesories
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_NECKLACE_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_RING_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_RING_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_EARRING_10_C_RARE',1,1
--weapons
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_BOW_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_TBLADE_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_BLADE_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_SPEAR_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_SWORD_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_SHIELD_10_C_RARE',1,1
-- END

-- IF @RefCharID<=1932 AND @RefCharID>=1920 -- Chinesse Women Gear
--BEGIN
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_EVENT_WINTER',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_EVENT_WINTER_ATTACH ',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_EVENT_WINTER_HAT',1 ,1


--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_W_LIGHT_HA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_W_LIGHT_SA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_W_LIGHT_BA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_W_LIGHT_LA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_W_LIGHT_AA_SET',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_ROC_CH_W_LIGHT_FA_SET',1,1
--accesories
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_NECKLACE_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_RING_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_RING_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_EARRING_10_C_RARE',1,1
--weapons
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_BOW_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_TBLADE_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_BLADE_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_SPEAR_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_SWORD_10_C_RARE',1,1
--exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_CH_SHIELD_10_C_RARE',1,1
-- END







--Founder name For 1st char on acc
END

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

COMMIT TRANSACTION

RETURN @NewCharID

Please close