case "Name":
        $order = "a.TITEL ASC, a.AENDERUNGSDATUM DESC, a.ID DESC";
        break;
    default:
        $order = "a.AENDERUNGSDATUM DESC, ID DESC";
        break;
}
$limit = "{$iter},10";
$columns = " distinct a.TITEL AS titel, a.BESCHREIBUNG as beschreibung, a.COUNTER AS downloads, a.SPRACHE, f.SPRACHE as sprache, a.ERSTELLUNGSDATUM as erdatum, a.AENDERUNGSDATUM as aendatum, a.TYP, a.ID as id, d.NAME as TypName, a.BEWERTUNG AS bewertung, a.BEWVONANZP as bewvonanzpand, c.NAME as KategorieName, a.KATEGORIE as KATID";
$tables = "DOKUMENT a, FORMAT b, KATEGORIE c, TYPDEF d, SPRACHEDEF f";
$where = " a.STATUS!='D' AND a.ID = b.DOKUID and a.TYP = d.ID AND a.KATEGORIE={$category} and a.KATEGORIE = c.ID AND a.SPRACHE=f.ID";
$sort = "({$cnt}) " . $t->translate("sorted by") . ": " . "<a href=\"" . $sess->url("docbycat.php") . $sess->add_query(array("category" => $category, "by" => "Date")) . "\">" . $t->translate("Date") . "</a>" . " | <a href=\"" . $sess->url("docbycat.php") . $sess->add_query(array("category" => $category, "by" => "Typ")) . "\">" . $t->translate("Type") . "</a>" . " | <a href=\"" . $sess->self_url() . $sess->add_query(array("category" => $category, "by" => "Name")) . "\">" . $t->translate("Title") . "</a>\n";
$bs->box_strip($sort);
if (!empty($category)) {
    $query = "SELECT {$columns} FROM {$tables} WHERE {$where} ORDER BY {$order} LIMIT {$limit}";
    doccat($query, $t->translate("Category") . ": ", $iter + 1, "Cat");
    if ($numiter > 1) {
        $url = "docbycat.php";
        $urlquery = array("category" => $category, "by" => $by);
        show_more($iter, $numiter, $url, $urlquery);
    }
}
?>
<!-- end content -->

<?php 
require "footer.inc";
@page_close();
?>

示例#2
0
        $order = "a.AENDERUNGSDATUM DESC, ID DESC";
        break;
    case "Name":
        $order = "a.TITEL ASC, a.AENDERUNGSDATUM DESC, a.ID DESC";
        break;
    default:
        $order = "a.AENDERUNGSDATUM DESC, ID DESC";
        break;
}
$limit = "{$iter},10";
$columns = " distinct a.TITEL AS titel, a.BESCHREIBUNG as beschreibung, a.COUNTER AS downloads, a.SPRACHE, f.SPRACHE as sprache, a.ERSTELLUNGSDATUM as erdatum, a.AENDERUNGSDATUM as aendatum, a.TYP, a.ID as id, d.NAME as TypName, a.BEWERTUNG AS bewertung, a.BEWVONANZP as bewvonanzpand, c.NAME as KategorieName, a.KATEGORIE as KATID ";
$tables = "DOKUMENT a, FORMAT b, KATEGORIE c, TYPDEF d, SPRACHEDEF f";
$where = "a.STATUS!='D' AND a.ID = b.DOKUID and a.TYP = d.ID AND a.TYP={$typ} and a.KATEGORIE = c.ID AND a.SPRACHE=f.ID";
$sort = "({$cnt}) " . $t->translate("sorted by") . ": " . "<a href=\"" . $sess->url("docbytyp.php") . $sess->add_query(array("typ" => $typ, "by" => "Date")) . "\">" . $t->translate("Date") . "</a>" . " | <a href=\"" . $sess->url("docbytyp.php") . $sess->add_query(array("typ" => $typ, "by" => "Category")) . "\">" . $t->translate("Category") . "</a>" . " | <a href=\"" . $sess->self_url() . $sess->add_query(array("typ" => $typ, "by" => "Name")) . "\">" . $t->translate("Title") . "</a>\n";
$bs->box_strip($sort);
if (!empty($typ)) {
    $query = "SELECT {$columns} FROM {$tables} WHERE {$where} ORDER BY {$order} LIMIT {$limit}";
    //echo $query;
    doccat($query, $t->translate("Type") . ": ", $iter + 1, "Typ");
    if ($numiter > 1) {
        $url = "docbytyp.php";
        $urlquery = array("typ" => $typ, "by" => $by);
        show_more($iter, $numiter, $url, $urlquery);
    }
}
?>
<!-- end content -->

<?php 
require "./include/footer.inc";
@page_close();
        $order = "a.TITEL ASC, a.AENDERUNGSDATUM DESC, a.ID DESC";
        break;
    case "Typ":
        $order = "TypName ASC, a.AENDERUNGSDATUM DESC, ID DESC";
        break;
    default:
        $order = "a.AENDERUNGSDATUM DESC, ID DESC";
        break;
}
$limit = "{$iter},10";
$sort = "({$cnt}) " . $t->translate("sorted by") . ": " . "<a href=\"" . $sess->url("docbydev.php") . $sess->add_query(array("developer" => $developer, "by" => "Date")) . "\">" . $t->translate("Date") . "</a>" . " | <a href=\"" . $sess->url("docbydev.php") . $sess->add_query(array("developer" => $developer, "by" => "Category")) . "\">" . $t->translate("Category") . "</a>" . " | <a href=\"" . $sess->self_url() . $sess->add_query(array("developer" => $developer, "by" => "Typ")) . "\">" . $t->translate("Type") . "</a>\n" . " | <a href=\"" . $sess->self_url() . $sess->add_query(array("developer" => $developer, "by" => "Name")) . "\">" . $t->translate("Title") . "</a>\n";
$bs->box_strip($sort);
if (!empty($developer)) {
    $query = "SELECT {$columns} FROM {$tables} WHERE {$where} ORDER BY {$order} LIMIT {$limit}";
    //echo $query;
    doccat($query, $t->translate("Author") . ": ", $iter + 1, "Author");
    if ($numiter > 1) {
        $url = "docbydev.php";
        $urlquery = array("developer" => $developer, "email" => $email, "by" => $by);
        show_more($iter, $numiter, $url, $urlquery);
    }
}
?>
<!-- end content -->

<?php 
require "footer.inc";
@page_close();
?>