Опытный пользователь
Сообщений: 270
Зарегистрирован: 08.03.2011 08:49
|
У меня стоит еще ужасное ЧПУ, может с ним связано =(
jikaka, а как в базе для поля увеличить размер подскажи пожалуйста? Вроде news_id в базе увеличивается...
Объединено 23.05.2016 07:59:
Файл с дурацкими ЧПУ, может в них проблема(
Объединено 23.05.2016 09:48:
Мое горе чпу news.php, может проблема в нем=(
Код <?php
require_once "maincore.php";
require_once THEMES."templates/header.php";
function makeurl_news($url,$id,$cat,$suffix='.html') {
return $url.'__'.intval($cat).'_'.intval($id).$suffix;
}
if (!function_exists('translit')) {
function translit($st) {
$st = strtr($st, "абвгдеёзийклмнопрстуфхъыэ_", "abvgdeeziyklmnoprstufh'ie_");
$st = strtr($st, "АБВГДЕЁЗИЙКЛМНОПРСТУФХЪЫЭ_","ABVGDEEZIYKLMNOPRSTUFH'IEI");
//$st = strtr($st, "АБВГДЕЁЗИЙКЛМНОПРСТУФХЪЫЭ_", "abvgdeeziyklmnoprstufh'ie_");
$st = strtr($st, array("ж" => "zh", "ц" => "ts",
"ч" => "ch", "ш" => "sh", "щ" => "shch",
"ь" => "", "ю" => "yu", "я" => "ya",
"Ж" => "ZH", "Ц" => "TS", "Ч" => "CH",
"Ш" => "SH", "Щ" => "SHCH", "Ь" => "",
"Ю" => "YU", "Я" => "YA", "ї" => "i",
"Ї" => "Yi", "є" => "ie", "Є" => "Ye"));
$search = array(".", ",", ":", ";", "'", '"', '-', '«', '»');
$replace = array("", "", "", "", "", "", '_', '', '');
$st = str_replace($search, $replace, $st);
$st = str_replace("&", " and ", $st);
$st = str_replace("&", " and ", $st);
$st = str_replace(" ", " ", $st);
$st = str_replace(" ", "_", $st);
$st = str_replace("__", "_", $st);
$st = preg_replace('/[^a-z0-9_]/','',$st);
$st = strtolower($st);
return $st;
}
}
add_to_head('<style>
.news-tags {
list-style: none;
}
.news-tags li {
display: inline-block;
padding: 5px 10px;
}
.news-tags li a {
font-size: 14px;
}
</style>');
function render_news_u($subject, $news, $info) {
global $locale, $aidlink;
echo "<h1 class='ncapmain'>".$subject."</h1>\n";
echo $news."\n";
if (!isset($_GET['readmore']) && $info['news_ext'] == "y") { echo " <a href='".makeurl_news($info['news_url'],$info['news_id'],$info['news_cat'])."'><img src='".THEME."images/readmore.png' alt='' style='vertical-align:middle;border:0px;' /><strong>".$locale['global_072']."...</strong></a><br />";}
echo "<p class='nfoot'>";
echo "<img src='".THEME."images/author.gif' alt='' style='vertical-align:middle;border:0px;' /> <a href='profile.php?lookup=".$info['user_id']."'>".$info['user_name']."</a> ".$locale['global_071'].showdate("longdate", $info['news_date']);
if ($info['news_allow_comments']) { echo " | <img src='".THEME."images/comments.gif' alt='' style='vertical-align:middle;border:0px;' /> <a href='".makeurl_news($info['news_url'],$info['news_id'],$info['news_cat'])."'>".$info['news_comments'].($info['news_comments'] == 1 ? $locale['global_073b'] : $locale['global_073'])."</a> |";}
// echo " <a href='print.php?type=N&item_id=".$info['news_id']."'><img src='".THEME."images/printer.gif' alt='".$locale['global_075']."' title='".$locale['global_075']."' style='vertical-align:middle;border:0px;' /></a>";
if (iADMIN && checkrights("N")) { echo " <a href='".ADMIN."news.php".$aidlink."&action=edit&news_id=".$info['news_id']."'><img src='".IMAGES."edit.gif' alt='".$locale['global_076']."' title='".$locale['global_076']."' style='vertical-align:middle;border:0px;' /></a>\n"; }
echo "</p>";
}
// Predefined variables, do not edit these values
if ($settings['news_style'] == "1") { $i = 0; $rc = 0; $ncount = 1; $ncolumn = 1; $news_[0] = ""; $news_[1] = ""; $news_[2] = ""; } else { $i = 1; }
// Number of news displayed
$items_per_page = $settings['newsperpage'];
if (!isset($_GET['readmore']) || !isnum($_GET['readmore'])) {
$rows = dbcount("(news_id)", DB_NEWS, groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_draft='0' AND ".$__city."='1'");
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
if ($rows) {
$result = dbquery(
"SELECT tn.*, tc.*, user_id, user_name FROM ".DB_NEWS." tn
LEFT JOIN ".DB_USERS." tu ON tn.news_name=tu.user_id
LEFT JOIN ".DB_NEWS_CATS." tc ON tn.news_cat=tc.news_cat_id
WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_draft='0' AND tn.".$__city."='1' AND news_entity<>'0'
ORDER BY news_sticky DESC, news_datestamp DESC LIMIT ".$_GET['rowstart'].",$items_per_page"
);
$numrows = dbrows($result);
if ($settings['news_style'] == "1") { $nrows = round((dbrows($result) - 1) / 2); }
while ($data = dbarray($result)) {
$news_cat_image = "";
$news_subject = "<a name='news_".$data['news_id']."' id='news_".$data['news_id']."'></a>".stripslashes($data['news_subject']);
if ($data['news_cat_image']) {
$news_cat_image = "<a href='news_cats.php?cat_id=".$data['news_cat_id']."'><img src='".get_image("nc_".$data['news_cat_name'])."' alt='".$data['news_cat_name']."' class='news-category' /></a>";
} else {
$news_cat_image = "";
}
$news_news = $data['news_breaks'] == "y" ? nl2br(stripslashes($data['news_news'])) : stripslashes($data['news_news']);
if ($news_cat_image != "") $news_news = $news_cat_image.$news_news;
$news_info = array(
"news_id" => $data['news_id'],
"news_cat" => $data['news_cat'],
"news_url" => $data['news_url'] ? $data['news_url'] : translit($data['news_subject']),
"user_id" => $data['user_id'],
"user_name" => $data['user_name'],
"news_date" => $data['news_datestamp'],
"news_ext" => $data['news_extended'] ? "y" : "n",
"news_reads" => $data['news_reads'],
"news_comments" => dbcount("(comment_id)", DB_COMMENTS, "comment_type='N' AND comment_item_id='".$data['news_id']."'"),
"news_allow_comments" => $data['news_allow_comments']
);
if ($settings['news_style'] == "1") {
if ($rows <= 2 || $ncount == 1) {
$news_[0] .= "<table width='100%' cellpadding='0' cellspacing='0'>\n";
$news_[0] .= "<tr>\n<td class='tbl2'><strong>".$news_subject."</strong></td>\n</tr>\n";
$news_[0] .= "<tr>\n<td class='tbl1' style='text-align:justify'>".$news_news."</td>\n</tr>\n";
$news_[0] .= "<tr>\n<td align='center' class='tbl2'>\n";
$news_[0] .= "<span class='small2'>".THEME_BULLET." <a href='profile.php?lookup=".$news_info['user_id']."'>".$news_info['user_name']."</a> ".$locale['global_071'].showdate("longdate", $news_info['news_date'])." ·\n";
if ($news_info['news_ext'] == "y" || $news_info['news_allow_comments']) {
$news_[0] .= $news_info['news_ext'] == "y" ? "<a href='".makeurl_news($data['news_url'],$data['news_id'],$data['news_cat'])."'>".$locale['global_072']."</a> ·\n" : "";
$news_[0] .= $news_info['news_allow_comments'] ? "<a href='".makeurl_news($data['news_url'],$data['news_id'],$data['news_cat'])."'>".$news_info['news_comments'].($news_info['news_comments'] == 1 ? $locale['global_073b'] : $locale['global_073'])."</a> ·\n" : "";
$news_[0] .= $news_info['news_reads'].$locale['global_074']." ·\n";
}
// $news_[0] .= "<a href='print.php?type=N&item_id=".$news_info['news_id']."'><img src='".get_image("printer")."' alt='".$locale['global_075']."' style='vertical-align:middle;border:0;' /></a>";
if (checkrights("N")) { $news_[0] .= " · <a href='".ADMIN."news.php".$aidlink."&action=edit&news_id=".$news_info['news_id']."'><img src='".get_image("edit")."' alt='".$locale['global_076']."' title='".$locale['global_076']."' style='vertical-align:middle;border:0;' /></a></span>\n"; } else { $news_[0] .= "</span>\n"; }
$news_[0] .= "</td>\n</tr>\n</table>\n";
if ($ncount != $rows) { $news_[0] .= "<div><img src='".get_image("blank")."' alt='' width='1' height='8' /></div>\n"; }
} else {
if ($i == $nrows && $ncolumn != 2) { $ncolumn = 2; $i = 0; }
$row_color = ($rc % 2 == 0 ? "tbl2" : "tbl1");
$news_[$ncolumn] .= "<table width='100%' cellpadding='0' cellspacing='0'>\n";
$news_[$ncolumn] .= "<tr>\n<td class='tbl2'><strong>".$news_subject."</strong></td>\n</tr>\n";
$news_[$ncolumn] .= "<tr>\n<td class='tbl1' style='text-align:justify'>".$news_news."</td>\n</tr>\n";
$news_[$ncolumn] .= "<tr>\n<td align='center' class='tbl2'>\n";
$news_[$ncolumn] .= "<span class='small2'>".THEME_BULLET." <a href='profile.php?lookup=".$news_info['user_id']."'>".$news_info['user_name']."</a> ".$locale['global_071'].showdate("longdate", $news_info['news_date']);
if ($news_info['news_ext'] == "y" || $news_info['news_allow_comments']) {
$news_[$ncolumn] .= "<br />\n";
$news_[$ncolumn] .= $news_info['news_ext'] == "y" ? "<a href='".makeurl_news($data['news_url'],$data['news_id'],$data['news_cat'])."'>".$locale['global_072']."</a> ·\n" : "";
$news_[$ncolumn] .= $news_info['news_allow_comments'] ? "<a href='".makeurl_news($data['news_url'],$data['news_id'],$data['news_cat'])."#comments'>".$news_info['news_comments'].($news_info['news_comments'] == 1 ? $locale['global_073b'] : $locale['global_073'])."</a> ·\n" : "";
$news_[$ncolumn] .= $news_info['news_reads'].$locale['global_074']." ·\n";
} else {
$news_[$ncolumn] .= " ·\n";
}
$news_[$ncolumn] .= "<a href='print.php?type=N&item_id=".$news_info['news_id']."'><img src='".get_image("printer")."' alt='".$locale['global_075']."' style='vertical-align:middle;border:0;' /></a>\n";
if (checkrights("N")) { $news_[$ncolumn] .= " · <a href='".ADMIN."news.php".$aidlink."&action=edit&news_id=".$news_info['news_id']."'><img src='".get_image("edit")."' alt='".$locale['global_076']."' title='".$locale['global_076']."' style='vertical-align:middle;border:0;' /></a></span>\n"; } else { $news_[$ncolumn] .= "</span>\n"; }
$news_[$ncolumn] .= "</td>\n</tr>\n</table>\n";
if ($ncolumn == 1 && $i < ($nrows - 1)) { $news_[$ncolumn] .= "<div><img src='".get_image("blank")."' alt='' width='1' height='8' /></div>\n"; }
if ($ncolumn == 2 && $i < (dbrows($result) - $nrows - 2)) { $news_[$ncolumn] .= "<div><img src='".get_image("blank")."' alt='' width='1' height='8' /></div>\n"; }
$i++; $rc++;
}
$ncount++;
} else {
echo "<!--news_prepost_".$i."-->\n";
$i++;
//render_news_u($news_subject, $news_news, $news_info);
render_news($news_subject, $news_news, $news_info);
}
}
if ($settings['news_style'] == "1") {
opentable($locale['global_077']);
echo "<table cellpadding='0' cellspacing='0' style='width:100%'>\n<tr>\n<td colspan='3' style='width:100%'>\n";
echo $news_[0];
echo "</td>\n</tr>\n<tr>\n<td style='width:50%;vertical-align:top;'>\n";
echo $news_[1];
echo "</td>\n<td style='width:10px'><img src='".get_image("blank")."' alt='' width='10' height='1' /></td>\n<td style='width:50%;vertical-align:top;'>\n";
echo $news_[2];
echo "</td>\n</tr>\n</table>\n";
closetable();
}
if ($rows > $items_per_page) echo "<div align='center' style=';margin-top:5px;'>\n".makepagenav($_GET['rowstart'],$items_per_page,$rows,3,'?')."\n</div>\n";
} else {
opentable($locale['global_077']);
echo "<div style='text-align:center'><br />\n".$locale['global_078']."<br /><br />\n</div>\n";
closetable();
}
} else {
$page_url = '';
$page_suffix = '.html';
if (isset($_GET['news_url'])) {
$page_url = stripinput($_GET['news_url']);
$page_url = trim($page_url,'/');
$page_suffix = '.html';
}
include INCLUDES."comments_include.php";
include INCLUDES."ratings_include.php";
$result = dbquery(
"SELECT tn.*, user_id, user_name FROM ".DB_NEWS." tn
LEFT JOIN ".DB_USERS." tu ON tn.news_name=tu.user_id
WHERE news_id='".$_GET['readmore']."' AND news_draft='0' AND ".$__city."='1' AND news_entity<>'0'"
);
if (dbrows($result)!=0) {
$data = dbarray($result);
if (checkgroup($data['news_visibility'])) {
if ($data['news_url'] == '') $data['news_url'] = translit($data['news_subject']);
if ($data['news_url'] != $page_url || $data['news_cat'] != $_GET['news_cat']) { redirect(makeurl_news($data['news_url'],$data['news_id'],$data['news_cat'])); }
$news_cat_image = "";
if (!isset($_POST['post_comment']) && !isset($_POST['post_rating'])) {
$result2 = dbquery("UPDATE ".DB_NEWS." SET news_reads=news_reads+1 WHERE news_id='".$_GET['readmore']."'");
$data['news_reads']++;
}
$news_subject = $data['news_subject'];
if ($data['news_cat']) {
$result2 = dbquery("SELECT * FROM ".DB_NEWS_CATS." WHERE news_cat_id='".$data['news_cat']."'");
if (dbrows($result2)) {
$data2 = dbarray($result2);
$news_cat_image = "<a href='news_cats.php?cat_id=".$data2['news_cat_id']."'><img src='".get_image("nc_".$data2['news_cat_name'])."' alt='".$data2['news_cat_name']."' class='news-category' /></a>";
}
}
$news_news = stripslashes($data['news_extended'] ? $data['news_extended'] : $data['news_news']);
if ($data['news_breaks'] == "y") { $news_news = nl2br($news_news); }
if ($news_cat_image != "") $news_news = $news_cat_image.$news_news;
$news_info = array(
"news_id" => $data['news_id'],
"news_cat" => $data['news_cat'],
"news_url" => $data['news_url'] ? $data['news_url'] : translit($data['news_subject']),
"user_id" => $data['user_id'],
"user_name" => $data['user_name'],
"news_date" => $data['news_datestamp'],
"news_ext" => "n",
"news_reads" => $data['news_reads'],
"news_comments" => dbcount("(comment_id)", DB_COMMENTS, "comment_type='N' AND comment_item_id='".$data['news_id']."'"),
"news_allow_comments" => $data['news_allow_comments']
);
add_to_title($news_subject);
echo "<!--news_pre_readmore-->";
render_news($news_subject, $news_news, $news_info);
echo "<!--news_sub_readmore-->";
$result = dbquery("SELECT nt.* FROM ".DB_NEWS_TAGS_PIVOT." ntp LEFT JOIN ".DB_NEWS_TAGS." nt ON nt.news_tag_id=ntp.tag_id WHERE ntp.news_id='".$data['news_id']."'");
if (dbrows($result)) {
echo "<ul class='news-tags'>";
while($tag = dbarray($result)) {
echo "<li><a href='".BASEDIR."news_tags.php?tag_id=".$tag['news_tag_id']."'>".$tag['news_tag_name']."</a></li>";
}
echo "</ul>";
}
if ($data['news_allow_comments']) { showcomments("N", DB_NEWS, "news_id", $_GET['readmore'], makeurl_news($data['news_url'],$data['news_id'],$data['news_cat'])); }
if ($data['news_allow_ratings']) { showratings("N", $_GET['readmore'], makeurl_news($data['news_url'],$data['news_id'],$data['news_cat'])); }
} else {
redirect(FUSION_SELF);
}
} else {
redirect(FUSION_SELF);
}
}
require_once THEMES."templates/footer.php";
?>
back1919 присоединено следующее:изображение:
Изменил(а) back1919, 23.05.2016 09:48
|