Community AlphaAlpha MUADMINS
DEDeutsch
Anmelden
Auf MuADMINSConfig ScannerZip deiner Dateien hochladen: Rates, Drops, Spots, LimitsÖffnenAuf MuADMINSTriff uns auf DiscordFrag nach Hilfe, zeig, woran du arbeitest, und sprich mit anderen Serverbetreibern über MU.Öffnen

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.

235 Lösungen für “muonline database” · Zurücksetzen

  1. Server-SetupMuEmu / 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...

    ✓ Vom Threadersteller bestätigtCreandoMU · 2021-03-09
  2. Server-SetupMuEmu / LouisSeason 6 (Louis)

    How do I give GoblinPoints each time a character resets (Season 6 MuEmu)?

    1. In SSMS edit the procedure WZ_SetResetInfo. 2. Below the line that starts with UPDATE Character add UPDATE CashShopData SET GoblinPoint=GoblinPoint+100 WHERE AccountID=@Account. 3. Exe...

    ✓ Vom Threadersteller bestätigtCreandoMU · 2021-01-21
  3. Server-SetupS3E1

    DarkMaster Season 3 Episode 1: every login says the account is invalid, although all IPs are changed

    The JoinServer password mode (MD5 or plain) did not match how the accounts were created. 1. Delete the test accounts. 2. Put the JoinServer build with MD5 enabled and create the account a...

    ✓ Vom Threadersteller bestätigtDarksTeam · 2010-03-09
  4. GameplayMuEmu / LouisSeason 6

    MuEmu (Emerson repack update 25): new characters get welcome items; where is that removed? It is not a SQL script

    1. The start items are given by the server file MuServer\Data\Custom\CustomStartItem.txt, not by a database script. 2. Remove or comment the item lines there (or switch the system off in...

    ✓ Vom Threadersteller bestätigtTUServerMU · 2021-06-03
  5. GameplayMuEmu / LouisSeason 6 Episode 3

    MuEmu S6 E3 Castle Siege: when the battle starts the defending guild shows as attacker, with no config change

    The Castle Siege data stored in SQL had gone bad. 1. Back up the database first. 2. The asker cleared the SQL tables used by Castle Siege (in MuEmu databases they are the MuCastle_ tables...

    ✓ Vom Threadersteller bestätigtTUServerMU · 2020-11-15
  6. Server-Setup0.97d

    DarksTeam 97d+99i moved to a VPS (Windows Server 2012 R2, SQL 2008 R2): RankingServer shows an error although the config did not change

    The VPS firewall was blocking the RankingServer connections. 1. In Windows Firewall (and the VPS provider firewall, if any) allow the RankingServer program, or open the port it uses, for...

    ✓ Vom Threadersteller bestätigtTUServerMU · 2020-07-08
  7. Server-Setup0.97d

    Aminyuz 97d files: GameServer gives a conexion.ini connection error at start although all IPs are right (EventServer and Ranking open fine)

    The SQL login in the Aminyuz connection file was wrong. 1. Open C:\MuServer\Aminyuz\Conexion (the connection ini of these files). 2. In the [SQL] block set Usuario = sa (your SQL user), C...

    ✓ Vom Threadersteller bestätigtTUServerMU · 2020-02-21
  8. Server-Setup

    Anyone can log in with a random account name and password, and the login creates that account in SQL

    1. This is not a database bug: the server has automatic account registration switched on, so an unknown login is created on the spot. 2. Open the JoinServer config (in some files the opti...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2021-04-15
  9. Server-SetupIGCNS9

    IGCN Season 9 repack: GameServerCS shows an error when Castle Siege is configured, even with correct settings.

    1. The SQL Server language caused it. 2. Install SQL Server in English (English instance) and restore the databases there. 3. Start GameServerCS again.

    ✓ Vom Threadersteller bestätigtTuServerMU · 2017-06-18
  10. Server-SetupIGCNS9

    IGC DataServer stays on its loading window and never finishes starting.

    1. Check the ODBC/SQL settings of the DataServer. 2. The SQL instance name was wrong. When SQL Server is on the same PC use (local) as the instance/host. 3. Start the DataServer again.

    ✓ Vom Threadersteller bestätigtTuServerMU · 2017-04-21
  11. Server-SetupMuEmu / 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...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2024-08-02
  12. ToolsWebZen 97d / 99b

    Cash Shop and VIP Editor (Dino): how to connect it to SQL Server and which columns it needs

    1. Enter the SQL Server IP, login, password and port, then click Connect. 2. Leave the filter empty to list all accounts, or type an account name. 3. Choose the VIP type and the amount of...

    Neufassung der Quelle durch MuADMINSNot verifiedImperyus Games Brasil · 2009-10-04
  13. Server-Setupany

    "Login failed for user 'sa'" (SQLSTATE 28000) from DataServer or the web right after installing SQL Server. How do I enable sa?

    1. If setup used Windows authentication only, sa is disabled. 2. In Management Studio right click the server > Properties > Security and pick SQL Server and Windows Authentication mode. 3...

    Neufassung der Quelle durch MuADMINSNot verifiedMicrosoft Learn · 2025-08-26
  14. Tools

    MuMaker: "Login failed for user 'sa'" although the server runs and the password is right (only one MuMaker build works)

    1. Check that the sa login has rights on the MU databases and that the password in the MuMaker Config.ini is right. 2. If it still says login failed, the MuMaker build does not fit your s...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2011-06-30
  15. ToolsMuEmu / Louis

    MuEmu Editor (2017) + Fixs: an error shows at start although Config.ini has localhost, port 1433, sa and the password

    1. Open the editor Config.ini. 2. In the [Me_MuOnline] and [MuOnline] blocks change EnableTrusted = 0 to EnableTrusted = 1. 3. Save and start the editor again: it connects.

    ✓ Vom Threadersteller bestätigtTUServerMU · 2017-04-29
  16. GameplayIGCNS13

    IGCN Season 13 files: how to give new characters a starting amount of zen.

    1. In SSMS run on MuOnline a query that creates an INSERT trigger on dbo.Character (named Bonus in the thread). 2. The trigger reads the new Name from INSERTED and runs UPDATE Character S...

    ✓ Vom Threadersteller bestätigtTuServerMU · 2018-10-15
  17. Website

    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 verifiedVon MuADMINS geschrieben
  18. Server-Setup

    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 verifiedVon MuADMINS geschrieben
  19. Server-SetupMuDevsS18, 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 verifiedVon MuADMINS geschrieben
  20. WebsiteX-TeamS2, S17

    WebEngine with X-Team files: online ranking fails with Invalid column name 'OnlineHours'

    WebEngine's map for X-Team files (includes\config\xteam.tables.php) defines _CLMN_MS_ONLINEHRS_ = OnlineHours, and the online ranking (only for xteam files) runs: SELECT TOP n memb___id,...

    Not verifiedVon MuADMINS geschrieben

MuADMINS Community Alpha: kostenlos, von der Community gemacht, in aktiver Entwicklung.