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.

235 soluzioni per “database” · Azzera

  1. Setup del serverMuEmu / LouisS6

    Louis / 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 verifiedScritto da MuADMINS
  2. Setup del serverMuEmu / LouisS6

    How do I ban and unban accounts or characters with an end date on Louis / MuEmu Season 6 files (bloc_code, CtlCode, Bloc_Expire)?

    Louis Season 6 Update 11 added the ban columns: MEMB_INFO.Bloc_Expire and Character.Bloc_Expire (smalldatetime). The procedure WZ_DesblocAccount @Account lifts a block only when it expire...

    Not verifiedScritto da MuADMINS
  3. Setup del serverS2, S6, S15, S17, S18

    How do I make a character GM on MuEmu, Louis, MSPro, X-Team or MuDevs files (GameMaster.txt, not CtlCode)?

    In MuEmu based files the GM list is a file, not a database column: GameServer\Data\Util\GameMaster.txt, one line per GM: "account1" "GMName" 2 - Louis Season 6: columns Account, Name, Lev...

    Not verifiedScritto da MuADMINS
  4. Setup del serverIGCNS12, S16, S17, S18

    IGCN Me_MuOnline (shared accounts): login fails or new accounts are not found after enabling it

    Me_MuOnline is a separate accounts database. It has its own MEMB_INFO, MEMB_STAT, T_VIPList, ConnectionHistory, IGC_MachineID_Banned, fn_md5, WZ_CONNECT_MEMB and WZ_DISCONNECT_MEMB. 1. IG...

    Not verifiedScritto da MuADMINS
  5. Setup del serverIGCNS9, S16, S17, S18

    IGCN: players cannot create Summoner, Rage Fighter or other card classes (AccountCharacter flags)

    IGCN stores the class unlocks per account in AccountCharacter. Season 17 has the flags Summoner, RageFighter, GrowLancer, MagicGladiator, DarkLord, RuneWizard, Slayer, GunCrusher, LightWi...

    Not verifiedScritto da MuADMINS
  6. Setup del serverIGCNS9, S12, S16, S17, S18

    IGCN WZ_MD5 (PasswordEncryptType 1): fn_md5 fails or XP_MD5_EncodeKeyVal is not found

    IGCN's fn_md5(@data VARCHAR(20), @data2 VARCHAR(10)) RETURNS BINARY(16) does only one thing: EXEC master.dbo.XP_MD5_EncodeKeyVal @data, @data2, @hash OUT (password first, account second)....

    Not verifiedScritto da MuADMINS
  7. Setup del serverIGCNS9, S12, S16, S17, S18

    How do I turn MD5 passwords on or off (enable / disable) on IGCN files (PasswordEncryptType, memb__pwd)?

    On IGCN files the password mode is chosen in the DataServer and the database column must be of the matching type. If they do not match, nobody can log in. 1. Close the whole server and ba...

    Not verifiedScritto da MuADMINS
  8. Strumenti

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

    ✓ Confermato dall'autore della discussioneRaGEZONE · 2013-01-23
  9. StrumentiWebZen 97d / 99b97d-99

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

    Riscrittura della fonte da parte di MuADMINSNot verifiedRaGEZONE · 2005-07-17
  10. StrumentiEX803

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

    Riscrittura della fonte da parte di MuADMINSNot verifiedRaGEZONE · 2016-11-19
  11. Strumenti

    MuMaker 1.12: "No connection could be made because the target machine actively refused it, error 0" or "error 40" when connecting

    1. Open SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for MSSQLSERVER. 2. Set TCP/IP to Enabled. 3. In TCP/IP Properties, IP Addresses tab: set Enabled t...

    ✓ Confermato dall'autore della discussioneRaGEZONE · 2017-08-08
  12. StrumentiIGCN

    IGC.EssentialTools: creating an account fails with "Could not find stored procedure master.dbo.XP_MD5_EncodeKeyVal"

    1. The tool hashes the password with the MD5 extended procedure, which is not installed in your SQL Server. 2. Install the MD5 procedure for your SQL Server: the fix in the thread is the...

    ✓ Confermato dall'autore della discussioneRaGEZONE · 2018-10-21
  13. StrumentiIGCN

    IGC.EssentialTools crashes after the first-run notice although SQL named pipes and TCP/IP are enabled (crash dump in CrashDumps)

    1. Symptoms: the first-run notice pops up, then the tool crashes on every start; compatibility mode and run as admin do not help; a dump such as IGCN.EssentialTools.exe.5908.dmp appears i...

    ✓ Confermato dall'autore della discussioneRaGEZONE · 2020-01-05
  14. StrumentiMuEmu / Louis

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

    ✓ Confermato dall'autore della discussioneTUServerMU · 2018-06-04
  15. Setup del serverMuEmu / LouisSeason 6 (Louis update 27)

    Louis update 27: CashShopData is not updated with the Custom Arena reward when the event ends.

    1. The procedure WZ_CustomArenaRanking only rewards arena index 0 (IF @ArenaNumber = 0), so check which arena number you use. 2. Add the reward for your arena index if it is not 0. 3. The...

    ✓ Confermato dall'autore della discussioneCreandoMU · 2021-09-19
  16. Setup del serverclassic

    After restoring an old backup, characters with the same name can be created on different accounts.

    1. The name primary key was lost. 2. Delete the duplicated rows one by one. 3. Restore the primary key before allowing new characters.

    ✓ Confermato dall'autore della discussioneImperyus Games Brasil · 2010-12-17
  17. Setup del server0.97d

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

    ✓ Confermato dall'autore della discussioneImperyus Games Brasil · 2013-05-26
  18. 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
  19. Setup del serverMuEmu / 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 =...

    ✓ Confermato dall'autore della discussioneCreandoMU · 2020-08-15
  20. Setup del serverany (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...

    ✓ Confermato dall'autore della discussioneCreandoMU · 2021-04-12

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