Revision 1157
Added by Luisehahne about 16 years ago
| rss.php | ||
|---|---|---|
| 1 |
<?php |
|
| 2 |
|
|
| 3 |
// $Id$ |
|
| 4 |
|
|
| 5 |
/* |
|
| 6 |
|
|
| 7 |
Website Baker Project <http://www.websitebaker.org/> |
|
| 8 |
Copyright (C) 2004-2009, Ryan Djurovich |
|
| 9 |
|
|
| 10 |
Website Baker is free software; you can redistribute it and/or modify |
|
| 11 |
it under the terms of the GNU General Public License as published by |
|
| 12 |
the Free Software Foundation; either version 2 of the License, or |
|
| 13 |
(at your option) any later version. |
|
| 14 |
|
|
| 15 |
Website Baker is distributed in the hope that it will be useful, |
|
| 16 |
but WITHOUT ANY WARRANTY; without even the implied warranty of |
|
| 17 |
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
|
| 18 |
GNU General Public License for more details. |
|
| 19 |
|
|
| 20 |
You should have received a copy of the GNU General Public License |
|
| 21 |
along with Website Baker; if not, write to the Free Software |
|
| 22 |
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA |
|
| 23 |
|
|
| 24 |
*/ |
|
| 25 |
|
|
| 26 |
// Check that GET values have been supplied |
|
| 27 |
if(isset($_GET['page_id']) AND is_numeric($_GET['page_id'])) {
|
|
| 28 |
$page_id = $_GET['page_id']; |
|
| 29 |
define('PAGE_ID', $page_id);
|
|
| 30 |
} else {
|
|
| 31 |
header('Location: '.WB_URL);
|
|
| 32 |
exit(0); |
|
| 33 |
} |
|
| 34 |
if(isset($_GET['group_id']) AND is_numeric($_GET['group_id'])) {
|
|
| 35 |
$group_id = $_GET['group_id']; |
|
| 36 |
define('GROUP_ID', $group_id);
|
|
| 37 |
} |
|
| 38 |
|
|
| 39 |
// Include WB files |
|
| 40 |
require_once('../../config.php');
|
|
| 41 |
require_once(WB_PATH.'/framework/class.frontend.php'); |
|
| 42 |
$database = new database(); |
|
| 43 |
$wb = new frontend(); |
|
| 44 |
$wb->page_id = $page_id; |
|
| 45 |
$wb->get_page_details(); |
|
| 46 |
$wb->get_website_settings(); |
|
| 47 |
|
|
| 48 |
//checkout if a charset is defined otherwise use UTF-8 |
|
| 49 |
if(defined('DEFAULT_CHARSET')) {
|
|
| 50 |
$charset=DEFAULT_CHARSET; |
|
| 51 |
} else {
|
|
| 52 |
$charset='utf-8'; |
|
| 53 |
} |
|
| 54 |
|
|
| 55 |
// Sending XML header |
|
| 56 |
header("Content-type: text/xml; charset=$charset" );
|
|
| 57 |
|
|
| 58 |
// Header info |
|
| 59 |
// Required by CSS 2.0 |
|
| 60 |
echo '<?xml version="1.0" encoding="'.$charset.'"?>'; |
|
| 61 |
?> |
|
| 62 |
<rss version="2.0"> |
|
| 63 |
<channel> |
|
| 64 |
<title><?php echo PAGE_TITLE; ?></title> |
|
| 65 |
<link>http://<?php echo $_SERVER['SERVER_NAME']; ?></link> |
|
| 66 |
<description> <?php echo PAGE_DESCRIPTION; ?></description> |
|
| 67 |
<?php |
|
| 68 |
// Optional header info |
|
| 69 |
?> |
|
| 70 |
<language><?php echo strtolower(DEFAULT_LANGUAGE); ?></language> |
|
| 71 |
<copyright><?php $thedate = date('Y'); $websitetitle = WEBSITE_TITLE; echo "Copyright {$thedate}, {$websitetitle}"; ?></copyright>
|
|
| 72 |
<managingEditor><?php echo SERVER_EMAIL; ?></managingEditor> |
|
| 73 |
<webMaster><?php echo SERVER_EMAIL; ?></webMaster> |
|
| 74 |
<category><?php echo WEBSITE_TITLE; ?></category> |
|
| 75 |
<generator>Website Baker Content Management System</generator> |
|
| 76 |
|
|
| 77 |
<?php |
|
| 78 |
// Get news items from database |
|
| 79 |
$t = TIME(); |
|
| 80 |
$time_check_str= "(published_when = '0' OR published_when <= ".$t.") AND (published_until = 0 OR published_until >= ".$t.")"; |
|
| 81 |
//Query |
|
| 82 |
if(isset($group_id)) {
|
|
| 83 |
$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"; |
|
| 84 |
} else {
|
|
| 85 |
$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"; |
|
| 86 |
} |
|
| 87 |
$result = $database->query($query); |
|
| 88 |
|
|
| 89 |
//Generating the news items |
|
| 90 |
while($item = $result->fetchRow($result)){ ?>
|
|
| 91 |
|
|
| 92 |
<item> |
|
| 93 |
<title><![CDATA[<?php echo stripslashes($item["title"]); ?>]]></title> |
|
| 94 |
<description><![CDATA[<?php echo stripslashes($item["content_short"]); ?>]]></description> |
|
| 95 |
<guid><?php echo WB_URL.PAGES_DIRECTORY.$item["link"].PAGE_EXTENSION; ?></guid> |
|
| 96 |
<link><?php echo WB_URL.PAGES_DIRECTORY.$item["link"].PAGE_EXTENSION; ?></link> |
|
| 97 |
</item> |
|
| 98 |
|
|
| 99 |
<?php } ?> |
|
| 100 |
|
|
| 101 |
</channel> |
|
| 1 |
<?php |
|
| 2 |
|
|
| 3 |
// $Id$ |
|
| 4 |
|
|
| 5 |
/* |
|
| 6 |
|
|
| 7 |
Website Baker Project <http://www.websitebaker.org/> |
|
| 8 |
Copyright (C) 2004-2009, Ryan Djurovich |
|
| 9 |
|
|
| 10 |
Website Baker is free software; you can redistribute it and/or modify |
|
| 11 |
it under the terms of the GNU General Public License as published by |
|
| 12 |
the Free Software Foundation; either version 2 of the License, or |
|
| 13 |
(at your option) any later version. |
|
| 14 |
|
|
| 15 |
Website Baker is distributed in the hope that it will be useful, |
|
| 16 |
but WITHOUT ANY WARRANTY; without even the implied warranty of |
|
| 17 |
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
|
| 18 |
GNU General Public License for more details. |
|
| 19 |
|
|
| 20 |
You should have received a copy of the GNU General Public License |
|
| 21 |
along with Website Baker; if not, write to the Free Software |
|
| 22 |
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA |
|
| 23 |
|
|
| 24 |
*/ |
|
| 25 |
|
|
| 26 |
// Check that GET values have been supplied |
|
| 27 |
if(isset($_GET['page_id']) AND is_numeric($_GET['page_id'])) |
|
| 28 |
{
|
|
| 29 |
$page_id = $_GET['page_id']; |
|
| 30 |
define('PAGE_ID', $page_id);
|
|
| 31 |
} |
|
| 32 |
else |
|
| 33 |
{
|
|
| 34 |
header('Location: '.WB_URL);
|
|
| 35 |
exit( 0 ); |
|
| 36 |
} |
|
| 37 |
if(isset($_GET['group_id']) AND is_numeric($_GET['group_id'])) {
|
|
| 38 |
$group_id = $_GET['group_id']; |
|
| 39 |
define('GROUP_ID', $group_id);
|
|
| 40 |
} |
|
| 41 |
|
|
| 42 |
// Include WB files |
|
| 43 |
require_once('../../config.php');
|
|
| 44 |
require_once(WB_PATH.'/framework/class.frontend.php'); |
|
| 45 |
$database = new database(); |
|
| 46 |
$wb = new frontend(); |
|
| 47 |
$wb->page_id = $page_id; |
|
| 48 |
$wb->get_page_details(); |
|
| 49 |
$wb->get_website_settings(); |
|
| 50 |
|
|
| 51 |
//checkout if a charset is defined otherwise use UTF-8 |
|
| 52 |
if(defined('DEFAULT_CHARSET')) {
|
|
| 53 |
$charset=DEFAULT_CHARSET; |
|
| 54 |
} else {
|
|
| 55 |
$charset='utf-8'; |
|
| 56 |
} |
|
| 57 |
|
|
| 58 |
// Sending XML header |
|
| 59 |
header("Content-type: text/xml; charset=$charset" );
|
|
| 60 |
|
|
| 61 |
// Header info |
|
| 62 |
// Required by CSS 2.0 |
|
| 63 |
echo '<?xml version="1.0" encoding="'.$charset.'"?>'; |
|
| 64 |
?> |
|
| 65 |
<rss version="2.0"> |
|
| 66 |
<channel> |
|
| 67 |
<title><?php echo PAGE_TITLE; ?></title> |
|
| 68 |
<link>http://<?php echo $_SERVER['SERVER_NAME']; ?></link> |
|
| 69 |
<description> <?php echo PAGE_DESCRIPTION; ?></description> |
|
| 70 |
<?php |
|
| 71 |
// Optional header info |
|
| 72 |
?> |
|
| 73 |
<language><?php echo strtolower(DEFAULT_LANGUAGE); ?></language> |
|
| 74 |
<copyright><?php $thedate = date('Y'); $websitetitle = WEBSITE_TITLE; echo "Copyright {$thedate}, {$websitetitle}"; ?></copyright>
|
|
| 75 |
<managingEditor><?php echo SERVER_EMAIL; ?></managingEditor> |
|
| 76 |
<webMaster><?php echo SERVER_EMAIL; ?></webMaster> |
|
| 77 |
<category><?php echo WEBSITE_TITLE; ?></category> |
|
| 78 |
<generator>Website Baker Content Management System</generator> |
|
| 79 |
|
|
| 80 |
<?php |
|
| 81 |
// Get news items from database |
|
| 82 |
$t = TIME(); |
|
| 83 |
$time_check_str= "(published_when = '0' OR published_when <= ".$t.") AND (published_until = 0 OR published_until >= ".$t.")"; |
|
| 84 |
//Query |
|
| 85 |
if(isset($group_id)) {
|
|
| 86 |
$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"; |
|
| 87 |
} else {
|
|
| 88 |
$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"; |
|
| 89 |
} |
|
| 90 |
$result = $database->query($query); |
|
| 91 |
|
|
| 92 |
//Generating the news items |
|
| 93 |
while($item = $result->fetchRow($result)){ ?>
|
|
| 94 |
|
|
| 95 |
<item> |
|
| 96 |
<title><![CDATA[<?php echo stripslashes($item["title"]); ?>]]></title> |
|
| 97 |
<description><![CDATA[<?php echo stripslashes($item["content_short"]); ?>]]></description> |
|
| 98 |
<guid><?php echo WB_URL.PAGES_DIRECTORY.$item["link"].PAGE_EXTENSION; ?></guid> |
|
| 99 |
<link><?php echo WB_URL.PAGES_DIRECTORY.$item["link"].PAGE_EXTENSION; ?></link> |
|
| 100 |
</item> |
|
| 101 |
|
|
| 102 |
<?php } ?> |
|
| 103 |
|
|
| 104 |
</channel> |
|
| 102 | 105 |
</rss> |
Also available in: Unified diff
Ticket #770, #785, #792, #807, #809, fixes and recoded the news module