Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
Vsro Files - Max Cap, NPC Edit, Items Vsro Files - Max Cap, NPC Edit, Items
You last visited: Today at 16:30

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

Vsro Files - Max Cap, NPC Edit, Items

Discussion on Vsro Files - Max Cap, NPC Edit, Items within the SRO Private Server forum part of the Silkroad Online category.

Reply
Page 4 of 5 « First 23 4 5
 
Old 10/10/2011, 20:58   #46

 
sarkoplata's Avatar
 
elite*gold: 166
The Black Market: 2/0/0
Join Date: Apr 2009
Posts: 2,339
Received Thanks: 2,661
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
sarkoplata is offline  
Old 10/10/2011, 21:33   #47
 
Zoxon's Avatar
 
elite*gold: 0
The Black Market: 2/0/0
Join Date: Oct 2010
Posts: 352
Received Thanks: 298
so some1 could help me?
Zoxon is offline  
Old 10/10/2011, 22:18   #48
 
lesderid's Avatar
 
elite*gold: 0
The Black Market: 1/0/0
Join Date: Dec 2007
Posts: 2,400
Received Thanks: 1,517
Quote:
Originally Posted by fiction12 View Post
was that necesary?...
imo, yes.
lesderid is offline  
Old 11/08/2011, 01:32   #49
 
elite*gold: 0
The Black Market: 2/0/0
Join Date: Sep 2010
Posts: 80
Received Thanks: 166
Solved

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
younex is offline  
Thanks
4 Users
Old 11/08/2011, 05:28   #50
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Apr 2009
Posts: 302
Received Thanks: 46
I rly don't think 140 is maximum , because the MAX DEGREE is 20.
alexutublade is offline  
Old 11/08/2011, 14:42   #51
 
elite*gold: 0
The Black Market: 2/0/0
Join Date: Sep 2010
Posts: 80
Received Thanks: 166
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
younex is offline  
Thanks
4 Users
Old 11/11/2011, 05:45   #52
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Apr 2008
Posts: 12
Received Thanks: 0
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
negron2 is offline  
Old 11/11/2011, 12:03   #53
Chat Killer In Duty


 
PortalDark's Avatar
 
elite*gold: 5
The Black Market: 3/0/0
Join Date: May 2008
Posts: 16,397
Received Thanks: 6,509
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
PortalDark is offline  
Old 11/11/2011, 15:29   #54
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Apr 2009
Posts: 302
Received Thanks: 46
32767 like on Mu Online(grrr miss old times )
alexutublade is offline  
Thanks
1 User
Old 11/11/2011, 18:00   #55
Chat Killer In Duty


 
PortalDark's Avatar
 
elite*gold: 5
The Black Market: 3/0/0
Join Date: May 2008
Posts: 16,397
Received Thanks: 6,509
Quote:
Originally Posted by alexutublade View Post
32767 like on Mu Online(grrr miss old times )
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
PortalDark is offline  
Old 11/11/2011, 19:52   #56
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Nov 2011
Posts: 2
Received Thanks: 0
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
paulinho110 is offline  
Old 11/12/2011, 03:46   #57
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Apr 2008
Posts: 12
Received Thanks: 0
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
negron2 is offline  
Old 11/12/2011, 19:57   #58
 
xBongosx's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Oct 2009
Posts: 1,295
Received Thanks: 424
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
What i do wrong i completly don't know.
xBongosx is offline  
Old 11/13/2011, 13:04   #59
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Nov 2011
Posts: 65
Received Thanks: 4
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
What i do wrong i completly don't know.
me 2..some 1 can help us？
ghost_h is offline  
Old 11/18/2011, 05:25   #60
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2010
Posts: 247
Received Thanks: 52
up we need help
amjed is offline  
Reply
Page 4 of 5 « First 23 4 5

« [Request] ZSZC Server Files (Non-Modified by Others) | please help me fast »

Similar Threads Similar Threads
Vsro files. how edit mobs spawn?
01/06/2013 - SRO Private Server - 13 Replies
if. i want add mobs spawn in other place.. how make it?
vsro files
09/08/2011 - SRO Private Server - 11 Replies
How to get vsro server files i dont speak turk mayby someone can translate and tell us what is this guy saying :) if its just a fake post dont start flaming on me just tried to help ! #Request Close
edit clientless to work on vsro
07/20/2009 - Silkroad Online - 0 Replies
hi so far everything that works for isro works for vsro as well but need little edit when i asked ppl on vsro about the clientless (i need it for plvling) they said to me :get the clientless for isro and just edit version and opcode :confused: and it will work i know it works somehow cuz i've seen many clientless plvling there so what should i do? any1 can help me , thanks in advance



All times are GMT +1. The time now is 16:31.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.