|
Order by: ".
($ord == "year" ?
""
:"")."Type".($ord == "year" ? "":"")." | ".
($ord != "year" ? "":"")."Year".($ord != "year" ? "":""));
$query = "SELECT $tb_publications.* FROM ".$tb_publications.
", $tb_pub_to_auth, $tb_authors WHERE $tb_authors.id='".
$author_id."' AND $tb_pub_to_auth.id_author='".$author_id.
"' AND $tb_pub_to_auth.id_pub=".$tb_publications.".id";
if ($ord == "year") {
$res = mysql_db_query($db_bibliography,
"SELECT DISTINCT $tb_publications.year FROM $tb_publications, $tb_authors, $tb_pub_to_auth WHERE $tb_authors.id='$author_id' AND $tb_pub_to_auth.id_author='$author_id' AND $tb_pub_to_auth.id_pub=$tb_publications.id ORDER BY year DESC;");
$prev='';$i=0;
if (mysql_num_rows($res) > 0){
while ($row = mysql_fetch_object($res)){
$next='';
$i++;
if ($i < mysql_num_rows($res)){
$roww=mysql_fetch_object($res);
$next=$roww->year;
mysql_data_seek($res, $i);
}
$querye = $query." AND ".$tb_publications.".year='".$row->year."';";
$ress = mysql_db_query($db_bibliography, $querye);
$start_elem += display_entries($ress, "year."\" title=\"All ".$publicationl."s ".(empty($row->year)?"with no year defined":"of year ".$row->year)."\">".$row->year."","", "", $start_elem, $prev, $next);
$prev=$row->year;
}
}
if (!empty($res)) mysql_free_result($res);
} else {
$next='';$prev='';
$res = mysql_db_query($db_bibliography, "SELECT DISTINCT $tb_publications.entry_type FROM $tb_publications, $tb_authors, $tb_pub_to_auth WHERE $tb_authors.id='$author_id' AND $tb_pub_to_auth.id_author='$author_id' AND $tb_pub_to_auth.id_pub=$tb_publications.id;");
$i=0;
while ($row=mysql_fetch_object($res)) $entr[$i++]=$row->entry_type;
for ($i=0; $i "); $lin = ""; for ($i=0; $i ![\"Edit\"](\"images/ed.gif\") ");
if ($i<(count($keywords)-1)){
if ($i==(count($keywords)-2)){
$titlul .= ($operation == 'a' ? " and " : " or ");
} else {
$titlul .= ", ";
}
}
}
titlu("left", "$title_bg", "FFFFFF", $titlul . " |
Order by: ".
($ord == "year" ?
""
:"")."Type".($ord == "year" ? "":"")." | ".
($ord != "year" ? "":"")."Year".($ord != "year" ? "":""));
require_once('./fc_enum.php');
echo "
|
|
";
if (!$user)
tabela_pub($ress, "y", "y", "" ,"", "", "", "", $start_elem);
else
tabela_pub($ress, "y", "", "y" ,"y", "", "", "", $start_elem);
$start_elem += mysql_num_rows($ress);
echo " | ";
if (!$user)
tabela_pub($ress, "y", "y", "" ,"", "", "", "", $start_elem);
else
tabela_pub($ress, "y", "", "y" ,"y", "", "", "", $start_elem);
$start_elem += mysql_num_rows($ress);
echo " | |
Type : ".
((!empty($type) and ($type == "bib" or $type == "both")) ?
""
:"")."Html".((!empty($type) and ($type == "bib" or $type == "both")) ? "":"")." | ".
($type != "bib" ? "":"")."Bib".($type != "bib" ? "":"") ." | ".
($type != "both" ? "":"")."Both".($type != "both" ? "":""));
$res = mysql_db_query($db_bibliography, "SELECT * FROM $tb_publications WHERE id='".$id."';");
if (mysql_num_rows($res) > 0){
$row=mysql_fetch_object($res);
mysql_data_seek($res, 0);
echo "| Created: ".get_user_name($row->id_user_c) ."".($user?", ":''). $row->date_c.($user?(empty($row->computer_c)?"":", ".$row->computer_c.""):'').($row->date_lm!=$row->date_c?" Modified: ".get_user_name($row->id_user_lm)."".($user?", ":'').$row->date_lm.($user?(empty($row->computer_lm)?"":", ".$row->computer_lm.""):""):'').(((($modifs_approve && $user) || $modifs_save_copy && $user_admin) && !empty($row->date_approved))?" Approved: ".get_user_name($row->id_admin_approved).", ".$row->date_approved:'')." | ";
if (!$user){
if ($type == "bib") {
tabela_pub($res, "y", "y", "" ,"", "", "", "y", $id - 1);
}
else if ($type == "both") {
tabela_pub($res, "y", "y", "" ,"", "", "", "", $id - 1);
}
else if (empty($type) or ($type != "bib" and $type != "both")) {
tabela_pub($res, "y", "y", "" ,"", "", "", "", $id - 1);
}
}
else {
if ($type == "bib") {
tabela_pub($res, "y", "", "y" ,"y", "", "", "y", $id - 1);
}
else if ($type == "both") {
tabela_pub($res, "y", "", "y" ,"y", "", "", "", $id - 1);
}
else if (empty($type) or ($type != "bib" and $type != "both")) {
tabela_pub($res, "y", "", "y" ,"y", "", "", "", $id - 1);
}
}
echo " | |
Order by: ".
($ord == "year" ?
""
:"")."Type".($ord == "year" ? "":"")." | ".
($ord != "year" ? "":"")."Year".($ord != "year" ? "":""));
if ($ord == "year"){
$res = mysql_db_query($db_bibliography,
"SELECT DISTINCT year FROM $tb_publications ORDER BY year DESC;");
$prev='';$i=0;
if (mysql_num_rows($res) > 0)
while ($row = mysql_fetch_object($res)) {//todo
$next='';
$i++;
if ($i < mysql_num_rows($res)){
$roww=mysql_fetch_object($res);
$next=$roww->year;
mysql_data_seek($res, $i);
}
$ress=mysql_db_query($db_bibliography, "SELECT * FROM $tb_publications WHERE year='".$row->year."';");
$start_elem += display_entries($ress, "year."\" title=\"Only ".$publicationl.'s '.(empty($row->year)?"with no year defined":"of year ".$row->year)."\">".$row->year."","", ($type == "bib" ? "y" : ""), 0, $prev, $next);
$prev=$row->year;
}
mysql_free_result($res);
} else {
$next='';$prev='';
$res = mysql_db_query($db_bibliography, "SELECT DISTINCT entry_type FROM $tb_publications;");
$i=0;
while ($row=mysql_fetch_object($res)) $entr[$i++]=$row->entry_type;
for ($i=0; $i |