Exclude members who didn’t participate yet

You can try to write an SQL query that selects all users without any predictions. With this data set you can then exclude them from the plugin.

If you are using leagues, then you delete the users from the pool_wp_league_users table. If you are not using leagues, then set the league_id for these users to “0” in the pool_wp_league_users table.

I am using No league mode.
When I go to pool_wp_league_users table, I see only two rows.
I am confused what to do now. Ranking in the front-end works fine though, showing all the members of the site.

If you are using ‘no league’ mode, then you can exclude players from the pool (and the ranking calculation) by adding a record to this league_users table with league 0.

You can do this by clicking each user in the User admin of the plugin. Or automated by inserting records in the database via SQL.

e.g. if user with ID 49 should be excluded, then do this:

INSERT INTO pool_wp_league_users
  ( user_id, league_id ) 
VALUES 
  ( 49, 0 );

And if you manage to write a query that selects all users without at least one prediction, then you can create a script to add records for all these users.

Thanks, I got it.
But, what if a member,currently excluded but want to join the prediction game, at a later date? Is there any auto-join mechanism which will include him in the pool as soon as he/she predicts a game? I think this would be very useful for site with a large number of userbase. If I pre-allow all members,it takes really long time to calculate (2 hours+)

Thank you for your prompt response,by the way.

There is no automated mechanism in the plugin. But it should be relatively easy to write a shortcode for example, that shows a button to join (which you then add to a page or widget).
And if you won’t be able to write this, then maybe a contact form via a plugin to request access?