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.