<?php 
include ("htmlparser.inc");
 
require_once("offlconfig.php"); 
require_once($DOC_ROOT . "/lib/header.php"); 
 
$sqllist = Array();
 
//change all nfl_profiles to point to CBS Sportsline
$sqllist[0] = "update players set nfl_profile = replace(nfl_profile,'http://www.nfl.com/players/playerpage/','http://www.sportsline.com/nfl/players/playerpage/')";

$db = new OFFL_DBObject(); 
$dbconn = $db->getConn(); 
 
foreach ($sqllist as $sql) { 
	$result = mysql_query($sql, $dbconn); 
	echo "$result - $sql<br>\n"; 
} 
 
$db->closeDB(); 
 
echo "<h2>Players NFL Profile update complete!</h2>"; 
echo "This only needs to be executed once!";
 
?>