Mas Stacks Codes

[timesmile2]

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

[S-R Online]

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 ''

[Crayon*]

PHP Code:

USE SRO_VT_SHARD 
UPDATE _RefObjItem SET MaxStack = 1000 where ID = (SELECT Link from _RefObjCommon where CodeName128 = 'ITEM_CODE_HERE') 


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.

[Eslam Galull]

MAGICSTONE

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

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

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

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

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

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