MuADMINS
Soluții
Rezolvări scurte pentru probleme frecvente ale serverelor, clienților și site-urilor MU Online, fiecare cu sursa și data ei. “Confirmată” înseamnă că persoana care a întrebat a spus că rezolvarea a funcționat.
Soluții: 239 pentru “sql server” · Șterge
0.97d: every item (even shop items) gets serial 00000000.
1. The trigger that creates item serials was deleted when the server was reset. 2. Recreate the serial trigger (run its script with the server off) and check the item serial counter is no...
✓ Confirmată de autorul topiculuiImperyus Games Brasil · 2013-05-26How 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...
✓ Confirmată de autorul topiculuiCreandoMU · 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...
✓ Confirmată de autorul topiculuiDarksTeam · 2010-03-09Louis (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...
✓ Confirmată de autorul topiculuiRaGEZONE · 2024-08-02How do I fix a vault (warehouse): forgotten vault password, or a broken vault that must be emptied safely?
Every MSSQL family we read has warehouse (AccountID, Items varbinary, Money, EndUseDate, pw ...); the Items size differs (IGCN S17 7680 bytes, MuDevs 6000, X-Team S17 4800, WebZen S2 1920...
Not verifiedScris de MuADMINSMuEditor 2.1 (SkyTeam): how to set it up on another PC to edit the server database remotely (ODBC and DNS.ini)
1. On the PC where you run MuEditor open Control Panel, Administrative Tools, Data Sources (ODBC). 2. In System DSN click Add, choose SQL Server: Name MuOnline, Description MuEditor, Serv...
IzsMuEditor 2.1.2 (EX803): the editor does not connect to the database
1. By default IzsMuEditor connects through an ODBC DSN. 2. If it does not connect, open Data\IzsConfig.ini, set Use_ODBC to 0 and fill in your SQL connection data (server, user, password)...
RJLauncher: how to set up the launcher and its patch download for Louis files (patchver, patchlink, launch line)
1. Set up a web server first (for example XAMPP) and make sure the site works; locally the IP is 127.0.0.1, for players use your public IP and forward the game ports and the web port (usu...
✓ Confirmată de autorul topiculuiRaGEZONE · 2022-03-17MuEmu Editor: an error appears when searching an account and inventory changes are not saved ('los cambios no han sido guardados')
1. Open the editor Config.ini and check the database names in both blocks: ME_DB under [Me_MuOnline] and MU_DB under [MuOnline]. 2. They must match the real name of your database in SQL S...
✓ Confirmată de autorul topiculuiTUServerMU · 2018-06-04MuEmu: 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...
✓ Confirmată de autorul topiculuiCreandoMU · 2020-09-28How to protect the server from attackers with the firewall
Only the ConnectServer and GameServer must be reachable from outside. 1. In the firewall block outside access for: MySQL (mysqld.exe), the DataServer(s), ExDB, EventServer, RankingServer,...
✓ Confirmată de autorul topiculuiDarksTeam · 2008-06-30Characters stop at level 350 (max level) but the website reset asks for level 400 (97d+99i)
On 97d+99i the max level cannot be raised, so lower the reset level on the website instead. 1. Open SQL Server Enterprise Manager > MuOnline > Tables. 2. Find the MuWeb table, right click...
✓ Confirmată de autorul topiculuiDarksTeam · 2009-10-31DarksWeb 0.1: the news cannot be deleted from the site admin
The news and admin data of DarksWeb are stored in the database, not in the PHP files. 1. Open SQL Server and go to Databases > MuOnline > table MuWeb_admin. 2. Edit or delete the news row...
✓ Confirmată de autorul topiculuiDarksTeam · 2011-04-14MuCore website Exchange System always shows 0 Online Hours although the character was online for hours (DarkMaster 97d server)
The MuCore module reads the column OnlineMinutes, which did not exist in the database. 1. Take the online-time SQL script from the thread (it adds a column to MEMB_STAT and changes the st...
✓ Confirmată de autorul topiculuiDarksTeam · 2019-07-25MuCore 1.0.6 admin panel: 'Edit module' and 'Edit pages' are broken
1. The helper's advice was to use MuCore 1.0.8 (and XAMPP 1.7.1 for SQL 2000/2005, or XAMPP 1.7.7 with MSSQL enabled for SQL 2008 or newer). 2. Replacing the whole folder caused other pro...
✓ Confirmată de autorul topiculuiRaGEZONE · 2017-08-03MuCore 2.2.0: the add and edit buttons for modules do not show in the admin panel
1. MuCore 2.2.0 does not work properly on PHP 7.x. 2. Run it on PHP 5.6: the topic starter installed XAMPP with PHP 5.6.40 plus the PDO fix for SQL Server. 3. On a web host, switch the PH...
✓ Confirmată de autorul topiculuiRaGEZONE · 2019-03-05MuCore 1.08 rankings show only one character (or none) while players are online
1. MuCore only ranks characters whose CtlCode is 0 in the Character table; characters with another value are left out. 2. In SQL Server set CtlCode to 0 for the normal player characters....
✓ Confirmată de autorul topiculuiRaGEZONE · 2017-11-03Kayito MuEmu 0.97k download has no JoinServer and DataServer folders. Where are they?
1. First choose your database engine: SQL Server or MySQL. 2. For SQL Server copy JoinServer and DataServer from the MSSQL folder; for MySQL take them from the MySQL folder. 3. Put both n...
✓ Confirmată în raportul problemeiGitHub (nicomuratona/MuEmu-0.97k-kayito) · 2025-06-22Files 99B DarksTeam on Windows 7: MuServer startup throws an ODBC error even with the 64-bit ODBC .reg applied. How was it solved?
1. Use the ODBC .reg (or manual DSN) that matches your Windows: 32-bit or 64-bit. 2. Make sure the databases were created or restored in SQL Server. 3. Right click the startup shortcuts (...
✓ Confirmată de autorul topiculuiTuServerMU · 2018-06-16DMN CMS with MuEmu S6E3 files: reset and grand reset modules do not work.
1. Open the Character table in SQL and read the exact column names. 2. In the DMN config type them exactly, with the same upper and lower case (for example ResetCount, not reset or resetc...
✓ Confirmată de autorul topiculuiTuServerMU · 2018-11-22