Вот код, красным выделена 29 строчка!
Скрытый текст
package handlers.voicedcommandhandlers;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.logging.Logger;
import com.l2jserver.L2DatabaseFactory;
import com.l2jserver.gameserver.handler.IVoicedCommandHandler;
import com.l2jserver.gameserver.model.actor.instance.L2PcInstance;
public class IpBlock
implements IVoicedCommandHandler
{
public IpBlock()
{
}
public boolean useVoicedCommand(String s, L2PcInstance l2pcinstance, String s1)
{
if(s.startsWith("ipblock"))
{
try
{
Connection connection = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement preparedstatement = connection.prepareStatement("SELECT * FROM accounts WHERE login=?");
preparedstatement.setString(1, l2pcinstance.getAccountName());
ResultSet resultset = preparedstatement.executeQuery();
resultset.next();
if(resultset.getBoolean("IPBlock"))
{
PreparedStatement preparedstatement1 = connection.prepareStatement("UPDATE accounts SET ipblock = 0 WHERE login=?");
preparedstatement1.setString(1, l2pcinstance.getAccountName());
preparedstatement1.execute();
l2pcinstance.sendMessage("Ваш аккаунт больше не привязан по IP-адресу");
_log.info((new StringBuilder()).append("changing ip block mode for account ").append(l2pcinstance.getAccountName()).append(": Blocking off").toString());
} else
{
PreparedStatement preparedstatement2 = connection.prepareStatement("UPDATE accounts SET ipblock = 1 WHERE login=?");
preparedstatement2.setString(1, l2pcinstance.getAccountName());
preparedstatement2.execute();
l2pcinstance.sendMessage((new StringBuilder()).append("Ваш аккаут был привязан к IP-адресу").append(resultset.getString("lastIP")).toString());
_log.info((new StringBuilder()).append("changing ip block mode for account ").append(l2pcinstance.getAccountName()).append(": Blocking on").toString());
}
}
catch(SQLException sqlexception)
{
_log.warning((new StringBuilder()).append("Could not store IPBlock mode: ").append(sqlexception).toString());
}
}
return true;
}
public String[] getVoicedCommandList()
{
return VOICED_COMMANDS;
}
private static Logger _log = Logger.getLogger(handlers.voicedcommandhandlers.IpBlock.class.getName());
private static final String VOICED_COMMANDS[] = {
"ipblock"
};
}
