Mas Stacks Codes

Can someone post Coding for MaxStacks = 1000 For Elixir/Stones/arrow/bolts 1000 ,
Please And Thanks all <3

you can change maxstack from dbo._objitem and itemdata_xxx in your database . You can find ID of the item in _objitem using this query

USE [SRO_VT_SHARD] SELECT LINK FROM DBO._REFOBJCOMMON WHERE CODENAME128 LIKE ''

Use this query to update MaxStack on DB side, and later you will need to edit them in Itemdata_***** manually. Just replace ITEM_CODE_HERE with your item code.

MAGICSTONE

Quote:

USE SRO_VT_SHARD DECLARE @CodeName VARCHAR(30) DECLARE @MaxStack INT SET @CodeName='%ARCHEMY%MAGICSTONE%' SET @MaxStack=1000 UPDATE _RefObjItem SET MaxStack=@MaxStack WHERE ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE @CodeName AND Service=1)

ATTRSTONE

Quote:

USE SRO_VT_SHARD DECLARE @CodeName VARCHAR(30) DECLARE @MaxStack INT SET @CodeName='%ARCHEMY%ATTRSTONE%' SET @MaxStack=1000 UPDATE _RefObjItem SET MaxStack=@MaxStack WHERE ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE @CodeName AND Service=1)

MAGICTABLET

Quote:

USE SRO_VT_SHARD DECLARE @CodeName VARCHAR(30) DECLARE @MaxStack INT SET @CodeName='%ARCHEMY%MAGICTABLET%' SET @MaxStack=1000 UPDATE _RefObjItem SET MaxStack=@MaxStack WHERE ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE @CodeName AND Service=1)

ATTRTABLET

Quote:

USE SRO_VT_SHARD DECLARE @CodeName VARCHAR(30) DECLARE @MaxStack INT SET @CodeName='%ARCHEMY%ATTRTABLET%' SET @MaxStack=1000 UPDATE _RefObjItem SET MaxStack=@MaxStack WHERE ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE @CodeName AND Service=1)

ELEMENT

Quote:

USE SRO_VT_SHARD DECLARE @CodeName VARCHAR(30) DECLARE @MaxStack INT SET @CodeName='%ARCHEMY%ELEMENT%' SET @MaxStack=1000 UPDATE _RefObjItem SET MaxStack=@MaxStack WHERE ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE @CodeName AND Service=1)

Elixirs

Quote:

UPDATE dbo._RefObjItem SET MaxStack = 250 WHERE ID BETWEEN 2025 AND 2032