1998 && $year<=$startdate0)
{
$year = (int)$year; $enddate = $year + 1;
if($year < 1999 || $year > $startdate0) { $year = $startdate0; }
$startdate = $year . "-01-01";
$enddate = $enddate . "-01-01";
$sql = "SELECT * FROM news WHERE date_entered >= \"$startdate\" AND date_entered < \"$enddate\" ORDER BY date_entered DESC, news_id DESC";
}
if($year && ($year > $startdate0 || $year < 1999))
{
$location = "https://www.eecs.umich.edu/eecs/etc/news/eecsnews.html";
header("Location: $location"); exit;
}
//Get news by category
if($cat)
{
$string_ok = "";
$allowed = array("External","Research","News","Awards","Student","Alumni","Grad","Undergrad","Diversity","Class");
foreach($allowed as $member) { if($member == $cat) { $string_ok = "yes"; } }
if(!$string_ok)
{
$location = "https://www.eecs.umich.edu/eecs/etc/news/eecsnews.html";
header("Location: $location"); exit;
}
$sql = "SELECT * FROM news WHERE news_type = \"$cat\" ORDER BY date_entered DESC, news_id DESC $limit";
}
//Get Undergrad news
if($cat == "Undergrad")
{
$sql = "SELECT DISTINCT * FROM news " .
"RIGHT JOIN tags ON news.news_id=tags.news_id " .
"WHERE news_type = \"Student\" " .
"AND tags.tagname_id = 233 " .
"ORDER BY news.news_id DESC $limit";
$result = mysql_query($sql) or die (mysql_error());
}
//Get Grad news
if($cat == "Grad")
{
$sql = "SELECT DISTINCT * FROM news " .
"RIGHT JOIN tags ON news.news_id=tags.news_id " .
"WHERE news_type = \"Student\" " .
"AND tags.tagname_id = 234 " .
"ORDER BY news.news_id DESC $limit";
$result = mysql_query($sql) or die (mysql_error());
}
//Get Diversity news
if($cat == "Diversity")
{
$sql = "SELECT DISTINCT * FROM news " .
"RIGHT JOIN tags ON news.news_id=tags.news_id " .
"WHERE tags.tagname_id = 232 " .
"ORDER BY news.news_id DESC $limit";
$result = mysql_query($sql) or die (mysql_error());
}
//Determine Title
if($cat == "News") { $title = "EECS Department News"; }
elseif($cat == "External") { $title = "EECS in the News"; }
elseif($cat == "Awards") { $title = "EECS Faculty and Staff News"; }
elseif($cat == "Student") { $title = "EECS Student News"; }
elseif($cat == "Undergrad") { $title = "EECS Undergraduate Student News"; }
elseif($cat == "Grad") { $title = "EECS Graduate Student News"; }
elseif($cat == "Diversity") { $title = "EECS Diversity and Outreach News"; }
elseif($cat == "Class") { $title = "EECS Course Announcements"; }
elseif(!$cat) { $title = "EECS News"; }
else { $title = "$cat News"; }
if($year) { $title = "EECS News for $year"; }
if($id) { $title = "EECS News Story"; }
print "
\n";
print "$title |
\n";
print "| \n";
include("get_records.php");
print " |
\n";
if(!$id && !$cat && !$year)
{
$thisyr = date("Y");
print "| All EECS News for $thisyr |
\n";
}
if($cat && !$showall) { print "| Show All |
\n"; }
print "
\n";
?>
