I agree with global guild stuff, except for "import global guild data." I don't think that global guilds should be local if a majority of players in that guild do not play the server or if the guild is largely inactive. Imagine if unixmad logged on, made VIP a local guild, and asked for the global guild data to be imported. I also think that guilds should have a limited amount of members.
The import the way I see it happening would happen on a per player basis once they try to put on a global tag that has been registered by their leader on Classic. A global guild would probably also not have the names/accounts/tags stored locally nor access to the local rights system since that sort of behavior is best left to the online panel for a global guild. The only interaction from global guild would be tracking their statistics in PKing/Sparring/Events.
I like the idea of prestige or points. One idea I have for using prestige is to purchase member slots; increasing the maximum amount of members. Also, having enough prestige could allow the guild to create or purchase a guild house.
I don't know if the points would be spent as a currency but this is probably a solid idea to insure that a guild is relevant before they can upload a guild house in the middle of the (very limited) GMAP. This sort of specific falls out of my domain but I think making sure a guild reaches a certain prestige point is probably as good a litmus as any for when they can have their guild house.
I don't like the idea of multi-guilding with local guilds. If you guys absolutely insist upon it, it may be a good idea to limit the amount of guilds a player can join.
My
hope is that by forcing players to commit to a guild to earn their prestige points for, and making the commitment to begin earning them points a serious one like reaching 50-100 player kills, participating in 20 events or 40 spars (these are all made up numbers subject to revision) players will build a strong loyalty to a certain guild, while not disqualifying people from messing around during a Sunday football game with an "Aaron Rodgers Fan Club" tag.
I do not see how event wins fit in with guilds. Guild tags are removed from single player events and tags are generic in team events.
The idea here is whatever prestige guild a player has selected will get 1 win per player win, so stats might see a minor bit of inflation since it wouldn't directly be guild vs guild. This can also be excluded entirely and lead to actual guild specific events in the future, like guild CTF tournaments, spar tournaments, etc. The idea with the stat tracking is to remain highly flexible so that data can remain highly readable and comparable, down to how many CTF Sumo's one guild may have won/lost compared to another.
Also, since this wasn't addressed; there is an alliance system already working. Staff guilds currently use it. What is the plan for alliances?
Right now I have a "Diplomacy" system penciled into the guilds SQL table where guilds will be stored and this is actually a great area to get in depth in before I finalize any data structures. Graal the Adventure's HD has an ally system (believe it or not default does as well now) that I think can reasonably be taken advantage of. Another thing I think would be really awesome is having allied actions contribute to allied guilds in some cases at a reduced rate, while possibly also adding multipliers for taking actions against hostile guilds (E.G: X player in US kills Y player in Ventrue on the overworld - they are given 1.5 of the points they would normally receive for that sort of action).