~~NOCACHE~~
====== Publications ======

<php>

$mysqli = new mysqli("localhost", "itn", "RsKGJxbQnG9CSFb9", "itn");



/* check connection */

if (mysqli_connect_errno()) {

    printf("Connect failed: %s\n", mysqli_connect_error());

    exit();

}

$query = "SET NAMES 'utf8'";



$dummy = $mysqli->query($query);





$query = "SELECT af.artikkel, af.forfatter, af.arbeidsinnsats, a.id, a.publiseringsaar,
	a.kategori, a.overskrift_eng, a.publikasjonssted_eng, a.registrert,
	f.id, GROUP_CONCAT(f.fullt_navn ORDER BY af.arbeidsinnsats DESC SEPARATOR ', '),
	a.url
	FROM artikkel_forfattere AS af
	LEFT JOIN artikler AS a ON af.artikkel = a.id
	LEFT JOIN forfattere AS f ON af.forfatter = f.id
	GROUP BY af.artikkel ORDER BY a.publiseringsaar DESC, a.kategori ASC, a.registrert DESC";

#echo $query;



if ($result = $mysqli->query($query)) {
	#$dato = date("Y");
	$dato = 9999;
	$kategori = 0;
	#echo "<strong><a name=\"" . $dato. "\">" . $dato . "</a></strong><br>";
	echo "<!--";

    /* fetch object array */
    while ($row = $result->fetch_row()) {
        if ($row[4] < $dato) {
		echo "</ul><!-- --><ul>";
		echo "<strong style='font-size: 150%;'><a name=\"" . $row[4]. "\">" . $row[4]. "</a></strong><br>";
		$dato = $row[4];
		$kategori = 0;
        }



          if ($row[5] != $kategori) {

            $kategori = $row[5];



            switch ($kategori) {

            	// Book chapter

            	case 1:
            		echo "</ul>";
          			echo "<em>Book chapters:<br></em>";
          			echo "\n<ul>\n\t";
          			#echo "\n\t<li class=\"level1\"><div class=\"li\"><strong>" . $row[10] . "</strong> " . $row[6] . " <i>" . $row[7] . "</i>, " . $row[4] . ".";
            	  echo "\n\t<li class=\"level1\"><div class=\"li\"><strong> ".$row[10]." </strong> ".$row[6]." <i> ".$row[7]." </i>, ".$row[4].".<br>\n\t".
			($row[11] ?"\tURL: <a target='_blank' href='".$row[11]."'>".$row[11]."</a>" :"");

          			break;

		// Journals

            	case 2:
            	  echo "</ul>";
            	  echo "<em>Journals:<br></em>";
            	  echo "\n<ul>\n\t";
            	  #echo "\n\t<li class=\"level1\"><div class=\"li\"><strong>" . $row[10] . "</strong> " . $row[6] . " <i>" . $row[7] . "</i>, " . $row[4] . ".";
            	  echo "\n\t<li class=\"level1\"><div class=\"li\"><strong> ".$row[10]." </strong> ".$row[6]." <i> ".$row[7]." </i>, ".$row[4].".<br>\n\t".
	($row[11] ?"\tURL: <a target='_blank' href='".$row[11]."'>".$row[11]."</a>" :"");

            	  break;

            	case 3:
            	  echo "</ul>";
            	  echo "<em>Conference papers: <br></em>";
            	  echo "\n<ul>\n\t";
            	  #echo "\n\t<li class=\"level1\"><div class=\"li\"><strong>" . $row[10] . "</strong> " . $row[6] . " <i>" . $row[7] . "</i>, " . $row[4] . ".</div>";
            	  echo "\n\t<li class=\"level1\"><div class=\"li\"><strong> ".$row[10]." </strong> ".$row[6]." <i> ".$row[7]." </i>, ".$row[4].".<br>\n\t".
	($row[11] ?"\tURL: <a target='_blank' href='".$row[11]."'>".$row[11]."</a>" :"");

            	  break;

            	case 4:
            	  echo "</ul>";
            	  echo "<em>Book:</em>";
            	  echo "\n<ul>\n\t";
            	  echo "\n\t<li class=\"level1\"><div class=\"li\"><strong> ".$row[10]." </strong> ".$row[6]." <i> ".$row[7]." </i>, ".$row[4].".<br>\n\t".
	($row[11] ?"\tURL: <a target='_blank' href='".$row[11]."'>".$row[11]."</a>" :"");
            	  break;
            	case 5:
            	  echo "</ul>";
            	  echo "<em>Patent:</em>";
            	  echo "\n<ul>\n\t";
            	  echo "\n\t<li class=\"level1\"><div class=\"li\"><strong> ".$row[10]." </strong> ".$row[6]." <i> ".$row[7]." </i>, ".$row[4].".<br>\n\t".
	($row[11] ?"\tURL: <a target='_blank' href='".$row[11]."'>".$row[11]."</a>" :"");
            	  break;
            	case 6:
            	  echo "</ul>";
            	  echo "<em>Technical report:</em>";
            	  echo "\n<ul>\n\t";
            	  echo "\n\t<li class=\"level1\"><div class=\"li\"><strong> ".$row[10]." </strong> ".$row[6]." <i> ".$row[7]." </i>, ".$row[4].".<br>\n\t".
	($row[11] ?"\tURL: <a target='_blank' href='".$row[11]."'>".$row[11]."</a>" :"");
            	  break;

            }

          } else {

#            echo "\n\t<li class=\"level1\"><div class=\"li\"><strong>" . $row[10] . "</strong> " . $row[6] . " <i>" . $row[7] . "</i>, " . $row[4] . ".";
		echo "\n\t<li class=\"level1\"><div class=\"li\"><strong> ".$row[10]." </strong> ".$row[6]." <i> ".$row[7]." </i>, ".$row[4].".<br>\n\t".
	($row[11] ?"\tURL: <a target='_blank' href='".$row[11]."'>".$row[11]."</a>" :"");
        }

    }

	echo "<!-- -->";



    /* free result set */

    $result->close();

}



/* close connection */

$mysqli->close();

</php>