aiongermany/aion-germany

Aion Emulator

aion-germany's Issues

Client Crashing

The gameforge client keeps crashing before server selection.

What should i do?

Zones missing

If You start game with Elyos (with non admin account) these zones are missing:

AZPHEL_SANCTUARY_220110000
ARIEL_SANCTUARY_210100000

Cube Expansion Problem

It is impossible expand the inventory to level 11.
Cube Expansion Key are present in the inventory, and when you try to improve they are not used.
Either I do something wrong or the keys don't work.

Error with skill charge

skills charge doesnt work properly, when i use it with boost casting speed , the speed works , the skill go faster but the effect doesnt count speed casting , and then dont apply effect correctly , Sleep of sorcerer cant be boosted with casting speed boost , in this aion-ger, sleep can be boosted. thanks ^^ ( sorry for my english xD )

GS Error

error.log

Error on loading GameServer (Include log)

哪里提交BUG 修复呢！Where to submit BUG repair!

哪里提交BUG 修复呢！
Where to submit BUG repair!

Event Window from ghostfur

Not working!? (rev125)

• i can't see or open this Event Window

Ophidan Bridge - small problem

Great is Ophidan Bridge working :) but:
There is second chest (supply) on the left side (bug if You click on it)

Magos and Tokanu Not working properly

Location Protective film Not working
Player enters no invincible gain effect

Skill Animation Issues Solved!

I fixing it now its a small error :) in skill animations i forgot something in static_data adding now :)

Base.spawnAttackers -> Null Pointer

In source Base->spawnAttackers:
I was tryed to remove and fix this (to avoid throw nullpointer) this line 449:
throw new NullPointerException("Base:" + getId() + " flag is null!");
I receive nullpointer today testing.

2018-07-15 10:43:05,579 Exception in a Runnable execution:
java.lang.NullPointerException: null
at com.aionemu.gameserver.services.base.Base.spawnAttackers(Base.java:451) ~[AL-Game.jar:na]

Maybe this should be ignore.

Bad AI names: flag

Warning log:
2018-06-24 21:28:59,842 [AIEngine] Bad AI names: flag

Skill Skin Errors

I can no Skill Skin Cards learn with Cleric, Elyos!

I can learn only 1 Skill Skin (Templer, Elyos)
All other skill Skins makes a Error and some Skill Skin Cards have no "Action":

2018-06-16 00:24:45,240 ERROR [PacketProcessor:3] mysql5.MySQL5PlayerTitleListDAO [MySQL5PlayerSkillSkinListDAO.java]:68] Could not store skill skin for player 326057 from DB: Duplicate entry '326057' for key 'PRIMARY' com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '326057' for key 'PRIMARY' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_51] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_51] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_51] at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:1.7.0_51] at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE] at mysql5.MySQL5PlayerSkillSkinListDAO.storeSkillSkins(MySQL5PlayerSkillSkinListDAO.java]:65) ~[na:na] at com.aionemu.gameserver.model.skinskill.SkillSkinList.addSkillSkin(SkillSkinList.java:76) [AL-Game.jar:na] at com.aionemu.gameserver.model.templates.item.actions.SkillAnimationAction.act(SkillAnimationAction.java:55) [AL-Game.jar:na] at com.aionemu.gameserver.network.aion.clientpackets.CM_USE_ITEM.runImpl(CM_USE_ITEM.java:204) [AL-Game.jar:na] at com.aionemu.gameserver.network.aion.AionClientPacket.run(AionClientPacket.java:65) [AL-Game.jar:na] at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) [al-commons.jar:na] at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:41) [al-commons.jar:na] at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:266) [al-commons.jar:na] at java.lang.Thread.run(Unknown Source) [na:1.7.0_51] 2018-06-16 00:24:52,498 ERROR [PacketProcessor:1] mysql5.MySQL5PlayerTitleListDAO [MySQL5PlayerSkillSkinListDAO.java]:68] Could not store skill skin for player 326057 from DB: Duplicate entry '326057' for key 'PRIMARY' com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '326057' for key 'PRIMARY' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_51] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_51] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.7.0_51] at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:1.7.0_51] at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE] at mysql5.MySQL5PlayerSkillSkinListDAO.storeSkillSkins(MySQL5PlayerSkillSkinListDAO.java]:65) ~[na:na] at com.aionemu.gameserver.model.skinskill.SkillSkinList.addSkillSkin(SkillSkinList.java:76) [AL-Game.jar:na] at com.aionemu.gameserver.model.templates.item.actions.SkillAnimationAction.act(SkillAnimationAction.java:55) [AL-Game.jar:na] at com.aionemu.gameserver.network.aion.clientpackets.CM_USE_ITEM.runImpl(CM_USE_ITEM.java:204) [AL-Game.jar:na] at com.aionemu.gameserver.network.aion.AionClientPacket.run(AionClientPacket.java:65) [AL-Game.jar:na] at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) [al-commons.jar:na] at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:41) [al-commons.jar:na] at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:266) [al-commons.jar:na] at java.lang.Thread.run(Unknown Source) [na:1.7.0_51] 2018-06-16 00:26:02,715 WARN [PacketProcessor:1] com.aionemu.gameserver.network.aion.clientpackets.CM_USE_ITEM [CM_USE_ITEM.java:145] CHECKPOINT: No Item use Action: 326057 189600149 2018-06-16 00:26:04,292 WARN [PacketProcessor:0] com.aionemu.gameserver.network.aion.clientpackets.CM_USE_ITEM [CM_USE_ITEM.java:145] CHECKPOINT: No Item use Action: 326057 189600149 2018-06-16 00:26:05,831 WARN [PacketProcessor:2] com.aionemu.gameserver.network.aion.clientpackets.CM_USE_ITEM [CM_USE_ITEM.java:145] CHECKPOINT: No Item use Action: 326057 189600129 2018-06-16 00:26:06,591 WARN [PacketProcessor:1] com.aionemu.gameserver.network.aion.clientpackets.CM_USE_ITEM [CM_USE_ITEM.java:145] CHECKPOINT: No Item use Action: 326057 189600129 2018-06-16 00:26:06,966 WARN [PacketProcessor:3] com.aionemu.gameserver.network.aion.clientpackets.CM_USE_ITEM [CM_USE_ITEM.java:145] CHECKPOINT: No Item use Action: 326057 189600149 2018-06-16 00:26:07,337 WARN [PacketProcessor:0] com.aionemu.gameserver.network.aion.clientpackets.CM_USE_ITEM [CM_USE_ITEM.java:145] CHECKPOINT: No Item use Action: 326057 189600129 2018-06-16 00:26:07,763 WARN [PacketProcessor:2] com.aionemu.gameserver.network.aion.clientpackets.CM_USE_ITEM [CM_USE_ITEM.java:145] CHECKPOINT: No Item use Action: 326057 189600149 2018-06-16 00:26:08,057 WARN [PacketProcessor:1] com.aionemu.gameserver.network.aion.clientpackets.CM_USE_ITEM [CM_USE_ITEM.java:145] CHECKPOINT: No Item use Action: 326057 189600129

applying sql

On player_events_window08.06.2018.sql i get this error

Query: CREATE TABLE player_events_window (account_idint(11) NULL DEFAULT NULL,event_idint(11) NULL DEFAULT NULL,last_stamptimestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,elapsed double(11, 0) NULL DEFAULT 0, PRIMARY KEY (account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Error occured at:2018-06-11 06:25:39
Line no.:8
Error Code: 1171 - All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead`

About Geodata

Maybe someone have updated geodata builder (with collision flags) ?
Collision flags are very important, defining inside of object (building,caves and others)
Or how to receive this collision info flags?
Generally we have 5.8 version and most maps changed from 4.8 version.(there are some terrain+objects differences in many maps, and there are new maps).

Error in new Querys

If You will try to run these querys there is a bug (Primary key problem).

player_events_window08.06.2018.sql
player_skill_skins08.06.2018.sql

5.8模拟器魔族排行榜不显示你们更新吗

5.8模拟器魔族排行榜不显示你们更新吗

SERVER has not been able to run smoothly

Operating environment: WIN10 PRO (1803) + JDK1.8 (game server using JRE1.7) + MariaDB 10 + AION 5.8 CHS client.
After opening the server, open the client to register an account and establish a character to enter the game. It is found that the character does not have any skills (including active and passive). Even if you use the GM command to assign character skills, you enter the game after exiting. The previously assigned skills all disappear. Now. But there are no such problems using several other server-side emulators. I hope to help find the problem and solve it. Thank you very much!
Attachments are screenshots of skills within the game client. Picture 1 is active and picture 2 is passive.


Game server log is as follows:

18:28:24.988 INFO [ReadWrite-0 Dispatcher]: - Authentication with Client Version 5.8
18:28:25.094 INFO [InstantPool-14]: - [LoginServer] Account authed: 2 = admint
18:28:25.154 INFO [PacketProcessor:3]: - 0 IPv4: {}
18:28:25.155 INFO [PacketProcessor:3]: - Mac: 90-2B-34-37-01-14
18:28:25.155 INFO [PacketProcessor:3]: - HDD SERIAL: 2139D56C
18:28:25.155 INFO [PacketProcessor:3]: - Local IP: {192.168.2.11}
18:28:25.155 INFO [PacketProcessor:3]: - Connect IP: 192.168.2.11
18:29:51.126 ERROR[pool-2-thread-30]: - Could not restore Event Window account: 321038 from DB: Table 'al_ser58_gs.player_events_window' doesn't exist
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'al_ser58_gs.player_events_window' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_25]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[na:1.7.0_25]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_25]
at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_25]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2030) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.jolbox.bonecp.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:172) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
at mysql5.MySQL5PlayerEventsWindowDAO.load(MySQL5PlayerEventsWindowDAO.java]:40) ~[na:na]
at com.aionemu.gameserver.services.player.PlayerService.getPlayer(PlayerService.java:210) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.player.PlayerEnterWorldService.enterWorld(PlayerEnterWorldService.java:316) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.player.PlayerEnterWorldService$1.run(PlayerEnterWorldService.java:290) ~[AL-Game.jar:na]
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) ~[al-commons.jar:na]
at com.aionemu.commons.utils.concurrent.RunnableWrapper.run(RunnableWrapper.java:40) ~[al-commons.jar:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) ~[na:1.7.0_25]
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) ~[na:1.7.0_25]
at java.util.concurrent.FutureTask.run(FutureTask.java:166) ~[na:1.7.0_25]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) ~[na:1.7.0_25]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) ~[na:1.7.0_25]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) ~[na:1.7.0_25]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) ~[na:1.7.0_25]
at java.lang.Thread.run(Thread.java:724) ~[na:1.7.0_25]
18:29:51.132 ERROR[pool-2-thread-30]: - Could not restore f2p time for accountId: 2 from DB: Unknown column 'account_id' in 'where clause'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'account_id' in 'where clause'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_25]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[na:1.7.0_25]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_25]
at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_25]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2030) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.jolbox.bonecp.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:172) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
at mysql5.MySQL5Free2PlayDAO.loadF2pInfo(MySQL5Free2PlayDAO.java]:52) ~[na:na]
at com.aionemu.gameserver.services.player.PlayerService.getPlayer(PlayerService.java:213) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.player.PlayerEnterWorldService.enterWorld(PlayerEnterWorldService.java:316) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.player.PlayerEnterWorldService$1.run(PlayerEnterWorldService.java:290) ~[AL-Game.jar:na]
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) ~[al-commons.jar:na]
at com.aionemu.commons.utils.concurrent.RunnableWrapper.run(RunnableWrapper.java:40) ~[al-commons.jar:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) ~[na:1.7.0_25]
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) ~[na:1.7.0_25]
at java.util.concurrent.FutureTask.run(FutureTask.java:166) ~[na:1.7.0_25]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) ~[na:1.7.0_25]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) ~[na:1.7.0_25]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) ~[na:1.7.0_25]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) ~[na:1.7.0_25]
at java.lang.Thread.run(Thread.java:724) ~[na:1.7.0_25]
18:29:51.184 WARN [pool-2-thread-30]: - Error executing select query com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'al_ser58_gs.player_skill_skins' doesn't exist
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'al_ser58_gs.player_skill_skins' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_25]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[na:1.7.0_25]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_25]
at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_25]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2030) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.jolbox.bonecp.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:172) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
at com.aionemu.commons.database.DB.select(DB.java:186) [al-commons.jar:na]
at com.aionemu.commons.database.DB.select(DB.java:165) [al-commons.jar:na]
at mysql5.MySQL5PlayerSkillSkinListDAO.loadSkillSkinList(MySQL5PlayerSkillSkinListDAO.java]:35) ~[na:na]
at com.aionemu.gameserver.services.player.PlayerService.getPlayer(PlayerService.java:225) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.player.PlayerEnterWorldService.enterWorld(PlayerEnterWorldService.java:316) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.player.PlayerEnterWorldService$1.run(PlayerEnterWorldService.java:290) ~[AL-Game.jar:na]
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) ~[al-commons.jar:na]
at com.aionemu.commons.utils.concurrent.RunnableWrapper.run(RunnableWrapper.java:40) ~[al-commons.jar:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) ~[na:1.7.0_25]
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) ~[na:1.7.0_25]
at java.util.concurrent.FutureTask.run(FutureTask.java:166) ~[na:1.7.0_25]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) ~[na:1.7.0_25]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) ~[na:1.7.0_25]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) ~[na:1.7.0_25]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) ~[na:1.7.0_25]
at java.lang.Thread.run(Thread.java:724) ~[na:1.7.0_25]
18:29:51.283 ERROR[pool-2-thread-30]: - Could not restore equipment setting for playerObjId: 321038 from DB: Table 'al_ser58_gs.player_equipment_setting' doesn't exist
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'al_ser58_gs.player_equipment_setting' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_25]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[na:1.7.0_25]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_25]
at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_25]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2030) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.jolbox.bonecp.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:172) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
at mysql5.MySQL5PlayerEquipmentSettingDAO.loadEquipmentSetting(MySQL5PlayerEquipmentSettingDAO.java]:53) ~[na:na]
at com.aionemu.gameserver.services.player.PlayerService.getPlayer(PlayerService.java:312) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.player.PlayerEnterWorldService.enterWorld(PlayerEnterWorldService.java:316) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.player.PlayerEnterWorldService$1.run(PlayerEnterWorldService.java:290) ~[AL-Game.jar:na]
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) ~[al-commons.jar:na]
at com.aionemu.commons.utils.concurrent.RunnableWrapper.run(RunnableWrapper.java:40) ~[al-commons.jar:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) ~[na:1.7.0_25]
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) ~[na:1.7.0_25]
at java.util.concurrent.FutureTask.run(FutureTask.java:166) ~[na:1.7.0_25]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) ~[na:1.7.0_25]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) ~[na:1.7.0_25]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) ~[na:1.7.0_25]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) ~[na:1.7.0_25]
at java.lang.Thread.run(Thread.java:724) ~[na:1.7.0_25]
18:29:51.283 INFO [pool-2-thread-30]: - [MAC_AUDIT] Player Testname (account admint) has entered world with 90-2B-34-37-01-14 MAC.
18:29:51.294 INFO [pool-2-thread-30]: - [MonsterbookService] loaded ...
18:29:51.447 INFO [pool-2-thread-30]: - Player logged in: Testname Account: admint
18:29:51.454 INFO [pool-2-thread-30]: - Player Testname Received Ascension Boost
18:29:51.477 WARN [pool-2-thread-30]: - Error executing select query com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'al_ser58_gs.player_events_window' doesn't exist
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'al_ser58_gs.player_events_window' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_25]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[na:1.7.0_25]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_25]
at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_25]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2030) ~[mysql-connector-java-5.1.33.jar:5.1.33]
at com.jolbox.bonecp.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:172) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
at com.aionemu.commons.database.DB.select(DB.java:186) [al-commons.jar:na]
at com.aionemu.commons.database.DB.select(DB.java:165) [al-commons.jar:na]
at mysql5.MySQL5PlayerEventsWindowDAO.getEventsWindow(MySQL5PlayerEventsWindowDAO.java]:115) ~[na:na]
at com.aionemu.gameserver.services.EventWindowService.getPlayerEventsWindow(EventWindowService.java:103) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.EventWindowService.onLogin(EventWindowService.java:121) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.player.PlayerEnterWorldService.enterWorld(PlayerEnterWorldService.java:601) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.player.PlayerEnterWorldService$1.run(PlayerEnterWorldService.java:290) ~[AL-Game.jar:na]
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) ~[al-commons.jar:na]
at com.aionemu.commons.utils.concurrent.RunnableWrapper.run(RunnableWrapper.java:40) ~[al-commons.jar:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) ~[na:1.7.0_25]
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) ~[na:1.7.0_25]
at java.util.concurrent.FutureTask.run(FutureTask.java:166) ~[na:1.7.0_25]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) ~[na:1.7.0_25]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) ~[na:1.7.0_25]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) ~[na:1.7.0_25]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) ~[na:1.7.0_25]
at java.lang.Thread.run(Thread.java:724) ~[na:1.7.0_25]
18:29:51.481 INFO [pool-2-thread-30]: - Start counting id 1 time 60 minute(s)
18:29:51.483 INFO [pool-2-thread-30]: - Start counting id 2 time 60 minute(s)
18:29:51.483 INFO [pool-2-thread-30]: - Start counting id 3 time 60 minute(s)
18:29:51.484 INFO [pool-2-thread-30]: - Start counting id 4 time 30 minute(s)
18:29:51.485 INFO [ReadWrite-0 Dispatcher]: - event id 1 remain 60 start-time 1514877300 end-time 1564697700 total size 4
18:29:51.485 INFO [ReadWrite-0 Dispatcher]: - event id 2 remain 60 start-time 1514877300 end-time 1564697700 total size 4
18:29:51.486 INFO [ReadWrite-0 Dispatcher]: - event id 3 remain 60 start-time 1514877300 end-time 1564697700 total size 4
18:29:51.486 INFO [ReadWrite-0 Dispatcher]: - event id 4 remain 30 start-time 1528876800 end-time 1530691200 total size 4
18:29:51.521 INFO [pool-2-thread-30]: - Loading PetitionService ...
18:29:51.524 INFO [pool-2-thread-30]: - Successfully loaded 0 database petitions
18:29:51.534 INFO [pool-2-thread-30]: - [ConquerorsService] ==You're Last Activity [Testname]==
18:29:51.534 INFO [pool-2-thread-30]: - [ConquerorsService] Kills : 0
18:29:51.535 INFO [pool-2-thread-30]: - [ConquerorsService] Buffs Protector : 0
18:29:51.536 INFO [pool-2-thread-30]: - [ConquerorsService] Buffs Conqueror : 0
Daily: 20339
Daily: 30658
Daily: 30687
Daily: 30321
Daily: 31670
18:29:53.532 INFO [pool-2-thread-5]: - [SurveyController] update task start.
18:29:57.364 INFO [PacketProcessor:2]: - CraftSkillUpdateService: Initialized.

Magic boost not working properly.

I tried to get max magic boost of 7k on sorc, and its seems like the skills only do 100% dmg and not counting the magic boost.

Its not suppost to be like that i think. Please reply.

Skill Skins from ghostfur

Cleric Skill Books (rev125)

• cant use this Skill Books with my Cleric

Forum Thread:
http://falke34.bplaced.net/forums/showthread.php?tid=3107

Skill Animation from ghostfur

Missing item Action in Item template

• can not use skill crads

Skills save

Always when i disconnect , armor and skill dissapears ?? why ? i mean i have 0 skills only developper skill

PlayerEnterWorldService.java error after update

2018-06-10 17:09:44,367 Error during enter world 321889
java.lang.NullPointerException: null
at com.aionemu.gameserver.services.player.PlayerEnterWorldService.enterWorld(PlayerEnterWorldService.java:863) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.player.PlayerEnterWorldService$1.run(PlayerEnterWorldService.java:267) ~[AL-Game.jar:na]
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) [al-commons.jar:na]
at com.aionemu.commons.utils.concurrent.RunnableWrapper.run(RunnableWrapper.java:40) [al-commons.jar:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [na:1.7.0_80]
at java.util.concurrent.FutureTask.run(Unknown Source) [na:1.7.0_80]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source) [na:1.7.0_80]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) [na:1.7.0_80]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.7.0_80]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.7.0_80]
at java.lang.Thread.run(Unknown Source) [na:1.7.0_80]

Forum???

Hey,
kann man sich nicht mehr bei euch im Forum anmelden???

Small problem with Book of Monsters

When you kill mob Moonlight Spirit counts mob Kselliki and so on with the others. Use Gameforge client.

P.S. Sorry for the bad English.

Fix all XSD file include errors in Static_data

Sorry, I don't really use GITHUB. I don't know how to upload differential files and PULL. I can only package them here. Please integrate ZIP content and fix all XSD file include errors in Static_data.
static_data.zip

After the Divine Fortress is opened, the server gs will make a mistake. The log report is as follows:

2018-06-23 17:59:50,724 Can't get elapsed time!
java.sql.SQLException: Illegal operation on empty result set.
2018-06-23 18:00:35,508
java.lang.NullPointerException: null
at com.aionemu.gameserver.dataholders.TribeRelationsData.getBaseTribe(TribeRelationsData.java:60) ~[AL-Game.jar:na]
at com.aionemu.gameserver.model.gameobjects.Npc.getBaseTribe(Npc.java:178) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.TribeRelationService.isNone(TribeRelationService.java:214) ~[AL-Game.jar:na]
at com.aionemu.gameserver.model.gameobjects.Npc.getType(Npc.java:236) ~[AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.serverpackets.SM_NPC_INFO.(SM_NPC_INFO.java:67) ~[AL-Game.jar:na]
at com.aionemu.gameserver.controllers.PlayerController.see(PlayerController.java:193) ~[AL-Game.jar:na]
at com.aionemu.gameserver.world.knownlist.KnownList.addVisualObject(KnownList.java:153) ~[AL-Game.jar:na]
at com.aionemu.gameserver.world.knownlist.KnownList.add(KnownList.java:133) ~[AL-Game.jar:na]
at com.aionemu.gameserver.world.knownlist.KnownList.findVisibleObjects(KnownList.java:232) ~[AL-Game.jar:na]
at com.aionemu.gameserver.world.knownlist.KnownList.doUpdate(KnownList.java:83) ~[AL-Game.jar:na]
at com.aionemu.gameserver.world.knownlist.NpcKnownList.doUpdate(NpcKnownList.java:35) ~[AL-Game.jar:na]
at com.aionemu.gameserver.model.gameobjects.VisibleObject.updateKnownlist(VisibleObject.java:178) ~[AL-Game.jar:na]
at com.aionemu.gameserver.world.World.spawn(World.java:448) ~[AL-Game.jar:na]
at com.aionemu.gameserver.spawnengine.SpawnEngine.bringIntoWorld(SpawnEngine.java:210) ~[AL-Game.jar:na]
at com.aionemu.gameserver.spawnengine.SpawnEngine.bringIntoWorld(SpawnEngine.java:203) ~[AL-Game.jar:na]
at com.aionemu.gameserver.spawnengine.VisibleObjectSpawner.spawnSiegeNpc(VisibleObjectSpawner.java:250) ~[AL-Game.jar:na]
at com.aionemu.gameserver.spawnengine.SpawnEngine.getSpawnedObject(SpawnEngine.java:91) ~[AL-Game.jar:na]
at com.aionemu.gameserver.spawnengine.SpawnEngine.spawnObject(SpawnEngine.java:69) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.SiegeService.spawnNpcs(SiegeService.java:499) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.siegeservice.Siege.spawnNpcs(Siege.java:229) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.siegeservice.FortressSiege.onSiegeStart(FortressSiege.java:103) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.siegeservice.Siege.startSiege(Siege.java:82) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.SiegeService.startSiege(SiegeService.java:247) ~[AL-Game.jar:na]
at admincommands.SiegeCommand.handleStartStopSiege(SiegeCommand.java]:98) ~[na:na]
at admincommands.SiegeCommand.execute(SiegeCommand.java]:64) ~[na:na]
at com.aionemu.gameserver.utils.chathandlers.ChatCommand.run(ChatCommand.java:41) ~[AL-Game.jar:na]
at com.aionemu.gameserver.utils.chathandlers.AdminCommand.process(AdminCommand.java:62) [AL-Game.jar:na]
at com.aionemu.gameserver.utils.chathandlers.ChatProcessor.handleChatCommand(ChatProcessor.java:182) [AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.clientpackets.CM_CHAT_MESSAGE_PUBLIC.runImpl(CM_CHAT_MESSAGE_PUBLIC.java:67) [AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.AionClientPacket.run(AionClientPacket.java:65) [AL-Game.jar:na]
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) [al-commons.jar:na]
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:41) [al-commons.jar:na]
at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:266) [al-commons.jar:na]
at java.lang.Thread.run(Thread.java:745) [na:1.7.0_80]

Not Playable

after like 6 hours of trying to make this server work, i came across those problems.

"cannot find or load main class com.aionemu..."
"error opening zip file or JAR manifest missing : libs/al.commons"

and the AL_Login.jar is missing...

and others like this..
if there is a solution please let me know..

Siege Boss not found for siege - Null Pointer

018-06-20 21:00:00,066 Exception in a Runnable execution:
com.aionemu.gameserver.services.siegeservice.SiegeException: [SiegeService] Siege Boss not found for siege 1241
at com.aionemu.gameserver.services.siegeservice.Siege.initSiegeBoss(Siege.java:221) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.siegeservice.FortressSiege.onSiegeStart(FortressSiege.java:104) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.siegeservice.Siege.startSiege(Siege.java:82) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.SiegeService.startSiege(SiegeService.java:247) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.SiegeService.checkSiegeStart(SiegeService.java:230) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.siegeservice.SiegeStartRunnable.run(SiegeStartRunnable.java:34) ~[AL-Game.jar:na]
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) ~[al-commons.jar:na]
at com.aionemu.commons.utils.concurrent.RunnableWrapper.run(RunnableWrapper.java:40) [al-commons.jar:na]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.7.0_80]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.7.0_80]
at java.lang.Thread.run(Unknown Source) [na:1.7.0_80]

---

Two other bugs same as upper :

2018-06-20 21:00:00,142 Exception in a Runnable execution:
com.aionemu.gameserver.services.siegeservice.SiegeException: [SiegeService] Siege Boss not found for siege 1231

2018-06-20 21:00:00,144 Exception in a Runnable execution:
com.aionemu.gameserver.services.siegeservice.SiegeException: [SiegeService] Siege Boss not found for siege 1221

Luna Points

When you add luna to yourself like for example ( //set luna 500) it giving luna coins but after a relog
all luna is gone so it doesnt stay inside db al_server_ls ? i tryed to change amounth inside the database but also has no effect

Greetings!

Skills problem

If You create new character (let's take priest), after enter to the game You have inactive skills:
(client says: You have to learn that skill)

-Healing Light
-Crush

And basic skills (inactive):
-Bandage Heal
-Return (icon is red)

These skills needs level 1 and You have level 1.
(around lvl 6 these skills are upgraded to lvl 2 and start working)

Why they are inactive ?

Inventory Shop

on Inventory Shop - opens the shop in order to sell an item directly. Prices are lower then in NPC shops.

When i go to sell a item. it trows it back into my Inventory Cube. But i can go to a NPC and sell it direct But not from Inventory Shop anymore

level 43 Asmodian Gladiator

breakage in Feb 23 commit for miniongrowth

Saving player data fails in this file with an SQL srror:
AL-Game/data/scripts/system/database/mysql5/MySQL5PlayerDAO.java

Affected statement (your update highlighted)
PreparedStatement stmt = con.prepareStatement("UPDATE players SET name=?, exp=?, recoverexp=?, x=?, y=?, z=?, heading=?, world_id=?, gender=?, race=?, player_class=?, last_online=?, cube_expands=?, advanced_stigma_slot_size=?, warehouse_size=?, note=?, title_id=?, bonus_title_id=?, dp=?, soul_sickness=?, mailbox_letters=?, reposte_energy=?, goldenstar_energy=?, growth_energy=?, bg_points=?, mentor_flag_time=?, initial_gamestats=?, world_owner=?, fatigue=?, fatigueRecover=?, fatigueReset=?, stamps=?, rewarded_pass=?, last_stamp=?, joinRequestLegionId=?, joinRequestState=?, frenzy_points=?, frenzy_count=?, bonus_type=?, bonus_buff_time=?, wardrobe_size=?, is_highdaeva=?, creativity_point=?, creativity_step=?, wardrobe_slot=?, luna_consume_count=?, muni_keys=?, luna_consume=?, toc_floor=?, minion_skill_points=?, minion_function_time=? WHERE id=?");

There is no corresponding setter for this parameter at line

		stmt.setInt(47, pcd.getMuniKeys());
		stmt.setInt(48, pcd.getLunaConsumePoint());
		stmt.setInt(49, pcd.getFloor());

•   	stmt.setInt(50,  pcd.getMinionSkillPoints());
  

•   	stmt.setInt(50, pcd.getMinionSkillPoints());
    	**here: must set value of argument 51**
                    stmt.setInt(51, player.getObjectId()); **This argument needs to change to 52**
  

I have changed my version to set an empty string as this value to resolve this. You need to set the appropriate value for your update here as I doubt an empty string is appropriate for this.

StartGS erro

Starting Aion German Version 5.x Game Server.

Java HotSpot(TM) 64-Bit Server VM warning: ignoring option UseSplitVerifier; support was removed in 8.0
18:06:53.067 ERROR[main]: - Critical Error - Thread: main terminated abnormaly: java.lang.VerifyError: Expecting a stack map frame
Exception Details:
Location:
com/aionemu/gameserver/utils/javaagent/JavaAgentUtils.checkObjectCallback()Z @90: iload_3
Reason:
Error exists in the bytecode
Bytecode:
0x0000000: 2ac0 0017 2ab4 003b 01b8 0041 4c2b b600
0x0000010: 4499 0007 03a7 0007 03a7 0003 3e2b b600
0x0000020: 4699 000e 2bb6 004a c000 4cb6 004f 3e2a
0x0000030: c000 172a b400 3b01 1dbb 004c 595d 58b7
0x0000040: 0052 b800 564c 2bb6 0058 9900 0e2b b600
0x0000050: 59c0 004c b600 4fac 1dac 1dac
Stackmap Table:
append_frame(@24,Object[#55])
same_locals_1_stack_item_frame(@28,Integer)
full_frame(@47,{Object[#20],Top,Top,Integer},{})
same_frame(@88)

java.lang.VerifyError: Expecting a stack map frame
Exception Details:
Location:
com/aionemu/gameserver/utils/javaagent/JavaAgentUtils.checkObjectCallback()Z @90: iload_3
Reason:
Error exists in the bytecode
Bytecode:
0x0000000: 2ac0 0017 2ab4 003b 01b8 0041 4c2b b600
0x0000010: 4499 0007 03a7 0007 03a7 0003 3e2b b600
0x0000020: 4699 000e 2bb6 004a c000 4cb6 004f 3e2a
0x0000030: c000 172a b400 3b01 1dbb 004c 595d 58b7
0x0000040: 0052 b800 564c 2bb6 0058 9900 0e2b b600
0x0000050: 59c0 004c b600 4fac 1dac 1dac
Stackmap Table:
append_frame(@24,Object[#55])
same_locals_1_stack_item_frame(@28,Integer)
full_frame(@47,{Object[#20],Top,Top,Integer},{})
same_frame(@88)

    at com.aionemu.gameserver.GameServer.initUtilityServicesAndConfig(GameServer.java:497) ~[AL-Game.jar:na]
    at com.aionemu.gameserver.GameServer.main(GameServer.java:239) ~[AL-Game.jar:na]

Server terminated abnormaly ...

Server terminated ...

Error during enter world 321172 : java.lang.NullPointerException: null

Hello, i'm having a problem when i try to connect with my character to the world, it starts loading and then this exceptions is returned. Could someone help me?

2018-06-12 11:47:59,550 Error during enter world 321172 java.lang.NullPointerException: null
	at com.aionemu.gameserver.services.player.PlayerEnterWorldService.enterWorld(PlayerEnterWorldService.java:863) ~[AL-Game.jar:na]
	at com.aionemu.gameserver.services.player.PlayerEnterWorldService$1.run(PlayerEnterWorldService.java:267) ~[AL-Game.jar:na]
	at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) [al-commons.jar:na]
	at com.aionemu.commons.utils.concurrent.RunnableWrapper.run(RunnableWrapper.java:40) [al-commons.jar:na]
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [na:1.7.0_80]
	at java.util.concurrent.FutureTask.run(FutureTask.java:262) [na:1.7.0_80]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) [na:1.7.0_80]
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) [na:1.7.0_80]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_80]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_80]
	at java.lang.Thread.run(Thread.java:745) [na:1.7.0_80]
2018-06-12 11:48:00,673 Dispatcher error! java.lang.NullPointerException
java.lang.NullPointerException: null
	at com.aionemu.gameserver.network.aion.serverpackets.SM_ATTACK_STATUS.writeImpl(SM_ATTACK_STATUS.java:142) ~[AL-Game.jar:na]
	at com.aionemu.gameserver.network.aion.AionServerPacket.write(AionServerPacket.java:144) ~[AL-Game.jar:na]
	at com.aionemu.gameserver.network.aion.AionConnection.writeData(AionConnection.java:321) ~[AL-Game.jar:na]
	at com.aionemu.commons.network.Dispatcher.write(Dispatcher.java:289) ~[al-commons.jar:na]
	at com.aionemu.commons.network.AcceptReadWriteDispatcherImpl.dispatch(AcceptReadWriteDispatcherImpl.java:83) ~[al-commons.jar:na]
	at com.aionemu.commons.network.Dispatcher.run(Dispatcher.java:107) ~[al-commons.jar:na]

Multiple Servers Issue

When trying to host multiple Game Servers connecting to a single login server there is an issue with the server selection.

For some reason the Client will always show the information of the first server in line (first ID in the game servers table).

Example: Server ID 1 is online and 1 character is created for this account. Server ID 2 is offline and there are 0 characters created for this account. The client would show both Server ID 1 and 2 as online and having each 1 character created. Also when trying to select a server to join it will always connect to the first server.

I can confirm that the information that the login server has about each GameServerInfo object is correct. I can only assume that something is incorrect between the packets being sent to the client and what the client is expecting.

Note* This has been tested with quite a few permutations between what servers are online/offline the id's of the servers, different passwords per server, also hosting game servers on multiple systems as well as hosting all servers on the same system. This was more just some check to make sure I wasn't missing anything with server setup and confirming that this may actually be a bug of some kind.

Skills are not saving

The skills doesn't save to db, tried to give them all manually to myself but they still disappear after relog.

Here is my logs; http://www.mediafire.com/file/i9ksigalt9fd6ns/console.log

Creating Character Error

Greetings,

When using the 64 bit client, you're unable to create a new character (by clicking the UI button). The 32 bit client works fine. I have tried with both NA and EU client. Also tested with JDK 7 and 8, same results. The error is attached below.

14:09:53.824 ERROR[ReadWrite-0 Dispatcher]: - Reading failed for packet [C] 0x153 CM_CREATE_CHARACTER
java.lang.IllegalArgumentException: There is no player class with id -7
        at com.aionemu.gameserver.model.PlayerClass.getPlayerClassById(PlayerClass.java:96) ~[AL-Game.jar:na]
        at com.aionemu.gameserver.network.aion.clientpackets.CM_CREATE_CHARACTER.readImpl(CM_CREATE_CHARACTER.java:115) ~[AL-Game.jar:na]
        at com.aionemu.commons.network.packet.BaseClientPacket.read(BaseClientPacket.java:98) ~[al-commons.jar:na]
        at com.aionemu.gameserver.network.aion.AionConnection.processData(AionConnection.java:297) [AL-Game.jar:na]
        at com.aionemu.commons.network.Dispatcher.parse(Dispatcher.java:245) [al-commons.jar:na]
        at com.aionemu.commons.network.Dispatcher.read(Dispatcher.java:206) [al-commons.jar:na]
        at com.aionemu.commons.network.AcceptReadWriteDispatcherImpl.dispatch(AcceptReadWriteDispatcherImpl.java:80) [al-commons.jar:na]
        at com.aionemu.commons.network.Dispatcher.run(Dispatcher.java:107) [al-commons.jar:na]

One small bug after last fix

You added: addPacketOpcode(SM_EVENT_WINDOW.class, 0x154, idSet);
but this colliding with: addPacketOpcode(SM_BATTLEFIELD_UNION_REGISTER.class, 0x154, idSet);

(the same OPCODES)

and bug on the console arrived.

I changed: addPacketOpcode(SM_EVENT_WINDOW.class, 0x154, idSet);
to:
addPacketOpcode(SM_EVENT_WINDOW.class, 0x153, idSet);

154 -> 153 OPCODE

Is this correct now ?

Skill Skin Cards with Time Expire

Skill Skin Cards working, but Skill Skin Cards with Time Expire (30 Days, 90 Days) dont working!

Can't find File for weapon range

Hi guys, Can someone tell me plz where i can find weapon range, since gunner has a range of 12 and 20 now which need to be 20 and 25. Also our skills damage seems to be double what i should be can someone help we with that?

Passkey sequrity option not working

I saw little fix in source code protocol but Passkey sequrity option still not working and bugs on the console(if You enter pin code). Maybe You know how to fix this ?

Problen when using 64-bit 5.8 client (EU)

For some odd reason the emu throws this exception when attempting to create a new character. This does not happen for the
console.log
32-bit client.:

2018-02-26 10:15:43,090 Reading failed for packet [C] 0x153 CM_CREATE_CHARACTER
java.lang.IllegalArgumentException: There is no player class with id -1
at com.aionemu.gameserver.model.PlayerClass.getPlayerClassById(PlayerClass.java:96) ~[AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.clientpackets.CM_CREATE_CHARACTER.readImpl(CM_CREATE_CHARACTER.java:115) ~[AL-Game.jar:na]
at com.aionemu.commons.network.packet.BaseClientPacket.read(BaseClientPacket.java:98) ~[al-commons.jar:na]
at com.aionemu.gameserver.network.aion.AionConnection.processData(AionConnection.java:297) [AL-Game.jar:na]
at com.aionemu.commons.network.Dispatcher.parse(Dispatcher.java:245) [al-commons.jar:na]
at com.aionemu.commons.network.Dispatcher.read(Dispatcher.java:206) [al-commons.jar:na]
at com.aionemu.commons.network.AcceptReadWriteDispatcherImpl.dispatch(AcceptReadWriteDispatcherImpl.java:80) [al-commons.jar:na]
at com.aionemu.commons.network.Dispatcher.run(Dispatcher.java:107) [al-commons.jar:na]

attached is my console log.
JVM in use is JDK_1.8.0_121
I used this version to compile and run (I use the -noverify JVM parameter to sidestep the Java 8's lack of a splitverifyier). I did not rebuild the commons.jar for these runs.

Fixed some EventWindow Bugs

TODO:

Better shedule ....
Remove recived reward from displayed list

Pls report Bugs for EventWindow here.

Al_server_gs.sql import error

[Err] 1067 - Invalid default value for 'level_up_date'
[Err] CREATE TABLE player_pets (
player_id int(11) NOT NULL,
pet_id int(11) NOT NULL,
decoration int(11) NOT NULL,
name varchar(255) NOT NULL,
hungry_level tinyint(4) NOT NULL DEFAULT '0',
feed_progress int(11) NOT NULL DEFAULT '0',
reuse_time bigint(20) NOT NULL DEFAULT '0',
birthday timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
mood_started bigint(20) NOT NULL DEFAULT '0',
counter int(11) NOT NULL DEFAULT '0',
mood_cd_started bigint(20) NOT NULL DEFAULT '0',
gift_cd_started bigint(20) NOT NULL DEFAULT '0',
dopings varchar(80) CHARACTER SET ascii DEFAULT NULL,
despawn_time timestamp NULL DEFAULT NULL,
expire_time int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (player_id,pet_id),
CONSTRAINT FK_player_pets FOREIGN KEY (player_id) REFERENCES players (id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

---

-- Records of player_pets

---

---

-- Table structure for player_punishments

---

DROP TABLE IF EXISTS player_punishments;
CREATE TABLE player_punishments (
player_id int(11) NOT NULL,
punishment_type enum('PRISON','GATHER','CHARBAN') NOT NULL,
start_time int(10) unsigned DEFAULT '0',
duration int(10) unsigned DEFAULT '0',
reason text,
PRIMARY KEY (player_id,punishment_type),
CONSTRAINT player_punishments_ibfk_1 FOREIGN KEY (player_id) REFERENCES players (id) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

---

-- Records of player_punishments

---

---

-- Table structure for player_quests

---

DROP TABLE IF EXISTS player_quests;
CREATE TABLE player_quests (
player_id int(11) NOT NULL,
quest_id int(10) unsigned NOT NULL DEFAULT '0',
status varchar(10) NOT NULL DEFAULT 'NONE',
quest_vars int(10) unsigned NOT NULL DEFAULT '0',
complete_count int(3) unsigned NOT NULL DEFAULT '0',
next_repeat_time timestamp NULL DEFAULT NULL,
reward smallint(3) DEFAULT NULL,
complete_time timestamp NULL DEFAULT NULL,
PRIMARY KEY (player_id,quest_id),
CONSTRAINT player_quests_ibfk_1 FOREIGN KEY (player_id) REFERENCES players (id) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

---

-- Records of player_quests

---

---

-- Table structure for player_recipes

---

DROP TABLE IF EXISTS player_recipes;
CREATE TABLE player_recipes (
player_id int(11) NOT NULL,
recipe_id int(11) NOT NULL,
PRIMARY KEY (player_id,recipe_id),
CONSTRAINT player_recipes_ibfk_1 FOREIGN KEY (player_id) REFERENCES players (id) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

---

-- Records of player_recipes

---

---

-- Table structure for player_registered_items

---

DROP TABLE IF EXISTS player_registered_items;
CREATE TABLE player_registered_items (
player_id int(10) NOT NULL,
item_unique_id int(10) NOT NULL,
item_id int(10) NOT NULL,
expire_time int(20) DEFAULT NULL,
color int(11) DEFAULT NULL,
color_expires int(11) NOT NULL DEFAULT '0',
owner_use_count int(10) NOT NULL DEFAULT '0',
visitor_use_count int(10) NOT NULL DEFAULT '0',
x float NOT NULL DEFAULT '0',
y float NOT NULL DEFAULT '0',
z float NOT NULL DEFAULT '0',
h smallint(3) DEFAULT NULL,
area enum('NONE','INTERIOR','EXTERIOR','ALL','DECOR') NOT NULL DEFAULT 'NONE',
floor tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (player_id,item_unique_id,item_id),
CONSTRAINT player_regitems_ibfk_1 FOREIGN KEY (player_id) REFERENCES players (`
[Msg] Finished - Unsuccessfully

error minion

Hello
I have this error
I do not understand
​​​​​​​Aion EU EmulatorVersion: 5.8

https://www.noelshack.com/2018-07-2-1518543369-error-minions.png

Thank you for you precious help

Does the resource below AL-Game\data\static_data\service_bonusattr seem to be working properly?

I added an F2P account to my MYSQL database. I can see the F2P account prompt when I log into the game, but there is no BUFF bonus in f2p_bonusattr. Similarly, the bonuses such as LegionBonusBuff, PartyBonusBuff, and VIP_Base_CN Buff in service_bonusattr have no effect. Where did I set it incorrectly? I have tried to solve the problem myself, but I failed and asked for help.

"Adma Stronghold Treasure Chest" item problem

If i added this item to inventory and try to open: "Adma Stronghold Treasure Chest" = player disconnected.
Character is unplayable if You try to relogin with this char.
I checked what item exactly does the problem:

item_template id="182007394" name="Damaged Necklace"

Probably slot is missing in "item_templates" file.

2018-06-17 12:09:29,290 Dispatcher error! java.lang.IllegalArgumentException: Invalid provided slotIdMask 0
java.lang.IllegalArgumentException: Invalid provided slotIdMask 0
at com.aionemu.gameserver.model.items.ItemSlot.getSlotFor(ItemSlot.java:149) ~[AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.iteminfo.ArmorInfoBlobEntry.writeThisBlob(ArmorInfoBlobEntry.java:41) ~[AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.iteminfo.ItemBlobEntry.writeMe(ItemBlobEntry.java:53) ~[AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.iteminfo.ItemInfoBlob.writeMe(ItemInfoBlob.java:53) ~[AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.serverpackets.SM_INVENTORY_INFO.writeItemInfo(SM_INVENTORY_INFO.java:73) ~[AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.serverpackets.SM_INVENTORY_INFO.writeImpl(SM_INVENTORY_INFO.java:61) ~[AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.AionServerPacket.write(AionServerPacket.java:144) ~[AL-Game.jar:na]
at com.aionemu.gameserver.network.aion.AionConnection.writeData(AionConnection.java:321) ~[AL-Game.jar:na]

Request, request, request

@Falke3434
你好！欧比斯 托斯卡努 和 玛高斯 据点的 上面有一个很漂亮的 保护膜 ，请问 这个 保护膜 在什么地方做调整和修改，感谢！@全体技术人员!
Hello there! There is a very beautiful protective film on the top of Obis Toscanu and Margoth. I would like to ask where the protective film is to be adjusted and modified. Thanks! @ All technicians!

Mini-game question

Is it possible to go into mini-games on the GF client?:
Lucky Dice
Daishun's random box (Luna)

Or these functions are not implemented here?