Initiate Mage
- Joined
- Jan 4, 2015
- Messages
- 2
- Reaction score
- 2
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
Attachments
You must be registered for see attachments list