From 1fac0677bbcba5dec26e11aa661c97e38f6c3d40 Mon Sep 17 00:00:00 2001
From: "Steinar H. Gunderson" <sgunderson@bigfoot.com>
Date: Sat, 9 Jun 2012 12:13:04 +0200
Subject: [PATCH] Pick old results from fotballresultater_2123.

---
 sync.pl      | 1 +
 train.pl     | 2 +-
 www/index.pl | 2 +-
 3 files changed, 3 insertions(+), 2 deletions(-)

diff --git a/sync.pl b/sync.pl
index 178866d..d57af44 100755
--- a/sync.pl
+++ b/sync.pl
@@ -53,6 +53,7 @@ $sdbh->{RaiseError} = 1;
 sync_table($mdbh, $sdbh, "Fotballbrukere");
 sync_table($mdbh, $sdbh, "Fotballdeltagere");
 sync_table($mdbh, $sdbh, "Fotballresultater");
+sync_table($mdbh, $sdbh, "Fotballresultater_2123");
 sync_table($mdbh, $sdbh, "Fotballserier");
 
 # Just for backup.
diff --git a/train.pl b/train.pl
index 19d9271..aaafde4 100755
--- a/train.pl
+++ b/train.pl
@@ -19,7 +19,7 @@ sub fetch_games {
 SELECT
   deltager1.id as p1, deltager2.id as p2, maalfor, maalmot, least(pow(2.0, (sesong - ? + 3) / 3.0), 1.0) AS vekt
 FROM
-  Fotballresultater resultater
+  ( SELECT * FROM fotballresultater UNION ALL SELECT * FROM fotballresultater_2123 ) resultater
   JOIN Fotballdeltagere deltager1 ON resultater.Lagrecno=deltager1.Nr AND resultater.Serie=deltager1.Serie
   JOIN Fotballdeltagere deltager2 ON resultater.Motstander=deltager2.Nr AND resultater.Serie=deltager2.Serie
   JOIN Fotballserier serier ON resultater.Serie=serier.Nr
diff --git a/www/index.pl b/www/index.pl
index 9bf692c..a039cea 100755
--- a/www/index.pl
+++ b/www/index.pl
@@ -135,7 +135,7 @@ sub get_matches {
 	my $q = $dbh->prepare('
 	SELECT
 	  d1.id AS p1, d2.id AS p2, maalfor AS score1, maalmot AS score2
-	FROM fotballresultater r
+	FROM ( SELECT * FROM fotballresultater UNION ALL SELECT * FROM fotballresultater_2123 ) r
 	  JOIN fotballserier s ON r.serie=s.nr
           JOIN fotballspraak sp ON s.spraak=sp.id
 	  JOIN fotballdeltagere d1 ON r.lagrecno=d1.nr AND r.serie=d1.serie
-- 
2.39.2