After looking through suggestions here and through PM I've modified the design to some of the structures a deal in a way I think most people will agree on
I'll try to convert my awfully handwritten design document into readable English here.
Guild System - use two SQL tables, one containing guild name, founding time, statistics, other one containing GuildMembers, IE account, guild, rights flag.
Stat tracking:
PKing, sparring, team events (full team must be guild), solo events, on tag time
in the case of events, only wins/losses will be tracked since stats like flags scored and returned are a bit excessive and don't give much explanation for the guild as a whole
on tag time will be extrapolated into an "activity rating" along with actual event participation, sparring, PKing etc (these are not the overall "points" concept, just a overall value rating with which to compare guilds as a whole rather than specific stat)
Guild management
Add, Kick, Edit members > local only
Edit diplomacy and information > available to global guilds
disband, view log > local administrative tools
-need to request Stefan make guild IDs as used on GraalOnline website accessible to lister so that creating URLs leading to global guild applications is easily doable
First few steps:
Track on tag time
Add PKing/sparring listening to track stats
Allow GCs to award guild wins for team events, have it automatically occur for solo wins