Kayıt
22 Haziran 2009
Mesajlar
625
Beğeniler
0
Şehir
İzmir/Göztepe


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





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​




 
Kayıt
24 Mayıs 2007
Mesajlar
3.806
Beğeniler
55
Ş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 :)
 
Kayıt
22 Haziran 2009
Mesajlar
625
Beğeniler
0
Şehir
İzmir/Göztepe
Bu mesaj Egoist rumuzlu uyeden alinti yapildi
Egoist demiş ki:
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 :)
Drop rateyı bır test edeyım ben :wink1:

[ Mesaj mobilden gonderildi MobileDevice ] mobile
 
Son düzenleme yönetici tarafından yapıldı:
Yukarı Alt