MuEMU 8.3 VIP Auto Expiration

[djguncha]

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

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

 

[lifekko17]

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

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

Tx Mate

 

[KarLi]

can you post the whole code in text format too?

 

[mcmarilag]

can you post the whole code in text format too?

here:

USE [MuOnline]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

ALTER Procedure [dbo].[WZ_GetAccountLevel]
 [USER=162874]account[/USER] 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 = [USER=162874]account[/USER]

IF (@CurrentAccountLevel <> 0 AND GETDATE() > @CurrentAccountExpireDate)
BEGIN
	SET @CurrentAccountLevel = 0
	UPDATE MEMB_INFO SET AccountLevel = @CurrentAccountLevel, AccountExpireDate = @CurrentAccountExpireDate WHERE memb___id = [USER=162874]account[/USER]
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

 

[basiak]

work for season 6.3 too thanks

 

[generalhbk]

here:

USE [MuOnline]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

ALTER Procedure [dbo].[WZ_GetAccountLevel]
 [USER=162874]account[/USER] 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 = [USER=162874]account[/USER]

IF (@CurrentAccountLevel <> 0 AND GETDATE() > @CurrentAccountExpireDate)
BEGIN
	SET @CurrentAccountLevel = 0
	UPDATE MEMB_INFO SET AccountLevel = @CurrentAccountLevel, AccountExpireDate = @CurrentAccountExpireDate WHERE memb___id = [USER=162874]account[/USER]
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

can you post a query for vip?

 

[diegah]

[h=3]

To add VIP to the account, send to MuOnline database following query:

 UPDATE MEMB_INFO SET AccountLevel = [COLOR=red]1[/COLOR], AccountExpireDate = GETDATE() + [COLOR=red]30[/COLOR] WHERE memb___id = '[COLOR=red]LOGIN[/COLOR]'

 LEGEND:
 [COLOR=red]1[/COLOR] - Account Level (AL0, AL1, AL2, AL3)
[COLOR=red]30[/COLOR] - VIP Days
[COLOR=red]LOGIN[/COLOR] - Account Login[/COLOR][/SIZE][SIZE=1][COLOR=black][SIZE=1][COLOR=black][SIZE=1][COLOR=black]

[/h]
Here you are!
[/COLOR][/SIZE][/COLOR][/SIZE]

 

[generalhbk]

[h=3]

To add VIP to the account, send to MuOnline database following query:

 UPDATE MEMB_INFO SET AccountLevel = [COLOR=red]1[/COLOR], AccountExpireDate = GETDATE() + [COLOR=red]30[/COLOR] WHERE memb___id = '[COLOR=red]LOGIN[/COLOR]'

 LEGEND:
 [COLOR=red]1[/COLOR] - Account Level (AL0, AL1, AL2, AL3)
[COLOR=red]30[/COLOR] - VIP Days
[COLOR=red]LOGIN[/COLOR] - Account Login[/COLOR][/SIZE][SIZE=1][COLOR=black][SIZE=1][COLOR=black][SIZE=1][COLOR=black]

[/h]
Here you are!
[/COLOR][/SIZE][/COLOR][/SIZE]

Thanks very much bro diegah

 

[Rupper]

have somebody procedure for Auto expire BAN (Auto Unban)?

 

[cover]

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

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

how to create .[dbo].[WZ_GetAccountLevel] in data base

 

[ajmeireles]

have somebody procedure for Auto expire BAN (Auto Unban)?

Use the same accountexpirate code as a base to creat this.

 

[spacein]

Thanks very much bro @diegah

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

 

[seedmaker]

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

Run them in new Query :v

 

[spacein]

thanks but this code is for season 8 i thought in season 6

 

[seedmaker]

any season ithink

 

[spacein]

any season ithink

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

 

[allexander]

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

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

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

 

[generalhbk]

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

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

 

[pelin4eto]

here:

USE [MuOnline]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

ALTER Procedure [dbo].[WZ_GetAccountLevel]
 @[I][B][URL="http://forum.ragezone.com/members/162874.html"]account[/URL][/B][/I] 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 = @[I][B][URL="http://forum.ragezone.com/members/162874.html"]account[/URL][/B][/I]

IF (@CurrentAccountLevel <> 0 AND GETDATE() > @CurrentAccountExpireDate)
BEGIN
    SET @CurrentAccountLevel = 0
    UPDATE MEMB_INFO SET AccountLevel = @CurrentAccountLevel, AccountExpireDate = @CurrentAccountExpireDate WHERE memb___id = @[I][B][URL="http://forum.ragezone.com/members/162874.html"]account[/URL][/B][/I]
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!

 

[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