<?php



if (!extension_loaded('php_pdo')) {
        //if (!dl(stristr(PHP_OS, "WIN") ? "php_pdo.dll" : "php_pdo.so"))
        //    exit("Could not load the SQLite extension.\n");
}

// Load SQLite extension 
if (!extension_loaded('sqlite')) {
        if (!dl(stristr(PHP_OS, "WIN") ? "php_sqlite.dll" : "sqlite.so"))
            exit("Could not load the SQLite extension.\n");
}

$langList = array("en", "de", "it", "fr", "se", "nl");
    
$dsn = "localedb.db";
$dbh = sqlite_open($dsn, 0666, $sqliteerror);

foreach ($langList as $lang) {
    //$sql = "SELECT base, $lang  FROM locales";
    $sql = "SELECT base, $lang  FROM locales ORDER BY UPPER(base)";
    
    $rstr = '<?php' . "\n";
    
    $q = sqlite_query($dbh, $sql); 
    $rows = array(); 
    while ($r = sqlite_fetch_array($q)) { 
        //$rstr .= $r[0] . " @@ " . $r[1] . "\n";
        if (strlen($r[1]) > 0) { 
            $rstr .= '$_sl["' . $r[0] . '"] = "' . $r[1] . '";' . "\n"; 
        }
    }
    
    $rstr .= "\n" . '?>';
    //echo $rstr;
    
    $fh = fopen("language_$lang.php", "w+");
    //$fh = fopen("language_$lang.txt", "w+");
    //fwrite($fh, $rstr);    // keep output in ISO-8859-1
    fwrite($fh, utf8_encode($rstr));  // Encode output to UTF-8
    fclose($fh);    
}

sqlite_close($dbh);

?>