Hi guys,
I created a dupe protection that is working quite well but I need some helo to improve it. As you can see below, I modified the gameserver.model.itemcontainer.inventory.java to remove all item from character bag if a dupe session is identified and also ban all accounts that have the same IP as the duping account. I need to know is how can I implement a kick process after ban the user.
I copy and past all restore() class from iventory.java below
public void restore()
{
Connection con = null;
int BanStatus = 0;
int char_id;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement = con.prepareStatement("SELECT object_id, item_id, count, enchant_level, loc, loc_data, custom_type1, custom_type2, mana_left, time FROM items WHERE owner_id=? AND (loc=? OR loc=?) ORDER BY loc_data");
statement.setInt(1, getOwnerId());
statement.setString(2, getBaseLocation().name());
statement.setString(3, getEquipLocation().name());
ResultSet inv = statement.executeQuery();
L2ItemInstance item;
while (inv.next())
{
item = L2ItemInstance.restoreFromDb(getOwnerId(), inv);
if (item == null)
{
continue;
}
// Bug get empty items when double session is created
if (L2World.getInstance().findObject(inv.getInt("object_id")) != null)
{
_log.log(Level.WARNING, "Item: " + item.getObjectId() + " Has Duplied on World And Cannot be Load");
L2World.getInstance().removeObject(item);
BanStatus = 1;
continue;
}
if (getOwner() instanceof L2PcInstance)
{
L2PcInstance player = (L2PcInstance) getOwner();
if (!player.isGM() && !player.isHero() && item.isHeroItem())
{
item.setLocation(ItemLocation.INVENTORY);
}
}
L2World.getInstance().storeObject(item);
// If stackable item is found in inventory just add to current quantity
if (item.isStackable() && (getItemByItemId(item.getItemId()) != null))
{
addItem("Restore", item, getOwner().getActingPlayer(), null);
}
else
{
addItem(item);
}
}
inv.close();
statement.close();
refreshWeight();
/* ---------------------- Ban account --------------------------- */
if (BanStatus == 1)
{
Connection BanCon = null;
try
{
BanCon = L2DatabaseFactory.getInstance().getConnection();
// PreparedStatement statement2 = BanCon.prepareStatement("update accounts set accesslevel =-100 where login in (select account_name from characters where charid = ? )");
PreparedStatement statement2 = BanCon.prepareStatement("update accounts acc , characters ch, accounts ac2 set ac2.accesslevel = -100 where acc.login = ch.account_name and ch.charid = ? and acc.lastIP = ac2.lastIP ");
statement2.setInt(1, getOwnerId());
int BanSQL = statement2.executeUpdate();
char_id = getOwnerId();
_log.log(Level.WARNING, "BANNED MAIN ACCOUNT THAT IS USING THE CHAR_ID : " + char_id);
}
catch (Exception e)
{
_log.log(Level.WARNING, "Falha ao banir usuario: " + e.getMessage(), e);
}
finally
{
L2DatabaseFactory.close(BanCon);
}
}
/* ---------------------- end Ban account --------------------------- */
}
catch (Exception e)
{
_log.log(Level.WARNING, "Could not restore inventory: " + e.getMessage(), e);
}
finally
{
L2DatabaseFactory.close(con);
}
}