Naujokas
Reputacija:
0
Pranešimai: 5
Įstojo: 2007-04-04
|
Beda tame, kaip padaryti jog sis modas rodytu mano pacio pasirinkta naujienu kategorija... Bandziau kazka kaitalioti su news_cast_id skaiciais bet nepasiduoda brudas :)
 Code
require_once \"maincore.php\";
require_once \"subheader.php\";
require_once \"side_left.php\";
openre (\"\");
if (isset($readmore) && !isNum($readmore)) fallback(FUSION_SELF);
// (\" \");
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 \"
\";
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 \" news_id'> $nu2->news_subject
\";
if ($nu2->news_breaks == \"y\") { $news_news = nl2br($nu2->news_news); }
echo stripslashes($news_news);
echo \"
Paskelbta: \".showdate(\"shortdate\", $nu2->news_datestamp); echo \"\";
echo \"
\";
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,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 \" news_id'
title= \".
//str_replace(\"]\", \"]]\", str_replace(\"[\", \"[[\", $nu3->news_subject)).\"] body=[\".
str_replace(\"\", \\\"]]\", str_replace(\"\", \"[[\", stripslashes($nu3->news_news))).\"> $nu3->news_subject
\";
echo \"Paskelbta: \".showdate(\"shortdate\", $nu3->news_datestamp);
echo \"
\";
}
echo \"news_cat_id'> Daugiau naujien
\";
}
}
}
}
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 = \"![]('\".IMAGES_N.$data2['news_cat_image'].\"'<br)
alt='\".$data2['news_cat_name'].\"' align='right' style='border:0px;margin-top:3px;margin-right:5px'>\";
}
}
$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\";
?>
Redagavo Inteligent 2007-10-04 13:15 |
