} } } //------------------------------> 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"; ?>
} 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"); $mit->setLink("index.php?page=" . $mypage . "&subpage=" . $subpage . "&func=edit&oid=", "id");
$mita->setValue("textarea", $I18N_SIMPLE_USER->msg("uw_pers_hobbys"), "personally_hobby", 0); $mita->setValue("textarea", $I18N_SIMPLE_USER->msg("uw_pers_lieblingsorte"), "personally_favorite_place", 0); $mita->setValue("textarea", $I18N_SIMPLE_USER->msg("uw_pers_motto"), "personally_slogan", 0); $mita->setValue("singleselect", $I18N_SIMPLE_USER->msg("uw_pers_eigenschaften_vorlieben"), "personally_data_public", 0, "1|" . $I18N_SIMPLE_USER->msg("uw_data_stat1") . "|0|" . $I18N_SIMPLE_USER->msg("uw_data_stat2") . ""); echo $mita->showForm(); echo "<br><br><a href=index.php?page=" . $mypage . "><b>« Zurück zur Übersicht</b></a><br>"; } //------------------------------> User löschen if ($func == "delete") { $query = "delete from rex_2_user where id='" . $oid . "' "; $delsql = new rex_sql(); $delsql->debugsql = 0; $delsql->setQuery($query); $func = ""; } //------------------------------> Userliste if ($func == "") { $sql = "select * from rex_2_user order by user_login"; $mit = new rexlist(); $mit->setQuery($sql); $mit->setGlobalLink("index.php?page=" . $mypage . "&next="); //$mit->setValue("id","id"); $mit->setValue("Login", "user_login"); $mit->setLink("index.php?page=" . $mypage . "&func=edit&oid=", "id"); $mit->setValue("Name", "user_name"); $mit->setLink("index.php?page=" . $mypage . "&func=edit&oid=", "id"); $mit->setValue("Vorname", "user_firstname"); $mit->addColumn("löschen", "index.php?page=" . $mypage . "&func=delete&oid=", "id", " onclick=\"return confirm('" . $I18N_SIMPLE_USER->msg("uw_sicherdel") . "');\""); echo $mit->showall($next); echo "<br><br><a href=index.php?page=" . $mypage . "&func=add><b>" . $I18N_SIMPLE_USER->msg("uw_useranlegen") . "</b></a><br>"; }
$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 == "") { $sql = "select * from rex_2_group order by id"; $mit = new rexlist(); $mit->setQuery($sql); $mit->setGlobalLink("index.php?page=" . $mypage . "&subpage=" . $subpage . "&next="); $mit->setValue("id", "id"); $mit->setValue("Name", "name"); $mit->setLink("index.php?page=" . $mypage . "&subpage=" . $subpage . "&func=edit&oid=", "id"); $mit->addColumn("löschen", "index.php?page=" . $mypage . "&subpage=" . $subpage . "&func=delete&oid=", "id", " onclick=\"return confirm('" . $I18N_SIMPLE_USER->msg("uw_sicherdel") . "');\""); echo $mit->showall($next); echo "<br><br><a href=index.php?page=" . $mypage . "&subpage=" . $subpage . "&func=add><b>" . $I18N_SIMPLE_USER->msg("uw_creategroup") . "</b></a><br>"; }
$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 if ($func == '') { $sql = 'SELECT * FROM ' . TBL_EXCEL_EXPORT_TBL . ' ORDER BY tbl_name'; // var_dump( $sql); $list = new rexlist(); $list->setQuery($sql); // Spalten setzen $list->setValue("Bezeichnung", "tbl_label"); $list->setLink("index.php?page=" . $page . "&subpage=" . $subpage . "&func=edit&tid=", "tbl_label"); // $list->setValue($I18N_GLOSSAR->msg('language'), "langname"); // $list->setValue($I18N_GLOSSAR->msg('description'), "description"); // $list->setValue($I18N_GLOSSAR->msg('casesensitivity'), "casesensitivity"); $list->addColumn($I18N->msg('delete'), "index.php?page=" . $page . "&func=delete&sid=", "short_id", " onclick=\"return confirm('" . $I18N_GLOSSAR->msg("confirm_delete") . "');\""); echo $list->showall($next); echo "<br><br><a href=index.php?page=" . $page . "&subpage=" . $subpage . "&func=add><b>Tabelle hinzufügen</b></a><br>"; }
} 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("Kommentar an", "user_id"); $mit->setValueOrder(1); $mit->setFormat("replace_value", $userReplaceValue); $mit->setValue("Kommentar 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");
$func = ""; } //------------------------------> Liste if ($func == "") { /** Suche **/ $add_sql = ""; $link = ""; // ADD echo '<table class="rex-table"><tr><td><a href="index.php?page=' . $page . '&subpage=' . $subpage . '&func=add"><b>+ ' . $bezeichner . ' hinzufügen</b></a></td></tr></table><br />'; $sql = "select * from {$table} " . $add_sql; //echo $sql; $mit = new rexlist(); $mit->setQuery($sql); $mit->setList(50); $mit->setGlobalLink("index.php?page=" . $page . "&subpage=" . $subpage . "" . $link . "&next="); $mit->setValue("id", "id"); $mit->setLink("index.php?page=" . $page . "&subpage=" . $subpage . "&func=edit&oid=", "id"); $mit->setValue("article_id", "article_id"); $mit->setValueOrder(1); $mit->setValue("user_id", "user_id"); $mit->setLink("index.php?page=" . $page . "&subpage=" . $subpage . "&func=edit&oid=", "id"); $mit->setValueOrder(1); $mit->setValue("status", "status"); $mit->setValue("editieren", ""); $mit->setFormat("ifempty", "editieren"); $mit->setLink("index.php?page=" . $page . "&subpage=" . $subpage . "&func=edit&oid=", "id"); $mit->setValue("löschen", ""); $mit->setFormat("ifempty", "löschen"); $mit->setFormat("link", "index.php?page=" . $page . "&subpage=" . $subpage . "&func=delete&oid=", "id", "", " onclick=\"return confirm('sicher löschen ?');\""); if (isset($FORM["ordername"]) && isset($FORM["ordertype"])) { $mit->setOrder($FORM["ordername"], $FORM["ordertype"]);
} 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("Kommentar id", "id"); $mit->setValueOrder(1); $mit->setValue("Artikel Bezeichnung", "article_id"); $mit->setFormat("replace_value", $articleReplaceValue); $mit->setValue("Artikel ID", "article_id"); $mit->setValueOrder(1); $mit->setValue("Kommentar von", "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->setFormat("replace_value", "0|<span style='color:#cc6666;'>inaktiv</span>|1|<span style='color:#66cc66;'>aktiv</span>"); $mit->setValueOrder(1); $mit->setValue("editieren", "");
} } //------------------------------> Userliste if ($func == "") { // ***** add echo "<table cellpadding=5 class=rex-table><tr><td><a href=index.php?page=" . $page . "&subpage=" . $subpage . "&func=add><b>+ {$bezeichner} anlegen</b></a></td></tr></table><br />"; // ***** Suche $addsql = ""; $link = ""; $ssql = new rex_sql(); $sql = "select * from {$table} order by prior"; $mit = new rexlist(); $mit->setQuery($sql); $mit->setList(50); $mit->setGlobalLink("index.php?page=" . $page . "&subpage=" . $subpage . "" . $link . "&next="); $mit->setValue("prior", "prior"); $mit->setValue("id", "id"); $mit->setValue("Name", "name"); $mit->setValueOrder(1); $mit->setLink("index.php?page=" . $page . "&subpage=" . $subpage . "&func=edit&oid=", "id"); $mit->setValue("Userfield", "userfield"); $mit->setValue("Typ", "type"); $mit->setFormat("replace_value", $rep); $mit->setValue("In Übersicht", "inlist"); $mit->setFormat("replace_value", "0|nein|1|ja"); $mit->setValue("Editierbar", "editable"); $mit->setFormat("replace_value", "0|nein|1|ja"); $mit->setValue("Pflichtfeld", "mandatory"); $mit->setFormat("replace_value", "0|nein|1|ja"); $mit->setValue("löschen", ""); $mit->setFormat("ifempty", "- löschen");
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 löschen if ($func == "delete") { $query = "delete from rex_5_group where id='" . $oid . "' "; $delsql = new sql(); $delsql->debugsql = 0; $delsql->setQuery($query); $func = ""; } //------------------------------> Userliste if ($func == "") { $sql = "select * from rex_5_group order by id"; $mit = new rexlist(); $mit->setQuery($sql); $mit->setGlobalLink("index.php?page=" . $mypage . "&subpage=" . $subpage . "&next="); $mit->setValue("id", "id"); $mit->setValue("Name", "name"); $mit->setLink("index.php?page=" . $mypage . "&subpage=" . $subpage . "&func=edit&oid=", "id"); $mit->setValue("löschen", ""); $mit->setFormat("ifempty", "- löschen"); $mit->setFormat("link", "index.php?page=" . $mypage . "&subpage=" . $subpage . "&func=delete&oid=", "id", "", " onclick=\"return confirm('sicher löschen ?');\""); echo $mit->showall($next); echo "<br /><table cellpadding=5 class=rex><tr><td><a href=index.php?page=" . $mypage . "&subpage=" . $subpage . "&func=add><b>+ {$bezeichner} anlegen</b></a></td></tr></table>"; }
$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>"; }
} if ($FORM['cstatus'] != "") { if ($addsql == "") { $addsql .= " WHERE "; } else { $addsql .= " AND "; } $addsql .= " `user_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("Login", "user_login"); $mit->setValueOrder(1); $mit->setLink("index.php?page=" . $mypage . "&subpage=" . $subpage . "&func=edit&oid=", "id"); $mit->setValue("Vorname", "user_firstname"); $mit->setValueOrder(1); $mit->setValue("Name", "user_name"); $mit->setValueOrder(1); //$mit->setValue("Status","user_status"); //$mit->setFormat("replace_value","0|<span style='color:#cc6666;'>inaktiv</span>|1|<span style='color:#66cc66;'>aktiv</span>"); // $mit->setValueOrder(1); $mit->setValue("Status", "user_status"); $mit->setFormat("replace_value", "0|<span style='color:#cc6666;'>inaktiv</span>|1|<span style='color:#66cc66;'>aktiv</span>"); $mit->setValueOrder(1); $mit->setValue("löschen", ""); $mit->setFormat("ifempty", "- löschen");