def main(): keyFile = open("keyfile.txt") keys = keyFile.readlines() steamKey = keys[0].rstrip() keyFile.close() urlGen = SteamUrl(steamKey) con = lite.connect("players.db") pcon = Players(con) players = [ str(p[0]) for p in pcon.getPBans()] num = len(players) for i in range(len(players)/100 + 1): url = urlGen.getPlayersBans(players[i*100:(i+1)*100]) response = urllib2.urlopen(url) banInfoList = json.loads(response.read())["players"] for info in banInfoList: steamid = info["SteamId"] cBanned = info["CommunityBanned"] vBanned = info["VACBanned"] nVBans = info["NumberOfVACBans"] nGBans = info["NumberOfGameBans"] eBan = info["EconomyBan"] insertBanInfo (con, steamid, cBanned, vBanned, nVBans, nGBans, eBan) print num num -= 1