Community AlphaAlpha MUADMINS
DEDeutsch
Anmelden
Auf MuADMINSConfig ScannerZip deiner Dateien hochladen: Rates, Drops, Spots, LimitsÖffnenAuf MuADMINSTriff uns auf DiscordFrag nach Hilfe, zeig, woran du arbeitest, und sprich mit anderen Serverbetreibern über MU.Öffnen

MuADMINS

Lösungen

Kurze Fixes für häufige Probleme mit Server, Client und Website bei MU Online, jeweils mit Quelle und Datum. “Bestätigt” heißt: Die Person, die gefragt hat, hat gesagt, dass der Fix funktioniert hat.

239 Lösungen für “sql server” · Zurücksetzen

  1. Server-Setup

    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 verifiedVon MuADMINS geschrieben
  2. Server-Setup

    Players 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 verifiedVon MuADMINS geschrieben
  3. Server-SetupMuDevsS18, 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 verifiedVon MuADMINS geschrieben
  4. Server-SetupMuDevsS18

    MuDevs 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 verifiedVon MuADMINS geschrieben
  5. WebsiteX-TeamS2, S17

    WebEngine 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 verifiedVon MuADMINS geschrieben
  6. Server-SetupMSProS2, 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 verifiedVon MuADMINS geschrieben
  7. Server-SetupMuEmu / LouisS6

    Louis / 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 verifiedVon MuADMINS geschrieben
  8. Server-SetupMuEmu / 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 verifiedVon MuADMINS geschrieben
  9. Server-SetupS2, 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 verifiedVon MuADMINS geschrieben
  10. Server-SetupIGCNS12, S16, S17, S18

    IGCN 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 verifiedVon MuADMINS geschrieben
  11. Server-SetupIGCNS9, 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 verifiedVon MuADMINS geschrieben
  12. Server-SetupIGCNS15, S16, S17, S18

    How 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 verifiedVon MuADMINS geschrieben
  13. Server-SetupIGCNS9, S12, S16, S17, S18

    IGCN 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 verifiedVon MuADMINS geschrieben
  14. Server-SetupIGCNS9, 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 verifiedVon MuADMINS geschrieben
  15. Tools

    MuMaker: "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...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2011-06-30
  16. WebsiteS1 to S12

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

    Neufassung der Quelle durch MuADMINSNot verifiedGitHub (r00tmebaby/DT-Web-2.0-MuOnline-CMS-All-Seasons) · 2019-04-12
  17. ToolsWebZen 97d / 99b97d, 99

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

    ✓ Vom Threadersteller bestätigtDarksTeam · 2020-04-14
  18. ToolsMuEmu / Louis

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

    ✓ Vom Threadersteller bestätigtTUServerMU · 2017-04-29
  19. Server-SetupOpenMUSeason 6 (OpenMU 0.8.x)

    OpenMU (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...

    ✓ Im Issue bestätigtGitHub (MUnique/OpenMU) · 2024-07-21
  20. Server-SetupMuEmu / LouisSeason 6 (MuEmu update 22)

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

    ✓ Vom Threadersteller bestätigtCreandoMU · 2020-08-20

MuADMINS Community Alpha: kostenlos, von der Community gemacht, in aktiver Entwicklung.