is the game server working? Must work 3 console window (login, char, and map servers) and all of them must NOT have any "ERROR" messages in the console.
Also, you must see a green flag, and you need to use ONLY files inside the package, do not mix it with your own client (if you have any from any other server)
There are a lot of updates since the 02 March 2017. The current version includes a lot of fixes and a lot of problems solved since the beginning of the last 2 years.
So, let me think about how you can upgrade everything for yourself with minimal efforts and downloads. If I will be in your position I would do next:
First of all, need to realize what do I have, what version of emulator and client (you said you have 2017 one). How to do this? To be clear if you have no experience it's hard if you have experience - it's easy by checking which hash your emulator and which commits you to see in the git log and from what date (you can do it with git log command) all that you need to see just dates. These "dates" need to determine what exactly SQL patches do you need to apply to your current game database for not losing your current gameplay experience
Second, I will copy-paste just for backup purposes ALL files what I have
Then, I will download just two folders from the first post: (01_emulator, and 02_client_side) Why? Because these folders interconnected, emulator configured for client version, client version configured for the emulator. They can't be different, they must be in pairs.
Now, I will extract 01_emulator somewhere (what I just did download). And will run openserver what I had earlier.
After this need to open phpmyadmin from openserver and import missing SQL upgrades from emulator_folder/sql/upgrades but what exactly upgrades apply? This is an interesting question, and the answer can be found in #1 that why we answered this question earlier. As you see here: https://github.com/rathena/rathena/tree/master/sql-files/upgrades these .sql patches have the next name structure: upgrade_DATE_DATABASE.sql Where date = date where this upgrade released and DATABASE where need to apply this upgrade. You have two databases one game database, and one log database. You can find it in your phpmyadmin.
Before touching anything, you need to export with phpmyadmin ALL of your databases (you can do it easily) just to make sure that you will NOT lose your data what you have now in your MySQL server database. How to do that? Select table -> export -> and you will get files called <your_database_name.sql>, do it for main and for logs databases, or for all that you see just for backup purposes.
Now it the hardest thing. Need to apply .sql upgrades patches (which modify your game database what you have right now) since the date when the last upgrade patch released up to the latest patch in STRICT order, one by one.
For example, you said you have 02 March 2017 version of the package. That means next:
1. look here: https://github.com/rathena/rathena/tree/master/sql-files/upgrades
You see next:
That means you have emulator after the march, and probably to make everything perfect I already have an actual database in the package released on March 02 2017 with all patches above by default before the 02 March 2017. That means right now 28 June 2019, and developers created next patches:
upgrade_20170327.sql and up to upgrade_20190309.sql which means I need to apply them 1 by 1, first 20170327, second 20170417.sql, third 20170509, and so on. This is a very quick process with phpmyadmin (you need to select IMPORT) and select a SQL patch and click import, one second - and your database now will be patched and will have a different structure from this patch.
As you see some files have names: "upgrade_20180705_LOGS.sql" that means these patches must be applied TOO but to _log database what you can find in your MySQL server with phpmyadmin. The same logic as with main patches, but all of them applied 1 by 1 too but to log database. Easy is not it?
If you will do it, and will apply all patches (you can apply 1 patch only once, after that your whole database structure will be changed, and you will not be able to apply the same patch twice or even can corrupt database easy) So always keep backups of your database in phpmyadmin (export feature) and do not worry to remove whole database and re-import your database again and repeat everything if you failed.
8. Now, after applying your patches to your database from the folder of emulator what you just downloaded above (01_emulator) you have the same data structure in your game database like emulator expect to see. Now both game-database (in MySQL server) emulator and MySQL will know about the data what is it and how to work with it. That means - emulator will work now just fine, what you just downloaded. Otherwise, if you forgot to apply some of the patches, or did a mistake, you will see SQL errors in your servers.
9. Now the last step, you need to get clean kRO game client somewhere (if you have one good, but I recommend to download full kRO client from the link above)
Just download, install, extract.
10. Now extract files from 02_client_files folder and copy-paste them as you did to your clean kRO folder
11. Try to connect, everything must be smooth and you must see your OLD data on upgraded emulator (which is released precompiled) and client which configured for emulator and vise verse.
12. Open openserver (green flag), emulator, client. And enjoy.
This guide can be used as a guide for upgrading your emulators if you have an old version of the package and wish to upgrade to the latest released version on the website but do not know what to do. Just replace 02 March 2017 to your date what you have on your hand and enable the brain to think and do like I said above in the game (abstract and detailed) and you will not fail.