require_once( 'settings.inc.php' );

require_once( 'connect.inc.php' );

require_once( 'dbutils.inc.php' );

require_once( 'utilities.inc.php' );

require_once( 'simterms.inc.php' );

$currentlang = validateLang(processDBParam("filterlang",'currentlanguage','',0));

$currentsort = processDBParam("sort",'currentwordsort','1',1);

$currentpage = processSessParam("page","currentwordpage",'1',1);

$currentquery = processSessParam("query","currentwordquery",'',0);

$currentquerymode = processSessParam("query_mode","currentwordquerymode",'term,rom,transl',0);

$currentregexmode = getSettingWithDefault("set-regex-mode");

$currentstatus = processSessParam("status","currentwordstatus",'',0);

$currenttext = validateText(processSessParam("text","currentwordtext",'',0));

$currenttexttag = processSessParam("texttag","currentwordtexttag",'',0);

$currenttextmode = processSessParam("text_mode","currentwordtextmode",0,0);

$currenttag1 = validateTag(processSessParam("tag1","currentwordtag1",'',0),$currentlang);

$currenttag2 = validateTag(processSessParam("tag2","currentwordtag2",'',0),$currentlang);

$currenttag12 = processSessParam("tag12","currentwordtag12",'',0);

$wh_lang = ($currentlang != '') ? (' and WoLgID=' . $currentlang ) : '';

$wh_stat = ($currentstatus != '') ? (' and ' . makeStatusCondition('WoStatus', $currentstatus)) : '';

$wh_query = $currentregexmode . 'like ' . convert_string_to_sqlsyntax(($currentregexmode == '') ? (str_replace("*","%",mb_strtolower($currentquery, 'UTF-8'))) : ($currentquery));

switch($currentquerymode){

case 'term,rom,transl':

$wh_query=' and (WoText ' . $wh_query . ' or IFNULL(WoRomanization,\'*\') ' . $wh_query . ' or WoTranslation ' . $wh_query . ')';

break;

case 'term,rom':

$wh_query=' and (WoText ' . $wh_query . ' or IFNULL(WoRomanization,\'*\') ' . $wh_query . ')';

break;

case 'rom,transl':

$wh_query=' and (IFNULL(WoRomanization,\'*\') ' . $wh_query . ' or WoTranslation ' . $wh_query . ')';

break;

case 'term,transl':

$wh_query=' and (WoText ' . $wh_query . ' or WoTranslation ' . $wh_query . ')';

break;

case 'term':

$wh_query=' and (WoText ' . $wh_query . ')';

break;

case 'rom':

$wh_query=' and (IFNULL(WoRomanization,\'*\') ' . $wh_query . ')';

break;

case 'transl':

$wh_query=' and (WoTranslation ' . $wh_query . ')';

break;

}

if($currentquery!==''){

if($currentregexmode!==''){

if(@mysqli_query($GLOBALS["DBCONNECTION"], 'select "test" rlike ' . convert_string_to_sqlsyntax($currentquery))===false){

$currentquery='';

$wh_query = '';

unset($_SESSION['currentwordquery']);

if(isset($_REQUEST['query']))echo '<p id="hide3" style="color:red;text-align:center;">+++ Warning: Invalid Search +++</p>';

}

}

}

else $wh_query = '';

if ($currenttag1 == '' && $currenttag2 == '')

$wh_tag = '';

else {

if ($currenttag1 != '') {

if ($currenttag1 == -1)

$wh_tag1 = "group_concat(WtTgID) IS NULL";

else

$wh_tag1 = "concat('/',group_concat(WtTgID separator '/'),'/') like '%/" . $currenttag1 . "/%'";

}

if ($currenttag2 != '') {

if ($currenttag2 == -1)

$wh_tag2 = "group_concat(WtTgID) IS NULL";

else

$wh_tag2 = "concat('/',group_concat(WtTgID separator '/'),'/') like '%/" . $currenttag2 . "/%'";

}

if ($currenttag1 != '' && $currenttag2 == '')

$wh_tag = " having (" . $wh_tag1 . ') ';

elseif ($currenttag2 != '' && $currenttag1 == '')

$wh_tag = " having (" . $wh_tag2 . ') ';

else

$wh_tag = " having ((" . $wh_tag1 . ($currenttag12 ? ') AND (' : ') OR (') . $wh_tag2 . ')) ';

}

$no_pagestart =

(getreq('markaction') == 'exp') ||

(getreq('markaction') == 'exp2') ||

(getreq('markaction') == 'exp3') ||

(getreq('markaction') == 'test') ||

(getreq('markaction') == 'deltag') ||

(getreq('allaction') == 'expall') ||

(getreq('allaction') == 'expall2') ||

(getreq('allaction') == 'expall3') ||

(getreq('allaction') == 'testall') ||

(getreq('allaction') == 'deltagall');

if (! $no_pagestart) {

pagestart('My ' . getLanguage($currentlang) . ' Terms (Words and Expressions)',true);

}

$message = '';

if (isset($_REQUEST['markaction'])) {

$markaction = $_REQUEST['markaction'];

$actiondata = stripTheSlashesIfNeeded(getreq('data'));

$message = "Multiple Actions: 0";

if (isset($_REQUEST['marked'])) {

if (is_array($_REQUEST['marked'])) {

$l = count($_REQUEST['marked']);

if ($l > 0 ) {

$list = "(" . $_REQUEST['marked'][0];

for ($i=1; $i<$l; $i++) $list .= "," . $_REQUEST['marked'][$i];

$list .= ")";

if ($markaction == 'del') {

$message = runsql('delete from ' . $tbpref . 'words where WoID in ' . $list, "Deleted");

do_mysqli_query ('update ' . $tbpref . 'textitems2 set Ti2WoID = 0 where Ti2WordCount = 1 and Ti2WoID in ' . $list);

do_mysqli_query ('delete from ' . $tbpref . 'textitems2 where Ti2WoID in ' . $list);

adjust_autoincr('words','WoID');

runsql("DELETE " . $tbpref . "wordtags FROM (" . $tbpref . "wordtags LEFT JOIN " . $tbpref . "words on WtWoID = WoID) WHERE WoID IS NULL",'');

}

elseif ($markaction == 'addtag' ) {

$message = addtaglist($actiondata,$list);

}

elseif ($markaction == 'deltag' ) {

$message = removetaglist($actiondata,$list);

header("Location: edit_words.php");

exit();

}

elseif ($markaction == 'spl1' ) {

$message = runsql('update ' . $tbpref . 'words set WoStatus=WoStatus+1, WoStatusChanged = NOW(),' . make_score_random_insert_update('u') . ' where WoStatus in (1,2,3,4) and WoID in ' . $list, "Updated Status (+1)");

}

elseif ($markaction == 'smi1' ) {

$message = runsql('update ' . $tbpref . 'words set WoStatus=WoStatus-1, WoStatusChanged = NOW(),' . make_score_random_insert_update('u') . ' where WoStatus in (2,3,4,5) and WoID in ' . $list, "Updated Status (-1)");

}

elseif ($markaction == 's5' ) {

$message = runsql('update ' . $tbpref . 'words set WoStatus=5, WoStatusChanged = NOW(),' . make_score_random_insert_update('u') . ' where WoID in ' . $list, "Updated Status (=5)");

}

elseif ($markaction == 's1' ) {

$message = runsql('update ' . $tbpref . 'words set WoStatus=1, WoStatusChanged = NOW(),' . make_score_random_insert_update('u') . ' where WoID in ' . $list, "Updated Status (=1)");

}

elseif ($markaction == 's99' ) {

$message = runsql('update ' . $tbpref . 'words set WoStatus=99, WoStatusChanged = NOW(),' . make_score_random_insert_update('u') . ' where WoID in ' . $list, "Updated Status (=99)");

}

elseif ($markaction == 's98' ) {

$message = runsql('update ' . $tbpref . 'words set WoStatus=98, WoStatusChanged = NOW(),' . make_score_random_insert_update('u') . ' where WoID in ' . $list, "Updated Status (=98)");

}

elseif ($markaction == 'today' ) {

$message = runsql('update ' . $tbpref . 'words set WoStatusChanged = NOW(),' . make_score_random_insert_update('u') . ' where WoID in ' . $list, "Updated Status Date (= Now)");

}

elseif ($markaction == 'delsent' ) {

$message = runsql('update ' . $tbpref . 'words set WoSentence = NULL where WoID in ' . $list, "Term Sentence(s) deleted");

}

elseif ($markaction == 'lower' ) {

$message = runsql('update ' . $tbpref . 'words set WoText = WoTextLC where WoID in ' . $list, "Term(s) set to lowercase");

}

elseif ($markaction == 'cap' ) {

$message = runsql('update ' . $tbpref . 'words set WoText = CONCAT(UPPER(LEFT(WoTextLC,1)),SUBSTRING(WoTextLC,2)) where WoID in ' . $list, "Term(s) capitalized");

}

elseif ($markaction == 'exp' ) {

anki_export('select distinct WoID, LgRightToLeft, LgRegexpWordCharacters, LgName, WoText, WoTranslation, WoRomanization, WoSentence, ifnull(group_concat(distinct TgText order by TgText separator \' \'),\'\') as taglist from ((' . $tbpref . 'words left JOIN ' . $tbpref . 'wordtags ON WoID = WtWoID) left join ' . $tbpref . 'tags on TgID = WtTgID), ' . $tbpref . 'languages where WoLgID = LgID AND WoTranslation != \'\' AND WoTranslation != \'*\' and WoSentence like concat(\'%{\',WoText,\'}%\') and WoID in ' . $list . ' group by WoID');

}

elseif ($markaction == 'exp2' ) {

tsv_export('select distinct WoID, LgName, WoText, WoTranslation, WoRomanization, WoSentence, WoStatus, ifnull(group_concat(distinct TgText order by TgText separator \' \'),\'\') as taglist from ((' . $tbpref . 'words left JOIN ' . $tbpref . 'wordtags ON WoID = WtWoID) left join ' . $tbpref . 'tags on TgID = WtTgID), ' . $tbpref . 'languages where WoLgID = LgID and WoID in ' . $list . ' group by WoID');

}

elseif ($markaction == 'exp3' ) {

flexible_export('select distinct WoID, LgName, LgExportTemplate, LgRightToLeft, WoText, WoTextLC, WoTranslation, WoRomanization, WoSentence, WoStatus, ifnull(group_concat(distinct TgText order by TgText separator \' \'),\'\') as taglist from ((' . $tbpref . 'words left JOIN ' . $tbpref . 'wordtags ON WoID = WtWoID) left join ' . $tbpref . 'tags on TgID = WtTgID), ' . $tbpref . 'languages where WoLgID = LgID and WoID in ' . $list . ' group by WoID');

}

elseif ($markaction == 'test' ) {

$_SESSION['testsql'] = ' ' . $tbpref . 'words where WoID in ' . $list . ' ';

header("Location: do_test.php?selection=1");

exit();

}

}

}

}

}

if (isset($_REQUEST['allaction'])) {

$allaction = $_REQUEST['allaction'];

$actiondata = stripTheSlashesIfNeeded(getreq('data'));

if ($allaction == 'delall' || $allaction == 'spl1all' || $allaction == 'smi1all' || $allaction == 's5all' || $allaction == 's1all' || $allaction == 's99all' || $allaction == 's98all' || $allaction == 'todayall' || $allaction == 'addtagall' || $allaction == 'deltagall' || $allaction == 'delsentall' || $allaction == 'lowerall' || $allaction == 'capall') {

if ($currenttext == '') {

$sql = 'select distinct WoID from (' . $tbpref . 'words left JOIN ' . $tbpref . 'wordtags ON WoID = WtWoID) where (1=1) ' . $wh_lang . $wh_stat . $wh_query . ' group by WoID ' . $wh_tag;

} else {

$sql = 'select distinct WoID from (' . $tbpref . 'words left JOIN ' . $tbpref . 'wordtags ON WoID = WtWoID), ' . $tbpref . 'textitems2 where Ti2LgID = WoLgID and Ti2WoID = WoID and Ti2TxID in (' . $currenttext. ')' . $wh_lang . $wh_stat . $wh_query . ' group by WoID ' . $wh_tag;

}

$cnt=0;

$res = do_mysqli_query($sql);

while ($record = mysqli_fetch_assoc($res)) {

$id = $record['WoID'];

$message='0';

if ($allaction == 'delall' ) {

$message = runsql('delete from ' . $tbpref . 'words where WoID = ' . $id, "");

do_mysqli_query ('update ' . $tbpref . 'textitems2 set Ti2WoID = 0 where Ti2WordCount = 1 and Ti2WoID = ' . $id);

do_mysqli_query ('delete from ' . $tbpref . 'textitems2 where Ti2WoID = ' . $id);

}

elseif ($allaction == 'addtagall' ) {

addtaglist($actiondata,'(' . $id . ')');

$message = 1;

}

elseif ($allaction == 'deltagall' ) {

removetaglist($actiondata,'(' . $id . ')');

$message = 1;

}

elseif ($allaction == 'spl1all' ) {

$message = runsql('update ' . $tbpref . 'words set WoStatus=WoStatus+1, WoStatusChanged = NOW(),' . make_score_random_insert_update('u') . ' where WoStatus in (1,2,3,4) and WoID = ' . $id, "");

}

elseif ($allaction == 'smi1all' ) {

$message = runsql('update ' . $tbpref . 'words set WoStatus=WoStatus-1, WoStatusChanged = NOW(),' . make_score_random_insert_update('u') . ' where WoStatus in (2,3,4,5) and WoID = ' . $id, "");

}

elseif ($allaction == 's5all' ) {

$message = runsql('update ' . $tbpref . 'words set WoStatus=5, WoStatusChanged = NOW(),' . make_score_random_insert_update('u') . ' where WoID = ' . $id, "");

}

elseif ($allaction == 's1all' ) {

$message = runsql('update ' . $tbpref . 'words set WoStatus=1, WoStatusChanged = NOW(),' . make_score_random_insert_update('u') . ' where WoID = ' . $id, "");

}

elseif ($allaction == 's99all' ) {

$message = runsql('update ' . $tbpref . 'words set WoStatus=99, WoStatusChanged = NOW(),' . make_score_random_insert_update('u') . ' where WoID = ' . $id, "");

}

elseif ($allaction == 's98all' ) {

$message = runsql('update ' . $tbpref . 'words set WoStatus=98, WoStatusChanged = NOW(),' . make_score_random_insert_update('u') . ' where WoID = ' . $id, "");

}

elseif ($allaction == 'todayall' ) {

$message = runsql('update ' . $tbpref . 'words set WoStatusChanged = NOW(),' . make_score_random_insert_update('u') . ' where WoID = ' . $id, "");

}

elseif ($allaction == 'delsentall' ) {

$message = runsql('update ' . $tbpref . 'words set WoSentence = NULL where WoID = ' . $id, "");

}

elseif ($allaction == 'lowerall' ) {

$message = runsql('update ' . $tbpref . 'words set WoText = WoTextLC where WoID = ' . $id, "");

}

elseif ($allaction == 'capall' ) {

$message = runsql('update ' . $tbpref . 'words set WoText = CONCAT(UPPER(LEFT(WoTextLC,1)),SUBSTRING(WoTextLC,2)) where WoID = ' . $id, "");

}

$cnt += (int)$message;

}

mysqli_free_result($res);

if ($allaction == 'deltagall') {

header("Location: edit_words.php");

exit();

}

if ($allaction == 'addtagall') {

$message = "Tag added in $cnt Terms";

}

else if ($allaction == 'delall') {

$message = "Deleted: $cnt Terms";

adjust_autoincr('words','WoID');

runsql("DELETE " . $tbpref . "wordtags FROM (" . $tbpref . "wordtags LEFT JOIN " . $tbpref . "words on WtWoID = WoID) WHERE WoID IS NULL",'');

}

else {

$message = "$cnt Terms changed";

}

}

elseif ($allaction == 'expall' ) {

if ($currenttext == '') {

anki_export('select distinct WoID, LgRightToLeft, LgRegexpWordCharacters, LgName, WoText, WoTranslation, WoRomanization, WoSentence, ifnull(group_concat(distinct TgText order by TgText separator \' \'),\'\') as taglist from ((' . $tbpref . 'words left JOIN ' . $tbpref . 'wordtags ON WoID = WtWoID) left join ' . $tbpref . 'tags on TgID = WtTgID), ' . $tbpref . 'languages where WoLgID = LgID AND WoTranslation != \'*\' and WoSentence like concat(\'%{\',WoText,\'}%\') ' . $wh_lang . $wh_stat . $wh_query . ' group by WoID ' . $wh_tag);

} else {

anki_export('select distinct WoID, LgRightToLeft, LgRegexpWordCharacters, LgName, WoText, WoTranslation, WoRomanization, WoSentence, ifnull(group_concat(distinct TgText order by TgText separator \' \'),\'\') as taglist from ((' . $tbpref . 'words left JOIN ' . $tbpref . 'wordtags ON WoID = WtWoID) left join ' . $tbpref . 'tags on TgID = WtTgID), ' . $tbpref . 'languages, ' . $tbpref . 'textitems2 where Ti2LgID = WoLgID and Ti2WoID = WoID and Ti2TxID in (' . $currenttext . ')' . ' and WoLgID = LgID AND WoTranslation != \'*\' and WoSentence like concat(\'%{\',WoText,\'}%\') ' . $wh_lang . $wh_stat . $wh_query . ' group by WoID ' . $wh_tag);

}

}

elseif ($allaction == 'expall2' ) {

if ($currenttext == '') {

tsv_export('select distinct WoID, LgName, WoText, WoTranslation, WoRomanization, WoSentence, WoStatus, ifnull(group_concat(distinct TgText order by TgText separator \' \'),\'\') as taglist from ((' . $tbpref . 'words left JOIN ' . $tbpref . 'wordtags ON WoID = WtWoID) left join ' . $tbpref . 'tags on TgID = WtTgID), ' . $tbpref . 'languages where WoLgID = LgID ' . $wh_lang . $wh_stat . $wh_query . ' group by WoID ' . $wh_tag);

} else {

tsv_export('select distinct WoID, LgName, WoText, WoTranslation, WoRomanization, WoSentence, WoStatus, ifnull(group_concat(distinct TgText order by TgText separator \' \'),\'\') as taglist from ((' . $tbpref . 'words left JOIN ' . $tbpref . 'wordtags ON WoID = WtWoID) left join ' . $tbpref . 'tags on TgID = WtTgID), ' . $tbpref . 'languages, ' . $tbpref . 'textitems2 where Ti2LgID = WoLgID and Ti2WoID = WoID and Ti2TxID in (' . $currenttext . ')' . ' and WoLgID = LgID ' . $wh_lang . $wh_stat . $wh_query . ' group by WoID ' . $wh_tag);

}

}

elseif ($allaction == 'expall3' ) {

if ($currenttext == '') {

flexible_export('select distinct WoID, LgName, LgExportTemplate, LgRightToLeft, WoText, WoTextLC, WoTranslation, WoRomanization, WoSentence, WoStatus, ifnull(group_concat(distinct TgText order by TgText separator \' \'),\'\') as taglist from ((' . $tbpref . 'words left JOIN ' . $tbpref . 'wordtags ON WoID = WtWoID) left join ' . $tbpref . 'tags on TgID = WtTgID), ' . $tbpref . 'languages where WoLgID = LgID ' . $wh_lang . $wh_stat . $wh_query . ' group by WoID ' . $wh_tag);

} else {

flexible_export('select distinct WoID, LgName, LgExportTemplate, LgRightToLeft, WoText, WoTextLC, WoTranslation, WoRomanization, WoSentence, WoStatus, ifnull(group_concat(distinct TgText order by TgText separator \' \'),\'\') as taglist from ((' . $tbpref . 'words left JOIN ' . $tbpref . 'wordtags ON WoID = WtWoID) left join ' . $tbpref . 'tags on TgID = WtTgID), ' . $tbpref . 'languages, ' . $tbpref . 'textitems2 where Ti2LgID = WoLgID and Ti2WoID = WoID and Ti2TxID in (' . $currenttext . ')' . ' and WoLgID = LgID ' . $wh_lang . $wh_stat . $wh_query . ' group by WoID ' . $wh_tag);

}

}

elseif ($allaction == 'testall' ) {

if ($currenttext == '') {

$sql = 'select distinct WoID from (' . $tbpref . 'words left JOIN ' . $tbpref . 'wordtags ON WoID = WtWoID) where (1=1) ' . $wh_lang . $wh_stat . $wh_query . ' group by WoID ' . $wh_tag;

} else {

$sql = 'select distinct WoID from (' . $tbpref . 'words left JOIN ' . $tbpref . 'wordtags ON WoID = WtWoID), ' . $tbpref . 'textitems2 where Ti2LgID = WoLgID and Ti2WoID = WoID and Ti2TxID in (' . $currenttext . ')' . $wh_lang . $wh_stat . $wh_query . ' group by WoID ' . $wh_tag;

}

$cnt = 0;

$list = '(';

$res = do_mysqli_query($sql);

while ($record = mysqli_fetch_assoc($res)) {

$cnt++;

$id = $record['WoID'];

$list .= ($cnt==1 ? '' : ',') . $id;

}

$list .= ")";

mysqli_free_result($res);

$_SESSION['testsql'] = ' ' . $tbpref . 'words where WoID in ' . $list . ' ';

header("Location: do_test.php?selection=1");

exit();

}

}

elseif (isset($_REQUEST['del'])) {

$message = runsql('delete from ' . $tbpref . 'words where WoID = ' . $_REQUEST['del'], "Deleted");

adjust_autoincr('words','WoID');

do_mysqli_query ('update ' . $tbpref . 'textitems2 set Ti2WoID = 0 where Ti2WordCount = 1 and Ti2WoID = ' . $_REQUEST['del']);

do_mysqli_query ('delete from ' . $tbpref . 'textitems2 where Ti2WoID = ' . $_REQUEST['del']);

runsql("DELETE " . $tbpref . "wordtags FROM (" . $tbpref . "wordtags LEFT JOIN " . $tbpref . "words on WtWoID = WoID) WHERE WoID IS NULL",'');

}

elseif (isset($_REQUEST['op'])) {

$translation_raw = repl_tab_nl(getreq("WoTranslation"));

if ( $translation_raw == '' ) $translation = '*';

else $translation = $translation_raw;

// INSERT

if ($_REQUEST['op'] == 'Save') {

$message = runsql('insert into ' . $tbpref . 'words (WoLgID, WoTextLC, WoText, ' .

'WoStatus, WoTranslation, WoSentence, WoRomanization, WoStatusChanged,' . make_score_random_insert_update('iv') . ') values( ' .

$_REQUEST["WoLgID"] . ', ' .

convert_string_to_sqlsyntax(mb_strtolower($_REQUEST["WoText"], 'UTF-8')) . ', ' .

convert_string_to_sqlsyntax($_REQUEST["WoText"]) . ', ' .

$_REQUEST["WoStatus"] . ', ' .

convert_string_to_sqlsyntax($translation) . ', ' .

convert_string_to_sqlsyntax(repl_tab_nl($_REQUEST["WoSentence"])) . ', ' .

convert_string_to_sqlsyntax($_REQUEST["WoRomanization"]) . ', NOW(), ' .

make_score_random_insert_update('id') . ')', "Saved", $sqlerrdie = FALSE);

$wid = get_last_key();

set_word_count();

$wis = mb_strtolower($_REQUEST["WoText"], 'UTF-8');

$lid = $_REQUEST["WoLgID"];

$sql = "select * from " . $tbpref . "languages where LgID=" . $lid;

$res = do_mysqli_query($sql);

$record = mysqli_fetch_assoc($res);

$termchar = $record['LgRegexpWordCharacters'];

$splitEachChar = $record['LgSplitEachChar'];

$removeSpaces = $record["LgRemoveSpaces"];

$rtlScript = $record['LgRightToLeft'];

mysqli_free_result($res);

$textlc = $splitEachChar?preg_replace('/([^\s])/u', "$1 ", $wis):$wis;

$len = preg_match_all('/([' . $termchar . ']+)/u',$textlc,$ma);

if(($removeSpaces==1 && $splitEachChar==0) or $len > 1){

if($removeSpaces==1 && $splitEachChar==0){

$rSflag = '';

}

if($removeSpaces==1 && $splitEachChar==0){

$sql = "SELECT group_concat(Ti2Text order by Ti2Order SEPARATOR ' ') AS SeText, SeID, SeTxID, SeFirstPos FROM " . $tbpref . "textitems2," . $tbpref . "sentences where SeID=Ti2SeID and SeLgID = " . $lid . " and Ti2LgID = " . $lid . " and SeText like " . convert_string_to_sqlsyntax_notrim_nonull("%" . $wis . "%") . " and Ti2WordCount < 2 group by SeID";

}

else {

$sql = "SELECT * FROM " . $tbpref . "sentences where SeLgID = " . $lid . " and SeText like " . convert_string_to_sqlsyntax_notrim_nonull("%" . $wis . "%");

}

$res=do_mysqli_query ($sql);

$notermchar='/[^' . $termchar . '](' . $textlc . ')[^' . $termchar . ']/ui';

while($record = mysqli_fetch_assoc($res)){

$string = ' ' . ($splitEachChar?preg_replace('/([^\s])/u', "$1 ", $record['SeText']):$record['SeText']) . ' ';

if($removeSpaces==1 && $splitEachChar==0){

if(empty($rSflag)){

$rSflag = preg_match ( '/(?<=[ ])(' . preg_replace('/(.)/ui', "$1[ ]*", $textlc) . ')(?=[ ])/ui', $string, $ma);

if(!empty($ma[1])){

$textlc = trim($ma[1]);

$notermchar='/[^' . $termchar . '](' . $textlc . ')[^' . $termchar . ']/ui';

}

$len = preg_match_all('/([' . $termchar . ']+)/u',$textlc,$match);

}

}

$txtid =$record['SeTxID'];

$sentid =$record['SeID'];

$last_pos = mb_strripos ( $string , $textlc , 0, 'UTF-8' );

while($last_pos!==false){

$matches=array();

if($splitEachChar || $removeSpaces || preg_match ( $notermchar, ' ' . $string, $matches, 0, $last_pos - 1)==1){

$string = mb_substr ( $string, 0, $last_pos , 'UTF-8');

$cnt = preg_match_all('/([' . $termchar . ']+)/u',$string,$ma);

$pos=2*$cnt+$record['SeFirstPos'];

$txt='';

if($len==1 || !($matches[1]==$textlc))$txt=$splitEachChar || $removeSpaces?$wis:$matches[1];

$sqlarr[] = '(' . $wid . ',' . $lid . ',' . $txtid . ',' . $sentid . ',' . $pos . ',' . $len . ',' . convert_string_to_sqlsyntax_notrim_nonull($txt) . ')';

$last_pos = mb_strripos ( $string , $textlc , 0, 'UTF-8' );

}

else{

$string = mb_substr ( $string, 0, $last_pos, 'UTF-8' );

$last_pos = mb_strripos ( $string , $textlc , 0, 'UTF-8' );

}

}

}

mysqli_free_result($res);

if($len > 0)runsql('update ' . $tbpref . 'words set WoWordCount = ' . $len . ' where WoID = ' . $wid,'');

if(isset($sqlarr)){

$sqltext = 'REPLACE INTO ' . $tbpref . 'textitems2 (Ti2WoID,Ti2LgID,Ti2TxID,Ti2SeID,Ti2Order,Ti2WordCount,Ti2Text) VALUES ';

$sqltext .= rtrim(implode(',', $sqlarr),',');

do_mysqli_query ($sqltext);

}

}

else {

runsql('update ' . $tbpref . 'words set WoWordCount = 1 where WoID = ' . $wid,'');

runsql('update ' . $tbpref . 'textitems2 set Ti2WoID = ' . $wid . ' where lower(Ti2Text) = ' . convert_string_to_sqlsyntax($wis),'');

}

}

// UPDATE

else {

$oldstatus = $_REQUEST["WoOldStatus"];

$newstatus = $_REQUEST["WoStatus"];

$xx = '';

if ($oldstatus != $newstatus) $xx = ', WoStatus = ' . $newstatus . ', WoStatusChanged = NOW()';

$wid = $_REQUEST["WoID"] + 0;

$message = runsql('update ' . $tbpref . 'words set WoText = ' .

convert_string_to_sqlsyntax($_REQUEST["WoText"]) . ', WoTextLC = ' .

convert_string_to_sqlsyntax(mb_strtolower($_REQUEST["WoText"], 'UTF-8')) . ', WoTranslation = ' .

convert_string_to_sqlsyntax($translation) . ', WoSentence = ' .

convert_string_to_sqlsyntax(repl_tab_nl($_REQUEST["WoSentence"])) . ', WoRomanization = ' .

convert_string_to_sqlsyntax($_REQUEST["WoRomanization"]) . $xx . ',' . make_score_random_insert_update('u') . ' where WoID = ' . $_REQUEST["WoID"],

"Updated", $sqlerrdie = FALSE);

}

saveWordTags($wid);

}

if (isset($_REQUEST['new']) && isset($_REQUEST['lang'])) {

$scrdir = getScriptDirectionTag($_REQUEST['lang']);

?>

<h4>New Term</h4>

<script type="text/javascript" src="js/unloadformcheck.js" charset="utf-8"></script>

<form name="newword" class="validate" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">

<input type="hidden" name="WoLgID" id="langfield" value="<?php echo $_REQUEST['lang']; ?>" />

<table class="tab3" cellspacing="0" cellpadding="5">

<tr>

<td class="td1 right">Language:</td>

<td class="td1"><?php echo tohtml(getLanguage($_REQUEST['lang'])); ?></td>

</tr>

<tr>

<td class="td1 right">Term:</td>

<td class="td1"><input <?php echo $scrdir; ?> class="notempty setfocus" type="text" name="WoText" id="wordfield" value="" maxlength="250" size="40" /> <img src="icn/status-busy.png" title="Field must not be empty" alt="Field must not be empty" /></td>

</tr>

<?php print_similar_terms_tabrow(); ?>

<tr>

<td class="td1 right">Translation:</td>

<td class="td1"><textarea class="textarea-noreturn checklength" data_maxlength="500" data_info="Translation" name="WoTranslation" cols="40" rows="3"></textarea></td>

</tr>

<tr>

<td class="td1 right">Tags:</td>

<td class="td1">

<?php echo getWordTags(0); ?>

</td>

</tr>

<tr>

<td class="td1 right">Romaniz.:</td>

<td class="td1"><input type="text" name="WoRomanization" value="" maxlength="100" size="40" /></td>

</tr>

<tr>

<td class="td1 right">Sentence<br />Term in {...}:</td>

<td class="td1"><textarea <?php echo $scrdir; ?> name="WoSentence" cols="40" rows="3" class="textarea-noreturn checklength" data_maxlength="1000" data_info="Sentence"></textarea></td>

</tr>

<tr>

<td class="td1 right">Status:</td>

<td class="td1">

<?php echo get_wordstatus_radiooptions(1); ?>

</td>

</tr>

<tr>

<td class="td1 right" colspan="2"> &nbsp;

<?php echo createDictLinksInEditWin2($_REQUEST['lang'],'document.forms[\'newword\'].WoSentence','document.forms[\'newword\'].WoText'); ?>

&nbsp; &nbsp;

<input type="button" value="Cancel" onclick="{resetDirty(); location.href='edit_words.php';}" />

<input type="submit" name="op" value="Save" /></td>

</tr>

</table>

</form>

<?php

}

elseif (isset($_REQUEST['chg'])) {

$sql = 'select * from ' . $tbpref . 'words, ' . $tbpref . 'languages where LgID = WoLgID and WoID = ' . $_REQUEST['chg'];

$res = do_mysqli_query($sql);

if ($record = mysqli_fetch_assoc($res)) {

$wordlc = $record['WoTextLC'];

$transl = repl_tab_nl($record['WoTranslation']);

if($transl == '*') $transl='';

$scrdir = ($record['LgRightToLeft'] ? ' dir="rtl" ' : '');

?>

<h4>Edit Term</h4>

<script type="text/javascript" src="js/unloadformcheck.js" charset="utf-8"></script>

<form name="editword" class="validate" action="<?php echo $_SERVER['PHP_SELF']; ?>#rec<?php echo $_REQUEST['chg']; ?>" method="post">

<input type="hidden" name="WoID" value="<?php echo $record['WoID']; ?>" />

<input type="hidden" name="WoLgID" id="langfield" value="<?php echo $record['WoLgID']; ?>" />

<input type="hidden" name="WoOldStatus" value="<?php echo $record['WoStatus']; ?>" />

<table class="tab3" cellspacing="0" cellpadding="5">

<tr>

<td class="td1 right">Language:</td>

<td class="td1"><?php echo tohtml($record['LgName']); ?></td>

</tr>

<tr title="Normally only change uppercase/lowercase here!">

<td class="td1 right">Term:</td>

<td class="td1"><input <?php echo $scrdir; ?> class="notempty setfocus" type="text" name="WoText" id="wordfield" value="<?php echo tohtml($record['WoText']); ?>" maxlength="250" size="40" /> <img src="icn/status-busy.png" title="Field must not be empty" alt="Field must not be empty" />

</td></tr>

<?php print_similar_terms_tabrow(); ?>

<tr>

<td class="td1 right">Translation:</td>

<td class="td1"><textarea class="textarea-noreturn checklength" data_maxlength="500" data_info="Translation" name="WoTranslation" cols="40" rows="3"><?php echo tohtml($transl); ?></textarea></td>

</tr>

<tr>

<td class="td1 right">Tags:</td>

<td class="td1">

<?php echo getWordTags($record['WoID']); ?>

</td>

</tr>

<tr>

<td class="td1 right">Romaniz.:</td>

<td class="td1"><input type="text" name="WoRomanization" maxlength="100" size="40"

value="<?php echo tohtml($record['WoRomanization']); ?>" /></td>

</tr>

<tr>

<td class="td1 right">Sentence<br />Term in {...}:</td>

<td class="td1"><textarea <?php echo $scrdir; ?> class="textarea-noreturn checklength" data_maxlength="1000" data_info="Sentence" name="WoSentence" cols="40" rows="3"><?php echo tohtml(repl_tab_nl($record['WoSentence'])); ?></textarea></td>

</tr>

<tr>

<td class="td1 right">Status:</td>

<td class="td1">

<?php echo get_wordstatus_radiooptions($record['WoStatus']); ?>

</td>

</tr>

<tr>

<td class="td1 right" colspan="2"> &nbsp;

<?php echo createDictLinksInEditWin2($record['WoLgID'],'document.forms[\'editword\'].WoSentence','document.forms[\'editword\'].WoText'); ?>

&nbsp; &nbsp;

<input type="button" value="Cancel" onclick="{resetDirty(); location.href='edit_words.php#rec<?php echo $_REQUEST['chg']; ?>';}" />

<input type="submit" name="op" value="Change" /></td>

</tr>

</table>

</form>

<div id="exsent"><span class="click" onclick="do_ajax_show_sentences(<?php echo $record['LgID']; ?>, <?php echo prepare_textdata_js($wordlc) . ', ' . prepare_textdata_js("document.forms['editword'].WoSentence") . ', ' . $_REQUEST['chg']; ?>);"><img src="icn/sticky-notes-stack.png" title="Show Sentences" alt="Show Sentences" /> Show Sentences</span></div>

}

mysqli_free_result($res);

}

else {

if (substr($message,0,24) == "Error: Duplicate entry '" &&

substr($message,-24) == "' for key 'WoLgIDTextLC'") {

$lgID = $_REQUEST["WoLgID"] . "-";

$message = substr($message,24+strlen($lgID));

$message = substr($message,0,strlen($message)-24);

$message = "Error: Term '" . $message . "' already exists. Please go back and correct this!";

}

echo error_message_with_hide($message,0);

if ($currenttext == '') {

$sql = 'select count(*) as value from (select WoID from (' . $tbpref . 'words left JOIN ' . $tbpref . 'wordtags ON WoID = WtWoID) where (1=1) ' . $wh_lang . $wh_stat . $wh_query . ' group by WoID ' . $wh_tag .') as dummy';

} else {

$sql = 'select count(*) as value from (select WoID from (' . $tbpref . 'words left JOIN ' . $tbpref . 'wordtags ON WoID = WtWoID), ' . $tbpref . 'textitems2 where Ti2LgID = WoLgID and Ti2WoID = WoID and Ti2TxID in (' . $currenttext . ')' . $wh_lang . $wh_stat . $wh_query . ' group by WoID ' . $wh_tag .') as dummy';

}

$recno = get_first_value($sql);

if ($debug) echo $sql . ' ===&gt; ' . $recno;

$maxperpage = getSettingWithDefault('set-terms-per-page');

$pages = $recno == 0 ? 0 : (intval(($recno-1) / $maxperpage) + 1);

if ($currentpage < 1) $currentpage = 1;

if ($currentpage > $pages) $currentpage = $pages;

$limit = 'LIMIT ' . (($currentpage-1) * $maxperpage) . ',' . $maxperpage;

$sorts = array('WoTextLC','lower(WoTranslation)','WoID desc','WoID asc','WoStatus, WoTextLC','WoTodayScore','textswordcount desc, WoTextLC asc');

$lsorts = count($sorts);

if ($currentsort < 1) $currentsort = 1;

if ($currentsort > $lsorts) $currentsort = $lsorts;

if ($currentlang != '') {

<p><a href="<?php echo $_SERVER['PHP_SELF']; ?>?new=1&amp;lang=<?php echo $currentlang; ?>"><img src="icn/plus-button.png" title="New" alt="New" /> New <?php echo tohtml(getLanguage($currentlang)); ?> Term ...</a></p>

} else {

<p><img src="icn/plus-button.png" title="New" alt="New" /> New Term? - Set Language Filter first ...</p>

}

<form name="form1" action="#" onsubmit="document.form1.querybutton.click(); return false;">

<table class="tab1" cellspacing="0" cellpadding="5">

<tr>

<th class="th1" colspan="4">Filter <img src="icn/funnel.png" title="Filter" alt="Filter" />&nbsp;

<input type="button" value="Reset All" onclick="resetAll('edit_words.php');" /></th>

</tr>

<tr>

<td class="td1 center" colspan="2">

Language:

<select name="filterlang" onchange="{setLang(document.form1.filterlang,'edit_words.php');}"><?php echo get_languages_selectoptions($currentlang,'[Filter off]'); ?></select>

</td>

<td class="td1 center" colspan="2">

<select name="text_mode" onchange="{val=document.form1.text_mode.value; location.href='edit_words.php?page=1&amp;texttag=&amp;text=&amp;text_mode=' + val;}">

<option value="0"<?php if($currenttextmode=="0")echo ' selected="selected"'; ?>>Text:</option>

<option value="1"<?php if($currenttextmode=="1")echo ' selected="selected"'; ?>>Text Tag:</option>

</select>

<select name="text" onchange="{val=document.form1.text.options[document.form1.text.selectedIndex].value; location.href='edit_words.php?page=1&amp;text=' + val;}"><?php echo ($currenttextmode!=1)?(get_texts_selectoptions($currentlang,$currenttext)):(get_txtag_selectoptions($currentlang,$currenttexttag)); ?></select>

</td>

</tr>

<tr>

<td class="td1 center" colspan="2" nowrap="nowrap">

Status:

<select name="status" onchange="{val=document.form1.status.options[document.form1.status.selectedIndex].value; location.href='edit_words.php?page=1&amp;status=' + val;}"><?php echo get_wordstatus_selectoptions($currentstatus,true,false); ?></select>

</td>

<td class="td1 center" colspan="2" nowrap="nowrap"><select name="query_mode" onchange="{val=document.form1.query.value;mode=document.form1.query_mode.value; location.href='edit_words.php?page=1&amp;query=' + val + '&amp;query_mode=' + mode;}">

<option value="term,rom,transl"<?php if($currentquerymode=="term,rom,transl")echo ' selected="selected"'; ?>>Term, Rom., Transl.</option>

<option disabled="disabled">------------</option>

<option value="term"<?php if($currentquerymode=="term")echo ' selected="selected"'; ?>>Term</option>

<option value="rom"<?php if($currentquerymode=="rom")echo ' selected="selected"'; ?>>Romanization</option>

<option value="transl"<?php if($currentquerymode=="transl")echo ' selected="selected"'; ?>>Translation</option>

<option disabled="disabled">------------</option>

<option value="term,rom"<?php if($currentquerymode=="term,rom")echo ' selected="selected"'; ?>>Term, Rom.</option>

<option value="term,transl"<?php if($currentquerymode=="term,transl")echo ' selected="selected"'; ?>>Term, Transl.</option>

<option value="rom,transl"<?php if($currentquerymode=="rom,transl")echo ' selected="selected"'; ?>>Rom., Transl.</option>

</select><?php

if($currentregexmode=='')echo '<span style="vertical-align: middle"> (Wildc.=*): </span>';

elseif($currentregexmode=='r') echo '<span style="vertical-align: middle"> RegEx Mode: </span>';

else echo '<span style="vertical-align: middle"> RegEx(CS) Mode: </span>';?>

<input type="text" name="query" value="<?php echo tohtml($currentquery); ?>" maxlength="50" size="15" />&nbsp;

<input type="button" name="querybutton" value="Filter" onclick="{val=document.form1.query.value;val=encodeURIComponent(val);mode=document.form1.query_mode.value; location.href='edit_words.php?page=1&amp;query=' + val + '&amp;query_mode=' + mode;}" />&nbsp;

<input type="button" value="Clear" onclick="{location.href='edit_words.php?page=1&amp;query=';}" />

</td>

</tr>

<tr>

<td class="td1 center" colspan="2" nowrap="nowrap">

Tag #1:

<select name="tag1" onchange="{val=document.form1.tag1.options[document.form1.tag1.selectedIndex].value; location.href='edit_words.php?page=1&amp;tag1=' + val;}"><?php echo get_tag_selectoptions($currenttag1,$currentlang); ?></select>

</td>

<td class="td1 center" nowrap="nowrap">

Tag #1 .. <select name="tag12" onchange="{val=document.form1.tag12.options[document.form1.tag12.selectedIndex].value; location.href='edit_words.php?page=1&amp;tag12=' + val;}"><?php echo get_andor_selectoptions($currenttag12); ?></select> .. Tag #2

</td>

<td class="td1 center" nowrap="nowrap">

Tag #2:

<select name="tag2" onchange="{val=document.form1.tag2.options[document.form1.tag2.selectedIndex].value; location.href='edit_words.php?page=1&amp;tag2=' + val;}"><?php echo get_tag_selectoptions($currenttag2,$currentlang); ?></select>

</td>

</tr>

<?php if($recno > 0) { ?>

<tr>

<th class="th1" colspan="2" nowrap="nowrap">

<?php echo $recno; ?> Term<?php echo ($recno==1?'':'s'); ?>

</th><th class="th1" colspan="1" nowrap="nowrap">

<?php makePager ($currentpage, $pages, 'edit_words.php', 'form1'); ?>

</th><th class="th1" nowrap="nowrap">

Sort Order:

<select name="sort" onchange="{val=document.form1.sort.options[document.form1.sort.selectedIndex].value; location.href='edit_words.php?page=1&amp;sort=' + val;}"><?php echo get_wordssort_selectoptions($currentsort); ?></select>

</th></tr>

<?php } ?>

</table>

</form>

if ($recno==0) {

<p>No terms found.</p>

} else {

<form name="form2" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">

<input type="hidden" name="data" value="" />

<table class="tab1" cellspacing="0" cellpadding="5">

<tr><th class="th1 center" colspan="2">

Multi Actions <img src="icn/lightning.png" title="Multi Actions" alt="Multi Actions" />

</th></tr>

<tr><td class="td1 center" colspan="2">

<b>ALL</b> <?php echo ($recno == 1 ? '1 Term' : $recno . ' Terms'); ?>:&nbsp;

<select name="allaction" onchange="allActionGo(document.form2, document.form2.allaction,<?php echo $recno; ?>);"><?php echo get_allwordsactions_selectoptions(); ?></select>

</td></tr>

<tr><td class="td1 center">

<input type="button" value="Mark All" onclick="selectToggle(true,'form2');" />

<input type="button" value="Mark None" onclick="selectToggle(false,'form2');" />

</td>

<td class="td1 center">Marked Terms:&nbsp;

<select name="markaction" id="markaction" disabled="disabled" onchange="multiActionGo(document.form2, document.form2.markaction);"><?php echo get_multiplewordsactions_selectoptions(); ?></select>

</td></tr></table>

<table class="sortable tab1" cellspacing="0" cellpadding="5">

<tr>

<th class="th1 sorttable_nosort">Mark</th>

<th class="th1 sorttable_nosort">Act.</th>

<?php if ($currentlang == '') echo '<th class="th1 clickable">Lang.</th>'; ?>

<th class="th1 clickable">Term /<br />Romanization</th>

<th class="th1 clickable">Translation [Tags]<br /><span id="waitinfo">Please <img src="<?php print_file_path('icn/waiting2.gif'); ?>" /> wait ...</span></th>

<th class="th1 sorttable_nosort">Se.<br />?</th>

<th class="th1 sorttable_numeric clickable">Stat./<br />Days</th>

<th class="th1 sorttable_numeric clickable">Score<br />%</th>

if ($currentsort == 7) {

<th class="th1 sorttable_numeric clickable" title="Word Count in Active Texts">WCnt<br />Txts</th>

}

</tr>

if ($currentsort == 7) {

if ($currenttext != '')

$sql = '';

else

$sql = 'select WoID, 0 AS textswordcount, WoText, WoTranslation, WoRomanization, WoSentence, ifnull(WoSentence,\'\') like concat(\'%{\',WoText,\'}%\') as SentOK, WoStatus, LgName, LgRightToLeft, LgGoogleTranslateURI, DATEDIFF( NOW( ) , WoStatusChanged ) AS Days, WoTodayScore AS Score, WoTomorrowScore AS Score2, ifnull(concat(\'[\',group_concat(distinct TgText order by TgText separator \', \'),\']\'),\'\') as taglist, WoTextLC, WoTodayScore from ((' . $tbpref . 'words left JOIN ' . $tbpref . 'wordtags ON WoID = WtWoID) left join ' . $tbpref . 'tags on TgID = WtTgID), ' . $tbpref . 'languages where WoLgID = LgID and WoID NOT IN (SELECT DISTINCT Ti2WoID from ' . $tbpref . 'textitems2 where Ti2LgID = LgID) ' . $wh_lang . $wh_stat . $wh_query . ' group by WoID ' . $wh_tag . ' UNION ';

$sql .= 'select WoID, count(WoID) AS textswordcount, WoText, WoTranslation, WoRomanization, WoSentence, ifnull(WoSentence,\'\') like concat(\'%{\',WoText,\'}%\') as SentOK, WoStatus, LgName, LgRightToLeft, LgGoogleTranslateURI, DATEDIFF( NOW( ) , WoStatusChanged ) AS Days, WoTodayScore AS Score, WoTomorrowScore AS Score2, ifnull(concat(\'[\',group_concat(distinct TgText order by TgText separator \', \'),\']\'),\'\') as taglist, WoTextLC, WoTodayScore from ((' . $tbpref . 'words left JOIN ' . $tbpref . 'wordtags ON WoID = WtWoID) left join ' . $tbpref . 'tags on TgID = WtTgID), ' . $tbpref . 'languages, ' . $tbpref . 'textitems2 where Ti2LgID = WoLgID and Ti2WoID = WoID and WoLgID = LgID ';

if ($currenttext != '') $sql .= 'and Ti2TxID in (' . $currenttext . ')' . ' ';

$sql .= $wh_lang . $wh_stat . $wh_query . ' group by WoID ' . $wh_tag . ' order by ' . $sorts[$currentsort-1] . ' ' . $limit;

} else {

if ($currenttext == '') {if($wh_tag=='')

$sql = 'select WoID, WoText, WoTranslation, WoRomanization, WoSentence, SentOK, WoStatus, LgName, LgRightToLeft, LgGoogleTranslateURI, Days, WoTodayScore AS Score, WoTomorrowScore AS Score2, ifnull(concat(\'[\',group_concat(distinct TgText order by TgText separator \', \'),\']\'),\'\') as taglist from (select WoID, WoTextLC, WoText, WoTranslation, WoRomanization, WoSentence, ifnull(WoSentence,\'\') like concat(\'%{\',WoText,\'}%\') as SentOK, WoStatus, LgName, LgRightToLeft, LgGoogleTranslateURI, DATEDIFF( NOW( ) , WoStatusChanged ) AS Days, WoTodayScore, WoTomorrowScore from ' . $tbpref . 'words, ' . $tbpref . 'languages where WoLgID = LgID ' . $wh_lang . $wh_stat . $wh_query . ' group by WoID order by ' . $sorts[$currentsort-1] . ' ' . $limit . ') AS AA left JOIN ' . $tbpref . 'wordtags ON WoID = WtWoID left join ' . $tbpref . 'tags on TgID = WtTgID group by WoID order by ' . $sorts[$currentsort-1];else

$sql = 'select WoID, WoText, WoTranslation, WoRomanization, WoSentence, ifnull(WoSentence,\'\') like concat(\'%{\',WoText,\'}%\') as SentOK, WoStatus, LgName, LgRightToLeft, LgGoogleTranslateURI, DATEDIFF( NOW( ) , WoStatusChanged ) AS Days, WoTodayScore AS Score, WoTomorrowScore AS Score2, ifnull(concat(\'[\',group_concat(distinct TgText order by TgText separator \', \'),\']\'),\'\') as taglist from ((' . $tbpref . 'words left JOIN ' . $tbpref . 'wordtags ON WoID = WtWoID) left join ' . $tbpref . 'tags on TgID = WtTgID), ' . $tbpref . 'languages where WoLgID = LgID ' . $wh_lang . $wh_stat . $wh_query . ' group by WoID ' . $wh_tag . ' order by ' . $sorts[$currentsort-1] . ' ' . $limit;

} else {

$sql = 'select distinct WoID, WoText, WoTranslation, WoRomanization, WoSentence, ifnull(WoSentence,\'\') like \'%{%}%\' as SentOK, WoStatus, LgName, LgRightToLeft, LgGoogleTranslateURI, DATEDIFF( NOW( ) , WoStatusChanged ) AS Days, WoTodayScore AS Score, WoTomorrowScore AS Score2, ifnull(concat(\'[\',group_concat(distinct TgText order by TgText separator \', \'),\']\'),\'\') as taglist from ((' . $tbpref . 'words left JOIN ' . $tbpref . 'wordtags ON WoID = WtWoID) left join ' . $tbpref . 'tags on TgID = WtTgID), ' . $tbpref . 'languages, ' . $tbpref . 'textitems2 where Ti2LgID = WoLgID and Ti2WoID = WoID and Ti2TxID in (' . $currenttext . ') and WoLgID = LgID ' . $wh_lang . $wh_stat . $wh_query . ' group by WoID ' . $wh_tag . ' order by ' . $sorts[$currentsort-1] . ' ' . $limit;

}

}

if ($debug) echo $sql;

flush();

$res = do_mysqli_query($sql);

while ($record = mysqli_fetch_assoc($res)) {

$days = $record['Days'];

if ( $record['WoStatus'] > 5 ) $days="-";

$score = $record['Score'];

if ( $score < 0 ) $score='<span class="scorered">0 <img src="icn/status-busy.png" title="Test today!" alt="Test today!" /></span>';

else $score='<span class="scoregreen">' . floor($score) . ($record['Score2'] < 0 ? ' <img src="icn/status-away.png" title="Test tomorrow!" alt="Test tomorrow!" />' : ' <img src="icn/status.png" title="-" alt="-" />') . '</span>';

echo '<tr>';

echo '<td class="td1 center"><a name="rec' . $record['WoID'] . '"><input name="marked[]" type="checkbox" class="markcheck" value="' . $record['WoID'] . '" ' . checkTest($record['WoID'], 'marked') . ' /></a></td>';

echo '<td class="td1 center" nowrap="nowrap">&nbsp;<a href="' . $_SERVER['PHP_SELF'] . '?chg=' . $record['WoID'] . '"><img src="icn/sticky-note--pencil.png" title="Edit" alt="Edit" /></a>&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?del=' . $record['WoID'] . '"><img src="icn/minus-button.png" title="Delete" alt="Delete" /></a>&nbsp;</td>';

if ($currentlang == '') echo '<td class="td1 center">' . tohtml($record['LgName']) . '</td>';

echo '<td class="td1"><span';

if(!empty($record['LgGoogleTranslateURI']) && strpos($record['LgGoogleTranslateURI'],'&sl=') !== false) echo ' class="tts_' . preg_replace('/.*[?&]sl=([a-zA-Z\-]*)(&.*)*$/','$1',$record['LgGoogleTranslateURI']) . '"';

echo ($record['LgRightToLeft'] ? ' dir="rtl" ' : '') . '>' . tohtml($record['WoText']) . '</span>' . ($record['WoRomanization'] != '' ? (' / <span id="roman' . $record['WoID'] . '" class="edit_area clickedit">' . tohtml(repl_tab_nl($record['WoRomanization'])) . '</span>') : (' / <span id="roman' . $record['WoID'] . '" class="edit_area clickedit">*</span>')) . '</td>';

echo '<td class="td1"><span id="trans' . $record['WoID'] . '" class="edit_area clickedit">' . tohtml(repl_tab_nl($record['WoTranslation'])) . '</span> <span class="smallgray2">' . tohtml($record['taglist']) . '</span></td>';

echo '<td class="td1 center"><b>' . ($record['SentOK']!=0 ? '<img src="icn/status.png" title="' . tohtml($record['WoSentence']) . '" alt="Yes" />' : '<img src="icn/status-busy.png" title="(No valid sentence)" alt="No" />') . '</b></td>';

echo '<td class="td1 center" title="' . tohtml(get_status_name($record['WoStatus'])) . '">' . tohtml(get_status_abbr($record['WoStatus'])) . ($record['WoStatus'] < 98 ? '/' . $days : '') . '</td>';

echo '<td class="td1 center" nowrap="nowrap">' . $score . '</td>';

if ($currentsort == 7) {

echo '<td class="td1 center" nowrap="nowrap">' . $record['textswordcount'] . '</td>';

}

echo "</tr>\n";

}

mysqli_free_result($res);

</table>

<script type="text/javascript">

//<![CDATA[

$('#waitinfo').addClass('hide');

//]]>

</script>

<?php if( $pages > 1) { ?>

<table class="tab1" cellspacing="0" cellpadding="5">

<tr>

<th class="th1" nowrap="nowrap">

<?php echo $recno; ?> Term<?php echo ($recno==1?'':'s'); ?>

</th><th class="th1" nowrap="nowrap">

<?php makePager ($currentpage, $pages, 'edit_words.php', 'form2'); ?>

</th></tr></table></form>

<?php } ?>

}

}

pageend();