[Share]Avoid stealing accounts

[mogo]

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?

[raimonbrinks]

Nice share really!:

But Is it also possible to make for freya?

[xAddytzu]

Nice share really!:

But Is it also possible to make for freya?

Sure

[SkyNet]

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 :/

[nikarasprotos]

1 @ skynet i got hack i havent posted anithing here sb took my account

2 take it easy man

[raimonbrinks]

oke i have problem i try for Freya but dosn't work any one can say how it must be

 

Uploaded with ImageShack.us

 

[xAddytzu]

Add after RegionBBSManager.getInstance().changeCommunityBoard();

ProtectionIP.onEnterWorld(activeChar);

[raimonbrinks]

Thank you now all oke!

[raimonbrinks]

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?

[xAddytzu]

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();
		}
	}
}

[raimonbrinks]

Yess it works :) thank you for help

[xAddytzu]

Yess it works :) thank you for help

You welcome.

 

- xAddytzu

[SoRa]

Awesome share xAddytzu,keep sharing mate.

P.S It works perfect so thank you again! :)

[L2Raijin]

Now this is really awesome!!!!! Btw how much resources does it take? Lets say 500 online players on server...All log on after rr...Wont it lag?

 

[xAddytzu]

Now this is really awesome!!!!! Btw how much resources does it take? Lets say 500 online players on server...All log on after rr...Wont it lag?

 

No