"January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"); $GLOBALS["maxImageWidth"]=1000; $conn = dbConnect("newsCorps"); setNewsroomGlobals(); function newsroom() { // NEWSROOM MODE // MENU switch ($_GET["c"].$_POST["c"]) { case "email": emailStory($_GET["id"]); break; case "send": validateEmail($_POST["id"]); break; case "releaseList": releaseListXML($_GET["p"],$_GET["t"], $_GET["count"]); break; case "releaseDisplayXML": releaseDisplayXML ($_GET["id"]); break; default: if (strlen($_GET["id"])>0) { showRelease($_GET["id"]); } else { $lpid=mysql_real_escape_string(filter_var($_GET["lp"], FILTER_SANITIZE_NUMBER_INT)); // // figure out if this is a landing page or not // if (strlen($lpid)) { $sql="select * from landingPages WHERE departmentID=".$GLOBALS["department"]." AND pageID=".$lpid; $q=mysql_query ($sql); $r=mysql_num_rows($q); if ($r>0) { //DISPLAY A LANDING PAGE TEMPLATE $row=mysql_fetch_array($q); displayLandingPage($row["pageID"], 0, $row["pageName"]); } else { // No landing page, just display recent releases listReleases($GLOBALS["department"]); } } else { if (strlen($_GET["topic"].$_GET["people"])>0) { // DISPLAY TOPIC or PERSON PAGE listReleases($GLOBALS["department"]); } else { //DISPLAY NEWSROOM HOMEPAGE //FIRST, IS THERE A DEFAULT HOMEPAGE??? $sql="select * from landingPages WHERE departmentID=".$GLOBALS["department"]." AND pageName=\"Homepage\""; $q=mysql_query ($sql); $r=mysql_num_rows($q); if (($r==0)||(strlen($_GET["all"])>0)) { // No landing page, just display recent releases listReleases($GLOBALS["department"]); } else { // Display the landing page for the homepage $row=mysql_fetch_array($q); displayLandingPage($row["pageID"], 1, $row["pageName"]); } } } } } } function directory() { // PEOPLE DIRECTORY MODE showHeader(0,1); if (strlen($_GET["id"])>0) { directoryPerson($_GET["id"]); } else { showDirectory(); } showFooter(1); } // DISPLAY A LANDING PAGE function displayLandingPage($id, $homepage=0,$pageName) { $GLOBALS["wide"]=""; $GLOBALS["narrow"]=""; $GLOBALS["fullWidth"]=""; $sql="SELECT * FROM landingPageElements WHERE pageID=".mysql_real_escape_string(filter_var($id, FILTER_SANITIZE_NUMBER_INT))." ORDER BY pageLocation, locationPosition"; $q=mysql_query($sql); $nRows=mysql_num_rows($q); if ($nRows==0) { listReleases($GLOBALS["department"]); } else { //iterate through page elements for ($i=0; $i<$nRows; $i++) { $row = mysql_fetch_array($q); $class=""; switch(strtolower($row["pageLocation"])) { case "w": $class="wide"; break; case "n": $class="narrow"; break; case "f": $class="fullWidth"; break; } switch(strtolower($row["display"])) { case "allreleases": listElementReleases(0,$row["displayCount"],"",$row["elementHeadline"],$class); break; case "releases": listElementReleases($row["topicSource"],$row["displayCount"],"",$row["elementHeadline"], $class); break; case "release": listElementRelease($row["topicSource"],$class); break; case "headlines": listElementReleases($row["topicSource"], $row["displayCount"], "headlines",$row["elementHeadline"],$class); break; case "multimedia": listElementMultimedia($row["topicSource"], $row["displayCount"],$class, $row["elementHeadline"]); break; case "rss": showRSS($row["htmlSource"], $row["displayCount"],$row["elementHeadline"], $class, $row["relatedURL"]); break; case "topics": listTopics($row["displayCount"], $row["elementHeadline"], $class); break; case "html": $output=stripslashes($row["htmlSource"]); $GLOBALS[$class].="\n\t\t
\n\t\t".$output."\n\t\t
\n"; break; } } ?> ".$pageName." : ".$GLOBALS["newsroomTitle"]." : IUPUI\n"; showHeader("1"); if (strlen($GLOBALS["fullWidth"])>0) { ?>
0) ?>
0) { ?>
0) { for ($i=0; $i<$nRows; $i++) { $row = mysql_fetch_array($q); if ($i==0) { if ($topicID) { $thisSubHead=$row["topicName"]; if ($subhead) $thisSubHead=$subhead; $output.="

".$thisSubHead."

\n"; $moreLink=$GLOBALS["publicBaseURL"]."topic/".$row["topicID"]."/".outputTitle($row["topicName"]); } else { $output.="

Recent News

\n"; $moreLink=$GLOBALS["publicBaseURL"]."?all=all"; } if (strlen($headlines)>0) $output.="\n\t\t\t\n"; if (strlen($moreLink)>0) { $output.="More news"; } $GLOBALS[$class].="\n\t\t
\n\t\t".$output."\n\t\t
\n"; } } function listElementRelease($releaseID, $class) { $today=date('Ymd'); $sql="select headline, copy, date, releases.id FROM releases WHERE releases.id=".mysql_real_escape_string(filter_var($releaseID, FILTER_SANITIZE_NUMBER_INT)); $q=mysql_query($sql); $nRows=mysql_num_rows($q); if ($nRows>0) { $row = mysql_fetch_array($q); $output.="

".$row["headline"]."

\n"; $output.="

".humanDate($row["date"])."

\n"; $output.=$row["copy"]."
\n"; $GLOBALS[$class].="\n\t\t
\n\t\t".$output."\n\t\t
\n"; } } function listElementMultimedia($topicID, $count,$class,$displayHeadline) { $sql="select mmName, multimedia.mmID, mmURL, mmCaption FROM multimedia, topicMultimediaAssignments WHERE topicMultimediaAssignments.topicID=".mysql_real_escape_string(filter_var($topicID, FILTER_SANITIZE_NUMBER_INT))." AND topicMultimediaAssignments.mmID=multimedia.mmID ORDER BY mmID desc LIMIT 0, ".$count; $q=mysql_query($sql); $nRows=mysql_num_rows($q); if ($nRows>0) { $output=""; if ($nRows<$count) $nRows==$count; for ($i=0; $i<$nRows; $i++) { $row=mysql_fetch_array($q); $output.=releaseVideoOutput($row["mmName"],$row["mmURL"], $row["mmCaption"]); } $GLOBALS[$class].="\n\t\t

".$displayHeadline."

\n\t\t".$output."\n\t\t
\n"; } } // PUBLIC RELEASE VIEWER function listReleases ($department) { // DETERMINE PAGINATION $page=0; if (strlen($_GET["p"]>0)) { $page=$_GET["p"]; } $introText=""; $whereClause=""; // DETERMINE TYPE - BY TOPIC, PEOPLE, OR ALL? $querystring="topic=".$_GET["topic"]."&people=".$_GET["people"]."&all=".$_GET["all"]; $rssURL=rssFileName("general"); $rssText="all releases"; if (strlen($_GET["topic"])>0) { $whereClause=", topicAssignments WHERE releases.id=topicAssignments.releaseID AND topicAssignments.topicID=".mysql_real_escape_string(filter_var($_GET["topic"], FILTER_SANITIZE_NUMBER_INT)); if (strlen($_GET["people"])==0) { $sql="select topicName, moreInfoText from topics WHERE topics.topicID='".mysql_real_escape_string(filter_var($_GET["topic"], FILTER_SANITIZE_NUMBER_INT))."'"; $rResult = mysql_query($sql); $rRows = mysql_num_rows($rResult); if ($rRows>0) { $row = mysql_fetch_array($rResult); $rssURL=rssFileName($row["topicName"]); $rssText="this topic"; ?> ".$row["topicName"]." : ".$GLOBALS["newsroomTitle"]." : IUPUI\n"; ?> News Releases for ".$row["topicName"]."\n"; if (strlen($row["moreInfoText"])>0) $introText.="".$row["moreInfoText"]."\n"; } } } elseif (strlen($_GET["people"])>0) { $uname=mysql_real_escape_string($_GET["people"]); $whereClause=", releasePeopleAssignments WHERE releases.id=releasePeopleAssignments.releaseID AND releasePeopleAssignments.username = '".$uname."'"; $sql="select directoryPeople.fullName, directoryPeople.credentials, peopleTitles.title from directoryPeople, peopleTitles where directoryPeople.username='".$uname."' AND directoryPeople.departmentID=".$department." AND directoryPeople.username=peopleTitles.username AND peopleTitles.departmentID=".$department." ORDER BY peopleTitles.displayOrder"; $zResult = mysql_query($sql); $zRows = mysql_num_rows($zResult); if ($zRows>0) { $row = mysql_fetch_array($zResult); $cred=""; if (strlen($row["credentials"])>0) { $cred=", ".$row["credentials"]; } ?> ".$row["fullName"]." : ".$GLOBALS["newsroomTitle"]." : IUPUI\n"; showHeader("1"); $introText="

News Releases for ".$row["fullName"].$cred."

\n

"; for ($i=0; $i<$zRows; $i++) { if ($i>0) { $row = mysql_fetch_array($zResult); } $introText.=$row["title"]."
\n"; } $introText.= "

"; } } else { ?> ".$GLOBALS["newsroomTitle"]." : IUPUI\n"; showHeader("1"); } if (strlen($whereClause)>0) { $whereClause.=" AND"; } else { $whereClause.=" WHERE"; } $today=date('Ymd'); $whereClause.=" releases.departmentID=".$department." AND releases.date<=".$today." "; // BUILD MASTER QUERY $sql="select releases.id, releases.date, releases.headline, releases.copy FROM releases ".$whereClause." ORDER BY date DESC, id DESC LIMIT ".($page*$GLOBALS["releasesPerPage"]).",10000"; $qResult = mysql_query($sql); $nRows = mysql_num_rows($qResult); if (strlen($introtxt)==0) { echo $introText; } else { echo $introtxt; } if ($nRows==0) { echo "

No news releases found with these criteria

"; // List releases by category $sql="select count(*) as numReleases, topicAssignments.topicID, topics.topicName from topicAssignments, topics WHERE topicAssignments.topiciD=topics.topicID AND topics.departmentID=".$department." GROUP BY topicID ORDER BY topics.topicName"; $aResult = mysql_query($sql); $aRows = mysql_num_rows($aResult); if ($aRows>0) echo "

View news in these topics:

\n\n"; } $more=0; $output=""; for ($i=0; $i<$nRows; $i++) { if ($i==1) { if (strlen($introText)==0) { echo "

Recent News Releases

\n"; } if (strlen($rssURL)>0) { ?>\n

"; $output.=$row["headline"]."

\n

"; if (mysql_num_rows($imgResult)>0) { $imgRow=mysql_fetch_array($imgResult); $output.="\"".$imgRow["caption"]."\""; } $output.= "".humanDate($row["date"])." —\n"; $pos=strpos(trim($row["copy"]), "

"); // $pos=strpos($row["copy"], "

", ($pos+4)); $firstGraph = substr(trim($row["copy"]), 3, $pos+3); if ($GLOBALS["releasesFull"]) { $output.=$row["copy"]; } else { $output.=$firstGraph; $output.= "Full story

\n"; } // $output.= strip_tags($firstGraph); $output.= "\n"; if ($i==$GLOBALS["releasesPerPage"]) { $more=1; break; } } //sjh // Generate Pagination Output if (($page+$more)>0) $pagination.= "View: "; if ($page>0) { $pagination.= "Newer Releases"; } if (($page>0)&&($more>0)) $pagination.=" | "; if ($more>0) { $pagination.= "Older Releases"; } if (strlen($pagination)>0) $pagination="
".$pagination."
\n"; // output echo $pagination.$output.$pagination; showFooter(); } // Display Release Detail function showRelease ($id,$msg="") { $today=date('Ymd'); $sql="select releases.date, releases.headline, releases.copy FROM releases WHERE id=".mysql_real_escape_string(filter_var($id, FILTER_SANITIZE_NUMBER_INT))." AND releases.date<=".$today; $qResult = mysql_query($sql); $nRows = mysql_num_rows($qResult); if ($nRows==0) { showHeader("1"); echo "

No release found with that ID number

"; // listReleases($GLOBALS["department"]); showFooter(); } else { // DISPLAY RELEASE $row = mysql_fetch_array($qResult); // GATHER TOPICS LIST $sql="select topics.topicID, topicName, topicURL, thumbnail FROM topics, topicAssignments WHERE topicAssignments.topicID=topics.topicID AND topics.hidden=0 AND topicAssignments.releaseID=".mysql_real_escape_string(filter_var($id, FILTER_SANITIZE_NUMBER_INT)); $zResult = mysql_query($sql); $thumbnail=""; $zRows = mysql_num_rows($zResult); $topics=""; $learnmore=""; for ($i=0; $i<$zRows; $i++) { $zrow = mysql_fetch_array($zResult); $topics.="
  • ".$zrow["topicName"]."
  • "; if ($i==0) $thumb=$zrow["thumbnail"]; if (strlen($zrow["topicURL"])>0) { $learnmore.="
  • ".$zrow["topicName"]."
  • "; } } // GATHER FACULTY LIST $sql="select directoryPeople.fullName, directoryPeople.url, directoryPeople.thumbnail, directoryPeople.username FROM directoryPeople, releasePeopleAssignments WHERE directoryPeople.username=releasePeopleAssignments.username AND releasePeopleAssignments.releaseID=".mysql_real_escape_string(filter_var($id, FILTER_SANITIZE_NUMBER_INT))." AND directoryPeople.departmentID=".$GLOBALS["department"]." ORDER BY directoryPeople.lastname ASC"; $rResult = mysql_query($sql); $rRows = mysql_num_rows($rResult); for ($i=0; $i<$rRows; $i++) { $rrow = mysql_fetch_array($rResult); $topics.="
  • ".$rrow["fullName"]."
  • "; if (strlen($rrow["url"])>0) { $learnmore.="
  • ".$rrow["fullName"]."
  • "; } if (($i==0)&&(strlen($thumbnail)==0)) $thumb=$zrow["thumbnail"]; } // GATHER MEDIA CONTACTS $sql="select directoryPeople.fullName, directoryPeople.displayDepartment, directoryPeople.phone, directoryPeople.email from directoryPeople, contactAssignments WHERE directoryPeople.username=contactAssignments.id AND contactAssignments.releaseID=".mysql_real_escape_string(filter_var($id, FILTER_SANITIZE_NUMBER_INT))." AND directoryPeople.departmentID=".$GLOBALS["department"]; $yResult = mysql_query($sql); $yRows = mysql_num_rows($yResult); $mediaContacts=""; for ($i=0; $i<$yRows; $i++) { $yrow = mysql_fetch_array($yResult); $mediaContacts.="
  • ".$yrow["fullName"]."
    \n"; if(strlen($yrow["displayDepartment"])>0) $mediaContacts.=$yrow["displayDepartment"]."
    \n"; if(strlen($yrow["phone"])>0) $mediaContacts.=$yrow["phone"]."
    \n"; if(strlen($yrow["email"])>0) $mediaContacts.="".$yrow["email"]."
  • \n"; } // GATHER EXTERNAL MEDIA CONTACTS $sql="select * from tempContactAssignments WHERE releaseID=".mysql_real_escape_string(filter_var($id, FILTER_SANITIZE_NUMBER_INT)); $yResult = mysql_query($sql); $yRows = mysql_num_rows($yResult); for ($i=0; $i<$yRows; $i++) { $yrow = mysql_fetch_array($yResult); $mediaContacts.="
  • ".$yrow["name"]."
    \n"; if(strlen($yrow["title"])>0) $mediaContacts.=$yrow["title"]."
    \n"; if(strlen($yrow["phone"])>0) $mediaContacts.=$yrow["phone"]."
    \n"; if(strlen($yrow["email"])>0) $mediaContacts.="".$yrow["email"]."
  • \n"; } // FIND RELATED IMAGES // $sql="SELECT thumbnailAssignments.thumbnailName, caption, highres FROM thumbnailAssignments, thumbnails WHERE thumbnailAssignments.releaseID=".$id." AND thumbnailAssignments.thumbnailName=thumbnails.thumbnailName"; // $sql="SELECT thumbnailAssignments.thumbnailName, caption, highres FROM thumbnailAssignments, thumbnails WHERE thumbnailAssignments.releaseID=".$id." AND thumbnailAssignments.thumbnailName=thumbnails.thumbnailName GROUP BY thumbnails.thumbnailName"; $sql="SELECT thumbnailAssignments.thumbnailName, caption, highres FROM thumbnailAssignments, thumbnails WHERE thumbnailAssignments.releaseID=".mysql_real_escape_string(filter_var($id, FILTER_SANITIZE_NUMBER_INT))." AND thumbnailAssignments.thumbnailName=thumbnails.thumbnailName ORDER BY thumbnails.thumbnailName"; $yResult = mysql_query($sql); $yRows = mysql_num_rows($yResult); $images=""; $lasttn=""; for ($i=0; $i<$yRows; $i++) { $yrow = mysql_fetch_array($yResult); if ($yrow["thumbnailName"]!==$lasttn) { $image="\"".$yrow["caption"]."\""; if ($yrow["highres"]=="1") { $image="".$image.""; } $images.=$image."
    ".$yrow["caption"]."\n"; if ($yrow["highres"]=="1") { $images.="View print-quality image"; } } $lasttn=$yrow["thumbnailName"]; } // RELATED MULTIMEDIA $sql="SELECT mmName, mmURL, mmCaption, mmType, mmTN FROM multimedia, releaseMultimediaAssignments WHERE releaseMultimediaAssignments.releaseID=".mysql_real_escape_string(filter_var($id, FILTER_SANITIZE_NUMBER_INT))." AND releaseMultimediaAssignments.mmID=multimedia.mmID"; $yResult = mysql_query($sql); $mm=""; $yRows = mysql_num_rows($yResult); for ($i=0; $i<$yRows; $i++) { $yrow = mysql_fetch_array($yResult); $output=""; // Determine multimedia type switch(strtolower($yrow['mmType'])) { case 'photogallery': $output=releaseGalleryOutput($yrow['mmName'], $yrow['mmURL'], $yrow['mmCaption']); break; case 'video': $output=releaseVideoOutput($yrow['mmName'], $yrow['mmURL'], $yrow['mmCaption']); if (strlen($output)>0) { $output="

    Video

    \n".$output."
    "; } break; } $mm.=$output; } ?> ".$row["headline"]." : ".$GLOBALS["newsroomTitle"]." : IUPUI\n"; showHeader("1"); if (strlen($msg)>0) echo $msg; echo "

    ".$row["headline"]."

    \n

    \n"; if (strlen($images)>0) { echo "

    \n".$images."
    \n"; } echo "
    \n"; echo "

    Published:

    \n

    ".humanDate($row["date"])."

    \n"; if (strlen($mediaContacts)>0) echo "\n

    Contact Information:

    \n"; if (strlen($topics)>0) echo "

    View Related Releases:

    \n\n"; if (strlen($learnmore)>0) echo "

    View Information About:

    \n\n"; echo "

    Share This:

    \n\n"; echo "
    \n"; if (strlen($mm)>0) { echo "

    Multimedia

    \n".$mm."\n"; } echo $row["copy"]."

    \n"; showFooter(); } } function releaseGalleryOutput($mmName, $id, $galleryCaption, $display=1) { mysql_select_db("photoGallery"); $output="

    Photo Gallery

    \n"; $sql="SELECT * FROM images WHERE galleryID=".mysql_real_escape_string(filter_var($id, FILTER_SANITIZE_NUMBER_INT))." ORDER BY galleryOrder ASC"; $zResult = mysql_query($sql); $nRows = mysql_num_rows($zResult); for ($i=0; $i<$nRows; $i++) { $zrow = mysql_fetch_array($zResult); $caption=str_replace("\"", "'", $zrow["caption"]); $title=str_replace("\"", "'", $zrow["title"]); $output.=""; if ($i<$display) { $output.="\"".$title."\""; $output.=""; if ($i==($display-1)) $output.="\n
    ".$mmName; } else { $output.="\n"; } } $output.="
    \n"; mysql_select_db("newsCorps"); return $output; } function releaseVideoOutput($mmName, $id, $caption) { $id=urldecode($id); // YOUTUBE VIDEO? if (strpos($id, "youtube.com")) { $output=""; $youtubeid=""; if (strpos($id, "watch?v=")) { $url_split=explode("=",$id); $youtubeid=$url_split[1]; $id="http://www.youtube.com/v/".$youtubeid; } elseif (strpos($id,"/v/")) { $url_split=explode("/",$id); $youtubeid=$url_split[count($url_split)]; } $output.=""; $output.="\"".$mmName."\"/
    ".$mmName."
    "; } elseif ((strpos($id, "iupui.edu/~iuihome/podcasts"))|| (strpos($id, "iupui.edu/podcasts"))) { $url_split=explode("=",$id); $iupuiID=$url_split[count($url_split)-1]; mysql_select_db("Impact"); $sql="select * from clips WHERE id=".mysql_real_escape_string(filter_var($iupuiID, FILTER_SANITIZE_NUMBER_INT)); $q=mysql_query($sql); $nRows = mysql_num_rows($q); if ($nRows<>0) { $row = mysql_fetch_array($q); $output.=""; $output.="\"".$mmName."\"/
    ".$mmName."
    "; } mysql_select_db("newsCorps"); } else { $output.="".$mmName.""; } // $output="
    ".$output."
    "; return $output; } function emailStory($id) { showHeader("1"); $sql="select releases.headline FROM releases WHERE id=".mysql_real_escape_string(filter_var($id, FILTER_SANITIZE_NUMBER_INT)); $qResult = mysql_query($sql); $nRows = mysql_num_rows($qResult); if ($nRows==0) { echo "

    No release found with that ID number

    "; listReleases(); } else { // DISPLAY RELEASE $row = mysql_fetch_array($qResult); ?>
    E-mail this story

    Story Headline:




    Error: Please enter an e-mail address"; emailStory($id); } else { sendEmail($id); } // } else { // echo "
    Error: Please re-enter the SPAM Question below
    "; // emailStory($id); // } } function sendEmail($id) { $sql="select releases.headline FROM releases WHERE id=".mysql_real_escape_string(filter_var($id, FILTER_SANITIZE_NUMBER_INT)); $qResult = mysql_query($sql); $nRows = mysql_num_rows($qResult); if ($nRows==0) { echo "

    No release found with that ID number

    "; listReleases(); } else { // DISPLAY RELEASE $row = mysql_fetch_array($qResult); $title=$row["headline"]; //get and truncate email and message $message=substr($_POST["message"],0,500); //remove cc and bcc in case of hackers $message=clean($message); $to=substr(clean($_POST["recipientEmail"]),0,100); $from=clean($_POST["senderEmail"]); $fromname=clean($_POST["senderName"]); $url=$GLOBALS['publicBaseURL'].'?id='.$id; $logInfo=date('Y-m-d')."\t".$to."\t".$from."\t".$fromname."\t".$url."\t".str_replace("\r\n", " ", $message); $subject = $GLOBALS["newsroomTitle"]." - ".substr($title,0,40).' - from '.$fromname; $message = ' '.$subject.'

    '.$fromname.' ('.$from.') has sent you an article from '.$GLOBALS["newsroomTitle"].'
    (E-mail address has not been verified)

    -----------------------------------
    Article Title: '.$title.'
    Article Address: '.$url.'
    Personal message:
    '.$message.'
    -----------------------------------

    * This is an automated message, please don\'t reply. *
    Please report spam or abuse of this service to the IUPUI webmaster at extaff@iupui.edu

    '; $headers = 'MIME-Version: 1.0' . "\r\n"; $headers .= 'From:' . $fromname . '<' . $from . ">\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; mail($to, $subject, $message, $headers); // write logfile // $handle=fopen("/ip/iupuimag/07emaillog.txt","a"); // fwrite($handle, $logInfo."\n"); // fclose($handle); showRelease($id, "

    Article sent via e-mail to ".$to."

    "); } } function showHeader($title=0,$directory=0) { ?> 0)) { include($GLOBALS["templateDirHeader"]); } else { include($GLOBALS["templateHeader"]); } if (strlen(trim($GLOBALS["publicNav"])) >0) include($GLOBALS["publicNav"]); if (strlen(trim($GLOBALS["templateHeadSecond"]))>0) include($GLOBALS["templateHeadSecond"]); if (strlen($GLOBALS["newsroomCSS"])>0) { echo ""; } // if ($title) { // echo "

    ".$GLOBALS["newsroomTitle"]."

    \n"; // echo "

    ".date('l, F j, Y')."

    \n
    "; // } } function showFooter($directory=0) { if (strlen(trim($GLOBALS["templateFootSecond"]))>0) include($GLOBALS["templateFootSecond"]); if (($directory)&&(strlen($GLOBALS["templateDirFooter"])>0)) { include($GLOBALS["templateDirFooter"]); } else { include($GLOBALS["templateFooter"]); } mysql_close(); } function setNewsroomGlobals() { // Get global variables from newsrooms table, set as global variables $sql = "SELECT * FROM departments, newsrooms WHERE departments.departmentID=".$GLOBALS["department"]." AND departments.departmentID=newsrooms.departmentID LIMIT 1"; $qResult=mysql_query($sql); if (mysql_num_rows($qResult)>0) { $row=mysql_fetch_array($qResult); $GLOBALS["department"]=$row["departmentID"]; $GLOBALS["rssBaseDir"]=$row["rssDir"]; $GLOBALS["shortName"]=$row["shortName"]; $GLOBALS["newsroomTitle"]=$row["title"]; $GLOBALS["releasesPerPage"]=$row["releasesPerPage"]; $GLOBALS["publicBaseURL"]=$row["baseURL"]; $GLOBALS["publicDirectoryURL"]=$row["baseDirectoryURL"]; $GLOBALS["publicNav"]=$row["publicNav"]; $GLOBALS["newsroomCSS"]=$row["newsroomStylesheet"]; $GLOBALS["templateHeader"]=$row["templateHead"]; $GLOBALS["templateFooter"]=$row["templateFoot"]; $GLOBALS["templateDirHeader"]=$row["directoryHead"]; $GLOBALS["templateDirFooter"]=$row["directoryFoot"]; $GLOBALS["directoryTnSize"]=$row["directoryTnSize"]; $GLOBALS["baseRSSURL"]=$row["baseRSSURL"]; $GLOBALS["baseImageOriginalPath"]=$row["baseImageOriginalPath"]; $GLOBALS["baseImageOriginalURL"]=$row["baseImageOriginalURL"]; $GLOBALS["baseImageURL"]=$row["baseImageURL"]; $GLOBALS["feedLength"]=$row["feedLength"]; $GLOBALS["releasesFull"]=$row["releasesFull"]; $GLOBALS["baseImageFinalPath"]=$row["baseImageFinalPath"]; $GLOBALS["templateFootSecond"]=$row["templateFootSecond"]; $GLOBALS["templateHeadSecond"]=$row["templateHeadSecond"]; $GLOBALS["directoryRootContent"]=$row["directoryRootContent"]; $GLOBALS["directoryBios"]=$row["directoryBios"]; $GLOBALS["directoryPreURL"]=$row["directoryPreURL"]; $GLOBALS["bioHeadline"]=$row["bioHeadline"]; $GLOBALS["homepageLandingPageID"]=$row["homepageLandingPageID"]; $GLOBALS["fundingHeadline"]=$row["fundingHeadline"]; } } function urlInclude($theURL) { $content=file_get_contents($theURL); echo $content; } function dbConnect($dbName) { $username="read-only"; $password="read-only"; $conn = mysql_connect("mysql.iu.edu:3121", $username, $password) or die("Could not connect: " . mysql_error()); //connect to server mysql_select_db($dbName) or die("Could not select database: " . mysql_error()); //connect to database; return $conn; } function humanDate ($computerDate) { $newDate=$GLOBALS["month"][substr($computerDate,4,2)+0]." "; $newDate.=(0+substr($computerDate,6,2)).", "; $newDate.=substr($computerDate,0,4); return $newDate; } function mysql_fetch_all($query, $kind = 'assoc') { $result = array(); $kind = $kind === 'assoc' ? $kind : 'row'; eval('while(@$r = mysql_fetch_'.$kind.'($query)) array_push($result, $r);'); return $result; } function clean($foo) { $foo=str_replace("bcc:","",$foo); $foo=str_replace("cc:","",$foo); $foo=strip_tags($foo); return $foo; } function directoryPerson() { // BUILD MASTER QUERY $sql="select directoryPeople.username, directoryPeople.fullName, directoryPeople.research, directoryPeople.bio, directoryPeople.focus, directoryPeople.address, directoryPeople.education, directoryPeople.phone, directoryPeople.email, directoryPeople.credentials, peopleStatus.statusName FROM directoryPeople, directoryAssignments, peopleStatus WHERE directoryAssignments.username='".mysql_real_escape_string($_GET["id"])."' AND directoryAssignments.departmentID=".$GLOBALS["department"]." AND directoryAssignments.statusID=peopleStatus.statusID AND peopleStatus.departmentID=".$GLOBALS["department"]." AND directoryAssignments.username=directoryPeople.username AND directoryPeople.departmentID=".$GLOBALS["department"]." LIMIT 1"; $output=""; $qResult = mysql_query($sql); $nRows = mysql_num_rows($qResult); if ($nRows==0){ echo "

    No people found with these criteria

    "; } else { $row = mysql_fetch_array($qResult); // Get Image $sql="select thumbnailName FROM peopleThumbnailAssignments WHERE username='".$row["username"]."'"; $zResult = mysql_query($sql); $zRows = mysql_num_rows($zResult); $thumbnail=""; if ($zRows>0){ $zrow = mysql_fetch_array($zResult); $thumbnail=$zrow["thumbnailName"]; } // Get titles $sql="select title FROM peopleTitles WHERE username='".$row["username"]."' AND departmentID=".$GLOBALS["department"]." ORDER BY displayOrder ASC"; $zResult = mysql_query($sql); $zRows = mysql_num_rows($zResult); for ($j=0; $j<$zRows; $j++ ) { $zrow = mysql_fetch_array($zResult); $titles.="
  • ".$zrow["title"]."
  • "; } $credentials=""; if (strlen(trim($row["credentials"]))>0) { $credentials=", ".$row["credentials"]; } $output.="

    ".$row["fullName"].$credentials."

    \n"; if (strlen($thumbnail)>0) { $output.="
    \"".$row["fullName"].$credentials."\"
    "; } if (strlen($titles)>0) { $output.=""; } if (strlen($row["email"].$row["phone"].$row["address"])>0) { $output.="

    Contact Information

    "; if (strlen($row["phone"])>0) $output.=$row["phone"]."
    "; if (strlen($row["address"])>0) $output.=$row["address"]."
    "; if (strlen($row["email"])>0) $output.="".$row["email"]."
    "; $output.="
    \n"; } if(strlen(trim($row["education"]))>0) { $output.="

    Education

    ".$row["education"]."
    \n"; } if(strlen(trim($row["research"]))>0) { $output.="

    ".$GLOBALS["fundingHeadline"]."

    ".$row["research"]."
    \n"; } if(strlen(trim($row["bio"]))>0) { $output.="

    ".$GLOBALS["bioHeadline"]."

    ".$row["bio"]."
    \n"; } if ($i==$GLOBALS["releasesPerPage"]) { $more=1; break; } } // $output.= ""; // output echo $output; $sql="select releases.id, releases.date, releases.headline, releases.copy FROM releases, releasePeopleAssignments WHERE releases.id=releasePeopleAssignments.releaseID AND releasePeopleAssignments.username = '".mysql_real_escape_string(filter_var($_GET["id"], FILTER_SANITIZE_NUMBER_INT))."' AND releases.departmentID=".$GLOBALS["department"]." ORDER BY date DESC LIMIT 0,".$GLOBALS["releasesPerPage"]; $qResult = mysql_query($sql); $nRows = mysql_num_rows($qResult); $output=""; for ($i=0; $i<$nRows; $i++) { if ($i==0) { $output="

    Recent News Releases

    \n"; } $row = mysql_fetch_array($qResult); // Get Image $sql="SELECT thumbnailAssignments.thumbnailName, caption, highres FROM thumbnailAssignments, thumbnails WHERE releaseID=".$row["id"]." AND thumbnailAssignments.thumbnailName=thumbnails.thumbnailName LIMIT 1"; $imgResult=mysql_query($sql); $output.="
    "; $output.="
    "; $output.=$row["headline"]."
    \n

    "; $output.= "".humanDate($row["date"])."\n

    "; } echo $output; } // END FUNCTION directoryPerson function showDirectory() { if (strlen($GLOBALS["directoryPreURL"])>0) include($GLOBALS["directoryPreURL"]); if ((strlen($_GET["status"])==0) && (strlen($GLOBALS["directoryRootContent"])>0)) { // DISPLAY ALTERNATE INDEX PAGE FOR DIRECTORY include ($GLOBALS["directoryRootContent"]); } else { // DISPLAY DIRECTORY $introText=""; $whereClause=""; $statusClause=""; $topic=0; // DETERMINE STATUS - ALL or a SPECIFIED STATUS? if (strlen($_GET["status"])>0) { $statusClause=" AND peopleStatus.statusID=".mysql_real_escape_string(filter_var($_GET["status"], FILTER_SANITIZE_NUMBER_INT)); } if (strlen($_GET["topic"])>0) { $topic=1; } //$statusClause=" AND peopleStatus.statusID=".$_GET["topic"]; } // BUILD MASTER QUERY $sql="select directoryPeople.username, directoryPeople.fullName, directoryPeople.bio, directoryPeople.phone, directoryPeople.email, directoryPeople.lastname, directoryPeople.address, directoryPeople.credentials, directoryPeople.focus, peopleStatus.statusName FROM directoryPeople, directoryAssignments, peopleStatus"; if ($topic) $sql.=", peopleTopicAssignments"; $sql.=" WHERE directoryAssignments.departmentID=".$GLOBALS["department"]." AND directoryPeople.departmentID=".$GLOBALS["department"]." AND directoryAssignments.statusID=peopleStatus.statusID ".$statusClause." AND peopleStatus.departmentID=".$GLOBALS["department"]." AND directoryAssignments.username=directoryPeople.username "; if ($topic) { $sql.=" AND directoryAssignments.username=peopleTopicAssignments.username "; $sql.=" AND peopleTopicAssignments.topicID=".mysql_real_escape_string(filter_var($_GET["topic"], FILTER_SANITIZE_NUMBER_INT)); } $sql.=" GROUP BY directoryPeople.username ORDER BY peopleStatus.statusID, directoryPeople.lastname, directoryPeople.fullName"; //ORDER BY date DESC LIMIT ".($page*$GLOBALS["releasesPerPage"]).",10000"; //echo $sql; $qResult = mysql_query($sql); $nRows = mysql_num_rows($qResult); if ($nRows==0){ echo "

    No people found with these criteria

    "; } $more=0; $output=""; //initialize anchors array. 0 = no people with that letter, 1=people with that letter $anchors=array(); for ($i=0; $i<26; $i++) { $anchors[$i]=0; } $thisStatus=""; for ($i=0; $i<$nRows; $i++) { $row = mysql_fetch_array($qResult); if ($i==0) { $output.=""; } //GET FIRST LETTER OF LAST NAME, SET ANCHORS TO TRUE FOR THAT LAST NAME $fChar=strtolower(substr($row["lastname"],0,1)); $fChar=ord($fChar)-97; $anchors[$fChar]++; if ($thisStatus<>$row["statusName"]) { $output.="\n"; $thisStatus=$row["statusName"]; } // Get Image $sql="select thumbnailName FROM peopleThumbnailAssignments WHERE username='".$row["username"]."'"; $zResult = mysql_query($sql); $zRows = mysql_num_rows($zResult); $thumbnail=""; if ($zRows>0){ $zrow = mysql_fetch_array($zResult); $thumbnail=$zrow["thumbnailName"]; } // Get titles $sql="select title FROM peopleTitles WHERE username='".$row["username"]."' AND departmentID=".$GLOBALS["department"]." ORDER BY displayOrder ASC"; $zResult = mysql_query($sql); $zRows = mysql_num_rows($zResult); $titles=""; for ($j=0; $j<$zRows; $j++ ) { $zrow = mysql_fetch_array($zResult); $titles.="
  • ".$zrow["title"]."
  • \n"; } $credentials=""; if (strlen(trim($row["credentials"]))>0) { $credentials=", ".$row["credentials"]; } $output.="0) { $output.="\"".$row["fullName"].$credentials."\""; } $output.= "\n\t"; $output.="\n\n\n"; // if ($i==$GLOBALS["releasesPerPage"]) { // $more=1; // break; // } } $output.= "

    ".$row["statusName"]."

    "; if (($GLOBALS["directoryBios"]=="1")&&(strlen(trim($row["bio"]))>0)) { $output.= ""; $output.=$row["fullName"].$credentials."\n"; } else { $output.=$row["fullName"].$credentials."\n"; } $output.=""; if (strlen($titles)>0) {$output.="
      ".$titles."
    ";} $output.="
    "; if (strlen($row["email"])>0) $output.="Send E-mail
    "; if (strlen($row["address"])>0) $output.=$row["address"]."
    "; if (strlen($row["phone"])>0) $output.=$row["phone"]; $output.="
    "; if (strlen($row["phone"])>0) $output.=$row["focus"]; $output.="
    "; // Generate Pagination Output if (($page+$more)>0) $pagination.= "View: "; if ($page>0) { $pagination.= "Newer Releases"; } if (($page>0)&&($more>0)) $pagination.=" | "; if ($more>0) { $pagination.= "Older Releases"; } if (strlen($pagination)>0) $pagination="
    ".$pagination."
    \n"; $anchorOutput=""; // Generate Anchors Output for ($i=0; $i<26; $i++) { if($anchors[$i]>0) { $anchorOutput.=""; $anchorOutput.=strtoupper(chr($i+97))." - "; } } $anchorOutput=substr($anchorOutput,0,strlen($anchorOutput)-3); if ((strlen($anchorOutput)>0)&&(strlen($_GET["status"])>0)) { echo "

    Jump to: ".$anchorOutput."

    \n"; } // output echo $pagination.$output.$pagination; } } // END FUNCTION showDirectory function getLargeImage($fn) { $lastChar=strrpos($fn, "/")+1; $output=substr($fn, 0, $lastChar).$GLOBALS["maxImageWidth"]."_".substr($fn, $lastChar); return $output; } function getTnImage($fn) { $lastChar=strrpos($fn, "/")+1; $output=substr($fn, 0, $lastChar)."tn_".substr($fn, $lastChar); return $output; } function outputTitle($in) { $in=preg_replace("/[^A-Za-z0-9\s\s+]/","",$in); $in=stripslashes(str_replace(" ","-",trim($in))); return $in; } function rssFileName ($title) { // TAKES TOPIC NAME AND RETURNS URL TO ITS RSS FEED $filename=strtolower(str_replace(" ", "", $title)); $filename=$GLOBALS["baseRSSURL"].$GLOBALS["shortName"]."-".$filename.".xml"; return $filename; } // RSS PARSER FUNCTIONS function startElement($parser, $name, $attrs) { global $rss_channel, $currently_writing, $main; switch($name) { case "RSS": case "RDF:RDF": case "ITEMS": $currently_writing = ""; break; case "CHANNEL": $main = "CHANNEL"; break; case "IMAGE": $main = "IMAGE"; $rss_channel["IMAGE"] = array(); break; case "ITEM": $main = "ITEMS"; break; default: $currently_writing = $name; break; } } function endElement($parser, $name) { global $rss_channel, $currently_writing, $item_counter; $currently_writing = ""; if ($name == "ITEM") { $item_counter++; } } function characterData($parser, $data) { global $rss_channel, $currently_writing, $main, $item_counter; if ($currently_writing != "") { switch($main) { case "ITEMS": if (isset($rss_channel[$main][$item_counter][$currently_writing])) { $rss_channel[$main][$item_counter][$currently_writing] .= $data; } else { //print ("rss_channel[$main][$item_counter][$currently_writing] = $data
    "); $rss_channel[$main][$item_counter][$currently_writing] = $data; } break; } } } function curl_string ($url,$user_agent='Mozilla 4.0'){ $ch = curl_init(); curl_setopt ($ch, CURLOPT_URL, $url); curl_setopt ($ch, CURLOPT_USERAGENT, $user_agent); curl_setopt ($ch, CURLOPT_HEADER, 0); curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt ($ch, CURLOPT_FOLLOWLOCATION, 1); curl_setopt ($ch, CURLOPT_TIMEOUT, 120); $result = curl_exec ($ch); curl_close($ch); return $result; } // END RSS PARSER FUNCTIONS function showRSS ($file, $nr_news, $displayHeadline, $class, $moreLink) { global $rss_channel, $currently_writing, $main, $item_counter; $rss_channel = array(); $currently_writing = ""; $main = ""; $item_counter = 0; $xml_parser = xml_parser_create(); xml_set_element_handler($xml_parser, "startElement", "endElement"); xml_set_character_data_handler($xml_parser, "characterData"); /* if (!($fp = fopen($file, "r"))) { die("could not open XML input"); } /* while ($data = fread($fp, 4096)) { if (!xml_parse($xml_parser, $data, feof($fp))) { die(sprintf("XML error: %s at line %d", xml_error_string(xml_get_error_code($xml_parser)), xml_get_current_line_number($xml_parser))); } } */ $data=curl_string($file); xml_parse($xml_parser,$data); xml_parser_free($xml_parser); // putting in array $news=array(); if (isset($rss_channel["ITEMS"])) { if (count($rss_channel["ITEMS"]) > 0) for($i = 0;$i < count($rss_channel["ITEMS"]);$i++) $news[]=$rss_channel["ITEMS"][$i]; } $c=0; foreach($news as $key=>$val) { if($c<$nr_news) { $output.= '
  • '.$val['TITLE'].'
    '.date("l, F j",strtotime($val['PUBDATE'])).'
  • '; } $c++; } if (strlen($output)>0) { $GLOBALS[$class].="\n\t\t

    ".$displayHeadline."

    \n\t\t"; $output.="More news"; if (strlen($moreLink)>0) { $GLOBALS[$class].="more";} $GLOBALS[$class].="\n\t\t
    \n"; } } // end RSS PARSER function listTopics($count, $headline, $class) { // List releases by category // List releases by category $sql="select count(*) as numReleases, topicAssignments.topicID, topics.topicName from topicAssignments, topics WHERE topicAssignments.topiciD=topics.topicID AND topics.departmentID=".$GLOBALS["department"]." GROUP BY topicID ORDER BY topics.topicName"; // $sql="select topics.topicID, topics.topicName from topics WHERE topics.departmentID=".$GLOBALS["department"]." ORDER BY topics.topicName LIMIT 0, ".$count; $aResult = mysql_query($sql); $aRows = mysql_num_rows($aResult); $output=""; if ($aRows>0) $output="

    ".$headline."

    \n\n"; $GLOBALS[$class].="\n\t\t
    \n\t\t".$output."\n\t\t
    \n"; } //FOR INTEGRATION WITH IUPUI MOBILE SITE function releaseDisplayXML ($id) { $today=date('Ymd'); $sql="select releases.date, releases.headline, releases.copy FROM releases WHERE id=".mysql_real_escape_string(filter_var($id, FILTER_SANITIZE_NUMBER_INT))." AND releases.date<=".$today; $qResult = mysql_query($sql); $nRows = mysql_num_rows($qResult); if ($nRows==0) { return 0; } else { // DISPLAY RELEASE $row = mysql_fetch_array($qResult); // FIND RELATED IMAGES $sql="SELECT thumbnailAssignments.thumbnailName, caption, highres FROM thumbnailAssignments, thumbnails WHERE thumbnailAssignments.releaseID=".mysql_real_escape_string(filter_var($id, FILTER_SANITIZE_NUMBER_INT))." AND thumbnailAssignments.thumbnailName=thumbnails.thumbnailName"; $yResult = mysql_query($sql); $yRows = mysql_num_rows($yResult); $image=""; $caption=""; $output="\n"; for ($i=0; $i<$yRows; $i++) { $yrow = mysql_fetch_array($yResult); $image=$GLOBALS["baseImageURL"]."100_".$yrow["thumbnailName"]; $caption=$yrow["caption"]; break; } $output.="\n".$row["headline"]."\n"; $output.="".humanDate($row["date"])."\n"; $output.="".$image."\n"; $output.="".$caption."\n"; $copyOut=""; $copy=strip_tags($row["copy"]); $array = explode("\r\n",$copy); global $htmlEnts,$htmlDec; foreach($array as $char) { $copyOut.=str_replace($htmlEnts,$htmlDec,$char)."\n"; // $copyOut.=str_replace ( array ( '&', '"', "'", '<', '>', '?' ), array ( ord('&') , ord('"'), ord("'") , ord('<') , ord('>'), ord('?') ), $char)."\n"; // $copyOut.=urlencode($char)."\n"; } $output.="".$copyOut."\n"; // $output.="".htmlentities(strip_tags($row["copy"]))."\n"; $output.="\n"; echo $output; } } //FOR INTEGRATION WITH IUPUI MOBILE SITE function releaseListXML ($page=0,$topic=0,$count=10) { // DETERMINE PAGINATION $introText=""; $whereClause=""; // DETERMINE TYPE - BY TOPIC, PEOPLE, OR ALL? $querystring="topic=".$_GET["topic"]."&all=".$_GET["all"]; if (strlen($_GET["topic"])>0) { $whereClause=", topicAssignments WHERE releases.id=topicAssignments.releaseID AND topicAssignments.topicID=".mysql_real_escape_string(filter_var($_GET["topic"], FILTER_SANITIZE_NUMBER_INT)); } if (strlen($whereClause)>0) { $whereClause.=" AND"; } else { $whereClause.=" WHERE"; } $today=date('Ymd'); $whereClause.=" releases.departmentID=".$GLOBALS["department"]." AND releases.date<=".$today." "; // BUILD MASTER QUERY $sql="select releases.id, releases.date, releases.headline FROM releases ".$whereClause." ORDER BY date DESC, id DESC LIMIT ".($page*10).",10"; $qResult = mysql_query($sql); $nRows = mysql_num_rows($qResult); if ($nRows==0) { return 0; } $more=0; $output=""; for ($i=0; $i<$nRows; $i++) { $row = mysql_fetch_array($qResult); // Get Image $sql="SELECT thumbnailAssignments.thumbnailName, caption, highres FROM thumbnailAssignments, thumbnails WHERE releaseID=".$row["id"]." AND thumbnailAssignments.thumbnailName=thumbnails.thumbnailName LIMIT 1"; $imgResult=mysql_query($sql); $output.="\n"; $output.= "\t".$row["id"]."\n"; $output.= "\t"; if (mysql_num_rows($imgResult)>0) { $imgRow=mysql_fetch_array($imgResult); $output.=$GLOBALS["baseImageURL"]."40_sq_".$imgRow["thumbnailName"]; } $output.="\n"; $output.="\t".$row["headline"]."\n\n"; } echo "\n".$output.""; } global $htmlEnts,$htmlDec; $htmlEnts=array( ' ', '"', '–', '—', '»', '‘', '’', '“', '”', '•', '¡', '¢', '£', '¤', '¥', '¦', '§', '¨', '©', 'ª', '«', '¬', '­', '®', '¯', '°', '±', '²', '³', '´', 'µ', '¶', '·', '¸', '¹', 'º', '»', '¼', '½', '¾', '¿', 'À', 'Á', 'Â', 'Ã', 'Ä', 'Å', 'Æ', 'Ç', 'È', 'É', 'Ê', 'Ë', 'Ì', 'Í', 'Î', 'Ï', 'Ð', 'Ñ', 'Ò', 'Ó', 'Ô', 'Õ', 'Ö', '×', 'Ø', 'Ù', 'Ú', 'Û', 'Ü', 'Ý', 'Þ', 'ß', 'à', 'á', 'â', 'ã', 'ä', 'å', 'æ', 'ç', 'è', 'é', 'ê', 'ë', 'ì', 'í', 'î', 'ï', 'ð', 'ñ', 'ò', 'ó', 'ô', 'õ', 'ö', '÷', 'ø', 'ù', 'ú', 'û', 'ü', 'ý', 'þ', 'ÿ'); $htmlDec=array( ' ', '"', '-', '-', ''', ''', ''', '"', '"', '•', '¡', '¢', '£', '¤', '¥', '¦', '§', '¨', '©', 'ª', '«', '¬', '­', '®', '¯', '°', '±', '²', '³', '´', 'µ', '¶', '·', '¸', '¹', 'º', '»', '¼', '½', '¾', '¿', 'À', 'Á', 'Â', 'Ã', 'Ä', 'Å', 'Æ', 'Ç', 'È', 'É', 'Ê', 'Ë', 'Ì', 'Í', 'Î', 'Ï', 'Ð', 'Ñ', 'Ò', 'Ó', 'Ô', 'Õ', 'Ö', '×', 'Ø', 'Ù', 'Ú', 'Û', 'Ü', 'Ý', 'Þ', 'ß', 'à', 'á', 'â', 'ã', 'ä', 'å', 'æ', 'ç', 'è', 'é', 'ê', 'ë', 'ì', 'í', 'î', 'ï', 'ð', 'ñ', 'ò', 'ó', 'ô', 'õ', 'ö', '÷', 'ø', 'ù', 'ú', 'û', 'ü', 'ý', 'þ', 'ÿ');