[Plugin] LastOnline

Minotorious · May 29th 2017

As the name says this plugin queries your world database and gives you the date a player was last on your server.

Only Command:
/lastonline playername (Admin only)

Should return a line like this: Player <playername> was last online on: <date>. That was <x> days ago.

joe67 · Jun 4th 2017

'Thank you for this plugin. This helps a lot identifying players who abandoned their unfinished buildings and works fine.

What I would like to have as a plugin is to get a list of all players that ever visited the server. Is this possible? Or would you mind publishing the source code of your plugin to give a clue how this could be done?

Minotorious · Jun 4th 2017

thanks, glad you find it helpful.

The source code is not that complicated in this plugin, all it does is a simple SQL query on the world database. See below a simplified example that does what you want (it is missing some safety nets but should work):

Java

@EventMethod
public void onCommand(PlayerCommandEvent event){
    Player player = event.getPlayer();
    String command = event.getCommand();
    if (command.equals("/playerlist")){ 
        WorldDatabase database = getWorldDatabase();
        try(ResultSet result = database.executeQuery("SELECT Name FROM Player")){
            while (result.next()){
                player.sendTextMessage(result.getString("Name"));
            }
        }
        catch(SQLException e){
            player.sendTextMessage("oups");
        }
    }
}

Display More

joe67 · Jun 4th 2017

Thank you very much for your quick response. I will have a look on how to use this for a plugin as soon as I have some spare time.

Minotorious · Jun 4th 2017

you're welcome I am currently working on few other plugins for "my" server but if I get some time I will pack this up in a jar file for you to use.

joe67 · Jun 4th 2017

This would be very kind. Thanks in advance.

lenko · Jun 5th 2017

Thank you first for the plugin but unfortunately it works only with sql-lite, with a mysql database is not unfortunately.

Minotorious · Jun 5th 2017

huh :O that is unexpected....I will have a look at the code tomorrow to try to fix that. Thanks for letting me know

Minotorious · Jun 24th 2017

@lenko Ich hab jetzt ein MySQL Server erstellt und das Plug-in funktioniert. Kannst du mir sagen genau was du gemacht hast und vielleicht kann ich dann dir mehr helfen?

lenko · Jun 24th 2017

Quote from Minotorious

@lenko Ich hab jetzt ein MySQL Server erstellt und das Plug-in funktioniert. Kannst du mir sagen genau was du gemacht hast und vielleicht kann ich dann dir mehr helfen?

Hey. Ich sag dir dann Bescheid. Hab Immo nicht so viel Zeit

lenko · Jun 27th 2017

sorry, hat etwas gedauert.

irgendwie versteh ich es nicht. wir haben dein plugin erst auf unserem testserver getestet, alles ok
dann auf unserem Hauptserver und es kam keine Ausgabe, nun habe ich es nochmal getestet und es geht auch auf unserem Hauptserver mit mysql.

wenn es nochmal zu problemen kommen sollte, meld ich mich aber sonst danke für dein Angebot.

Wer genug Kaffee trinkt, hat Koffein im Blut

icon58 · Sep 3rd 2017

What would be the chances of getting the location of where the player was when they left?

Deirdre · Sep 5th 2017

Is there a difference between the plugin and the chat command "last player name". or more information?

Locations can be found in the database, but you need to search.

Minotorious · Sep 5th 2017

didn't know that command existed....will try it out and let you know if there is a difference

icon58 · Sep 5th 2017

I have pulled the DB and looked at then information but maybe because "I am a PC Tech Jim not a programmer" I cannot make sense of the coordinates? I use DB browser lite to peak in the DB and it has many rows for the coords...

Smudger · Jul 15th 2018

Quote from joe67

Thank you very much for your quick response. I will have a look on how to use this for a plugin as soon as I have some spare time.

did this ever happen?

Minotorious · Jul 15th 2018

Yes i think it was done but can't remember what name it wa uploaded under. But if you own the servee you can just open the world database to see all players

Edit: found it, [Plugin] List all Players

lenko · Aug 26th 2018

It would not be bad to just enter the command and then a list of day, month or so will pop up.

Deirdre · Aug 26th 2018

You can also use the ingame chat command "last playername" to see all informations.

lenko · Aug 26th 2018

Quote from Deirdre

You can also use the ingame chat command "last playername" to see all informations.

du musst den spielernamen mit eingeben und siehst dann wann er / sie das letzte mal auf dem Server war

Participate now!