[Share] SQL Queries to monitor In-Game Statistics

[iWareZ]

A simple share for those owners that are not familiar with SQL Query yet.
I know this is just a simple thing, would just like to help the community.

All queries below are Juver based database.

Feel free to comment if you have any request regarding sql query.

-- Get Total Online Players
SELECT count(*)
FROM RanGame1.dbo.ChaInfo
WHERE ChaOnline = 1

-- List all online players players, sorted by level and character name
SELECT ChaName, ChaLevel
FROM RanGame1.dbo.ChaInfo
WHERE ChaOnline = 1
ORDER BY ChaLevel, ChaName

-- Check Top 100 Characters sorted by Activity Points
SELECT TOP 100 ChaName, ChaActivityPoint
FROM RanGame1.dbo.ChaInfo
ORDER BY ChaActivityPoint desc

-- Check Top 100 Characters sorted by Contribution Points
SELECT TOP 100 ChaName, ChaContributionPoint
FROM RanGame1.dbo.ChaInfo
ORDER BY ChaContributionPoint desc

-- Check Top 100 Characters sorted by  Gold
SELECT TOP 100 ChaName, ChaMoney
FROM RanGame1.dbo.ChaInfo
ORDER BY ChaMoney desc

-- Check Top 100 Character sorted by PK Score
SELECT TOP 100 ChaName, ChaPKScore
FROM RanGame1.dbo.ChaInfo
ORDER BY ChaPKScore desc

-- Check Top 100 Character sorted by PK Death
SELECT TOP 100 ChaName, ChaPKDeath
FROM RanGame1.dbo.ChaInfo
ORDER BY ChaPKDeath desc

-- Check Top 100 Character sorted by CW Score
SELECT TOP 100 ChaName, ChaCWKill
FROM RanGame1.dbo.ChaInfo
ORDER BY ChaCWKill desc

-- Check Top 100 Character sorted by CW Death
SELECT TOP 100 ChaName, ChaCWDeath
FROM RanGame1.dbo.ChaInfo
ORDER BY ChaCWDeath desc