0) {
while($nu = mysql_fetch_object($rezas)) {
echo "$nu->news_cat_name
";
$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 "".showdate("shortdate", $nu2->news_datestamp); echo " news_id'
title=\"header=[ ".
str_replace("]", "]]", str_replace("[", "[[", $nu2->news_subject))."] body=[".
str_replace("]", "]]", str_replace("[", "[[", $nu2->news_news))."] delay=[0] fade=[on]\">$nu2->news_subject
";
echo "komentarų [$komentarai] Skaityta [$nu2->news_reads]
Skaityti visą
";
if ($nu2->news_breaks == "y") { $news_news = nl2br($nu2->news_news); }
echo stripslashes($news_news);
echo "
Kitos naujienos:
";
}
}
$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 "".showdate("shortdate", $nu3->news_datestamp); echo " news_id'
title=\"header=[ ".
str_replace("]", "]]", str_replace("[", "[[", $nu3->news_subject))."] body=[".
str_replace("]", "]]", str_replace("[", "[[", $nu3->news_news))."] delay=[1] fade=[on]\">$nu3->news_subject
Skaityta
[$nu3->news_reads] Komentarų [$komentarai2] Skaityti visą
";
}
echo "Visos naujienos
";
}
}
}
}
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 = "![".$data2[](".IMAGES_NC.$data2[)
";
}
}
$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);
}
}
closeside();
require_once "side_right.php";
require_once "footer.php";
?>