Ninja Posted June 3, 2017 Group: Members Topic Count: 54 Topics Per Day: 0.01 Content Count: 513 Reputation: 83 Joined: 08/11/12 Last Seen: December 25, 2021 Share Posted June 3, 2017 View File Guild Activity Logging 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 Submitter Ninja Submitted 06/03/2017 Category Source Modifications Content Author Quote Link to comment Share on other sites More sharing options...
SusanoSprites Posted June 3, 2017 Group: Members Topic Count: 7 Topics Per Day: 0.00 Content Count: 28 Reputation: 0 Joined: 10/06/12 Last Seen: December 10, 2022 Share Posted June 3, 2017 Cool! Thx! Quote Link to comment Share on other sites More sharing options...
Ninja Posted June 4, 2017 Group: Members Topic Count: 54 Topics Per Day: 0.01 Content Count: 513 Reputation: 83 Joined: 08/11/12 Last Seen: December 25, 2021 Author Share Posted June 4, 2017 You're welcome have fun Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.