Location: PHPKode > projects > Online Fantasy Football League > offl-0.2.6/www/alternflteams.php
include ("htmlparser.inc");
require_once($DOC_ROOT . "/lib/header.php"); 
$sqllist = Array();
//change all nfl_profiles to point to CBS Sportsline
//$sqllist[0] = "ALTER TABLE nflteams DROP nflteam_schedulenamex";
$sqllist[1] = "ALTER TABLE nflteams ADD nflteam_schedulename varchar(100)";
$sqllist[2] = "UPDATE nflteams SET nflteam_schedulename = nflteam_city";
$sqllist[3] = "UPDATE nflteams SET nflteam_schedulename = 'N.Y. Jets' WHERE nflteam_name = 'Jets'";
$sqllist[4] = "UPDATE nflteams SET nflteam_schedulename = 'N.Y. Giants' WHERE nflteam_name = 'Giants'";

$db = new OFFL_DBObject(); 
$dbconn = $db->getConn(); 
foreach ($sqllist as $sql) { 
	$result = mysql_query($sql, $dbconn); 
	echo "$result - $sql<br>\n"; 
echo "<br/>Any line with a - not preceded by a 1 means it failed!  This is OK on ALTER TABLE if already executed!";
echo "<h2>Players NFL Teams table update complete!</h2>"; 
echo "This only needs to be executed once!";
Return current item: Online Fantasy Football League