diff options
| author | mrjive <mrjive@mrjive.it> | 2018-01-30 16:13:30 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2018-01-30 16:13:30 +0100 |
| commit | 7ac4b477020689572a50dbc777c968263e86f6c4 (patch) | |
| tree | 470336bcbdf0f989d48fb2c3349bd0ac0513da42 /Zotlabs/Module/Ping.php | |
| parent | c2abbe2c238fa4d66e8a088c7d271acaa7e20876 (diff) | |
| parent | d24cf0b85b24cb8d6d10e9fe66fed568f9fb08b2 (diff) | |
| download | volse-hubzilla-7ac4b477020689572a50dbc777c968263e86f6c4.tar.gz volse-hubzilla-7ac4b477020689572a50dbc777c968263e86f6c4.tar.bz2 volse-hubzilla-7ac4b477020689572a50dbc777c968263e86f6c4.zip | |
Merge pull request #13 from redmatrix/dev
Dev
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'", |