• Content Count

  • Avg. Content Per Day

  • Joined

  • Days Won


Everything posted by anacondaq

  1. moderators have removed the method for supporting me from the top post in this topic, (aff link for some very good virtual private servers provider). But you can find a method if you wish to express your gratitude in Valkyrie NPC or in readme.txt Same as this one (with few limitations) settings you can find in conf/battle/player.conf
  2. 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: 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: 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.
  3. reshacker, restorator.
  4. SQL? item_db.sql? Open Server -> Green Flag -> Click on Green Flag -> Advanced -> Phpmyadmin Login: root Pass: empty field Press Enter After that, you will open an sql connection to your MySQL server where all databases stored. And with UI you can easily import, delete, remove whatever you want with any databases as you wish from phpmyadmin This is not a problem, this is just informative messages about what is going on on the server. You can easily turn them off inside /conf/map_athena or char_athena or login_athena conf files. (separate setting per server) I think there are many videos about how to add custom items. Also, there are many guides on how to add customs. My package just a portable thing which not requires configuration out the box just to make the emulator run, nothing more. For example You must know, that exe (client) is 2018 years old in this package (new one), not ""old one". So you need always for your custom items guides where you will see ItemInfo.lub or iteminfo.lua (it's the same filename but with different extensions).
  5. Yes, you can. Open src/common/mapindex.hpp: //Some definitions for the mayor city maps. #define MAP_PRONTERA "prontera" #define MAP_GEFFEN "geffen" #define MAP_MORROC "morocc" #define MAP_ALBERTA "alberta" #define MAP_PAYON "payon" #define MAP_IZLUDE "izlude" #define MAP_ALDEBARAN "aldebaran" #define MAP_LUTIE "xmas" #define MAP_COMODO "comodo" In the head of the file. Add your own map there Then open atcommand.cpp and add your map.
  6. Hi, yes, I think this client not support soul reaper sprite and skills. Need to use something like end of 2018 exes or even 2019 exes. But rathena does not support it yet.
  7. After a lot of testing, the guide is NOT actual for 2019 MSBuild tools. Because the size of the community build tools is about 4.6GB, while the WHOLE installation of the complete package required for rAthena is just 5.6GB or 6.6GB with IDE. This is not worth it. If you wish to save your internet traffic and disk space, I have for you a piece of bad news... The only way is to use old 2017 build tools and downloading them from somewhere... An alternative method will be cygwin like packages, but they are not compatible with rathena only source code after last changes with epoll changes, yaml crap libs inside include dirs which implemented not properly and not only. All of these things make impossible to use 300mb archive with compiler and cygwin for compiling the emulator (see my another topic in Projects and Concepts). What to do? or install buildtools for VS2017 or install buildtools for VS2015 or install Visual Studio 2013 The size will be less than in latest VS 2019 compile.cmd for VS Buildtools 2019 @Echo OFF Echo "Building solution/project file using batch file" SET PATH=C:\Program Files (x86)\Microsoft Visual Studio\2019\BuildTools\MSBuild\Current\Bin SET SolutionPath=%~dp0\rAthena.sln Echo Start Time - %Time% MSbuild.exe %SolutionPath% /p:PlatformToolset=v142 /m Echo End Time - %Time% Set /p Wait=Build Process Completed... Just copy-paste it to compile.cmd if you're using buildtools 2019, and copy-paste compile.cmd to your rathena folder, and run, it will compile the code without VS Studio Community 2019 IDE
  8. You don't need to download 12.3gb of data, around 3GB or even 1.5GB by using MSBuild Tools Or: About the upgrade: I explained in the post about the update how to do it, and also whole theory several times, sorry I will not explain it another 10 times the same thing which is not changed for years Second: updated kRO is not really what you need, yes you can download it, but only optionally, the pack will work with old kRO client just fine Third: in the last 01 June 2019 update changed only emulator part (and recompiled) so maximum what needs to download up to 300mb instead of 3GB or 12.3GB of data. Download, extract, play (if you played before on 2019 April 27 update)
  9. Install Windows SDK (usually it's installed by default when you install Visual Studio Community 2019 or 2017 and select C++). Then, right click on the solution -> Retarget Solution -> OK -> Clean Solution -> Build Solution. If source code correct - everything will work fine.
  10. In options of OSPanel (modules tab) you can turn off everything except mysql server, you don't really need all of these there.
  11. Do not follow old guides for adding items. If you do not see in the guide ItemInfo.lua - skip the guide. There are historically two versions of clients <= 20120410 which has one file structure and before big changes how items structures information stored inside the game client, and after 20120410 up to now, with small changes inside ItemInfo.lua. Find better a guides with ItemInfo.lua and without idnumrestable or like that
  12. Usually, it is enough to make fonts readable and follow your system settings. Otherwise, use NEMO to increase font size by applying a font-size increased patch which can break your whole client alignment of the elements or even do many worst things.
  13. script_commands.txt --------------------------------------- *addspiritball <count>,<duration>{,<char_id>}; Adds spirit ball to player for 'duration' in milisecond. --------------------------------------- *delspiritball <count>{,<char_id>}; Deletes the spirit ball(s) from player. --------------------------------------- *countspiritball {<char_id>}; Counts the spirit ball that player has. ---------------------------------------
  14. This is very interesting. Because in PRE-RE izlude map is modified (replaced with the old version of izlude afaik, might be wrong) There are 5 different links for the game client, 3 different types of downloading (via each file in folder, or downloading whole folder, or downloading already pre-created archive, or downloading just some parts). From RO offline side there is no problem at all.
  15. please show phpinfo Or you could not show the phpinfo. The reasons can be next: wrong user (webserver works under some user, files under another user, for example because you uploaded though ssh root user files to your host but not from control panel directly). The solution can be: just remove all files (but backup them first again) and try again upload files but via plesk. this is an old file, and not really needed, it's generated once when you open website and store in cache config. So you can try to remove the file, and webserver should create the file again. But do not remove all files, only files with .cache.php also, it can be disabled php fopen() command, or php user is different to your website files.
  16. No, you did not get me at all. There is impossible (almost) to make a "please select your language" without writing a lot of code and writing custom programs for this purpose some kind of patchers or like that. I wrote about the easy solution to your needs. You need to do next: prepare a game client for the English language prepare a game client for your native language or a language what you wish to deliver to players in the separate game folder you must have two different folders of two different game clients with two different languages Now create or SFX archive (self-extracted one with 7z SFX builders or tools like that) or much easier - google for inno setup or inno-setup like alternatives and try all of them. Almost all installer creation tools offer to you (who building the final installer) to add checkboxes where a player on the stage of installing your product can select what version of the client he wanted to pick. English or for example a French one. Because of deduplication of data, and if you will use solid archiving you can save pretty compressed archive which will be around the same as your original English one + files what translated to another language. (this is an option inside installer setup tools) Now a player or any other guy run installer, and he sees: "To continue installation select a.) English; b.) French language" and a player will be forced to pick a version/language what he likes. Optionally you can create a bat script or PowerShell script which will do language switching by replacing or even re-downloading remotely files with correct translation per a language that you want. The main thing that you must understand - there are no simple solutions.
  17. Possible. But on a stage of installer and only with pre-defined correct translation per language. On server-side also possible too, cydh did it long time ago, also in hercules this is built-in feature.
  18. Hi, to understand how to do properly update you need to understand the next simple thing: RO is an emulator + database + game client Emulator connected to a database Emulator responsible for the database Emulator store different game data inside the database (all) Even your players, items, all in the database. Database = used for not losing your data. In other words, if you turn off your pc, and then boot again and will try to log in you will see your items what you had before termination of the PC. So the database is the place where data is stored. What is `upgrade`? It's replacing your old files to a new one taken from the official repository. Repository = it's a place where developers do changes to the emulator day after day, month after month. All changes what they do you can see, a "one logical change" for example adding some feature or a fixing a bug usually called "commit". Commit it's a mix of changes in different files with some comment which describes what is happening here. Commits used for tracking all changes in time. For example today I wrote something, tomorrow it broke, so I can open a git log (list of commits) and see what happen and what lines I did touch which probably broke the emulator. Again: a database is a place where stored data generated by emulator because of players activity in the game, like getting items from mobs, moving, using stylists, etc. The database in my package stored in the OSPanel mysql server. OSPanel = bundle of free software servers packed and prepared for easy usage for end users and everything is portable. Usually, you need manually configured everything, install, bound to your operation system, etc things. OSPanel have inside: web server (required for displaying sites hosted on your local pc), php interpretation it's a thing which read PHP and converts it to dynamic pages, and MySQL server. It's a server that manages databases. Inside the MySQL server, you have 4 databases that I did create. 2 databases for renewal server, 2 databases for pre-renewal server. For pre-re we have rathena_prere_db, rathena_prere_log db, for renewal, we have rathena_renewal_db, rathena_renewal_log or like that, I do not remember. Inside these databases, you can see your data. You can do whatever you want with these databases with for example any graphical editor like PHPMYADMIN or HeidiSQL, or DBeaver, like watch tables in the database, checking columns, editing any data what you wish manually, applying different scripts to make automatic very complex things though SQL language which supports MySQL server. These scripts called "querries". Your emulator sending to mysqlserver "querries" with pre-defined commands what to do, for example find all players online and return me number how many users in game, or for example: find all players who have a knife XX, or delete item XX from database, or whatever you wish to do with a data. At this point, you should realize that for success upgrade you need to save just somehow your game database where is all of your data stored. This is correct, but there are some nuances. For example, rAthena developers time to time for implementing more features or for fixing bugs changing database column/tables structure data types, etc thing. They change it in src code and in sql table. When they do these changes, they release a patch that needs important to the game database which will automatically upgrade the database and all data because of this "patch" to structures of database/columns/ tables to the latest actual one. For example usually inside SQL-files/upgrades these files stored. They have a name format: <data>_<db>.sql As you see developers not frequently touch databases and structures, but still do these changes to keep emulator with many features, etc things. So here is a nuance: If the developer will write some changes and will apply these changes to the emulator codebase. And if you will NOT apply this update to make data structures on database what expect to see emulator = you will see errors in your char/login/map-server depends on the database which is broken, it can provoke data lose (and probably will, because data will not be stored, because MySQL server will read a query and will try to verify can a MySQL server query be executed and data will fill or not fill a column in table in a database or not, if not) you will, for example, will receive an item in the game, but your data will not be saved for example in item database, and when you will re-login (when you log in/ re-login and while you're playing emulator sending data to database to save) you will not find your item. So, in short, the nuance very easy: you must keep emulator, SQL-upgrades equal. In other words, if you wish to upgrade emulator - you need manually check that upgrades (SQL patches) applied to your database too (if there are any released, if not released -not need to apply anything). These SQL patches applied only once to database, and not need to apply them every time. Just once to change the structure of data in the database. What is left? Upgrading emulator. Upgrading emulator is just one command: git pull origin which will download and merge all data with git magic to your repository, and every time when any file inside /src/ folder changed you need to recompile your emulator. About how to upgrade client - nothing really hard too. And then make sure that there are no SQL patches so you can safely use an emulator with your current database. That how upgrade in theory and in practice looks like, I did explain it in the readme and on the video (afaik) A short guide on how to upgrade: - upgrade emulator - make sure that there are no SQL patches for your database since the last update if any - apply these patches with PHPMyAdmin for example - now compile emulator - try to run it if no SQL or any other errors - everything is good.
  19. Update 01 June 2019: updated emulator (several small changes) updated kRO client nothing else changed updated links and added mirrors first topic post updated. This is a very small update. All package files re-uploaded to different cloud storages. Short: kRO client, exe, OSPanel, database, translation project (client files) - still the same. The only emulator upgraded. So if you wish to upgrade your emulator and you're using old 27 April 2019 package, just replace your current emulator files with a new one (use another folder, do not copy-paste anything from one folder to another). Just download 01_emulator and extract it somewhere. Everything else leave untouched and the emulator will work just fine. Hash:
  20. For receiving the help you need the next things to do: Understand what do you want Understand what do you have Understand how to write it properly to clarify for example me (because you're asking me) about your problem If English is not your native language, you can always use any very good translators like, or Add screenshots of the problem Add screenshots and steps what you do and how to reproduce your problem The emulator has a built-in engine which checks for errors and problems inside scripts. If you're trying to load a script with errors in the code you will see these errors in your map-server (red text)
  21. In this package, you can do whatever you want. Yes, you can change NPC's items, descriptions, NPC names, write your own NPCs and many other things. Can you show this news npc code? I do not know why your screen freezes. There are a lot of potential problems (95% of them related to mising files, or viruses, or whatever on your PC side).
  22. /nc or /ns and also gvg flag remove from the map mapflags/gvg.txt