case "Importance":
$order = "sum_cnt DESC";
break;
case "Urgency":
$order = "software.urgency DESC";
break;
case "Name":
$order = "software.name ASC";
break;
case "Date":
default:
$by = "Date";
$order = "software.modification DESC";
break;
}
$limit = "{$iter},10";
$query = "SELECT *,SUM(app_cnt+homepage_cnt+download_cnt+changelog_cnt+rpm_cnt+deb_cnt+tgz_cnt+cvs_cnt+screenshots_cnt+mailarch_cnt) AS sum_cnt FROM software,counter WHERE section='{$section}' AND category='{$category}' AND status='A' AND software.appid=counter.appid AND name LIKE '{$with}' GROUP BY software.appid ORDER BY {$order} LIMIT {$limit}";
$sort = $t->translate("sorted by") . ": " . "<a href=\"" . htmlentities($sess->self_url() . $sess->add_query(array("section" => $section, "category" => $category, "with" => "{$with}", "find" => "{$find}", "by" => "Date"))) . "\">" . $t->translate("Date") . "</a>" . " | <a href=\"" . htmlentities($sess->self_url() . $sess->add_query(array("section" => $section, "category" => $category, "with" => "{$with}", "find" => "{$find}", "by" => "Importance"))) . "\">" . $t->translate("Importance") . "</a>" . " | <a href=\"" . htmlentities($sess->self_url() . $sess->add_query(array("section" => $section, "category" => $category, "with" => "{$with}", "find" => "{$find}", "by" => "Urgency"))) . "\">" . $t->translate("Urgency") . "</a>" . " | <a href=\"" . htmlentities($sess->self_url() . $sess->add_query(array("section" => $section, "category" => $category, "with" => "{$with}", "find" => "{$find}", "by" => "Name"))) . "\">" . $t->translate("Name") . "</a>\n";
$bs->box_strip($sort);
appcat($query, $section . "/" . $category, $iter + 1);
if ($numiter > 1) {
$url = "appbycat.php";
$urlquery = array("section" => $section, "category" => $category, "with" => "{$with}", "find" => "{$find}", "by" => $by);
show_more($iter, $numiter, $url, $urlquery);
}
?>
<!-- end content -->
<?php
require "./include/footer.inc";
@page_close();
break;
case "Name":
$order = "software.name ASC";
break;
case "Date":
default:
$by = "Date";
$order = "software.modification DESC";
break;
}
$limit = "{$iter},10";
$sort = $t->translate("sorted by") . ": " . "<a href=\"" . htmlentities($sess->url("appbydev.php") . $sess->add_query(array("developer" => $developer, "email" => $email, "with" => "{$with}", "find" => "{$find}", "by" => "Date"))) . "\">" . $t->translate("Date") . "</a>" . " | <a href=\"" . htmlentities($sess->url("appbydev.php") . $sess->add_query(array("developer" => $developer, "email" => $email, "with" => "{$with}", "find" => "{$find}", "by" => "Importance"))) . "\">" . $t->translate("Importance") . "</a>" . " | <a href=\"" . htmlentities($sess->url("appbydev.php") . $sess->add_query(array("developer" => $developer, "email" => $email, "with" => "{$with}", "find" => "{$find}", "by" => "Urgency"))) . "\">" . $t->translate("Urgency") . "</a>" . " | <a href=\"" . htmlentities($sess->url("appbydev.php") . $sess->add_query(array("developer" => $developer, "email" => $email, "with" => "{$with}", "find" => "{$find}", "by" => "Name"))) . "\">" . $t->translate("Name") . "</a>\n";
$bs->box_strip($sort);
if (empty($developer)) {
$devnam = "Unknown";
} else {
$devnam = $developer;
}
$query = "SELECT {$columns} FROM {$tables} WHERE {$where} ORDER BY {$order} LIMIT {$limit}";
appcat($query, $t->translate("Author") . ": " . stripslashes($devnam), $iter + 1);
if ($numiter > 1) {
$url = "appbydev.php";
$urlquery = array("developer" => $developer, "email" => $email, "with" => "{$with}", "find" => "{$find}", "by" => $by);
show_more($iter, $numiter, $url, $urlquery);
}
?>
<!-- end content -->
<?php
require "./include/footer.inc";
@page_close();
case "Importance":
$order = "sum_cnt DESC";
break;
case "Urgency":
$order = "software.urgency DESC";
break;
case "Name":
$order = "software.name ASC";
break;
case "Date":
default:
$by = "Date";
$order = "software.modification DESC";
break;
}
$limit = "{$iter},10";
$db->query("SELECT *,SUM(app_cnt+homepage_cnt+download_cnt+changelog_cnt+rpm_cnt+deb_cnt+tgz_cnt+cvs_cnt+screenshots_cnt+mailarch_cnt) AS sum_cnt FROM software,counter WHERE license='{$license}' AND status='A' AND software.appid=counter.appid AND name LIKE '{$with}' GROUP BY software.appid ORDER BY {$order} LIMIT {$limit}");
$sort = $t->translate("sorted by") . ": " . "<a href=\"" . htmlentities($sess->self_url() . $sess->add_query(array("license" => $license, "with" => "{$with}", "find" => "{$find}", "by" => "Date"))) . "\">" . $t->translate("Date") . "</a>" . " | <a href=\"" . htmlentities($sess->self_url() . $sess->add_query(array("license" => $license, "with" => "{$with}", "find" => "{$find}", "by" => "Importance"))) . "\">" . $t->translate("Importance") . "</a>" . " | <a href=\"" . htmlentities($sess->self_url() . $sess->add_query(array("license" => $license, "with" => "{$with}", "find" => "{$find}", "by" => "Urgency"))) . "\">" . $t->translate("Urgency") . "</a>" . " | <a href=\"" . htmlentities($sess->self_url() . $sess->add_query(array("license" => $license, "with" => "{$with}", "find" => "{$find}", "by" => "Name"))) . "\">" . $t->translate("Name") . "</a>\n";
$bs->box_strip($sort);
appcat($query, $t->translate("License") . ": " . $license, $iter + 1);
if ($numiter > 1) {
$url = "appbylic.php";
$urlquery = array("license" => $license, "by" => $by);
show_more($iter, $numiter, $url, $urlquery);
}
?>
<!-- end content -->
<?php
require "./include/footer.inc";
@page_close();
