MuADMINS
Lösungen
Kurze Fixes für häufige Probleme mit Server, Client und Website bei MU Online, jeweils mit Quelle und Datum. “Bestätigt” heißt: Die Person, die gefragt hat, hat gesagt, dass der Fix funktioniert hat.
21 Lösungen für “character creation” in Server-Setup · Zurücksetzen
IGCN: players cannot create Summoner, Rage Fighter or other card classes (AccountCharacter flags)
IGCN stores the class unlocks per account in AccountCharacter. Season 17 has the flags Summoner, RageFighter, GrowLancer, MagicGladiator, DarkLord, RuneWizard, Slayer, GunCrusher, LightWi...
Not verifiedVon MuADMINS geschriebenCreating 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...
✓ Vom Threadersteller bestätigtTUServerMU · 2020-05-04After 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.
✓ Vom Threadersteller bestätigtImperyus Games Brasil · 2010-12-17DarksTeam 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...
✓ Vom Threadersteller bestätigtTuServerMU · 2018-10-15New 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...
✓ Vom Threadersteller bestätigtCreandoMU · 2020-08-20How do I change the items new characters start with equipped?
1. Create a character and equip it with MuEditor as you want. 2. Copy that character's Inventory value in SQL. 3. Run UPDATE DefaultClassType SET Inventory = <copied value> WHERE Class =...
✓ Vom Threadersteller bestätigtCreandoMU · 2020-08-15Two servers on one VPS: after creating a character (Summoner, Elbeland) the player is sent to the wrong server code from MapServerInfo
With subservers the main MapServerInfo must know every GameServer. 1. Open the main Data\MapServerInfo. 2. Add the index (server code) lines of every GameServer and every GameServerCS you...
✓ Vom Threadersteller bestätigtTUServerMU · 2021-02-21A 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 verifiedVon MuADMINS geschriebenHow 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 verifiedVon MuADMINS geschriebenHow 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...
✓ Vom Threadersteller bestätigtCreandoMU · 2021-03-09Korean, 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 verifiedVon MuADMINS geschriebenWhere 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 verifiedVon MuADMINS geschriebenMuDevs 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 verifiedVon MuADMINS geschriebenWhat 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 verifiedVon MuADMINS geschriebenOpenMU (Docker all-in-one) after updating the server: the client stays on the login screen after entering the password.
1. Open the admin panel and run every pending update; the maintainer notes you cannot enter the game without them. 2. In this case the database upgrade had not completed, and an old impor...
✓ Im Issue bestätigtGitHub (MUnique/OpenMU) · 2024-07-21On a 0.99b server the ConnectServer closes by itself when I replace the numeric IP with a No-IP hostname. Why?
1. Old 0.99b ConnectServer builds only accept an address as long as a numeric IP. 2. Keep the hostname at 14 characters or less including the dots (the length of a full IPv4 address strin...
✓ Vom Threadersteller bestätigtTuServerMU · 2021-02-10Unicode (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 verifiedVon MuADMINS geschrieben"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 verifiedVon MuADMINS geschriebenWhat 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 verifiedVon MuADMINS geschriebenWhat are the MSPro database settings (ODBC, MD5Encryption, DisconnectOnlineAccount) and the update queries?
MSPro files connect through the ODBC DSN named MuOnline: - JoinServer\JoinServer.ini: JoinServerODBC = MuOnline, CaseSensitive = 0, MD5Encryption = 0, MaxIPLimit = 0, MaxHwIDLimit = 0, Di...
Not verifiedVon MuADMINS geschrieben



