MuADMINS
Решения
Короткие исправления частых проблем серверов, клиентов и сайтов MU Online, каждое с источником и датой. “Подтверждено” означает, что автор вопроса сообщил, что исправление сработало.
Решений: 1 по запросу “script sql” в категории «Геймплей» · Сбросить
MuEmu (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...
✓ Подтверждено автором темыTUServerMU · 2021-06-03
Ещё ответы по запросу «script sql»
1 в разделе Геймплей, 49 в других категориях и серверных файлах:
Creating a character fails with 'Nombre de personaje incorrecto o ya existe' after installing a SQL script that gives points and zen to new characters (MuEmu S6 EP3 Louis Update 13)
The new character script wrote to columns that do not exist in this database. 1. Open the script (trigger) you added in SQL Server Management Studio. 2. Compare its column names with your...
✓ Подтверждено автором темыTUServerMU · 2020-05-04Season 2 Ep X (Evolution Team) files ship the database as SQL scripts, not a .bak. How do I create the database?
1. On SQL Server 2008 or newer, restore the database backup if the files include one. 2. On SQL Server 2000 or 2005, open Query Analyzer (Start menu) and log in as sa. 3. Paste the script...
✓ Подтверждено автором темыTuServerMU · 2016-12-14Reset 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...
Which 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Написано MuADMINSEvery time I leave the game my account is banned (after adding an anti-dupe ban script)
The ban-dupers SQL script that was added to the database does not work with every version and bans normal accounts. 1. Remove that script (trigger / job) from the MuOnline database. 2. Un...
✓ Подтверждено автором темыDarksTeam · 2010-01-05What 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Написано MuADMINSLouis / MuEmu Season 6: "Invalid column name" after updating the server files (which Update script adds which column)
Louis (JogandoMU) Season 6 files ship one SQL file per update. If the files are newer than the database, the server logs Invalid column name 'X'. Find X below and run that script (and the...
Not verifiedНаписано MuADMINSWhat are the MSPro database settings (ODBC, MD5Encryption, DisconnectOnlineAccount) and the update queries?
MSPro files connect through the ODBC DSN named MuOnline: - JoinServer\JoinServer.ini: JoinServerODBC = MuOnline, CaseSensitive = 0, MD5Encryption = 0, MaxIPLimit = 0, MaxHwIDLimit = 0, Di...
Not verifiedНаписано MuADMINS
