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
← Tutte le soluzioni

MuDevs: WZ_CONNECT_MEMB has 4 parameters (@HarwareID) and MEMB_STAT has HWID / OnlineHours

Scritto da MuADMINS a partire dalla fonteNot verified

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 HarwareID in the file).
  • MEMB_STAT has two more columns: OnlineHours int DEFAULT 0 and HWID varchar(74).
  • Hardware bans: BanMacInfo (Account, Name, HardwareId).

If you replace WZ_CONNECT_MEMB with a 3 parameter version from another pack or an old website guide, the server's call with 4 values fails ("Procedure or function WZ_CONNECT_MEMB has too many arguments specified") and nobody gets online status. DmN CMS knows this: its setup installs its MUDevs variant (with @hwid) when MEMB_STAT has a HWID column.

Check the parameters of the procedure you have:

SELECT p.name, t.name AS type_name, p.max_length
FROM sys.parameters p JOIN sys.types t ON p.user_type_id = t.user_type_id
WHERE p.object_id = OBJECT_ID('dbo.WZ_CONNECT_MEMB');

Source: MuDevs S18 MuOnline DB Create Script.sql (WZ_CONNECT_MEMB, MEMB_STAT, BanMacInfo); DmN CMS 1.2.3 setup controller.setup.php and required_stored_procedures[20.05.2015].json.

Scritto da MuADMINS
Ti è stato utile?

Non hai ancora risolto? Cerca su MuGPS Chiedi all'Assistente MU

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