MuADMINS
Решения
Короткие исправления частых проблем серверов, клиентов и сайтов MU Online, каждое с источником и датой. “Подтверждено” означает, что автор вопроса сообщил, что исправление сработало.
Решений: 85 по запросу “closes” · Сбросить
How to remove the master skill tree skills from every character at once (S6 Up15 GamingMaster files); DELETE MasterSkillTree did not remove them
The learned skills are stored in the MagicList column of the Character table. 1. Back up the database and close the server. 2. Run: USE MuOnline; UPDATE Character SET [MagicList] = CONVER...
✓ Подтверждено автором темыTUServerMU · 2021-05-09IGCN Season 12: DataServer says it cannot be run twice, though I start it only once
1. An earlier DataServer did not close properly and still runs hidden in the background. 2. Open Task Manager, find the DataServer process and end it (or simply restart the PC). 3. Start...
✓ Подтверждено автором темыRaGEZONE · 2019-02-22MuEmu S4: /post says 'could not find message 69' and fixing one message line breaks others.
1. Several lines in the message files had a dot outside the closing quotes. 2. Move the dots inside the quotes with the text. 3. Reload messages.
✓ Подтверждено автором темыTuServerMU · 2018-01-17Game freezes when you click outside the client window (Louis update 43)
1. Close the game. 2. Check that Settings.ini is in the client folder. In the topic starter's client it was missing. 3. Copy Settings.ini from the original client package of the same upda...
✓ Подтверждено автором темыTUServerMU · 2026-08-05Client disconnects right after choosing the server (server on a VPS)
The server list shows, so the ConnectServer port is open, but the client is dropped when it moves on to the GameServer: the GameServer port is closed somewhere. 1. Find the GameServer por...
✓ Подтверждено автором темыTUServerMU · 2023-09-16MuMaker: "MuMaker has stopped working" on Windows 7 although .NET Framework is installed
1. Check the Windows regional settings: open Region (Regional and Language Options) > Administrative > "Language for non-Unicode programs". 2. Here it was set to Japanese, which made MuMa...
✓ Подтверждено автором темыRaGEZONE · 2011-03-02How do I fix a vault (warehouse): forgotten vault password, or a broken vault that must be emptied safely?
Every MSSQL family we read has warehouse (AccountID, Items varbinary, Money, EndUseDate, pw ...); the Items size differs (IGCN S17 7680 bytes, MuDevs 6000, X-Team S17 4800, WebZen S2 1920...
Not verifiedНаписано MuADMINSUnicode (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 verifiedНаписано MuADMINSHow do I back up and restore MU databases: which ones, in which order, and moving to a new PC?
Back up every database of the server at the same moment (server closed), and restore them together: - IGCN: MuOnline, Me_MuOnline (if used), Events, Ranking, BattleCore - MuEmu, Louis, MS...
Not verifiedНаписано MuADMINSI changed a character, coins or a vault with SQL and the change disappeared (UPDATE while the server is on)
The running server keeps its own copy of every online character and account and writes it back to the database, so an UPDATE made while that player is online can be overwritten a moment l...
Not verifiedНаписано MuADMINSA character exists in the Character table but does not appear (AccountCharacter slots)
The character list of an account is kept in AccountCharacter (Id = account, GameID1 to GameID5, or to GameID10 on newer files, plus GameIDC). The packs' WZ_CreateCharacter writes the new...
Not verifiedНаписано 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 verifiedНаписано MuADMINSMuDevs Season 18: Invalid column name 'LastGateIndex' (the extra query of the pack)
The MuDevs Season 18 pack ships, next to the database scripts, a file Execute query.sql with one statement: ALTER TABLE dbo.Character ADD LastGateIndex [int] NOT NULL DEFAULT(-1); If the...
Not verifiedНаписано MuADMINSMSPro: the shipped query "Dar coin ganador gs" (WCoin for the Castle Siege winner) is broken
The file Tools - Querys Y Otros\Query-Sql\Dar coin ganador gs.txt has three problems: 1. Line 1 update CashShopData set WCoinC= WCoinC+1000 where AccountID in has nothing after IN (syntax...
Not verifiedНаписано 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 verifiedНаписано MuADMINSLouis / MuEmu Season 6: "Invalid column name" after updating the server files (which Update script adds which column)
Louis (JogandoMU) Season 6 files ship one SQL file per update. If the files are newer than the database, the server logs Invalid column name 'X'. Find X below and run that script (and the...
Not verifiedНаписано MuADMINSHow do I add WCoinC, WCoinP or Goblin Points with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files (CashShopData)?
The table is CashShopData (AccountID, WCoinC, WCoinP, GoblinPoint). 1. Account offline (best: server closed), backup first, look at the row: SELECT AccountID, WCoinC, WCoinP, GoblinPoint...
Not verifiedНаписано 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 verifiedНаписано 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 verifiedНаписано MuADMINSMU Online Web Editor: 'Node is not recognized' or 'File Not Found' when editing server drops, shops and monsters
1. Install Node.js 18 or newer first and restart the PC; without it you get *Node is not recognized*. 2. Run Start-Editor.bat and keep the black window open; the browser opens the dashboa...