ranking online para web ferrarezi funcionar

[faber]

esse e um mine tutorial para os ranking da sua web pegar o rankings online e para funcionar a aba ranking do site.
rode a query.

1- USE MuOnline
ALTER TABLE Character ADD TempoOnline int DEFAULT (0)
2- DROP TRIGGER MembStat_RecordOnlineHours
3- CREATE TRIGGER [MembStat_RecordOnlineHours] ON dbo.MEMB_STAT
AFTER UPDATE
AS
declare @memb___id varchar(10)
declare @connectstat tinyint
SELECT @memb___id=memb___id,@connectstat=connectstat FROM INSERTED
IF (@connectstat = 0)
BEGIN
UPDATE [dbo].[Character]
SET TempoOnline = TempoOnline + datediff(minute, (SELECT ConnectTM FROM MEMB_STAT WHERE memb___id= @memb___id), getdate())
WHERE Name = (SELECT GameIDC FROM AccountCharacter WHERE Id=@memb___id)
END

[MuSoul]

Bom nao entendi a parte 2 e 3 se puder explicar melhor 😊 nao manjo muito de job e trigger

[xeonlaser2014]

rode isso primeiro

USE MuOnline
ALTER TABLE Character ADD TempoOnline int DEFAULT (0)

depois isso

DROP TRIGGER MembStat_RecordOnlineHours

e depois isso e pronto

CREATE TRIGGER [MembStat_RecordOnlineHours] ON dbo.MEMB_STAT
AFTER UPDATE
AS
declare @memb___id varchar(10)
declare @connectstat tinyint
SELECT @memb___id=memb___id,@connectstat=connectstat FROM INSERTED
IF (@connectstat = 0)
BEGIN
UPDATE [dbo].[Character]
SET TempoOnline = TempoOnline + datediff(minute, (SELECT ConnectTM FROM MEMB_STAT WHERE memb___id= @memb___id), getdate())
WHERE Name = (SELECT GameIDC FROM AccountCharacter WHERE Id=@memb___id)
END