PHP rexlist Examples

Example #1

File: index.inc.php Project: BackupTheBerlios/redaxo-addons

        }
    }
}
//------------------------------> 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";
?>

Example #2

File: toolbars.inc.php Project: BackupTheBerlios/gbforredaxo

/**
 * Addon Framework Classes 
 * @author staab[at]public-4u[dot]de Markus Staab
 * @author <a href="http://www.public-4u.de">www.public-4u.de</a>
 * @package redaxo3
 * @version $Id: toolbars.inc.php,v 1.1 2006/06/24 11:04:17 koala_s Exp $
 */
//------------------------------> Eintragsliste
if ($func == '') {
    /* 
     * Liste anlegen 
     */
    // Standard sortierung nach Name aufsteigend
    // Standard suchspalte ist Name
    $sql = 'SELECT * FROM rex_article';
    $list = new rexlist($sql, 'Name', 'ASC', 'Name');
    /*
     * Spalten aus dem SQL-ResultSet anlegen 
     */
    $colId = new resultColumn('id', 'ID');
    $colName = new resultColumn('name', 'Name');
    $colPrio = new resultColumn('catprior', 'Prio');
    $colUpdate = new resultColumn('updateuser', 'Aktualisiert von');
    $colCreate = new resultColumn('createuser', 'Erstellt von');
    /*
     * Statische Spalten anlegen 
     */
    // Lösch link
    $colAction = new staticColumn('Aktion', 'l&ouml;schen');
    /*
     *  Sonder Spalten anlegen 

Example #3

File: messages.inc.php Project: BackupTheBerlios/redaxo-addons

         $addsql = substr($addsql, 0, strlen($addsql) - 3);
         $addsql .= ")";
     }
     $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);

Example #4

File: user.inc.php Project: BackupTheBerlios/redaxo-addons

    $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>&laquo; 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>";
}

Example #5

File: list_variables.inc.php Project: BackupTheBerlios/redaxo-addons

Platzhalter: Nach der Liste
  LIST_VAR_BOTTOM
Platzhalter: Erscheint, wenn die Liste keine Datensätze enthält
  LIST_VAR_NO_DATA
*/
if ($func == '') {
    /*
     *  Liste anlegen
     */
    if (empty($category_id)) {
        $category_id = 0;
    }
    $sql = 'SELECT * FROM rex_article WHERE re_id=' . $category_id . ' AND startpage=1 AND clang=' . $clang;
    // Standard sortierung nach CATPRIOR aufsteigend
    // Standard suchspalte ist Name
    $list = new rexlist($sql, 'catprior', 'asc', 'name');
    $list->setVar(LIST_VAR_TOP, '<p>First Header<p>');
    $list->setVar(LIST_VAR_BEFORE_HEAD, '<p>Before Head</p>');
    $list->setVar(LIST_VAR_AFTER_HEAD, '<p>After Head</p>');
    $list->setVar(LIST_VAR_BEFORE_DATAHEAD, '<p>Before DataHead</p>');
    $list->setVar(LIST_VAR_AFTER_DATAHEAD, '<tr><td colspan="3">After DataHead</td></tr>');
    $list->setVar(LIST_VAR_BEFORE_DATA, '<tr><td colspan="3">Before Data</td></tr>');
    $list->setVar(LIST_VAR_AFTER_DATA, '<tr><td colspan="3">After Data</td></tr>');
    $list->setVar(LIST_VAR_BEFORE_FOOT, '<p>Before Foot</p>');
    $list->setVar(LIST_VAR_AFTER_FOOT, '<p>After Foot</p>');
    $list->setVar(LIST_VAR_BOTTOM, '<p>Bottom</p>');
    $list->setVar(LIST_VAR_NO_DATA, '<p>No Data</p>');
    /*
     *  Spalten aus dem SQL-ResultSet anlegen
     */
    $colId = new resultColumn('id', 'ID');

Example #6

File: structure.inc.php Project: BackupTheBerlios/gbforredaxo

 * @author <a href="http://www.public-4u.de">www.public-4u.de</a>
 * @package redaxo3
 * @version $Id: structure.inc.php,v 1.2 2007/02/01 21:44:28 koala_s Exp $
 */
//------------------------------> Eintragsliste
if ($func == '') {
    /*
     *  Liste anlegen 
     */
    if (empty($category_id)) {
        $category_id = 0;
    }
    $sql = 'SELECT * FROM rex_article WHERE re_id=' . $category_id . ' AND startpage=1 AND clang=' . $clang;
    // Standard sortierung nach CATPRIOR aufsteigend
    // Standard suchspalte ist Name
    $list = new rexlist($sql, 'catprior', 'asc', 'name');
    /*
     *  Spalten aus dem SQL-ResultSet anlegen 
     */
    $colId = new resultColumn('id', 'ID');
    // ID zentrieren
    $colId->setBodyAttributes('style="text-align: center"');
    $colName = new resultColumn('name', 'Kategorie', '', '%name% [%id%]');
    $colPrio = new resultColumn('catprior', 'Prio');
    /*
     *  Statische Spalten anlegen 
     */
    // Icon Spalte
    $colIcon = new staticColumn('<img src="pics/folder.gif"/>', '<img src="pics/folder_plus.gif"/>');
    // Icons zentrieren
    $colIcon->setHeadAttributes('style="text-align: center"');

Example #7

File: formats.inc.php Project: BackupTheBerlios/redaxo-addons

 * Addon Framework Classes
 * @author staab[at]public-4u[dot]de Markus Staab
 * @author <a href="http://www.public-4u.de">www.public-4u.de</a>
 * @package redaxo3
 * @version $Id: formats.inc.php,v 1.2 2007/08/24 10:35:36 kills Exp $
 */
echo '<h1>Diese Demo zeigt wie man mit Formatierungsfunktionen die Inhalte verändern kann</h1>';
//------------------------------> Eintragsliste
if ($func == '') {
    /**
     *  Liste anlegen
     */
    // Standard sortierung nach Name aufsteigend
    // Standard suchspalte ist Name
    $sql = 'SELECT * FROM rex_article';
    $list = new rexlist($sql, 'Name', 'ASC', 'Name');
    /**
     *  Spalten aus dem SQL-ResultSet anlegen
     */
    $colId = new resultColumn('id', 'ID');
    // String formatiert mit sprintf() im format '-> [%s] <-'
    $colName = new resultColumn('name', 'Name', 'sprintf', '-> [%s] <-');
    $colPrio = new resultColumn('catprior', 'Prio');
    // Datum formatiert mit date() im format 'd.m.Y'
    $colUpdate = new resultColumn('updatedate', 'Aktualisiert am', 'date', 'd.m.Y');
    // Datum formatiert mit strftime() im format '%d.%m.%Y %H-%M'
    $colCreate = new resultColumn('createdate', 'Erstellt am', 'strftime', '%d.%m.%Y %H-%M');
    /**
     *  Statische Spalten anlegen
     */
    // Lösch link

Example #8

File: settings.inc.php Project: BackupTheBerlios/redaxo

    $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
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>";
}

Example #9

File: index.inc.php Project: BackupTheBerlios/redaxo-svn

    $query = "delete from {$table} where id='" . $oid . "' ";
    $delsql = new rex_sql();
    $delsql->debugsql = 0;
    $delsql->setQuery($query);
    $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", "");

Example #10

File: index.inc.php Project: BackupTheBerlios/redaxo-addons

} else {
    $short_id = (int) $short_id;
}
if (!isset($func)) {
    $func = '';
}
//------------------------------> Eintragsliste
if ($func == '') {
    require_once $Basedir . '/../../addon_framework/classes/list/class.rex_list.inc.php';
    /**
     *  Liste anlegen 
     */
    $sql = 'SELECT * FROM rex_13_glossar, rex_13_glossar_lang WHERE language = lang_id';
    // Standard sortierung nach shortcut aufsteigend
    // Standard suchspalte ist shortcut
    $list = new rexlist($sql, 'shortcut', 'asc', 'shortcut');
    $list->setLabel($I18N_GLOSSAR->msg('label_list'));
    $list->setName('glossarlist');
    $list->setColGroup(array('50px', '*', '85px', '45px', '*'));
    // $list->debug = true;
    /**
     *  Spalten aus dem SQL-ResultSet anlegen 
     */
    $colId = new resultColumn('short_id', $I18N_GLOSSAR->msg('label_id'));
    $colShort = new resultColumn('shortcut', $I18N_GLOSSAR->msg('label_shortcut'));
    $colDesc = new resultColumn('description', $I18N_GLOSSAR->msg('label_description'));
    $colLang = new resultColumn('lang_name', $I18N_GLOSSAR->msg('label_language'));
    $colCase = new resultColumn('casesense', $I18N_GLOSSAR->msg('label_casesens'));
    // ID zentrieren
    $colId->setBodyAttributes('style="text-align: center;"');
    // colCase Werte übersetzen

Example #11

File: entries.inc.php Project: BackupTheBerlios/redaxo-addons

$Basedir = dirname(__FILE__);
if (!isset($entry_id)) {
    $entry_id = 0;
} else {
    $entry_id = (int) $entry_id;
}
//------------------------------> Eintragsliste
if ($func == '') {
    require_once $Basedir . '/../../addon_framework/classes/list/class.rex_list.inc.php';
    /**
     *  Liste anlegen 
     */
    $sql = 'SELECT * FROM ' . TBL_GBOOK;
    // Standard sortierung nach id absteigend
    // Standard author ist shortcut
    $list = new rexlist($sql, 'id', 'desc', 'author');
    $list->setLabel($I18N_GBOOK->msg('label_list'));
    //$list->debug = true;
    /**
     *  Spalten aus dem SQL-ResultSet anlegen 
     */
    $colId = new resultColumn('id', $I18N_GBOOK->msg('label_id'));
    $colAuthor = new resultColumn('author', $I18N_GBOOK->msg('label_author'));
    $colMsg = new resultColumn('message', $I18N_GBOOK->msg('label_message'), 'truncate');
    $colUrl = new resultColumn('url', $I18N_GBOOK->msg('label_url'), 'url');
    $colCreated = new resultColumn('created', $I18N_GBOOK->msg('label_created'), 'strftime', 'datetime');
    // ID zentrieren
    $colId->setBodyAttributes('style="text-align: center;"');
    /**
     *  Statische Spalten anlegen 
     */

Example #12

File: user_fields.inc.php Project: BackupTheBerlios/redaxo-svn

            $delsql->setQuery($query);
            $func = "";
            $gf->setQuery("ALTER TABLE `{$table_user}` DROP `" . $gf->getValue("userfield") . "`");
        }
    }
}
//------------------------------> 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");

Example #13

File: group.inc.php Project: BackupTheBerlios/redaxo-addons

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

Example #14

File: user.inc.php Project: BackupTheBerlios/redaxo-addons

    $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>";
}

Example #15

File: user.inc.php Project: BackupTheBerlios/redaxo-addons

         $addsql = substr($addsql, 0, strlen($addsql) - 3);
         $addsql .= ")";
     }
     $link .= "&FORM[csuche]=" . $FORM['csuche'];
 }
 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");