Community AlphaAlpha MUADMINS
ENEnglish
Sign in
On MuADMINSConfig ScannerDrop your files zip: rates, drops, spots, limitsOpenOn MuADMINSMeet us on DiscordAsk for help, share what you are building and talk MU with other server owners.Open
← All solutions
Server setupS2, S6, S16, S17, S18, S20

How do I give VIP (AccountLevel) to an account with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files?

Written by MuADMINS from the sourceNot verified

In MuEmu based files VIP is MEMB_INFO.AccountLevel (0 = normal, the AL1 / AL2 / AL3 levels of your configs) with MEMB_INFO.AccountExpireDate.

Use the shipped procedure, account offline:

EXEC WZ_SetAccountLevel 'account1', 1, 2592000;
SELECT memb___id, AccountLevel, AccountExpireDate FROM MEMB_INFO WHERE memb___id = 'account1';

WZ_SetAccountLevel @Account, @AccountLevel, @AccountExpireTime takes the time in SECONDS (2592000 = 30 days). Same level: the seconds are added to the current end date. Another level: the new level starts now.

WZ_GetAccountLevel @Account (called at login) puts AccountLevel back to 0 when GETDATE() is past AccountExpireDate, so a VIP set with a past date disappears at the next login.

Found in: Louis Season 6 V13 and Update 27 backups, MSPro V14 backup, X-Team S2 / S17 and MuDevs S18 / S20 scripts. WebEngine xteam.tables.php reads the same columns (_TBL_VIP_ = MEMB_INFO, AccountLevel, AccountExpireDate).

Source: X-Team S17 DB/MuOnline.sql (WZ_GetAccountLevel, WZ_SetAccountLevel), procedure lists of the Louis and MSPro backups, WebEngine 1.2.7 includes/config/xteam.tables.php.

Written by MuADMINS
Did this help?

Still stuck? Search MuGPS Ask the MU Assistant

MuADMINS Community Alpha: free and community made, in active development.