def add_results(self, rteams_r, players_r):
        scoring = Scoring()
        scoring.calculate(rteams_r, players_r)

        # add the kills/deaths to the players
        for player_id in scoring.player_kd.keys():
            self.sql.query("UPDATE players SET kills=?, deaths=? WHERE uniqueid=?", (scoring.player_kd[player_id][0], scoring.player_kd[player_yd][1], player_id))
        self.sql.commit()

        # add the scores to their teams
        for player_id in scoring.player_updates.keys(): # loop through each player
            self.sql.query("SELECT teamid FROM tpmap WHERE playerid=?", (player_id))
            for team_id in self.sql.cursor: # loop through each player, adjust score
                self.sql.query("UPDATE teams SET score=score+? WHERE uniqueid=?", (scoring.player_updates[player_id], team_id)
        self.sql.commit()