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>'; } }