Paylaşım VSRO - Tek Query İle Stack Güncelleme

[InFlames]

🔥 SRO ARENA: Bu Alana Reklam Verebilirsiniz. ⚡

Spoyler

USE SRO_VT_SHARD;

BEGIN TRANSACTION;

-- Alchemy ile ilgili item'lar için MaxStack değerini 1000 yapma
UPDATE _RefObjItem
SET MaxStack = CASE
WHEN ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE '%ARCHEMY%MAGICSTONE%' AND Service = 1) THEN 1000
WHEN ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE '%ARCHEMY%ATTRSTONE%' AND Service = 1) THEN 1000
WHEN ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE '%ARCHEMY%MAGICTABLET%' AND Service = 1) THEN 1000
WHEN ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE '%ARCHEMY%ATTRTABLET%' AND Service = 1) THEN 1000
WHEN ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE '%ARCHEMY%ELEMENT%' AND Service = 1) THEN 1000
WHEN ID BETWEEN 2025 AND 2032 THEN 1000
ELSE MaxStack
END
WHERE ID IN (
SELECT Link FROM _RefObjCommon WHERE
(CodeName128 LIKE '%ARCHEMY%MAGICSTONE%' OR
CodeName128 LIKE '%ARCHEMY%ATTRSTONE%' OR
CodeName128 LIKE '%ARCHEMY%MAGICTABLET%' OR
CodeName128 LIKE '%ARCHEMY%ATTRTABLET%' OR
CodeName128 LIKE '%ARCHEMY%ELEMENT%')
AND Service = 1
)
OR ID BETWEEN 2025 AND 2032;

-- Potion ve ilgili item'lar için MaxStack değerini güncelleme
UPDATE _RefObjItem
SET MaxStack = CASE
WHEN _RefObjCommon.CodeName128 LIKE '%ITEM_ETC_HP_POTION%' THEN 25000
WHEN _RefObjCommon.CodeName128 LIKE '%ITEM_ETC_MP_POTION%' THEN 25000
WHEN _RefObjCommon.CodeName128 LIKE '%ITEM_ETC_ALL_SPOTION%' THEN 1000
WHEN _RefObjCommon.CodeName128 LIKE '%ITEM_ETC_CURE_ALL%' THEN 1000
ELSE MaxStack
END
FROM _RefObjItem
INNER JOIN _RefObjCommon ON _RefObjItem.ID = _RefObjCommon.Link
WHERE _RefObjCommon.Service = 1
AND (
_RefObjCommon.CodeName128 LIKE '%ITEM_ETC_HP_POTION%' OR
_RefObjCommon.CodeName128 LIKE '%ITEM_ETC_MP_POTION%' OR
_RefObjCommon.CodeName128 LIKE '%ITEM_ETC_ALL_SPOTION%' OR
_RefObjCommon.CodeName128 LIKE '%ITEM_ETC_CURE_ALL%'
);

-- Reverse Return ve diğer benzer item'lar için MaxStack değerini güncelleme
UPDATE _RefObjItem
SET MaxStack = CASE
WHEN _RefObjCommon.CodeName128 = 'ITEM_MALL_REVERSE_RETURN_SCROLL' THEN 100
WHEN _RefObjCommon.CodeName128 LIKE 'ITEM_ETC_SCROLL_RETURN%' THEN 100
WHEN _RefObjCommon.CodeName128 = 'ITEM_MALL_RETURN_SCROLL_HIGH_SPEED' THEN 100
WHEN _RefObjCommon.CodeName128 LIKE 'ITEM_ETC_ARCHEMY_RONDO%' THEN 1000
WHEN _RefObjCommon.CodeName128 LIKE 'ITEM_ETC_AMMO_BOLT_01%' THEN 25000
WHEN _RefObjCommon.CodeName128 LIKE 'ITEM_ETC_AMMO_ARROW_01%' THEN 25000
WHEN _RefObjCommon.CodeName128 LIKE 'ITEM_ETC_COS_HP_POTION%' THEN 1000
WHEN _RefObjCommon.CodeName128 IN ('ITEM_COS_P_REVIVAL', 'ITEM_COS_P_REVIVAL_SILK') THEN 1000
WHEN _RefObjCommon.CodeName128 = 'ITEM_COS_P_HGP_POTION_01' THEN 1000
WHEN _RefObjCommon.CodeName128 IN ('ITEM_COS_P_CURE_ALL_01', 'ITEM_COS_P_CURE_ALL_02') THEN 1000
ELSE MaxStack
END
FROM _RefObjItem
INNER JOIN _RefObjCommon ON _RefObjItem.ID = _RefObjCommon.Link
WHERE _RefObjCommon.Service = 1
AND (
_RefObjCommon.CodeName128 IN ('ITEM_MALL_REVERSE_RETURN_SCROLL', 'ITEM_MALL_RETURN_SCROLL_HIGH_SPEED') OR
_RefObjCommon.CodeName128 LIKE 'ITEM_ETC_SCROLL_RETURN%' OR
_RefObjCommon.CodeName128 LIKE 'ITEM_ETC_ARCHEMY_RONDO%' OR
_RefObjCommon.CodeName128 LIKE 'ITEM_ETC_AMMO_BOLT_01%' OR
_RefObjCommon.CodeName128 LIKE 'ITEM_ETC_AMMO_ARROW_01%' OR
_RefObjCommon.CodeName128 LIKE 'ITEM_ETC_COS_HP_POTION%' OR
_RefObjCommon.CodeName128 IN ('ITEM_COS_P_REVIVAL', 'ITEM_COS_P_REVIVAL_SILK', 'ITEM_COS_P_HGP_POTION_01', 'ITEM_COS_P_CURE_ALL_01', 'ITEM_COS_P_CURE_ALL_02')
);

COMMIT;

DB'to Media Yaparak Çıkan İtemdata"xxx".txt'i Güncelleyin.