Community AlphaAlpha MUADMINS
ENEnglish
Sign in
On MuADMINSConfig ScannerDrop your files zip: rates, drops, spots, limitsOpenOn MuADMINSMeet us on DiscordAsk for help, share what you are building and talk MU with other server owners.Open

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

  1. Gameplay

    /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-15
  2. Website

    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 verifiedWritten by MuADMINS
  3. Server setupX-TeamS2, S15, S17, S18

    What 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 MuADMINS
  4. Server setup

    How 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-11
  5. Server setupWebZen 97d / 99b97d

    DarksTeam 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-15
  6. ToolsWebZen 97d / 99bS3

    main.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-17
  7. ToolsWebZen 97d / 99b

    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...

    ✓ Confirmed by the topic starterRaGEZONE · 2007-10-05
  8. ToolsWebZen 97d / 99bS3

    main.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-09
  9. ToolsWebZen 97d / 99b97d

    OllyDbg: 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-25
  10. Tools

    Pentium 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-07
  11. Tools

    MuMaker 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-30
  12. Server setupMuEmu / LouisSeason 6 (MuEmu update 22)

    New 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-20
  13. Server setupMuEmu / LouisSeason 6 (Louis)

    How 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-09
  14. GameplayMuEmu / LouisSeason 6 (MuEmu)

    MuEmu: 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-28
  15. Website97d+99i

    Characters 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-31
  16. Website

    DarksWeb 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-14
  17. Gameplay0.99.60T (1.0M)

    Devil 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-04
  18. ToolsMuEmu / LouisSeason 6

    Cash 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-10
  19. GameplayMuEmu / LouisSeason 8 Episode 3

    Louis 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-22
  20. GameplayMuEmu / LouisSeason 6 Episode 3

    MuEmu 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

MuADMINS Community Alpha: free and community made, in active development.