diff options
| author | zotlabs <mike@macgirvin.com> | 2018-01-28 21:43:50 -0800 |
|---|---|---|
| committer | zotlabs <mike@macgirvin.com> | 2018-01-28 21:43:50 -0800 |
| commit | c1e44c0f54e2dc9a340f0d619fa8082ec12947c1 (patch) | |
| tree | 3bb0deca1c350445bcc8935afa2536bd842007e7 /Zotlabs/Module/Ping.php | |
| parent | 5cf2bf6b29fde04ddc791af8ce21731818bedb7a (diff) | |
| parent | edf6ad9eda323f6e04823b8c110d21d82d519d32 (diff) | |
| download | volse-hubzilla-c1e44c0f54e2dc9a340f0d619fa8082ec12947c1.tar.gz volse-hubzilla-c1e44c0f54e2dc9a340f0d619fa8082ec12947c1.tar.bz2 volse-hubzilla-c1e44c0f54e2dc9a340f0d619fa8082ec12947c1.zip | |
Merge branch 'dev' of https://github.com/redmatrix/hubzilla into xdev_merge
Diffstat (limited to 'Zotlabs/Module/Ping.php')
| -rw-r--r-- | Zotlabs/Module/Ping.php | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/Zotlabs/Module/Ping.php b/Zotlabs/Module/Ping.php index a3f6cdfec..f8399d871 100644 --- a/Zotlabs/Module/Ping.php +++ b/Zotlabs/Module/Ping.php @@ -320,7 +320,9 @@ class Ping extends \Zotlabs\Web\Controller { if(argc() > 1 && (argv(1) === 'network' || argv(1) === 'home')) { $result = array(); - $r = q("SELECT * FROM item + $use_index = db_use_index('uid_item_unseen'); + + $r = q("SELECT * FROM item $use_index WHERE item_unseen = 1 and uid = %d $item_normal AND author_xchan != '%s' ORDER BY created DESC limit 300", @@ -492,8 +494,10 @@ class Ping extends \Zotlabs\Web\Controller { $t3 = dba_timer(); if($vnotify & (VNOTIFY_NETWORK|VNOTIFY_CHANNEL)) { + + $use_index = db_use_index('uid_item_unseen'); - $r = q("SELECT id, item_wall FROM item + $r = q("SELECT id, item_wall FROM item $use_index WHERE item_unseen = 1 and uid = %d $item_normal AND author_xchan != '%s'", |