Daniel Vogler Publications

Dr. Daniel Vogler

Senior Research Assistant

daniel_vogler_234x323

Mailing Address
Dr. Daniel Vogler
Geothermal Energy & Geofluids
Institute of Geophysics
NO F 61
Sonneggstrasse 5
CH-8092 Zurich Switzerland

Contact
Phone +41 44 633 27 51
Email davogler(at)ethz.ch

Administration
Dominique Ballarin Dolfin
Phone +41 44 632 3465
Email ballarin(at)ethz.ch

Publications

A complete overview can be found here

[insert_php] $max_authors = 10;
$input_lastname = “Vogler”;
$year_choice= “all_years”; /* kann die Werte some_years oder all_years haben */
$author_firstname = “Daniel”;
$author_lastname = “Vogler”;
global $wpdb;
/* wpdb class should not be called directly.global $wpdb variable is an instantiation of the class already set up to talk to the WordPress database */
/* SELECT * FROM geg_publications_new */
$sqlabf = “SELECT * FROM geg_pub_inf INNER JOIN geg_pub_aut ON geg_pub_inf.id_aut=geg_pub_aut.id”;

$sqlabf .= ” WHERE ((author_1_lastname = ‘$author_lastname’) AND (author_1_firstname = ‘$author_firstname’)”;
for ($x = 2; $x <= $max_authors; $x++) { $sqlabf .= " OR (author_" . $x . "_lastname = '$author_lastname') AND (author_" . $x . "_firstname = '$author_firstname')"; } $sqlabf .= ")"; $sqlabf .= " ORDER BY type_year DESC"; /*echo $sqlabf; */ /* ------------------------ WRITE OUTPUT DATA ON WEBSITE ------------------------- */ /*multiple row results can be pulled from the database with get_results function and outputs an object which is stored in $result */ $result = $wpdb->get_results($sqlabf);

/* If you require you may print and view the contents of $result object */
/* echo “

"; print_r($result); echo "

“; */

/* ——————– OUTPUT OF REFEREED PUBLICATIONS IN JOURNALS —————- */

$nr_refpub = 0;
foreach($result as $row)
{
if (($row->type == ‘Refereed Publications in Journals’) AND (($row->publicationstatus == ‘Accepted’) OR ($row->publicationstatus == ‘Published’))) {
$nr_refpub = $nr_refpub + 1;
}
}

// echo “
number of rows of ref publications is ” . $nr_refpub;

$e = $nr_refpub +1;
//echo $e;
foreach($result as $row)
{
if (($row->type == ‘Refereed Publications in Journals’) AND (($row->publicationstatus == ‘Accepted’) OR ($row->publicationstatus == ‘Published’))) {
if ($e == $nr_refpub +1) {
echo “

REFEREED PUBLICATIONS IN JOURNALS

“;
echo “

“;
}
for ($d = 2; $d <= $max_authors; $d++) { $varln="author_".$d."_lastname"; $varfi="author_".$d."_firstinitial"; if ($row->$varln == “”)
{
/* echo “
” . $d; */
break;
}
}

$e = $e – 1;
$c = $d – 1; /* anzahl der autoren */
echo “

“;
if ($row->author_1_lastname) {
echo “

“;

/* echo “, Database ID: ” . $row->iid . ““; */

/* echo “ ” . $row->type . “
“; */

} /* end proceedings refereed */
} /* end foreach */
echo “

” . $e . “.  ” . $row->author_1_lastname . “, ” . htmlentities($row->author_1_firstinitial) . ““;
}
for ($j = 2; $j < $c; $j++) { $varln="author_".$j."_lastname"; $varfi="author_".$j."_firstinitial"; // echo $var; /* echo " BEGIN testtest " . $row->$var . ” END “; */
if ($row->$varln != “”)
{
echo “” . “, ” . $row->$varfi . ” ” . $row->$varln . ““;
}
} /* end for */

if ($c != 1)
{
$varln_lastauthor_lastname=”author_”.$c.”_lastname”;
$varln_lastauthor_firstname=”author_”.$c.”_firstname”;
$varln_lastauthor_firstinitial=”author_”.$c.”_firstinitial”;
echo “, and ” . $row->$varln_lastauthor_firstinitial . ” ” . $row->$varln_lastauthor_lastname . ““;
}

if ($row->title) {
echo “” . ” ” . $row->title . ““;
}

if ($row->type_name) {
echo “” . “, ” . $row->type_name . ““;
}
else {
}

if ($row->type_vol) {
echo “” . “, ” . $row->type_vol . ““;
}
else {
}

if ($row->type_nr) {
echo “” . “/” . $row->type_nr . ““;
}
else {
}

if ($row->startpage) {
echo “” . “, pp. ” . $row->startpage . ““;
}
else {
}

if ($row->endpage) {
echo “” . “-” . $row->endpage . ““;
}
else {
}

if ($row->publicationstatus == ‘Accepted’) {
echo “, ” . ” (in press). “;
}
else {
echo “, ” . $row->type_year . “. “;
}

if ($row->abstract) {
echo “Abstract

” . $row->abstract . “
“;
}
else {
echo “”;
}

if ($row->doi) {
$doi_url = “http://dx.doi.org/” . $row->doi;
/* echo “doi_url is ” . $doi_url; */
echo “ / Download“;
}
elseif ($row->url_nodoi) {
$url_nodoi = $row->url_nodoi;
/* echo “url nodoi is ” . $url_nodoi; */
echo “ / Download“;
}
else {
/* echo “no download ?”; */
/* echo “ no_download“; */
}

echo “

“;

/* —————————- OUTPUT OF PROCEEDINGS REFEREED ———————— */

$nr_refproc = 0;
foreach($result as $row)
{
if (($row->type == ‘Proceedings Refereed’) AND (($row->publicationstatus == ‘Accepted’) OR ($row->publicationstatus == ‘Published’))) {
$nr_refproc = $nr_refproc + 1;
}
}
// echo “
number of rows of ref proceedings is ” . $nr_refproc;

$e = $nr_refproc +1;
foreach($result as $row)
{
if (($row->type == ‘Proceedings Refereed’) AND (($row->publicationstatus == ‘Accepted’) OR ($row->publicationstatus == ‘Published’))) {
if ($e == $nr_refproc +1) {
echo “

PROCEEDINGS REFEREED

“;
echo “

“;
}
for ($d = 2; $d <= $max_authors; $d++) { $varln="author_".$d."_lastname"; $varfi="author_".$d."_firstinitial"; if ($row->$varln == “”)
{
/* echo “
” . $d; */
break;
}
}

$e = $e – 1;
$c = $d – 1; /* anzahl der autoren */
echo “

“;
if ($row->author_1_lastname) {
echo “

“;

/* echo “, Database ID: ” . $row->iid . ““; */

/* echo “ ” . $row->type . “
“; */

} /* end proceedings refereed */
} /* end foreach */
echo “

” . $e . “.  ” . $row->author_1_lastname . “, ” . htmlentities($row->author_1_firstinitial) . ““;
}
for ($j = 2; $j < $c; $j++) { $varln="author_".$j."_lastname"; $varfi="author_".$j."_firstinitial"; // echo $var; /* echo " BEGIN testtest " . $row->$var . ” END “; */
if ($row->$varln != “”)
{
echo “” . “, ” . $row->$varfi . ” ” . $row->$varln . ““;
}
} /* end for */

if ($c != 1)
{
$varln_lastauthor_lastname=”author_”.$c.”_lastname”;
$varln_lastauthor_firstname=”author_”.$c.”_firstname”;
$varln_lastauthor_firstinitial=”author_”.$c.”_firstinitial”;
echo “, and ” . $row->$varln_lastauthor_firstinitial . ” ” . $row->$varln_lastauthor_lastname . ““;
}

if ($row->title) {
echo “” . ” ” . $row->title . ““;
}

if ($row->type_name) {
echo “” . “, ” . $row->type_name . ““;
}
else {
}

if ($row->type_vol) {
echo “” . “, ” . $row->type_vol . ““;
}
else {
}

if ($row->type_nr) {
echo “” . “/” . $row->type_nr . ““;
}
else {
}

if ($row->startpage) {
echo “” . “, pp. ” . $row->startpage . ““;
}
else {
}

if ($row->endpage) {
echo “” . “-” . $row->endpage . ““;
}
else {
}

if ($row->publicationstatus == ‘Accepted’) {
echo “, ” . ” (in press). “;
}
else {
echo “, ” . $row->type_year . “. “;
}

if ($row->abstract) {
echo “Abstract

” . $row->abstract . “
“;
}
else {
echo “”;
}

if ($row->doi) {
$doi_url = “http://dx.doi.org/” . $row->doi;
/* echo “doi_url is ” . $doi_url; */
echo “ / Download“;
}
elseif ($row->url_nodoi) {
$url_nodoi = $row->url_nodoi;
/* echo “url nodoi is ” . $url_nodoi; */
echo “ / Download“;
}
else {
/* echo “no download ?”; */
/* echo “ no_download“; */
}

echo “

“;

/* —————————- OUTPUT OF THESES ———————— */

$nr_theses = 0;
foreach($result as $row)
{
if (($row->type == ‘Theses PhD’) OR ($row->type == ‘Theses MSc’) OR ($row->type == ‘Theses Habil.’)) {
$nr_theses = $nr_theses + 1;
}
}
// echo “
number of rows of ref publications is ” . $nr_theses;

$e = $nr_theses +1;
foreach($result as $row)
{
if (($row->type == ‘Theses PhD’) OR ($row->type == ‘Theses MSc’) OR ($row->type == ‘Theses Habil.’)) {
if ($e == $nr_theses +1) {
echo “

THESES

“;
echo “

“;
}
for ($d = 2; $d <= $max_authors; $d++) { $varln="author_".$d."_lastname"; $varfi="author_".$d."_firstinitial"; if ($row->$varln == “”)
{
/* echo “
” . $d; */
break;
}
}

$e = $e – 1;
$c = $d – 1; /* anzahl der autoren */
echo “

“;
if ($row->author_1_lastname) {
echo “

“;

/* echo “, Database ID: ” . $row->iid . ““; */

/* echo “ ” . $row->type . “
“; */

} /* end proceedings refereed */
} /* end foreach */
echo “

” . $e . “.  ” . $row->author_1_lastname . “, ” . htmlentities($row->author_1_firstinitial) . ““;
}
for ($j = 2; $j < $c; $j++) { $varln="author_".$j."_lastname"; $varfi="author_".$j."_firstinitial"; // echo $var; /* echo " BEGIN testtest " . $row->$var . ” END “; */
if ($row->$varln != “”)
{
echo “” . “, ” . $row->$varfi . ” ” . $row->$varln . ““;
}
} /* end for */

if ($c != 1)
{
$varln_lastauthor_lastname=”author_”.$c.”_lastname”;
$varln_lastauthor_firstname=”author_”.$c.”_firstname”;
$varln_lastauthor_firstinitial=”author_”.$c.”_firstinitial”;
echo “, and ” . $row->$varln_lastauthor_firstinitial . ” ” . $row->$varln_lastauthor_lastname . ““;
}

if ($row->title) {
echo “” . ” ” . $row->title . ““;
}

if ($row->type == “Theses MSc”) {
echo “” . “, MSc Thesis“;
}
if ($row->type == “Theses PhD”) {
echo “” . “, Dissertation“;
}
if ($row->type == “Theses Habil.”) {
echo “” . “, Habil. Thesis“;
}

if ($row->type_publisher) {
echo “ ” . ” ” . $row->type_publisher . ““;
}
else {
}

if (($row->total_pages != 0) OR ($row->total_pages == “”)) {
echo “, ” . $row->total_pages . ” pp.“;
}

if ($row->type_year) {
echo “, ” . $row->type_year . “. “;
}

if ($row->abstract) {
echo “Abstract

” . $row->abstract . “
“;
}
else {
echo “”;
}

if ($row->doi) {
$doi_url = “http://dx.doi.org/” . $row->doi;
/* echo “doi_url is ” . $doi_url; */
echo “ / Download“;
}
elseif ($row->url_nodoi) {
$url_nodoi = $row->url_nodoi;
/* echo “url nodoi is ” . $url_nodoi; */
echo “ / Download“;
}
else {
/* echo “no download ?”; */
/* echo “ no_download“; */
}

echo “

“;

[/insert_php]

show/hide list of publications
[insert_php] $max_authors = 10;
$input_lastname = “Vogler”;
$year_choice= “all_years”; /* kann die Werte some_years oder all_years haben */
$author_firstname = “Daniel”;
$author_lastname = “Vogler”;
global $wpdb;
/* wpdb class should not be called directly.global $wpdb variable is an instantiation of the class already set up to talk to the WordPress database */
/* SELECT * FROM geg_publications_new */
$sqlabf = “SELECT * FROM geg_pub_inf INNER JOIN geg_pub_aut ON geg_pub_inf.id_aut=geg_pub_aut.id”;

$sqlabf .= ” WHERE ((author_1_lastname = ‘$author_lastname’) AND (author_1_firstname = ‘$author_firstname’)”;
for ($x = 2; $x <= $max_authors; $x++) { $sqlabf .= " OR (author_" . $x . "_lastname = '$author_lastname') AND (author_" . $x . "_firstname = '$author_firstname')"; } $sqlabf .= ")"; $sqlabf .= " ORDER BY type_year DESC"; /*echo $sqlabf; */ /* ------------------------ WRITE OUTPUT DATA ON WEBSITE ------------------------- */ /*multiple row results can be pulled from the database with get_results function and outputs an object which is stored in $result */ $result = $wpdb->get_results($sqlabf);

/* If you require you may print and view the contents of $result object */
/* echo “

"; print_r($result); echo "

“; */

/* ——————– OUTPUT OF REFEREED PUBLICATIONS IN JOURNALS —————- */

$nr_refpub = 0;
foreach($result as $row)
{
if (($row->type == ‘Refereed Publications in Journals’) AND (($row->publicationstatus == ‘Accepted’) OR ($row->publicationstatus == ‘Published’))) {
$nr_refpub = $nr_refpub + 1;
}
}

// echo “
number of rows of ref publications is ” . $nr_refpub;

$e = $nr_refpub +1;
//echo $e;
foreach($result as $row)
{
if (($row->type == ‘Refereed Publications in Journals’) AND (($row->publicationstatus == ‘Accepted’) OR ($row->publicationstatus == ‘Published’))) {
if ($e == $nr_refpub +1) {
echo “

REFEREED PUBLICATIONS IN JOURNALS

“;
echo “

“;
}
for ($d = 2; $d <= $max_authors; $d++) { $varln="author_".$d."_lastname"; $varfi="author_".$d."_firstinitial"; if ($row->$varln == “”)
{
/* echo “
” . $d; */
break;
}
}

$e = $e – 1;
$c = $d – 1; /* anzahl der autoren */
echo “

“;
if ($row->author_1_lastname) {
echo “

“;

/* echo “, Database ID: ” . $row->iid . ““; */

/* echo “ ” . $row->type . “
“; */

} /* end proceedings refereed */
} /* end foreach */
echo “

” . $e . “.  ” . $row->author_1_lastname . “, ” . htmlentities($row->author_1_firstinitial) . ““;
}
for ($j = 2; $j < $c; $j++) { $varln="author_".$j."_lastname"; $varfi="author_".$j."_firstinitial"; // echo $var; /* echo " BEGIN testtest " . $row->$var . ” END “; */
if ($row->$varln != “”)
{
echo “” . “, ” . $row->$varfi . ” ” . $row->$varln . ““;
}
} /* end for */

if ($c != 1)
{
$varln_lastauthor_lastname=”author_”.$c.”_lastname”;
$varln_lastauthor_firstname=”author_”.$c.”_firstname”;
$varln_lastauthor_firstinitial=”author_”.$c.”_firstinitial”;
echo “, and ” . $row->$varln_lastauthor_firstinitial . ” ” . $row->$varln_lastauthor_lastname . ““;
}

if ($row->title) {
echo “” . ” ” . $row->title . ““;
}

if ($row->type_name) {
echo “” . “, ” . $row->type_name . ““;
}
else {
}

if ($row->type_vol) {
echo “” . “, ” . $row->type_vol . ““;
}
else {
}

if ($row->type_nr) {
echo “” . “/” . $row->type_nr . ““;
}
else {
}

if ($row->startpage) {
echo “” . “, pp. ” . $row->startpage . ““;
}
else {
}

if ($row->endpage) {
echo “” . “-” . $row->endpage . ““;
}
else {
}

if ($row->publicationstatus == ‘Accepted’) {
echo “, ” . ” (in press). “;
}
else {
echo “, ” . $row->type_year . “. “;
}

if ($row->abstract) {
echo “Abstract

” . $row->abstract . “
“;
}
else {
echo “”;
}

if ($row->doi) {
$doi_url = “http://dx.doi.org/” . $row->doi;
/* echo “doi_url is ” . $doi_url; */
echo “ / Download“;
}
elseif ($row->url_nodoi) {
$url_nodoi = $row->url_nodoi;
/* echo “url nodoi is ” . $url_nodoi; */
echo “ / Download“;
}
else {
/* echo “no download ?”; */
/* echo “ no_download“; */
}

echo “

“;

/* —————————- OUTPUT OF PROCEEDINGS REFEREED ———————— */

$nr_refproc = 0;
foreach($result as $row)
{
if (($row->type == ‘Proceedings Refereed’) AND (($row->publicationstatus == ‘Accepted’) OR ($row->publicationstatus == ‘Published’))) {
$nr_refproc = $nr_refproc + 1;
}
}
// echo “
number of rows of ref proceedings is ” . $nr_refproc;

$e = $nr_refproc +1;
foreach($result as $row)
{
if (($row->type == ‘Proceedings Refereed’) AND (($row->publicationstatus == ‘Accepted’) OR ($row->publicationstatus == ‘Published’))) {
if ($e == $nr_refproc +1) {
echo “

PROCEEDINGS REFEREED

“;
echo “

“;
}
for ($d = 2; $d <= $max_authors; $d++) { $varln="author_".$d."_lastname"; $varfi="author_".$d."_firstinitial"; if ($row->$varln == “”)
{
/* echo “
” . $d; */
break;
}
}

$e = $e – 1;
$c = $d – 1; /* anzahl der autoren */
echo “

“;
if ($row->author_1_lastname) {
echo “

“;

/* echo “, Database ID: ” . $row->iid . ““; */

/* echo “ ” . $row->type . “
“; */

} /* end proceedings refereed */
} /* end foreach */
echo “

” . $e . “.  ” . $row->author_1_lastname . “, ” . htmlentities($row->author_1_firstinitial) . ““;
}
for ($j = 2; $j < $c; $j++) { $varln="author_".$j."_lastname"; $varfi="author_".$j."_firstinitial"; // echo $var; /* echo " BEGIN testtest " . $row->$var . ” END “; */
if ($row->$varln != “”)
{
echo “” . “, ” . $row->$varfi . ” ” . $row->$varln . ““;
}
} /* end for */

if ($c != 1)
{
$varln_lastauthor_lastname=”author_”.$c.”_lastname”;
$varln_lastauthor_firstname=”author_”.$c.”_firstname”;
$varln_lastauthor_firstinitial=”author_”.$c.”_firstinitial”;
echo “, and ” . $row->$varln_lastauthor_firstinitial . ” ” . $row->$varln_lastauthor_lastname . ““;
}

if ($row->title) {
echo “” . ” ” . $row->title . ““;
}

if ($row->type_name) {
echo “” . “, ” . $row->type_name . ““;
}
else {
}

if ($row->type_vol) {
echo “” . “, ” . $row->type_vol . ““;
}
else {
}

if ($row->type_nr) {
echo “” . “/” . $row->type_nr . ““;
}
else {
}

if ($row->startpage) {
echo “” . “, pp. ” . $row->startpage . ““;
}
else {
}

if ($row->endpage) {
echo “” . “-” . $row->endpage . ““;
}
else {
}

if ($row->publicationstatus == ‘Accepted’) {
echo “, ” . ” (in press). “;
}
else {
echo “, ” . $row->type_year . “. “;
}

if ($row->abstract) {
echo “Abstract

” . $row->abstract . “
“;
}
else {
echo “”;
}

if ($row->doi) {
$doi_url = “http://dx.doi.org/” . $row->doi;
/* echo “doi_url is ” . $doi_url; */
echo “ / Download“;
}
elseif ($row->url_nodoi) {
$url_nodoi = $row->url_nodoi;
/* echo “url nodoi is ” . $url_nodoi; */
echo “ / Download“;
}
else {
/* echo “no download ?”; */
/* echo “ no_download“; */
}

echo “

“;

/* —————————- OUTPUT OF THESES ———————— */

$nr_theses = 0;
foreach($result as $row)
{
if (($row->type == ‘Theses PhD’) OR ($row->type == ‘Theses MSc’) OR ($row->type == ‘Theses Habil.’)) {
$nr_theses = $nr_theses + 1;
}
}
// echo “
number of rows of ref publications is ” . $nr_theses;

$e = $nr_theses +1;
foreach($result as $row)
{
if (($row->type == ‘Theses PhD’) OR ($row->type == ‘Theses MSc’) OR ($row->type == ‘Theses Habil.’)) {
if ($e == $nr_theses +1) {
echo “

THESES

“;
echo “

“;
}
for ($d = 2; $d <= $max_authors; $d++) { $varln="author_".$d."_lastname"; $varfi="author_".$d."_firstinitial"; if ($row->$varln == “”)
{
/* echo “
” . $d; */
break;
}
}

$e = $e – 1;
$c = $d – 1; /* anzahl der autoren */
echo “

“;
if ($row->author_1_lastname) {
echo “

“;

/* echo “, Database ID: ” . $row->iid . ““; */

/* echo “ ” . $row->type . “
“; */

} /* end proceedings refereed */
} /* end foreach */
echo “

” . $e . “.  ” . $row->author_1_lastname . “, ” . htmlentities($row->author_1_firstinitial) . ““;
}
for ($j = 2; $j < $c; $j++) { $varln="author_".$j."_lastname"; $varfi="author_".$j."_firstinitial"; // echo $var; /* echo " BEGIN testtest " . $row->$var . ” END “; */
if ($row->$varln != “”)
{
echo “” . “, ” . $row->$varfi . ” ” . $row->$varln . ““;
}
} /* end for */

if ($c != 1)
{
$varln_lastauthor_lastname=”author_”.$c.”_lastname”;
$varln_lastauthor_firstname=”author_”.$c.”_firstname”;
$varln_lastauthor_firstinitial=”author_”.$c.”_firstinitial”;
echo “, and ” . $row->$varln_lastauthor_firstinitial . ” ” . $row->$varln_lastauthor_lastname . ““;
}

if ($row->title) {
echo “” . ” ” . $row->title . ““;
}

if ($row->type == “Theses MSc”) {
echo “” . “, MSc Thesis“;
}
if ($row->type == “Theses PhD”) {
echo “” . “, Dissertation“;
}
if ($row->type == “Theses Habil.”) {
echo “” . “, Habil. Thesis“;
}

if ($row->type_publisher) {
echo “ ” . ” ” . $row->type_publisher . ““;
}
else {
}

if (($row->total_pages != 0) OR ($row->total_pages == “”)) {
echo “, ” . $row->total_pages . ” pp.“;
}

if ($row->type_year) {
echo “, ” . $row->type_year . “. “;
}

if ($row->abstract) {
echo “Abstract

” . $row->abstract . “
“;
}
else {
echo “”;
}

if ($row->doi) {
$doi_url = “http://dx.doi.org/” . $row->doi;
/* echo “doi_url is ” . $doi_url; */
echo “ / Download“;
}
elseif ($row->url_nodoi) {
$url_nodoi = $row->url_nodoi;
/* echo “url nodoi is ” . $url_nodoi; */
echo “ / Download“;
}
else {
/* echo “no download ?”; */
/* echo “ no_download“; */
}

echo “

“;

[/insert_php]


[insert_php] echo ”

“;
[/insert_php]