Sistema Anty Dual Box

[Swarlog]

Básicamente es un script que te permite limitar el uso de cuentas desde la misma direccion IP. En la mayoria de los emuladores ya viene integrado, pero lo dejo por aqui por si a alguien le hace falta o puede aprovechar su código para lo que sea

Código [Seleccionar] Expandir

/*
 * 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 3 of the License, 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, see <http://www.gnu.org/licenses/>.
 */

package custom.AntiDualBox;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import com.l2jserver.L2DatabaseFactory;
import com.l2jserver.gameserver.model.actor.instance.L2PcInstance;
import com.l2jserver.gameserver.model.quest.Quest;

public class AntiDualBox extends Quest
{
    public AntiDualBox(int questId, String name, String descr)
    {
        super(questId, name, descr);
        setOnEnterWorld(true);
    }
   
    @Override
    public final String onEnterWorld(L2PcInstance player)
    {
        // Cantidad maxima de usuarios desde la misma computadora:
        long MaximumBoxAllowed = 1;
       
        Connection con = null;
        PreparedStatement statement = null;
        String PlayerAccountName = player.getAccountName();
        String PlayerLastIP = "";
        String PlayerPcIP = "";
        long CharsFromSamePC = 0;
   
        try
        {
            con = L2DatabaseFactory.getInstance().getConnection();
            statement = con.prepareStatement("SELECT accounts.lastIP FROM accounts WHERE accounts.login = ?");
            statement.setString(1, PlayerAccountName);
           
            ResultSet resultSet = statement.executeQuery();
           
            while (resultSet.next())
            {
                PlayerLastIP = resultSet.getString(1);
            }
           
            resultSet.close();
            statement.close();
        }
       
        catch (Exception e)
        {
            //Errors
        }
       
        finally
        {
            L2DatabaseFactory.close(con);
        }
       
        try
        {
            con = L2DatabaseFactory.getInstance().getConnection();
            statement = con.prepareStatement("SELECT accounts.pcIp FROM accounts WHERE accounts.login = ?");
            statement.setString(1, PlayerAccountName);
           
            ResultSet resultSet = statement.executeQuery();
           
            while (resultSet.next())
            {
                PlayerPcIP = resultSet.getString(1);
            }
           
            resultSet.close();
            statement.close();
        }
       
        catch (Exception e)
        {
            //Errors
        }
       
        finally
        {
            L2DatabaseFactory.close(con);
        }
       
        try
        {
            con = L2DatabaseFactory.getInstance().getConnection();
            statement = con.prepareStatement("SELECT COUNT(characters.char_name) FROM accounts INNER JOIN characters ON accounts.login = characters.account_name WHERE characters.online = 1 AND accounts.lastIP = ? AND accounts.pcIp = ?");
            statement.setString(1, PlayerLastIP);
            statement.setString(2, PlayerPcIP);
           
            ResultSet resultSet = statement.executeQuery();
           
            while (resultSet.next())
            {
                CharsFromSamePC = resultSet.getLong(1);
            }
           
            resultSet.close();
            statement.close();
        }
       
        catch (Exception e)
        {
            //Errors
        }
       
        finally
        {
            L2DatabaseFactory.close(con);
        }
       
        if (CharsFromSamePC > MaximumBoxAllowed)
        {
            //player.sendMessage("You are allowed to use " + MaximumBoxAllowed + " client!);
            player.logout();
        }
   
        return null;
    }
   
    public static void main(String[] args)
    {
        new AntiDualBox(-1, "AntiDualBox", "custom");
    }
}