vSRO Paylaşım vSRO F10 veya NPC Basitce ve Hızlı İtem Ekleme

USE SRO_VT_SHARD;
GO

DECLARE @TabCodeName VARCHAR(129) = 'STORE_HKN_DRESS_TAB1'; -- Sekme adı
DECLARE @Price INT = 1; -- Alınması için gereken silk miktarı

-- Verilen item kodlarını bir döngüde işlemek için tablo oluşturuyoruz
DECLARE @ItemCodes TABLE (ItemCodeName VARCHAR(129));

INSERT INTO @ItemCodes (ItemCodeName)
VALUES
('ITEM_MALL_AVATAR_M_KAJA_SKYBLOCKER1'),
('ITEM_MALL_AVATAR_M_KAJA_SKYBLOCKER1_HAT');
DECLARE @ItemCodeName VARCHAR(129);
DECLARE @PackageCodeName VARCHAR(129);
DECLARE @SlotIndex INT;
DECLARE @AssocFileIcon VARCHAR(129);
DECLARE @NameStrID VARCHAR(129);
DECLARE @DescStrID VARCHAR(129);

DECLARE item_cursor CURSOR FOR SELECT ItemCodeName FROM @ItemCodes;
OPEN item_cursor;

FETCH NEXT FROM item_cursor INTO @ItemCodeName;

WHILE @@FETCH_STATUS = 0
BEGIN
    SET @PackageCodeName = 'PACKAGE_' + @ItemCodeName;

    SELECT
        @AssocFileIcon = AssocFileIcon128,
        @NameStrID = NameStrID128,
        @DescStrID = DescStrID128
    FROM _RefObjCommon
    WHERE CodeName128 = @ItemCodeName;

    IF NOT EXISTS (SELECT * FROM _RefPackageItem WHERE CodeName128 = @PackageCodeName)
    BEGIN
        INSERT INTO _RefPackageItem (Service, Country, CodeName128, SaleTag, ExpandTerm, NameStrID, DescStrID, AssocFileIcon, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128)
        VALUES (1, 15, @PackageCodeName, 0, 'EXPAND_TERM_ALL', @NameStrID, @DescStrID, @AssocFileIcon, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx');
    END

    SELECT @SlotIndex = ISNULL(MAX(SlotIndex), 0) + 1 FROM _RefShopGoods WHERE RefTabCodeName = @TabCodeName;

    INSERT INTO _RefShopGoods (Service, Country, RefTabCodeName, RefPackageItemCodeName, SlotIndex, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128)
    VALUES (1, 15, @TabCodeName, @PackageCodeName, @SlotIndex, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx');

    IF NOT EXISTS (SELECT * FROM _RefScrapOfPackageItem WHERE RefPackageItemCodeName = @PackageCodeName AND RefItemCodeName = @ItemCodeName)
    BEGIN
        INSERT INTO _RefScrapOfPackageItem (Service, Country, RefPackageItemCodeName, RefItemCodeName, OptLevel, Variance, Data, MagParamNum, MagParam1, MagParam2, MagParam3, MagParam4, MagParam5, MagParam6, MagParam7, MagParam8, MagParam9, MagParam10, MagParam11, MagParam12, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128)
        VALUES (1, 15, @PackageCodeName, @ItemCodeName, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx');
    END

    IF NOT EXISTS (SELECT * FROM _RefPricePolicyOfItem WHERE RefPackageItemCodeName = @PackageCodeName AND Cost = @Price)
    BEGIN
        INSERT INTO _RefPricePolicyOfItem (Service, Country, RefPackageItemCodeName, PaymentDevice, PreviousCost, Cost, Param1, Param1_Desc128, Param2, Param2_Desc128, Param3, Param3_Desc128, Param4, Param4_Desc128)
        VALUES (1, 15, @PackageCodeName, 1, 0, @Price, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx');
    END

    FETCH NEXT FROM item_cursor INTO @ItemCodeName;
END

CLOSE item_cursor;
DEALLOCATE item_cursor;