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
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
BEGIN
UPDATE [dbo].[Character]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
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
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
BEGIN
UPDATE [dbo].[Character]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
END