X-Git-Url: http://git.vanrenterghem.biz/www.vanrenterghem.biz.git/blobdiff_plain/4b1ce0d83844cfd7c55e75a60ccb239882cd62e3..83ab5456767602f2a9860a7db7247f002ec96945:/phpBB2_old/includes/sql_parse.php

diff --git a/phpBB2_old/includes/sql_parse.php b/phpBB2_old/includes/sql_parse.php
deleted file mode 100644
index ad27bb3..0000000
--- a/phpBB2_old/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: 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