[CentOS] Ultimate guide to setting up and using your Aura Kingdom Server

[Zortex]

---

Prerequisites:

• CentOS 6.5
• VPS or VMWare/VirtualBox
• Solar-PuTTY or PuTTY
• WinSCP
• Server & Client (I Recommend you use a VPN and Mega Link Downloader to download the client.)
• AKTools

---

Please note: I will be using VMWare Workstation Pro, However, this should work with VirtualBox or a Linux VPS, This tutorial will be for VMWare, But it can still be done using a CentOS VPS or VirtualBox.

Step 1:
Start by installing CentOS 6.5 in VMWare by going to File -> New Virtual Machine
(I used Typical Installation for this, You can use Custom Installation if you want.)
Next, you want to select your CentOS 6.5 ISO File, Then go through and personalize your VM.
(I recommend ~20GB for your VM and Splitting the virtual disk.)After you've set it up, If you chose the start the VM after installation you should shut it off now and then go to Edit virtual machine settings -> Network Adapter Then set it to Bridged.
(While you're at it make sure to change Ram and other things)

NOTE: If you're using a VPS, You shouldn't need to do this step
Step 2:
Start up your virtual machine and login, Now you want to edit ifcfg-*(Usually eth0)

  sudo vi    /etc/sysconfig/network-scripts/ifcfg-eth0 (Or your interface)

The code will look somewhat like

 
DEVICE=eth0 (Your interface) 
HWADDR=00:00:00:00:00:00 
TYPE=Ethernet 
UUID=(long string) 
ONBOOT=no 
NM_CONTROLLED=yes 
BOOTPROTO=dhcp

You just want to change this to

 
DEVICE=eth0 (Or your interface) 
HWADDR=00:00:00:00:00:00 
TYPE=Ethernet UUID=(long string)
ONBOOT=yes 
NM_CONTROLLED=no 
BOOTPROTO=static 
IPADDR=192.168.*.* (Change the first part and the last part, First part    is usually 1, You can set last part to whatever as long as it's not   taken  or above 254*) 
NETMASK=255.255.255.0 
GATEWAY=192.168.*.* (Your router's IP address)

After this is done just do

ifup eth0 (Or your interface)
ifconfig (To confirm that the new IP is set.)

NOTE: If you're using a VPS, You usually have to connect via ssh to do the above, Your VPS Provider should have provided you with the ssh details

Step 3:
Start Solar-PuTTY or PuTTY, I will be using Solar-PuTTY for this tutorial.
Click on Create new session, Then fill out the details.
IP is the one you set in the previous step, If you're using VPS you should have had this provided to you already by your provider.
Next you need to enter your credentials, This is just your username and password for the centos VM or VPS
After you've set this up, Just connect to it.
Next, To install PostgreSQL Use these two commands.

sudo yum install https://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-redhat93-9.3-2.noarch.rpm 
sudo yum install postgresql93-server postgresql93-contrib

Now, Start WinSCP and connect to your server, then navigate to your root directory.
Extract the server files and upload hsxy folder to the root directory, And make sure to chmod it

 sudo chmod 777 /root -R

Now start PostgreSQL & Change the password of "postgres"

service postgresql-9.3 initdb 
service postgresql-9.3 start

sudo -u postgres psql -c "ALTER user postgres WITH password 'INSERTPASSHERE';"

Now, You want to connect to the "postgres" User

sudo su postgres
psql

Create the database's

create database ffaccount encoding 'UTF8' template template0;
create database ffdb1 encoding 'UTF8' template template0;
create database ffmember encoding 'UTF8' template template0;
create database itemmall encoding 'UTF8' template template0;

Import the SQL files

\c ffaccount
\i '/root/hxsy/SQL/FFAccount.sql';
\c ffdb1
\i '/root/hxsy/SQL/FFDB1.sql';
\c ffmember
\i '/root/hxsy/SQL/FFMember.sql';
\c itemmall
\i '/root/hxsy/SQL/Itemmall.sql';

Then disconnect

\q
exit

Step 4:
Goto WinSCP and navigate to /var/lib/pgsql/9.3/data and then open "pg_hba.conf" and edit

.....
# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
host    all             all             0.0.0.0/0            md5
# IPv6 local connections:
host    all             all             ::1/128                 ident
.....

Next, Open "postgresql.conf" and edit

.....
listen_addresses = '*'
.....

Now, Navigate to /etc/sysconfig/iptables, and open "iptables" then edit

.....
-A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT

-A INPUT -m state --state NEW -m tcp -p tcp --dport 6543 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 5567 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 5568 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 10021 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 10022 -j ACCEPT

-A INPUT -j REJECT --reject-with icmp-host-prohibited
.....

Now do

service iptables reload

Step 5:
Open up Navicat or some other PostgreSQL Gui, and then connect to the database.
Next you want to go to ff_member -> tb_user -> Query -> New Query

INSERT INTO tb_user (mid, password, pwd) VALUES ('test', 'test', '098f6bcd4621d373cade4e832627b4f6')

Now go to Goto ff_account -> accounts -> Query -> New Query

INSERT INTO accounts (username, password) VALUES ('test', 'test')

Step 6:
Now you want to go to ff_account -> worlds and then replace the IP with your local IP (Or wan, Depending on if you're hosting locally or publically.)
Next, Go to ff_db1 -> serverstatus and do the same.

Now in WinSCP, navigate to the hxsy folder, open all setup.ini files, find and replace 192.168.198.129 with your server's LAN ip (or wan), Then Find and replace DB Password "xxxxxxxx" with your DB Password

Step 7:
In your client, open connect.ini and change the IP to your server's LAN IP (Or wan)

Now, patch LoginServer, MissionServer, TicketServer, WorldServer and ZoneServer's ELF Files with AKTools

Last of all you just want to do

date +%Y%m%d -s "20160909"

That's it, You now have a fully working Aura Kingdom Private Server, Congratz!

Starting / Stopping the server:

/root/hxsy/start
/root/hxsy/stop

---

GM Commands:

Spoiler:

0,change_weather <number>,0,, 1,take_expbonus,0,, 2,clone_monster <number> <number> <number>,0,, 3,restore,0,, 4,set_rb <number> <number> <number>,0,, 5,ls_rb,0,, 6,rm_rb <number>,0,, 7,status,0,, 8,clone_item <number>,0,, 9,clone_reward_item <number> <number>,0,, 10,clone_items <number> <number>,0,, 11,clone_item_to <number> <number>,0,, 12,clone_quest_item <number> <number> <number> <number>,0,, 13,say <rest_input>,0,, 14,whisper <word> <rest_input>,0,, 15,kill <number>,0,, 17,gain_exp <number>,0,, 18,gain_gold <number> ,0,, 19,goto <number> <number>,0,, 20,users,0,, 21,allusers,0,, 22,transfer <number>,0,, 23,listarea,0,, 24,weak <number>,0,, 25,setra <number> <number>,0,, 26,transport_area <number> <number>,0,, 27,transport_node <number>,0,, 28,drop_item <number> <number>,0,, 29,drop_quest_item <number> <number> <number>,0,, 30,list_durability <number>,0,, 31,date,0,, 32,shop <word> <number> <number>,0,, 33,shop <word> <number>,0,, 34,create_family,0,, 35,effect_life <number> <number> <number> <number> <number>,0,, 36,effect_loc <number> <number> <number> <number> <number>,0,, 37,repairshop,0,, 38,invincible <number>,0,, 39,vanish <number>,0,, 40,town,0,, 41,transport_to_character <word>,0,, 42,get_user_info <word>,0,, 43,get_shortcuts,0,, 44,update_shortcut <number> <number> <number>,0,, 45,save_shortcut,0,, 46,display_sum_node_users <number>,0,, 47,display_sum_world_users <number>,0,, 48,get_spellmaster <number>,0,, 49,debug <number>,0,, 50,list_state,0,, 51,shut_down <number>,0,, 52,kick <word>,0,, 53,slayer <number>,0,, 54,announce <rest_input>,0,, 55,storage <number> <number>,0,, 56,querychar <word>,0,, 57,look <number>,0,, 58,listenchant <word>,0,, 59,version,0,, 60,transport_and_deduct <number> <number>,0,, 61,clone_quest_item_silently <number> <number> <number>,0,, 62,query_npc <number>,0,, 63,party <rest_input>,0,, 64,guild <rest_input>,0,, 65,trade <rest_input>,0,, 66,chat <rest_input>,0,, 67,system <rest_input>,0,, 68,channel_limit <number> <number>,0,, 69,flush_dba_data,0,, 70,banchar <number> <number>,0,, 71,identify_shop,0,, 72,disband_family,0,, 73,select_family_leader <word>,0,, 74,listfms <number>,0,, 75,run <number>,0,, 76,exchange item service,0,, 77,drop_items <number> <number>,0,, 78,allworld_cmd <rest_input> ,0,, 79,query_npc_involve <number>,0,, 80,channel_limit_name <word> <number>,0,, 81,banchar_name <word> <number>,0,, 82,quest <rest_input>,0,, 83,reset_attribute,0,, 84,reset_skill,0,, 85,reset_attribute_gold <number>,0,, 86,reset_skill_gold <number>,0,, 87,get_spell <number>,0,, 88,inlay_shop <number>,0,, 89,broadcast_system_message <number> <number> <number> <rest_input>,0,, 90,echo <rest_input>,0,, 91,clone_monster_locate <number> <number> <number> <number>,0,, 92,clone_monster_around <number> <number> <number> <number>,0,, 93,npc_use_channel <number> <number> <rest_input>,0,, 94,npc_use_spell <number> <number>,0,, 95,self_use_effect <number> <number>,0,, 97,change_class <number>,0,, 98,adjust_spell_anitime <number> <number>,0,, 99,escape,0,, 100,set_level <number>,0,, 101,set_monster_damage <number> <number> <number> <number> <number> <number> <number>,0,, 102,set_monster_movement <number> <number> <number> <number>,0,, 103,show_monster <number>,0,, 104,set_monster_sight <number> <number>,0,, 105,test_character_attack <number> <number>,0,, 106,test_monster_attack <number> <number>,0,, 107,set_level_grow <number> <number> <number> <number> <number> <number> <number> <number> <number>,0,, 108,query_level_grow,0,, 109,query_equipment,0,, 110,set_item <number> <word> <number>,0,, 111,save_monster <number>,0,, 112,get_effect_data <number>,0,, 113,set_effect_data <number> <word> <word> <number> <number> <number> <number> <word> <word> <number> <number> <number> <number>,0,, 114,set_effect_command <number> <word> <rest_input>,0,, 115,get_spell_data <number>,0,, 116,set_reborn_monster <number> <word> <word> <number> <number> <number> <word> <word> <number> <number> <number>,0,, 117,get_all_template_monsters,0,, 118,save_item <number>,0,, 119,monster_goto <number> <number> <number>,0,, 120,around_kill_all <number>,0,, 121,around_kill <number> <number>,0,, 122,query_test_attack_monster,0,, 124,listpms <number>,0,, 125,echobyid <number>,0,, 126,change_hair_color <number>,0,, 127,change_hair <number>,0,, 128,reload_effect,0,, 129,reload_template_monster,0,, 130,summon_pet <number>,0,, 131,gain_skill_point <number>,0,, 132,node <rest_input>,0,, 133,system_area <word> <rest_input>,0,, 134,fatality_damage <number>,0,, 135,restore_all,0,, 136,clear_near_items,0,, 137,get_server_id,0,, 138,test_durability <number> <number> <number>,0,, 139,test_spell_attack <number> <number> <number>,0,, 140,test_drop_treasure <number> <number>,0,, 141,test_pk <number> <number>,0,, 142,surprise_box <number>,0,, 143,setextbornmonster <number> <number>,0,, 144,set_family_level <number>,0,, 145,family_level_up,0,, 146,set_family_emblem <number> <number>,0,, 147,select_family_emblem,0,, 148,open_exploit_rank,0,, 151,setstallspace <number> ,0,, 152,setstallsignboard <number> ,0,, 153,give_exploit <number>,0,, 154,repairallequipment,0,, 155,ping,0,, 156,trace <number> <word>,0,, 157,drill_item <number> <number>,0,, 158,fubag <number>,0,, 159,aw_put_treasure <number> <number>,0,, 161,setfms <number> <number>,0,, 162,clone_quest_treasure <number> <number> <number> <number> <number> <number>,0,, 163,set_bag_time <number> <number>,0,, 164,gain_crystal <number>,0,, 165,gain_family_exp <number>,0,, 166,set_prestige_level <number> <number>,0,, 167,gain_prestige_exp <number> <number>,0,, 168,cast_spell <number> <number>,0,, 169,set_sys_var <word> <number>,0,, 170,add_appellation <number>,0,, 171,set_present_appellation <number>,0,, 172,add_elf <number>,0,, 173,elf_work <number> <number> <number> <number> <number>,0,, 174,remove_elf <number>,0,, 175,elf_skill <number> <number> <number>,0,, 176,set_elf_level <number>,0,, 177,set_elf_mood <number> <number>,0,, 178,use_item_to <word> <number> <number> <number> <rest_input>,0,, 179,set_spell_card <number> <number>,0,, 180,gain_elf_exp <number> <number>,0,, 181,gain_elf_familiar <number> <number>,0,, 182,show_debug_message <number>,0,, 183,set_log_level <word> <number>,0,, 184,set_assert <word> <number>,0,, 185,set_spell_card_attr <number> <number> <number> <number>,0,, 186,set_elf_action <number> <number>,0,, 187,inside <number>,0,, 188,auction_sell <number> <number>,0,, 189,friend_together,0,, 190,reload_itemmall_db,0,, 191,set_node_exp <number> <number>,0,, 192,set_node_gold <number> <number>,0,, 193,set_node_drop <number> <number>,0,, 194,show_hate <number>,0,, 195,clone_item <number> <number>,0,, 196,clone_item <number> <number> <number>,0,, 197,return_item <number> <word>,0,, 198,call_elf <number>,0,, 199,return_gold <number> <number>,0,, 200,battlefield <number>,0,, 201,gain_aa_point <number>,0,, 202,gain_aa_exp <number>,0,, 203,set_aa_rate <number>,0,, 204,reset_aa,0,, 206,around_kill_all_player <number>,0,, 205,clone_npc <number>,0,, 207,captcha_id <number> <number>,0,, 208,captcha_name <word> <number>,0,, 209,change_grow_type <number>,0,, 211,clear_bag_item,0,, 213,set_statue <number> <number> <number> <number>,0,, 214,bf_ch_num <number> <number> <number>,0,, 215,bf_open <number> <number>,0,, 216,gain_love_coin <number>,0,, 217,reset_st,0,, 218,gain_st_point <number>,0,, 219,gain_farm_interaction_point <number> <number>,0,, 220,visit_family_instance <word>,0,, 221,gain_building_exp <number> <number>,0,, 222,remove_enchant <number> <number>,0,, 223,gain_family_treasury <number>,0,, 224,gain_building_durability <number> <number>,0,, 225,achievement_item <number>,0,, 226,create_town <number>,0,, 227,set_territory_open <number> <number>,0,, 228,clone_item <number> <number> <number> <number>,0,, 229,screenmsg <number> <rest_input>,0,, 230,set_blocklogin <number> <number>,0,, 231,set_useblocklogin <number>,0,, 232,visit_player_room_id <number>,0,, 233,visit_player_room <word>,0,, 234,gain_family_leader_point <number>,0,, 235,gain_family_cp <number>,0,, 236,set_territory_status <number> <number>,0,, 237,caplv <number>,0,, 238,gain_forever_gold <number>,0,, 239,gain_destiny_exp <number>,0,, 240,gain_destiny_event <number> <number>,0,, 241,switch_player_room <number>,0,, 242,switch_room_decorating <number> <number>,0,, 243,gain_life_skill_exp <number> <number>,0,, 244,send_reward_item <number> <number> <number> <number> <number>,0,, 246,gain_cs_gold <number>,0,, 247,gain_special_gold <number> <number>,0,, 248,gain_bind_gold <number>,0,, 249,set_cs_mode <number>,0,, 250,set_cs_is_force_open <number>,0,, 251,set_territory_max_num <number>,0,, 252,gain_lifelong_gold <number>,0,, 253,effect_life <number> <number> <number> <number> <number> <number>,0,, 254,effect_map <number> <number> <number>,0,, 255,effect_map_time <number> <number> <number> <number>,,, 256,clone_monster_remote <number> <number> <number> <number> <number> <number>,,, 257,gain_gold <number> <number>,0,, 258,cross_world <number>,0,, 259,refresh_recommend_activities <number>,0,, 260,set_colosseum_open <number> <number> <number> <number>,0,, 800,set_hair_id <number>,0,, 801,set_face_id <number>,0,, 802,set_hair_color <number>,0,, 803,set_skin_color <number>,0,, 804,set_eyes_color <number>,0,, 805,set_helmet_color <number>,0,, 806,set_clothes_color <number>,0,, 807,set_cloak_color <number>,0,, 808,update_closet <number>,0,, 809,set_spell_level <number> <number>,0,, 810,add_class <number>,0,, 811,remove_class <number>,0,, 812,set_class_level <number>,0,, 813,get_license <number>,0,, 814,remove_all_license,0,, 815,set_all_spell_level <number>,0,, 816,set_node_np <number> <number>,0,, 817,remove_family_emblem <number>,0,, 818,set_node_exp <number> <number> <number>,0,, 819,set_node_gold <number> <number> <number>,0,, 820,set_node_drop <number> <number> <number>,0,, 821,set_node_np <number> <number> <number>,0,, 822,inside <number> <number>,0,, 901,get_farm,0,, 902,set_farm_level <number>,0,, 905,get_farm_event <number>,0,, 906,clear_cool_down_time,0,, 907,set_farm_visitable <number>,0,, 908,gain_soul_ability <number> <number>,0,, 909,shop <word> <number> <number> <number>,0,, 910,enter_my_farm,0,, 911,put_treasure <number> <number>,0,, 912,add_lottery_plus <number>,0,, 913,reload_elf_lottery_db,0,, 914,set_farm_interact_time <number>,0,, 915,farm_interact_open <number>,0,, 916,clear_lover_disband,0,, 917,super_clear_bag_item,0,,

---

Known Bugs:

Running is bugged, I myself have no idea why at the moment.

I've heard that fishing is bugged, I've never experienced it but if it's happened for you try using the fixed fishing link below.

---

Fixed Fishing: Link (Haven't tested, Can't confirm it works)
S_ItemMallEnchant.ini Editor: Link
S_Ai.ini Editor: Link
Item.ini Editor: Link
BoundInfo.ini Editor: Link
INI Editor: Link
ItemMall.ini Editor: Link

Please note: This is an expanded version of genz's tutorial, As I had issue's with genz's tutorial I decided to make my own based on his, I created this tutorial while making my own private server to make sure everything worked.

EDIT: If anyone has the original source for the binary files, Please do provide it :)

[MentaL]

[cielthephantom]

i using there server file , it working fine but cant see any monster drop any loot ( armor, weapon ,..etc ) is it normal ?? Fixed
- another question , anyone can guide me how to change exp and drop rate , i searching found that we can use gm command but i dont know map id and i dont know in the guide post in release zone so complex to me for understand ( when i covert the ini using the java tool it make a new ini file but cant search |1|....)
- sorry english not my main

[Zortex]

i using there server file , it working fine but cant see any monster drop any loot ( armor, weapon ,..etc ) is it normal ?? Fixed
- another question , anyone can guide me how to change exp and drop rate , i searching found that we can use gm command but i dont know map id and i dont know in the guide post in release zone so complex to me for understand ( when i covert the ini using the java tool it make a new ini file but cant search |1|....)
- sorry english not my main

[Tutorial]Change Monster EXP rates

[Encik Bob]

do you have latest server file?

[Zortex]

do you have latest server file?

Latest server files I can find are the ones in the thread.

[toujimizuki]

how to open 2other classes?

[Zortex]

how to open 2other classes?

I have no idea if they are fully implemented yet, I imagine you would need to have access to server and client source to fully add them in.

[padilha22]

I have a bug in the first quest, the initial where you have to kill the 3 bosses with the Templar Andre. I kill the first two and André does not open the way for the third boss.

FIX: date 090909092016

[Zortex]

I have a bug in the first quest, the initial where you have to kill the 3 bosses with the Templar Andre. I kill the first two and André does not open the way for the third boss.

FIX: date 090909092016

Yeah, As i said in the guide, you have to use the date command.

[AKzxy789]

Connection to the server failed. (1) how to fix plz!!!

[Zortex]

Connection to the server failed. (1) how to fix plz!!!

This is obviously something that you did wrong, Are you using a VPS or VM

[AKzxy789]

VM
i try weit 400+ and i removed the vmnet 0 bridget.. i try with many servers and clients too

[AKzxy789]

940,2018/10/14 12:55:22,EVAL(1.000731 secs): {Main Loop} 941,2018/10/14 12:55:22,Ticket 0x01000000C0A8F701C0A8F785BF15F491AD2F67458B6B, 1, 0x1F7A8C0, 0x85F7A8C0, 0x15BF Sent 942,2018/10/14 12:55:35,EVAL(13.380391 secs): {Network I/O} 943,2018/10/14 12:55:35,EVAL(13.380437 secs): {Main Loop} 944,2018/10/14 12:55:35,Ticket 0x01000000C0A8F701C0A8F785C01591BD7930C6237B32, 1, 0x1F7A8C0, 0x85F7A8C0, 0x15C0 Sent

- - - Updated - - -

its saying this and stop with Connection to the server failed. (1)

[AKzxy789]

fixed! just patch only the elf files in hsxy..

- - - Updated - - -

But appear a new erro OMG -_-Could not create character profile.

[dsdfgsg12]

can someone tell me if it has as per level above 100 and the items? as on the private server?

- - - Updated - - -

- - - Updated - - -

Help!! http://prntscr.com/lb5gq5