X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=train.pl;h=e3b106b15fea1758dd109c071d2e0cdd596291b9;hb=c50bd339f0e959dc796f9a3dea2e08941ef504a5;hp=19d9271455a509d7392ae70e1342bf4e4382c7f3;hpb=5d811d8049a3f14cb586d4e9eb195de18036ded1;p=wloh diff --git a/train.pl b/train.pl index 19d9271..e3b106b 100755 --- a/train.pl +++ b/train.pl @@ -4,7 +4,8 @@ use strict; use warnings; no warnings qw(once); use POSIX; -require './config.pm'; +use lib qw( include ); +require 'config.pm'; # Find last completely done season sub find_last_season { @@ -19,7 +20,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