MuADMINS
Решения
Короткие исправления частых проблем серверов, клиентов и сайтов MU Online, каждое с источником и датой. “Подтверждено” означает, что автор вопроса сообщил, что исправление сработало.
Решений: 69 по запросу “SQL Server” в категории «Настройка сервера» для IGCN и любых файлов · Сбросить
How 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 verifiedНаписано MuADMINSHow do I add WCoin or Goblin Points to an account with a SQL query on IGCN files?
The table is T_InGameShop_Point, but the columns changed between seasons: - Season 9 and 12: AccountID, WCoinC, WCoinP, GoblinPoint (float) - Season 16, 17, 18: AccountID, WCoin, GoblinPo...
Not verifiedНаписано MuADMINSWhy did IGCN CreateDatabase.sql delete my databases, and what must I change before running it?
Database\1. Full Scripts\CreateDatabase.sql starts with two switches: - DECLARE @DropExistingDatabases INT = 1: with 1 it DROPS existing databases named Me_MuOnline, MuOnline, Events, Ran...
Not verifiedНаписано MuADMINSHow 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 verifiedНаписано 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 verifiedНаписано MuADMINSSQL Server 2000 setup says there is not enough free disk space although 60 GB are free
1. Extract the SQL Server 2000 installer files with WinRAR into a normal folder. 2. Run setup from that extracted folder.
✓ Подтверждено автором темыDarksTeam · 2010-08-08SQL 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...
✓ Подтверждено автором темыTUServerMU · 2021-03-3097d GameServer on a VPS says 'Failed to connect to SQL Server' although the SQL login, the MuOnline database and the IPs look correct
The database and the SQL settings were fine; the IP passed to GameServer.exe in its shortcut was the problem. 1. Right-click the GameServer.exe shortcut you start the server with and open...
✓ Подтверждено автором темыTUServerMU · 2021-02-08Creating the MuOnline ODBC data source fails with 'SQL Server Error: 2' (EX700 server, SQL Express)
1. Error 2 means the ODBC wizard cannot find the SQL Server you typed. 2. Make sure the SQL Server service is running. 3. With SQL Server Express the server name must include the instance...
✓ Подтверждено автором темыRaGEZONE · 2015-04-22SQL Server 2008 R2 setup crashes and closes while installing support files. Formatting and installing it before .NET did not help.
1. Stop using the repacked or modified installer you downloaded. 2. Download the SQL Server installer directly from Microsoft (a forum moderator linked the official download). 3. Run that...
✓ Подтверждено автором темыTuServerMU · 2017-09-17SQL Server 2012 installed without errors but SQL Server Agent will not start (Browser starts fine) when preparing MU files. What fixed it?
1. In services.msc set SQL Server Agent to Automatic and try to start it. 2. If it still fails, the instance was installed with the wrong authentication choice. 3. Reinstall SQL Server an...
✓ Подтверждено автором темыTuServerMU · 2018-11-19IGCN 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...
✓ Подтверждено автором темыRaGEZONE · 2019-07-14What breaks a MU server database? Safe SQL checklist before you run a query
What breaks MU databases most often, and what the pack files themselves show: 1. UPDATE while the server runs: the server writes online characters back from memory (IGCN maintenance scrip...
Not verifiedНаписано MuADMINSI 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 verifiedНаписано MuADMINSHow 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 verifiedНаписано MuADMINSHow do I add WCoinC, WCoinP or Goblin Points with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files (CashShopData)?
The table is CashShopData (AccountID, WCoinC, WCoinP, GoblinPoint). 1. Account offline (best: server closed), backup first, look at the row: SELECT AccountID, WCoinC, WCoinP, GoblinPoint...
Not verifiedНаписано MuADMINSHow 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 verifiedНаписано MuADMINSWhich databases do IGCN files need (MuOnline, Me_MuOnline, Events, Ranking, BattleCore) and in which order do the update scripts run?
IGCN files use up to five databases: - MuOnline: accounts (MEMB_INFO, MEMB_STAT), characters, guilds, warehouse, cash shop (T_InGameShop_Point), VIP (T_VIPList). - Me_MuOnline: optional s...
Not verifiedНаписано MuADMINSSQL command to give credits to every account (DarksTeam 97d+99i)
1. Open SSMS / Query Analyzer on the MuOnline database. 2. For all accounts run UPDATE MEMB_CREDITS SET credits=credits+500. 3. For one account run UPDATE MEMB_CREDITS SET credits=credits...
✓ Подтверждено автором темыDarksTeam · 2021-12-28IGCN 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...
✓ Подтверждено автором темыRaGEZONE · 2020-01-08



