$link .= "&FORM[csuche]=" . $FORM['csuche'];
}
if ($FORM['cstatus'] != "") {
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");
}
}
}
//------------------------------> Löschen
if ($func == "delete") {
$query = "delete from rex_opf_lang where replacename= BINARY'" . $oname . "' ";
$delsql = new sql();
// $delsql->debugsql=0;
$delsql->setQuery($query);
$func = "";
echo rex_opf_msg("Replace value deleted");
}
//------------------------------> Liste
//if($func == ""){
$sql = "select * from rex_opf_lang where rex_opf_lang.clang=" . $clang . " order by replacename";
$mit = new rexlist();
$mit->setQuery($sql);
$mit->setList(30);
$mit->setGlobalLink("index.php?page=" . $mypage . "&clang=" . $clang . "&next=");
$mit->setValue("id", "rex_opf_lang.id");
$mit->setLink("index.php?page=" . $mypage . "&clang=" . $clang . "&func=edit&oid=", "id");
$mit->setValue("Value", "rex_opf_lang.name");
$mit->setLink("index.php?page=" . $mypage . "&clang=" . $clang . "&func=edit&oid=", "id");
$mit->setValue("ReplaceValue", "rex_opf_lang.replacename");
$mit->addColumn("delete", "index.php?page=" . $mypage . "&clang=" . $clang . "&func=delete&oname=", "replacename", " onclick=\"return confirm('Delete ?');\"");
echo $mit->showall($next);
//}
include $REX[INCLUDE_PATH] . "/layout/bottom.php";
?>
$delsql->debugsql = 0;
$delsql->setQuery($query);
$func = "";
}
//------------------------------> Userliste
if ($func == "") {
echo "<table class=rex cellpadding=5 cellspacing=1>\n\t\t<form action=index.php method=get>\n\t\t<input type=hidden name=page value=newsletter>\n\t\t<input type=hidden name=subpage value=user>\n\t\t<tr>\n\t\t<td width=100><b>Suche:</b></td>\n\t\t<td><input type=text size=30 class=inp100 name=searchtxt value='" . htmlspecialchars($_REQUEST["searchtxt"]) . "'></td>\n\t\t<td width=500><input type=submit value='Suche starten'></td>\n\t\t</tr>\n\t\t</form>\n\t\t</table><br>";
$addsql = "";
if ($_REQUEST["searchtxt"] != "") {
$addsql = "where email LIKE '%" . $_REQUEST["searchtxt"] . "%' ";
$addsql .= "or name LIKE '%" . $_REQUEST["searchtxt"] . "%' ";
$addsql .= "or firstname LIKE '%" . $_REQUEST["searchtxt"] . "%' ";
$addsql .= "or last_nlid LIKE '%" . $_REQUEST["searchtxt"] . "%' ";
}
$sql = "select * from rex_8_newsletter {$addsql} order by name";
$mit = new rexlist();
$mit->setQuery($sql);
$mit->setGlobalLink("index.php?page=" . $mypage . "&subpage=user&searchtxt=" . urlencode($_REQUEST["searchtxt"]) . "&next=");
//$mit->setValue("id","id");
$mit->setValue("E-Mail", "email");
$mit->setLink("index.php?page=" . $mypage . "&func=edit&oid=", "id");
$mit->setValue("Name", "name");
$mit->setLink("index.php?page=" . $mypage . "&func=edit&oid=", "id");
$mit->setValue("Vorname", "firstname");
$mit->setValue("Aktion ID", "last_nlid");
$mit->setValue("Status", "status");
$mit->setFormat("replace_value", "0|<span style='color:#cc6666;'>inaktiv</span>|1|<span style='color:#66cc66;'>aktiv</span>");
$mit->addColumn("löschen", "index.php?page=" . $mypage . "&subpage=user&func=delete&oid=", "id", " onclick=\"return confirm('sicher löschen ?');\"");
echo $mit->showall($next);
echo "<br><br><a href=index.php?page=" . $mypage . "&subpage=user&func=add><b>User anlegen</b></a><br>";
}
