Chaos SRO

22/12/2019

PureSRO12_12_2019

Venus.Online

02/01/2020

06/01/2020

QueenSro

09/01/2020    23.10.2019

 

  [ ] | |  

  Silkroad4Arab Facebook  




   Silkroad Online > >

[ ] [ ]

         ::  EgyptSro.Com ( :ahmedzizoa)       :: Cannot Find Target - FTW ( : )       :: WTB Account Wizz/Cleric and Warrior/Cleric 125+++ ( :Senior Mido)       ::  Wizard - Cleirc LV 123 FF 5.8m SP ( :Senior Mido)       ::  01018144442 ( : )       :: [Release] Mercenaries Fix ( :Dev.Hyper)       ::  Start item ( :speednetroy)       :: New Server Cap 130...D14 Guard Open10/12/2019 ( :abkar2019)       :: New Server Cap 130 D14 Open 10/12/2019 ( :abkar2019)       :: Exclusive :- Random Scrolls ( :.Gamer.)       :: How to play Unique ( :BesO BadR)       ::  D10 Level 90 ( :ahmed frahat)       :: inventory trans pet Buffalo Hellp ( :speednetroy)       ::   ( :menaloka)       ::   ( :mrswat)       ::  300  ( :mrswat)       ::  ABS Scrolls Quest ( :ashrfali)       ::  Titan Uniques Hunting ( :ashrfali)       ::  speed 200% ( :ashrfali)       ::   ( :ali2015)       ::  Model Switchers ( : )       :: Model Switcher Working 100% ( :roske)       ::   ( :GMKotsh)       ::  Sro Client  ( :ali11ali)       ::  ftw ( :alieleraky)      

 
27-10-2018, 02:32 PM   #1

Hamza FiGo



  Hamza FiGo


Dec 2007
6993
6,172
Cairo
Helping ppl
Private Server
Male
973
Hamza FiGo  Hamza FiGo  Hamza FiGo  Hamza FiGo  Hamza FiGo  Hamza FiGo  Hamza FiGo  Hamza FiGo

Hamza FiGo

12004  


   Yahoo  Hamza FiGo    Skype  Hamza FiGo

  
: 1

(21) Auto Equipment: NEW







100%

Execute AddNewChar
:
Normal

PHP:
USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_AddNewChar]    Script Date: 8/24/2016 15:20:47 ******/
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. ÄÅÍ Ô Ñö¡ validÇÑ ÍÀÎÁö, ׸í ºóÔÀÌ ÂÂÁö ÕÀú ÃÅÇÑÙ.        
    
-----------------------------------------------------------------------------        
         
    -- 
start by novice.        
    
SELECT @temp count(CharIDFROM _User WITH (NOLOCKWHERE UserJID = @UserJID        
          
    
IF (@temp >= 4)        
    
BEGIN        
        
-- Ê ÀÚª        
        
RETURN -2        
    END        
    
-- finish by novice.        
      
    -----------------------------------------------------------------------------        
    -- 
2. ÄÅÍ Ãß¡ÇÏ        
    
-----------------------------------------------------------------------------        
    IF (@
CharScale 68) -- 0100 0100 --> 68 ÀÌÙ!        
    
BEGIN        
        
-- ÄÅÍ ýº ÇÆÐ! ºÄÉÀÏ ªÀÌ ÀÌóÇÏÙ!         
        
RETURN -3        
    END
        
    EXEC 
@temp _IsExistingCharName @CharName        
    
IF (@temp <> 0)        
    
BEGIN        
        
-- &#192;ÌÌ ¿ÁßÀΠÀÌÀÌóÂ?        
        
RETURN -4        
    END        
    
BEGIN TRANSACTION
    
    
-- &#192;ÎøúÅÛÀÌ À¿Ç* Áö¿¡ WorldID¿Í 1ªÀ õ Ö ÁÖúÙ!      
    
INSERT INTO _Char (RefObjIDCharName16ScaleStrengthIntellectLatestRegion,PosXPosYPosZAppointedTeleportInventorySize,      
                
LastLogoutCurLevelMaxLevelRemainGoldRemainStatPointRemainSkillPointHPMPJobLvl_TraderJobLvl_HunterJobLvl_RobberWorldID)      
    
VALUES (@RefCharID, @CharName, @CharScale2020, @StartRegionID, @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport45,      
                
GetDate(), 113500000000200,2001111)      
    
    
SET @NewCharID = @@IDENTITY        
    
IF (@@ERROR <> OR @@ROWCOUNT 0)        
    
BEGIN        
        
-- &#196;ÅÍ ýº ÇÆÐ!        
        
ROLLBACK TRANSACTION        
        
RETURN -5        
    END        
        
           
    
-- start by novice.        
    -- &
#192;ÌÁ Slot ÈÙ.. ׳É Insert ..        
    
INSERT INTO _User VALUES (@UserJID, @NewCharID)        
    -- 
finish by novice.        
      
      
     -----------------------------------------------------------------------------        
     -- 
3-1. &#192;åºñ Ô Ã¿ì        
     
-- [&#192;κÅä Ô 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(CharIDSlotItemID)        
      
SELECT @NewCharIDcnt0        
       FROM _RefDummySlot with
nolock )       
        
WHERE cnt 109        

          
    
IF (@@ERROR <> 0)        
    
BEGIN        
        
-- &#192;κÅä ýº ÇÆÐ!        
        
ROLLBACK TRANSACTION        
        
RETURN -7         
    END        

    
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!        
           
    -- 
&#240;ÆúÆΠÅÃÇÑ ÆÀÌÅÛÀ ÙàÖÁÖÀÚ...        
    /* ¿ä ø*Π ÁÀÇÇ ÀÖÙ.        
    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        
    
-- &#243;        
    
IF (@RefMailID <> 0)        
    
BEGIN        
        EXEC 
@ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID1, @RefMailID, @DurMail        
        
IF (@ItemID <= 0)        
        
BEGIN        
            ROLLBACK TRANSACTION        
            
RETURN -8        
        END        
    END        
    
-- &#217;Áö        
    
IF (@RefPantsID <> 0)        
    
BEGIN        
        EXEC 
@ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID4, @RefPantsID, @DurPants        
        
IF (@ItemID <= 0)        
        
BEGIN        
            ROLLBACK TRANSACTION        
            
RETURN -9        
        END        
    END        
    
-- Boots        
    
IF (@RefBootsID <> 0)        
    
BEGIN        
        EXEC 
@ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID5, @RefBootsID, @DurBoots        
        
IF (@ItemID <= 0)        
        
BEGIN        
            ROLLBACK TRANSACTION        
            
RETURN -10        
        END        
    END        
    
-- Weapon        
    
IF (@RefWeaponID <> 0)        
    
BEGIN        
        EXEC 
@ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID6, @RefWeaponID, @DurWeapon        
        
IF (@ItemID <= 0)        
        
BEGIN        
            ROLLBACK TRANSACTION        
            
RETURN -11        
        END        
    END        
    
-- &#230;ÆР       
    
IF (@RefShield <> 0)        
    
BEGIN        
        EXEC 
@ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID7, @RefShield, @DurShield        
        
IF (@ItemID <= 0)        
        
BEGIN        
            ROLLBACK TRANSACTION        
            
RETURN -12        
        END        
    END        
    
-- &#200;àdefaultΠÅÃÇÑ ¡ ÈÀÌó È*ì 250ÀÌ ÈÅ뵵 ÇÔ ÁØÙ. ÁÒÄ¡?        
    
IF (@DefaultArrow <> 0)        
    
BEGIN        
        EXEC 
@ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID7, @DefaultArrow250        
        
IF (@ItemID <= 0)        
        
BEGIN        
            ROLLBACK TRANSACTION        
            
RETURN -13        
        END        
    END
    exec SRO_VT_SHARD
..__AUTO_EQUIP_GEAR @CharName 3

     
-----------------------------------------------------------------------------        
     -- 
3-2. &#198;ÙÅ Inventory Ô Ã¿ì        
     
-- [&#198;ÙÅ ÀκÅä Ô 5]
     
-- APPLY_AVATAR_SYSTEM&#192;Ì À¿Ç* Ãß¡Ç ºÎºÐ
     
-----------------------------------------------------------------------------        
     --
PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!        
     
INSERT INTO _InventoryForAvatar(CharIDSlotItemID)        
      
SELECT @NewCharIDcnt0
       FROM _RefDummySlot with
nolock )       
        
WHERE cnt 5

          
    
IF (@@ERROR <> 0)        
    
BEGIN        
        
-- &#198;ÙÅ ÀκÅä ýº ÇÆÐ!        
        
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&#214;ÁÖ        
    
-----------------------------------------------------------------------------        
    DECLARE @
country tinyINT        
    EXEC 
@country _GetObjCountry @RefCharID        
           
    INSERT INTO _CharSkillMastery 
(CharIDMasteryIDLevel)        
    
SELECT @NewCharIDMasteryID0        
    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 @NewCharIDSkillID1        
    FROM  _RefCharDefault_Skill  with
(nolock)      
    
WHERE Race = @country or Race 3        
    
IF (@@error <> 0)        
    
BEGIN        
        ROLLBACK TRANSACTION        
        
RETURN -16        
    END        
    
-----------------------------------------------------------------------------        
    -- 
&#186; ÄºÆ ÖÁÖ
    
-----------------------------------------------------------------------------        
    
INSERT INTO _CharQuest (CharIDQuestIDStatusAchievementCountStartTimeEndTimeQuestData1QuestData2)        
    
SELECT @NewCharIDID10getdate(), getdate(), 00        
    FROM _RefQuest
    WHERE CodeName in 
(SELECT CodeName FROM _RefCharDefault_Quest  with(nolockWHERE (Race = @country or Race 3) and RequiredLevel and Service 1)
    IF (@@
error <> 0)
    
BEGIN
        ROLLBACK TRANSACTION        
        
RETURN -17        
    END    
    
-----------------------------------------------------------------------------        
    -- Static 
Avatar Initial Record &#214;        
    
-----------------------------------------------------------------------------        
    
INSERT INTO _StaticAvatar(CharIDvalues(@NewCharID)        
    IF (@@
ERROR <> 0)        
    
BEGIN        
        ROLLBACK TRANSACTION        
        
RETURN -18        
    END         
          
    
-----------------------------------------------------------------------------        
    -- 
Trijob &#195;¿öÖ!!!!!        
    
-----------------------------------------------------------------------------        
    
INSERT INTO _CharTrijob VALUES (@NewCharID01000)        
    IF (@@
ERROR <> 0)        
    
BEGIN        
        
-- &#192;κÅä ýº ÇÆÐ!        
        
ROLLBACK TRANSACTION        
        
RETURN -19        
    END         
          
    
-----------------------------------------------------------------------------        
    -- 
CharList&#191;¡ ID ÖÁÖ        
    
-----------------------------------------------------------------------------        
    
INSERT _CharNameList VALUES(@CharName, @NewCharID)        
          
    
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_HP_SUPERSET_5_BAG',1000,1  
    exec _ADD_ITEM_EXTERN 
@CharName,'ITEM_MALL_MP_SUPERSET_5_BAG',1000,1      
    exec _ADD_ITEM_EXTERN 
@CharName,'ITEM_COS_P_RABBIT_SCROLL',1,1      
    exec _ADD_ITEM_EXTERN 
@CharName,'ITEM_ETC_SCROLL_RETURN_NEWBIE_01',20,1      
          
    
-- Quick Slot &#193;º ÀúÀå¿!!!        
    
exec _AddNewClientConfig @NewCharID  -- by novice...... for saving client configurations...        

COMMIT TRANSACTION        
          
RETURN @NewCharID 
Sun

PHP:
USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_AddNewChar]    Script Date: 7/2/2016 8:22:40 PM ******/
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 3643BEGIN
    SET 
@RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_01_AA_A_RARE')
    
SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_06_BA_A_RARE')
    
SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_06_FA_A_RARE')
    
SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_06_HA_A_RARE')
    
SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_06_LA_A_RARE')
    
SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_CLOTHES_06_SA_A_RARE')
    
SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_01_A_RARE')
    
SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_01_A_RARE')
    
SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_01_A_RARE')
 
END
 
 
--Male Heavy Armor Chinese
 
IF (@RefMailID 3637BEGIN
    SET 
@RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_01_AA_A_RARE')
    
SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_06_BA_A_RARE')
    
SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_06_FA_A_RARE')
    
SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_06_HA_A_RARE')
    
SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_06_LA_A_RARE')
    
SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_HEAVY_06_SA_A_RARE')
    
SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_01_A_RARE')
    
SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_01_A_RARE')
    
SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_01_A_RARE')
 
END
 
 
--Male Light Armor Chinese
 
IF (@RefMailID 3640BEGIN
    SET 
@RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_01_AA_A_RARE')
    
SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_06_BA_A_RARE')
    
SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_06_FA_A_RARE')
    
SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_06_HA_A_RARE')
    
SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_06_LA_A_RARE')
    
SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_M_LIGHT_06_SA_A_RARE')
    
SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_01_A_RARE')
    
SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_01_A_RARE')
    
SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_01_A_RARE')
 
END
 
 
--Female Clothes Chinese
 
IF (@RefMailID 3652BEGIN
    SET 
@RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_01_AA_A_RARE')
    
SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_06_BA_A_RARE')
    
SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_06_FA_A_RARE')
    
SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_06_HA_A_RARE')
    
SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_06_LA_A_RARE')
    
SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_CLOTHES_06_SA_A_RARE')
    
SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_01_A_RARE')
    
SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_01_A_RARE')
    
SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_01_A_RARE')
 
END
 
 
--Female Heavy Armor Chinese
 
IF (@RefMailID 3646BEGIN
    SET 
@RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_01_AA_A_RARE')
    
SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_06_BA_A_RARE')
    
SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_06_FA_A_RARE')
    
SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_06_HA_A_RARE')
    
SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_06_LA_A_RARE')
    
SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_HEAVY_06_SA_A_RARE')
    
SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_01_A_RARE')
    
SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_01_A_RARE')
    
SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_01_A_RARE')
 
END
 
 
--Female Light Armor Chinese
 
IF (@RefMailID 3649BEGIN
    SET 
@RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_01_AA_A_RARE')
    
SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_06_BA_A_RARE')
    
SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_06_FA_A_RARE')
    
SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_06_HA_A_RARE')
    
SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_06_LA_A_RARE')
    
SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_W_LIGHT_06_SA_A_RARE')
    
SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_EARRING_01_A_RARE')
    
SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_NECKLACE_01_A_RARE')
    
SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_RING_01_A_RARE')
 
END
 
 
--Male Clothes Europe
 
IF (@RefMailID 11623BEGIN
    SET 
@RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_01_AA_A_RARE')
    
SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_06_BA_A_RARE')
    
SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_06_FA_A_RARE')
    
SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_06_HA_A_RARE')
    
SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_06_LA_A_RARE')
    
SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_CLOTHES_06_SA_A_RARE')
    
SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_01_A_RARE')
    
SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_01_A_RARE')
    
SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_01_A_RARE')
 
END
 
 
--Male Heavy Armor Europe
 
IF (@RefMailID 11617BEGIN
    SET 
@RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_01_AA_A_RARE')
    
SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_06_BA_A_RARE')
    
SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_06_FA_A_RARE')
    
SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_06_HA_A_RARE')
    
SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_06_LA_A_RARE')
    
SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_HEAVY_06_SA_A_RARE')
    
SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_01_A_RARE')
    
SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_01_A_RARE')
    
SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_01_A_RARE')
 
END
 
 
--Male Light Armor Europe
 
IF (@RefMailID 11620BEGIN
    SET 
@RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_01_AA_A_RARE')
    
SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_06_BA_A_RARE')
    
SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_06_FA_A_RARE')
    
SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_06_HA_A_RARE')
    
SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_06_LA_A_RARE')
    
SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_M_LIGHT_06_SA_A_RARE')
    
SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_01_A_RARE')
    
SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_01_A_RARE')
    
SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_01_A_RARE')
 
END
 
 
--Female Clothes Europe
 
IF (@RefMailID 11632BEGIN
    SET 
@RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_01_AA_A_RARE')
    
SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_06_BA_A_RARE')
    
SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_06_FA_A_RARE')
    
SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_06_HA_A_RARE')
    
SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_06_LA_A_RARE')
    
SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_CLOTHES_06_SA_A_RARE')
    
SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_01_A_RARE')
    
SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_01_A_RARE')
    
SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_01_A_RARE')
 
END
 
 
--Female Heavy Armor Europe
 
IF (@RefMailID 11626BEGIN
    SET 
@RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_01_AA_A_RARE')
    
SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_06_BA_A_RARE')
    
SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_06_FA_A_RARE')
    
SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_06_HA_A_RARE')
    
SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_06_LA_A_RARE')
    
SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_HEAVY_06_SA_A_RARE')
    
SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_01_A_RARE')
    
SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_01_A_RARE')
    
SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_01_A_RARE')
 
END
 
 
--Female Light Armor Europe
 
IF (@RefMailID 11629BEGIN
    SET 
@RefHandID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_01_AA_A_RARE')
    
SET @RefMailID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_06_BA_A_RARE')
    
SET @RefBootsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_06_FA_A_RARE')
    
SET @RefHatID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_06_HA_A_RARE')
    
SET @RefPantsID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_06_LA_A_RARE')
    
SET @RefShoulderID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_W_LIGHT_06_SA_A_RARE')
    
SET @RefEarringID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_EARRING_01_A_RARE')
    
SET @RefNeckID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_NECKLACE_01_A_RARE')
    
SET @RefRingID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_RING_01_A_RARE')
 
END
 
 
--Shield Chinese
 
IF (@RefShield 10886BEGIN
    SET 
@RefShield = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_SHIELD_01_A_RARE')
 
END
 
 
--Shield Europe
 
IF (@RefShield 10896BEGIN
    SET 
@RefShield = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_SHIELD_01_A_RARE')
 
END
 
 
--Blade Chinese
 
IF (@RefWeaponID 3633BEGIN
    SET 
@RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_BLADE_01_A_RARE')
 
END
 
 
--Bow Chinese
 
IF (@RefWeaponID 3636BEGIN
    SET 
@RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_BOW_01_A_RARE')
 
END
 
 
--Spear Chinese
 
IF (@RefWeaponID 3634BEGIN
    SET 
@RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_SPEAR_01_A_RARE')
 
END
 
 
--Sword Chinese
 
IF (@RefWeaponID 3632BEGIN
    SET 
@RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_SWORD_01_A_RARE')
 
END
 
 
--Glavie Chinese
 
IF (@RefWeaponID 3635BEGIN
    SET 
@RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_CH_TBLADE_01_A_RARE')
 
END
 
 
--Axe Europe
 
IF (@RefWeaponID 10890BEGIN
    SET 
@RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_AXE_01_A_RARE')
 
END
 
 
--XBow Europe
 
IF (@RefWeaponID 10891BEGIN
    SET 
@RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_CROSSBOW_01_A_RARE')
 
END
 
 
--Dagger Europe
 
IF (@RefWeaponID 10887BEGIN
    SET 
@RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_DAGGER_01_A_RARE')
 
END
 
 
--Darkstaff Europe
 
IF (@RefWeaponID 10892BEGIN
    SET 
@RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_DARKSTAFF_01_A_RARE')
 
END
 
 
--Harp Europe
 
IF (@RefWeaponID 10894BEGIN
    SET 
@RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_HARP_01_A_RARE')
 
END
 
 
--Cleric Rod Europe
 
IF (@RefWeaponID 10895BEGIN
    SET 
@RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_STAFF_01_A_RARE')
 
END
 
 
--Sword Europe
 
IF (@RefWeaponID 10888BEGIN
    SET 
@RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_SWORD_01_A_RARE')
 
END
 
 
--Staff Europe
 
IF (@RefWeaponID 10893BEGIN
    SET 
@RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_TSTAFF_01_A_RARE')
 
END
 
 
--Twohand Sword Europe
 
IF (@RefWeaponID 10889BEGIN
    SET 
@RefWeaponID = (SELECT ID FROM _RefObjCommon WHERE CodeName128='ITEM_EU_TSWORD_01_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(CharIDFROM _User WITH (NOLOCKWHERE UserJID = @UserJID        
          
    
IF (@temp >= 4)        
    
BEGIN        
        
-- &#65533;ʹ� ���ڳ�        
        
RETURN -2        
    END        
    
-- finish by novice.        
    
    -----------------------------------------------------------------------------        
    -- 
2. &#307;���� �߰��ϱ�        
    
-----------------------------------------------------------------------------        
    IF (@
CharScale 68) -- 0100 0100 --> 68 &#65533;̴�!        
    
BEGIN        
        
-- &#307;���� ���� ����! ������ ���� �̻��ϴ�!         
        
RETURN -3        
    END
        
    EXEC 
@temp _IsExistingCharName @CharName        
    
IF (@temp <> 0)        
    
BEGIN        
        
-- &#65533;̹� ������� �̸��̶��?        
        
RETURN -4        
    END        
    
BEGIN TRANSACTION
    

    
-- &#65533;δ��ý����� ����Ǹ鼭 �������� WorldID�� 1���� �� �־� �־���!      
    
INSERT INTO _Char (RefObjIDCharName16ScaleStrengthIntellectLatestRegion,PosXPosYPosZAppointedTeleportInventorySize,      
                
LastLogoutCurLevelMaxLevelRemainGoldRemainStatPointRemainSkillPointHPMPJobLvl_TraderJobLvl_HunterJobLvl_RobberWorldID)      
    
VALUES (@RefCharID, @CharName, @CharScale2020, @StartRegionID, @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport45,      
                
GetDate(), 11000200,2001111)  

    
SET @NewCharID = @@IDENTITY        
    
IF (@@ERROR <> OR @@ROWCOUNT 0)        
    
BEGIN        
        
-- &#307;���� ���� ����!        
        
ROLLBACK TRANSACTION        
        
RETURN -5        
    END        
    
-- start by novice.        
    -- &
#65533;��� Slot �Ⱦ���.. �׳� Insert ��..        
    
INSERT INTO _User VALUES (@UserJID, @NewCharID)        
    -- 
finish by novice.        
    
    
     -----------------------------------------------------------------------------        
     -- 
3-1. &#65533;�� ���� ä���        
     
-- [&#65533;κ��丮 ���� 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(CharIDSlotItemID)        
      
SELECT @NewCharIDcnt0        
       FROM _RefDummySlot with
nolock )       
        
WHERE cnt 109        

          
    
IF (@@ERROR <> 0)        
    
BEGIN        
        
-- &#65533;κ��丮 ���� ����!        
        
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 <> 0BEGIN
    EXEC 
@ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID1, @RefMailID, @DurMail
    
IF (@ItemID <= 0BEGIN
        ROLLBACK TRANSACTION
        
RETURN -8
    END
 END
 
-- Hand
 
IF (@RefHandID <> 0BEGIN
    EXEC 
@ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID3, @RefHandID, @DurHand
    
IF (@ItemID <= 0BEGIN
        ROLLBACK TRANSACTION
        
RETURN -8
    END
 END
 
-- Hat
 
IF (@RefHatID <> 0BEGIN
    EXEC 
@ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID0, @RefHatID, @DurHat
    
IF (@ItemID <= 0BEGIN
        ROLLBACK TRANSACTION
        
RETURN -8
    END
 END
 
-- Shoulder
 
IF (@RefShoulderID <> 0BEGIN
    EXEC 
@ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID2, @RefShoulderID, @DurShoulder
    
IF (@ItemID <= 0BEGIN
        ROLLBACK TRANSACTION
        
RETURN -8
    END
 END
 
-- Pants 
 
IF (@RefPantsID <> 0BEGIN    
    EXEC 
@ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID4, @RefPantsID, @DurPants
    
IF (@ItemID <= 0BEGIN    
        ROLLBACK TRANSACTION    
        
RETURN -9    
    END    
 END    
 
-- Boots    
 
IF (@RefBootsID <> 0BEGIN    
    EXEC 
@ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID5, @RefBootsID, @DurBoots
    
IF (@ItemID <= 0BEGIN    
        ROLLBACK TRANSACTION    
        
RETURN -10    
    END    
 END    
 
-- Weapon    
 
IF (@RefWeaponID <> 0BEGIN   
    EXEC 
@ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID6, @RefWeaponID, @DurWeapon
    
IF (@ItemID <= 0BEGIN    
        ROLLBACK TRANSACTION    
        
RETURN -11    
    END    
 END    
 
-- Shield
 
IF (@RefShield <> 0BEGIN    
    EXEC 
@ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID7, @RefShield, @DurShield
    
IF (@ItemID <= 0BEGIN    
        ROLLBACK TRANSACTION    
        
RETURN -12    
    END    
 END    
 
-- Arror/Bolt
 
IF (@DefaultArrow <> 0BEGIN    
    EXEC 
@ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID7, @DefaultArrow250
    
IF (@ItemID <= 0BEGIN    
        ROLLBACK TRANSACTION    
        
RETURN -13    
    END    
 END
 
-- Earring
 
IF (@RefEarringID <> 0BEGIN
    EXEC 
@ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID9, @RefEarringID, @DurEarring
    
IF (@ItemID <= 0BEGIN
        ROLLBACK TRANSACTION
        
RETURN -8
    END
 END
 
-- Ring 1
 
IF (@RefRingID <> 0BEGIN
    EXEC 
@ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID11, @RefRingID, @DurRing
    
IF (@ItemID <= 0BEGIN
        ROLLBACK TRANSACTION
        
RETURN -8
    END
 END
 
-- Ring 2
 
IF (@RefRingID <> 0BEGIN
    EXEC 
@ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID12, @RefRingID, @DurRing
    
IF (@ItemID <= 0BEGIN
        ROLLBACK TRANSACTION
        
RETURN -8
    END
 END
 
-- Necklace
 
IF (@RefNeckID <> 0BEGIN
    EXEC 
@ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID10, @RefNeckID, @DurNeck
    
IF (@ItemID <= 0BEGIN
        ROLLBACK TRANSACTION
        
RETURN -8
    END
 END
 
-- Initial Equip Edit by LemoniscooL
     
     
-----------------------------------------------------------------------------        
     -- 
3-2. &#65533;ƹ�Ÿ Inventory ���� ä���        
     
-- [&#65533;ƹ�Ÿ �κ��丮 ���� 5��]
     
-- APPLY_AVATAR_SYSTEM&#65533;� ����Ǹ鼭 �߰��Ǵ� �κ�
     
-----------------------------------------------------------------------------        
     --
PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!        
     
INSERT INTO _InventoryForAvatar(CharIDSlotItemID)        
      
SELECT @NewCharIDcnt0
       FROM _RefDummySlot with
nolock )       
        
WHERE cnt 5

          
    
IF (@@ERROR <> 0)        
    
BEGIN        
        
-- &#65533;ƹ�Ÿ �κ��丮 ���� ����!        
        
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&#65533;־��ֱ�        
    
-----------------------------------------------------------------------------        
    DECLARE @
country tinyINT        
    EXEC 
@country _GetObjCountry @RefCharID        
           
    INSERT INTO _CharSkillMastery 
(CharIDMasteryIDLevel)        
    
SELECT @NewCharIDMasteryID0        
    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 @NewCharIDSkillID1        
    FROM  _RefCharDefault_Skill  with
(nolock)      
    
WHERE Race = @country or Race 3        
    
IF (@@error <> 0)        
    
BEGIN        
        ROLLBACK TRANSACTION        
        
RETURN -16        
    END        
    
-----------------------------------------------------------------------------        
    -- &
#65533;⺻ ����Ʈ �־��ֱ�
    
-----------------------------------------------------------------------------        
    
INSERT INTO _CharQuest (CharIDQuestIDStatusAchievementCountStartTimeEndTimeQuestData1QuestData2)        
    
SELECT @NewCharIDID10getdate(), getdate(), 00        
    FROM _RefQuest
    WHERE CodeName in 
(SELECT CodeName FROM _RefCharDefault_Quest  with(nolockWHERE (Race = @country or Race 3) and RequiredLevel and Service 1)
    IF (@@
error <> 0)
    
BEGIN
        ROLLBACK TRANSACTION        
        
RETURN -17        
    END    
    
-----------------------------------------------------------------------------        
    -- Static 
Avatar Initial Record &#65533;ֱ�        
    
-----------------------------------------------------------------------------        
    
INSERT INTO _StaticAvatar(CharIDvalues(@NewCharID)        
    IF (@@
ERROR <> 0)        
    
BEGIN        
        ROLLBACK TRANSACTION        
        
RETURN -18        
    END         
          
    
-----------------------------------------------------------------------------        
    -- 
Trijob &#228;���ֱ�!!!!!        
    
-----------------------------------------------------------------------------        
    
INSERT INTO _CharTrijob VALUES (@NewCharID01000)        
    IF (@@
ERROR <> 0)        
    
BEGIN        
        
-- &#65533;κ��丮 ���� ����!        
        
ROLLBACK TRANSACTION        
        
RETURN -19        
    END         
          
    
-----------------------------------------------------------------------------        
    -- 
CharList&#65533;� ID �־��ֱ�        
    
-----------------------------------------------------------------------------        
    
INSERT _CharNameList VALUES(@CharName, @NewCharID)        
    
UPDATE _Items SET OptLevel=3 WHERE ID64 IN (SELECT ItemID FROM _Inventory WHERE Slot BETWEEN 0 AND 12 AND Slot Not LIKE '8' AND CharID=@NewCharID)
     
EXEC SRO_VT_SHARDLOG.dbo._AutoEquipmentTEST @NewCharID,1


    
    exec _ADD_ITEM_EXTERN 
@CharName,'ITEM_EVENT_RETURN_SCROLL_HIGH_SPEED',25,1  
 exec _ADD_ITEM_EXTERN 
@CharName,'ITEM_EVENT_RENT_REVERSE_RETURN_SCROLL',25,1
 exec _ADD_ITEM_EXTERN 
@CharName,'ITEM_COS_P_CAT_SCROLL',1,0
 exec _ADD_ITEM_EXTERN 
@CharName,'ITEM_ETC_SPEED_UP_BASIC',20,0
  exec _ADD_ITEM_EXTERN 
@CharName,'ITEM_ETC_HP_POTION_05',1000,0
 exec _ADD_ITEM_EXTERN 
@CharName,'ITEM_ETC_MP_POTION_05',1000,0
      
            
    
-- Quick Slot &#65533;��� �����!!!        
    
exec _AddNewClientConfig @NewCharID  -- by novice...... for saving client configurations...        

COMMIT TRANSACTION        
          
RETURN @NewCharID 
Create Table

PHP:
USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[_RoyalItemPoolAutoEquipment]    Script Date: 7/2/2016 8:27:19 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE 
[dbo].[_RoyalItemPoolAutoEquipment](
    [
service] [intNOT NULL,
    [
ID] [intNOT NULL,
    [
CodeName128] [varchar](129NOT NULL,
    [
TypeID1] [tinyintNOT NULL,
    [
TypeID2] [tinyintNOT NULL,
    [
TypeID3] [tinyintNOT NULL,
    [
TypeID4] [tinyintNOT NULL,
    [
ReqLevel1] [tinyintNOT NULL,
    [
Gender] [tinyintNULL,
    [
P1] [bigintNULL,
    [
P2] [bigintNULL,
    [
P3] [bigintNULL,
    [
P4] [bigintNULL,
    [
P5] [bigintNULL,
    [
P6] [bigintNULL,
    [
P7] [bigintNULL,
    [
P8] [bigintNULL,
    [
P9] [bigintNULL,
    [
MagParamNum] [tinyintNULL,
    [
Va] [bigintNULL,
    [
Race] [bitNULL,
 
CONSTRAINT [PK__RoyalItemPoolAutoEquipmentPRIMARY KEY CLUSTERED 
(
    [
IDASC
)WITH (PAD_INDEX OFFSTATISTICS_NORECOMPUTE OFFIGNORE_DUP_KEY OFFALLOW_ROW_LOCKS ONALLOW_PAGE_LOCKS ONON [PRIMARY]
ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO 


PHP:
USE [SRO_VT_SHARDLOG]
GO
/****** Object:  StoredProcedure [dbo].[_AutoEquipmentTEST]    Script Date: 2/7/2016 8:26:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE procedure 
[dbo].[_AutoEquipmentTEST]
    @
CharID INT,
    @
data2 INT
AS
    



    DECLARE @
Flag INT 0,    @ID64 INT, @ReFObjID INT, @ReFItemID INT, @T1 TINYINT, @T2 TINYINT, @T3 TINYINT, @T4 TINYINT, @optLvl TINYINT, @race BIT, @Gen TINYINT, @REQLVL INT;
    
SELECT @Gen = CASE WHEN RefObjID BETWEEN 1920 AND 1932 THEN 2 WHEN RefObjID <= 1919 THEN 1 WHEN RefObjID BETWEEN 14875 AND 14887 THEN 3 WHEN RefObjID BETWEEN 14888 AND 14900 THEN 4 ELSE 0 END FROM SRO_VT_SHARD.._Char WITH (NOLOCKWHERE CharID = @CharID
    SELECT 
@race = CASE WHEN @Gen IN (1,2THEN 0 WHEN @Gen IN (3,4THEN 1 ELSE NULL END
    
IF  (@race IS NULL) RETURN;
    WHILE @
Flag <13    BEGIN
            SELECT 
@ID64 0, @ReFItemID 0, @ReFObjID 0, @T1 0, @T2 =0, @T3 0, @T4 0
            
IF @Flag != 8 BEGIN
                    SELECT 
@ID64 I.ItemID, @ReFObjID IT.RefItemID, @optLvl IT.OptLevel FROM SRO_VT_SHARD.._Inventory I WITH (NOLOCKINNER JOIN SRO_VT_SHARD.._Items IT WITH (NOLOCKON I.ItemID IT.ID64 WHERE I.Slot = @Flag AND I.CharID = @CharID AND IT.ID64    NOT IN (62,3655382324459383451038310885,196442446038346) -- Arrows Bolts...
                    IF @
ID64  != 0  AND @ReFObjID IS NOT NULL BEGIN
                            SELECT 
@T1 TypeID1,@T2 TypeID2, @T3 TypeID3, @T4 TypeID4, @REQLVL ReqLevel1 FROM SRO_VT_SHARD.._RefObjCommon WHERE    ID = @ReFObjID
                            SELECT 
@optLvl = CASE WHEN @optLvl >= 3 THEN @optLvl ELSE 3 END
                            
if (@REQLVL <= 82 )
                            
BEGIN
                            UPDATE    SRO_VT_SHARD
.._Items SET RefItemID Q.IDVariance  ISNULL(Q.Va0),    MagParam1 Q.P1MagParam2 Q.P2MagParam3 Q.P3MagParam4 Q.P4MagParam5 Q.P5MagParam6 Q.P6MagParam7 Q.P7MagParam8 Q.P8MagParam9 Q.P9MagParamNum Q.MagParamNumOptLevel = @optLvl FROM    (SELECT TOP 1 IDP1P2P3P4P5P6P7P8P9Va, CASE WHEN P1 0 THEN 0 WHEN P5 0 THEN 4 WHEN P6 0 THEN 5 WHEN P7 0 THEN 6 WHEN P8 0 THEN 7 ELSE 0 END AS MagParamNum FROM        SRO_VT_SHARDLOG.._royalitempoolautoequipment P WITH (NOLOCKWHERE typeid1 = @T1 AND typeid2 = @T2 AND typeid3 = @T3 AND typeid4 = @T4 AND (Gender = @Gen OR Gender 0) AND Race = @race AND ReqLevel1 <= @data2 ORDER  BY reqlevel1 DESC) AS Q WHERE ID64 = @ID64 AND ID64 != AND Q.ID != 0 END END 
                           END
                            SET 
@Flag += 1 END 
AddLogChar as

PHP:
        IF (@EventID 22) -- Character level up
               BEGIN
                EXEC SRO_VT_SHARDLOG
.dbo._AutoEquipmentTEST  @CharID,@Data2
               END 

SQL
_RoyalItemPoolAutoEquipment

..

,,, [ ] ,,, [ ]
,,, [ ]

...


Hamza FiGo :
,,, [ ]
,,, [ ]
,,, [ ]

,,, [ ] || ,,, [ ] || ,,, [ ]


google

27-10-2018, 02:51 PM   #2

Scrox



  Scrox


Apr 2017
132672
1,328
Qena
Developermnt & Designs
Private Server
Male
38
Scrox

Scrox

6076  


   Yahoo  Scrox

: Auto Equipment: NEW



#Reserved


Scrox :
,,, [ ]



27-10-2018, 05:20 PM   #3

Mahmoud Rashwan



  Mahmoud Rashwan


Oct 2008
37620
3,175
No Server
Male
1081
Mahmoud Rashwan   Mahmoud Rashwan   Mahmoud Rashwan   Mahmoud Rashwan   Mahmoud Rashwan   Mahmoud Rashwan   Mahmoud Rashwan   Mahmoud Rashwan

Mahmoud Rashwan

10004  


   AIM  Mahmoud Rashwan

: Auto Equipment: NEW







27-10-2018, 05:27 PM   #4

Warriors





Mar 2017
132464
58
No Server
Male
10
Warriors

Warriors

181  



: Auto Equipment: NEW







27-10-2018, 10:42 PM   #5

BuiLt4KiLl



  BuiLt4KiLl


Jul 2014
118364
1,847
Kuwait
Private Server
Male
67
BuiLt4KiLl

BuiLt4KiLl

7406  




  
: 1

: Auto Equipment: NEW





BuiLt4KiLl :


27-10-2018, 11:25 PM   #6

.Gamer.


Be Smart

  .Gamer.


Jul 2015
123161
2,929
Mansoura Egypt
Developer At Private Silkroad
Private Server
Male
33
.Gamer.

.Gamer.

15628  


   Skype  .Gamer.

     
: 2

: Auto Equipment: NEW





.Gamer. :
,,, [ ]


,,, [ ]


29-10-2018, 01:13 AM   #7

_Legend_R_





Aug 2017
133345
262
Private Server
Male
10
_Legend_R_

_Legend_R_

545  



: Auto Equipment: NEW



12




09-06-2019, 11:43 AM   #8

ahmedjak1993



  ahmedjak1993


Feb 2011
79302
139
Private Server
Male
10
ahmedjak1993

ahmedjak1993

383  



: Auto Equipment: NEW









ahmedjak1993 :


01-12-2019, 02:58 PM   #9

malak2100





Mar 2017
132613
2
No Server
Male
10
malak2100

malak2100

4  



: Auto Equipment: NEW



The module '_AddNewChar' depends on the missing object 'SRO_VT_SHARD..__AUTO_EQUIP_GEAR'. The module will still be created; however, it cannot run successfully until the object exists.





auto, auto equip, equip, equipment

« | »

: 1 (0 1 )
 




09:12 AM.

@ @ @ @ @ @ SilkroadOnline @ @ @ @ @ @ @ @ (Gold) @ ( Gold) @ (Gold) @ @ ( Korean SilkRoad ) @ AgBot @ ( Accounts ) @ ( Item ) @ ( Item ) @ @ Flora @ Minerva @ Feronia @ Bellona @ [ iSro ] @ @ @ @ PhBot @ -== T-BOT ==- @ Ceres @ @ @ @ @ @ @ StealthLite Bot @ Agbot @ StealthLite @ PHBOT @ T-BOT @ SroKing Bot @ [ iSro ] @ Flora @ Ceres @ Bellona @ Minerva @ Feronia @ 2019 @ @ @ @ ECSRO @ ECSRO(Fembria) @ ECSRO(VIP) @ SJSRO (OLD) @ SJSRO (new) @ sunworld @ IBot @ @ Vsro @ Rusro @ [ Private-SRO ] @ ZSZC & Aurora @ Sbot @ Mbot @ V.I.P Zone @ VIP @ VIP @ [ PK2 Edit ] @ Mysro @ @ @ @ IBOT @ Sbot @ Mbot @ Sroking @ Elite & Eroad @ DreamWorld @ [ Silkroad-R ] @ Maycena @ @ [ Silkroad-R ] @ - Private SRO @ Perfection @ Ex.Silkroad R @ SroKings @ @ Other Online Games @ S4 League @ CrossFire @ Conquer Online @ LOL @ Pc Games @ @ Barons Online @ (AriesOnline (Pvp @ QueenSRO Network @ & S4 League @ & CrossFire @ World's Gate @ Sun-World @ Aion @ Continent Of The Ninth @ World Of Warcraft @ PanicSro @ @ @ IceSro-R @ Kings_Silkroad @ Justice Road @ ArabianRoadOnline Network @ Devias Online @ @ CrossFire Fantasy Game @ CrossFire @ & Aion @ & Conquer Online @ League Of Legends @ legenD road @ WantedSro Online @ @ @ Mixsro @ @ SRO-R @ LegenD Road @ Knights War Online @ Evolution Network @ FlagSRO Network @ Perfection (PvP) Network @ S4league @ @ @ @ @ Destructions Network @ FanTasYWorld @ @ Smart-Sro Online @ InFusion Online @ @ Divine Online @ Dota @ PC @ GameXen Network @ inferno online @ @ @ PK2 edit @ Velestia @ Punisher Sro Online @ Atlantis Online @ ALEXNADER SRO @ Hell World Online @ ImmortalRoad @ Centerbot @ Centerbot @ Time.Sro-Online @ Revenge (PVE) Online @ Silkroad4arab || Games Online @ Online Games @ ( - ) @ @ @ @ @ @ @ @ Creddy Online @ Alliance-sro @ Quick Road (PvP ) @ @ League Of Legends @ League Of Legends @ CrossFire @ League Of Legends @ [ LOL ] @ North America @ EU West @ EU Nordic & East @ League Of Legends @ @ @ @ Wolf team @ Dota 2 @ Dragon nest @ DC Universe Online @ Windows @ Quenth Online @ Wolf team Arabic @ RealDreamSro ( PvP ) @ EmpireSRO @ Amazing Sro @ Speed-sro @ . Destructions Network @ SilkRoad E 80 China @ @ @ Greats-sro Online @ @ @ Srowing @ Dakupra-Online @ @ @ @ @ @ @ @ PantuSRO @ (Silkroad4arab vps , server) @ Tyr Online @ RocSro @ Legend Of Silkroad @ Pioneer Gaming-Network @ Valentus - CAP 80 @ MirrorSro @ Eridanus Online Cap90 @ Fear-Sro @ Silkroad-Z Online PVE @ @ Massive-Network @ Kryptonite-Sro @ DeathRoad @ Mysro Servers @ Devils Team @ DooMSRO Network @ EROAD SRO @ Story-SRO @ Ventrue-Online @ Settlers-SRO @ Electus Online @ MarsRoad Online @ Arrow Online @ Selene @ Hermes @ OldSro Online (cap 80 ) @ Sunroad @ Eloys Online @ Sentiero-Road Online @ Steam-Sro @ Arcane Reborn Online @ Eryxonline @ Vengeance Online @ Mirage Online @ SyndiCateOnline @ Desert Sro @ NeSro Network @ Android @ @ @ MegaWar Sro @ Mirror Sro @ AdvancedSRO @ OblivionSilkroad @ Arrivals_Sro @ Amphibius Online @ Royal online @ Forbidden-Sro @ vanish-sro @ Majesty Online @ Chaos Network @ srAssist Bot @ srAssist Bot @ Damocles Sro @ Demo Sro @ KingsRoad @ Arius 9D ch & eu @ brother sro @ DreamWorld-Online @ Poseidon-Sro @ Ph-Sro @ Jupiet-Online @ Fury Sro @ JungleSro @ Xemia Games @ invctus-sro @ Revolution Gaming Network @ DemonSro @ Aeolus @ Golden Sro @ Chaos Reborn @ Chaos II Online @ Fallen Soul @ StarLife Online @ Xian @ Xian @ Revira online @ @ 2018 @ Bcsro Online @ Unix Sro @ Immortal SRO @ Justice Online @ [English - Arabic - Videos] @ Egypt-Sro @ (Rap) @ | WWE @ @ Perfection SRO @ Rev-Sro @ Destiny-Network @ Egypt Sro @ Data Base @ PUBG Mobile @ Fortnite @ PureSRO @ Rectos Online @ Lunox Online @ Knight-Sro @ Hypnos Online @ Venus.Online @ Helix Sro @ Flox Sro @ EGYSro @


- - -