/** Gets TTranslationEntry object by property $property_name with value $property_value.
* @return TTranslationEntry or NULL in case of error
*/
public static function getTranslationEntry($property_name, $property_value, $translation_obj = NULL)
{
global $LINK_DB;
$query = "SELECT * FROM translation_entry WHERE `{$property_name}`='{$property_value}' order by id";
$result = $LINK_DB->query_e($query, "Query failed in " . __METHOD__ . " in file <b>" . __FILE__ . "</b>, string <b>" . __LINE__ . "</b>");
if ($LINK_DB->query_count($result) == 0) {
return NULL;
}
$translationEntry_arr = array();
while ($row = $result->fetch_object()) {
if ($translation_obj == NULL) {
$translation_obj = TTranslation::getByID($row->translation_id);
}
$translationEntry_arr[] = new TTranslationEntry($row->id, $translation_obj, TLang::getByID($row->lang_id), TWikiText::getByID($row->wiki_text_id));
}
return $translationEntry_arr;
}
/** Gets TRelation object by property $property_name with value $property_value.
* @return TRelation or NULL in case of error
*/
public static function getRelation($property_name, $property_value, $meaning_obj = NULL)
{
global $LINK_DB;
$query = "SELECT * FROM relation WHERE `{$property_name}`='{$property_value}' order by id";
$result = $LINK_DB->query_e($query, "Query failed in " . __METHOD__ . " in file <b>" . __FILE__ . "</b>, string <b>" . __LINE__ . "</b>");
if ($LINK_DB->query_count($result) == 0) {
return NULL;
}
$relation_arr = array();
while ($row = $result->fetch_object()) {
/*
if ($meaning_obj == NULL)
$meaning_obj = TMeaning::getByID($row->meaning_id);
*/
$relation_arr[] = new TRelation($row->id, $meaning_obj, TWikiText::getByID($row->wiki_text_id), TRelationType::getByID($row->relation_type_id), $row->meaning_summary);
}
return $relation_arr;
}
/** Gets TMeaning object by property $property_name with value $property_value.
* @return TMeaning or NULL in case of error
*/
public static function getMeaning($property_name, $property_value, $lang_pos_obj = NULL)
{
global $LINK_DB;
$query = "SELECT * FROM meaning WHERE `{$property_name}`='{$property_value}' order by id";
$result = $LINK_DB->query_e($query, "Query failed in " . __METHOD__ . " in file <b>" . __FILE__ . "</b>, string <b>" . __LINE__ . "</b>");
if ($LINK_DB->query_count($result) == 0) {
return NULL;
}
$meaning_arr = array();
while ($row = $result->fetch_object()) {
/*
if ($lang_pos_obj == NULL)
$lang_pos_obj = TLangPOS::getByID($row->lang_pos_id);
*/
$meaning = new TMeaning($row->id, $lang_pos_obj, $row->lang_pos_id, $row->meaning_n, TWikiText::getByID($row->wiki_text_id), $row->wiki_text_id);
$meaning->relation = TRelation::getByMeaning($row->id, $meaning);
$meaning->translation = TTranslation::getByMeaning($row->id, $meaning);
$meaning->label_meaning = TLabelMeaning::getByMeaning($row->id, $meaning);
$meaning_arr[] = $meaning;
}
return $meaning_arr;
}
echo $substring;
?>
"></p>
<p><input type="submit" name="view_list" value="view"></p>
</form>
<?php
if (isset($view_list) && $view_list) {
$query = "SELECT meaning.id as meaning_id, page_title, text FROM page, lang_pos, meaning, wiki_text WHERE lang_pos.page_id=page.id and meaning.lang_pos_id=lang_pos.id and meaning.wiki_text_id=wiki_text.id " . " and text like '%{$substring}%' order by text";
// LIMIT $limit
$result = $link_db->query_e($query, "Query failed in file <b>" . __FILE__ . "</b>, string <b>" . __LINE__ . "</b>");
print "<p>" . $link_db->query_count($result) . " definitions are found</p><table border=1>\n";
$counter = 0;
while ($row = $result->fetch_object()) {
// LABELS OF MEANING
$label_name_arr = array();
/*
$labelMeaning_arr = TMeaning::getByID($row->meaning_id)->getLabelMeaning();
if (is_array($labelMeaning_arr)) foreach ($labelMeaning_arr as $labelMeaningObj)
$label_name_arr[] = "<span title=\"".$labelMeaningObj->getLabel()->getName()."\">".$labelMeaningObj->getLabel()->getShortName()."</span>";
*/
$query = "SELECT id, short_name, name FROM label, label_meaning WHERE label_meaning.label_id=label.id and label_meaning.meaning_id=" . (int) $row->meaning_id;
$res_label = $link_db->query_e($query, "Query failed in file <b>" . __FILE__ . "</b>, string <b>" . __LINE__ . "</b>");
while ($row_label = $res_label->fetch_object()) {
$label_name_arr[] = "<span title=\"" . $row_label->name . "\">" . $row_label->short_name . "</span>";
}
print "<tr><td>" . ++$counter . ".</td><td>" . TPage::getURL($row->page_title) . "</td><td>" . join(', ', $label_name_arr) . "</td><td>" . TWikiText::selectText($row->text, $substring, "<span style='font-weight:bold; color:#FF00FF'>", "</span>") . "</td></tr>\n";
}
print "</table><BR>";
}
include LIB_DIR . "footer.php";
<?php require "../../config.php"; $string = '# выражает доведение объекта действия с помощью длительного и/или интенсивного действия, названного мотивирующим глаголом, до нежелательного состояния (крайней усталости, бессилия, исчерпанности) или состояния невозможности продолжения действия: убегаться, укачать, уреветься, уходиться.'; $substring = 'об%т'; print TWikiText::selectText($string, $substring);
