@Tez
To get all newsitems from the website you need to change some code
first no need to redirect if no page is given, it could be what we want
change:
// Check that GET values have been supplied
if(isset($_GET['page_id']) AND is_numeric($_GET['page_id'])) {
$page_id = $_GET['page_id'];
} else {
header('Location: /');
exit(0);
}
to:
// Check that GET values have been supplied, no need to redirect anymore if there is no page given, it could be what we want ;)
if(isset($_GET['page_id']) AND is_numeric($_GET['page_id'])) {
$page_id = $_GET['page_id'];
}
next give more options to db query, allow all pages, a page all groups, a group
change:
//Query
if(isset($group_id)) {
$query = "SELECT * FROM ".TABLE_PREFIX."mod_news_posts WHERE group_id=".$group_id." AND page_id = ".$page_id." AND active=1 AND ".$time_check_str." ORDER BY posted_when DESC";
} else {
$query = "SELECT * FROM ".TABLE_PREFIX."mod_news_posts WHERE page_id=".$page_id." AND active=1 AND ".$time_check_str." ORDER BY posted_when DESC";
}
to:
//Query Build extra 'where' clause when a page or group is given
$page_group_check = '';
if(isset($page_id)) {
$page_group_check .= ' AND page_id='.$page_id;
}
if(isset($group_id)) {
$page_group_check .= ' AND group_id='.$group_id;
}
$query = "SELECT * FROM ".TABLE_PREFIX."mod_news_posts WHERE active=1 AND ".$time_check_str." ".$page_group_check." ORDER BY posted_when DESC";
Didn't test this but it should work and it give you new pointers to achieve what you are after.
If you need RSS all pages per language you need to query the table pages and query each news item for that page with given language. Could be done. Could help if needed.
Would be something like:
make variable for language like rss.php?language=EN
test if language is given, if language is given query table pages for all pages with that language
per page query newsitems and show items
Wouldn't be hard, but I don't have multilanguage websites
Have fun,
John.
WebsiteBaker Community Forum
