Gecko [ www.utparral.edu.mx ]

Name	Size	Permission
certs	[ DIR ]	drwxrwxr-x
config	[ DIR ]	drwxrwxr-x
controllers	[ DIR ]	drwxrwxr-x
dbi	[ DIR ]	drwxrwxr-x
di	[ DIR ]	drwxrwxr-x
engines	[ DIR ]	drwxrwxr-x
gis	[ DIR ]	drwxrwxr-x
navigation	[ DIR ]	drwxrwxr-x
plugins	[ DIR ]	drwxrwxr-x
properties	[ DIR ]	drwxrwxr-x
rte	[ DIR ]	drwxrwxr-x
.1724597954	0 B	-rwxrwxr-x
.1724621370	0 B	-rwxrwxr-x
.1724621595	0 B	-rwxrwxr-x
.1724693108	0 B	-rwxrwxr-x
.1724693161	0 B	-rwxrwxr-x
.1724693163	0 B	-rwxrwxr-x
.1724716554	0 B	-rwxrwxr-x
.1724716619	0 B	-rwxrwxr-x
.1724995546	0 B	-rwxrwxr-x
.1725018452	0 B	-rwxrwxr-x
.1725018571	0 B	-rwxrwxr-x
.1725018746	0 B	-rwxrwxr-x
.1725030833	0 B	-rwxrwxr-x
.1725030838	0 B	-rwxrwxr-x
.1725030897	0 B	-rwxrwxr-x
.1725030901	0 B	-rwxrwxr-x
advisor.lib.php	1.58 KB	-rwxrwxr-x
Advisor.php	16.32 KB	-rwxrwxr-x
advisory_rules.txt	25.94 KB	-rwxrwxr-x
Bookmark.php	9.76 KB	-rwxrwxr-x
browse_foreigners.lib.php	9.63 KB	-rwxrwxr-x
central_columns.lib.php	49.24 KB	-rwxrwxr-x
Charsets.php	22.67 KB	-rwxrwxr-x
check_user_privileges.lib.php	11 KB	-rwxrwxr-x
common.inc.php	29.21 KB	-rwxrwxr-x
config.default.php	65.5 KB	-rwxrwxr-x
Config.php	55.12 KB	-rwxrwxr-x
config.values.php	10.24 KB	-rwxrwxr-x
Console.php	3.38 KB	-rwxrwxr-x
core.lib.php	29.45 KB	-rwxrwxr-x
create_addfield.lib.php	15.7 KB	-rwxrwxr-x
database_interface.inc.php	2.63 KB	-rwxrwxr-x
DatabaseInterface.php	95.6 KB	-rwxrwxr-x
db_common.inc.php	3.04 KB	-rwxrwxr-x
db_designer.lib.php	10.77 KB	-rwxrwxr-x
DbList.php	1.91 KB	-rwxrwxr-x
DbQbe.php	68.78 KB	-rwxrwxr-x
DbSearch.php	17.06 KB	-rwxrwxr-x
display_change_password.lib.php	6.15 KB	-rwxrwxr-x
display_create_table.lib.php	1.53 KB	-rwxrwxr-x
display_export.lib.php	35.53 KB	-rwxrwxr-x
display_git_revision.lib.php	2.88 KB	-rwxrwxr-x
display_import_ajax.lib.php	3.13 KB	-rwxrwxr-x
display_import.lib.php	24.38 KB	-rwxrwxr-x
DisplayResults.php	206.87 KB	-rwxrwxr-x
Encoding.php	8.93 KB	-rwxrwxr-x
ErrorHandler.php	16.41 KB	-rwxrwxr-x
error.inc.php	1.27 KB	-rwxrwxr-x
Error.php	12.87 KB	-rwxrwxr-x
error_report.lib.php	9.25 KB	-rwxrwxr-x
file_listing.lib.php	2.37 KB	-rwxrwxr-x
File.php	20.62 KB	-rwxrwxr-x
Font.php	4.24 KB	-rwxrwxr-x
Footer.php	10.29 KB	-rwxrwxr-x
Header.php	25.21 KB	-rwxrwxr-x
import.lib.php	49.9 KB	-rwxrwxr-x
inc.php	30.99 KB	-rwxrwxr-x
IndexColumn.php	4.46 KB	-rwxrwxr-x
index.lib.php	1.13 KB	-rwxrwxr-x
Index.php	23.38 KB	-rwxrwxr-x
information_schema_relations.lib.php	10.95 KB	-rwxrwxr-x
insert_edit.lib.php	112.42 KB	-rwxrwxr-x
ip_allow_deny.lib.php	8.09 KB	-rwxrwxr-x
LanguageManager.php	22.63 KB	-rwxrwxr-x
Language.php	4.21 KB	-rwxrwxr-x
language_stats.inc.php	1.5 KB	-rwxrwxr-x
Linter.php	5.09 KB	-rwxrwxr-x
ListAbstract.php	3.15 KB	-rwxrwxr-x
ListDatabase.php	4.63 KB	-rwxrwxr-x
Logging.php	1023 B	-rwxrwxr-x
Menu.php	21.36 KB	-rwxrwxr-x
Message.php	19.14 KB	-rwxrwxr-x
mime.lib.php	704 B	-rwxrwxr-x
mult_submits.inc.php	10.46 KB	-rwxrwxr-x
mult_submits.lib.php	20.45 KB	-rwxrwxr-x
normalization.lib.php	33.97 KB	-rwxrwxr-x
OpenDocument.php	8.52 KB	-rwxrwxr-x
operations.lib.php	71.3 KB	-rwxrwxr-x
OutputBuffering.php	3.59 KB	-rwxrwxr-x
parse_analyze.lib.php	2.18 KB	-rwxrwxr-x
Partition.php	9 KB	-rwxrwxr-x
PDF.php	3.92 KB	-rwxrwxr-x
plugin_interface.lib.php	19.69 KB	-rwxrwxr-x
pmd_common.php	24.1 KB	-rwxrwxr-x
RecentFavoriteTable.php	11.79 KB	-rwxrwxr-x
relation_cleanup.lib.php	13.84 KB	-rwxrwxr-x
relation.lib.php	68.74 KB	-rwxrwxr-x
replication_gui.lib.php	37.24 KB	-rwxrwxr-x
replication.inc.php	9.33 KB	-rwxrwxr-x
Response.php	12.05 KB	-rwxrwxr-x
Sanitize.php	14.1 KB	-rwxrwxr-x
SavedSearches.php	11.67 KB	-rwxrwxr-x
Scripts.php	6.59 KB	-rwxrwxr-x
select_server.lib.php	3.52 KB	-rwxrwxr-x
server_common.inc.php	1.24 KB	-rwxrwxr-x
server_common.lib.php	1.92 KB	-rwxrwxr-x
server_privileges.lib.php	171.6 KB	-rwxrwxr-x
server_status_advisor.lib.php	1.89 KB	-rwxrwxr-x
ServerStatusData.php	15.7 KB	-rwxrwxr-x
server_status.lib.php	9.84 KB	-rwxrwxr-x
server_status_monitor.lib.php	26.31 KB	-rwxrwxr-x
server_status_processes.lib.php	9.4 KB	-rwxrwxr-x
server_status_queries.lib.php	4.9 KB	-rwxrwxr-x
server_status_variables.lib.php	28.85 KB	-rwxrwxr-x
server_user_groups.lib.php	12.71 KB	-rwxrwxr-x
server_users.lib.php	1.32 KB	-rwxrwxr-x
session.lib.php	1.11 KB	-rwxrwxr-x
special_schema_links.lib.php	17.51 KB	-rwxrwxr-x
sql.lib.php	77.55 KB	-rwxrwxr-x
sql_query_form.lib.php	15.78 KB	-rwxrwxr-x
StorageEngine.php	13.51 KB	-rwxrwxr-x
string.lib.php	800 B	-rwxrwxr-x
stringMb.lib.php	1.85 KB	-rwxrwxr-x
stringNative.lib.php	6.82 KB	-rwxrwxr-x
SubPartition.php	3.52 KB	-rwxrwxr-x
sysinfo.lib.php	1.35 KB	-rwxrwxr-x
SysInfoLinux.php	1.92 KB	-rwxrwxr-x
SysInfo.php	800 B	-rwxrwxr-x
SysInfoSunOS.php	1.86 KB	-rwxrwxr-x
SysInfoWINNT.php	3.08 KB	-rwxrwxr-x
SystemDatabase.php	3.66 KB	-rwxrwxr-x
Table.php	86.78 KB	-rwxrwxr-x
tbl_columns_definition_form.inc.php	13.84 KB	-rwxrwxr-x
tbl_common.inc.php	1.71 KB	-rwxrwxr-x
tbl_info.inc.php	3.54 KB	-rwxrwxr-x
Template.php	4.42 KB	-rwxrwxr-x
ThemeManager.php	12.25 KB	-rwxrwxr-x
Theme.php	12.68 KB	-rwxrwxr-x
Tracker.php	28.76 KB	-rwxrwxr-x
tracking.lib.php	54.52 KB	-rwxrwxr-x
tracking.php	393 B	-rwxrwxr-x
transformations.lib.php	14.62 KB	-rwxrwxr-x
TypesMySQL.php	17.26 KB	-rwxrwxr-x
Types.php	6.08 KB	-rwxrwxr-x
URL.php	8.42 KB	-rwxrwxr-x
user_preferences.inc.php	2.41 KB	-rwxrwxr-x
user_preferences.lib.php	8.28 KB	-rwxrwxr-x
util.lib.php	749 B	-rwxrwxr-x
Util.php	169.69 KB	-rwxrwxr-x
vendor_config.php	2.07 KB	-rwxrwxr-x
VersionInformation.php	6.34 KB	-rwxrwxr-x
zip_extension.lib.php	5.81 KB	-rwxrwxr-x
ZipFile.php	6.63 KB	-rwxrwxr-x

Code Editor : transformations.lib.php

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * Set of functions used with the relation and pdf feature
 *
 * This file also provides basic functions to use in other plugins!
 * These are declared in the 'GLOBAL Plugin functions' section
 *
 * Please use short and expressive names.
 * For now, special characters which aren't allowed in
 * filenames or functions should not be used.
 *
 * Please provide a comment for your function,
 * what it does and what parameters are available.
 *
 * @package PhpMyAdmin
 */
if (! defined('PHPMYADMIN')) {
    exit;
}

/**
 * Returns array of options from string with options separated by comma,
 * removes quotes
 *
 * <code>
 * PMA_Transformation_getOptions("'option ,, quoted',abd,'2,3',");
 * // array {
 * //     'option ,, quoted',
 * //     'abc',
 * //     '2,3',
 * //     '',
 * // }
 * </code>
 *
 * @param string $option_string comma separated options
 *
 * @return array options
 */
function PMA_Transformation_getOptions($option_string)
{
    $result = array();

if (strlen($option_string) === 0
        || ! $transform_options = preg_split('/,/', $option_string)
    ) {
        return $result;
    }

while (($option = array_shift($transform_options)) !== null) {
        $trimmed = trim($option);
        if (strlen($trimmed) > 1
            && $trimmed[0] == "'"
            && $trimmed[strlen($trimmed) - 1] == "'"
        ) {
            // '...'
            $option = mb_substr($trimmed, 1, -1);
        } elseif (isset($trimmed[0]) && $trimmed[0] == "'") {
            // '...,
            $trimmed = ltrim($option);
            while (($option = array_shift($transform_options)) !== null) {
                // ...,
                $trimmed .= ',' . $option;
                $rtrimmed = rtrim($trimmed);
                if ($rtrimmed[strlen($rtrimmed) - 1] == "'") {
                    // ,...'
                    break;
                }
            }
            $option = mb_substr($rtrimmed, 1, -1);
        }
        $result[] = stripslashes($option);
    }

return $result;
}

/**
 * Gets all available MIME-types
 *
 * @access  public
 * @staticvar   array   mimetypes
 * @return array    array[mimetype], array[transformation]
 */
function PMA_getAvailableMIMEtypes()
{
    static $stack = null;

if (null !== $stack) {
        return $stack;
    }

$stack = array();
    $sub_dirs = array(
        'input/' => 'input_',
        'output/' => '',
        '' => ''
    );

foreach ($sub_dirs as $sd => $prefix) {
        $handle = opendir('libraries/plugins/transformations/' . $sd);

if (! $handle) {
            $stack[$prefix . 'transformation'] = array();
            $stack[$prefix . 'transformation_file'] = array();
            continue;
        }

$filestack = array();
        while ($file = readdir($handle)) {
            // Ignore hidden files
            if ($file[0] == '.') {
                continue;
            }
            // Ignore old plugins (.class in filename)
            if (strpos($file, '.class') !== false) {
                continue;
            }
            $filestack[] = $file;
        }

closedir($handle);
        sort($filestack);

foreach ($filestack as $file) {
            if (preg_match('|^[^.].*_.*_.*\.php$|', $file)) {
                // File contains transformation functions.
                $parts = explode('_', str_replace('.php', '', $file));
                $mimetype = $parts[0] . "/" . $parts[1];
                $stack['mimetype'][$mimetype] = $mimetype;

$stack[$prefix . 'transformation'][] = $mimetype . ': ' . $parts[2];
                $stack[$prefix . 'transformation_file'][] = $sd . $file;
                if ($sd === '') {
                    $stack['input_transformation'][] = $mimetype . ': ' . $parts[2];
                    $stack['input_transformation_file'][] = $sd . $file;
                }

} elseif (preg_match('|^[^.].*\.php$|', $file)) {
                // File is a plain mimetype, no functions.
                $base = str_replace('.php', '', $file);

if ($base != 'global') {
                    $mimetype = str_replace('_', '/', $base);
                    $stack['mimetype'][$mimetype] = $mimetype;
                    $stack['empty_mimetype'][$mimetype] = $mimetype;
                }
            }
        }
    }
    return $stack;
}

/**
 * Returns the class name of the transformation
 *
 * @param string $filename transformation file name
 *
 * @return string the class name of transformation
 */
function PMA_getTransformationClassName($filename)
{
    // get the transformation class name
    $class_name = explode(".php", $filename);
    $class_name = 'PMA\\' . str_replace('/', '\\', $class_name[0]);

return $class_name;
}

/**
 * Returns the description of the transformation
 *
 * @param string $file transformation file
 *
 * @return String the description of the transformation
 */
function PMA_getTransformationDescription($file)
{
    $include_file = 'libraries/plugins/transformations/' . $file;
    /* @var $class_name PMA\libraries\plugins\TransformationsInterface */
    $class_name = PMA_getTransformationClassName($include_file);
    // include and instantiate the class
    include_once $include_file;
    return $class_name::getInfo();
}

/**
 * Returns the name of the transformation
 *
 * @param string $file transformation file
 *
 * @return String the name of the transformation
 */
function PMA_getTransformationName($file)
{
    $include_file = 'libraries/plugins/transformations/' . $file;
    /* @var $class_name PMA\libraries\plugins\TransformationsInterface */
    $class_name = PMA_getTransformationClassName($include_file);
    // include and instantiate the class
    include_once $include_file;
    return $class_name::getName();
}

/**
 * Fixups old MIME or tranformation name to new one
 *
 * - applies some hardcoded fixups
 * - adds spaces after _ and numbers
 * - capitalizes words
 * - removes back spaces
 *
 * @param string $value Value to fixup
 *
 * @return string
 */
function PMA_fixupMIME($value)
{
    $value = str_replace(
        array("jpeg", "png"), array("JPEG", "PNG"), $value
    );
    return str_replace(
        ' ',
        '',
        ucwords(
            preg_replace('/([0-9_]+)/', '$1 ', $value)
        )
    );
}

/**
 * Gets the mimetypes for all columns of a table
 *
 * @param string  $db       the name of the db to check for
 * @param string  $table    the name of the table to check for
 * @param boolean $strict   whether to include only results having a mimetype set
 * @param boolean $fullName whether to use full column names as the key
 *
 * @access public
 *
 * @return array [field_name][field_key] = field_value
 */
function PMA_getMIME($db, $table, $strict = false, $fullName = false)
{
    $cfgRelation = PMA_getRelationsParam();

if (! $cfgRelation['commwork']) {
        return false;
    }

$com_qry = '';
    if ($fullName) {
        $com_qry .= "SELECT CONCAT("
            . "`db_name`, '.', `table_name`, '.', `column_name`"
            . ") AS column_name, ";
    } else {
        $com_qry  = "SELECT `column_name`, ";
    }
    $com_qry .= '`mimetype`,
                `transformation`,
                `transformation_options`,
                `input_transformation`,
                `input_transformation_options`
         FROM ' . PMA\libraries\Util::backquote($cfgRelation['db']) . '.'
        . PMA\libraries\Util::backquote($cfgRelation['column_info']) . '
         WHERE `db_name`    = \'' . $GLOBALS['dbi']->escapeString($db) . '\'
           AND `table_name` = \'' . $GLOBALS['dbi']->escapeString($table) . '\'
           AND ( `mimetype` != \'\'' . (!$strict ? '
              OR `transformation` != \'\'
              OR `transformation_options` != \'\'
              OR `input_transformation` != \'\'
              OR `input_transformation_options` != \'\'' : '') . ')';
    $result = $GLOBALS['dbi']->fetchResult(
        $com_qry, 'column_name', null, $GLOBALS['controllink']
    );

foreach ($result as $column => $values) {
        // replacements in mimetype and transformation
        $values = str_replace("jpeg", "JPEG", $values);
        $values = str_replace("png", "PNG", $values);

// convert mimetype to new format (f.e. Text_Plain, etc)
        $values['mimetype'] = PMA_fixupMIME($values['mimetype']);

// For transformation of form
        // output/image_jpeg__inline.inc.php
        // extract dir part.
        $dir = explode('/', $values['transformation']);
        $subdir = '';
        if (count($dir) === 2) {
            $subdir = $dir[0] . '/';
            $values['transformation'] = $dir[1];
        }

$values['transformation'] = PMA_fixupMIME($values['transformation']);
        $values['transformation'] = $subdir . $values['transformation'];
        $result[$column] = $values;
    }

return $result;
} // end of the 'PMA_getMIME()' function

/**
 * Set a single mimetype to a certain value.
 *
 * @param string  $db                 the name of the db
 * @param string  $table              the name of the table
 * @param string  $key                the name of the column
 * @param string  $mimetype           the mimetype of the column
 * @param string  $transformation     the transformation of the column
 * @param string  $transformationOpts the transformation options of the column
 * @param string  $inputTransform     the input transformation of the column
 * @param string  $inputTransformOpts the input transformation options of the column
 * @param boolean $forcedelete        force delete, will erase any existing
 *                                    comments for this column
 *
 * @access  public
 *
 * @return boolean  true, if comment-query was made.
 */
function PMA_setMIME($db, $table, $key, $mimetype, $transformation,
    $transformationOpts, $inputTransform, $inputTransformOpts, $forcedelete = false
) {
    $cfgRelation = PMA_getRelationsParam();

if (! $cfgRelation['commwork']) {
        return false;
    }

// lowercase mimetype & transformation
    $mimetype = mb_strtolower($mimetype);
    $transformation = mb_strtolower($transformation);

// Do we have any parameter to set?
    $has_value = (
        strlen($mimetype) > 0 ||
        strlen($transformation) > 0 ||
        strlen($transformationOpts) > 0 ||
        strlen($inputTransform) > 0 ||
        strlen($inputTransformOpts) > 0
    );

$test_qry = '
         SELECT `mimetype`,
                `comment`
           FROM ' . PMA\libraries\Util::backquote($cfgRelation['db']) . '.'
        . PMA\libraries\Util::backquote($cfgRelation['column_info']) . '
          WHERE `db_name`     = \'' . $GLOBALS['dbi']->escapeString($db) . '\'
            AND `table_name`  = \'' . $GLOBALS['dbi']->escapeString($table) . '\'
            AND `column_name` = \'' . $GLOBALS['dbi']->escapeString($key) . '\'';

$test_rs   = PMA_queryAsControlUser(
        $test_qry, true, PMA\libraries\DatabaseInterface::QUERY_STORE
    );

if ($test_rs && $GLOBALS['dbi']->numRows($test_rs) > 0) {
        $row = @$GLOBALS['dbi']->fetchAssoc($test_rs);
        $GLOBALS['dbi']->freeResult($test_rs);

if (! $forcedelete && ($has_value || strlen($row['comment']) > 0)) {
            $upd_query = 'UPDATE '
                . PMA\libraries\Util::backquote($cfgRelation['db']) . '.'
                . PMA\libraries\Util::backquote($cfgRelation['column_info'])
                . ' SET '
                . '`mimetype` = \''
                . $GLOBALS['dbi']->escapeString($mimetype) . '\', '
                . '`transformation` = \''
                . $GLOBALS['dbi']->escapeString($transformation) . '\', '
                . '`transformation_options` = \''
                . $GLOBALS['dbi']->escapeString($transformationOpts) . '\', '
                . '`input_transformation` = \''
                . $GLOBALS['dbi']->escapeString($inputTransform) . '\', '
                . '`input_transformation_options` = \''
                . $GLOBALS['dbi']->escapeString($inputTransformOpts) . '\'';
        } else {
            $upd_query = 'DELETE FROM '
                . PMA\libraries\Util::backquote($cfgRelation['db'])
                . '.' . PMA\libraries\Util::backquote($cfgRelation['column_info']);
        }
        $upd_query .= '
            WHERE `db_name`     = \'' . $GLOBALS['dbi']->escapeString($db) . '\'
              AND `table_name`  = \'' . $GLOBALS['dbi']->escapeString($table)
                . '\'
              AND `column_name` = \'' . $GLOBALS['dbi']->escapeString($key)
                . '\'';
    } elseif ($has_value) {

$upd_query = 'INSERT INTO '
            . PMA\libraries\Util::backquote($cfgRelation['db'])
            . '.' . PMA\libraries\Util::backquote($cfgRelation['column_info'])
            . ' (db_name, table_name, column_name, mimetype, '
            . 'transformation, transformation_options, '
            . 'input_transformation, input_transformation_options) '
            . ' VALUES('
            . '\'' . $GLOBALS['dbi']->escapeString($db) . '\','
            . '\'' . $GLOBALS['dbi']->escapeString($table) . '\','
            . '\'' . $GLOBALS['dbi']->escapeString($key) . '\','
            . '\'' . $GLOBALS['dbi']->escapeString($mimetype) . '\','
            . '\'' . $GLOBALS['dbi']->escapeString($transformation) . '\','
            . '\'' . $GLOBALS['dbi']->escapeString($transformationOpts) . '\','
            . '\'' . $GLOBALS['dbi']->escapeString($inputTransform) . '\','
            . '\'' . $GLOBALS['dbi']->escapeString($inputTransformOpts) . '\')';
    }

if (isset($upd_query)) {
        return PMA_queryAsControlUser($upd_query);
    } else {
        return false;
    }
} // end of 'PMA_setMIME()' function

/**
 * GLOBAL Plugin functions
 */

/**
 * Delete related transformation details
 * after deleting database. table or column
 *
 * @param string $db     Database name
 * @param string $table  Table name
 * @param string $column Column name
 *
 * @return boolean State of the query execution
 */
function PMA_clearTransformations($db, $table = '', $column = '')
{
    $cfgRelation = PMA_getRelationsParam();

if (! isset($cfgRelation['column_info'])) {
        return false;
    }

$delete_sql = 'DELETE FROM '
        . PMA\libraries\Util::backquote($cfgRelation['db']) . '.'
        . PMA\libraries\Util::backquote($cfgRelation['column_info'])
        . ' WHERE ';

if (($column != '') && ($table != '')) {

$delete_sql .= '`db_name` = \'' . $db . '\' AND '
            . '`table_name` = \'' . $table . '\' AND '
            . '`column_name` = \'' . $column . '\' ';

} else if ($table != '') {

$delete_sql .= '`db_name` = \'' . $db . '\' AND '
            . '`table_name` = \'' . $table . '\' ';

} else {
        $delete_sql .= '`db_name` = \'' . $db . '\' ';
    }

return $GLOBALS['dbi']->tryQuery($delete_sql);

}

${this.title}

Code Editor : transformations.lib.php