Admin export/view all predictions

I have 2 extensions. One will show the matches without the actual predictions for a user, but it can be adjusted to also show the prediction if you change the SQL query. And one that shows the count per user.

thank you very much – i will give it a go

could you advise how i would run this extension please?

Extensions are simple plugins. So, upload the file to your /plugins folder and then activate it via the admin.

wonderful, thank you so much

Antoine wrote:

I have 2 extensions. One will show the matches without the actual predictions for a user, but it can be adjusted to also show the prediction if you change the SQL query. And one that shows the count per user.

Change the SQL Query…
Can you help me further?
What do I have to change exactly?

What do I have to change exactly?

You have to query the columns that hold the scores from the predictions table. Add the following to the end of line 45:

, p.home_score, p.away_score

Hi Antoine!
How to change to choose the name displayed on the website instead of the login user?

e.g.
login – jd
display name – john doe

Hi Antoine.

Thanks. I sent you an email too. But now I’ll get it.
GrtZ
Robin

How to change to choose the name displayed on the website instead of the login user?

Change line 33 to:
$options[$user->user_login] = $user->display_name;

Change line 33 to:
$options[$user->user_login] = $user->display_name;

That’s what I thought but hadn’t tried before. Thanks!

Hi Antoine – Is there an extension that performs a count on bonus questions answered by user (in a similar way to the extension previously shared where it shows a log of predictions)?

There wasn’t one, but easy to create based on the predictions count example. See here.

awesome – top man!