Community AlphaAlpha MUADMINS
VITiếng Việt
Đăng nhập
Trên MuADMINSConfig ScannerTải lên zip file của bạn: rate, rơi đồ, spot, giới hạnMởTrên MuADMINSGặp chúng tôi trên DiscordNhờ giúp đỡ, chia sẻ những gì bạn đang làm và trò chuyện về MU với các chủ server khác.Mở
← Tất cả giải pháp

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

MuADMINS biên soạn từ nguồnNot 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.

Do MuADMINS biên soạn
Cách này có giúp được bạn không?

Vẫn còn vướng mắc? Tìm trên MuGPS Hỏi Trợ lý MU

MuADMINS Community Alpha: miễn phí, do cộng đồng xây dựng, đang được phát triển tích cực.