Community AlphaAlpha MUADMINS
PTPortuguês (Brasil)
Entrar
No MuADMINSContribuirAjude e ganhe Community PointsAbrirNo MuADMINSHorários de eventosBlood Castle, Devil Square, invasões em uma grade semanalAbrir
← Todas as soluções

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

Escrita pelo MuADMINS a partir da fonteNot 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.

Escrito pelo MuADMINS
Isso ajudou?

Ainda com problema? Buscar no MuGPS Pergunte ao Assistente MU

MuADMINS Community Alpha: grátis, feito pela comunidade e em desenvolvimento ativo.