Paylaşım Skill Scroll Ekleme Detaylı anlatım

C#MunihShytain

C#MunihShytain

Üye
YENİ KULLANICI
[replyandthanks]
Kod: 
USE [SRO_VT_LOG]
GO

/****** Object:  Table [dbo].[_CharacterSkills]    Script Date: 1.05.2024 15:24:49 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[_CharacterSkills](
    [SkillID] [int] NOT NULL,
    [Build] [varchar](50) NOT NULL,
    [Race] [varchar](50) NOT NULL,
    [MasteryID] [int] NOT NULL,
 CONSTRAINT [PK__CharacterSkills] PRIMARY KEY CLUSTERED
(
    [SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
TABLOMUZU OLUSTURUYORUZ ONDAN SONRA
Kod: 
WITH CTE AS (
SELECT
RS.ID,
CASE
WHEN RS.Basic_Code LIKE 'SKILL_EU_%' THEN UPPER(LEFT(SUBSTRING(RS.Basic_Code, CHARINDEX('_', RS.Basic_Code) + 4, CHARINDEX('_', RS.Basic_Code, CHARINDEX('_', RS.Basic_Code) + 4) - CHARINDEX('_', RS.Basic_Code) - 4), 1)) + LOWER(RIGHT(SUBSTRING(RS.Basic_Code, CHARINDEX('_', RS.Basic_Code) + 4, CHARINDEX('_', RS.Basic_Code, CHARINDEX('_', RS.Basic_Code) + 4) - CHARINDEX('_', RS.Basic_Code) - 4), LEN(SUBSTRING(RS.Basic_Code, CHARINDEX('_', RS.Basic_Code) + 4, CHARINDEX('_', RS.Basic_Code, CHARINDEX('_', RS.Basic_Code) + 4) - CHARINDEX('_', RS.Basic_Code) - 4)) - 1))
WHEN RS.Basic_Code LIKE 'SKILL_CH_%' THEN UPPER(LEFT(SUBSTRING(RS.Basic_Code, CHARINDEX('_', RS.Basic_Code) + 4, CHARINDEX('_', RS.Basic_Code, CHARINDEX('_', RS.Basic_Code) + 4) - CHARINDEX('_', RS.Basic_Code) - 4), 1)) + LOWER(RIGHT(SUBSTRING(RS.Basic_Code, CHARINDEX('_', RS.Basic_Code) + 4, CHARINDEX('_', RS.Basic_Code, CHARINDEX('_', RS.Basic_Code) + 4) - CHARINDEX('_', RS.Basic_Code) - 4), LEN(SUBSTRING(RS.Basic_Code, CHARINDEX('_', RS.Basic_Code) + 4, CHARINDEX('_', RS.Basic_Code, CHARINDEX('_', RS.Basic_Code) + 4) - CHARINDEX('_', RS.Basic_Code) - 4)) - 1))
ELSE RS.Basic_Code
END AS 'Build',
CASE
WHEN Basic_Code LIKE 'SKILL_EU_%' THEN 'European'
WHEN Basic_Code LIKE 'SKILL_CH_%' THEN 'Chinese'
ELSE ''
END AS 'Race',
RS.ReqCommon_Mastery1,
ROW_NUMBER() OVER (PARTITION BY RS.Basic_Group ORDER BY RS.Basic_Level DESC, RS.ID ASC) AS RN
FROM SRO_VT_SHARD.dbo._RefSkill RS
WHERE RS.ReqCommon_Mastery1 in  ('257','258','259','277','276','513','514','515','516','517','518') AND RS.Service LIKE '1' AND RS.Basic_Code NOT LIKE '%BASE%' AND ReqLearn_SP not like '0')
SELECT ID, [Build],  [Race],ReqCommon_Mastery1
FROM CTE
WHERE RN = 1
ORDER BY ID ASC
1714567265806.png


Buradaki Querde Cıkan ne varsa kopyalayıp oluşturduğumuz tablonun içine atıyoruz.
1714567317631.png

ardından refobjcommon ve refobj item ekliyoruz.
Kod: 
--------------------------refobjcommon
1    45026    ITEM_HONOR_SCROLL1    ?????    xxx    SN_ITEM_HONOR_BICHON1    SN_ITEM_HONOR_SCROLL1_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\etc\vortex\mastery_sword.ddj    xxx    xxx    22536
1    45027    ITEM_HONOR_HEUKSAL1    ?????    xxx    SN_ITEM_HONOR_BICHON2    SN_ITEM_HONOR_SCROLL2_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\etc\vortex\mastery_spear.ddj    xxx    xxx    22537
1    45028    ITEM_HONOR_PACHEON1    ?????    xxx    SN_ITEM_HONOR_BICHON3    SN_ITEM_HONOR_SCROLL3_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\etc\vortex\mastery_bow.ddj    xxx    xxx    22538
1    45029    ITEM_HONOR_COLD1    ?????    xxx    SN_ITEM_HONOR_BICHON4    SN_ITEM_HONOR_SCROLL4_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\etc\vortex\mastery_cold.ddj    xxx    xxx    22539
1    45030    ITEM_HONOR_FIRE1    ?????    xxx    SN_ITEM_HONOR_BICHON5    SN_ITEM_HONOR_SCROLL5_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\etc\vortex\mastery_fire.ddj    xxx    xxx    22540
1    45031    ITEM_HONOR_LIGHT1    ?????    xxx    SN_ITEM_HONOR_BICHON6    SN_ITEM_HONOR_SCROLL6_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\etc\vortex\mastery_lightning.ddj    xxx    xxx    22541
1    45032    ITEM_HONOR_FORCE1    ?????    xxx    SN_ITEM_HONOR_BICHON7    SN_ITEM_HONOR_SCROLL7_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\etc\vortex\mastery_water.ddj    xxx    xxx    22542
-------------------------------refobjitem
22536    1    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    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -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    0
22537    1    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    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -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    0
22538    1    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    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -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    0
22539    1    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    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -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    0
22540    1    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    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -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    0
22541    1    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    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -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    0
22542    1    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    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -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    0
Daha sonra SRO_VT_LOG -- ADDLOGITEM PROSEDÜRÜNÜN ALTINA
Kod: 
 IF (@ItemRefID BETWEEN 42164 AND 42170 and @Operation = 41) ---------------- Chinese Mastery Scrolls -------------------
    BEGIN
    IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE MasteryID='257')
    BEGIN
    DECLARE @Bicheon INT,@Heuksal INT,@Pacheon INT,@Cold INT,@Lightning INT,@Fire INT,@Force INT
    SELECT @Bicheon=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='257'
    SELECT @Heuksal=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='258'
    SELECT @Pacheon=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='259'
    SELECT @Cold=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='273'
    SELECT @Lightning=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='274'
    SELECT @Fire=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='275'
    SELECT @Force=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='276'
    IF (@Bicheon+@Heuksal+@Pacheon+@Cold+@Lightning+@Fire+@Force <='220')
    BEGIN
    DECLARE @ChineseMasteryType INT;
            SET @ChineseMasteryType = Case
                WHEN @ItemRefID=42166   ---------------    Bacheon
                THEN 257 --Item Ref Id yazan kısım bu kısımdaki idler commona eklediğimiz scroll idleri dir
                WHEN @ItemRefID=42165   ---------------    Heuksal
                THEN 258
                WHEN @ItemRefID=42164   ---------------    Pacheon
                THEN 259
                WHEN @ItemRefID=42169   ---------------    Cold
                THEN 273
                WHEN @ItemRefID=42168   ---------------    Lightning
                THEN 274
                WHEN @ItemRefID=42167   ---------------    Fire
                THEN 275
                WHEN @ItemRefID=42170   ---------------    Foce
                THEN 276
                END
    UPDATE SRO_VT_SHARD.dbo._CharSkillMastery SET [Level]='110' WHERE CharID=@CharID AND MasteryID=@ChineseMasteryType
    INSERT SRO_VT_SHARD.dbo._CharSkill SELECT @CharID,SkillID,'1' FROM SRO_VT_LOG.dbo._CharacterSkills WHERE MasteryID=@ChineseMasteryType
    END
    END
    END
/*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>¦?? ? ? ? - C#MunihShytain - ? ? ? ? ?¦<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

IF (@ItemRefID BETWEEN 42171 AND 42176 and @Operation = 41) ---------------- Europan Mastery Scrolls -------------------
    BEGIN
    IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE MasteryID='513')
    BEGIN
    DECLARE @Wizard INT,@Warrior INT,@Rouge INT,@Warlock INT,@Bard INT,@Cleric INT
    SELECT @Wizard=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='514'
    SELECT @Warrior=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='513'
    SELECT @Rouge=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='515'
    SELECT @Warlock=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='516'
    SELECT @Bard=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='517'
    SELECT @Cleric=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='518'
    IF (@Wizard+@Warrior+@Rouge+@Warlock+@Bard+@Cleric<='110')
    BEGIN
    DECLARE @EuropeanMasteryType INT;
            SET @EuropeanMasteryType = CASE
                WHEN @ItemRefID=42171 --------------- Wizard
                THEN 514
                WHEN @ItemRefID=42172 --------------- Warrior
                THEN 513
                WHEN @ItemRefID=42173 --------------- Rouge
                THEN 515
                WHEN @ItemRefID=42174 --------------- Cleric
                THEN 518
                WHEN @ItemRefID=42175 --------------- Bard
                THEN 517
                WHEN @ItemRefID=42176 --------------- Warlock
                THEN 516
                END
    UPDATE SRO_VT_SHARD.dbo._CharSkillMastery SET [Level]='110' WHERE CharID=@CharID AND MasteryID=@EuropeanMasteryType
    INSERT SRO_VT_SHARD.dbo._CharSkill SELECT @CharID,SkillID,'1' FROM SRO_VT_LOG.dbo._CharacterSkills WHERE MasteryID=@EuropeanMasteryType
    END
    END
    END
Ekliyoruz ben sadece chin için yaptım siz isterseniz eu yuda ekleyebilirsiniz ardından mediapk2 yedekleyin önce daha sonra dbtomediadan itemdata4500 ü pach atın ve iconları atıyorum aşşağıdaki linkte
link
[/replyandthanks]
 
Son düzenleme:
Buraya yanıt vermek için giriş yapmalı veya kayıt olmalısınız.
Geri
Başa dön