Ninja

Tested and working with: 3e625dfdf9868690e36677701cbebe1b379a7485
This source edit is intended for my experiments. Feel free to have fun with it but I wouldn't be held accountable for damages that it may create for your server.
No support will be given other than the specified rAthena version above.
Purpose
Create a mapflag for instakill. As it would suggest, all damages done within the map will be amplified to max damage, thus instakilling the target.
It works both for the following use cases:
1. Player attacking a Monster
2. Player attacking another Player
3. Monster attacking a Player
4. Monster attacking another monster
Where "Monster" can be a normal mob or a Homunculus
Usage
In-game
@mapflag instakill [0|1] Script as mapflag
prontera<tab>mapflag<tab>instakill Script as used in setmapflag
setmapflag .EventMap$, mf_instakill; Example
Tag, You're Dead Script
Source In Action
Source file
 
1. I will retain all the rights in all the scripts that I create
2. Client cannot redistribute nor resell the scripts that I provide
3. No refunds
4. Maintenance of scripts does not include modification of the original intended behavior. If the script has been broken due to prior modification of the original behavior then it would mean a new service request
5. Modification of the original intended behavior would mean a new service request and would go through the process mentioned above
2. This can be redistributed anywhere in any form.
3. This shall not be in any way be branded for sale anywhere in any form.
4. Maintenance will not be provided. Feel free to use the support section.
5. See #3.
6. Ninja has the right to post all my free services to the release section and make it available for everybody to use
7. Maintenance of scripts will be provide free of charge
8. I will not keep any sensitive information from your server nor any credentials that you lend me
9. I will backup all my server files before I use this.
10. Ninja will not be liable in any way at any time.
11. The moment I use anything from here, I accept all the terms of services stated above.
Where the script author is Ninja (https://rathena.org/board/profile/7005-ninja/).

About This File
Tested and working with: 264af55
No Source Modifications needed.
Purpose
Provides a nice set of hats which resets after x amount of days. It can give the possibility to try the headgear on. This is primarily targeted for Headgears but other items can also be sold and automatically takes off "View Item" in the menu if it is the item being bought is not a headgear. Has the ability to randomize or use a pre-defined set of items.
Changelogs
The Mad Hatter
V 1.1.1:
    Fixed problem about checking rentals items in inventory when Randomize Hats option is enabled
    
V 1.1.0:
    Public Release
    Swapped Yes/No sequence when a GM talks to the NPC to avoid accidental reroll.
    Added Randomization option of hats
    
V 1.0.1:
    Fixed missing semi-colon in config part.
    
V 1.0.0:
    Player can rent 1 headgear per day.
    Cannot rent another headgear, if the rented item is still present on their inventory.
    Configurable length of rental time
    Choose between Zeny or Coin payment
    Able to try headgear via "View Item" menu
    Weekly change of items. GMs can manually reroll the item set per week.
    Configurable amount of Headgears to be displayed per week
    
    *please see configuration part by searching "Configuration part"
Preview of Configuration in Script

End User License and Terms of Services:
1. I will retain all the rights in all the scripts that I create
2. Client cannot redistribute nor resell the scripts that I provide
3. No refunds
4. Maintenance of scripts does not include modification of the original intended behavior. If the script has been broken due to prior modification of the original behavior then it would mean a new service request
5. Modification of the original intended behavior would mean a new service request and would go through the process mentioned above
2. This can be redistributed anywhere in any form.
3. This shall not be in any way be branded for sale anywhere in any form.
4. Maintenance will not be provided. Feel free to use the support section.
5. See #3.
6. Ninja has the right to post all my free services to the release section and make it available for everybody to use
7. Maintenance of scripts will be provide free of charge
8. I will not keep any sensitive information from your server nor any credentials that you lend me
9. I will backup all my server files before I use this.
10. Ninja will not be liable in any way at any time.
11. The moment I use anything from here, I accept all the terms of services stated above.
Where the script author is Ninja (https://rathena.org/board/profile/7005-ninja/).
======================================================================================================
Credits to Radian for the initial request.
======================================================================================================

About This File
Tested and working with: c212b2ed053d60855ce584a0368d98cff94c5059
This source edit is intended for my experiments. Feel free to have fun with it but I wouldn't be held accountable for damages that it may create for your server.
No support will be given other than the specified rAthena version above.
Purpose
To improve the Guild Activity Logging of rAthena. 
It works for the following Guild Logging activities:
1. Guild Creation
2. Guild Breakage
3. Guild Member Addition
4. Guild Member Removal/Leave
5. Guild Alliance Formation
6. Guild Alliance Breakage
7. Guild Antagonist Formation
8. Guild Antagonist Breakage
9. Guild Castle Occupancy
10. Guild Castle Abandonment
Usage
1. Tracking guild activities of a character
SELECT origin, target, `activity`, COUNT(`activity`) as "Times Done" FROM interlog WHERE origin = "this" or target = "this" GROUP BY `activity`   2. Tracking a guild's WoE Castle occupancy rate SELECT castle_id, COUNT(`activity`) as "Times Done" FROM interlog WHERE `origin` = "ThisGuild" and `activity` like "%Occupied%" GROUP BY castle_id  

v1.5 by Me
- Will be tagged as stable if noone complains about any bug
- Fixed the "fatal error: player not attached problem" caused by @MyTeam
- Participant will be taken as a casualty if he logs out when the session is on-going
- Added mapflags and can be modified through .@mapflags
- Tested and results were without errors, bugs, and exploits.
v1.4 by Me
- Will be tagged as stable if noone complains about any bug
- Thoroughly fixed a lot of logical and semantic errors
- Optimized a lot of codes
- Fixed a lot of exploits and bugs
- Made it functionally working
- Demo video uploaded
v1.3 by Me
- Quick fix for event not being able to function correctly because of mishandled variables
- Optimized OnEventStart algorithm
- Optimized and Improved Logged in/Logged Off Checking [suggested by PandaLovesHamster]
- Takes off logged off players from the roster instead of resetting the whole recruitment process [Response to the question of PandaLovesHamster]
- Took off OnFailLack
- Added OnPCLoginEvent and OnPCLogoutEvent
- Added GM OnAtCommand Safe failcheck [suggested by Litro Endemic]
v1.2 by Me
- Renamed to "PvP Recruiter"
- Changed @4v4 to @pvprecruitment <on|off>
- Added flexibility on number of parcipants (set .NumPlayers)
- Fixed and improved free slot checking algorithm
- Fixed and improved registration checking and team transfer algorithm
- Added Player Variable @MyTeam for easier checkings:
[0] Team number ( 0 for No Team Yet | 1 for Odin | 2 for Freya)
[1] Slot number of his team
- Fixed OnClear event
- Fixed Menu not closing on registration
- Added a variable to indicate if the session is on-going (set .started)
- Check if the event is already running at the beginning
v1.1 by PandaLovesHamster http://pastebin.com/Nya7kzsQ
- Player Logoff Detection
- Team change on recruitment stage
v1.0 by Me
- Rewrote the whole script
- Multiple registration detection
- Free slot detection
- Warp in and warp out function
- Rewards per kill
- Rewards for round win
- Search for "getitem" to change rewards and their quantity
- GM Commands: @4v4 on ~ to start | @4v4 off ~ to interrupt at anytime
- Broadcast message on registering when noone else has or during GM atcommand trigger
Credits:
jTynne for the original script that this was based on and to PandaLovesHamster for saving my file XD
PandaLovesHamster for suggestions making addons
Litro Endemic for suggestions

Features
- A reused script with some modifications and addons
- Mechanics: 30-minute run, kill all the way, reward the top 3 contenders
- No need to register to the PVP Ladder to be able to record PVP stats and see PVP Broadcasts
- No need to logout everytime the PVP Ladder is reset
- Reward system:
- Top 3 contenders will be rewarded, just find "announce", "OnGMStop" and "$pvpeventreward" to change stuff as needed
- Event runs for 30 minutes
- Just find "OnTimer" and change the numbers appended to it as needed

A Rework of Euphy's Devil Square Event
Changelog
v1.3
- Fixed Map-server Error about waitingroom
v1.2
- No. of monsters fixed to 3 * No of players inside Devil Square- Changed Monster level range per round to compensate for renewal monsters - Round 1: Monster Lv60 ~ 70 - Round 2: Monster Lv70 ~ 75 - Round 3: Monster Lv75 ~ 80 - MVP Round: if players <= 5: MVP levels from 1 ~ 120, else: 100 ~ 120 - These levels can be changed by searching for "query_sql" and changing the numbers in the lines- Added a ([ (1 / (2 + (n*5))) *100]% chance to spawn another MVP after killing it, where n is the number of MVP rounds so far - example: after killing the 1st MVP there is a [(1 / (2 + (0*5))) *100] = 50 % chance to spawn another MVP after killing the 2nd MVP there is a [(1 / (2 + (1*5))) *100] = 14.29 % chance to spawn another MVPA short summary for 10 rounds:http://imgur.com/uChQv0r- This chance can be changed by searching for "set $MVPDefeat" and changing the number in the line - Spawned Treasure Chests now considers all kinds of spawnable Treasure Chests from mob_db_re
v1.1
- changed Round 3 Player-to-Monster-Ratio to 1:3x3 (3 sets of 3 instead of 3 sets of 5)- fixed problem about not being able to enter Devil Square during Auto Event Trigger
v1.0 Initial Features:
- Random selection of mobs through SQL query - Round 1: Monster Lv40 ~ 50 - Round 2: Monster Lv51 ~ 55 - Round 3: Monster Lv55 ~ 60 - MVP Round: MVP LV60 ~ 70- Takes into consideration on how many players are inside the Devil Square - Round 1: 3 x No. of players - Round 2: 3 x No. of players - Round 3: 3 x No. of players //change - MVP Round: 1 MVP- 1 minute wait time after each wave- 3 rounds of normal monsters- 1 MVP round after the 3 rounds of normal monsters- 1% chance of summoning another MVP thereafter- separated script for NPCs and event

Features
1. 5-minute wait time
2. 5 rounds of 30 seconds each
3. Mechanics:
Win conditions:
only 1 player left
or all rounds finished
# of bombrings spawned:
if players <= 20: 3 * #of players
if players > 20: 60
Frequency of bombring spawn:
Round 1: every 4 seconds
Round 2: every 3 seconds
Round 3: every 2 seconds
Round 4: every 1.5 seconds
Round 5: every 1 second
4. rewards: (configurable, just search for "CASHPOINTS")
winner(s): 250 CASHPOINTS + configurable item
non-winners: 100 CASHPOINTS
5. GM commands:
@enablebombring to start
@disablebombring to interrupt