<?php
-require_once("include/datetime.php");
+
+use Friendica\App;
+use Friendica\Core\System;
+use Friendica\Core\PConfig;
+use Friendica\Database\DBM;
+
+require_once('include/datetime.php');
require_once('include/bbcode.php');
require_once('include/ForumManager.php');
require_once('include/group.php');
require_once('mod/proxy.php');
require_once('include/xml.php');
require_once('include/cache.php');
+require_once('include/enotify.php');
/**
* @brief Outputs the counts and the lists of various notifications
$notifs = ping_get_notifications(local_user());
- $items_unseen = qu("SELECT `item`.`id`, `item`.`parent`, `item`.`verb`, `item`.`wall`, `item`.`author-name`,
+ $items_unseen = q("SELECT `item`.`id`, `item`.`parent`, `item`.`verb`, `item`.`wall`, `item`.`author-name`,
`item`.`contact-id`, `item`.`author-link`, `item`.`author-avatar`, `item`.`created`, `item`.`object`,
`pitem`.`author-name` AS `pname`, `pitem`.`author-link` AS `plink`
FROM `item` INNER JOIN `item` AS `pitem` ON `pitem`.`id` = `item`.`parent`
intval(local_user()), intval(local_user())
);
- if (dbm::is_result($items_unseen)) {
+ if (DBM::is_result($items_unseen)) {
$arr = array('items' => $items_unseen);
call_hooks('network_ping', $arr);
if (intval(feature_enabled(local_user(), 'groups'))) {
// Find out how unseen network posts are spread across groups
$group_counts = groups_count_unseen();
- if (dbm::is_result($group_counts)) {
+ if (DBM::is_result($group_counts)) {
foreach ($group_counts as $group_count) {
if ($group_count['count'] > 0) {
$groups_unseen[] = $group_count;
if (intval(feature_enabled(local_user(), 'forumlist_widget'))) {
$forum_counts = ForumManager::count_unseen_items();
- if (dbm::is_result($forums_counts)) {
+ if (DBM::is_result($forums_counts)) {
foreach ($forums_counts as $forum_count) {
if ($forum_count['count'] > 0) {
$forums_unseen[] = $forum_count;
}
}
- $intros1 = qu("SELECT `intro`.`id`, `intro`.`datetime`,
+ $intros1 = q("SELECT `intro`.`id`, `intro`.`datetime`,
`fcontact`.`name`, `fcontact`.`url`, `fcontact`.`photo`
FROM `intro` LEFT JOIN `fcontact` ON `intro`.`fid` = `fcontact`.`id`
WHERE `intro`.`uid` = %d AND `intro`.`blocked` = 0 AND `intro`.`ignore` = 0 AND `intro`.`fid` != 0",
intval(local_user())
);
- $intros2 = qu("SELECT `intro`.`id`, `intro`.`datetime`,
+ $intros2 = q("SELECT `intro`.`id`, `intro`.`datetime`,
`contact`.`name`, `contact`.`url`, `contact`.`photo`
FROM `intro` LEFT JOIN `contact` ON `intro`.`contact-id` = `contact`.`id`
WHERE `intro`.`uid` = %d AND `intro`.`blocked` = 0 AND `intro`.`ignore` = 0 AND `intro`.`contact-id` != 0",
$intro_count = count($intros1) + count($intros2);
$intros = $intros1 + $intros2;
- $myurl = App::get_baseurl() . '/profile/' . $a->user['nickname'] ;
- $mails = qu("SELECT `id`, `from-name`, `from-url`, `from-photo`, `created` FROM `mail`
+ $myurl = System::baseUrl() . '/profile/' . $a->user['nickname'] ;
+ $mails = q("SELECT `id`, `from-name`, `from-url`, `from-photo`, `created` FROM `mail`
WHERE `uid` = %d AND `seen` = 0 AND `from-url` != '%s' ",
intval(local_user()),
dbesc($myurl)
$mail_count = count($mails);
if ($a->config['register_policy'] == REGISTER_APPROVE && is_site_admin()){
- $regs = qu("SELECT `contact`.`name`, `contact`.`url`, `contact`.`micro`, `register`.`created`, COUNT(*) AS `total`
+ $regs = q("SELECT `contact`.`name`, `contact`.`url`, `contact`.`micro`, `register`.`created`, COUNT(*) AS `total`
FROM `contact` RIGHT JOIN `register` ON `register`.`uid` = `contact`.`uid`
WHERE `contact`.`self` = 1");
- if (dbm::is_result($regs)) {
+ if (DBM::is_result($regs)) {
$register_count = $regs[0]['total'];
}
}
$cachekey = "ping_init:".local_user();
$ev = Cache::get($cachekey);
if (is_null($ev)) {
- $ev = qu("SELECT count(`event`.`id`) AS total, type, start, adjust FROM `event`
+ $ev = q("SELECT type, start, adjust FROM `event`
WHERE `event`.`uid` = %d AND `start` < '%s' AND `finish` > '%s' and `ignore` = 0
ORDER BY `start` ASC ",
intval(local_user()),
dbesc(datetime_convert('UTC', 'UTC', 'now + 7 days')),
dbesc(datetime_convert('UTC', 'UTC', 'now'))
);
- if (dbm::is_result($ev)) {
+ if (DBM::is_result($ev)) {
Cache::set($cachekey, $ev, CACHE_HOUR);
}
}
- if (dbm::is_result($ev)) {
- $all_events = intval($ev[0]['total']);
+ if (DBM::is_result($ev)) {
+ $all_events = count($ev);
if ($all_events) {
$str_now = datetime_convert('UTC', $a->timezone, 'now', 'Y-m-d');
$data['birthdays'] = $birthdays;
$data['birthdays-today'] = $birthdays_today;
- if (dbm::is_result($notifs)) {
+ if (DBM::is_result($notifs)) {
foreach ($notifs as $notif) {
if ($notif['seen'] == 0) {
$sysnotify_count ++;
}
// merge all notification types in one array
- if (dbm::is_result($intros)) {
+ if (DBM::is_result($intros)) {
foreach ($intros as $intro) {
$notif = array(
- 'href' => App::get_baseurl() . '/notifications/intros/' . $intro['id'],
+ 'href' => System::baseUrl() . '/notifications/intros/' . $intro['id'],
'name' => $intro['name'],
'url' => $intro['url'],
'photo' => $intro['photo'],
}
}
- if (dbm::is_result($mails)) {
+ if (DBM::is_result($mails)) {
foreach ($mails as $mail) {
$notif = array(
- 'href' => App::get_baseurl() . '/message/' . $mail['id'],
+ 'href' => System::baseUrl() . '/message/' . $mail['id'],
'name' => $mail['from-name'],
'url' => $mail['from-url'],
'photo' => $mail['from-photo'],
}
}
- if (dbm::is_result($regs)) {
+ if (DBM::is_result($regs)) {
foreach ($regs as $reg) {
$notif = array(
- 'href' => App::get_baseurl() . '/admin/users/',
+ 'href' => System::baseUrl() . '/admin/users/',
'name' => $reg['name'],
'url' => $reg['url'],
'photo' => $reg['micro'],
// sort notifications by $[]['date']
$sort_function = function($a, $b) {
- $adate = date($a['date']);
- $bdate = date($b['date']);
+ $adate = strtotime($a['date']);
+ $bdate = strtotime($b['date']);
+
+ // Unseen messages are kept at the top
+ // The value 31536000 means one year. This should be enough :-)
+ if (!$a['seen']) {
+ $adate += 31536000;
+ }
+ if (!$b['seen']) {
+ $bdate += 31536000;
+ }
+
if ($adate == $bdate) {
return 0;
}
};
usort($notifs, $sort_function);
- if (dbm::is_result($notifs)) {
+ if (DBM::is_result($notifs)) {
// Are the nofications called from the regular process or via the friendica app?
- $regularnotifications = (intval($_GET['uid']) AND intval($_GET['_']));
+ $regularnotifications = (intval($_GET['uid']) && intval($_GET['_']));
foreach ($notifs as $notif) {
- if ($a->is_friendica_app() OR !$regularnotifications) {
+ if ($a->is_friendica_app() || !$regularnotifications) {
$notif['message'] = str_replace("{0}", $notif['name'], $notif['message']);
}
$a = get_app();
do {
- $r = qu("SELECT `notify`.*, `item`.`visible`, `item`.`spam`, `item`.`deleted`
+ $r = q("SELECT `notify`.*, `item`.`visible`, `item`.`spam`, `item`.`deleted`
FROM `notify` LEFT JOIN `item` ON `item`.`id` = `notify`.`iid`
WHERE `notify`.`uid` = %d AND `notify`.`msg` != ''
AND NOT (`notify`.`type` IN (%d, %d))
intval($offset)
);
- if (!$r AND !$seen) {
+ if (!$r && !$seen) {
$seen = true;
$seensql = "";
$order = "DESC";
);
}
- $notification["href"] = App::get_baseurl() . "/notify/view/" . $notification["id"];
+ $notification["href"] = System::baseUrl() . "/notify/view/" . $notification["id"];
- if ($notification["visible"] AND !$notification["spam"] AND
- !$notification["deleted"] AND !is_array($result[$notification["parent"]])) {
- $result[$notification["parent"]] = $notification;
+ if ($notification["visible"] && !$notification["spam"] &&
+ !$notification["deleted"] && !is_array($result[$notification["parent"]])) {
+ // Should we condense the notifications or show them all?
+ if (PConfig::get(local_user(), 'system', 'detailed_notif')) {
+ $result[$notification["id"]] = $notification;
+ } else {
+ $result[$notification["parent"]] = $notification;
+ }
}
}
- } while ((count($result) < 50) AND !$quit);
+ } while ((count($result) < 50) && !$quit);
return($result);
}
projects / friendica.git / blobdiff