Implemented support for multilingual releases

The 'language' column in releases_rev has been replaced with a
releases_lang table. As this is quite a big change, there may still
be bugs floating around somewhere.

1 files changed, 3 insertions, 3 deletions

diff --git a/lib/VNDB/DB/Misc.pm b/lib/VNDB/DB/Misc.pm
index c13a38d2..1c21675e 100644
--- a/lib/VNDB/DB/Misc.pm
+++ b/lib/VNDB/DB/Misc.pm
@@ -163,10 +163,10 @@ sub dbItemMod {
 sub dbLanguages {
   my $self = shift;
   return [
-    map $_->{language}, @{$self->dbAll(q|
-      SELECT DISTINCT rr.language
+    map $_->{lang}, @{$self->dbAll(q|
+      SELECT DISTINCT rl.lang
         FROM releases r
-        JOIN releases_rev rr ON rr.id = r.latest
+        JOIN releases_lang rl ON rl.rid = r.latest
         WHERE r.hidden = FALSE|
     )}
   ];