Community AlphaAlpha MUADMINS
ITItaliano
Accedi
Su MuADMINSConfig ScannerCarica lo zip dei tuoi file: rates, drop, spot, limitiApriSu MuADMINSIncontraci su DiscordChiedi aiuto, condividi quello che stai creando e parla di MU con altri proprietari di server.Apri

MuADMINS

Soluzioni

Fix brevi per i problemi comuni di server, client e siti web di MU Online, ognuno con la sua fonte e la sua data. “Confermato” significa che chi ha fatto la domanda ha detto che il fix ha funzionato.

103 soluzioni per “tables” · Azzera

  1. Gameplay

    /reset always costs 100 million Zen no matter what is set in the command config.

    1. Open MuServer\Data\Util\ResetTable.txt. 2. Set Money_AL0 to Money_AL3 to the wanted cost per account level. 3. Reload.

    ✓ Confermato dall'autore della discussioneTuServerMU · 2019-07-15
  2. Sito web

    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 verifiedScritto da MuADMINS
  3. Setup del serverX-TeamS2, S15, S17, S18

    What is in the X-Team MuOnline database (password column, VIP, coins, resets, gens, master level)?

    X-Team uses one database, MuOnline, with the MuEmu procedure set. - Accounts: MEMB_INFO.memb__pwd varchar(10) (plain; no MD5 function in the scripts), sno__numb char(18), AccountLevel / A...

    Not verifiedScritto da MuADMINS
  4. Setup del server

    How to protect Game Master characters (give them the protected GM status)

    The GM status is the CtlCode column of the character. 1. Open the MuOnline database in SQL Server. 2. Run UPDATE Character SET CtlCode = '8' WHERE Name='<GM name>' (the asker confirmed 8...

    ✓ Confermato dall'autore della discussioneDarksTeam · 2012-05-11
  5. Setup del serverWebZen 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...

    ✓ Confermato dall'autore della discussioneTuServerMU · 2018-10-15
  6. StrumentiWebZen 97d / 99bS3

    main.exe 1.03K: the cash shop window text looks broken on Windows XP SP3 (fine on Vista and 7)

    1. Open main.exe (1.03K) in OllyDbg and go to offset 0079CFF4. 2. There you see MOV DWORD PTR SS:[EBP-1F0],1F4: change it to MOV DWORD PTR SS:[EBP-1F0],190. 3. Copy the change to the exec...

    ✓ Confermato dall'autore della discussioneRaGEZONE · 2011-09-17
  7. StrumentiWebZen 97d / 99b

    CzF Editor 1.5a: creating a new account gives an error although MD5 is disabled in the editor options

    1. With MD5 off in the editor, the password column must be plain text, but in this database memb__pwd was still binary. 2. Open Enterprise Manager (or Management Studio) > Databases > MuO...

    ✓ Confermato dall'autore della discussioneRaGEZONE · 2007-10-05
  8. StrumentiWebZen 97d / 99bS3

    main.exe 1.03K JPN: how to make the main open only through the launcher (mu.exe) with OllyDbg

    1. Open main.exe (1.03K JPN) in OllyDbg and find the mu.exe check (search the referenced text strings for mu.exe). 2. At 005FA1DF there is EB 55 JMP SHORT main.005FA236, just before the P...

    ✓ Confermato dall'autore della discussioneRaGEZONE · 2011-09-09
  9. StrumentiWebZen 97d / 99b97d

    OllyDbg: how to give a 97d+99i main.exe a widescreen resolution (for example 1366x768)

    1. You need OllyDbg and an unpacked 97d+99i main.exe. 2. Open main.exe in OllyDbg, right click > Search for > All referenced text strings, find Resolution and double click it. 3. Below it...

    ✓ Confermato dall'autore della discussioneDarksTeam · 2019-05-25
  10. Strumenti

    Pentium Tools: converting SMD back to BMD skips the texture (the model has no texture in game)

    1. A BMD model does not pack the texture: converting gives the model and animation SMD files plus a separate texture, and the converter only rebuilds the SMD files (do not put the texture...

    ✓ Confermato dall'autore della discussioneRaGEZONE · 2016-08-07
  11. Strumenti

    MuMaker 1.13: "Format of the initialization string does not conform to specification starting at index 30" when connecting to SQL

    1. Check that SQL Server has TCP/IP enabled on port 1433 and that port 1433 is allowed in the Windows firewall; check the ODBC source and the MuMaker config. 2. Make sure .NET Framework 3...

    ✓ Confermato dall'autore della discussioneRaGEZONE · 2025-04-30
  12. Setup del serverMuEmu / LouisSeason 6 (MuEmu update 22)

    New characters show 65535 kills and deaths.

    1. Fix existing ones: UPDATE dbo.Character SET Kills=0 WHERE Kills=65535 and the same for Deads. 2. In SSMS design the Character table and set the Default Value of Kills and Deads to 0. 3...

    ✓ Confermato dall'autore della discussioneCreandoMU · 2020-08-20
  13. Setup del serverMuEmu / 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...

    ✓ Confermato dall'autore della discussioneCreandoMU · 2021-03-09
  14. GameplayMuEmu / LouisSeason 6 (MuEmu)

    MuEmu: 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...

    ✓ Confermato dall'autore della discussioneCreandoMU · 2020-09-28
  15. Sito web97d+99i

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

    ✓ Confermato dall'autore della discussioneDarksTeam · 2009-10-31
  16. Sito web

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

    ✓ Confermato dall'autore della discussioneDarksTeam · 2011-04-14
  17. Gameplay0.99.60T (1.0M)

    Devil Square 5 and 6 open but no monsters spawn and no countdown is shown (DarksTeam MuServer 0.99.60T)

    The Devil Square timetable (DevilSquare.dat) was fine; the edited MonsterSetBase.txt was the cause. 1. Put back the original MonsterSetBase.txt that came with the server files. 2. Restart...

    ✓ Confermato dall'autore della discussioneDarksTeam · 2015-01-04
  18. StrumentiMuEmu / LouisSeason 6

    Cash Editor gives an error when editing credits, although the SQL user and password are set

    The cash table and column names in the editor config were wrong. 1. Open the editor config file (XTRMu in the thread). 2. [SQLConnection]: SQLHost = (local), SQLUser = your SQL user, SQLP...

    ✓ Confermato dall'autore della discussioneTUServerMU · 2020-07-10
  19. GameplayMuEmu / LouisSeason 8 Episode 3

    Louis MuEmu S8 E3: Crywolf stays empty (no NPCs or monsters) although the event is on and the CS MonsterSetBase is complete

    The Crywolf event config itself was incomplete. 1. Open the Crywolf event config of GameServerCS. 2. Compare it with a complete one (the asker copied it again from a forum post): section...

    ✓ Confermato dall'autore della discussioneTUServerMU · 2020-11-22
  20. GameplayMuEmu / LouisSeason 6 Episode 3

    MuEmu S6 E3 Castle Siege: when the battle starts the defending guild shows as attacker, with no config change

    The Castle Siege data stored in SQL had gone bad. 1. Back up the database first. 2. The asker cleared the SQL tables used by Castle Siege (in MuEmu databases they are the MuCastle_ tables...

    ✓ Confermato dall'autore della discussioneTUServerMU · 2020-11-15

MuADMINS Community Alpha: gratuito, fatto dalla community, in sviluppo attivo.