[MoT3rror]

You can have a column in like your user table called confidence_points. This column will hold the points they have gain total. When a user goes to assign a confidence value, the game id(if are you wanting to use it or you can use a different way to tell games part) and the value is stored in a new table. When the game is finished/reported into system, the system will then find all the users that guess correct and add the points to the column confidence_points.

Then a query like this can determine who has the most points.
[SQL]
SELECT * FROM users ORDER BY confidence_points + 0 DESC LIMIT 30
[/SQL]

There is still a lot to fill in the system but that should get you the basic ranking system.

Sorry I never played ESPN Bowl Pick 'Em but this my understanding of their system after a quick look through.