Title: Admin export/view all predictions
Last modified: June 8, 2021

---

# Admin export/view all predictions

 *  Resolved [ppflgoalsgalore](https://wordpress.org/support/users/ppflgoalsgalore/)
 * (@ppflgoalsgalore)
 * [4 years, 11 months ago](https://wordpress.org/support/topic/admin-export-view-all-predictions/)
 * Hi,
    As admin can i view all predictions entered whilst keeping the settings 
   set to private to users until match prediction cannot be changed? I get people
   asking if their predictions have been saved and also id like to be able to chase/
   remind specific users if they haven’t made predictions.

Viewing 14 replies - 1 through 14 (of 14 total)

 *  Plugin Author [AntoineH](https://wordpress.org/support/users/antoineh/)
 * (@antoineh)
 * [4 years, 11 months ago](https://wordpress.org/support/topic/admin-export-view-all-predictions/#post-14532216)
 * I have 2 extensions. One will show the [matches without the actual predictions](https://www.dropbox.com/s/cnln3gd2mlh8mfx/football-pool-predictions.php?dl=0)
   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](https://www.dropbox.com/s/g5o4prymfuxqat4/football-pool-admin-predictions-count.php?dl=0).
 *  Thread Starter [ppflgoalsgalore](https://wordpress.org/support/users/ppflgoalsgalore/)
 * (@ppflgoalsgalore)
 * [4 years, 11 months ago](https://wordpress.org/support/topic/admin-export-view-all-predictions/#post-14532263)
 * thank you very much – i will give it a go
 *  Thread Starter [ppflgoalsgalore](https://wordpress.org/support/users/ppflgoalsgalore/)
 * (@ppflgoalsgalore)
 * [4 years, 11 months ago](https://wordpress.org/support/topic/admin-export-view-all-predictions/#post-14532272)
 * could you advise how i would run this extension please?
 *  Plugin Author [AntoineH](https://wordpress.org/support/users/antoineh/)
 * (@antoineh)
 * [4 years, 11 months ago](https://wordpress.org/support/topic/admin-export-view-all-predictions/#post-14532308)
 * Extensions are simple plugins. So, upload the file to your /plugins folder and
   then activate it via the admin.
 *  Thread Starter [ppflgoalsgalore](https://wordpress.org/support/users/ppflgoalsgalore/)
 * (@ppflgoalsgalore)
 * [4 years, 11 months ago](https://wordpress.org/support/topic/admin-export-view-all-predictions/#post-14532314)
 * wonderful, thank you so much
 *  [RM](https://wordpress.org/support/users/robinmak/)
 * (@robinmak)
 * [4 years, 11 months ago](https://wordpress.org/support/topic/admin-export-view-all-predictions/#post-14534754)
 * 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?
 *  Plugin Author [AntoineH](https://wordpress.org/support/users/antoineh/)
 * (@antoineh)
 * [4 years, 11 months ago](https://wordpress.org/support/topic/admin-export-view-all-predictions/#post-14535490)
 * > 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`
 *  [fanman1948](https://wordpress.org/support/users/fanman1948/)
 * (@fanman1948)
 * [4 years, 11 months ago](https://wordpress.org/support/topic/admin-export-view-all-predictions/#post-14535932)
 * 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
 *  [RM](https://wordpress.org/support/users/robinmak/)
 * (@robinmak)
 * [4 years, 11 months ago](https://wordpress.org/support/topic/admin-export-view-all-predictions/#post-14535957)
 * Hi Antoine.
 * Thanks. I sent you an email too. But now I’ll get it.
    GrtZ Robin
 *  Plugin Author [AntoineH](https://wordpress.org/support/users/antoineh/)
 * (@antoineh)
 * [4 years, 11 months ago](https://wordpress.org/support/topic/admin-export-view-all-predictions/#post-14535982)
 * > 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;`
 *  [fanman1948](https://wordpress.org/support/users/fanman1948/)
 * (@fanman1948)
 * [4 years, 11 months ago](https://wordpress.org/support/topic/admin-export-view-all-predictions/#post-14536001)
 * > Change line 33 to:
   >  $options[$user->user_login] = $user->display_name;
 * That’s what I thought but hadn’t tried before. Thanks!
 *  Thread Starter [ppflgoalsgalore](https://wordpress.org/support/users/ppflgoalsgalore/)
 * (@ppflgoalsgalore)
 * [4 years, 11 months ago](https://wordpress.org/support/topic/admin-export-view-all-predictions/#post-14537141)
 * 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)?
 *  Plugin Author [AntoineH](https://wordpress.org/support/users/antoineh/)
 * (@antoineh)
 * [4 years, 11 months ago](https://wordpress.org/support/topic/admin-export-view-all-predictions/#post-14538038)
 * There wasn’t one, but easy to create based on the predictions count example. 
   See [here](https://www.dropbox.com/s/13gkqcuk8k8369r/football-pool-admin-bonus-questions-answered-count.php?dl=0).
 *  Thread Starter [ppflgoalsgalore](https://wordpress.org/support/users/ppflgoalsgalore/)
 * (@ppflgoalsgalore)
 * [4 years, 11 months ago](https://wordpress.org/support/topic/admin-export-view-all-predictions/#post-14544326)
 * awesome – top man!

Viewing 14 replies - 1 through 14 (of 14 total)

The topic ‘Admin export/view all predictions’ is closed to new replies.

 * ![](https://ps.w.org/football-pool/assets/icon-256x256.png?rev=983880)
 * [Football Pool](https://wordpress.org/plugins/football-pool/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/football-pool/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/football-pool/)
 * [Active Topics](https://wordpress.org/support/plugin/football-pool/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/football-pool/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/football-pool/reviews/)

 * 14 replies
 * 4 participants
 * Last reply from: [ppflgoalsgalore](https://wordpress.org/support/users/ppflgoalsgalore/)
 * Last activity: [4 years, 11 months ago](https://wordpress.org/support/topic/admin-export-view-all-predictions/#post-14544326)
 * Status: resolved