Vencimento VIP

Alguém poderia me explicar como faço pra por o vencimento do vip na web Ferrarezi?, consigo normalmente adicionar o vip, mas o vencimento não aparece.

[Only registered and activated users can see links. Click Here To Register...]

Pode ser a template que não está puxando a coluna vip que está configurado no site, revise a Template expecificamente a parte onde informa isso.

O Problema é que todas as templates do ferrarezi está com o mesmo erro, não mostra o vencimento.

@[Only registered and activated users can see links. Click Here To Register...]

Teste isso, só lembre de fazer um backup. Não lembro se está completa, tenho isso a muito tempo.

Código:

---

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


alter Procedure [dbo].[WZ_GetAccountLevel]
 @[Only registered and activated users can see links. Click Here To Register...] 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 @[Only registered and activated users can see links. Click Here To Register...]


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


UPDATE MEMB_INFO SET AccountLevel=@CurrentAccountLevel,AccountExpireDat e=@CurrentAccountExpireDate WHERE memb___id @[Only registered and activated users can see links. Click Here To Register...]
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

---

Citação:

---

Originally Posted by L.Henrique [Only registered and activated users can see links. Click Here To Register...]

@[Only registered and activated users can see links. Click Here To Register...]

Teste isso, só lembre de fazer um backup. Não lembro se está completa, tenho isso a muito tempo.

Código:

---

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


alter Procedure [dbo].[WZ_GetAccountLevel]
 @[Only registered and activated users can see links. Click Here To Register...] 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 @[Only registered and activated users can see links. Click Here To Register...]


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


UPDATE MEMB_INFO SET AccountLevel=@CurrentAccountLevel,AccountExpireDat e=@CurrentAccountExpireDate WHERE memb___id @[Only registered and activated users can see links. Click Here To Register...]
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

---

---

Opa Henrique, quando uso isso aí, aparece isso "Mensagem 137, Nível 15, Estado 2, Procedimento WZ_GetAccountLevel, Linha 17É necessário declarar a variável escalar "@CurrentAccountE".
Mensagem 102, Nível 15, Estado 1, Procedimento WZ_GetAccountLevel, Linha 25
Sintaxe incorreta próxima a 'e'."


Oq devo fazer ?

19 minutes:------- Atualizado -------

Henrique, usei esse aqui e foi

Código:

---

USE [MuOnline]
GO
/****** Object:  StoredProcedure [dbo].[WZ_GetAccountLevel]    Script Date: 03/20/2018 22:16:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[WZ_GetAccountLevel]  @[Only registered and activated users can see links. Click Here To Register...] 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 = @[Only registered and activated users can see links. Click Here To Register...]


IF (@CurrentAccountLevel <> 0 AND GETDATE() > @CurrentAccountExpireDate)
BEGIN
    SET @CurrentAccountLevel = 0
    UPDATE MEMB_INFO SET AccountLevel = @CurrentAccountLevel WHERE memb___id = @[Only registered and activated users can see links. Click Here To Register...]
END


SELECT @CurrentAccountLevel as AccountLevel, @CurrentAccountExpireDate as AccountExpireDate


SET NOCOUNT OFF
SET XACT_ABORT OFF


END

---

Mas continua do mesmo jeito! :/

Posta a sua LoginAjax2.tpl.php

Pasta Do seu Template/modules

Aqui está

Código:

---

<div class="logado">
   
    <strong>
        Olá, {name}!
    </strong><br />


    <a href="?c=UserPanel">
        [Painel de Usu&aacute;rio]
    </a><br /> <br />


    <a href="?c=Messages">
        Você tem<span style="color:#ff0">
            {messages}
        </span>aviso(s)
    </a>.<br /> <br />
   
        &nbsp;&nbsp;&nbsp; {vip_status}<br />
        &nbsp;&nbsp;&nbsp; {due_date}<br /> <br />
   
    <strong>
        Cr&eacute;dito:
    </strong>R${credits},00<br />


    <strong>
        Relikias:
    </strong>{Credit_3}<br />
   
    <strong>
        Eventos:
    </strong>{Credit_4}<br /> <br />
    <a href="localhost/index.php?logout">
        [Deslogar]
    </a>
</div>

---

@[Only registered and activated users can see links. Click Here To Register...] me passa seu skype via MP
que eu irei te ajudar a arrumar isso