MuADMINS
Soluzioni
Fix brevi per i problemi comuni di server, client e siti web di MU Online, ognuno con la sua fonte e la sua data. “Confermato” significa che chi ha fatto la domanda ha detto che il fix ha funzionato.
1 soluzione per “memb_stat” in Strumenti · Azzera
SkynetMU Full Option Cleaner: how do I find and remove full excellent items from warehouses and inventories of a 97/97D SQL database?
1. Install Python 3.11 or 3.12 on Windows, then run py -m pip install -r requirements.txt and py SkynetMU_FullOption_Cleaner.py. 2. For ODBC install Microsoft ODBC Driver 17 or 18 for SQL...
Altre risposte per “memb_stat”
1 in Strumenti, 18 in altre categorie e file del server:
Players show online on the website after the server closed, or accounts stay "online" (MEMB_STAT.ConnectStat stuck at 1)
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 Con...
Not verifiedScritto da MuADMINSMuDevs: WZ_CONNECT_MEMB has 4 parameters (@HarwareID) and MEMB_STAT has HWID / OnlineHours
MuDevs differs from the other MuEmu based files here: - WZ_CONNECT_MEMB @memb___id varchar(10), @ServerName varchar(50), @IP varchar(20), @HarwareID varchar(74) (4th parameter, spelled Ha...
Not verifiedScritto da MuADMINSHow do I make a working online time ranking per character?
1. Add an int column OnlineTime to the Character table (back up first). 2. Create a SQL Agent job every minute: UPDATE Character SET OnlineTime=OnlineTime+1 joined to MEMB_STAT (ConnectSt...
✓ Confermato dall'autore della discussioneCreandoMU · 2021-03-09The website always shows 2 players online even when the server is off
Stale rows in MEMB_STAT still say the accounts are connected. 1. Open Query Analyzer / SSMS on the MuOnline database. 2. Run UPDATE MEMB_STAT SET ConnectStat='0' WHERE ConnectStat>0. 3. R...
✓ Confermato dall'autore della discussioneDarksTeam · 2009-03-03Website staff table: show whether each GM / Admin is online or offline
1. Select the staff characters: Select CtlCode,AccountID From Character where CtlCode='32'. 2. For each one check MEMB_STAT: Select * from MEMB_STAT where memb___id='<AccountID>' and Conn...
✓ Confermato dall'autore della discussioneDarksTeam · 2010-05-14MuCore website Exchange System always shows 0 Online Hours although the character was online for hours (DarkMaster 97d server)
The MuCore module reads the column OnlineMinutes, which did not exist in the database. 1. Take the online-time SQL script from the thread (it adds a column to MEMB_STAT and changes the st...
✓ Confermato dall'autore della discussioneDarksTeam · 2019-07-25WebEngine sidebar shows players online when nobody is connected
The online count comes from MEMB_STAT, and some accounts stayed marked as connected there. 1. With the game server closed, clear the stuck online flag in MEMB_STAT (for example: UPDATE ME...
✓ Confermato dall'autore della discussioneTUServerMU · 2021-05-30Replacing WZ_DISCONNECT_MEMB for MuCore gives 'Msg 468 ... Cannot resolve the collation conflict between Latin1_General_CS_AS and SQL_Latin1_General_CP1_CI_AS'
1. The procedure compares memb___id from MEMB_INFO with memb___id from MEMB_STAT, and the two columns use different collations. 2. In SQL Server Management Studio set the same collation o...
✓ Confermato dall'autore della discussioneRaGEZONE · 2015-11-30