Leaderboard

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