View Full Version : |Pedido| Ranking PK/HERO
mixisco
03/01/2017, 06:36 PM
Alguém pode disponibilizar um ranking de PK/hero 100% funcional , testei todos disponibilizados na net , mais não estão 100% , ranking hero contabiliza apenas até 3, pode se acumulativo ou , diário , semanal e mensal , obrigado.
russo1
04/01/2017, 08:49 PM
amigo, teste esse, o PK sei que conta certinho, mas o HERO não sei
USE [MuOnline]
GO
ALTER TABLE dbo.Character ADD PkCountWeb int NOT NULL DEFAULT 0
GO
ALTER TABLE dbo.Character ADD PkCountWebHero int NOT NULL DEFAULT 0
GO
CREATE TRIGGER [dbo].[RankingHeroPK]
ON [dbo].[Character]
after update
as
IF UPDATE(pkcount)
begin SET NOCOUNT ON;
Update [Character] set [Character].PkCountWebHero=PkCountWebHero+1, pkcount=0
Where [Character].accountid=(SELECT accountid FROM Inserted)
and [Character].name=(SELECT name FROM Inserted) and [character].pkcount < 0
end
IF UPDATE(pkcount)
begin SET NOCOUNT ON;
Update [Character] set [Character].PkCountWeb=PkCountWeb+1, pkcount=0
Where [Character].accountid=(SELECT accountid FROM Inserted)
and [Character].name=(SELECT name FROM Inserted) and [character].pkcount > 0
end
mixisco
04/01/2017, 09:42 PM
amigo, teste esse, o PK sei que conta certinho, mas o HERO não sei
USE [MuOnline]
GO
ALTER TABLE dbo.Character ADD PkCountWeb int NOT NULL DEFAULT 0
GO
ALTER TABLE dbo.Character ADD PkCountWebHero int NOT NULL DEFAULT 0
GO
CREATE TRIGGER [dbo].[RankingHeroPK]
ON [dbo].[Character]
after update
as
IF UPDATE(pkcount)
begin SET NOCOUNT ON;
Update [Character] set [Character].PkCountWebHero=PkCountWebHero+1, pkcount=0
Where [Character].accountid=(SELECT accountid FROM Inserted)
and [Character].name=(SELECT name FROM Inserted) and [character].pkcount < 0
end
IF UPDATE(pkcount)
begin SET NOCOUNT ON;
Update [Character] set [Character].PkCountWeb=PkCountWeb+1, pkcount=0
Where [Character].accountid=(SELECT accountid FROM Inserted)
and [Character].name=(SELECT name FROM Inserted) and [character].pkcount > 0
end
Infelizmente não funcionou da maneira correta , para pontuar o player precisa ficar relogando , tipo se o cara matar 50pks sem relogar , quando ele relogar vai pontuar apenas 1 ponto , mais agradeço por tentar ajudar , obrigado russo1
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.