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.

67 solutions for “stats” · Clear

  1. Server setupMuEmu / LouisSeason 6 (Louis free)

    Items ask for more stats than shown and only equip after relogging (Louis free S6).

    1. Louis first advice: item.bmd (client) and Item.txt (server) must match. 2. Here the asker had changed the starting stats of the classes directly in the database, which caused the confl...

    ✓ Confirmed by the topic starterCreandoMU · 2021-08-31
  2. Website

    DarksWeb 0.3: the Statistics page shows only the header

    The page layout breaks because a table is not closed. 1. Open modules/statistics.php. 2. Add </table> at the very bottom of the file. 3. Save and reload the page.

    ✓ Confirmed by the topic starterDarksTeam · 2010-05-19
  3. Gameplay

    The Blood Castle crystal statue status is not visible, so players cannot finish the event.

    1. Check the Blood Castle monster settings and MonsterSetBase. 2. Add the statue (crystal) monster id for each Blood Castle level if it is missing. 3. Restart and run the event.

    ✓ Confirmed by the topic starterRaGEZONE · 2019-07-18
  4. Server setup

    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 verifiedWritten by MuADMINS
  5. Server setupMuDevsS18, S20

    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 verifiedWritten by MuADMINS
  6. GameplayMuEmu / LouisSeason 6 Episode 3 (Louis update 27)

    Louis S6E3 update 27: how do I make /reset keep the stats and give extra points each reset?

    1. Open Command.dat (see the Louis guide jogandomu.com.br/louisup27/#commanddat). 2. Set CommandResetType = 1. 3. Restart the GameServer and test /reset.

    ✓ Confirmed by the topic starterCreandoMU · 2021-12-16
  7. GameplayMuEmu / LouisSeason 6 (Louis update 19)

    Louis S6 Up19: how do I disable the stats/rank box shown when pointing at a character?

    1. Open GameServer/Data/GameServerInfo - Custom.txt. 2. Find the Custom RankUser settings and set CustomRankUserSwitch to 0. 3. Restart the GameServer.

    ✓ Confirmed by the topic starterCreandoMU · 2023-02-08
  8. GameplayMuEmu / LouisSeason 6

    MuEmu: doing /reset in Loren Deep wipes the stats, while a reset in other maps works normally

    Loren Deep is served by GameServerCS, not by the normal GameServer, so the CS reset settings apply there. 1. Open the reset command settings of GameServerCS. 2. Copy the reset options exa...

    ✓ Confirmed by the topic starterTUServerMU · 2020-08-17
  9. GameplayMuEmu / LouisSeason 6

    MuEmu S6: how to set how many stat points a character gets on each /reset (wanted 500 points per reset)

    The points per reset are set in the reset command block of the GameServer command file, not in Common. 1. Open MuServer\GameServer\DATA\GameServerInfo - Command.txt and find the Reset Com...

    ✓ Confirmed by the topic starterTUServerMU · 2016-11-13
  10. Server setupIGCNS9

    IGCN S9 E2 repack: DataServer says 'Login failed for user ...' (SQLSTATE 28000) and 'DATA SERVER CANNOT CONNECT TO MSSQL'

    1. The repack DataServer config came with a SQL login that does not exist on your SQL Server (here a random name like D2a78Rtko0), so the login fails. 2. Open the database settings of the...

    ✓ Confirmed by the topic starterRaGEZONE · 2019-07-14
  11. Server setupMuEmu / LouisS4

    DataServer floods '[QueryManager] State (24000) ... [ODBC SQL Server Driver] Invalid' when a character gets PK status (MuEmu S4 with the Ferrarezi website)

    1. The cause was not ODBC: the Ferrarezi website adds a trigger Z_PK_HERO on dbo.Character that fires when PkCount changes, and its old version broke the DataServer queries. 2. In SQL Ser...

    ✓ Confirmed by the topic starterRaGEZONE · 2018-04-09
  12. Server setupany

    "Login failed for user 'sa'" (SQLSTATE 28000) from DataServer or the web right after installing SQL Server. How do I enable sa?

    1. If setup used Windows authentication only, sa is disabled. 2. In Management Studio right click the server > Properties > Security and pick SQL Server and Windows Authentication mode. 3...

    MuADMINS rewrite of the sourceNot verifiedMicrosoft Learn · 2025-08-26
  13. GameplayIGCNS12

    Lowering the stat limit from 65000 to 32000 with a SQL query on IGCN-based S12 files does not work in game.

    1. No SQL query is needed. 2. Edit MuServer/IGCData/IGC_PlayerInfo.xml and change the Max values per class (MaxStrenghtDW, MaxAgilityDW, MaxVitalityDW, MaxEnergyDW, MaxCommandDW and the s...

    ✓ Confirmed by the topic starterTuServerMU · 2018-08-22
  14. Tools

    Zyth3 Launcher: the server status check always shows the server offline

    1. In the launcher config put the server address as yourdomain.com or a plain IP like 123.101.12.102. 2. Do not write it as a web address like http://domain.com. 3. If your ConnectServer...

    MuADMINS rewrite of the sourceNot verifiedRaGEZONE · 2015-03-13
  15. Gameplay1.0L

    1.0L server: a Blade Knight with max stats starts Twisting Slash, then the animation stops as if the attack speed is too high

    The attack speed limits in the GameServer config are too low for high stats. 1. Open commonserver.cfg. 2. Set the speed block like the answer: AttackSpeedTimeLimit = 2300, IsIgnorePacketH...

    ✓ Confirmed by the topic starterDarksTeam · 2008-12-31
  16. 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
  17. Server setup

    Characters do not save and the DataServer log shows State (42S22)

    SQL state 42S22 means a column was not found: the server files query a column your database does not have, so the save fails. 1. Open the DataServer log and read which table and column th...

    ✓ Confirmed by the topic starterTUServerMU · 2021-03-24
  18. 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
  19. Server setup

    The website always shows 2 players online even when the server is off

    Stale rows in MEMB_STAT still say the accounts are connected. 1. Open Query Analyzer / SSMS on the MuOnline database. 2. Run UPDATE MEMB_STAT SET ConnectStat='0' WHERE ConnectStat>0. 3. R...

    ✓ Confirmed by the topic starterDarksTeam · 2009-03-03
  20. Gameplay

    Where to set how many stat points a character gets per level

    In these files it is not in CommonServer.cfg but in the GameServer folder. 1. Open D:\MuServer\GameServer\CTGSSet.ini. 2. Set MagSword= (points for DL and MG), Level220Down= (DW, DK, Elf...

    ✓ Confirmed by the topic starterDarksTeam · 2009-04-04

Videos on MUTube

More videos for “stats”

Still stuck? Ask the MU Assistant Search MuGPS

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