Re: Sitewide Activity Widget
Your old data should have remained in the wp_bp_activity_user_activity_cached table. If you performed some SQL queries on that table, you may have deleted the old data. Your only option then is to add the data back using another SQL query. You will need to compare the schema of the new table to the old one as several fields have been removed as they were no longer needed.
How long will this widget show a event ?
In WPMU’s backend, there is a setting for the widget that allows you to configure the maximum number of activity items to show. So there is no time limit on how long an event will be shown. If you’ve set the maximum number to 10, then the 10th item will not be displayed anymore as soon as the next, new activity gets recorded.