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.

103 soluções para “tables” · Limpar

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

    SQL query to delete only characters and guilds but keep the accounts and their warehouse

    1. Make a full backup of the database first. 2. In SQL Server Management Studio run: USE MuOnline; DELETE Character (characters). 3. For guilds run: DELETE Guild; DELETE GuildMember. 4. M...

    ✓ Confirmado pelo autor do tópicoTUServerMU · 2021-03-30
  3. Configuração do servidorany

    How to back up only the accounts and characters (inventory, warehouse, stats) instead of the whole MU database

    1. First make a full backup of the current database as it is (SQL Server Management Studio > Tasks > Back Up). 2. To move players to a clean database, copy over only the tables that hold...

    ✓ Confirmado pelo autor do tópicoTUServerMU · 2020-07-23
  4. Configuração do servidorMuEmu / LouisSeason 6 Episode 3

    Creating a character fails with 'Nombre de personaje incorrecto o ya existe' after installing a SQL script that gives points and zen to new characters (MuEmu S6 EP3 Louis Update 13)

    The new character script wrote to columns that do not exist in this database. 1. Open the script (trigger) you added in SQL Server Management Studio. 2. Compare its column names with your...

    ✓ Confirmado pelo autor do tópicoTUServerMU · 2020-05-04
  5. Site

    How do I show the guild logo (G_Mark) of a guild, for example the Castle Siege owner, on a PHP website with MSSQL?

    1. G_Mark in the Guild table is binary: turn it into text with bin2hex(). You get 64 hex digits, one per cell of an 8x8 grid. 2. Map each digit to a color: 0 transparent, 1 #000000, 2 #8c...

    ✓ Confirmado pelo autor do tópicoRaGEZONE · 2020-07-01
  6. Configuração do servidor

    Replacing WZ_DISCONNECT_MEMB for MuCore gives 'Msg 468 ... Cannot resolve the collation conflict between Latin1_General_CS_AS and SQL_Latin1_General_CP1_CI_AS'

    1. The procedure compares memb___id from MEMB_INFO with memb___id from MEMB_STAT, and the two columns use different collations. 2. In SQL Server Management Studio set the same collation o...

    ✓ Confirmado pelo autor do tópicoRaGEZONE · 2015-11-30
  7. Configuração do servidorMuEmu / LouisS4

    DataServer floods '[QueryManager] State (24000) ... [ODBC SQL Server Driver] Invalid' when a character gets PK status (MuEmu S4 with the Ferrarezi website)

    1. The cause was not ODBC: the Ferrarezi website adds a trigger Z_PK_HERO on dbo.Character that fires when PkCount changes, and its old version broke the DataServer queries. 2. In SQL Ser...

    ✓ Confirmado pelo autor do tópicoRaGEZONE · 2018-04-09
  8. Configuração do servidorOpenMUany

    OpenMU starts with -demo but -reinit fails: Postgres says column ExcellentItemDropLevelDelta of GameConfiguration does not exist.

    1. Two recent EF migrations were not picked up during a Postgres reinit, so the table was created without the new column. 2. Update your OpenMU checkout or image to a build that contains...

    ✓ Confirmado na issueGitHub (MUnique/OpenMU) · 2026-04-11
  9. Configuração do servidorMuEmu / Louisany

    After moving from TitansTech to MuEmu, characters roll back on relog: items and position are not saved. The database was converted. What fixed it?

    1. Character data is saved by the DataServer, so check that first, not the tables. 2. Do not reuse the DataServer from your old TitansTech files: it did not work with MuEmu. 3. Use the Da...

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2017-11-02
  10. Siteany

    After switching to new server files with a new database, the MuCore site no longer detects the database and players cannot register.

    1. The new database does not contain the MuCore tables. 2. Run the MuCore installer again against the new database so it creates its tables. 3. Check config.SQL.php points to the new DB.

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2018-11-19
  11. SiteMuEmu / LouisS6

    MVCore web does not save WCoin (WCC) to the account on MuEmu S6E3 files.

    1. In MVCore credit settings point to the MuEmu cash shop table. 2. Table: CashShopData. Account column: AccountID. Coin column: WCoinC (or the coin you want). 3. Save and test adding coi...

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2019-01-17
  12. SiteMuEmu / LouisS6

    WebEngine vote module with MuEmu files does not add the GP/points after voting.

    1. AdminCP > Credit configuration used by the vote reward. 2. Set User Identifier to Username (the MuEmu table stores the account name). 3. Save and vote again to test.

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2018-06-22
  13. 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
  14. Siteany

    WebEngine 1.0.9 says cache folders are not found (cache/news, cache/profiles, cache/profiles/players, cache/profiles/guilds) and AdminCP shows errors.

    1. Create the missing folders: cache/news, cache/profiles, cache/profiles/players, cache/profiles/guilds. 2. Make them writable by the web server user (chmod 755 or 775 on Linux, write ri...

    ✓ Confirmado pelo autor do tópicoRaGEZONE · 2017-07-08
  15. SiteIGCNS6

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

    ✓ Confirmado pelo autor do tópicoRaGEZONE · 2022-07-11
  16. 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
  17. Configuração do servidorMuEmu / LouisS6

    MSVCP100.DLL is missing when starting ConnectServer, DataServer or JoinServer (MuEmu S6 files).

    Install the Microsoft Visual C++ 2010 Redistributable (x86, plus x64 on 64 bit Windows). Prefer the Microsoft download over single DLL sites.

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2018-06-11
  18. Cliente do jogoMuEmu / LouisS6

    How to make main.exe start only through the launcher (Louis S6 E3 Update 13 with a launcher).

    In MainInfo set LauncherType = 1 (0 lets main and launcher both start it) and set LauncherName to the launcher executable name. Regenerate main.premium and copy it into the client.

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2020-08-08
  19. Cliente do jogo

    A resolution .reg file sets the wrong resolution: index 4 gives 1600x1200 instead of 1366x768.

    1. A broken ExMain.dll in that client rewrote the resolution index when main.exe started; use a clean client. 2. Each client family (Louis, IGCN and others) uses its own resolution index...

    ✓ Confirmado pelo autor do tópicoRaGEZONE · 2020-04-26
  20. Site

    WebEngine rankings, Castle Siege and guild pages stay empty

    WebEngine fills rankings, Castle Siege and guild data with cron jobs. If the crons never ran, those pages stay empty even when the tables exist. 1. In the WebEngine admin panel open the c...

    ✓ Confirmado pelo autor do tópicoTUServerMU · 2021-05-12

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