need assistance with stackable

[yangc10]

Can someone provide their itemdata text file for the following items?

ID	Link	CodeName	Description

2145	1924	ITEM_ETC_COS_RES_POTION_01	Abnormal State Recovery (Small)
2146	1925	ITEM_ETC_COS_RES_POTION_02	Abnormal State Recovery (Medium)

I could not locate the info on the itemdata to increase its max stacks.

[_SGA_]

Since I left sro scene a long time ago I don't exactly remember anymore but, I believe it was in the _RefObjCommon table.

[NorseGodTyr]

Originally Posted by yangc10

Can someone provide their itemdata text file for the following items?

ID	Link	CodeName	Description

2145	1924	ITEM_ETC_COS_RES_POTION_01	Abnormal State Recovery (Small)
2146	1925	ITEM_ETC_COS_RES_POTION_02	Abnormal State Recovery (Medium)

I could not locate the info on the itemdata to increase its max stacks.

to increase stack search codename in RefObjCommon and Itemdata after you find open RefObjItem ( search id from RefObjCommon end of the Line is linked Number ) and increase MaxStack dont forget to change inside itemdata

[yangc10]

sorry, I should've mentioned that the SQL side is already completed, but I'm not seeing it on the textdata side in media.pk2

[NorseGodTyr]

Originally Posted by yangc10

sorry, I should've mentioned that the SQL side is already completed, but I'm not seeing it on the textdata side in media.pk2

marked in red exmaple this line
after cos\cos_p_circusbear.ddj *** ***

1 41521 ITEM_COS_P_CIRCUSBEAR_SCROLL ???? ????? *** SN_ITEM_COS_P_CIRCUSBEAR_SCROLL SN_ITEM_COS_P_CIRCUSBEAR_SCROLL_TT_DESC 1 0 3 2 1 2 180000 3 0 1 1 1 223 0 1 0 0 1 0 0 0 0 0 0 0 1 5 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 *** item\etc\drop_valtyr0_box1.bsr cos\cos_p_circusbear.ddj *** *** 1 2 0 0 1 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 40320 COS_P_CIRCUSBEAR -1 *** -1 *** -1 *** -1 *** -1 CashRank:2 -1 *** -1 *** -1 *** -1 *** -1 *** -1 *** -1 *** -1 *** -1 *** -1 *** -1 *** -1 *** -1 *** -1 *** 0 0

[yangc10]

I'm looking for the following items:

2145	1924	ITEM_ETC_COS_RES_POTION_01	Abnormal State Recovery (Small)
2146	1925	ITEM_ETC_COS_RES_POTION_02	Abnormal State Recovery (Medium)

The one you posted seems to be for something else. I know how to modify the stacks; I just need the lines for the Abnormal State Recovery items which I cannot find it on the textdata.

[NorseGodTyr]

Originally Posted by yangc10

I'm looking for the following items:

2145	1924	ITEM_ETC_COS_RES_POTION_01	Abnormal State Recovery (Small)
2146	1925	ITEM_ETC_COS_RES_POTION_02	Abnormal State Recovery (Medium)

The one you posted seems to be for something else. I know how to modify the stacks; I just need the lines for the Abnormal State Recovery items which I cannot find it on the textdata.

itemdata_10000.txt

1 9226 ITEM_COS_P_CURE_ALL_01 ? ???? ?? ???(?) xxx SN_ITEM_COS_P_CURE_ALL_01 SN_ITEM_COS_P_CURE_ALL_01_TT_DESC 0 0 3 3 2 7 180000 3 0 1 1 1 255 3 1 0 0 1 0 36 0 0 0 1 17 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_ch_bag.bsr cos\item_cos_p_cure_all_01.ddj xxx xxx 50 2 0 0 1 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 36 ??????? 36 ??????? 36 ??????? 36 ??????? 36 ??????? 36 ??????? -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0

textdata_object.txt

1 SN_ITEM_COS_P_CURE_ALL_01 ???? ???(?) 0 0 0 0 0 Abnormal state recovery potion (small) Abnormal state recovery potion (small) 0 0 0 0 0 0

[yangc10]

lolz I was looking at the wrong thing all along. Thanks.

[suntrockdinokna]

Use this to change stacks of items

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

ID taken from ObjItem table