break; case "Date": $order = "solutions_modify_date DESC, solutions_id DESC"; break; default: $order = "solutions_modify_date DESC, solutions_id DESC"; break; } $limit = $cnt . "," . $config_show_solsperpage; $sort = $t->translate("sorted by") . ": " . "<a href=\"" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("by" => "Date")) . "\">" . $t->translate("Date") . "</a>" . " | <a href=\"" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("by" => "Name")) . "\">" . $t->translate("Name") . "</a>" . " | <a href=\"" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("by" => "Contact")) . "\">" . $t->translate("Contact") . "</a>" . " | <a href=\"" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("by" => "Branch")) . "\">" . $t->translate("Branch") . "</a>" . " | <a href=\"" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("by" => "Category")) . "\">" . $t->translate("Category") . "</a>\n"; $bs->box_strip($sort); $nav = "<a href=\"" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("cnt" => $prev_cnt, "by" => $by)) . "\">< " . $t->translate("previous") . " {$config_show_solsperpage} " . $t->translate("Solutions") . "</a>" . " | <a href=\"" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("by" => "Date")) . "\">" . $t->translate("Top") . "</a>"; if ($cnt > 0) { $nav .= " | <a href=\"" . $sess->url(basename($PHP_SELF)) . $sess->add_query(array("cnt" => $next_cnt, "by" => $by)) . "\">" . $t->translate("next") . " {$config_show_solsperpage} " . $t->translate("Solutions") . " ></a>"; } else { $nav .= " | " . $t->translate("next") . " {$config_show_solsperpage} " . $t->translate("Solutions") . " >"; } $bs->box_strip($nav); $query = "SELECT {$columns} FROM {$tables} WHERE {$where} ORDER BY {$order} LIMIT {$limit}"; $db->query($query); while ($db->next_record()) { solshow($db); } $bs->box_strip($nav); $bs->box_strip($sort); ?> <!-- end content --> <?php require "footer.inc"; page_close();
<?php if (!isset($cnt)) { $cnt = 0; } $next_cnt = $cnt + $config_showfull_solperpage; if ($cnt >= $config_showfull_solperpage) { $prev_cnt = $cnt - $config_showfull_solperpage; } else { $prev_cnt = 0; } $query = solquery(0); $db->query($query); solsort($db, 0); if ($db->num_rows() > 0) { while ($db->next_record()) { solshow($db, admin($db)); } solnav($db, 0); } else { $be->box_full($t->translate("Attention!"), $t->translate("No more Solution exist") . "."); } ?> </td><td width=20%> <?php // Recent Solutions at the right column solidx($config_showshort_solperpage); ?> </td></tr> </table> <!-- end content -->