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

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

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

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.