$textlc = trim(prepare_textdata($_REQUEST["WoTextLC"]));

$text = trim(prepare_textdata($_REQUEST["WoText"]));

if (mb_strtolower($text, 'UTF-8') == $textlc) {

// INSERT

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

$message = edit_mword_do_insert($translation);

$wid = get_last_key();

} // $_REQUEST['op'] == 'Save'

// UPDATE

else { // $_REQUEST['op'] != 'Save'

$message = edit_mword_do_update($translation);

$wid = $_REQUEST["WoID"];

} // $_REQUEST['op'] != 'Save'

saveWordTags($wid);

} // (mb_strtolower($text, 'UTF-8') == $textlc)

else { // (mb_strtolower($text, 'UTF-8') != $textlc)

$titletext = "New/Edit Term: " . tohtml(prepare_textdata($_REQUEST["WoTextLC"]));

pagestart_nobody($titletext);

echo '<h4><span class="bigger">' . $titletext . '</span></h4>';

$message = 'Error: Term in lowercase must be exactly = "' . $textlc . '", please go back and correct this!';

echo error_message_with_hide($message, 0);

pageend();

exit();

}

?>

<script type="text/javascript">

//<![CDATA[

const context = window.parent.document;

var woid = <?php echo prepare_textdata_js($wid); ?>;

var status = <?php echo prepare_textdata_js($_REQUEST["WoStatus"]); ?>;

var trans = <?php echo prepare_textdata_js($translation . getWordTagList($wid, ' ', 1, 0)); ?>;

var roman = <?php echo prepare_textdata_js($_REQUEST["WoRomanization"]); ?>;

var title = window.parent.JQ_TOOLTIP ? '':make_tooltip(<?php echo prepare_textdata_js($_REQUEST["WoText"]); ?>,trans,roman,status);

//]]>

</script>

<?php

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

insertExpressions($textlc, $_REQUEST["WoLgID"], $wid, $_REQUEST["len"], 0);

} else {

?>

<script type="text/javascript">

//<![CDATA[

$('.word' + woid, context)

.attr('data_trans',trans)

.attr('data_rom',roman)

.attr('title',title)

.removeClass('status<?php echo $_REQUEST['WoOldStatus']; ?>')

.addClass('status' + status)

.attr('data_status',status);

//]]>

</script>

<?php

}

?>

<script type="text/javascript">

window.parent.document.getElementById('frame-l').focus();

window.parent.setTimeout('cClick()', 100);

</script>

<?php

if(isset($sqltext)) {

flush();

do_mysqli_query($sqltext);

echo '<p>OK: ',tohtml($message),'</p>';

}

global $tbpref;

$titletext = "New Term: " . tohtml(prepare_textdata($_REQUEST["WoTextLC"]));

pagestart_nobody($titletext);

echo '<h4><span class="bigger">' . $titletext . '</span></h4>';

$message = runsql(

'insert into ' . $tbpref . 'words (

WoRomanization, WoWordCount, WoStatusChanged,'

. make_score_random_insert_update('iv') . '

) values( ' .

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

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

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"]) . ', ' .

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

make_score_random_insert_update('id') .

')',

"Term saved"

);

set_word_count();

strToClassName(prepare_textdata($_REQUEST["WoTextLC"]));

return $message;

global $tbpref;

$titletext = "Edit Term: " . tohtml(prepare_textdata($_REQUEST["WoTextLC"]));

pagestart_nobody($titletext);

echo '<h4><span class="bigger">' . $titletext . '</span></h4>';

$oldstatus = $_REQUEST["WoOldStatus"];

$newstatus = $_REQUEST["WoStatus"];

$xx = '';

if ($oldstatus != $newstatus) {

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

}

$message = runsql(

'update ' . $tbpref . 'words set

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

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"

);

$wid = $_REQUEST["WoID"];

return $message;

global $tbpref;

$wid = getreq('wid');

if ($wid == '') {

$lang = get_first_value(

"select TxLgID as value

from " . $tbpref . "texts

where TxID = " . $_REQUEST['tid']

);

$term = prepare_textdata(getreq('txt'));

$termlc = mb_strtolower($term, 'UTF-8');

$wid = get_first_value(

"select WoID as value

from " . $tbpref . "words

where WoLgID = " . $lang . " and WoTextLC = " . convert_string_to_sqlsyntax($termlc)

);

if (isset($wid)) {

$term = get_first_value(

"select WoText as value

from " . $tbpref . "words

where WoID = " . $wid

);

}

} else {

$sql = 'select WoText, WoLgID from ' . $tbpref . 'words where WoID = ' . $wid;

$res = do_mysqli_query($sql);

$record = mysqli_fetch_assoc($res);

if ($record ) {

$term = $record['WoText'];

$lang = $record['WoLgID'];

} else {

my_die("Cannot access Term and Language in edit_mword.php");

}

mysqli_free_result($res);

$termlc = mb_strtolower($term, 'UTF-8');

}

$new = empty($wid);

$titletext = ($new ? "New Term" : "Edit Term") . ": " . $term;

pagestart_nobody($titletext);

?>

<script type="text/javascript">

$(document).ready(ask_before_exiting);

$(window).on('beforeunload',function() {

setTimeout(function() {window.parent.frames['ru'].location.href = 'empty.html';}, 0);

});

</script>

<?php

$scrdir = getScriptDirectionTag($lang);

// NEW

if ($new) {

edit_mword_new($wid, $lang, $termlc, $term, $scrdir);

}

// CHG

else {

edit_mword_change($wid, $lang, $termlc, $term, $scrdir);

}

global $tbpref;

$seid = get_first_value(

"select Ti2SeID as value

from " . $tbpref . "textitems2

where Ti2TxID = " . $_REQUEST['tid'] . " and Ti2Order = " . $_REQUEST['ord']

);

$sent = getSentence($seid, $termlc, (int) getSettingWithDefault('set-term-sentence-count'));

?>

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

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

<input type="hidden" name="WoTextLC" value="<?php echo tohtml($termlc); ?>" />

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

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

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

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

<tr title="Only change uppercase/lowercase!">

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

<td class="td1"><input <?php echo $scrdir; ?> class="notempty checkoutsidebmp" data_info="New Term" type="text" name="WoText" id="wordfield" value="<?php echo tohtml($term); ?>" maxlength="250" size="35" /> <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 name="WoTranslation" class="setfocus textarea-noreturn checklength checkoutsidebmp" data_maxlength="500" data_info="Translation" cols="35" 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" class="checkoutsidebmp" data_info="Romanization" name="WoRomanization" value="" maxlength="100" size="35" /></td>

</tr>

<tr>

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

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

</tr>

<tr>

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

<td class="td1">

<?php echo get_wordstatus_radiooptions(1); ?>

</td>

</tr>

<tr>

<tr>

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

<?php echo createDictLinksInEditWin($lang, $term, 'document.forms[0].WoSentence', isset($_GET['nodict'])?0:1); ?>

&nbsp; &nbsp; &nbsp;

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

</tr>

</table>

</form>

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

<?php

global $tbpref;

$sql = 'select WoTranslation, WoSentence, WoRomanization, WoStatus from ' . $tbpref . 'words where WoID = ' . $wid;

$res = do_mysqli_query($sql);

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

$status = $record['WoStatus'];

if ($status >= 98) {

$status = 1;

}

$sentence = repl_tab_nl($record['WoSentence']);

if ($sentence == '') {

$seid = get_first_value("select Ti2SeID as value from " . $tbpref . "textitems2 where Ti2TxID = " . $_REQUEST['tid'] . " and Ti2Order = " . $_REQUEST['ord']);

$sent = getSentence($seid, $termlc, (int) getSettingWithDefault('set-term-sentence-count'));

$sentence = repl_tab_nl($sent[1]);

}

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

if($transl == '*') {

$transl='';

}

?>

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

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

<input type="hidden" name="WoID" value="<?php echo $wid; ?>" />

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

<input type="hidden" name="WoStatus" value="<?php echo $status; ?>" />

<input type="hidden" name="WoTextLC" value="<?php echo tohtml($termlc); ?>" />

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

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

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

<tr title="Only change uppercase/lowercase!">

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

<td class="td1"><input <?php echo $scrdir; ?> class="notempty checkoutsidebmp" data_info="Term" type="text" name="WoText" id="wordfield" value="<?php echo tohtml($term); ?>" maxlength="250" size="35" /> <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 name="WoTranslation" class="setfocus textarea-noreturn checklength checkoutsidebmp" data_maxlength="500" data_info="Translation" cols="35" rows="3"><?php echo tohtml($transl); ?></textarea></td>

</tr>

<tr>

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

<td class="td1">

<?php echo getWordTags($wid); ?>

</td>

</tr>

<tr>

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

<td class="td1"><input type="text" class="checkoutsidebmp" data_info="Romanization" name="WoRomanization" maxlength="100" size="35"

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; ?> name="WoSentence" class="textarea-noreturn checklength checkoutsidebmp" data_maxlength="1000" data_info="Sentence" cols="35" rows="3"><?php echo tohtml($sentence); ?></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">

<?php echo createDictLinksInEditWin($lang, $term, 'document.forms[0].WoSentence', isset($_GET['nodict'])?0:1); ?>

&nbsp; &nbsp; &nbsp;

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

</tr>

</table>

</form>

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

<?php

}

mysqli_free_result($res);