Community AlphaAlpha MUADMINS
RORomână
Autentificare
Pe MuADMINSConfig ScannerÎncarcă zip-ul fișierelor tale: rate-uri, drop-uri, spoturi, limiteDeschidePe MuADMINSÎntâlnește-ne pe DiscordCere ajutor, arată la ce lucrezi și vorbește despre MU cu alți proprietari de servere.Deschide
← Toate soluțiile

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

Scris de MuADMINS pe baza surseiNot 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.

Scris de MuADMINS
Te-a ajutat?

Tot nu merge? Caută în MuGPS Întreabă Asistentul MU

MuADMINS Community Alpha: gratuit, făcut de comunitate, în dezvoltare activă.