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: 79 dla “cannot open database” w kategorii Konfiguracja serwera · Wyczyść

  1. Konfiguracja serwera97d+99i

    SQL command to give credits to every account (DarksTeam 97d+99i)

    1. Open SSMS / Query Analyzer on the MuOnline database. 2. For all accounts run UPDATE MEMB_CREDITS SET credits=credits+500. 3. For one account run UPDATE MEMB_CREDITS SET credits=credits...

    ✓ Potwierdzone przez autora tematuDarksTeam · 2021-12-28
  2. Konfiguracja serweraMuEmu / LouisSeason 6 (MuEmu)

    How do I change the items new characters start with equipped?

    1. Create a character and equip it with MuEditor as you want. 2. Copy that character's Inventory value in SQL. 3. Run UPDATE DefaultClassType SET Inventory = <copied value> WHERE Class =...

    ✓ Potwierdzone przez autora tematuCreandoMU · 2020-08-15
  3. Konfiguracja serweraany

    I run one server on my VPS and want a second one with its own database on the same VPS, but it does not connect. What must change?

    1. Give the second server its own database and create a new ODBC data source pointing to it (same driver, Server = (local), Database = new name). 2. Point the second JoinServer and DataSe...

    ✓ Potwierdzone przez autora tematuTuServerMU · 2019-10-09
  4. 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
  5. Konfiguracja serweraWebZen 97d / 99b97d

    DarksTeam 97d: accounts created on the web show NULL columns in the database and characters do not show up properly. How to fix it?

    1. Back up the MuOnline database first. 2. Open a new query on MuOnline in SQL Server Management Studio. 3. Run: UPDATE Character SET CtlCode = 0 WHERE CtlCode IS NULL 4. Restart the serv...

    ✓ Potwierdzone przez autora tematuTuServerMU · 2018-10-15
  6. Konfiguracja serweraMuEmu / LouisSeason 8 Episode 3

    JoinServer and DataServer stopped connecting to the database (MuEmu Season 8)

    Restoring the database and the ODBC data sources again did not help: the SQL login the servers use did not have the rights it needs. 1. Open SQL Server Management Studio and go to Securit...

    ✓ Potwierdzone przez autora tematuTUServerMU · 2018-10-06
  7. 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
  8. 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
  9. Konfiguracja serweraIGCNS9, S12, S16, S17, S18

    How do I give or extend VIP for an account with SQL on IGCN files (IGC_VipAdd, T_VIPList)?

    IGCN keeps the active VIP in T_VIPList (AccountID, Date, Type); MEMB_INFO also has VipType, VipStart, VipDays. The shipped procedure is IGC_VipAdd @szCharName, @DayAdd, @VipType. Despite...

    Not verifiedNapisane przez MuADMINS
  10. Konfiguracja serweraIGCNS9, S12, S16, S17, S18

    How do I reset a character with SQL on IGCN files (RESETS, GrandResets) with the server closed?

    Columns in IGCN Character: RESETS (int, all seasons), GrandResets (tinyint, Season 16, 17, 18), GRANDRESET (Season 12), plus cLevel, Experience, LevelUpPoint and the stats. 1. Close the G...

    Not verifiedNapisane przez MuADMINS
  11. 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
  12. Konfiguracja serweraS3E2

    DarksTeam Season 3 Episode 2 (Beta 19) Cash Shop: a bought Seal disappears after reconnect

    The seal was saved with a wrong date format in t_perioditem_info. 1. Open the stored procedure t_perioditem_insert in the MuOnline database. 2. Fix the datetime format it uses when insert...

    ✓ Potwierdzone przez autora tematuDarksTeam · 2009-08-09
  13. Konfiguracja serwera

    Guild war gives no points: the website shows a negative score and the in-game G Score stays 0

    The Guild table column G_Score had no default value, so new guilds got NULL. 1. Open SQL Server > MuOnline database > Tables > Guild > Design Table. 2. Select the column G_Score and set i...

    ✓ Potwierdzone przez autora tematuDarksTeam · 2010-05-03
  14. 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
  15. 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
  16. Konfiguracja serweraany

    After enabling TCP/IP in SQL Server for the web, DataServer, JoinServer and GameServerCS lost the database connection. How was it fixed?

    1. In SQL Server Configuration Manager keep Named Pipes and TCP/IP enabled for the instance. 2. Open the ODBC DSNs used by the server files. 3. Change the Server field from the LAN IP to...

    ✓ Potwierdzone przez autora tematuTuServerMU · 2020-05-23
  17. 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
  18. Konfiguracja serweraSeason 6

    How to remove the master skill tree skills from every character at once (S6 Up15 GamingMaster files); DELETE MasterSkillTree did not remove them

    The learned skills are stored in the MagicList column of the Character table. 1. Back up the database and close the server. 2. Run: USE MuOnline; UPDATE Character SET [MagicList] = CONVER...

    ✓ Potwierdzone przez autora tematuTUServerMU · 2021-05-09
  19. Konfiguracja serweraX-TeamSeason 15

    X-Team Season 15 files (update 5): GameServer shows a message that something 'does not exist' and will not start

    The error is about the server code and the GameServer common file of the update. 1. Check the ServerCode is the same in ConnectServer\ConnectServer.txt, Data\MapServerInfo and the GameSer...

    ✓ Potwierdzone przez autora tematuTUServerMU · 2020-08-15
  20. Konfiguracja serweraIGCNS12

    IGCN Season 12: DataServer is not responding although TCP/IP is enabled in SQL Server

    1. Open DataServer.ini and check SQLServerName. 2. When SQL Server runs on the same machine use SQLServerName = (local) or the exact PC name as shown in SQL Server Management Studio (for...

    ✓ Potwierdzone przez autora tematuRaGEZONE · 2020-01-08

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