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é.
47 solutions pour “character name” · Effacer
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...
✓ Confirmé par l'auteur du sujetCreandoMU · 2021-03-09How to stop WebEngine from showing GM/admin characters in the level and reset rankings.
1. AdminCP > website settings > Module Manager > Rankings. 2. In 'Excluded Characters' add the admin character names separated by commas. 3. Save and wait for the next ranking cron run.
✓ Confirmé par l'auteur du sujetTuServerMU · 2020-06-15WebEngine register error "String or binary data would be truncated" (sno__numb is shorter than 13 characters)
WebEngine 1.2.7 fills MEMB_INFO.sno__numb with _defaultAccountSerial = '1111111111111' (13 characters, includes/classes/class.account.php line 16). The column size depends on the files: -...
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 MuADMINSIn Land of Trials the character is pulled back after the bridge.
1. Server terrain and client terrain differ. 2. With a MU terrain tool use File > Convert > EncTerrain ATT -> Server Terrain ATT on the client Data/World32/EncTerrain32.att (map 31 is fol...
✓ Confirmé par l'auteur du sujetCreandoMU · 2021-09-22Entering the Arena (Stadium) keeps throwing the character back to Lorencia or makes it glitch and jump around
1. The Arena terrain (.att) on the server does not match the client one, so the server rejects positions that the client allows and moves you back. 2. Use the same terrain on both sides:...
✓ Confirmé par l'auteur du sujetRaGEZONE · 2022-08-21DMN CMS with MuEmu S6E3 files: reset and grand reset modules do not work.
1. Open the Character table in SQL and read the exact column names. 2. In the DMN config type them exactly, with the same upper and lower case (for example ResetCount, not reset or resetc...
✓ Confirmé par l'auteur du sujetTuServerMU · 2018-11-22Where 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 MuADMINSTitan Editor: "Item [0, 107]. Doesnt exist in DB" and custom items do not show in the vault or inventory (TT 6.3)
1. The editor only knows the items listed in its own item database, so custom items (here section 0, index 107) are unknown to it. 2. Add the custom items to the Titan Editor item databas...
✓ Confirmé par l'auteur du sujetRaGEZONE · 2016-05-17Launcher auto update (Titan Tech SCF ConnectServer) never downloads the patch from a hosting FTP account
1. The update FTP is set in the ConnectServer SCF_Config.ini, sections [FtpServerInfo] and [HttpServerInfo] (SCFAddress, SCFPort, SCFID, SCFPASS), with SCFClientVersion and SCFVersionFile...
✓ Confirmé par l'auteur du sujetRaGEZONE · 2015-02-23DarksWeb 0.3: give stat points per reset (500 for the first reset, 1000 for the second and so on)
1. Open the reset module of DarksWeb. 2. After the line $respoints = '500'; read the character's resets: Select Clevel,Resets From Character where Name='$char'. 3. Compute $resetpoints =...
✓ Confirmé par l'auteur du sujetDarksTeam · 2010-04-05During SQL Server setup the password for sa is rejected no matter what I type. Why?
1. Setup enforces the Windows password policy on the sa password. 2. Use at least 8 characters that mix uppercase letters, lowercase letters and numbers (a symbol helps too). 3. Do not us...
✓ Confirmé par l'auteur du sujetTuServerMU · 2017-07-21Which website CMS expects which MU database columns (WebEngine table maps, DmN)
WebEngine 1.2.7 picks a table map by server files (includes/config): - igcn.tables.php / custom.tables.php: resets = Character.RESETS, grand resets = Character.GrandResets, VIP = T_VIPLis...
Not verifiedRédigé par MuADMINSWebEngine: accounts made on the website cannot log in (password encryption must match memb__pwd)
WebEngine 1.2.7 has four password modes (install/definitions.php PDO_PWD_ENCRYPT) and writes MEMB_INFO differently for each: - none: memb__pwd = :password (plain), for varchar columns (IG...
Not verifiedRédigé par MuADMINSUnicode (NVARCHAR) migration of a MuEmu / Louis Season 6 database: what is right and what breaks
Review of a Season 6 Unicode script set (a migration that converts the name columns to NVARCHAR plus new WZ_CreateCharacter, WZ_DeleteCharacter, WZ_CreateGuild procedures). Its table list...
Not verifiedRédigé par MuADMINS"Account does not exist" or the login fails although the account is in MEMB_INFO: what to check in the database
Check these in order (all read only, nothing changes): 1. Is the server reading the same database? MuEmu, Louis, MSPro, X-Team, MuDevs use the ODBC DSN in JoinServer.ini (JoinServerODBC =...
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 MuADMINSWhat are the MSPro database settings (ODBC, MD5Encryption, DisconnectOnlineAccount) and the update queries?
MSPro files connect through the ODBC DSN named MuOnline: - JoinServer\JoinServer.ini: JoinServerODBC = MuOnline, CaseSensitive = 0, MD5Encryption = 0, MaxIPLimit = 0, MaxHwIDLimit = 0, Di...
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 MuADMINS