Hello friends I will can help.
I have a problem I have on my server potions for 50 units but I want to put them 1000 or 200 as I do this
Printable View
Hello friends I will can help.
I have a problem I have on my server potions for 50 units but I want to put them 1000 or 200 as I do this
Use the following query
declare @Stack varchar(max)
declare @Code varchar(max)
set @Stack='1000'--The stack package, it will change the amount of stackable item
set @Code='ITEM_XXX'--Place the code here.
update _RefObjItem set MaxStack = @Stack where ID = (select Link from _RefObjCommon where CodeName128 like @Code)
print (select
Tell me if it gave you subquery. did not test it yet!
Also, after finishing this shit, remove the first query and copy both queries "query and result" in notepad
select * from _RefObjCommon where CodeName128 like @code
select * from _RefObjItem where ID like=(select Link from _RefObjCommon where CodeName128 like @Code)
and then, delete enter and spaces between both lines till it become only one line, remove the Link number from the first result and inject with the 2nd result like the following
1 44068 ITEM_COS_PET2_FOX_SCROLL ?? xxx SN_ITEM_COS_PET2_FOX_SCROLL SN_ITEM_COS_PET2_FOX_SCROLL_TT_DESC 1 0 3 2 1 1 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_ch_acc.bsr pet2\item\item_pet2_scroll_fox.ddj xxx xxx 21886
21886 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 -1 COS_PET2_FOX_001 -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 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
1 44068 ITEM_COS_PET2_FOX_SCROLL ?? xxx SN_ITEM_COS_PET2_FOX_SCROLL SN_ITEM_COS_PET2_FOX_SCROLL_TT_DESC 1 0 3 2 1 1 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_ch_acc.bsr pet2\item\item_pet2_scroll_fox.ddj xxx xxx 21886 21886 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 -1 COS_PET2_FOX_001 -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 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
Remove the bold and replace the result in itemdata_xxx
Dunno if you cant get me. and tell me please if the query did not work. did not test it, only wrote.
hey man this is to place the pack potions eg 1000 1000 Hp and Mp