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.

61 Lösungen für “online counter” in Server-Setup · Zurücksetzen

  1. Server-Setupany

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

    ✓ Vom Threadersteller bestätigtTUServerMU · 2021-03-30
  2. Server-Setupany

    How to get the list of e-mail addresses of all registered accounts from the MU database

    1. Open SQL Server Management Studio and connect to the server that holds your MU database. 2. Run: USE MuOnline; SELECT mail_addr FROM MEMB_INFO; 3. The result is the e-mail of every acc...

    ✓ Vom Threadersteller bestätigtTUServerMU · 2021-03-17
  3. Server-SetupOpenMU

    OpenMU: a player stays 'already connected' after a dropped connection and cannot log in again, even with the right password

    1. The old session stays registered while the TCP connection to OpenMU is still open. With the web client the WebSocket proxy keeps that connection alive, so every new login gets AccountA...

    ✓ Im Issue bestätigtGitHub (MUnique/OpenMU) · 2026-10-07
  4. Server-Setupclassic

    After 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-17
  5. Server-Setup

    The website always shows 2 players online even when the server is off

    Stale rows in MEMB_STAT still say the accounts are connected. 1. Open Query Analyzer / SSMS on the MuOnline database. 2. Run UPDATE MEMB_STAT SET ConnectStat='0' WHERE ConnectStat>0. 3. R...

    ✓ Vom Threadersteller bestätigtDarksTeam · 2009-03-03
  6. Server-SetupWebZen 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...

    ✓ Vom Threadersteller bestätigtTuServerMU · 2018-10-15
  7. Server-Setup

    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 verifiedVon MuADMINS geschrieben
  8. Server-SetupWebZen 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 verifiedVon MuADMINS geschrieben
  9. Server-SetupIGCNS9, S12, S16, S17, S18

    How do I set a new password for one account in SQL on IGCN files (plain, WZ_MD5 or md5 text)?

    Use the form that matches PasswordEncryptType in IGCDS.ini and the memb__pwd column type. Keep the account offline and always use WHERE. - Type 0 (varchar(20)): UPDATE MEMB_INFO SET memb_...

    Not verifiedVon MuADMINS geschrieben
  10. Server-SetupIGCNS9

    IGCN S9 E2 repack: DataServer says 'Login failed for user ...' (SQLSTATE 28000) and 'DATA SERVER CANNOT CONNECT TO MSSQL'

    1. The repack DataServer config came with a SQL login that does not exist on your SQL Server (here a random name like D2a78Rtko0), so the login fails. 2. Open the database settings of the...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2019-07-14
  11. Server-SetupS6, S16, S17, S18, S20

    How do I add WCoinC, WCoinP or Goblin Points with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files (CashShopData)?

    The table is CashShopData (AccountID, WCoinC, WCoinP, GoblinPoint). 1. Account offline (best: server closed), backup first, look at the row: SELECT AccountID, WCoinC, WCoinP, GoblinPoint...

    Not verifiedVon MuADMINS geschrieben
  12. Server-SetupOpenMUS6E3

    OpenMU in Docker: how do I update to a new version without losing accounts and characters?

    1. Back up the PostgreSQL database first. 2. In the folder with the compose file run docker-compose pull to pull all images of the stack. 3. Run docker-compose up -d. Containers that use...

    Neufassung der Quelle durch MuADMINSNot verifiedGitHub (MUnique/OpenMU) · 2024-07-19
  13. Server-Setup0.97d

    0.97d: every item (even shop items) gets serial 00000000.

    1. The trigger that creates item serials was deleted when the server was reset. 2. Recreate the serial trigger (run its script with the server off) and check the item serial counter is no...

    ✓ Vom Threadersteller bestätigtImperyus Games Brasil · 2013-05-26
  14. 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
  15. 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
  16. 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
  17. Server-Setup

    Players are disconnected from the game about one minute after entering

    The anti-hack options in the GameServer config kick legit players. 1. Open MuServer\Data\commonserver.cfg and find SpeedHackPlayerBlock. 2. Set the anti-hack block like the working values...

    ✓ Vom Threadersteller bestätigtDarksTeam · 2011-01-25
  18. Server-SetupMuEmu / 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...

    ✓ Vom Threadersteller bestätigtTUServerMU · 2020-05-04
  19. Server-SetupMuEmu / LouisSeason 6

    MuEmu (Louis) files: where do I enter the SQL user and password? I cannot find it in any server config

    MuEmu servers do not keep the SQL login in their config files: JoinServer and DataServer reach the database through ODBC. 1. Run the ODBC .reg file that comes with the files, or create th...

    ✓ Vom Threadersteller bestätigtTUServerMU · 2020-07-12
  20. Server-SetupMuEmu / 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...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2018-04-09

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