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))
- 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');- 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.
- 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.