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>