Bu prosedür gerçekten çok işe yarıyor düşen bütün itemlerin kime düştüğünü ve özelliklerini görebiliyorsunuz.
Nasıl kullanılır = New Query ile execute yapınca hemen aşağıda kime ne düştüğü görünür.
Select Top 500 bölümünü 100 yaparsanız 100 tanesi görünür 1000 yaparsanız 1000 tanesi görünür.
Prosedür aşağıdadır.
PHP- Kodu:
Nasıl kullanılır = New Query ile execute yapınca hemen aşağıda kime ne düştüğü görünür.
Select Top 500 bölümünü 100 yaparsanız 100 tanesi görünür 1000 yaparsanız 1000 tanesi görünür.
Prosedür aşağıdadır.
PHP- Kodu:
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_utf8mb3_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 elog.strDesc not like '%NPC%'
AND ref.CodeName128 not like '%ARCHEMY%'
AND chart.CharName16 not like '%[GM]%'
ORDER BY elog.EventTime desc
END
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_utf8mb3_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 elog.strDesc not like '%NPC%'
AND ref.CodeName128 not like '%ARCHEMY%'
AND chart.CharName16 not like '%[GM]%'
ORDER BY elog.EventTime desc
END