خط حاجات ديه في _addlogchar في SHADLOG
|
|
|
If @EventID = 6 and exists (select * from sro_vt_shard.._charcos where ownercharid = @CharID and refcharid in (select id from sro_vt_shard.._refobjcommon where codename128 like '%COS_T%')
begin
update SRO_VT_SHARD.._InvCOS set itemid = 0
where COSID = (select id from sro_vt_shard.._CharCOS where OwnerCharID = @CharID and RefCharID in (select id from sro_vt_Shard.._RefObjCommon where codename128 like '%COS_T%'))
update SRO_VT_SHARD.dbo._CharCOS set ownercharid = 0
where
OwnerCharID = @CharID and RefCharID in (select id from SRO_VT_SHARD.._RefObjCommon where CodeName128 like '%COS_T%')
end
|