$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>« 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>« 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>« 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>« " . $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>« 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>« 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>« 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);