]> git.vanrenterghem.biz Git - www.vanrenterghem.biz.git/blob - phpBB2/includes/sql_parse.php
update brief bio
[www.vanrenterghem.biz.git] / phpBB2 / includes / sql_parse.php
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 ****************************************************************************/
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  ***************************************************************************/
22 /***************************************************************************
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 \***************************************************************************/
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 = "";
40         // try to keep mem. use down
41         $linecount = count($lines);
43         $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                 }
51                 if( !$in_comment )
52                 {
53                         $output .= $lines[$i] . "\n";
54                 }
56                 if( preg_match("/\*\/$/", preg_quote($lines[$i])) )
57                 {
58                         $in_comment = false;
59                 }
60         }
62         unset($lines);
63         return $output;
64 }
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 = "";
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                                 $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 }
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)
106         // Split up our string into "possible" SQL statements.
107         $tokens = explode($delimiter, $sql);
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                         $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                                 $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];
166                                                 // save memory.
167                                                 $tokens[$j] = "";
168                                                 $temp = "";
169                                                 
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         }
189         return $output;
192 ?>