MuEMU 8.3 VIP Auto Expiration

Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    Member djguncha is offline
    MemberRank
    Jun 2009 Join Date
    26Posts

    MuEMU 8.3 VIP Auto Expiration


    RaGEZONE Recommends

    RaGEZONE Recommends




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

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


  2. #2

    Re: MuEMU 8.3 VIP Auto Expiration

    Quote Originally Posted by djguncha View Post



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

    he does not create the database .[dbo].[WZ_GetAccountLevel]
    Tx Mate :D

  3. #3

    Re: MuEMU 8.3 VIP Auto Expiration

    can you post the whole code in text format too?

  4. #4
    Member mcmarilag is offline
    MemberRank
    Sep 2015 Join Date
    Dubai, UAELocation
    30Posts

    Re: MuEMU 8.3 VIP Auto Expiration

    Quote Originally Posted by KarLi View Post
    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]
     @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

  5. #5
    Ultimate Member basiak is offline
    MemberRank
    Jun 2014 Join Date
    182Posts

    Re: MuEMU 8.3 VIP Auto Expiration

    work for season 6.3 too :D thanks

  6. #6
    Account Upgraded | Title Enabled! generalhbk is offline
    True MemberRank
    Aug 2012 Join Date
    207Posts

    Re: MuEMU 8.3 VIP Auto Expiration

    Quote Originally Posted by mcmarilag View Post
    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
    can you post a query for vip?

    *porn link removed*

  7. #7
    Hardcore Member diegah is offline
    MemberRank
    Jun 2016 Join Date
    121Posts

    Re: MuEMU 8.3 VIP Auto Expiration

    Code:
    To add VIP to the account, send to MuOnline database following query:
    
     UPDATE MEMB_INFO SET AccountLevel = 1, AccountExpireDate = GETDATE() + 30 WHERE memb___id = 'LOGIN'
    
     LEGEND:
     1 - Account Level (AL0, AL1, AL2, AL3)
    30 - VIP Days
    LOGIN - Account Login



    Here you are!

  8. #8
    Account Upgraded | Title Enabled! generalhbk is offline
    True MemberRank
    Aug 2012 Join Date
    207Posts

    Re: MuEMU 8.3 VIP Auto Expiration

    Quote Originally Posted by diegah View Post
    Code:
    To add VIP to the account, send to MuOnline database following query:
    
     UPDATE MEMB_INFO SET AccountLevel = 1, AccountExpireDate = GETDATE() + 30 WHERE memb___id = 'LOGIN'
    
     LEGEND:
     1 - Account Level (AL0, AL1, AL2, AL3)
    30 - VIP Days
    LOGIN - Account Login



    Here you are!
    Thanks very much bro @diegah (y)

    *porn link removed*

  9. #9
    Registered Rupper is offline
    MemberRank
    Mar 2009 Join Date
    8Posts

    Re: MuEMU 8.3 VIP Auto Expiration

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

  10. #10
    Hardcore Member cover is offline
    MemberRank
    Jun 2016 Join Date
    146Posts

    Re: MuEMU 8.3 VIP Auto Expiration

    Quote Originally Posted by djguncha View Post




    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

  11. #11
    Member ajmeireles is offline
    MemberRank
    Feb 2016 Join Date
    56Posts

    Re: MuEMU 8.3 VIP Auto Expiration

    Quote Originally Posted by Rupper View Post
    have somebody procedure for Auto expire BAN (Auto Unban)?
    Use the same accountexpirate code as a base to creat this.

  12. #12
    Member spacein is offline
    MemberRank
    Nov 2017 Join Date
    31Posts

    Re: MuEMU 8.3 VIP Auto Expiration

    Quote Originally Posted by generalhbk View Post
    Thanks very much bro @diegah (y)


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

  13. #13
    Account Upgraded | Title Enabled! seedmaker is offline
    True MemberRank
    Feb 2017 Join Date
    127.0.0.1Location
    399Posts

    Re: MuEMU 8.3 VIP Auto Expiration

    Quote Originally Posted by spacein View Post
    any tutorial on how to put that code thanks my used season 6 epi 3
    Run them in new Query :v

  14. #14
    Member spacein is offline
    MemberRank
    Nov 2017 Join Date
    31Posts

    Re: MuEMU 8.3 VIP Auto Expiration

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

  15. #15
    Account Upgraded | Title Enabled! seedmaker is offline
    True MemberRank
    Feb 2017 Join Date
    127.0.0.1Location
    399Posts

    Re: MuEMU 8.3 VIP Auto Expiration

    any season ithink :D




Page 1 of 2 12 LastLast

Advertisement