Tag Archives: sql


I finished the revision of one paper on Monday.

Now I’m working on another paper on expertise development, but for it I want to display some graphs of participation turns over time from two different nights in Molten Core. The thing is that I found a couple of cool free web apps (amCharts and TimePlot) that do pretty graphs and such so long as the data is in the right format.

So, yesterday I spent the day converting those two nights (the first time we encountered Ragnaros and the first time we killed Ragnaros three months later) to a delimited text file so that I could import them into a sql database. I created an additional table that has attributes of the participants, such as alias, gender, class, and whether that person was an official leader.

Now I want to display a graph of activity during the fight and pre-fight times. I also want to break it down by the character attributes I listed. I want to confirm whether women participate far less than men do, etc. Or maybe it is confounded by character class or whatever.

My curent problem is that I have to relearn PHP and SQL today so that the data is formatted for the graphing software. :p

Meanwhile, my updates to this site are very irregular. Read my Twitter feed for slightly more regular updates if you so care…