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.
50 solutions for “resets” · Clear
How do I reset a character with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files (ResetCount) with the server closed?
Columns: Character.ResetCount and MasterResetCount (X-Team also ResetDay, ResetWek, ResetMon and MasterResetDay / Wek / Mon for the daily, weekly and monthly limits). The server reads and...
Not verifiedWritten by MuADMINSHow do I reset a character with SQL on IGCN files (RESETS, GrandResets) with the server closed?
Columns in IGCN Character: RESETS (int, all seasons), GrandResets (tinyint, Season 16, 17, 18), GRANDRESET (Season 12), plus cLevel, Experience, LevelUpPoint and the stats. 1. Close the G...
Not verifiedWritten by MuADMINSReset Generator: how to make the SQL reset script and run it automatically with SQL Server Agent
1. Tick the options you want for a character reset (the settings of your server) and press Generate Reset. 2. The program writes the SQL code (script) of your reset system. 3. Copy it and...
MuMaker: how to fill the first configuration window (SQL user, local or remote, MD5, database names, reset column)
1. Extract MuMaker and start MuMaker.exe. 2. Type any name (server name or yours), the SQL user (sa by default) and its password. 3. Connection type: choose local when MuMaker runs on the...
With dynamic EXP by resets the Master Level EXP also changes. How do I control ML EXP separately?
1. Use ExperienceTable.txt, which has MinMasterLevel and MaxMasterLevel columns. 2. Add lines per ML range, for example 400 800 0 50 * * * * 24, then 51 100 with 20, and so on. 3. The rat...
✓ Confirmed by the topic starterCreandoMU · 2021-02-11Where 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 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 MuADMINSIGC.EssentialTools crashes after the first-run notice although SQL named pipes and TCP/IP are enabled (crash dump in CrashDumps)
1. Symptoms: the first-run notice pops up, then the tool crashes on every start; compatibility mode and run as admin do not help; a dump such as IGCN.EssentialTools.exe.5908.dmp appears i...
✓ Confirmed by the topic starterRaGEZONE · 2020-01-05Web JM final: rankings show nothing although the site works.
1. Check the procedure WZ_SetResetInfo in the MuOnline database (Louis emulator). 2. Fix it so resets are written where the site reads them. 3. Reload the rankings.
✓ Confirmed by the topic starterCreandoMU · 2020-08-11How to stop WebEngine from showing GM/admin characters in the level and reset rankings.
1. AdminCP > website settings > Module Manager > Rankings. 2. In 'Excluded Characters' add the admin character names separated by commas. 3. Save and wait for the next ranking cron run.
✓ Confirmed by the topic starterTuServerMU · 2020-06-15Which 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 verifiedWritten by MuADMINSLouis files: after testing the auction system no new auction starts (or it starts and ends at once).
1. A finished auction does not run again. 2. Back up the database, then run on MuOnline: DELETE FROM EventAuction and DELETE FROM EventAuctionReward. 3. Restart the GameServer to start ne...
✓ Confirmed by the topic starterCreandoMU · 2020-12-02SQL 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...
✓ Confirmed by the topic starterTUServerMU · 2021-03-30How do I set a new password for one account in SQL on IGCN files (plain, WZ_MD5 or md5 text)?
Use the form that matches PasswordEncryptType in IGCDS.ini and the memb__pwd column type. Keep the account offline and always use WHERE. - Type 0 (varchar(20)): UPDATE MEMB_INFO SET memb_...
Not verifiedWritten by MuADMINSMuMain: the macOS build fails with Homebrew LLVM 23: 'use of undeclared identifier malloc' in the spdlog bundled format.h
1. The macOS toolchain picks Homebrew LLVM when it is installed. With LLVM 23.1.1 the build stops with format.h:747:28: error: use of undeclared identifier 'malloc' (spdlog v1.15.3 bundle...
✓ Confirmed in the issueGitHub (sven-n/MuMain) · 2026-10-08MainInfo (Louis Update 13): how to remove the rank icons (Custom Rank User, patentes) shown over the characters
1. Open the main info config you use to generate the Main (Premium) and find the block Custom Rank User (Patentes). 2. Pick the mouse over type with RankUserType: 0 complete, 1 no stats,...
✓ Confirmed by the topic starterTUServerMU · 2018-12-160.97d: every item (even shop items) gets serial 00000000.
1. The trigger that creates item serials was deleted when the server was reset. 2. Recreate the serial trigger (run its script with the server off) and check the item serial counter is no...
✓ Confirmed by the topic starterImperyus Games Brasil · 2013-05-26IGCN Season 13 files: how to give new characters a starting amount of zen.
1. In SSMS run on MuOnline a query that creates an INSERT trigger on dbo.Character (named Bonus in the thread). 2. The trigger reads the new Name from INSERTED and runs UPDATE Character S...
✓ Confirmed by the topic starterTuServerMU · 2018-10-15Louis (MuEmu) server ran out of item serials: every new item gets serial FFFFFFFF and is flagged as a dupe.
1. Serials come from the stored procedure WZ_GetItemSerial, which increments ItemCount in table GameServerInfo for every created item (drops, bags, commands). 2. Edit that existing proced...
✓ Confirmed by the topic starterRaGEZONE · 2024-08-02What 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