<?php require_once '../../phplib/util.php'; assert_options(ASSERT_BAIL, 1); debug_off(); $dbResult = mysql_query("select * from lexems where lexem_id not in " . "(select LexemId from LexemDefinitionMap, Definition " . "where DefinitionId = Definition.Id " . "and SourceId not in (6, 8) and Status = 0)"); $seen = 0; $split = 0; while (($dbRow = mysql_fetch_assoc($dbResult)) != null) { $l = Lexem::createFromDbRow($dbRow); $defs = Definition::loadByLexemId($l->id); if (!count($defs)) { continue; } $seen++; // Remove the -ul accent where possible. if (text_endsWith($l->form, 'ul')) { $form = substr($l->form, 0, strlen($l->form) - 2); $otherLexems = Lexem::loadByForm($form); if (count($otherLexems)) { print "REMOVING -UL FROM: {$l->form}\n"; foreach ($otherLexems as $otherLexem) { foreach ($defs as $def) { LexemDefinitionMap::associate($otherLexem->id, $def->id); } } $l->delete(); $split++; continue; } }
<?php require_once '../../phplib/util.php'; $PLURAL_INFLECTIONS = array(3, 11, 19, 27, 35); $SOURCES = loadSources(); define('DRY_RUN', true); $dbResult = mysql_query('select * from lexems where (lexem_model_type = "T") or (lexem_model_type in ("MQ", "FQ", "NQ") and lexem_restriction like "%P%")' . 'order by lexem_neaccentuat'); $found = 0; while ($row = mysql_fetch_assoc($dbResult)) { $lexem = Lexem::createFromDbRow($row); $wordLists = WordList::loadByUnaccented($lexem->unaccented); $matchingWordLists = array(); foreach ($wordLists as $wl) { if (in_array($wl->inflectionId, $PLURAL_INFLECTIONS) && $wl->lexemId != $lexem->id) { $matchingWordLists[] = $wl; } } if (count($matchingWordLists)) { $sources = getSourcesForLexem($lexem); print "{$lexem->unaccented} {$lexem->modelType}{$lexem->modelNumber}{$lexem->restriction} {$sources} " . "http://dexonline.ro/admin/lexemEdit.php?lexemId={$lexem->id}\n"; foreach ($matchingWordLists as $wl) { $match = Lexem::load($wl->lexemId); $sources = getSourcesForLexem($match); print " * {$match->unaccented} {$match->modelType}{$match->modelNumber}{$match->restriction} {$sources}" . "http://dexonline.ro/admin/lexemEdit.php?lexemId={$match->id}\n"; } $found++; } } print "{$found} lexeme semnalate.\n"; /**************************************************************/ function loadSources()