Really? What's the URI to the DB?

I can link you to a forum thread I put out there that contains that information (although the stats are out of 1000 games and not out of the 22k that this site boasts. The 22k will be off since there are a ton of games that contain multis, wins with less than 18 centers and other things that skew the information).

Wins with less than 18 centres?

What?

Here's the link to the infoRough win percentages by country and the most successful opening moves:
http://webdiplomacy.net/forum.php?threadID=558670

Austrian Statistics:
http://webdiplomacy.net/forum.php?threadID=493200

English Statistics:
http://webdiplomacy.net/forum.php?threadID=494156

French Statistics:
http://webdiplomacy.net/forum.php?threadID=495440

German Statistics:
http://webdiplomacy.net/forum.php?threadID=496126

Italian Statistics:
http://webdiplomacy.net/forum.php?threadID=496446

Russian Statistics:
http://webdiplomacy.net/forum.php?threadID=497743

Turkish Statistics:
http://webdiplomacy.net/forum.php?threadID=497745

@Hellenic Riot: Yes, there used to be some problems with games on this site. When 6 out of the 7 players stopped playing (or all 7), the one that played most recently would receive the win. Sometimes the number of centers were as few as 3 by one player with the other 6 resigning. Very early on, a number of games had wins where a player had 17 centers or even 16 and were declared the winner. The problems have been resolved and you won't see them anymore.

I also have stats on the correlation between messages per game and win/draw pct.

I also have stats on the correlation between messages per game and win/draw pct. I'm currently working on a project for a stat class that goes more in depth by country.

Tru Ninja: I'd love to see the correlation between messages/game and win/draw pct. Got a link for that one?
I'd love to show the messages/game (full press) on people's profiles.

good work dude

Did you end up finishing your report?
I'd love to get a copy of what you've done.

@draug, you can't download a copy of the db from a uri, but i do have an old one lying around, and kestas may be convinced to make an updated version (or on of the other admins...)

i can link you to my old copy if you wish.

Well done. Just read all the reports, most of it is what you'd expect, but with a few interesting twists like Germany's almost complete dependence on a strong Italy.

@MKECharlie: I can get it to you, but the problem is that it's currently in my notebook. I'd have to scan the pages and the graph would be difficult to read at best. I'm in the works of transferring it to a spreadsheet which will take some time.

@Yonni: Yes and no. Yes in that I initially did this report a year ago and it was done loosely for all 7 countries but the report is for Austria and England (due to time constraints) and has since been updated. Some of the openings don't necessarily reflect accurate statistics (the data are fine but the stats rely on a sample size of 30+ which I didn't have at the time).

I'm in the works of doing it for all 7 countries as well as including additional opening moves based on common moves made on this site. The basis for the names of the opening moves came from (originally) Diplomacy Pouch's proper names. Since that time it has been updated and many of the original names used by Richard Sharp have been deleted and many of the common openers have been replaced by others. Thus, the names for the opening moves common to this site are based first on Richard Sharp's book and where that fails, I create my own.

Anyone can currently request a copy of the incomplete stats or wait a few weeks to a month for the updated copy. My email is [email protected]

ninja, what language did you write the stats building program in?
I'd be interested in writing a script that takes the db info and places it into a better 'stats' db that would make it easier to derive statistics from it... I can remove unfinished games, 'bad/test' games, and put it into a better table structure aimed for statistical information.

try this: http://www.maths.tcd.ie/~orathaic/old/files/webDiplomacy.net-SQLdata.zip

a very much out of date copy of the games...

@fortknox: by hand :) i used the search engine within this forum to look at specific types of games, opened each one up (at least 1300 of them anyhow) and wrote down info by hand which then made it to an excel spreadsheet where i calculated the sample means, standard deviations and other info and then produced histograms from there.

@orathaic - Nah. I was just wondering if somehow the current database was downloadable or not. The thought being that could be dangerous if it had active games and all the messages from games, forums posts, and PMs. A data miner/SQL expert like myslef could really do some damage with that info.

I am still hoping someone will do a statistical analysis to see how high the correlation is between squirters and stabbers. (Since that line made Fortknox laugh for 5 minutes, I thought it would fit nicely into this thread)

its exponential and the formula is as messy as the stab

Here's the latest data: http://webdiplomacy.net/webDiplomacy.net-SQLdata.zip

btw Draugnar don't worry about that, I blank out the usernames so no-one can tell who is who.

(Just kidding.. It goes without saying the database snapshots don't come with sensitive data)

my link should be down while i update the file...

and back up...

"its exponential and the formula is as messy as the stab"
LMFAO!! Great reply to a hilarious Crazyter post!! :D

glad you liked it :)

So, I downloaded the SQL database, but Microsoft Access 2010 doesn't recognize the .sql extension even though it's supposedly capable of opening it... :/

access loading that entire file into RAM will have some trouble, i suggest you try a sql server, i've had this issue myself, and always failed to access.

if you manage to open and you find a conversion system i'd love a mysql copy of the database...

I shutter at the name 'sqlserver' almost as much as 'access'. Try PostGres or MySql.

I shdder at 'Access' but ScwlServer is an industry standard (and comes as a developer edition as part of Visual Studio Professional).

Geez. Typos. "shudder" and "SqlServer"