Pradinukas
Reputacija:
0
Pranešimai: 26
Įstojo: 2011-01-22
|
Sveiki, reikia man Paneles, panasios i filmu isidestima, kad isidestitu grazei bet kad prasidetu popiuleriausios Ir, Kitokio Reiketu Kur prasideda Naujienos Pagal Naujausias.
as Turiu kazka panasaus tik nemoku sureguliuoti
 Code
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2011 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: news.php
| Author: Nick Jones (Digitanium)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once \"maincore.php\";
require_once THEMES.\"templates/header.php\";
// Predefined variables, do not edit these values
$i = 0;
// Number of news displayed
$items_per_page = $settings['newsperpage'];
add_to_title($locale['global_200'].$locale['global_077']);
if (!isset($_GET['readmore']) || !isnum($_GET['readmore'])) {
$rows = dbcount(
\"(news_id)\",
DB_NEWS,
groupaccess('news_visibility').\" AND (news_start='0'||news_start<=\".time().\")
AND (news_end='0'||news_end>=\".time().\")
AND news_draft='0'\"
);
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
if ($rows) {
$result = dbquery(
\"SELECT tn.*, tc.*, tu.user_id, tu.user_name, tu.user_status
FROM \".DB_NEWS.\" tn
LEFT JOIN \".DB_USERS.\" tu ON tn.news_name=tu.user_id
LEFT JOIN \".DB_NEWS_CATS.\" tc ON tn.news_cat=tc.news_cat_id
WHERE \".groupaccess('news_visibility').\" AND (news_start='0'||news_start<=\".time().\")
AND (news_end='0'||news_end>=\".time().\") AND news_draft='0'
GROUP BY news_id
ORDER BY news_sticky DESC, news_datestamp DESC LIMIT \".$_GET['rowstart'].\",\".$items_per_page
);
$numrows = dbrows($result);
while ($data = dbarray($result)) {
$wynik = dbquery(\"SELECT SUM(rating_vote) FROM \".DB_RATINGS.\" WHERE rating_type='N' AND rating_item_id='\".$data['news_id'].\"'\");
$info2 = dbresult($wynik,0);
$num_rating = dbcount(\"(rating_vote)\", DB_RATINGS, \"rating_type='N' AND rating_item_id='\".$data['news_id'].\"'\");
$wyn_rating = ($num_rating ? $info2 / $num_rating : 0);
$i++;
$comments = dbcount(\"(comment_id)\", DB_COMMENTS.\" WHERE comment_type='N' AND comment_hidden='0' AND comment_item_id='\".$data['news_id'].\"'\");
$news_cat_image = \"\";
$news_subject = \"\".stripslashes($data['news_subject']);
$news_cat_image = \"
: FUSION_SELF.\"?readmore=\".$data['news_id'] ).\"'>\";
if ($data['news_image_t2'] && $settings['news_image_frontpage'] == 0) {
$news_cat_image .= \"!['\".$data['news_subject'].\"']('\".IMAGES_N_T.$data['news_image_t2'].\"') \";
} elseif ($data['news_cat_image']) {
$news_cat_image .= \"!['\".$data['news_cat_name'].\"']('\".get_image(\"nc_\".$data['news_cat_name']).\"') \";
} else {
$news_cat_image = \"\";
}
$news_news = preg_replace(\"//i\", \"\", ($data['news_breaks'] == \"y\" ? nl2br(stripslashes($data['news_news'])) : stripslashes($data['news_news'])));
$news_info = array(
\"news_id\" => $data['news_id'],
\"user_id\" => $data['user_id'],
\"user_name\" => $data['user_name'],
\"user_status\" => $data['user_status'],
\"news_date\" => $data['news_datestamp'],
\"cat_id\" => $data['news_cat'],
\"cat_name\" => $data['news_cat_name'],
\"cat_image\" => $news_cat_image,
\"rating\" => $wyn_rating,
\"news_subject\" => $data['news_subject'],
\"news_ext\" => $data['news_extended'] ? \"y\" : \"n\",
\"news_reads\" => $data['news_reads'],
\"news_comments\" => $comments,
\"news_allow_comments\" => $data['news_allow_comments'],
\"news_sticky\" => $data['news_sticky']
);
echo \"\n\";
render_news($news_subject, $news_news, $news_info);
}
echo \"\n\";
if ($rows > $items_per_page) echo \"\n\".makepagenav($_GET['rowstart'],$items_per_page,$rows,3).\"\n \n\";
} else {
opentable($locale['global_077']);
echo \"
\n\".$locale['global_078'].\"
\n
\n\";
closetable();
}
} else {
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
$result = dbquery(
\"SELECT tn.*, tc.*, tu.user_id, tu.user_name, tu.user_status FROM \".DB_NEWS.\" tn
LEFT JOIN \".DB_USERS.\" tu ON tn.news_name=tu.user_id
LEFT JOIN \".DB_NEWS_CATS.\" tc ON tn.news_cat=tc.news_cat_id
WHERE \".groupaccess('news_visibility').\" AND news_id='\".$_GET['readmore'].\"' AND news_draft='0'
LIMIT 1\"
);
if (dbrows($result)) {
include INCLUDES.\"comments_include.php\";
include INCLUDES.\"ratings_include.php\";
$data = dbarray($result);
$wynik = dbquery(\"SELECT SUM(rating_vote) FROM \".DB_RATINGS.\" WHERE rating_type='N' AND rating_item_id='\".$data['news_id'].\"'\");
$info2 = dbresult($wynik,0);
$num_rating = dbcount(\"(rating_vote)\", DB_RATINGS, \"rating_type='N' AND rating_item_id='\".$data['news_id'].\"'\");
$wyn_rating = ($num_rating ? $info2 / $num_rating : 0);
if (!isset($_POST['post_comment']) && !isset($_POST['post_rating'])) {
$result2 = dbquery(\"UPDATE \".DB_NEWS.\" SET news_reads=news_reads+1 WHERE news_id='\".$_GET['readmore'].\"'\");
$data['news_reads']++;
}
$news_cat_image = \"\";
$news_subject = $data['news_subject'];
if ($data['news_image_t1'] && $settings['news_image_readmore'] == \"0\") {
$img_size = @getimagesize(IMAGES_N.$data['news_image']);
$news_cat_image = \">!['\".$data['news_subject'].\"']('\".IMAGES_N_T.$data['news_image_t1'].\"') \";
} elseif ($data['news_cat_image']) {
$news_cat_image = \"\";
}
$news_news = preg_split(\"//i\", $data['news_breaks'] == \"y\" ? nl2br(stripslashes($data['news_extended'] ? $data['news_extended'] : $data['news_news'])) : stripslashes($data['news_extended'] ? $data['news_extended'] : $data['news_news']));
$pagecount = count($news_news);
$news_info = array(
\"news_id\" => $data['news_id'],
\"user_id\" => $data['user_id'],
\"user_name\" => $data['user_name'],
\"user_status\" => $data['user_status'],
\"news_date\" => $data['news_datestamp'],
\"cat_id\" => $data['news_cat'],
\"cat_name\" => $data['news_cat_name'],
\"cat_image\" => $news_cat_image,
\"rating\" => $wyn_rating,
\"news_subject\" => $data['news_subject'],
\"news_ext\" => \"n\",
\"news_reads\" => $data['news_reads'],
\"news_comments\" => dbcount(\"(comment_id)\", DB_COMMENTS, \"comment_type='N' AND comment_item_id='\".$data['news_id'].\"' AND comment_hidden='0'\"),
\"news_allow_comments\" => $data['news_allow_comments'],
\"news_sticky\" => $data['news_sticky']
);
add_to_title($locale['global_201'].$news_subject);
echo \"\";
render_news($news_subject, $news_news[$_GET['rowstart']], $news_info);
echo \"\";
if ($pagecount > 1) {
echo \"\n\".makepagenav($_GET['rowstart'], 1, $pagecount, 3, FUSION_SELF.\"?readmore=\".$_GET['readmore'].\"&\").\"\n \n\";
}
if ($data['news_allow_comments']) { showcomments(\"N\", DB_NEWS, \"news_id\", $_GET['readmore'], FUSION_SELF.\"?readmore=\".$_GET['readmore']); }
if ($data['news_allow_ratings']) { showratings(\"N\", $_GET['readmore'], FUSION_SELF.\"?readmore=\".$_GET['readmore']); }
} else {
redirect(FUSION_SELF);
}
}
require_once THEMES.\"templates/footer.php\";
?>
Jeigu galit, padekit nes reiketu kad rodytu Naujausias Naujienas ir Populeriausas |
