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: 145 dla “cannot open database” · Wyczyść
How do I give VIP (AccountLevel) to an account with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files?
In MuEmu based files VIP is MEMB_INFO.AccountLevel (0 = normal, the AL1 / AL2 / AL3 levels of your configs) with MEMB_INFO.AccountExpireDate. Use the shipped procedure, account offline: E...
Not verifiedNapisane przez MuADMINSHow do I give or extend VIP for an account with SQL on IGCN files (IGC_VipAdd, T_VIPList)?
IGCN keeps the active VIP in T_VIPList (AccountID, Date, Type); MEMB_INFO also has VipType, VipStart, VipDays. The shipped procedure is IGC_VipAdd @szCharName, @DayAdd, @VipType. Despite...
Not verifiedNapisane przez MuADMINSMu Launcher v1.3 (RJ launcher, harlcreeds): how to set the server IP, the patch link and the registration
1. Run rjdllcreator.exe and type your server IP: it builds rjconnect.dll, the connector the launcher uses. 2. Install a web server (WAMP www, XAMPP htdocs, nginx html) and copy the rjlaun...
IGCN Essential Tools (S9 E2 repack) shows an error pop-up as soon as it is opened.
1. Open SQL Server Configuration Manager > SQL Server Network Configuration > Protocols. 2. Enable Named Pipes and TCP/IP. 3. In TCP/IP properties > IP Addresses set TCP Port 1433 (IPAll)...
✓ Potwierdzone przez autora tematuRaGEZONE · 2018-06-18IGCN 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-15How 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 MuADMINSThe website always shows 2 players online even when the server is off
Stale rows in MEMB_STAT still say the accounts are connected. 1. Open Query Analyzer / SSMS on the MuOnline database. 2. Run UPDATE MEMB_STAT SET ConnectStat='0' WHERE ConnectStat>0. 3. R...
✓ Potwierdzone przez autora tematuDarksTeam · 2009-03-03DarksTeam Season 3 Episode 2 (Beta 19) Cash Shop: a bought Seal disappears after reconnect
The seal was saved with a wrong date format in t_perioditem_info. 1. Open the stored procedure t_perioditem_insert in the MuOnline database. 2. Fix the datetime format it uses when insert...
✓ Potwierdzone przez autora tematuDarksTeam · 2009-08-09Guild war gives no points: the website shows a negative score and the in-game G Score stays 0
The Guild table column G_Score had no default value, so new guilds got NULL. 1. Open SQL Server > MuOnline database > Tables > Guild > Design Table. 2. Select the column G_Score and set i...
✓ Potwierdzone przez autora tematuDarksTeam · 2010-05-03How to protect Game Master characters (give them the protected GM status)
The GM status is the CtlCode column of the character. 1. Open the MuOnline database in SQL Server. 2. Run UPDATE Character SET CtlCode = '8' WHERE Name='<GM name>' (the asker confirmed 8...
✓ Potwierdzone przez autora tematuDarksTeam · 2012-05-11IGCN S9 E2 repack: DataServer says 'Login failed for user ...' (SQLSTATE 28000) and 'DATA SERVER CANNOT CONNECT TO MSSQL'
1. The repack DataServer config came with a SQL login that does not exist on your SQL Server (here a random name like D2a78Rtko0), so the login fails. 2. Open the database settings of the...
✓ Potwierdzone przez autora tematuRaGEZONE · 2019-07-14After enabling TCP/IP in SQL Server for the web, DataServer, JoinServer and GameServerCS lost the database connection. How was it fixed?
1. In SQL Server Configuration Manager keep Named Pipes and TCP/IP enabled for the instance. 2. Open the ODBC DSNs used by the server files. 3. Change the Server field from the LAN IP to...
✓ Potwierdzone przez autora tematuTuServerMU · 2020-05-23MuCore on XAMPP on the same VPS as SQL Server cannot connect to the database.
1. Easiest: in the MuCore config.php change the connection type from MSSQL to ODBC. 2. Or open SQL Server Configuration Manager, enable TCP/IP and Named Pipes, and restart SQL Server. 3....
✓ Potwierdzone przez autora tematuTuServerMU · 2017-12-27After the VPS (SQL) IP changed, a WebEngine CMS 1.2.4 site hosted on a separate Linux server shows 'Connection to database failed (MuOnline)' and the installer says the install is already complete.
1. Open includes/config/webengine.json and set "webengine_cms_installed": false, then upload it. 2. In the web host cPanel open PHP Selector and (re)enable pdo_dblib and pdo_sqlsrv. 3. Ru...
✓ Potwierdzone przez autora tematuRaGEZONE · 2024-02-16Items ask for more stats than shown and only equip after relogging (Louis free S6).
1. Louis first advice: item.bmd (client) and Item.txt (server) must match. 2. Here the asker had changed the starting stats of the classes directly in the database, which caused the confl...
✓ Potwierdzone przez autora tematuCreandoMU · 2021-08-31MuEmu: 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...
✓ Potwierdzone przez autora tematuCreandoMU · 2020-09-28Cash Editor gives an error when editing credits, although the SQL user and password are set
The cash table and column names in the editor config were wrong. 1. Open the editor config file (XTRMu in the thread). 2. [SQLConnection]: SQLHost = (local), SQLUser = your SQL user, SQLP...
✓ Potwierdzone przez autora tematuTUServerMU · 2020-07-10How to remove the master skill tree skills from every character at once (S6 Up15 GamingMaster files); DELETE MasterSkillTree did not remove them
The learned skills are stored in the MagicList column of the Character table. 1. Back up the database and close the server. 2. Run: USE MuOnline; UPDATE Character SET [MagicList] = CONVER...
✓ Potwierdzone przez autora tematuTUServerMU · 2021-05-09X-Team Season 15 files (update 5): GameServer shows a message that something 'does not exist' and will not start
The error is about the server code and the GameServer common file of the update. 1. Check the ServerCode is the same in ConnectServer\ConnectServer.txt, Data\MapServerInfo and the GameSer...
✓ Potwierdzone przez autora tematuTUServerMU · 2020-08-15IGCN Season 12: DataServer is not responding although TCP/IP is enabled in SQL Server
1. Open DataServer.ini and check SQLServerName. 2. When SQL Server runs on the same machine use SQLServerName = (local) or the exact PC name as shown in SQL Server Management Studio (for...
✓ Potwierdzone przez autora tematuRaGEZONE · 2020-01-08