[RELEASE] Script - Number of Players Online

[ProfNerwosol]

I don't remember why I made the Select statement to chose LoginStatus field. Just remove it and leave Family only.

[NocturnalSniper]

i had it in the root directory but never could ge it to work. same problem everytime with the print statement.
I finally wrote my own that shows ToonName Level Mode and Class

[il.mane]

LoginStatus was ment to tell who's online :P would be just great have it working,
still... cant read that column with the php code, its there but look like its been missing a sort of "commit" or make it readable, i dunno im too noob with SQL to tell

[ShaiyaUnited]

Worked without problems thx alot,ProfNerwosol

[ProfNerwosol]

Originally Posted by il.mane

LoginStatus was ment to tell who's online :P would be just great have it working,
still... cant read that column with the php code, its there but look like its been missing a sort of "commit" or make it readable, i dunno im too noob with SQL to tell

Actually no. The statement filters everyone who has LoginStatus=1. What I forgot is why in the world I select something that is after WHERE clause.

[Shaiyasux]

In online.php, first line says <?
should say <?PHP
This is where I had the problem. For other people that are new to this, like myself.

[topazee]

problem ...

Players online: ".$online." Human: ".$human." Elf: ".$elf." Vail: ".$vail." DeathEater: ".$nordein." "; @mssql_close($link); ?>

[nevak]

Hi! First of all thanks for the script, Prof. Really good idea =)
However, I have to say that after using it for some days I have noticed that some characters show online when in fact they are not. After further researching I found out that this happens when a player goes to character selection screen instead of closing the game window. So I think that usp_Save_Char_LeaveDate_R is not called unless you close the window so the LoginStatus remains 1.
I have found another SP that also alters "LeaveDate" which is usp_Save_Char_Info_E. However making this SP set LoginStatus to 0 causes to eventually show all players offline.

So...Im clueless, does this happen to you also guys?


Thanks in advance =)

[ProfNerwosol]

Yup, we had the same problem. Players were shown online when their game crashed.
Abrasive solved the problem with his and EarthCrush's fix for item duping. It will take some time and modifications to use it though.

[Xx.LaMin.xX]

well you can easily change that check Char loginstatus and acc login
the script was only connecting to character not to account. In ep3 database(mine one) have login status plus character status so the ranking show whos online when both char and acc online.. if not then offline.

[nevak]

Well, I finally added this line in PS_UserData.dbo.usp_Try_GameLogout_R

UPDATE PS_GameData.dbo.Chars SET LoginStatus = 0, LeaveDate = GETDATE() WHERE UserUID = @UserUID

Now the problem is gone, thank you both for your answers ^^

[Svinseladden]

heya. first i get this: Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.Chars" because it does not exist or you do not have permissions.

this is from Add_LoginStatus

then i get : Msg 208, Level 16, State 6, Procedure usp_Read_Chars_Detail2_R, Line 78
Invalid object name 'dbo.usp_Read_Chars_Detail2_R'.


when i use Procedure1

and :

Msg 208, Level 16, State 6, Procedure usp_Save_Char_LeaveDate_R, Line 14
Invalid object name 'dbo.usp_Save_Char_LeaveDate_R'.

when i use Procedure2. i don't realy need the php. i just want to be abel to check how many ppl are online. if this is posible tell me how please:-) just a sql query not php. becouse sql conn3ect on iss 7.5 don't work i guess. i only get odbc to work in iss 7.5


NB:after done all this is haver the colum LoginStatus but all set to NULL

[[GM]Hazel]

Hi, I tried running the 2 proc's an altered them it seems that my database doesn't like the login status as it doesn't ever update. Is there anything else we must edit for it to work or is it just that. Any help would be greatly appricated. Thanks

[thetruestarr1337]

me too

[HoaX.]

Here a fix made by me.


Run this Query:

USE [PS_GameLog]
GO
/****** Object:  Trigger [dbo].[Leave]    Script Date: 11/29/2011 19:25:07 by [Dev]HoaX ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[Leave]
ON [PS_GameLog].[dbo].[UserLog]
FOR INSERT
AS
declare @UserUID int

SET @UserUID= (SELECT UserUID FROM inserted)

UPDATE PS_GameData.dbo.Chars SET LoginStatus=0 WHERE UserUID=@UserUID

This creates a Trigger which uses the error UserLog.
If someone gets DC the server sends error values in this log.
This Trigger sets the User LoginStatus that got DCed back to 0 if a new error row gets added.
It's not tested yet.

Use this to reset all LoginStatus to 0.

UPDATE PS_GameData.dbo.Chars SET LoginStatus=0

If this helps you click the Thanks button.