Instructions
Place the code below in your PS_GameLog.dbo.usp_Insert_Action_Log_E
( PS_GameLog > Programmability > Stored Procedures > usp_Insert_Action_Log_E )
You should place this near the bottom to insure it will take effect properly if your unsure where to add new script to the procedure.
Code:
/* Login - Logout replacement for players online */ IF @ActionType = '108' BEGIN UPDATE PS_GameData.dbo.Chars SET [LoginStatus]=0 WHERE PS_GameData.dbo.Chars.CharID=@CharID END IF @ActionType = '107' BEGIN UPDATE PS_GameData.dbo.Chars SET [LoginStatus]=1 WHERE PS_GameData.dbo.Chars.CharID=@CharID END
This script is designed to read login / logout of any character the server detects as offline. This means even DC's will register as the server logs the logout when it detects the online person as not being present any longer.
**Related Material