so today i'm going to share it ( its epic solution :-p )
prof.
http://www.youtube.com/watch?v=OMuIx8E8mBQ
reobjcommon
refobjitemCode:1 42043 ITEM_COS_GUILD_CH_SOLDIER5_105_1 ?? ?? ?? ??? xxx SN_ITEM_COS_GUILD_CH_SOLDIER5_105_1 SN_ITEM_COS_GUILD_CH_SOLDIER5_105_1_TT_DESC 0 0 3 2 1 1 180000 3 0 1 1 1 223 0 1 0 0 1 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_scroll.bsr cos\guild_ch_soldier5_scroll.ddj xxx xxx 1999
for noobs don't ask about how to add it ( most of you already knows how ) how ever i have been working on them long time ago and tried to make them controllable and i failedCode:1999 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 20 COS_GUILD_CH_SOLDIER5_105 0 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
so would be gr8 if some one knows how and share it
Yours Ahmed4ever2u from epvp
i did a quick test with this query
and the result was unsummon able :(Code:
use SRO_VT_SHARD
update _RefObjCommon
set TypeID1= 3 ,
TypeID2= 2 ,
TypeID3= 1 ,
TypeID4= 1
where CodeName128 like 'ITEM_ETC_GUILD_CH_SOLDIER4_SCROLL';
USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)
set @CharName = 'Admin'
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_GUILD_CH_SOLDIER4_SCROLL',1,1
select * from _RefObjCommon where CodeName128 like 'ITEM_ETC_GUILD_CH_SOLDIER4_SCROLL';
select * from _RefObjItem where ID = ( select Link from _RefObjCommon where CodeName128 like 'ITEM_ETC_GUILD_CH_SOLDIER4_SCROLL' )

