MuADMINS
Solutions
Short fixes for common MU Online server, client and website problems, each with its source and date. “Confirmed” means the person who asked said the fix worked.
103 solutions for “tables” · Clear
/reset always costs 100 million Zen no matter what is set in the command config.
1. Open MuServer\Data\Util\ResetTable.txt. 2. Set Money_AL0 to Money_AL3 to the wanted cost per account level. 3. Reload.
✓ Confirmed by the topic starterTuServerMU · 2019-07-15What 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 verifiedWritten by MuADMINSWhat is in the X-Team MuOnline database (password column, VIP, coins, resets, gens, master level)?
X-Team uses one database, MuOnline, with the MuEmu procedure set. - Accounts: MEMB_INFO.memb__pwd varchar(10) (plain; no MD5 function in the scripts), sno__numb char(18), AccountLevel / A...
Not verifiedWritten by MuADMINSHow to protect Game Master characters (give them the protected GM status)
The GM status is the CtlCode column of the character. 1. Open the MuOnline database in SQL Server. 2. Run UPDATE Character SET CtlCode = '8' WHERE Name='<GM name>' (the asker confirmed 8...
✓ Confirmed by the topic starterDarksTeam · 2012-05-11DarksTeam 97d: accounts created on the web show NULL columns in the database and characters do not show up properly. How to fix it?
1. Back up the MuOnline database first. 2. Open a new query on MuOnline in SQL Server Management Studio. 3. Run: UPDATE Character SET CtlCode = 0 WHERE CtlCode IS NULL 4. Restart the serv...
✓ Confirmed by the topic starterTuServerMU · 2018-10-15main.exe 1.03K: the cash shop window text looks broken on Windows XP SP3 (fine on Vista and 7)
1. Open main.exe (1.03K) in OllyDbg and go to offset 0079CFF4. 2. There you see MOV DWORD PTR SS:[EBP-1F0],1F4: change it to MOV DWORD PTR SS:[EBP-1F0],190. 3. Copy the change to the exec...
✓ Confirmed by the topic starterRaGEZONE · 2011-09-17CzF 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...
✓ Confirmed by the topic starterRaGEZONE · 2007-10-05main.exe 1.03K JPN: how to make the main open only through the launcher (mu.exe) with OllyDbg
1. Open main.exe (1.03K JPN) in OllyDbg and find the mu.exe check (search the referenced text strings for mu.exe). 2. At 005FA1DF there is EB 55 JMP SHORT main.005FA236, just before the P...
✓ Confirmed by the topic starterRaGEZONE · 2011-09-09OllyDbg: how to give a 97d+99i main.exe a widescreen resolution (for example 1366x768)
1. You need OllyDbg and an unpacked 97d+99i main.exe. 2. Open main.exe in OllyDbg, right click > Search for > All referenced text strings, find Resolution and double click it. 3. Below it...
✓ Confirmed by the topic starterDarksTeam · 2019-05-25Pentium Tools: converting SMD back to BMD skips the texture (the model has no texture in game)
1. A BMD model does not pack the texture: converting gives the model and animation SMD files plus a separate texture, and the converter only rebuilds the SMD files (do not put the texture...
✓ Confirmed by the topic starterRaGEZONE · 2016-08-07MuMaker 1.13: "Format of the initialization string does not conform to specification starting at index 30" when connecting to SQL
1. Check that SQL Server has TCP/IP enabled on port 1433 and that port 1433 is allowed in the Windows firewall; check the ODBC source and the MuMaker config. 2. Make sure .NET Framework 3...
✓ Confirmed by the topic starterRaGEZONE · 2025-04-30New characters show 65535 kills and deaths.
1. Fix existing ones: UPDATE dbo.Character SET Kills=0 WHERE Kills=65535 and the same for Deads. 2. In SSMS design the Character table and set the Default Value of Kills and Deads to 0. 3...
✓ Confirmed by the topic starterCreandoMU · 2020-08-20How do I make a working online time ranking per character?
1. Add an int column OnlineTime to the Character table (back up first). 2. Create a SQL Agent job every minute: UPDATE Character SET OnlineTime=OnlineTime+1 joined to MEMB_STAT (ConnectSt...
✓ Confirmed by the topic starterCreandoMU · 2021-03-09MuEmu: how do I set Castle Siege so registration opens by itself on Monday and the siege runs on Sunday?
1. Edit GameServerCS/Data/Event/MuCastleData.dat: state 7 sets the siege day and start hour, state 8 sets the end hour. 2. In GameServerCS/Data/GameServerInfo - Event.dat set CastleSiegeE...
✓ Confirmed by the topic starterCreandoMU · 2020-09-28Characters stop at level 350 (max level) but the website reset asks for level 400 (97d+99i)
On 97d+99i the max level cannot be raised, so lower the reset level on the website instead. 1. Open SQL Server Enterprise Manager > MuOnline > Tables. 2. Find the MuWeb table, right click...
✓ Confirmed by the topic starterDarksTeam · 2009-10-31DarksWeb 0.1: the news cannot be deleted from the site admin
The news and admin data of DarksWeb are stored in the database, not in the PHP files. 1. Open SQL Server and go to Databases > MuOnline > table MuWeb_admin. 2. Edit or delete the news row...
✓ Confirmed by the topic starterDarksTeam · 2011-04-14Devil Square 5 and 6 open but no monsters spawn and no countdown is shown (DarksTeam MuServer 0.99.60T)
The Devil Square timetable (DevilSquare.dat) was fine; the edited MonsterSetBase.txt was the cause. 1. Put back the original MonsterSetBase.txt that came with the server files. 2. Restart...
✓ Confirmed by the topic starterDarksTeam · 2015-01-04Cash Editor gives an error when editing credits, although the SQL user and password are set
The cash table and column names in the editor config were wrong. 1. Open the editor config file (XTRMu in the thread). 2. [SQLConnection]: SQLHost = (local), SQLUser = your SQL user, SQLP...
✓ Confirmed by the topic starterTUServerMU · 2020-07-10Louis MuEmu S8 E3: Crywolf stays empty (no NPCs or monsters) although the event is on and the CS MonsterSetBase is complete
The Crywolf event config itself was incomplete. 1. Open the Crywolf event config of GameServerCS. 2. Compare it with a complete one (the asker copied it again from a forum post): section...
✓ Confirmed by the topic starterTUServerMU · 2020-11-22MuEmu S6 E3 Castle Siege: when the battle starts the defending guild shows as attacker, with no config change
The Castle Siege data stored in SQL had gone bad. 1. Back up the database first. 2. The asker cleared the SQL tables used by Castle Siege (in MuEmu databases they are the MuCastle_ tables...
✓ Confirmed by the topic starterTUServerMU · 2020-11-15