Community AlphaAlpha MUADMINS
FRFrançais
Connexion
Sur MuADMINSConfig ScannerDéposez le zip de vos fichiers : rates, drops, spots, limitesOuvrirSur MuADMINSRetrouvez-nous sur DiscordDemandez de l'aide, partagez ce que vous créez et parlez de MU avec d'autres propriétaires de serveurs.Ouvrir

MuADMINS

Solutions

Des correctifs courts pour les problèmes courants de serveur, de client et de site web MU Online, chacun avec sa source et sa date. “Confirmé” signifie que la personne qui a posé la question a indiqué que le correctif a fonctionné.

235 solutions pour “database” · Effacer

  1. Installation du serveurMuEmu / 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 verifiedRédigé par MuADMINS
  2. Installation du serveurMuEmu / 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 verifiedRédigé par MuADMINS
  3. Installation du serveurS2, 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 verifiedRédigé par MuADMINS
  4. Installation du serveurIGCNS12, 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 verifiedRédigé par MuADMINS
  5. Installation du serveurIGCNS9, 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 verifiedRédigé par MuADMINS
  6. Installation du serveurIGCNS9, 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 verifiedRédigé par MuADMINS
  7. Installation du serveurIGCNS9, 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 verifiedRédigé par MuADMINS
  8. Outils

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

    ✓ Confirmé par l'auteur du sujetRaGEZONE · 2013-01-23
  9. OutilsWebZen 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...

    Réécriture de la source par MuADMINSNot verifiedRaGEZONE · 2005-07-17
  10. OutilsEX803

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

    Réécriture de la source par MuADMINSNot verifiedRaGEZONE · 2016-11-19
  11. Outils

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

    ✓ Confirmé par l'auteur du sujetRaGEZONE · 2017-08-08
  12. OutilsIGCN

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

    ✓ Confirmé par l'auteur du sujetRaGEZONE · 2018-10-21
  13. OutilsIGCN

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

    ✓ Confirmé par l'auteur du sujetRaGEZONE · 2020-01-05
  14. OutilsMuEmu / 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...

    ✓ Confirmé par l'auteur du sujetTUServerMU · 2018-06-04
  15. Installation du serveurMuEmu / 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...

    ✓ Confirmé par l'auteur du sujetCreandoMU · 2021-09-19
  16. Installation du serveurclassic

    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.

    ✓ Confirmé par l'auteur du sujetImperyus Games Brasil · 2010-12-17
  17. Installation du serveur0.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...

    ✓ Confirmé par l'auteur du sujetImperyus Games Brasil · 2013-05-26
  18. Installation du serveurMuEmu / 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...

    ✓ Confirmé par l'auteur du sujetCreandoMU · 2020-08-20
  19. Installation du serveurMuEmu / 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 =...

    ✓ Confirmé par l'auteur du sujetCreandoMU · 2020-08-15
  20. Installation du serveurany (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...

    ✓ Confirmé par l'auteur du sujetCreandoMU · 2021-04-12

MuADMINS Community Alpha : gratuit, fait par la communauté, en développement actif.