Başlangıcta Builde Göre İtem Vermek

USE [SRO_VT_SHARD]GO
/****** Object:  StoredProcedure [dbo].[_AddNewChar]    Script Date: 09/08/2012 00:20:49 ******/
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       
     
      SET @CharName =@CharName
    -----------------------------------------------------------------------------       
    -- 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¸¯ÅÍ »y¼º ½ÇÆ?! ½ºÄÉÀÏ °ªÀÌ ÀÌ»óÇÏ´Ù!       
        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, 109,     
                GetDate(), 1, 1, 0, 0, 0, 200,200, 1, 1, 1, 1)     
   
    SET @NewCharID = @@IDENTITY       
    IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)       
    BEGIN       
        -- ij¸¯ÅÍ »y¼º ½ÇÆ?!       
        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       
        -- Àκ¥Å丮 »y¼º ½ÇÆ?!       
        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       
        -- ¾Æ¹ÙŸ Àκ¥Å丮 »y¼º ½ÇÆ?!       
        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       
        -- Àκ¥Å丮 »y¼º ½ÇÆ?!       
        ROLLBACK TRANSACTION       
        RETURN -19       
    END       
         
    -----------------------------------------------------------------------------       
    -- CharList¿¡ ID ³Ö¾îÁÖ±â       
    -----------------------------------------------------------------------------       
    INSERT _CharNameList VALUES(@CharName, @NewCharID)       
         
             
   
--EUROPE MAAAAAn
IF (@RefBootsID = 11622 or @RefBootsID = 11625 or @RefBootsID = 11619 )       
        BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_12_A_RARE',1,5 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_12_A_RARE',1,5 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_12_A_RARE',1,5   
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_12_A_RARE',1,5

 
 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_12_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_12_SA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_12_LA_A_RARE',1,5
 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_12_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_12_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_12_SA_A_RARE',1,5
 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_12_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_12_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_12_SA_A_RARE',1,5
 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',20,20
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_ARCHEMY_POTION_SPEED_11',5,5
END
 
 
--EUROPE WOMENNN
IF (@RefBootsID = 11631 or @RefBootsID = 11634 or @RefBootsID = 11628 )
BEGIN
  exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_12_A_RARE',1,5 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_12_A_RARE',1,5 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_12_A_RARE',1,5   
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_12_A_RARE',1,5
 
 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_12_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_12_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_12_SA_A_RARE',1,5
 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_12_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_12_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_12_SA_A_RARE',1,5
 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_12_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_12_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_12_SA_A_RARE',1,5
 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',20,20
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_ARCHEMY_POTION_SPEED_11',5,5 
        END   
 
 
--CHina MAAAAN
IF (@RefBootsID = 3639 or @RefBootsID = 3642 or @RefBootsID = 3645 )       
        BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_12_A_RARE',1,5 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_12_A_RARE',1,5 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_12_A_RARE',1,5   
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_12_A_RARE',1,5
  
 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_12_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_12_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_12_SA_A_RARE',1,5
 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_12_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_12_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_12_SA_A_RARE',1,5
 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_12_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_12_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_12_SA_A_RARE',1,5
 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',20,20
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_ARCHEMY_POTION_SPEED_11',5,5 
END
 
--CHINA WOMENNN
IF (@RefBootsID = 3648 or @RefBootsID = 3651 or @RefBootsID = 3654 )
BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_12_A_RARE',1,5 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_12_A_RARE',1,5 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_12_A_RARE',1,5   
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_12_A_RARE',1,5
 
 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_12_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_12_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_12_SA_A_RARE',1,5
 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_12_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_12_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_12_SA_A_RARE',1,5
 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_12_HA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_12_LA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_12_AA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_12_FA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_12_BA_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_12_SA_A_RARE',1,5
 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_12_A_RARE',1,5
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',20,20
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_ARCHEMY_POTION_SPEED_11',5,5
        END
 
 
 
 
 
 
 
    -- Quick Slot Á¤º¸ ÀúÀå¿ë!!!       
    exec _AddNewClientConfig @NewCharID  -- by novice...... for saving client configurations...       
 
COMMIT TRANSACTION       
         
RETURN @NewCharID