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
122
123
124
125
126
127
128
129
130
|
<?php
function path($fragment=null) {
global $config;
if($fragment === null) return $config['path'];
return (!empty($config['path'][$fragment])) ? $config['path'][$fragment] : false;
}
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;
}
function twitter_post_status($status='') {
global $config;
require_once(ROOT.DS.'twitter_api.php');
if(empty($status)) return array('errors' => 1);
if(empty($config['twitter']['oauth_access_token']) ||
empty($config['twitter']['oauth_access_token_secret']) ||
empty($config['twitter']['consumer_key']) ||
empty($config['twitter']['consumer_secret'])) return array('errors' => 2);
$url = 'https://api.twitter.com/1.1/statuses/update.json';
$postfields = array(
'status' => $status,
'trim_user' => 1
);
$twitter = new TwitterAPIExchange($config['twitter']);
return $twitter->buildOauth($url, 'POST')->setPostfields($postfields)->performRequest();
}
|
