1 rizwank 1.1 <?php
  2             /***************************************************************************
  3             *                             sql_parse.php
  4             *                              -------------------
  5             *     begin                : Thu May 31, 2001
  6             *     copyright            : (C) 2001 The phpBB Group
  7             *     email                : support@phpbb.com
  8             *
  9             *     $Id: sql_parse.php,v 1.8 2002/03/18 23:53:12 psotfx Exp $
 10             *
 11             ****************************************************************************/
 12             
 13             /***************************************************************************
 14              *
 15              *   This program is free software; you can redistribute it and/or modify
 16              *   it under the terms of the GNU General Public License as published by
 17              *   the Free Software Foundation; either version 2 of the License, or
 18              *   (at your option) any later version.
 19              *
 20              ***************************************************************************/
 21             
 22 rizwank 1.1 /***************************************************************************
 23             *
 24             *	These functions are mainly for use in the db_utilities under the admin
 25             *	however in order to make these functions available elsewhere, specifically
 26             *	in the installation phase of phpBB I have seperated out a couple of 
 27             *	functions into this file.  JLH
 28             *
 29             \***************************************************************************/
 30             
 31             //
 32             // remove_comments will strip the sql comment lines out of an uploaded sql file
 33             // specifically for mssql and postgres type files in the install....
 34             //
 35             function remove_comments(&$output)
 36             {
 37             	$lines = explode("\n", $output);
 38             	$output = "";
 39             
 40             	// try to keep mem. use down
 41             	$linecount = count($lines);
 42             
 43 rizwank 1.1 	$in_comment = false;
 44             	for($i = 0; $i < $linecount; $i++)
 45             	{
 46             		if( preg_match("/^\/\*/", preg_quote($lines[$i])) )
 47             		{
 48             			$in_comment = true;
 49             		}
 50             
 51             		if( !$in_comment )
 52             		{
 53             			$output .= $lines[$i] . "\n";
 54             		}
 55             
 56             		if( preg_match("/\*\/$/", preg_quote($lines[$i])) )
 57             		{
 58             			$in_comment = false;
 59             		}
 60             	}
 61             
 62             	unset($lines);
 63             	return $output;
 64 rizwank 1.1 }
 65             
 66             //
 67             // remove_remarks will strip the sql comment lines out of an uploaded sql file
 68             //
 69             function remove_remarks($sql)
 70             {
 71             	$lines = explode("\n", $sql);
 72             	
 73             	// try to keep mem. use down
 74             	$sql = "";
 75             	
 76             	$linecount = count($lines);
 77             	$output = "";
 78             
 79             	for ($i = 0; $i < $linecount; $i++)
 80             	{
 81             		if (($i != ($linecount - 1)) || (strlen($lines[$i]) > 0))
 82             		{
 83             			if ($lines[$i][0] != "#")
 84             			{
 85 rizwank 1.1 				$output .= $lines[$i] . "\n";
 86             			}
 87             			else
 88             			{
 89             				$output .= "\n";
 90             			}
 91             			// Trading a bit of speed for lower mem. use here.
 92             			$lines[$i] = "";
 93             		}
 94             	}
 95             	
 96             	return $output;
 97             	
 98             }
 99             
100             //
101             // split_sql_file will split an uploaded sql file into single sql statements.
102             // Note: expects trim() to have already been run on $sql.
103             //
104             function split_sql_file($sql, $delimiter)
105             {
106 rizwank 1.1 	// Split up our string into "possible" SQL statements.
107             	$tokens = explode($delimiter, $sql);
108             
109             	// try to save mem.
110             	$sql = "";
111             	$output = array();
112             	
113             	// we don't actually care about the matches preg gives us.
114             	$matches = array();
115             	
116             	// this is faster than calling count($oktens) every time thru the loop.
117             	$token_count = count($tokens);
118             	for ($i = 0; $i < $token_count; $i++)
119             	{
120             		// Don't wanna add an empty string as the last thing in the array.
121             		if (($i != ($token_count - 1)) || (strlen($tokens[$i] > 0)))
122             		{
123             			// This is the total number of single quotes in the token.
124             			$total_quotes = preg_match_all("/'/", $tokens[$i], $matches);
125             			// Counts single quotes that are preceded by an odd number of backslashes, 
126             			// which means they're escaped quotes.
127 rizwank 1.1 			$escaped_quotes = preg_match_all("/(?<!\\\\)(\\\\\\\\)*\\\\'/", $tokens[$i], $matches);
128             			
129             			$unescaped_quotes = $total_quotes - $escaped_quotes;
130             			
131             			// If the number of unescaped quotes is even, then the delimiter did NOT occur inside a string literal.
132             			if (($unescaped_quotes % 2) == 0)
133             			{
134             				// It's a complete sql statement.
135             				$output[] = $tokens[$i];
136             				// save memory.
137             				$tokens[$i] = "";
138             			}
139             			else
140             			{
141             				// incomplete sql statement. keep adding tokens until we have a complete one.
142             				// $temp will hold what we have so far.
143             				$temp = $tokens[$i] . $delimiter;
144             				// save memory..
145             				$tokens[$i] = "";
146             				
147             				// Do we have a complete statement yet? 
148 rizwank 1.1 				$complete_stmt = false;
149             				
150             				for ($j = $i + 1; (!$complete_stmt && ($j < $token_count)); $j++)
151             				{
152             					// This is the total number of single quotes in the token.
153             					$total_quotes = preg_match_all("/'/", $tokens[$j], $matches);
154             					// Counts single quotes that are preceded by an odd number of backslashes, 
155             					// which means they're escaped quotes.
156             					$escaped_quotes = preg_match_all("/(?<!\\\\)(\\\\\\\\)*\\\\'/", $tokens[$j], $matches);
157             			
158             					$unescaped_quotes = $total_quotes - $escaped_quotes;
159             					
160             					if (($unescaped_quotes % 2) == 1)
161             					{
162             						// odd number of unescaped quotes. In combination with the previous incomplete
163             						// statement(s), we now have a complete statement. (2 odds always make an even)
164             						$output[] = $temp . $tokens[$j];
165             
166             						// save memory.
167             						$tokens[$j] = "";
168             						$temp = "";
169 rizwank 1.1 						
170             						// exit the loop.
171             						$complete_stmt = true;
172             						// make sure the outer loop continues at the right point.
173             						$i = $j;
174             					}
175             					else
176             					{
177             						// even number of unescaped quotes. We still don't have a complete statement. 
178             						// (1 odd and 1 even always make an odd)
179             						$temp .= $tokens[$j] . $delimiter;
180             						// save memory.
181             						$tokens[$j] = "";
182             					}
183             					
184             				} // for..
185             			} // else
186             		}
187             	}
188             
189             	return $output;
190 rizwank 1.1 }
191             
192             ?>