Vsro Files - Max Cap, NPC Edit, Items

Page 4 of 5 « First 23 4 5
10/10/2011 20:58 sarkoplata#46
Quote:
Originally Posted by fiction12 View Post
was that necesary?...
Ignore that.
-
There is entry named "ExpOffset" in char table in SHARD db, you can change experience, never tried before :P
10/10/2011 21:33 Zoxon#47
so some1 could help me?
10/10/2011 22:18 lesderid#48
Quote:
Originally Posted by fiction12 View Post
was that necesary?...
imo, yes.
11/08/2011 01:32 younex#49
ok i solved ur problem even no one solve my problems i solve them myself
Go to ==> SRO_VT_SHARD => Programmability => Stored Procedures => _AddNewChar => Right Click => Modify
Copy Paste & replace everything

--try to learn some SQL Codding ;)
BTW This Module is fully recompiled by Me

Code:
USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_AddNewChar]    Script Date: 11/07/2011 23:36:07 ******/
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 = '[MA]' + @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¸¯ÅÍ »ý¼º ½ÇÆÐ! ½ºÄÉÀÏ °ªÀÌ ÀÌ»óÇÏ´Ù!         
        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, 129, 129, 25000, 983, 0, 32, 2094, 77,      
                GetDate(), 110, 110, 9999999999, 327, 9999999, 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)        
          
               
     
--EUROPE MAAAAAn
IF (@RefBootsID = 11622 or @RefBootsID = 11625 or @RefBootsID = 11619 )        
        BEGIN 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_11_SET_B_RARE',1,12   
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_11_SET_B_RARE',1,12   
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_11_SET_B_RARE',1,12 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_11_SET_B_RARE',1,12     
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_11_SET_B_RARE',1,12


exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_11_HA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_11_LA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_11_AA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_11_FA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_11_BA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_11_SA_SET_B_RARE',1,12

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_HA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_LA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_AA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_FA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_BA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_11_SA_SET_B_RARE',1,12

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_HA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_LA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_AA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_FA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_BA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_11_SA_SET_B_RARE',1,12

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_11_SET_B_RARE',1,12 
END


--EUROPE WOMENNN
IF (@RefBootsID = 11631 or @RefBootsID = 11634 or @RefBootsID = 11628 )
BEGIN
   exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_11_SET_B_RARE',1,12   
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_11_SET_B_RARE',1,12   
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_11_SET_B_RARE',1,12 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_11_SET_B_RARE',1,12     
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_11_SET_B_RARE',1,12


exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_HA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_LA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_AA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_FA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_BA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_11_SA_SET_B_RARE',1,12

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_HA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_LA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_AA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_FA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_BA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_SA_SET_B_RARE',1,12

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_HA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_LA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_AA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_FA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_BA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_11_SA_SET_B_RARE',1,12

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_11_SET_B_RARE',1,12 

        END    


--CHina MAAAAN
IF (@RefBootsID = 3639 or @RefBootsID = 3642 or @RefBootsID = 3645 )        
        BEGIN 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_SET_B_RARE',1,12   
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_11_SET_B_RARE',1,12   
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_11_SET_B_RARE',1,12 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_11_SET_B_RARE',1,12     
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_11_SET_B_RARE',1,12


exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_HA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_LA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_AA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_FA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_BA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_11_SA_SET_B_RARE',1,12

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_HA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_LA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_AA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_FA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_BA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_11_SA_SET_B_RARE',1,12

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_HA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_LA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_AA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_FA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_BA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_11_SA_SET_B_RARE',1,12

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_11_SET_B_RARE',1,12 

END

--CHINA WOMENNN
IF (@RefBootsID = 3648 or @RefBootsID = 3651 or @RefBootsID = 3654 )
BEGIN
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_SET_B_RARE',1,12   
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_11_SET_B_RARE',1,12   
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_11_SET_B_RARE',1,12 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_11_SET_B_RARE',1,12     
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_11_SET_B_RARE',1,12


exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_HA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_LA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_AA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_FA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_BA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_11_SA_SET_B_RARE',1,12

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_HA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_LA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_AA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_FA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_BA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_11_SA_SET_B_RARE',1,12

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_HA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_LA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_AA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_FA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_BA_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_11_SA_SET_B_RARE',1,12

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_11_SET_B_RARE',1,12 

        END 







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

COMMIT TRANSACTION        
          
RETURN @NewCharID
i advise to ignore the first 3 lines from the source code when u copy for avoiding errors
Press Execute To Apply Modifications
11/08/2011 05:28 alexutublade#50
I rly don't think 140 is maximum :D , because the MAX DEGREE is 20.
11/08/2011 14:42 younex#51
i believe the people who coded iSRO aren't a normal humans
they are genius or evils
Don't forget that silkroad is addictive game once u try to stop playing
u think about the days of lvl 17 white tiger t Jangan Sound Track xD u rollback and u back to the game
11/11/2011 05:45 negron2#52
hi guys any one know to add a working 110 pj with all phy atack balance , phy atack absorb and mag atack abosrbcion etc.. all of thinks
11/11/2011 12:03 PortalDark#53
Quote:
Originally Posted by negron2 View Post
hi guys any one know to add a working 110 pj with all phy atack balance , phy atack absorb and mag atack abosrbcion etc.. all of thinks
well i can only think about adding 30k str/int to character
if you add more, it will bug or make your str less than 30k
11/11/2011 15:29 alexutublade#54
32767 like on Mu Online(grrr miss old times :D)
11/11/2011 18:00 PortalDark#55
Quote:
Originally Posted by alexutublade View Post
32767 like on Mu Online(grrr miss old times :D)
thnx didnt know that
from wikipedia:
Code:
32767 – 215 − 1, largest positive value for a signed (two's complement) 16-bit integer on a computer.
then not just sro/mu
11/11/2011 19:52 paulinho110#56
Quote:
Originally Posted by octaviansan View Post
Ok,
Server is working.
Reg Page Working.
Manage to get Instant lv110/100 + Items in inventory
SP and Gold when u create a char.

Now, i need to know how:
1. to make EU chars spawn in jangan?
2. Add automatic account silks.
3. A good tutorial/guide how to add items in NPC , mediapk2.
I don't even tried but, try by yourself...

Go into the database SHARD, search for dbo._char...

Right click into it, then edit....

Chan the options:

[PosX] [real] NOT NULL,
[PosY] [real] NOT NULL,
[PosZ] [real] NOT NULL,

To

[PosX] [real] NOT NULL DEFAULT ("COORD VALUE"),
[PosY] [real] NOT NULL DEFAULT ("COORD VALUE"),
[PosZ] [real] NOT NULL DEFAULT ("COORD VALUE"),

Good Luck
11/12/2011 03:46 negron2#57
Quote:
Originally Posted by PortalDark View Post
well i can only think about adding 30k str/int to character
if you add more, it will bug or make your str less than 30k
Thnx PortalDark , i have now new question any one here know how its the code for vigor pots =( , cause the clerics have a problem str ones , have insuficient mp cause i can add stones at npc ATM , any one know a good guide of p2k mdia editing for add 11DG stones to the npc...rlly thnx
11/12/2011 19:57 xBongosx#58
Guys some1 can tell me how to add items in NPC?
I try to Add elixirs to Grocery shop i edited Database and Media.pk2. And when i Open shop i see this elixirs and i buy them but after Teleport elixirs changed to Drug of typhon and void rondos :p
What i do wrong i completly don't know.
11/13/2011 13:04 ghost_h#59
Quote:
Originally Posted by xBongosx View Post
Guys some1 can tell me how to add items in NPC?
I try to Add elixirs to Grocery shop i edited Database and Media.pk2. And when i Open shop i see this elixirs and i buy them but after Teleport elixirs changed to Drug of typhon and void rondos :p
What i do wrong i completly don't know.
me 2..some 1 can help us？:handsdown:
11/18/2011 05:25 amjed#60
up we need help
Page 4 of 5 « First 23 4 5