MuADMINS
Lösungen
Kurze Fixes für häufige Probleme mit Server, Client und Website bei MU Online, jeweils mit Quelle und Datum. “Bestätigt” heißt: Die Person, die gefragt hat, hat gesagt, dass der Fix funktioniert hat.
116 Lösungen für “online accounts” · Zurücksetzen
OpenMU: I start main.exe with the ClientLauncher pointing to 127.0.0.1:44405 and nothing happens, the server never sees a connection.
1. The original client refuses 127.0.0.1. 2. Use another loopback address instead, usually 127.127.127.127, with port 44405. 3. Set it in the ClientLauncher (or in main.exe with a hex edi...
✓ Im Issue bestätigtGitHub (MUnique/OpenMU) · 2019-02-15WebEngine vote module with MuEmu files does not add the GP/points after voting.
1. AdminCP > Credit configuration used by the vote reward. 2. Set User Identifier to Username (the MuEmu table stores the account name). 3. Save and vote again to test.
✓ Vom Threadersteller bestätigtTuServerMU · 2018-06-22WebEngine 1.2 on cPanel hosting: AdminCP cannot be opened after the install.
1. First log in on the normal site login page with the game account you set as admin during the install. 2. While logged in, open AdminCP (the AdminCP button appears for that account). 3....
✓ Vom Threadersteller bestätigtTuServerMU · 2021-01-28/reset always costs 100 million Zen no matter what is set in the command config.
1. Open MuServer\Data\Util\ResetTable.txt. 2. Set Money_AL0 to Money_AL3 to the wanted cost per account level. 3. Reload.
✓ Vom Threadersteller bestätigtTuServerMU · 2019-07-15MuEmu S6: where to change the success rate of Jewel of Harmony refining (Elphis) and refining stones (Osbourne)?
1. Open the ChaosMix settings in GameServer/DATA (GameServerInfo - ChaosMix). 2. JewelOfHarmonyItemPurityMixRate_AL0 to _AL3 set the gemstone to Harmony rate per account level. 3. JewelOf...
✓ Vom Threadersteller bestätigtTuServerMU · 2020-09-11JoinServer and DataServer stopped connecting to the database (MuEmu Season 8)
Restoring the database and the ODBC data sources again did not help: the SQL login the servers use did not have the rights it needs. 1. Open SQL Server Management Studio and go to Securit...
✓ Vom Threadersteller bestätigtTUServerMU · 2018-10-06IGCN: 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 verifiedVon MuADMINS geschriebenWhich 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 verifiedVon MuADMINS geschriebenWhat 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 verifiedVon MuADMINS geschriebenHow do I set up WebEngine credits (WCoin, Goblin Points, web credits) for my server files?
WebEngine keeps each currency in a row of WEBENGINE_CREDITS_CONFIG: config_database, config_table, config_credits_col, config_user_col, config_user_col_id (userid, username or email), con...
Not verifiedVon MuADMINS geschriebenWebEngine 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 verifiedVon MuADMINS geschriebenHow do I fix a vault (warehouse): forgotten vault password, or a broken vault that must be emptied safely?
Every MSSQL family we read has warehouse (AccountID, Items varbinary, Money, EndUseDate, pw ...); the Items size differs (IGCN S17 7680 bytes, MuDevs 6000, X-Team S17 4800, WebZen S2 1920...
Not verifiedVon MuADMINS geschriebenUnicode (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 verifiedVon MuADMINS geschriebenKorean, 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 verifiedVon MuADMINS geschriebenI changed a character, coins or a vault with SQL and the change disappeared (UPDATE while the server is on)
The running server keeps its own copy of every online character and account and writes it back to the database, so an UPDATE made while that player is online can be overwritten a moment l...
Not verifiedVon MuADMINS geschriebenMuDevs: 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 verifiedVon MuADMINS geschriebenWhat is in the X-Team MuOnline database (password column, VIP, coins, resets, gens, master level)?
X-Team uses one database, MuOnline, with the MuEmu procedure set. - Accounts: MEMB_INFO.memb__pwd varchar(10) (plain; no MD5 function in the scripts), sno__numb char(18), AccountLevel / A...
Not verifiedVon MuADMINS geschriebenMSPro: the shipped query "Dar coin ganador gs" (WCoin for the Castle Siege winner) is broken
The file Tools - Querys Y Otros\Query-Sql\Dar coin ganador gs.txt has three problems: 1. Line 1 update CashShopData set WCoinC= WCoinC+1000 where AccountID in has nothing after IN (syntax...
Not verifiedVon MuADMINS geschriebenLouis / MuEmu Season 6: "Invalid column name" after updating the server files (which Update script adds which column)
Louis (JogandoMU) Season 6 files ship one SQL file per update. If the files are newer than the database, the server logs Invalid column name 'X'. Find X below and run that script (and the...
Not verifiedVon MuADMINS geschriebenHow do I reset a character with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files (ResetCount) with the server closed?
Columns: Character.ResetCount and MasterResetCount (X-Team also ResetDay, ResetWek, ResetMon and MasterResetDay / Wek / Mon for the daily, weekly and monthly limits). The server reads and...
Not verifiedVon MuADMINS geschrieben