]> git.sesse.net Git - wloh/commitdiff
Ignore languages that are not WLoH languages; this is marked by non-standard-length...
authorSteinar H. Gunderson <sgunderson@bigfoot.com>
Thu, 13 Dec 2012 17:48:37 +0000 (18:48 +0100)
committerSteinar H. Gunderson <sgunderson@bigfoot.com>
Thu, 13 Dec 2012 17:48:37 +0000 (18:48 +0100)
include/common.pm

index 8ec16eb26ccb8496c2b214f2d54b0271cc3941ed..f81f9840d9817e683b520eca863518123b942849 100644 (file)
@@ -93,7 +93,7 @@ sub print_navbar {
 
        print "<p style=\"font-size: smaller;\">";
 
-       my $q = $dbh->prepare('SELECT spraak, kultur FROM fotballspraak WHERE nyestesesong <> -1 ORDER BY id');
+       my $q = $dbh->prepare('SELECT spraak, kultur FROM fotballspraak WHERE nyestesesong <> -1 AND length(kultur)=5 ORDER BY id');
        $q->execute;
 
        my $first = 1;
@@ -163,7 +163,7 @@ sub get_ordinal {
 
 sub find_all_locales {
        my $dbh = shift;
-       my $q = $dbh->prepare('SELECT kultur FROM fotballspraak WHERE nyestesesong<>-1');
+       my $q = $dbh->prepare('SELECT kultur FROM fotballspraak WHERE nyestesesong <> -1 AND length(kultur)=5');
        $q->execute;
 
        my @locales = ();