Drawing some pretty graphs from scores.html files - Page 2

lch · #11 April 14th, 2008, 01:42 AM

A little preview of the future: http://valhalla.techno-mage.com/webstats.php

Not sure yet if I like Flash or Javascript graphs more...

P.S.: Zooming is done by selecting an area inside the graphs.

llamabeast · #12 June 27th, 2008, 01:52 PM

Is your valhalla.techno-mage.com site hosted by Gandalf? I can't seem to get to it at the moment.

Gandalf Parker · #13 June 27th, 2008, 02:38 PM

Yes Im afraid that it is.
Estimates are that it should be back in a week.

If lch has copies we could upload them to the other server for now

lch · #14 June 27th, 2008, 06:48 PM

Nope, I don't have backups of those scripts.
Wouldn't make any sense without the game backups, anyway, since I'd have nothing to plot graphs for.

llamabeast · #15 July 10th, 2008, 03:18 PM

Is Gandalf's server back up yet by any chance? Do you have access to those lovely scripts lch? I'd love to use them for the LlamaServer if you were happy to let me.

lch · #16 July 10th, 2008, 04:23 PM

I'm sorry, but I don't have anything that I could pass on to you right now. I can tell you how I implemented this, though. I wrote a simple parser for the scores.html files that the game can generate. For the initial per-turn charts, I used the column/bar Flash graph libraries from amCharts and for the later MySQL-backed graphs I used the JavaScript library Flotr, I think, or its predecessor Plotr. The flash graphs needed the input formatted as XML, I don't remember what the input format for the other graphs was, maybe CSV. Both could be supplied inline in the dynamically generated HTML - rendering was done on the client side. I picked both because they only require a small number of files on the webserver, so it's very manageable.

Here's a list of national colors, which you might be interested in when plotting: http://www.shrapnelcommunity.com/thr...?Number=561877

Gandalf Parker · #17 July 10th, 2008, 06:59 PM

Good timing. Yes its back and the links should all be working.

Thanks to all who donated

llamabeast · #18 July 10th, 2008, 07:29 PM

Ooh, awesome! I just looked at the graphs again, they are really sweet.

lch, now that Gandalf's server is back up, is it possible I could use your scripts? If you'd prefer me to make my own I'd understand. Yours are really cool though, and of course I'd give credit.

lch · #19 July 10th, 2008, 07:54 PM

Quote:

llamabeast said:
lch, now that Gandalf's server is back up, is it possible I could use your scripts? If you'd prefer me to make my own I'd understand. Yours are really cool though, and of course I'd give credit.

As long as you don't ask compensation from me for having to deal with my hacked together code, you can do what you want with it.

I already linked to the source code which generates the per-turn graphs on the first page. What you'll have to add is the files from amCharts. If you have some time, then I'll package the stuff together and release it, I am planning to put all my code into proper Mercurial repositories anyway. If you want the goods NOW, then I could just zip up my web folder and remove unrelated content and let you figure out the rest.

llamabeast · #20 July 11th, 2008, 05:27 AM

Thanks lch! Hmm, well I'm in no great rush really. Xietor wants me to sort out score graphs for KingMaker, but I think the main reason is to see how many capitals each nation controls, which I think this actually won't really help with (I can't remember if we've got VPs on or not, but if we have then we can see the scores in game, and if we haven't I think these graphs won't tell us capital counts - is that right?).