Community AlphaAlpha MUADMINS
ESEspañol
Iniciar sesión
En MuADMINSConfig ScannerSube el zip de tus archivos: rates, drops, spots, límitesAbrirEn MuADMINSEncuéntranos en DiscordPide ayuda, comparte lo que estás creando y habla de MU con otros dueños de servidores.Abrir
← Todas las soluciones
Instalación del servidorS2, 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?

Escrito por MuADMINS a partir de la fuenteNot 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.

Escrito por MuADMINS
¿Te sirvió?

¿Sigues atascado? Buscar en MuGPS Pregúntale al Asistente MU

MuADMINS Community Alpha: gratis, hecho por la comunidad y en desarrollo activo.