Помогите дополнить плагин (Транслит ссылок дополнительных полей от LazyDev) под php 8.1 и dle 17?

вопрос

Доброго времени суток. Есть плагин, Используем транслит вместо кириллицы в ссылках дополнительных полей от LazyDev, я его подправил под dle 17, он работает как нужно. Все доп поля такого вида работают нормально:

/xfsearch/nacionalnye-kuhni/abhazskaja/

Но я вывожу некоторые поля по другому:

/xfsearch/abhazskaja/

В шаблоне так:

<a href="/xfsearch/[nacionalnye-kuhni limit="999"]/" >[nacionalnye-kuhni limit="999"]</a>

В данном случае я создал новый тег в engine/modules/show.full.php
Найти и добавить ниже

Показать / Скрыть текст


if ( preg_match( "#\\[xfvalue_{$preg_safe_name} limit=['\"](.+?)['\"]\\]#i", $tpl->copy_template, $matches ) ) {
	$tpl->set( $matches[0], clear_content($xfieldsdata[$value[0]], $matches[1]) );
}


if ( preg_match( "#\\[xfvalue_{$preg_safe_name} limit-totranslit=['\"](.+?)['\"]\\]#i", $tpl->copy_template, $matches ) ) {
	$tpl->set( $matches[0], totranslit(clear_content($xfieldsdata[$value[0]], $matches[1])) );
}

Теперь в шаблоне так: В шаблоне так:

<a href="/xfsearch/[nacionalnye-kuhni limit="999"]/" >[nacionalnye-kuhni limit-totranslit="999"]</a>

Но остается проблема с редиректом в

engine/engine.php

Найти и заменить:

Показать / Скрыть текст


$sql_select = "SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.descr, p.keywords, p.category, p.alt_name, p.comm_num, p.allow_comm, p.allow_main, p.approve, p.fixed, p.symbol, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.disable_index, e.editdate, e.editor, e.reason {$user_select}FROM " . PREFIX . "_post p LEFT JOIN " . PREFIX . "_post_extras e ON (p.id=e.news_id) {$user_join}";
$sql_count  = "SELECT COUNT(*) as count FROM " . PREFIX . "_post p INNER JOIN " . PREFIX . "_xfsearch xf on (xf.news_id=p.id) {$cat_join}WHERE {$stop_list}xf.tagname = '{$xfname}' AND xf.tagvalue='{$xf}' AND approve=1";


$data_xf = xfieldsload();
$this_xf = array_filter($data_xf, function($item) use($xfname) {
    return $item[0] == $xfname && $item[34] == 1;
});

if ($this_xf) {
    $sql_select_ids = false;
  	$translit_xf = totranslit($xf, true, false);
    $url_page = $config['http_home_url'] . "xfsearch/{$xfname}/" . rawurlencode(dle_strtolower(str_replace(["&#039;", "&quot;", "&amp;", "&#123;", "&#91;", "&#58;", "/"], ["'", '"', "&", "{", "[", ":", "&frasl;"], $translit_xf)));
    if ($xf != $translit_xf) {
        $re_url = $url_page . '/';
        header("HTTP/1.0 301 Moved Permanently");
        header("Location: {$re_url}");
        die("Redirect");
    }
  
  	$xf_temp = $db->super_query("SELECT tagvalue FROM " . PREFIX . "_xfsearch WHERE tagname='{$xfname}' AND tagvalue_translit='{$xf}' LIMIT 1");
    $sql_select = "SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.category, p.alt_name, p.comm_num, p.allow_comm, p.fixed, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.editdate, e.editor, e.reason {$user_select} FROM " . PREFIX . "_post p INNER JOIN " . PREFIX . "_xfsearch xf on (xf.news_id=p.id) {$cat_join} LEFT JOIN " . PREFIX . "_post_extras e ON (p.id=e.news_id) {$user_join} WHERE {$stop_list} xf.tagname = '{$xfname}' AND xf.tagvalue_translit='{$xf}' AND p.approve=1 " . $where_date . " ORDER BY " . $news_sort_by . " " . $news_direction_by . " LIMIT " . $cstart . "," . $config['news_number'];
    $sql_count  = "SELECT COUNT(*) as count FROM " . PREFIX . "_post p INNER JOIN " . PREFIX . "_xfsearch xf on (xf.news_id=p.id) {$cat_join}WHERE {$stop_list}xf.tagname = '{$xfname}' AND xf.tagvalue_translit='{$xf}' AND approve=1";
  	$xf = stripslashes($xf_temp['tagvalue']);
} else {
	$sql_select = "SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.descr, p.keywords, p.category, p.alt_name, p.comm_num, p.allow_comm, p.allow_main, p.approve, p.fixed, p.symbol, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.disable_index, e.editdate, e.editor, e.reason {$user_select}FROM " . PREFIX . "_post p LEFT JOIN " . PREFIX . "_post_extras e ON (p.id=e.news_id) {$user_join}";
    $sql_count  = "SELECT COUNT(*) as count FROM " . PREFIX . "_post p INNER JOIN " . PREFIX . "_xfsearch xf on (xf.news_id=p.id) {$cat_join}WHERE {$stop_list}xf.tagname = '{$xfname}' AND xf.tagvalue='{$xf}' AND approve=1";
}

Здесь, к сожалению у меня не хватает знаний.
Заранее спасибо за любую помощь.

Ответа пока нет

$data_xf = xfieldsload(); $this_xf = array_filter($data_xf, function($item) use($xfname) { return $item[0] == $xfname && $item[34] == 1; }); $this_xf2 = array_filter($data_xf, function($item) use($xfname) { return $item[0] != $xfname && $item[34] == 1; }); if ($this_xf) { $sql_select_ids = false; $translit_xf = totranslit($xf, true, false); $url_page = $config['http_home_url'] . "xfsearch/{$xfname}/" . rawurlencode(dle_strtolower(str_replace(["'", """, "&", "{", "[", ":", "/"], ["'", '"', "&", "{", "[", ":", "&frasl;"], $translit_xf))); if ($xf != $translit_xf) { $re_url = $url_page . '/'; header("HTTP/1.0 301 Moved Permanently"); header("Location: {$re_url}"); die("Redirect"); } $xf_temp = $db->super_query("SELECT tagvalue FROM " . PREFIX . "_xfsearch WHERE tagname='{$xfname}' AND tagvalue_translit='{$xf}' LIMIT 1"); $sql_select = "SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.category, p.alt_name, p.comm_num, p.allow_comm, p.fixed, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.editdate, e.editor, e.reason {$user_select} FROM " . PREFIX . "_post p INNER JOIN " . PREFIX . "_xfsearch xf on (xf.news_id=p.id) {$cat_join} LEFT JOIN " . PREFIX . "_post_extras e ON (p.id=e.news_id) {$user_join} WHERE {$stop_list} xf.tagname = '{$xfname}' AND xf.tagvalue_translit='{$xf}' AND p.approve=1 " . $where_date . " ORDER BY " . $news_sort_by . " " . $news_direction_by . " LIMIT " . $cstart . "," . $config['news_number']; $sql_count = "SELECT COUNT(*) as count FROM " . PREFIX . "_post p INNER JOIN " . PREFIX . "_xfsearch xf on (xf.news_id=p.id) {$cat_join}WHERE {$stop_list}xf.tagname = '{$xfname}' AND xf.tagvalue_translit='{$xf}' AND approve=1"; $xf = stripslashes($xf_temp['tagvalue']); } else { $sql_select = "SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.descr, p.keywords, p.category, p.alt_name, p.comm_num, p.allow_comm, p.allow_main, p.approve, p.fixed, p.symbol, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.disable_index, e.editdate, e.editor, e.reason {$user_select}FROM " . PREFIX . "_post p LEFT JOIN " . PREFIX . "_post_extras e ON (p.id=e.news_id) {$user_join}"; $sql_count = "SELECT COUNT(*) as count FROM " . PREFIX . "_post p INNER JOIN " . PREFIX . "_xfsearch xf on (xf.news_id=p.id) {$cat_join}WHERE {$stop_list}xf.tagname = '{$xfname}' AND xf.tagvalue='{$xf}' AND approve=1"; } if ($this_xf2) { $sql_select_ids = false; $translit_xf = totranslit($xf, true, false); $url_page = $config['http_home_url'] . "xfsearch/" . rawurlencode(dle_strtolower(str_replace(["'", """, "&", "{", "[", ":", "/"], ["'", '"', "&", "{", "[", ":", "&frasl;"], $translit_xf))); if ($xf != $translit_xf) { $re_url = $url_page . '/'; header("HTTP/1.0 301 Moved Permanently"); header("Location: {$re_url}"); die("Redirect"); } $xf_temp = $db->super_query("SELECT tagvalue FROM " . PREFIX . "_xfsearch WHERE tagvalue_translit='{$xf}' LIMIT 1"); $sql_select = "SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.category, p.alt_name, p.comm_num, p.allow_comm, p.fixed, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.editdate, e.editor, e.reason {$user_select} FROM " . PREFIX . "_post p INNER JOIN " . PREFIX . "_xfsearch xf on (xf.news_id=p.id) {$cat_join} LEFT JOIN " . PREFIX . "_post_extras e ON (p.id=e.news_id) {$user_join} WHERE {$stop_list} xf.tagname = '{$xfname}' AND xf.tagvalue_translit='{$xf}' AND p.approve=1 " . $where_date . " ORDER BY " . $news_sort_by . " " . $news_direction_by . " LIMIT " . $cstart . "," . $config['news_number']; $sql_count = "SELECT COUNT(*) as count FROM " . PREFIX . "_post p INNER JOIN " . PREFIX . "_xfsearch xf on (xf.news_id=p.id) {$cat_join}WHERE {$stop_list}xf.tagname = '{$xfname}' AND xf.tagvalue_translit='{$xf}' AND approve=1"; $xf = stripslashes($xf_temp['tagvalue']); } else { $sql_select = "SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.descr, p.keywords, p.category, p.alt_name, p.comm_num, p.allow_comm, p.allow_main, p.approve, p.fixed, p.symbol, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.disable_index, e.editdate, e.editor, e.reason {$user_select}FROM " . PREFIX . "_post p LEFT JOIN " . PREFIX . "_post_extras e ON (p.id=e.news_id) {$user_join}"; $sql_count = "SELECT COUNT(*) as count FROM " . PREFIX . "_post p INNER JOIN " . PREFIX . "_xfsearch xf on (xf.news_id=p.id) {$cat_join}WHERE {$stop_list}xf.tagname = '{$xfname}' AND xf.tagvalue='{$xf}' AND approve=1"; }

$data_xf = xfieldsload(); $this_xf = array_filter($data_xf, function($item) use($xfname) { return $item[0] == $xfname && $item[34] == 1; }); if ($this_xf) { $sql_select_ids = false; $translit_xf = totranslit($xf, true, false); if($xfname) { $url_page = $config['http_home_url'] . "xfsearch/{$xfname}/" . rawurlencode(dle_strtolower(str_replace(["'", """, "&", "{", "[", ":", "/"], ["'", '"', "&", "{", "[", ":", "&frasl;"], $translit_xf))); } else { $url_page = $config['http_home_url'] . "xfsearch/" . rawurlencode(dle_strtolower(str_replace(["'", """, "&", "{", "[", ":", "/"], ["'", '"', "&", "{", "[", ":", "&frasl;"], $translit_xf))); } if ($xf != $translit_xf) { $re_url = $url_page . '/'; header("HTTP/1.0 301 Moved Permanently"); header("Location: {$re_url}"); die("Redirect"); } $xf_temp = $db->super_query("SELECT tagvalue FROM " . PREFIX . "_xfsearch WHERE tagname='{$xfname}' AND tagvalue_translit='{$xf}' LIMIT 1"); $sql_select = "SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.category, p.alt_name, p.comm_num, p.allow_comm, p.fixed, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.editdate, e.editor, e.reason {$user_select} FROM " . PREFIX . "_post p INNER JOIN " . PREFIX . "_xfsearch xf on (xf.news_id=p.id) {$cat_join} LEFT JOIN " . PREFIX . "_post_extras e ON (p.id=e.news_id) {$user_join} WHERE {$stop_list} xf.tagname = '{$xfname}' AND xf.tagvalue_translit='{$xf}' AND p.approve=1 " . $where_date . " ORDER BY " . $news_sort_by . " " . $news_direction_by . " LIMIT " . $cstart . "," . $config['news_number']; $sql_count = "SELECT COUNT(*) as count FROM " . PREFIX . "_post p INNER JOIN " . PREFIX . "_xfsearch xf on (xf.news_id=p.id) {$cat_join}WHERE {$stop_list}xf.tagname = '{$xfname}' AND xf.tagvalue_translit='{$xf}' AND approve=1"; $xf = stripslashes($xf_temp['tagvalue']); } else { $sql_select = "SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.descr, p.keywords, p.category, p.alt_name, p.comm_num, p.allow_comm, p.allow_main, p.approve, p.fixed, p.symbol, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.disable_index, e.editdate, e.editor, e.reason {$user_select}FROM " . PREFIX . "_post p LEFT JOIN " . PREFIX . "_post_extras e ON (p.id=e.news_id) {$user_join}"; $sql_count = "SELECT COUNT(*) as count FROM " . PREFIX . "_post p INNER JOIN " . PREFIX . "_xfsearch xf on (xf.news_id=p.id) {$cat_join}WHERE {$stop_list}xf.tagname = '{$xfname}' AND xf.tagvalue='{$xf}' AND approve=1"; }

<script> window.addEventListener('load', ()=> { $('#category').on('change', function() { var value = $(this).val(); if ($.isArray(value)) { ShowOrHideEx("xfield_holder_year", jQuery.inArray('1', value) != -1 || jQuery.inArray('2', value) != -1 ); } else { ShowOrHideEx("xfield_holder_year", value == 1 || value==2); } }) }); </script> year доп поле . 1 и 2 катег

2 комментария

Юзер

167

ushkom - 2023-06-2925 января 2024 13:51 - #82671

Пытался этот кусок кода заменить на:


$data_xf = xfieldsload();
$this_xf = array_filter($data_xf, function($item) use($xfname) {
    return $item[0] == $xfname && $item[34] == 1;
});

$this_xf2 = array_filter($data_xf, function($item) use($xfname) {
    return $item[0] != $xfname && $item[34] == 1;
});

if ($this_xf) {
    $sql_select_ids = false;
  	$translit_xf = totranslit($xf, true, false);
    $url_page = $config['http_home_url'] . "xfsearch/{$xfname}/" . rawurlencode(dle_strtolower(str_replace(["&#039;", "&quot;", "&amp;", "&#123;", "&#91;", "&#58;", "/"], ["'", '"', "&", "{", "[", ":", "&frasl;"], $translit_xf)));

    if ($xf != $translit_xf) {
        $re_url = $url_page . '/';
        header("HTTP/1.0 301 Moved Permanently");
        header("Location: {$re_url}");
        die("Redirect");
    }
  
  	$xf_temp = $db->super_query("SELECT tagvalue FROM " . PREFIX . "_xfsearch WHERE tagname='{$xfname}' AND tagvalue_translit='{$xf}' LIMIT 1");
    $sql_select = "SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.category, p.alt_name, p.comm_num, p.allow_comm, p.fixed, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.editdate, e.editor, e.reason {$user_select} FROM " . PREFIX . "_post p INNER JOIN " . PREFIX . "_xfsearch xf on (xf.news_id=p.id) {$cat_join} LEFT JOIN " . PREFIX . "_post_extras e ON (p.id=e.news_id) {$user_join} WHERE {$stop_list} xf.tagname = '{$xfname}' AND xf.tagvalue_translit='{$xf}' AND p.approve=1 " . $where_date . " ORDER BY " . $news_sort_by . " " . $news_direction_by . " LIMIT " . $cstart . "," . $config['news_number'];
    $sql_count  = "SELECT COUNT(*) as count FROM " . PREFIX . "_post p INNER JOIN " . PREFIX . "_xfsearch xf on (xf.news_id=p.id) {$cat_join}WHERE {$stop_list}xf.tagname = '{$xfname}' AND xf.tagvalue_translit='{$xf}' AND approve=1";
  	$xf = stripslashes($xf_temp['tagvalue']);
} else {
	$sql_select = "SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.descr, p.keywords, p.category, p.alt_name, p.comm_num, p.allow_comm, p.allow_main, p.approve, p.fixed, p.symbol, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.disable_index, e.editdate, e.editor, e.reason {$user_select}FROM " . PREFIX . "_post p LEFT JOIN " . PREFIX . "_post_extras e ON (p.id=e.news_id) {$user_join}";
    $sql_count  = "SELECT COUNT(*) as count FROM " . PREFIX . "_post p INNER JOIN " . PREFIX . "_xfsearch xf on (xf.news_id=p.id) {$cat_join}WHERE {$stop_list}xf.tagname = '{$xfname}' AND xf.tagvalue='{$xf}' AND approve=1";
}

if ($this_xf2) {
    $sql_select_ids = false;
  	$translit_xf = totranslit($xf, true, false);
    $url_page = $config['http_home_url'] . "xfsearch/" . rawurlencode(dle_strtolower(str_replace(["&#039;", "&quot;", "&amp;", "&#123;", "&#91;", "&#58;", "/"], ["'", '"', "&", "{", "[", ":", "&frasl;"], $translit_xf)));

    if ($xf != $translit_xf) {
        $re_url = $url_page . '/';
        header("HTTP/1.0 301 Moved Permanently");
        header("Location: {$re_url}");
        die("Redirect");
    }
	
  
  	$xf_temp = $db->super_query("SELECT tagvalue FROM " . PREFIX . "_xfsearch WHERE tagvalue_translit='{$xf}' LIMIT 1");
    $sql_select = "SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.category, p.alt_name, p.comm_num, p.allow_comm, p.fixed, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.editdate, e.editor, e.reason {$user_select} FROM " . PREFIX . "_post p INNER JOIN " . PREFIX . "_xfsearch xf on (xf.news_id=p.id) {$cat_join} LEFT JOIN " . PREFIX . "_post_extras e ON (p.id=e.news_id) {$user_join} WHERE {$stop_list} xf.tagname = '{$xfname}' AND xf.tagvalue_translit='{$xf}' AND p.approve=1 " . $where_date . " ORDER BY " . $news_sort_by . " " . $news_direction_by . " LIMIT " . $cstart . "," . $config['news_number'];
    $sql_count  = "SELECT COUNT(*) as count FROM " . PREFIX . "_post p INNER JOIN " . PREFIX . "_xfsearch xf on (xf.news_id=p.id) {$cat_join}WHERE {$stop_list}xf.tagname = '{$xfname}' AND xf.tagvalue_translit='{$xf}' AND approve=1";
  	$xf = stripslashes($xf_temp['tagvalue']);
} else {
	$sql_select = "SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.descr, p.keywords, p.category, p.alt_name, p.comm_num, p.allow_comm, p.allow_main, p.approve, p.fixed, p.symbol, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.disable_index, e.editdate, e.editor, e.reason {$user_select}FROM " . PREFIX . "_post p LEFT JOIN " . PREFIX . "_post_extras e ON (p.id=e.news_id) {$user_join}";
    $sql_count  = "SELECT COUNT(*) as count FROM " . PREFIX . "_post p INNER JOIN " . PREFIX . "_xfsearch xf on (xf.news_id=p.id) {$cat_join}WHERE {$stop_list}xf.tagname = '{$xfname}' AND xf.tagvalue='{$xf}' AND approve=1";
}

Я скорее всего условие прописал:

$this_xf2 = array_filter($data_xf, function($item) use($xfname) {
    return $item[0] != $xfname && $item[34] == 1;
});

Но не могу понять что именно не верно.
Заранее спасибо за помощь

ushkom - 2023-06-2931 января 2024 19:31 - #82694

Если не сложно, помогите правильно составить условие. Спасибо


$data_xf = xfieldsload();

$this_xf = array_filter($data_xf, function($item) use($xfname) {
    return $item[0] == $xfname && $item[34] == 1;
});

if ($this_xf) {
    $sql_select_ids = false;
  	$translit_xf = totranslit($xf, true, false);
	if($xfname) {
    $url_page = $config['http_home_url'] . "xfsearch/{$xfname}/" . rawurlencode(dle_strtolower(str_replace(["&#039;", "&quot;", "&amp;", "&#123;", "&#91;", "&#58;", "/"], ["'", '"', "&", "{", "[", ":", "&frasl;"], $translit_xf)));
    } else {
	$url_page = $config['http_home_url'] . "xfsearch/" . rawurlencode(dle_strtolower(str_replace(["&#039;", "&quot;", "&amp;", "&#123;", "&#91;", "&#58;", "/"], ["'", '"', "&", "{", "[", ":", "&frasl;"], $translit_xf)));	 
    }
	
	if ($xf != $translit_xf) {
        $re_url = $url_page . '/';
        header("HTTP/1.0 301 Moved Permanently");
        header("Location: {$re_url}");
        die("Redirect");
    }
  
  	$xf_temp = $db->super_query("SELECT tagvalue FROM " . PREFIX . "_xfsearch WHERE tagname='{$xfname}' AND tagvalue_translit='{$xf}' LIMIT 1");
    $sql_select = "SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.category, p.alt_name, p.comm_num, p.allow_comm, p.fixed, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.editdate, e.editor, e.reason {$user_select} FROM " . PREFIX . "_post p INNER JOIN " . PREFIX . "_xfsearch xf on (xf.news_id=p.id) {$cat_join} LEFT JOIN " . PREFIX . "_post_extras e ON (p.id=e.news_id) {$user_join} WHERE {$stop_list} xf.tagname = '{$xfname}' AND xf.tagvalue_translit='{$xf}' AND p.approve=1 " . $where_date . " ORDER BY " . $news_sort_by . " " . $news_direction_by . " LIMIT " . $cstart . "," . $config['news_number'];
    $sql_count  = "SELECT COUNT(*) as count FROM " . PREFIX . "_post p INNER JOIN " . PREFIX . "_xfsearch xf on (xf.news_id=p.id) {$cat_join}WHERE {$stop_list}xf.tagname = '{$xfname}' AND xf.tagvalue_translit='{$xf}' AND approve=1";
  	$xf = stripslashes($xf_temp['tagvalue']);
} else {
	$sql_select = "SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.descr, p.keywords, p.category, p.alt_name, p.comm_num, p.allow_comm, p.allow_main, p.approve, p.fixed, p.symbol, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.disable_index, e.editdate, e.editor, e.reason {$user_select}FROM " . PREFIX . "_post p LEFT JOIN " . PREFIX . "_post_extras e ON (p.id=e.news_id) {$user_join}";
    $sql_count  = "SELECT COUNT(*) as count FROM " . PREFIX . "_post p INNER JOIN " . PREFIX . "_xfsearch xf on (xf.news_id=p.id) {$cat_join}WHERE {$stop_list}xf.tagname = '{$xfname}' AND xf.tagvalue='{$xf}' AND approve=1";
}

Помогите дополнить плагин (Транслит ссылок дополнительных полей от LazyDev) под php 8.1 и dle 17?

Ответа пока нет

2 комментария

Похожие вопросы

Все публикации пользователя

Алфавит

Новости пользователя, могут смотреть только авторы, что подправить?

Как вывести id пользователя в адресе на персональной странице, вместо логина?

Как добавить пагинацию в скрипте ?

В каких файлах DLE нужно изменить код, чтобы выводить материалы не из dle_post?

Как реализовать вывод ошибки в случае отсутствия новостей?

Как вывести новости на модерации на странице моих новостей?

Где находится запрос который выводит новости пользователя на отдельной странице?

Подскажите пожалуйста, как прикрутить навигацию?