Change the "root" password for more security (or simply leave it)
for Example:
I'm using "HeidiSQL v9.2" to manage my databases
Open HeidiSQL > Tools > User manager > (here you can Add or Modify Users and Passwords) (Included in Repack) if you use Navicat, it probably can't import SQL to DB. but it's your choise
Username: root
Password: *anything you want* i set "GiGatRoon" (make sure to add to all GameServer Config files)
4. Open "HeidiSQL" or your favorite MySQL Manager
Create a new Database "ac47_server_gs" and then select it.
Import AC-Game\sql\ac47_server_gs.sql (in HeidiSQL, Press Ctrl+O)
5. Open "HeidiSQL" again (if closed)
Create a new Database "ac47_server_ls" and then again select it.
Import AC-Login\sql\ac47_server_ls.sql (in HeidiSQL, Press Ctrl+O)
6. Now you should have two new Databases:
ac47_server_gs ac47_server_ls
7. Open your login server db "ac47_server_ls"
Find "gameservers" table and open it
Add id:1 Mask:127.0.0.1 Password:*anything you want* i set "GiGatRoon"
Id .................: can be 1 - 127 (any integer number but it shows Retail Server Name) Mask ...........: IP Address Template of the your GameServer Password ...: password for successful authentication of the game server
You can get full ServerIds from Client (L10N\ENU\data\data.pak)
# ----------------------------
# Chat Server Config's:
# ----------------------------
# CS will listen for connections on specified address
# need to be your external Ip of your Live server
chatserver.network.client.address = localhost:10241
# Address that will be used by CS to listen for GS connections
# Use instead of "localhost" or "127.0.0.1" your LAN IP if you wish access from outside.
# Set up a new MySQL user with your LAN IP and grant access to the both LS and GS databases
chatserver.network.gameserver.address = localhost:9021
# Password to match for successful authentication of the game server
# NOTE: Don't forget to add your password!
chatserver.network.gameserver.password = GiGatRoon
# This class represents database driver class that will be used while connecting to database
database.driver = com.mysql.jdbc.Driver
# This is database url.
# Use instead of "localhost" or "127.0.0.1" your LAN IP if you wish access from outside.
# Set up a new MySQL user with your LAN IP and grant access to the both LS and GS databases
database.url = jdbc:mysql://localhost:3306/ac47_server_ls?useUnicode=true&characterEncoding=UTF-8
# Database user
database.user = root
# Database password
# NOTE: Change this! Root password is not safe!
database.password = GiGatRoon
# This class represents database driver class that will be used while connecting to database
database.driver = com.mysql.jdbc.Driver
# This is database url.
# Use instead of "localhost" or "127.0.0.1" your LAN IP if you wish access from outside.
# Set up a new MySQL user with your LAN IP and grant access to the both LS and GS databases
database.url = jdbc:mysql://127.0.0.1:3306/ac47_server_gs?useUnicode=true&characterEncoding=UTF-8
# Database user
database.user = root
# Database password
# NOTE: Change this! Root password is not safe!
database.password = GiGatRoon
AC-Game\config\network\ipconfig.xml For LAN: 127.0.0.1 WAN(Internet): your External IP Address
# Port that will be used to listen for client connections
gameserver.network.client.port = 7777
# Host that will be used to listen for client connections
# Use instead of "localhost" or "127.0.0.1" your LAN IP if you wish access from outside.
# Set up a new MySQL user with your LAN IP and grant access to the both LS and GS databases
gameserver.network.client.host = *
# Maximum online players on the server
gameserver.network.client.maxplayers = 1000
# Address of login server
# Use instead of "localhost" or "127.0.0.1" your LAN IP if you wish access from outside.
# Set up a new MySQL user with your LAN IP and grant access to the both LS and GS databases
gameserver.network.login.address = localhost:9014
# Id of this game server
gameserver.network.login.gsid = 1
# Password of this game server
gameserver.network.login.password = GiGatRoon
# Address of chat server
# Ip and port of chat server should be accessible from
# 1) game server
# 2) all connected clients
# Use instead of "localhost" or "127.0.0.1" your LAN IP if you wish access from outside.
# Set up a new MySQL user with your LAN IP and grant access to the both LS and GS databases
gameserver.network.chat.address = localhost:9021
# Password of this game server for chat server
gameserver.network.chat.password = GiGatRoon
AC-Game\config\main\gameserver.properties
Spoiler:
# Name of your loginserver database
# MySQL5AbyssRankDAO fix to exclude GM/Staff from Abyss Ranking list
# Default: ac47_server_ls
loginserver.database.name = ac47_server_ls
If you need to make Live Aion Server (Not LAN)
=========================================
Open these ports (Incoming and Outgoing) 3306 (MySQL Database Server) 10241 (Chat Server) 2106 (Login Server) 7777 (GameServer for client connections)
All the above ports based on your configuration
Game Server Configuration is finished. now just use Launcher.bat to start three Servers. it makes you 1-3 minutes to full startup (based on ur PC).
after, Open Aion Client using the following Command Line:
as Auto Create Account is Enabled so you can now login using every Username and Password you want.
Don't forget to put NoIP DLL into "bin32" folder of your Aion installation.
GeoData:
=======
if you want to enable GeoData, first need to get geo.7z from my SVNtrunk\AC-Tools\AC-GEO
then extract it inside AC-Game\data\geo Enable it via Configs:
Re: Aion-Core v4.7.5.x NO LICENSE SYSTEM [GameServer SETUP]
Geodata (heights and meshes)
GeoData is used to determines correct Z-Position by using Collision Detection Formulas .
It's like a tiny Physics Engine which used on modern games.
When two rectangle collides each other, an event has been occurred using a simple mathematics formula, and the programmer makes correct decision based on it for ex. Killing Enemies, Shooting Targets, ...
Formula Credits: @Nepster
Code:
/**
* Check if two rectangles collide
* x_1, y_1, width_1, and height_1 define the boundaries of the first rectangle
* x_2, y_2, width_2, and height_2 define the boundaries of the second rectangle
*/
boolean rectangle_collision(float x_1, float y_1, float width_1, float height_1, float x_2, float y_2, float width_2, float height_2)
{
return !(x_1 > x_2+width_2 || x_1+width_1 < x_2 || y_1 > y_2+height_2 || y_1+height_1 < y_2);
}
Re: Aion-Core v4.7.5.x NO LICENSE SYSTEM [GameServer SETUP]
Alright! I got the server running, updated through the NcSoft client and made sure it was NA. Server works, but my client never actually gets to the character select screen. I wonder if I did something wrong?
Re: Aion-Core v4.7.5.x NO LICENSE SYSTEM [GameServer SETUP]
Hello, I have encountered an error, but could not figure out how to solve it.
Spoiler:
Starting Aion-Core GameServer in DEVELOPMENT mode.
Listening for transport dt_socket at address: 8998
18:11:08.589 INFO [main]: - JavaAgent [Callback Support] is configured.
18:11:08.651 INFO [main]: - Using default implementation for ThreadExecutor
18:11:08.682 INFO [main]: - Initialized Scheduler Signaller of type: class org.q
uartz.core.SchedulerSignalerImpl
18:11:08.682 INFO [main]: - Quartz Scheduler v.2.1.7 created.
18:11:08.682 INFO [main]: - RAMJobStore initialized.
18:11:08.698 INFO [main]: - Scheduler meta-data: Quartz Scheduler (v2.1.7) 'Quar
tzScheduler' with instanceId 'NON_CLUSTERED'
Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
NOT STARTED.
Currently in standby mode.
Number of jobs executed: 0
Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 1 threads.
Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persis
tence. and is not clustered.
========================[ =========================== ]========================
========================[ ==========DATABASE========= ]========================
18:11:09.571 INFO [main]: - Successfully connected to database
18:11:11.662 ERROR[main]: - Java Compiler ERROR: cannot find symbol
symbol : class PlayerLoginRewardDAO
location: package com.aionemu.gameserver.dao
Source: /C:/XXX/AC-Game/./data/scripts/system/databa
se/mysql5/MySQL5PlayerLoginRewardDAO.java
Line: 47
Column: 34
18:11:11.662 ERROR[main]: - Java Compiler ERROR: cannot find symbol
symbol : class LoginReward
location: package com.aionemu.gameserver.model.gameobjects.player
Source: /C:/XXX/AC-Game/./data/scripts/system/databa
se/mysql5/MySQL5PlayerLoginRewardDAO.java
Line: 48
Column: 55
18:11:11.662 ERROR[main]: - Java Compiler ERROR: cannot find symbol
symbol: class PlayerLoginRewardDAO
Source: /C:/XXX/AC-Game/./data/scripts/system/databa
se/mysql5/MySQL5PlayerLoginRewardDAO.java
Line: 54
Column: 49
18:11:11.662 ERROR[main]: - Java Compiler ERROR: cannot find symbol
symbol : class LoginReward
location: class mysql5.MySQL5PlayerLoginRewardDAO
Source: /C:/XXX/AC-Game/./data/scripts/system/databa
se/mysql5/MySQL5PlayerLoginRewardDAO.java
Line: 69
Column: 16
18:11:11.927 ERROR[main]: - Java Compiler ERROR: cannot find symbol
symbol : class WebshopDAO
location: package com.aionemu.gameserver.dao
Source: /C:/XXX/AC-Game/./data/scripts/system/databa
se/mysql5/MySQL5WebshopDAO.java
Line: 35
Column: 34
18:11:11.943 ERROR[main]: - Java Compiler ERROR: cannot find symbol
symbol : class Webshop
location: package com.aionemu.gameserver.model
Source: /C:/XXX/AC-Game/./data/scripts/system/databa
se/mysql5/MySQL5WebshopDAO.java
Line: 37
Column: 36
18:11:11.943 ERROR[main]: - Java Compiler ERROR: cannot find symbol
symbol: class WebshopDAO
Source: /C:/XXX/AC-Game/./data/scripts/system/databa
se/mysql5/MySQL5WebshopDAO.java
Line: 48
Column: 39
18:11:11.943 ERROR[main]: - Java Compiler ERROR: cannot find symbol
symbol : class Webshop
location: class mysql5.MySQL5WebshopDAO
Source: /C:/XXX/AC-Game/./data/scripts/system/databa
se/mysql5/MySQL5WebshopDAO.java
Line: 52
Column: 16
18:11:12.379 ERROR[main]: - Java Compiler ERROR: method does not override or imp
lement a method from a supertype
Source: /C:/XXX/AC-Game/./data/scripts/system/databa
se/mysql5/MySQL5PlayerLoginRewardDAO.java
Line: 63
Column: 9
18:11:12.395 ERROR[main]: - Java Compiler ERROR: cannot find symbol
symbol : class LoginReward
location: class mysql5.MySQL5PlayerLoginRewardDAO
Source: /C:/XXX/AC-Game/./data/scripts/system/databa
se/mysql5/MySQL5PlayerLoginRewardDAO.java
Line: 87
Column: 28
18:11:12.411 ERROR[main]: - Java Compiler ERROR: method does not override or imp
lement a method from a supertype
Source: /C:/XXX/AC-Game/./data/scripts/system/databa
se/mysql5/MySQL5PlayerLoginRewardDAO.java
Line: 68
Column: 9
18:11:12.426 ERROR[main]: - Java Compiler ERROR: method does not override or imp
lement a method from a supertype
Source: /C:/XXX/AC-Game/./data/scripts/system/databa
se/mysql5/MySQL5PlayerLoginRewardDAO.java
Line: 90
Column: 9
18:11:12.442 ERROR[main]: - Java Compiler ERROR: method does not override or imp
lement a method from a supertype
Source: /C:/XXX/AC-Game/./data/scripts/system/databa
se/mysql5/MySQL5PlayerLoginRewardDAO.java
Line: 105
Column: 9
18:11:12.467 ERROR[main]: - Java Compiler ERROR: method does not override or imp
lement a method from a supertype
Source: /C:/XXX/AC-Game/./data/scripts/system/databa
se/mysql5/MySQL5PlayerLoginRewardDAO.java
Line: 123
Column: 9
18:11:12.481 ERROR[main]: - Java Compiler ERROR: method does not override or imp
lement a method from a supertype
Source: /C:/XXX/AC-Game/./data/scripts/system/databa
se/mysql5/MySQL5PlayerLoginRewardDAO.java
Line: 147
Column: 9
18:11:12.597 ERROR[main]: - Java Compiler ERROR: cannot find symbol
symbol : class Webshop
location: class mysql5.MySQL5WebshopDAO
Source: /C:/XXX/AC-Game/./data/scripts/system/databa
se/mysql5/MySQL5WebshopDAO.java
Line: 53
Column: 19
18:11:12.617 ERROR[main]: - Java Compiler ERROR: cannot find symbol
symbol : class Webshop
location: class mysql5.MySQL5WebshopDAO
Source: /C:/XXX/AC-Game/./data/scripts/system/databa
se/mysql5/MySQL5WebshopDAO.java
Line: 53
Column: 49
18:11:12.636 ERROR[main]: - Java Compiler ERROR: cannot find symbol
symbol: class Webshop
Source: /C:/XXX/AC-Game/./data/scripts/system/databa
se/mysql5/MySQL5WebshopDAO.java
Line: 58
Column: 36
18:11:12.653 ERROR[main]: - Java Compiler ERROR: method does not override or imp
lement a method from a supertype
Source: /C:/XXX/AC-Game/./data/scripts/system/databa
se/mysql5/MySQL5WebshopDAO.java
Line: 51
Column: 5
18:11:12.667 ERROR[main]: - Java Compiler ERROR: method does not override or imp
lement a method from a supertype
Source: /C:/XXX/AC-Game/./data/scripts/system/databa
se/mysql5/MySQL5WebshopDAO.java
Line: 67
Column: 5
18:11:12.681 ERROR[main]: - Java Compiler ERROR: method does not override or imp
lement a method from a supertype
Source: /C:/XXX/AC-Game/./data/scripts/system/databa
se/mysql5/MySQL5WebshopDAO.java
Line: 80
Column: 5
18:11:12.707 ERROR[main]: - Critical Error - Thread: main terminated abnormaly:
java.lang.Error: Error while compiling classes
java.lang.Error: Error while compiling classes
at com.aionemu.commons.database.dao.DAOManager.init(DAOManager.java:73)
~[ac-commons-1.3.jar:na]
at com.aionemu.gameserver.GameServer.initUtilityServicesAndConfig(Unknow
n Source) ~[AC-Game.jar:na]
at com.aionemu.gameserver.GameServer.main(Unknown Source) ~[AC-Game.jar:
na]
Caused by: java.lang.RuntimeException: Error while compiling classes
at com.aionemu.commons.scripting.impl.javacompiler.ScriptCompilerImpl.do
Compilation(ScriptCompilerImpl.java:194) ~[ac-commons-1.3.jar:na]
at com.aionemu.commons.scripting.impl.javacompiler.ScriptCompilerImpl.co
mpile(ScriptCompilerImpl.java:163) ~[ac-commons-1.3.jar:na]
at com.aionemu.commons.scripting.impl.ScriptContextImpl.init(ScriptConte
xtImpl.java:141) ~[ac-commons-1.3.jar:na]
at com.aionemu.commons.scripting.scriptmanager.ScriptManager.load(Script
Manager.java:96) ~[ac-commons-1.3.jar:na]
at com.aionemu.commons.database.dao.DAOManager.init(DAOManager.java:70)
~[ac-commons-1.3.jar:na]
... 2 common frames omitted
Re: Aion-Core v4.7.5.x NO LICENSE SYSTEM [GameServer SETUP]
Hello, I have followed the steps exactly but have come up with an error.
this is not my release. Just See your errors list. you can find many Java Classes that missed. So Download My Full Release and never mix it with ur stuffs.
and also, don't star Aion Servers in DEVELOPMENT mode. It's Only for Devs
Re: Aion-Core v4.7.5.x NO LICENSE SYSTEM [GameServer SETUP]
Hello have few problems when playet go out from the world next enter he will be at bind point...
Pls help to make it saving coordiantes at DB?!
GameServer working perfectly. it's all becuz of how you shutdown your GameServer.
if you are ingame, Just type in Chat Window, //sys shutdown
and if you are outside of Game, Just Select GameServer Console Window and type exit
and also, Open AC-Game\config\main\periodicsave.properties and change to:
Spoiler:
# ----------------------------
# Periodic save intervals:
# ----------------------------
# WARNING:
# With 500 player online saving can be up to 10 seconds
# (it depends on hardware, changes in item locations, new acquisitions etc)
# Generally accepted interval is 15-20 minutes.
# Time in seconds for saving player data (player, abyss rank, quests, skills)
# Default: 900 (15 minutes)
gameserver.periodicsave.player.general = 30
# Time in seconds for saving player items and item stones
# Default: 900 (15 minutes)
gameserver.periodicsave.player.items = 30
# Time in seconds for saving legion wh items and item stones
# Default: 1200 (20 minutes)
gameserver.periodicsave.legion.items = 30
# Time in seconds for saving broker
# Default: 1500 (25 minutes)
gameserver.periodicsave.broker = 30
# Time in seconds for saving/updating pet mood data
# Default: 5 (retail is 4-5 seconds)
gameserver.periodicsave.player.pets = 5
2)
When enchanting the stones like +HP/+atack... some times lose few of them from the closes when fail to enchant...
It's Normal (Not a bug) and also NA Retail Like.
When Enchanting or Socketing, we have a Fail Rate. so sometimes, you fail, cuz of your bad luck
Re: Aion-Core v4.7.5.x NO LICENSE SYSTEM [GameServer SETUP]
Thanks for you answer!
I have done all as you tell me but still it is not saving the position of Players.
Also as i know server must save position on left the game, but it is not. Always im at bind poit stone.
and for exmpl. at local pc i even do not have buffs on top of client but loock like they are working not showing.