MuADMINS
Giải pháp
Các cách sửa ngắn gọn cho những lỗi thường gặp của server, client và website MU Online, mỗi cách đều kèm nguồn và ngày. “Đã xác nhận” nghĩa là người đặt câu hỏi cho biết cách sửa đã hiệu quả.
127 giải pháp cho “SQL Server” cho DV-Team và mọi bộ file · Xóa lọc
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...
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...
✓ Được người mở chủ đề xác nhậnDarksTeam · 2021-12-28Remote 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...
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...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2018-01-06During 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...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2017-07-21WebEngine 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.
✓ Được người mở chủ đề xác nhậnRaGEZONE · 2017-09-09WebEngine 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...
✓ Được người mở chủ đề xác nhậnRaGEZONE · 2023-10-06MuCore 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...
✓ Được người mở chủ đề xác nhậnRaGEZONE · 2011-03-05MuCore 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...
✓ Được người mở chủ đề xác nhậnRaGEZONE · 2016-05-26MFS 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...
✓ Được người mở chủ đề xác nhậnRaGEZONE · 2014-02-11Titan 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)...
✓ Được người mở chủ đề xác nhậnRaGEZONE · 2013-09-25Accounts do not work after putting a 1.0L database under 1.0M files
The two versions use different password storage. 1. 1.0M files use MD5 on; 1.0L files use MD5 off. 2. Use the database (and website install option) that matches your files: MD5 on for 1.0...
✓ Được người mở chủ đề xác nhậnDarksTeam · 2008-11-25MuWeb 0.9 installer check shows Mssql: NO even after editing php.ini
1. Install XAMPP 1.7.0 (it includes the mssql extension the site needs). 2. Put MuWeb 0.9 in its htdocs and open the installer again; Mssql now shows YES.
✓ Được người mở chủ đề xác nhậnDarksTeam · 2009-02-12Error #123 Loading php_mssql.dll Failed when installing DarksWeb, although the dll is in the ext folder
1. Install AppServ 2.5.9 instead of the XAMPP / VertrigoServ builds that failed. 2. Edit C:\Windows\php.ini (the php.ini AppServ really uses) and enable extension=php_mssql.dll there. 3....
✓ Được người mở chủ đề xác nhậnDarksTeam · 2009-10-28How to get the list of e-mail addresses of all registered accounts from the MU database
1. Open SQL Server Management Studio and connect to the server that holds your MU database. 2. Run: USE MuOnline; SELECT mail_addr FROM MEMB_INFO; 3. The result is the e-mail of every acc...
✓ Được người mở chủ đề xác nhậnTUServerMU · 2021-03-17How 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...
✓ Được người mở chủ đề xác nhậnTUServerMU · 2020-07-23How do I show the guild logo (G_Mark) of a guild, for example the Castle Siege owner, on a PHP website with MSSQL?
1. G_Mark in the Guild table is binary: turn it into text with bin2hex(). You get 64 hex digits, one per cell of an 8x8 grid. 2. Map each digit to a color: 0 transparent, 1 #000000, 2 #8c...
✓ Được người mở chủ đề xác nhậnRaGEZONE · 2020-07-01JoinServer and DataServer show Could not connect to database on start.
1. Restore the MuOnline database correctly in SQL Server (from the backup shipped with your files). 2. Create the ODBC data source the servers expect, pointing to that database. 3. Make s...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2017-07-05After switching to new server files with a new database, the MuCore site no longer detects the database and players cannot register.
1. The new database does not contain the MuCore tables. 2. Run the MuCore installer again against the new database so it creates its tables. 3. Check config.SQL.php points to the new DB.
✓ Được người mở chủ đề xác nhậnTuServerMU · 2018-11-19DMN MuCMS 1.1.8 installer fails at the database selection step (both on a host and on XAMPP).
1. Use a separate database for the web (for example dmncms). 2. The MU game database must be named MuOnline (plus Me_MuOnline if your files use it); the install failed with a custom name....
✓ Được người mở chủ đề xác nhậnTuServerMU · 2018-04-27