Community AlphaAlpha MUADMINS
PTPortuguês (Brasil)
Entrar
No MuADMINSConfig ScannerEnvie o zip dos seus arquivos: rates, drops, spots, limitesAbrirNo MuADMINSEncontre-nos no DiscordPeça ajuda, mostre o que está criando e converse sobre MU com outros donos de servidores.Abrir

MuADMINS

Soluções

Correções curtas para problemas comuns de servidor, cliente e site de MU Online, cada uma com a fonte e a data. “Confirmado” significa que quem perguntou disse que a correção funcionou.

239 soluções para “sql server” · Limpar

  1. Configuração do servidor0.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...

    ✓ Confirmado pelo autor do tópicoImperyus Games Brasil · 2013-05-26
  2. Configuração do servidorMuEmu / 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...

    ✓ Confirmado pelo autor do tópicoCreandoMU · 2021-01-21
  3. Configuração do servidorS3E1

    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...

    ✓ Confirmado pelo autor do tópicoDarksTeam · 2010-03-09
  4. Configuração do servidorMuEmu / 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...

    ✓ Confirmado pelo autor do tópicoRaGEZONE · 2024-08-02
  5. Configuração do servidor

    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 verifiedEscrito pelo MuADMINS
  6. FerramentasWebZen 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...

    Reescrita da fonte pelo MuADMINSNot verifiedRaGEZONE · 2005-07-17
  7. FerramentasEX803

    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)...

    Reescrita da fonte pelo MuADMINSNot verifiedRaGEZONE · 2016-11-19
  8. FerramentasMuEmu / 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...

    ✓ Confirmado pelo autor do tópicoRaGEZONE · 2022-03-17
  9. FerramentasMuEmu / 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...

    ✓ Confirmado pelo autor do tópicoTUServerMU · 2018-06-04
  10. GameplayMuEmu / 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...

    ✓ Confirmado pelo autor do tópicoCreandoMU · 2020-09-28
  11. Configuração do servidor

    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,...

    ✓ Confirmado pelo autor do tópicoDarksTeam · 2008-06-30
  12. Site97d+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...

    ✓ Confirmado pelo autor do tópicoDarksTeam · 2009-10-31
  13. Site

    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...

    ✓ Confirmado pelo autor do tópicoDarksTeam · 2011-04-14
  14. Site97d

    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...

    ✓ Confirmado pelo autor do tópicoDarksTeam · 2019-07-25
  15. Site

    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...

    ✓ Confirmado pelo autor do tópicoRaGEZONE · 2017-08-03
  16. Site

    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...

    ✓ Confirmado pelo autor do tópicoRaGEZONE · 2019-03-05
  17. Site

    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....

    ✓ Confirmado pelo autor do tópicoRaGEZONE · 2017-11-03
  18. Configuração do servidorMuEmu / 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...

    ✓ Confirmado na issueGitHub (nicomuratona/MuEmu-0.97k-kayito) · 2025-06-22
  19. Configuração do servidorWebZen 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 (...

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2018-06-16
  20. SiteMuEmu / 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...

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2018-11-22

MuADMINS Community Alpha: grátis, feito pela comunidade e em desenvolvimento ativo.