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.

39 soluções para “character table” · 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. 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
  3. Site

    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 verifiedEscrito pelo MuADMINS
  4. GameplayMuEmu / Louis0.97k (update 24)

    Kayito MuEmu 0.97k: after lowering MaxCharacterLevel in Common.dat from 1000 to 400, players level much faster than before.

    1. The default experience formula is built for level 1000. 2. When you change the max level, adapt the experience table in the GameServer source: User.cpp, gObjSetExperienceTable. 3. Also...

    ✓ Confirmado na issueGitHub (nicomuratona/MuEmu-0.97k-kayito) · 2024-09-15
  5. 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
  6. Configuração do servidorWebZen 97d / 99b97d

    DarksTeam 97d: accounts created on the web show NULL columns in the database and characters do not show up properly. How to fix it?

    1. Back up the MuOnline database first. 2. Open a new query on MuOnline in SQL Server Management Studio. 3. Run: UPDATE Character SET CtlCode = 0 WHERE CtlCode IS NULL 4. Restart the serv...

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2018-10-15
  7. Configuração do servidorMuEmu / LouisSeason 6 (MuEmu update 22)

    New characters show 65535 kills and deaths.

    1. Fix existing ones: UPDATE dbo.Character SET Kills=0 WHERE Kills=65535 and the same for Deads. 2. In SSMS design the Character table and set the Default Value of Kills and Deads to 0. 3...

    ✓ Confirmado pelo autor do tópicoCreandoMU · 2020-08-20
  8. 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
  9. 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
  10. 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
  11. 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
  12. Configuração do servidor

    Characters do not save and the DataServer log shows State (42S22)

    SQL state 42S22 means a column was not found: the server files query a column your database does not have, so the save fails. 1. Open the DataServer log and read which table and column th...

    ✓ Confirmado pelo autor do tópicoTUServerMU · 2021-03-24
  13. Site

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

    How do I reset a character with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files (ResetCount) with the server closed?

    Columns: Character.ResetCount and MasterResetCount (X-Team also ResetDay, ResetWek, ResetMon and MasterResetDay / Wek / Mon for the daily, weekly and monthly limits). The server reads and...

    Not verifiedEscrito pelo MuADMINS
  15. Configuração do servidorIGCNS9, S12, S16, S17, S18

    How do I reset a character with SQL on IGCN files (RESETS, GrandResets) with the server closed?

    Columns in IGCN Character: RESETS (int, all seasons), GrandResets (tinyint, Season 16, 17, 18), GRANDRESET (Season 12), plus cLevel, Experience, LevelUpPoint and the stats. 1. Close the G...

    Not verifiedEscrito pelo MuADMINS
  16. Configuração do servidorIGCNS15, S16, S17, S18

    How do I make a character Game Master (GM) or Administrator on IGCN files (CtlCode)?

    On IGCN files the GM rights are on the character: Character.CtlCode (tinyint, default 0). - The IGCN command documentation says GM commands such as /item and /spawn "require Administrator...

    Not verifiedEscrito pelo MuADMINS
  17. Configuração do servidorMuEmu / LouisSeason 6 (Louis)

    How do I make a working online time ranking per character?

    1. Add an int column OnlineTime to the Character table (back up first). 2. Create a SQL Agent job every minute: UPDATE Character SET OnlineTime=OnlineTime+1 joined to MEMB_STAT (ConnectSt...

    ✓ Confirmado pelo autor do tópicoCreandoMU · 2021-03-09
  18. 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
  19. 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
  20. 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

Vídeos no MUTube

Mais vídeos de “character table”

Ainda com problema? Pergunte ao Assistente MU Buscar no MuGPS

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