Support Forum

Sadly - there is no built in way to do this. This may or may not be considered an oversight but you are the first to ever ask for this.

However - we can use a WordPress style filter to accomplish it. Currently the code does not have a filter hook but I can tell you how to add it and we would add it too so that on the next update it will be a part of the core.

If this interests you it will mean making 1 small edit to a code file and creating one new code file with some code I can give you. Very easy. Do you want to do this?

Excellent. A simple rule if you do not know it. All edits must be made in plain text - using tools like Notepad (Win) or TextEdit (macOS). To edit existing files on your server, your hosting control panel will usually come with a simple editor.

1: Editing existing code file:

The file is /wp-content/plugins/simple-press/forum/database/sp-db-statistics.php

About two thirds down - on line 272 you will find the function sp_get_top_poster_stats()

Immediately before the line of code...

$topPosters = $spdb->select();

add the following - so the last 3 lines looks like:

$spdb = apply_filters('sph_top_poster_stats_query', $spdb);
$topPosters = $spdb->select();
return $topPosters;

Use the 'raw code' button on the code and copy from the popup.

2: Add new code file:

Create a new code file with the code below. The file needs to be named sp-user-functions.php and needs to reside in the 'wp-content' folder. NOT in a plugin folder. Simple:Press will find it in wp-content and will never overwrite it or change it.

This is the code function:

add_filter('sph_top_poster_stats_query', 'add_mods');
function add_mods($query) {
    $query->where = 'hide_stats = 0 AND admin=0 AND posts > -1';
    return $query;
}

Now... this code has to be surrounded by php opening and closing tags which I can't easily show in the code box. So - first line of the file show the opening tag <?php and at the end of the file the closing tag ?> - but remember that there must be no empty lines at the top or bottom. The tags must be on first and last lines. It really is easy!

Finally - remember that the stats are cached and only refresh themselves about once an hour so you will not necessarily see an instant change. If you want to update them then you can do so in the forum admin > toolbox > cron panel and run the sph_stats_cron task in the run box provided.

And we will add that filter to the code in the next update.

File permissions would more normally be 664. 775 is usual for folders.

The only change we will make to the core for the next update - actually already made and committed - is that filter hook in the stats php file. So as long as you used the same name for the filter as I gave you then it will continue to work for you after you update in the future,

And for everyone else - it will remain the same as now as they will not have the code that actually changes the query -which is what that function does you put into the new code file.

Hope that makes sense 🙂

yes - as was promised