aszrool

Make your (offline) RO server in more than 5 hours - pun intended
Hercules Link
This Guide is intended for
- Windows users
windows sux, but 90% of the community still using windows, so I am targeting the majority of the members here
- You want to contribute something back to the community
if you just want to have fun by yourself, of course it's fine to use that 5 minute instant noodle guide
BUT if you want to contribute to the community, you have to use LATEST server and software available
... which makes this guide outdated very fast
 
Prelude: Determine your Windows Operating System type
a. Windows Key -> Right Click on My Computer -> Select Properties
https://github.com/AnnieRuru/customs/blob/master/server setup/prelude-1.png

b. Determine your Operating System type
I'm using Windows 7 Ultimate 64-bit system
https://github.com/AnnieRuru/customs/blob/master/server setup/prelude-2.png
 
Step 1: Download and Install TortoiseGit

1a. Download TortoiseGit
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 1a.png
 
1b. Installation
next... next... next.. next... next.. next.. Install !!!
 
1c. Create 2 new folders
1 for Hercules, 1 for rAthena
Right-click -> TortoiseGit -> Clone
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 1c.png
 
1d. Download git 2.20.1
you'll get this warning message
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 1d.png
Open Git for Windows Website, Download it
next... next... next.. next... next.. next.. Install !!!
 
1e. Reposition git.exe
This time go to TortoiseGit -> Settings
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 1e.png
General tab -> Git.exe path
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 1e2.png
C:\Program Files\Git\bin  
1f. Download Hercules and rAthena
Right Click on the folder, TortoiseGit -> Clone
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 1f.png
https://github.com/HerculesWS/Hercules https://github.com/rathena/rathena  
Problems might encounter during Step 1c,
when it ask for a git.exe, you have to go to that git for windows site, and download that thing
Problems might encounter during Step 1e,
sometimes even though you have already install git2.20.1.exe, but it still couldn't find the git.exe file
to solve it, Right-click -> TortoiseGit -> Settings, you get a warning, Click Ignore, then follow Step 1e
 
Step 2: Download and Install Microsoft Visual Studio 2017
Step 2a. Download Microsoft Visual Studio
https://visualstudio.microsoft.com/downloads/
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 2a.png
 
Step 2b. Downloading ...
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 2b.png
 
Step 2c. Click Install Visual Studio Community 2017
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 2c.png
 
Step 2d. Load Hercules Project
Double click Hercules-15.sln
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 2d.png
it says missing Windows 10 SDK 10.0.15063 ...
 
Step 2e. Install individual component
you can either let Visual Studio do its magic, or ...
manually go to visual studio downloader ... click modify
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 2e.png
then select the component to install manually
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 2e2.png
 
Step 2f. Load rAthena Project
Do the same thing by double clicking rAthena.sln,
but this time rAthena project needs Windows 8.1 SDK and Windows Universal CRT SDK
 
Both emulator has been compiled
 
Problems might encounter during Step 2c
if using Windows 7/8, after the download is complete, it install a windows update that might crash all the programs in your operating system
this Parasite MUST be remove !!
To do this, go to Control Panel -> Program and Features
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 2g.png
Click View Install Update tab
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 2g1.png
then find KB2882822 and remove this parasite from your computer immediately before restarting your computer
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 2g2.png
IF you are the unlucky soul and you can't start any .exe file .... there's still a fix
Restart the computer in Safe Mode ...
many answer around the Internet tells you to press F8 when Windows Logo shows up, but this doesn't work for me, I have USB keyboard
so I found another method ... run System Configuration
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 2h.png
Select the [Boot] tab, then select Safe Mode.
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 2h2.png
this will make your windows always restart in safe mode until you turn it off
then follow the above process, uninstall that windows update, deselect safe mode, restart computer again, now it should be back to normal
 
Problems might encounter during Step 2f
During compiling, if you see this in your Visual Studio
fatal error C1083: Cannot open include file: 'corecrt.h': No such file or directory this means you are missing a component Windows Universal CRT SDK
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 2f.png
 
Step 3: Download and Install MySQL 8.0
Step 3a: Download MySQL 8.0
https://dev.mysql.com/downloads/mysql/
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 3a.png
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 3a2.png
actually, you can just click this -> https://dev.mysql.com/downloads/file/?id=480824
I have 64-bit operating system, but this 32-bit installer works fine for me
 
Step 3b. Install MySQL 8.0
Select Custom
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 3b1.png
We only need 2 products, MySQL 8.0 and MySQL Workbench
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 3b2.png
Ready to Install
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 3b3.png
next... next.. Execute !! next.. next.. next..
Account and Roles, type "1234" as password
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 3b4.png
click [Check]... next... next.. next... DONE !!
 
Step 3c. Run MySQL Workbench
Welcome to MySQL Workbench
Double click the icon -> Click Connect
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 3c.png
 
Step 3d. Create a Schema
Right click at the left side of the window
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 3d.png
and create a Database call Hercules. Remember change charset/collation to utf8
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 3d2.png
 
Step 3e. Install SQL Script for Hercules
Set Hercules as default Schema
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 3e.png
load hercules/sql-files/main.sql file
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 3e2.png
copy into Query field, then Press Execute button
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 3e3.png
repeat the same process again for log.sql file
 
Step 3f. Install SQL Script for rAthena
Set rAthena as default Schema
install rAthena/sql-files/main.sql and the log.sql
 
Problems might encounter during Step 3e.
If you got a warning message that `ipbanlist` table creation failed, this has been reported -> hercules & rAthena
that's why now we can only use utf8 charset
 
Step 4: Connect MySQL to Hercules and rAthena
Step 4a. Connect Hercules to MySQL
Copy paste the import-tmpl folder, and rename it into import
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 4a.png
then open each individual files and modify each one of them
conf/import/char_server.conf
char_configuration: { // Server name, use alternative character such as ASCII 160 for spaces. // NOTE: Do not use spaces or any of these characters which are not allowed in // Windows filenames \/:*?"<>| // ... or else guild emblems won't work client-side! server_name: "Hercules" // Information related to inter-server behavior inter: { // Server Communication username and password. userid: "qwer" passwd: "asdf" // Login Server IP // The character server connects to the login server using this IP address. // NOTE: This is useful when you are running behind a firewall or are on // a machine with multiple interfaces. login_ip: "127.0.0.1" // Character Server IP // The IP address which clients will use to connect. // Set this to what your server's public IP address is. char_ip: "127.0.0.1" } pincode: { enabled: false } } conf/import/map-server.conf
map_configuration: { // Information related to inter-server behavior inter: { // Interserver communication passwords, set in the login server database userid: "qwer" passwd: "asdf" // Map Server IP // The IP address which clients will use to connect. // Set this to what your server's public IP address is. map_ip: "127.0.0.1" // Character Server IP // The map server connects to the character server using this IP address. // NOTE: This is useful when you are running behind a firewall or are on // a machine with multiple interfaces. char_ip: "127.0.0.1" } } conf/global/sql_connections.conf
sql_connection: { // [INTER] You can specify the codepage to use in your mySQL tables here. // (Note that this feature requires MySQL 4.1+) //default_codepage: "" // [LOGIN] Is `userid` in account_db case sensitive? //case_sensitive: false // For IPs, ideally under linux, you want to use localhost instead of 127.0.0.1. // Under windows, you want to use 127.0.0.1. If you see a message like // "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" // and you have localhost, switch it to 127.0.0.1 db_hostname: "127.0.0.1" db_port: 3306 db_username: "root" db_password: "1234" db_database: "hercules" //codepage:"" }  
Step 4b. Change s1/p1 inter server connection password
since hercules server hates you for using s1/p1, I change it into qwer/asdf then
Here's how to do it ... Open MySQL Workbench, double click your current running MySQL connection
Type "SELECT * FROM `login`;" , edit the field s1/p1, then click [Apply]
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 4b2.png
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 4b3.png
 
Step 4c. connect rAthena to MySQL
Copy paste the import-tmpl folder, and rename it into import
then open each individual files and modify each one of them
conf/import/char-conf.txt
// Server name, use alternative character such as ASCII 160 for spaces. // NOTE: Do not use spaces or any of these characters which are not allowed in // Windows filenames \/:*?"<>| // ... or else guild emblems won't work client-side! server_name: rAthena // Login Server IP // The character server connects to the login server using this IP address. // NOTE: This is useful when you are running behind a firewall or are on // a machine with multiple interfaces. login_ip: 127.0.0.1 // The character server listens on the interface with this IP address. // NOTE: This allows you to run multiple servers on multiple interfaces // while using the same ports for each server. bind_ip: 127.0.0.1 // Character Server IP // The IP address which clients will use to connect. // Set this to what your server's public IP address is. char_ip: 127.0.0.1 // NOTE: Requires client 2011-03-09aragexeRE or newer. // A window is opened before you can select your character and you will have to enter a pincode by using only your mouse. // Default: yes pincode_enabled: no conf/import/inter-conf.txt
// MySQL Login server login_server_ip: 127.0.0.1 login_server_port: 3306 login_server_id: root login_server_pw: 1234 login_server_db: rathena login_codepage: login_case_sensitive: no ipban_db_ip: 127.0.0.1 ipban_db_port: 3306 ipban_db_id: root ipban_db_pw: 1234 ipban_db_db: rathena ipban_codepage: // MySQL Character server char_server_ip: 127.0.0.1 char_server_port: 3306 char_server_id: root char_server_pw: 1234 char_server_db: rathena // MySQL Map Server map_server_ip: 127.0.0.1 map_server_port: 3306 map_server_id: root map_server_pw: 1234 map_server_db: rathena // MySQL Log Database log_db_ip: 127.0.0.1 log_db_port: 3306 log_db_id: root log_db_pw: 1234 log_db_db: rathena log_codepage: log_login_db: loginlog conf/import/login_conf.txt
// The login server listens on the interface with this IP address. // NOTE: This allows you to run multiple servers on multiple interfaces // while using the same ports for each server. bind_ip: 127.0.0.1 conf/import/map_conf.txt
// Character Server IP // The map server connects to the character server using this IP address. // NOTE: This is useful when you are running behind a firewall or are on // a machine with multiple interfaces. char_ip: 127.0.0.1 // The map server listens on the interface with this IP address. // NOTE: This allows you to run multiple servers on multiple interfaces // while using the same ports for each server. bind_ip: 127.0.0.1 // Map Server IP // The IP address which clients will use to connect. // Set this to what your server's public IP address is. map_ip: 127.0.0.1  
Note: you can do the same for rAthena, change s1/p1 into qwer/asdf. rAthena doesn't *BEEP* when you use s1/p1 though
simply add this line in both conf/import/char-conf.txt and conf/import/map_conf.txt then change it in MySQL Workbench
// Server Communication username and password. userid: s1 passwd: p1  
Read Also: What is Import folder, just scroll down to the bottom and read it
 
 
Before going into next step, I want to stress enough and make sure you can get your server to connect to MySQL
so try running run-server.bat to connect your hercules --OR-- rathena server to MySQL
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 4.5.png
if you can't do it right, Open a New Topic in General Server Support
 
 
problem might encounter during this step
[SQL]: Client does not support authentication protocol requested by server; consider upgrading MySQL client This happens if you have previous version of MySQL installed on your computer, and upgrade into MySQL 8.0
to fix this issue, run MySQL command line Client from start menu
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 4.5a.png
then run these 2 commands seperately
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '1234'; FLUSH PRIVILEGES; https://github.com/AnnieRuru/customs/blob/master/server setup/Step 4.5b.png
 
5. Download latest KRO Client and client translation files
Step 5a. Download latest KRO from
http://herc.ws/board/topic/15592-collection-official-full-clients-latest-kro/
https://rathena.org/board/topic/106413-kro-full-client-2018-08-13-includes-bgm-rsu/ <-- I pick this
 
// ========== THIS PART IS CONTROVERSIAL ===== BUT IT WORKS FOR ME ========
Step 5b. Create another 2 folders
let's name it Asheraf and zackdreaver ... the author of making client translation
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 5b.png
then download their translation files by git clone them
https://github.com/Asheraf/Translation https://github.com/zackdreaver/ROenglishRE  
Step 5c. Download GRF Editor
http://www.mediafire.com/file/aflylbhblrzpz0h/GRF+Editor+v1.8.2.7.zip <-- author forgot to update in that topic, mediafire link is latest one
 
Step 5d. Compile GRF Editor
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 5d.png
double click GRFEditor.sln
 
Step 5e. Open GRF Editor file
Navigate to the directory  \GRF Editor Sources v1.8.2.7\GRF Editor\GRFEditor\bin\Release and open GRF Editor.exe
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 5e.png
I also wondering why the author makes the execution files hide so deep inside
 
Step 5f. Drag the data folder from Asheraf client translation to new.grf
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 5f.png
then save it as Asheraf.grf
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 5f2.png
 
Step 5g. Repeat the process for zackdreaver translation
Close Grf. New -> Grf, Drag the data folder from zackdreaver/Ragnarok/data to new.grf, then save it as zackdreaver.grf
 
Now you have learn how to pack your own grf. You should have 2 new grf in client folder
 
Step 5h. open data.ini in your ragnarok client and edit DATA.INI
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 5h.png
[Data] 1=Asheraf.grf 2=zackdreaver.grf 3=rdata.grf 4=data.grf  
Step 5i. Replace Asheraf/system folder into client/system folder
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 5i.png
 
// ========== CONTROVERSIAL PART ENDS HERE ===== I'm sure many client experts having your doubts why I do like this ========
 
A lot of problems can appear in this step, these problems also recent and changes with every client
 
6. Create your own patch client
Step 6a. Download latest nemo
create another folder name nemo
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 6a.png
then git clone from this site
https://gitlab.com/4144/Nemo  
Step 6b. Find a suitable client patches
http://nemo.herc.ws/downloads/
Since I download KRO 20180813, I chose 2018-06-20eRagexeRe
 
Step 6c. Open nemo.exe
Click Browse to select your downloaded client patch, then select Load Client
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 6c.png
 
Step 6d. Use Recommend Settings
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 6d.png
1. forget the "Always call SelectKoreaClientInfo" error
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 6d1.png
2. DATA.INI
3. system/itemInfo_Sak.lub <--- note: the Capital letter of Info_Sak ... nemo doesn't auto-detect capital letters
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 6d3.png
4. Always Load Korea ExternalSetting lua files
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 6d4.png
5. Read Data Folder first
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 6d5.png
6. Apply Selected
Step 6e. Copy 2018-06-20eRagexeRE_patched.exe to the KRO client folder
 
 
By this step, you should be able to load your own hexed client without throwing any error
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 6.5.png
if you having problem in this Step 5 & 6, Open a New Topic in Client Support
 
FINAL STEP - change PACKEVER
#define PACKETVER 20180620  
Hercules -> src\common\mmo.h
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 7a.png
 
rAthena ->
src\config\packets.hpp <--- original directory, don't edit here
src\custom\defines_pre.hpp
https://github.com/AnnieRuru/customs/blob/master/server setup/Step 7b.png
 
Then Compile for a Final time
 
 
After thought, there are still some minor annoyance and adjustment
client/data/msgstringtable.txt (unpack it or just put at client/data/ folder)
line 3262 Smooth# line 3458 There was an error when loading the data account settings. (Please restart to retry.)# change them into just a #
 
Frequently Asked Question:
Change Renewal into Pre-Renewal
Hercules -> src/config/renewal.h
rAthena -> src/config/renewal.hpp
 
This guide will be feature and pin only for a few months ... while it last .... I guess

https://github.com/HerculesWS/Hercules/pull/2061
before understanding this pull request, let's talk about the history of OnNPCKillEvent
History
during the time OnNPCKillEvent implement, monster only spawn on the fields and dungeon, in this syntax
** Create a permanent monster spawn: <map name>,<x>,<y>,<xs>,<ys>%TAB%monster%TAB%<monster name>%TAB%<mob id>,<amount>,<delay1>,<delay2> and the monsters that spawned with event labels were only use in job changer quests
*monster("<map name>", <x>, <y>, "<name to show>", <mob id>, <amount>{, "<event label>";} Note: if you noticed some parameter missing, yup those were added later.
Notice the permanent monster spawn during that time still doesn't support event labels
So, in order to trigger the permanent monster spawn, OnNPCKillEvent was the only way (during that time)
this was to separate the trigger between OnNPCKillEvent and monster with event labels
Why separate them ?
there's a good reason to separate them, aleos also said in this issue
in fact, this bug was also brought up several times during eathena ...
Let's give 2 examples:
Example 1: Bot-killer script
Bot-killer script is intended to kill bots, and bots usually only appear on fields/dungeon
which makes OnNPCKillEvent: label an ideal solution to work on them
currently, Bot-Killer script doesn't trigger with job changer script or event script
because the job changer npc, the monster was spawned with event labels
example like priest job change quest -> you have to kill all the undeads within 5 minutes
imagine ... IF the Bot-Killer script was able to trigger monster with event labels,
while the players was rushing against time, suddenly a bot-killer script pops up !!
this is enough to make them fail the test ...
same thing goes to other event scripts such as devil square
when players were busy killing monsters, trying to get the most kills, suddenly a bot-killer script pops up !!
enough to make them lose the 1st place
Example 2: MVP ranking script + MVP Ladder game
MVP ranking script ... show the top 10 MVP hunters in your server
MVP ladder game ... a game to form a party then kill MVPs inside arena
currently, the MVP ranking script doesn't record the MVP kills from MVP ladder game
the reason is ... the MVP ladder game spawn the MVPs with event labels ...
imagine IF the OnNPCKillEvent label able to trigger monster with event label
players just has to replay the MVP ladder game again and again to earn themselves the best MVP hunter ...
each game adds 39 kills, so cheap !! Don't need to find MVPs on the field anymore
now that's defeat the purpose of MVP hunting .... I mean the MVP ranking script
So why propose the change now ?
Things has changed since then, especially with the introduction of instance script
since all instance monster has event labels, previously said that monster only spawn on the fields and dungeon no longer apply
Take a look back at Example 2 ... the MVP ranking script
currently the MVP ranking only record the MVP kills that spawn MVP tombs
but it doesn't record the kills from instance ... for example Nacht Sieger or Nidhoggur's Shadow or even Lighthalzen MVP
Now here's the tricky part ...
Example 1: Bot-Killer
If we keep it as it is, the script works fine
and if let OnNPCKillEvent run event labels, bot-killer can trigger inside job change npc (BUG)
Example 2: MVP ranking script + MVP Ladder game
If we keep it as it is, the MVP ranking script doesn't record the MVP kills from instance script (BUG)
and if allow OnNPCKillEvent run event labels, MVP ranker script record the kills from MVP ladder game (BUG)
both options are not a perfect solution
but there is a way to actually solve all these problem,
find this line
OnNPCKillEvent: replace with ...
OnNPCKillEvent: if ( getmapflag( strcharinfo(PC_MAP), mf_nosave ) ) end; let ALL OnNPCKillEvent: doesn't trigger on the map that has nosave mapflag
simple because, all job changer npc and event maps has nosave mapflag ... this is easy
this simple solution actually solve both example's problem above
.... well actually I also has another patch ready ...
but not sure if this setting make things more complicated ?
well ... currently still in the discussion stage ~

View File 2017-06-14bRagexeRE Client
Release for the 2017-06-14bRagexeRE client.
Be sure to have your DATA.INI set to read rdata.grf first and data.grf second.
Packets are provided in the included text file. Packet shuffles and keys can be found at the bottom in the file.
Submitter Rytech Submitted 07/21/17 Category Client Resources  

Yeah dont host this on github, it will be DMCA'd so hard since the clients are copyrighted.
Best bet is to do a torrent or build a nodejs script that can download any client from the patch server, unpack it on-demand, and serve it to the user. Or split up the clients into chunks so theyre no longer a whole file and serve them thru a downloader and have them combine at the end stage.

File Name: Starter map (iz_int) *both versions*
File Submitter: Ridley
File Submitted: 04 May 2016
File Category: Maps & Textures

Old iz_int

 
new iz_int (used by kro and hercules)
 

 
 
Download here

Greetings all,
 
Today, I am introducing a project I've been envisioning and working on for a couple of months that is finally in a usable and sharing state where multiple people could potentially contribute to the project.
 
Introducing HAT!
 
What is HAT?!
HAT, or Hercules Admin Tool, is an administration tool for your RO server running the Hercules emulator. It is coded in PHP and Javascript and uses backends of CodeIgniter and Twitter Bootstrap to present information in a secure and meaningful way. Written by a server owner for a server owner. It is completely Open Source and hosted on Github, released under the Apache license.
 
Another Control Panel? Too many! Stop making these damn things!
Yes, another one. However, this one is different. A lot of Control Panels today are written as a CMS for your users as well as administration for your GM's. HAT is not designed to be accessed by your users, similar to the PHPMyAdmin tool. Your users will never know its there, therefore already enhancing security. However, contrary to PHPMyAdmin, you can more deeply control what your GM's have access to.
 
Oooh, control? I'm a control freak, tell me more!
HAT has a separate database of users for your GM's that have access to your panel. You're not relying on the login table of your server and their group level to provide access. Instead, a separate user database allows access, with a fully customisable set of permission settings on what those GM's can do and not do. 98 different permission sets are possible. So, you can have an in-game support GM with some limited powers in game, and they don't have to have access to your admin panel. Likewise, you can have a developer who only needs access to some server functions and your item/mob DB's without access to your server's accounts.
 
What other features does it have?
HAT gives you the ability to administrate just about everything on your Hercules server or its databases. It's a backend tool designed to be installed to the same server as your running Hercules server, giving you error tracking, server restarting and GM commands through a web interface without needing to login to SSH. With its fully responsive interface, its suitable for access via mobile, tablet or desktop without comprising access to information you need.
 
So far, a somewhat complete list of the features already done:
Account Management including: Changing account name, email, reset passwords/PINs, manage bans, account notes, account flags, manage account storage Character Management including: Change character name, stats, levels, jobs, items, flags Guild Management including: Change guild name, leader Server Management including: Viewing server console logs, start/stop/restart running Hercules server, reload item/mob db's, scripts and battleconf, viewing server performance data Admin Management including: Add/disable/delete GM's, assign/delete/change permission sets (groups)

More features being added almost every week!
 
How can I use it?
Note that the panel is still in constant development and could be unstable. We would appreciate more testers and bug reports regarding the panel. While I try to write and test code that I know will work before pushing it to Github, sometimes I miss something or it doesn't work as expected in another environment. If you're willing to contribute by using and reporting bugs, you can find the panel to download here:
 
https://github.com/jguy1987/HercAdminTool
 
I found a bug! How do I report it to you?!
You can use the Github issue tracker to report bugs: https://github.com/jguy1987/HercAdminTool/issues
 
I want XYZ feature! Can you make it?
Maybe. Use the Gitbhub issue tracker to give me the suggestion and I'll see if I can/want to add it: https://github.com/jguy1987/HercAdminTool/issues
 
You lied! My panel completely destroyed my server!
Take backups. As mentioned above, you're using something that is constantly in development. If you encounter a bug, please report it. If you encounter an issue that leads to the destruction of data, this is a beta product, and I'm sorry, but I cannot and will not be held responsible.
 
What are the system and server requirements for running the HAT?!
 
The following system I run my testing on, let me know if you have similar results with a system with different packages or such:
* Linux, specifically Ubuntu 14.04. Windows or BSD at this moment is completely untested. I plan on hopefully testing this weekend.
* apache2, version 3.4.7
* php5, version 5.5.9
* php5-mcrypt needs to be installed and enabled. You can do such by adding to your php.ini: `extension=mcrypt.so`.
* php5-mysql extension. MySQL can be installed on a different machine if you so desire but you must have the php5 extension installed on the machine
* apache needs to be configured to include the mod_rewrite extension. In addition, your per directory settings for apache configuration must allow "follow symlinks" and "AllowOverride all".
* You can optimize Apache to use a bit less memory so that your Hercules server can expand if you do not anticipate many people using your panel by taking the following steps:
- Install apache2-mpm-prefork.
- Reduce the amount of clients your apache can serve and reduce the amount of servers it starts up in httpd.conf/apache2.conf.
 
So....
Github: https://github.com/jguy1987/HercAdminTool
IRC: irc.rizon.net @ #hercadmintool - if you want to talk to me about it or submit features or poke me to do more work.
Demo available at: http://hatdemo.jemstuff.com
The demo can be access with username/password: admin/admin. You can do most things in the demo so feel free to play around. I know there's not much data there to experiment with, but feel free to play.

Hey all,
 
So I've worked on a difference checker between the fields of some rAthena and Hercules database files.
This could help people or devs or users do quick lookups for differences.
 
Key Features
The differences are listed in libconfig format to make things easier for people trying to merge or lookup entries between rAthena and Hercules.
It lists only the differences if any. (Except ID and Name field for quick lookups).
 
Repository: https://github.com/Smokexyz/Hercules-vs-rAthena
 
Currently supported files -
db/pre-re/mob_db.conf db/pre-re/item_db.conf db/pre-re/skill_db.conf db/re/mob_db.conf db/re/item_db.conf db/re/skill_db.conf  
TODO
Add support for more files. Automate checks and updates to repository.  
If you have any suggestions for files or format do let me know.
If you want to report errors, please feel free to open an issue on the repository page.

kRO had released anew refinery interface for item refinement last year in their 2016-10-* clients.
 
Source: 
 
A preview of my implementation:

 
I already have it working on my local Hercules branch. A big thanks to @Asheraf for providing information from kRO. This will be available for Hercules as and when it support the newer clients.
Just thought I'd share the info here
Hope for its release soon!

Update: June 9 2017
 
New script commands:
add_group_command isstr getarrayindex  
Modified script commands:
readparam specialeffect can_use_command  
Deprecated script commands:
specialeffect2 superseded by specialeffect misceffect superseded by specialeffect pow superseded by the exponentiation operator

=Database
*A few item changes.
-Fixed the Upgraded Huuma Shuriken to increase MATK properly.
-Falcon Flute is now only usable by Hunter type jobs.

*Added the Emergency Magic Gear.
-This item is usable only by Mechanics.
-Mounts the Mechanic to a mado when used.
-Has a reuse delay of 3 minutes.



=NPC
*Updated the thanatos quest to allow Summoner's to enter.



=Jobs
*Mechanic
-Updated the mado code with official March 2017 update changes.
-The follow changes applies to the mados....
-
-The base movement speed of mado's is now the same as Peco's,
-but the movement speed penalty still applies and is reduced with
-the Mado License skill.
-
-Natural HP recovery is increased. Its doubled for now until
-the official info is learned.
-
-Mado's now have a max weight increase of 1500.
-
-The Teleport skill can now be used.
-
-Mado's are now immune to equipment stripping.

Hey all,
I had an idea to implement the ultimate storage system with which users of Hercules would be able to create as many storages as they want without a hassle. And so I worked on Hercules Ultimate Storage System (HUSS). The basic idea of the design has been completed and at this point it is ready to be tested. I wanted to gather suggestions to further extend the system, hence this topic.
To test the system, simply visit my fork of Hercules in the storages branch and clone it.
 
Storage.conf Example Entry
{ Id: (int) (required|unique) Unique Identifier Name: (string) (required) Name of the storage sent to the client. Capacity: (int) (required) Maximum capacity of the storage. }
All storages are handled with dynamic arrays that will save a tonne of memory if and when created.
They are saved in the same storage database (SQL) as the original separating them by a storage identifier.
An infinite number of storages can be created, there are no limits.
The current design implementation only allows saving/loading of approximately 1600 items per storage due to packet size limits.
 
Script Command Changes
*openstorage(<storage_id>{, <storage_mode>}) Default Storage Access Mode: STORAGE_ACCESS_ALL This will open character's Kafra storage window on the client connected to the invoking character. It can be used from any kind of NPC or item script, not just limited to Kafra Staff. The storage window opens regardless of whether there are open NPC dialogs or not, but it is preferred to close the dialog before displaying the storage window, to avoid any disruption when both windows overlap. mes("I will now open your stash for you"); close2(); openstorage(1); end; Storage Modes: STORAGE_ACCESS_VIEW // View storage only STORAGE_ACCESS_GET // Allow getting items from storage. STORAGE_ACCESS_PUT // Allow putting items to storage. STORAGE_ACCESS_ALL // Allow all actions.  
So if you guys have any suggestions or ideas that would better the system for Hercules, feel free to comment below

Download: 1.5
plugin
 
create table maintenance ( id int primary key auto_increment, account_id int, name varchar(23), reason varchar(99), minlv2connect tinyint, order_time datetime, start_time datetime, end_time datetime ) engine = innodb;   .
remember to enable HPMHooking to enable this modification
plugins_list: [ /* Enable HPMHooking when plugins in use rely on Hooking */ "HPMHooking", .
.
Note:
sometimes the server countdown jumps 1 second ahead
this is normal because the timetick from time->add is unstable
so I use unix_time to synchronize the countdown to server time
 
.
.
so, if you found some script/source code having bugs and you need to shut down your server for a short while
then you come to the right place
.
@maintenance <Group ID can stay 1~99> <duration to kick in minute> <maintenance duration in minute> <reason> then a GM99 can commence the maintenance
 
Example : '@maintenance 40 5 10 need to fix announcer script'
 
every player with group ID 40 and below will be kick after 5 minutes
and the server will start counting down by an announcement,
during the maintenance of 10 minutes, group ID 40 and below will deny from login into the server
`maintenance` table will also generate a new line, with the `reason` field as 'need to fix announcer script'
which is useful to know when and how many times you did emergency server shutdown
though, the actual reason for using SQL is to persist the data after server shutdown
so the server will continue being in maintenance mode despite how many times you have shut down the server
until it times up ( `end_time` field ), or manually do `@maintenanceoff`
 
Note:
you can't generate a new line using 'INSERT INTO' Sql syntax when server is online
because I declare a bunch of variables to for them, for the purpose of saving memory consumption
you have to login the game and type `@maintenance` to initiate the maintenance mode, otherwise it wont work.
.
.
.
@maintenanceoff if you have already finished fixing the script/source code, and there's still a lot of time left
you can type '@maintenanceoff' to immediately turn off the maintenance mode so players can login before the schedule.
.
.
.
.
-- Script commands --
.
*maintenance <Group ID can stay 1~99>, <duration to kick in minute>, <maintenance duration in minute> { , <reason> }; .
.
actually I have no idea why I wanna make a script command ... maybe just for fun ?
.
- script jsdfksdj FAKE_NPC,{ OnMon0255: maintenance 40, 5, 60; end; } .
this will make an announcement on Monday, 2:55AM that the server will have a regular server maintenance starts from 3AM to 4AM
during that time, player with group ID 40 will be kicked and blocked from entering the server
the `reason` field in `maintenance` table will be defaulted to '*Regular server maintenance*'
.
maintenance 40, 5, 60, "系统保养";
this will overwrite the `reason` field in `maintenance` table to '系统保养' instead of regular maintenance
.
.
*maintenanceoff { <reason> }; uhh ... useless I think ...
.
.
*maintenancecheck( <type> ); use 'maintenance()' to check the server is currently in maintenance mode or not
return 0 if server is normal
return 1 if server is going to have maintenance
return 2 if server is having maintenance
all other types are meant to myself to debug this junk