MuADMINS
Решения
Короткие исправления частых проблем серверов, клиентов и сайтов MU Online, каждое с источником и датой. “Подтверждено” означает, что автор вопроса сообщил, что исправление сработало.
Решений: 15 по запросу “delete” в категории «Настройка сервера» · Сбросить
SQL 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...
✓ Подтверждено автором темыTUServerMU · 2021-03-30Louis 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...
✓ Подтверждено автором темыCreandoMU · 2020-12-02How 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-09Why 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 verifiedНаписано MuADMINSOpenMU: after a restart all my configuration and data were gone and the database was initialized again.
1. With Docker the Postgres data must live in a volume. 2. The provided docker-compose files persist it in volumes, so the data was lost because the volumes were deleted or the setup did...
✓ Подтверждено в issueGitHub (MUnique/OpenMU) · 2023-11-11After restoring an old backup, characters with the same name can be created on different accounts.
1. The name primary key was lost. 2. Delete the duplicated rows one by one. 3. Restore the primary key before allowing new characters.
✓ Подтверждено автором темыImperyus Games Brasil · 2010-12-170.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...
✓ Подтверждено автором темыImperyus Games Brasil · 2013-05-26DarkMaster Season 3 Episode 1: every login says the account is invalid, although all IPs are changed
The JoinServer password mode (MD5 or plain) did not match how the accounts were created. 1. Delete the test accounts. 2. Put the JoinServer build with MD5 enabled and create the account a...
✓ Подтверждено автором темыDarksTeam · 2010-03-09After changing the client name in the main info and replacing Main.premium, the login box (ID and password) no longer appears (files with MHP)
The Mu Hack Protection server config still had the old customer name. 1. Open C:\MuServer\MHPServer\MHPServer.ini and set CustomerName to the new name, with the right ClientVersion and Cl...
✓ Подтверждено автором темыTUServerMU · 2021-03-27DataServer 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...
✓ Подтверждено автором темыRaGEZONE · 2018-04-09Two MuEmu S8 servers on one machine: the first works, the second disconnects at login although its ports (55902, 55920, 55961, 55971) are forwarded.
1. Open the router page and check that the forwarding rules for the second server ports are really enabled, not only created. 2. If a rule turns itself off again after a refresh, delete i...
✓ Подтверждено автором темыTuServerMU · 2020-06-17MuEmu S6 DataServer and JoinServer show "Could not connect to database" on SQL 2008 R2 even after renaming MuOnlineS6 to MuOnline. What fixed it?
1. In the DataServer and JoinServer config files make sure the database name is the one you restored (MuOnline, not MuOnlineS6). 2. Delete the old or duplicate MuOnline DSNs and create th...
✓ Подтверждено автором темыTuServerMU · 2018-06-06Unicode (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Написано 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 verifiedНаписано MuADMINSOpenMU in Docker: how do I back up and restore the PostgreSQL database, and fix 'permission denied for schema config' after a restore?
1. The openmu-db-backup container of nolt/openmu-docker runs pg_dump -Fc every BACKUP_INTERVAL seconds (default 86400), checks the dump and keeps gzipped files in ./backups/ for RETENTION...
Видео на MUTube
КАК УБРАТЬ ЛАГИ FPS В MUONLINE - ОКОНЧАТЕЛЬНОЕ РЕШЕНИЕ - ТЕСТОВАЯ СТАДИЯ
Gui PvP · 8:52 · 2024
Mu Online Туториал 26: как снять бонусную опцию с socket предмета?
NaQuEvEr · 7:52 · 2025
Как УБРАТЬ ЛАГИ в MU Online * Без программ* #muonline #antilag #mmorpgs
JeongGuwonYT · 7:07 · 2020
Удаление/смена логотипа Print Screen в эмуляторе MuOnline
Josue Ochoa · 22:36 · 2022