Community AlphaAlpha MUADMINS
ESEspañol
Iniciar sesión
En MuADMINSConfig ScannerSube el zip de tus archivos: rates, drops, spots, límitesAbrirEn MuADMINSEncuéntranos en DiscordPide ayuda, comparte lo que estás creando y habla de MU con otros dueños de servidores.Abrir

MuADMINS

Soluciones

Arreglos breves para problemas comunes de servidores, clientes y sitios web de MU Online, cada uno con su fuente y su fecha. “Confirmado” significa que la persona que preguntó dijo que el arreglo funcionó.

19 soluciones para “memb_stat” · Limpiar

  1. Instalación del servidor

    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 verifiedEscrito por MuADMINS
  2. Instalación del servidorMuDevsS18, S20

    MuDevs: 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 verifiedEscrito por MuADMINS
  3. Instalación del servidorMuEmu / LouisSeason 6 (Louis)

    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...

    ✓ Confirmado por el autor del temaCreandoMU · 2021-03-09
  4. Instalación del servidor

    The 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...

    ✓ Confirmado por el autor del temaDarksTeam · 2009-03-03
  5. Sitio web

    Website 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...

    ✓ Confirmado por el autor del temaDarksTeam · 2010-05-14
  6. Sitio web97d

    MuCore 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...

    ✓ Confirmado por el autor del temaDarksTeam · 2019-07-25
  7. Sitio webany

    WebEngine 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...

    ✓ Confirmado por el autor del temaTUServerMU · 2021-05-30
  8. Instalación del servidor

    Replacing 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...

    ✓ Confirmado por el autor del temaRaGEZONE · 2015-11-30
  9. Sitio webX-TeamS2, S17

    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 verifiedEscrito por MuADMINS
  10. Sitio web

    Which 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 verifiedEscrito por MuADMINS
  11. Sitio web

    What does the DmN CMS setup change in the MU database (columns, Character.id, WZ_CONNECT_MEMB) and what can break?

    The DmN CMS 1.2.3 setup does more than create its own tables: 1. It ALTERs the game databases: adds columns from its version files, for example MEMB_INFO Admin, last_login, activated, act...

    Not verifiedEscrito por MuADMINS
  12. Instalación del servidorMuEmu / LouisS6

    Unicode (NVARCHAR) migration of a MuEmu / Louis Season 6 database: what is right and what breaks

    Review of a Season 6 Unicode script set (a migration that converts the name columns to NVARCHAR plus new WZ_CreateCharacter, WZ_DeleteCharacter, WZ_CreateGuild procedures). Its table list...

    Not verifiedEscrito por MuADMINS
  13. Instalación del servidor

    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 verifiedEscrito por MuADMINS
  14. Instalación del servidor

    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 verifiedEscrito por MuADMINS
  15. Instalación del servidorWebZen 97d / 99b97d, 99b, S2, S3

    Which databases and procedures do WebZen 97d, Season 2 and Season 3 files use?

    - 97d (RaGEZONE pack): MuOnline.bak and Ranking.bak, SQL Server 2000 backups (restore them on 2005, 2008 or 2008 R2 first: 2012 and newer cannot restore a SQL 2000 backup). WZ_CONNECT_MEM...

    Not verifiedEscrito por MuADMINS
  16. Instalación del servidorX-TeamS2, S15, S17, S18

    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 verifiedEscrito por MuADMINS
  17. Instalación del servidorIGCNS12, S16, S17, S18

    IGCN Me_MuOnline (shared accounts): login fails or new accounts are not found after enabling it

    Me_MuOnline is a separate accounts database. It has its own MEMB_INFO, MEMB_STAT, T_VIPList, ConnectionHistory, IGC_MachineID_Banned, fn_md5, WZ_CONNECT_MEMB and WZ_DISCONNECT_MEMB. 1. IG...

    Not verifiedEscrito por MuADMINS
  18. Instalación del servidorIGCNS9, S12, S16, S17, S18

    Which databases do IGCN files need (MuOnline, Me_MuOnline, Events, Ranking, BattleCore) and in which order do the update scripts run?

    IGCN files use up to five databases: - MuOnline: accounts (MEMB_INFO, MEMB_STAT), characters, guilds, warehouse, cash shop (T_InGameShop_Point), VIP (T_VIPList). - Me_MuOnline: optional s...

    Not verifiedEscrito por MuADMINS
  19. HerramientasWebZen 97d / 99b97d

    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...

    Reescrito por MuADMINS a partir de la fuenteNot verifiedGitHub (Azzlaer/Mu_Cleaner_OF) · 2026-08-24
¿Sigues atascado? Pregúntale al Asistente MU Buscar en MuGPS Buscar en MUTube

MuADMINS Community Alpha: gratis, hecho por la comunidad y en desarrollo activo.