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
How do I give VIP (AccountLevel) to an account with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files?
In MuEmu based files VIP is MEMB_INFO.AccountLevel (0 = normal, the AL1 / AL2 / AL3 levels of your configs) with MEMB_INFO.AccountExpireDate. Use the shipped procedure, account offline: E...
Not verifiedWritten by MuADMINSHow do I turn MD5 on (MD5Encryption in JoinServer.ini) on MuEmu, Louis, MSPro, X-Team or MuDevs files, and what does the database need?
In MuEmu based files the switch is JoinServer\JoinServer.ini, MD5Encryption = 0/1 (next to CaseSensitive = 0). Every pack we read ships 0. What the databases have: - X-Team Season 2 and 1...
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 MuADMINSHow do I make a character Game Master (GM) or Administrator on IGCN files (CtlCode)?
On IGCN files the GM rights are on the character: Character.CtlCode (tinyint, default 0). - The IGCN command documentation says GM commands such as /item and /spawn "require Administrator...
Not verifiedWritten by MuADMINSHow do I give or extend VIP for an account with SQL on IGCN files (IGC_VipAdd, T_VIPList)?
IGCN keeps the active VIP in T_VIPList (AccountID, Date, Type); MEMB_INFO also has VipType, VipStart, VipDays. The shipped procedure is IGC_VipAdd @szCharName, @DayAdd, @VipType. Despite...
Not verifiedWritten by MuADMINSHow do I add WCoin or Goblin Points to an account with a SQL query on IGCN files?
The table is T_InGameShop_Point, but the columns changed between seasons: - Season 9 and 12: AccountID, WCoinC, WCoinP, GoblinPoint (float) - Season 16, 17, 18: AccountID, WCoin, GoblinPo...
Not verifiedWritten by MuADMINSWhich databases do IGCN files need (MuOnline, Me_MuOnline, Events, Ranking, BattleCore) and in which order do the update scripts run?
IGCN files use up to five databases: - MuOnline: accounts (MEMB_INFO, MEMB_STAT), characters, guilds, warehouse, cash shop (T_InGameShop_Point), VIP (T_VIPList). - Me_MuOnline: optional s...
Not verifiedWritten by MuADMINSWhy did IGCN CreateDatabase.sql delete my databases, and what must I change before running it?
Database\1. Full Scripts\CreateDatabase.sql starts with two switches: - DECLARE @DropExistingDatabases INT = 1: with 1 it DROPS existing databases named Me_MuOnline, MuOnline, Events, Ran...
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 MuADMINSMuEmu MainInfo: how to set the color of a custom item in CustomItem.txt (RGB values)
1. Open ToolsX603\MAIN_INFO\CustomItem.txt of your MuEmu tools. 2. Find the line of your custom item: only the 3 color boxes (R, G, B) need to change. 3. Pick the color you want in any RG...
IGC Dashboard: how to install the web part (Defines.php URL_DEFAULT and SUB_DIRECTORY) before the license activation
1. Upload the content of the Web folder to your web hosting, best in its own folder such as dashboard (or point a subdomain to it). 2. Open Defines.php and set URL_DEFAULT to the web addr...
DTweb 2.0 (MuOnline CMS for all seasons): how do I install it and log into its admin panel the first time?
1. Run Script.sql in your SQL query analyzer on the server database. 2. Put the website in the main web directory, not in a subfolder: some files use the document root and images or inclu...
MuADMINS rewrite of the sourceNot verifiedGitHub (r00tmebaby/DT-Web-2.0-MuOnline-CMS-All-Seasons) · 2019-04-12WebEngine CMS with X-Team files: give credits to accounts that never logged into the game (CashShopData)
1. X-Team files keep the cash in CashShopData. An account without a row there cannot receive credits through the WebEngine credit system. 2. Open /modules/usercp.php. 3. Replace its code...
MU DB Helper: how do I install the item, inventory and vault database editor for Ex702 and newer servers?
1. Requirements: Visual Studio 2013, SQL Server 2012 or newer, ODBC Driver 13 and a MU Online Ex702+ database. 2. Clone the repository and make sure a MuOnline database exists (CREATE DAT...
MuMain Launcher: 'Could not download the patch manifest' (version.json) when the launcher checks for updates
1. On Linux run the native launcher directly (./MumainLauncher), not with wine: .NET networking fails under Wine with GetAddrInfoExW … Unsupported. 2. Check the ManifestUrl baked into the...
MuMain-translator: how do I translate the MuMain client UI strings and item names into a new language?
1. Get what to translate: a MuMain checkout (UI strings in src/Localization/*.resx plus item names) or a game folder (item names in Data/Items only). 2. Run the tool: the release zip (MuM...
MuMain: how do I draw a monster from a .glb (glTF 2.0) model instead of its BMD?
1. Put the .glb file under Data/, for example Data/Monster/Monster14.glb. 2. Add an entry to src/bin/Data/Models/ModelFiles.json: model (the monster model name, for example MODEL_ELITE_YE...
OpenMU admin panel: how do I kick a player or stop an offline session that keeps a personal store open?
1. Open Online accounts (/logged-in). 2. The first table lists every logged-in account with its server id: Disconnect closes that connection. 3. The second table lists offline sessions, c...
BeastMaker admin tool: how to set up the SQL connection and the allowed user (and SQL 2000 without "Edit Top 200 Rows")
1. Run the table script from the release post to create the BeastMaker table (columns BeastMaker_Allowed, BeastMaker_Logs) in the MuOnline database. 2. Add your allowed entry {"YOURNAME":...
Pentium Tools 1.06: which client files it edits and converts (Text, Gate, MoveReq, OZJ/OZT, bmd to smd)
1. Table editors for Text.bmd (also Unicode TextW.bmd), Gate.bmd and MoveReq.bmd from Season 1 to Season 4 clients, with find, replace, filter, sort, undo and a compare mode that highligh...