<?php
require_once "maincore.php";
require_once "subheader.php";
require_once "side_left.php";
openre ("");
if (isset($readmore) && !isNum($readmore)) fallback(FUSION_SELF);
 // ("<marquee behavior='alternate' scrollamount='3' scrolldelay='10' style='font-family: Tahoma; font-size: 10pt'>Profs&#224;junga - tavo organizacija, o ne organizacija tau !!!</marquee> ");
if (!isset($readmore)) {



$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)) {
echo "<br><img src='images/juosta.JPG' width='100%' height='5'><br><br>";
echo "<img border='0' src='images/tema1.png'> <b><font size='3' color='#FF3E0D' >$nu->news_cat_name</font></b><br><br>";
$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'><img border='0' src='images/straipsnis.JPG'> <font size='-1'><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>Paskelbta: <b>".showdate("shortdate", $nu2->news_datestamp); echo "</b>";
echo "<hr width='100%' size='1'>";
echo "Kitos naujienos:<br><br>";
}
}
$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,3";
$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= ".
//str_replace("]", "]]", str_replace("[", "[[", $nu3->news_subject))."] body=[".
str_replace("", \\"]]", str_replace("", "[[", stripslashes($nu3->news_news)))."><img border='0' src='images/straipsnis.JPG'> <font size='-1'><b>$nu3->news_subject</b></font><br>";

echo "Paskelbta: ".showdate("shortdate", $nu3->news_datestamp);
echo "<hr width='100%' size='1'>";
}





echo "<a href='".BASEDIR."news_cats.php?cat_id=$nu->news_cat_id'><b><img border='0' src='images/tema.JPG'> <font color=red>Daugiau naujien¸</font></b></a><br><hr>";
}

}
}

}
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);
}
}
closere("");
require_once "side_right.php";
require_once "footer.php";
?>