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: 99 dla “darksteam” w kategorii Konfiguracja serwera · Wyczyść

  1. Konfiguracja serwera

    What breaks a MU server database? Safe SQL checklist before you run a query

    What breaks MU databases most often, and what the pack files themselves show: 1. UPDATE while the server runs: the server writes online characters back from memory (IGCN maintenance scrip...

    Not verifiedNapisane przez MuADMINS
  2. 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
  3. Konfiguracja serwera

    A character exists in the Character table but does not appear (AccountCharacter slots)

    The character list of an account is kept in AccountCharacter (Id = account, GameID1 to GameID5, or to GameID10 on newer files, plus GameIDC). The packs' WZ_CreateCharacter writes the new...

    Not verifiedNapisane przez MuADMINS
  4. Konfiguracja serwera

    "Account does not exist" or the login fails although the account is in MEMB_INFO: what to check in the database

    Check these in order (all read only, nothing changes): 1. Is the server reading the same database? MuEmu, Louis, MSPro, X-Team, MuDevs use the ODBC DSN in JoinServer.ini (JoinServerODBC =...

    Not verifiedNapisane przez MuADMINS
  5. 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
  6. 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
  7. Konfiguracja serweraWebZen 97d / 99bS2, S3

    How do I set a new password for one account on a WebZen Season 2 / 3 MD5 database (SP_MD5_ENCODE_VALUE)?

    The Season 3 mumatrix and Season 2 namech databases ship SP_MD5_ENCODE_VALUE @btInStr VARCHAR(10), @btInStrIndex VARCHAR(10) ("Created By WebZen, Adapted By [CzF]Deathway" in the Season 3...

    Not verifiedNapisane przez MuADMINS
  8. 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
  9. Konfiguracja serweraS2, S6, S16, S17, S18, S20

    How do I reset a character with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files (ResetCount) with the server closed?

    Columns: Character.ResetCount and MasterResetCount (X-Team also ResetDay, ResetWek, ResetMon and MasterResetDay / Wek / Mon for the daily, weekly and monthly limits). The server reads and...

    Not verifiedNapisane przez MuADMINS
  10. Konfiguracja serweraS2, S6, S15, S17, S18

    How do I make a character GM on MuEmu, Louis, MSPro, X-Team or MuDevs files (GameMaster.txt, not CtlCode)?

    In MuEmu based files the GM list is a file, not a database column: GameServer\Data\Util\GameMaster.txt, one line per GM: "account1" "GMName" 2 - Louis Season 6: columns Account, Name, Lev...

    Not verifiedNapisane przez MuADMINS
  11. Konfiguracja serweraS6, S16, S17, S18, S20

    How do I add WCoinC, WCoinP or Goblin Points with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files (CashShopData)?

    The table is CashShopData (AccountID, WCoinC, WCoinP, GoblinPoint). 1. Account offline (best: server closed), backup first, look at the row: SELECT AccountID, WCoinC, WCoinP, GoblinPoint...

    Not verifiedNapisane przez MuADMINS
  12. Konfiguracja serweraS2, S6, S16, S17, S18, S20

    How do I give VIP (AccountLevel) to an account with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files?

    In MuEmu based files VIP is MEMB_INFO.AccountLevel (0 = normal, the AL1 / AL2 / AL3 levels of your configs) with MEMB_INFO.AccountExpireDate. Use the shipped procedure, account offline: E...

    Not verifiedNapisane przez MuADMINS
  13. Konfiguracja serweraS6, S16

    How do I turn MD5 on (MD5Encryption in JoinServer.ini) on MuEmu, Louis, MSPro, X-Team or MuDevs files, and what does the database need?

    In MuEmu based files the switch is JoinServer\JoinServer.ini, MD5Encryption = 0/1 (next to CaseSensitive = 0). Every pack we read ships 0. What the databases have: - X-Team Season 2 and 1...

    Not verifiedNapisane przez MuADMINS
  14. Konfiguracja serweraany

    GameServer, DataServer or JoinServer will not start: MSVCR100.dll, MSVCP120.dll or VCRUNTIME140.dll is missing. Which runtime do I install?

    1. The number in the DLL name tells the Visual C++ version: 80 = 2005, 90 = 2008, 100 = 2010, 110 = 2012, 120 = 2013, 140 = 2015 to 2026. 2. Download the matching Visual C++ Redistributab...

    Opracowanie źródła przez MuADMINSNot verifiedMicrosoft Learn · 2025-12-03
  15. Konfiguracja serweraany

    How do I open the MU server ports (44405, 55901, 55919 and others) in Windows Firewall quickly and correctly?

    1. Open PowerShell as administrator on the server. 2. Create one inbound rule for all TCP ports, for example: New-NetFirewallRule -DisplayName "MU Server" -Direction Inbound -Protocol TCP...

    Opracowanie źródła przez MuADMINSNot verifiedMicrosoft Learn · 2025-05-14
  16. Konfiguracja serweraany

    My GameServer (port 55901 and up) sometimes fails to start because the port is already in use. How do I check the Windows dynamic port range?

    1. Since Windows Vista and Server 2008, outgoing connections use local ports 49152 to 65535 by default, which includes 55901, 55960, 55970. 2. Show the range: netsh int ipv4 show dynamicp...

    Opracowanie źródła przez MuADMINSNot verifiedMicrosoft Learn · 2026-02-12
  17. Konfiguracja serweraany

    Remote tools or the web cannot reach a SQL Express or named instance on port 1433. How do I make SQL listen on a fixed port?

    1. Named instances use dynamic ports by default; only the default instance uses 1433. 2. SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for your instance...

    Opracowanie źródła przez MuADMINSNot verifiedMicrosoft Learn · 2025-08-26
  18. 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
  19. Konfiguracja serwera

    The ODBC data source exists but the server says it cannot find it (64-bit Windows)

    64-bit Windows has two ODBC administrators and each keeps its own list of System DSNs. Most MU server programs (JoinServer, DataServer, GameServer) are 32-bit, so they only see data sourc...

    Opracowanie źródła przez MuADMINSNot verifiedMicrosoft Learn

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