gooses89 Posted March 13, 2014 Report Share Posted March 13, 2014 Does anyone know of any existing tool that shows where people are logged out on a map? Link to comment Share on other sites More sharing options...
Uro Posted April 4, 2014 Report Share Posted April 4, 2014 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.... Link to comment Share on other sites More sharing options...
bFe Posted April 4, 2014 Report Share Posted April 4, 2014 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. Link to comment Share on other sites More sharing options...
Uro Posted April 6, 2014 Report Share Posted April 6, 2014 Look up the player in the database :) Link to comment Share on other sites More sharing options...
bFe Posted April 6, 2014 Report Share Posted April 6, 2014 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 Link to comment Share on other sites More sharing options...
hambeast Posted April 7, 2014 Report Share Posted April 7, 2014 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. bFe 1 Link to comment Share on other sites More sharing options...
Affraid Posted May 8, 2014 Report Share Posted May 8, 2014 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. Link to comment Share on other sites More sharing options...
StiflersM0M Posted May 9, 2014 Report Share Posted May 9, 2014 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); Link to comment Share on other sites More sharing options...
Affraid Posted May 10, 2014 Report Share Posted May 10, 2014 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 . Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now