Community AlphaAlpha MUADMINS
ITItaliano
Accedi
Su MuADMINSConfig ScannerCarica lo zip dei tuoi file: rates, drop, spot, limitiApriSu MuADMINSIncontraci su DiscordChiedi aiuto, condividi quello che stai creando e parla di MU con altri proprietari di server.Apri

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.

122 soluzioni per “sql server” in Setup del server · Azzera

  1. Setup del serverMuDevsS18

    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 verifiedScritto da MuADMINS
  2. Setup del serverMSProS2, 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 verifiedScritto da MuADMINS
  3. Setup del serverMuEmu / 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 verifiedScritto da MuADMINS
  4. Setup del serverMuEmu / 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 verifiedScritto da MuADMINS
  5. Setup del serverS2, 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 verifiedScritto da MuADMINS
  6. Setup del serverIGCNS12, 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 verifiedScritto da MuADMINS
  7. Setup del serverIGCNS9, 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 verifiedScritto da MuADMINS
  8. Setup del serverIGCNS15, 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 verifiedScritto da MuADMINS
  9. Setup del serverIGCNS9, 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 verifiedScritto da MuADMINS
  10. Setup del serverIGCNS9, 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 verifiedScritto da MuADMINS
  11. Setup del serverOpenMUSeason 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...

    ✓ Confermato nella issueGitHub (MUnique/OpenMU) · 2024-07-21
  12. Setup del serverMuEmu / 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...

    ✓ Confermato dall'autore della discussioneCreandoMU · 2020-08-20
  13. Setup del serverMuEmu / LouisSeason 6 (Louis free)

    Items ask for more stats than shown and only equip after relogging (Louis free S6).

    1. Louis first advice: item.bmd (client) and Item.txt (server) must match. 2. Here the asker had changed the starting stats of the classes directly in the database, which caused the confl...

    ✓ Confermato dall'autore della discussioneCreandoMU · 2021-08-31
  14. Setup del serverMuEmu / LouisSeason 6 (Louis)

    Louis files: after testing the auction system no new auction starts (or it starts and ends at once).

    1. A finished auction does not run again. 2. Back up the database, then run on MuOnline: DELETE FROM EventAuction and DELETE FROM EventAuctionReward. 3. Restart the GameServer to start ne...

    ✓ Confermato dall'autore della discussioneCreandoMU · 2020-12-02
  15. Setup del serverS4

    SCFdb (SCF Season 4 database manager) shows an error at start

    1. Reinstall Microsoft .NET Framework 2.0, or better install .NET Framework 3.0. 2. Start SCFdb again.

    ✓ Confermato dall'autore della discussioneDarksTeam · 2008-10-16
  16. Setup del server

    The website always shows 2 players online even when the server is off

    Stale rows in MEMB_STAT still say the accounts are connected. 1. Open Query Analyzer / SSMS on the MuOnline database. 2. Run UPDATE MEMB_STAT SET ConnectStat='0' WHERE ConnectStat>0. 3. R...

    ✓ Confermato dall'autore della discussioneDarksTeam · 2009-03-03
  17. Setup del serverS3E2

    DarksTeam Season 3 Episode 2 (Beta 19) Cash Shop: a bought Seal disappears after reconnect

    The seal was saved with a wrong date format in t_perioditem_info. 1. Open the stored procedure t_perioditem_insert in the MuOnline database. 2. Fix the datetime format it uses when insert...

    ✓ Confermato dall'autore della discussioneDarksTeam · 2009-08-09
  18. Setup del server

    Guild war gives no points: the website shows a negative score and the in-game G Score stays 0

    The Guild table column G_Score had no default value, so new guilds got NULL. 1. Open SQL Server > MuOnline database > Tables > Guild > Design Table. 2. Select the column G_Score and set i...

    ✓ Confermato dall'autore della discussioneDarksTeam · 2010-05-03
  19. Setup del server

    How to protect Game Master characters (give them the protected GM status)

    The GM status is the CtlCode column of the character. 1. Open the MuOnline database in SQL Server. 2. Run UPDATE Character SET CtlCode = '8' WHERE Name='<GM name>' (the asker confirmed 8...

    ✓ Confermato dall'autore della discussioneDarksTeam · 2012-05-11
  20. Setup del serverSeason 6

    How to remove the master skill tree skills from every character at once (S6 Up15 GamingMaster files); DELETE MasterSkillTree did not remove them

    The learned skills are stored in the MagicList column of the Character table. 1. Back up the database and close the server. 2. Run: USE MuOnline; UPDATE Character SET [MagicList] = CONVER...

    ✓ Confermato dall'autore della discussioneTUServerMU · 2021-05-09

MuADMINS Community Alpha: gratuito, fatto dalla community, in sviluppo attivo.