Guild Activity Logging 1.2.0

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`

SELECT castle_id, COUNT(`activity`) as "Times Done"
FROM interlog
WHERE `origin` = "ThisGuild" and `activity` like "%Occupied%"
GROUP BY castle_id