echo '<a href="' . $_SERVER['PHP_SELF'] . '?selected_term=' . $row['term'] . htmlspecialchars(SEP) . 'lang_code=' . $_REQUEST['lang_code'] . htmlspecialchars(SEP) . 'new_or_translated=' . $_REQUEST["new_or_translated"] . htmlspecialchars(SEP) . 'term_type=' . $_REQUEST["term_type"] . htmlspecialchars(SEP) . 'search_phase=' . $_REQUEST["search_phase"] . $submits . '#anchor" ';
if ($row['term'] == $_REQUEST["selected_term"]) {
echo 'class="selected"';
}
echo '>';
echo $row['term'];
echo '</a>' . "\n";
// }
// display if the term is new or translated
$rows_check = $languageTextDAO->getByTermAndLang($row['term'], $_REQUEST['lang_code']);
$row_check = $rows_check[0];
// check if the term is new
if ($row_check['text'] == '') {
echo ' <small>*New*</small>' . "\n";
}
// compare revised_date to see if the term is updated since last translation
if ($row_check['revised_date'] != '' && $row['revised_date'] > $row_check['revised_date']) {
echo ' <small>*Updated*</small>' . "\n";
}
echo '<br /><br/>';
// display translation form
if ($row['term'] == $_REQUEST["selected_term"]) {
trans_form();
}
echo '</li>' . "\n";
}
}
echo '</ul>' . "\n";
echo '</div>' . "\n";
}
include TR_INCLUDE_PATH . 'footer.inc.php';
function display_search_terms($variable, $term1, $lang_code, $new, $updated)
{
global $db, $addslashes, $stripslashes;
$_REQUEST['search_term'] = $addslashes($_REQUEST['search_term']);
$sql = "SELECT term, revised_date+0 AS r_date FROM " . TABLE_PREFIX . "language_text WHERE (term LIKE '%{$_REQUEST['search_term']}%' OR CAST(text AS CHAR) LIKE '%{$_REQUEST['search_term']}%') AND (language_code='{$_SESSION['language']}' OR language_code='en') GROUP BY term ORDER BY term";
$result = mysql_query($sql, $db);
$t_keys = array();
while ($row = mysql_fetch_assoc($result)) {
$t_keys[$row['term']] = $row['r_date'];
}
$sql = "SELECT *, revised_date+0 AS r_date FROM " . TABLE_PREFIX . "language_text WHERE (term LIKE '%{$_REQUEST['search_term']}%' OR CAST(text AS CHAR) LIKE '%{$_REQUEST['search_term']}%') AND (language_code='en' OR language_code='{$_SESSION['language']}') GROUP BY term ORDER BY term";
$result = mysql_query($sql, $db);
if (mysql_num_rows($result) == 0) {
echo '<ul><li>No results found.</li></ul>';
} else {
echo '<ul>';
while ($row = mysql_fetch_assoc($result)) {
if ($_SESSION['language'] != 'en') {
if ($new && $updated) {
if (!($t_keys[$row['term']] == '') && !($t_keys[$row['term']] < $row['r_date'] && $t_keys[$row['term']])) {
continue;
}
} else {
if ($new) {
if (!($t_keys[$row['term']] == '')) {
continue;
}
} else {
if ($updated) {
if (!($t_keys[$row['term']] < $row['r_date'] && $t_keys[$row['term']])) {
continue;
}
}
}
}
}
if ($row['term'] == $term1) {
trans_form('search');
echo '<li class="selected">';
} else {
echo '<li>';
}
echo '<small>';
if ($_SESSION['language'] != 'en') {
if ($t_keys[$row['term']] == '') {
echo '<b>*New*</b> ';
} else {
if ($t_keys[$row['term']] < $row['r_date']) {
echo '<b>*Updated*</b> ';
}
}
}
if ($row['term'] != $term1) {
echo '<a href="' . $_SERVER['PHP_SELF'] . '?v=' . $row['variable'] . SEP . 'search=1' . SEP . 'search_term=' . urlencode($stripslashes($_REQUEST['search_term'])) . SEP . 'k=' . $row['term'] . SEP . 'f=' . $lang_code . SEP . 'n=' . $new . SEP . 'u=' . $updated . '#anchor">';
echo $row['term'];
echo '</a>';
} else {
echo $row['term'];
}
echo '</small>';
echo '</li>';
}
echo '</ul>';
}
}
