diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-07-14 14:43:31 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-07-14 14:43:31 +0000 |
| commit | d03de47b51173dac761e4fdf6e7004661a5565ac (patch) | |
| tree | 1a066dd0a714ca000fe009a1a9a298a3cf264e79 /phpBB/includes/sql_parse.php | |
| parent | c4a926b4e201380a45e0c4ebe76fba49fa6b42f1 (diff) | |
| download | forums-d03de47b51173dac761e4fdf6e7004661a5565ac.tar forums-d03de47b51173dac761e4fdf6e7004661a5565ac.tar.gz forums-d03de47b51173dac761e4fdf6e7004661a5565ac.tar.bz2 forums-d03de47b51173dac761e4fdf6e7004661a5565ac.tar.xz forums-d03de47b51173dac761e4fdf6e7004661a5565ac.zip | |
Gone but not forgotten ... what's not forgotten? who said that? shut up Paul
git-svn-id: file:///svn/phpbb/trunk@2672 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/sql_parse.php')
| -rw-r--r-- | phpBB/includes/sql_parse.php | 192 |
1 files changed, 0 insertions, 192 deletions
diff --git a/phpBB/includes/sql_parse.php b/phpBB/includes/sql_parse.php deleted file mode 100644 index 9761dd315c..0000000000 --- a/phpBB/includes/sql_parse.php +++ /dev/null @@ -1,192 +0,0 @@ -<?php -/*************************************************************************** -* sql_parse.php -* ------------------- -* begin : Thu May 31, 2001 -* copyright : (C) 2001 The phpBB Group -* email : support@phpbb.com -* -* $Id$ -* -****************************************************************************/ - -/*************************************************************************** - * - * This program is free software; you can redistribute it and/or modify - * it under the terms of the GNU General Public License as published by - * the Free Software Foundation; either version 2 of the License, or - * (at your option) any later version. - * - ***************************************************************************/ - -/*************************************************************************** -* -* These functions are mainly for use in the db_utilities under the admin -* however in order to make these functions available elsewhere, specifically -* in the installation phase of phpBB I have seperated out a couple of -* functions into this file. JLH -* -\***************************************************************************/ - -// -// remove_comments will strip the sql comment lines out of an uploaded sql file -// specifically for mssql and postgres type files in the install.... -// -function remove_comments(&$output) -{ - $lines = explode("\n", $output); - $output = ""; - - // try to keep mem. use down - $linecount = count($lines); - - $in_comment = false; - for($i = 0; $i < $linecount; $i++) - { - if( preg_match("/^\/\*/", preg_quote($lines[$i])) ) - { - $in_comment = true; - } - - if( !$in_comment ) - { - $output .= $lines[$i] . "\n"; - } - - if( preg_match("/\*\/$/", preg_quote($lines[$i])) ) - { - $in_comment = false; - } - } - - unset($lines); - return $output; -} - -// -// remove_remarks will strip the sql comment lines out of an uploaded sql file -// -function remove_remarks($sql) -{ - $lines = explode("\n", $sql); - - // try to keep mem. use down - $sql = ""; - - $linecount = count($lines); - $output = ""; - - for ($i = 0; $i < $linecount; $i++) - { - if (($i != ($linecount - 1)) || (strlen($lines[$i]) > 0)) - { - if ($lines[$i][0] != "#") - { - $output .= $lines[$i] . "\n"; - } - else - { - $output .= "\n"; - } - // Trading a bit of speed for lower mem. use here. - $lines[$i] = ""; - } - } - - return $output; - -} - -// -// split_sql_file will split an uploaded sql file into single sql statements. -// Note: expects trim() to have already been run on $sql. -// -function split_sql_file($sql, $delimiter) -{ - // Split up our string into "possible" SQL statements. - $tokens = explode($delimiter, $sql); - - // try to save mem. - $sql = ""; - $output = array(); - - // we don't actually care about the matches preg gives us. - $matches = array(); - - // this is faster than calling count($oktens) every time thru the loop. - $token_count = count($tokens); - for ($i = 0; $i < $token_count; $i++) - { - // Don't wanna add an empty string as the last thing in the array. - if (($i != ($token_count - 1)) || (strlen($tokens[$i] > 0))) - { - // This is the total number of single quotes in the token. - $total_quotes = preg_match_all("/'/", $tokens[$i], $matches); - // Counts single quotes that are preceded by an odd number of backslashes, - // which means they're escaped quotes. - $escaped_quotes = preg_match_all("/(?<!\\\\)(\\\\\\\\)*\\\\'/", $tokens[$i], $matches); - - $unescaped_quotes = $total_quotes - $escaped_quotes; - - // If the number of unescaped quotes is even, then the delimiter did NOT occur inside a string literal. - if (($unescaped_quotes % 2) == 0) - { - // It's a complete sql statement. - $output[] = $tokens[$i]; - // save memory. - $tokens[$i] = ""; - } - else - { - // incomplete sql statement. keep adding tokens until we have a complete one. - // $temp will hold what we have so far. - $temp = $tokens[$i] . $delimiter; - // save memory.. - $tokens[$i] = ""; - - // Do we have a complete statement yet? - $complete_stmt = false; - - for ($j = $i + 1; (!$complete_stmt && ($j < $token_count)); $j++) - { - // This is the total number of single quotes in the token. - $total_quotes = preg_match_all("/'/", $tokens[$j], $matches); - // Counts single quotes that are preceded by an odd number of backslashes, - // which means they're escaped quotes. - $escaped_quotes = preg_match_all("/(?<!\\\\)(\\\\\\\\)*\\\\'/", $tokens[$j], $matches); - - $unescaped_quotes = $total_quotes - $escaped_quotes; - - if (($unescaped_quotes % 2) == 1) - { - // odd number of unescaped quotes. In combination with the previous incomplete - // statement(s), we now have a complete statement. (2 odds always make an even) - $output[] = $temp . $tokens[$j]; - - // save memory. - $tokens[$j] = ""; - $temp = ""; - - // exit the loop. - $complete_stmt = true; - // make sure the outer loop continues at the right point. - $i = $j; - } - else - { - // even number of unescaped quotes. We still don't have a complete statement. - // (1 odd and 1 even always make an odd) - $temp .= $tokens[$j] . $delimiter; - // save memory. - $tokens[$j] = ""; - } - - } // for.. - } // else - } - } - - return $output; -} - -?>
\ No newline at end of file |