MuADMINS
Solutions
Des correctifs courts pour les problèmes courants de serveur, de client et de site web MU Online, chacun avec sa source et sa date. “Confirmé” signifie que la personne qui a posé la question a indiqué que le correctif a fonctionné.
24 solutions pour “site” dans Installation du serveur · Effacer
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...
✓ Confirmé par l'auteur du sujetDarksTeam · 2009-03-03Accounts 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...
✓ Confirmé par l'auteur du sujetCreandoMU · 2021-04-12With 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....
✓ Confirmé par l'auteur du sujetDarksTeam · 2012-07-14DataServer 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...
✓ Confirmé par l'auteur du sujetRaGEZONE · 2018-04-09Players 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 verifiedRédigé par MuADMINSGuild 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...
✓ Confirmé par l'auteur du sujetDarksTeam · 2010-05-03MUDevs free Season 20.2-3: where do I get the official files and how do I make the client main?
1. Download server and client only from the MUDevs Discord, #announcement channel (MediaFire links); copies from other sites are not supported. 2. Generate the main with the official tool...
✓ Confirmé par l'auteur du sujetMUDevs · 2026-01-01How to protect the server from attackers with the firewall
Only the ConnectServer and GameServer must be reachable from outside. 1. In the firewall block outside access for: MySQL (mysqld.exe), the DataServer(s), ExDB, EventServer, RankingServer,...
✓ Confirmé par l'auteur du sujetDarksTeam · 2008-06-30Accounts 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...
✓ Confirmé par l'auteur du sujetDarksTeam · 2008-11-25SQL Server 2008 R2 setup crashes and closes while installing support files. Formatting and installing it before .NET did not help.
1. Stop using the repacked or modified installer you downloaded. 2. Download the SQL Server installer directly from Microsoft (a forum moderator linked the official download). 3. Run that...
✓ Confirmé par l'auteur du sujetTuServerMU · 2017-09-17MSVCP100.DLL is missing when starting ConnectServer, DataServer or JoinServer (MuEmu S6 files).
Install the Microsoft Visual C++ 2010 Redistributable (x86, plus x64 on 64 bit Windows). Prefer the Microsoft download over single DLL sites.
✓ Confirmé par l'auteur du sujetTuServerMU · 2018-06-11Korean, 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 verifiedRédigé par MuADMINSHow 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 verifiedRédigé par MuADMINSWhat 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 verifiedRédigé par MuADMINS"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 verifiedRédigé par MuADMINSCould 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 verifiedRédigé par MuADMINSMuDevs: 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 verifiedRédigé par MuADMINSHow 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 verifiedRédigé par MuADMINSIGCN 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 verifiedRédigé par MuADMINSHow do I add WCoin or Goblin Points to an account with a SQL query on IGCN files?
The table is T_InGameShop_Point, but the columns changed between seasons: - Season 9 and 12: AccountID, WCoinC, WCoinP, GoblinPoint (float) - Season 16, 17, 18: AccountID, WCoin, GoblinPo...
Not verifiedRédigé par MuADMINS



