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é.
57 solutions pour “update 29” dans Installation du serveur · Effacer
Where are accounts, VIP, credits, resets and bans in the DV-Team Season 19 database (MySQL / MariaDB)?
DV-Team does not use SQL Server: the database is a MySQL / MariaDB dump (Navicat), databases muonline (127 tables) and log (22 tables). There is no MEMB_INFO and no stored procedure, so S...
Not verifiedRédigé par MuADMINSWhat 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 verifiedRédigé par MuADMINSMSPro: 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 MuADMINSHow 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 MuADMINSHow 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 MuADMINSHow 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 MuADMINSHow do I add WCoinC, WCoinP or Goblin Points with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files (CashShopData)?
The table is CashShopData (AccountID, WCoinC, WCoinP, GoblinPoint). 1. Account offline (best: server closed), backup first, look at the row: SELECT AccountID, WCoinC, WCoinP, GoblinPoint...
Not verifiedRédigé par MuADMINSHow 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 MuADMINSHow 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 MuADMINSIGCN: 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 MuADMINSHow 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 MuADMINSHow do I make a character Game Master (GM) or Administrator on IGCN files (CtlCode)?
On IGCN files the GM rights are on the character: Character.CtlCode (tinyint, default 0). - The IGCN command documentation says GM commands such as /item and /spawn "require Administrator...
Not verifiedRédigé par MuADMINSHow 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 MuADMINSHow 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 MuADMINSIGCN license system: which ports to open and why the Windows time must be synchronized before activating the server license
1. Every IGCN application connects to the IGCN servers for activation, verification and normal use, so the license needs constant internet access. 2. Open these ports in the firewall: TCP...
My GameServer (port 55901 and up) sometimes fails to start because the port is already in use. How do I check the Windows dynamic port range?
1. Since Windows Vista and Server 2008, outgoing connections use local ports 49152 to 65535 by default, which includes 55901, 55960, 55970. 2. Show the range: netsh int ipv4 show dynamicp...
OpenMU worked before, but after the PC ran for a while the game server cannot listen on 55901 or players cannot connect. Why?
1. Ports 49152 to 65535 are the Windows dynamic range used for outgoing connections, so another process can already hold 55901 and up. 2. Newer OpenMU databases use 45901 to 45906 for gam...