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: 84 pentru “database editor” · Șterge
Guild Editor: "An Error was found in your CMTedit.ini !" when it starts
1. Open CMTedit.ini next to the editor. 2. In [MuOnline] (and [MeMuOnline]) the DSN= value is the name of your ODBC data source, not the SQL Server name; it is generally MuOnline. Create...
Remote tools or the web cannot reach a SQL Express or named instance on port 1433. How do I make SQL listen on a fixed port?
1. Named instances use dynamic ports by default; only the default instance uses 1433. 2. SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for your instance...
What does the DmN CMS setup change in the MU database (columns, Character.id, WZ_CONNECT_MEMB) and what can break?
The DmN CMS 1.2.3 setup does more than create its own tables: 1. It ALTERs the game databases: adds columns from its version files, for example MEMB_INFO Admin, last_login, activated, act...
Not verifiedScris de MuADMINS"Account does not exist" or the login fails although the account is in MEMB_INFO: what to check in the database
Check these in order (all read only, nothing changes): 1. Is the server reading the same database? MuEmu, Louis, MSPro, X-Team, MuDevs use the ODBC DSN in JoinServer.ini (JoinServerODBC =...
Not verifiedScris de MuADMINSWhich databases and procedures do WebZen 97d, Season 2 and Season 3 files use?
- 97d (RaGEZONE pack): MuOnline.bak and Ranking.bak, SQL Server 2000 backups (restore them on 2005, 2008 or 2008 R2 first: 2012 and newer cannot restore a SQL 2000 backup). WZ_CONNECT_MEM...
Not verifiedScris de 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 verifiedScris de 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 verifiedScris de MuADMINSMuMaker: "Cannot open database "MuOnline" requested by the login. The login failed" on SQL Server 2005 Express
1. Enable the sa login: Management Studio > Security > Logins > sa > Properties: untick "Enforce password policy", set a password; on the Status page tick Grant and Enabled. 2. Server Pro...
✓ Confirmată de autorul topiculuiRaGEZONE · 2012-08-18Flawless Editor: how to set it up to edit WCoinC, WCoinP, Goblin Points, Ruud and Zen of accounts
1. Open Config.ini in the Flawless Editor folder. 2. Add your SQL user name and SQL password. 3. Save the file and start the editor: it edits WCoinC, WCoinP, Goblin Point, Ruud and Zen. 4...
MuEmu (Louis) files: where do I enter the SQL user and password? I cannot find it in any server config
MuEmu servers do not keep the SQL login in their config files: JoinServer and DataServer reach the database through ODBC. 1. Run the ODBC .reg file that comes with the files, or create th...
✓ Confirmată de autorul topiculuiTUServerMU · 2020-07-12How to set up the WebEngine Credit Manager so it gives WCoinC/WCoinP or Goblin Points on IGCN S6 files; adding credits says the account ID is invalid.
1. Database: MuOnline. Table: T_InGameShop_Point (check the exact name in your DB). 2. Credits column: the currency column you want (WCoinC, WCoinP or GoblinPoint). 3. User column: Accoun...
✓ Confirmată de autorul topiculuiRaGEZONE · 2022-07-11Which website CMS expects which MU database columns (WebEngine table maps, DmN)
WebEngine 1.2.7 picks a table map by server files (includes/config): - igcn.tables.php / custom.tables.php: resets = Character.RESETS, grand resets = Character.GrandResets, VIP = T_VIPLis...
Not verifiedScris de MuADMINSMuEmu S4: the server and MuMaker do not see the databases on SQL Server 2008 R2 even with remote connections and TCP/IP enabled.
1. Check how SQL Server was installed: it had been set up as a named instance. 2. The files and MuMaker expect the default instance, reached as (local) or the PC name. 3. Reinstall SQL Se...
✓ Confirmată de autorul topiculuiTuServerMU · 2017-11-11IGCN 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)...
✓ Confirmată de autorul topiculuiRaGEZONE · 2018-06-18During SQL Server setup the password for sa is rejected no matter what I type. Why?
1. Setup enforces the Windows password policy on the sa password. 2. Use at least 8 characters that mix uppercase letters, lowercase letters and numbers (a symbol helps too). 3. Do not us...
✓ Confirmată de autorul topiculuiTuServerMU · 2017-07-21MuWeb 0.8 does not work with XAMPP on Windows 7 and SQL 2008 (php.ini edits do not help)
1. MuWeb 0.8 needs an old PHP with the MSSQL functions: the newer XAMPP builds do not run it even after php.ini changes. 2. Install XAMPP 1.6.1 (not higher), configure php.ini as the MuWe...
✓ Confirmată de autorul topiculuiRaGEZONE · 2013-01-23MuCore 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-03I 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 verifiedScris de MuADMINSReset 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...
SkynetMU Full Option Cleaner: how do I find and remove full excellent items from warehouses and inventories of a 97/97D SQL database?
1. Install Python 3.11 or 3.12 on Windows, then run py -m pip install -r requirements.txt and py SkynetMU_FullOption_Cleaner.py. 2. For ODBC install Microsoft ODBC Driver 17 or 18 for SQL...