routes.rb - Controller name not supported

Change: Players to players so:

match '/players/:userid', :to => 'Players#show'

to

match '/players/:userid', :to => 'players#show'

Read more.

To read user id value in your controller, use params[:userid], not just :userid.