Stackable Items Guide

[kellogz]

Someone PMed me on here, and since ive had help from this community im willing to share back some usefull infromation and will continue too...

So without further or do here is my second guide for allowing stackable items on your servers:

you need to change the stacks values in two places, server side and media side. If you do just 1 you will see the stack effect but it will cause crashing and DC too players.

In this guide i will show you how to change the stack limit off a item that currently doesnt stack "Weapon Elixir"

Ok first off in SQL open up your Refobjcommon table and find the item you want to make stackable or increase its stack limit.

1 3679 ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_WEAPON_B ?? ????(??) xxx SN_ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_WEAPON_B SN_ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_WEAPON_B_TT_DESC 0 0 3 3 10 1 180000 3 0 1 1 1 255 3 1 0 0 0 0 100000 0 0 0 600 20000 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_reinforce_recipe.bsr item\etc\archemy_reinforce_recipe_weapon_b.ddj xxx xxx 2029

If you look on the far right coloumn there is a number in this case "2029" this is the "Link" coloumn number. You will need this number so write it down!

Now that you have this number open on your Refobjitem table and go to the id of the number you just wrote down, in our case it was "2029"

You will see a coloumn named "MaxStack" if you are doing a weapon elixir and not modified this before it will be set to "1" by default. Change this to the value you wish, i have mine on Atomix set too 1000, i wouldnt advise going much higher than 10000 for any item you modify stack wise.

Ok now thats everything done DB side, we now need to do it Media side.

ok so using your pk2 tool extract the itemdata5000 too itemdata45000 files.

I STRONGLY adivse you use a good txt editor such as Notepad++ this is very very uesfull for alot of things related to editing the medias.

With notepad++ open up all the documents and hit Ctrl+F. Since we got our DB still open go back to the RefObjCommon to tab and copy the "codename128" for the item stack you are changing, for this example its "ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_WEAPON_B". Paste this in the search box and hit "Find In All Opened Documents" you will have the results at the bottom so just double click in the result and it will auto load the document for you. you should now have a line like this:

1	3679	ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_WEAPON_B	?? ????(??)	xxx	SN_ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_WEAPON_B	SN_ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_WEAPON_B_TT_DESC	0	0	3	3	10	1	180000	3	0	1	1	1	255	3	1	0	0	0	0	100000	0	0	0	600	20000	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_reinforce_recipe.bsr	item\etc\archemy_reinforce_recipe_weapon_b.ddj	xxx	xxx	1	2	0	0	2	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	100663296	??????	841489939	1,2,3,4	286331153	5,6,7,8	286002188	9,10,11,12	0	??????	0	??????	-1	xxx	-1	xxx	-1	xxx	1	[??]	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0

This is the bit of that line we need:

xxx	item\etc\drop_reinforce_recipe.bsr	item\etc\archemy_reinforce_recipe_weapon_b.ddj	xxx	xxx	1

The max stack limit is the end number after the 2 sets of "xxx". Change this to how you have just chaneged the limit, for our example we set it too "1000". Save the txt, put it back into your media.pk2, restart your server and you now have stacble weapon elixirs. Please note there are two types of weapon elixirs A and B, i simply did both A and B of all elixirs. just follow the guide again.

Enjoy now stackable items :)

Kellogz - Atomix SRO

[MentaL]

[Jangan]

Woot! Old news! I stole atomix's method loong time ago!! ~~ Kidding...

love the release bro! i was always wondering how the Media calculated the max limits... thought it was interface xD

[kellogz]

Woot! Old news! I stole atomix's method loong time ago!! ~~ Kidding...

love the release bro! i was always wondering how the Media calculated the max limits... thought it was interface xD

NP you only had to ask me you know that :)

[SL1MSH4DY]

I'll be trying this soon with more stackable items.

[3d2000]

great Guide.. thxxxxxxxxxxxxx

[Caipi]

I made some nonsense for lazy ones regarding to the topic :)

USE SRO_VT_SHARD
Declare @NEWMaxStack varchar(10)
Declare @ItemID int
Declare @oldStack varchar(10)



SET @NEWMaxStack = 75    /* e.g. stackable up to 75 */
SET @ItemID = 4            /* ID of the Item ofrom the itemdata.txt files */



SET @oldStack = (SELECT MaxStack FROM _RefObjItem WHERE ID like (SELECT Link FROM _RefObjCommon WHERE ID like @ItemID))
UPDATE dbo._RefObjItem SET MaxStack = @NEWMaxStack WHERE ID = (SELECT Link FROM _RefObjCommon WHERE ID like @ItemID)

/* Which Itemdata.txt is affected in the Media.pk2*/
Declare @newItemID varchar(5)
IF (@ItemID < 5000)
    SET @newItemID = 5000
else if (@ItemID < 10000)
    SET @newItemID = 10000
else if (@ItemID < 15000)
    SET @newItemID = 15000
else if (@ItemID < 20000)
    SET @newItemID = 20000
else if (@ItemID < 25000)
    SET @newItemID = 25000
else if (@ItemID < 30000)
    SET @newItemID = 30000
else if (@ItemID < 35000)
    SET @newItemID = 35000
else if (@ItemID < 40000)
    SET @newItemID = 40000
else if (@ItemID >= 40000)
    SET @newItemID = 45000
/*END which Itemdata.txr*/

Declare @CodeName varchar(74)
Declare @DDJ varchar(74)
SET @CodeName = (SELECT CodeName128 FROM _RefObjCommon WHERE ID like @ItemID)
SET @DDJ = (SELECT AssocFileIcon128 FROM _RefObjCommon WHERE ID like @ItemID)

/* Paths */
print ''
print '@ Media\server_dep\silkroad\textdata\itemdata_'+@newItemID+'.txt'
print ''
print 'Change the line within the Itemdata.txt file like stated below:'
print ''
print 'Press CTRL+F and paste '+'"'+@CodeName+'"'+' into the box and search for the line at the file.'
print 'Scroll to the right till you reach '+'"'+@DDJ+'"'+' and change the value behind the 2x "xxx" from '+'"'+@oldStack+'"'+' to '+'"'+@NEWMaxStack+'"'+'.' 

Change only the values of @NEWMaxStack and @ItemID!

Will give you everything out what and where you need to change it.

[SL1MSH4DY]

I think you like doing querys. Great work!

[Romochild]

I made some nonsense for lazy ones regarding to the topic :)

USE SRO_VT_SHARD
Declare @NEWMaxStack varchar(10)
Declare @ItemID int
Declare @oldStack varchar(10)



SET @NEWMaxStack = 75    /* e.g. stackable up to 75 */
SET @ItemID = 4            /* ID of the Item ofrom the itemdata.txt files */



SET @oldStack = (SELECT MaxStack FROM _RefObjItem WHERE ID like (SELECT Link FROM _RefObjCommon WHERE ID like @ItemID))
UPDATE dbo._RefObjItem SET MaxStack = @NEWMaxStack WHERE ID = (SELECT Link FROM _RefObjCommon WHERE ID like @ItemID)

/* Which Itemdata.txt is affected in the Media.pk2*/
Declare @newItemID varchar(5)
IF (@ItemID < 5000)
    SET @newItemID = 5000
else if (@ItemID < 10000)
    SET @newItemID = 10000
else if (@ItemID < 15000)
    SET @newItemID = 15000
else if (@ItemID < 20000)
    SET @newItemID = 20000
else if (@ItemID < 25000)
    SET @newItemID = 25000
else if (@ItemID < 30000)
    SET @newItemID = 30000
else if (@ItemID < 35000)
    SET @newItemID = 35000
else if (@ItemID < 40000)
    SET @newItemID = 40000
else if (@ItemID >= 40000)
    SET @newItemID = 45000
/*END which Itemdata.txr*/

Declare @CodeName varchar(74)
Declare @DDJ varchar(74)
SET @CodeName = (SELECT CodeName128 FROM _RefObjCommon WHERE ID like @ItemID)
SET @DDJ = (SELECT AssocFileIcon128 FROM _RefObjCommon WHERE ID like @ItemID)

/* Paths */
print ''
print '@ Media\server_dep\silkroad\textdata\itemdata_'+@newItemID+'.txt'
print ''
print 'Change the line within the Itemdata.txt file like stated below:'
print ''
print 'Press CTRL+F and paste '+'"'+@CodeName+'"'+' into the box and search for the line at the file.'
print 'Scroll to the right till you reach '+'"'+@DDJ+'"'+' and change the value behind the 2x "xxx" from '+'"'+@oldStack+'"'+' to '+'"'+@NEWMaxStack+'"'+'.' 

Change only the values of @NEWMaxStack and @ItemID!

Will give you everything out what and where you need to change it.

Thanks bro! Very helpful. If only you were like 8 days earlier? T_T haha would of saved me quite a while.

[Caipi]

Thanks bro! Very helpful. If only you were like 8 days earlier? T_T haha would of saved me quite a while.

I actually thought that changing the MaxStack is so easy that no one will ever need such a detailed one.. ^^

[sladlejrhfpq]

Well, i have a strange bug, i set the maxstack to 100 for elixirs like this

USE SRO_VT_SHARD
UPDATE _RefObjItem SET MaxStack=100 WHERE ID=3679
UPDATE _RefObjItem SET MaxStack=100 WHERE ID=3680
UPDATE _RefObjItem SET MaxStack=100 WHERE ID=3681
UPDATE _RefObjItem SET MaxStack=100 WHERE ID=3682

Of course i edited it at media.pk2 too,(for example i have 20 put together), but when i put that 20 on a weapon, start alchemy, it uses 19, and i have only one left. Anybody know what can cause this?

EDIT:
Working..... I used the ID instead of the Link lol

[Dragonzee]

well i used a query its like this

UPDATE dbo._RefObjCommon
SET MaxStack = Number of Stack
WHERE ID BETWEEN Start from id of item AND to last item id

[sladlejrhfpq]

well i used a query its like this

UPDATE dbo._RefObjCommon
SET MaxStack = Number of Stack
WHERE ID BETWEEN Start from id of item AND to last item id

yeah I know it too, but I want to see everything what did I do :)

[3d2000]

Caipi <3

[Oventiful]

have 5 elixier when use 1 .. all go
and when have 2 immortal and teleport it be 1 - 1
any help ?!!

[omerdogan41]

great guide,thanks :)