Hola quiero modificar mi procedimiento para generar "score" en la columna de ScoreDay para que pueda crear ranking de blood castle diaria, semanal y mensual

Hello I want to modify my procedure to generate "score" in the column scoreday so that I can create daily, weekly and monthly blood castle ranking

Olá quero modificar minha procedure para gerar "score" na coluna scoreday para que eu possa criar ranking blood castle diario,semanal e mensal

USE [MuOnline]
GO
/****** Object:  StoredProcedure [dbo].[WZ_RankingBloodCastle]    Script Date: 27/03/2018 04:15:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[WZ_RankingBloodCastle]
@Account varchar(10),
@Name varchar(10),
@Score int
AS
BEGIN

SET NOCOUNT ON
SET XACT_ABORT ON

IF NOT EXISTS (SELECT Name FROM RankingBloodCastle WHERE Name=@Name)
BEGIN

   INSERT INTO RankingBloodCastle (Name,Score) VALUES (@Name,@Score)

END
ELSE
BEGIN

   UPDATE RankingBloodCastle SET Score=Score+@Score WHERE Name=@Name

END

SET NOCOUNT OFF
SET XACT_ABORT OFF

END

Hola quiero modificar mi procedimiento para generar "score" en la columna de ScoreDay para que pueda crear ranking de blood castle diaria, semanal y mensual

Hello I want to modify my procedure to generate "score" in the column scoreday so that I can create daily, weekly and monthly blood castle ranking

Olá quero modificar minha procedure para gerar "score" na coluna scoreday para que eu possa criar ranking blood castle diario,semanal e mensal

USE [MuOnline]
GO
/****** Object:  StoredProcedure [dbo].[WZ_RankingBloodCastle]    Script Date: 27/03/2018 04:15:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[WZ_RankingBloodCastle]
@Account varchar(10),
@Name varchar(10),
@Score int
AS
BEGIN

SET NOCOUNT ON
SET XACT_ABORT ON

IF NOT EXISTS (SELECT Name FROM RankingBloodCastle WHERE Name=@Name)
BEGIN

   INSERT INTO RankingBloodCastle (Name,Score) VALUES (@Name,@Score)

END
ELSE
BEGIN

   UPDATE RankingBloodCastle SET Score=Score+@Score WHERE Name=@Name

END

SET NOCOUNT OFF
SET XACT_ABORT OFF

END

Configurar Blood Castle y Chaos Castle

Started by Angel Olano General

Blood Castle no tira puente y Chaos castle al querer ingresar te saca

Started by basthialbo Soporte / Ayudas

Como edito blood castle y chaos castle

Started by winston Soporte / Ayudas

problemas en los eventos blood castle , chaos castle y devil. Files Muemu s6

Started by joselagos Soporte / Ayudas

Blood Castle

Started by nelson Soporte / Ayudas