$addsql .= " `status`='" . $FORM['cstatus'] . "' ";
}
$sql = "select * from {$table} " . $addsql;
//echo $sql;
$mit = new rexlist();
$mit->setQuery($sql);
$mit->setList(50);
$mit->setGlobalLink("index.php?page=" . $mypage . "&subpage=" . $subpage . "" . $link . "&next=");
$mit->setValue("id", "id");
$mit->setValue("Nachricht an", "user_id");
$mit->setValueOrder(1);
$mit->setFormat("replace_value", $userReplaceValue);
$mit->setValue("Nachricht von", "from_user_id");
$mit->setValueOrder(1);
$mit->setFormat("replace_value", $userReplaceValue);
$mit->setValue("Datum", "stamp");
$mit->setValueOrder(1);
$mit->setFormat("unixToDateTime");
$mit->setValue("Status", "status");
$mit->setValueOrder(1);
$mit->setFormat("replace_value", "0|<span style='color:#cc6666;'>inaktiv</span>|1|<span style='color:#66cc66;'>aktiv</span>");
$mit->setValue("editieren", "");
$mit->setFormat("ifempty", "editieren");
$mit->setLink("index.php?page=" . $mypage . "&subpage=" . $subpage . "&func=edit&oid=", "id");
$mit->setValue("löschen", "");
$mit->setFormat("ifempty", "löschen");
$mit->setFormat("link", "index.php?page=" . $mypage . "&subpage=" . $subpage . "&func=delete&oid=", "id", "", " onclick=\"return confirm('sicher löschen ?');\"");
$mit->setOrder($FORM[ordername], $FORM[ordertype]);
echo $mit->showall($next);
echo "<br />";
}
$add_sql = "";
$link = "";
// ADD
echo '<table class="rex-table"><tr><td><a href="index.php?page=' . $page . '&subpage=' . $subpage . '&func=add"><b>+ ' . $bezeichner . ' hinzufügen</b></a></td></tr></table><br />';
$sql = "select * from {$table} " . $add_sql;
//echo $sql;
$mit = new rexlist();
$mit->setQuery($sql);
$mit->setList(50);
$mit->setGlobalLink("index.php?page=" . $page . "&subpage=" . $subpage . "" . $link . "&next=");
$mit->setValue("id", "id");
$mit->setLink("index.php?page=" . $page . "&subpage=" . $subpage . "&func=edit&oid=", "id");
$mit->setValue("article_id", "article_id");
$mit->setValueOrder(1);
$mit->setValue("user_id", "user_id");
$mit->setLink("index.php?page=" . $page . "&subpage=" . $subpage . "&func=edit&oid=", "id");
$mit->setValueOrder(1);
$mit->setValue("status", "status");
$mit->setValue("editieren", "");
$mit->setFormat("ifempty", "editieren");
$mit->setLink("index.php?page=" . $page . "&subpage=" . $subpage . "&func=edit&oid=", "id");
$mit->setValue("löschen", "");
$mit->setFormat("ifempty", "löschen");
$mit->setFormat("link", "index.php?page=" . $page . "&subpage=" . $subpage . "&func=delete&oid=", "id", "", " onclick=\"return confirm('sicher löschen ?');\"");
if (isset($FORM["ordername"]) && isset($FORM["ordertype"])) {
$mit->setOrder($FORM["ordername"], $FORM["ordertype"]);
}
$next = rex_request("next", "int", "0");
echo $mit->showall($next);
echo "<br />";
}
