Community AlphaAlpha MUADMINS
PLPolski
Zaloguj się
Na MuADMINSConfig ScannerWgraj zip swoich plików: rates, dropy, spoty, limityOtwórzNa MuADMINSSpotkajmy się na DiscordziePoproś o pomoc, pokaż, nad czym pracujesz, i rozmawiaj o MU z innymi właścicielami serwerów.Otwórz

MuADMINS

Rozwiązania

Krótkie poprawki częstych problemów z serwerem, klientem i stroną MU Online, każda ze źródłem i datą. “Potwierdzone” oznacza, że osoba, która pytała, potwierdziła, że poprawka zadziałała.

Rozwiązania: 29 dla “stats” w kategorii Konfiguracja serwera · Wyczyść

  1. Konfiguracja serweraMuEmu / LouisSeason 6 (Louis free)

    Items ask for more stats than shown and only equip after relogging (Louis free S6).

    1. Louis first advice: item.bmd (client) and Item.txt (server) must match. 2. Here the asker had changed the starting stats of the classes directly in the database, which caused the confl...

    ✓ Potwierdzone przez autora tematuCreandoMU · 2021-08-31
  2. Konfiguracja serwera

    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 verifiedNapisane przez MuADMINS
  3. Konfiguracja serweraMuDevsS18, 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 verifiedNapisane przez MuADMINS
  4. Konfiguracja serweraIGCNS9

    IGCN S9 E2 repack: DataServer says 'Login failed for user ...' (SQLSTATE 28000) and 'DATA SERVER CANNOT CONNECT TO MSSQL'

    1. The repack DataServer config came with a SQL login that does not exist on your SQL Server (here a random name like D2a78Rtko0), so the login fails. 2. Open the database settings of the...

    ✓ Potwierdzone przez autora tematuRaGEZONE · 2019-07-14
  5. Konfiguracja serweraMuEmu / LouisS4

    DataServer floods '[QueryManager] State (24000) ... [ODBC SQL Server Driver] Invalid' when a character gets PK status (MuEmu S4 with the Ferrarezi website)

    1. The cause was not ODBC: the Ferrarezi website adds a trigger Z_PK_HERO on dbo.Character that fires when PkCount changes, and its old version broke the DataServer queries. 2. In SQL Ser...

    ✓ Potwierdzone przez autora tematuRaGEZONE · 2018-04-09
  6. Konfiguracja serweraany

    "Login failed for user 'sa'" (SQLSTATE 28000) from DataServer or the web right after installing SQL Server. How do I enable sa?

    1. If setup used Windows authentication only, sa is disabled. 2. In Management Studio right click the server > Properties > Security and pick SQL Server and Windows Authentication mode. 3...

    Opracowanie źródła przez MuADMINSNot verifiedMicrosoft Learn · 2025-08-26
  7. Konfiguracja serwera

    How to protect Game Master characters (give them the protected GM status)

    The GM status is the CtlCode column of the character. 1. Open the MuOnline database in SQL Server. 2. Run UPDATE Character SET CtlCode = '8' WHERE Name='<GM name>' (the asker confirmed 8...

    ✓ Potwierdzone przez autora tematuDarksTeam · 2012-05-11
  8. Konfiguracja serwera

    Characters do not save and the DataServer log shows State (42S22)

    SQL state 42S22 means a column was not found: the server files query a column your database does not have, so the save fails. 1. Open the DataServer log and read which table and column th...

    ✓ Potwierdzone przez autora tematuTUServerMU · 2021-03-24
  9. Konfiguracja serweraMuEmu / 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...

    ✓ Potwierdzone przez autora tematuCreandoMU · 2021-03-09
  10. Konfiguracja serwera

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

    ✓ Potwierdzone przez autora tematuDarksTeam · 2009-03-03
  11. Konfiguracja serweraany

    How to back up only the accounts and characters (inventory, warehouse, stats) instead of the whole MU database

    1. First make a full backup of the current database as it is (SQL Server Management Studio > Tasks > Back Up). 2. To move players to a clean database, copy over only the tables that hold...

    ✓ Potwierdzone przez autora tematuTUServerMU · 2020-07-23
  12. Konfiguracja serwera

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

    ✓ Potwierdzone przez autora tematuRaGEZONE · 2015-11-30
  13. Konfiguracja serweraOpenMU

    OpenMU: a player stays 'already connected' after a dropped connection and cannot log in again, even with the right password

    1. The old session stays registered while the TCP connection to OpenMU is still open. With the web client the WebSocket proxy keeps that connection alive, so every new login gets AccountA...

    ✓ Potwierdzone w zgłoszeniuGitHub (MUnique/OpenMU) · 2026-10-07
  14. Konfiguracja serweraMuEmu / LouisSeason 6 (Louis)

    Two accounts always say they are already logged in, but they are not in game and cannot be disconnected.

    1. The online state is kept by the JoinServer. 2. Use the JoinServer option to disconnect accounts. 3. Then the account can log in again.

    ✓ Potwierdzone przez autora tematuCreandoMU · 2021-01-31
  15. Konfiguracja serwera0.97d (97d+99i)

    GameServer 0.97 (DarksTeam 97d Beta 41) disconnects Dark Wizard / Soul Master with [ClientHack Detected : Editing AttackSpeed]

    The characters wear items that need more Strength or Agility than they have, so the attack speed check fires. 1. Either give the characters the stat points the items require, or 2. Open D...

    ✓ Potwierdzone przez autora tematuDarksTeam · 2018-12-29
  16. Konfiguracja serweraOpenMUany

    OpenMU crashes on startup after a failed data import left the database tables without a GameConfiguration.

    1. Older builds crashed when the tables existed but no GameConfiguration row did. 2. Update to a build containing PR #910 (September 2026): the server then starts and the admin panel offe...

    ✓ Potwierdzone w zgłoszeniuGitHub (MUnique/OpenMU) · 2026-08-27
  17. Konfiguracja serweraMuEmu / 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 verifiedNapisane przez MuADMINS
  18. Konfiguracja serwera

    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 verifiedNapisane przez MuADMINS
  19. Konfiguracja serwera

    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 verifiedNapisane przez MuADMINS
  20. Konfiguracja serweraWebZen 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 verifiedNapisane przez MuADMINS

Filmy w MUTube

Więcej filmów dla „stats”

Nadal masz problem? Zapytaj Asystenta MU Szukaj w MuGPS

MuADMINS Community Alpha: za darmo, tworzone przez społeczność, w aktywnym rozwoju.