Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

MuEMU 8.3 VIP Auto Expiration

Initiate Mage
Joined
Jun 16, 2009
Messages
23
Reaction score
0
djguncha - MuEMU  8.3 VIP Auto Expiration - RaGEZONE Forums



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

he does not create the database .[dbo].[WZ_GetAccountLevel]
 
Initiate Mage
Joined
Sep 8, 2015
Messages
26
Reaction score
4
can you post the whole code in text format too?

here:

Code:
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
 
Experienced Elementalist
Joined
Jun 13, 2014
Messages
272
Reaction score
21
work for season 6.3 too :D thanks
 
Junior Spellweaver
Joined
Aug 26, 2012
Messages
197
Reaction score
19
here:

Code:
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?
 
Skilled Illusionist
Joined
Jun 29, 2016
Messages
341
Reaction score
14
[h=3]
Code:
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]
 
Junior Spellweaver
Joined
Aug 26, 2012
Messages
197
Reaction score
19
[h=3]
Code:
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 (y)
 
Initiate Mage
Joined
Mar 23, 2009
Messages
6
Reaction score
0
have somebody procedure for Auto expire BAN (Auto Unban)?
 
Skilled Illusionist
Joined
Jun 9, 2016
Messages
324
Reaction score
20
djguncha - MuEMU  8.3 VIP Auto Expiration - RaGEZONE Forums




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
 
Initiate Mage
Joined
Nov 14, 2017
Messages
93
Reaction score
3
thanks but this code is for season 8 i thought in season 6
 
Joined
Jan 20, 2013
Messages
49
Reaction score
7
here:

Code:
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!
 
Last edited:
Experienced Elementalist
Joined
Jun 13, 2014
Messages
272
Reaction score
21
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 :
 
Back
Top