Pradinukas
Reputacija:
0
Pranešimai: 45
Įstojo: 2009-08-02
|
Sveiki.
Turiu toki rimt problem.[/b]
Kai paspaud?iu ant savo naujienos kategorijos pavyzd?iui albumai(?tai pavizds http://one.our.lt...?cat_id=18) man i?meta kok 50 naujien i? karto.Tai yra labai blogai.
Ir noriau paklausti kaip padaryti kad rodyt naujienas kaip news.php po kokias 5.
[b]$items_per_page = 10; pakeiiau $items_per_page = 5; bet vistiek neveikia
(Jei ka tai serch'inau visur ir pas jus forumose,ir googlei bet niekur neradau.)
news_cats.php failas stai
 Code
/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright 2002 - 2005 Nick Jones
| http://www.php-fusion.co.uk/
+----------------------------------------------------+
| Released under the terms & conditions of v2 of the
| GNU General Public License. For details refer to
| the included gpl.txt file or visit http://gnu.org
+----------------------------------------------------*/
require_once \"maincore.php\";
require_once \"subheader.php\";
require_once \"side_left.php\";
if (!isset($readmore)) {
$items_per_page = 10;
if (isset($cat_id)) {
$result = dbquery(\"SELECT * FROM \".$db_prefix.\"news_cats WHERE news_cat_id='$cat_id'\");
if (dbrows($result) || $cat_id == 0) {
$data = dbarray($result);
$rows = dbcount(\"(news_id)\", \"news\", \"news_cat='$cat_id' AND \".groupaccess('news_visibility').\" AND (news_start='0'||news_start<=\".time().\") AND (news_end='0'||news_end>=\".time().\")\");
$result = dbquery(\"SELECT * FROM \".$db_prefix.\"news WHERE news_cat='$cat_id' AND \".groupaccess('news_visibility').\" AND (news_start='0'||news_start<=\".time().\") AND (news_end='0'||news_end>=\".time().\") ORDER BY news_datestamp DESC\");
//opentable(\"News Items in \" .$data['news_cat_name']. \" Category\");
//closetable();
}
} else {
$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 \".groupaccess('news_visibility').\" AND (news_start='0'||news_start<=\".time().\") AND (news_end='0'||news_end>=\".time().\")
ORDER BY news_datestamp DESC LIMIT $rowstart,$items_per_page\"
);
$rows = dbcount(\"(news_id)\", \"news\", groupaccess('news_visibility').\" AND (news_start='0'||news_start<=\".time().\") AND (news_end='0'||news_end>=\".time().\")\");
}
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if ($rows != 0) {
$i = 1;
$numrows = dbrows($result);
while ($data = dbarray($result)) {
$news_cat_image = \"\";
$news_subject = \"\".stripslashes($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['news_cat_name'].\"']('\".IMAGES_NC.$data2['news_cat_image'].\"') \";
}
}
$news_news = stripslashes($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\" => $data['news_extended'] ? \"y\" : \"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 ($i != $numrows) { tablebreak(); } $i++;
}
if ($rows > $items_per_page) echo \"\n\".makePageNav($rowstart,$items_per_page,$rows,3).\"\n \n\";
} else {
opentable($locale['046']);
echo \"
\n\".$locale['047'].\"
\n\n\";
closetable();
}
} else {
if (!isNum($readmore)) fallback(FUSION_SELF);
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 = \"\";
}
}
$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\";
?>
|
