jaBote

Yeah, this could remove some cumbersomeness that makes trying to restrict that from your GMs by other means.
 
On my side, I made an unequippable headgear which weighed 111% the original GM's weight capacity, and assigned it to the GM via the DB then removed any statpoint left. This way the GM had all those permissions applied because it was 1/1 novice without even basic skills.

I agree with it:
Easier to use Easier to make new official and custom related items without needing to code and recompile

I'm on cellphone so I can't give you a full reply.
 
As a temporary solution, you can just head to db/(pre-)re/item_db.txt then search for the Maya purple card. On its script field you should add a mapflag comparison.
 
something like this:
if (!getmapflag(strcharinfo(X), mf_pvp) && !getmapflag(strcharinfo(X), mf_gvg)) {original_Maya_purple_script;}
 
I haven't the value of x right now, but I think it's 3. Go to /doc/script_commands.txt to look for the strcharinfo command help and take the value of the script command that returns char's current map. You should also chech if I used getmapflag correctly, of which I'm almost sure.

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

6791428e - 34a10fe9 - 434115de
2013 06 18 Ragexe

Hercules on Amazon EC2 (Windows Server 2012) Instance
 
Video
 
https://vimeo.com/68667751
 
Benefits
 
Main benefits of using Amazon’s Elastic Compute Cloud (EC2) are:
 
Cost
You can start with a micro instance which has 750 hours per month of Linux and Windows instance use, along with 613 MB of RAM, 32 bit or 63 bit systems. Which is free of charge with certain operating systems, including Windows Server 2012 Base. This is called the Free Tier.
Beyond the free tier you start $0.060 USD cents per hour for a Small Linux instance, which is $1.44 USD per day, or $0.091 USD cents per hour for a Small Windows instance, which is $2.18 USD per day. Not bad at all. Lots of VPS hosts charge this and more already. Just pay as you go.
Small instances support 32/64 bits, 1 core, 1 ECU, 1.7 GiB, 1x160 GB
Source: http://aws.amazon.com/ec2/pricing/
Source: http://aws.amazon.com/ec2/instance-types/
 
Scalability
Once your server needs more RAM and CPU power than the Free Tier can offer, you can just 1) take a Snapshot of your current instance, 2) Detach your Elastic IP from your old instance, 3) Create a new, more powerful instance from the Snapshot, 4) Attach your Elastic IP to your new instance, and BAM, you’ve got the exact same Hercules server on better hardware. All this in a few
minutes. You have complete control.
 
Reliability
Amazon’s Elastic Compute Cloud is exactly that. A reliable, elastic computing cloud. All your virtual machines are hosted on the most stable clusters that use the most speedy network connections available. You’ll definitely get peace of mind that you’ll server won’t just stop working one day because of unreliable hardware, software or bad maintenance.
 
Important

Creating and using an Elastic IP is FREE of cost. But using additional Elastic IP’s cost you $0.005 USD cents per hour. Which is $.12 USD cents per day.
http://aws.amazon.com/ec2/pricing/#elastic-ip
 
Inbound and Outbound Bandwidth per GB is free.
http://aws.amazon.com/ec2/pricing/#DataTransfer
 
Snapshots are pretty cheap too. Cost depends on country.
 
You can get an idea of how much your new instance will cost with the calculator
http://calculator.s3.amazonaws.com/calc5.html
Note: Remember, Micro instances are FREE with certain Operating Systems.
 
Thanks to
 
Hercules Team for, well, Hercules
Judas for Skype session and Full Install / Small Client post

New mapflag folder is npc/mapflag. This is way more intuitive, I don't know why it wasn't done before.

Detailed WoE stat can be made into a plugin, it's not that hard.
 
I'm waiting for the Hook update for the HPM system and then i'll try converting some of eAmod stuff into plugins.

Hello
 
1.- For the most part and as far as I am aware of, pre-renewal is pretty stable as it has been for the past.. 3 years? There could possibly be more tweaks to do, but the pre-renewal code is pretty much the same for eA/rA/Hercules, so you shouldnt have any major issues there.
2.- The cashshop doesnt have a Renewal specification, as long as your client supports it, you should be fine (Ragexe clients support Cash shop). 
3.- Skills and statuses are available for either version on its most, only times when *Renewal* comes into play is when the formulas for a skill differ. Since Kagerou/Oboro are Renewal exclusive, there is no pre-renewal formula for the skills. They will work given you update your pre-re files acconrdingly (skill_db, job_db, etc)
4.- For the most part, item bonuses don't change much except for a recent commit which updated the name of some Statuses. Shouldn't require a major overhaul of any of your custom items.
5.- As far as I am aware of, only ViariableCastRate/FixedCastRate related additions. 
 
For the client:
1.- No idea. Cashshop is a Ragexe feature but I personally havnt tried any of those clients afar. Going with something like 20120418 should be good though
2.- You only need to change your item files to lua if you go with a client > 2012-04-18
3.- Hercules anti WPE/RPE works by encrypting packets (It doesnt have anything to do with skill delays or 3rd party software attachment). 

Here in Hercules we follow kRO updates. However, most kRO mechanics are also implemented in iRO and it's easier for us to get information straight from iRO, pRO and other servers (mainly because of the language). We usually make sure whatever we implement on Hercules exists in kRO.
 
Even in case we implement non-kRO updates, you should use kRO clients because they're more complete than other ones.
 
Hope I helped.

He hecho una traduccioncita rápida en tu post del bug para que te entiendan algo mejor, aunque creo que los últimos ragexeRE tienen Cash Shop. Eso sí, no son estables aunque se pueden usar.
 
-------------------------------------------------
 
Pequeña respuesta de Yommy desde IRC:
 
El mail system fue eliminado de los servidores oficiales (incluso su ventana oficial de mail) hace como un año debido a una cantidad enorme de bugs y exploits que había en él y que parece que no podían solucionar, motivo por el que no funciona el mail en los clientes Ragexe. Y RagexeRE son clientes de servidores de prueba de Gravity que ni siquiera tienen cash shop.
 
Así pues, no parece que haya manera de casar las dos cosas: habrá que escoger entre una u otra.

either request at rAthena to convert it, or change to using Hercules
 
Hercules devs will not create this for rAthena o_O

If you set a variable to 0 if it's a number or "" (empty string) it's supposed to be gone for good, so this script command request is already made:
 
Check this piece of text from doc/script_commands.txt

for anyone who requires, the 3 keys are hardcoded to each client, you can search the keys in hex editor and modify for something unique.
for those with IDA / OllyDBG, the keys are pushed just before the PACKET_CZ_ENTER reference (not the actual string)
 
.text:007962A7 0F 84 77 FC FF FF jz loc_795F24 .text:007962AD 8B 0D 04 0F 98 00 mov ecx, dword_980F04 .text:007962B3 68 05 22 05 22 push 22052205h // key 3 .text:007962B8 68 05 22 05 22 push 22052205h // key 2 .text:007962BD 68 05 22 05 76 push 76052205h // key 1 .text:007962C2 E8 A9 64 E3 FF call sub_5CC770 .text:007962C7 68 6C 30 89 00 push offset aPacket_cz_ente ; "PACKET_CZ_ENTER" .text:007962CC E8 6F 19 C7 FF call nullsub_1 .text:007962D1 B9 2D 02 00 00 mov ecx, 22Dh .text:007962D6 83 C4 04 add esp, 4 .text:007962D9 66 89 4C 24 48 mov word ptr [esp+3ECh+cp+2], cx

Hercules WPE Free - June 14th Patch
 
Made Possible Thanks to Yommy
We're only able to provide you with this feature thanks to Yommy, Thank you very much! WPE Free - Official Packet Obfuscation Support Packet spamming is no longer possible by normal means, with this feature each packet sent has its own id, so spamming (by sending the same packet more than once) is impossible. For this feature to function you MUST NOT use the 'disable packet obfuscation' client diff. conf/battle/client.conf
// Whether to enable the official packet obfuscation support (good vs WPE)// 0: disabled// 1: optional (not recommended) -- identifies whether it is required// 2: enabled (recommended)packet_obfuscation: <value>
Currently functional for over 44 clients (Thanks to Shakto!): 2011-08-17 - 2015-05-13 Special Thanks to Yommy ..Yommy ...The all-awesome Yommy~! Thank you again! Shakto for the 44 PacketKeys! Also - SQL DB Updates & DB2SQL For logical and performance reasons we've modified the structure of the renewal item db tables, atk and matk no longer share the same column, equip_level was replaced by equip_level_min so that we could add equip_level_max which is required by new renewal items. Note however that because of the previous atk:matk format, it was not possible to provide a upgrade file that would save the matk data Item script errors from sql dbs used to point to a inexistent line number, it was modified to display the item id instead. This update has shrunk the sizes of the item db .sql files, making it possible for tools such as phpmyadmin to parse them, once again. With this patch we're also introducing a new official plugin, db2sql, its purpose is to make it easier for our developers to keep the .sql db files up to date (but you may use that to convert your own if you so desire, too), to use this plugin (when it is enabled in plugins.conf) type server tools db2sql in the console. Link~u! Commit 1 Commit 2

Hercules Renewal Updates
 
Ladies and Gentlemen Hercules Development Team Proudly present you Official Ragnarok Renewal Mechanics/Systems that is now available in Hercules....
 
 
What Renewal updates do we have?
 
RE PHYSICAL ATK SYSTEM
-RE EDP support.
-Mob ATK support
-RE DEF reduction support
NOTE:It is functional however there are still some missing piece that needs to be discovered
 
RE MAGICAL ATK SYSTEM
-Mob MATK support
-RE MDEF support
NOTE:It is functional however there are still some missing piece that needs to be discovered
 
RE CASTING SYSTEM
-Fully functional casting formula derived/based from kRO
-Skill bonuses support
 
RE ASPD SYSTEM
-Full support for skill bonuses
-Support for item bonuses
 
RE STATUS SYSTEM
-Accurate batk, hit, flee, def, mdef & etc formula for MOBS and PC
 
RE SKILLS
-Such as CR_ACIDDEMONSTRATION, ASC_BREAKER and etc.
-3rd jobs skills
NOTE:This is huge but I can say we already have almost half of it
 
2013 kRO Updates
we already have some of the new skills implemented
GC_DARKCROW RA_UNLIMIT GN_ILLUSIONDOPING RK_DRAGONBREATH_WATER RK_LUXANIMA NC_MAGMA_ERUPTION WM_FRIGG_SONG SO_ELEMENTAL_SHIELD SR_FLASHCOMBO SC_ESCAPE AB_OFFERTORIUM WL_TELEKINESIS_INTENSE LG_KINGS_GRACE ALL_FULL_THROTTLE And a lot lot lot more to be added...
 
 
And now we challenge you to compare our current system to official servers and we guarantee a good satisfaction but PLLEEASE if you find bugs, discrepancy and other anomaly just drop by our  Bug Tracker and we will immediately take appropriate action to serve you most..
 
commit
 
SPECIAL THANKS!
To Awesome Yommy for the AWESOME support, resources, methods and techniques. To Rytech for the KG/OB skill info To Kyeme, Mecheiru, Angezerous & others for RE info and tips And lastly to you as a member of Hercules

If you set a variable to 0 if it's a number or "" (empty string) it's supposed to be gone for good, so this script command request is already made:
 
Check this piece of text from doc/script_commands.txt

For usable items you can use a map zone restriction: just disable it on the "All" zone and enable it on the Battleground zone.
 
For items used by skills, that's a bit more complicated and maybe you need a source mod.
 
Why you don't check out this source mod? May be useful for what you want: http://herc.ws/board/topic/425-bg-consume-mapflag-battlegrounds-items-that-can-only-be-used-in-bg/

Actually, renaming the entire interface system to i<Whatever> seems a really good idea, in order to maintain consistency and reduce the difference. 
In general for anyone who comes fresh new, learning that the interface system renames all the previous functions to iPrefix might be easier to adapt to, however I believe all the interface system should be renamed accordingly to whatever comes into this.
As for mkbu's comment when I first read it I thought it was referencing to inter functions or those *if* functions (chrif, intif), which might lead to a small confusion (which iPrefix wouldn't). 
 
On a side note and as a personal remark, I hate the lower i and the first capped character afterwards, feels too much like Apple stuff and that's way too mainstream for us (But as stated previously, anything saying "if" or "int" or similar could cause some confusion, so I don't think it'd be a really good idea)

Before I forget for the nth time. 
 
Regarding HPM Function Overloading, is it possible *or would it be possible if it doesnt already* to have Hercule's core functions be loaded together with the plugin functions or would the plugin overwrite them?
 
Scenario: The PK Plugin checks if sd->state.pk is enabled (which would go under battle_check_target), while Faction system plugin would check for like sd->status.faction value to see wether target is friend or foe. If both plugins overwrite battle->check_target, would both checks remai or would one overwrite the other? And each one overwrite the original battle_check_target's code? 
 
Edit: Also in case the functions are not overwritten, would the new custom battle_check_target have to be completely the same  as the original one? or could I just add the pieces of code as I need them? Like for instance, could I simply do
int my_battle_check_target( struct block_list *src, struct block_list *target,int flag){ int16 m; //map int state = 0; //Initial state none int strip_enemy = 1; //Flag which marks whether to remove the BCT_ENEMY status if it's also friend/ally. struct block_list *s_bl = src, *t_bl = target; nullpo_ret(src); nullpo_ret(target); if (s_bl->type == BL_PC && !((TBL_PC*)s_bl)->state.pk) return false;} for the PK plugin? 

Hello friends!
 
this is interesting to you? can i continue the development? or it's not a good project? 
 
Page: http://barrosfilipe.github.io/robrew/
Github: https://github.com/barrosfilipe/robrew
 
 
What is RObrew?
 
It's a Linux (Debian Based OS / Red Hat Based OS) application that will provide you a simple life in ragnarok emulator management.
 
Example without RObrew:
 
You need to install package dependencies to your emulator manually, for example:
 
    * gcc
* make
* mysql
* mysql-devel
* mysql-server
* pcre-devel
* subversion
* zlib-devel
 
And then download the emulator from svn/repo and compile it manually!
 
Example with RObrew:
 
After install RObrew you just need to do that command in your terminal:
 
$ robrew install <emulator>  
For Hercules:
$ robrew install hercules  
Package Dependencies:   * gcc * make * mysql * mysql-devel * mysql-server * pcre-devel * subversion * zlib-devel  
The robrew command will install all package dependencies automatically, download Hercules from official svn/repository.
 
If you want to compile:
 
 
$ robrew compile /path/to/downloaded/hercules/folder/  
RObrew is now in development and the first release will have plugins. For example, a plugin named emulator-dropbox-backup that provide automatically daily backups from your emulator and database to a DropBox storage.
 
if you are interested to get involved contact me (PM).
 
Thanks! Let's make the world better 
 
with Love <3,
c0nsumer (Filipe Barros)

Hello,   Just want to share my Hercules Userbar, you can use this userbar if you want.  

This project is focused in texture translation to English Translation. The current translation are done very bad, by alot of people. Some buttons are bold, some wrong color, some missing drop shadow. There needs to be some record of official font, color, size, etc

The translation that you are going to find here may not be the official one.

Any advice, suggestions or request would be most welcome!
 
svn:
https://subversion.assembla.com/svn/texture-translation-project  
And also you can find the data_PSD folder where you can edit the whole project using Photoshop CS6.
 
Special thanks to Yommy for your good advices.

Se refiere a esto: http://herc.ws/board/topic/988-atcommanddance/
 
Como puedes observar a través del código, si especificas algún parámetro entre el 1 y el 9 (ambos inclusive), tu PJ realizará algún efecto visual o sonoro. La decisión del efecto que se realiza aparece en este trozo del código, tomado directamente de ese tema:
if ( atoi(message) == 1 ) {clif->specialeffect(&sd->bl, 413, ALL_CLIENT); } else if ( atoi(message) == 2 ) {clif->specialeffect(&sd->bl, 414, ALL_CLIENT); } else if ( atoi(message) == 3 ) {clif->specialeffect(&sd->bl, 415, ALL_CLIENT); } else if ( atoi(message) == 4 ) {clif->specialeffect(&sd->bl, 426, ALL_CLIENT); } else if ( atoi(message) == 5 ) {clif->specialeffect(&sd->bl, 458, ALL_CLIENT); } else if ( atoi(message) == 6 ) {clif->specialeffect(&sd->bl, 466, ALL_CLIENT); } else if ( atoi(message) == 7 ) {clif->specialeffect(&sd->bl, 501, ALL_CLIENT); } else if ( atoi(message) == 8 ) {clif->specialeffect(&sd->bl, 540, ALL_CLIENT); } else if ( atoi(message) == 9 ) {clif->specialeffect(&sd->bl, 550, ALL_CLIENT); } else { clif->message(fd, "usage: @dance 1-9"); } Los efectos que se envían son el valor numérico de tres cifras (en azul claro) que varía con cada número (recuerda, del 1 al 9) que le especifiques.
 
Puedes ver esos efectos en doc/effect_list.txt. Para referencia:
 
Como puedes observar, se trata de un comando bastante simple, con un uso meramente cosmético.

For this you should have a lot of care. If you want to wipe all your server data and ONLY leave accounts alive (which is what I think you want), I'd truncate (TRUNCATE TABLE `table_name`) all tables except `login` and (optionally) `mapreg`. Truncating a table means emptying all of its content and setting the auto_increment values to 1. Making backup is highly advised before doing this. 
 
Can't tell you right now, I'd better use PHP for this and insert it with 2 queries: one for getting all the account ids and another for inserting a value on the storage table for them. 
For the warning, it means you're running it as a root superuser in your Linux system and you're advised not to do that ecause consequences may be fatal if someone manages to take over your system via the game, because they're allowed to do anything as root. That's not MySQL related.