Como ativar a contagem dos tops reset do MuSite.
Basta rodar essa query no SQL.
USE [MuOnline]
GO
CREATE TRIGGER [dbo].[Rankings]
ON [dbo].[Character]
after update
as
IF UPDATE(ResetCount)
begin SET NOCOUNT ON;
Update [Character] set [Character].resetsDay=resetsDay+1,resetsWeek=resetsWeek+1 ,resetsMonth=resetsMonth+1
Where [Character].name=(SELECT name FROM Inserted)
end
GO
CREATE TRIGGER [dbo].[Rankings]
ON [dbo].[Character]
after update
as
IF UPDATE(ResetCount)
begin SET NOCOUNT ON;
Update [Character] set [Character].resetsDay=resetsDay+1,resetsWeek=resetsWeek+1 ,resetsMonth=resetsMonth+1
Where [Character].name=(SELECT name FROM Inserted)
end
Lembre-se que os rankings no site atualizam a cada 15 minutos.