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

MuADMINS

Решения

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

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

  1. Настройка сервера0.97d

    0.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-26
  2. Настройка сервераMuEmu / LouisSeason 6 (Louis)

    How do I give GoblinPoints each time a character resets (Season 6 MuEmu)?

    1. In SSMS edit the procedure WZ_SetResetInfo. 2. Below the line that starts with UPDATE Character add UPDATE CashShopData SET GoblinPoint=GoblinPoint+100 WHERE AccountID=@Account. 3. Exe...

    ✓ Подтверждено автором темыCreandoMU · 2021-01-21
  3. Настройка сервераS3E1

    DarkMaster 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-09
  4. Настройка сервераMuEmu / Louis

    Louis (MuEmu) server ran out of item serials: every new item gets serial FFFFFFFF and is flagged as a dupe.

    1. Serials come from the stored procedure WZ_GetItemSerial, which increments ItemCount in table GameServerInfo for every created item (drops, bags, commands). 2. Edit that existing proced...

    ✓ Подтверждено автором темыRaGEZONE · 2024-08-02
  5. Настройка сервера

    How 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Написано MuADMINS
  6. ИнструментыWebZen 97d / 99b97d-99

    MuEditor 2.1 (SkyTeam): how to set it up on another PC to edit the server database remotely (ODBC and DNS.ini)

    1. On the PC where you run MuEditor open Control Panel, Administrative Tools, Data Sources (ODBC). 2. In System DSN click Add, choose SQL Server: Name MuOnline, Description MuEditor, Serv...

    Пересказ источника от MuADMINSNot verifiedRaGEZONE · 2005-07-17
  7. ИнструментыEX803

    IzsMuEditor 2.1.2 (EX803): the editor does not connect to the database

    1. By default IzsMuEditor connects through an ODBC DSN. 2. If it does not connect, open Data\IzsConfig.ini, set Use_ODBC to 0 and fill in your SQL connection data (server, user, password)...

    Пересказ источника от MuADMINSNot verifiedRaGEZONE · 2016-11-19
  8. ИнструментыMuEmu / Louis

    RJLauncher: how to set up the launcher and its patch download for Louis files (patchver, patchlink, launch line)

    1. Set up a web server first (for example XAMPP) and make sure the site works; locally the IP is 127.0.0.1, for players use your public IP and forward the game ports and the web port (usu...

    ✓ Подтверждено автором темыRaGEZONE · 2022-03-17
  9. ИнструментыMuEmu / Louis

    MuEmu Editor: an error appears when searching an account and inventory changes are not saved ('los cambios no han sido guardados')

    1. Open the editor Config.ini and check the database names in both blocks: ME_DB under [Me_MuOnline] and MU_DB under [MuOnline]. 2. They must match the real name of your database in SQL S...

    ✓ Подтверждено автором темыTUServerMU · 2018-06-04
  10. ГеймплейMuEmu / LouisSeason 6 (MuEmu)

    MuEmu: how do I set Castle Siege so registration opens by itself on Monday and the siege runs on Sunday?

    1. Edit GameServerCS/Data/Event/MuCastleData.dat: state 7 sets the siege day and start hour, state 8 sets the end hour. 2. In GameServerCS/Data/GameServerInfo - Event.dat set CastleSiegeE...

    ✓ Подтверждено автором темыCreandoMU · 2020-09-28
  11. Настройка сервера

    How to protect the server from attackers with the firewall

    Only the ConnectServer and GameServer must be reachable from outside. 1. In the firewall block outside access for: MySQL (mysqld.exe), the DataServer(s), ExDB, EventServer, RankingServer,...

    ✓ Подтверждено автором темыDarksTeam · 2008-06-30
  12. Сайт97d+99i

    Characters stop at level 350 (max level) but the website reset asks for level 400 (97d+99i)

    On 97d+99i the max level cannot be raised, so lower the reset level on the website instead. 1. Open SQL Server Enterprise Manager > MuOnline > Tables. 2. Find the MuWeb table, right click...

    ✓ Подтверждено автором темыDarksTeam · 2009-10-31
  13. Сайт

    DarksWeb 0.1: the news cannot be deleted from the site admin

    The news and admin data of DarksWeb are stored in the database, not in the PHP files. 1. Open SQL Server and go to Databases > MuOnline > table MuWeb_admin. 2. Edit or delete the news row...

    ✓ Подтверждено автором темыDarksTeam · 2011-04-14
  14. Сайт97d

    MuCore website Exchange System always shows 0 Online Hours although the character was online for hours (DarkMaster 97d server)

    The MuCore module reads the column OnlineMinutes, which did not exist in the database. 1. Take the online-time SQL script from the thread (it adds a column to MEMB_STAT and changes the st...

    ✓ Подтверждено автором темыDarksTeam · 2019-07-25
  15. Сайт

    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
  16. Сайт

    MuCore 2.2.0: the add and edit buttons for modules do not show in the admin panel

    1. MuCore 2.2.0 does not work properly on PHP 7.x. 2. Run it on PHP 5.6: the topic starter installed XAMPP with PHP 5.6.40 plus the PDO fix for SQL Server. 3. On a web host, switch the PH...

    ✓ Подтверждено автором темыRaGEZONE · 2019-03-05
  17. Сайт

    MuCore 1.08 rankings show only one character (or none) while players are online

    1. MuCore only ranks characters whose CtlCode is 0 in the Character table; characters with another value are left out. 2. In SQL Server set CtlCode to 0 for the normal player characters....

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

    Kayito MuEmu 0.97k download has no JoinServer and DataServer folders. Where are they?

    1. First choose your database engine: SQL Server or MySQL. 2. For SQL Server copy JoinServer and DataServer from the MSSQL folder; for MySQL take them from the MySQL folder. 3. Put both n...

    ✓ Подтверждено в issueGitHub (nicomuratona/MuEmu-0.97k-kayito) · 2025-06-22
  19. Настройка сервераWebZen 97d / 99b99b

    Files 99B DarksTeam on Windows 7: MuServer startup throws an ODBC error even with the 64-bit ODBC .reg applied. How was it solved?

    1. Use the ODBC .reg (or manual DSN) that matches your Windows: 32-bit or 64-bit. 2. Make sure the databases were created or restored in SQL Server. 3. Right click the startup shortcuts (...

    ✓ Подтверждено автором темыTuServerMU · 2018-06-16
  20. СайтMuEmu / LouisS6

    DMN CMS with MuEmu S6E3 files: reset and grand reset modules do not work.

    1. Open the Character table in SQL and read the exact column names. 2. In the DMN config type them exactly, with the same upper and lower case (for example ResetCount, not reset or resetc...

    ✓ Подтверждено автором темыTuServerMU · 2018-11-22

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