Re: The FIRST Alliance - A whole new way to play
 

I don't know if it's too early to offer suggestions, and I know that this is reminiscent of The Blue Alliance, but if it was possible to go back and forth from a team's page to the data for the events they participated in and vice-versa, that would be nice. It would make moving around the website easier if I didn't have to go back to the front page every time I wanted to switch from looking at teams to looking through events.

Re: The FIRST Alliance - A whole new way to play
 

Great job on creating another resource for FIRSTers!

One thing on your stats for Spokane...our third match (which was a win) was a surrogate and therefore needs to be removed from our win column (currently shows as 10-1-1 with 11 matches played).

Overall a great start on what I am sure will prove a valuable resource...

Re: The FIRST Alliance - A whole new way to play
 

Just as a quick update, we already surpassed over 10,000 individual API requests since the launch a mere 20 hours ago. I thank all of you who support us and we will be bringing more and more content and fixes to the site over the next few weeks, and well into the future.

Re: The FIRST Alliance - A whole new way to play
 

I like the site. Easy to navigate your extensive database.

Just one issue. When clicking on a team's website via their team page, the url which it points me to is always prefaced with a second http://.

Re: The FIRST Alliance - A whole new way to play
 

Yup we've found the issue and are going to fix it when we update the site tonight. Thanks for the feedback!

Re: The FIRST Alliance - A whole new way to play
 

I think I found a bug....that or I don't understand the API....

When hitting this URL:http://www.thefirstalliance.org/api/...event-code=OHC

It returns:
{"result":true,"data":"MySql Error for query(SELECT t.number, t.id FROM\n((SELECT red_1_id as id from Matches m, events e where m.event_id=e.id and e.api_name='OHC' group by red_1_id)UNION\n(SELECT red_2_id from Matches m, events e where m.event_id=e.id and e.api_name='OHC' group by red_2_id)UNION\n(SELECT red_2_id from Matches m, events e where m.event_id=e.id and e.api_name='OHC' group by red_3_id)UNION\n(SELECT blue_1_id from Matches m, events e where m.event_id=e.id and e.api_name='OHC' group by blue_1_id)UNION\n(SELECT blue_2_id from Matches m, events e where m.event_id=e.id and e.api_name='OHC' group by blue_2_id)UNION\n(SELECT blue_3_id from Matches m, events e where m.event_id=e.id and e.api_name='OHC' group by blue_3_id)) as team_list,\nteams t where team_list.id= t.id)Error: Table 'db409593564.Matches' doesn't exist"}

Every other time I used an incorrect parameter it returned with result = false and not an SQL error.

Aside from that, great job this site has a lot of potential.

Re: The FIRST Alliance - A whole new way to play
 

Okay, fixed that bug, thank you very much for notcing that.

Re: The FIRST Alliance - A whole new way to play
 

Ok big update!

First we want to say a big "THANK YOU" to everyone in the FIRST community who has given positive and negative feedback, we've taken everyone's suggestions into account and are working on making The FIRST Alliance even better.

In the past five days we've averaged 5,000 API hits per day, and currently are slightly over 20,000 total hits.

The Big Announcement:
We've finalized an official roadmap for the site!
Check it out at: http://thefirstalliance.org/roadmap.php

Let us know what you think by replying to the thread or sending an email to contact@thefirstalliance.org

**We've fixed several bugs as well. Elimination brackets are mostly fixed, however we suspect they will break under certain edge cases, so if you notice anything please let us know. The team website issue has been resolved. As far as we know, all data has been downloaded and put into our database, but if you notice any oddities let us know by emailing contact@thefirstalliance.org.

Thanks to all of you again! We can't wait to show you what's next!

Re: The FIRST Alliance - A whole new way to play
 

Something doesn't add up here. Is there a typo?

Re: The FIRST Alliance - A whole new way to play
 

There is a little bit of rounding up and a little bit of rounding down. The current total as of right now is 23,000 requests, but the average is pretty effected by inrush from the first day.

Re: The FIRST Alliance - A whole new way to play
 

Sorry about that. Here's how it breaks down:

At the end of today we're on track to receive 25,000 total API hits.
It's been five days since we launched.
That averages out to 5,000 hits per day.

My brain seemed to turn into mush there, thanks for pointing that out!

Re: The FIRST Alliance - A whole new way to play
 

Would it be possible to add a team robot photo to the team page (user uploaded, of course) sometime down the road? Also, will outside scouting data eventually find its way on this site, or will it be based more on official data?

Re: The FIRST Alliance - A whole new way to play
 

Update: Team pages now have a section where you can upload an image of a robot along with a caption to be viewed by all. As of right now, all images need to be verified first by an admin due to the public nature of the website. If we don't have many incidents after a while we will talk about removing the verification process.

Does anybody have any suggestions of things they would like to see on this website?

Re: The FIRST Alliance - A whole new way to play
 

Dude.....I literally started working on that feature last night and finished it this morning, you can go have a look at the website.

Re: The FIRST Alliance - A whole new way to play
 

upload mechanism works great! Thanks :D