MuADMINS
Rozwiązania
Krótkie poprawki częstych problemów z serwerem, klientem i stroną MU Online, każda ze źródłem i datą. “Potwierdzone” oznacza, że osoba, która pytała, potwierdziła, że poprawka zadziałała.
Rozwiązania: 50 dla “resets” · Wyczyść
How 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 verifiedNapisane przez MuADMINSHow do I reset a character with SQL on IGCN files (RESETS, GrandResets) with the server closed?
Columns in IGCN Character: RESETS (int, all seasons), GrandResets (tinyint, Season 16, 17, 18), GRANDRESET (Season 12), plus cLevel, Experience, LevelUpPoint and the stats. 1. Close the G...
Not verifiedNapisane przez MuADMINSReset Generator: how to make the SQL reset script and run it automatically with SQL Server Agent
1. Tick the options you want for a character reset (the settings of your server) and press Generate Reset. 2. The program writes the SQL code (script) of your reset system. 3. Copy it and...
MuMaker: how to fill the first configuration window (SQL user, local or remote, MD5, database names, reset column)
1. Extract MuMaker and start MuMaker.exe. 2. Type any name (server name or yours), the SQL user (sa by default) and its password. 3. Connection type: choose local when MuMaker runs on the...
With dynamic EXP by resets the Master Level EXP also changes. How do I control ML EXP separately?
1. Use ExperienceTable.txt, which has MinMasterLevel and MaxMasterLevel columns. 2. Add lines per ML range, for example 400 800 0 50 * * * * 24, then 51 100 with 20, and so on. 3. The rat...
✓ Potwierdzone przez autora tematuCreandoMU · 2021-02-11Where are accounts, VIP, credits, resets and bans in the DV-Team Season 19 database (MySQL / MariaDB)?
DV-Team does not use SQL Server: the database is a MySQL / MariaDB dump (Navicat), databases muonline (127 tables) and log (22 tables). There is no MEMB_INFO and no stored procedure, so S...
Not verifiedNapisane przez MuADMINSWhat 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 verifiedNapisane przez MuADMINSIGC.EssentialTools crashes after the first-run notice although SQL named pipes and TCP/IP are enabled (crash dump in CrashDumps)
1. Symptoms: the first-run notice pops up, then the tool crashes on every start; compatibility mode and run as admin do not help; a dump such as IGCN.EssentialTools.exe.5908.dmp appears i...
✓ Potwierdzone przez autora tematuRaGEZONE · 2020-01-05Web JM final: rankings show nothing although the site works.
1. Check the procedure WZ_SetResetInfo in the MuOnline database (Louis emulator). 2. Fix it so resets are written where the site reads them. 3. Reload the rankings.
✓ Potwierdzone przez autora tematuCreandoMU · 2020-08-11How to stop WebEngine from showing GM/admin characters in the level and reset rankings.
1. AdminCP > website settings > Module Manager > Rankings. 2. In 'Excluded Characters' add the admin character names separated by commas. 3. Save and wait for the next ranking cron run.
✓ Potwierdzone przez autora tematuTuServerMU · 2020-06-15Which 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 verifiedNapisane przez MuADMINSLouis files: after testing the auction system no new auction starts (or it starts and ends at once).
1. A finished auction does not run again. 2. Back up the database, then run on MuOnline: DELETE FROM EventAuction and DELETE FROM EventAuctionReward. 3. Restart the GameServer to start ne...
✓ Potwierdzone przez autora tematuCreandoMU · 2020-12-02SQL query to delete only characters and guilds but keep the accounts and their warehouse
1. Make a full backup of the database first. 2. In SQL Server Management Studio run: USE MuOnline; DELETE Character (characters). 3. For guilds run: DELETE Guild; DELETE GuildMember. 4. M...
✓ Potwierdzone przez autora tematuTUServerMU · 2021-03-30How do I set a new password for one account in SQL on IGCN files (plain, WZ_MD5 or md5 text)?
Use the form that matches PasswordEncryptType in IGCDS.ini and the memb__pwd column type. Keep the account offline and always use WHERE. - Type 0 (varchar(20)): UPDATE MEMB_INFO SET memb_...
Not verifiedNapisane przez MuADMINSMuMain: the macOS build fails with Homebrew LLVM 23: 'use of undeclared identifier malloc' in the spdlog bundled format.h
1. The macOS toolchain picks Homebrew LLVM when it is installed. With LLVM 23.1.1 the build stops with format.h:747:28: error: use of undeclared identifier 'malloc' (spdlog v1.15.3 bundle...
✓ Potwierdzone w zgłoszeniuGitHub (sven-n/MuMain) · 2026-10-08MainInfo (Louis Update 13): how to remove the rank icons (Custom Rank User, patentes) shown over the characters
1. Open the main info config you use to generate the Main (Premium) and find the block Custom Rank User (Patentes). 2. Pick the mouse over type with RankUserType: 0 complete, 1 no stats,...
✓ Potwierdzone przez autora tematuTUServerMU · 2018-12-160.97d: every item (even shop items) gets serial 00000000.
1. The trigger that creates item serials was deleted when the server was reset. 2. Recreate the serial trigger (run its script with the server off) and check the item serial counter is no...
✓ Potwierdzone przez autora tematuImperyus Games Brasil · 2013-05-26IGCN Season 13 files: how to give new characters a starting amount of zen.
1. In SSMS run on MuOnline a query that creates an INSERT trigger on dbo.Character (named Bonus in the thread). 2. The trigger reads the new Name from INSERTED and runs UPDATE Character S...
✓ Potwierdzone przez autora tematuTuServerMU · 2018-10-15Louis (MuEmu) server ran out of item serials: every new item gets serial FFFFFFFF and is flagged as a dupe.
1. Serials come from the stored procedure WZ_GetItemSerial, which increments ItemCount in table GameServerInfo for every created item (drops, bags, commands). 2. Edit that existing proced...
✓ Potwierdzone przez autora tematuRaGEZONE · 2024-08-02What 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 verifiedNapisane przez MuADMINS