MySQL-Admin

 view release on metacpan or  search on metacpan

cgi-bin/Content/admin.pl  view on Meta::CPAN

$te  = translate('env');
$tna = translate('navigation');
$tr  = translate('trash');
$trn = translate('translate');
print qq|<table align="center" border="0" cellpadding="5" cellspacing="5" class="ShowTables marginTop" summary="adminlayout" >
<tr>
<td align="center"><img src="style/$m_sStyle/buttons/settings.png" alt="$ts" border="0" title="$ts"/><br/><a href="javascript:requestURI('$m_hrSettings->{cgi}{serverName}$ENV{SCRIPT_NAME}?action=settings','settings','settings')">$ts</a></td>
<td align="center"><img src="style/$m_sStyle/buttons/mysql.jpg" alt="$td" border="0" title="$td"/><br/><a href="javascript:requestURI('$m_hrSettings->{cgi}{serverName}$ENV{SCRIPT_NAME}?action=ShowDatabases','ShowDatabases','ShowDatabases')">$td</a>
</td>
</tr></tr>
<td align="center"><img src="style/$m_sStyle/buttons/folder_txt.png" alt="$tna" border="0" title="$tna"/><br/><a href="javascript:requestURI('$m_hrSettings->{cgi}{serverName}$ENV{SCRIPT_NAME}?action=editTreeview','editTreeview','editTreeview')">$tna<...
<td align="center"><img src="style/$m_sStyle/buttons/bookmark.png" alt="$tl" border="0" title="$tl"/><br/><a href="javascript:requestURI('$m_hrSettings->{cgi}{serverName}$ENV{SCRIPT_NAME}?action=editTreeview&dump=links','editTreeview','editTreeview')...
</tr><tr>
<td align="center"><img src="style/$m_sStyle/buttons/explorer.png" alt="$tf" border="0" title="$tf"/><br/><a href="javascript:requestURI('$m_hrSettings->{cgi}{serverName}$ENV{SCRIPT_NAME}?action=showDir','showDir','showDir')">$tf</a></td>
<td align="center"><img src="style/$m_sStyle/buttons/env.png" alt="$te" border="0" title="$te"/><br/><a href="javascript:requestURI('$m_hrSettings->{cgi}{serverName}$ENV{SCRIPT_NAME}?action=env','env','env')">$te</a></td>
</tr>
<tr>
<td align="center"><img src="style/$m_sStyle/buttons/trash.png" alt="$tr" border="0" title="$tr"/><br/><a href="javascript:requestURI('$m_hrSettings->{cgi}{serverName}$ENV{SCRIPT_NAME}?action=trash','trash','trash')">$tr</a></td>
<td align="center"><img src="style/$m_sStyle/buttons/translate.png" alt="$trn" border="0" title="$trn"/><br/><a href="javascript:requestURI('$m_hrSettings->{cgi}{serverName}$ENV{SCRIPT_NAME}?action=translate','translate','translate')">$trn</a></td>
</tr></table><br/>|;
1;

cgi-bin/Content/editTree.pl  view on Meta::CPAN

    action   => 1,
    folder   => 1,
    subtree  => 1,
    class    => 1,
    dump     => 1,
    sid      => 1,
    m_bLogin => 1
);
%params = Vars();

sub linkseditTreeview {
    $m_sPdmp = 'links';
    $m_sDump = $m_hrSettings->{tree}{'links'};
    editTreeview();
} ## end sub linkseditTreeview

sub newTreeviewEntry {
    $m_sPdmp = param('dump') ? param('dump') : 'navigation';
    $m_sDump = $m_hrSettings->{tree}{$m_sPdmp};
    &newEntry();
} ## end sub newTreeviewEntry

sub saveTreeviewEntry {
    &load();
    &saveEntry( \@m_aTree, $m_nPrid );
    _Tree();
} ## end sub saveTreeviewEntry

sub addTreeviewEntry {
    &load();
    &addEntry( \@m_aTree, $m_nPrid );
    _Tree();
} ## end sub addTreeviewEntry

sub editTreeview {
    &load();
    &rid();
    saveTree( $m_sDump, \@m_aTree );
    _Tree();
} ## end sub editTreeview

sub _Tree {
    &updateTree( \@m_aTree );
    TrOver(1);
    print
qq(<div align="center"><form action="$m_hrSettings->{cgi}{serverName}$ENV{SCRIPT_NAME}" method="POST" enctype="multipart/form-data" onsubmit="submitForm(this,'deleteTreeviewEntrys','deleteTreeviewEntrys');return false;"  accept-charset="UTF-8"><input...
    print table(
        {
            align => 'center',
            width => '100%'
        },
        Tr( td( Tree( \@m_aTree ) ) )
    );
    my $delete   = translate('delete');
    my $mmark    = translate('selected');
    my $markAll  = translate('select_all');
    my $umarkAll = translate('unselect_all');
    my $rebuild  = translate('rebuild');
    print
qq{</td></tr><tr><td><script language="Javascript">m_sDump = '$m_sPdmp';</script><table align="center" border="0" cellpadding="0"  cellspacing="0" summary="layout" width="100%" ><tr><td style="padding-left:18px;text-align:left;"><a id="markAll" href=...
    TrOver(0);
    undef @m_aTree;
} ## end sub _Tree

sub editTreeviewEntry {
    &load();
    &editEntry( \@m_aTree, $m_nPrid );
} ## end sub editTreeviewEntry

sub deleteTreeviewEntry {
    &load();
    &deleteEntry( \@m_aTree, $m_nPrid );
    _Tree();
} ## end sub deleteTreeviewEntry

sub upEntry {
    &load();
    &sortUp( \@m_aTree, $m_nPrid );
    _Tree();
} ## end sub upEntry

sub MoveTreeViewEntry {
    &load();
    my $from = param('from');

cgi-bin/Content/editTree.pl  view on Meta::CPAN

        &load();
        &rid();
        saveTree( $m_sDump, \@m_aTree );
        $m_nPrid = $m_nRid;
        $push    = '<input type="hidden" name="addBookMark" value="addBookMark"/>';
    } ## end if ( param('addBookMark'...))
    my $new = translate('newEntry');
    print qq(
<div align="center" class="marginTop">
<b>$new</b>
<form action="$m_hrSettings->{cgi}{serverName}$ENV{SCRIPT_NAME}" onsubmit="submitForm(this,'addTreeviewEntry','addTreeviewEntry');return false;">
<input type="hidden" name="rid" value="a$m_nPrid"/>$push<br/>
<table align="center" class="mainborder" cellpadding="2"  cellspacing="2" summary="mainLayolut">
<tr><td>) . translate('txt') . qq(</td><td><input type="text" value="$value" name="text"/></td></tr>
<tr><td>) . translate('folder') . qq(</td><td><input type="checkbox" name="folder"/></td></tr>);
    print qq(<tr><td>) . translate('right') . qq(</td><td><input type="text" value="$node->{right}" name="right" /></td></tr>);
    language('de') if $ACCEPT_LANGUAGE eq 'de';
    my $node = help();

    foreach my $key ( sort keys %{$node} ) {
        $value = "";
        $value = param('addBookMark') if ( $key eq 'href' && param('addBookMark') );
        $value = param('title') if ( $key eq 'title' && param('title') );
        $value = 'a' . $m_nPrid if ( $key eq 'id' && param('addBookMark') );
        print
          qq(<tr><td></td><td>$node->{$key}</td></tr><tr><td>$key :</td><td><input type="text" value="$value" name="$key" id="$key"/><br/></td></tr>)
          unless $disallowedKeys{$key};
    } ## end foreach my $key ( sort keys...)
    print
qq|<tr><td><input type="hidden" name="action" value="addTreeviewEntry"/><input type="hidden" name="dump" value="$m_sPdmp"/></td><td><input type="submit"/></td></tr></table></form></div>|;
} ## end sub newEntry

sub addEntry {
    my $t    = shift;
    my $find = shift;
    $find = $find ? $find : 1;
    for ( my $i = 0 ; $i < @$t ; $i++ ) {
        if ( @$t[$i]->{rid} eq $find ) {
            my %params = Vars();
            my $node   = {};

cgi-bin/Content/editTree.pl  view on Meta::CPAN

            return;
        } elsif ( ref @$t[$i]->{subtree}[0] eq "HASH" ) {
            &saveEntry( \@{ @$t[$i]->{subtree} }, $find );
        } ## end elsif ( ref @$t[$i]->{subtree...})
    } ## end for ( my $i = 0 ; $i < ...)
} ## end sub saveEntry

sub editEntry {
    my $t    = shift;
    my $find = shift;
    my $href = "submitForm(this ,'editTreeviewEntry','editTreeviewEntry');return false;";
    language('de') if $ACCEPT_LANGUAGE eq 'de';
    my $node = help();
    for ( my $i = 0 ; $i < @$t ; $i++ ) {
        if ( @$t[$i]->{rid} eq $find ) {
            print '<div align="center" class="marginTop"><b>'
              . @$t[$i]->{text}
              . '</b><form onsubmit="'
              . $href
              . '"><table align=" center " class=" mainborder " cellpadding="0"  cellspacing="0" summary="mainLayolut">';
            print qq(<tr><td>) . translate('txt') . qq(</td><td><input type="text" value="@$t[$i]->{text}" name="text" /></td></tr>);

cgi-bin/Content/editTree.pl  view on Meta::CPAN

                    return +1        if @$t[$i]->{$b};
                    return $a cmp $b;
                } keys %{$node}
            ) {
                unless ( $disallowedKeys{$key2} ) {
                    print
qq(<tr><td></td><td>$node->{$key2}</td></tr><tr><td>$key2 :</td><td><input type="text" value="@$t[$i]->{$key2}" name="$key2"/><br/></td></tr>);
                } ## end unless ( $disallowedKeys{$key2...})
            } ## end foreach my $key2 ( sort { return...})
            print
qq(<tr><td><input type="hidden" name="action" value="saveTreeviewEntry"/><input type="hidden" name="rid" value="@$t[$i]->{rid}"/><input type="hidden" name="dump" value="$m_sPdmp"/></td><td><input type="submit" value="save"/></td></tr></table></form><...
            saveTree( $m_sDump, \@m_aTree );
            return;
        } elsif ( ref @$t[$i]->{subtree}[0] eq "HASH" ) {
            &editEntry( \@{ @$t[$i]->{subtree} }, $find );
        } ## end elsif ( ref @$t[$i]->{subtree...})
    } ## end for ( my $i = 0 ; $i < ...)
} ## end sub editEntry

sub sortUp {
    my $t    = shift;

cgi-bin/Content/editTree.pl  view on Meta::CPAN

            @$t[$i]->{onmouseup} = 'confirmMove()';

            #@$t[$i]->{id}          = @$t[$i]->{id};
            @$t[$i]->{name}        = @$t[$i]->{id};
            @$t[$i]->{onmousedown} = "prepareMove('" . @$t[$i]->{id} . "')";
            @$t[$i]->{onmousemove} = "enableDropZone('" . @$t[$i]->{id} . "')";
            @$t[$i]->{onmouseout}  = "disableDropZone('" . @$t[$i]->{id} . "')";
            my $nPrevId = 'a' . ( @$t[$i]->{rid} - 1 );
            @$t[$i]->{addition} = qq|<table border="0" cellpadding="0" cellspacing="0" align="right" summary="layout"><tr>
<td><a class="treeviewLink$m_nSize" target="_blank" title="@$t[$i]->{text}" href="@$t[$i]->{href}"><img src="style/$m_sStyle/$m_nSize/mimetypes/www.png" border="0" alt=""></a></td>
<td><a class="treeviewLink$m_nSize" href="javascript:requestURI('$m_hrSettings->{cgi}{serverName}$ENV{SCRIPT_NAME}?action=editTreeviewEntry&dump=$m_sPdmp&rid=@$t[$i]->{rid}','editTreeviewEntry','editTreeviewEntry')"><img src="style/$m_sStyle/$m_nSize...
            @$t[$i]->{href} = '';
            updateTree( \@{ @$t[$i]->{subtree} } ) if ( ref @$t[$i]->{subtree}[0] eq "HASH" );
        } ## end if ( defined @$t[$i] )
    } ## end for ( my $i = 0 ; $i < ...)
} ## end sub updateTree

sub rid {
    $m_nRid = 0;
    &getRid( \@m_aTree );

cgi-bin/Content/editTree.pl  view on Meta::CPAN

    } ## end sub getRid
} ## end sub rid

sub load {
    if ( -e $m_sDump ) {
        loadTree($m_sDump);
        *m_aTree = \@{ $HTML::Menu::TreeView::TreeView[0] };
    } ## end if ( -e $m_sDump )
} ## end sub load

sub deleteTreeviewEntrys {
    &load();
    my @params = param();
    for ( my $i = 0 ; $i <= $#params ; $i++ ) {
        if ( $params[$i] =~ /markBox\d?/ ) {
            my $id = param( $params[$i] );
            &deleteEntry( \@m_aTree, $id );
        } ## end if ( $params[$i] =~ /markBox\d?/)
    } ## end for ( my $i = 0 ; $i <=...)
    editTreeview();
} ## end sub deleteTreeviewEntrys
1;

cgi-bin/Content/links.pl  view on Meta::CPAN

"javascript:requestURI('$m_hrSettings->{cgi}{serverName}$ENV{SCRIPT_NAME}?action=ExportOperaBookmarks','ExportOperaBookmarks','ExportOperaBookmarks')",
            title => translate('ExportOperaBookmarks')
        },
        translate('ExportOperaBookmarks')
    );
    print '<br/>'
      . a(
        {
            class => 'link',
            href =>
"javascript:requestURI('$m_hrSettings->{cgi}{serverName}$ENV{SCRIPT_NAME}?action=editTreeview&dump=links','editTreeview','editTreeview')",
            title => translate('edit')
        },
        translate('edit')
      ) if ( $m_nRight >= $m_oDatabase->getActionRight('editTreeview') );
    print ' '
      . a(
        {
            class => $m_sAction eq 'ImportOperaBookmarks'
            ? 'currentLink'
            : 'link',
            href =>
"javascript:requestURI('$m_hrSettings->{cgi}{serverName}$ENV{SCRIPT_NAME}?action=ImportOperaBookmarks','ImportOperaBookmarks','ImportOperaBookmarks')",
            title => translate('ImportOperaBookmarks')
        },

extra/install.sql  view on Meta::CPAN

INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('delete','news.pl','blog','0','deleteNews','html',NULL,'65');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('edit','news.pl','blog','0','editNews','html',NULL,'66');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('saveedit','news.pl','blog','0','saveedit','html',NULL,'67');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('reply','news.pl','blog','0','replyNews','html',NULL,'68');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('profile','profile.pl','Profile','1','main','html',NULL,'69');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('reg','reg.pl','register','0','reg','html',NULL,'70');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('addReply','news.pl','blog','0','addReply','html',NULL,'71');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('showthread','news.pl','blog','0','showMessage','html',NULL,'72');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('verify','reg.pl','verify','0','verify','html',NULL,'73');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('fulltext','search.pl','search','0','fulltext','html',NULL,'74');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('newTreeviewEntry','editTree.pl','newTreeViewEntry','5','newTreeviewEntry','html',NULL,'75');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('saveTreeviewEntry','editTree.pl','saveTreeviewEntry','5','saveTreeviewEntry','html',NULL,'76');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('editTreeview','editTree.pl','editTreeview','5','editTreeview','html',NULL,'77');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('addTreeviewEntry','editTree.pl','addTreeviewEntry','5','addTreeviewEntry','html',NULL,'78');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('editTreeviewEntry','editTree.pl','editTreeviewEntry','5','editTreeviewEntry','html',NULL,'79');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('deleteTreeviewEntry','editTree.pl','deleteTreeviewEntry','5','deleteTreeviewEntry','html',NULL,'80');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('upEntry','editTree.pl','upEntry','5','upEntry','html',NULL,'81');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('downEntry','editTree.pl','downEntry','5','downEntry','html',NULL,'82');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('links','links.pl','Bookmarks','0','ShowBookmarks','html',NULL,'83');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('env','env.pl','env','5','main','html',NULL,'84');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('lostpass','login.pl','lostpass','0','lostpass','html',NULL,'85');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('getpass','login.pl','getpass','0','getpass','html',NULL,'86');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('showDir','files.pl','Files','5','showDir','html',NULL,'87');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('FileOpen','files.pl','FileOpen','5','FileOpen','html',NULL,'88');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('newFile','files.pl','newFile','5','newFile','html',NULL,'89');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('saveFile','files.pl','saveFile','5','saveFile','html',NULL,'90');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('showMessage','news.pl','blog','0','main','html',NULL,'91');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('chmodFile','files.pl','chmodFile','5','chmodFile','html',NULL,'92');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('deleteFile','files.pl','deleteFile','5','deleteFile','html',NULL,'93');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('makeDir','files.pl','Files','5','makeDir','html',NULL,'94');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('newGbookEntry','gbook.pl','gbook','0','newGbookEntry','html',NULL,'95');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('addnewGbookEntry','gbook.pl','gbook','0','addnewGbookEntry','html',NULL,'96');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('gbook','gbook.pl','gbook','0','showGbook','html',NULL,'97');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('deleteExploit','admin.pl','Admin','5','deleteExploit','html',NULL,'98');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('ImportOperaBookmarks','links.pl','ImportOperaBookmarks','5','ImportOperaBookmarks','html',NULL,'99');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('linkseditTreeview','editTree.pl','linkseditTreeview','5','linkseditTreeview','html',NULL,'100');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('EditFile','files.pl','EditAction','5','EditFile','html',NULL,'101');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('ExportOperaBookmarks','links.pl','ExportOperaBookmarks','0','ExportOperaBookmarks','html',NULL,'102');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('MoveTreeViewEntry','editTree.pl','MoveTreeViewEntry','5','MoveTreeViewEntry','html',NULL,'103');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('chownFile','files.pl','chownFile','5','chownFile','html',NULL,'104');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('ImportFireFoxBookmarks','links.pl','ImportFireFoxBookmarks','5','ImportFireFoxBookmarks','html',NULL,'105');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('rebuildtrash','news.pl','weblog','0','rebuildtrash','html',NULL,'106');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('trash','news.pl','trash','5','trash','html',NULL,'107');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('showaddTranslation','addtranslate.pl','showaddTranslation','5','main','html',NULL,'108');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('translate','translate.pl','translate','5','main','html',NULL,'109');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('deleteTreeviewEntrys','editTree.pl','Edit','5','deleteTreeviewEntrys','html',NULL,'110');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('makeUser','reg.pl','register','0','make','html',NULL,'111');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('navigation','navigation.pl','navigation','0','main','html',NULL,'112');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('mainMenu','main.pl','Menu','0','main','html',NULL,'113');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('impressum','impressum.pl','Impressum','0','main','html',NULL,'114');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('HelpTopics','tables.pl','HelpTopics','5','HelpTopics','html',NULL,'115');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('makePassword','reg.pl','makePassword','0','makePassword','html',NULL,'116');
INSERT INTO `actions` (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('lostPassword','reg.pl','lostPassword','0','lostPassword','html',NULL,'117');
INSERT INTO actions (`action`,`file`,`title`,`right`,`sub`,`type`,`xsl`,`id`) values('datenschutz','datenschutz.pl','Datenschutzerklärung','0','main','html',NULL,'118');

CREATE TABLE `actions_set` (

extra/install.sql  view on Meta::CPAN

INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('delete','delete','content','62');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('edit','edit','content','63');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('saveedit','saveedit','content','64');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('reply','reply','content','65');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('profile','profile','content','66');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('reg','reg','content','67');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('addReply','addReply','content','68');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('showthread','showthread','content','69');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('verify','verify','content','70');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('fulltext','fulltext','content','71');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('newTreeviewEntry','newTreeviewEntry','content','72');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('saveTreeviewEntry','saveTreeviewEntry','content','73');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('editTreeview','editTreeview','content','74');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('addTreeviewEntry','addTreeviewEntry','content','75');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('editTreeviewEntry','editTreeviewEntry','content','76');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('deleteTreeviewEntry','deleteTreeviewEntry','content','77');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('upEntry','upEntry','content','78');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('downEntry','downEntry','content','79');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('links','links','content','80');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('env','env','content','81');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('lostpass','lostpass','content','82');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('getpass','getpass','content','83');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('showDir','showDir','content','84');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('FileOpen','FileOpen','content','85');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('newFile','newFile','content','86');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('saveFile','saveFile','content','87');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('showMessage','showMessage','content','88');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('chmodFile','chmodFile','content','89');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('deleteFile','deleteFile','content','90');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('makeDir','makeDir','content','91');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('newGbookEntry','newGbookEntry','content','92');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('addnewGbookEntry','addnewGbookEntry','content','93');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('gbook','gbook','content','94');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('deleteExploit','deleteExploit','content','95');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('ImportOperaBookmarks','ImportOperaBookmarks','\r\ncontent','96');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('linkseditTreeview','linkseditTreeview','content','97');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('EditFile','EditFile','content','98');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('ExportOperaBookmarks','ExportOperaBookmarks','content','99');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('MoveTreeViewEntry','MoveTreeViewEntry','content','100');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('chownFile','chownFile','content','101');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('ImportFireFoxBookmarks','ImportFireFoxBookmarks','content','102');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('rebuildtrash','rebuildtrash','content','103');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('trash','trash','content','104');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('showaddTranslation','showaddTranslation','content','105');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('translate','translate','content','106');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('deleteTreeviewEntrys','deleteTreeviewEntrys','content','107');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('makeUser','makeUser','content','108');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('default','navigation','treeview','109');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('default','login','loginContent','110');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('showDatabases','quickbar','quickbar','111');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('showLogin','login','content','112');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('mainMenu','mainMenu','menuBar','113');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('impressum','impressum','content','114');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('ShowTables','quickbar','quickbar','121');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('HelpTopics','HelpTopics','content','122');
INSERT INTO `actions_set` (`action`,`foreign_action`,`output_id`,`id`) values('makePassword','makePassword','content','123');

extra/install.sql  view on Meta::CPAN

CREATE TABLE `submenuadmin` (
  `title` varchar(100) NOT NULL DEFAULT '',
  `action` varchar(100) NOT NULL DEFAULT '',
  `src` varchar(100) NOT NULL DEFAULT 'link.gif',
  `right` int(11) NOT NULL DEFAULT '0',
  `submenu` varchar(100) DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
INSERT INTO `submenuadmin` (`title`,`action`,`src`,`right`,`submenu`,`id`) values('settings','settings','link.gif','5','','1');
INSERT INTO `submenuadmin` (`title`,`action`,`src`,`right`,`submenu`,`id`) values('navigation','editTreeview','','5','','2');
INSERT INTO `submenuadmin` (`title`,`action`,`src`,`right`,`submenu`,`id`) values('env','env','link.gif','5','','3');
INSERT INTO `submenuadmin` (`title`,`action`,`src`,`right`,`submenu`,`id`) values('Editlinks','linkseditTreeview','link.gif','6','','4');
INSERT INTO `submenuadmin` (`title`,`action`,`src`,`right`,`submenu`,`id`) values('Explorer','showDir','link.gif','5','','5');
INSERT INTO `submenuadmin` (`title`,`action`,`src`,`right`,`submenu`,`id`) values('trash','trash','','5','','6');
INSERT INTO `submenuadmin` (`title`,`action`,`src`,`right`,`submenu`,`id`) values('translate','translate','link.png','5','','7');

CREATE TABLE `trash` (
  `table` varchar(50) NOT NULL DEFAULT '',
  `oldId` bigint(50) NOT NULL DEFAULT '0',
  `title` varchar(100) NOT NULL DEFAULT '',
  `body` text NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,



( run in 0.629 second using v1.01-cache-2.11-cpan-49f99fa48dc )