MuADMINS
Mga Solusyon
Maiikling fix para sa mga karaniwang problema sa MU Online server, client at website, bawat isa ay may source at petsa. Ang ibig sabihin ng “Kinumpirma” ay sinabi ng nagtanong na gumana ang fix.
0 solusyon para sa “memb_stat” sa Game client · I-clear
Wala pang laman ang Game client para sa mga salitang ito, pero may nakikitang solusyon sa ibang kategorya at server files (sa ibaba).
Iba pang sagot para sa “memb_stat”
0 sa Game client, 19 sa ibang kategorya at server files:
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 verifiedIsinulat ng 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 verifiedIsinulat ng 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...
✓ Kinumpirma ng nagsimula ng topicCreandoMU · 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...
✓ Kinumpirma ng nagsimula ng topicDarksTeam · 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...
✓ Kinumpirma ng nagsimula ng topicDarksTeam · 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...
✓ Kinumpirma ng nagsimula ng topicDarksTeam · 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...
✓ Kinumpirma ng nagsimula ng topicTUServerMU · 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...
✓ Kinumpirma ng nagsimula ng topicRaGEZONE · 2015-11-30