Last Login for Lucera

[Haber]

Hey ! I would like to share with you a simple script that shows the IP and date of the last login.

package listeners;

import l2.commons.dbutils.DbUtils;
import l2.gameserver.database.DatabaseFactory;
import l2.gameserver.listener.actor.player.OnPlayerEnterListener;
import l2.gameserver.model.Player;

import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.Date;

public class LastLogin implements OnPlayerEnterListener {

    @Override
    public void onPlayerEnter(Player var1) {

        Timestamp ts = new Timestamp(var1.getLastAccess() * 1000);
        Date la = new Date(ts.getTime());
        SimpleDateFormat df = new SimpleDateFormat("dd/MM/yyyy, HH:mm");
        String ll = df.format(la);
        var1.sendMessage("Your character was last logged in " + ll);
        var1.sendMessage("Last IP: " + LastIP(var1));
        var1.sendMessage("Current IP: " + var1.getIP());
    }

    public static String LastIP(Player var1)
    {
        String var2 = "";
        Connection var3 = null;
        PreparedStatement var4 = null;
        ResultSet var5 = null;
        try
        {
            var3 = DatabaseFactory.getInstance().getConnection();
            var4 = var3.prepareStatement("select lastIP from accounts where login = ?");
            var4.setString(1, var1.getAccountName());
            var5 = var4.executeQuery();
            while(var5.next())
            {
                var2 = var5.getString("lastIP");
            }
        } catch (SQLException ex) {
            System.out.println(ex.getMessage());

        } finally {
            DbUtils.closeQuietly(var3, var4, var5);
        }
        return var2;
    }
}