aboutsummaryrefslogtreecommitdiffstats
path: root/Zotlabs/Module
diff options
context:
space:
mode:
authorMario Vavti <mario@mariovavti.com>2018-06-01 23:22:52 +0200
committerMario Vavti <mario@mariovavti.com>2018-06-01 23:22:52 +0200
commit53efd4e470f10e123209ed63b90213b20a87e011 (patch)
tree6a65af68db1553329313b293af51ddb7d72e14b3 /Zotlabs/Module
parent22a9e4c9a9e4a48f644deed0432dc05a7e5b189c (diff)
downloadvolse-hubzilla-53efd4e470f10e123209ed63b90213b20a87e011.tar.gz
volse-hubzilla-53efd4e470f10e123209ed63b90213b20a87e011.tar.bz2
volse-hubzilla-53efd4e470f10e123209ed63b90213b20a87e011.zip
unread forum notifications - wip/unfinished
Diffstat (limited to 'Zotlabs/Module')
-rw-r--r--Zotlabs/Module/Ping.php61
1 files changed, 61 insertions, 0 deletions
diff --git a/Zotlabs/Module/Ping.php b/Zotlabs/Module/Ping.php
index bb80adc41..a43d9863e 100644
--- a/Zotlabs/Module/Ping.php
+++ b/Zotlabs/Module/Ping.php
@@ -39,6 +39,7 @@ class Ping extends \Zotlabs\Web\Controller {
$result['info'] = array();
$result['pubs'] = 0;
$result['files'] = 0;
+ $result['forums'] = 0;
if(! $_SESSION['static_loadtime'])
$_SESSION['static_loadtime'] = datetime_convert();
@@ -622,6 +623,66 @@ class Ping extends \Zotlabs\Web\Controller {
if(! ($vnotify & VNOTIFY_BIRTHDAY))
$result['birthdays'] = 0;
+
+
+#### unseen forum
+
+ $perms_sql = item_permissions_sql(local_channel()) . item_normal();
+
+ $xf = false;
+
+ $x1 = q("select xchan from abconfig where chan = %d and cat = 'their_perms' and k = 'send_stream' and v = '0'",
+ intval(local_channel())
+ );
+ if($x1) {
+ $xc = ids_to_querystr($x1,'xchan',true);
+
+ $x2 = q("select xchan from abconfig where chan = %d and cat = 'their_perms' and k = 'tag_deliver' and v = '1' and xchan in (" . $xc . ") ",
+ intval(local_channel())
+ );
+
+ if($x2) {
+ $xf = ids_to_querystr($x2,'xchan',true);
+
+ // private forums
+ $x3 = q("select xchan from abconfig where chan = %d and cat = 'their_perms' and k = 'post_wall' and v = '1' and xchan in (" . $xc . ") and not xchan in (" . $xf . ") ",
+ intval(local_channel())
+ );
+ if($x3) {
+ $xf = ids_to_querystr(array_merge($x2,$x3),'xchan',true);
+ }
+ }
+ }
+
+ $sql_extra = (($xf) ? " and ( xchan_hash in (" . $xf . ") or xchan_pubforum = 1 ) " : " and xchan_pubforum = 1 ");
+
+ $r1 = q("select abook_id, xchan_hash, xchan_name, xchan_url, xchan_photo_s from abook left join xchan on abook_xchan = xchan_hash where xchan_deleted = 0 and abook_channel = %d and abook_pending = 0 and abook_ignored = 0 and abook_blocked = 0 $sql_extra order by xchan_name",
+ intval(local_channel())
+ );
+
+ if(! $r1) {
+ $result['forums'] = 0;
+ }
+ else {
+ $fcount = count($r1);
+ $r1['total'] = 0;
+ for($x = 0; $x < $fcount; $x ++) {
+ $r = q("select sum(item_unseen) as unseen from item
+ where uid = %d and owner_xchan = '%s' and item_unseen = 1 $perms_sql ",
+ intval(local_channel()),
+ dbesc($r1[$x]['xchan_hash'])
+ );
+ if($r[0]['unseen']) {
+ $r1[$x]['unseen'] = $r[0]['unseen'];
+ $r1['total'] = $r1['total'] + $r[0]['unseen'];
+ }
+ else {
+ unset($r1[$x]);
+ }
+ }
+ $result['forums'] = $r1['total'];
+ }
+
$x = json_encode($result);
$t8 = dba_timer();