Kiel

yes, just patch it
no problem
 

Summoner's Rift in Ragnarok Online
(map created by Tio Akima)

 Hi Guys,
I'm passing to expose my new map (recently completed) to RO!
This is a map inspired by summoner's rift (map of the game of League of Legends).

The design follows the same pattern, but with the poetic freedom (or poetic limitation ?!) available within RO!
I will post some pictures here of the map and a video to be able to see better.
It is!
Att, 
Tio Akima.

ScreenShots:


more:
Green Base:


Red Base:




Video:
 

HERE

As usual, I only write advance guides
This guide is a compilation of SQL commands that I have used, or Questions answered on the forum
every single subject here are related to Hercules/Ragnarok Online in some ways, so you won't feel bored reading them XD
Table of Content
1. When to use *escape_sql script command
2. How to build a case-sensitive table
3. Choose a table type, MyISAM or InnoDB ?
3a. How to index a table properly
3b. Why you shouldn't use `char_reg_num_db` table
4. AUTO_INCREMENT
5. How to do IF-ELSE in SQL query ?
5a. How to update multiple rows on different conditions in a single query
6. How to show the current rank of the player
7. INSERT INTO ... SELECT ...
8. Table JOIN vs AS
9. What is the maximum string limit for *query_sql
9a. UNION
This topic is now open to Suggestions, Ideas, Improvements, and Questions ~
I'm sure many of you have some questions since the creation of this topic
You may also post up your tricks if you want to share with us

Corrected Jobs updated.

That is a nice idea. But you can cut this work to less than a half making the beards lower headgears (or lower costume headgear) like jRO did in this past year.
Just a suggestion, the heads with beard are very welcome.

Here is it, maybe need adaptions (brA now is a herc fork but this file is from 2011, before the fork)
http://http://forum.brathena.org/index.php/topic/2581-suporte-emilyn-the-full-support/
 
 
You'll need to Translate Too hehehehehehe

Program name is ACT Editor e.e
http://herc.ws/board/files/file/170-act-editor/

To modify both spr and act better program is ACT Editor.
Pra fazer sprites vai ter de aprender com tutoriais de pixel art, começa com algo basico do paint antes de ir pra ps e outros programas.

You can use the OnTouch: label. I don't know about movements, but you could use this for when a player touches it.
 
I don't know if this even works, I randomly thought it up. Hopefully somebody more knowledgeable can help you.
 
 
prontera,150,150,3         script        Angeling#prontera        4_F_NPC,{   OnTouch: sc_start SC_INC_AGI,600000,10; // Level 10 Increase Agility for 10 minutes. npctalk "Increase Agility !!","Angeling#prontera"; end; }

Of course there'll be a PC version of it! If it comes to Android, simply download the Android emulator Bluestacks, I use it to play games that are on Android =P @@Kiel

I used MySQL 5.6 + workbench 6.1 prior changed it to MariaDB.
The graphical interface is different but that shouldn't be a problem.
After you installed Workbench you should have a connection named "root", it can be seen in first interface.
You can open it by double clicking it, then you can make "hercules" & "log" schema, and follow the rest of the guide.

Introducing Hercules' Map Zone Database
Hello~! - What?!
1st, it is a merge from item_noequip.txt and skill_nocast_db.txt functionality. 2nd, it is a major improvement on what these features did in both performance and usability. map_zone_db.txt format sample
{     name: "My Zone"     inherit: ( "My Other Zone" )     disabled_skills: {         AL_HEAL: "PLAYER | MONSTER | ELEMENTAL"         AL_TELEPORT: "MONSTER"         MG_FIREBOLT: "NONE"         //MG_NAPALMBEAT: "PLAYER"         //ID11: "PLAYER"     }     disabled_items: {         Assumptio_5_Scroll: false         //Apple: true         //ID501: true     }     mapflags: (         "adjust_skill_damage    MG_FIREBOLT    250",         "adjust_unit_duration    PR_SANCTUARY    50"     )     /* "command:min-group-lv-to-override" e.g. "heal: 70" */     disabled_commands: {         //Example Below makes @heal be used in maps within this zone only by those group lv 70 and above         //heal: 70     }     skill_damage_cap: {         //Exemple Below caps firebolt damage in maps within this zone to a maximum 50 damage,         // (depends on HMAP_ZONE_DAMAGE_CAP_TYPE in src/config/core.h)         // when cast vs players and monsters.         //MG_COLDBOLT: (50,"PLAYER | MONSTER")     } } Notes on the format
In disabled_skills the var following the name (: "PLAYER | MONSTER | HOMUN | MERCENARY | ELEMENTAL | PET | CLONE | MOB_BOSS") is what allows a zone to know what unit types should have this skill disabled. In the sample above, for example, in My Zone, player, monster and elemental unit types are unable to cast heal, while only monsters are unable to cast teleport. this variable may also be used to ignore skills from inheritance, for example if My Other Zone disabled a number of skills, including MG_FIREBOLT, in My Zone all of them will be disabled as well, except for MG_FIREBOLT since it is set as NONE. In disabled_items the var following the name (: true or : false) is what allows a zone to override what it inherited, for example if My Other Zone disables a number of items, including Assumptio_5_Scroll, in My Zone all of them will be disabled as well, except Assumptio_5_Scroll since it is as false. A zone may enforce an unlimited number of mapflags on all its maps, by using this sample all maps under My Zone will have Fire Bolt damage increased by 2.5x and Sanctuary will have its duration halved. A unlimited number of maps may be linked to a specific zone through a mapflag '<map name><tab>mapflag<tab>zone<tab><zone name>' Changes The mf_restrict (restrict) was dropped. item_noequip.txt and skill_nocast_db.txt were dropped, replaced by map_zone_db.txt. setmapflag script command was modified to support the new zones. @mapinfo was modified to support the new zones, also modified the formatting and made it include the amount of vendings. Improvements As opposed to item_noequip.txt and skill_nocast_db.txt, map_zone_db.txt supports an unlimited number of zones. map_zone_db.txt implementation surpasses the ones from item_noequip.txt and skill_nocast_db.txt, making item equipping (pc_useitem/status_calc_pc) and skill using (previously skillnotok, now status_check_skilluse) processing much faster and efficient. @mapinfo performance was improved (was doing chat room dbmap lookups without even checking if player was on the map in question) Special Thanks to Muad_Dib <3. to lighta for discussing the feature with me and helping design the unit-based restrictions on skills to Bahmut and Emistry for ideas on how to format the file. to kyeme for feature ideas. Links~! Commit Commit 2 (update) Map Zone Database File

Just comment out #define tags 
 
Link : https://github.com/HerculesWS/Hercules/blob/master/src/config/renewal.h

Skill Tree DB Redesign
Hello~! - What?!
The file has been completely overwritten, the redesign achieves 2 goals: make it easier for us to update the file and for our users to customise it. skill_db.conf format : sample
Swordsman: { inherit: ( "Novice" ); skills: { SM_SWORD: 10 SM_TWOHAND: { MaxLevel: 10 SM_SWORD: 1 } SM_RECOVERY: 10 SM_BASH: 10 SM_PROVOKE: 10 SM_MAGNUM: { MaxLevel: 10 SM_BASH: 5 } SM_ENDURE: { MaxLevel: 10 SM_PROVOKE: 5 } SM_MOVINGRECOVERY: 1 SM_FATALBLOW: 1 SM_AUTOBERSERK: 1 } } Knight: { inherit: ( "Swordsman" ); skills: { KN_SPEARMASTERY: 10 KN_PIERCE: { MaxLevel: 10 KN_SPEARMASTERY: 1 } KN_BRANDISHSPEAR: { MaxLevel: 10 KN_RIDING: 1 KN_SPEARSTAB: 3 } KN_SPEARSTAB: { MaxLevel: 10 KN_PIERCE: 5 } KN_SPEARBOOMERANG: { MaxLevel: 5 KN_PIERCE: 3 } KN_TWOHANDQUICKEN: { MaxLevel: 10 SM_TWOHAND: 1 } KN_AUTOCOUNTER: { MaxLevel: 5 SM_TWOHAND: 1 } KN_BOWLINGBASH: { MaxLevel: 10 SM_BASH: 10 SM_MAGNUM: 3 SM_TWOHAND: 5 KN_TWOHANDQUICKEN: 10 KN_AUTOCOUNTER: 5 } KN_RIDING: { MaxLevel: 1 SM_ENDURE: 1 } KN_CAVALIERMASTERY: { MaxLevel: 5 KN_RIDING: 1 } KN_CHARGEATK: 1 KN_ONEHAND: { MaxLevel: 1 KN_TWOHANDQUICKEN: 10 } } } Main Design Benefit
Skills and its requirements are now per job instead of per class id, so there are no duplicates -- for example in the previous format if wanted to modify, say, the max level of SM_MAGNUM you'd need to edit its 31 entries, in the new format there are only 2 entries (one in swordsman, other in super novice) Credits
Designed/Proposed by malufett Links~!
Commit skill_db.conf file

There is an existing server installation guide made by Diconfrost VaNz on this topic but this is outdated. So let me give ample time to share my experience on how to install Hercules SVN on your local machine.
 
1. To obtain hercules, refer to Ind's topic
2. Go to conf/char-server.conf and look for the code below : 
// Server Communication username and password.userid: s1passwd: p1  
Set s1 and p1 to anything you want but take note of them as you will use them later on when you move to SQL portion of this installation.
 
In my case, i will use patskie since it is my screen name.
// Server Communication username and password.userid: patskiepasswd: patskie  
3. Set your server name? Find this line also on your conf/char-server.conf. Change it to whatever you want : 
// 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  
4. Remove // on the following code : 
//login_ip: 127.0.0.1  
//char_ip: 127.0.0.1 Note : 127.0.0.1 means localhost, local machine.
 
5. Save and exit
6. Now go to conf/map-server.conf
7. Same to what you have did in conf/char-server.conf :
//--------------------------------------------------------------//                     Configuration Info//--------------------------------------------------------------// Interserver communication passwords, set in account.txt (or equiv.)userid: patskiepasswd: patskie  
8. Remove // on the following code :
//char_ip: 127.0.0.1  
//map_ip: 127.0.0.1  
9. Once you're done. Save and exit.
10. Now go to conf/inter-server.conf
11. Set the following code :
// Global SQL settings// overriden by local settings when the hostname is defined there// (currently only the login-server reads/obeys these settings)sql.db_hostname: 127.0.0.1sql.db_port: 3306sql.db_username: rootsql.db_password: ragnaroksql.db_database: herculessql.codepage:// MySQL Character SQL serverchar_server_ip: 127.0.0.1char_server_port: 3306char_server_id: rootchar_server_pw: ragnarokchar_server_db: hercules// MySQL Map SQL Servermap_server_ip: 127.0.0.1map_server_port: 3306map_server_id: rootmap_server_pw: ragnarokmap_server_db: hercules// MySQL Log SQL Databaselog_db_ip: 127.0.0.1log_db_port: 3306log_db_id: rootlog_db_pw: ragnaroklog_db_db: loglog_codepage:log_login_db: loginlog Note : Use 127.0.0.1 as ip because you will run these server on your local machine. Use root as the database id because by default MySQL workbench uses root as username. And finally ragnarok as database password which is configurable by users. Set map, char an sql database to hercules and set log database to loginlog 
 
12. Once done, Save and exit
13. Now go to src/common/mmo.h and find the following code :
#ifndef PACKETVER #define PACKETVER 20120418#endif Change to : 
#ifndef PACKETVER #define PACKETVER 20100730#endif Note : You can change 20120418 (2012-04-18) to whatever client-date you want. In my case i will use 2010-07-30 client (20100730).
 
14. Save and exit.
15. Now let's go to mysql part.
16. Download MySQL workbench here. Why workbench? More convenient to use.
17. Once you are finished downloading and installing. Download WAMP server here because workbench will not start functioning if you do not have WAMP server
18. Once you are finished downloading and installing wampserver. Run it
19. Open mysql workbench
20. Add user and password into it. Follow this guide. Make sure you set username as root and password as ragnarok because this is the credentials located on your conf/inter-server.conf
21. Create a server instance and connection. Just click New Connection for creating connection and click New Server Instance for creating a new server instance everything there are self explanatory
22. More likely you must have the following : ( Check image below )

23. At the left portion of the application. You can see schemas. Right click on one of them (test schema) and click on create schema
24. Set the name of the schema to hercules because that is the credential we put in our inter-server
25. Create also a schema log 
26. Double click hercules schema
27. Under file located at the bottom of the home button ( upper left to be exact ) click Open SQL Script and locate sql script on sql-files/main.sql, open it and execute ( you can find execute button at the upper portion of the text editor of mysql workbench it looks like a thunder xD )
28. Double click log schema
29. Under file located at the bottom of the home button ( upper left to be exact ) click Open SQL Script and locate sql script on sql-files/logs.sql, open it and execute ( you can find execute button at the upper portion of the text editor of mysql workbench it looks like a thunder xD )
30. Once everything is set double click again hercules schema
31. Execute the following code 
SELECT * FROM login; 32. Change userid, user_pass to the credentials you have put on both char-server and map-server.conf
33. Click apply.
34. Once done, go back to your server files and compile everything using Microsoft Visual Studio 2009 or 2010 or 2012 
 
Note : 
Microsoft Visual Studio 2009 = Hercules-9
Microsoft Visual Studio 2010 = Hercules-10
Microsoft Visual Studio 2012 = Hercules-12
 
35. Open it via C++
36. In my case i am using MVS 2010, Highlight char-server, login-server, map-server, mapcache at the left portion of the application. Right click on it and click Build Selection
37. Check image for successful compilation, Once done exit the application

38. Now you're done! Run run-server.bat on main folder
 
 
I hope this guide help other people who find it difficult to install hercules svn on your local machine. Actually this guide is not hard. I just divided the guide into small chunks so that people will understand more. If you think that any portion of installation is not included in my guide or maybe in some way not good or not correct then feel free to post it.
 
Additional Notes : 
- If you want other people to connect then you must port forward your router, or you can use other application like hamachi
- If any error occur feel free to post it here. Make sure you will post it in a detailed manner. Post screenshot if possible
- I include a diff client for 2010-07-30 since i use it in this guide
2010-07-30-DIFF.rar

if it ever becomes obsolete, let me know, and I can refactor parts of the guide =D
Always want to try to help newcomers 

hi, i  was start write specially for you guide, but later i stop to do that, because here a lot of them, but information not structured. I remember good bible made by Judas. Try to read it and follow step by stem, and i hope, you will create your own server.
 
http://supportmii.com/ro1/JudasBible.pdf

If you're going to try this on Windows and on a local enviroment only (definately not good for a production server), I'd suggest you start off with wamp, its a pack that installs mysql, apache,php and phpmyadmin.
 
With phpMyAdmin you can manage mysql databases slightly easy. At least easier then through the command line if this is your first time playing with them
Once you have phpMyAdmin (Shall you decide go this way), simply create a database (Its one of the first things that pops up on the main page), a user (and give him permissions on your new database), Go into your database, click import and import the sql-files/ files(Main.sql, log.sql mainly). 
 
Thats pretty much it. If you have any questions feel free to drop by!

Obtaining Hercules through Git on Windows
Downloads
Download and Install MSysGit Download the latest TortoiseGit

  Installation
Alright, first go through MSysGit installer and just set it up (its used as a base for TortoiseGit). then once you install MSysGit, launch the installer you just downloaded for TortoiseGit, you'll be prompted by a window similar to the following


The next window is "Choose SSH Client", select "TortoisePLink", hit Next.


The next window is "Custom Setup", do not change anything unless you know what you're doing, hit Next.


We're done with the installation, that was easy, wasn't it?


Obtaining Hercules
Go to the folder where you want Hercules to be placed, right click and select "Git Clone..."


in the URL field, type the following:
https://github.com/HerculesWS/Hercules.git ensure the 'Directory' field is as desired, and hit 'OK'


Now Hercules is being downloaded


Just wait for it to complete the download of your working copy and you'll be good to go.

Updating Hercules
Right-Click the folder where you downloaded your working copy and within the TortoiseGit menu, select "Pull..." as shown below


On the following window just hit 'OK', and your working copy will update.

3rd Class Effects : Update

Hello~! What?!
This is to let you know about a very prominent bug that Hercules just squashed. The prominent bug
As brought up by Beret here, when a character possessing warlock spheres comes into another character's sight, the spheres are not displayed -- unless you were in the character's range when he created them. This bug was not exclusive to warlock spheres' effect: Camouflage Duplelight Oratio Freezing Venom Impress Hallucination Walk Rolling Cutter Banding Crystalize Deep Sleep Cursed Circle Blood Sucker Shadow Form Manhole This bug has now been fixed, as of today the visual effects of all the skills above should be working as they should.
Special Thanks to
Beret, for bringing this issue to light Yommy, for making it possible for me to understand how officials do this Rytech, for the list of statuses that use this came from his 3CeAM Link~u!
Commit

Hercules April 22 Patch
Hello~! - What?!
1st, most of these things were meant to be released separately but as I started to work with them one thing hooked up to another and I ended up deciding to get all out at once No second today! The all-long, all-mighty list
New Map Zone DB Updates Added New "All" Zone, easy way to add modifiers to all maps in the game. Automatically inherited by all existent zones. Added new zone setting disabled_commands, can disable any command in any zone "command-name: min-group-lv" also supports min group level to override, to enable back a command disabled by inheritance just use "command-name: 0" Added new zone setting skill_damage_cap (as requested by the community), can cap any skill damage to any range of unit types, and also a new core config "HMAP_ZONE_DAMAGE_CAP_TYPE" that controls how the cap is applied (before or after modifiers) New target-type support (used by skill_damage_cap and disabled_skills): PET (special thanks to frenzmu06 for bringing it up!), CLONE and MOB_BOSS Added support to ids! item and skill ids may now be employed in all sections of the file in the place of item/skill names Detailed Map Zone DB Update Hercules Channel System Update Added a IRC bridge as requested by the community, allows users outside of the game (but in a irc network e.g. thru mobile/cel app) to communicate with anyone in-game that is within a specific #channel, and vice-versa Detailed Channel System Update Added Beret and Yommy's suggestion on cash shop file format, also added support for item ids Added Ryuuzaki's kafra point support to the new cashshop Updated map-server's save_setting, added new option: 128, to save buyingstore transactions on the fly Revisited bindatcmd feature, dropped level support, added group level support and added a new flag capable of deciding whether calls to that command should be logged in the atcommand log. Performance Improvement Added a in-memory list to store existent shops (saves iterating through all online players) Modified searchstore to use said db above, making its queries faster Improved pc_groups processing, decreased runtime ram usage by a about 1mb. Improved @command log processing through groups, now caching the state (no longer does dbmap lookup). Improved atcommand.conf file processing (was doing a extra lookup instead of using atcommand_exists already-performed lookup result) Improved atcommand's help file processing (no more lookups! string is now cached directly in the atcommandinfo struct of each command) and data management Improved @help's processing: dropped the huge config file lookup and replaced by using the caches. Improved atcommand logging, added option to not log specific commands (so you dont waste log room with stuff such as @iteminfo/@mobinfo/etc) -- atcommand.conf nolog group Sightly improved zone inheritance processing. Speeded up mvp drop processing Speeded up item log processing Speeded up mob item drop processing Misc With map_zone_db's new clone support, flag 0x8000 (no-clone-use) in the skill db was dropped With map_zone_db's new way to block commands, mapflag nogo was dropped. Fixed a number of discrepancies between unsigned and signed variables in many packets. Fixed loading messages for exp_db, attr_fix, statpoint, mob_chat_db, mob_pouch, mob_branch, mob_classchange, mob_boss, mob_poring and item_group_db pets from gms who cant drop items no longer can loot items (prevents exploit where gm kills something, pet loots, then drops and action is not logged nor blocked). Fixed combo bonuses that used getrefine on weapons/cards that affect weapons. Added @searchstore as to offer same availability to gms as @auction/@mail does Improved 2013 client charselect procedure, all thanks to Yommy! Links~!
Commit

Obtaining Hercules
Hercules is available through GitHub, a web-based hosting service for software development projects that use the Git revision control system.
Obtaining Hercules through Git on Windows Obtaining Hercules through Git on Linux Git Troubleshooting

  Support
Looking for assistance on getting Git to work? Post here

Alternatively...
GitHub also provides a SVN Mirror. We won't officially work to support many branches or repository-features in SVN, but it should remain in-sync with the latest stable release, based on master branch in git.
Windows
You need to download TortoiseGit The address is http://github.com/HerculesWS/Hercules  
Linux
Typing the following creates a working copy of hercules at your home directory svn checkout http://github.com/HerculesWS/Hercules ~/Hercules  
 
 

Hercules Download Section
 
Where?!!
[*]Here~

The rules
[*]None exclusive to this download section as of yet, all our forum rules extend to our download section -- e.g. no warez. Probably not for long, our moderators surely will think of some as issues show up.

Why so few categories
[*]Since we're starting from scratch we thought it'd be best if we didn't have a high number of empty categories, we'll be creating new categories as we see necessary, example: if the sprites & palettes section gets crowded (i.e. with different types of sprites) we'll create a new subcategory section for said type, and so on as more files come in.
In short, we'll be expanding as necessity comes.

Upcoming Modifications
[*]JayPee came up with a very interesting idea we'll be implementing soon, making downloads on certain areas (e.g. control panels) be capable of having their download link be their respective repository's latest zip file ( e.g. from a github project ), as to allow users to always download the latest version as opposed to having to rely on the files' author to update their file on our system.
[*]We are not yet sure whether we'll be implementing paid file support, however if we do we already have a few modification ideas from our staff whos got frustrated by similar systems' inability to counter frauds (for example introduction of measures on first-time buyers)