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ả.
71 giải pháp cho “php -q” · Xóa lọc
Website error "Fatal error: Call to undefined function mssql_connect()" (XAMPP 1.7.7, SQL Server 2008, DarksWeb 0.3)
New XAMPP builds no longer have the mssql_* functions these old sites use. 1. Install XAMPP 1.7.1 (said to be the last one with mssql_*), or add code that defines those functions to the s...
✓ Được người mở chủ đề xác nhậnDarksTeam · 2019-02-07WebEngine player profile and character editor fail for names with [ ] tags like [ADM]Name. How to fix?
1. Older versions filter player names to letters and numbers, so names with brackets break the profile links. 2. Update to WebEngine 1.2.6 or newer: player and guild profile links are Bas...
✓ Đã xác nhận trong issueGitHub (lautaroangelico/WebEngine) · 2022-08-17MuCore on a web host cannot connect to the MuOnline database on a Google Cloud VPS (Connection with MuOnline Database Failed), although 1433 is open in Windows.
1. Enable TCP/IP and Named Pipes for the instance in SQL Server Configuration Manager and restart SQL. 2. Open TCP 1433 in the Windows firewall of the VPS. 3. Also open TCP 1433 in the cl...
✓ Được người mở chủ đề xác nhậnTuServerMU · 2019-03-17After 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-19WebEngine 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 1.2.0 shows a server time that is not in sync with the Windows server time.
1. Open includes/config/timezone.php. 2. Set the timezone that matches your game server. 3. Save and reload the site.
✓ Được người mở chủ đề xác nhậnRaGEZONE · 2019-05-09After the VPS (SQL) IP changed, a WebEngine CMS 1.2.4 site hosted on a separate Linux server shows 'Connection to database failed (MuOnline)' and the installer says the install is already complete.
1. Open includes/config/webengine.json and set "webengine_cms_installed": false, then upload it. 2. In the web host cPanel open PHP Selector and (re)enable pdo_dblib and pdo_sqlsrv. 3. Ru...
✓ Được người mở chủ đề xác nhậnRaGEZONE · 2024-02-16Installing WebEngine CMS 1.2.5 with the ODBC driver fails with '[ODBC SQL Server Driver] The data types varchar(max) and text are incompatible in the equal to operator'.
1. Do not use the old ODBC SQL Server driver for the install. 2. Install the Microsoft PHP SQLSRV / PDO_SQLSRV drivers that match your PHP version and enable them in php.ini. 3. Restart A...
✓ Đã xác nhận trong issueGitHub (lautaroangelico/WebEngine) · 2025-02-20WebEngine rankings, Castle Siege and guild pages stay empty
WebEngine fills rankings, Castle Siege and guild data with cron jobs. If the crons never ran, those pages stay empty even when the tables exist. 1. In the WebEngine admin panel open the c...
✓ Được người mở chủ đề xác nhậnTUServerMU · 2021-05-12Which website CMS expects which MU database columns (WebEngine table maps, DmN)
WebEngine 1.2.7 picks a table map by server files (includes/config): - igcn.tables.php / custom.tables.php: resets = Character.RESETS, grand resets = Character.GrandResets, VIP = T_VIPLis...
Not verifiedDo MuADMINS biên soạnWhat does the DmN CMS setup change in the MU database (columns, Character.id, WZ_CONNECT_MEMB) and what can break?
The DmN CMS 1.2.3 setup does more than create its own tables: 1. It ALTERs the game databases: adds columns from its version files, for example MEMB_INFO Admin, last_login, activated, act...
Not verifiedDo MuADMINS biên soạnHow do I set up WebEngine credits (WCoin, Goblin Points, web credits) for my server files?
WebEngine keeps each currency in a row of WEBENGINE_CREDITS_CONFIG: config_database, config_table, config_credits_col, config_user_col, config_user_col_id (userid, username or email), con...
Not verifiedDo MuADMINS biên soạnWebEngine register error "String or binary data would be truncated" (sno__numb is shorter than 13 characters)
WebEngine 1.2.7 fills MEMB_INFO.sno__numb with _defaultAccountSerial = '1111111111111' (13 characters, includes/classes/class.account.php line 16). The column size depends on the files: -...
Not verifiedDo MuADMINS biên soạnWebEngine: accounts made on the website cannot log in (password encryption must match memb__pwd)
WebEngine 1.2.7 has four password modes (install/definitions.php PDO_PWD_ENCRYPT) and writes MEMB_INFO differently for each: - none: memb__pwd = :password (plain), for varchar columns (IG...
Not verifiedDo MuADMINS biên soạnWhat 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 verifiedDo MuADMINS biên soạnI 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 verifiedDo MuADMINS biên soạnPlayers 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 verifiedDo MuADMINS biên soạnMuDevs: 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 verifiedDo MuADMINS biên soạnWebEngine with X-Team files: online ranking fails with Invalid column name 'OnlineHours'
WebEngine's map for X-Team files (includes\config\xteam.tables.php) defines _CLMN_MS_ONLINEHRS_ = OnlineHours, and the online ranking (only for xteam files) runs: SELECT TOP n memb___id,...
Not verifiedDo MuADMINS biên soạnHow 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 verifiedDo MuADMINS biên soạn