Community AlphaAlpha MUADMINS
RORomână
Autentificare
Pe MuADMINSConfig ScannerÎncarcă zip-ul fișierelor tale: rate-uri, drop-uri, spoturi, limiteDeschidePe MuADMINSÎntâlnește-ne pe DiscordCere ajutor, arată la ce lucrezi și vorbește despre MU cu alți proprietari de servere.Deschide

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: 122 pentru “sql” în Configurarea serverului · Șterge

  1. Configurarea serveruluiMuEmu / LouisSeason 6 (MuEmu)

    How do I change the items new characters start with equipped?

    1. Create a character and equip it with MuEditor as you want. 2. Copy that character's Inventory value in SQL. 3. Run UPDATE DefaultClassType SET Inventory = <copied value> WHERE Class =...

    ✓ Confirmată de autorul topiculuiCreandoMU · 2020-08-15
  2. Configurarea serveruluiany (Morpheus web)

    Accounts created on the website get VIP months instead of days (Morpheus web).

    1. The SQL login used by the site had its language changed to Portuguese, which changes the date format. 2. Set the default language of that SQL login back to English (us_english). 3. Cre...

    ✓ Confirmată de autorul topiculuiCreandoMU · 2021-04-12
  3. Configurarea serveruluiMuEmu / LouisSeason 6 (Louis)

    How do I make a working online time ranking per character?

    1. Add an int column OnlineTime to the Character table (back up first). 2. Create a SQL Agent job every minute: UPDATE Character SET OnlineTime=OnlineTime+1 joined to MEMB_STAT (ConnectSt...

    ✓ Confirmată de autorul topiculuiCreandoMU · 2021-03-09
  4. Configurarea serverului

    Every 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...

    ✓ Confirmată de autorul topiculuiDarksTeam · 2010-01-05
  5. Configurarea serverului0.97d

    DarksTeam 97d+99i moved to a VPS (Windows Server 2012 R2, SQL 2008 R2): RankingServer shows an error although the config did not change

    The VPS firewall was blocking the RankingServer connections. 1. In Windows Firewall (and the VPS provider firewall, if any) allow the RankingServer program, or open the port it uses, for...

    ✓ Confirmată de autorul topiculuiTUServerMU · 2020-07-08
  6. Configurarea serverului0.97d

    Aminyuz 97d files: GameServer gives a conexion.ini connection error at start although all IPs are right (EventServer and Ranking open fine)

    The SQL login in the Aminyuz connection file was wrong. 1. Open C:\MuServer\Aminyuz\Conexion (the connection ini of these files). 2. In the [SQL] block set Usuario = sa (your SQL user), C...

    ✓ Confirmată de autorul topiculuiTUServerMU · 2020-02-21
  7. Configurarea serverului

    Anyone can log in with a random account name and password, and the login creates that account in SQL

    1. This is not a database bug: the server has automatic account registration switched on, so an unknown login is created on the spot. 2. Open the JoinServer config (in some files the opti...

    ✓ Confirmată de autorul topiculuiRaGEZONE · 2021-04-15
  8. Configurarea serveruluiany

    "Login failed for user 'sa'" (SQLSTATE 28000) from DataServer or the web right after installing SQL Server. How do I enable sa?

    1. If setup used Windows authentication only, sa is disabled. 2. In Management Studio right click the server > Properties > Security and pick SQL Server and Windows Authentication mode. 3...

    Rescriere MuADMINS a surseiNot verifiedMicrosoft Learn · 2025-08-26
  9. Configurarea serveruluiWebZen 97d / 99b97d

    DarksTeam 97d: accounts created on the web show NULL columns in the database and characters do not show up properly. How to fix it?

    1. Back up the MuOnline database first. 2. Open a new query on MuOnline in SQL Server Management Studio. 3. Run: UPDATE Character SET CtlCode = 0 WHERE CtlCode IS NULL 4. Restart the serv...

    ✓ Confirmată de autorul topiculuiTuServerMU · 2018-10-15
  10. Configurarea serveruluiIGCNS9

    IGCN Season 9 repack: GameServerCS shows an error when Castle Siege is configured, even with correct settings.

    1. The SQL Server language caused it. 2. Install SQL Server in English (English instance) and restore the databases there. 3. Start GameServerCS again.

    ✓ Confirmată de autorul topiculuiTuServerMU · 2017-06-18
  11. Configurarea serveruluiIGCNS9

    IGC DataServer stays on its loading window and never finishes starting.

    1. Check the ODBC/SQL settings of the DataServer. 2. The SQL instance name was wrong. When SQL Server is on the same PC use (local) as the instance/host. 3. Start the DataServer again.

    ✓ Confirmată de autorul topiculuiTuServerMU · 2017-04-21
  12. Configurarea serveruluiMuEmu / LouisSeason 8 Episode 3

    JoinServer and DataServer stopped connecting to the database (MuEmu Season 8)

    Restoring the database and the ODBC data sources again did not help: the SQL login the servers use did not have the rights it needs. 1. Open SQL Server Management Studio and go to Securit...

    ✓ Confirmată de autorul topiculuiTUServerMU · 2018-10-06
  13. Configurarea serveruluiany

    I run one server on my VPS and want a second one with its own database on the same VPS, but it does not connect. What must change?

    1. Give the second server its own database and create a new ODBC data source pointing to it (same driver, Server = (local), Database = new name). 2. Point the second JoinServer and DataSe...

    ✓ Confirmată de autorul topiculuiTuServerMU · 2019-10-09
  14. Configurarea serveruluiMuEmu / Louisany

    After moving from TitansTech to MuEmu, characters roll back on relog: items and position are not saved. The database was converted. What fixed it?

    1. Character data is saved by the DataServer, so check that first, not the tables. 2. Do not reuse the DataServer from your old TitansTech files: it did not work with MuEmu. 3. Use the Da...

    ✓ Confirmată de autorul topiculuiTuServerMU · 2017-11-02
  15. Configurarea serveruluiIGCNS16, S17, S18

    IGCN: players have negative WCoin or Goblin Points (shipped maintenance script)

    IGCN ships 2. Update Scripts\Maintenance Scripts\Check & Fix negative Coins.sql. It works in two runs and says "Take server offline before proceeding with the script": 1. With @Update = 0...

    Not verifiedScris de MuADMINS
  16. Configurarea serverului

    ODBC / DSN: the DataServer or JoinServer cannot connect to MuOnline (DSN name, 32 bit or 64 bit)

    MuEmu, Louis, MSPro, X-Team and MuDevs files connect through an ODBC System DSN: - JoinServer.ini JoinServerODBC = MuOnline, DataServer.ini DataServerODBC = MuOnline (MSPro: ODBC = MuOnli...

    Not verifiedScris de MuADMINS
  17. Configurarea serverului

    A character exists in the Character table but does not appear (AccountCharacter slots)

    The character list of an account is kept in AccountCharacter (Id = account, GameID1 to GameID5, or to GameID10 on newer files, plus GameIDC). The packs' WZ_CreateCharacter writes the new...

    Not verifiedScris de MuADMINS
  18. Configurarea serverului

    Could not find stored procedure 'WZ_CONNECT_MEMB' (or WZ_DISCONNECT_MEMB): what they do and how to restore them

    WZ_CONNECT_MEMB and WZ_DISCONNECT_MEMB keep MEMB_STAT up to date (ConnectStat 1 at login, 0 at logout). They must exist in the database the JoinServer / DataServer connects to: - IGCN: in...

    Not verifiedScris de MuADMINS
  19. Configurarea serverului

    Players show online on the website after the server closed, or accounts stay "online" (MEMB_STAT.ConnectStat stuck at 1)

    How it works in every MSSQL files family we read (IGCN, MuEmu, Louis, MSPro, X-Team, MuDevs, WebZen): at login the server runs WZ_CONNECT_MEMB, which inserts or updates MEMB_STAT with Con...

    Not verifiedScris de MuADMINS
  20. Configurarea serveruluiMuDevsS18, S20

    MuDevs: WZ_CONNECT_MEMB has 4 parameters (@HarwareID) and MEMB_STAT has HWID / OnlineHours

    MuDevs differs from the other MuEmu based files here: - WZ_CONNECT_MEMB @memb___id varchar(10), @ServerName varchar(50), @IP varchar(20), @HarwareID varchar(74) (4th parameter, spelled Ha...

    Not verifiedScris de MuADMINS

MuADMINS Community Alpha: gratuit, făcut de comunitate, în dezvoltare activă.