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

[wilber1414]

itemdata"***".txt what's it ? I need edit the Media.pk2 to show the new MaxStack

[Dev Microsoft]

Originally Posted by wilber1414

itemdata"***".txt what's it ? I need edit the Media.pk2 to show the new MaxStack

you dont need to edit it in media only from db

[Anonyxx]

i cant see image ??

[MÓE]

Originally Posted by wilber1414

itemdata"xxx".txt what's it ? I need edit the Media.pk2 to show the new MaxStack

you've to search in all the itemdata and change the maxstack like what you did in database for avioding crashing.

Originally Posted by Dev Microsoft

you dont need to edit it in media only from db

he should change the maxstack same as db side otherwise he gonna get crash as well.

Originally Posted by Anonyxx

i cant see image ??

I dont have them anymore to re-upload but I think I wrote all what u want to change the maxstack also Certus wrote a quick query
here you go

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 


[pvperz ll]

pls s.s

[metma12]

7- Media Side - edit itemdata"***".txt in your media as the stack number
Some one can expline me how to do that im new
Nvm sorry done

[hunter2051]

Originally Posted by metma12

7- Media Side - edit itemdata"***".txt in your media as the stack number
Some one can expline me how to do that im new
Nvm sorry done

SAME QUESTION....

[Judgelemental]

Originally Posted by hunter2051

SAME QUESTION....

From itemdata5000 to itemdata45000, edit depending on where your item is located at, that's all.

[hunter2051]

i still stuck here. i edited DB and itemdataxxx.txt also, it still crash...

[SDClowen]

Always use TypeId instead of codename for that. It will be return good results about performance than "codename like bla bla". Example working query.

PHP Code:

-- types
--TypeID4: 1 -> Magic stones
--TypeID4: 2 -> Attribute stones
--TypeID4: 3 -> Tablets
--TypeID4: 4 -> Material
--TypeID4: 5 -> Elements

declare @type tinyint = 1
declare @stack int = 20

update _RefObjItem set MaxStack = @stack from _RefObjCommon
join _RefObjItem on _RefObjItem.ID = _RefObjCommon.Link
where 
    TypeID1 = 3 and TypeID2 = 3 and  TypeID3 = 11 and TypeID4 = @type 


[Xoen]

so good

[guast21]

any news about this:

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

how to do it? where is itemdata"***".txt and what "***" stands for?

[Sorrich525]

Originally Posted by guast21

any news about this:

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

how to do it? where is itemdata"***".txt and what "***" stands for?

At the media.pk2 you got the folder server_dep/silkroad/textdata/
And there you got the itemdata files

[Judgelemental]

Originally Posted by guast21

any news about this:

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

how to do it? where is itemdata"***".txt and what "***" stands for?

'***' stands for the itemdata.txt number.
For example, itemdata45000.txt or wherever your item is at.

I will make a tutorial later.

[XAnthraxx]

[CENTER]7- Media Side - edit itemdata"***".txt in your media as the stack number

 Spoiler

8- Restart Server

 Spoiler

Restart Server

what do i do for media side? im confused?