function get_next_key($key = null, $tail = '')
{
global $range, $trans;
// bad
if ($key === null) {
$key = get_last_key();
}
if (empty($key)) {
return "a{$tail}";
}
$keylen = strlen($key);
$last_char = $key[$keylen - 1];
if ($last_char != '9') {
return substr($key, 0, $keylen - 1) . $range[$trans[$last_char] + 1] . $tail;
} else {
return get_next_key(substr($key, 0, -1), "a{$tail}");
}
}
adjust_autoincr('archivedtexts', 'AtID');
runsql("DELETE archtexttags FROM (archtexttags LEFT JOIN archivedtexts on AgAtID = AtID) WHERE AtID IS NULL", '');
$message = 'Unarchived Text(s): ' . $count;
}
}
}
}
}
// DEL
if (isset($_REQUEST['del'])) {
$message = runsql('delete from archivedtexts where AtID = ' . $_REQUEST['del'], "Archived Texts deleted");
adjust_autoincr('archivedtexts', 'AtID');
runsql("DELETE archtexttags FROM (archtexttags LEFT JOIN archivedtexts on AgAtID = AtID) WHERE AtID IS NULL", '');
} elseif (isset($_REQUEST['unarch'])) {
$message2 = runsql('insert into texts (TxLgID, TxTitle, TxText, TxAudioURI) select AtLgID, AtTitle, AtText, AtAudioURI from archivedtexts where AtID = ' . $_REQUEST['unarch'], "Texts added");
$id = get_last_key();
runsql('insert into texttags (TtTxID, TtT2ID) select ' . $id . ', AgT2ID from archtexttags where AgAtID = ' . $_REQUEST['unarch'], "");
splitText(get_first_value('select TxText as value from texts where TxID = ' . $id), get_first_value('select TxLgID as value from texts where TxID = ' . $id), $id);
$message1 = runsql('delete from archivedtexts where AtID = ' . $_REQUEST['unarch'], "Archived Texts deleted");
$message = $message1 . " / " . $message2 . " / Sentences added: " . get_first_value('select count(*) as value from sentences where SeTxID = ' . $id) . " / Text items added: " . get_first_value('select count(*) as value from textitems where TiTxID = ' . $id);
adjust_autoincr('archivedtexts', 'AtID');
runsql("DELETE archtexttags FROM (archtexttags LEFT JOIN archivedtexts on AgAtID = AtID) WHERE AtID IS NULL", '');
} elseif (isset($_REQUEST['op'])) {
// UPDATE
if ($_REQUEST['op'] == 'Change') {
$message = runsql('update archivedtexts set ' . 'AtLgID = ' . $_REQUEST["AtLgID"] . ', ' . 'AtTitle = ' . convert_string_to_sqlsyntax($_REQUEST["AtTitle"]) . ', ' . 'AtText = ' . convert_string_to_sqlsyntax($_REQUEST["AtText"]) . ', ' . 'AtAudioURI = ' . convert_string_to_sqlsyntax($_REQUEST["AtAudioURI"]) . ' ' . 'where AtID = ' . $_REQUEST["AtID"], "Updated");
$id = $_REQUEST["AtID"];
}
saveArchivedTextTags($id);
}
// CHG
function splitCheckText($text, $lid, $id)
{
// $id = -1 => Check, return protocol
// $id = -2 => Only return sentence array
// $id = TextID => Split: insert sentences/textitems entries in DB
global $tbpref;
$r = '';
$sql = "select * from " . $tbpref . "languages where LgID=" . $lid;
$res = do_mysql_query($sql);
$record = mysql_fetch_assoc($res);
if ($record == FALSE) {
my_die("Language data not found: {$sql}");
}
$removeSpaces = $record['LgRemoveSpaces'];
$splitEachChar = $record['LgSplitEachChar'];
$splitSentence = $record['LgRegexpSplitSentences'];
$noSentenceEnd = $record['LgExceptionsSplitSentences'];
$termchar = $record['LgRegexpWordCharacters'];
$replace = explode("|", $record['LgCharacterSubstitutions']);
$rtlScript = $record['LgRightToLeft'];
mysql_free_result($res);
$s = prepare_textdata($text);
$s = str_replace("\n", " ¶ ", $s);
$s = str_replace("\t", " ", $s);
$s = trim($s);
if ($splitEachChar) {
$s = preg_replace('/([^\\s])/u', "\$1 ", $s);
}
$s = preg_replace('/\\s{2,}/u', ' ', $s);
if ($id == -1) {
$r .= "<div style=\"margin-right:50px;\"><h4>Text</h4><p " . ($rtlScript ? 'dir="rtl"' : '') . ">" . str_replace("¶", "<br /><br />", tohtml($s)) . "</p>";
}
$s = str_replace('{', '[', $s);
// because of sent. spc. char
$s = str_replace('}', ']', $s);
foreach ($replace as $value) {
$fromto = explode("=", trim($value));
if (count($fromto) >= 2) {
$s = str_replace(trim($fromto[0]), trim($fromto[1]), $s);
}
}
$s = trim($s);
if ($noSentenceEnd != '') {
$s = preg_replace('/(' . $noSentenceEnd . ')\\s/u', '$1‧', $s);
}
$s = preg_replace('/([' . $splitSentence . '¶])\\s/u', "\$1\n", $s);
$s = str_replace(" ¶\n", "\n¶\n", $s);
$s = str_replace('‧', ' ', $s);
if ($s == '') {
$textLines = array($s);
} else {
$s = explode("\n", $s);
$l = count($s);
for ($i = 0; $i < $l; $i++) {
$s[$i] = trim($s[$i]);
if ($s[$i] != '') {
$pos = strpos($splitSentence, $s[$i]);
while ($pos !== false && $i > 0) {
$s[$i - 1] .= " " . $s[$i];
for ($j = $i + 1; $j < $l; $j++) {
$s[$j - 1] = $s[$j];
}
array_pop($s);
$l = count($s);
$pos = strpos($splitSentence, $s[$i]);
}
}
}
$l = count($s);
$textLines = array();
for ($i = 0; $i < $l; $i++) {
$zz = trim($s[$i]);
if ($zz != '') {
$textLines[] = $zz;
}
}
}
if ($id == -2) {
////////////////////////////////////
// Only return sentence array
return $textLines;
}
$lineWords = array();
if ($id == -1) {
////////////////////////////////////
// Check, return protocol
$wordList = array();
$wordSeps = array();
$r .= "<h4>Sentences</h4><ol>";
$sentNumber = 0;
foreach ($textLines as $value) {
$r .= "<li " . ($rtlScript ? 'dir="rtl"' : '') . ">" . tohtml(remove_spaces($value, $removeSpaces)) . "</li>";
$lineWords[$sentNumber] = preg_split('/([^' . $termchar . ']{1,})/u', $value, -1, PREG_SPLIT_DELIM_CAPTURE);
$l = count($lineWords[$sentNumber]);
for ($i = 0; $i < $l; $i++) {
$term = mb_strtolower($lineWords[$sentNumber][$i], 'UTF-8');
if ($term != '') {
if ($i % 2 == 0) {
if (array_key_exists($term, $wordList)) {
$wordList[$term][0]++;
$wordList[$term][1][] = $sentNumber;
} else {
$wordList[$term] = array(1, array($sentNumber));
}
} else {
$ww = remove_spaces($term, $removeSpaces);
if (array_key_exists($ww, $wordSeps)) {
$wordSeps[$ww]++;
} else {
$wordSeps[$ww] = 1;
}
}
}
}
$sentNumber += 1;
}
$r .= "</ol><h4>Word List <span class=\"red2\">(red = already saved)</span></h4><ul>";
ksort($wordList);
$anz = 0;
foreach ($wordList as $key => $value) {
$trans = get_first_value("select WoTranslation as value from " . $tbpref . "words where WoLgID = " . $lid . " and WoTextLC = " . convert_string_to_sqlsyntax($key));
if (!isset($trans)) {
$trans = "";
}
if ($trans == "*") {
$trans = "";
}
if ($trans != "") {
$r .= "<li " . ($rtlScript ? 'dir="rtl"' : '') . "><span class=\"red2\">[" . tohtml($key) . "] — " . $value[0] . " - " . tohtml(repl_tab_nl($trans)) . "</span></li>";
} else {
$r .= "<li " . ($rtlScript ? 'dir="rtl"' : '') . ">[" . tohtml($key) . "] — " . $value[0] . "</li>";
}
$anz++;
}
$r .= "</ul><p>TOTAL: " . $anz . "</p><h4>Non-Word List</h4><ul>";
if (array_key_exists('', $wordSeps)) {
unset($wordSeps['']);
}
ksort($wordSeps);
$anz = 0;
foreach ($wordSeps as $key => $value) {
$r .= "<li>[" . str_replace(" ", "<span class=\"backgray\"> </span>", tohtml($key)) . "] — " . $value . "</li>";
$anz++;
}
$r .= "</ul><p>TOTAL: " . $anz . "</p></div>";
return $r;
}
////////////////////////////////////
// Split: insert sentences/textitems entries in DB
$sentNumber = 0;
$lfdnr = 0;
foreach ($textLines as $value) {
$dummy = runsql('INSERT INTO ' . $tbpref . 'sentences (SeLgID, SeTxID, SeOrder, SeText) VALUES (' . $lid . ',' . $id . ',' . ($sentNumber + 1) . ',' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($value . ' ', $removeSpaces)) . ')', ' ');
$sentid = get_last_key();
$lineWords[$sentNumber] = preg_split('/([^' . $termchar . ']+)/u', $value . ' ', null, PREG_SPLIT_DELIM_CAPTURE);
$l = count($lineWords[$sentNumber]);
$sqltext = 'INSERT INTO ' . $tbpref . 'textitems (TiLgID, TiTxID, TiSeID, TiOrder, TiWordCount, TiText, TiTextLC, TiIsNotWord) VALUES ';
$lfdnr1 = 0;
for ($i = 0; $i < $l; $i++) {
$term = mb_strtolower($lineWords[$sentNumber][$i], 'UTF-8');
$rest2 = '';
$rest3 = '';
$rest4 = '';
$rest5 = '';
$rest6 = '';
$rest7 = '';
$rest8 = '';
$rest9 = '';
$restlc2 = '';
$restlc3 = '';
$restlc4 = '';
$restlc5 = '';
$restlc6 = '';
$restlc7 = '';
$restlc8 = '';
$restlc9 = '';
if ($term != '') {
if ($i % 2 == 0) {
$isnotwort = 0;
$rest = $lineWords[$sentNumber][$i];
$cnt = 0;
for ($j = $i + 1; $j < $l; $j++) {
if ($lineWords[$sentNumber][$j] != '') {
$rest .= $lineWords[$sentNumber][$j];
$cnt++;
if ($cnt == 2) {
$rest2 = $rest;
$restlc2 = mb_strtolower($rest, 'UTF-8');
}
if ($cnt == 4) {
$rest3 = $rest;
$restlc3 = mb_strtolower($rest, 'UTF-8');
}
if ($cnt == 6) {
$rest4 = $rest;
$restlc4 = mb_strtolower($rest, 'UTF-8');
}
if ($cnt == 8) {
$rest5 = $rest;
$restlc5 = mb_strtolower($rest, 'UTF-8');
}
if ($cnt == 10) {
$rest6 = $rest;
$restlc6 = mb_strtolower($rest, 'UTF-8');
}
if ($cnt == 12) {
$rest7 = $rest;
$restlc7 = mb_strtolower($rest, 'UTF-8');
}
if ($cnt == 14) {
$rest8 = $rest;
$restlc8 = mb_strtolower($rest, 'UTF-8');
}
if ($cnt == 16) {
$rest9 = $rest;
$restlc9 = mb_strtolower($rest, 'UTF-8');
break;
}
}
}
} else {
$isnotwort = 1;
}
$lfdnr++;
$lfdnr1++;
if ($lfdnr1 > 1) {
$sqltext .= ',';
}
$sqltext .= '(' . $lid . ',' . $id . ',' . $sentid . ',' . $lfdnr . ', 1, ' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($lineWords[$sentNumber][$i], $removeSpaces)) . ',' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($term, $removeSpaces)) . ',' . $isnotwort . ')';
if ($isnotwort == 0) {
if ($rest2 != '') {
$sqltext .= ',(' . $lid . ',' . $id . ',' . $sentid . ',' . $lfdnr . ', 2, ' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($rest2, $removeSpaces)) . ',' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($restlc2, $removeSpaces)) . ',' . $isnotwort . ')';
}
if ($rest3 != '') {
$sqltext .= ',(' . $lid . ',' . $id . ',' . $sentid . ',' . $lfdnr . ', 3, ' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($rest3, $removeSpaces)) . ',' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($restlc3, $removeSpaces)) . ',' . $isnotwort . ')';
}
if ($rest4 != '') {
$sqltext .= ',(' . $lid . ',' . $id . ',' . $sentid . ',' . $lfdnr . ', 4, ' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($rest4, $removeSpaces)) . ',' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($restlc4, $removeSpaces)) . ',' . $isnotwort . ')';
}
if ($rest5 != '') {
$sqltext .= ',(' . $lid . ',' . $id . ',' . $sentid . ',' . $lfdnr . ', 5, ' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($rest5, $removeSpaces)) . ',' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($restlc5, $removeSpaces)) . ',' . $isnotwort . ')';
}
if ($rest6 != '') {
$sqltext .= ',(' . $lid . ',' . $id . ',' . $sentid . ',' . $lfdnr . ', 6, ' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($rest6, $removeSpaces)) . ',' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($restlc6, $removeSpaces)) . ',' . $isnotwort . ')';
}
if ($rest7 != '') {
$sqltext .= ',(' . $lid . ',' . $id . ',' . $sentid . ',' . $lfdnr . ', 7, ' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($rest7, $removeSpaces)) . ',' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($restlc7, $removeSpaces)) . ',' . $isnotwort . ')';
}
if ($rest8 != '') {
$sqltext .= ',(' . $lid . ',' . $id . ',' . $sentid . ',' . $lfdnr . ', 8, ' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($rest8, $removeSpaces)) . ',' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($restlc8, $removeSpaces)) . ',' . $isnotwort . ')';
}
if ($rest9 != '') {
$sqltext .= ',(' . $lid . ',' . $id . ',' . $sentid . ',' . $lfdnr . ', 9, ' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($rest9, $removeSpaces)) . ',' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($restlc9, $removeSpaces)) . ',' . $isnotwort . ')';
}
}
}
}
if ($lfdnr > 0) {
$dummy = runsql($sqltext, '');
}
$sentNumber += 1;
}
}
|
<a href="<?php
echo get_page_link('edit_user');
?>
&user_id=<?php
echo $item->ID;
?>
">Редактировать</a>
|
<a class="button-control table-delete" data-set-action="delete_user">Удалить</a>
</p>
</td>
<td>
<?php
if (is_array($item->groups_ID)) {
$last = get_last_key($item->groups_ID);
foreach ($item->groups_ID as $key => $group) {
$key_search = array_multi_search($group, $groups, 'ID');
if ($key_search !== null) {
echo $groups[$key_search]->name;
if ($key != $last) {
echo ', ';
}
}
}
}
?>
</td>
</tr>
<?php
}
<?php
header("Cache-Control: no-cache, must-revalidate");
// HTTP/1.1
header("Expires: Sat, 26 Jul 1997 05:00:00 GMT");
// Date in the past
header('Content-type: application/json');
function get_last_key(&$array)
{
end($array);
return key($array);
}
$size = sizeof($results);
echo '[';
for ($i = 0; $i < $size; $i++) {
$item = $results[$i];
echo '{';
$last_field = get_last_key($item);
foreach ($item as $field_name => $value) {
echo '"$' . $field_name . '":' . json_encode($value);
if ($field_name != $last_field) {
echo ',';
}
}
echo '}';
if ($i < $size - 1) {
echo ',';
}
}
echo ']';
function splitText($text, $lid, $id)
{
$sql = "select * from languages where LgID=" . $lid;
$res = mysql_query($sql);
if ($res == FALSE) {
die("Invalid Query: {$sql}");
}
$record = mysql_fetch_assoc($res);
if ($record == FALSE) {
die("No results: {$sql}");
}
$removeSpaces = $record['LgRemoveSpaces'];
$splitEachChar = $record['LgSplitEachChar'];
$splitSentence = $record['LgRegexpSplitSentences'];
$noSentenceEnd = $record['LgExceptionsSplitSentences'];
$termchar = $record['LgRegexpWordCharacters'];
$replace = explode("|", $record['LgCharacterSubstitutions']);
mysql_free_result($res);
$s = str_replace("\r\n", "\n", $text);
$s = str_replace("\n", " ¶ ", $s);
$s = str_replace("\t", " ", $s);
$s = trim($s);
if ($splitEachChar) {
$s = preg_replace('/([^\\s])/u', "\$1 ", $s);
}
$s = preg_replace('/\\s{2,}/u', ' ', $s);
$s = str_replace('{', '[', $s);
// because of sent. spc. char
$s = str_replace('}', ']', $s);
foreach ($replace as $value) {
$fromto = explode("=", trim($value));
if (count($fromto) >= 2) {
$s = str_replace(trim($fromto[0]), trim($fromto[1]), $s);
}
}
$s = trim($s);
if ($noSentenceEnd != '') {
$s = preg_replace('/(' . $noSentenceEnd . ')\\s/u', '$1‧', $s);
}
$s = preg_replace('/([' . $splitSentence . '¶])\\s/u', "\$1\n", $s);
$s = str_replace(" ¶\n", "\n¶\n", $s);
$s = str_replace('‧', ' ', $s);
if ($s == '') {
$textLines = array($s);
} else {
$s = explode("\n", $s);
$l = count($s);
for ($i = 0; $i < $l; $i++) {
$s[$i] = trim($s[$i]);
if ($s[$i] != '') {
$pos = strpos($splitSentence, $s[$i]);
while ($pos !== false && $i > 0) {
$s[$i - 1] .= " " . $s[$i];
for ($j = $i + 1; $j < $l; $j++) {
$s[$j - 1] = $s[$j];
}
array_pop($s);
$l = count($s);
$pos = strpos($splitSentence, $s[$i]);
}
}
}
$l = count($s);
$textLines = array();
for ($i = 0; $i < $l; $i++) {
$zz = trim($s[$i]);
if ($zz != '') {
$textLines[] = $zz;
}
}
}
$lineWords = array();
$wordList = array();
$wordIndex = array();
$wordSeps = array();
$sentNumber = 0;
$lfdnr = 0;
foreach ($textLines as $value) {
$dummy = runsql('INSERT INTO sentences (SeLgID, SeTxID, SeOrder, SeText) VALUES (' . $lid . ',' . $id . ',' . ($sentNumber + 1) . ',' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($value . ' ', $removeSpaces)) . ')', ' ');
$sentid = get_last_key();
/**** Speichern Sätze Ende ***/
$lineWords[$sentNumber] = preg_split('/([^' . $termchar . ']+)/u', $value . ' ', null, PREG_SPLIT_DELIM_CAPTURE);
$l = count($lineWords[$sentNumber]);
$sqltext = 'INSERT INTO textitems (TiLgID, TiTxID, TiSeID, TiOrder, TiWordCount, TiText, TiTextLC, TiIsNotWord) VALUES ';
$lfdnr1 = 0;
for ($i = 0; $i < $l; $i++) {
$term = mb_strtolower($lineWords[$sentNumber][$i], 'UTF-8');
$rest2 = '';
$rest3 = '';
$rest4 = '';
$rest5 = '';
$rest6 = '';
$rest7 = '';
$rest8 = '';
$rest9 = '';
$restlc2 = '';
$restlc3 = '';
$restlc4 = '';
$restlc5 = '';
$restlc6 = '';
$restlc7 = '';
$restlc8 = '';
$restlc9 = '';
if ($term != '') {
if ($i % 2 == 0) {
$isnotwort = 0;
$rest = $lineWords[$sentNumber][$i];
$cnt = 0;
for ($j = $i + 1; $j < $l; $j++) {
if ($lineWords[$sentNumber][$j] != '') {
$rest .= $lineWords[$sentNumber][$j];
$cnt++;
if ($cnt == 2) {
$rest2 = $rest;
$restlc2 = mb_strtolower($rest, 'UTF-8');
}
if ($cnt == 4) {
$rest3 = $rest;
$restlc3 = mb_strtolower($rest, 'UTF-8');
}
if ($cnt == 6) {
$rest4 = $rest;
$restlc4 = mb_strtolower($rest, 'UTF-8');
}
if ($cnt == 8) {
$rest5 = $rest;
$restlc5 = mb_strtolower($rest, 'UTF-8');
}
if ($cnt == 10) {
$rest6 = $rest;
$restlc6 = mb_strtolower($rest, 'UTF-8');
}
if ($cnt == 12) {
$rest7 = $rest;
$restlc7 = mb_strtolower($rest, 'UTF-8');
}
if ($cnt == 14) {
$rest8 = $rest;
$restlc8 = mb_strtolower($rest, 'UTF-8');
}
if ($cnt == 16) {
$rest9 = $rest;
$restlc9 = mb_strtolower($rest, 'UTF-8');
break;
}
}
}
} else {
$isnotwort = 1;
}
$lfdnr++;
$lfdnr1++;
if ($lfdnr1 > 1) {
$sqltext .= ',';
}
$sqltext .= '(' . $lid . ',' . $id . ',' . $sentid . ',' . $lfdnr . ', 1, ' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($lineWords[$sentNumber][$i], $removeSpaces)) . ',' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($term, $removeSpaces)) . ',' . $isnotwort . ')';
if ($isnotwort == 0) {
if ($rest2 != '') {
$sqltext .= ',(' . $lid . ',' . $id . ',' . $sentid . ',' . $lfdnr . ', 2, ' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($rest2, $removeSpaces)) . ',' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($restlc2, $removeSpaces)) . ',' . $isnotwort . ')';
}
if ($rest3 != '') {
$sqltext .= ',(' . $lid . ',' . $id . ',' . $sentid . ',' . $lfdnr . ', 3, ' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($rest3, $removeSpaces)) . ',' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($restlc3, $removeSpaces)) . ',' . $isnotwort . ')';
}
if ($rest4 != '') {
$sqltext .= ',(' . $lid . ',' . $id . ',' . $sentid . ',' . $lfdnr . ', 4, ' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($rest4, $removeSpaces)) . ',' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($restlc4, $removeSpaces)) . ',' . $isnotwort . ')';
}
if ($rest5 != '') {
$sqltext .= ',(' . $lid . ',' . $id . ',' . $sentid . ',' . $lfdnr . ', 5, ' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($rest5, $removeSpaces)) . ',' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($restlc5, $removeSpaces)) . ',' . $isnotwort . ')';
}
if ($rest6 != '') {
$sqltext .= ',(' . $lid . ',' . $id . ',' . $sentid . ',' . $lfdnr . ', 6, ' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($rest6, $removeSpaces)) . ',' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($restlc6, $removeSpaces)) . ',' . $isnotwort . ')';
}
if ($rest7 != '') {
$sqltext .= ',(' . $lid . ',' . $id . ',' . $sentid . ',' . $lfdnr . ', 7, ' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($rest7, $removeSpaces)) . ',' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($restlc7, $removeSpaces)) . ',' . $isnotwort . ')';
}
if ($rest8 != '') {
$sqltext .= ',(' . $lid . ',' . $id . ',' . $sentid . ',' . $lfdnr . ', 8, ' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($rest8, $removeSpaces)) . ',' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($restlc8, $removeSpaces)) . ',' . $isnotwort . ')';
}
if ($rest9 != '') {
$sqltext .= ',(' . $lid . ',' . $id . ',' . $sentid . ',' . $lfdnr . ', 9, ' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($rest9, $removeSpaces)) . ',' . convert_string_to_sqlsyntax_notrim_nonull(remove_spaces($restlc9, $removeSpaces)) . ',' . $isnotwort . ')';
}
}
}
}
if ($lfdnr > 0) {
$dummy = runsql($sqltext, '');
}
$sentNumber += 1;
}
}
function string_values($arr, $var = null, $par = null)
{
$str = '';
$mode = is_assoc_array($arr) && $par == null ? true : false;
if ($mode) {
$par = $var;
}
$custom = array('separ' => ',', 'empty' => 'NULL', 'middle' => '=', 'body' => "'", 'json' => false);
$custom = set_merge($custom, $par);
$arr = take_good_array($arr, true, $custom['json']);
if (!$mode) {
$var = take_good_array($var, false, $custom['json']);
if (count($arr) == 1 && count($var) > 1) {
$var = array(json_val_encode($var));
}
}
$L = get_last_key($arr);
$i = 1;
if (!$mode && $var) {
$B = count($arr) < count($var) ? count($arr) : count($var);
} else {
$B = count($arr);
}
foreach ($arr as $key => $item) {
if ($i <= $B) {
$item1 = $item2 = null;
if ($mode) {
$item1 = $key;
$item2 = $item;
} elseif (isset($var[$key])) {
$item1 = $item;
$item2 = $var[$key];
}
if (is_jsoned($item1)) {
$item1 = json_val_encode($item1);
}
if (is_jsoned($item2)) {
$item2 = json_val_encode($item2);
}
$str .= "{$item1}{$custom['middle']}{$custom['body']}{$item2}{$custom['body']}";
if ($key != $L && $i < $B) {
$str .= $custom['separ'];
}
$i++;
}
}
return $str;
}
echo $user->last_ip;
?>
</td>
</tr>
<tr>
<td>Последнее место</td>
<td><?php
echo $user->last_place;
?>
</td>
</tr>
<tr>
<td>Группы</td>
<td><?php
if (is_array($user->groups_ID)) {
$last = get_last_key($user->groups_ID);
foreach ($user->groups_ID as $key => $group) {
$key_search = array_multi_search($group, $groups, 'ID');
if ($key_search !== null) {
echo $groups[$key_search]->name;
if ($key != $last) {
echo ', ';
}
}
}
}
?>
</td>
</tr>
<tr>
<td>Права</td>
