forked from nhodges/neighbr
-
Notifications
You must be signed in to change notification settings - Fork 0
/
rss.php
64 lines (56 loc) · 2.16 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
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
<?php
require_once "./include/config.php";
require_once "./include/inursql.php";
$db = new inursql();
$c = $db->connect($hostname, $username, $password, $database);
if(!isset($_GET['user'])) {
$title = "Neighbrhood Report";
$sql = "SELECT * FROM posts WHERE objectionable = 0 ORDER BY id DESC LIMIT 0,20";
$url = "http://neighbr.net/feed";
} else {
$neighbr = sanitize($_GET['user']);
$title = "Neighbrhood Report: $neighbr";
$sql = "SELECT * FROM posts WHERE objectionable = 0 AND neighbr = '$neighbr' ORDER BY id DESC LIMIT 0,20";
$url = "http://neighbr.net/$neighbr/feed";
}
$result = $db->query($sql);
if(mysql_num_rows($result) == 0) { die("There seems to be some sort of force field."); }
header("Content-type: text/xml");
echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\r\n";
echo "<rss version=\"2.0\">\r\n";
echo "<channel>\r\n";
echo "<title>$title</title>\r\n";
echo "<description>What have your neighbrs been up to?</description>\r\n";
echo "<link>$url</link>\r\n";
echo "<language>en-us</language>\r\n";
while($post = $db->grab($result)) {
$pubDate = date("D, d M Y H:i:s O", strtotime($post['timestamp']));
echo "\t<item>\r\n";
echo "\t\t<neighbr>$post[neighbr]</neighbr>\r\n";
if(file_exists("./img/avatars/$post[neighbr].jpg")) {
$avatar = "http://neighbr.net/img/avatars/$post[neighbr].jpg";
} else {
$avatar = "http://neighbr.net/img/avatars/neighbrhood.jpg";
}
echo "\t\t<avatar>$avatar</avatar>\r\n";
echo "\t\t<title>" . str_replace("&", "&", $post[title]) . "</title>\r\n";
echo "\t\t<description>" . str_replace("&", "&", $post[note]) . "</description>\r\n";
switch($post['type']) {
case "text";
case "code";
echo "";
break;
case "link";
echo "\t\t<source>" . str_replace("&", "&", $post[note]) . "</source>\r\n";
break;
default;
echo "\t\t<source>" . str_replace("&", "&", $post[source]) . "</source>\r\n";
echo "";
}
echo "\t\t<pubDate>$pubDate</pubDate>\r\n";
echo "\t\t<guid>http://neighbr.net/view/$post[id]</guid>\r\n";
echo "\t\t<link>http://neighbr.net/view/$post[id]</link>\r\n";
echo "\t</item>\r\n";
}
echo "</channel>\r\n";
echo "</rss>\r\n";