[Dean C]

My table is exactly as it is above. Right now I have this query which will give me the wins/losses for a user (thanks to a guy at sitepoint):

select sum(
         case when $id = userid1 
               and votesforuserid1 > votesforuserid2
                or $id = userid2 
               and votesforuserid1 < votesforuserid2
              then 1 else 0 end
          ) as wins  
     , sum(
         case when $id = userid1 
               and votesforuserid1 > votesforuserid2
                or $id = userid2 
               and votesforuserid1 < votesforuserid2
              then 0 else 1 end
          ) as losses  
  from battle_records 
 where $id in ( userid1 , userid2 )

Where $id is the userid in question.

The thing that i'm stuck with now is the easiest way to run that for all my users every night. Obviously running that 10,000 times is not very efficient.