MuADMINS
Решения
Короткие исправления частых проблем серверов, клиентов и сайтов MU Online, каждое с источником и датой. “Подтверждено” означает, что автор вопроса сообщил, что исправление сработало.
Решений: 80 по запросу “columns” · Сбросить
Where do I change how much damage monsters do? Is it MonsterSetBase?
1. Not MonsterSetBase (that file only places monsters on maps). 2. MuEmu style files: open Monster.txt and change the DamageMin and DamageMax columns of the monster. 3. Files with XML dat...
✓ Подтверждено автором темыRaGEZONE · 2023-08-30MuOnlineWebs with Louis S6 files: /reset works in game but the website does not count the resets
1. Louis files store resets in the column ResetCount, while MuOnlineWebs reads Resets by default. 2. In the MuOnlineWebs admin panel open the Table Settings. 3. Change the reset column fr...
✓ Подтверждено автором темыRaGEZONE · 2020-12-15Accounts registered on the website exist in MEMB_INFO, but the game says 'Your account is invalid'
1. Compare how the website stores passwords with what the JoinServer expects: look at the password column of the new accounts in MEMB_INFO. 2. If the website saves MD5 hashed passwords, e...
✓ Подтверждено автором темыRaGEZONE · 2026-04-05Replacing WZ_DISCONNECT_MEMB for MuCore gives 'Msg 468 ... Cannot resolve the collation conflict between Latin1_General_CS_AS and SQL_Latin1_General_CP1_CI_AS'
1. The procedure compares memb___id from MEMB_INFO with memb___id from MEMB_STAT, and the two columns use different collations. 2. In SQL Server Management Studio set the same collation o...
✓ Подтверждено автором темыRaGEZONE · 2015-11-30Louis S6 Up13 GameServer window never opens, shows an error and fills the folder with .dmp files after editing configs.
1. Restore the original Data folder; if the server starts, the bad file is in there. 2. Put your edited files back one by one, starting with the ones you changed, until it fails again. 3....
✓ Подтверждено автором темыTuServerMU · 2021-10-11MVCore web does not save WCoin (WCC) to the account on MuEmu S6E3 files.
1. In MVCore credit settings point to the MuEmu cash shop table. 2. Table: CashShopData. Account column: AccountID. Coin column: WCoinC (or the coin you want). 3. Save and test adding coi...
✓ Подтверждено автором темыTuServerMU · 2019-01-17How to set up the WebEngine Credit Manager so it gives WCoinC/WCoinP or Goblin Points on IGCN S6 files; adding credits says the account ID is invalid.
1. Database: MuOnline. Table: T_InGameShop_Point (check the exact name in your DB). 2. Credits column: the currency column you want (WCoinC, WCoinP or GoblinPoint). 3. User column: Accoun...
✓ Подтверждено автором темыRaGEZONE · 2022-07-11Chaos Cards do not drop in Land of Trials although a line was added to ItemDrop.txt.
1. The ItemDrop column in item.txt only applies when no custom drop is defined. 2. If the item is in ItemDrop.txt, set its ItemDrop value in item.txt back to 0. 3. Test with a much higher...
✓ Подтверждено автором темыTuServerMU · 2019-05-08MuEmu S6 Ep3: how to raise or lower jewel drops in one specific map?
1. Use ItemDrop.txt: each line has a MapNumber column. 2. Add the jewel with the map number and its own rate; repeat the item with other maps if needed. 3. Reload.
✓ Подтверждено автором темыTuServerMU · 2019-05-26Louis S6: edits to the bar shop do not show in game even after reload.
1. The wrong shop file was edited: the bar shop is '001 - Liaman the Barmaid'. 2. Use the line format of your update (update 13 lines end with extra columns like 0 0 0 255 255 255 255 255...
✓ Подтверждено автором темыTuServerMU · 2019-09-29MuEmu S6 Ep3: how to make monsters respawn faster after a spot is cleared?
1. The respawn time is not in MonsterSetBase on these files. 2. Open Monster.txt, find the RegenTime column for that monster and lower it. 3. Reload monsters.
✓ Подтверждено автором темыTuServerMU · 2020-08-04Louis S6 Ep3: after /reset the character gets a huge or negative Zen amount (shows -7000 in the database).
1. The Zen cost was set in two places that conflicted for /reset. 2. Set the MoneyReq columns of the reset command line in Command.txt to 0. 3. Keep the reset Zen cost only in GameServerI...
✓ Подтверждено автором темыTuServerMU · 2024-08-24MuEmu S6 EventItemBag drops random ancient items instead of the exact ancient items listed in the bag.
1. SetItemDropRate in the bag header only uses the general ancient pool, so it gives random sets. 2. Set SetItemDropRate to 0. 3. List the wanted items one by one in the item section and...
✓ Подтверждено автором темыRaGEZONE · 2020-04-26IGCN: players have negative WCoin or Goblin Points (shipped maintenance script)
IGCN ships 2. Update Scripts\Maintenance Scripts\Check & Fix negative Coins.sql. It works in two runs and says "Take server offline before proceeding with the script": 1. With @Update = 0...
Not verifiedНаписано MuADMINSWebEngine register error "String or binary data would be truncated" (sno__numb is shorter than 13 characters)
WebEngine 1.2.7 fills MEMB_INFO.sno__numb with _defaultAccountSerial = '1111111111111' (13 characters, includes/classes/class.account.php line 16). The column size depends on the files: -...
Not verifiedНаписано MuADMINSWebEngine: accounts made on the website cannot log in (password encryption must match memb__pwd)
WebEngine 1.2.7 has four password modes (install/definitions.php PDO_PWD_ENCRYPT) and writes MEMB_INFO differently for each: - none: memb__pwd = :password (plain), for varchar columns (IG...
Not verifiedНаписано MuADMINSUnicode (NVARCHAR) migration of a MuEmu / Louis Season 6 database: what is right and what breaks
Review of a Season 6 Unicode script set (a migration that converts the name columns to NVARCHAR plus new WZ_CreateCharacter, WZ_DeleteCharacter, WZ_CreateGuild procedures). Its table list...
Not verifiedНаписано MuADMINSKorean, 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"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Написано MuADMINSPlayers 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