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

80 solutions pour “columns” · Effacer

  1. Installation du serveurMuDevsS18, 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 verifiedRédigé par MuADMINS
  2. Installation du serveurMSProS2, S3, S6

    MSPro: the shipped query "Dar coin ganador gs" (WCoin for the Castle Siege winner) is broken

    The file Tools - Querys Y Otros\Query-Sql\Dar coin ganador gs.txt has three problems: 1. Line 1 update CashShopData set WCoinC= WCoinC+1000 where AccountID in has nothing after IN (syntax...

    Not verifiedRédigé par MuADMINS
  3. Installation du serveurS2, S6, S16, S17, S18, S20

    How do I reset a character with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files (ResetCount) with the server closed?

    Columns: Character.ResetCount and MasterResetCount (X-Team also ResetDay, ResetWek, ResetMon and MasterResetDay / Wek / Mon for the daily, weekly and monthly limits). The server reads and...

    Not verifiedRédigé par MuADMINS
  4. 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
  5. 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
  6. Installation du serveurS2, S6, S16, S17, S18, S20

    How do I give VIP (AccountLevel) to an account with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files?

    In MuEmu based files VIP is MEMB_INFO.AccountLevel (0 = normal, the AL1 / AL2 / AL3 levels of your configs) with MEMB_INFO.AccountExpireDate. Use the shipped procedure, account offline: E...

    Not verifiedRédigé par MuADMINS
  7. Installation du serveurS6, S16

    How do I turn MD5 on (MD5Encryption in JoinServer.ini) on MuEmu, Louis, MSPro, X-Team or MuDevs files, and what does the database need?

    In MuEmu based files the switch is JoinServer\JoinServer.ini, MD5Encryption = 0/1 (next to CaseSensitive = 0). Every pack we read ships 0. What the databases have: - X-Team Season 2 and 1...

    Not verifiedRédigé par MuADMINS
  8. 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
  9. Installation du serveurIGCNS9, S12, S16, S17, S18

    How do I reset a character with SQL on IGCN files (RESETS, GrandResets) with the server closed?

    Columns in IGCN Character: RESETS (int, all seasons), GrandResets (tinyint, Season 16, 17, 18), GRANDRESET (Season 12), plus cLevel, Experience, LevelUpPoint and the stats. 1. Close the G...

    Not verifiedRédigé par MuADMINS
  10. Installation du serveurIGCNS9, S12, S16, S17, S18

    How do I give or extend VIP for an account with SQL on IGCN files (IGC_VipAdd, T_VIPList)?

    IGCN keeps the active VIP in T_VIPList (AccountID, Date, Type); MEMB_INFO also has VipType, VipStart, VipDays. The shipped procedure is IGC_VipAdd @szCharName, @DayAdd, @VipType. Despite...

    Not verifiedRédigé par MuADMINS
  11. Installation du serveurIGCNS9, S12, S16, S17, S18

    How do I add WCoin or Goblin Points to an account with a SQL query on IGCN files?

    The table is T_InGameShop_Point, but the columns changed between seasons: - Season 9 and 12: AccountID, WCoinC, WCoinP, GoblinPoint (float) - Season 16, 17, 18: AccountID, WCoin, GoblinPo...

    Not verifiedRédigé par MuADMINS
  12. Installation du serveurIGCNS9, S12, S16, S17, S18

    How do I set a new password for one account in SQL on IGCN files (plain, WZ_MD5 or md5 text)?

    Use the form that matches PasswordEncryptType in IGCDS.ini and the memb__pwd column type. Keep the account offline and always use WHERE. - Type 0 (varchar(20)): UPDATE MEMB_INFO SET memb_...

    Not verifiedRédigé par MuADMINS
  13. 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
  14. Outils

    MagicHand 2.0 BETA: how to run it and convert client BMD files for the server (archivos/txt folder)

    1. MagicHand is a web editor written in PHP5, not a desktop program: install AppServ or XAMPP and open it in any browser except Internet Explorer. 2. It edits the client BMD files (from B...

    Réécriture de la source par MuADMINSNot verifiedImperyus Games Brasil · 2010-08-14
  15. OutilsAutres fichiersS6

    BeastMaker admin tool: how to set up the SQL connection and the allowed user (and SQL 2000 without "Edit Top 200 Rows")

    1. Run the table script from the release post to create the BeastMaker table (columns BeastMaker_Allowed, BeastMaker_Logs) in the MuOnline database. 2. Add your allowed entry {"YOURNAME":...

    Réécriture de la source par MuADMINSNot verifiedRaGEZONE · 2015-07-14
  16. Outils

    Mu Launcher v1.3 (RJ launcher, harlcreeds): how to set the server IP, the patch link and the registration

    1. Run rjdllcreator.exe and type your server IP: it builds rjconnect.dll, the connector the launcher uses. 2. Install a web server (WAMP www, XAMPP htdocs, nginx html) and copy the rjlaun...

    Réécriture de la source par MuADMINSNot verifiedRaGEZONE · 2017-11-18
  17. Outils1.04D (S6)

    ItemToolTip.bmd (MagicHand): where to add new custom items when Tipo 1 has no free lines, and "file corrupted" after saving

    1. Open your ItemToolTip.bmd with MagicHand (on a 1.04D client it is in Data\Local\Eng, or Por / Spn). 2. Find the LAST original item, normally on Tipo 2, and add your items on the lines...

    Réécriture de la source par MuADMINSNot verifiedRaGEZONE · 2012-04-02
  18. OutilsS6E3

    NuTT MuShop Editor: how to edit .txt NPC shops with full item codes (JoH, ancient, sockets)

    1. Copy the item.txt of your server into the ShopEditor folder. 2. Open the shop .txt file and work on it. 3. Unlike older shop editors that write only Group, Index, Level, Dur, Skill, Lu...

    Réécriture de la source par MuADMINSNot verifiedRaGEZONE · 2025-12-10
  19. Outils

    ServerList Editor: how to mark a server as Gold, Gold PVP, Non-PVP or Normal in ServerList.bmd

    1. Install .NET Framework 2.0 (x86 or x64) and open your ServerList.bmd with the editor (English language was added in update 1). 2. The table columns 1 to 15 are the server indexes insid...

    Réécriture de la source par MuADMINSNot verifiedRaGEZONE · 2012-02-18
  20. OutilsIGCN

    IGC.ToolKit: how to add a custom item to the IGCN client (Item.bmd sub group, model file name, ItemTRSData in Lang.mpr)

    1. Edit the BMD files in \Data\Local\ of the client with IGC.ToolKit (Free or Premium). ToolKit Premium can add the item on the client first and export it to the server format, and its It...

    Réécriture de la source par MuADMINSNot verifiedIGCN · 2022-09-16

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