Reviewed

"; $project_joomla = mysql_query("SELECT jos_peerpaper.paper_id AS paperid, jos_peerpaper.paper_bibtex AS bibtex, jos_peerpaper.paper_link AS link FROM jos_peerpaper WHERE jos_peerpaper.publish LIKE '%J%' ORDER BY jos_peerpaper.paper_id DESC"); if (!$project_joomla) { die('Ungültige Abfrage: ' .mysql_error());} while ($row = mysql_fetch_array($project_joomla)) { $paper_id = $row['paperid']; $bibtex = $row['bibtex']; $link = $row['link']; $parse = NEW PARSEENTRIES(); $parse->loadBibtexString($bibtex); $parse->extractEntries(); list($preamble, $strings, $entries, $undefinedStrings) = $parse->returnArrays(); $order[0] = "author"; $order[1] = "title"; $order[2] = "booktitle"; $order[3] = "address"; $order[4] = "year"; $string = ""; foreach($order as $index => $bibfield) { foreach($entries[0] as $field => $content) { if(strcmp($field,$bibfield) == 0) { if(strcmp($field, "booktitle") == 0 && $content[0] != 'I' && $content[1] != 'n') $string .= "In "; $string .= $content; if($content !== "") { $string .= ". "; } } } } if($link === "") { $file_name = ""; if($row2 = mysql_fetch_array(mysql_query("SELECT jos_peerpaper_uploads.file_name AS filename FROM jos_peerpaper_uploads WHERE jos_peerpaper_uploads.paper_id ='{$paper_id}' AND jos_peerpaper_uploads.file_name LIKE '%.pdf'"))) { $file_name = $row2['filename']; } echo " " . $string; if(substr($file_name, -4) === ".pdf") { echo " (PDF)"; } } else { if($link !== "") { echo " " . $string; } else { echo "" . $string; } } if($bibtex != "") { $quotebibtex = $bibtex; if(strpos($quotebibtex, "\n") === FALSE) { $quotebibtex = str_replace("'", "\'", $quotebibtex); $quotebibtex = str_replace("},", "},\n", $quotebibtex); $quotebibtex = str_replace($entries[0]['bibtexCitation'] . ", ", $entries[0]['bibtexCitation'] . ",\n ", $quotebibtex); $quotebibtex = str_replace("} }", "}\n}", $quotebibtex); } echo "[bib]"; echo " ".$quotebibtex." "; } if($line == "") { echo ""; } else { echo " "; } echo "\n"; } echo "

"; echo "

Students' Projects

"; $project_joomla = mysql_query("SELECT jos_papers.paper_id AS paperid, jos_papers.paper_description AS description, jos_paper_types.type_description AS type, jos_employees.first_name AS firstname, jos_employees.last_name AS lastname FROM jos_papers, jos_paper_types, jos_employees, jos_employees_papers WHERE jos_papers.paper_status = 4 AND jos_papers.publish LIKE '%J%' AND jos_papers.paper_type = jos_paper_types.type_id AND jos_employees.employee_id = jos_employees_papers.employee_id AND jos_papers.paper_id = jos_employees_papers.paper_id ORDER BY jos_papers.end_date DESC"); //$project_joomla = mysql_query("SELECT * FROM jos_papers, jos_paper_status, jos_paper_types WHERE jos_papers.paper_status = jos_paper_status.status_id AND jos_papers.paper_type = jos_paper_types.type_id AND jos_papers.publish LIKE '%J%' ORDER BY paper_id DESC"); if (!$project_joomla) { die('Ungültige Abfrage: ' .mysql_error());} while ($row = mysql_fetch_array($project_joomla)) { $paper_id = $row['paperid']; $head = $row['description']; $type = $row['type']; $author_firstname = $row['firstname']; $author_lastname = $row['lastname']; $file_name = ""; if($row2 = mysql_fetch_array(mysql_query("SELECT jos_papers_uploads.file_name AS filename FROM jos_papers_uploads WHERE jos_papers_uploads.paper_id ='{$paper_id}' AND jos_papers_uploads.file_name LIKE '%.pdf'"))) { $file_name = $row2['filename']; } if (substr($file_name, -4) == ".pdf" || $file_name == "") { echo " $head, $type, $author_firstname $author_lastname"; if(substr($file_name, -4) == ".pdf") {echo " (PDF)";} echo" "; } } echo"

"; echo "

Other

Publications from the Robocup Other reports/works from the Robocup

"; zFooter() ?>