score1,
score2,
ra1.rating_diff as diff1,
- ra2.rating_diff as diff2
+ ra2.rating_diff as diff2,
+ ra3.rating_diff as diff3,
+ ra4.rating_diff as diff4
from
double_results re
join double_rating ra1
and re.team1_username1=ra1.username
join double_rating ra2
on re.gametime=ra2.ratetime
- and re.team2_username1=ra2.username
+ and re.team1_username2=ra2.username
+ join double_rating ra3
+ on re.gametime=ra3.ratetime
+ and re.team2_username1=ra3.username
+ join double_rating ra4
+ on re.gametime=ra4.ratetime
+ and re.team2_username2=ra4.username
union all
select
to_char(gametime, \'IYYY-MM-DD HH24:MI\') as gametime,
score1,
score2,
ra1.rating_diff as diff1,
- ra2.rating_diff as diff2
+ null as diff2,
+ ra2.rating_diff as diff3,
+ null as diff4
from
single_results re
join single_rating ra1
order by gametime desc limit 10');
$q->execute();
while (my $ref = $q->fetchrow_hashref) {
- $ref->{'diff1'} = sprintf "%+d", int($ref->{'diff1'} + 0.5);
- $ref->{'diff2'} = sprintf "%+d", int($ref->{'diff2'} + 0.5);
+ if (defined($ref->{'diff2'})) {
+ $ref->{'diff1'} = sprintf "%+d / %+d",
+ int($ref->{'diff1'} + 0.5),
+ int($ref->{'diff2'} + 0.5);
+ $ref->{'diff2'} = sprintf "%+d / %+d",
+ int($ref->{'diff3'} + 0.5),
+ int($ref->{'diff4'} + 0.5);
+ } else {
+ $ref->{'diff1'} = sprintf "%+d", int($ref->{'diff1'} + 0.5);
+ $ref->{'diff2'} = sprintf "%+d", int($ref->{'diff3'} + 0.5);
+ }
push @last_games, $ref;
}