Community AlphaAlpha MUADMINS
RUРусский
Войти
На MuADMINSConfig ScannerЗагрузите zip своих файлов: рейты, дропы, споты, лимитыОткрытьНа MuADMINSПрисоединяйтесь к нам в DiscordПросите помощи, показывайте свои проекты и общайтесь о MU с другими владельцами серверов.Открыть

MuADMINS

Решения

Короткие исправления частых проблем серверов, клиентов и сайтов MU Online, каждое с источником и датой. “Подтверждено” означает, что автор вопроса сообщил, что исправление сработало.

Решений: 24 по запросу “site” в категории «Настройка сервера» · Сбросить

  1. Настройка сервера

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

    ✓ Подтверждено автором темыDarksTeam · 2009-03-03
  2. Настройка сервераany (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...

    ✓ Подтверждено автором темыCreandoMU · 2021-04-12
  3. Настройка сервера

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

    ✓ Подтверждено автором темыDarksTeam · 2012-07-14
  4. Настройка сервераMuEmu / 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...

    ✓ Подтверждено автором темыRaGEZONE · 2018-04-09
  5. Настройка сервера

    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 verifiedНаписано MuADMINS
  6. Настройка сервера

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

    ✓ Подтверждено автором темыDarksTeam · 2010-05-03
  7. Настройка сервераMuDevsSeason 20.2-3 (free)

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

    ✓ Подтверждено автором темыMUDevs · 2026-01-01
  8. Настройка сервера

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

    ✓ Подтверждено автором темыDarksTeam · 2008-06-30
  9. Настройка сервера1.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...

    ✓ Подтверждено автором темыDarksTeam · 2008-11-25
  10. Настройка сервераany

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

    ✓ Подтверждено автором темыTuServerMU · 2017-09-17
  11. Настройка сервераMuEmu / LouisS6

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

    ✓ Подтверждено автором темыTuServerMU · 2018-06-11
  12. Настройка сервера

    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 verifiedНаписано MuADMINS
  13. Настройка сервера

    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 verifiedНаписано MuADMINS
  14. Настройка сервера

    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 verifiedНаписано MuADMINS
  15. Настройка сервера

    "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 verifiedНаписано MuADMINS
  16. Настройка сервера

    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 verifiedНаписано MuADMINS
  17. Настройка сервераMuDevsS18, 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 verifiedНаписано MuADMINS
  18. Настройка сервераS6, 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 verifiedНаписано MuADMINS
  19. Настройка сервераIGCNS12, 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 verifiedНаписано MuADMINS
  20. Настройка сервераIGCNS9, S12, S16, S17, S18

    How 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 verifiedНаписано MuADMINS

Видео на MUTube

Ещё видео по запросу «site»

Всё ещё не получается? Спросить Помощника MU Поиск в MuGPS

MuADMINS Community Alpha: бесплатно, создаётся сообществом, в активной разработке.