Printable View
ola bom dia amigo eu queria pedir a ajuda de voces para que possa me ajudar resolver um probleminha simples q eu n to conseguindo resolver e o seguinte meu site do ferrarezi nao esta marcando pk e nem hero e nem pkday nem semanal e nem mensal alguem me ajuda por favor
Rode essa query para contar os tops..
Código:
ALTER TRIGGER [dbo].[Z_PK_HERO] ON [dbo].[Character]
AFTER UPDATE
AS
SET NOCOUNT ON
SET XACT_ABORT ON
DECLARE @rank int
DECLARE @[Only registered and activated users can see links. Click Here To Register...]or int
DECLARE @char varchar(10)
SELECT @[Only registered and activated users can see links. Click Here To Register...]or = PkCount FROM DELETED
SELECT @rank = PkCount, @char = Name FROM INSERTED
IF (@rank > 0) and (@rank > @[Only registered and activated users can see links. Click Here To Register...]or)
UPDATE [dbo].[Character]
SET Z_RankPK = Z_RankPK + (@rank @[Only registered and activated users can see links. Click Here To Register...]or),Z_RankPK_semanal = Z_RankPK_semanal + (@rank @[Only registered and activated users can see links. Click Here To Register...]or), Z_RankPK_mensal = Z_RankPK_mensal + (@rank @[Only registered and activated users can see links. Click Here To Register...]or)
WHERE Name = @char
ELSE
IF (@rank < 0) and (@rank < @[Only registered and activated users can see links. Click Here To Register...]or)
UPDATE [dbo].[Character]
SET Z_RankHR = Z_RankHR + @[Only registered and activated users can see links. Click Here To Register...]or-@rank), Z_RankHR_semanal = Z_RankHR_semanal + @[Only registered and activated users can see links. Click Here To Register...]or-@rank), Z_RankHR_mensal = Z_RankHR_mensal + @[Only registered and activated users can see links. Click Here To Register...]or-@rank)
WHERE Name = @char
SET NOCOUNT OFF
SET XACT_ABORT OFF