Cerberiuk

Can someone answer for my question?!!

you need just rename one sql file.

LoginController.java

 

if(ok)

{

client.setAccessLevel(access);

client.setLastServer(lastServer);

statement = con.prepareStatement("UPDATE accounts SET lastactive=? WHERE login=?");

statement.setLong(1, System.currentTimeMillis());

statement.setString(2, user);

statement.execute();

statement.close();

statement = null;

}

 

md = null;

 

EnterWorld.java

 

 

activeChar.teleToLocation(MapRegionTable.TeleportWhereType.Town);

activeChar.sendMessage("You have been teleported to the nearest town due to you being in siege zone");

}

 

RegionBBSManager.getInstance().changeCommunityBoard();

ProtectionIP.onEnterWorld(activeChar);

CustomWorldHandler.getInstance().enterWorld(activeChar);

 

if (TvT._savePlayers.contains(activeChar.getName()))

TvT.addDisconnectedPlayer(activeChar);

 

 

ProtectionIP.java

 

 

/* This program is free software; you can redistribute it and/or modify

* it under the terms of the GNU General Public License as published by

* the Free Software Foundation; either version 2, or (at your option)

* any later version.

*

* This program is distributed in the hope that it will be useful,

* but WITHOUT ANY WARRANTY; without even the implied warranty of

* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

* GNU General Public License for more details.

*

* You should have received a copy of the GNU General Public License

* along with this program; if not, write to the Free Software

* Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA

* 02111-1307, USA.

*

* http://www.gnu.org/copyleft/gpl.html

*/

package com.l2jfrozen.gameserver.model.entity;

 

import java.sql.PreparedStatement;

import java.sql.ResultSet;

 

import com.l2jfrozen.util.database.L2DatabaseFactory;

import com.l2jfrozen.gameserver.network.clientpackets.Say2;

import com.l2jfrozen.gameserver.model.actor.instance.L2PcInstance;

import com.l2jfrozen.gameserver.network.serverpackets.CreatureSay;

 

/**

*

* @author  xAddytzu

*/

public class ProtectionIP

{

  public static void onEnterWorld(L2PcInstance player)

  {

      String last = "";

      String curr = "";

      try

      {

        last = LastIP(player);

        curr = player.getClient().getConnection().getInetAddress().getHostAddress();

      }

      catch (Exception e)

      {

      }

 

      if (!last.equals(curr))

        player.sendPacket(new CreatureSay(1, Say2.PARTY, "SYSTEM", "Your last ip was: "+last+" and current: " +curr+ ""));

 

      UpdateLastIP(player, player.getAccountName());

  }

  public static String LastIP(L2PcInstance player)

  {

      String lastIp = "";

      java.sql.Connection con = null;

      try

      {

        ResultSet rset;

        con = L2DatabaseFactory.getInstance().getConnection();

        PreparedStatement statement = con.prepareStatement("SELECT * FROM `accounts` WHERE login = ?");

        statement.setString(1, player.getAccountName());

        rset = statement.executeQuery();

            while(rset.next())

            {

              lastIp = rset.getString("lastIP");

            }

      }

      catch(Exception e)

      {

        e.printStackTrace();

      }

      finally

      {

        try

        {

            con.close();

        }

        catch(Exception e)

        {

            e.printStackTrace();

        }

      }

      return lastIp;

  }

 

  public static void UpdateLastIP(L2PcInstance player ,String user)

  {

      String address = player.getClient().getConnection().getInetAddress().getHostAddress();

      java.sql.Connection con = null;

      try

      {

        con = L2DatabaseFactory.getInstance().getConnection();

        PreparedStatement statement = con.prepareStatement("UPDATE accounts SET lastIP=? WHERE login=?");

        statement.setString(1, address);

        statement.setString(2, user);

        statement.execute();

        statement.close();

      }

      catch(Exception e)

      {

        e.printStackTrace();

      }

      finally

      {

        try

        {

            con.close();

        }

        catch(Exception e)

        {

            e.printStackTrace();

        }

      }

  }

}

 

All perfect  NO ONE mistake! why not working? WHY not showing nothing when I log in? Just please answer me someone  :-\

Thanks for sharing ! It is very good:)

ej peope can anyone tell me who have Last Hero event on L2frozen?

NeoX you can't see this Event :DDDD but say Very good :DD very nice :D

I fix that mistake but this code does not work anyway.... Can help me someone? Use anyone that code on L2Frozen?

Can someone tell me, why that code doesn't work on L2frozen? it shows me that getActiveChar() its wrong...