+++ /dev/null
-<?php
-/***************************************************************************
-* sql_parse.php
-* -------------------
-* begin : Thu May 31, 2001
-* copyright : (C) 2001 The phpBB Group
-* email : support@phpbb.com
-*
-* $Id: sql_parse.php,v 1.8 2002/03/18 23:53:12 psotfx Exp $
-*
-****************************************************************************/
-
-/***************************************************************************
- *
- * 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