Guys, what with the recent problems at Tzumainn.com, we thought it would be a good idea to announce a new collaborative project Erick (finitesquarewell) dreamed up a little while back.

The site is agotwiki.com , and its goal is to be a resource for all Thrones players which isn't ultimately dependent upon one person's current involvement (or lack thereof - life gets in the way, unfortunately, for all of us at times).

A secondary project closely tied in with the site is that of a player-run rating and ranking system, which Erick, along with other prominent members of the community, had been working on. Alas, those efforts were not completed before Regional Season (those pesky 'life" interruptions), but hopefully those plans can get back on track soon.

What you'll see is a rough start, but a basic framework that's in place. Feel free to jump in, add your name to the player pages and edit your own page, submit decklists, articles, etc. Hopefully, with all of us working together, we can make it a useful tool for old and new players alike.

One request that I would make: I would love to get some of the older info from past World Champions (their winning decklists, for instance) as a start to compiling some of the more important information from the history of the game. (I would love to have more, obviously, but that's a good starting point.) And if anyone knows of a way to salvage some material from Tzu's site and transfer it, that would be a great help.

Didn't we have a page on Wikipedia? Didn't that die for lack of interest? Why would we need another wikipedia page?

The old wikipedia page is linked to from the new agotwiki page. The old page is more basic information about the game. The new site is intended to be a complete catch-all for player interaction, including tournaments, rankings, metas, OCTGN, etc.

Great idea guys! I would love to see a card database section with card rankings as wells as an area people can post questions about each card or have a FAQ for cards with tricky timing, wording etc.

thanks for posting this longclaw. i haven't had time to work on this, but it's definitely something the community needs. it'll be a great place to keep a comprehensive list of OCTGN players, post tournaments, look at past tournament results, etc. we intend to have a ratings/rankings system with it (the details for which are mostly hammered out already), but that's not going to be ready for a while yet.

as for whether or not this is the ideal solution to a card database, it might not be. i would avoid starting in on such a project with the wiki until it can be thought out, but in general things that require database solutions aren't very well done with wikis due to their lack of strong inherent database capabilities. it might seem like a good idea to store all the cards in existence on there, but it wouldn't really be searchable. also, we have to be considerate of the space our host is lending us, and i fear that a full entry for each card might be encroaching. something for discussion when i'm done with school in a week or two...

Now that the news is official I can excent this project also to other italian players... tomorrow we have a tourney in Genova so I'll post also there results and my wolf deck :-)

ciauuu

Being a public project, if we ever do get card images on the site (is it worth it?) users could them post FAQ about the individual cards. Perhaps them ktom won'thave to answer the same question 5 or 10 times. I know that there have been times I have wanted to find those types of answers without having to always post on the forums.

Also, perhaps the community is now in a better place to have this type of site. Some of us seem to spend too much time online when we have nothing better to do (like me...)

The agot database ive been working on is open source under BSD license.

Erick: the tourney ranking system? What sort of data needs to be stored? I was orignaly going to add something along the lines of:

Tourney: id - Primary Key, date, description,user_id -> Foreign Key to the users table which is the person who ran the tourney.

Tourney_Decks: id - Primary Key, tourney_id -> Foreign key to the tourney table, deck_id -> links to the deck table, version -> version of the deck., public - boolean whether the player wants this deck posted.

Tourney_Matches: id - Primary Key, win_deck_id -> Foreign Key to Tourney_Decks, loss_deck_id -> Foreign Key to Tourney Decks, draw - boolean.

As I already link decks with players

So then one could run queries of any type to determine rankings, etc. Let me know if anything else is needed for storage and I can adapt. This is all on sourceforge btw so anyone can take my code so long as they adhere to the BSD License.

In Spain we have one AGoT wiki that we started some time ago...

This one