{

global $tbpref;

$sqlarr = array();

$max = get_first_value("SELECT max(WoID) AS value FROM {$tbpref}words");

foreach ($terms as $row) {

$sqlarr[] = '(' .

convert_string_to_sqlsyntax($row['lg']) . ',' .

convert_string_to_sqlsyntax(mb_strtolower($row['text'], 'UTF-8')) . ',' .

convert_string_to_sqlsyntax($row['text']) . ',' .

convert_string_to_sqlsyntax($row['status']) . ',' .

(

(!isset($row['trans']) || $row['trans']=='') ?

'"*"' :

convert_string_to_sqlsyntax($row['trans'])

) .

',

NOW(), ' .

make_score_random_insert_update('id') .

')';

}

$sqltext = "INSERT INTO {$tbpref}words (

WoRomanization, WoStatusChanged," .

make_score_random_insert_update('iv') . "

) VALUES " . rtrim(implode(',', $sqlarr), ',');

runsql($sqltext, '');

$tooltip_mode = getSettingWithDefault('set-tooltip-mode');

$res = do_mysqli_query(

"SELECT WoID, WoTextLC, WoStatus, WoTranslation

);

do_mysqli_query(

"UPDATE {$tbpref}textitems2

);

?>

<p id="displ_message">

<img src="icn/waiting2.gif" /> Updating Texts

</p>

<script type="text/javascript">

const context = window.parent.document;

const tooltip = <?php echo json_encode($tooltip_mode == 1); ?>;

function change_term(term) {

$(".TERM" + term.hex, context)

.removeClass("status0")

.addClass("status" + term.WoStatus)

.addClass("word" + term.WoID)

.attr("data_wid", term.WoID)

.attr("data_status", term.WoStatus)

.attr("data_trans", term.translation);

if (tooltip) {

$(".TERM" + term.hex, context).each(

function() {

this.title = make_tooltip(

$(this).text(), $(this).attr('data_trans'),

$(this).attr('data_rom'), $(this).attr('data_status')

);

}

);

} else {

$(".TERM" + term.hex, context).attr('title', '');

}

}

<?php

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

$record["hex"] = strToClassName(prepare_textdata($record["WoTextLC"]));

$record["translation"] = $record["WoTranslation"];

echo "change_term(" . json_encode($record) . ");";

}

?>

$('#learnstatus', context)

.html('<?php echo addslashes(texttodocount2($tid)); ?>');

$('#displ_message').remove();

if (<?php echo json_encode($cleanUp); ?>) {

cleanupRightFrames();

}

</script>

<?php

mysqli_free_result($res);

flush();

{

global $tbpref;

$cnt = 0;

$offset = '';

$limit = (int)getSettingWithDefault('set-ggl-translation-per-page') + 1;

$sql = "SELECT LgName, LgDict1URI, LgDict2URI, LgGoogleTranslateURI

WHERE LgID = TxLgID AND TxID = $tid";

$res = do_mysqli_query($sql);

$record = mysqli_fetch_assoc($res);

$wb1 = isset($record['LgDict1URI']) ? $record['LgDict1URI'] : "";

$wb2 = isset($record['LgDict2URI']) ? $record['LgDict2URI'] : "";

$wb3 = isset($record['LgGoogleTranslateURI']) ?

$record['LgGoogleTranslateURI'] : "";

?>

<style>

.dict {

cursor: pointer;

}

.dict1:hover, .dict2:hover, .dict3:hover {

opacity:1;

color:red;

}

input[name="WoTranslation"] {

border: 1px solid red;

}

.del_trans{

cursor: pointer;

float: right;

}

.del_trans:after{

content: url(icn/broom.png);

opacity: 0.2;

}

.del_trans:hover:after{

opacity: 1;

}

</style>

<script type="text/javascript">

WBLINK1 = '<?php echo $wb1; ?>';

WBLINK2 = '<?php echo $wb2; ?>';

WBLINK3 = '<?php echo $wb3; ?>';

$('h3,h4,title').addClass('notranslate');

const bulk_interactions = function() {

$('[name="form1"]').submit(function() {

$('[name="WoTranslation"]').attr('name',$('[name="WoTranslation"]')

.attr('data_name'));

window.parent.frames['ru'].location.href = 'empty.html';

return true;

});

$('td').on(

'click',

'span.dict1, span.dict2, span.dict3',

function() {

if ($(this).hasClass( "dict1" ))

WBLINK = WBLINK1;

if ($(this).hasClass( "dict2" ))

WBLINK = WBLINK2;

if ($(this).hasClass( "dict3" ))

WBLINK = WBLINK3;

let dict_link = WBLINK;

let popup;

if (dict_link.startsWith('*')) {

popup = true;

dict_link = dict_link.substring(1);

}

try {

let final_url = new URL(dict_link);

popup |= final_url.searchParams.has("lwt_popup");

} catch (err) {

if (!(err instanceof TypeError)) {

throw err;

}

}

if (popup) {

owin(createTheDictUrl(

dict_link, $(this).parent().prev().text()

));

} else {

window.parent.frames['ru'].location.href = createTheDictUrl(

dict_link, $(this).parent().prev().text()

);

}

$('[name="WoTranslation"]')

.attr('name',$('[name="WoTranslation"]')

.attr('data_name'));

el = $(this).parent().parent().next().children();

el.attr('data_name', el.attr('name'));

el.attr('name','WoTranslation');

}

).on(

'click',

'.del_trans',

function() { $(this).prev().val('').focus(); }

);

const displayTranslations = setInterval(function() {

if ($(".trans>font").length == $(".trans").length) {

$('.trans').each(function() {

const txt = $(this).text();

const cnt = $(this).attr('id').replace('Trans_', '');

$(this).addClass('notranslate')

.html(

'<input type="text" name="term[' + cnt + '][trans]" value="'

+ txt + '" maxlength="100" class="respinput"></input>' +

'<div class="del_trans"></div>'

);

});

$('.term').each(function() {

$(this).parent().css('position', 'relative');

$(this).after(

'<div class="dict">' +

(WBLINK1 ? '<span class="dict1">D1</span>' : '') +

(WBLINK2 ? '<span class="dict2">D2</span>' : '') +

(WBLINK3 ? '<span class="dict3">Tr</span>' : '') +

'</div>'

);

});

$('iframe,#google_translate_element').remove();

selectToggle(true, 'form1');

$('[name^=term]').prop('disabled', false);

clearInterval(displayTranslations);

}

}, 300);

}

const bulk_checkbox = function() {

window.parent.frames['ru'].location.href = 'empty.html';

$('input[type="checkbox"]').change(function(){

let v = parseInt($(this).val());

const e = '[name=term\\[' + v + '\\]\\[text\\]],[name=term\\[' + v +

'\\]\\[lg\\]],[name=term\\[' + v + '\\]\\[status\\]]';

$(e).prop('disabled', !this.checked);

$('#Trans_'+v+' input').prop('disabled', !this.checked);

if ($('input[type="checkbox"]:checked').length) {

let operation_option;

if (this.checked) {

operation_option = 'Save';

} else if ($('input[name="offset"]').length) {

operation_option = 'Next';

} else {

operation_option = 'End';

}

$('input[type="submit"]').val(operation_option);

}

});

}

$(window).load(bulk_interactions);

$(document).ready(bulk_checkbox);

function googleTranslateElementInit() {

new google.translate.TranslateElement({

pageLanguage: '<?php echo $sl; ?>',

layout: google.translate.TranslateElement.InlineLayout.SIMPLE,

includedLanguages: '<?php echo $tl; ?>',

autoDisplay: false

}, 'google_translate_element');

}

</script>

<script type="text/javascript" src="//translate.google.com/translate_a/element.js?cb=googleTranslateElementInit"></script>

<script type="text/javascript">

function markAll() {

$('input[type^=submit]').val('Save');

selectToggle(true, 'form1');

$('[name^=term]').prop('disabled', false);

}

function markNone() {

const v = (!$('input[name^=offset]').length) ? 'End' : 'Next';

$('input[type^=submit]').val(v);

selectToggle(false,'form1');

$('[name^=term]').prop('disabled', true);

}

function changeTermToggles (elem) {

const v = elem.val();

if (v==6) {

$('.markcheck:checked').each(function() {

e=$('#Term_' + elem.val()).children('.term');

e.text(e.text().toLowerCase());

$('#Text_' + elem.val()).val(e.text().toLowerCase());

});

elem.prop('selectedIndex',0);

return false;

}

if (v==7) {

$('.markcheck:checked').each(function() {

$('#Trans_' + elem.val() + ' input').val('*');

});

elem.prop('selectedIndex',0);

return false;

}

$('.markcheck:checked').each(function() {

$('#Stat_' + elem.val()).val(v);

});

elem.prop('selectedIndex', 0);

return false;

}

</script>

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

<span class="notranslate">

<div id="google_translate_element"></div>

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

<tr class="notranslate">

<th class="th1 center" colspan="3">

<input type="button" value="Mark All" onclick="markAll()" />

<input type="button" value="Mark None" onclick="markNone()" />

<br />

</th>

</tr>

<tr class="notranslate">

<td class="td1">Marked Terms: </td>

<td class="td1">

<select onchange="changeTermToggles($(this));">

<option value="0" selected="selected">

[Choose...]

</option>

<optgroup label="Change Status">

<option value="1">Set Status To [1]</option>

<option value="2">Set Status To [2]</option>

<option value="3">Set Status To [3]</option>

<option value="4">Set Status To [4]</option>

<option value="5">Set Status To [5]</option>

<option value="99">Set Status To [WKn]</option>

<option value="98">Set Status To [Ign]</option>

</optgroup>

<option value="6">Set To Lowercase</option>

<option value="7">Delete Translation</option>

</select>

</td>

<td class="td1" style="min-width: 45px;">

<input type="submit" value="Save" />

</td>

</tr>

</table>

</span>

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

<tr class="notranslate">

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

<th class="th1" style="min-width:5em;">Term</th>

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

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

</tr>

<?php

$res = do_mysqli_query(

"SELECT Ti2Text AS word, Ti2LgID, MIN(Ti2Order) AS pos

);

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

if (++$cnt < $limit) {

$value = tohtml($record['word']);

?>

<tr>

<td class="td1 center notranslate">

<input name="marked[<?php echo $cnt ?>]" type="checkbox" class="markcheck" checked="checked" value="<?php echo $cnt ?>" />

</td>

<td id="Term_<?php echo $cnt ?>" class="td1 left notranslate">

<span class="term"><?php echo $value ?></span>

</td>

<td class="td1 trans" id="Trans_<?php echo $cnt ?>">

<?php echo mb_strtolower($value, 'UTF-8') ?>

</td>

<td class="td1 center notranslate">

<select id="Stat_<?php echo $cnt ?>" name="term[<?php echo $cnt ?>][status]">

<option value="1" selected="selected">[1]</option>

<option value="2">[2]</option>

<option value="3">[3]</option>

<option value="4">[4]</option>

<option value="5">[5]</option>

<option value="99">[WKn]</option>

<option value="98">[Ign]</option>

</select>

<input type="hidden" id="Text_<?php echo $cnt ?>" name="term[<?php echo $cnt ?>][text]" value="<?php echo $value ?>" />

<input type="hidden" name="term[<?php echo $cnt ?>][lg]" value="<?php echo tohtml($record['Ti2LgID']) ?>" />

</td>

</tr>

<?php

} else {

$offset = '<input type="hidden" name="offset" value="' .

($pos + $limit - 1) . '" />

<input type="hidden" name="sl" value="' . $sl . '" />

<input type="hidden" name="tl" value="' . $tl . '" />';

}

}

mysqli_free_result($res);

?>

</table>

<input type="hidden" name="tid" value="<?php echo $tid ?>" />

<?php echo $offset ?>

</form>

<?php