MuADMINS
Решения
Короткие исправления частых проблем серверов, клиентов и сайтов MU Online, каждое с источником и датой. “Подтверждено” означает, что автор вопроса сообщил, что исправление сработало.
Решений: 13 по запросу “columns” в категории «Сайт» · Сбросить
Which website CMS expects which MU database columns (WebEngine table maps, DmN)
WebEngine 1.2.7 picks a table map by server files (includes/config): - igcn.tables.php / custom.tables.php: resets = Character.RESETS, grand resets = Character.GrandResets, VIP = T_VIPLis...
Not verifiedНаписано MuADMINSWebEngine with X-Team files: online ranking fails with Invalid column name 'OnlineHours'
WebEngine's map for X-Team files (includes\config\xteam.tables.php) defines _CLMN_MS_ONLINEHRS_ = OnlineHours, and the online ranking (only for xteam files) runs: SELECT TOP n memb___id,...
Not verifiedНаписано MuADMINSWhat does the DmN CMS setup change in the MU database (columns, Character.id, WZ_CONNECT_MEMB) and what can break?
The DmN CMS 1.2.3 setup does more than create its own tables: 1. It ALTERs the game databases: adds columns from its version files, for example MEMB_INFO Admin, last_login, activated, act...
Not verifiedНаписано MuADMINS/reset works in game but the website still shows 0 resets (newest DarksTeam files)
The server writes resets to the column Resets, while the website reads another column (Reset). 1. Open the website config (usually config.php) and find $res_column_name. 2. Set it to $res...
✓ Подтверждено автором темыDarksTeam · 2017-06-13DMN CMS with MuEmu S6E3 files: reset and grand reset modules do not work.
1. Open the Character table in SQL and read the exact column names. 2. In the DMN config type them exactly, with the same upper and lower case (for example ResetCount, not reset or resetc...
✓ Подтверждено автором темыTuServerMU · 2018-11-22Morpheus web install stops with error 47.
1. Back up the database first. 2. Delete the columns Credits, indocation and indicated from MEMB_INFO. 3. Run the Morpheus installer again.
✓ Подтверждено автором темыCreandoMU · 2020-08-08MuCore website Exchange System always shows 0 Online Hours although the character was online for hours (DarkMaster 97d server)
The MuCore module reads the column OnlineMinutes, which did not exist in the database. 1. Take the online-time SQL script from the thread (it adds a column to MEMB_STAT and changes the st...
✓ Подтверждено автором темыDarksTeam · 2019-07-25MuOnlineWebs 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-05MVCore 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-11WebEngine 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Написано MuADMINS