Problema de Vip Web Ferrarezi

Bom Dia , Boa Tarde , Booa Noite

Eu queria uma ajuda de vocês hoje eu deparei com o server do meo amigo , ate o Meo nao ta retirando o vip e nem a data ta ficando certo

Vai a Procedures que eu tenho Para Da Vip .

1 - Nao sei se essa ea Certa.

USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_SetAccountLevel] Script Date: 11/19/2017 15:17:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[WZ_SetAccountLevel] @[Only registered and activated users can see links. Click Here To Register...] varchar(10), @[Only registered and activated users can see links. Click Here To Register...]Level int, @[Only registered and activated users can see links. Click Here To Register...]ExpireTime int
AS
BEGIN

SET NOCOUNT ON
SET XACT_ABORT ON

DECLARE @CurrentAccountLevel int
DECLARE @CurrentAccountExpireDate smalldatetime

SELECT @CurrentAccountLevel=AccountLevel,@CurrentAccountE xpireDate=AccountExpireDate FROM MEMB_INFO WHERE memb___id @[Only registered and activated users can see links. Click Here To Register...]

IF(@CurrentAccountLevel = @[Only registered and activated users can see links. Click Here To Register...]Level)
BEGIN
SET @CurrentAccountLevel = @CurrentAccountLevel

SET @CurrentAccountExpireDate = DATEADD(second @[Only registered and activated users can see links. Click Here To Register...]ExpireTime,@CurrentAccountExpireDate)
END
ELSE
BEGIN
SET @CurrentAccountLevel = @[Only registered and activated users can see links. Click Here To Register...]Level

SET @CurrentAccountExpireDate = DATEADD(second @[Only registered and activated users can see links. Click Here To Register...]ExpireTime,getdate())
END

UPDATE MEMB_INFO SET AccountLevel=@CurrentAccountLevel,AccountExpireDat e=@CurrentAccountExpireDate WHERE memb___id @[Only registered and activated users can see links. Click Here To Register...]

SET NOCOUNT OFF
SET XACT_ABORT OFF

END
[Only registered and activated users can see links. Click Here To Register...]Screenshot_11.png (3.2 KiB) Exibido 6 vezes
Entao Galera Nois esta usando essa tabela - modi_days
Nao sei se essa ea exata ou a exta e - AccountExpireDate

Alguem pode me ajuda ? Obrigado deiz jah.



Agora Prestei Atenção ten essa tbm la.

USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_GetAccountLevel] Script Date: 11/19/2017 15:50:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[WZ_GetAccountLevel]
[FONT=&quot @[Only registered and activated users can see links. Click Here To Register...] varchar(10)[/FONT]
AS
BEGIN

SET NOCOUNT ON
SET XACT_ABORT ON

SELECT AccountLevel As AccountLevel,AccountExpireDate As AccountExpireDate FROM MEMB_INFO WHERE memb___id @[Only registered and activated users can see links. Click Here To Register...]

SET NOCOUNT OFF
SET XACT_ABORT OFF

END

se voce estiver usando o Season 6 da x-team ou muemu ou do Louis é AccountExpireDate

Tem que refazer essas procedures.

@[Only registered and activated users can see links. Click Here To Register...] se nao tem pra aruma pra nois ai por favoor :d tamos no aperto akie

1 45 minutes:------- Atualizado -------

Problema Resolvido .
Procedures Feita Por - @[Only registered and activated users can see links. Click Here To Register...]

USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_GetAccountLevel] Script Date: 18/12/2016 20:10:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER Procedure [dbo].[WZ_GetAccountLevel]
@Account varchar(10)
AS
BEGIN

SET NOCOUNT ON
SET XACT_ABORT ON

DECLARE @CurrentAccountLevel int
DECLARE @CurrentAccountExpireDate smalldatetime

SELECT @CurrentAccountLevel=AccountLevel,@CurrentAccountE xpireDate=AccountExpireDate FROM MEMB_INFO WHERE memb___id=@Account

IF(@CurrentAccountLevel <> 0 AND getdate() > @CurrentAccountExpireDate)
BEGIN
SET @CurrentAccountLevel = 0

UPDATE MEMB_INFO SET AccountLevel=@CurrentAccountLevel,AccountExpireDate=@CurrentAccountExpireDate WHERE memb___id=@Account
END

SELECT @CurrentAccountLevel As AccountLevel,@CurrentAccountExpireDate As AccountExpireDate

SET NOCOUNT OFF
SET XACT_ABORT OFF

END