<?php

$ISO_CHARS_1 = array (
    '&#261;' => 'ą',
    '&#260;' => 'Ą',
    '&#263;' => 'ć',
    '&#262;' => 'Ć',
    '&#281;' => 'ę',
    '&#280;' => 'Ę',
    '&#322;' => 'ł',
    '&#321;' => 'Ł',
    '&#324;' => 'ń',
    '&#323;' => 'Ń',
    '&#243;' => 'ó',
    '&#211;' => 'Ó',
    '&#347;' => 'ś',
    '&#346;' => 'Ś',
    '&#378;' => 'ź',
    '&#377;' => 'Ź',
    '&#380;' => 'ż',
    '&#379;' => 'Ż',
);

$ISO_CHARS_2 = array (
    '&#261' => 'ą',
    '&#260' => 'Ą',
    '&#263' => 'ć',
    '&#262' => 'Ć',
    '&#281' => 'ę',
    '&#280' => 'Ę',
    '&#322' => 'ł',
    '&#321' => 'Ł',
    '&#324' => 'ń',
    '&#323' => 'Ń',
    '&#243' => 'ó',
    '&#211' => 'Ó',
    '&#347' => 'ś',
    '&#346' => 'Ś',
    '&#378' => 'ź',
    '&#377' => 'Ź',
    '&#380' => 'ż',
    '&#379' => 'Ż',
);

//-------------------------------------------------------------------

$fn = fopen('comments.txt', 'r') or die('I can not open the file.');

$db = new SQLite3('aol.db');
$db->exec("CREATE TABLE IF NOT EXISTS comments(id INTEGER PRIMARY KEY, news_id INTEGER, author TEXT, email TEXT, ip TEXT, content TEXT)");
$stm = $db->prepare("INSERT or REPLACE INTO comments(id, news_id, author, email, ip, content) VALUES (?, ?, ?, ?, ?, ?)");
$stm->bindParam(1, $id);
$stm->bindParam(2, $newsId);
$stm->bindParam(3, $author);
$stm->bindParam(4, $email);
$stm->bindParam(5, $ip);
$stm->bindParam(6, $content);

while(!feof($fn))  {
    $rLine = fgets($fn);
    if ($rLine) {
        $arrCommentsRow = explode('|>|', $rLine);
        if (strlen($arrCommentsRow[1]) > 1) {

            $row = $arrCommentsRow[1];
            $row = mb_convert_encoding($row, 'UTF-8', 'ISO-8859-2');
            $row = strtr($row, $ISO_CHARS_1);
            $row = strtr($row, $ISO_CHARS_2);            
            $newsId = intval($arrCommentsRow[0]);

            $arrComments = explode('||', $row);
            foreach ($arrComments as $comment){
                if (strlen($comment) > 1) {
                    $arrComment = explode('|', $comment);
                    $id         = intval($arrComment[0]);
                    $author     = $arrComment[1];
                    $email      = $arrComment[2];
                    $ip         = $arrComment[3];
                    $content    = $arrComment[4];
                    $stm->execute();
                }
            }  
        }
    }
}

fclose($fn);