Queryleri DynamicRankv2 tablosuna işleyerek çalıştırabilirsiniz.
Ekli dosyayı görüntüle 238
*** Gizli metin: alıntı yapılamaz. ***
SELECT TOP 50 F.CharName16, CASE WHEN G.ID = 0 THEN '<No Guild>' ELSE G.Name END AS Guild, ISNULL(CAST((SUM(B.OptLevel)) + (CASE WHEN SUM(C.nOptValue) > 0 THEN SUM(C.nOptValue) ELSE 0 END) + (SUM(CEILING((E.HR_U / 3)))) + (SUM(CEILING(E.ER_U * 2))) + (SUM(CEILING((E.PAR_U * 2)))) AS INT),0) AS ItemPoints , RefObjID
from SRO_VT_SHARD.._Inventory AS A WITH (NOLOCK)
INNER join SRO_VT_SHARD.._Items AS B WITH (NOLOCK) ON A.ItemID = B.ID64
LEFT join SRO_VT_SHARD.._BindingOptiONWithItem AS C WITH (NOLOCK) ON A.ItemID = C.nItemDBID AND C.bOptType = 2
INNER join SRO_VT_SHARD.._RefObjCommON AS D WITH (NOLOCK) ON B.RefItemID = D.ID
INNER join SRO_VT_SHARD.._RefObjItem AS E WITH (NOLOCK) ON D.Link = E.ID
LEFT join SRO_VT_SHARD.._Char AS F WITH (NOLOCK) ON A.CharID = F.CharID
LEFT join SRO_VT_SHARD.._Guild AS G WITH (NOLOCK) ON F.GuildID = G.ID
where A.Slot NOT IN (7,8) and A.ItemID > 0 and A.Slot >=0 and A.Slot <=12
group by F.CharName16, F.RefObjID, F.CurLevel, G.Name,G.ID
Order by ItemPoints DESC
SELECT TOP 50
CharName16,
Guild,
Experiance,
RefObjID
FROM
(
SELECT
A.CharName16,
CASE WHEN C.ID = 0 THEN '<No Guild>' ELSE C.Name END AS Guild,
CONVERT(varchar, A.CurLevel) + ' (%' + CONVERT(varchar, FORMAT((CONVERT(FLOAT, (A.ExpOffset) * 100) / CONVERT(FLOAT, (B.Exp_C))), 'N2')) + '%)' AS Experiance,
A.RefObjID,
A.CurLevel,
(CONVERT(FLOAT, A.ExpOffset) / NULLIF(CONVERT(FLOAT, B.Exp_C), 0)) AS ExpPercentage
FROM
SRO_VT_SHARD.._Char A
JOIN
SRO_VT_SHARD.._RefLevel B ON A.CurLevel = B.Lvl
JOIN
SRO_VT_SHARD.._Guild C ON A.GuildID = C.ID
WHERE
A.CharName16 NOT LIKE '%GM%'
AND A.CharName16 NOT IN ( 'Developer' )
) AS SubQuery
ORDER BY
CurLevel DESC,
ExpPercentage DESC
30 Unique Rank SELECT TOP 50 _Char.CharName16 as Char_Name,GuildName as 'Guild', LTRIM(STR(Point)) + ' (' + LTRIM(STR(TotalUniqueKills)) + ')' as 'Point (Kills)', _Char.RefObjID from Maxiguard_User.._DynamicRankUnique
INNER JOIN SRO_VT_SHARD.dbo._Char WITH(NOLOCK) ON _Char.CharID = _DynamicRankUnique.CharID
ORDER BY Point DESC, TotalUniqueKills DESC, _Char.CharID ASC
SELECT TOP 50 _Char.CharName16 as Char_Name, CASE WHEN _Guild.ID = 0 THEN '<No Guild>' ELSE _Guild.Name END AS Guild, DynamicRank.Point as Point, RefObjID as RefObjID, JobType as JobType FROM
SRO_VT_SHARD.dbo._Char
INNER JOIN SRO_VT_SHARD.dbo._Guild ON _Char.GuildID = _Guild.ID
INNER JOIN SRO_VT_SHARD.dbo._CharTrijob ON _CharTrijob.CharID = _Char.CharID
INNER JOIN MaxiGuard_User.._DynamicRankJob_Hunter DynamicRank ON DynamicRank.CharID=_Char.CharID
WHERE _CharTrijob.JobType=3
ORDER BY _Char.CurLevel DESC True chardata True False
31 Player Rank SELECT TOP 50 F.CharName16, CASE WHEN G.ID = 0 THEN '<No Guild>' ELSE G.Name END AS Guild, ISNULL(CAST((SUM(B.OptLevel)) + (CASE WHEN SUM(C.nOptValue) > 0 THEN SUM(C.nOptValue) ELSE 0 END) + (SUM(CEILING((E.HR_U / 3)))) + (SUM(CEILING(E.ER_U * 2))) + (SUM(CEILING((E.PAR_U * 2)))) AS INT),0) AS ItemPoints , RefObjID
from SRO_VT_SHARD.._Inventory AS A WITH (NOLOCK)
INNER join SRO_VT_SHARD.._Items AS B WITH (NOLOCK) ON A.ItemID = B.ID64
LEFT join SRO_VT_SHARD.._BindingOptiONWithItem AS C WITH (NOLOCK) ON A.ItemID = C.nItemDBID AND C.bOptType = 2
INNER join SRO_VT_SHARD.._RefObjCommON AS D WITH (NOLOCK) ON B.RefItemID = D.ID
INNER join SRO_VT_SHARD.._RefObjItem AS E WITH (NOLOCK) ON D.Link = E.ID
LEFT join SRO_VT_SHARD.._Char AS F WITH (NOLOCK) ON A.CharID = F.CharID
LEFT join SRO_VT_SHARD.._Guild AS G WITH (NOLOCK) ON F.GuildID = G.ID
where A.Slot NOT IN (7,8) and A.ItemID > 0 and A.Slot >=0 and A.Slot <=12
group by F.CharName16, F.RefObjID, F.CurLevel, G.Name,G.ID
Order by ItemPoints DESC True chardata True False
32 Trader Rank SELECT TOP 50 _Char.CharName16 as Char_Name, CASE WHEN _Guild.ID = 0 THEN '<No Guild>' ELSE _Guild.Name END AS Guild, DynamicRank.Point as Point, RefObjID as RefObjID, JobType as JobType FROM
SRO_VT_SHARD.dbo._Char
INNER JOIN SRO_VT_SHARD.dbo._Guild ON _Char.GuildID = _Guild.ID
INNER JOIN SRO_VT_SHARD.dbo._CharTrijob ON _CharTrijob.CharID = _Char.CharID
INNER JOIN MaxiGuard_User.._DynamicRankJob_Trader DynamicRank ON DynamicRank.CharID=_Char.CharID
WHERE _CharTrijob.JobType=1
ORDER BY DynamicRank.Point DESC False 0 True True
33 Hunter Rank SELECT TOP 50 _Char.CharName16 as Char_Name, CASE WHEN _Guild.ID = 0 THEN '<No Guild>' ELSE _Guild.Name END AS Guild, DynamicRank.Point as Point, RefObjID as RefObjID, JobType as JobType FROM
SRO_VT_SHARD.dbo._Char
INNER JOIN SRO_VT_SHARD.dbo._Guild ON _Char.GuildID = _Guild.ID
INNER JOIN SRO_VT_SHARD.dbo._CharTrijob ON _CharTrijob.CharID = _Char.CharID
INNER JOIN MaxiGuard_User.._DynamicRankJob_Hunter DynamicRank ON DynamicRank.CharID=_Char.CharID
WHERE _CharTrijob.JobType=3
ORDER BY DynamicRank.Point DESC False 0 True True
34 Thief Rank SELECT TOP 50 _Char.CharName16 as Char_Name, CASE WHEN _Guild.ID = 0 THEN '<No Guild>' ELSE _Guild.Name END AS Guild, DynamicRank.Point as Point, RefObjID as RefObjID, JobType as JobType FROM
SRO_VT_SHARD.dbo._Char
INNER JOIN SRO_VT_SHARD.dbo._Guild ON _Char.GuildID = _Guild.ID
INNER JOIN SRO_VT_SHARD.dbo._CharTrijob ON _CharTrijob.CharID = _Char.CharID
INNER JOIN MaxiGuard_User.._DynamicRankJob_Thief DynamicRank ON DynamicRank.CharID=_Char.CharID
WHERE _CharTrijob.JobType=2
ORDER BY DynamicRank.Point DESC True 0 True True
35 Honor Rank SELECT TOP 50 _Char.CharName16 as Char_Name, CASE WHEN _Guild.ID = 0 THEN '<No Guild>' ELSE _Guild.Name END AS Guild, _TrainingCampMember.HonorPoint as Point, _Char.RefObjID as RefObjID FROM
SRO_VT_SHARD.dbo._Char
INNER JOIN SRO_VT_SHARD.dbo._Guild ON _Char.GuildID = _Guild.ID
INNER JOIN SRO_VT_SHARD.._TrainingCampMember ON _Char.CharID=_TrainingCampMember.CharID
ORDER BY _TrainingCampMember.HonorPoint DESC True chardata True False
[/CODE][/REPLYANDTHANKS]
