When fetching auxillary parameters, index them by meaningful names and not the databa...

[wloh] / common.pm

diff --git a/common.pm b/common.pm
index 37c59a377e74f4e6cfbff38fb0e14bdb68d1c7cc..832a61173f0f85932e164d0f828742ac78862df6 100644 (file)
--- a/common.pm
+++ b/common.pm
@@ -4,6 +4,13 @@ use POSIX;
 
 package wloh_common;
 
+sub get_max_season {
+       my ($dbh, $locale) = @_;
+       my $ref = $dbh->selectrow_hashref('SELECT MAX(sesong) AS max_sesong FROM fotballserier se JOIN fotballspraak sp ON se.spraak=sp.id WHERE kultur=?',
+               undef, $locale);
+       return $ref->{'max_sesong'};
+}
+
 sub output_last_sync {
        my $dbh = shift;
        my $ref = $dbh->selectrow_hashref('SELECT EXTRACT(EPOCH FROM last_sync) AS last_sync FROM last_sync');
@@ -15,4 +22,11 @@ sub output_last_sync {
        }
 }
 
+sub get_locale {
+       my $cgi = shift;
+       my $url = $cgi->url(-absolute => 1);
+       $url =~ m#^/([a-z][a-z]-[A-Z][A-Z])/# or die "Invalid locale!";
+       return $1;
+}
+
 1;