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

Could not find stored procedure 'WZ_CONNECT_MEMB' (or WZ_DISCONNECT_MEMB): what they do and how to restore them

Scritto da MuADMINS a partire dalla fonteNot verified

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 MuOnline AND in Me_MuOnline: (@memb___id varchar(10), @ServerName varchar(20), @IP varchar(15))
  • MuEmu, Louis, MSPro, X-Team: in MuOnline: (@memb___id varchar(10), @ServerName varchar(50), @IP varchar(20))
  • MuDevs: 4 parameters, the 4th is @HarwareID varchar(74)
  • WebZen 97d: (@uid varchar(20), @server varchar(20), @uip varchar(20))
  1. Check the database you are really connected to (DSN "Database" or IGCDS.ini) and whether the procedure is there:
SELECT DB_NAME() AS current_db, name, modify_date FROM sys.procedures WHERE name IN ('WZ_CONNECT_MEMB', 'WZ_DISCONNECT_MEMB');
  1. Missing: take only the CREATE PROCEDURE block of that procedure from YOUR pack's MuOnline script and run it on that database. Never re-run the whole MuOnline script on a database with players: it creates tables again.
  2. Installed a website lately? DmN setup drops and replaces both procedures with versions that write to the web database (DmN_IP_Log, DmN_OnlineCheck). If that database was renamed or removed, re-create the pack's original procedures.

Note: no procedure named WZ_DesignateFriend exists in any of the scripts or backups we read; the friend system uses WZ_FriendAdd, WZ_FriendDel, WZ_WaitFriendAdd, WZ_WaitFriendDel and the tables T_FriendMain, T_FriendList, T_WaitFriend, T_FriendMail, T_CGuid.

Source: IGCN S17 MuOnline / Me_MuOnline scripts, X-Team S2 / S17 DB/MuOnline.sql, MuDevs S18 script, 97d MuOnline.bak (module text), DmN CMS 1.2.3 setup.

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.