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");