bbPress

Simple, fast, elegant

bbPress Plugin Browser »

User Roles Table for bbPress (1.3)

Download

Version: 1.3

Other Versions

Last Updated: 2009-6-25

Requires bbPress Version: 1.0-alpha-5 or higher

Compatible up to: 1.0-rc-3

Author Homepage »

Plugin Homepage »

Average Rating

5 stars
4 stars
3 stars
2 stars
1 star
(1)

Your Rating

Author: Sam Bauers

This plugin creates a user roles table in the database with the specific intention of speeding up read queries based on user role.

Currently to obtain a list of users based on some role, bbPress must do a query against the usermeta table using a LIKE query on an un-indexed column. Queries like this bring any database server to it's knees when there are millions of users.

Primarily, there is a filter added to the admin function bbgetuseridsby_role(). So any plugin using this function will gain an instant speed-up by using this plugin as well.

If another plugin wants to check for the existence of this plugin, then it can detect the BBURTINSTALLED and BBURTACTIVE constants. This detection should be made by hooking into the 'bbpluginsloaded' action and querying for those constants.

This plugin requires modifications made to the bbPress codebase between 1.0-alpha-4 and 1.0-alpha-5, so the first supported release is 1.0-alpha-5.


  1. Ipstenu

    5 stars
    4 stars
    3 stars
    2 stars
    1 star

    Member

    Kills the main dashboard:

    Fatal error: Cannot redeclare get_total_users() (previously declared in /home/ME/public_html/forums/my-plugins/user-roles-table-for-bbpress/user-roles-table-for-bbpress.php:259) in /home/ME/public_html/forums/bb-includes/functions.bb-statistics.php on line 51

    Does not seem to affect any other page.

    bbPress 1.0-alpha6 with WordPress 2.7.1

    Posted: 1 year ago #

  2. Ipstenu

    5 stars
    4 stars
    3 stars
    2 stars
    1 star

    Member

    Okay, this now works (no errors) on trunk alpha (as of ... er ... last week? Something like that).

    Weird things/Thoughts:
    1) When I look at deleted posts, it lists all my users as 'Inactive' but when I check their account, they are indeed Members. (correction - This looks like it happens even with the plugin deactivated)

    2) I know it's supposed to trash the recently registered view from the front page, but shouldn't it replace that with ... something?

    Posted: 11 months ago #

  3. sambauers

    Key Master

    I think the dashboard has limited purpose even with that panel in there. It may even be dropped altogether in later versions. Did you add that bug to trac?

    Posted: 11 months ago #

  4. Junior75

    Member

    When i try to activate the Plugin:

    Fatal error: Cannot access empty property in /home/bbpress/bb-includes/db.php on line 82

    Do i have to edit something?

    Posted: 9 months ago #

RSS feed for this topic

Add a Comment

You must log in to post.

Code is Poetry.