from urllib import urlopen
from json import loads
apis = ["http://www.pikminwiki.com/api.php","http://bulbapedia.bulbagarden.net/w/api.php","http://www.donkeykongwiki.com/api.php","http://www.fireemblemwiki.org/api.php","http://mutecity.org/w/api.php","http://goldensunwiki.net/api.php","http://www.kidicaruswiki.org/api.php","http://www.starfoxwiki.org/w/api.php","http://www.metroidwiki.org/w/api.php","http://www.niwanetwork.org/wiki/api.php","http://nookipedia.com/w/api.php","http://www.pikminfanon.com/api.php","http://www.ssbwiki.com/api.php","http://www.starfywiki.org/api.php","http://strategywiki.org/w/api.php","http://www.mariowiki.com/api.php","http://www.wikibound.info/api.php","http://wikirby.com/api.php","http://www.zeldawiki.org/api.php","http://dragon-quest.org/w/api.php"]
labels = ["Pikipedia","Bulbapedia","Donkey Kong Wiki","Fire Emblem Wiki","F-Zero Wiki","Golden Sun Universe","Icaruspedia","Lylat Wiki","Metroid Wiki","Nintendo Wiki","Nookipedia","Pikmin Fanon Wiki","Smash Wiki","Starfy Wiki","Strategy Wiki","Mario Wiki","Wikibound","Wikirby","Zelda Wiki","Dragon Quest Wiki"]
cats = ['articles','edits','images','users','activeusers','admins']
totals = [0,0,0,0,0,0]
f = open("niwa_stats.html","w")
f.write('<html><head><title>NIWA Statistics</title></head><body><table border="1"><tr><td colspan="7">NIWA Statistics</td></tr><tr><td>Wiki Name</td><td>Articles</td><td>Edits</td><td>Media</td><td>Users</td><td>Active Users</td><td>Admins</td></tr>')
for idx, val in enumerate(apis):
f.write('<tr><td>' + labels[idx] + '</td>')
for idy, cat in enumerate(cats):
x = loads(urlopen(val + '?format=json&action=query&meta=siteinfo&siprop=statistics').read().decode())['query']['statistics'][cat]
f.write('<td>' + str(x) + '</td>')
totals[idy] += x
f.write('</tr>')
f.write('<tr><td>Totals</td>')
for t in totals:
f.write('<td>' + str(t) + '</td>')
f.write('</tr></table></body></html>')
f.close()