summaryrefslogtreecommitdiff
path: root/scripts/inbox_users.php
diff options
context:
space:
mode:
authorEvan Prodromou <evan@zhora.(none)>2009-01-19 21:37:31 -0500
committerEvan Prodromou <evan@zhora.(none)>2009-01-19 21:37:31 -0500
commitd1cbd756366580962e58bcc8216dd88fe0b5ef2f (patch)
tree9c3e39fc0ffc80c9014e5ea04a32ed76149f5f7e /scripts/inbox_users.php
parent235d458395248a04bc9e0ce94cef1c92beff9471 (diff)
Change inboxes to have 1000 items rather than last full month
Diffstat (limited to 'scripts/inbox_users.php')
-rwxr-xr-xscripts/inbox_users.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/scripts/inbox_users.php b/scripts/inbox_users.php
index 0543abb2a..7b029e142 100755
--- a/scripts/inbox_users.php
+++ b/scripts/inbox_users.php
@@ -78,11 +78,11 @@ foreach ($ids as $id) {
'FROM subscription JOIN notice ON subscription.subscribed = notice.profile_id ' .
'WHERE subscription.subscriber = ' . $user->id . ' ' .
'AND notice.created >= subscription.created ' .
- 'AND now() - notice.created < ' . (7 * 24 * 3600) . ' ' .
'AND NOT EXISTS (SELECT user_id, notice_id ' .
'FROM notice_inbox ' .
'WHERE user_id = ' . $user->id . ' ' .
- 'AND notice_id = notice.id)');
+ 'AND notice_id = notice.id) ' .
+ 'LIMIT 0, 1000');
if (is_null($result) || $result === false) {
common_log_db_error($inbox, 'INSERT', __FILE__);