MuADMINS
Решения
Короткие исправления частых проблем серверов, клиентов и сайтов MU Online, каждое с источником и датой. “Подтверждено” означает, что автор вопроса сообщил, что исправление сработало.
Решений: 33 по запросу “memb_info” · Сбросить
Accounts registered on the website exist in MEMB_INFO, but the game says 'Your account is invalid'
1. Compare how the website stores passwords with what the JoinServer expects: look at the password column of the new accounts in MEMB_INFO. 2. If the website saves MD5 hashed passwords, e...
✓ Подтверждено автором темыRaGEZONE · 2026-04-05"Account does not exist" or the login fails although the account is in MEMB_INFO: what to check in the database
Check these in order (all read only, nothing changes): 1. Is the server reading the same database? MuEmu, Louis, MSPro, X-Team, MuDevs use the ODBC DSN in JoinServer.ini (JoinServerODBC =...
Not verifiedНаписано MuADMINSCzF Editor 1.5a: creating a new account gives an error although MD5 is disabled in the editor options
1. With MD5 off in the editor, the password column must be plain text, but in this database memb__pwd was still binary. 2. Open Enterprise Manager (or Management Studio) > Databases > MuO...
✓ Подтверждено автором темыRaGEZONE · 2007-10-05MuMaker: creating an account fails with "Disallowed implicit conversion from data type varchar to data type varbinary ... column 'memb_pwd'"
1. The error means MEMB_INFO.memb_pwd is a varbinary column: your database stores MD5 passwords. 2. Enable MD5 in the MuMaker settings and create the account again. 3. A reply also sugges...
✓ Подтверждено автором темыRaGEZONE · 2011-12-06Morpheus web install stops with error 47.
1. Back up the database first. 2. Delete the columns Credits, indocation and indicated from MEMB_INFO. 3. Run the Morpheus installer again.
✓ Подтверждено автором темыCreandoMU · 2020-08-08How 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...
✓ Подтверждено автором темыTUServerMU · 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...
✓ Подтверждено автором темыTUServerMU · 2020-07-23Replacing WZ_DISCONNECT_MEMB for MuCore gives 'Msg 468 ... Cannot resolve the collation conflict between Latin1_General_CS_AS and SQL_Latin1_General_CP1_CI_AS'
1. The procedure compares memb___id from MEMB_INFO with memb___id from MEMB_STAT, and the two columns use different collations. 2. In SQL Server Management Studio set the same collation o...
✓ Подтверждено автором темыRaGEZONE · 2015-11-30WebEngine 1.0.9 with IGCN tables: account registration fails.
1. Open the IGCN table definitions file of WebEngine. 2. Change define('_CLMN_SNONUMBER_', 'sno_numb'); to define('_CLMN_SNONUMBER_', 'sno__numb'); (two underscores, as in MEMB_INFO). 3....
✓ Подтверждено автором темыRaGEZONE · 2017-05-18WebEngine 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 verifiedНаписано MuADMINSHow do I turn MD5 passwords on or off (enable / disable) on IGCN files (PasswordEncryptType, memb__pwd)?
On IGCN files the password mode is chosen in the DataServer and the database column must be of the matching type. If they do not match, nobody can log in. 1. Close the whole server and ba...
Not verifiedНаписано MuADMINSCash 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...
Mu Launcher v1.3 (RJ launcher, harlcreeds): how to set the server IP, the patch link and the registration
1. Run rjdllcreator.exe and type your server IP: it builds rjconnect.dll, the connector the launcher uses. 2. Install a web server (WAMP www, XAMPP htdocs, nginx html) and copy the rjlaun...
MuWeb 0.8 registration says the account has been created, but it is not created
1. Run the MuWeb 0.8 installer again. 2. When it asks whether MD5 is on, choose off (it must match the server; these files do not use MD5). 3. Register a new account.
✓ Подтверждено автором темыDarksTeam · 2009-03-07SQL query to delete only characters and guilds but keep the accounts and their warehouse
1. Make a full backup of the database first. 2. In SQL Server Management Studio run: USE MuOnline; DELETE Character (characters). 3. For guilds run: DELETE Guild; DELETE GuildMember. 4. M...
✓ Подтверждено автором темыTUServerMU · 2021-03-30Creating a character fails with 'Nombre de personaje incorrecto o ya existe' after installing a SQL script that gives points and zen to new characters (MuEmu S6 EP3 Louis Update 13)
The new character script wrote to columns that do not exist in this database. 1. Open the script (trigger) you added in SQL Server Management Studio. 2. Compare its column names with your...
✓ Подтверждено автором темыTUServerMU · 2020-05-04Which 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 verifiedНаписано MuADMINSWhat 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 verifiedНаписано MuADMINSWebEngine: 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 verifiedНаписано MuADMINSUnicode (NVARCHAR) migration of a MuEmu / Louis Season 6 database: what is right and what breaks
Review of a Season 6 Unicode script set (a migration that converts the name columns to NVARCHAR plus new WZ_CreateCharacter, WZ_DeleteCharacter, WZ_CreateGuild procedures). Its table list...
Not verifiedНаписано MuADMINS