bWolfie

Execute this:
SELECT g.guild_id, g.char_id, c.char_id, c.last_login FROM guild_members g LEFT JOIN `char` c ON c.char_id = g.char_id;
There might be some guild for which char_id is not found in char table.
You would get guild Id where 3rd and 4th column might be NULL, 2nd column is the char id that does not exist in char table (deleted or something?)

Good stuff guys. Keep up reporting issues in an orderly manner.

View File 2018 ICONS FOR FLUXCP 1.0.0
THIS PACK CONTAINS THE HERCULES 2012 PACK AND THE ITEMS THAT FAIL UP TO THE 
DATE OF: 2018-03-25. IN ACCORDANCE WITH KRO.
MORE INFO READ THE .TXT FILE INSIDE THE ZIP.

///////////////////////////////////////////////////////////////////////////////////

ESSE PACK CONTÉM O PACK DE 2012 DO HERCULES E OS ITENS QUE FALTAM ATÉ A 
DATA DE : 2018-03-25. DE ACORDO COM O KRO.
MAIS INFORMAÇÕES LEIA O ARQUIVO .TXT DENTRO DO ZIP.
Submitter wlauton Submitted 07/12/18 Category Web Resources  

Description: Adds the check_resist() script command to your script engine.
With this command, you can retrieve elemental resistances for a character.
check_resist(<type>{, <account id>}) e.g. check_resist(Ele_Water); check_resist(Ele_Wind, getcharid(CHAR_ID_ACCOUNT)); https://github.com/bWolfie/HPM-Plugins/blob/master/src/plugins/check_resist.c

Description: Adds the check_resist() script command to your script engine.
With this command, you can retrieve elemental resistances for a character.
check_resist(<type>{, <account id>}) e.g. check_resist(Ele_Water); check_resist(Ele_Wind, getcharid(CHAR_ID_ACCOUNT)); https://github.com/bWolfie/HPM-Plugins/blob/master/src/plugins/check_resist.c

No offence to the creator Smoke, as he did a great effort putting this all together, but there are outstanding issues which make it not possible to use in a production server.
Being curious, just did some more testing with it, and the guild system (I believe that's what causes it) actually creates this issue where sometimes the sword cursor doesn't appear (need to refresh to get it to show, seems random chance it actually appears), meaning your players would need to have /ns activated all the time to play. 
So please, any future posters - unless you know how to edit the plugin (and therefore source code) itself, don't download it.
And nobody request support as nobody is going to help you.

Yes, the illust folder don't like subfolders
I improved the topic to avoid problems

nice idea remind me of classic final fantasy games

wow looks really cool. somehow it reminds me of lunar base from final fantasy 8 and ratchet gladiator for some reason.

We continue to experiment!
This is my first attempt to send my imagination into space.
Not open, but still distant and mysterious.
.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.
ttmoon

Please rate it  if the map is good enough

I liked the idea of @vykimo, that these maps can turn into a project.
I would say that these were supposed to be a project, but there's still a long way.
While I'm working on expanding the mini world, all information on progress will be here.
.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.
Rune-Midgards
 Youtube Link: https://www.youtube.com/watch?v=u2xDTdNBmOQ

   
New World
 Youtube Link: https://www.youtube.com/watch?v=z819j_6QvwU

   
PvP Arena
 Youtube Link: https://www.youtube.com/watch?v=A928NksS0y4
   
.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.
A few questions, if you know the answers, please help : P
1. In fact, the island of Lasagna is almost ready, and it could have been added to
New World, but since I was stuck in 2012, neither my Brow nor the client
see most of the objects from the last episodes, unfortunately.
Brow 620 is alright, but 586 can't open map file to save
it and fix the problem points on this island : C
2. Also after the 13.2 episode I'm not very good at new cities.
How many of them and in which worlds should they be located?
 

very Very VERY Awesome work especially the New Year's collection ... 
I can't imagine how to celebrate without these cute <3
P.S> but I'm not a fan of wings, sorry =C

Thank you! 

I updated the pastebin. There was an error it was pointing to OnEnd instead of OnStop. Thanks.

I updated the pastebin. There was an error it was pointing to OnEnd instead of OnStop. Thanks.

View File [NPC] Campfire to regenerate HP/SP
Originally:
There is a nice contribution from meko on that subject,
Menhir (Big rock that possesses magical powers and able to restore Health and Energy of Seekers resting/meditating nearby)
Thanks, meko!
But, I thought to myself, well, that is wonderful, but why not make it portable?
The Idea:
An element of role play, a way to add functionality 
to the item 7035 - Matchstick, To light a Campfire.
A Campfire is a portable temporary regeneration NPC.
OW, and it is configurable ;).

Campfire to restore / regenerate HP & SP.
When you sit by the Campfire, you start feeling the warmth and the comfort, thus your HP & SP begin to regenerate.
 
Mechanics : 

A phosphorus tipped stick that can be used to start a fire. (Now Indeed )
When you use the item Matchstick in your inventory, it will spawn a duplicate of the NPC called Campfire.
This will help you when you are in the field, farming, grinding, starting a Campfire will help you rest.

- You need to sit close to the Campfire (3 cells ) to feel the warmth.
- Anyone can sit by your Campfire and rest.
- Campfire lasts 2-3 minutes.
- Need to sit for at least some time to begin feeling the warmth and comfort.
- you cannot start a fire within 5 cells of another NPC
- If you use a match one more time, old Campfire disappears and a new one appears.
 
I think it will add an element of roleplay and romanticism to the gameplay.
 
 
Installation : 
To be able to use this script you need a plugin npc-duplicate.c
https://github.com/dastgirp/HPM-Plugins/blob/master/src/plugins/npc-duplicate.c
Install & enable this plugin This script uses a relatively new NPC sprite at the moment of writing this release.
4_BONFIRE
Therefore, you may have to edit the Hercules source to allow for this new NPC
To the /db/constants.conf
add this line: 4_BONFIRE: 10252 In the /src/map/npc.h
change this line: #define MAX_NPC_CLASS2_END 10800 This will allow for way more NPCs
Save and recompile Hercules. In the client, you may not have this NPC
But luckily for you, I've included with this release a data.zip archive containing the NPC sprite
and the sound of striking a matchstick.
Just add it to your GRF or data folder if you use data folder. In the client, Lua Files make sure you have this NPC sprite

LuaFiles514/Lua Files/Datainfo/NPCIdentity.lub JT_4_BONFIRE = 10252,
LuaFiles514/Lua Files/Datainfo/jobName.lub
  [jobtbl.JT_4_BONFIRE] = "4_bonfire", In the /db/re/item_db.conf or /db/pre-re/item_db.conf
find Id: 7035
and add these 3 attributes Type: 2 Delay: 3000 Script: <" callfunc("F_CreateCFDup"); ">  
Configuration: 
It is a configurable script
All of the parameters are explicitly commented for a better understanding of the rules
.refillHP_rate = 15; // number of HP to give every refill .refillSP_rate = 5; // number of SP to give every refill .refill_distance = 3; // max distance from fire HP/SP regeneration will work .camp_fire_delay = 5; // Skip how many ticks before feel warm ;) .refill_timer = 300; // wait rand(X) ms before refil Feel free to adjust to your server needs
.@nofire_distance = 5; // How far from other NPCs allowed to make fire. .@fire_duration = 1000 * 60 * 3;// 3 minutes (How long will the Campfire last, in ms)  
Submitter Habilis Submitted 06/22/18 Category Utility  

View File Hash table
This plugin exposes the internal hash table (strdb) to the script engine to provide a key-value store.
See documentation on hercules-hashtable/doc/script_commands.txt
 
Download here: https://github.com/Helianthella/hercules-hashtable
Submitter meko Submitted 06/18/18 Category Plugins  

Description: When a Star Gladiator is Soul Linked, the 'Lord of Vermilion' and 'Parrying' skills become available for them to use.
This must be the most requested source edit of all time? Idk why. Anyway, here you go - in plugin form.
https://github.com/bWolfie/HPM-Plugins/blob/master/src/plugins/sg_parrying_lov.c

What you have there are instructions. Basically, you just need to follow them and it should slot straight into Hercules.
It should work, cause skill ID 85 = WZ_VERMILION and 356 = LK_PARRYING.
If I'm correct, it is telling you to edit the pc_calc_skilltree_clear function. I'll let you try to work it out from here.

Hi all,
For the longest time I've been creating custom script commands simply so I can read a value from struct map_session_data{}. For example, I wanted to return the value of sd->state.showzeny, so I created a simple buildin just for that purpose.It would go something like this:
 
BUILDIN(read_showzeny) {     struct map_session_data *sd =  script->rid2sd(st);     if (sd != NULL)         script_pushint(st, sd->state.showzeny);     else         script_pushint(st, -1);     return true; } Seems not bad, right? But then it got me thinking. I'm creating all these script commands for one simple action. Surely there's a better way? That's when I stumbled across the getunitdata() command.
Then it came to me - create a script command which can fetch this data for a player.
The Goal
Create a script command which can fetch the data which map_session_data provides. It would work similar to getunitdata():
*getplayerdata(<account id>, <DataType>{,<Variable>})
Maybe also setplayerdata()?
Helped needed: The one thing is, not all the stuff in there is useful. Maybe it would be best to selectively choose what can be retrieved as data? I made a list for this stuff. Let me know what you think.
 

just remove cases of disablenpc

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:
 

i thought stalker is already immune to dispell skill when linked?

chat_area_size refers to the distance in cells in which you can see the public chat of other players.
It must be equal or lesser than area_size, which specifies how many cells away can you see players.
E.g.
chat_area_size = 9
Player A is at prontera 100 100 -> Can see chat from Player B, not C.
Player B is at prontera 100 109 -> Can see chat from Player A and B.
Player C is at prontera 100 110 -> Can not see chat from Player A, can see Player B.
#channel system is something else.
 

=General
*Added ranges of styles/dyes for Doram's.
-This is a range seprate from the regular ones since Doram's officially have a
-different set number of hair styles and cloth dyes. As of 2018-06-05 they have
-6 hair styles, 8 hair dyes, and no cloth dyes (tho kRO says their will be a few
-added soon).
*min_doram_hair_style
*max_doram_hair_style
*min_doram_hair_color
*max_doram_hair_color
*min_doram_cloth_color
*max_doram_cloth_color
+Added these configs to the client config file.
-These are a seprate set of style/dye ranges for Doram characters.
-This is needed since they have different maxes from humans.
*Updated a few commands to pickup on the style/dye ranges for Doram characters.
*Updated default setting for "max_hair_style" to 29.
*Corrected default setting for "max_hair_color" to 8.
*clif_spiritball_single
*clif_soulball_single
+Changed the packet these functions use to 0x1d0 (ZC_SPIRITS).
-This change fixes a issue where Rebellion's Coin sphere's and Soul Reaper's
-Soul Energy sphere's would look like regular spirit sphere's when the player
-warps to another map, refreshes, and also appear as spirit sphere's to other
-players who walk into view range of the one with the spheres.
-It also fixes a issue where the sphere's may not vanish properly from view
-when the player dies.
*Added job restriction system.
+This allows setting restrictions to different jobs that prevent's them from
-entering certain maps. Attempts of entering a map as a banned job will just
-result in no warpping. Basicly, something as simple as walking into a regular
-map warp won't do anything if the player's job is banned from entering the map.
-This works for teleporting, warping, any warp commands, walking into NPC warp,
-put something else here and it will likely fail as well.
-Should a player playing a job banned from that map somehow login on that map,
-the player will be warped out into Prontera's graveyard behind the church.
-These restrictions can be set in the "job_notallowed" database file.
*Added a missing timer function list entry for the soul energy system.
 
=Database
*Updated const file to support detection of new style/dye ranges for Doram
-characters in NPC scripts.
*Added the "job_notallowed" file.
-This file is used to set jobs that are banned from entering certain maps.
-It basicly works just like item_noequip and skill_nocast_db.
*Rebuilt the map cache.
-This is due to prontera being reverted back to the original version.
 
=NPC
*Updated the 3CeAM super stylist to detect the ranges of styles/dyes for Doram
-character's.
 
=Skills
*RL_MASS_SPIRAL
+Fixed a issue where the skill would deal extremely high damage on targets with
-negeative DEF.