VSRO Son Düşen Sox itemler, vSRO Drop Sox Items Log Query
VSRO Son Düşen Sox itemler, vSRO Drop Sox Items Log Query
BLOG
Merhabalar,
Vereceğimquery ile serverinizde drop olan son 500 sox item’i görebileceksiniz.
Eğerson düşen 500 itemden fazlasını görmek isterseniz Select Top kısmındaki 500’ü kendinize göre değiştirin.
Loglarınız kapalıysa bu query bir işinize yaramaz.
SQL:
USE SRO_VT_SHARD
BEGIN
SELECT TOP 500
chart.CharName16 as Player,
ref.CodeName128 as ItemCode,
CASE WHEN CHARINDEX('Opt',elog.strDesc) != 0 THEN SUBSTRING(elog.strDesc,(PATINDEX('%+%',elog.strDesc)),2) ELSE '+0' END as '+Amount',
SUBSTRING(elog.strDesc,CHARINDEX('MOB',elog.strDesc),(CHARINDEX(',',elog.strDesc, CHARINDEX('MOB',elog.strDesc)))-CHARINDEX('MOB',elog.strDesc)) as Monster,
CASE
WHEN chart.CharName16 collate SQL_Latin1_General_CP1_CI_AS like '%'+(SUBSTRING(elog.strDesc,CHARINDEX('[',elog.strDesc,CHARINDEX('Var',elog.strDesc))+1,(CHARINDEX(']',elog.strDesc, CHARINDEX('[',elog.strDesc,CHARINDEX('Var',elog.strDesc))+1))-CHARINDEX('[',elog.strDesc,CHARINDEX('Var',elog.strDesc))-1))+'%'
THEN '-'
WHEN CHARINDEX('Var',elog.strDesc) != 0
THEN UPPER(SUBSTRING(elog.strDesc,CHARINDEX('[',elog.strDesc,CHARINDEX('Var',elog.strDesc))+1,(CHARINDEX(']',elog.strDesc, CHARINDEX('[',elog.strDesc,CHARINDEX('Var',elog.strDesc))+1))-CHARINDEX('[',elog.strDesc,CHARINDEX('Var',elog.strDesc))-1))
ELSE '-'
END as Info,
elog.EventTime as 'Date'
FROM _Items as items
JOIN SRO_VT_LOG.dbo._LogEventItem/*#*/ as elog on items.Serial64 = elog.Serial64
JOIN _Char as chart on elog.CharID = chart.CharID
JOIN _RefObjCommon as ref on elog.ItemRefID = ref.ID
WHERE
elog.strDesc like '%MOB%'
AND ref.CodeName128 not like '%ARCHEMY%'
AND ref.CodeName128 like '%RARE%'
ORDER BY elog.EventTime desc
END
