MuADMINS
Soluciones
Arreglos breves para problemas comunes de servidores, clientes y sitios web de MU Online, cada uno con su fuente y su fecha. “Confirmado” significa que la persona que preguntó dijo que el arreglo funcionó.
80 soluciones para “columns” · Limpiar
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...
✓ Confirmado por el autor del temaRaGEZONE · 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...
✓ Confirmado por el autor del temaRaGEZONE · 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...
✓ Confirmado por el autor del temaRaGEZONE · 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...
✓ Confirmado por el autor del temaRaGEZONE · 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....
✓ Confirmado por el autor del temaTuServerMU · 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...
✓ Confirmado por el autor del temaTuServerMU · 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...
✓ Confirmado por el autor del temaRaGEZONE · 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...
✓ Confirmado por el autor del temaTuServerMU · 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.
✓ Confirmado por el autor del temaTuServerMU · 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...
✓ Confirmado por el autor del temaTuServerMU · 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.
✓ Confirmado por el autor del temaTuServerMU · 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...
✓ Confirmado por el autor del temaTuServerMU · 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...
✓ Confirmado por el autor del temaRaGEZONE · 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 verifiedEscrito por 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 verifiedEscrito por 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 verifiedEscrito por 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 verifiedEscrito por 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 verifiedEscrito por 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 verifiedEscrito por 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 verifiedEscrito por MuADMINS