Parašė zDon· 2009 Bir. 26 18:06:53
#2
Bandyk...
<?php
require_once "maincore.php";
require_once "subheader.php";
require_once "side_left.php";
if (isset($readmore) && !isNum($readmore)) fallback(FUSION_SELF);
if (!isset($readmore)) {
echo "<script type='text/javascript' language='JavaScript' src='ft_boxover.js'></script>";
$uzklausa = "SELECT news_cat_id, news_cat_name FROM ".$db_prefix."news_cats ";
$rezas = mysql_query($uzklausa)
or die ("Klaidos");
if (mysql_num_rows($rezas) > 0) {
while($nu = mysql_fetch_object($rezas)) {
$uzklausa = "SELECT news_id, news_cat, news_breaks, news_extended, news_subject, news_cat, news_news, news_datestamp,
news_reads FROM ".$db_prefix."news
WHERE news_cat = '$nu->news_cat_id' ORDER BY news_datestamp DESC LIMIT 0,1";
$rezas2 = mysql_query($uzklausa) or die ("Klaida");
if (mysql_num_rows($rezas2) > 0) {
while($nu2 = mysql_fetch_object($rezas2)) {
$komentarai = dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id='$nu2->news_id' ");
echo " <a href='".BASEDIR."news.php?readmore=$nu2->news_id'><font size='2'><b> $nu2->news_subject</b></font></a> <br>";
if ($nu2->news_breaks == "y") { $news_news = nl2br($nu2->news_news); }
echo stripslashes($news_news);
echo "<br><br>".showdate("shortdate", $nu2->news_datestamp); echo " - [Skaityta $nu2->news_reads] - <a href='".BASEDIR."news.php?readmore=$nu2->news_id'>[Komentarų $komentarai]</a>";
echo "<hr width='100%' size='1'>";
}
}
$uzklausa3 = "SELECT news_id, news_cat, news_subject, news_cat, news_news, news_datestamp, news_reads FROM ".$db_prefix."news
WHERE news_cat = '$nu->news_cat_id' ORDER BY news_datestamp DESC LIMIT 1,6";
$rezas3 = mysql_query($uzklausa3) or die ("Klaida");
if (mysql_num_rows($rezas3) > 0) {
while($nu3 = mysql_fetch_object($rezas3)) {
$komentarai2 = dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id='$nu3->news_id' ");
echo " <a href='".BASEDIR."news.php?readmore=$nu3->news_id'
title=\"header=[ ".
str_replace("]", "]]", str_replace("[", "[[", $nu3->news_subject))."] body=[".
str_replace("]", "]]", str_replace("[", "[[", stripslashes($nu3->news_news)))."] delay=[1] fade=[on]\"> <font size='1'><b>$nu3->news_subject</b></font></a><br>";
echo "".showdate("shortdate", $nu3->news_datestamp);
echo " - [Skaityta $nu3->news_reads] <a href='".BASEDIR."news.php?readmore=$nu3->news_id'> - [Komentarų $komentarai2]</a><br>";
echo "<hr width='100%' size='1'>";
}
}
}
}
}
else
{
include INCLUDES."comments_include.php";
include INCLUDES."ratings_include.php";
$result = dbquery(
"SELECT tn.*, user_id, user_name FROM ".$db_prefix."news tn
LEFT JOIN ".$db_prefix."users tu ON tn.news_name=tu.user_id
WHERE news_id='$readmore'"
);
if (dbrows($result)!=0) {
$data = dbarray($result);
if (checkgroup($data['news_visibility'])) {
$news_cat_image = "";
if (!isset($_POST['post_comment']) && !isset($_POST['post_rating'])) {
$result2 = dbquery("UPDATE ".$db_prefix."news SET news_reads=news_reads+1 WHERE news_id='$readmore'");
$data['news_reads']++;
}
$news_subject = $data['news_subject'];
if ($data['news_cat'] != 0) {
$result2 = dbquery("SELECT * FROM ".$db_prefix."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='".IMAGES_N.$data2['news_cat_image']."'
alt='".$data2['news_cat_name']."' align='right' style='border:0px;margin-top:3px;margin-right:5px'></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'],
"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)", "comments", "comment_type='N' AND comment_item_id='".$data['news_id']."'"),
"news_allow_comments" => $data['news_allow_comments']
);
render_news($news_subject, $news_news, $news_info);
if ($data['news_allow_comments']) showcomments("N","news","news_id",$readmore,FUSION_SELF."?readmore=$readmore");
if ($data['news_allow_ratings']) showratings("N",$readmore,FUSION_SELF."?readmore=$readmore");
} else {
redirect(FUSION_SELF);
}
} else {
redirect(FUSION_SELF);
}
}
require_once "side_right.php";
require_once "footer.php";
?>