From d1cbd756366580962e58bcc8216dd88fe0b5ef2f Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Mon, 19 Jan 2009 21:37:31 -0500 Subject: Change inboxes to have 1000 items rather than last full month --- scripts/inbox_users.php | 4 ++-- 1 file 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__); -- cgit v1.2.3-54-g00ecf