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.

33 Lösungen für “procedure” · Zurücksetzen

  1. Server-SetupDV-TeamS19

    Where 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 verifiedVon MuADMINS geschrieben
  2. 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
  3. Server-SetupX-TeamS2, S15, S17, S18

    What 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 verifiedVon MuADMINS geschrieben
  4. 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
  5. Server-SetupMSProS2, S3, S6

    What 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 verifiedVon MuADMINS geschrieben
  6. 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
  7. 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
  8. Server-SetupS6, S16, S17, S18, S20

    How do I add WCoinC, WCoinP or Goblin Points with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files (CashShopData)?

    The table is CashShopData (AccountID, WCoinC, WCoinP, GoblinPoint). 1. Account offline (best: server closed), backup first, look at the row: SELECT AccountID, WCoinC, WCoinP, GoblinPoint...

    Not verifiedVon MuADMINS geschrieben
  9. Server-SetupS2, S6, S16, S17, S18, S20

    How do I give VIP (AccountLevel) to an account with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files?

    In MuEmu based files VIP is MEMB_INFO.AccountLevel (0 = normal, the AL1 / AL2 / AL3 levels of your configs) with MEMB_INFO.AccountExpireDate. Use the shipped procedure, account offline: E...

    Not verifiedVon MuADMINS geschrieben
  10. 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
  11. Server-SetupIGCNS9, S12, S16, S17, S18

    How do I give or extend VIP for an account with SQL on IGCN files (IGC_VipAdd, T_VIPList)?

    IGCN keeps the active VIP in T_VIPList (AccountID, Date, Type); MEMB_INFO also has VipType, VipStart, VipDays. The shipped procedure is IGC_VipAdd @szCharName, @DayAdd, @VipType. Despite...

    Not verifiedVon MuADMINS geschrieben
  12. Server-SetupIGCNS9, S12, S16, S17, S18

    How do I add WCoin or Goblin Points to an account with a SQL query on IGCN files?

    The table is T_InGameShop_Point, but the columns changed between seasons: - Season 9 and 12: AccountID, WCoinC, WCoinP, GoblinPoint (float) - Season 16, 17, 18: AccountID, WCoin, GoblinPo...

    Not verifiedVon MuADMINS geschrieben
  13. ToolsEx702 to S8E2

    MU DB Helper: how do I install the item, inventory and vault database editor for Ex702 and newer servers?

    1. Requirements: Visual Studio 2013, SQL Server 2012 or newer, ODBC Driver 13 and a MU Online Ex702+ database. 2. Clone the repository and make sure a MuOnline database exists (CREATE DAT...

    Neufassung der Quelle durch MuADMINSNot verifiedGitHub (kyleruss/mu-db-helper) · 2018-04-30

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