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.

25 Lösungen für “cms” in Server-Setup · Zurücksetzen

  1. 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
  2. Server-Setup

    With the firewall turned on nobody can enter my server or my website; with it off they can

    The firewall blocks the server ports. 1. In the firewall allow (unblock) TCP 44405 (ConnectServer), 55901 (GameServer) and 55919 (GameServer CS). 2. Also allow port 80 for the website. 3....

    ✓ Vom Threadersteller bestätigtDarksTeam · 2012-07-14
  3. 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
  4. Server-Setupany (Morpheus web)

    Accounts created on the website get VIP months instead of days (Morpheus web).

    1. The SQL login used by the site had its language changed to Portuguese, which changes the date format. 2. Set the default language of that SQL login back to English (us_english). 3. Cre...

    ✓ Vom Threadersteller bestätigtCreandoMU · 2021-04-12
  5. Server-Setup

    Guild war gives no points: the website shows a negative score and the in-game G Score stays 0

    The Guild table column G_Score had no default value, so new guilds got NULL. 1. Open SQL Server > MuOnline database > Tables > Guild > Design Table. 2. Select the column G_Score and set i...

    ✓ Vom Threadersteller bestätigtDarksTeam · 2010-05-03
  6. 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
  7. Server-SetupIGCNS12, S16, S17, S18

    IGCN Me_MuOnline (shared accounts): login fails or new accounts are not found after enabling it

    Me_MuOnline is a separate accounts database. It has its own MEMB_INFO, MEMB_STAT, T_VIPList, ConnectionHistory, IGC_MachineID_Banned, fn_md5, WZ_CONNECT_MEMB and WZ_DISCONNECT_MEMB. 1. IG...

    Not verifiedVon MuADMINS geschrieben
  8. Server-Setup1.0M, 1.0L

    Accounts do not work after putting a 1.0L database under 1.0M files

    The two versions use different password storage. 1. 1.0M files use MD5 on; 1.0L files use MD5 off. 2. Use the database (and website install option) that matches your files: MD5 on for 1.0...

    ✓ Vom Threadersteller bestätigtDarksTeam · 2008-11-25
  9. Server-Setup

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

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

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

    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 verifiedVon MuADMINS geschrieben
  13. Server-SetupWebZen 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 verifiedVon MuADMINS geschrieben
  14. 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
  15. Server-Setup

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

    "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 geschrieben
  17. Server-SetupDV-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 verifiedVon MuADMINS geschrieben
  18. Server-SetupS2, S6, S16, S17, S18, S20

    How 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 geschrieben
  19. Server-SetupS2, S6, S16, S17, S18, S20

    How do I give VIP (AccountLevel) to an account with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files?

    In MuEmu based files VIP is MEMB_INFO.AccountLevel (0 = normal, the AL1 / AL2 / AL3 levels of your configs) with MEMB_INFO.AccountExpireDate. Use the shipped procedure, account offline: E...

    Not verifiedVon MuADMINS geschrieben
  20. Server-SetupS6, 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 verifiedVon MuADMINS geschrieben

Videos auf MUTube

Mehr Videos zu „cms“

Kommst du immer noch nicht weiter? Frag den MU-Assistenten MuGPS durchsuchen

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