diff options
author | Evan Prodromou <evan@zhora.(none)> | 2009-01-19 21:37:31 -0500 |
---|---|---|
committer | Evan Prodromou <evan@zhora.(none)> | 2009-01-19 21:37:31 -0500 |
commit | d1cbd756366580962e58bcc8216dd88fe0b5ef2f (patch) | |
tree | 9c3e39fc0ffc80c9014e5ea04a32ed76149f5f7e | |
parent | 235d458395248a04bc9e0ce94cef1c92beff9471 (diff) |
Change inboxes to have 1000 items rather than last full month
-rwxr-xr-x | scripts/inbox_users.php | 4 |
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__); |