Anty Dual Box

[Swarlog]

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