Jump to content

Recommended Posts

Posted

No, we dont use this system, we have own, so shut up, if you dont know nothing...

<sarcasm>Oh..My..God.. Wow you have your OWN 50 lines of code?? Really?? Like zomg man you're the bestestest.</sarcasm>

Anyways.. ok so i login to my account and i have all my precious items stolen, and the screen is only showing the last ip of the thief ( which is pobably proxy anyway ). Am i missing something?

  • 3 weeks later...
Posted

trusted seller

 

nikarasprotos = true spammer...

 

its a share or can't u read? where u see here somethings to sell ?

 

ontopic: guess its useless its won't help a player at all... only if the stealer has a static IP :/

Posted

WARNING: Unclosed connection! Trace: com.l2jserver.gameserver.model.entity.ProtectionIP.UpdateLastIP(ProtectionIP.java:92)

java.lang.RuntimeException

at com.l2jserver.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:227)

at com.l2jserver.gameserver.model.entity.ProtectionIP.UpdateLastIP(ProtectionIP.java:92)

at com.l2jserver.gameserver.model.entity.ProtectionIP.onEnterWorld(ProtectionIP.java:50)

at com.l2jserver.gameserver.network.clientpackets.EnterWorld.runImpl(EnterWorld.java:473)

at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:62)

at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:997)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

i got this error anyone knows?

Posted

Replace your static method "UpdateLastIP" with

 

public static void UpdateLastIP(L2PcInstance player ,String user)
{
	String address = player.getClient().getConnection().getSocketChannel().socket().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();
		}
	}
}

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.




×
×
  • Create New...