Revision 605

Grand Olympiad update.
- Reworked Olympiad Observer mode. Also, fixed several related old bugs.
- Added Olympiad point ranking.
- Olympiad data will now be stored into database.
- Improved Olympiad user packet broadcasts.
- Players who log out during Olympiad will spawn at their initial location upon relog.
- Olympiad properties file will now contain Olympiad configurations.
- Fixed a serious bug that could stuck hero computation. This was caused by removal of Javolution.
- Minor corrections on database installer.
- Removed skill_name column from character_skills, since it's useless and consumes space.
- Fixed Olympiad and Seven Signs auto-save global tasks not running.

Before updating, please make sure to install new addons.
All in all, new update requires the following:
- Installation of olympiad_data and olympiad_nobles_eom tables.
- Drop of column skill_name from character_skills.
- Move of stored parameters from olympiad properties file to olympiad_data table.

Best regards,
DnR

New installation, DB clean.

Code:

Error could not store char skills: java.sql.SQLException: Parameter index out of range (5 > number of parameters, which is 4).

Wrong section to post bugs/errors.

-->   https://l2jlisvus.forumotion.com/f2-bug-reports

Hello. character_skills table has been updated. *Please update the corresponding table inside your database.
*Drop skill_name column and update skill_level column type.

Best regards,
DnR

DnR wrote:Hello. character_skills table has been updated. *Please update the corresponding table inside your database.
*Drop skill_name column and update skill_level column type.

Best regards,
DnR

It's a new installation, all tables clean and get this error.

FIXED

Code:

Index: java/net/sf/l2j/gameserver/model/actor/instance/L2PcInstance.java
===================================================================
--- java/net/sf/l2j/gameserver/model/actor/instance/L2PcInstance.java (revision 608)
+++ java/net/sf/l2j/gameserver/model/actor/instance/L2PcInstance.java (working copy)
@@ -7179,8 +7179,7 @@
 statement.setInt(1, getObjectId());
 statement.setInt(2, newSkill.getId());
 statement.setInt(3, newSkill.getLevel());
- statement.setString(4, newSkill.getName());
- statement.setInt(5, classIndex);
+ statement.setInt(4, classIndex);
 statement.execute();
 }
 }


This was truly a project fault. Added fix in rev609.
I am sorry for the inconvenience, and thanks for pointing out and fixing the issue.

Best regards,
DnR