Tool that shows offline player locations

[gooses89]

Does anyone know of any existing tool that shows where people are logged out on a map?

[Uro]

I'm confused...

 

Why would you need to know where someone logged out?

 

Unless your planning to troll them when they login again...

 

Or something else....

[bFe]

I'm confused...

 

Why would you need to know where someone logged out?

 

Unless your planning to troll them when they login again...

 

Or something else....

 

 

To trace down combat loggers etc.

BlissAdmin had that feature, but I haven't seen it since.

[Uro]

Look up the player in the database :)

[bFe]

Its a hassle to have to get the coordinates, then apply them to yourself and go ingame to check out were the person logged out.
Doesn't take long at all, but its still a minor hassle :P

[hambeast]

Its a hassle to have to get the coordinates, then apply them to yourself and go ingame to check out were the person logged out.

Doesn't take long at all, but its still a minor hassle :P

 

you can take a look at one of the player map tools, most of them query the character_data table for recent activity and display the players location by that.  You could modify the query so it just looks for players who are alive.

 

Depending on your server and the number of unique players alive it may be kind of cluttered.

SELECT COUNT(*) 
  FROM dayz_epoch.character_data cd
  WHERE 1 = 1
  AND cd.Alive = 1

returns 4446 records.

 

Now if we narrow it down to say the last week, we get

SELECT COUNT(*) 
  FROM dayz_epoch.character_data cd
  WHERE 1 = 1
  AND cd.Alive = 1
  AND cd.LastLogin > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY)

returns 263 records.  Much more manageable.

[Affraid]

I'm looking for the same thing. My reason is that it's easier to clean up abandoned bases. When looking at build items the Character ID chANGES everytime they die. So it's a real pain in the ass to see who's items they are. 

 

HAMBEAST..

 

I like the way you can check live players in DB for up to certain days. How would you do that with just players who havn't logged in ? Example : i'm looking to just show up the players who havn't logged in 30 days. 

[StiflersM0M]

Shows the player who are not logged in for 30 days and more,

SELECT * FROM `character_data` WHERE `LastLogin` <= date_sub(CURRENT_TIMESTAMP, INTERVAL 30 DAY)

Delete all players who have not logged it for over 30 days,

DELETE FROM `character_data` WHERE `LastLogin` <= date_sub(CURRENT_TIMESTAMP, INTERVAL 30 DAY);

[Affraid]

 

Shows the player who are not logged in for 30 days and more,

SELECT * FROM `character_data` WHERE `LastLogin` <= date_sub(CURRENT_TIMESTAMP, INTERVAL 30 DAY)

Delete all players who have not logged it for over 30 days,

DELETE FROM `character_data` WHERE `LastLogin` <= date_sub(CURRENT_TIMESTAMP, INTERVAL 30 DAY);

Great . Thank You for the reply .