Community AlphaAlpha MUADMINS
PLPolski
Zaloguj się
Na MuADMINSConfig ScannerWgraj zip swoich plików: rates, dropy, spoty, limityOtwórzNa MuADMINSSpotkajmy się na DiscordziePoproś o pomoc, pokaż, nad czym pracujesz, i rozmawiaj o MU z innymi właścicielami serwerów.Otwórz
← Wszystkie rozwiązania

How do I ban and unban accounts or characters with an end date on Louis / MuEmu Season 6 files (bloc_code, CtlCode, Bloc_Expire)?

Napisane przez MuADMINS na podstawie źródłaNot verified

Louis Season 6 Update 11 added the ban columns: MEMB_INFO.Bloc_Expire and Character.Bloc_Expire (smalldatetime). The procedure WZ_DesblocAccount @Account lifts a block only when it expired:

  • MEMB_INFO: bloc_code 1 -> 0 when bloc_expire < GETDATE()
  • Character: CtlCode 1 -> 0 when bloc_expire < GETDATE()

So bloc_code 1 = blocked account and CtlCode 1 = blocked character.

Ban (player offline):

UPDATE MEMB_INFO SET bloc_code = 1, Bloc_Expire = DATEADD(day, 7, GETDATE()) WHERE memb___id = 'account1';
UPDATE Character SET CtlCode = 1, Bloc_Expire = DATEADD(day, 7, GETDATE()) WHERE Name = 'CharName';

Lift expired blocks of one account:

EXEC WZ_DesblocAccount 'account1';

Unban now:

UPDATE MEMB_INFO SET bloc_code = 0 WHERE memb___id = 'account1' AND bloc_code = 1;

If you get "Invalid column name 'Bloc_Expire'", the Update 11 script "Ban columns.sql" was never run on this database.

Source: Louis (JogandoMU) Season 6 Update 27 SQL folder: "Update11 - Ban columns.sql", "Update11 - Procedure WZ_DesblocAccount.sql"; the procedure is also in the MSPro V14 and S6 ZG backups.

Napisane przez MuADMINS
Czy to pomogło?

Nadal masz problem? Szukaj w MuGPS Zapytaj Asystenta MU

MuADMINS Community Alpha: za darmo, tworzone przez społeczność, w aktywnym rozwoju.