Community AlphaAlpha MUADMINS
ESEspañol
Iniciar sesión
En MuADMINSConfig ScannerSube el zip de tus archivos: rates, drops, spots, límitesAbrirEn MuADMINSEncuéntranos en DiscordPide ayuda, comparte lo que estás creando y habla de MU con otros dueños de servidores.Abrir

MuADMINS

Soluciones

Arreglos breves para problemas comunes de servidores, clientes y sitios web de MU Online, cada uno con su fuente y su fecha. “Confirmado” significa que la persona que preguntó dijo que el arreglo funcionó.

39 soluciones para “character table” · Limpiar

  1. Sitio web

    WebEngine register error "String or binary data would be truncated" (sno__numb is shorter than 13 characters)

    WebEngine 1.2.7 fills MEMB_INFO.sno__numb with _defaultAccountSerial = '1111111111111' (13 characters, includes/classes/class.account.php line 16). The column size depends on the files: -...

    Not verifiedEscrito por MuADMINS
  2. Instalación del servidor

    Korean, Cyrillic, Greek or other character names turn into ?? (collation and Unicode in MU databases)

    In every MSSQL files family we read, names are VARCHAR: Character.Name varchar(10), AccountCharacter.GameID1 ... varchar(10), Guild.G_Name varchar(8), MEMB_INFO.memb___id varchar(10). A V...

    Not verifiedEscrito por MuADMINS
  3. Sitio web

    Website staff table: show whether each GM / Admin is online or offline

    1. Select the staff characters: Select CtlCode,AccountID From Character where CtlCode='32'. 2. For each one check MEMB_STAT: Select * from MEMB_STAT where memb___id='<AccountID>' and Conn...

    ✓ Confirmado por el autor del temaDarksTeam · 2010-05-14
  4. Instalación del servidorDV-TeamS19

    Where are accounts, VIP, credits, resets and bans in the DV-Team Season 19 database (MySQL / MariaDB)?

    DV-Team does not use SQL Server: the database is a MySQL / MariaDB dump (Navicat), databases muonline (127 tables) and log (22 tables). There is no MEMB_INFO and no stored procedure, so S...

    Not verifiedEscrito por MuADMINS
  5. Instalación del servidorMuDevsS18

    MuDevs Season 18: Invalid column name 'LastGateIndex' (the extra query of the pack)

    The MuDevs Season 18 pack ships, next to the database scripts, a file Execute query.sql with one statement: ALTER TABLE dbo.Character ADD LastGateIndex [int] NOT NULL DEFAULT(-1); If the...

    Not verifiedEscrito por MuADMINS
  6. Instalación del servidorX-TeamS2, S15, S17, S18

    What is in the X-Team MuOnline database (password column, VIP, coins, resets, gens, master level)?

    X-Team uses one database, MuOnline, with the MuEmu procedure set. - Accounts: MEMB_INFO.memb__pwd varchar(10) (plain; no MD5 function in the scripts), sno__numb char(18), AccountLevel / A...

    Not verifiedEscrito por MuADMINS
  7. Sitio webMuEmu / 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 por el autor del temaTuServerMU · 2018-11-22
  8. Sitio web

    WebEngine: accounts made on the website cannot log in (password encryption must match memb__pwd)

    WebEngine 1.2.7 has four password modes (install/definitions.php PDO_PWD_ENCRYPT) and writes MEMB_INFO differently for each: - none: memb__pwd = :password (plain), for varchar columns (IG...

    Not verifiedEscrito por MuADMINS
  9. Instalación del servidorMuEmu / LouisS6

    Unicode (NVARCHAR) migration of a MuEmu / Louis Season 6 database: what is right and what breaks

    Review of a Season 6 Unicode script set (a migration that converts the name columns to NVARCHAR plus new WZ_CreateCharacter, WZ_DeleteCharacter, WZ_CreateGuild procedures). Its table list...

    Not verifiedEscrito por MuADMINS
  10. Instalación del servidor

    What breaks a MU server database? Safe SQL checklist before you run a query

    What breaks MU databases most often, and what the pack files themselves show: 1. UPDATE while the server runs: the server writes online characters back from memory (IGCN maintenance scrip...

    Not verifiedEscrito por MuADMINS
  11. Instalación del servidor

    "Account does not exist" or the login fails although the account is in MEMB_INFO: what to check in the database

    Check these in order (all read only, nothing changes): 1. Is the server reading the same database? MuEmu, Louis, MSPro, X-Team, MuDevs use the ODBC DSN in JoinServer.ini (JoinServerODBC =...

    Not verifiedEscrito por MuADMINS
  12. Instalación del servidorMuEmu / LouisS6

    Louis / MuEmu Season 6: "Invalid column name" after updating the server files (which Update script adds which column)

    Louis (JogandoMU) Season 6 files ship one SQL file per update. If the files are newer than the database, the server logs Invalid column name 'X'. Find X below and run that script (and the...

    Not verifiedEscrito por MuADMINS
  13. Instalación del servidorS6, S16

    How do I turn MD5 on (MD5Encryption in JoinServer.ini) on MuEmu, Louis, MSPro, X-Team or MuDevs files, and what does the database need?

    In MuEmu based files the switch is JoinServer\JoinServer.ini, MD5Encryption = 0/1 (next to CaseSensitive = 0). Every pack we read ships 0. What the databases have: - X-Team Season 2 and 1...

    Not verifiedEscrito por MuADMINS
  14. Instalación del servidorIGCNS9, S12, S16, S17, S18

    Which databases do IGCN files need (MuOnline, Me_MuOnline, Events, Ranking, BattleCore) and in which order do the update scripts run?

    IGCN files use up to five databases: - MuOnline: accounts (MEMB_INFO, MEMB_STAT), characters, guilds, warehouse, cash shop (T_InGameShop_Point), VIP (T_VIPList). - Me_MuOnline: optional s...

    Not verifiedEscrito por MuADMINS
  15. Instalación del servidorIGCNS9, S12, S16, S17, S18

    How do I turn MD5 passwords on or off (enable / disable) on IGCN files (PasswordEncryptType, memb__pwd)?

    On IGCN files the password mode is chosen in the DataServer and the database column must be of the matching type. If they do not match, nobody can log in. 1. Close the whole server and ba...

    Not verifiedEscrito por MuADMINS
  16. Sitio webS1 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...

    Reescrito por MuADMINS a partir de la fuenteNot verifiedGitHub (r00tmebaby/DT-Web-2.0-MuOnline-CMS-All-Seasons) · 2019-04-12
  17. HerramientasEx702 to S8E2

    MU DB Helper: how do I install the item, inventory and vault database editor for Ex702 and newer servers?

    1. Requirements: Visual Studio 2013, SQL Server 2012 or newer, ODBC Driver 13 and a MU Online Ex702+ database. 2. Clone the repository and make sure a MuOnline database exists (CREATE DAT...

    Reescrito por MuADMINS a partir de la fuenteNot verifiedGitHub (kyleruss/mu-db-helper) · 2018-04-30
  18. HerramientasOpenMU

    OpenMU admin panel: how do I kick a player or stop an offline session that keeps a personal store open?

    1. Open Online accounts (/logged-in). 2. The first table lists every logged-in account with its server id: Disconnect closes that connection. 3. The second table lists offline sessions, c...

    Reescrito por MuADMINS a partir de la fuenteNot verifiedGitHub (MUnique/OpenMU) · 2026-08-23
  19. HerramientasIGCN

    IGC.ToolKit: how to encode an edited XML into a client BMD and decode a BMD back to XML (IGC File Enc/Dec)

    1. Open the XML in \Data\Local\ of the game client (Notepad++ is recommended), make the changes and save. The header of each file says what it contains. 2. Note the Password attribute at...

    Reescrito por MuADMINS a partir de la fuenteNot verifiedIGCN · 2025-11-25

MuADMINS Community Alpha: gratis, hecho por la comunidad y en desarrollo activo.