userfull querry to modify max stack items easy

02/16/2020 08:38 gunneremil#1
Search your item to see its maxstack
Quote:
use JSRO_SHARDTEST
select b.service,a.maxstack,a.ID,b.codename128 from _RefObjItem a inner join _RefObjCommon b on a.ID=b.Link
and b.codename128 like '%cure%'
order by MaxStack

Update your item maxstack
Quote:
use JSRO_SHARDTEST
update _RefObjItem set MaxStack = 100 where id in (select link from _RefObjCommon where CodeName128 like '%cure%')
02/19/2020 08:41 VORTEX*#2
too late , released since 2013
02/19/2020 09:11 bende16#3
Quote:
Originally Posted by Zerox* View Post
too late , released since 2013
maybe this member wasn't born yet at the time, maybe ?
02/19/2020 09:15 Devsome#4
Quote:
Originally Posted by bende16 View Post
maybe this member wasn't born yet at the time, maybe ?
Sure, all the members are 7 years old.