Mercenarios [vSRO]:D

[agtreo]

RefOfCommon

1 21400 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

RefOfItem

21400 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

SQL

use SRO_VT_SHARDupdate _RefObjCommon
set TypeID1= 3 ,
TypeID2= 2 ,
TypeID3= 1 ,
TypeID4= 1
where CodeName128 like 'ITEM_ETC_GUILD_CH_SOLDIER4_SCROLL';
USE SRO_VT_SHARD_INIT
--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' )

You must be registered to see links

CAP 110 D11
Visit