Dupe protection

[Swarlog]

Código [Seleccionar] Expandir

/**
    * Get back items in inventory from database
    */
   @Override
   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, "BANIDO POR SESSAO DUPLA A CONTA PRINCIPAL DO 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);
      }
   }
Se trata de un code suelto/complementario, por ello tiene el (@Override). Lo que hace es llamar a la función restore de L2PcInstance y hace además ese chequeo que indica para evitar el dupe.

Par poder utilizarlo podrias ponerlo en una nueva clase, por ejemplo:

Código [Seleccionar] Expandir

public class DupProtection extends AbstractNpcAI
{
private DupProtection()
{
super(DupProtection.class.getSimpleName(), "xxxxx/custom");
}

/**
* Get back items in inventory from database
*/
@Override
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, "BANIDO POR SESSAO DUPLA A CONTA PRINCIPAL DO 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);
}
}

public static void main(String[] args)
{
new DupProtection();
}
}