MuADMINS
Soluzioni
Fix brevi per i problemi comuni di server, client e siti web di MU Online, ognuno con la sua fonte e la sua data. “Confermato” significa che chi ha fatto la domanda ha detto che il fix ha funzionato.
239 soluzioni per “sql server” · Azzera
Could not find stored procedure 'WZ_CONNECT_MEMB' (or WZ_DISCONNECT_MEMB): what they do and how to restore them
WZ_CONNECT_MEMB and WZ_DISCONNECT_MEMB keep MEMB_STAT up to date (ConnectStat 1 at login, 0 at logout). They must exist in the database the JoinServer / DataServer connects to: - IGCN: in...
Not verifiedScritto da MuADMINSPlayers show online on the website after the server closed, or accounts stay "online" (MEMB_STAT.ConnectStat stuck at 1)
How it works in every MSSQL files family we read (IGCN, MuEmu, Louis, MSPro, X-Team, MuDevs, WebZen): at login the server runs WZ_CONNECT_MEMB, which inserts or updates MEMB_STAT with Con...
Not verifiedScritto da MuADMINSMuDevs: 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 verifiedScritto da MuADMINSMuDevs Season 18: Invalid column name 'LastGateIndex' (the extra query of the pack)
The MuDevs Season 18 pack ships, next to the database scripts, a file Execute query.sql with one statement: ALTER TABLE dbo.Character ADD LastGateIndex [int] NOT NULL DEFAULT(-1); If the...
Not verifiedScritto da MuADMINSWebEngine with X-Team files: online ranking fails with Invalid column name 'OnlineHours'
WebEngine's map for X-Team files (includes\config\xteam.tables.php) defines _CLMN_MS_ONLINEHRS_ = OnlineHours, and the online ranking (only for xteam files) runs: SELECT TOP n memb___id,...
Not verifiedScritto da 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 verifiedScritto da MuADMINSLouis / 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 verifiedScritto da 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 verifiedScritto da 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 verifiedScritto da MuADMINSIGCN 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 verifiedScritto da 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 verifiedScritto da 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 verifiedScritto da MuADMINSIGCN 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 verifiedScritto da MuADMINSHow 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 verifiedScritto da MuADMINSMuMaker: "Login failed for user 'sa'" although the server runs and the password is right (only one MuMaker build works)
1. Check that the sa login has rights on the MU databases and that the password in the MuMaker Config.ini is right. 2. If it still says login failed, the MuMaker build does not fit your s...
✓ Confermato dall'autore della discussioneRaGEZONE · 2011-06-30DTweb 2.0 (MuOnline CMS for all seasons): how do I install it and log into its admin panel the first time?
1. Run Script.sql in your SQL query analyzer on the server database. 2. Put the website in the main web directory, not in a subfolder: some files use the document root and images or inclu...
Riscrittura della fonte da parte di MuADMINSNot verifiedGitHub (r00tmebaby/DT-Web-2.0-MuOnline-CMS-All-Seasons) · 2019-04-12MuOnline Shop Editor 1.6 (Mu Shop.exe) does not work on 64-bit Windows: the Microsoft.Jet.OLEDB.4.0 provider is not registered
1. The editor reads its item list through the old 32-bit Microsoft.Jet.OLEDB.4.0 provider, so on 64-bit Windows (the asker used Windows Server 2012 x64) it fails; installing .NET Framewor...
✓ Confermato dall'autore della discussioneDarksTeam · 2020-04-14MuEmu Editor (2017) + Fixs: an error shows at start although Config.ini has localhost, port 1433, sa and the password
1. Open the editor Config.ini. 2. In the [Me_MuOnline] and [MuOnline] blocks change EnableTrusted = 0 to EnableTrusted = 1. 3. Save and start the editor again: it connects.
✓ Confermato dall'autore della discussioneTUServerMU · 2017-04-29OpenMU (Docker all-in-one) after updating the server: the client stays on the login screen after entering the password.
1. Open the admin panel and run every pending update; the maintainer notes you cannot enter the game without them. 2. In this case the database upgrade had not completed, and an old impor...
✓ Confermato nella issueGitHub (MUnique/OpenMU) · 2024-07-21New 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...
✓ Confermato dall'autore della discussioneCreandoMU · 2020-08-20