function liste() {
global $db, $prefix, $pagetitle, $conf, $confso;
$cwhere = catmids($conf['name'], "p.product_cid");
$slistnum = intval($confso['listnum']);
$num = isset($_GET['num']) ? intval($_GET['num']) : "1";
$offset = ($num-1) * $slistnum;
$offset = intval($offset);
$result = $db->sql_query("SELECT p.product_id, p.product_cid, p.product_time, p.product_title, p.product_preis, c.id, c.title FROM ".$prefix."_products AS p LEFT JOIN ".$prefix."_categories AS c ON (p.product_cid=c.id) ".$order." ".$cwhere." ORDER BY p.product_cid DESC LIMIT $offset, $slistnum");
head();
menu(""._LIST."");
if ($db->sql_numrows($result) > 0) {
open();
echo "<table width=\"100%\" border=\"0\" cellpadding=\"2\" cellspacing=\"1\" class=\"sort\" id=\"sort_id\"><tr>"
."<th>"._ID."</th><th>"._CATEGORY."</th><th>"._TITLE."</th><th>"._PREIS."</th></tr>";
while (list($product_id, $product_cid, $product_time, $product_title, $product_preis, $cid, $ctitle) = $db->sql_fetchrow($result)) {
$ctitle = (!$ctitle) ? ""._NO."" : "<a href=\"index.php?name=".$conf['name']."&cat=$cid\" title=\"".$ctitle."\">".cutstr($ctitle, 50)."</a>";
echo "<tr class=\"bgcolor1\">"
."<td align=\"center\">".$product_cid."</td>"
."<td align=\"left\">".$ctitle."</td>"
."<td><a href=\"index.php?name=".$conf['name']."&op=view&id=$product_id\" title=\"".$product_title."\">".cutstr($product_title, 90)."</a></td>"
."<td align=\"left\">".$product_preis." ".$confso['valute']."</td></tr>";
}
echo "</table>";
close();
num_article($conf['name'], $slistnum, $field, "product_id", "_products", "product_cid", $ordernum);
} else {
warning(""._NO_INFO."", "", "", 2);
}
foot();
}
$result = $db->sql_query("SELECT .....
