Community AlphaAlpha MUADMINS
DEDeutsch
Anmelden
Auf MuADMINSConfig ScannerZip deiner Dateien hochladen: Rates, Drops, Spots, LimitsÖffnenAuf MuADMINSTriff uns auf DiscordFrag nach Hilfe, zeig, woran du arbeitest, und sprich mit anderen Serverbetreibern über MU.Öffnen

MuADMINS

Lösungen

Kurze Fixes für häufige Probleme mit Server, Client und Website bei MU Online, jeweils mit Quelle und Datum. “Bestätigt” heißt: Die Person, die gefragt hat, hat gesagt, dass der Fix funktioniert hat.

145 Lösungen für “SQL Server” für WebZen 97d / 99b und alle Files · Zurücksetzen

  1. Server-Setup

    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 verifiedVon MuADMINS geschrieben
  2. Server-Setup

    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 verifiedVon MuADMINS geschrieben
  3. Server-SetupWebZen 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 verifiedVon MuADMINS geschrieben
  4. Server-SetupWebZen 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 verifiedVon MuADMINS geschrieben
  5. Server-SetupS2, 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 verifiedVon MuADMINS geschrieben
  6. Server-SetupS6, 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 verifiedVon MuADMINS geschrieben
  7. Server-SetupS2, 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 verifiedVon MuADMINS geschrieben
  8. Tools

    MuMaker: cannot connect to SQL Server 2005 Express (SQLEXPRESS)

    1. Open SQL Server Configuration Manager, then Protocols for SQLEXPRESS. 2. Right click TCP/IP, Properties, set Enabled to Yes. 3. In the IP Addresses tab set Active and Enabled to Yes fo...

    Neufassung der Quelle durch MuADMINSNot verifiedRaGEZONE · 2013-10-09
  9. Tools

    MuMaker: how to fill the first configuration window (SQL user, local or remote, MD5, database names, reset column)

    1. Extract MuMaker and start MuMaker.exe. 2. Type any name (server name or yours), the SQL user (sa by default) and its password. 3. Connection type: choose local when MuMaker runs on the...

    Neufassung der Quelle durch MuADMINSNot verifiedRaGEZONE · 2007-12-22
  10. Server-Setup97d+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...

    ✓ Vom Threadersteller bestätigtDarksTeam · 2021-12-28
  11. Server-Setupany

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

    Neufassung der Quelle durch MuADMINSNot verifiedMicrosoft Learn · 2025-08-26
  12. Toolsany

    I cannot delete a MU database in SQL Server Management Studio, it gives an error because it is in use. How do I remove it?

    1. Stop DataServer, JoinServer, the editors and the web that use the database. 2. In Management Studio right click the database > Delete. 3. In the Delete Object window tick Close existin...

    ✓ Vom Threadersteller bestätigtTuServerMU · 2018-01-06
  13. Server-Setupany

    During SQL Server setup the password for sa is rejected no matter what I type. Why?

    1. Setup enforces the Windows password policy on the sa password. 2. Use at least 8 characters that mix uppercase letters, lowercase letters and numbers (a symbol helps too). 3. Do not us...

    ✓ Vom Threadersteller bestätigtTuServerMU · 2017-07-21
  14. Websiteany

    WebEngine 1.0.9 with a remote SQL Server IP fails with 'Could not connect to database (1)', while MuCore connects to the same server without problems.

    1. In the WebEngine installer select the ODBC driver instead of dblib/sqlsrv. 2. Make sure the matching PHP ODBC extension is enabled and port 1433 is reachable. 3. Finish the install.

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2017-09-09
  15. ToolsS6

    WebEngine CMS installer: "Could not connect to database (1)" at the database step with MSSQL Server 2008 (PDO ODBC, XAMPP)

    1. In this case the game files connected fine but the WebEngine installer kept failing on the database step, with no error in the SQL logs or the Windows event log. 2. The cause was a con...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2023-10-06
  16. Tools

    MuCore install: "Connection with MuOnline Database Failed" and "Extension php_mssql.dll must be enabled"

    1. MuCore needs a PHP that still has the old php_mssql.dll extension: in php.ini find extension=php_mssql.dll and remove the ; in front of it. 2. If your web server package has no php_mss...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2011-03-05
  17. Tools

    MuCore 1.08 installer: with the MSSQL connection it cannot get past step 3 (MSSQL 2008 R2, XAMPP 1.7.1)

    1. Use XAMPP 1.7.7 for MuCore 1.08 (XAMPP 1.7.1 with MSSQL 2008 works badly). 2. Install the client DLL that supports your MSSQL version (linked in the reply). 3. Open C:/xampp/php/php.in...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2016-05-26
  18. ToolsWebZen 97d / 99b

    Cash Shop and VIP Editor (Dino): how to connect it to SQL Server and which columns it needs

    1. Enter the SQL Server IP, login, password and port, then click Connect. 2. Leave the filter empty to list all accounts, or type an account name. 3. Choose the VIP type and the amount of...

    Neufassung der Quelle durch MuADMINSNot verifiedImperyus Games Brasil · 2009-10-04
  19. Tools

    MFS Database Tool: the backup gives the same error as other backup managers, even with (local), Windows authentication or 127.0.0.1

    1. Connect to your SQL Server as usual (the tool supports SQL Server 2000 and 2008 style connections). 2. Do not pick the database with the drop down button: type the database name (for e...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2014-02-11
  20. Tools

    Titan Editor: cannot connect to the MU database to create accounts (single MuOnline database)

    1. Open the Titan Editor config. With only one database (MuOnline) both ODBC names point to it: [Connection] ODBC=MuOnline, ODBC_Me=MuOnline, User=sa, Password=yourpass, SQLServer=(local)...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2013-09-25

MuADMINS Community Alpha: kostenlos, von der Community gemacht, in aktiver Entwicklung.