From 250d947667b1500633d80b043ac3760be21446fc Mon Sep 17 00:00:00 2001 From: zotlabs Date: Sun, 19 Nov 2017 21:51:21 -0800 Subject: cloud tiles: use folder-o for folders and set the icon colour to something a bit less harsh than the link colour for system icons. Dark solid blue folders are a bit overwhelming, as is the default text_colour (black) --- Zotlabs/Module/Ping.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'Zotlabs/Module') diff --git a/Zotlabs/Module/Ping.php b/Zotlabs/Module/Ping.php index 8644b8326..406e554d1 100644 --- a/Zotlabs/Module/Ping.php +++ b/Zotlabs/Module/Ping.php @@ -492,10 +492,11 @@ class Ping extends \Zotlabs\Web\Controller { $t3 = dba_timer(); if($vnotify & (VNOTIFY_NETWORK|VNOTIFY_CHANNEL)) { + $r = q("SELECT id, item_wall FROM item WHERE item_unseen = 1 and uid = %d $item_normal - AND author_xchan != '%s'", + AND author_xchan != '%s' $sql_extra ", intval(local_channel()), dbesc($ob_hash) ); -- cgit v1.2.3 From 624196711242cb5bf398ff2d368e73a10e65b67e Mon Sep 17 00:00:00 2001 From: Mario Vavti Date: Mon, 20 Nov 2017 09:57:07 +0100 Subject: speed up initial query if no mid is provided --- Zotlabs/Module/Hq.php | 1 + 1 file changed, 1 insertion(+) (limited to 'Zotlabs/Module') diff --git a/Zotlabs/Module/Hq.php b/Zotlabs/Module/Hq.php index 41e9d40ca..ad39768f4 100644 --- a/Zotlabs/Module/Hq.php +++ b/Zotlabs/Module/Hq.php @@ -46,6 +46,7 @@ class Hq extends \Zotlabs\Web\Controller { $r = q("SELECT mid FROM item WHERE uid = %d + AND item_unseen = 1 AND mid = parent_mid $item_normal ORDER BY id DESC -- cgit v1.2.3 From 66c0ac591cd342a31348ad54723fd269659251c6 Mon Sep 17 00:00:00 2001 From: Mario Vavti Date: Mon, 20 Nov 2017 10:00:13 +0100 Subject: order by created instead of id --- Zotlabs/Module/Hq.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'Zotlabs/Module') diff --git a/Zotlabs/Module/Hq.php b/Zotlabs/Module/Hq.php index ad39768f4..e2efc6a0d 100644 --- a/Zotlabs/Module/Hq.php +++ b/Zotlabs/Module/Hq.php @@ -49,7 +49,7 @@ class Hq extends \Zotlabs\Web\Controller { AND item_unseen = 1 AND mid = parent_mid $item_normal - ORDER BY id DESC + ORDER BY created DESC limit 1", local_channel() ); -- cgit v1.2.3 From 9ab33f1e134e6e7694a42b92fc9d73c2e6dcffd1 Mon Sep 17 00:00:00 2001 From: Mario Vavti Date: Mon, 20 Nov 2017 11:05:08 +0100 Subject: we need a mid also if there is no unseen items --- Zotlabs/Module/Hq.php | 1 - 1 file changed, 1 deletion(-) (limited to 'Zotlabs/Module') diff --git a/Zotlabs/Module/Hq.php b/Zotlabs/Module/Hq.php index e2efc6a0d..92dfc8587 100644 --- a/Zotlabs/Module/Hq.php +++ b/Zotlabs/Module/Hq.php @@ -46,7 +46,6 @@ class Hq extends \Zotlabs\Web\Controller { $r = q("SELECT mid FROM item WHERE uid = %d - AND item_unseen = 1 AND mid = parent_mid $item_normal ORDER BY created DESC -- cgit v1.2.3