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

MuADMINS

Решения

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

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

  1. Инструменты

    Guild Editor: "An Error was found in your CMTedit.ini !" when it starts

    1. Open CMTedit.ini next to the editor. 2. In [MuOnline] (and [MeMuOnline]) the DSN= value is the name of your ODBC data source, not the SQL Server name; it is generally MuOnline. Create...

    Пересказ источника от MuADMINSNot verifiedRaGEZONE · 2020-05-30
  2. Настройка сервераany

    Remote tools or the web cannot reach a SQL Express or named instance on port 1433. How do I make SQL listen on a fixed port?

    1. Named instances use dynamic ports by default; only the default instance uses 1433. 2. SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for your instance...

    Пересказ источника от MuADMINSNot verifiedMicrosoft Learn · 2025-08-26
  3. Сайт

    What does the DmN CMS setup change in the MU database (columns, Character.id, WZ_CONNECT_MEMB) and what can break?

    The DmN CMS 1.2.3 setup does more than create its own tables: 1. It ALTERs the game databases: adds columns from its version files, for example MEMB_INFO Admin, last_login, activated, act...

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

    "Account does not exist" or the login fails although the account is in MEMB_INFO: what to check in the database

    Check these in order (all read only, nothing changes): 1. Is the server reading the same database? MuEmu, Louis, MSPro, X-Team, MuDevs use the ODBC DSN in JoinServer.ini (JoinServerODBC =...

    Not verifiedНаписано MuADMINS
  5. Настройка сервера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
  6. Настройка сервера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
  7. Настройка сервераIGCNS16, S17, S18

    Why 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Написано MuADMINS
  8. Инструменты

    MuMaker: "Cannot open database "MuOnline" requested by the login. The login failed" on SQL Server 2005 Express

    1. Enable the sa login: Management Studio > Security > Logins > sa > Properties: untick "Enforce password policy", set a password; on the Status page tick Grant and Enabled. 2. Server Pro...

    ✓ Подтверждено автором темыRaGEZONE · 2012-08-18
  9. ИнструментыS6

    Flawless Editor: how to set it up to edit WCoinC, WCoinP, Goblin Points, Ruud and Zen of accounts

    1. Open Config.ini in the Flawless Editor folder. 2. Add your SQL user name and SQL password. 3. Save the file and start the editor: it edits WCoinC, WCoinP, Goblin Point, Ruud and Zen. 4...

    Пересказ источника от MuADMINSNot verifiedRaGEZONE · 2026-06-16
  10. Настройка сервераMuEmu / LouisSeason 6

    MuEmu (Louis) files: where do I enter the SQL user and password? I cannot find it in any server config

    MuEmu servers do not keep the SQL login in their config files: JoinServer and DataServer reach the database through ODBC. 1. Run the ODBC .reg file that comes with the files, or create th...

    ✓ Подтверждено автором темыTUServerMU · 2020-07-12
  11. СайтIGCNS6

    How to set up the WebEngine Credit Manager so it gives WCoinC/WCoinP or Goblin Points on IGCN S6 files; adding credits says the account ID is invalid.

    1. Database: MuOnline. Table: T_InGameShop_Point (check the exact name in your DB). 2. Credits column: the currency column you want (WCoinC, WCoinP or GoblinPoint). 3. User column: Accoun...

    ✓ Подтверждено автором темыRaGEZONE · 2022-07-11
  12. Сайт

    Which website CMS expects which MU database columns (WebEngine table maps, DmN)

    WebEngine 1.2.7 picks a table map by server files (includes/config): - igcn.tables.php / custom.tables.php: resets = Character.RESETS, grand resets = Character.GrandResets, VIP = T_VIPLis...

    Not verifiedНаписано MuADMINS
  13. Настройка сервераMuEmu / LouisS4

    MuEmu S4: the server and MuMaker do not see the databases on SQL Server 2008 R2 even with remote connections and TCP/IP enabled.

    1. Check how SQL Server was installed: it had been set up as a named instance. 2. The files and MuMaker expect the default instance, reached as (local) or the PC name. 3. Reinstall SQL Se...

    ✓ Подтверждено автором темыTuServerMU · 2017-11-11
  14. ИнструментыIGCNS9

    IGCN Essential Tools (S9 E2 repack) shows an error pop-up as soon as it is opened.

    1. Open SQL Server Configuration Manager > SQL Server Network Configuration > Protocols. 2. Enable Named Pipes and TCP/IP. 3. In TCP/IP properties > IP Addresses set TCP Port 1433 (IPAll)...

    ✓ Подтверждено автором темыRaGEZONE · 2018-06-18
  15. Настройка сервераany

    During SQL Server setup the password for sa is rejected no matter what I type. Why?

    1. Setup enforces the Windows password policy on the sa password. 2. Use at least 8 characters that mix uppercase letters, lowercase letters and numbers (a symbol helps too). 3. Do not us...

    ✓ Подтверждено автором темыTuServerMU · 2017-07-21
  16. Инструменты

    MuWeb 0.8 does not work with XAMPP on Windows 7 and SQL 2008 (php.ini edits do not help)

    1. MuWeb 0.8 needs an old PHP with the MSSQL functions: the newer XAMPP builds do not run it even after php.ini changes. 2. Install XAMPP 1.6.1 (not higher), configure php.ini as the MuWe...

    ✓ Подтверждено автором темыRaGEZONE · 2013-01-23
  17. Сайт

    MuCore 1.0.6 admin panel: 'Edit module' and 'Edit pages' are broken

    1. The helper's advice was to use MuCore 1.0.8 (and XAMPP 1.7.1 for SQL 2000/2005, or XAMPP 1.7.7 with MSSQL enabled for SQL 2008 or newer). 2. Replacing the whole folder caused other pro...

    ✓ Подтверждено автором темыRaGEZONE · 2017-08-03
  18. Настройка сервера

    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
  19. ИнструментыWebZen 97d / 99b

    Reset Generator: how to make the SQL reset script and run it automatically with SQL Server Agent

    1. Tick the options you want for a character reset (the settings of your server) and press Generate Reset. 2. The program writes the SQL code (script) of your reset system. 3. Copy it and...

    Пересказ источника от MuADMINSNot verifiedDarksTeam · 2008-04-22
  20. Инструменты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

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