Community AlphaAlpha MUADMINS
FILFilipino
Mag-sign in
Sa MuADMINSConfig ScannerI-upload ang zip ng mga file mo: rate, drop, spot, limitBuksanSa MuADMINSMakipagkita sa amin sa DiscordHumingi ng tulong, ibahagi ang ginagawa mo at makipag-usap tungkol sa MU sa ibang may-ari ng server.Buksan
← Lahat ng solusyon

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

Isinulat ng MuADMINS mula sa sourceNot 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.

Isinulat ng MuADMINS
Nakatulong ba ito?

Naipit pa rin? Maghanap sa MuGPS Magtanong sa MU Assistant

MuADMINS Community Alpha: libre, gawa ng komunidad, at patuloy na dine-develop.