Projeto nao será receberá mais updates

Code: [Select]

16:21 - 31/05/2023
Olá, estou com um projeto pronto para ser upado, em breve irei postar
acessem: https://newtin.online/

Imagenes: https://imgur.com/a/yLLoi6A

Se não me engano, essa query resolve um problema no vencimento do VIP:

-----------------------------------------------------------------------------
Use MuOnline

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,@CurrentAccountExpireDate=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
GO


SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO

-------------------------------------------------------------------

Próximo Update #2

gameserver ta com erro e nao abre , poderia corrigir?

spam?

????????????????