<?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";