Query To Set New MaxStack Of Stones / Tablets / Elements / Elixirs

[MÓE]

actually i don't know if it's released before or not but it's helpful

MAGICSTONE

 Spoiler

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

 Spoiler

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

 Spoiler

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

 Spoiler

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

 Spoiler

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

 Spoiler

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

follow these steps

1- Open your sql

 Spoiler

2- Press New query

 Spoiler

3- Paste Query There

 Spoiler

4- Change @MaxStack=(NewMaxStack)

 Spoiler

5- Press Execute

 Spoiler

6- Query executed successfully

 Spoiler

7- Media Side - edit itemdata"xxx".txt in your media as the stack number

 Spoiler

8- Restart Server

 Spoiler

Restart Server

Congratulations!

[PortalDark]

#Approved

[radde94]

Good comment!

[TrixArts]

Thanks very helpful

[eXoTe30]

are the attribute stones and magicstones not bugged after this because of 0% 10% 20% and 30% stones are stacked at the same slot?

nice work thank you

[MÓE]

no it's working fine tested in sql 2008 r2 , you are welcome

[bxxb]

HelpFull thanks

[MÓE]

you're welcome

[Empire-Sro]

Help Full Thank You

[MÓE]

you're welcome

[Certus]

good job, but here is a clearer version of this query

Type 1 = Stones
Type 2 = Tablets
Type 3 = Elements
Type 4 = Elixirs

PHP Code:

USE SRO_VT_SHARD
/******By Certus ******/
DECLARE @Type INT = 1
DECLARE @MaxStack INT = 250 

-- *******************************************************************************
-- CHANGE STACK OF STONES
-- *******************************************************************************
IF @Type = 1
BEGIN
UPDATE _RefObjItem SET MaxStack = @MaxStack WHERE ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE 'ITEM_ETC_ARCHEMY_%STONE%' AND Service=1)
DECLARE @PrintMessageStones VARCHAR (50) = 'Stack of stones is successfully changed to '
    + RTRIM(CAST(@MaxStack AS nvarchar(30)))
PRINT @PrintMessageStones
END

-- *******************************************************************************
-- CHANGE STACK OF TABLETS
-- *******************************************************************************
IF @Type = 2
BEGIN
UPDATE _RefObjItem SET MaxStack = @MaxStack WHERE ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE 'ITEM_ETC_ARCHEMY_%TABLET%' AND Service=1)
DECLARE @PrintMessageTablets VARCHAR (50) = 'Stack of tablets is successfully changed to '
    + RTRIM(CAST(@MaxStack AS nvarchar(30)))
PRINT @PrintMessageTablets
END

-- *******************************************************************************
-- CHANGE STACK OF ELEMENTS
-- *******************************************************************************
IF @Type = 3
BEGIN
UPDATE _RefObjItem SET MaxStack = @MaxStack WHERE ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE 'ITEM_ETC_ARCHEMY_%ELEMENT%' AND Service=1)
DECLARE @PrintMessageElements VARCHAR (50) = 'Stack of elements is successfully changed to '
    + RTRIM(CAST(@MaxStack AS nvarchar(30)))
PRINT @PrintMessageElements
END

-- *******************************************************************************
-- CHANGE STACK OF ELIXIRS
-- *******************************************************************************
IF @Type = 4
BEGIN
UPDATE _RefObjItem SET MaxStack = @MaxStack WHERE ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE '%ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_%_B%' AND Service=1)
DECLARE @PrintMessageElexirs VARCHAR (50) = 'Stack of elixirs is successfully changed to '
    + RTRIM(CAST(@MaxStack AS nvarchar(30)))
PRINT @PrintMessageElexirs
END

IF @Type NOT BETWEEN 1 AND 4
BEGIN
PRINT 'Please set Type to 1 for stones'
PRINT 'Please set Type to 2 for tablets'
PRINT 'Please set Type to 3 for elements'
PRINT 'Please set Type to 4 for elixirs'
END 


[awful1337]

good job fifa..

very helpful
thanks mate<3

[MÓE]

Originally Posted by Certus

good job, but here is a clearer version of this query

Type 1 = Stones
Type 2 = Tablets
Type 3 = Elements
Type 4 = Elixirs

PHP Code:

USE SRO_VT_SHARD
/******By Certus ******/
DECLARE @Type INT = 1
DECLARE @MaxStack INT = 250 

-- *******************************************************************************
-- CHANGE STACK OF STONES
-- *******************************************************************************
IF @Type = 1
BEGIN
UPDATE _RefObjItem SET MaxStack = @MaxStack WHERE ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE 'ITEM_ETC_ARCHEMY_%STONE%' AND Service=1)
DECLARE @PrintMessageStones VARCHAR (50) = 'Stack of stones is successfully changed to '
    + RTRIM(CAST(@MaxStack AS nvarchar(30)))
PRINT @PrintMessageStones
END

-- *******************************************************************************
-- CHANGE STACK OF TABLETS
-- *******************************************************************************
IF @Type = 2
BEGIN
UPDATE _RefObjItem SET MaxStack = @MaxStack WHERE ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE 'ITEM_ETC_ARCHEMY_%TABLET%' AND Service=1)
DECLARE @PrintMessageTablets VARCHAR (50) = 'Stack of tablets is successfully changed to '
    + RTRIM(CAST(@MaxStack AS nvarchar(30)))
PRINT @PrintMessageTablets
END

-- *******************************************************************************
-- CHANGE STACK OF ELEMENTS
-- *******************************************************************************
IF @Type = 3
BEGIN
UPDATE _RefObjItem SET MaxStack = @MaxStack WHERE ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE 'ITEM_ETC_ARCHEMY_%ELEMENT%' AND Service=1)
DECLARE @PrintMessageElements VARCHAR (50) = 'Stack of elements is successfully changed to '
    + RTRIM(CAST(@MaxStack AS nvarchar(30)))
PRINT @PrintMessageElements
END

-- *******************************************************************************
-- CHANGE STACK OF ELIXIRS
-- *******************************************************************************
IF @Type = 4
BEGIN
UPDATE _RefObjItem SET MaxStack = @MaxStack WHERE ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE '%ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_%_B%' AND Service=1)
DECLARE @PrintMessageElexirs VARCHAR (50) = 'Stack of elixirs is successfully changed to '
    + RTRIM(CAST(@MaxStack AS nvarchar(30)))
PRINT @PrintMessageElexirs
END

IF @Type NOT BETWEEN 1 AND 4
BEGIN
PRINT 'Please set Type to 1 for stones'
PRINT 'Please set Type to 2 for tablets'
PRINT 'Please set Type to 3 for elements'
PRINT 'Please set Type to 4 for elixirs'
END 


well mine working aswell so you can create a new topic thanks anyway

Originally Posted by awful1337

good job fifa..

very helpful
thanks mate<3

thank you you're welcome

[MÓE]

thank you!

[burundukas]

Helpful ty