MuADMINS
Решения
Короткие исправления частых проблем серверов, клиентов и сайтов MU Online, каждое с источником и датой. “Подтверждено” означает, что автор вопроса сообщил, что исправление сработало.
Решений: 42 по запросу “account created” · Сбросить
CzF 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-06Titan 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)...
✓ Подтверждено автором темыRaGEZONE · 2013-09-25Anyone can log in with a random account name and password, and the login creates that account in SQL
1. This is not a database bug: the server has automatic account registration switched on, so an unknown login is created on the spot. 2. Open the JoinServer config (in some files the opti...
✓ Подтверждено автором темыRaGEZONE · 2021-04-15IGCN: players cannot create Summoner, Rage Fighter or other card classes (AccountCharacter flags)
IGCN stores the class unlocks per account in AccountCharacter. Season 17 has the flags Summoner, RageFighter, GrowLancer, MagicGladiator, DarkLord, RuneWizard, Slayer, GunCrusher, LightWi...
Not verifiedНаписано MuADMINSWebsite registration says "Your Account Has Been Created Successfully" but nothing is saved in the database
The fix given: add the MD5 extension to SQL Server and install the site with MD5 on. 1. Copy the MD5 dll for SQL Server (shared in the thread) into the MSSQL\Binn folder of SQL Server. 2....
✓ Подтверждено автором темыDarksTeam · 2008-11-28MuWeb 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-07IGC.EssentialTools: creating an account fails with "Could not find stored procedure master.dbo.XP_MD5_EncodeKeyVal"
1. The tool hashes the password with the MD5 extended procedure, which is not installed in your SQL Server. 2. Install the MD5 procedure for your SQL Server: the fix in the thread is the...
✓ Подтверждено автором темыRaGEZONE · 2018-10-21OpenMU admin panel: how do I make an account a game master or ban a player?
1. Open Accounts (/accounts) and search the login name. 2. Click Edit and set the state: GameMaster (or GameMasterInvisible) unlocks the game master chat commands; Banned or TemporarilyBa...
Accounts created on the website get VIP months instead of days (Morpheus web).
1. The SQL login used by the site had its language changed to Portuguese, which changes the date format. 2. Set the default language of that SQL login back to English (us_english). 3. Cre...
✓ Подтверждено автором темыCreandoMU · 2021-04-12Accounts 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...
✓ Подтверждено автором темыDarksTeam · 2008-11-25DarkMaster Season 3 Episode 1: every login says the account is invalid, although all IPs are changed
The JoinServer password mode (MD5 or plain) did not match how the accounts were created. 1. Delete the test accounts. 2. Put the JoinServer build with MD5 enabled and create the account a...
✓ Подтверждено автором темыDarksTeam · 2010-03-09A character exists in the Character table but does not appear (AccountCharacter slots)
The character list of an account is kept in AccountCharacter (Id = account, GameID1 to GameID5, or to GameID10 on newer files, plus GameIDC). The packs' WZ_CreateCharacter writes the new...
Not verifiedНаписано MuADMINS"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Написано MuADMINSWhere are accounts, VIP, credits, resets and bans in the DV-Team Season 19 database (MySQL / MariaDB)?
DV-Team does not use SQL Server: the database is a MySQL / MariaDB dump (Navicat), databases muonline (127 tables) and log (22 tables). There is no MEMB_INFO and no stored procedure, so S...
Not verifiedНаписано MuADMINSWhat are the MSPro database settings (ODBC, MD5Encryption, DisconnectOnlineAccount) and the update queries?
MSPro files connect through the ODBC DSN named MuOnline: - JoinServer\JoinServer.ini: JoinServerODBC = MuOnline, CaseSensitive = 0, MD5Encryption = 0, MaxIPLimit = 0, MaxHwIDLimit = 0, Di...
Not verifiedНаписано MuADMINSHow do I add WCoin or Goblin Points to an account with a SQL query on IGCN files?
The table is T_InGameShop_Point, but the columns changed between seasons: - Season 9 and 12: AccountID, WCoinC, WCoinP, GoblinPoint (float) - Season 16, 17, 18: AccountID, WCoin, GoblinPo...
Not verifiedНаписано MuADMINSWhy did IGCN CreateDatabase.sql delete my databases, and what must I change before running it?
Database\1. Full Scripts\CreateDatabase.sql starts with two switches: - DECLARE @DropExistingDatabases INT = 1: with 1 it DROPS existing databases named Me_MuOnline, MuOnline, Events, Ran...
Not verifiedНаписано MuADMINSOpenMU admin panel: the Setup page says 'Can't connect to the database, probably not created yet' or 'Update required'
1. Open Setup (/setup). It shows the state of the database. 2. *Can't connect to the database, probably not created yet* or *Not created*: click Create, pick the game version (Season 6 Ep...
After restoring an old backup, characters with the same name can be created on different accounts.
1. The name primary key was lost. 2. Delete the duplicated rows one by one. 3. Restore the primary key before allowing new characters.
✓ Подтверждено автором темыImperyus Games Brasil · 2010-12-17

