<?php
require_once "../../phplib/util.php";
$result = logged_query("select * from words");
$count = 0;
while ($row = mysql_fetch_assoc($result)) {
$def = $row['def'];
// echo "DEF: [$def]\n";
$def = text_internalizeDefinition($def);
// echo "INT: [$def]\n";
$htmlDef = text_htmlize($def);
// echo "HTM: [$htmlDef]\n";
$dname = text_internalizeDname($row['dname']);
// echo "DNM: [$dname]\n";
// TODO: Internalize the dname too, fix dname search
logged_query("update words set def = '" . addslashes($def) . "', " . "htmlDef = '" . addslashes($htmlDef) . "', " . "dname = '" . addslashes($dname) . "' " . "where counter = " . $row['counter']);
$count++;
if ($count % 1000 == 0) {
echo "Processed {$count} definitions.\n";
}
}
echo "Done! Processed {$count} definitions.\n";
<?php
require_once "../../phplib/util.php";
$result = logged_query("select * from words " . "where def like '%<%' or def like '%>%'");
$count = 0;
while ($row = mysql_fetch_assoc($result)) {
$def = $row['def'];
$htmlDef = text_htmlize($def);
logged_query("update words set htmlDef = '" . addslashes($htmlDef) . "' " . "where counter = " . $row['counter']);
$count++;
if ($count % 50 == 0) {
echo "Processed {$count} definitions.\n";
}
}
echo "Done! Processed {$count} definitions.\n";
}
}
if ($migrateAll) {
mysql_query("delete from transforms where transf_from != ''" . "or transf_to != ''");
}
$query = $migrateAll ? "select * from models where model_type not in ('I', 'T')" : "select models.* from models left outer join model_description " . "on model_id = md_model where md_model is null";
$dbResult = logged_query($query);
$numModels = 0;
while ($dbRow = mysql_fetch_assoc($dbResult)) {
$model = new Model();
$model->populateFromDbRow($dbRow);
//print "{$model->modelType} {$model->number}\n";
// Load all the DMLR model records
mysql_query("delete from model_description where md_model = {$model->id}");
$query = "select form, infl_id, variant, is_baseform from dmlr_models " . "where model_type = '{$model->modelType}' " . "and model_no = '" . addslashes($model->number) . "' order by infl_id";
$dmlrDbResult = logged_query($query);
$results = db_getArray($dmlrDbResult);
$baseForm = null;
foreach ($results as $row) {
$form = $row['form'];
$variant = $row['variant'];
$inflId = $row['infl_id'];
$isBaseForm = $row['is_baseform'];
if ($baseForm && $isBaseForm) {
die("Incorrect baseform for {$model->modelType}{$model->number}\n");
}
if (!$baseForm) {
$baseForm = $form;
}
if (text_contains($baseForm, "'") ^ text_contains($form, "'")) {
print "Incomplete accents for {$baseForm} => {$form}\n";
