[offl-cvs] offl/www/lib/classes offl_nflteam.php,NONE,1.3

[Brad S. <sc...@us...>]

Update of /cvsroot/offl/offl/www/lib/classes
In directory sc8-pr-cvs3.sourceforge.net:/tmp/cvs-serv26041

Modified Files:
      Tag: 1.3
	offl_nflteam.php 
Log Message:
Adds "getNFLTeamByAbbv" function.

Index: offl_nflteam.php
===================================================================
RCS file: /cvsroot/offl/offl/www/lib/classes/offl_nflteam.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** offl_nflteam.php	22 Sep 2004 04:05:46 -0000	1.2
--- offl_nflteam.php	6 Sep 2007 03:31:34 -0000	1.3
***************
*** 201,204 ****
--- 201,222 ----
  
  	/**
+ 	 * Returns an OFFL_NFLTeam object by NFL.com abbreviation
+ 	 *
+ 	 * @param string $abbv i.e. "TEN" or "IND"
+ 	 * @return OFFL_NFLTeam
+ 	 */
+ 	function getNFLTeamBySchedName($schedName)
+ 	{
+ 		$sql = "SELECT nflteam_id FROM nflteams WHERE nflteam_schedulename='" . mysql_escape_string($schedName) . "'";
+ 		$result = mysql_query($sql,$this->_conn) or die (mysql_error() . ": $sql");
+ 
+ 		$team = new OFFL_NFLTeam(mysql_result($result,0,"nflteam_id"));
+ 
+ 		mysql_free_result($result);
+ 
+ 		return $team;
+ 	}
+ 
+ 	/**
  	 * Returns an array of all registered NFL teams
  	 *
***************
*** 209,212 ****
--- 227,240 ----
  		$retArr = array();
  		$sql = "SELECT nflteam_id FROM nflteams ORDER BY nflteam_city, nflteam_name";
+ 		
+ 		//$sql = "SELECT nflteam_id FROM nflteams WHERE nflteam_id <= 4 ORDER BY nflteam_city, nflteam_name";
+ 		//$sql = "SELECT nflteam_id FROM nflteams WHERE nflteam_id >= 5 AND nflteam_id <= 8 ORDER BY nflteam_city, nflteam_name";
+ 		//$sql = "SELECT nflteam_id FROM nflteams WHERE nflteam_id >= 9 AND nflteam_id <= 12 ORDER BY nflteam_city, nflteam_name";
+ 		//$sql = "SELECT nflteam_id FROM nflteams WHERE nflteam_id >= 13 AND nflteam_id <= 16 ORDER BY nflteam_city, nflteam_name";
+ 		//$sql = "SELECT nflteam_id FROM nflteams WHERE nflteam_id >= 17 AND nflteam_id <= 20 ORDER BY nflteam_city, nflteam_name";
+ 		//$sql = "SELECT nflteam_id FROM nflteams WHERE nflteam_id >= 21 AND nflteam_id <= 24 ORDER BY nflteam_city, nflteam_name";
+ 		//$sql = "SELECT nflteam_id FROM nflteams WHERE nflteam_id >= 25 AND nflteam_id <= 28 ORDER BY nflteam_city, nflteam_name";
+ 		//$sql = "SELECT nflteam_id FROM nflteams WHERE nflteam_id >= 29 AND nflteam_id <= 32 ORDER BY nflteam_city, nflteam_name";
+ 		
  		$result = mysql_query($sql,$this->_conn) or die (mysql_error() . ": $sql");