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.

128 soluções para “SQL Server” para MuDevs e para todos os files · Limpar

  1. Configuração do servidor

    A character exists in the Character table but does not appear (AccountCharacter slots)

    The character list of an account is kept in AccountCharacter (Id = account, GameID1 to GameID5, or to GameID10 on newer files, plus GameIDC). The packs' WZ_CreateCharacter writes the new...

    Not verifiedEscrito pelo MuADMINS
  2. Configuração do servidor

    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 verifiedEscrito pelo MuADMINS
  3. Configuração do servidor

    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 verifiedEscrito pelo MuADMINS
  4. Configuração do servidorS2, S6, S15, S17, S18

    How do I make a character GM on MuEmu, Louis, MSPro, X-Team or MuDevs files (GameMaster.txt, not CtlCode)?

    In MuEmu based files the GM list is a file, not a database column: GameServer\Data\Util\GameMaster.txt, one line per GM: "account1" "GMName" 2 - Louis Season 6: columns Account, Name, Lev...

    Not verifiedEscrito pelo MuADMINS
  5. Ferramentas

    MuMaker: "Login failed for user 'sa'" although the server runs and the password is right (only one MuMaker build works)

    1. Check that the sa login has rights on the MU databases and that the password in the MuMaker Config.ini is right. 2. If it still says login failed, the MuMaker build does not fit your s...

    ✓ Confirmado pelo autor do tópicoRaGEZONE · 2011-06-30
  6. SiteS1 to S12

    DTweb 2.0 (MuOnline CMS for all seasons): how do I install it and log into its admin panel the first time?

    1. Run Script.sql in your SQL query analyzer on the server database. 2. Put the website in the main web directory, not in a subfolder: some files use the document root and images or inclu...

    Reescrita da fonte pelo MuADMINSNot verifiedGitHub (r00tmebaby/DT-Web-2.0-MuOnline-CMS-All-Seasons) · 2019-04-12
  7. Configuração do servidorS4

    SCFdb (SCF Season 4 database manager) shows an error at start

    1. Reinstall Microsoft .NET Framework 2.0, or better install .NET Framework 3.0. 2. Start SCFdb again.

    ✓ Confirmado pelo autor do tópicoDarksTeam · 2008-10-16
  8. Site

    Website registration says "Your Account Has Been Created Successfully" but nothing is saved in the database

    The fix given: add the MD5 extension to SQL Server and install the site with MD5 on. 1. Copy the MD5 dll for SQL Server (shared in the thread) into the MSSQL\Binn folder of SQL Server. 2....

    ✓ Confirmado pelo autor do tópicoDarksTeam · 2008-11-28
  9. Configuração do servidor

    The website always shows 2 players online even when the server is off

    Stale rows in MEMB_STAT still say the accounts are connected. 1. Open Query Analyzer / SSMS on the MuOnline database. 2. Run UPDATE MEMB_STAT SET ConnectStat='0' WHERE ConnectStat>0. 3. R...

    ✓ Confirmado pelo autor do tópicoDarksTeam · 2009-03-03
  10. Configuração do servidorS3E2

    DarksTeam Season 3 Episode 2 (Beta 19) Cash Shop: a bought Seal disappears after reconnect

    The seal was saved with a wrong date format in t_perioditem_info. 1. Open the stored procedure t_perioditem_insert in the MuOnline database. 2. Fix the datetime format it uses when insert...

    ✓ Confirmado pelo autor do tópicoDarksTeam · 2009-08-09
  11. Configuração do servidor

    Guild war gives no points: the website shows a negative score and the in-game G Score stays 0

    The Guild table column G_Score had no default value, so new guilds got NULL. 1. Open SQL Server > MuOnline database > Tables > Guild > Design Table. 2. Select the column G_Score and set i...

    ✓ Confirmado pelo autor do tópicoDarksTeam · 2010-05-03
  12. Configuração do servidor

    How to protect Game Master characters (give them the protected GM status)

    The GM status is the CtlCode column of the character. 1. Open the MuOnline database in SQL Server. 2. Run UPDATE Character SET CtlCode = '8' WHERE Name='<GM name>' (the asker confirmed 8...

    ✓ Confirmado pelo autor do tópicoDarksTeam · 2012-05-11
  13. Configuração do servidorSeason 6

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

    ✓ Confirmado pelo autor do tópicoTUServerMU · 2021-05-09
  14. SiteS6

    MuCore install on a web host: after the serial number step, step_1 of the installer shows nothing (Season 6 repack)

    1. Open the MuCore configuration file that holds the database settings. 2. Find $core['connection_type'] = "MSSQL";. 3. Change the value to lower case: $core['connection_type'] = "mssql";...

    ✓ Confirmado pelo autor do tópicoRaGEZONE · 2018-03-23
  15. Siteany

    WebEngine cannot connect to an older SQL Server (2008, 2012, 2014, 2016). What settings help?

    1. Linux with pdo_dblib: install FreeTDS (apt install freetds-bin) and add a named block in /etc/freetds/freetds.conf with host, port 1433, encryption off and tds version 7.1. 2. Test it...

    Reescrita da fonte pelo MuADMINSNot verifiedWebEngine docs · 2025-04-25
  16. Siteany

    How do I enable the SQL Server PDO driver in php.ini and check it is really loaded?

    1. Copy the matching php_sqlsrv and php_pdo_sqlsrv DLLs into the PHP ext folder (run php -i to see extension_dir). 2. Add extension= lines for both files in php.ini. 3. On Linux, load pdo...

    Reescrita da fonte pelo MuADMINSNot verifiedMicrosoft Learn · 2026-09-17
  17. Siteany

    After switching PHP from 5.6 to 7.x in cPanel my WebEngine lost the connection to the MuOnline database.

    1. Each PHP version in cPanel has its own extension list. 2. Check the new version is supported by your WebEngine release. 3. In cPanel PHP selector, enable the same connection extension...

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2021-07-31
  18. Siteany

    MuCore does not load on XAMPP 7.2.1.

    1. MuCore needs the old mssql PHP extension that newer XAMPP/PHP 7 no longer ships. 2. Use XAMPP 1.7.1 (old PHP with the mssql extension) for MuCore, or move to a CMS that supports PDO sq...

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2018-02-08
  19. Siteany

    After moving the MU server and WebEngine to a new Windows Server machine (VirtualBox), the site connects to the database but the crons stop updating rankings.

    1. Go to the includes/cache folder of the site and delete the cached data files. 2. If needed, run the cron once by hand with the link shown in AdminCP > Cron Manager. 3. The rankings ref...

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2021-03-25
  20. Configuração do servidorclassic

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

    ✓ Confirmado pelo autor do tópicoImperyus Games Brasil · 2010-12-17

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