Community AlphaAlpha MUADMINS
PTPortuguês (Brasil)
Entrar
No MuADMINSConfig ScannerEnvie o zip dos seus arquivos: rates, drops, spots, limitesAbrirNo MuADMINSEncontre-nos no DiscordPeça ajuda, mostre o que está criando e converse sobre MU com outros donos de servidores.Abrir
← Todas as soluções

Players show online on the website after the server closed, or accounts stay "online" (MEMB_STAT.ConnectStat stuck at 1)

Escrita pelo MuADMINS a partir da fonteNot verified

How it works in every MSSQL files family we read (IGCN, MuEmu, Louis, MSPro, X-Team, MuDevs, WebZen): at login the server runs WZ_CONNECT_MEMB, which inserts or updates MEMB_STAT with ConnectStat = 1; at logout it runs WZ_DISCONNECT_MEMB, which sets ConnectStat = 0 and DisConnectTM. If the server crashes or is killed, WZ_DISCONNECT_MEMB never runs and ConnectStat stays 1. Websites count online players from this column, and WebEngine refuses credit changes while it says online.

Fix, only with ALL servers closed (JoinServer, DataServer, GameServers):

SELECT memb___id, ConnectStat, ServerName, ConnectTM, DisConnectTM FROM MEMB_STAT WHERE ConnectStat = 1;
UPDATE MEMB_STAT SET ConnectStat = 0 WHERE ConnectStat = 1;

Do not run it while the server is on: real players would show offline.

Also check:

  • DmN CMS replaces WZ_DISCONNECT_MEMB with a version that first writes [web database].dbo.DmN_OnlineCheck; if that database or table is missing, or the SQL user cannot write there, the procedure errors and ConnectStat is never reset.
  • IGCN IGCDS.ini has MembStatSync (shipped 0) with the comment "Gives ability to disconnect account from website by setting MEMB_STAT.ConnectStat".
  • MSPro JoinServer.ini has DisconnectOnlineAccount = 0.

Source: WZ_CONNECT_MEMB / WZ_DISCONNECT_MEMB in IGCN S17 (MuOnline and Me_MuOnline), X-Team S17, MuDevs S18 scripts and the 97d backup; DmN CMS 1.2.3 required_stored_procedures[20.05.2015].json; IGCN S16 IGCDS.ini; MSPro V14 JoinServer.ini; WebEngine 1.2.7 class.credits.php.

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.