<?php

// LT to <span style="border-bottom: 1px dotted black;">HTML</span> encoded characters transform function

function lt2html_parse($text) {

$search = array(

"Ą", "Č", "Ę", "Ė", "Į", "Š", "Ų", "Ū", "Ž",

"ą", "č", "ę", "ė", "į", "š", "ų", "ū", "ž");

$replace = array(

"&#260;", "&#268;", "&#280;", "&#278;", "&#302;", "&#352;", "&#370;", "&#362;", "&#381;",

"&#261;", "&#269;", "&#281;", "&#279;", "&#303;", "&#353;", "&#371;", "&#363;", "&#382;");

$text = str_replace($search, $replace, $text);

return $text;

}

 

$results = array();

$results[] = array("table" => DB_COMMENTS, "fields" => array("comment_message"));

$results[] = array(

"table" => DB_MESSAGES,

"fields" => array("message_subject","message_message")

);

$results[] = array("table" => DB_POSTS, "fields" => array("post_message"));

$results[] = array("table" => DB_SHOUTBOX, "fields" => array("shout_message"));

$results[] = array("table" => DB_THREADS, "fields" => array("thread_subject"));

foreach($results AS $result)

{

$t = $result['table']; $f = $result['fields'];

$query = dbquery("SELECT ".implode(", ",$f)." FROM $t");

while($data = dbarray($query))

{

$f_upd = "";

foreach($f AS $f_el) $f_upd .= "$f_el='".lt2html_parse($data[$f_el])."'";

dbquery("UPDATE $t SET $f_upd");

}

}

?>