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

Page 4 of 5 « First 23 4 5
11/30/2015 02:16 wilber1414#46
itemdata"xxx".txt what's it ? I need edit the Media.pk2 to show the new MaxStack
12/01/2015 12:20 Dev Microsoft#47
Quote:
Originally Posted by wilber1414 View Post
itemdata"xxx".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 :)
01/31/2016 06:32 Anonyxx#48
i cant see image ??
07/22/2016 11:40 MÓE#49
Quote:
Originally Posted by wilber1414 View Post
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.
Quote:
Originally Posted by Dev Microsoft View Post
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.
Quote:
Originally Posted by Anonyxx View Post
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 
01/16/2018 14:59 pvperz ll#50
pls s.s
05/04/2020 11:42 metma12#51
7- Media Side - edit itemdata"xxx".txt in your media as the stack number
Some one can expline me how to do that im new :)
Nvm sorry done
11/10/2020 07:52 hunter2051#52
Quote:
Originally Posted by metma12 View Post
7- Media Side - edit itemdata"xxx".txt in your media as the stack number
Some one can expline me how to do that im new :)
Nvm sorry done
SAME QUESTION....
11/14/2020 22:26 Judgelemental#53
Quote:
Originally Posted by hunter2051 View Post
SAME QUESTION....
From itemdata5000 to itemdata45000, edit depending on where your item is located at, that's all.
11/27/2020 16:41 hunter2051#54
i still stuck here. i edited DB and itemdataxxx.txt also, it still crash...
11/30/2020 04:21 SDClowen#55
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 
12/06/2020 21:26 Xoen#56
so good
12/18/2020 20:35 guast21#57
any news about this:

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

how to do it? where is itemdata"xxx".txt and what "xxx" stands for?
12/19/2020 10:14 Sorrich525#58
Quote:
Originally Posted by guast21 View Post
any news about this:

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

how to do it? where is itemdata"xxx".txt and what "xxx" stands for?
At the media.pk2 you got the folder server_dep/silkroad/textdata/
And there you got the itemdata files
12/19/2020 10:54 Judgelemental#59
Quote:
Originally Posted by guast21 View Post
any news about this:

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

how to do it? where is itemdata"xxx".txt and what "xxx" stands for?
'xxx' stands for the itemdata.txt number.
For example, itemdata45000.txt or wherever your item is at.

I will make a tutorial later.
10/12/2022 19:36 XAnthraxx#60
[CENTER]7- Media Side - edit itemdata"xxx".txt in your media as the stack number


8- Restart Server



what do i do for media side? im confused?
Page 4 of 5 « First 23 4 5