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.
14 solutions for “reset” in Server setup · Clear
How do I give GoblinPoints each time a character resets (Season 6 MuEmu)?
1. In SSMS edit the procedure WZ_SetResetInfo. 2. Below the line that starts with UPDATE Character add UPDATE CashShopData SET GoblinPoint=GoblinPoint+100 WHERE AccountID=@Account. 3. Exe...
✓ Confirmed by the topic starterCreandoMU · 2021-01-21How 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 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 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 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 MuADMINS0.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-26Louis (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-02Unicode (NVARCHAR) migration of a MuEmu / Louis Season 6 database: what is right and what breaks
Review of a Season 6 Unicode script set (a migration that converts the name columns to NVARCHAR plus new WZ_CreateCharacter, WZ_DeleteCharacter, WZ_CreateGuild procedures). Its table list...
Not verifiedWritten by MuADMINSPlayers 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 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 verifiedWritten by MuADMINSHow do I turn MD5 passwords on or off (enable / disable) on IGCN files (PasswordEncryptType, memb__pwd)?
On IGCN files the password mode is chosen in the DataServer and the database column must be of the matching type. If they do not match, nobody can log in. 1. Close the whole server and ba...
Not verifiedWritten by MuADMINS
Videos on MUTube
Configuring xp, drop and reset MuOnline
Zonya_- · 11:41 · 2017
MU Online Season 21 — Sleep Later. Reset Nov 15 | LIGAMU PRO
LIGAMU PRO · :40 · 2026
Mu Online Season 21 Just Launched | No Reset Server | Are You Ready?
MuDrX · :43 · 2026
ZenMU.vn - Open Beta 24.05.2026 - Mu Online PC Non Reset
Zen Mu Việt Nam · :31 · 2026