Piraelle

http://forummaxi.ru/files/file/700-l2-scriptsru-09072014-hf/ как вариант пока сам гоняю вродь все работает единственное что привязка минусы : - как я понял сборка у когото стояла конфиги над ставить сразу из архива нулевые (а то не будет наботать помошник новечков ) и по адресу gameserver\data\pc_parameters\template_data над менять шмот для старта перса (стандартно топ нг и пуха нг на 15=) )

больше двух говорят в слух))

[29.04.15 02:11:50:988] INFO dao.AccountVariablesDAO: AccountVariablesDAO.select(String, String): java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1). java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1). at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3717) at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3701) at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:4541) at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135) at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135) at l2s.gameserver.dao.AccountVariablesDAO.select(AccountVariablesDAO.java:41) at l2s.gameserver.security.SecondaryPasswordAuth.loadPassword(SecondaryPasswordAuth.java:47) at l2s.gameserver.security.SecondaryPasswordAuth.<init>(SecondaryPasswordAuth.java:41) at l2s.gameserver.network.GameClient.setLoginName(GameClient.java:253) at l2s.gameserver.clientpackets.AuthLogin.runImpl(AuthLogin.java:44) at l2s.gameserver.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:50) at l2s.commons.net.nio.impl.MMOExecutableQueue.run(MMOExecutableQueue.java:38) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) [29.04.15 02:11:51:005] INFO dao.AccountVariablesDAO: AccountVariablesDAO.select(String, String): java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1). java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1). at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3717) at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3701) at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:4541) at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135) at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135) at l2s.gameserver.dao.AccountVariablesDAO.select(AccountVariablesDAO.java:41) at l2s.gameserver.security.SecondaryPasswordAuth.loadPassword(SecondaryPasswordAuth.java:52) at l2s.gameserver.security.SecondaryPasswordAuth.<init>(SecondaryPasswordAuth.java:41) at l2s.gameserver.network.GameClient.setLoginName(GameClient.java:253) at l2s.gameserver.clientpackets.AuthLogin.runImpl(AuthLogin.java:44) at l2s.gameserver.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:50) at l2s.commons.net.nio.impl.MMOExecutableQueue.run(MMOExecutableQueue.java:38) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) [29.04.15 02:11:51:023] ERROR clientpackets.L2GameClientPacket: Client: CONNECTED IP: 192.168.1.45 Account: minori - Failed running: [C] AuthLogin - Server Version: ${build.revision} java.lang.NumberFormatException: For input string: "" at java.lang.NumberFormatException.forInputString(Unknown Source) at java.lang.Integer.parseInt(Unknown Source) at java.lang.Integer.parseInt(Unknown Source) at l2s.gameserver.security.SecondaryPasswordAuth.loadPassword(SecondaryPasswordAuth.java:54) at l2s.gameserver.security.SecondaryPasswordAuth.<init>(SecondaryPasswordAuth.java:41) at l2s.gameserver.network.GameClient.setLoginName(GameClient.java:253) at l2s.gameserver.clientpackets.AuthLogin.runImpl(AuthLogin.java:44) at l2s.gameserver.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:50) at l2s.commons.net.nio.impl.MMOExecutableQueue.run(MMOExecutableQueue.java:38) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)

ок

https://yadi.sk/d/FUTOyA1_gJpyE ссылка на фаил буду признателен за помощь

как удобней передать фаил через скайп или яндекс диск?

заплюсую всех))

ок очень благодарен за помощь , единственное что исходов нету =( пойду искать пилу =) , если кто в курсе как внести изменения в фаил просьба подетиться знаниями ))

l2s\ \gameserver\ \dao\ \AccountVariablesDAO.java добрался до фаила 41 строку выделил желтым package l2s.gameserver.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import l2s.commons.dbutils.DbUtils; import l2s.gameserver.database.DatabaseFactory; import org.slf4j.Logger; import org.slf4j.LoggerFactory; public class AccountVariablesDAO { private static final Logger _log = LoggerFactory.getLogger(AccountVariablesDAO.class); private static final AccountVariablesDAO _instance = new AccountVariablesDAO(); public static final String SELECT_SQL_QUERY = "SELECT var, value FROM account_variables WHERE account_name=?"; public static final String DELETE_SQL_QUERY = "DELETE FROM account_variables WHERE account=? AND var=?"; public static final String INSERT_SQL_QUERY = "REPLACE INTO account_variables(account_name, var, value) VALUES (?,?,?)"; public static final String UPDATE_SQL_QUERY = "UPDATE account_variables SET value=? WHERE account=? AND var=?"; public static AccountVariablesDAO getInstance() { return _instance; } public String select(String account, String var) { String result_value = ""; Connection con = null; PreparedStatement statement = null; ResultSet rset = null; try { con = DatabaseFactory.getInstance().getConnection(); statement = con.prepareStatement("SELECT var, value FROM account_variables WHERE account_name=?"); statement.setString(1, account); statement.setString(2, var); rset = statement.executeQuery(); if (rset.next()) { result_value = rset.getString("value"); } } catch (Exception e) { _log.info("AccountVariablesDAO.select(String, String): " + e, e); } finally { DbUtils.closeQuietly(con, statement, rset); } return result_value; } public void delete(String account, String var) { Connection con = null; PreparedStatement statement = null; try { con = DatabaseFactory.getInstance().getConnection(); statement = con.prepareStatement("DELETE FROM account_variables WHERE account=? AND var=?"); statement.setString(1, account); statement.setString(2, var); statement.execute(); } catch (Exception e) { _log.info("AccountVariablesDAO.delete(String, String): " + e, e); } finally { DbUtils.closeQuietly(con, statement); } } public void insert(String account, String var, String value) { Connection con = null; PreparedStatement statement = null; try { con = DatabaseFactory.getInstance().getConnection(); statement = con.prepareStatement("REPLACE INTO account_variables(account_name, var, value) VALUES (?,?,?)"); statement.setString(1, account); statement.setString(2, var); statement.setString(3, value); statement.execute(); } catch (Exception e) { _log.info("AccountVariablesDAO.insert(String, String, String): " + e, e); } finally { DbUtils.closeQuietly(con, statement); } } public void update(String account, String var, String value) { Connection con = null; PreparedStatement statement = null; try { con = DatabaseFactory.getInstance().getConnection(); statement = con.prepareStatement("UPDATE account_variables SET value=? WHERE account=? AND var=?"); statement.setString(1, value); statement.setString(2, account); statement.setString(3, var); statement.execute(); } catch (Exception e) { _log.info("AccountVariablesDAO.update(String, String, String): " + e, e); } finally { DbUtils.closeQuietly(con, statement); } } }

Все что было в SQL Все залил

Доброго дня ! Прошу помощи в решение проблемы связанной с включением второго пароля на персанаже. Включил в конфигах вот это SecondAuthEnabled =true В клиенте тоже включил Активирует второй пароль при выборе персонажей # Должно быть включено в клиенте # l2.ini # [Auth] # UseSecondaryAuth=true вроде все сделал как надо но дальше выбора сервера не пускает (защиту отключал включал результат 0) ниже логи как я понимаю проблема в пакетах (может чтото надо делать с патчем?) [28.04.15 03:49:03:595] INFO dao.AccountVariablesDAO: AccountVariablesDAO.select(String, String): java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1). java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1). at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3717) at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3701) at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:4541) at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135) at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135) at l2s.gameserver.dao.AccountVariablesDAO.select(AccountVariablesDAO.java:41) at l2s.gameserver.security.SecondaryPasswordAuth.loadPassword(SecondaryPasswordAuth.java:47) at l2s.gameserver.security.SecondaryPasswordAuth.<init>(SecondaryPasswordAuth.java:41) at l2s.gameserver.network.GameClient.setLoginName(GameClient.java:253) at l2s.gameserver.clientpackets.AuthLogin.runImpl(AuthLogin.java:44) at l2s.gameserver.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:50) at l2s.commons.net.nio.impl.MMOExecutableQueue.run(MMOExecutableQueue.java:38) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) [28.04.15 03:49:03:614] INFO dao.AccountVariablesDAO: AccountVariablesDAO.select(String, String): java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1). java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1). at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3717) at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3701) at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:4541) at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135) at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135) at l2s.gameserver.dao.AccountVariablesDAO.select(AccountVariablesDAO.java:41) at l2s.gameserver.security.SecondaryPasswordAuth.loadPassword(SecondaryPasswordAuth.java:52) at l2s.gameserver.security.SecondaryPasswordAuth.<init>(SecondaryPasswordAuth.java:41) at l2s.gameserver.network.GameClient.setLoginName(GameClient.java:253) at l2s.gameserver.clientpackets.AuthLogin.runImpl(AuthLogin.java:44) at l2s.gameserver.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:50) at l2s.commons.net.nio.impl.MMOExecutableQueue.run(MMOExecutableQueue.java:38) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) [28.04.15 03:49:03:628] ERROR clientpackets.L2GameClientPacket: Client: CONNECTED IP: 192.168.1.42 Account: piraelle - Failed running: [C] AuthLogin - Server Version: ${build.revision} java.lang.NumberFormatException: For input string: "" at java.lang.NumberFormatException.forInputString(Unknown Source) at java.lang.Integer.parseInt(Unknown Source) at java.lang.Integer.parseInt(Unknown Source) at l2s.gameserver.security.SecondaryPasswordAuth.loadPassword(SecondaryPasswordAuth.java:54) at l2s.gameserver.security.SecondaryPasswordAuth.<init>(SecondaryPasswordAuth.java:41) at l2s.gameserver.network.GameClient.setLoginName(GameClient.java:253) at l2s.gameserver.clientpackets.AuthLogin.runImpl(AuthLogin.java:44) at l2s.gameserver.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:50) at l2s.commons.net.nio.impl.MMOExecutableQueue.run(MMOExecutableQueue.java:38) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)