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

60 soluciones para “source” en Instalación del servidor · Limpiar

  1. Instalación del servidorMuEmu / LouisSeason 8 Episode 3

    JoinServer and DataServer stopped connecting to the database (MuEmu Season 8)

    Restoring the database and the ODBC data sources again did not help: the SQL login the servers use did not have the rights it needs. 1. Open SQL Server Management Studio and go to Securit...

    ✓ Confirmado por el autor del temaTUServerMU · 2018-10-06
  2. Instalación del servidor

    JoinServer and DataServer cannot connect to the database although the backup is restored

    These files had the database name MuOnlineS6 in the server configs while the database was restored as MuOnline, so the servers looked for a database that does not exist. 1. In SQL Server...

    ✓ Confirmado por el autor del temaTUServerMU · 2018-09-27
  3. Instalación del servidorIGCNS16, S17, S18

    IGCN: players have negative WCoin or Goblin Points (shipped maintenance script)

    IGCN ships 2. Update Scripts\Maintenance Scripts\Check & Fix negative Coins.sql. It works in two runs and says "Take server offline before proceeding with the script": 1. With @Update = 0...

    Not verifiedEscrito por MuADMINS
  4. Instalación del 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 por MuADMINS
  5. 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
  6. 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
  7. Instalación del servidor

    ODBC / DSN: the DataServer or JoinServer cannot connect to MuOnline (DSN name, 32 bit or 64 bit)

    MuEmu, Louis, MSPro, X-Team and MuDevs files connect through an ODBC System DSN: - JoinServer.ini JoinServerODBC = MuOnline, DataServer.ini DataServerODBC = MuOnline (MSPro: ODBC = MuOnli...

    Not verifiedEscrito por MuADMINS
  8. Instalación del servidor

    How do I back up and restore MU databases: which ones, in which order, and moving to a new PC?

    Back up every database of the server at the same moment (server closed), and restore them together: - IGCN: MuOnline, Me_MuOnline (if used), Events, Ranking, BattleCore - MuEmu, Louis, MS...

    Not verifiedEscrito por MuADMINS
  9. 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
  10. Instalación del servidor

    I changed a character, coins or a vault with SQL and the change disappeared (UPDATE while the server is on)

    The running server keeps its own copy of every online character and account and writes it back to the database, so an UPDATE made while that player is online can be overwritten a moment l...

    Not verifiedEscrito por MuADMINS
  11. Instalación del 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 por MuADMINS
  12. 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
  13. Instalación del 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 por MuADMINS
  14. Instalación del 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 por MuADMINS
  15. Instalación del servidorWebZen 97d / 99bS2, S3

    How do I set a new password for one account on a WebZen Season 2 / 3 MD5 database (SP_MD5_ENCODE_VALUE)?

    The Season 3 mumatrix and Season 2 namech databases ship SP_MD5_ENCODE_VALUE @btInStr VARCHAR(10), @btInStrIndex VARCHAR(10) ("Created By WebZen, Adapted By [CzF]Deathway" in the Season 3...

    Not verifiedEscrito por MuADMINS
  16. Instalación del servidorWebZen 97d / 99b97d, 99b, S2, S3

    Which databases and procedures do WebZen 97d, Season 2 and Season 3 files use?

    - 97d (RaGEZONE pack): MuOnline.bak and Ranking.bak, SQL Server 2000 backups (restore them on 2005, 2008 or 2008 R2 first: 2012 and newer cannot restore a SQL 2000 backup). WZ_CONNECT_MEM...

    Not verifiedEscrito por MuADMINS
  17. 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
  18. Instalación del servidorMuDevsS18, S20

    MuDevs: WZ_CONNECT_MEMB has 4 parameters (@HarwareID) and MEMB_STAT has HWID / OnlineHours

    MuDevs differs from the other MuEmu based files here: - WZ_CONNECT_MEMB @memb___id varchar(10), @ServerName varchar(50), @IP varchar(20), @HarwareID varchar(74) (4th parameter, spelled Ha...

    Not verifiedEscrito por MuADMINS
  19. 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
  20. 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

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