MuADMINS
Rozwiązania
Krótkie poprawki częstych problemów z serwerem, klientem i stroną MU Online, każda ze źródłem i datą. “Potwierdzone” oznacza, że osoba, która pytała, potwierdziła, że poprawka zadziałała.
Rozwiązania: 47 dla “character name” · Wyczyść
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...
✓ Potwierdzone przez autora tematuCreandoMU · 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.
✓ Potwierdzone przez autora tematuTuServerMU · 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 verifiedNapisane przez 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 verifiedNapisane przez 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...
✓ Potwierdzone przez autora tematuCreandoMU · 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:...
✓ Potwierdzone przez autora tematuRaGEZONE · 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...
✓ Potwierdzone przez autora tematuTuServerMU · 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 verifiedNapisane przez 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...
✓ Potwierdzone przez autora tematuRaGEZONE · 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...
✓ Potwierdzone przez autora tematuRaGEZONE · 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 =...
✓ Potwierdzone przez autora tematuDarksTeam · 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...
✓ Potwierdzone przez autora tematuTuServerMU · 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 verifiedNapisane przez 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 verifiedNapisane przez 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 verifiedNapisane przez 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 verifiedNapisane przez 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 verifiedNapisane przez 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 verifiedNapisane przez 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 verifiedNapisane przez 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 verifiedNapisane przez MuADMINS