FIRST Team Search on FIRSTTopsite.com [Archive]

View Full Version : FIRST Team Search on FIRSTTopsite.com

Babyhueyhnx

12-04-2005, 19:53

Hello all,

Calvin and i are working on putting together a search database for the First Topsite (http://www.firsttopsite.com) 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.

Mike AA

13-04-2005, 01:31

Calvin

13-04-2005, 02:24

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. :)

DarkJedi613

13-04-2005, 08:47

I've already done this. ;)

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... ;)

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. :)

Calvin

13-04-2005, 18:26

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. :)

DarkJedi613

13-04-2005, 20:29

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 (http://www.team358.org/files/team_lookup/id_name_url_link.php).

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

Calvin

13-04-2005, 20:44

Oh, sorry I misunderstood.

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

DarkJedi613

13-04-2005, 20:53

Oh, sorry I misunderstood.

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

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. :)

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

Calvin

13-04-2005, 20:59

The code is messing the file_get_contents() function.

DarkJedi613

13-04-2005, 21:03

The code is messing the file_get_contents() function.
Hmm? Not sure what you're talking about.

BTW the public version is up. :)

Calvin

13-04-2005, 21:05

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

DarkJedi613

13-04-2005, 21:08

nevermind... Thanks for the public thing! I'll take a look now.
No problem, you can be my test subject...if you have questions or problems, etc. tell me though please. :)

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.

Calvin

13-04-2005, 22:11

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! :)

DarkJedi613

13-04-2005, 22:41

Awesome. :) It could use some more flavor...perhaps a color or two thrown in though. ;)

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. :)

Calvin

13-04-2005, 22:57

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.

DarkJedi613

13-04-2005, 23:08

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:

Calvin

13-04-2005, 23:23

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.

Babyhueyhnx

14-04-2005, 01:39

Calvin

14-04-2005, 02:22

Yes, details can be added later... :)

DarkJedi613

14-04-2005, 08:34

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.
Well, whatever - if you want to link to my search that's fine. :)

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. :D

Calvin

14-04-2005, 20:06

I have a feeling this is going to turn into a competition… “Who has a better search engine?” :D

My latest update: http://firsttopsite.com/teamdatabase/search.php

DarkJedi613

14-04-2005, 20:22

lol, nah...they're different - mine is meant to search for anything ever to do with a team, and yours is more specific... :)

It looks good now, I like the layout! ;) Only comment I have is when linking to other websites add a target="_blank" so it opens in a new window. :)

Anyway, it looks good - I'm gonna add some stuff to it when i get a chance, I'll send you an email when its done if you want.

Calvin

14-04-2005, 20:30

A great thing to add would be a php file that will search through usfirst.org and compile a new team_file.php for you. Like a update.php file!

DarkJedi613

14-04-2005, 21:51

A great thing to add would be a php file that will search through usfirst.org and compile a new team_file.php for you. Like a update.php file!
LOL, how do you think I did it the first time? ;) No way I did that by hand... :)

Beth Sweet

14-04-2005, 22:14

Calvin
Just to play english major, "special" is spelled incorrectly on the page that you linked to...

Calvin

15-04-2005, 00:40

Just to play english major, "special" is spelled incorrectly on the page that you linked to...details, details... :D I'll change it later... lol

LOL, how do you think I did it the first time? No way I did that by hand...
What I meant was, "if you could add that file to the package."

DarkJedi613

15-04-2005, 08:26

What I meant was, "if you could add that file to the package."That's why I have a file that you can download seperatly - the "Team Information Only" file.

I'm not going to release the file for a bunch of reasons. First of all it takes like 2 hours to run through (exaggeration, but seriously like 30 - 45 minutes depending on how fast usfirst.org (http://www.usfirst.org) responds and how fast my server responds (though I usually run it off Apache2 running on my home computer so that's a quick response)). Second, it opens 1708 pages on the FIRST server, that's a lot of their bandwidth to be using. Third there's no point - if you want the updated version download them from our site.

Also I made a quick search option which'll be available soon like your idea to make it so that they can just use my search instead of having people download the files. :)

What'd I tell you about details yesterday? It's the most important part! ;) :p

Calvin

15-04-2005, 18:53

ok, Fine! ;)