<?php/* vim: set expandtab sw=4 ts=4 sts=4: *//** * SQL import plugin for phpMyAdmin * * @version $Id: sql.php 11335 2008-06-21 14:01:54Z lem9 $ */if (! defined('PHPMYADMIN')) {    exit;}/** * */if (isset($plugin_list)) {    $plugin_list['sql'] = array(        'text' => 'strSQL',        'extension' => 'sql',        'options_text' => 'strOptions',        );    $compats = PMA_DBI_getCompatibilities();    if (count($compats) > 0) {        $values = array();        foreach($compats as $val) {            $values[$val] = $val;        }        $plugin_list['sql']['options'] = array(            array('type' => 'select', 'name' => 'compatibility', 'text' => 'strSQLCompatibility', 'values' => $values, 'doc' => array('manual_MySQL_Database_Administration', 'Server_SQL_mode'))            );    }    /* We do not define function when plugin is just queried for information above */    return;}$buffer = '';// Defaults for parser$sql = '';$start_pos = 0;$i = 0;$len= 0;if (isset($_POST['sql_delimiter'])) {    $sql_delimiter = $_POST['sql_delimiter'];} else {    $sql_delimiter = ';';}// Handle compatibility optionif (isset($_REQUEST['sql_compatibility'])) {    PMA_DBI_try_query('SET SQL_MODE="' . $_REQUEST['sql_compatibility'] . '"');}while (!($finished && $i >= $len) && !$error && !$timeout_passed) {    $data = PMA_importGetNextChunk();    if ($data === FALSE) {        // subtract data we didn't handle yet and stop processing        $offset -= strlen($buffer);        break;    } elseif ($data === TRUE) {        // Handle rest of buffer    } else {        // Append new data to buffer        $buffer .= $data;        // free memory        unset($data);        // Do not parse string when we're not at the end and don't have ; inside        if ((strpos($buffer, $sql_delimiter, $i) === FALSE) && !$finished)  {            continue;        }    }    // Current length of our buffer    $len = strlen($buffer);    // prepare an uppercase copy of buffer for PHP < 5    // outside of the loop    // (but on Windows and PHP 5.2.5, stripos() is very slow    //  so prepare this buffer also in this case)    if (PMA_PHP_INT_VERSION < 50000 || PMA_IS_WINDOWS) {        $buffer_upper = strtoupper($buffer);    }    // Grab some SQL queries out of it     while ($i < $len) {        $found_delimiter = false;        // Find first interesting character, several strpos seem to be faster than simple loop in php:        //while (($i < $len) && (strpos('\'";#-/', $buffer[$i]) === FALSE)) $i++;        //if ($i == $len) break;        $oi = $i;        $big_value = 2147483647;        $first_quote = strpos($buffer, '\'', $i);        if ($first_quote === FALSE) {            $first_quote = $big_value;        }        $p2 = strpos($buffer, '"', $i);        if ($p2 === FALSE) {            $p2 = $big_value;        }        /**         * @todo it's a shortcoming to look for a delimiter that might be         *       inside quotes (or even double-quotes)         */        $first_sql_delimiter = strpos($buffer, $sql_delimiter, $i);        if ($first_sql_delimiter === FALSE) {            $first_sql_delimiter = $big_value;        } else {            $found_delimiter = true;        }        $p4 = strpos($buffer, '#', $i);        if ($p4 === FALSE) {            $p4 = $big_value;        }        $p5 = strpos($buffer, '--', $i);        if ($p5 === FALSE || $p5 >= ($len - 2) || $buffer[$p5 + 2] > ' ') {            $p5 = $big_value;        }        $p6 = strpos($buffer, '/*', $i);        if ($p6 === FALSE) {            $p6 = $big_value;        }        $p7 = strpos($buffer, '`', $i);        if ($p7 === FALSE) {            $p7 = $big_value;        }        // catch also "delimiter"        // stripos() very slow on Windows (at least on PHP 5.2.5)        if (PMA_PHP_INT_VERSION >= 50000 && ! PMA_IS_WINDOWS) {            $p8 = stripos($buffer, 'DELIMITER', $i);        } else {            $p8 = strpos($buffer_upper, 'DELIMITER', $i);        }        if ($p8 === FALSE || $p8 >= ($len - 11) || $buffer[$p8 + 9] > ' ') {            $p8 = $big_value;        }        $i = min ($first_quote, $p2, $first_sql_delimiter, $p4, $p5, $p6, $p7, $p8);        unset($first_quote, $p2, $p4, $p5, $p6, $p7, $p8);        if ($i == $big_value) {            $i = $oi;            if (!$finished) {                break;            }            // at the end there might be some whitespace...            if (trim($buffer) == '') {                $buffer = '';                $len = 0;                break;            }            // We hit end of query, go there!            $i = strlen($buffer) - 1;        }        // Grab current character        $ch = $buffer[$i];        // Quotes        if (strpos('\'"`', $ch) !== FALSE) {            $quote = $ch;            $endq = FALSE;            while (!$endq) {                // Find next quote                $pos = strpos($buffer, $quote, $i + 1);                // No quote? Too short string                if ($pos === FALSE) {                    // We hit end of string => unclosed quote, but we handle it as end of query                    if ($finished) {                        $endq = TRUE;                        $i = $len - 1;                    }                    $found_delimiter = false;                    break;                }                // Was not the quote escaped?                $j = $pos - 1;                while ($buffer[$j] == '\\') $j--;                // Even count means it was not escaped                $endq = (((($pos - 1) - $j) % 2) == 0);                // Skip the string                $i = $pos;                if ($first_sql_delimiter < $pos) {                    $found_delimiter = false;                }            }            if (!$endq) {                break;            }            $i++;            // Aren't we at the end?            if ($finished && $i == $len) {                $i--;            } else {                continue;            }        }        // Not enough data to decide        if ((($i == ($len - 1) && ($ch == '-' || $ch == '/'))          || ($i == ($len - 2) && (($ch == '-' && $buffer[$i + 1] == '-')            || ($ch == '/' && $buffer[$i + 1] == '*')))) && !$finished) {            break;        }        // Comments        if ($ch == '#'                || ($i < ($len - 1) && $ch == '-' && $buffer[$i + 1] == '-' && (($i < ($len - 2) && $buffer[$i + 2] <= ' ') || ($i == ($len - 1) && $finished)))                || ($i < ($len - 1) && $ch == '/' && $buffer[$i + 1] == '*')                ) {            // Copy current string to SQL            if ($start_pos != $i) {                $sql .= substr($buffer, $start_pos, $i - $start_pos);            }            // Skip the rest            $j = $i;            $i = strpos($buffer, $ch == '/' ? '*/' : "\n", $i);            // didn't we hit end of string?            if ($i === FALSE) {                if ($finished) {                    $i = $len - 1;                } else {                    break;                }            }            // Skip *            if ($ch == '/') {                // Check for MySQL conditional comments and include them as-is                if ($buffer[$j + 2] == '!') {                    $comment = substr($buffer, $j + 3, $i - $j - 3);                    if (preg_match('/^[0-9]{5}/', $comment, $version)) {                        if ($version[0] <= PMA_MYSQL_INT_VERSION) {                            $sql .= substr($comment, 5);                        }                    } else {                        $sql .= $comment;                    }                }                $i++;            }            // Skip last char            $i++;            // Next query part will start here            $start_pos = $i;            // Aren't we at the end?            if ($i == $len) {                $i--;            } else {                continue;            }        }       // Change delimiter, if redefined, and skip it (don't send to server!)       if ((strtoupper(substr($buffer, $i, 9)) == "DELIMITER") && ($buffer[$i + 9] <= ' ') && ($i<$len-11) && (!(strpos($buffer,"\n",$i+11)===FALSE))) {           $new_line_pos = strpos($buffer, "\n", $i + 10);           $sql_delimiter = substr($buffer, $i+10, $new_line_pos - $i -10);           $i= $new_line_pos + 1;           // Next query part will start here           $start_pos = $i;           continue;        }        // End of SQL        if ($found_delimiter || ($finished && ($i == $len - 1))) {            $tmp_sql = $sql;            if ($start_pos < $len) {                $length_to_grab = $i - $start_pos;                if (!$found_delimiter) {                    $length_to_grab++;                }                $tmp_sql .= substr($buffer, $start_pos, $length_to_grab);                unset($length_to_grab);            }            // Do not try to execute empty SQL            if (!preg_match('/^([\s]*;)*$/', trim($tmp_sql))) {                $sql = $tmp_sql;                PMA_importRunQuery($sql, substr($buffer, 0, $i + strlen($sql_delimiter)));                $buffer = substr($buffer, $i + strlen($sql_delimiter));                // Reset parser:                $len = strlen($buffer);                $sql = '';                $i = 0;                $start_pos = 0;                // Any chance we will get a complete query?                //if ((strpos($buffer, ';') === FALSE) && !$finished) {                if ((strpos($buffer, $sql_delimiter) === FALSE) && !$finished) {                    break;                }            } else {                $i++;                $start_pos = $i;            }        }    } // End of parser loop} // End of import loop// Commit any possible data in buffersPMA_importRunQuery('', substr($buffer, 0, $len));PMA_importRunQuery();?>