FIRST Team Search on FIRSTTopsite.com

Technical Website Design/Showcase
1

Hello all,

Calvin and i are working on putting together a search database for the First Topsite which includes the name, team number and website address for every team. in a effort to speed this up i would like it if you all could send an email to database@firsttopsite.com with all your team info as the contents.

Thanks.

2

Wouldnt this be easier achieved by looking at the site? all teams have their # and name and URL

-Mike

3

Our search engine, already searches through the list of FIRST Topsite members. Yet, we were thinking about adding another search engine what will search through a separate database that includes everybody.

In order to do this we must construct a list of all teams with a link to their webpage. I’ve already started construction on the list. You can see a preview here: http://firsttopsite.com/teamdatabase/detailsearch.php

BTW, members (of topsite) need-not send any info, we already have it. :slight_smile:

4

I’ve already done this. :wink:

http://www.team358.org/files/team_lookup/

It uses the websites and information posted by the TIMS system. If you guys want I could make something that just prints out “<Name> - <#> - <url>”, or could just search for them… :wink:

Eventually all the information I’ve compiled will be available (as a serialized PHP array), but I haven’t finished writing up a readme, etc. :slight_smile:

5

Looks great, but what we’re doing is a little different. Pretty much just id - name - url. Maybe I can add a “detail” button that will link to your website if the searcher wants details. :slight_smile:

6

I understand that, but what I’m saying is I have everything already made up for doing that - you just have to create a new file and put the following in it.


<?php
function id_name_url_link($arr_teams, $str_spacer) {
  foreach ($arr_teams as $i => $value) {
    echo $str_spacer . $arr_teams$i]"id"]  . " - " . $arr_teams$i]"name"] . " - <a href=\"" . $arr_teams$i]"website"] . "\" title=\"" . $arr_teams$i]"name"] . "\" target=\"_blank\">" . $arr_teams$i]"website"] . "</a>";
  }
}

$teams = unserialize(file_get_contents("team_file.php"));
id_name_url_link($teams, "<br>");
?>

As can be seen here.

I just think its pointless to try getting information I already have. :slight_smile:

7

Oh, sorry I misunderstood.

Thanks for that link.
Maybe I should just link to you. :smiley:

8

If you want, that’s fine. Also I’m gonna put up a public version as soon as I finish writing the download page @ http://www.team358.org/files/team_lookup/public/ (I know, its an original URL…), it’ll contain the team information and stuff, but if you want to just link to my file that’s cool. :slight_smile:

Would it better to take out teams w/o a website? :confused:

9

The code is messing the file_get_contents() function.

10

Hmm? Not sure what you’re talking about.

BTW the public version is up. :slight_smile:

11

nevermind… Thanks for the public thing! I’ll take a look now.

12

No problem, you can be my test subject…if you have questions or problems, etc. tell me though please. :slight_smile:

I have some search functions too, but they’re not in the public version cause itd just take up more room that was written specifically for my search. But if you want 'em I have 'em.

13

OK I used your package to compile a new file that will work under the search engine I already have. http://firsttopsite.com/teamdatabase/detailsearch.php

Pretty cool! :slight_smile:

14

Awesome. :slight_smile: It could use some more flavor…perhaps a color or two thrown in though. :wink:

Where’d you get the “short names” from, i.e. “Robotic Eagles” for us…I don’t think that’s in my file…? :confused:

I’m getting weird results if I search for a number like “2”

Also the link for team 2 is wrong when I search for “2”

Thanks for the link back. :slight_smile:

15

Yep, you just found a bug! (fixed it)

When you search for “2” it displays all entries that have “2” somewhere.
As for the short names, those were found at firstwiki.org

BTW, this is just a test page. When done will look like the rest of the website.

16

So when I search for 2…is team 2 supposed to show up? cause I’m getting 395 & 1593…which don’t have twos in 'em :eek:

Thanks for the FIRSTWiki hint…:goes to add that into the arrays: :yikes:

17

Team 2, doesn’t have a website… so it’s not going to show up. The other entries you found have a “2” in the name.

18

i like the fact that Pats search includes all the info about the team. not just the name and url. the information can be helpful to scouting teams and the like. i also think that it would be cool if all teams with out websites were listed in the search too. just a thought though.

19

Yes, details can be added later… :slight_smile:

20

Well, whatever - if you want to link to my search that’s fine. :slight_smile:

My search also does a lot of error checking and stuff to make sure you don’t give it BS data. Soon awards are going to be searchable also. :smiley: