Community AlphaAlpha MUADMINS
ENEnglish
Sign in
On MuADMINSConfig ScannerDrop your files zip: rates, drops, spots, limitsOpenOn MuADMINSMeet us on DiscordAsk for help, share what you are building and talk MU with other server owners.Open

MuADMINS

Solutions

Short fixes for common MU Online server, client and website problems, each with its source and date. “Confirmed” means the person who asked said the fix worked.

25 solutions for “cms” in Server setup · Clear

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

    ✓ Confirmed by the topic starterDarksTeam · 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....

    ✓ Confirmed by the topic starterDarksTeam · 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...

    ✓ Confirmed by the topic starterRaGEZONE · 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...

    ✓ Confirmed by the topic starterCreandoMU · 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...

    ✓ Confirmed by the topic starterDarksTeam · 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 verifiedWritten by MuADMINS
  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 verifiedWritten by MuADMINS
  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...

    ✓ Confirmed by the topic starterDarksTeam · 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 verifiedWritten by MuADMINS
  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 verifiedWritten by MuADMINS
  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 verifiedWritten by MuADMINS
  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 verifiedWritten by MuADMINS
  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 verifiedWritten by MuADMINS
  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 verifiedWritten by MuADMINS
  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 verifiedWritten by MuADMINS
  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 verifiedWritten by MuADMINS
  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 verifiedWritten by MuADMINS
  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 verifiedWritten by MuADMINS
  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 verifiedWritten by MuADMINS
  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 verifiedWritten by MuADMINS

Videos on MUTube

More videos for “cms”

Still stuck? Ask the MU Assistant Search MuGPS

MuADMINS Community Alpha: free and community made, in active development.