Community AlphaAlpha MUADMINS
RUРусский
Войти
На MuADMINSConfig ScannerЗагрузите zip своих файлов: рейты, дропы, споты, лимитыОткрытьНа MuADMINSПрисоединяйтесь к нам в DiscordПросите помощи, показывайте свои проекты и общайтесь о MU с другими владельцами серверов.Открыть

MuADMINS

Решения

Короткие исправления частых проблем серверов, клиентов и сайтов MU Online, каждое с источником и датой. “Подтверждено” означает, что автор вопроса сообщил, что исправление сработало.

Решений: 45 по запросу “backup” · Сбросить

  1. Настройка сервераMuEmu / LouisS6

    Unicode (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Написано MuADMINS
  2. Настройка сервера

    I 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Написано MuADMINS
  3. Настройка сервера

    Could not find stored procedure 'WZ_CONNECT_MEMB' (or WZ_DISCONNECT_MEMB): what they do and how to restore them

    WZ_CONNECT_MEMB and WZ_DISCONNECT_MEMB keep MEMB_STAT up to date (ConnectStat 1 at login, 0 at logout). They must exist in the database the JoinServer / DataServer connects to: - IGCN: in...

    Not verifiedНаписано MuADMINS
  4. Настройка сервера

    Players 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 verifiedНаписано MuADMINS
  5. Настройка сервераWebZen 97d / 99bS2, S3

    How do I set a new password for one account on a WebZen Season 2 / 3 MD5 database (SP_MD5_ENCODE_VALUE)?

    The Season 3 mumatrix and Season 2 namech databases ship SP_MD5_ENCODE_VALUE @btInStr VARCHAR(10), @btInStrIndex VARCHAR(10) ("Created By WebZen, Adapted By [CzF]Deathway" in the Season 3...

    Not verifiedНаписано MuADMINS
  6. Настройка сервераWebZen 97d / 99b97d, 99b, S2, S3

    Which databases and procedures do WebZen 97d, Season 2 and Season 3 files use?

    - 97d (RaGEZONE pack): MuOnline.bak and Ranking.bak, SQL Server 2000 backups (restore them on 2005, 2008 or 2008 R2 first: 2012 and newer cannot restore a SQL 2000 backup). WZ_CONNECT_MEM...

    Not verifiedНаписано MuADMINS
  7. Настройка сервераDV-TeamS19

    Where 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Написано MuADMINS
  8. Настройка сервераMuDevsS18

    MuDevs 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Написано MuADMINS
  9. СайтX-TeamS2, S17

    WebEngine with X-Team files: online ranking fails with Invalid column name 'OnlineHours'

    WebEngine's map for X-Team files (includes\config\xteam.tables.php) defines _CLMN_MS_ONLINEHRS_ = OnlineHours, and the online ranking (only for xteam files) runs: SELECT TOP n memb___id,...

    Not verifiedНаписано MuADMINS
  10. Настройка сервераMSProS2, S3, S6

    MSPro: 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Написано MuADMINS
  11. Настройка сервераMSProS2, S3, S6

    What 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Написано MuADMINS
  12. Настройка сервераMuEmu / LouisS6

    Louis / 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Написано MuADMINS
  13. Настройка сервераMuEmu / LouisS6

    How do I ban and unban accounts or characters with an end date on Louis / MuEmu Season 6 files (bloc_code, CtlCode, Bloc_Expire)?

    Louis Season 6 Update 11 added the ban columns: MEMB_INFO.Bloc_Expire and Character.Bloc_Expire (smalldatetime). The procedure WZ_DesblocAccount @Account lifts a block only when it expire...

    Not verifiedНаписано MuADMINS
  14. Настройка сервераS6, S16, S17, S18, S20

    How 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Написано MuADMINS
  15. Настройка сервераS2, S6, S16, S17, S18, S20

    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 verifiedНаписано MuADMINS
  16. Настройка сервераS6, S16

    How 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 verifiedНаписано MuADMINS
  17. Настройка сервераIGCNS9, S12, S16, S17, S18

    How 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Написано MuADMINS
  18. ИнструментыДругие файлы

    MU Monster + Spawn Editor: how do I edit Monster.txt, MonsterList.xml and MonsterSpawn.xml together?

    1. Install Python 3.10+ on Windows, open CMD in the script folder and run python mu_monster_editor.py. 2. Click Open Monster Folder... and select the folder that holds Monster.txt, Monste...

    Пересказ источника от MuADMINSNot verifiedGitHub (CParaschivDev/Phantasm-LTP-Monster-Editor) · 2026-02-27
  19. ИнструментыWebZen 97d / 99b97d

    SkynetMU Full Option Cleaner: how do I find and remove full excellent items from warehouses and inventories of a 97/97D SQL database?

    1. Install Python 3.11 or 3.12 on Windows, then run py -m pip install -r requirements.txt and py SkynetMU_FullOption_Cleaner.py. 2. For ODBC install Microsoft ODBC Driver 17 or 18 for SQL...

    Пересказ источника от MuADMINSNot verifiedGitHub (Azzlaer/Mu_Cleaner_OF) · 2026-08-24
  20. ИнструментыMuEmu / Louis0.97k

    CustomNpcMove Enterprise Editor: how do I edit CustomNpcMove.txt of MuEmu 0.97k kayito without breaking it?

    1. It needs Windows 10/11 or Server 2022 and Python 3.10 or newer, no extra libraries. 2. Run CustomNpcMove_Enterprise.py. 3. Click Monster.txt and select the GameServer file (for the NPC...

    Пересказ источника от MuADMINSNot verifiedGitHub (Azzlaer/MU_CustomNPCMove_Kayito) · 2026-07-31

MuADMINS Community Alpha: бесплатно, создаётся сообществом, в активной разработке.