Single Player Project - Aion 5.8 (AionGermany)

[Leonhart914]

I am using the database from this server, but i can't equip armor or weapons, this is what console shows

15:59:49.365 ERROR[PacketProcessor:3]: - Can't add skills for player: 326320
16:00:17.874 ERROR[pool-2-thread-28]: - Could not restore SkillList data for player: 326320 from DB: Unknown column 'skill_animation' in 'field list'

can someone help me?

[Robyson]

I am using the database from this server, but i can't equip armor or weapons, this is what console shows

15:59:49.365 ERROR[PacketProcessor:3]: - Can't add skills for player: 326320
16:00:17.874 ERROR[pool-2-thread-28]: - Could not restore SkillList data for player: 326320 from DB: Unknown column 'skill_animation' in 'field list'

can someone help me?

Update your database...
should have some sql with the name skill_animation to update.
This is missing.

[Leonhart914]

how can i update my database?

[Robyson]

how can i update my database?

I use Navicat to update...

Screenshot by Lightshot

[Leonhart914]

this is the code i am using

ALTER TABLE `player_skills` ADD COLUMN skill_animation INT(11) NOT NULL AFTER `skill_level`;ALTER TABLE `player_skills` ADD COLUMN skill_animation_enabled INT(1) NOT NULL AFTER `skill_animation`;

thanks for the help, i use navicat too, but when a execute the query it shows my this error

[SQL]ALTER TABLE `player_skills` ADD COLUMN skill_animation INT(11) NOT NULL AFTER `skill_level`;[Err] 1046 - No database selected

could you tell me how to select the database
thaks again

[Robyson]

this is the code i am using

ALTER TABLE `player_skills` ADD COLUMN skill_animation INT(11) NOT NULL AFTER `skill_level`;ALTER TABLE `player_skills` ADD COLUMN skill_animation_enabled INT(1) NOT NULL AFTER `skill_animation`;

thanks for the help, i use navicat too, but when a execute the query it shows my this error

[SQL]ALTER TABLE `player_skills` ADD COLUMN skill_animation INT(11) NOT NULL AFTER `skill_level`;[Err] 1046 - No database selected

could you tell me how to select the database
thaks again

I did the test, it's okay...

Screenshot by Lightshot

[Leonhart914]

it is normal that the columns are empty?

[Robyson]

it is normal that the columns are empty?

No but it's because there was update...
could have included in a single sql

- - - Updated - - -

No but it's because there was update...
could have included in a single sql

Create a new al_server_gs database and use this, I added skill_animation:

https://mega.nz/#!sdIQgAzR!pzWJuXUvfdOAnInSMhkuJ1StEyYawZlq7TUb6s1DoZ4

[twerkjob]

in the client of your girlfriend you will to create *.bat with a similar command line
start bin32\aion.bin -ip:(IP-adress of your PC with working Aion server) -cc:2 -lang:eng -noweb -noauthgg
Just change the IP-address of your girlfriend in the client to the address of your computer that runs the server.

I'm back with more problems lol. I'm trying to get someone to connect to the server on my LAN. I changed the ipconfig.xml to 192.168.1.111 (my local IP on my LAN) and I created the .bat file as instructed above (changed the -ip to 192.168.1.111 as well), but when I try to connect, the client says it can't connect to the authorization server.

Other than ipconfig.xml in the server files and creating a new .bat launcher file in the other client, is there anything else I need to change or modify first?

Both the server computer and the client computer have windows firewall ports open for Aion (2106, 7777, 10241, 80), plus I even tried enabling DMZ in the router for the server and client computer's local IP addresses and that didn't work either.

On the server computer, I ran my own client and logged into the world and attacked enemies, so I know it works, I just can't get another client on another PC on the same LAN to connect.

[Robyson]

I'm back with more problems lol. I'm trying to get someone to connect to the server on my LAN. I changed the ipconfig.xml to 192.168.1.111 (my local IP on my LAN) and I created the .bat file as instructed above (changed the -ip to 192.168.1.111 as well), but when I try to connect, the client says it can't connect to the authorization server.

Other than ipconfig.xml in the server files and creating a new .bat launcher file in the other client, is there anything else I need to change or modify first?

Both the server computer and the client computer have windows firewall ports open for Aion (2106, 7777, 10241, 80), plus I even tried enabling DMZ in the router for the server and client computer's local IP addresses and that didn't work either.

On the server computer, I ran my own client and logged into the world and attacked enemies, so I know it works, I just can't get another client on another PC on the same LAN to connect.

I never used these files online, but when had problems it was in the file No_IP

- - - Updated - - -

Support here: Aion EU 6.x Emulator

[Leonhart914]

Robson26 one million thanks, i finaly solved whit your help.

[Robyson]

Robson26 one million thanks, i finaly solved whit your help.

[twerkjob]

I never used these files online, but when had problems it was in the file No_IP

Tried this but it didn't work http://forum.ragezone.com/f586/aion-...al-ip-1071278/ I downloaded the .dll and put it into the bin32 directory but it didn't make a difference unfortunately.

[Robyson]

Tried this but it didn't work http://forum.ragezone.com/f586/aion-...al-ip-1071278/ I downloaded the .dll and put it into the bin32 directory but it didn't make a difference unfortunately.

Yes i understand

[BrunoDM]

Yes i understand

Hey Robson... Do you know what is working in this emulator aiongermany?