need assistance with stackable

04/23/2019 20:58 yangc10#1
Can someone provide their itemdata text file for the following items?

Code:
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.
04/24/2019 13:18 _SGA_#2
Since I left sro scene a long time ago I don't exactly remember anymore but, I believe it was in the _RefObjCommon table.
04/24/2019 18:58 NorseGodTyr#3
Quote:
Originally Posted by yangc10 View Post
Can someone provide their itemdata text file for the following items?

Code:
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
04/24/2019 20:12 yangc10#4
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
04/24/2019 21:19 NorseGodTyr#5
Quote:
Originally Posted by yangc10 View Post
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 xxx xxx
Quote:
1 41521 ITEM_COS_P_CIRCUSBEAR_SCROLL ???? ????? xxx 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 xxx item\etc\drop_valtyr0_box1.bsr cos\cos_p_circusbear.ddj xxx xxx 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 xxx -1 xxx -1 xxx -1 xxx -1 CashRank:2 -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
04/24/2019 21:27 yangc10#6
I'm looking for the following items:
Code:
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.
04/25/2019 10:43 NorseGodTyr#7
Quote:
Originally Posted by yangc10 View Post
I'm looking for the following items:
Code:
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
Quote:
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
Quote:
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
04/26/2019 02:08 yangc10#8
lolz I was looking at the wrong thing all along. Thanks.
07/30/2019 11:25 suntrockdinokna#9
Use this to change stacks of items

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

ID taken from ObjItem table