Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server > Shaiya PServer Guides & Releases
You last visited: Today at 07:00

  • Please register to post and access all features, it's quick, easy and FREE!


[RELEASE FIX] Players Online - Logout not detected or not displayed properly

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Oct 2009
Posts: 56
Received Thanks: 478
[RELEASE FIX] Players Online - Logout not detected or not displayed properly

For those of you using the original release of the players online script that are having trouble with accurate logout detection would benefit from this mini fix. The reason the error occurs is because the script is tagging the wrong stored procedure for logout. This SP is not fired when the server doesn't detect a proper logout so disconnections will error the script results. I have been asked repeatedly for this fix after I released my players online php/css adaptation and wish to release the fix to assist others unable to figure out the error.

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 [email protected] 	
	END
IF @ActionType = '107'
	BEGIN
        UPDATE PS_GameData.dbo.Chars SET [LoginStatus]=1 WHERE [email protected]		
    END
Explanation

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
Original Players Online Release
My Players Online Display Release



BodySalvage is offline  
Thanks
19 Users
Reply



« closed | Shaiya Login Screen Edit »

Similar Threads
[RELEASE]Players Online Script
NOTICE - This was assembled under Xampp 1.8.2 and tested on 1.6.3 as well. These 2 versions are all I can attest to for functionality and it is...
7 Replies - Shaiya PServer Guides & Releases
[RELEASE] Script - Number of Players Online
Updated Script showing how many players are online, with distinction by race. Instructions: Note that for it to work, you need to alter two...
47 Replies - Shaiya PServer Guides & Releases
[Release]Users Visiting/Players Online
Just some simple code to display how many people are visiting your site and the number of players on your server. Players Online: This one will...
5 Replies - EO PServer Guides & Releases
[Release] Total Players Online
For Who Looking For that code that code let you know how many players play on your server now Its Not Made by Me Total Players Online: 30...
1 Replies - CO2 PServer Guides & Releases
[RELEASE] Free Items to all Online Players
A "free" Command, put this Command in Client.cs under GM or Owner Command and change "@" to "/" if your command start with "/" "LOFT code not...
17 Replies - CO2 PServer Guides & Releases



All times are GMT +2. The time now is 07:00.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.