MuADMINS
Solutions
Short fixes for common MU Online server, client and website problems, each with its source and date. “Confirmed” means the person who asked said the fix worked.
7 solutions for “sql server” in Gameplay · Clear
Lowering the stat limit from 65000 to 32000 with a SQL query on IGCN-based S12 files does not work in game.
1. No SQL query is needed. 2. Edit MuServer/IGCData/IGC_PlayerInfo.xml and change the Max values per class (MaxStrenghtDW, MaxAgilityDW, MaxVitalityDW, MaxEnergyDW, MaxCommandDW and the s...
✓ Confirmed by the topic starterTuServerMU · 2018-08-22MuEmu (Emerson repack update 25): new characters get welcome items; where is that removed? It is not a SQL script
1. The start items are given by the server file MuServer\Data\Custom\CustomStartItem.txt, not by a database script. 2. Remove or comment the item lines there (or switch the system off in...
✓ Confirmed by the topic starterTUServerMU · 2021-06-03MuEmu S6 E3 Castle Siege: when the battle starts the defending guild shows as attacker, with no config change
The Castle Siege data stored in SQL had gone bad. 1. Back up the database first. 2. The asker cleared the SQL tables used by Castle Siege (in MuEmu databases they are the MuCastle_ tables...
✓ Confirmed by the topic starterTUServerMU · 2020-11-15IGCN 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...
✓ Confirmed by the topic starterTuServerMU · 2018-10-15Louis 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...
✓ Confirmed by the topic starterTuServerMU · 2024-08-24MuEmu: how do I set Castle Siege so registration opens by itself on Monday and the siege runs on Sunday?
1. Edit GameServerCS/Data/Event/MuCastleData.dat: state 7 sets the siege day and start hour, state 8 sets the end hour. 2. In GameServerCS/Data/GameServerInfo - Event.dat set CastleSiegeE...
✓ Confirmed by the topic starterCreandoMU · 2020-09-28MuEmu (Season 3 downgrade) Castle Siege does not work after following the guides
The Castle Siege timings had been shortened in the CS event file and that broke the cycle. 1. Put GameServerCS\DATA\Event.dat back to the original Castle Siege times. 2. On MuEmu you only...
✓ Confirmed by the topic starterTUServerMU · 2021-02-23



