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

[YodnoX]

if it's not there you can install it yourself

is there a terminal command for that I can't find one. :) I am on stuck on that part .
Help me good sir.

[Devry Kawirian]

is there a terminal command for that I can't find one. :) I am on stuck on that part .
Help me good sir.

lots of tutorials on google, how to instrall iptable in centos xx

https://linuxize.com/post/how-to-ins...s-on-centos-7/

[sasuke]

does not install yum install https://yum.postgresql.org/9.3/redha...3-2.noarch.rpm by mistake how do I solve?

- - - Updated - - -

---

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 :)

how do i solve this?

[Devry Kawirian]

port is not open, setting pg_hba.conf and postgresql.conf and try adding it in iptable -A INPUT -m state --state NEW -m tcp -p tcp --dport 5432 -j ACCEPT don't forget also the postgresql is restarted

[RiyukeOfficial]

port is not open, setting pg_hba.conf and postgresql.conf and try adding it in iptable -A INPUT -m state --state NEW -m tcp -p tcp --dport 5432 -j ACCEPT don't forget also the postgresql is restarted

Thanks this is what i was lacking. now it runs on my Centos8 VPS Server

[KurioCat]

How to use GM Command,who can tell me？

[cekeki]

Please upload again the client
Mega removed the file