MySQL-Admin

 view release on metacpan or  search on metacpan

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

            )
        )
    ),
    Tr(
        {
            -align  => 'left',
            -valign => 'top'
        },
        td('Language'),
        td(
            popup_menu(
                -onchange => 'setLang(this.options[this.options.selectedIndex].value)',
                -name     => 'lang',
                -values   => [@l],
                -style    => 'width:100%'
            ),
        )
    ),
    Tr(
        {
            -align  => 'right',

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

                      )
                    : ''
                  )
              )
            : ''
        );
        my $toolbar = a(
            {
                class => 'toolbarButton',
                onclick =>
q|document.getElementById('popupContent1').style.left='5%';document.getElementById('popupContent1').style.width='90%';showPopup('NewEntry');|,
                onmouseover => q|window.status='| . translate('NewEntry') . q|'|,
                title       => translate('NewEntry')
            },
            translate('NewEntry')
        );    #2
        $toolbar .= a(
            {
                class   => 'toolbarButton',
                onclick => q|showPopup('SqlSearch')|,
                title   => translate('search')

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

        $return .=
          $type eq 'LONGBLOB'
          ? '<option selected="selected"  value="LONGBLOB">LONGBLOB</option>'
          : '<option value="LONGBLOB">LONGBLOB</option>';
        $return .= qq|</select>
      <script language="JavaScript">ChangeToolTip('ChooseType$typId','$type');</script>
      </td><td>
      <div id="SET$name" | . ( $type ne 'SET' ? 'style="display:none;"' : '' ) . qq|>
      <a id="dropdown$name" class="dropdownLink" onclick="showMenu('dropdown$name','setContent$name');"><img src="style/$m_sStyle/buttons/edit.png"  title="Edit"/></a></div>
      </td></tr></table>
      <div id="setContent$name" align="center" style="display:none" class="popupMenu">
      <div class="selectBox">
      <div align="right">
      <a class="setButton" style="color:red;" onclick="deleteEntry('select$name');" title="remove">-</a>
      <a class="setButton" onclick="addEntry('select$name','lineEditSet$name');" title="add">+</a>
      <select multiple="multiple" onchange="editSet('lineEditSet$name',this)" style="width:100%;height:100px;margin:0%;" id="select$name" name="SET$name" class="set" size="10" >
      $options
      </select>
      <br/>
      <input type="text" id="lineEditSet$name" class="short" onkeypress="if(enter(event))return false;" onkeyup="if(enter(event))setEnter(this,'select$name');">
      </div>

htdocs/cms.html  view on Meta::CPAN

<div id="animation_2" class="animationBox"></div>
<div id="animation_3" class="animationBox"></div>
<div id="animation_4" class="animationBox"></div>
</div>
<div class="mainFrame">
<div style="text-align:left;padding-top: 1%;padding-left: 1%;"><img onclick="location.href='index.html'" src="images/logo.png" alt="MySQL-Admin" style="cursor:pointer;"/></div>
<div id="errorMessage"></div>
<div id="tab"></div>
<div id="content" class="content"></div>
</div>
<div class="popup" id="popup" style="display:none;">
<div id="popupContent1" class="popupContent1" align="right">
<div class="popupCaption">
<div id="popupTitle" class="popupTitle" style="float:left"></div>
<div id="closeButton" class="closeButton">X</div>
</div>
<div id="popupContent" class="popupContent"></div>
</div>
</div>
</div>
<div class="menu closed" id="menu"></div>
<div id="sid"></div>
<div id="moveHere" style="display:none;" class="moveHereContent" width="100px"></div>
<div style="text-align: center"><a class="link" href="http://info@dirk-lindner.de">Copyright (C) 2019 Dirk Lindner</a></div>
</body>
</html>

htdocs/index.html  view on Meta::CPAN

<table cellpadding="0" cellspacing="0" width="100%" id="mainLayout">
<tr><td class="menu closed" id="menu" onclick="menu()" height="800"></td>
<td style="vertical-align:top;" id="con">
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr><td><div id="tab"></div></td></tr>
<tr><td id="content" class="content" style="padding-left:5px;"></td></tr>
</table>
</td>
</tr>
</table>
<div class="popup" id="popup" style="display:none;" >
<div id="popupContent1" class="popupContent1" align="right" >
<div class="popupCaption" onmousedown="startdrag('popupContent1');">
<div id="popupTitle" class="popupTitle" style="float:left"></div>
  <div id="closeButton" class="closeButton">X</div>
</div>
<div id="popupContent" class="popupContent"></div>
</div>
</div>
<div id="errorMessage"></div>
<div id="sid"></div>
<div id="postScript"></div>

<div id="moveHere" style="display:none;" class="moveHereContent" width="100px"></div>
<noscript>
This is the Website from Dirk Lindner
<br/>

htdocs/install.html  view on Meta::CPAN

</head>
<body onload="initInstaller()" style="padding:5%">
<div class="ShowTables">
<div style="text-align:left;padding:1%;padding-left: 1%;border-bottom:1px solid black;">
<img onclick="location.href='index.html';" src="images/logo.png" alt="MySQL-Admin" style="cursor:pointer"/>
</div>
Username and Passwort will be set through Installation.
<div id="errorMessage"></div>
<div id="content" class="install"></div>
</div>
<div class="popup" id="popup" style="display:none;">
<div id="popupContent1" class="popupContent1" align="right">
<div class="popupCaption">
<div id="popupTitle" class="popupTitle" style="float:left"></div>
<div id="closeButton" class="closeButton">X</div>
</div>
<div id="popupContent" class="popupContent"></div>
</div>
</div>
</div>
</body>
</html>

htdocs/javascript/cms.js  view on Meta::CPAN

 */
function intputMask(id, regexp) {
    var rxObj = regexp;
    rxObj.exec(document.getElementById(id).value);
    document.getElementById(id).value = RegExp.$1;
}
var tmpTxt;
var tmpID;

function showPopup(id, hideCloseButton) {
    visible('popup');
    if (hideCloseButton) hide('closeButton');
    else visible('closeButton');
    tmpTxt = getText(id);
    tmpID = id;
    setText(id, '');
    setText('popupTitle', translate(id));
    setText('popupContent', tmpTxt);
    evalId(id);
}

function showEditorOptions() {
    visible('popup');
    visible('closeButton');
    tmpTxt = getText('editorOptions');
    tmpID = 'editorOptions';
    setText('popupTitle', translate('editorOptions'));
    setText('popupContent', tmpTxt);
}

function closePopup() {
    hide('popup');
    if (tmpID !== 'editorOptions')
        setText(tmpID, tmpTxt);
    document.getElementById('popupContent1').style.left = '25%';
    document.getElementById('popupContent1').style.width = '50%';
}

function setCurrentTab(id, title) {
    var body = document.getElementsByTagName('body')[0];
    var nodes = body.getElementsByTagName("td");

    for (var i = 0; i < nodes.length; i++) {
        if (nodes[i].className == 'headerItemHover') {
            nodes[i].className = 'headerItem';
            nodes[i].firstChild.className = 'menuLink';

htdocs/javascript/cms.js  view on Meta::CPAN

            if (oldpage.length > 0) {
                setText('content', oldpage);
                setCurrentTab(currentId, currentTxt);
            } else {
                errorPopUp('<div style="overflow:auto">' + http_request.status + " " + http_request.responseText + "</div>", errorMessage);
            }
            return false;
        }
        if (m_sid == '123' && m_blogin && (cAction != 'reg' && cAction != 'datenschutz' && cAction != 'lostPassword' && cAction != 'make' && cAction != 'makePassword')) {
            showPopup('loginContent', true);
            evalId('popupContent');
        } else {
            var closeButton = document.getElementById("closeButton");
            closeButton.addEventListener('click', closePopup);
        }
    }
}

function alert(txt) {
    visible('popup');
    setText('popupContent', '<div align="center">' + txt + '<br/><input type="submit" id="confirmButton" value="Ok"/></div>');
    var node = document.getElementById("confirmButton");
    node.addEventListener('click', function (evt) {
        hide('popup');
    });
}
window.onerror = logError;

function logError(message, file, line) {

    var formData = new FormData();
    formData.append("message", message);
    formData.append("file", file);
    formData.append("line", line);
    formData.append("action", "logJsError");
    requestURI("cgi-bin/mysql.pl", "", "", false, formData, "POST");
    console.log("Message: " + message + "file: " + file + "line: " + line);
}

function confirm2(txt, sub, arg, arg2, arg3) {
    visible('popup');
    setText('popupContent', '<b>' + txt +
        '</b><div align="right" style="padding:0.4em;"><input type="submit" name="cancelButton" id="cancelButton" value="Cancel"/>&#160;<input  type="submit" id="confirmButton" value="Ok"/></div>'
    );
    var node = document.getElementById("confirmButton");
    node.addEventListener('click', function (evt) {
        hide('popup');
        sub(arg, arg2, arg3);
    });
    var node2 = document.getElementById("cancelButton");
    node2.addEventListener('click', function (evt) {
        hide('popup');
    });
}

function moveHere(txt, sub, arg, arg2, arg3) {
    visible('moveHere');
    window.document.title = txt;
    setText('moveHere', '<div id="moveButton" class="moveButton" style="padding:0.4em;">' + translate('MoveHere') +
        '</div><div id="moveCancelButton" class="moveButton" style="padding:0.4em;">' + translate('Cancel') + '</div>');
    var node = document.getElementById("moveButton");
    document.getElementById('moveHere').style.position = "absolute";

htdocs/javascript/cms.js  view on Meta::CPAN

function stopDrop() {
    hide('moveHere');
    dragobjekt.style.position = "";
    dropenabled = false;
    dragobjekt.className = "treeviewLink";
    dragobjekt = null;
    m_bNoDrop = false;
}

function prompt(txt, sub) {
    visible('popup');
    setText('popupContent', '<b>' + txt + '</b><br/><input  type="text" align="center" id="promptPopUp"/><br/><div align="right" style="padding:0.4em;"><input type="submit" name="cancelButton" id="cancelButton" value="Cancel"/>&#160;<input type="subm...
    var node = document.getElementById("confirmButton");
    node.addEventListener('click', function (evt) {
        hide('popup');
        sub(document.getElementById('promptPopUp').value);
    });
    var node2 = document.getElementById("cancelButton");
    node2.addEventListener('click', function (evt) {
        hide('popup');
        evt.stopPropagation();
    });
}

function disclaimer(txt, sub) {
    visible('disclaimer');
    setText('disclaimerContent', '<div align="center" style="padding:0.4em;"><b>' + txt + '</b>&#160;<input type="checkbox" onclick="$(\'#confirmButtonDisclaimer\').toggle()" /><div id="datenschutz"><a href="javascript:requestURI(\'cgi-bin/mysql.pl?a...
    var node = document.getElementById("confirmButtonDisclaimer");
    node.addEventListener('click', function (evt) {
        hide('disclaimer');
        $('#confirmButtonDisclaimer').toggle();
        privatPolicy = true;
        sub();
    });
}


function errorPopUp(txt, sub, arg, arg2, arg3) {
    visible('popup');
    setText('popupContent', '<b>' + txt + '</b><div align="right" style="padding:0.4em;">&#160;<input type="submit" id="confirmButton" value="Ok"/></div>');
    var node = document.getElementById("confirmButton");
    node.addEventListener('click', function (evt) {
        hide('popup');
        sub(arg, arg2, arg3);
    });
}

function checkForm(form) {
    var selectElement = form.querySelectorAll('input');
    var ret = true;
    for (i = 0; i < form.length; i++) {
        if (selectElement[i]) {
            var value = selectElement[i].value;

htdocs/javascript/cms.js  view on Meta::CPAN

 * insert vales from an select into autocomplete
 *
 * @param {string} id
 */
function selKeyword(id) {
    for (var i = 0; i < document.getElementById(id).options.length; i++) autocomplete.push(document.getElementById(id).options[i].value);
}
var uno = true;

function showSQLEditor() {
    document.getElementById('popupContent1').style.left = '5%';
    document.getElementById('popupContent1').style.width = '90%';
    showPopup('SqlEditor');
    oAutocomplete = document.getElementById("sqlEdit");
    oAutocomplete.addEventListener('keyup', Autocomplete);
    if (uno) {
        selKeyword('selKeyword');
        selKeyword('tablelist');
        for (var i = 0; i < document.getElementById('tablelist').options.length; i++) selKeyword(document.getElementById('tablelist').options[i].value);
    }
    uno = false;
}

function ShowNewRow() {
    document.getElementById('popupContent1').style.left = '2%';
    document.getElementById('popupContent1').style.width = '96%';
    showPopup('ShowNewRow');
}

/**
 * fake (styled) checkbox for HTML::Editor
 *
 * @param {string} id
 * @param {HTMLElement} parent
 */
function checkButton(id, parent) {

htdocs/src-min/ext-language_tools.js  view on Meta::CPAN

define("ace/snippets",["require","exports","module","ace/lib/oop","ace/lib/event_emitter","ace/lib/lang","ace/range","ace/anchor","ace/keyboard/hash_handler","ace/tokenizer","ace/lib/dom","ace/editor"],function(e,t,n){"use strict";var r=e("./lib/oop"...
                (function() {
                    window.require(["ace/ext/language_tools"], function() {});
                })();
            

htdocs/src-min/worker-css.js  view on Meta::CPAN

"no use strict";(function(e){function t(e,t){var n=e,r="";while(n){var i=t[n];if(typeof i=="string")return i+r;if(i)return i.location.replace(/\/*$/,"/")+(r||i.main||i.name);if(i===!1)return"";var s=n.lastIndexOf("/");if(s===-1)break;r=n.substr(s)+r,...

htdocs/style/mysql/cms.css  view on Meta::CPAN

}
/*opera*/
.captionRadius{
  -webkit-border-top-left-radius:15px;  
  -webkit-border-top-right-radius:15px;
  -moz-border-top-left-radius:15px;  
  -moz-border-top-right-radius:15px;
  border-top-left-radius:15px;  
  border-top-right-radius:15px;
}
.popup{
  z-index:1;
  position:fixed;
  left:0px;
  top:0px;
  width:100%;
  height:1000px;
  background-color:rgba(255,255,255,0.7);
  opacity:0.9;
  background-size:100%;
  background-position:top;
}
.popupContent1{
  position:relative;
  left:25%;
  top:100px;
  border:1px solid;
  border-radius:25px;
  -webkit-border-radius:25px; 
  -moz-border-radius:25px;
  padding:1%;
  opacity:0.9;
  width:50%;

htdocs/style/mysql/cms.css  view on Meta::CPAN

  border-color:black;
  border-radius:25px;
  -webkit-border-radius:25px; 
  -moz-border-radius:25px;
  background-color:rgba(1,90, 132,0.4);/*blue*/
  color:rgba(233, 123, 0,1);/*orange*/
  cursor:pointer;
  text-align:center;
  box-shadow:1px 1px 1px 1px rgba(0,0,0,0.4);/*black */ 
}
.popupContent{
  text-align:center;
  width:100%;
  overflow:auto;
}
/* //sidebar Menu */
.menuCaption{
  cursor:pointer;
}
.menuContent{
  width:100%;

htdocs/style/mysql/mysql_admin.css  view on Meta::CPAN

-moz-border-top-right-radius:15px;
border-top-left-radius:15px;  
border-top-right-radius:15px;
background: -webkit-linear-gradient(#d8d5d3, #eee); /* For Safari 5.1 to 6.0 */
background: -o-linear-gradient(#d8d5d3, #eee); /* For Opera 11.1 to 12.0 */
background: -moz-linear-gradient(#d8d5d3, #eee); /* For Firefox 3.6 to 15 */
background: linear-gradient(#d8d5d3, #eee); /* Standard syntax (must be last) */
cursor:pointer;
text-align:center;
}
.popupCaption{
-webkit-border-top-left-radius:15px;  
-webkit-border-top-right-radius:15px;
-moz-border-top-left-radius:15px;  
-moz-border-top-right-radius:15px;
border-top-left-radius:15px;  
border-top-right-radius:15px;
padding:0.4em;
border-bottom: 1px solid #000;
height:1.5em;
/* width:99%; */

htdocs/style/mysql/mysql_admin.css  view on Meta::CPAN

color:#6c9dbd;
}
/*<<allgemein*/
/* datenbank headline */
.captionLink{
color:#000;
}
.captionLink:hover{
color:#2b4569;
}
.popup{
z-index:1;
position:fixed;
left:0px;
top:0px;
width:100%;
height:1000px;
background-color:rgba(255,255,255,0.7);
/* background-image:url('/mysql.png'); */
opacity:0.95;
background-size:100%;
background-position:top;
}
.popupContent1{
position:relative;
left:25%;
top:100px;
border:1px solid;
border-radius:15px;
-webkit-border-radius:15px; 
-moz-border-radius:15px;
/* padding:1%; */
opacity:0.9;
width:50%;

htdocs/style/mysql/mysql_admin.css  view on Meta::CPAN

-moz-border-radius:25px;
color:rgba(76, 158, 217,1);
color:black;
cursor:pointer;
text-align:center;
}
.closeMenu:hover{
background-color:#6c9dee;/*blue*/
box-shadow:1px 1px 1px 1px rgba(0,0,0,0.4);/*black */ 
}
.popupContent{
text-align:center;
width:100%;
/* overflow:auto; */
}
.menuCaption{
cursor:pointer;
text-align:center;
}
.menuContent{
width:100%;

htdocs/style/mysql/mysql_admin.css  view on Meta::CPAN

select.editTable{
height: 1.85em;
margin:0px;
}
a.dropdownLink{
color:#000;
}
a.dropdownLink:hover{
color:rgba(76, 158, 217,1);
}
.popupMenu{
border:1px solid #000;
background-color:rgba(255,255,255,0.9);
padding:5px;
border-radius:5px;
}
table.flat{
padding:0;
margin:0;
border-spacing:0px;
vertical-align:top;

lib/MySQL/Admin.pm  view on Meta::CPAN

use strict;
use warnings;
no warnings 'redefine';
use utf8;
use MySQL::Admin::Settings;
use MySQL::Admin::Translate;
use MySQL::Admin::Config;
use MySQL::Admin::Session;
use MySQL::Admin::Actions;
use CGI
  qw(-compile -utf8 :html2 :html3 :netscape :cgi :internal :html4 :cgi-lib textfield textarea filefield password_field hidden checkbox checkbox_group submit reset defaults radio_group popup_menu button autoEscape
  scrolling_list image_button start_form end_form start_multipart_form end_multipart_form isindex tmpFileName uploadInfo URL_ENCODED MULTIPART -private_tempfiles );

require Exporter;
use vars qw(
  $m_hrParams
  $m_qy
  $m_hrActions
  $ACCEPT_LANGUAGE
  $DefaultClass
  $m_nUplod_bytes

lib/MySQL/Admin.pm  view on Meta::CPAN


$CGI::DefaultClass     = 'CGI';
$DefaultClass          = 'MySQL::Admin' unless defined $MySQL::Admin::DefaultClass;
$defaultconfig         = '%CONFIG%';
$CGI::AutoloadClass    = 'CGI';
$MySQL::Admin::VERSION = '1.18';
$m_bMod_perl           = ($ENV{MOD_PERL}) ? 1 : 0;
our $hold = 120;    #session ist 120 sekunden gültig.
@ISA = qw(Exporter CGI);
@MySQL::Admin::EXPORT_OK =
  qw(hook start_table end_table include h1 h2 h3 h4 h5 h6 p br hr ol ul li dl dt dd menu code var strong em tt u i b blockquote pre img a address cite samp dfn html head base body Link nextid title meta kbd start_html end_html input Select option com...
$ACCEPT_LANGUAGE ='de';
%EXPORT_TAGS = (
    'html2' => [
        'h1' .. 'h6', qw/p br hr ol ul li dl dt dd menu code var strong em
          tt u i b blockquote pre img a address cite samp dfn html head
          base body Link nextid title meta kbd start_html end_html
          input Select option comment charset escapeHTML/
    ],
    'html3' => [
        qw/div table caption th td TR Tr sup Sub strike applet Param
          embed basefont style span layer ilayer font frameset frame script small big Area Map/
    ],
    'html4' => [
        qw/abbr acronym bdo col colgroup del fieldset iframe
          ins label legend noframes noscript object optgroup Q
          thead tbody tfoot/
    ],
    'netscape' => [qw/blink fontsize center/],
    'form'     => [
        qw/textfield textarea filefield password_field hidden checkbox checkbox_group
          submit reset defaults radio_group popup_menu button autoEscape
          scrolling_list image_button end_form start_form
          start_multipart_form end_multipart_form isindex tmpFileName uploadInfo URL_ENCODED MULTIPART/
    ],
    'cgi' => [
        qw/param upload path_info path_translated request_uri url self_url script_name
          cookie Dump
          raw_cookie request_method query_string Accept user_agent remote_host content_type
          remote_addr referer server_name server_software server_port server_protocol virtual_port
          virtual_host remote_ident auth_type http append
          save_parameters restore_parameters param_fetch
          remote_user user_name header redirect import_names put
          Delete Delete_all url_param cgi_error/
    ],
    'ssl'     => [qw/https/],
    'cgi-lib' => [qw/ReadParse PrintHeader HtmlTop HtmlBot SplitParam Vars/],
    'html'    => [
        qw/h1 h2 h3 h4 h5 h6 p br hr ol ul li dl dt dd menu code var strong em tt u i b blockquote pre img a address cite samp dfn html head base body Link nextid title meta kbd start_html end_html input Select option comment charset escapeHTML div t...
    ],
    'standard' => [
        qw/h1 h2 h3 h4 h5 h6 p br hr ol ul li dl dt dd menu code var strong em tt u i b blockquote pre img a address cite samp dfn html head base body Link nextid title meta kbd start_html end_html input Select option comment charset escapeHTML div t...
          submit reset defaults radio_group popup_menu button autoEscape
          scrolling_list image_button start_form end_form
          start_multipart_form end_multipart_form isindex tmpFileName uploadInfo URL_ENCODED MULTIPART param upload path_info path_translated request_uri url self_url script_name
          cookie Dump
          raw_cookie request_method query_string Accept user_agent remote_host content_type
          remote_addr referer server_name server_software server_port server_protocol virtual_port
          virtual_host remote_ident auth_type http append
          save_parameters restore_parameters param_fetch
          remote_user user_name header redirect import_names put
          Delete Delete_all url_param cgi_error/
    ],
    'push' => [qw/multipart_init multipart_start multipart_end multipart_final/],
    'all'  => [
        qw/h1 h2 h3 h4 h5 h6 p br hr ol ul li dl dt dd menu code var strong em tt u i b blockquote pre img a address cite samp dfn html head base body Link nextid title meta kbd start_html end_html input Select option comment charset escapeHTML div t...
    ],
);

=head1 NAME

MySQL::Admin - Just a MySQL administration Web-App

=head1 SYNOPSIS

use MySQL::Admin;



( run in 1.279 second using v1.01-cache-2.11-cpan-364913b4093 )