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
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
|
<?php
function path($fragment=null) {
global $config;
if($fragment === null) return $config['path'];
return (!empty($config['path'][$fragment])) ? $config['path'][$fragment] : false;
}
function autolink($text='') {
// https://stackoverflow.com/a/10002262/3625228
$pattern = '(?xi)\b((?:https?://|www\d{0,3}[.]|[a-z0-9.\-]+[.][a-z]{2,4}/)(?:[^\s()<>]+|\(([^\s()<>]+|(\([^\s()<>]+\)))*\))+(?:\(([^\s()<>]+|(\([^\s()<>]+\)))*\)|[^\s`!()\[\]{};:\'".,<>?«»“”‘’]))';
return preg_replace_callback("#$pattern#i", function($matches) {
$input = $matches[0];
$url = preg_match('!^https?://!i', $input) ? $input : "http://$input";
return '<a href="' . $url . '" rel="nofollow" target="_blank">' . "$input</a>";
}, $text);
}
function db_insert($message, $timestamp=NOW) {
global $db;
if(empty($db)) return false;
$statement = $db->prepare('INSERT INTO posts (post_content, post_timestamp) VALUES (:post_content, :post_timestamp)');
$statement->bindParam(':post_content', $message, PDO::PARAM_STR);
$statement->bindParam(':post_timestamp', $timestamp, PDO::PARAM_INT);
$statement->execute();
return $db->lastInsertId();
}
function db_select_post($id=0) {
global $db;
if(empty($db)) return false;
if($id === 0) return false;
$statement = $db->prepare('SELECT * FROM posts WHERE id = :id LIMIT 1');
$statement->bindParam(':id', $id, PDO::PARAM_INT);
$statement->execute();
$row = $statement->fetch(PDO::FETCH_ASSOC);
return (!empty($row)) ? $row : false;
}
function db_select_posts($from=NOW, $amount=10, $sort='desc', $page=1) {
global $config;
global $db;
if(empty($db)) return false;
if($sort !== 'desc') $sort = 'asc';
$offset = ($page-1)*$config['posts_per_page'];
$statement = $db->prepare('SELECT * FROM posts WHERE post_timestamp < :post_timestamp ORDER BY id '.$sort.' LIMIT :limit OFFSET :page');
$statement->bindParam(':post_timestamp', $from, PDO::PARAM_INT);
$statement->bindParam(':limit', $amount, PDO::PARAM_INT);
$statement->bindParam(':page', $offset, PDO::PARAM_INT);
$statement->execute();
$rows = $statement->fetchAll(PDO::FETCH_ASSOC);
return (!empty($rows)) ? $rows : false;
}
/* function that pings the official micro.blog endpoint for feed refreshes */
function ping_microblog() {
global $config;
$ping_url = 'https://micro.blog/ping';
$feed_url = $config['url'].'/feed.json';
$ch = curl_init($ping_url);
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_POSTFIELDS, 'url='.urlencode($feed_url));
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
curl_setopt($ch, CURLOPT_HEADER, true);
curl_setopt($ch, CURLOPT_NOBODY, true);
curl_setopt($ch, CURLOPT_TIMEOUT, 10);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$response = curl_exec($ch);
$status = curl_getinfo($ch, CURLINFO_HTTP_CODE);
return ($status == 200) ? true : false;
}
function rebuild_feed($amount=10) {
global $config;
$feed = array(
'version' => 'https://jsonfeed.org/version/1',
'title' => 'status updates by '.$config['microblog_account'],
'description' => '',
'home_page_url' => $config['url'],
'feed_url' => $config['url'].'/feed.json',
'user_comment' => '',
'favicon' => '',
'author' => array('name' => $config['microblog_account']),
'items' => array()
);
// make a timezone string for dates (is this dumb?)
$timezone_offset = timezone_offset_get(timezone_open('UTC'), new DateTime())/60/60; // this is probably incorrect
$timezone_offset_string = (is_int($timezone_offset) && $timezone_offset >= 0) ? '+'.str_pad($timezone_offset, 2, '0', STR_PAD_LEFT).':00' : '-'.str_pad($timezone_offset, 2, '0', STR_PAD_LEFT).':00';
$posts = db_select_posts(NOW+60, $amount, 'desc');
foreach($posts as $post) {
$feed['items'][] = array(
'id' => $config['url'].'/'.$post['id'],
'url' => $config['url'].'/'.$post['id'],
'title' => '',
'content_html' => $post['post_content'],
'date_published' => strftime('%Y-%m-%dT%H:%M:%S', $post['post_timestamp']).$timezone_offset_string
);
}
if(file_put_contents(ROOT.DS.'feed.json', json_encode($feed, JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES))) {
return true;
} else return false;
}
|
