$func = rex_request("func", "string", "");
$FORM = rex_request("FORM", "array", "");
//------------------------------
if ($func == "add" || $func == "edit") {
    echo $back_to_overview;
    $mita = new rexform();
    // $mita->debug = 1;
    $mita->setWidth(770);
    $mita->setLabelWidth(160);
    $mita->setTablename($table);
    $oid = (int) @$_REQUEST["oid"];
    if ($func == "add") {
        $mita->setFormtype("add");
        $mita->setFormheader("\n\t\t\t<input type=hidden name=page value=" . $page . " />\n\t\t\t<input type=hidden name=subpage value=" . $subpage . " />\n\t\t\t<input type=hidden name=func value=" . $func . " />");
        $mita->setShowFormAlways(false);
        $mita->setValue("subline", "{$bezeichner} erstellen", "left", 0);
    } else {
        $mita->setFormtype("edit", "id='" . $oid . "'", "{$bezeichner} wurde nicht gefunden");
        $mita->setFormheader("\n\t\t\t<input type=hidden name=page value=" . $page . ">\n\t\t\t<input type=hidden name=subpage value=" . $subpage . ">\n\t\t\t<input type=hidden name=func value=" . $func . " />\n\t\t\t<input type=hidden name=oid value=" . $oid . ">");
        $mita->setShowFormAlways(false);
        $mita->setValue("subline", "{$bezeichner} edieren", "left", 0);
    }
    $mita->setCols(2);
    $mita->setValue("empty", "", "", 0);
    $guf = new rex_sql();
    $guf->setQuery("select * from " . $table_field . " where editable=1 order by prior");
    $fields = array();
    $gufa = $guf->getArray();
    foreach ($gufa as $key => $value) {
        rex_com_s_rexform($mita, $value);
    }
            $FORM['csuchid'][] = $fromsql->getValue("id");
        }
        $fromsql->next();
    }
    $userReplaceValue = substr($userReplaceValue, 0, strlen($userReplaceValue) - 1);
}
//------------------------------> Poll Anlegen|Editieren
if ($func == "edit") {
    $mita = new rexform();
    $mita->setWidth(770);
    $mita->setLabelWidth(160);
    $mita->setTablename($table);
    $mita->setFormtype("edit", "id='" . $oid . "'", "Nachricht wurde nicht gefunden");
    $mita->setFormheader("<input type=hidden name=page value=" . $mypage . "><input type=hidden name=subpage value=" . $subpage . "><input type=hidden name=func value=" . $func . " /><input type=hidden name=oid value=" . $oid . ">");
    $mita->setShowFormAlways(false);
    $mita->setValue("subline", "{$bezeichner} edieren", "left", 0);
    $mita->setValue("showtext", "An", "user_id", 0, "width:100%;'");
    $mita->setValue("showtext", "Von", "from_user_id", 0, "width:100%;'");
    $mita->setValue("showtext", "Datum", "stamp", 0, "width:100%;'");
    $mita->setValue("textarea", "Nachricht", "message", 1);
    $mita->setValue("singleselect", "Status", "status", 0, "0|inaktiv|1|aktiv");
    echo $mita->showForm();
    if (!$mita->form_show) {
        $func = "";
        echo "<br>";
    } else {
        echo "<br /><table cellpadding=5 class=rex><tr><td><a href=index.php?page=" . $mypage . "&subpage=" . $subpage . "><b>&laquo; Zurück zur Übersicht</b></a></td></tr></table>";
    }
}
//------------------------------> Partner löschen
if ($func == "delete") {
//------------------------------> User Anlegen|Editieren
if ($func == "add" || $func == "edit") {
    $mita = new rexform();
    $mita->setWidth(770);
    $mita->setLabelWidth(160);
    $mita->setTablename("rex_2_user");
    if ($func == "add") {
        $mita->setFormtype("add");
        $mita->setFormheader("<input type=hidden name=page value=" . $mypage . "><input type=hidden name=func value=" . $func . " />");
        $mita->setShowFormAlways(false);
    } else {
        $mita->setFormtype("edit", "id='" . $oid . "'", "User wurde nicht gefunden");
        $mita->setFormheader("<input type=hidden name=page value=" . $mypage . "><input type=hidden name=func value=" . $func . " /><input type=hidden name=oid value=" . $oid . ">");
        $mita->setShowFormAlways(true);
    }
    $mita->setValue("subline", $I18N_SIMPLE_USER->msg("uw_info_headline"), "left", 0);
    $mita->setValue("text", $I18N_SIMPLE_USER->msg("uw_login"), "user_login", 1);
    $mita->setCols(2);
    $mita->setValue("text", $I18N_SIMPLE_USER->msg("uw_passwort"), "user_password", 1);
    $mita->setValue("singleselect", $I18N_SIMPLE_USER->msg("uw_user_status"), "user_status", 0, "1|" . $I18N_SIMPLE_USER->msg("uw_user_status_on") . "|0|" . $I18N_SIMPLE_USER->msg("uw_user_status_off") . "");
    $mita->setValue("text", $I18N_SIMPLE_USER->msg("uw_usre_typ"), "user_typ", 0);
    $mita->setValue("checkbox", $I18N_SIMPLE_USER->msg("uw_info_newsletter"), "info_newsletter", 0);
    $mita->setValue("checkbox", $I18N_SIMPLE_USER->msg("uw_info_mail"), "info_mail", 0);
    $mita->setValue("text", $I18N_SIMPLE_USER->msg("uw_file1"), "user_file1", 0);
    $mita->setValue("text", $I18N_SIMPLE_USER->msg("uw_file2"), "user_file2", 0);
    $mita->setValue("singleselect", $I18N_SIMPLE_USER->msg("uw_login_activation"), "login_activation", 0, "0|" . $I18N_SIMPLE_USER->msg("uw_nein") . "|1|" . $I18N_SIMPLE_USER->msg("uw_ja") . "");
    $mita->setValue("text", $I18N_SIMPLE_USER->msg("uw_activation_key"), "activation_key", 0);
    if ($func == "edit") {
        $mita->setValue("multipleselectsql", "Gruppen", "", 0, "select * from rex_2_group order by name", "id", "name", 5, "rex_2_u_g", "user_id='{$oid}'", "group_id");
        $mita->setValue("empty", "", "", 0);
    }
//------------------------------> Gruppe Anlegen|Editieren
if ($func == "add" || $func == "edit") {
    $mita = new rexform();
    $mita->setWidth(770);
    $mita->setLabelWidth(160);
    $mita->setTablename("rex_2_group");
    if ($func == "add") {
        $mita->setFormtype("add");
        $mita->setFormheader("<input type=hidden name=page value=" . $mypage . "><input type=hidden name=subpage value=" . $subpage . "><input type=hidden name=func value=" . $func . " />");
        $mita->setShowFormAlways(false);
    } else {
        $mita->setFormtype("edit", "id='" . $oid . "'", "Gruppe wurde nicht gefunden");
        $mita->setFormheader("<input type=hidden name=page value=" . $mypage . "><input type=hidden name=subpage value=" . $subpage . "><input type=hidden name=func value=" . $func . " /><input type=hidden name=oid value=" . $oid . ">");
        $mita->setShowFormAlways(true);
    }
    $mita->setValue("subline", $I18N_SIMPLE_USER->msg("uw_hl_group"), "left", 0);
    $mita->setValue("text", $I18N_SIMPLE_USER->msg("uw_name"), "name", 1);
    $mita->setValue("text", $I18N_SIMPLE_USER->msg("uw_extras"), "extras");
    echo $mita->showForm();
    echo "<br><br><a href=index.php?page=" . $mypage . "&subpage=" . $subpage . "><b>&laquo; Zurück zur Übersicht</b></a><br>";
}
//------------------------------> User löschen
if ($func == "delete") {
    $query = "delete from rex_2_group where id='" . $oid . "' ";
    $delsql = new rex_sql();
    $delsql->debugsql = 0;
    $delsql->setQuery($query);
    $func = "";
}
//------------------------------> Userliste
if ($func == "") {
if ($func == 'add' || $func == 'edit') {
    $form = new rexform();
    $form->setWidth(770);
    $form->setLabelWidth(160);
    $form->setTablename(TBL_EXCEL_EXPORT_TBL);
    $form->setSubmitValue("Übernehmen");
    if ($func == "add") {
        $form->setFormtype("add", 'lang_id = language');
        $form->setFormheader("<input type=hidden name=page value=" . $page . "><input type=hidden name=func value=" . $func . " />");
        $form->setShowFormAlways(false);
    } else {
        $form->setFormtype("edit", 'lang_id = language and short_id = ' . $sid, $I18N_GLOSSAR->msg('invalid_shortcut'));
        $form->setFormheader("<input type=hidden name=page value=" . $page . "><input type=hidden name=func value=" . $func . " /><input type=hidden name=sid value=" . $sid . ">");
        $form->setShowFormAlways(true);
    }
    $form->setValue("subline", "Tabelleninformationen", "left", 0);
    $form->setValue("singleselect", "Name", "", 1, "SHOW TABLES", "Tables_in_redaxo2_7", "Tables_in_redaxo2_7");
    $form->setValue("text", "Bezeichnung", "tbl_label", 1);
    $form->setValue("text", "Primärschlüssel", "tbl_pk", 1);
    echo $form->showForm();
    echo "<br><br><a href=index.php?page=" . $page . "&subpage=" . $subpage . "><b>&laquo; Zurück zur Übersicht</b></a><br>";
}
//------------------------------> Shortcut löschen
if ($func == 'delete') {
    $query = 'DELETE FROM ' . TBL_GLOSSAR . ' WHERE short_id=' . $sid;
    $delsql = new sql();
    //    $delsql->debugsql=1;
    $delsql->setQuery($query);
    $func = '';
}
//------------------------------> Shortcutliste
//------------------------------> Projekt Anlegen|Editieren
if ($func == "add" || $func == "edit") {
    $mita = new rexform();
    $mita->setWidth(770);
    $mita->setLabelWidth(160);
    $mita->setTablename("rex_21_bug_report");
    if ($func == "add") {
        $mita->setFormtype("add");
        $mita->setFormheader("<input type=hidden name=page value=" . $mypage . "><input type=hidden name=subpage value=" . $subpage . "><input type=hidden name=func value=" . $func . " />");
        $mita->setShowFormAlways(false);
    } else {
        $mita->setFormtype("edit", "id='" . $oid . "'", "Projekt wurde nicht gefunden");
        $mita->setFormheader("<input type=hidden name=page value=" . $mypage . "><input type=hidden name=subpage value=" . $subpage . "><input type=hidden name=func value=" . $func . " /><input type=hidden name=oid value=" . $oid . ">");
        $mita->setShowFormAlways(true);
    }
    $mita->setValue("subline", $I18N_BUG_REPORT->msg("hdl_bugs"), "left", 0);
    $mita->setValue("text", $I18N_BUG_REPORT->msg("title"), "title", 1);
    $mita->setValue("textarea", $I18N_BUG_REPORT->msg("description"), "description", 0);
    $mita->setValue("singleselect", $I18N_BUG_REPORT->msg("status"), "status", 0, "0|" . $I18N_BUG_REPORT->msg("status0") . "|1|" . $I18N_BUG_REPORT->msg("status1") . "|2|" . $I18N_BUG_REPORT->msg("status2") . "");
    echo $mita->showForm();
    echo "<br /><br /><a href=index.php?page=" . $mypage . "&subpage=" . $subpage . "><b>&laquo; " . $I18N_BUG_REPORT->msg("back_to_list") . "</b></a><br>";
}
//------------------------------> löschen
if ($func == "delete") {
    $query = "delete from rex_21_bug_report where id='" . $oid . "' ";
    $delsql = new sql();
    $delsql->debugsql = 0;
    $delsql->setQuery($query);
    $func = "";
}
//------------------------------> Liste
//------------------------------> Editieren
if ($func == "edit") {
    echo $back_to_overview;
    $mita = new rexform();
    $mita->setWidth(770);
    $mita->setLabelWidth(160);
    $mita->setTablename($table);
    $mita->setFormtype("edit", "id='" . $oid . "'", "Nachricht wurde nicht gefunden");
    $mita->setFormheader('
		<input type="hidden" name="page" value="' . $page . '" />
		<input type="hidden" name="subpage" value="' . $subpage . '" />
		<input type="hidden" name="func" value="' . $func . '" />
		<input type="hidden" name="oid" value="' . $oid . '" />
		');
    $mita->setShowFormAlways(false);
    $mita->setValue("subline", "{$bezeichner} edieren", "left", 0);
    $mita->setValue("text", "user_id", "user_id", 0);
    $mita->setValue("text", "article_id", "article_id", 0);
    $mita->setValue("textarea", "comment", "comment", 0);
    $mita->setValue("text", "create_datetime", "create_datetime", 0);
    $mita->setValue("text", "status", "status", 0);
    echo $mita->showForm();
    if (!$mita->form_show) {
        $func = "";
    }
}
//------------------------------> Löschen
if ($func == "delete") {
    $query = "delete from {$table} where id='" . $oid . "' ";
    $delsql = new rex_sql();
    $delsql->debugsql = 0;
            $FORM['csuchartid'][] = $artsql->getValue("id");
        }
        $artsql->next();
    }
    $articleReplaceValue = substr($articleReplaceValue, 0, strlen($articleReplaceValue) - 1);
}
//------------------------------> Poll Anlegen|Editieren
if ($func == "edit") {
    $mita = new rexform();
    $mita->setWidth(770);
    $mita->setLabelWidth(160);
    $mita->setTablename($table);
    $mita->setFormtype("edit", "id='" . $oid . "'", "Nachricht wurde nicht gefunden");
    $mita->setFormheader("<input type=hidden name=page value=" . $mypage . "><input type=hidden name=subpage value=" . $subpage . "><input type=hidden name=func value=" . $func . " /><input type=hidden name=oid value=" . $oid . ">");
    $mita->setShowFormAlways(false);
    $mita->setValue("subline", "{$bezeichner} edieren", "left", 0);
    $mita->setValue("showtext", "Von", "user_id", 0, "width:100%;'");
    $mita->setValue("showtext", "Email Von", "user_email", 0, "width:100%;'");
    $mita->setValue("showtext", "Registriert", "user_registered", 0, "width:100%;'");
    $mita->setValue("showtext", "Artikel", "article_id", 0, "width:100%;'");
    $mita->setValue("showtext", "Datum", "stamp", 0, "width:100%;'");
    $mita->setValue("textarea", "Kommentar", "comment", 1);
    $mita->setValue("singleselect", "Status", "status", 0, "0|inaktiv|1|aktiv");
    echo $mita->showForm();
    if (!$mita->form_show) {
        $func = "";
        echo "<br>";
    } else {
        echo "<br /><table cellpadding=5 class=rex><tr><td><a href=index.php?page=" . $mypage . "&subpage=" . $subpage . "><b>&laquo; Zurück zur Übersicht</b></a></td></tr></table>";
    }
}
    if ($rep != "") {
        $rep .= "|";
    }
    $rep .= "{$key}|[{$key}] {$value}";
}
//------------------------------> Poll Anlegen|Editieren
if ($func == "add" || $func == "edit") {
    $mita = new rexform();
    $mita->setWidth(770);
    $mita->setLabelWidth(160);
    $mita->setTablename($table);
    if ($func == "add") {
        $mita->setFormtype("add");
        $mita->setFormheader("\n\t\t\t<input type=hidden name=page value=" . $page . " />\n\t\t\t<input type=hidden name=subpage value=" . $subpage . " />\n\t\t\t<input type=hidden name=func value=" . $func . " />");
        $mita->setShowFormAlways(false);
        $mita->setValue("subline", "{$bezeichner} erstellen", "left", 0);
        $mita->setValue("text", "prior", "prior", 1);
        $mita->setValue("text", "name", "name", 1);
        $mita->setValue("text", "userfield", "userfield", 1);
        $mita->setValue("singleselect", "type", "type", 1, $rep);
        $mita->setValue("text", "extra1", "extra1", 0);
        // $mita->setValue("text","extra2","extra2",0);
        // $mita->setValue("text","extra3","extra3",0);
        $mita->setValue("checkbox", "Erscheint in Userliste", "inlist", 0);
        $mita->setValue("checkbox", "Editierbar", "editable", 0);
        $mita->setValue("checkbox", "Pflichtfeld", "mandatory", 0);
        $mita->setValue("text", "Defaultwert", "defaultvalue", 0);
        $mita->setValue("subline", "***** Beispiele", "left", 0);
        $mita->setValue("subline", "INT * extra1=14", "left", 0);
        $mita->setValue("subline", "VARCHAR * extra1=255", "left", 0);
        $mita->setValue("subline", "TEXT * ", "left", 0);
$SF = true;
$mypage = "community";
$subpage = "group";
$table = "rex_5_group";
$bezeichner = "Gruppe";
//------------------------------> Gruppe Anlegen|Editieren
if ($func == "add" || $func == "edit") {
    $mita = new rexform();
    $mita->setWidth(770);
    $mita->setLabelWidth(160);
    $mita->setTablename("rex_5_group");
    if ($func == "add") {
        $mita->setFormtype("add");
        $mita->setFormheader("<input type=hidden name=page value=" . $mypage . "><input type=hidden name=subpage value=" . $subpage . "><input type=hidden name=func value=" . $func . " />");
        $mita->setShowFormAlways(false);
        $mita->setValue("subline", "{$bezeichner} erstellen", "left", 0);
    } else {
        $mita->setFormtype("edit", "id='" . $oid . "'", "Gruppe wurde nicht gefunden");
        $mita->setFormheader("<input type=hidden name=page value=" . $mypage . "><input type=hidden name=subpage value=" . $subpage . "><input type=hidden name=func value=" . $func . " /><input type=hidden name=oid value=" . $oid . ">");
        $mita->setShowFormAlways(true);
        $mita->setValue("subline", "{$bezeichner} bearbeiten", "left", 0);
    }
    $mita->setValue("text", "Name", "name", 1);
    $mita->setValue("text", "Extras", "extras");
    echo $mita->showForm();
    if (!$mita->form_show) {
        $func = "";
        echo "<br>";
    } else {
        echo "<br /><table cellpadding=5 class=rex><tr><td><a href=index.php?page=" . $mypage . "&subpage=" . $subpage . "><b>&laquo; Zurück zur Übersicht</b></a></td></tr></table>";
    }
//------------------------------> User Anlegen|Editieren
if ($func == "add" || $func == "edit") {
    $mita = new rexform();
    $mita->setWidth(770);
    $mita->setLabelWidth(160);
    $mita->setTablename("rex_8_newsletter");
    if ($func == "add") {
        $mita->setFormtype("add");
        $mita->setFormheader("<input type=hidden name=page value=" . $mypage . "><input type=hidden name=func value=" . $func . " />");
        $mita->setShowFormAlways(false);
    } else {
        $mita->setFormtype("edit", "id='" . $oid . "'", "User wurde nicht gefunden");
        $mita->setFormheader("<input type=hidden name=page value=" . $mypage . "><input type=hidden name=func value=" . $func . " /><input type=hidden name=oid value=" . $oid . ">");
        $mita->setShowFormAlways(false);
    }
    $mita->setValue("subline", "User edieren", "left", 0);
    $mita->setValue("text", "E-Mail", "email", 1);
    $mita->setValue("text", "Vorname", "firstname", 0);
    $mita->setValue("text", "Name", "name", 0);
    $mita->setValue("text", "ID der letzten Aktion", "last_nlid", 0);
    $mita->setValue("singleselect", "Status", "status", 0, "0|offline|1|online");
    echo $mita->showForm();
    if (!$mita->form_show) {
        $func = "";
        echo "<br>";
    } else {
        echo "<br><br><a href=index.php?page=" . $mypage . "><b>&laquo; Zurück zur Übersicht</b></a><br>";
    }
}
//------------------------------> User löschen
if ($func == "delete") {
$bezeichner = "User";
if ($_REQUEST["func"] == "sendmail") {
    // dem user eine mail schicken
    include $REX["INCLUDE_PATH"] . "/addons/community/pages/user_email.inc.php";
}
//------------------------------> Poll Anlegen|Editieren
if ($func == "add" || $func == "edit") {
    $mita = new rexform();
    $mita->setWidth(770);
    $mita->setLabelWidth(160);
    $mita->setTablename($table);
    if ($func == "add") {
        $mita->setFormtype("add");
        $mita->setFormheader("<input type=hidden name=page value=" . $mypage . "><input type=hidden name=subpage value=" . $subpage . "><input type=hidden name=func value=" . $func . " />");
        $mita->setShowFormAlways(false);
        $mita->setValue("subline", "{$bezeichner} erstellen", "left", 0);
    } else {
        $mita->setFormtype("edit", "id='" . $oid . "'", "{$bezeichner} wurde nicht gefunden");
        $mita->setFormheader("<input type=hidden name=page value=" . $mypage . "><input type=hidden name=subpage value=" . $subpage . "><input type=hidden name=func value=" . $func . " /><input type=hidden name=oid value=" . $oid . ">");
        $mita->setShowFormAlways(false);
        $mita->setValue("subline", "{$bezeichner} edieren", "left", 0);
    }
    $mita->setValue("subline", "Stammdaten", "left", 0);
    $mita->setCols(1);
    $mita->setValue("text", "user_login", "user_login", 1);
    $mita->setCols(2);
    $mita->setValue("text", "user_password", "user_password", 1);
    $mita->setValue("singleselect", "user_status", "user_status", 0, "1|aktiv [1]|0|inaktiv [0]");
    $mita->setValue("text", "user_typ [1=user,7=admin]", "user_typ", 0);
    $mita->setValue("text", "user_name", "user_name", 0);
    $mita->setValue("text", "user_firstname", "user_firstname", 0);