1. Reklam


    1. joysro
      ledas
      jungler
      keasro
      zeus
      karantina

Vsro Arşiv # 1


  1. HaFu

    HaFu Öğretiyorum rank8

    Kayıt:
    22 Haziran 2009
    Mesajlar:
    636
    Beğenilen Mesajlar:
    0
    Ödül Puanları:
    0
    Meslek:
    Cnc Operator/Programmer
    Şehir:
    İzmir/Göztepe
    [​IMG]


    Merhaba Arkadaşlar bu konuyu sızlere arşivimde bulunan Vsro Kurulum Hakkındakı bılgılerımı sızelere anlatıcagım umarım işinize yarar 8)



    1-Normal Uniqueler Yerine Ver3

    Bazı serverlerde normal uniqueler lag oluşturduğu için (çıkan eliteler kalıp lag oluşturuyor.)



    ]
    Kod:
    USE [SRO_VT_SHARD]
    UPDATE [dbo].[Tab_RefTactics]SET dwObjID = replace(dwObjID, '1954', '7551')WHERE dwObjID LIKE '1954';
    UPDATE [dbo].[Tab_RefTactics]SET dwObjID = replace(dwObjID, '1982', '7558')WHERE dwObjID LIKE '1982';     
    UPDATE [dbo].[Tab_RefTactics]SET dwObjID = replace(dwObjID, '2002', '7560')WHERE dwObjID LIKE '2002';
    UPDATE [dbo].[Tab_RefTactics]SET dwObjID = replace(dwObjID, '3810', '7562')WHERE dwObjID LIKE '3810';
    UPDATE [dbo].[Tab_RefTactics]SET dwObjID = replace(dwObjID, '3875', '7564')WHERE dwObjID LIKE '3875';
    UPDATE [dbo].[Tab_RefTactics]SET dwObjID = replace(dwObjID, '14936', '23308')WHERE dwObjID LIKE '14936';
    UPDATE [dbo].[Tab_RefTactics]SET dwObjID = replace(dwObjID, '5871', '23307')WHERE dwObjID LIKE '5871';
    


    2- Unique spawn süreleri​


    Bunları tek tek sharda yollayacaksınız.. Bu kodlar ile spawnlar yarım saat olarak değişir(1800:60=30 dakika) Daha uzun veya daha kısa sürede çıkmasını istiyorsanız spawn süresini saniyeye dönüştürüp dwDelayTimeMin ve dwDelayTimeMax kısmına yazın..

    Kod:
    Tiger Girl
    Update Tab_RefNest Set dwDelayTimeMin=1800 , dwDelayTimeMax=1800 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = 
    (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_CH_TIGERWOMAN'))
    Uruchi
    Update Tab_RefNest Set dwDelayTimeMin=1800 , dwDelayTimeMax=1800 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics 
    WHERE dwObjID = 
    (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_OA_URUCHI'))
    Isyutaru
    Update Tab_RefNest Set dwDelayTimeMin=1800 , dwDelayTimeMax=1800 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = 
    (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_KK_ISYUTARU'))
    Lord Yarkan:
    Update Tab_RefNest Set dwDelayTimeMin=1800 , dwDelayTimeMax=1800 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = 
    (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_TK_BONELORD'))
    Demon Shaitan
    Update Tab_RefNest Set dwDelayTimeMin=1800 , dwDelayTimeMax=1800 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = 
    (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_RM_TAHOMET'))
    Cerberus
    Update Tab_RefNest Set dwDelayTimeMin=1800 , dwDelayTimeMax=1800 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = 
    (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_EU_KERBEROS'))
    Captain ivy
    Update Tab_RefNest Set dwDelayTimeMin=1800 , dwDelayTimeMax=1800 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = 
    (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_AM_IVY'))

    3- Fortress War Zaman Ayarı

    Kod:
      (Benım verdıgım ornektır sız kendınıze gore ayarlayın   )
    
    1.Adım ;
    
    Smc`ye giriş yapıyoruz , Smc`nin içinden SR_Scheduler'e giriyoruz.Oradan şunları buluyoruz ;
    
    PHP- Kodu:
    SCHEDULE_DEF_SIEGE_REQUEST_PERIOD ( Fortress Kayıt Zamanı ) 
    SCHEDULE_DEF_SIEGE_PERIOD ( Fortress War Zamanı ) 
    SCHEDULE_DEF_SIEGE_FORTRESS_DB_UPDATE ( Fortress War Kazananlarını Databaseye Kaydetme Zamanı )  
    2.Adım ;
    
    Örnek olarak Kale savaşını Saat 19:00`da yapacağız.Bunun için aşağıdakilerin zamanlarını şöyle ayarlamalıyız.
    
    SCHEDULE_DEF_SIEGE_REQUEST_PERIOD => 00:00 - 15:30 (Gece 12 de başlayıp , Öğlen 15:30 da biteceğini gösteriyor.) (Bunu isteğinize göre değiştirebilirsiniz.)
    
    SCHEDULE_DEF_SIEGE_PERIOD => 19:30 - 21:30 ( 2 Saat sürecek.Kale savaşı için oyundan 19:00 da NOTİCE geçecek.Kale savaşına 30 dakika kaldı diye.) (Saat 19:00 da başlayacak ve 21:30 da bitecek.)
    
    SCHEDULE_DEF_SIEGE_FORTRESS_DB_UPDATE => 19:30 - 19:31 (Buda kale savaşının bittikten 1 dakika içerisinde databaseye kaydedecek.)






    4-Job ve Guild Cezalarını Kaldırma


    Kod:
    Job ve Guild cezalarıını tamamen kaldırma 
    
    
    USE [SRO_VT_SHARD]
    GO
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    
    
    ALTER procedure [dbo].[_AddTimedJob]
    @CharID int,
    @Category tinyint,
    @JobID int,
    @TimeToKeep int,
    @Data1 int,
    @Data2 int,
    --##begin due to develop composite item
    @Data3 int,
    @Data4 int,
    @Data5 int,
    @Data6 int,
    @Data7 int,
    @Data8 int,
    @Serial64 bigint,
    @JID int
    --##end due to develop composite item
    as
    if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
    return -1
    if (@TimeToKeep <= 0)
    return -2
    declare @NewJobID int
    set @NewJobID = 0
    
    
    --##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader
    --##If you want to only have one not both, then just modify the line below!
    if (@JobID = 1 or @JobID = 2)
    BEGIN
    return -1
    END
    ELSE
    BEGIN
    --##begin due to develop composite item
    insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64, JID)
    values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
    END
    --##end due to develop composite item
    set @NewJobID = @@identity
    if (@@error <> 0 or @@rowcount = 0)
    
    
    return -3
    return @NewJobID


    [​IMG]



    5- Sorunsuz Silk Vermek [Query]​



    Kod:
    Öncelikle silk alacak adamın oyuna giriş ID'sini öğrenip bu aşağıdaki koda Adamın giriş ID'sini yazın execute yapın. Hemen aşağıda JID çıkacaktır silk vermek içinde bize bu JID yeterli.[/b]
    SELECT     JID, StrUserID
    FROM          TB_User
    WHERE     (StrUserID LIKE '%Oyuna giriş ID buraya yaz%')


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



    Not ! Kendınıze Gore Ayarlamayı Unutmayın

    Kod:
    USE [SRO_VT_SHARD]
    GO
    /****** Object:  StoredProcedure [dbo].[_AddNewChar]    Script Date: 15/07/2013 04:54:49 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
     
     
     
     
    ALTER PROCEDURE [dbo].[_AddNewChar]
        @UserJID            INT,       
        --@CharSlot            INT,       
        @RefCharID            INT,       
        @CharName            varchar (64),       
        @CharScale            tinyINT,       
        @StartRegionID            INT,       
        @StartPos_X            real,       
        @StartPos_Y            real,       
        @StartPos_Z            real,       
        @DefaultTeleport    INT,       
        @RefMailID            INT,       
        @RefPantsID            INT,       
        @RefBootsID            INT,       
        @RefWeaponID        INT,       
        @RefShield            INT,       
        @DurMail            tinyINT,       
        @DurPants            tinyINT,       
        @DurBoots            tinyINT,       
        @DurWeapon            tinyINT,       
        @DurShield            tinyINT,       
        @DefaultArrow        INT       
    AS   
       
    SET NOCOUNT ON     
     
        DECLARE @Slot  INT       
        DECLARE @temp  INT       
               
        DECLARE @NewCharID  INT       
        SET @NewCharID = 0       
         
          SET @CharName =@CharName
        -----------------------------------------------------------------------------       
        -- 1. ij¸¯ÅÍ ½½·Ô ³Ñ¹ö°¡ validÇÑ °ÍÀÎÁö, ±×¸®°í ºó½½·ÔÀÌ ¸Â´ÂÁö ¸ÕÀú üũÇÑ´Ù.       
        -----------------------------------------------------------------------------       
           
        -- start by novice.       
        SELECT @temp = count(CharID) FROM _User WITH (NOLOCK) WHERE UserJID = @UserJID       
             
        IF (@temp >= 4)       
        BEGIN       
            -- ³Ê¹« ¸¹ÀÚ³ª       
            RETURN -2       
        END       
        -- finish by novice.       
         
        -----------------------------------------------------------------------------       
        -- 2. ij¸¯ÅÍ Ãß°¡Ç챉       
        -----------------------------------------------------------------------------       
        IF (@CharScale > 68) -- 0100 0100 --> 68 ÀÌ´Ù!       
        BEGIN       
            -- ij¸¯ÅÍ »y¼º ½ÇÆ?! ½ºÄÉÀÏ °ªÀÌ ÀÌ»óÇÏ´Ù!       
            RETURN -3       
        END
           
        EXEC @temp = _IsExistingCharName @CharName       
        IF (@temp <> 0)       
        BEGIN       
            -- ÀÌ¹Ì »ç¿ëÁßÀÎ À̸§À̶ó´Âµ¥?       
            RETURN -4       
        END       
       
    BEGIN TRANSACTION
       
        -- Àδø½Ã½ºÅÛÀÌ Àû¿ëµÇ¸é¼ ¸¶Áö¸·¿¡ WorldID¿Í 1°ªÀ» ´õ ³Ö¾î ÁÖ¾ú´Ù!     
        INSERT INTO _Char (RefObjID, CharName16, Scale, Strength, Intellect,  LatestRegion,PosX, PosY, PosZ, AppointedTeleport, InventorySize,     
                    LastLogout, CurLevel, MaxLevel, RemainGold,  RemainStatPoint, RemainSkillPoint, HP, MP, JobLvl_Trader, JobLvl_Hunter,  JobLvl_Robber, WorldID)     
        VALUES (@RefCharID, @CharName, @CharScale, 20, 20, @StartRegionID,  @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport, 109,     
                    GetDate(), 1, 1, 0, 0, 0, 200,200, 1, 1, 1, 1)     
       
        SET @NewCharID = @@IDENTITY       
        IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)       
        BEGIN       
            -- ij¸¯ÅÍ »y¼º ½ÇÆ?!       
            ROLLBACK TRANSACTION       
            RETURN -5       
        END       
           
             
        -- start by novice.       
        -- ÀÌÁ¦ Slot ¾È¾´´Ù.. ±×³É Insert ¸¸..       
        INSERT INTO _User VALUES (@UserJID, @NewCharID)       
        -- finish by novice.       
         
         
        -----------------------------------------------------------------------------       
        -- 3-1. Àåºñ ½½·Ô ä¿ì±â       
        -- [Àκ¥Å丮 ½½·Ô 96°³] + [Àåºñ½½·Ô 13°³] <- Àκ¥Å丮 È®Àå ¼*ºñ½º ÈÄ 48°³¿¡¼* 96°³·Î Áõ°¡!!!(woos0)
        -----------------------------------------------------------------------------       
        --PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH  WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH  WARNING!!!PATCH WARNING!!!       
        INSERT INTO _Inventory(CharID, Slot, ItemID)       
          SELECT @NewCharID, cnt, 0       
          FROM _RefDummySlot with( nolock )     
            WHERE cnt < 109       
     
             
        IF (@@ERROR <> 0)       
        BEGIN       
            -- Àκ¥Å丮 »y¼º ½ÇÆ?!       
            ROLLBACK TRANSACTION       
            RETURN -7       
        END       
     
        --PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH  WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH  WARNING!!!PATCH WARNING!!!       
             
        -- µ?ÆúÆ®·Î ¼±ÅÃÇÑ ¾ÆÀÌÅÛÀ» ´Ù½Ã ³Ö¾îÁÖÀÚ...       
        /* ¿ä·± ¼ø¼*·Î  Á¤ÀǵǾî ÀÖ´Ù.       
        0: EQUIP_SLOT_HELM       
        1: EQUIP_SLOT_MAIL,       
        2: EQUIP_SLOT_SHOULDERGUARD,       
        3: EQUIP_SLOT_GAUNTLET,       
        4: EQUIP_SLOT_PANTS,       
        5: EQUIP_SLOT_BOOTS,       
        6: EQUIP_SLOT_WEAPON,       
        7: EQUIP_SLOT_SHIELD or ARROW,       
        8: EQUIP_SLOT_EARRING,       
        9: EQUIP_SLOT_NECKLACE,       
        10: EQUIP_SLOT_L_RING,       
        11: EQUIP_SLOT_R_RING,       
        */       
             
        DECLARE @ItemID BIGINT       
        SET @ItemID = 0       
        -- »ó°©       
        IF (@RefMailID <> 0)       
        BEGIN       
            EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 1, @RefMailID, @DurMail       
            IF (@ItemID <= 0)       
            BEGIN       
                ROLLBACK TRANSACTION       
                RETURN -8       
            END       
        END       
        -- ¹ÙÁö       
        IF (@RefPantsID <> 0)       
        BEGIN       
            EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 4, @RefPantsID, @DurPants       
            IF (@ItemID <= 0)       
            BEGIN       
                ROLLBACK TRANSACTION       
                RETURN -9       
            END       
        END       
        -- Boots       
        IF (@RefBootsID <> 0)       
        BEGIN       
            EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 5, @RefBootsID, @DurBoots       
            IF (@ItemID <= 0)       
            BEGIN       
                ROLLBACK TRANSACTION       
                RETURN -10       
            END       
        END       
        -- Weapon       
        IF (@RefWeaponID <> 0)       
        BEGIN       
            EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 6, @RefWeaponID, @DurWeapon       
            IF (@ItemID <= 0)       
            BEGIN       
                ROLLBACK TRANSACTION       
                RETURN -11       
            END       
        END       
        -- ¹æÆ?       
        IF (@RefShield <> 0)       
        BEGIN       
            EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @RefShield, @DurShield       
            IF (@ItemID <= 0)       
            BEGIN       
                ROLLBACK TRANSACTION       
                RETURN -12       
            END       
        END       
        -- Ȥ½Ã default·Î ¼±ÅÃÇÑ ¹«±â°¡ È°À̶ó¸é È*»ì 250°³µéÀÌ È°Åëµµ ÇÔ²² ÁØ´Ù. ÁÒÄ¡?       
        IF (@DefaultArrow <> 0)       
        BEGIN       
            EXEC @ItemID =  _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @DefaultArrow, 250       
            IF (@ItemID <= 0)       
            BEGIN       
                ROLLBACK TRANSACTION       
                RETURN -13       
            END       
        END
     
     
        -----------------------------------------------------------------------------       
        -- 3-2. ¾Æ¹ÙŸ Inventory ½½·Ô ä¿ì±â       
        -- [¾Æ¹ÙŸ Àκ¥Å丮 ½½·Ô 5°³]
        -- APPLY_AVATAR_SYSTEMÀÌ Àû¿ëµÇ¸é¼* Ãß°¡µÇ´Â ºÎº?
        -----------------------------------------------------------------------------       
        --PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH  WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH  WARNING!!!PATCH WARNING!!!       
        INSERT INTO _InventoryForAvatar(CharID, Slot, ItemID)       
          SELECT @NewCharID, cnt, 0
          FROM _RefDummySlot with( nolock )     
            WHERE cnt < 5
     
             
        IF (@@ERROR <> 0)       
        BEGIN       
            -- ¾Æ¹ÙŸ Àκ¥Å丮 »y¼º ½ÇÆ?!       
            ROLLBACK TRANSACTION       
            RETURN -14
        END       
        --PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH  WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH  WARNING!!!PATCH WARNING!!!       
             
        -----------------------------------------------------------------------------       
        -- default skill³Ö¾îÁÖ±â       
        -----------------------------------------------------------------------------       
        DECLARE @country tinyINT       
        EXEC @country = _GetObjCountry @RefCharID       
             
        INSERT INTO _CharSkillMastery (CharID, MasteryID, Level)       
        SELECT @NewCharID, MasteryID, 0       
        FROM _RefCharDefault_SkillMastery  with(nolock)     
        WHERE Race = @country or Race = 3       
        IF (@@error <> 0)       
        BEGIN       
            ROLLBACK TRANSACTION       
            RETURN -15       
        END       
        INSERT INTO _CharSkill (CharID,SkillID,Enable)       
        SELECT @NewCharID, SkillID, 1       
        FROM  _RefCharDefault_Skill  with(nolock)     
        WHERE Race = @country or Race = 3       
        IF (@@error <> 0)       
        BEGIN       
            ROLLBACK TRANSACTION       
            RETURN -16       
        END       
        -----------------------------------------------------------------------------       
        -- ±âº» Äù½ºÆ® ³Ö¾îÁÖ±â
        -----------------------------------------------------------------------------       
        INSERT INTO _CharQuest (CharID, QuestID, Status, AchievementCount, StartTime, EndTime, QuestData1, QuestData2)       
        SELECT @NewCharID, ID, 1, 0, getdate(), getdate(), 0, 0       
        FROM _RefQuest
        WHERE CodeName in (SELECT CodeName FROM _RefCharDefault_Quest   with(nolock) WHERE (Race = @country or Race = 3) and RequiredLevel = 1  and Service = 1)
        IF (@@error <> 0)
        BEGIN
            ROLLBACK TRANSACTION       
            RETURN -17       
        END   
        -----------------------------------------------------------------------------       
        -- Static Avatar Initial Record ³Ö±â       
        -----------------------------------------------------------------------------       
        INSERT INTO _StaticAvatar(CharID) values(@NewCharID)       
        IF (@@ERROR <> 0)       
        BEGIN       
            ROLLBACK TRANSACTION       
            RETURN -18       
        END       
             
        -----------------------------------------------------------------------------       
        -- Trijob ä¿ö³Ö±â!!!!!       
        -----------------------------------------------------------------------------       
        INSERT INTO _CharTrijob VALUES (@NewCharID, 0, 1, 0, 0, 0)       
        IF (@@ERROR <> 0)       
        BEGIN       
            -- Àκ¥Å丮 »y¼º ½ÇÆ?!       
            ROLLBACK TRANSACTION       
            RETURN -19       
        END       
             
        -----------------------------------------------------------------------------       
        -- CharList¿¡ ID ³Ö¾îÁÖ±â       
        -----------------------------------------------------------------------------       
        INSERT _CharNameList VALUES(@CharName, @NewCharID)       
             
                 
       
    --EUROPE MAAAAAn
    IF (@RefBootsID = 11622 or @RefBootsID = 11625 or @RefBootsID = 11619 )       
            BEGIN
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_12_A_RARE',1,5 
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_12_A_RARE',1,5 
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_12_A_RARE',1,5   
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_12_A_RARE',1,5
    
     
     
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_12_HA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_12_AA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_12_FA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_12_BA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_12_SA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_12_LA_A_RARE',1,5
     
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_12_HA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_12_LA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_12_AA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_12_FA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_12_BA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_CLOTHES_12_SA_A_RARE',1,5
     
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_12_HA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_12_LA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_12_AA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_12_FA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_12_BA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_HEAVY_12_SA_A_RARE',1,5
     
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',20,20
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_ARCHEMY_POTION_SPEED_11',5,5
    END
     
     
    --EUROPE WOMENNN
    IF (@RefBootsID = 11631 or @RefBootsID = 11634 or @RefBootsID = 11628 )
    BEGIN
      exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSWORD_12_A_RARE',1,5 
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SHIELD_12_A_RARE',1,5 
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_HARP_12_A_RARE',1,5   
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_SWORD_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_AXE_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DARKSTAFF_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_DAGGER_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_CROSSBOW_12_A_RARE',1,5
     
     
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_12_HA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_12_LA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_12_AA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_12_FA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_12_BA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_LIGHT_12_SA_A_RARE',1,5
     
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_12_HA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_12_LA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_12_AA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_12_FA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_12_BA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_12_SA_A_RARE',1,5
     
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_12_HA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_12_LA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_12_AA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_12_FA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_12_BA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_HEAVY_12_SA_A_RARE',1,5
     
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',20,20
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_ARCHEMY_POTION_SPEED_11',5,5 
            END   
     
     
    --CHina MAAAAN
    IF (@RefBootsID = 3639 or @RefBootsID = 3642 or @RefBootsID = 3645 )       
            BEGIN
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_12_A_RARE',1,5 
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_12_A_RARE',1,5 
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_12_A_RARE',1,5   
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_12_A_RARE',1,5
      
     
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_12_HA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_12_LA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_12_AA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_12_FA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_12_BA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_12_SA_A_RARE',1,5
     
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_12_HA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_12_LA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_12_AA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_12_FA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_12_BA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_CLOTHES_12_SA_A_RARE',1,5
     
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_12_HA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_12_LA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_12_AA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_12_FA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_12_BA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_HEAVY_12_SA_A_RARE',1,5
     
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',20,20
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_ARCHEMY_POTION_SPEED_11',5,5 
    END
     
    --CHINA WOMENNN
    IF (@RefBootsID = 3648 or @RefBootsID = 3651 or @RefBootsID = 3654 )
    BEGIN
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_12_A_RARE',1,5 
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_12_A_RARE',1,5 
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_12_A_RARE',1,5   
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_12_A_RARE',1,5
     
     
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_12_HA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_12_LA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_12_AA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_12_FA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_12_BA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_LIGHT_12_SA_A_RARE',1,5
     
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_12_HA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_12_LA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_12_AA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_12_FA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_12_BA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_CLOTHES_12_SA_A_RARE',1,5
     
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_12_HA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_12_LA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_12_AA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_12_FA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_12_BA_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_W_HEAVY_12_SA_A_RARE',1,5
     
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_12_A_RARE',1,5
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',20,20
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_ARCHEMY_POTION_SPEED_11',5,5
            END
     
     
     
     
     
     
     
        -- Quick Slot Á¤º¸ ÀúÀå¿ë!!!       
        exec _AddNewClientConfig @NewCharID  -- by novice...... for saving client configurations...       
     
    COMMIT TRANSACTION       
             
    RETURN @NewCharID 
    
    
    
    Avrupa Karakteri Erkek Cinsi
    IF (@RefBootsID = 11622 or @RefBootsID = 11625 or @RefBootsID = 11619 ) 
    BEGIN
    [/BILGI][BILGI]-- Örn : exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_REVERSE_RETURN_SCROLL',5,1 ( 5 Adet Reverse Ekler )
    END
    
    
    --Avrupa Karakteri Kadın Cinsi
    IF (@RefBootsID = 11631 or @RefBootsID = 11634 or @RefBootsID = 11628 )
    BEGIN
    -- Örn : exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_REVERSE_RETURN_SCROLL',5,1 ( 5 Adet Reverse Ekler )
    END 
    
    
    --Chinese Karakteri Erkek Cinsi
    IF (@RefBootsID = 3639 or @RefBootsID = 3642 or @RefBootsID = 3645 ) 
    BEGIN
    -- Örn : exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_REVERSE_RETURN_SCROLL',5,1 ( 5 Adet Reverse Ekler )
    
    
    
    
    END
    
    --Chinese Karakteri Kadın Cinsi
    IF (@RefBootsID = 3648 or @RefBootsID = 3651 or @RefBootsID = 3654 )
    BEGIN
    -- Örn : exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_REVERSE_RETURN_SCROLL',5,1 ( 5 Adet Reverse Ekler )
    END

    7-Job Rate Ayarlamak​


    Kod:
    USE [SRO_VT_SHARD]
    GO
    -- *120 ratedir yanı carpı 120 kac x olsun ıstıyorsanız onu yazın --
    UPDATE dbo._RefObjCommon
    SET Price = 383*15
    WHERE Price = 383
    
    
    UPDATE dbo._RefObjCommon
    SET SellPrice = 191*15
    WHERE SellPrice = 191
    
    
    UPDATE dbo._RefPricePolicyOfItem
    SET Cost = 383*15
    WHERE Cost = 383

    8-Sox Drop Ayarlama​


    Kod:
    USE SRO_VT_SHARD DECLARE @RATE INT SET @RATE = 20 -- set the rate here
    update _RefDropClassSel_RareEquip set ProbGroup1 = ProbGroup1*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup2 = ProbGroup2*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup3 = ProbGroup3*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup4 = ProbGroup4*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup5 = ProbGroup5*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup6 = ProbGroup6*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup7 = ProbGroup7*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup8 = ProbGroup8*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup9 = ProbGroup9*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup10 = ProbGroup10*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup11 = ProbGroup11*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup12 = ProbGroup12*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup13 = ProbGroup13*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup14 = ProbGroup14*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup15 = ProbGroup15*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup16 = ProbGroup16*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup17 = ProbGroup17*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup18 = ProbGroup18*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup19 = ProbGroup19*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup20 = ProbGroup20*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup21 = ProbGroup21*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup22 = ProbGroup22*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup23 = ProbGroup23*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup24 = ProbGroup24*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup25 = ProbGroup25*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup26 = ProbGroup26*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup27 = ProbGroup27*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup28 = ProbGroup28*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup29 = ProbGroup29*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup30 = ProbGroup30*@RATE
    update _RefDropClassSel_RareEquip set ProbGroup31 = ProbGroup31*@RATE
    20 Yazan yere 120 yazarsanız 3 saatde bır duşecektir

    9- Unique Scroll Ekleme​




    İlk olarak media2pk çıkarıcımız ile ItemdataX.txt çıkartıyoruz ve düzenliyoruz.

    HTML-Kodu:​


    Kod:
    1    41798    ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3    ???    xxx    SN_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3    SN_ITEM_SCROLL_UNIQUE_TT_DESC    0    0    3    3    3    2    18000    3    0    1    1    1    255    0    1    0    0    1    0    100000000    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    5    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_scroll.bsr    item\etc\e050729_summon_scroll.ddj    xxx    xxx    5    2    0    0    1    0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0    0    0    0    0    0    0    0    0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    -1    MOB_CH_TIGERWOMAN_L3    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0
    1    41799    ITEM_SCROLL_MOB_OA_URUCHI_L3    ???    xxx    SN_ITEM_SCROLL_MOB_OA_URUCHI_L3    SN_ITEM_SCROLL_UNIQUE_TT_DESC    0    0    3    3    3    2    18000    3    0    1    1    1    255    0    1    0    0    1    0    150000000    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    5    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_scroll.bsr    item\etc\e050729_summon_scroll.ddj    xxx    xxx    5    2    0    0    1    0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0    0    0    0    0    0    0    0    0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    -1    MOB_OA_URUCHI_L3    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0
    1    41800    ITEM_SCROLL_MOB_KK_ISYUTARU_L3    ???    xxx    SN_ITEM_SCROLL_MOB_KK_ISYUTARU_L3    SN_ITEM_SCROLL_UNIQUE_TT_DESC    0    0    3    3    3    2    18000    3    0    1    1    1    255    0    1    0    0    1    0    200000000    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    5    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_scroll.bsr    item\etc\e050729_summon_scroll.ddj    xxx    xxx    5    2    0    0    1    0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0    0    0    0    0    0    0    0    0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    -1    MOB_KK_ISYUTARU_L3    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0
    1    41801    ITEM_SCROLL_MOB_TK_BONELORD_L3    ???    xxx    SN_ITEM_SCROLL_MOB_TK_BONELORD_L3    SN_ITEM_SCROLL_UNIQUE_TT_DESC    0    0    3    3    3    2    18000    3    0    1    1    1    255    0    1    0    0    1    0    300000000    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    5    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_scroll.bsr    item\etc\e050729_summon_scroll.ddj    xxx    xxx    5    2    0    0    1    0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0    0    0    0    0    0    0    0    0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0    -1    MOB_TK_BONELORD_L3    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0
    RefObjCommon açıyoruz ve editliyoruz;​


    HTML-Kodu:

    Kod:
    1 41799 ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3 ??? xxx SN_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3 SN_ITEM_SCROLL_UNIQUE_TT_DESC 0 0 3 3 3 2 18000 3 0 0 1 1 255 3 1 0 0 1 0 100000000 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 5 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_scroll.bsr item\etc\e050729_summon_scroll.ddj XXX XXX 21334
    1 41799 ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3 ??? xxx SN_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3 SN_ITEM_SCROLL_UNIQUE_TT_DESC 0 0 3 3 3 2 18000 3 0 0 1 1 255 3 1 0 0 1 0 100000000 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 5 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_scroll.bsr item\etc\e050729_summon_scroll.ddj XXX XXX 21334
    1 41801 ITEM_SCROLL_MOB_KK_ISYUTARU_L3 ??? xxx SN_ITEM_SCROLL_MOB_KK_ISYUTARU_L3 SN_ITEM_SCROLL_UNIQUE_TT_DESC 0 0 3 3 3 2 18000 3 0 0 1 1 255 3 1 0 0 1 0 200000000 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 5 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_scroll.bsr item\etc\e050729_summon_scroll.ddj XXX XXX 21336
    ​  1 41802    ITEM_SCROLL_MOB_TK_BONELORD_L3    ???    xxx    SN_ITEM_SCROLL_MOB_TK_BONELORD_L3    SN_ITEM_SCROLL_UNIQUE_TT_DESC    0    0    3    3    3    2    18000    3    0    0    1    1    255    3    1    0    0    1    0    300000000    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    5    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_scroll.bsr    item\etc\e050729_summon_scroll.ddj    XXX    XXX    21337
    
    RefObjItem;

    HTML-Kodu:

    Kod:
    21334    5    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    MOB_CH_TIGERWOMAN_L3    -1    xxx                                                                                                                                  -1    xxx    -1    xxxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
    21335    5    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    MOB_OA_URUCHI_L3    -1    xxx                                                                                                                                  -1    xxx    -1    xxxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
    21336    5    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    MOB_KK_ISYUTARU_L3    -1    xxx                                                                                                                                  -1    xxx    -1    xxxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
    21337    5    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    MOB_TK_BONELORD_L3    -1    xxx                                                                                                                                  -1    xxx    -1    xxxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
    Refpackageitem;

    HTML-Kodu:


    Kod:
    1    15    84045    PACKAGE_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3    0    EXPAND_TERM_ALL    SN_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3    SN_ITEM_SCROLL_UNIQUE_TT_DESC    item\etc\e050729_summon_scroll.ddj    -1    xxx    -1    xxx    -1    xxx    -1    xxx
    1    15    84046    PACKAGE_ITEM_SCROLL_MOB_OA_URUCHI_L3    0    EXPAND_TERM_ALL    SN_ITEM_SCROLL_MOB_OA_URUCHI_L3    SN_ITEM_SCROLL_UNIQUE_TT_DESC    item\etc\e050729_summon_scroll.ddj    -1    xxx    -1    xxx    -1    xxx    -1    xxx
    1    15    84047    PACKAGE_ITEM_SCROLL_MOB_KK_ISYUTARU_L3    0    EXPAND_TERM_ALL    SN_ITEM_SCROLL_MOB_KK_ISYUTARU_L3    SN_ITEM_SCROLL_UNIQUE_TT_DESC    item\etc\e050729_summon_scroll.ddj    -1    xxx    -1    xxx    -1    xxx    -1    xxx
    1    15    84048    PACKAGE_ITEM_SCROLL_MOB_TK_BONELORD_L3    0    EXPAND_TERM_ALL    SN_ITEM_SCROLL_MOB_TK_BONELORD_L3    SN_ITEM_SCROLL_UNIQUE_TT_DESC    item\etc\e050729_summon_scroll.ddj    -1    xxx    -1    xxx    -1    xxx    -1    xxx
    Burada fiyatını ayarlıyoruz;

    HTML-Kodu:

    Kod:
    1    15    PACKAGE_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3    1    0    100000000    -1    xxx    0    xxx    0    xxx    0    xxx
    1    15    PACKAGE_ITEM_SCROLL_MOB_OA_URUCHI_L3    1    0    150000000    -1    xxx    0    xxx    0    xxx    0    xxx
    1    15    PACKAGE_ITEM_SCROLL_MOB_KK_ISYUTARU_L3    1    0    200000000    -1    xxx    0    xxx    0    xxx    0    xxx
    1    15    PACKAGE_ITEM_SCROLL_MOB_TK_BONELORD_L3    1    0    300000000    -1    xxx    0    xxx    0    xxx    0    xxx
    Refscrapofpackageitem;

    HTML-Kodu:

    Kod:
    1    15    PACKAGE_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3    ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx    86691
    1    15    PACKAGE_ITEM_SCROLL_MOB_OA_URUCHI_L3    ITEM_SCROLL_MOB_OA_URUCHI_L3    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx    86692
    1 15    PACKAGE_ITEM_SCROLL_MOB_KK_ISYUTARU_L3    ITEM_SCROLL_MOB_KK_ISYUTARU_L3    0000000000000000-1    xxx    -1    xxx    -1    xxx    -1    xxx    86693
    1    15    PACKAGE_ITEM_SCROLL_MOB_TK_BONELORD_L3    ITEM_SCROLL_MOB_TK_BONELORD_L3    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx    86694
    Son işlemimiz ise scrolları koyacagımız Npc ayarlıyoruz ben ozel npc edıtlemıştım oraya koymustum.Siz istediginize ekliye bilirsiniz.


    refshopgoods açıyoruz ve eklemeye başlıyoruz
    ;
    HTML-Kodu:​

    Kod:
    1    15    STORE_Rısus_NPC_EU_TAB1    PACKAGE_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx
    1    15    STORE_Rısus_NPC_EU_TAB1    PACKAGE_ITEM_SCROLL_MOB_OA_URUCHI_L3    1    -1    xxx    -1    xxx    -1    xxx    -1    xxx
    1    15    STORE_Rısus_NPC_EU_TAB1    PACKAGE_ITEM_SCROLL_MOB_KK_ISYUTARU_L3    2    -1    xxx    -1    xxx    -1    xxx    -1    xxx
    1    15    STORE_Rısus_NPC_EU_TAB1    PACKAGE_ITEM_SCROLL_MOB_KK_ISYUTARU_L3    2    -1    xxx    -1    xxx    -1    xxx    -1    xxx
    1    15    STORE_Rısus_NPC_EU_TAB1    PACKAGE_ITEM_SCROLL_MOB_TK_BONELORD_L3    3    -1    xxx    -1    xxx    -1    xxx    -1    xxx

    Yakında Zamanda Arşiv 2 # Eklıyeceğim 8)


    Şimdilik Bu Kadar Diyelim Takıldıgınız Yerler olursa om veya konu altından mesaj atarsanız yardımcı olurum , Umarım İşinize Yarar​





    [​IMG]
     
  2. Tweety

    Tweety Old School olduser rank8

    Kayıt:
    24 Mayıs 2007
    Mesajlar:
    3.716
    Beğenilen Mesajlar:
    19
    Ödül Puanları:
    38
    Meslek:
    Chief Operating Officer
    Şehir:
    İzmir, Bornova
    SCHEDULE_DEF_SIEGE_PERIOD => 19:30 - 21:30 ( 2 Saat sürecek.Kale savaşı için oyundan 19:00 da NOTİCE geçecek.Kale savaşına 30 dakika kaldı diye.) (Saat 19:00 da başlayacak ve 21:30 da bitecek.)

    Saatleri belirtirken minik bir hata yapmışsın :)

    8-Sox Drop Ayarlama
    20 Yazan yere 120 yazarsanız 3 saatde bır duşecektir

    demişsin ama 20 yazan yere 120 yazarsan drop oranı 20değil 120 kat artmış olur yanlışlıkla iki kere çalıştırırsan 120 kat artmış oran tekrar 120 kat artar aman dikkat :)

    Güzel bilgiler ama biraz daha detaylı anlatım yapmazsan yeni başlayanlar olayı çözemez :)
     
  3. HaFu

    HaFu Öğretiyorum rank8

    Kayıt:
    22 Haziran 2009
    Mesajlar:
    636
    Beğenilen Mesajlar:
    0
    Ödül Puanları:
    0
    Meslek:
    Cnc Operator/Programmer
    Şehir:
    İzmir/Göztepe
    Bu mesaj Egoist rumuzlu uyeden alinti yapildi
    Drop rateyı bır test edeyım ben :wink1:

    [ Mesaj mobilden gonderildi MobileDevice ] mobile
     
    Son düzenleme yönetici tarafından yapıldı: 12 Şubat 2016
  4. levox1

    levox1 Yeni üye rank8

    Kayıt:
    20 Mayıs 2009
    Mesajlar:
    5
    Beğenilen Mesajlar:
    0
    Ödül Puanları:
    0
    Hocam FGW Rate Nasıl artırılır yane Duzen verilir.