/* 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();
}
}
}
}
kai to evala sto pack alla otan kaneis login den s vgazei tpt .. prepei na mpeis apo ena pc kai meta apo ena allo gia na s vgalei to mynhma..ginete na tou kanoume akwma kai an einai h idia ip na to dixnei?
Hi. I have an issue with the interface — I want to remove the autoshot option from the interface and leave only the standard functionality.
Make the red work like the green so it's easier to understand.
he options could be removed via .dat, but I want to keep the window — just with the normal manual activation function
Where to look for this symbol in the launch file LoginServer.bat or in the database file? Maybe someone can throw off their server that was actually launched. Or a file to register the server. I downloaded the server and inserted the MSQL password everywhere. I don't understand the rest. Help please.
GameServer.
I apologize, I managed to launch it without errors. I moved the server from the desktop to the root of the C drive and it launched without errors. Thank you very much. If anyone has the RegisterGameServer.bat file, I would be very grateful.
Question
maximilion2
Klhspera :) Vrhka auto:
and
ProtectionIP.java
kai to evala sto pack alla otan kaneis login den s vgazei tpt .. prepei na mpeis apo ena pc kai meta apo ena allo gia na s vgalei to mynhma..ginete na tou kanoume akwma kai an einai h idia ip na to dixnei?
16 answers to this question
Recommended Posts