[HIDE]
_RefShopTab İlk Ekleme
INSERT INTO _RefShopTab (Service, Country, CodeName128, RefTabGroupCodeName, StrID128_Tab)
VALUES (1, 15, 'MALL_CONSUME_GLOW', 'MALL_CONSUME_GROUP1', 'UIIT_STT_SILKMALL_GLOW');
Daha Sonrada
USE SRO_VT_SHARD;
GO
DECLARE @ItemCodeName VARCHAR(129) = 'ITEM_SILKROADPVP_GLOW_01';-- Buraya eklenecek Itemin _RefObjCommon deki kodunu ekliyoruz
DECLARE @PackageCodeName VARCHAR(129) = 'PACKAGE_ITEM_SILKROADPVP_GLOW_01';-- Burayada ayni sekilde basinda PACKAGE_ olucak sekilde kodumuzu ekliyoruz
DECLARE @TabCodeName VARCHAR(129) = 'MALL_CONSUME_GLOW'; -- Ekledigimiz Sekme adı
DECLARE @Price INT = 300; -- Alinmasi icin gereken silk miktari
DECLARE @SlotIndex INT;
DECLARE @AssocFileIcon VARCHAR(129); -- İconların gözükmesi için MediaPk2/İcon Klasöründe olan iconlar MediaPk2/İcon64 içerisindede olmalıdır
DECLARE @NameStrID VARCHAR(129);
DECLARE @DescStrID VARCHAR(129);
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, 2, 0, @Price, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx');
END
PRINT 'ITEM_SILKROADPVP_GLOW_01 başarıyla MALL_CONSUME_GLOW sekmesine eklendi.';
[/HIDE]
_RefShopTab İlk Ekleme
INSERT INTO _RefShopTab (Service, Country, CodeName128, RefTabGroupCodeName, StrID128_Tab)
VALUES (1, 15, 'MALL_CONSUME_GLOW', 'MALL_CONSUME_GROUP1', 'UIIT_STT_SILKMALL_GLOW');
Daha Sonrada
USE SRO_VT_SHARD;
GO
DECLARE @ItemCodeName VARCHAR(129) = 'ITEM_SILKROADPVP_GLOW_01';-- Buraya eklenecek Itemin _RefObjCommon deki kodunu ekliyoruz
DECLARE @PackageCodeName VARCHAR(129) = 'PACKAGE_ITEM_SILKROADPVP_GLOW_01';-- Burayada ayni sekilde basinda PACKAGE_ olucak sekilde kodumuzu ekliyoruz
DECLARE @TabCodeName VARCHAR(129) = 'MALL_CONSUME_GLOW'; -- Ekledigimiz Sekme adı
DECLARE @Price INT = 300; -- Alinmasi icin gereken silk miktari
DECLARE @SlotIndex INT;
DECLARE @AssocFileIcon VARCHAR(129); -- İconların gözükmesi için MediaPk2/İcon Klasöründe olan iconlar MediaPk2/İcon64 içerisindede olmalıdır
DECLARE @NameStrID VARCHAR(129);
DECLARE @DescStrID VARCHAR(129);
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, 2, 0, @Price, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx');
END
PRINT 'ITEM_SILKROADPVP_GLOW_01 başarıyla MALL_CONSUME_GLOW sekmesine eklendi.';
[/HIDE]
