[buddypress-trac] [BuddyPress Trac] #6943: Email inactive users to bring them back to the site (was: Last login in user table)

[buddypress-trac]

#6943: Email inactive users to bring them back to the site
---------------------------------+-----------------------------
 Reporter:  alexh_               |       Owner:
     Type:  idea                 |      Status:  new
 Priority:  normal               |   Milestone:  Future Release
Component:  Component - Members  |     Version:
 Severity:  normal               |  Resolution:
 Keywords:                       |
---------------------------------+-----------------------------
Changes (by r-a-y):

 * milestone:  Awaiting Review => Future Release


Comment:

 > There should be a column in the user table which shows when the users
 were last logged in.

 We do log the last activity of when a user last visited any WordPress page
 in the BuddyPress activity (`wp_bp_activity`) table.  Do a query for
 `SELECT user_id,date_recorded FROM wp_bp_activity WHERE component =
 'members' AND type = 'last_activity'`.

 Hope that works for your needs.  Otherwise, you will need to either write
 a plugin for this or use an existing plugin that is available in the
 wp.org plugins repository.

 > Best case would be to mail all people manually or automatically who were
 not logged in the last xx days.

 At the moment, this functionality should be left to a plugin.  However,
 maybe we could consider this in a future release.  I've renamed this
 ticket to reflect this.

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/6943#comment:2>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac