-
Notifications
You must be signed in to change notification settings - Fork 17
/
Copy pathrss.php
27 lines (26 loc) · 1.03 KB
/
rss.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
<? header("location: http://blog.CAcert.org/feed/"); exit; ?>
<? /* <author>$row['who'] <nomail@nospam.sss></author> */ ?>
<? header("Content-Type: application/xml");
?><<?="?"?>xml version="1.0" encoding="UTF-8" <?="?"?>>
<rss version="2.0">
<channel>
<title>CAcert.org NEWS!</title>
<link>http://www.CAcert.org/</link>
<copyright>Copyright © 2002-present, CAcert Inc.</copyright>
<description>News feed for CAcert.org</description>
<pubDate><?=date("D, d M Y H:i:s O")?></pubDate>
<lastBuildDate><?=date("D, d M Y H:i:s O")?></lastBuildDate>
<ttl>3600</ttl><?
$query = "select *, UNIX_TIMESTAMP(`when`) as `TS` from news order by `when` desc limit 10";
$res = mysql_query($query);
while($row = mysql_fetch_assoc($res))
{ ?>
<item>
<title><?=strip_tags($row['short'])?></title>
<description><?=strip_tags($row['story'])?></description>
<link>http://www.cacert.org/news.php?from=rss&id=<?=$row['id']?></link>
<pubDate><?=date("D, d M Y H:i:s O", $row['TS'])?></pubDate>
</item>
<? } ?>
</channel>
</rss>