[Problem]Vsro client stuck at Requesting User Confirmation

[gman2233]

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

[~Untouchable~]

SRO_VT_ACCOUNT-dbo._PrivilegedIP-type your ip numerically,like that

[gman2233]

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

[~Untouchable~]

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.

[gman2233]

I got it to work to log in by setting it my public ip not my local. although i used Chernobyl's guide() 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

[~Untouchable~]

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

[gman2233]

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

[~Untouchable~]

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

[gman2233]

Please close