Your username here MUST MATCH your XenForo username (connected to your XF license).

    Once you have registered here, then you need to start a conversation at xenforo.com w/Bob and provide the following:
    1. Your XenForo License Validation Token
    2. The Domain Name associated with the License
    NOTE: Your account will be validated once ALL requirements are verified/met. Thank you for your patience.

NCAA Football Teams SQL and Helmets

Discussion in 'Pickem Support' started by Sheldon, Aug 22, 2012.

  1. Sheldon

    Sheldon Active Member Pickem Sportsbook Survivor

    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:
    Colorado.png Florida.png FSU.png NC_State.png Texas_Tech.png UNC.png USC.png

    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.

    Attached Files:

    wickedstangs likes this.
  2. Solari

    Solari Member AMS Premium RMS Premium SC Premium Pickem Sportsbook

    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.

  3. Solari

    Solari Member AMS Premium RMS Premium SC Premium Pickem Sportsbook

    Any word on this?
  4. Bob

    Bob Developer Staff Member

    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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.