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.
235 Lösungen für “database” · Zurücksetzen
How do I make a working online time ranking per character?
1. Add an int column OnlineTime to the Character table (back up first). 2. Create a SQL Agent job every minute: UPDATE Character SET OnlineTime=OnlineTime+1 joined to MEMB_STAT (ConnectSt...
✓ Vom Threadersteller bestätigtCreandoMU · 2021-03-09How do I give GoblinPoints each time a character resets (Season 6 MuEmu)?
1. In SSMS edit the procedure WZ_SetResetInfo. 2. Below the line that starts with UPDATE Character add UPDATE CashShopData SET GoblinPoint=GoblinPoint+100 WHERE AccountID=@Account. 3. Exe...
✓ Vom Threadersteller bestätigtCreandoMU · 2021-01-21DarkMaster Season 3 Episode 1: every login says the account is invalid, although all IPs are changed
The JoinServer password mode (MD5 or plain) did not match how the accounts were created. 1. Delete the test accounts. 2. Put the JoinServer build with MD5 enabled and create the account a...
✓ Vom Threadersteller bestätigtDarksTeam · 2010-03-09MuEmu (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...
✓ Vom Threadersteller bestätigtTUServerMU · 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...
✓ Vom Threadersteller bestätigtTUServerMU · 2020-11-15DarksTeam 97d+99i moved to a VPS (Windows Server 2012 R2, SQL 2008 R2): RankingServer shows an error although the config did not change
The VPS firewall was blocking the RankingServer connections. 1. In Windows Firewall (and the VPS provider firewall, if any) allow the RankingServer program, or open the port it uses, for...
✓ Vom Threadersteller bestätigtTUServerMU · 2020-07-08Aminyuz 97d files: GameServer gives a conexion.ini connection error at start although all IPs are right (EventServer and Ranking open fine)
The SQL login in the Aminyuz connection file was wrong. 1. Open C:\MuServer\Aminyuz\Conexion (the connection ini of these files). 2. In the [SQL] block set Usuario = sa (your SQL user), C...
✓ Vom Threadersteller bestätigtTUServerMU · 2020-02-21Anyone can log in with a random account name and password, and the login creates that account in SQL
1. This is not a database bug: the server has automatic account registration switched on, so an unknown login is created on the spot. 2. Open the JoinServer config (in some files the opti...
✓ Vom Threadersteller bestätigtRaGEZONE · 2021-04-15IGCN Season 9 repack: GameServerCS shows an error when Castle Siege is configured, even with correct settings.
1. The SQL Server language caused it. 2. Install SQL Server in English (English instance) and restore the databases there. 3. Start GameServerCS again.
✓ Vom Threadersteller bestätigtTuServerMU · 2017-06-18IGC DataServer stays on its loading window and never finishes starting.
1. Check the ODBC/SQL settings of the DataServer. 2. The SQL instance name was wrong. When SQL Server is on the same PC use (local) as the instance/host. 3. Start the DataServer again.
✓ Vom Threadersteller bestätigtTuServerMU · 2017-04-21Louis (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...
✓ Vom Threadersteller bestätigtRaGEZONE · 2024-08-02Cash Shop and VIP Editor (Dino): how to connect it to SQL Server and which columns it needs
1. Enter the SQL Server IP, login, password and port, then click Connect. 2. Leave the filter empty to list all accounts, or type an account name. 3. Choose the VIP type and the amount of...
"Login failed for user 'sa'" (SQLSTATE 28000) from DataServer or the web right after installing SQL Server. How do I enable sa?
1. If setup used Windows authentication only, sa is disabled. 2. In Management Studio right click the server > Properties > Security and pick SQL Server and Windows Authentication mode. 3...
MuMaker: "Login failed for user 'sa'" although the server runs and the password is right (only one MuMaker build works)
1. Check that the sa login has rights on the MU databases and that the password in the MuMaker Config.ini is right. 2. If it still says login failed, the MuMaker build does not fit your s...
✓ Vom Threadersteller bestätigtRaGEZONE · 2011-06-30MuEmu Editor (2017) + Fixs: an error shows at start although Config.ini has localhost, port 1433, sa and the password
1. Open the editor Config.ini. 2. In the [Me_MuOnline] and [MuOnline] blocks change EnableTrusted = 0 to EnableTrusted = 1. 3. Save and start the editor again: it connects.
✓ Vom Threadersteller bestätigtTUServerMU · 2017-04-29IGCN 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...
✓ Vom Threadersteller bestätigtTuServerMU · 2018-10-15WebEngine: 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 verifiedVon MuADMINS geschriebenA character exists in the Character table but does not appear (AccountCharacter slots)
The character list of an account is kept in AccountCharacter (Id = account, GameID1 to GameID5, or to GameID10 on newer files, plus GameIDC). The packs' WZ_CreateCharacter writes the new...
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 geschriebenWebEngine 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 verifiedVon MuADMINS geschrieben