if ($addsql == "") {
$addsql .= " WHERE ";
} else {
$addsql .= " AND ";
}
$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");
