team 930's scouting db

Competition Scouting
1

here is 930’s scouting db,.http://bfganimation.sytes.net , we might not use it though. We may help out stang with theirs. This is very preliminary layout though

2

It looks good. One suggestion though. Please… seperate the teams into different pages. Don’t put them all on one big one. :wink:

Since you’re allready using php, just add something like

if ( isset($HTTP_GET_VARS’tn’]) || isset($HTTP_POST_VARS’tn’]) )
{
$team_number = (int) ( isset(HTTP_POST_VARS’tn’]) ? $HTTP_POST_VARS’tn’] : $HTTP_GET_VARS’tn’] );

if ( $team_number < 1 || $team_number > 9999 )
{
$team_number = -1;
}

} else {
$team_number = -1;
}

if ($team_number != -1)
{
$add_sql = “WHERE team_number = $team_number”;
} else {
$add_sql = “”;
}

Then… to your sql string that you get to fetch the data… just go

$sql .= $add_sql

note… if you allredy have a WHERE to take that out of the $add_sql and to rename the team_number in the sql to whatever it’s in your db. This should work with any version of php and if you use a new enough version you can just use the globals. Also… be sure you have magic quotes or else use addslashes($team_number) before the sql.

Also… once you finish this… please pm or email me with a direct link to a team page so that I can add your db to the www.feds201.com

3

Hey Jack

I am actually the programmer of the site, not that the look is oh so great. I was intending to do that but just hadn’t had the time to yet
it was easier to do it that way quickly

I have just updated it (or will) after I restart the server and update some stuff. I should have your suggestion done also by the end of the night and i will update this tomorrow again with that idea…

4

FYI you spelled “torque” as “toque” in your DB

5

Thanks Dave i also noticed that as i was writing the update of today. It’s really looking cool. If someone would like to design some graphics for it that’d be great or actually any ideas to spruce up the GUI because right now i would agree the GUI sucks.

The last update i so far have planned is to put a small form on the view that lists all the teams that would allow someone to just type in a team number…

I should for sure have that out tomorrow…