MuADMINS
Çözümler
Yaygın MU Online sunucu, client ve web sitesi sorunları için kısa düzeltmeler; her biri kaynağı ve tarihiyle. “Onaylanmış”, soruyu soran kişinin düzeltmenin işe yaradığını söylediği anlamına gelir.
10 çözüm “connectstat” için · Temizle
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 verifiedMuADMINS tarafından yazıldıHow 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...
✓ Konu sahibi tarafından onaylandıCreandoMU · 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...
✓ Konu sahibi tarafından onaylandıDarksTeam · 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...
✓ Konu sahibi tarafından onaylandıDarksTeam · 2010-05-14WebEngine 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...
✓ Konu sahibi tarafından onaylandıTUServerMU · 2021-05-30Which website CMS expects which MU database columns (WebEngine table maps, DmN)
WebEngine 1.2.7 picks a table map by server files (includes/config): - igcn.tables.php / custom.tables.php: resets = Character.RESETS, grand resets = Character.GrandResets, VIP = T_VIPLis...
Not verifiedMuADMINS tarafından yazıldıI changed a character, coins or a vault with SQL and the change disappeared (UPDATE while the server is on)
The running server keeps its own copy of every online character and account and writes it back to the database, so an UPDATE made while that player is online can be overwritten a moment l...
Not verifiedMuADMINS tarafından yazıldıCould not find stored procedure 'WZ_CONNECT_MEMB' (or WZ_DISCONNECT_MEMB): what they do and how to restore them
WZ_CONNECT_MEMB and WZ_DISCONNECT_MEMB keep MEMB_STAT up to date (ConnectStat 1 at login, 0 at logout). They must exist in the database the JoinServer / DataServer connects to: - IGCN: in...
Not verifiedMuADMINS tarafından yazıldıWhat is in the X-Team MuOnline database (password column, VIP, coins, resets, gens, master level)?
X-Team uses one database, MuOnline, with the MuEmu procedure set. - Accounts: MEMB_INFO.memb__pwd varchar(10) (plain; no MD5 function in the scripts), sno__numb char(18), AccountLevel / A...
Not verifiedMuADMINS tarafından yazıldıWebEngine with X-Team files: online ranking fails with Invalid column name 'OnlineHours'
WebEngine's map for X-Team files (includes\config\xteam.tables.php) defines _CLMN_MS_ONLINEHRS_ = OnlineHours, and the online ranking (only for xteam files) runs: SELECT TOP n memb___id,...
Not verifiedMuADMINS tarafından yazıldı