NCAA Football Teams SQL and Helmets

[Sheldon]

Hopefully you all can use these.

It will list all FBS (Football Bowl Subdivision) Schools. Here is a preview of the helmet style used for each:


Once entered you will have this look on your Pick'Em Page:

​

Copy the contents of the NCAA_Helmet folder into the /styles/default/nflj/pickem/logos folder. The team_id starts at 33, you may have to change it. Maybe Bob can help out a little better.

Import the SQL.

If you have any questions, feel free to ask.

 

[Solari]

Awesome! How would I find out the proper team_id to start at, and is this SQL still valid since it was over a year ago? Thanks.

Ray

 

[Solari]

Any word on this?

 

[Bob]

The team id will be in the URL. Go to the team management page for the sport you are working on. Hover over a team name and you will see at the end of the URL is the teamname.number. That number is the Team ID. In the example URL below, the Falcons Team ID is 24

http://localhost/XF-Dev/admin.php?pickem/team/falcons.24/edit