Community AlphaAlpha MUADMINS
ESEspañol
Iniciar sesión
En MuADMINSConfig ScannerSube el zip de tus archivos: rates, drops, spots, límitesAbrirEn MuADMINSEncuéntranos en DiscordPide ayuda, comparte lo que estás creando y habla de MU con otros dueños de servidores.Abrir
← Todas las soluciones

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

Escrito por MuADMINS a partir de la fuenteNot 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.

Escrito por MuADMINS
¿Te sirvió?

¿Sigues atascado? Buscar en MuGPS Pregúntale al Asistente MU

MuADMINS Community Alpha: gratis, hecho por la comunidad y en desarrollo activo.