MuADMINS
Çözümler
Yaygın MU Online sunucu, client ve web sitesi sorunları için kısa düzeltmeler; her biri kaynağı ve tarihiyle. “Onaylanmış”, soruyu soran kişinin düzeltmenin işe yaradığını söylediği anlamına gelir.
71 çözüm “php -q” için · Temizle
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...
✓ Konu sahibi tarafından onaylandıDarksTeam · 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...
✓ Sorun kaydında onaylandıGitHub (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...
✓ Konu sahibi tarafından onaylandıTuServerMU · 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.
✓ Konu sahibi tarafından onaylandıTuServerMU · 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.
✓ Konu sahibi tarafından onaylandıRaGEZONE · 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.
✓ Konu sahibi tarafından onaylandıRaGEZONE · 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...
✓ Konu sahibi tarafından onaylandıRaGEZONE · 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...
✓ Sorun kaydında onaylandıGitHub (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...
✓ Konu sahibi tarafından onaylandıTUServerMU · 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 verifiedMuADMINS tarafından yazıldıWhat 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 verifiedMuADMINS tarafından yazıldıHow 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 verifiedMuADMINS tarafından yazıldıWebEngine 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 verifiedMuADMINS tarafından yazıldıWebEngine: 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 verifiedMuADMINS tarafından yazıldı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 verifiedMuADMINS tarafından yazıldı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 verifiedMuADMINS tarafından yazıldı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 verifiedMuADMINS tarafından yazıldıMuDevs: 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 verifiedMuADMINS tarafından yazıldıWebEngine 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 verifiedMuADMINS tarafından yazıldı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 verifiedMuADMINS tarafından yazıldı