Community AlphaAlpha MUADMINS
ITItaliano
Accedi
Su MuADMINSConfig ScannerCarica lo zip dei tuoi file: rates, drop, spot, limitiApriSu MuADMINSIncontraci su DiscordChiedi aiuto, condividi quello che stai creando e parla di MU con altri proprietari di server.Apri
← Tutte le soluzioni

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

Scritto da MuADMINS a partire dalla 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.

Scritto da MuADMINS
Ti è stato utile?

Non hai ancora risolto? Cerca su MuGPS Chiedi all'Assistente MU

MuADMINS Community Alpha: gratuito, fatto dalla community, in sviluppo attivo.