*/
use Friendica\App;
+use Friendica\Core\System;
use Friendica\ParseUrl;
+use Friendica\Util\Lock;
+use Friendica\Core\Config;
+use Friendica\Core\PConfig;
+use Friendica\Core\Worker;
+use Friendica\Database\DBM;
+use Friendica\Protocol\DFRN;
require_once 'include/bbcode.php';
require_once 'include/oembed.php';
require_once 'include/Contact.php';
require_once 'mod/share.php';
require_once 'include/enotify.php';
-require_once 'include/dfrn.php';
require_once 'include/group.php';
/// @TODO one day with composer autoloader no more needed
/// @todo make a positive list of allowed characters
$hashtag = str_replace(array(" ", "+", "/", ".", "#", "'", "’", "`", "(", ")", "„", "“"),
array("", "", "", "", "", "", "", "", "", "", "", ""), $keyword);
- $hashtags .= "#[url=" . App::get_baseurl() . "/search?tag=" . rawurlencode($hashtag) . "]" . $hashtag . "[/url] ";
+ $hashtags .= "#[url=" . System::baseUrl() . "/search?tag=" . rawurlencode($hashtag) . "]" . $hashtag . "[/url] ";
}
}
$tags .= ", ";
}
- $tags .= "#[url=" . App::get_baseurl() . "/search?tag=" . rawurlencode($hashtag) . "]" . $hashtag . "[/url]";
+ $tags .= "#[url=" . System::baseUrl() . "/search?tag=" . rawurlencode($hashtag) . "]" . $hashtag . "[/url]";
}
}
$postopts = "";
}
- require_once('library/langdet/Text/LanguageDetect.php');
-
$naked_body = preg_replace('/\[(.+?)\]/','', $arr['body']);
$l = new Text_LanguageDetect();
- //$lng = $l->detectConfidence($naked_body);
- //$arr['postopts'] = (($lng['language']) ? 'lang=' . $lng['language'] . ';' . $lng['confidence'] : '');
$lng = $l->detect($naked_body, 3);
if (sizeof($lng) > 0) {
// We have to avoid that different routines could accidentally create the same value
$parsed = parse_url($uri);
+ // When the hostname isn't given, we take it from the uri
if ($host == "") {
- $host = $parsed["host"];
+ // Is it in the format data@host.tld?
+ if ((count($parsed) == 1) && strstr($uri, '@')) {
+ $mailparts = explode('@', $uri);
+ $host = array_pop($mailparts);
+ } else {
+ $host = $parsed["host"];
+ }
}
+ // We use a hash of the hostname as prefix for the guid
$guid_prefix = hash("crc32", $host);
// Remove the scheme to make sure that "https" and "http" doesn't make a difference
unset($parsed["scheme"]);
+ // Glue it together to be able to make a hash from it
$host_id = implode("/", $parsed);
// We could use any hash algorithm since it isn't a security issue
*/
function store_conversation($arr) {
if (in_array($arr['network'], array(NETWORK_DFRN, NETWORK_DIASPORA, NETWORK_OSTATUS))) {
- $conversation = array('item-uri' => $arr['uri'], 'received' => dbm::date());
+ $conversation = array('item-uri' => $arr['uri'], 'received' => DBM::date());
if (isset($arr['parent-uri']) && ($arr['parent-uri'] != $arr['uri'])) {
$conversation['reply-to-uri'] = $arr['parent-uri'];
$old_conv = dba::fetch_first("SELECT `item-uri`, `reply-to-uri`, `conversation-uri`, `conversation-href`, `protocol`, `source`
FROM `conversation` WHERE `item-uri` = ?", $conversation['item-uri']);
- if (dbm::is_result($old_conv)) {
+ if (DBM::is_result($old_conv)) {
// Don't update when only the source has changed.
// Only do this when there had been no source before.
if ($old_conv['source'] != '') {
logger('Conversation: update for '.$conversation['item-uri'].' from '.$conv['protocol'].' to '.$conversation['protocol'].' failed', LOGGER_DEBUG);
}
} else {
- if (!dba::insert('conversation', $conversation)) {
+ if (!dba::insert('conversation', $conversation, true)) {
logger('Conversation: insert for '.$conversation['item-uri'].' (protocol '.$conversation['protocol'].') failed', LOGGER_DEBUG);
}
}
}
// Converting the plink
+ /// @todo Check if this is really still needed
if ($arr['network'] == NETWORK_OSTATUS) {
if (isset($arr['plink'])) {
$arr['plink'] = ostatus::convert_href($arr['plink']);
$arr['type'] = 'remote';
}
- // check for create date and expire time
$uid = intval($arr['uid']);
- $r = q("SELECT expire FROM user WHERE uid = %d", intval($uid));
- if (dbm::is_result($r)) {
- $expire_interval = $r[0]['expire'];
- if ($expire_interval>0) {
- $expire_date = new DateTime( '- '.$expire_interval.' days', new DateTimeZone('UTC'));
- $created_date = new DateTime($arr['created'], new DateTimeZone('UTC'));
- if ($created_date < $expire_date) {
- logger('item-store: item created ('.$arr['created'].') before expiration time ('.$expire_date->format(DateTime::W3C).'). ignored. ' . print_r($arr,true), LOGGER_DEBUG);
- return 0;
- }
+
+ // check for create date and expire time
+ $expire_interval = Config::get('system', 'dbclean-expire-days', 0);
+
+ $r = dba::select('user', array('expire'), array('uid' => $uid), array("limit" => 1));
+ if (DBM::is_result($r) && ($r['expire'] > 0) && (($r['expire'] < $expire_interval) || ($expire_interval == 0))) {
+ $expire_interval = $r['expire'];
+ }
+
+ if (($expire_interval > 0) && !empty($arr['created'])) {
+ $expire_date = time() - ($expire_interval * 86400);
+ $created_date = strtotime($arr['created']);
+ if ($created_date < $expire_date) {
+ logger('item-store: item created ('.date('c', $created_date).') before expiration time ('.date('c', $expire_date).'). ignored. ' . print_r($arr,true), LOGGER_DEBUG);
+ return 0;
}
}
dbesc(NETWORK_DFRN),
dbesc(NETWORK_OSTATUS)
);
- if (dbm::is_result($r)) {
+ if (DBM::is_result($r)) {
// We only log the entries with a different user id than 0. Otherwise we would have too many false positives
if ($uid != 0) {
logger("Item with uri ".$arr['uri']." already existed for user ".$uid." with id ".$r[0]["id"]." target network ".$r[0]["network"]." - new network: ".$arr['network']);
$arr['owner-name'] = ((x($arr, 'owner-name')) ? trim($arr['owner-name']) : '');
$arr['owner-link'] = ((x($arr, 'owner-link')) ? notags(trim($arr['owner-link'])) : '');
$arr['owner-avatar'] = ((x($arr, 'owner-avatar')) ? notags(trim($arr['owner-avatar'])) : '');
- $arr['created'] = ((x($arr, 'created') !== false) ? datetime_convert('UTC','UTC', $arr['created']) : datetime_convert());
- $arr['edited'] = ((x($arr, 'edited') !== false) ? datetime_convert('UTC','UTC', $arr['edited']) : datetime_convert());
- $arr['commented'] = ((x($arr, 'commented') !== false) ? datetime_convert('UTC','UTC', $arr['commented']) : datetime_convert());
- $arr['received'] = ((x($arr, 'received') !== false) ? datetime_convert('UTC','UTC', $arr['received']) : datetime_convert());
- $arr['changed'] = ((x($arr, 'changed') !== false) ? datetime_convert('UTC','UTC', $arr['changed']) : datetime_convert());
+ $arr['received'] = ((x($arr, 'received') !== false) ? datetime_convert('UTC','UTC', $arr['received']) : datetime_convert());
+ $arr['created'] = ((x($arr, 'created') !== false) ? datetime_convert('UTC','UTC', $arr['created']) : $arr['received']);
+ $arr['edited'] = ((x($arr, 'edited') !== false) ? datetime_convert('UTC','UTC', $arr['edited']) : $arr['created']);
+ $arr['changed'] = ((x($arr, 'changed') !== false) ? datetime_convert('UTC','UTC', $arr['changed']) : $arr['created']);
+ $arr['commented'] = ((x($arr, 'commented') !== false) ? datetime_convert('UTC','UTC', $arr['commented']) : $arr['created']);
$arr['title'] = ((x($arr, 'title')) ? trim($arr['title']) : '');
$arr['location'] = ((x($arr, 'location')) ? trim($arr['location']) : '');
$arr['coord'] = ((x($arr, 'coord')) ? notags(trim($arr['coord'])) : '');
$arr['inform'] = ((x($arr, 'inform')) ? trim($arr['inform']) : '');
$arr['file'] = ((x($arr, 'file')) ? trim($arr['file']) : '');
+ // When there is no content then we don't post it
+ if ($arr['body'].$arr['title'] == '') {
+ return 0;
+ }
+
// Items cannot be stored before they happen ...
if ($arr['created'] > datetime_convert()) {
$arr['created'] = datetime_convert();
}
if (($arr['author-link'] == "") && ($arr['owner-link'] == "")) {
- logger("Both author-link and owner-link are empty. Called by: " . App::callstack(), LOGGER_DEBUG);
+ logger("Both author-link and owner-link are empty. Called by: " . System::callstack(), LOGGER_DEBUG);
}
if ($arr['plink'] == "") {
- $arr['plink'] = App::get_baseurl() . '/display/' . urlencode($arr['guid']);
+ $arr['plink'] = System::baseUrl() . '/display/' . urlencode($arr['guid']);
}
if ($arr['network'] == "") {
intval($arr['uid'])
);
- if (!dbm::is_result($r))
+ if (!DBM::is_result($r))
$r = q("SELECT `network` FROM `gcontact` WHERE `network` IN ('%s', '%s', '%s') AND `nurl` = '%s' LIMIT 1",
dbesc(NETWORK_DFRN), dbesc(NETWORK_DIASPORA), dbesc(NETWORK_OSTATUS),
dbesc(normalise_link($arr['author-link']))
);
- if (!dbm::is_result($r)) {
+ if (!DBM::is_result($r)) {
$r = q("SELECT `network` FROM `contact` WHERE `id` = %d AND `uid` = %d LIMIT 1",
intval($arr['contact-id']),
intval($arr['uid'])
);
}
- if (dbm::is_result($r)) {
+ if (DBM::is_result($r)) {
$arr['network'] = $r[0]["network"];
}
if ($arr["contact-id"] == 0) {
$r = q("SELECT `id` FROM `contact` WHERE `self` AND `uid` = %d", intval($uid));
- if (dbm::is_result($r)) {
+ if (DBM::is_result($r)) {
$arr["contact-id"] = $r[0]["id"];
}
}
$arr["author-id"] = get_contact($arr["author-link"], 0);
}
+ if (blockedContact($arr["author-id"])) {
+ logger('Contact '.$arr["author-id"].' is blocked, item '.$arr["uri"].' will not be stored');
+ return 0;
+ }
+
if ($arr["owner-id"] == 0) {
$arr["owner-id"] = get_contact($arr["owner-link"], 0);
}
+ if (blockedContact($arr["owner-id"])) {
+ logger('Contact '.$arr["owner-id"].' is blocked, item '.$arr["uri"].' will not be stored');
+ return 0;
+ }
+
if ($arr['guid'] != "") {
// Checking if there is already an item with the same guid
logger('checking for an item for user '.$arr['uid'].' on network '.$arr['network'].' with the guid '.$arr['guid'], LOGGER_DEBUG);
$r = q("SELECT `guid` FROM `item` WHERE `guid` = '%s' AND `network` = '%s' AND `uid` = '%d' LIMIT 1",
dbesc($arr['guid']), dbesc($arr['network']), intval($arr['uid']));
- if (dbm::is_result($r)) {
+ if (DBM::is_result($r)) {
logger('found item with guid '.$arr['guid'].' for user '.$arr['uid'].' on network '.$arr['network'], LOGGER_DEBUG);
return 0;
}
intval($arr['uid'])
);
- if (dbm::is_result($r)) {
+ if (DBM::is_result($r)) {
// is the new message multi-level threaded?
// even though we don't support it now, preserve the info
intval($arr['uid'])
);
- if (dbm::is_result($z)) {
+ if (DBM::is_result($z)) {
$r = $z;
}
}
* The original author commented, but as this is a comment, the permissions
* weren't fixed up so it will still show the comment as private unless we fix it here.
*/
- if ((intval($r[0]['forum_mode']) == 1) && (! $r[0]['private'])) {
+ if ((intval($r[0]['forum_mode']) == 1) && $r[0]['private']) {
$arr['private'] = 0;
}
// If its a post from myself then tag the thread as "mention"
logger("item_store: Checking if parent ".$parent_id." has to be tagged as mention for user ".$arr['uid'], LOGGER_DEBUG);
$u = q("SELECT `nickname` FROM `user` WHERE `uid` = %d", intval($arr['uid']));
- if (dbm::is_result($u)) {
+ if (DBM::is_result($u)) {
$a = get_app();
- $self = normalise_link(App::get_baseurl() . '/profile/' . $u[0]['nickname']);
+ $self = normalise_link(System::baseUrl() . '/profile/' . $u[0]['nickname']);
logger("item_store: 'myself' is ".$self." for parent ".$parent_id." checking against ".$arr['author-link']." and ".$arr['owner-link'], LOGGER_DEBUG);
if ((normalise_link($arr['author-link']) == $self) || (normalise_link($arr['owner-link']) == $self)) {
- q("UPDATE `thread` SET `mention` = 1 WHERE `iid` = %d", intval($parent_id));
+ dba::update('thread', array('mention' => true), array('iid' => $parent_id));
logger("item_store: tagged thread ".$parent_id." as mention for user ".$self, LOGGER_DEBUG);
}
}
dbesc(NETWORK_DFRN),
intval($arr['uid'])
);
- if (dbm::is_result($r)) {
+ if (DBM::is_result($r)) {
logger('duplicated item with the same uri found. '.print_r($arr,true));
return 0;
}
dbesc($arr['guid']),
intval($arr['uid'])
);
- if (dbm::is_result($r)) {
+ if (DBM::is_result($r)) {
logger('duplicated item with the same guid found. '.print_r($arr,true));
return 0;
}
intval($arr['contact-id']),
intval($arr['uid'])
);
- if (dbm::is_result($r)) {
+ if (DBM::is_result($r)) {
logger('duplicated item with the same body found. '.print_r($arr,true));
return 0;
}
$arr["global"] = true;
// Set the global flag on all items if this was a global item entry
- q("UPDATE `item` SET `global` = 1 WHERE `uri` = '%s'", dbesc($arr["uri"]));
+ dba::update('item', array('global' => true), array('uri' => $arr["uri"]));
} else {
$isglobal = q("SELECT `global` FROM `item` WHERE `uid` = 0 AND `uri` = '%s'", dbesc($arr["uri"]));
- $arr["global"] = (dbm::is_result($isglobal) && count($isglobal) > 0);
+ $arr["global"] = (DBM::is_result($isglobal) && count($isglobal) > 0);
}
// ACL settings
call_hooks('post_remote', $arr);
}
+ // This array field is used to trigger some automatic reactions
+ // It is mainly used in the "post_local" hook.
+ unset($arr['api_source']);
+
if (x($arr, 'cancel')) {
logger('item_store: post cancelled by plugin.');
return 0;
* An unique index would help - but the limitations of MySQL (maximum size of index values) prevent this.
*/
if ($arr["uid"] == 0) {
- $r = qu("SELECT `id` FROM `item` WHERE `uri` = '%s' AND `uid` = 0 LIMIT 1", dbesc(trim($arr['uri'])));
- if (dbm::is_result($r)) {
+ $r = q("SELECT `id` FROM `item` WHERE `uri` = '%s' AND `uid` = 0 LIMIT 1", dbesc(trim($arr['uri'])));
+ if (DBM::is_result($r)) {
logger('Global item already stored. URI: '.$arr['uri'].' on network '.$arr['network'], LOGGER_DEBUG);
return 0;
}
}
- // Store the unescaped version
- $unescaped = $arr;
-
- dbm::esc_array($arr, true);
-
logger('item_store: ' . print_r($arr,true), LOGGER_DATA);
dba::transaction();
-
- $r = dbq("INSERT INTO `item` (`"
- . implode("`, `", array_keys($arr))
- . "`) VALUES ("
- . implode(", ", array_values($arr))
- . ")");
-
- // And restore it
- $arr = $unescaped;
+ $r = dba::insert('item', $arr);
// When the item was successfully stored we fetch the ID of the item.
- if (dbm::is_result($r)) {
- $r = q("SELECT LAST_INSERT_ID() AS `item-id`");
- if (dbm::is_result($r)) {
- $current_post = $r[0]['item-id'];
- } else {
- // This shouldn't happen
- $current_post = 0;
- }
+ if (DBM::is_result($r)) {
+ $current_post = dba::lastInsertId();
} else {
// This can happen - for example - if there are locking timeouts.
dba::rollback();
dbesc($arr['network'])
);
- if (!dbm::is_result($r)) {
+ if (!DBM::is_result($r)) {
// This shouldn't happen, since COUNT always works when the database connection is there.
logger("We couldn't count the stored entries. Very strange ...");
dba::rollback();
}
// Set parent id
- $r = q("UPDATE `item` SET `parent` = %d WHERE `id` = %d",
- intval($parent_id),
- intval($current_post)
- );
+ $r = dba::update('item', array('parent' => $parent_id), array('id' => $current_post));
$arr['id'] = $current_post;
$arr['parent'] = $parent_id;
// update the commented timestamp on the parent
// Only update "commented" if it is really a comment
- if (($arr['verb'] == ACTIVITY_POST) || !get_config("system", "like_no_comment")) {
- q("UPDATE `item` SET `commented` = '%s', `changed` = '%s' WHERE `id` = %d",
- dbesc(datetime_convert()),
- dbesc(datetime_convert()),
- intval($parent_id)
- );
+ if (($arr['verb'] == ACTIVITY_POST) || !Config::get("system", "like_no_comment")) {
+ dba::update('item', array('commented' => datetime_convert(), 'changed' => datetime_convert()), array('id' => $parent_id));
} else {
- q("UPDATE `item` SET `changed` = '%s' WHERE `id` = %d",
- dbesc(datetime_convert()),
- intval($parent_id)
- );
+ dba::update('item', array('changed' => datetime_convert()), array('id' => $parent_id));
}
if ($dsprsig) {
logger("Repaired double encoded signature from handle ".$dsprsig->signer, LOGGER_DEBUG);
}
- q("INSERT INTO `sign` (`iid`,`signed_text`,`signature`,`signer`) values (%d,'%s','%s','%s') ",
- intval($current_post),
- dbesc($dsprsig->signed_text),
- dbesc($dsprsig->signature),
- dbesc($dsprsig->signer)
- );
+ dba::insert('sign', array('iid' => $current_post, 'signed_text' => $dsprsig->signed_text,
+ 'signature' => $dsprsig->signature, 'signer' => $dsprsig->signer));
}
$deleted = tag_deliver($arr['uid'], $current_post);
if (!$deleted && !$dontcache) {
$r = q('SELECT * FROM `item` WHERE `id` = %d', intval($current_post));
- if ((dbm::is_result($r)) && (count($r) == 1)) {
+ if ((DBM::is_result($r)) && (count($r) == 1)) {
if ($notify) {
call_hooks('post_local_end', $r[0]);
} else {
check_item_notification($current_post, $uid);
if ($notify) {
- proc_run(array('priority' => PRIORITY_HIGH, 'dont_fork' => true), "include/notifier.php", $notify_type, $current_post);
+ Worker::add(array('priority' => PRIORITY_HIGH, 'dont_fork' => true), "notifier", $notify_type, $current_post);
}
return $current_post;
if (!$update && ($arr["network"] == NETWORK_DFRN) && ($arr["parent-uri"] === $arr["uri"])) {
$isforum = q("SELECT `forum` FROM `contact` WHERE `id` = %d AND `forum`",
intval($arr['contact-id']));
- if (dbm::is_result($isforum)) {
+ if (DBM::is_result($isforum)) {
$update = true;
}
}
if ($update) {
- q("UPDATE `contact` SET `success_update` = '%s', `last-item` = '%s' WHERE `id` = %d",
- dbesc($arr['received']),
- dbesc($arr['received']),
- intval($arr['contact-id'])
- );
+ dba::update('contact', array('success_update' => $arr['received'], 'last-item' => $arr['received']),
+ array('id' => $arr['contact-id']));
}
// Now do the same for the system wide contacts with uid=0
if (!$arr['private']) {
- q("UPDATE `contact` SET `success_update` = '%s', `last-item` = '%s' WHERE `id` = %d",
- dbesc($arr['received']),
- dbesc($arr['received']),
- intval($arr['owner-id'])
- );
+ dba::update('contact', array('success_update' => $arr['received'], 'last-item' => $arr['received']),
+ array('id' => $arr['owner-id']));
if ($arr['owner-id'] != $arr['author-id']) {
- q("UPDATE `contact` SET `success_update` = '%s', `last-item` = '%s' WHERE `id` = %d",
- dbesc($arr['received']),
- dbesc($arr['received']),
- intval($arr['author-id'])
- );
+ dba::update('contact', array('success_update' => $arr['received'], 'last-item' => $arr['received']),
+ array('id' => $arr['author-id']));
}
}
}
$URLSearchString = "^\[\]";
- /// @TODO old-lost code?
- // All hashtags should point to the home server
- //$item["body"] = preg_replace("/#\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism",
- // "#[url=".App::get_baseurl()."/search?tag=$2]$2[/url]", $item["body"]);
+ // All hashtags should point to the home server if "local_tags" is activated
+ if (Config::get('system', 'local_tags')) {
+ $item["body"] = preg_replace("/#\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism",
+ "#[url=".System::baseUrl()."/search?tag=$2]$2[/url]", $item["body"]);
- //$item["tag"] = preg_replace("/#\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism",
- // "#[url=".App::get_baseurl()."/search?tag=$2]$2[/url]", $item["tag"]);
+ $item["tag"] = preg_replace("/#\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism",
+ "#[url=".System::baseUrl()."/search?tag=$2]$2[/url]", $item["tag"]);
+ }
// mask hashtags inside of url, bookmarks and attachments to avoid urls in urls
$item["body"] = preg_replace_callback("/\[url\=([$URLSearchString]*)\](.*?)\[\/url\]/ism",
$basetag = str_replace('_',' ',substr($tag,1));
- $newtag = '#[url=' . App::get_baseurl() . '/search?tag=' . rawurlencode($basetag) . ']' . $basetag . '[/url]';
+ $newtag = '#[url=' . System::baseUrl() . '/search?tag=' . rawurlencode($basetag) . ']' . $basetag . '[/url]';
$item["body"] = str_replace($tag, $newtag, $item["body"]);
function get_item_guid($id) {
$r = q("SELECT `guid` FROM `item` WHERE `id` = %d LIMIT 1", intval($id));
- if (dbm::is_result($r)) {
+ if (DBM::is_result($r)) {
return $r[0]["guid"];
} else {
/// @TODO This else-block can be elimited again
$r = q("SELECT `item`.`id`, `user`.`nickname` FROM `item` INNER JOIN `user` ON `user`.`uid` = `item`.`uid`
WHERE `item`.`visible` = 1 AND `item`.`deleted` = 0 AND `item`.`moderated` = 0
AND `item`.`guid` = '%s' AND `item`.`uid` = %d", dbesc($guid), intval($uid));
- if (dbm::is_result($r)) {
+ if (DBM::is_result($r)) {
$id = $r[0]["id"];
$nick = $r[0]["nickname"];
}
AND `item`.`deny_cid` = '' AND `item`.`deny_gid` = ''
AND `item`.`private` = 0 AND `item`.`wall` = 1
AND `item`.`guid` = '%s'", dbesc($guid));
- if (dbm::is_result($r)) {
+ if (DBM::is_result($r)) {
$id = $r[0]["id"];
$nick = $r[0]["nickname"];
}
intval($uid)
);
- if (! dbm::is_result($u)) {
+ if (! DBM::is_result($u)) {
return;
}
intval($item_id),
intval($uid)
);
- if (! dbm::is_result($i)) {
+ if (! DBM::is_result($i)) {
return;
}
$item = $i[0];
- $link = normalise_link(App::get_baseurl() . '/profile/' . $u[0]['nickname']);
+ $link = normalise_link(System::baseUrl() . '/profile/' . $u[0]['nickname']);
/*
* Diaspora uses their own hardwired link URL in @-tags
* instead of the one we supply with webfinger
*/
- $dlink = normalise_link(App::get_baseurl() . '/u/' . $u[0]['nickname']);
+ $dlink = normalise_link(System::baseUrl() . '/u/' . $u[0]['nickname']);
$cnt = preg_match_all('/[\@\!]\[url\=(.*?)\](.*?)\[\/url\]/ism', $item['body'], $matches, PREG_SET_ORDER);
if ($cnt) {
$c = q("SELECT `name`, `url`, `thumb` FROM `contact` WHERE `self` = 1 AND `uid` = %d LIMIT 1",
intval($u[0]['uid'])
);
- if (! dbm::is_result($c)) {
+ if (! DBM::is_result($c)) {
return;
}
);
update_thread($item_id);
- proc_run(array('priority' => PRIORITY_HIGH, 'dont_fork' => true), 'include/notifier.php', 'tgroup', $item_id);
+ Worker::add(array('priority' => PRIORITY_HIGH, 'dont_fork' => true), 'notifier', 'tgroup', $item_id);
}
$u = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1",
intval($uid)
);
- if (! dbm::is_result($u)) {
+ if (! DBM::is_result($u)) {
return false;
}
$community_page = (($u[0]['page-flags'] == PAGE_COMMUNITY) ? true : false);
$prvgroup = (($u[0]['page-flags'] == PAGE_PRVGROUP) ? true : false);
- $link = normalise_link(App::get_baseurl() . '/profile/' . $u[0]['nickname']);
+ $link = normalise_link(System::baseUrl() . '/profile/' . $u[0]['nickname']);
/*
* Diaspora uses their own hardwired link URL in @-tags
* instead of the one we supply with webfinger
*/
- $dlink = normalise_link(App::get_baseurl() . '/u/' . $u[0]['nickname']);
+ $dlink = normalise_link(System::baseUrl() . '/u/' . $u[0]['nickname']);
$cnt = preg_match_all('/[\@\!]\[url\=(.*?)\](.*?)\[\/url\]/ism', $item['body'], $matches, PREG_SET_ORDER);
if ($cnt) {
*
* @todo fix type-hints (both array)
*/
-function edited_timestamp_is_newer ($existing, $update) {
+function edited_timestamp_is_newer($existing, $update) {
if (!x($existing, 'edited') || !$existing['edited']) {
return true;
}
WHERE `contact`.`id` = %d AND `user`.`uid` = %d",
dbesc($contact["id"]), dbesc($importer["uid"])
);
- if (dbm::is_result($r)) {
+ if (DBM::is_result($r)) {
logger("Now import the DFRN feed");
- dfrn::import($xml, $r[0], true);
+ DFRN::import($xml, $r[0], true);
return;
}
}
if ($contact['remote_self'] == 2) {
$r = q("SELECT `id`,`url`,`name`,`thumb` FROM `contact` WHERE `uid` = %d AND `self`",
intval($contact['uid']));
- if (dbm::is_result($r)) {
+ if (DBM::is_result($r)) {
$datarray['contact-id'] = $r[0]["id"];
$datarray['owner-name'] = $r[0]["name"];
$datarray['author-name'] = $datarray['owner-name'];
$datarray['author-link'] = $datarray['owner-link'];
$datarray['author-avatar'] = $datarray['owner-avatar'];
+
+ unset($datarray['created']);
+ unset($datarray['edited']);
}
if ($contact['network'] != NETWORK_FEED) {
$datarray["app"] = "Feed";
}
+ // Trigger automatic reactions for addons
+ $datarray['api_source'] = true;
+
+ // We have to tell the hooks who we are - this really should be improved
+ $_SESSION["authenticated"] = true;
+ $_SESSION["uid"] = $contact['uid'];
+
return true;
}
if (is_array($contact)) {
if (($contact['network'] == NETWORK_OSTATUS && $contact['rel'] == CONTACT_IS_SHARING)
|| ($sharing && $contact['rel'] == CONTACT_IS_FOLLOWER)) {
- $r = q("UPDATE `contact` SET `rel` = %d, `writable` = 1 WHERE `id` = %d AND `uid` = %d",
- intval(CONTACT_IS_FRIEND),
- intval($contact['id']),
- intval($importer['uid'])
- );
+ $r = dba::update('contact', array('rel' => CONTACT_IS_FRIEND, 'writable' => true),
+ array('id' => $contact['id'], 'uid' => $importer['uid']));
}
// send email notification to owner?
} else {
intval($importer['uid']),
dbesc($url)
);
- if (dbm::is_result($r)) {
+ if (DBM::is_result($r)) {
$contact_record = $r[0];
update_contact_avatar($photo, $importer["uid"], $contact_record["id"], true);
}
intval($importer['uid'])
);
- if (dbm::is_result($r) && !in_array($r[0]['page-flags'], array(PAGE_SOAPBOX, PAGE_FREELOVE))) {
+ if (DBM::is_result($r) && !in_array($r[0]['page-flags'], array(PAGE_SOAPBOX, PAGE_FREELOVE, PAGE_COMMUNITY))) {
// create notification
$hash = random_string();
if (is_array($contact_record)) {
- $ret = q("INSERT INTO `intro` ( `uid`, `contact-id`, `blocked`, `knowyou`, `hash`, `datetime`)
- VALUES ( %d, %d, 0, 0, '%s', '%s' )",
- intval($importer['uid']),
- intval($contact_record['id']),
- dbesc($hash),
- dbesc(datetime_convert())
- );
+ dba::insert('intro', array('uid' => $importer['uid'], 'contact-id' => $contact_record['id'],
+ 'blocked' => false, 'knowyou' => false,
+ 'hash' => $hash, 'datetime' => datetime_convert()));
}
$def_gid = get_default_group($importer['uid'], $contact_record["network"]);
'to_name' => $r[0]['username'],
'to_email' => $r[0]['email'],
'uid' => $r[0]['uid'],
- 'link' => App::get_baseurl() . '/notifications/intro',
+ 'link' => System::baseUrl() . '/notifications/intro',
'source_name' => ((strlen(stripslashes($contact_record['name']))) ? stripslashes($contact_record['name']) : t('[Name Withheld]')),
'source_link' => $contact_record['url'],
'source_photo' => $contact_record['photo'],
));
}
- } elseif (dbm::is_result($r) && in_array($r[0]['page-flags'], array(PAGE_SOAPBOX, PAGE_FREELOVE))) {
+ } elseif (DBM::is_result($r) && in_array($r[0]['page-flags'], array(PAGE_SOAPBOX, PAGE_FREELOVE, PAGE_COMMUNITY))) {
$r = q("UPDATE `contact` SET `pending` = 0 WHERE `uid` = %d AND `url` = '%s' AND `pending` LIMIT 1",
intval($importer['uid']),
dbesc($url)
function lose_follower($importer, $contact, array $datarray = array(), $item = "") {
if (($contact['rel'] == CONTACT_IS_FRIEND) || ($contact['rel'] == CONTACT_IS_SHARING)) {
- q("UPDATE `contact` SET `rel` = %d WHERE `id` = %d",
- intval(CONTACT_IS_SHARING),
- intval($contact['id'])
- );
+ dba::update('contact', array('rel' => CONTACT_IS_SHARING), array('id' => $contact['id']));
} else {
contact_remove($contact['id']);
}
function lose_sharer($importer, $contact, array $datarray = array(), $item = "") {
if (($contact['rel'] == CONTACT_IS_FRIEND) || ($contact['rel'] == CONTACT_IS_FOLLOWER)) {
- q("UPDATE `contact` SET `rel` = %d WHERE `id` = %d",
- intval(CONTACT_IS_FOLLOWER),
- intval($contact['id'])
- );
+ dba::update('contact', array('rel' => CONTACT_IS_FOLLOWER), array('id' => $contact['id']));
} else {
contact_remove($contact['id']);
}
* through the direct Diaspora protocol. If we try and use
* the feed, we'll get duplicates. So don't.
*/
- if ((! dbm::is_result($r)) || $contact['network'] === NETWORK_DIASPORA) {
+ if ((! DBM::is_result($r)) || $contact['network'] === NETWORK_DIASPORA) {
return;
}
- $push_url = get_config('system','url') . '/pubsub/' . $r[0]['nickname'] . '/' . $contact['id'];
+ $push_url = Config::get('system','url') . '/pubsub/' . $r[0]['nickname'] . '/' . $contact['id'];
// Use a single verify token, even if multiple hubs
$verify_token = ((strlen($contact['hub-verify'])) ? $contact['hub-verify'] : random_string());
logger('subscribe_to_hub: ' . $hubmode . ' ' . $contact['name'] . ' to hub ' . $url . ' endpoint: ' . $push_url . ' with verifier ' . $verify_token);
if (!strlen($contact['hub-verify']) || ($contact['hub-verify'] != $verify_token)) {
- $r = q("UPDATE `contact` SET `hub-verify` = '%s' WHERE `id` = %d",
- dbesc($verify_token),
- intval($contact['id'])
- );
+ $r = dba::update('contact', array('hub-verify' => $verify_token), array('id' => $contact['id']));
}
post_url($url, $params);
function fix_private_photos($s, $uid, $item = null, $cid = 0) {
- if (get_config('system','disable_embedded')) {
+ if (Config::get('system','disable_embedded')) {
return $s;
}
$a = get_app();
logger('fix_private_photos: check for photos', LOGGER_DEBUG);
- $site = substr(App::get_baseurl(),strpos(App::get_baseurl(),'://'));
+ $site = substr(System::baseUrl(),strpos(System::baseUrl(),'://'));
$orig_body = $s;
$new_body = '';
intval($uid)
);
- if (dbm::is_result($r)) {
+ if (DBM::is_result($r)) {
/*
* Check to see if we should replace this photo link with an embedded image
* 1. No need to do so if the photo is public
* $expire_network_only = save your own wall posts
* and just expire conversations started by others
*/
- $expire_network_only = get_pconfig($uid,'expire', 'network_only');
+ $expire_network_only = PConfig::get($uid,'expire', 'network_only');
$sql_extra = ((intval($expire_network_only)) ? " AND wall = 0 " : "");
if ($network != "") {
intval($days)
);
- if (! dbm::is_result($r)) {
+ if (! DBM::is_result($r)) {
return;
}
- $expire_items = get_pconfig($uid, 'expire', 'items');
- $expire_items = (($expire_items === false) ? 1 : intval($expire_items)); // default if not set: 1
+ $expire_items = PConfig::get($uid, 'expire', 'items', 1);
// Forcing expiring of items - but not notes and marked items
if ($force) {
$expire_items = true;
}
- $expire_notes = get_pconfig($uid, 'expire', 'notes');
- $expire_notes = (($expire_notes === false) ? 1 : intval($expire_notes)); // default if not set: 1
-
- $expire_starred = get_pconfig($uid, 'expire', 'starred');
- $expire_starred = (($expire_starred === false) ? 1 : intval($expire_starred)); // default if not set: 1
-
- $expire_photos = get_pconfig($uid, 'expire', 'photos');
- $expire_photos = (($expire_photos === false) ? 0 : intval($expire_photos)); // default if not set: 0
+ $expire_notes = PConfig::get($uid, 'expire', 'notes', 1);
+ $expire_starred = PConfig::get($uid, 'expire', 'starred', 1);
+ $expire_photos = PConfig::get($uid, 'expire', 'photos', 0);
logger('User '.$uid.': expire: # items=' . count($r). "; expire items: $expire_items, expire notes: $expire_notes, expire starred: $expire_starred, expire photos: $expire_photos");
drop_item($item['id'], false);
}
- proc_run(array('priority' => PRIORITY_LOW, 'dont_fork' => true), "include/notifier.php", "expire", $uid);
-
+ Worker::add(array('priority' => PRIORITY_LOW, 'dont_fork' => true), "notifier", "expire", $uid);
}
/// @TODO type-hint is array
// multiple threads may have been deleted, send an expire notification
if ($uid) {
- proc_run(array('priority' => PRIORITY_LOW, 'dont_fork' => true), "include/notifier.php", "expire", $uid);
+ Worker::add(array('priority' => PRIORITY_LOW, 'dont_fork' => true), "notifier", "expire", $uid);
}
}
intval($id)
);
- if (! dbm::is_result($r)) {
+ if (! DBM::is_result($r)) {
if (! $interactive) {
return 0;
}
notice( t('Item not found.') . EOL);
- goaway(App::get_baseurl() . '/' . $_SESSION['return_url']);
+ goaway(System::baseUrl() . '/' . $_SESSION['return_url']);
}
$item = $r[0];
}
// Now check how the user responded to the confirmation query
if ($_REQUEST['canceled']) {
- goaway(App::get_baseurl() . '/' . $_SESSION['return_url']);
+ goaway(System::baseUrl() . '/' . $_SESSION['return_url']);
}
logger('delete item: ' . $item['id'], LOGGER_DEBUG);
+
// delete the item
+ $r = dba::update('item', array('deleted' => true, 'title' => '', 'body' => '',
+ 'edited' => datetime_convert(), 'changed' => datetime_convert()),
+ array('id' => $item['id']));
- $r = q("UPDATE `item` SET `deleted` = 1, `title` = '', `body` = '', `edited` = '%s', `changed` = '%s' WHERE `id` = %d",
- dbesc(datetime_convert()),
- dbesc(datetime_convert()),
- intval($item['id'])
- );
create_tags_from_item($item['id']);
create_files_from_item($item['id']);
delete_thread($item['id'], $item['parent-uri']);
// If it's the parent of a comment thread, kill all the kids
if ($item['uri'] == $item['parent-uri']) {
- $r = q("UPDATE `item` SET `deleted` = 1, `edited` = '%s', `changed` = '%s', `body` = '' , `title` = ''
- WHERE `parent-uri` = '%s' AND `uid` = %d ",
- dbesc(datetime_convert()),
- dbesc(datetime_convert()),
- dbesc($item['parent-uri']),
- intval($item['uid'])
- );
+ $r = dba::update('item', array('deleted' => true, 'title' => '', 'body' => '',
+ 'edited' => datetime_convert(), 'changed' => datetime_convert()),
+ array('parent-uri' => $item['parent-uri'], 'uid' => $item['uid']));
+
create_tags_from_itemuri($item['parent-uri'], $item['uid']);
create_files_from_itemuri($item['parent-uri'], $item['uid']);
delete_thread_uri($item['parent-uri'], $item['uid']);
// ignore the result
} else {
// ensure that last-child is set in case the comment that had it just got wiped.
- q("UPDATE `item` SET `last-child` = 0, `changed` = '%s' WHERE `parent-uri` = '%s' AND `uid` = %d ",
- dbesc(datetime_convert()),
- dbesc($item['parent-uri']),
- intval($item['uid'])
- );
+ dba::update('item', array('last-child' => false, 'changed' => datetime_convert()),
+ array('parent-uri' => $item['parent-uri'], 'uid' => $item['uid']));
+
// who is the last child now?
$r = q("SELECT `id` FROM `item` WHERE `parent-uri` = '%s' AND `type` != 'activity' AND `deleted` = 0 AND `uid` = %d ORDER BY `edited` DESC LIMIT 1",
dbesc($item['parent-uri']),
intval($item['uid'])
);
- if (dbm::is_result($r)) {
- q("UPDATE `item` SET `last-child` = 1 WHERE `id` = %d",
- intval($r[0]['id'])
- );
+ if (DBM::is_result($r)) {
+ dba::update('item', array('last-child' => true), array('id' => $r[0]['id']));
}
}
$drop_id = intval($item['id']);
$priority = ($interactive ? PRIORITY_HIGH : PRIORITY_LOW);
- proc_run(array('priority' => $priority, 'dont_fork' => true), "include/notifier.php", "drop", $drop_id);
+ Worker::add(array('priority' => $priority, 'dont_fork' => true), "notifier", "drop", $drop_id);
if (! $interactive) {
return $owner;
}
- goaway(App::get_baseurl() . '/' . $_SESSION['return_url']);
+ goaway(System::baseUrl() . '/' . $_SESSION['return_url']);
//NOTREACHED
} else {
if (! $interactive) {
return 0;
}
notice( t('Permission denied.') . EOL);
- goaway(App::get_baseurl() . '/' . $_SESSION['return_url']);
+ goaway(System::baseUrl() . '/' . $_SESSION['return_url']);
//NOTREACHED
}
}
-
+/// @todo: This query seems to be really slow
function first_post_date($uid, $wall = false) {
$r = q("SELECT `id`, `created` FROM `item`
WHERE `uid` = %d AND `wall` = %d AND `deleted` = 0 AND `visible` = 1 AND `moderated` = 0
intval($uid),
intval($wall ? 1 : 0)
);
- if (dbm::is_result($r)) {
+ if (DBM::is_result($r)) {
// logger('first_post_date: ' . $r[0]['id'] . ' ' . $r[0]['created'], LOGGER_DATA);
return substr(datetime_convert('',date_default_timezone_get(), $r[0]['created']),0,10);
}
// For former Facebook folks that left because of "timeline"
/*
* @TODO old-lost code?
- if ($wall && intval(get_pconfig($uid, 'system', 'no_wall_archive_widget')))
+ if ($wall && intval(PConfig::get($uid, 'system', 'no_wall_archive_widget')))
return $o;
*/
- $visible_years = get_pconfig($uid,'system','archive_visible_years');
+ $visible_years = PConfig::get($uid,'system','archive_visible_years');
if (! $visible_years) {
$visible_years = 5;
}
$ret = list_post_dates($uid, $wall);
- if (! dbm::is_result($ret)) {
+ if (! DBM::is_result($ret)) {
return $o;
}