info to fix savebotreport from DailyServer.BOTReportedRanking
SQL:
DECLARE @t_BotReported TABLE (
idx INT IDENTITY,
world_id INT,
char_name NVARCHAR(100),
account_name NVARCHAR(100),
level INT,
total_reported_count INT
)
INSERT INTO @t_BotReported (world_id, char_name, account_name, level, total_reported_count)
SELECT TOP 100 world_id, char_name, account_name, MAX(level), SUM(reported_count) total_reported_count
FROM RPLD_BOTReported (NOLOCK)
WHERE log_date>=@fromDate AND log_date<=@toDate AND world_id=@worldId
GROUP BY world_id, char_name, account_name
ORDER BY SUM(reported_count) DESC
SELECT * FROM @t_BotReported