[Release] Simple players online page

[UsernameUnknown]

​

Add the following to your database

ALTER PROCEDURE [dbo].[WEB_PlayersOnline]
as
BEGIN
SELECT uc.LastUpdateDate, uc.Gamertag, uc.CustomerID, ud.CustomerID, ud.IsDeveloper, ud.AccountType From UsersChars as uc
JOIN UsersData as ud ON
uc.CustomerID = ud.CustomerID
WHERE DATEDIFF(MINUTE, uc.LastUpdateDate, GETDATE()) <= 15
END

Files :

You must be registered to see links

 

[own_prox]

if you wanted this i suggest you put a int column isOnline and update it to 1 when player loggs iin and 0 when logs out and just for a good mannor when server starts up set all to 0

your putting strain on mssql when not needed

 

[iTzTonyR703]

Credit zonfire :fanny:

 

[Joe Cooper]

if you wanted this i suggest you put a int column isOnline and update it to 1 when player loggs iin and 0 when logs out and just for a good mannor when server starts up set all to 0

your putting strain on mssql when not needed

Good to know man thanks, and it is released as is no support!

 

[Rigor Mortis]

Credit zonfire :fanny:

Actually it was originally implemented into some of the unknowN's code by Zon ...... So credit to both of them.

 

[iTzTonyR703]

Actually it was originally implemented into some of the unknowN's code by Zon ...... So credit to both of them.

which unknown we talking about here

 

[LukasCCB]

if only to show the online numbers would colocari there?

Thanks again for your sharing =)

 

[Rigor Mortis]

which unknown we talking about here

Does it really matter Tony.....They know who they are. Lay off of my threads.

 

[GdZ]

have sript for Number players online ?
Exemple: Survivors Online: 13
please.

 

[Doky]

would have something to change there?
wanted it to be by numbers
"Online Players: 58"


Thanks for sharing liked this idea: D

 

[Naoki Seiichi]

/*ALTER PROCEDURE [dbo].[WEB_PlayersOnline]*/
CREATE PROCEDURE [dbo].[WEB_PlayersOnline]
as
BEGIN
SELECT uc.LastUpdateDate, uc.Gamertag, uc.CustomerID, ud.CustomerID, ud.IsDeveloper, ud.AccountType From UsersChars as uc
JOIN UsersData as ud ON
uc.CustomerID = ud.CustomerID
WHERE DATEDIFF(MINUTE, uc.LastUpdateDate, GETDATE()) <= 15
END