MuEMU 8.3 VIP Auto Expiration

Quote:

---

Originally Posted by seedmaker

any season ithink :D

---

really =) bro you have a vid tutorial please i am new please help me =)

Quote:

---

Originally Posted by spacein

really =) bro you have a vid tutorial please i am new please help me =)

---

Here with photos :D fallow the steps add the code execute and done

https://www.serverintellect.com/support/sqlserver/sql-query/

Quote:

---

Originally Posted by spacein

any tutorial on how to put that code thanks my used season 6 epi 3

---

just open your sql and make a query :D then copy paste and execute :) :P that's it :D ^_^

Quote:

---

Originally Posted by mcmarilag

here:

Code:

---

USE [MuOnline]
GO

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

---

---

need me raking for all vip users and date expire in ranking >?
or php file for buy vip for 30 days
info:
MEMB_INFO
memb___id
AccountLevel
AccountExpireDate

I can not handle it I've tried.. I tried!

anyone know why it doesn't create me the [WZ_GetAccountLevel] ??? it tells me that command(s) completed successfully but it doesn't make any table.

image to understand better :
https://imgur.com/a/4NttA

Quote:

---

Originally Posted by basiak

anyone know why it doesn't create me the [WZ_GetAccountLevel] ??? it tells me that command(s) completed successfully but it doesn't make any table.

image to understand better :
https://imgur.com/a/4NttA

---

Its not a table man... its a procedure.

Quote:

---

Originally Posted by djguncha

https://i.imgsafe.org/15537368b9.png


To make VIP Account auto expire, edit stored procedure "WZ_GetAccountLevel" in database

he does not create the database .[dbo].[WZ_GetAccountLevel]

---

need me for my web site rankings php file