<?php
include_once '../doc-typo3-funcs.php';
$doxygen_vars = array( "title" => "TYPO3 4.0.1: typo3_src-4.0.1/t3lib/class.t3lib_sqlparser.php Source File",
"datetime" => "Sat Dec 2 19:22:18 2006",
"date" => "2 Dec 2006",
"doxygenversion" => "1.4.6",
"projectname" => "TYPO3 4.0.1",
"projectnumber" => "4.0.1"
);
get_header($doxygen_vars);
?>
<!-- Generated by Doxygen 1.4.6 -->
<div class="tabs">
<ul>
<li><a href="main.html"><span>Main Page</span></a></li>
<li><a href="namespaces.html"><span>Namespaces</span></a></li>
<li><a href="classes.html"><span>Classes</span></a></li>
<li id="current"><a href="files.html"><span>Files</span></a></li>
<li><a href="dirs.html"><span>Directories</span></a></li>
<li><a href="pages.html"><span>Related Pages</span></a></li>
<li><a href="examples.html"><span>Examples</span></a></li>
<li>
<form action="search.php" method="get">
<table cellspacing="0" cellpadding="0" border="0">
<tr>
<td><label> <u>S</u>earch for </label></td>
<td><input type="text" name="query" value="" size="20" accesskey="s"/></td>
</tr>
</table>
</form>
</li>
</ul></div>
<div class="nav">
<a class="el" href="dir_c8daf1ad746050abf985cc546c89e248.html">typo3_src-4.0.1</a> » <a class="el" href="dir_9d0e5c424a38b69aeeedc616a9634e5f.html">t3lib</a></div>
<h1>class.t3lib_sqlparser.php</h1><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 <?php
<a name="l00002"></a>00002 <span class="comment">/***************************************************************</span>
<a name="l00003"></a>00003 <span class="comment">* Copyright notice</span>
<a name="l00004"></a>00004 <span class="comment">*</span>
<a name="l00005"></a>00005 <span class="comment">* (c) 2004-2006 Kasper Skaarhoj (kasperYYYY@typo3.com)</span>
<a name="l00006"></a>00006 <span class="comment">* All rights reserved</span>
<a name="l00007"></a>00007 <span class="comment">*</span>
<a name="l00008"></a>00008 <span class="comment">* This script is part of the TYPO3 project. The TYPO3 project is</span>
<a name="l00009"></a>00009 <span class="comment">* free software; you can redistribute it and/or modify</span>
<a name="l00010"></a>00010 <span class="comment">* it under the terms of the GNU General Public License as published by</span>
<a name="l00011"></a>00011 <span class="comment">* the Free Software Foundation; either version 2 of the License, or</span>
<a name="l00012"></a>00012 <span class="comment">* (at your option) any later version.</span>
<a name="l00013"></a>00013 <span class="comment">*</span>
<a name="l00014"></a>00014 <span class="comment">* The GNU General Public License can be found at</span>
<a name="l00015"></a>00015 <span class="comment">* http://www.gnu.org/copyleft/gpl.html.</span>
<a name="l00016"></a>00016 <span class="comment">* A copy is found in the textfile GPL.txt and important notices to the license</span>
<a name="l00017"></a>00017 <span class="comment">* from the author is found in LICENSE.txt distributed with these scripts.</span>
<a name="l00018"></a>00018 <span class="comment">*</span>
<a name="l00019"></a>00019 <span class="comment">*</span>
<a name="l00020"></a>00020 <span class="comment">* This script is distributed in the hope that it will be useful,</span>
<a name="l00021"></a>00021 <span class="comment">* but WITHOUT ANY WARRANTY; without even the implied warranty of</span>
<a name="l00022"></a>00022 <span class="comment">* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the</span>
<a name="l00023"></a>00023 <span class="comment">* GNU General Public License for more details.</span>
<a name="l00024"></a>00024 <span class="comment">*</span>
<a name="l00025"></a>00025 <span class="comment">* This copyright notice MUST APPEAR in all copies of the script!</span>
<a name="l00026"></a>00026 <span class="comment">***************************************************************/</span>
<a name="l00107"></a><a class="code" href="classt3lib__sqlparser.html">00107</a> <span class="keyword">class </span><a class="code" href="classt3lib__sqlparser.html">t3lib_sqlparser</a> {
<a name="l00108"></a>00108
<a name="l00109"></a>00109 <span class="comment">// Parser:</span>
<a name="l00110"></a><a class="code" href="classt3lib__sqlparser.html#b124140ba08c69fa0007ed1ab3721c9e">00110</a> var <a class="code" href="classt3lib__sqlparser.html#b124140ba08c69fa0007ed1ab3721c9e">$parse_error</a> = ''; <span class="comment">// Parsing error string</span>
<a name="l00111"></a><a class="code" href="classt3lib__sqlparser.html#005c3912bda3a199c5e939f93d6c72a0">00111</a> var <a class="code" href="classt3lib__sqlparser.html#005c3912bda3a199c5e939f93d6c72a0">$lastStopKeyWord</a> = ''; <span class="comment">// Last stop keyword used.</span>
<a name="l00112"></a>00112
<a name="l00113"></a>00113
<a name="l00114"></a>00114
<a name="l00115"></a>00115
<a name="l00116"></a>00116 <span class="comment">/*************************************</span>
<a name="l00117"></a>00117 <span class="comment"> *</span>
<a name="l00118"></a>00118 <span class="comment"> * SQL Parsing, full queries</span>
<a name="l00119"></a>00119 <span class="comment"> *</span>
<a name="l00120"></a>00120 <span class="comment"> **************************************/</span>
<a name="l00121"></a>00121
<a name="l00129"></a><a class="code" href="classt3lib__sqlparser.html#17b1d286e74c5e32540caf5353d26b4f">00129</a> function <a class="code" href="classt3lib__sqlparser.html#17b1d286e74c5e32540caf5353d26b4f">parseSQL</a>($parseString) {
<a name="l00130"></a>00130 <span class="comment">// Prepare variables:</span>
<a name="l00131"></a>00131 $parseString = $this-><a class="code" href="classt3lib__sqlparser.html#d2ef5063c9c6a0c08dfd86f53229e9c9">trimSQL</a>($parseString);
<a name="l00132"></a>00132 $this->parse_error = '';
<a name="l00133"></a>00133 $result = array();
<a name="l00134"></a>00134
<a name="l00135"></a>00135 <span class="comment">// Finding starting keyword of string:</span>
<a name="l00136"></a>00136 $_parseString = $parseString; <span class="comment">// Protecting original string...</span>
<a name="l00137"></a>00137 $keyword = $this-><a class="code" href="classt3lib__sqlparser.html#79a91063ceb67a9179e72b35562bca4f">nextPart</a>($_parseString, '^(SELECT|UPDATE|INSERT[[:space:]]+INTO|DELETE[[:space:]]+FROM|EXPLAIN|DROP[[:space:]]+TABLE|CREATE[[:space:]]+TABLE|CREATE[[:space:]]+DATABASE|ALTER[[:space:]]+TABLE)[[:space:]]+');
<a name="l00138"></a>00138 $keyword = strtoupper(str_replace(array(<span class="charliteral">' '</span>,<span class="stringliteral">"\t"</span>,<span class="stringliteral">"\r"</span>,<span class="stringliteral">"\n"</span>),'',$keyword));
<a name="l00139"></a>00139
<a name="l00140"></a>00140 <span class="keywordflow">switch</span>($keyword) {
<a name="l00141"></a>00141 <span class="keywordflow">case</span> 'SELECT':
<a name="l00142"></a>00142 <span class="comment">// Parsing SELECT query:</span>
<a name="l00143"></a>00143 $result = $this-><a class="code" href="classt3lib__sqlparser.html#931ea257be2c06b17a7ca1d8c6fcdf4c">parseSELECT</a>($parseString);
<a name="l00144"></a>00144 <span class="keywordflow">break</span>;
<a name="l00145"></a>00145 <span class="keywordflow">case</span> 'UPDATE':
<a name="l00146"></a>00146 <span class="comment">// Parsing UPDATE query:</span>
<a name="l00147"></a>00147 $result = $this-><a class="code" href="classt3lib__sqlparser.html#a621121a7e29a4b645358deb5eb13e86">parseUPDATE</a>($parseString);
<a name="l00148"></a>00148 <span class="keywordflow">break</span>;
<a name="l00149"></a>00149 <span class="keywordflow">case</span> 'INSERTINTO':
<a name="l00150"></a>00150 <span class="comment">// Parsing INSERT query:</span>
<a name="l00151"></a>00151 $result = $this-><a class="code" href="classt3lib__sqlparser.html#45b52a99a0f44d1df48376daf10f0bd0">parseINSERT</a>($parseString);
<a name="l00152"></a>00152 <span class="keywordflow">break</span>;
<a name="l00153"></a>00153 <span class="keywordflow">case</span> 'DELETEFROM':
<a name="l00154"></a>00154 <span class="comment">// Parsing DELETE query:</span>
<a name="l00155"></a>00155 $result = $this-><a class="code" href="classt3lib__sqlparser.html#c222fa822d4fde43365825c1b748726b">parseDELETE</a>($parseString);
<a name="l00156"></a>00156 <span class="keywordflow">break</span>;
<a name="l00157"></a>00157 <span class="keywordflow">case</span> 'EXPLAIN':
<a name="l00158"></a>00158 <span class="comment">// Parsing EXPLAIN SELECT query:</span>
<a name="l00159"></a>00159 $result = $this-><a class="code" href="classt3lib__sqlparser.html#60d17a696b97c933f2e2598a98c8fbd0">parseEXPLAIN</a>($parseString);
<a name="l00160"></a>00160 <span class="keywordflow">break</span>;
<a name="l00161"></a>00161 <span class="keywordflow">case</span> 'DROPTABLE':
<a name="l00162"></a>00162 <span class="comment">// Parsing DROP TABLE query:</span>
<a name="l00163"></a>00163 $result = $this-><a class="code" href="classt3lib__sqlparser.html#20b3403c67b12d1868b46d641efbb5b9">parseDROPTABLE</a>($parseString);
<a name="l00164"></a>00164 <span class="keywordflow">break</span>;
<a name="l00165"></a>00165 <span class="keywordflow">case</span> 'ALTERTABLE':
<a name="l00166"></a>00166 <span class="comment">// Parsing ALTER TABLE query:</span>
<a name="l00167"></a>00167 $result = $this-><a class="code" href="classt3lib__sqlparser.html#816a58f427a1337724d4527e2c394def">parseALTERTABLE</a>($parseString);
<a name="l00168"></a>00168 <span class="keywordflow">break</span>;
<a name="l00169"></a>00169 <span class="keywordflow">case</span> 'CREATETABLE':
<a name="l00170"></a>00170 <span class="comment">// Parsing CREATE TABLE query:</span>
<a name="l00171"></a>00171 $result = $this-><a class="code" href="classt3lib__sqlparser.html#685f71ce3447402f61dd0065603ce649">parseCREATETABLE</a>($parseString);
<a name="l00172"></a>00172 <span class="keywordflow">break</span>;
<a name="l00173"></a>00173 <span class="keywordflow">case</span> 'CREATEDATABASE':
<a name="l00174"></a>00174 <span class="comment">// Parsing CREATE DATABASE query:</span>
<a name="l00175"></a>00175 $result = $this-><a class="code" href="classt3lib__sqlparser.html#fbbb0bf02647b6075f2b6cf6794818f1">parseCREATEDATABASE</a>($parseString);
<a name="l00176"></a>00176 <span class="keywordflow">break</span>;
<a name="l00177"></a>00177 <span class="keywordflow">default</span>:
<a name="l00178"></a>00178 $result = $this-><a class="code" href="classt3lib__sqlparser.html#021ad281fa14992ada15223cced8aec2">parseError</a>(<span class="charliteral">'"'</span>.$keyword.'<span class="stringliteral">" is not a keyword',$parseString);</span>
<a name="l00179"></a>00179 <span class="stringliteral"> break;</span>
<a name="l00180"></a>00180 <span class="stringliteral"> }</span>
<a name="l00181"></a>00181 <span class="stringliteral"></span>
<a name="l00182"></a>00182 <span class="stringliteral"> return $result;</span>
<a name="l00183"></a>00183 <span class="stringliteral"> }</span>
<a name="l00184"></a>00184 <span class="stringliteral"></span>
<a name="l00192"></a><a class="code" href="classt3lib__sqlparser.html#931ea257be2c06b17a7ca1d8c6fcdf4c">00192</a> <span class="stringliteral"> function parseSELECT($parseString) {</span>
<a name="l00193"></a>00193 <span class="stringliteral"></span>
<a name="l00194"></a>00194 <span class="stringliteral"> // Removing SELECT:</span>
<a name="l00195"></a>00195 <span class="stringliteral"> $parseString = $this->trimSQL($parseString);</span>
<a name="l00196"></a>00196 <span class="stringliteral"> $parseString = ltrim(substr($parseString,6)); // REMOVE eregi_replace('^SELECT[[:space:]]+','',$parseString);</span>
<a name="l00197"></a>00197 <span class="stringliteral"></span>
<a name="l00198"></a>00198 <span class="stringliteral"> // Init output variable:</span>
<a name="l00199"></a>00199 <span class="stringliteral"> $result = array();</span>
<a name="l00200"></a>00200 <span class="stringliteral"> $result['type'] = 'SELECT';</span>
<a name="l00201"></a>00201 <span class="stringliteral"></span>
<a name="l00202"></a>00202 <span class="stringliteral"> // Looking for STRAIGHT_JOIN keyword:</span>
<a name="l00203"></a>00203 <span class="stringliteral"> $result['STRAIGHT_JOIN'] = $this->nextPart($parseString, '^(STRAIGHT_JOIN)[[:space:]]+');</span>
<a name="l00204"></a>00204 <span class="stringliteral"></span>
<a name="l00205"></a>00205 <span class="stringliteral"> // Select fields:</span>
<a name="l00206"></a>00206 <span class="stringliteral"> $result['SELECT'] = $this->parseFieldList($parseString, '^(FROM)[[:space:]]+');</span>
<a name="l00207"></a>00207 <span class="stringliteral"> if ($this->parse_error) { return $this->parse_error; }</span>
<a name="l00208"></a>00208 <span class="stringliteral"></span>
<a name="l00209"></a>00209 <span class="stringliteral"> // Continue if string is not ended:</span>
<a name="l00210"></a>00210 <span class="stringliteral"> if ($parseString) {</span>
<a name="l00211"></a>00211 <span class="stringliteral"></span>
<a name="l00212"></a>00212 <span class="stringliteral"> // Get table list:</span>
<a name="l00213"></a>00213 <span class="stringliteral"> $result['FROM'] = $this->parseFromTables($parseString, '^(WHERE)[[:space:]]+');</span>
<a name="l00214"></a>00214 <span class="stringliteral"> if ($this->parse_error) { return $this->parse_error; }</span>
<a name="l00215"></a>00215 <span class="stringliteral"></span>
<a name="l00216"></a>00216 <span class="stringliteral"> // If there are more than just the tables (a WHERE clause that would be...)</span>
<a name="l00217"></a>00217 <span class="stringliteral"> if ($parseString) {</span>
<a name="l00218"></a>00218 <span class="stringliteral"></span>
<a name="l00219"></a>00219 <span class="stringliteral"> // Get WHERE clause:</span>
<a name="l00220"></a>00220 <span class="stringliteral"> $result['WHERE'] = $this->parseWhereClause($parseString, '^(GROUP[[:space:]]+BY|ORDER[[:space:]]+BY|LIMIT)[[:space:]]+');</span>
<a name="l00221"></a>00221 <span class="stringliteral"> if ($this->parse_error) { return $this->parse_error; }</span>
<a name="l00222"></a>00222 <span class="stringliteral"></span>
<a name="l00223"></a>00223 <span class="stringliteral"> // If the WHERE clause parsing was stopped by GROUP BY, ORDER BY or LIMIT, then proceed with parsing:</span>
<a name="l00224"></a>00224 <span class="stringliteral"> if ($this->lastStopKeyWord) {</span>
<a name="l00225"></a>00225 <span class="stringliteral"></span>
<a name="l00226"></a>00226 <span class="stringliteral"> // GROUP BY parsing:</span>
<a name="l00227"></a>00227 <span class="stringliteral"> if ($this->lastStopKeyWord == 'GROUPBY') {</span>
<a name="l00228"></a>00228 <span class="stringliteral"> $result['GROUPBY'] = $this->parseFieldList($parseString, '^(ORDER[[:space:]]+BY|LIMIT)[[:space:]]+');</span>
<a name="l00229"></a>00229 <span class="stringliteral"> if ($this->parse_error) { return $this->parse_error; }</span>
<a name="l00230"></a>00230 <span class="stringliteral"> }</span>
<a name="l00231"></a>00231 <span class="stringliteral"></span>
<a name="l00232"></a>00232 <span class="stringliteral"> // ORDER BY parsing:</span>
<a name="l00233"></a>00233 <span class="stringliteral"> if ($this->lastStopKeyWord == 'ORDERBY') {</span>
<a name="l00234"></a>00234 <span class="stringliteral"> $result['ORDERBY'] = $this->parseFieldList($parseString, '^(LIMIT)[[:space:]]+');</span>
<a name="l00235"></a>00235 <span class="stringliteral"> if ($this->parse_error) { return $this->parse_error; }</span>
<a name="l00236"></a>00236 <span class="stringliteral"> }</span>
<a name="l00237"></a>00237 <span class="stringliteral"></span>
<a name="l00238"></a>00238 <span class="stringliteral"> // LIMIT parsing:</span>
<a name="l00239"></a>00239 <span class="stringliteral"> if ($this->lastStopKeyWord == 'LIMIT') {</span>
<a name="l00240"></a>00240 <span class="stringliteral"> if (preg_match('/^([0-9]+|[0-9]+[[:space:]]*,[[:space:]]*[0-9]+)$/',trim($parseString))) {</span>
<a name="l00241"></a>00241 <span class="stringliteral"> $result['LIMIT'] = $parseString;</span>
<a name="l00242"></a>00242 <span class="stringliteral"> } else {</span>
<a name="l00243"></a>00243 <span class="stringliteral"> return $this->parseError('No value for limit!',$parseString);</span>
<a name="l00244"></a>00244 <span class="stringliteral"> }</span>
<a name="l00245"></a>00245 <span class="stringliteral"> }</span>
<a name="l00246"></a>00246 <span class="stringliteral"> }</span>
<a name="l00247"></a>00247 <span class="stringliteral"> }</span>
<a name="l00248"></a>00248 <span class="stringliteral"> } else return $this->parseError('No table to select from!',$parseString);</span>
<a name="l00249"></a>00249 <span class="stringliteral"></span>
<a name="l00250"></a>00250 <span class="stringliteral"> // Return result:</span>
<a name="l00251"></a>00251 <span class="stringliteral"> return $result;</span>
<a name="l00252"></a>00252 <span class="stringliteral"> }</span>
<a name="l00253"></a>00253 <span class="stringliteral"></span>
<a name="l00261"></a><a class="code" href="classt3lib__sqlparser.html#a621121a7e29a4b645358deb5eb13e86">00261</a> <span class="stringliteral"> function parseUPDATE($parseString) {</span>
<a name="l00262"></a>00262 <span class="stringliteral"></span>
<a name="l00263"></a>00263 <span class="stringliteral"> // Removing UPDATE</span>
<a name="l00264"></a>00264 <span class="stringliteral"> $parseString = $this->trimSQL($parseString);</span>
<a name="l00265"></a>00265 <span class="stringliteral"> $parseString = ltrim(substr($parseString,6)); // REMOVE eregi_replace('^UPDATE[[:space:]]+','',$parseString);</span>
<a name="l00266"></a>00266 <span class="stringliteral"></span>
<a name="l00267"></a>00267 <span class="stringliteral"> // Init output variable:</span>
<a name="l00268"></a>00268 <span class="stringliteral"> $result = array();</span>
<a name="l00269"></a>00269 <span class="stringliteral"> $result['type'] = 'UPDATE';</span>
<a name="l00270"></a>00270 <span class="stringliteral"></span>
<a name="l00271"></a>00271 <span class="stringliteral"> // Get table:</span>
<a name="l00272"></a>00272 <span class="stringliteral"> $result['TABLE'] = $this->nextPart($parseString, '^([[:alnum:]_]+)[[:space:]]+');</span>
<a name="l00273"></a>00273 <span class="stringliteral"></span>
<a name="l00274"></a>00274 <span class="stringliteral"> // Continue if string is not ended:</span>
<a name="l00275"></a>00275 <span class="stringliteral"> if ($result['TABLE']) {</span>
<a name="l00276"></a>00276 <span class="stringliteral"> if ($parseString && $this->nextPart($parseString, '^(SET)[[:space:]]+')) {</span>
<a name="l00277"></a>00277 <span class="stringliteral"></span>
<a name="l00278"></a>00278 <span class="stringliteral"> $comma = TRUE;</span>
<a name="l00279"></a>00279 <span class="stringliteral"></span>
<a name="l00280"></a>00280 <span class="stringliteral"> // Get field/value pairs:</span>
<a name="l00281"></a>00281 <span class="stringliteral"> while($comma) {</span>
<a name="l00282"></a>00282 <span class="stringliteral"> if ($fieldName = $this->nextPart($parseString,'^([[:alnum:]_]+)[[:space:]]*=')) {</span>
<a name="l00283"></a>00283 <span class="stringliteral"> $this->nextPart($parseString,'^(=)'); // Strip of "</span>=<span class="stringliteral">" sign.</span>
<a name="l00284"></a>00284 <span class="stringliteral"> $value = $this->getValue($parseString);</span>
<a name="l00285"></a>00285 <span class="stringliteral"> $result['FIELDS'][$fieldName] = $value;</span>
<a name="l00286"></a>00286 <span class="stringliteral"> } else return $this->parseError('No fieldname found',$parseString);</span>
<a name="l00287"></a>00287 <span class="stringliteral"></span>
<a name="l00288"></a>00288 <span class="stringliteral"> $comma = $this->nextPart($parseString,'^(,)');</span>
<a name="l00289"></a>00289 <span class="stringliteral"> }</span>
<a name="l00290"></a>00290 <span class="stringliteral"></span>
<a name="l00291"></a>00291 <span class="stringliteral"> // WHERE</span>
<a name="l00292"></a>00292 <span class="stringliteral"> if ($this->nextPart($parseString,'^(WHERE)')) {</span>
<a name="l00293"></a>00293 <span class="stringliteral"> $result['WHERE'] = $this->parseWhereClause($parseString);</span>
<a name="l00294"></a>00294 <span class="stringliteral"> if ($this->parse_error) { return $this->parse_error; }</span>
<a name="l00295"></a>00295 <span class="stringliteral"> }</span>
<a name="l00296"></a>00296 <span class="stringliteral"> } else return $this->parseError('Query missing SET...',$parseString);</span>
<a name="l00297"></a>00297 <span class="stringliteral"> } else return $this->parseError('No table found!',$parseString);</span>
<a name="l00298"></a>00298 <span class="stringliteral"></span>
<a name="l00299"></a>00299 <span class="stringliteral"> // Should be no more content now:</span>
<a name="l00300"></a>00300 <span class="stringliteral"> if ($parseString) {</span>
<a name="l00301"></a>00301 <span class="stringliteral"> return $this->parseError('Still content in clause after parsing!',$parseString);</span>
<a name="l00302"></a>00302 <span class="stringliteral"> }</span>
<a name="l00303"></a>00303 <span class="stringliteral"></span>
<a name="l00304"></a>00304 <span class="stringliteral"> // Return result:</span>
<a name="l00305"></a>00305 <span class="stringliteral"> return $result;</span>
<a name="l00306"></a>00306 <span class="stringliteral"> }</span>
<a name="l00307"></a>00307 <span class="stringliteral"></span>
<a name="l00315"></a><a class="code" href="classt3lib__sqlparser.html#45b52a99a0f44d1df48376daf10f0bd0">00315</a> <span class="stringliteral"> function parseINSERT($parseString) {</span>
<a name="l00316"></a>00316 <span class="stringliteral"></span>
<a name="l00317"></a>00317 <span class="stringliteral"> // Removing INSERT</span>
<a name="l00318"></a>00318 <span class="stringliteral"> $parseString = $this->trimSQL($parseString);</span>
<a name="l00319"></a>00319 <span class="stringliteral"> $parseString = ltrim(substr(ltrim(substr($parseString,6)),4)); // REMOVE eregi_replace('^INSERT[[:space:]]+INTO[[:space:]]+','',$parseString);</span>
<a name="l00320"></a>00320 <span class="stringliteral"></span>
<a name="l00321"></a>00321 <span class="stringliteral"> // Init output variable:</span>
<a name="l00322"></a>00322 <span class="stringliteral"> $result = array();</span>
<a name="l00323"></a>00323 <span class="stringliteral"> $result['type'] = 'INSERT';</span>
<a name="l00324"></a>00324 <span class="stringliteral"></span>
<a name="l00325"></a>00325 <span class="stringliteral"> // Get table:</span>
<a name="l00326"></a>00326 <span class="stringliteral"> $result['TABLE'] = $this->nextPart($parseString, '^([[:alnum:]_]+)([[:space:]]+|\()');</span>
<a name="l00327"></a>00327 <span class="stringliteral"></span>
<a name="l00328"></a>00328 <span class="stringliteral"> if ($result['TABLE']) {</span>
<a name="l00329"></a>00329 <span class="stringliteral"></span>
<a name="l00330"></a>00330 <span class="stringliteral"> if ($this->nextPart($parseString,'^(VALUES)[[:space:]]+')) { // In this case there are no field names mentioned in the SQL!</span>
<a name="l00331"></a>00331 <span class="stringliteral"> // Get values/fieldnames (depending...)</span>
<a name="l00332"></a>00332 <span class="stringliteral"> $result['VALUES_ONLY'] = $this->getValue($parseString,'IN');</span>
<a name="l00333"></a>00333 <span class="stringliteral"> if ($this->parse_error) { return $this->parse_error; }</span>
<a name="l00334"></a>00334 <span class="stringliteral"> } else { // There are apparently fieldnames listed:</span>
<a name="l00335"></a>00335 <span class="stringliteral"> $fieldNames = $this->getValue($parseString,'_LIST');</span>
<a name="l00336"></a>00336 <span class="stringliteral"> if ($this->parse_error) { return $this->parse_error; }</span>
<a name="l00337"></a>00337 <span class="stringliteral"></span>
<a name="l00338"></a>00338 <span class="stringliteral"> if ($this->nextPart($parseString,'^(VALUES)[[:space:]]+')) { // "</span>VALUES<span class="stringliteral">" keyword binds the fieldnames to values:</span>
<a name="l00339"></a>00339 <span class="stringliteral"></span>
<a name="l00340"></a>00340 <span class="stringliteral"> $values = $this->getValue($parseString,'IN'); // Using the "</span><a class="code" href="classt3lib__sqlparser.html#823616337fd26fdff4a222de04223124">getValue</a><span class="stringliteral">" function to get the field list...</span>
<a name="l00341"></a>00341 <span class="stringliteral"> if ($this->parse_error) { return $this->parse_error; }</span>
<a name="l00342"></a>00342 <span class="stringliteral"></span>
<a name="l00343"></a>00343 <span class="stringliteral"> foreach($fieldNames as $k => $fN) {</span>
<a name="l00344"></a>00344 <span class="stringliteral"> if (preg_match('/^[[:alnum:]_]+$/',$fN)) {</span>
<a name="l00345"></a>00345 <span class="stringliteral"> if (isset($values[$k])) {</span>
<a name="l00346"></a>00346 <span class="stringliteral"> if (!isset($result['FIELDS'][$fN])) {</span>
<a name="l00347"></a>00347 <span class="stringliteral"> $result['FIELDS'][$fN] = $values[$k];</span>
<a name="l00348"></a>00348 <span class="stringliteral"> } else return $this->parseError('Fieldname ("</span>'.$fN.'<span class="stringliteral">") already found in list!',$parseString);</span>
<a name="l00349"></a>00349 <span class="stringliteral"> } else return $this->parseError('No value set!',$parseString);</span>
<a name="l00350"></a>00350 <span class="stringliteral"> } else return $this->parseError('Invalid fieldname ("</span>'.$fN.'<span class="stringliteral">")',$parseString);</span>
<a name="l00351"></a>00351 <span class="stringliteral"> }</span>
<a name="l00352"></a>00352 <span class="stringliteral"> if (isset($values[$k+1])) {</span>
<a name="l00353"></a>00353 <span class="stringliteral"> return $this->parseError('Too many values in list!',$parseString);</span>
<a name="l00354"></a>00354 <span class="stringliteral"> }</span>
<a name="l00355"></a>00355 <span class="stringliteral"> } else return $this->parseError('VALUES keyword expected',$parseString);</span>
<a name="l00356"></a>00356 <span class="stringliteral"> }</span>
<a name="l00357"></a>00357 <span class="stringliteral"> } else return $this->parseError('No table found!',$parseString);</span>
<a name="l00358"></a>00358 <span class="stringliteral"></span>
<a name="l00359"></a>00359 <span class="stringliteral"> // Should be no more content now:</span>
<a name="l00360"></a>00360 <span class="stringliteral"> if ($parseString) {</span>
<a name="l00361"></a>00361 <span class="stringliteral"> return $this->parseError('Still content after parsing!',$parseString);</span>
<a name="l00362"></a>00362 <span class="stringliteral"> }</span>
<a name="l00363"></a>00363 <span class="stringliteral"></span>
<a name="l00364"></a>00364 <span class="stringliteral"> // Return result</span>
<a name="l00365"></a>00365 <span class="stringliteral"> return $result;</span>
<a name="l00366"></a>00366 <span class="stringliteral"> }</span>
<a name="l00367"></a>00367 <span class="stringliteral"></span>
<a name="l00375"></a><a class="code" href="classt3lib__sqlparser.html#c222fa822d4fde43365825c1b748726b">00375</a> <span class="stringliteral"> function parseDELETE($parseString) {</span>
<a name="l00376"></a>00376 <span class="stringliteral"></span>
<a name="l00377"></a>00377 <span class="stringliteral"> // Removing DELETE</span>
<a name="l00378"></a>00378 <span class="stringliteral"> $parseString = $this->trimSQL($parseString);</span>
<a name="l00379"></a>00379 <span class="stringliteral"> $parseString = ltrim(substr(ltrim(substr($parseString,6)),4)); // REMOVE eregi_replace('^DELETE[[:space:]]+FROM[[:space:]]+','',$parseString);</span>
<a name="l00380"></a>00380 <span class="stringliteral"></span>
<a name="l00381"></a>00381 <span class="stringliteral"> // Init output variable:</span>
<a name="l00382"></a>00382 <span class="stringliteral"> $result = array();</span>
<a name="l00383"></a>00383 <span class="stringliteral"> $result['type'] = 'DELETE';</span>
<a name="l00384"></a>00384 <span class="stringliteral"></span>
<a name="l00385"></a>00385 <span class="stringliteral"> // Get table:</span>
<a name="l00386"></a>00386 <span class="stringliteral"> $result['TABLE'] = $this->nextPart($parseString, '^([[:alnum:]_]+)[[:space:]]+');</span>
<a name="l00387"></a>00387 <span class="stringliteral"></span>
<a name="l00388"></a>00388 <span class="stringliteral"> if ($result['TABLE']) {</span>
<a name="l00389"></a>00389 <span class="stringliteral"></span>
<a name="l00390"></a>00390 <span class="stringliteral"> // WHERE</span>
<a name="l00391"></a>00391 <span class="stringliteral"> if ($this->nextPart($parseString,'^(WHERE)')) {</span>
<a name="l00392"></a>00392 <span class="stringliteral"> $result['WHERE'] = $this->parseWhereClause($parseString);</span>
<a name="l00393"></a>00393 <span class="stringliteral"> if ($this->parse_error) { return $this->parse_error; }</span>
<a name="l00394"></a>00394 <span class="stringliteral"> }</span>
<a name="l00395"></a>00395 <span class="stringliteral"> } else return $this->parseError('No table found!',$parseString);</span>
<a name="l00396"></a>00396 <span class="stringliteral"></span>
<a name="l00397"></a>00397 <span class="stringliteral"> // Should be no more content now:</span>
<a name="l00398"></a>00398 <span class="stringliteral"> if ($parseString) {</span>
<a name="l00399"></a>00399 <span class="stringliteral"> return $this->parseError('Still content in clause after parsing!',$parseString);</span>
<a name="l00400"></a>00400 <span class="stringliteral"> }</span>
<a name="l00401"></a>00401 <span class="stringliteral"></span>
<a name="l00402"></a>00402 <span class="stringliteral"> // Return result:</span>
<a name="l00403"></a>00403 <span class="stringliteral"> return $result;</span>
<a name="l00404"></a>00404 <span class="stringliteral"> }</span>
<a name="l00405"></a>00405 <span class="stringliteral"></span>
<a name="l00413"></a><a class="code" href="classt3lib__sqlparser.html#60d17a696b97c933f2e2598a98c8fbd0">00413</a> <span class="stringliteral"> function parseEXPLAIN($parseString) {</span>
<a name="l00414"></a>00414 <span class="stringliteral"></span>
<a name="l00415"></a>00415 <span class="stringliteral"> // Removing EXPLAIN</span>
<a name="l00416"></a>00416 <span class="stringliteral"> $parseString = $this->trimSQL($parseString);</span>
<a name="l00417"></a>00417 <span class="stringliteral"> $parseString = ltrim(substr($parseString,6)); // REMOVE eregi_replace('^EXPLAIN[[:space:]]+','',$parseString);</span>
<a name="l00418"></a>00418 <span class="stringliteral"></span>
<a name="l00419"></a>00419 <span class="stringliteral"> // Init output variable:</span>
<a name="l00420"></a>00420 <span class="stringliteral"> $result = $this->parseSELECT($parseString);</span>
<a name="l00421"></a>00421 <span class="stringliteral"> if (is_array($result)) {</span>
<a name="l00422"></a>00422 <span class="stringliteral"> $result['type'] = 'EXPLAIN';</span>
<a name="l00423"></a>00423 <span class="stringliteral"> }</span>
<a name="l00424"></a>00424 <span class="stringliteral"></span>
<a name="l00425"></a>00425 <span class="stringliteral"> return $result;</span>
<a name="l00426"></a>00426 <span class="stringliteral"> }</span>
<a name="l00427"></a>00427 <span class="stringliteral"></span>
<a name="l00435"></a><a class="code" href="classt3lib__sqlparser.html#685f71ce3447402f61dd0065603ce649">00435</a> <span class="stringliteral"> function parseCREATETABLE($parseString) {</span>
<a name="l00436"></a>00436 <span class="stringliteral"></span>
<a name="l00437"></a>00437 <span class="stringliteral"> // Removing CREATE TABLE</span>
<a name="l00438"></a>00438 <span class="stringliteral"> $parseString = $this->trimSQL($parseString);</span>
<a name="l00439"></a>00439 <span class="stringliteral"> $parseString = ltrim(substr(ltrim(substr($parseString,6)),5)); // REMOVE eregi_replace('^CREATE[[:space:]]+TABLE[[:space:]]+','',$parseString);</span>
<a name="l00440"></a>00440 <span class="stringliteral"></span>
<a name="l00441"></a>00441 <span class="stringliteral"> // Init output variable:</span>
<a name="l00442"></a>00442 <span class="stringliteral"> $result = array();</span>
<a name="l00443"></a>00443 <span class="stringliteral"> $result['type'] = 'CREATETABLE';</span>
<a name="l00444"></a>00444 <span class="stringliteral"></span>
<a name="l00445"></a>00445 <span class="stringliteral"> // Get table:</span>
<a name="l00446"></a>00446 <span class="stringliteral"> $result['TABLE'] = $this->nextPart($parseString, '^([[:alnum:]_]+)[[:space:]]*\(',TRUE);</span>
<a name="l00447"></a>00447 <span class="stringliteral"></span>
<a name="l00448"></a>00448 <span class="stringliteral"> if ($result['TABLE']) {</span>
<a name="l00449"></a>00449 <span class="stringliteral"></span>
<a name="l00450"></a>00450 <span class="stringliteral"> // While the parseString is not yet empty:</span>
<a name="l00451"></a>00451 <span class="stringliteral"> while(strlen($parseString)>0) {</span>
<a name="l00452"></a>00452 <span class="stringliteral"> if ($key = $this->nextPart($parseString, '^(KEY|PRIMARY KEY|UNIQUE KEY|UNIQUE)([[:space:]]+|\()')) { // Getting key</span>
<a name="l00453"></a>00453 <span class="stringliteral"> $key = strtoupper(str_replace(array(' ',"</span>\t<span class="stringliteral">","</span>\r<span class="stringliteral">","</span>\n<span class="stringliteral">"),'',$key));</span>
<a name="l00454"></a>00454 <span class="stringliteral"></span>
<a name="l00455"></a>00455 <span class="stringliteral"> switch($key) {</span>
<a name="l00456"></a>00456 <span class="stringliteral"> case 'PRIMARYKEY':</span>
<a name="l00457"></a>00457 <span class="stringliteral"> $result['KEYS']['PRIMARYKEY'] = $this->getValue($parseString,'_LIST');</span>
<a name="l00458"></a>00458 <span class="stringliteral"> if ($this->parse_error) { return $this->parse_error; }</span>
<a name="l00459"></a>00459 <span class="stringliteral"> break;</span>
<a name="l00460"></a>00460 <span class="stringliteral"> case 'UNIQUE':</span>
<a name="l00461"></a>00461 <span class="stringliteral"> case 'UNIQUEKEY':</span>
<a name="l00462"></a>00462 <span class="stringliteral"> if ($keyName = $this->nextPart($parseString, '^([[:alnum:]_]+)([[:space:]]+|\()')) {</span>
<a name="l00463"></a>00463 <span class="stringliteral"> $result['KEYS']['UNIQUE'] = array($keyName => $this->getValue($parseString,'_LIST'));</span>
<a name="l00464"></a>00464 <span class="stringliteral"> if ($this->parse_error) { return $this->parse_error; }</span>
<a name="l00465"></a>00465 <span class="stringliteral"> } else return $this->parseError('No keyname found',$parseString);</span>
<a name="l00466"></a>00466 <span class="stringliteral"> break;</span>
<a name="l00467"></a>00467 <span class="stringliteral"> case 'KEY':</span>
<a name="l00468"></a>00468 <span class="stringliteral"> if ($keyName = $this->nextPart($parseString, '^([[:alnum:]_]+)([[:space:]]+|\()')) {</span>
<a name="l00469"></a>00469 <span class="stringliteral"> $result['KEYS'][$keyName] = $this->getValue($parseString,'_LIST');</span>
<a name="l00470"></a>00470 <span class="stringliteral"> if ($this->parse_error) { return $this->parse_error; }</span>
<a name="l00471"></a>00471 <span class="stringliteral"> } else return $this->parseError('No keyname found',$parseString);</span>
<a name="l00472"></a>00472 <span class="stringliteral"> break;</span>
<a name="l00473"></a>00473 <span class="stringliteral"> }</span>
<a name="l00474"></a>00474 <span class="stringliteral"> } elseif ($fieldName = $this->nextPart($parseString, '^([[:alnum:]_]+)[[:space:]]+')) { // Getting field:</span>
<a name="l00475"></a>00475 <span class="stringliteral"> $result['FIELDS'][$fieldName]['definition'] = $this->parseFieldDef($parseString);</span>
<a name="l00476"></a>00476 <span class="stringliteral"> if ($this->parse_error) { return $this->parse_error; }</span>
<a name="l00477"></a>00477 <span class="stringliteral"> }</span>
<a name="l00478"></a>00478 <span class="stringliteral"></span>
<a name="l00479"></a>00479 <span class="stringliteral"> // Finding delimiter:</span>
<a name="l00480"></a>00480 <span class="stringliteral"> $delim = $this->nextPart($parseString, '^(,|\))');</span>
<a name="l00481"></a>00481 <span class="stringliteral"> if (!$delim) {</span>
<a name="l00482"></a>00482 <span class="stringliteral"> return $this->parseError('No delimiter found',$parseString);</span>
<a name="l00483"></a>00483 <span class="stringliteral"> } elseif ($delim==')') {</span>
<a name="l00484"></a>00484 <span class="stringliteral"> break;</span>
<a name="l00485"></a>00485 <span class="stringliteral"> }</span>
<a name="l00486"></a>00486 <span class="stringliteral"> }</span>
<a name="l00487"></a>00487 <span class="stringliteral"></span>
<a name="l00488"></a>00488 <span class="stringliteral"> // Finding what is after the table definition - table type in MySQL</span>
<a name="l00489"></a>00489 <span class="stringliteral"> if ($delim==')') {</span>
<a name="l00490"></a>00490 <span class="stringliteral"> if ($this->nextPart($parseString, '^(TYPE[[:space:]]*=)')) {</span>
<a name="l00491"></a>00491 <span class="stringliteral"> $result['tableType'] = $parseString;</span>
<a name="l00492"></a>00492 <span class="stringliteral"> $parseString = '';</span>
<a name="l00493"></a>00493 <span class="stringliteral"> }</span>
<a name="l00494"></a>00494 <span class="stringliteral"> } else return $this->parseError('No fieldname found!',$parseString);</span>
<a name="l00495"></a>00495 <span class="stringliteral"></span>
<a name="l00496"></a>00496 <span class="stringliteral"> // Getting table type</span>
<a name="l00497"></a>00497 <span class="stringliteral"> } else return $this->parseError('No table found!',$parseString);</span>
<a name="l00498"></a>00498 <span class="stringliteral"></span>
<a name="l00499"></a>00499 <span class="stringliteral"> // Should be no more content now:</span>
<a name="l00500"></a>00500 <span class="stringliteral"> if ($parseString) {</span>
<a name="l00501"></a>00501 <span class="stringliteral"> return $this->parseError('Still content in clause after parsing!',$parseString);</span>
<a name="l00502"></a>00502 <span class="stringliteral"> }</span>
<a name="l00503"></a>00503 <span class="stringliteral"></span>
<a name="l00504"></a>00504 <span class="stringliteral"> return $result;</span>
<a name="l00505"></a>00505 <span class="stringliteral"> }</span>
<a name="l00506"></a>00506 <span class="stringliteral"></span>
<a name="l00514"></a><a class="code" href="classt3lib__sqlparser.html#816a58f427a1337724d4527e2c394def">00514</a> <span class="stringliteral"> function parseALTERTABLE($parseString) {</span>
<a name="l00515"></a>00515 <span class="stringliteral"></span>
<a name="l00516"></a>00516 <span class="stringliteral"> // Removing ALTER TABLE</span>
<a name="l00517"></a>00517 <span class="stringliteral"> $parseString = $this->trimSQL($parseString);</span>
<a name="l00518"></a>00518 <span class="stringliteral"> $parseString = ltrim(substr(ltrim(substr($parseString,5)),5)); // REMOVE eregi_replace('^ALTER[[:space:]]+TABLE[[:space:]]+','',$parseString);</span>
<a name="l00519"></a>00519 <span class="stringliteral"></span>
<a name="l00520"></a>00520 <span class="stringliteral"> // Init output variable:</span>
<a name="l00521"></a>00521 <span class="stringliteral"> $result = array();</span>
<a name="l00522"></a>00522 <span class="stringliteral"> $result['type'] = 'ALTERTABLE';</span>
<a name="l00523"></a>00523 <span class="stringliteral"></span>
<a name="l00524"></a>00524 <span class="stringliteral"> // Get table:</span>
<a name="l00525"></a>00525 <span class="stringliteral"> $result['TABLE'] = $this->nextPart($parseString, '^([[:alnum:]_]+)[[:space:]]+');</span>
<a name="l00526"></a>00526 <span class="stringliteral"></span>
<a name="l00527"></a>00527 <span class="stringliteral"> if ($result['TABLE']) {</span>
<a name="l00528"></a>00528 <span class="stringliteral"> if ($result['action'] = $this->nextPart($parseString, '^(CHANGE|DROP[[:space:]]+KEY|DROP[[:space:]]+PRIMARY[[:space:]]+KEY|ADD[[:space:]]+KEY|ADD[[:space:]]+PRIMARY[[:space:]]+KEY|DROP|ADD|RENAME)([[:space:]]+|\()')) {</span>
<a name="l00529"></a>00529 <span class="stringliteral"> $actionKey = strtoupper(str_replace(array(' ',"</span>\t<span class="stringliteral">","</span>\r<span class="stringliteral">","</span>\n<span class="stringliteral">"),'',$result['action']));</span>
<a name="l00530"></a>00530 <span class="stringliteral"></span>
<a name="l00531"></a>00531 <span class="stringliteral"> // Getting field:</span>
<a name="l00532"></a>00532 <span class="stringliteral"> if (t3lib_div::inList('ADDPRIMARYKEY,DROPPRIMARYKEY',$actionKey) || $fieldKey = $this->nextPart($parseString, '^([[:alnum:]_]+)[[:space:]]+')) {</span>
<a name="l00533"></a>00533 <span class="stringliteral"></span>
<a name="l00534"></a>00534 <span class="stringliteral"> switch($actionKey) {</span>
<a name="l00535"></a>00535 <span class="stringliteral"> case 'ADD':</span>
<a name="l00536"></a>00536 <span class="stringliteral"> $result['FIELD'] = $fieldKey;</span>
<a name="l00537"></a>00537 <span class="stringliteral"> $result['definition'] = $this->parseFieldDef($parseString);</span>
<a name="l00538"></a>00538 <span class="stringliteral"> if ($this->parse_error) { return $this->parse_error; }</span>
<a name="l00539"></a>00539 <span class="stringliteral"> break;</span>
<a name="l00540"></a>00540 <span class="stringliteral"> case 'DROP':</span>
<a name="l00541"></a>00541 <span class="stringliteral"> case 'RENAME':</span>
<a name="l00542"></a>00542 <span class="stringliteral"> $result['FIELD'] = $fieldKey;</span>
<a name="l00543"></a>00543 <span class="stringliteral"> break;</span>
<a name="l00544"></a>00544 <span class="stringliteral"> case 'CHANGE':</span>
<a name="l00545"></a>00545 <span class="stringliteral"> $result['FIELD'] = $fieldKey;</span>
<a name="l00546"></a>00546 <span class="stringliteral"> if ($result['newField'] = $this->nextPart($parseString, '^([[:alnum:]_]+)[[:space:]]+')) {</span>
<a name="l00547"></a>00547 <span class="stringliteral"> $result['definition'] = $this->parseFieldDef($parseString);</span>
<a name="l00548"></a>00548 <span class="stringliteral"> if ($this->parse_error) { return $this->parse_error; }</span>
<a name="l00549"></a>00549 <span class="stringliteral"> } else return $this->parseError('No NEW field name found',$parseString);</span>
<a name="l00550"></a>00550 <span class="stringliteral"> break;</span>
<a name="l00551"></a>00551 <span class="stringliteral"></span>
<a name="l00552"></a>00552 <span class="stringliteral"> case 'ADDKEY':</span>
<a name="l00553"></a>00553 <span class="stringliteral"> case 'ADDPRIMARYKEY':</span>
<a name="l00554"></a>00554 <span class="stringliteral"> $result['KEY'] = $fieldKey;</span>
<a name="l00555"></a>00555 <span class="stringliteral"> $result['fields'] = $this->getValue($parseString,'_LIST');</span>
<a name="l00556"></a>00556 <span class="stringliteral"> if ($this->parse_error) { return $this->parse_error; }</span>
<a name="l00557"></a>00557 <span class="stringliteral"> break;</span>
<a name="l00558"></a>00558 <span class="stringliteral"> case 'DROPKEY':</span>
<a name="l00559"></a>00559 <span class="stringliteral"> $result['KEY'] = $fieldKey;</span>
<a name="l00560"></a>00560 <span class="stringliteral"> break;</span>
<a name="l00561"></a>00561 <span class="stringliteral"> case 'DROPPRIMARYKEY':</span>
<a name="l00562"></a>00562 <span class="stringliteral"> // ??? todo!</span>
<a name="l00563"></a>00563 <span class="stringliteral"> break;</span>
<a name="l00564"></a>00564 <span class="stringliteral"> }</span>
<a name="l00565"></a>00565 <span class="stringliteral"> } else return $this->parseError('No field name found',$parseString);</span>
<a name="l00566"></a>00566 <span class="stringliteral"> } else return $this->parseError('No action CHANGE, DROP or ADD found!',$parseString);</span>
<a name="l00567"></a>00567 <span class="stringliteral"> } else return $this->parseError('No table found!',$parseString);</span>
<a name="l00568"></a>00568 <span class="stringliteral"></span>
<a name="l00569"></a>00569 <span class="stringliteral"> // Should be no more content now:</span>
<a name="l00570"></a>00570 <span class="stringliteral"> if ($parseString) {</span>
<a name="l00571"></a>00571 <span class="stringliteral"> return $this->parseError('Still content in clause after parsing!',$parseString);</span>
<a name="l00572"></a>00572 <span class="stringliteral"> }</span>
<a name="l00573"></a>00573 <span class="stringliteral"></span>
<a name="l00574"></a>00574 <span class="stringliteral"> return $result;</span>
<a name="l00575"></a>00575 <span class="stringliteral"> }</span>
<a name="l00576"></a>00576 <span class="stringliteral"></span>
<a name="l00583"></a><a class="code" href="classt3lib__sqlparser.html#20b3403c67b12d1868b46d641efbb5b9">00583</a> <span class="stringliteral"> function parseDROPTABLE($parseString) {</span>
<a name="l00584"></a>00584 <span class="stringliteral"></span>
<a name="l00585"></a>00585 <span class="stringliteral"> // Removing DROP TABLE</span>
<a name="l00586"></a>00586 <span class="stringliteral"> $parseString = $this->trimSQL($parseString);</span>
<a name="l00587"></a>00587 <span class="stringliteral"> $parseString = ltrim(substr(ltrim(substr($parseString,4)),5)); // eregi_replace('^DROP[[:space:]]+TABLE[[:space:]]+','',$parseString);</span>
<a name="l00588"></a>00588 <span class="stringliteral"></span>
<a name="l00589"></a>00589 <span class="stringliteral"> // Init output variable:</span>
<a name="l00590"></a>00590 <span class="stringliteral"> $result = array();</span>
<a name="l00591"></a>00591 <span class="stringliteral"> $result['type'] = 'DROPTABLE';</span>
<a name="l00592"></a>00592 <span class="stringliteral"></span>
<a name="l00593"></a>00593 <span class="stringliteral"> // IF EXISTS</span>
<a name="l00594"></a>00594 <span class="stringliteral"> $result['ifExists'] = $this->nextPart($parseString, '^(IF[[:space:]]+EXISTS[[:space:]]+)');</span>
<a name="l00595"></a>00595 <span class="stringliteral"></span>
<a name="l00596"></a>00596 <span class="stringliteral"> // Get table:</span>
<a name="l00597"></a>00597 <span class="stringliteral"> $result['TABLE'] = $this->nextPart($parseString, '^([[:alnum:]_]+)[[:space:]]+');</span>
<a name="l00598"></a>00598 <span class="stringliteral"></span>
<a name="l00599"></a>00599 <span class="stringliteral"> if ($result['TABLE']) {</span>
<a name="l00600"></a>00600 <span class="stringliteral"></span>
<a name="l00601"></a>00601 <span class="stringliteral"> // Should be no more content now:</span>
<a name="l00602"></a>00602 <span class="stringliteral"> if ($parseString) {</span>
<a name="l00603"></a>00603 <span class="stringliteral"> return $this->parseError('Still content in clause after parsing!',$parseString);</span>
<a name="l00604"></a>00604 <span class="stringliteral"> }</span>
<a name="l00605"></a>00605 <span class="stringliteral"></span>
<a name="l00606"></a>00606 <span class="stringliteral"> return $result;</span>
<a name="l00607"></a>00607 <span class="stringliteral"> } else return $this->parseError('No table found!',$parseString);</span>
<a name="l00608"></a>00608 <span class="stringliteral"> }</span>
<a name="l00609"></a>00609 <span class="stringliteral"></span>
<a name="l00616"></a><a class="code" href="classt3lib__sqlparser.html#fbbb0bf02647b6075f2b6cf6794818f1">00616</a> <span class="stringliteral"> function parseCREATEDATABASE($parseString) {</span>
<a name="l00617"></a>00617 <span class="stringliteral"></span>
<a name="l00618"></a>00618 <span class="stringliteral"> // Removing CREATE DATABASE</span>
<a name="l00619"></a>00619 <span class="stringliteral"> $parseString = $this->trimSQL($parseString);</span>
<a name="l00620"></a>00620 <span class="stringliteral"> $parseString = ltrim(substr(ltrim(substr($parseString,6)),8)); // eregi_replace('^CREATE[[:space:]]+DATABASE[[:space:]]+','',$parseString);</span>
<a name="l00621"></a>00621 <span class="stringliteral"></span>
<a name="l00622"></a>00622 <span class="stringliteral"> // Init output variable:</span>
<a name="l00623"></a>00623 <span class="stringliteral"> $result = array();</span>
<a name="l00624"></a>00624 <span class="stringliteral"> $result['type'] = 'CREATEDATABASE';</span>
<a name="l00625"></a>00625 <span class="stringliteral"></span>
<a name="l00626"></a>00626 <span class="stringliteral"> // Get table:</span>
<a name="l00627"></a>00627 <span class="stringliteral"> $result['DATABASE'] = $this->nextPart($parseString, '^([[:alnum:]_]+)[[:space:]]+');</span>
<a name="l00628"></a>00628 <span class="stringliteral"></span>
<a name="l00629"></a>00629 <span class="stringliteral"> if ($result['DATABASE']) {</span>
<a name="l00630"></a>00630 <span class="stringliteral"></span>
<a name="l00631"></a>00631 <span class="stringliteral"> // Should be no more content now:</span>
<a name="l00632"></a>00632 <span class="stringliteral"> if ($parseString) {</span>
<a name="l00633"></a>00633 <span class="stringliteral"> return $this->parseError('Still content in clause after parsing!',$parseString);</span>
<a name="l00634"></a>00634 <span class="stringliteral"> }</span>
<a name="l00635"></a>00635 <span class="stringliteral"></span>
<a name="l00636"></a>00636 <span class="stringliteral"> return $result;</span>
<a name="l00637"></a>00637 <span class="stringliteral"> } else return $this->parseError('No database found!',$parseString);</span>
<a name="l00638"></a>00638 <span class="stringliteral"> }</span>
<a name="l00639"></a>00639 <span class="stringliteral"></span>
<a name="l00640"></a>00640 <span class="stringliteral"></span>
<a name="l00641"></a>00641 <span class="stringliteral"></span>
<a name="l00642"></a>00642 <span class="stringliteral"></span>
<a name="l00643"></a>00643 <span class="stringliteral"></span>
<a name="l00644"></a>00644 <span class="stringliteral"></span>
<a name="l00645"></a>00645 <span class="stringliteral"></span>
<a name="l00646"></a>00646 <span class="stringliteral"></span>
<a name="l00647"></a>00647 <span class="stringliteral"></span>
<a name="l00648"></a>00648 <span class="stringliteral"></span>
<a name="l00649"></a>00649 <span class="stringliteral"></span>
<a name="l00650"></a>00650 <span class="stringliteral"></span>
<a name="l00651"></a>00651 <span class="stringliteral"></span>
<a name="l00652"></a>00652 <span class="stringliteral"></span>
<a name="l00653"></a>00653 <span class="stringliteral"></span>
<a name="l00654"></a>00654 <span class="stringliteral"> /**************************************</span>
<a name="l00655"></a>00655 <span class="stringliteral"> *</span>
<a name="l00656"></a>00656 <span class="stringliteral"> * SQL Parsing, helper functions for parts of queries</span>
<a name="l00657"></a>00657 <span class="stringliteral"> *</span>
<a name="l00658"></a>00658 <span class="stringliteral"> **************************************/</span>
<a name="l00659"></a>00659 <span class="stringliteral"></span>
<a name="l00670"></a><a class="code" href="classt3lib__sqlparser.html#7f3c4b044c0ba3415100e145f898f91b">00670</a> <span class="stringliteral"> function parseFieldList(&$parseString, $stopRegex='') {</span>
<a name="l00671"></a>00671 <span class="stringliteral"></span>
<a name="l00672"></a>00672 <span class="stringliteral"> $stack = array(); // Contains the parsed content</span>
<a name="l00673"></a>00673 <span class="stringliteral"></span>
<a name="l00674"></a>00674 <span class="stringliteral"> if(strlen($parseString)==0) return $stack; // FIXME - should never happen, why does it?</span>
<a name="l00675"></a>00675 <span class="stringliteral"></span>
<a name="l00676"></a>00676 <span class="stringliteral"> $pnt = 0; // Pointer to positions in $stack</span>
<a name="l00677"></a>00677 <span class="stringliteral"> $level = 0; // Indicates the parenthesis level we are at.</span>
<a name="l00678"></a>00678 <span class="stringliteral"> $loopExit = 0; // Recursivity brake.</span>
<a name="l00679"></a>00679 <span class="stringliteral"></span>
<a name="l00680"></a>00680 <span class="stringliteral"> // Prepare variables:</span>
<a name="l00681"></a>00681 <span class="stringliteral"> $parseString = $this->trimSQL($parseString);</span>
<a name="l00682"></a>00682 <span class="stringliteral"> $this->lastStopKeyWord = '';</span>
<a name="l00683"></a>00683 <span class="stringliteral"> $this->parse_error = '';</span>
<a name="l00684"></a>00684 <span class="stringliteral"></span>
<a name="l00685"></a>00685 <span class="stringliteral"> // $parseString is continously shortend by the process and we keep parsing it till it is zero:</span>
<a name="l00686"></a>00686 <span class="stringliteral"> while (strlen($parseString)) {</span>
<a name="l00687"></a>00687 <span class="stringliteral"></span>
<a name="l00688"></a>00688 <span class="stringliteral"> // Checking if we are inside / outside parenthesis (in case of a function like count(), max(), min() etc...):</span>
<a name="l00689"></a>00689 <span class="stringliteral"> if ($level>0) { // Inside parenthesis here (does NOT detect if values in quotes are used, the only token is "</span>)<span class="stringliteral">" or "</span>(<span class="stringliteral">"):</span>
<a name="l00690"></a>00690 <span class="stringliteral"></span>
<a name="l00691"></a>00691 <span class="stringliteral"> // Accumulate function content until next () parenthesis:</span>
<a name="l00692"></a>00692 <span class="stringliteral"> $funcContent = $this->nextPart($parseString,'^([^()]*.)');</span>
<a name="l00693"></a>00693 <span class="stringliteral"> $stack[$pnt]['func_content.'][] = array(</span>
<a name="l00694"></a>00694 <span class="stringliteral"> 'level' => $level,</span>
<a name="l00695"></a>00695 <span class="stringliteral"> 'func_content' => substr($funcContent,0,-1)</span>
<a name="l00696"></a>00696 <span class="stringliteral"> );</span>
<a name="l00697"></a>00697 <span class="stringliteral"> $stack[$pnt]['func_content'].= $funcContent;</span>
<a name="l00698"></a>00698 <span class="stringliteral"></span>
<a name="l00699"></a>00699 <span class="stringliteral"> // Detecting ( or )</span>
<a name="l00700"></a>00700 <span class="stringliteral"> switch(substr($stack[$pnt]['func_content'],-1)) {</span>
<a name="l00701"></a>00701 <span class="stringliteral"> case '(':</span>
<a name="l00702"></a>00702 <span class="stringliteral"> $level++;</span>
<a name="l00703"></a>00703 <span class="stringliteral"> break;</span>
<a name="l00704"></a>00704 <span class="stringliteral"> case ')':</span>
<a name="l00705"></a>00705 <span class="stringliteral"> $level--;</span>
<a name="l00706"></a>00706 <span class="stringliteral"> if (!$level) { // If this was the last parenthesis:</span>
<a name="l00707"></a>00707 <span class="stringliteral"> $stack[$pnt]['func_content'] = substr($stack[$pnt]['func_content'],0,-1);</span>
<a name="l00708"></a>00708 <span class="stringliteral"> $parseString = ltrim($parseString); // Remove any whitespace after the parenthesis.</span>
<a name="l00709"></a>00709 <span class="stringliteral"> }</span>
<a name="l00710"></a>00710 <span class="stringliteral"> break;</span>
<a name="l00711"></a>00711 <span class="stringliteral"> }</span>
<a name="l00712"></a>00712 <span class="stringliteral"> } else { // Outside parenthesis, looking for next field:</span>
<a name="l00713"></a>00713 <span class="stringliteral"></span>
<a name="l00714"></a>00714 <span class="stringliteral"> // Looking for a known function (only known functions supported)</span>
<a name="l00715"></a>00715 <span class="stringliteral"> $func = $this->nextPart($parseString,'^(count|max|min|floor|sum|avg)[[:space:]]*\(');</span>
<a name="l00716"></a>00716 <span class="stringliteral"> if ($func) {</span>
<a name="l00717"></a>00717 <span class="stringliteral"> $parseString = trim(substr($parseString,1)); // Strip of "</span>(<span class="stringliteral">"</span>
<a name="l00718"></a>00718 <span class="stringliteral"> $stack[$pnt]['type'] = 'function';</span>
<a name="l00719"></a>00719 <span class="stringliteral"> $stack[$pnt]['function'] = $func;</span>
<a name="l00720"></a>00720 <span class="stringliteral"> $level++; // increse parenthesis level counter.</span>
<a name="l00721"></a>00721 <span class="stringliteral"> } else {</span>
<a name="l00722"></a>00722 <span class="stringliteral"> $stack[$pnt]['distinct'] = $this->nextPart($parseString,'^(distinct[[:space:]]+)');</span>
<a name="l00723"></a>00723 <span class="stringliteral"> // Otherwise, look for regular fieldname:</span>
<a name="l00724"></a>00724 <span class="stringliteral"> if ($fieldName = $this->nextPart($parseString,'^([[:alnum:]\*._]+)(,|[[:space:]]+)')) {</span>
<a name="l00725"></a>00725 <span class="stringliteral"> $stack[$pnt]['type'] = 'field';</span>
<a name="l00726"></a>00726 <span class="stringliteral"></span>
<a name="l00727"></a>00727 <span class="stringliteral"> // Explode fieldname into field and table:</span>
<a name="l00728"></a>00728 <span class="stringliteral"> $tableField = explode('.',$fieldName,2);</span>
<a name="l00729"></a>00729 <span class="stringliteral"> if (count($tableField)==2) {</span>
<a name="l00730"></a>00730 <span class="stringliteral"> $stack[$pnt]['table'] = $tableField[0];</span>
<a name="l00731"></a>00731 <span class="stringliteral"> $stack[$pnt]['field'] = $tableField[1];</span>
<a name="l00732"></a>00732 <span class="stringliteral"> } else {</span>
<a name="l00733"></a>00733 <span class="stringliteral"> $stack[$pnt]['table'] = '';</span>
<a name="l00734"></a>00734 <span class="stringliteral"> $stack[$pnt]['field'] = $tableField[0];</span>
<a name="l00735"></a>00735 <span class="stringliteral"> }</span>
<a name="l00736"></a>00736 <span class="stringliteral"> } else {</span>
<a name="l00737"></a>00737 <span class="stringliteral"> return $this->parseError('No field name found as expected in parseFieldList()',$parseString);</span>
<a name="l00738"></a>00738 <span class="stringliteral"> }</span>
<a name="l00739"></a>00739 <span class="stringliteral"> }</span>
<a name="l00740"></a>00740 <span class="stringliteral"> }</span>
<a name="l00741"></a>00741 <span class="stringliteral"></span>
<a name="l00742"></a>00742 <span class="stringliteral"> // After a function or field we look for "</span>AS<span class="stringliteral">" alias and a comma to separate to the next field in the list:</span>
<a name="l00743"></a>00743 <span class="stringliteral"> if (!$level) {</span>
<a name="l00744"></a>00744 <span class="stringliteral"></span>
<a name="l00745"></a>00745 <span class="stringliteral"> // Looking for "</span>AS<span class="stringliteral">" alias:</span>
<a name="l00746"></a>00746 <span class="stringliteral"> if ($as = $this->nextPart($parseString,'^(AS)[[:space:]]+')) {</span>
<a name="l00747"></a>00747 <span class="stringliteral"> $stack[$pnt]['as'] = $this->nextPart($parseString,'^([[:alnum:]_]+)(,|[[:space:]]+)');</span>
<a name="l00748"></a>00748 <span class="stringliteral"> $stack[$pnt]['as_keyword'] = $as;</span>
<a name="l00749"></a>00749 <span class="stringliteral"> }</span>
<a name="l00750"></a>00750 <span class="stringliteral"></span>
<a name="l00751"></a>00751 <span class="stringliteral"> // Looking for "</span>ASC<span class="stringliteral">" or "</span>DESC<span class="stringliteral">" keywords (for ORDER BY)</span>
<a name="l00752"></a>00752 <span class="stringliteral"> if ($sDir = $this->nextPart($parseString,'^(ASC|DESC)([[:space:]]+|,)')) {</span>
<a name="l00753"></a>00753 <span class="stringliteral"> $stack[$pnt]['sortDir'] = $sDir;</span>
<a name="l00754"></a>00754 <span class="stringliteral"> }</span>
<a name="l00755"></a>00755 <span class="stringliteral"></span>
<a name="l00756"></a>00756 <span class="stringliteral"> // Looking for stop-keywords:</span>
<a name="l00757"></a>00757 <span class="stringliteral"> if ($stopRegex && $this->lastStopKeyWord = $this->nextPart($parseString, $stopRegex)) {</span>
<a name="l00758"></a>00758 <span class="stringliteral"> $this->lastStopKeyWord = strtoupper(str_replace(array(' ',"</span>\t<span class="stringliteral">","</span>\r<span class="stringliteral">","</span>\n<span class="stringliteral">"),'',$this->lastStopKeyWord));</span>
<a name="l00759"></a>00759 <span class="stringliteral"> return $stack;</span>
<a name="l00760"></a>00760 <span class="stringliteral"> }</span>
<a name="l00761"></a>00761 <span class="stringliteral"></span>
<a name="l00762"></a>00762 <span class="stringliteral"> // Looking for comma (since the stop-keyword did not trigger a return...)</span>
<a name="l00763"></a>00763 <span class="stringliteral"> if (strlen($parseString) && !$this->nextPart($parseString,'^(,)')) {</span>
<a name="l00764"></a>00764 <span class="stringliteral"> return $this->parseError('No comma found as expected in parseFieldList()',$parseString);</span>
<a name="l00765"></a>00765 <span class="stringliteral"> }</span>
<a name="l00766"></a>00766 <span class="stringliteral"></span>
<a name="l00767"></a>00767 <span class="stringliteral"> // Increasing pointer:</span>
<a name="l00768"></a>00768 <span class="stringliteral"> $pnt++;</span>
<a name="l00769"></a>00769 <span class="stringliteral"> }</span>
<a name="l00770"></a>00770 <span class="stringliteral"></span>
<a name="l00771"></a>00771 <span class="stringliteral"> // Check recursivity brake:</span>
<a name="l00772"></a>00772 <span class="stringliteral"> $loopExit++;</span>
<a name="l00773"></a>00773 <span class="stringliteral"> if ($loopExit>500) {</span>
<a name="l00774"></a>00774 <span class="stringliteral"> return $this->parseError('More than 500 loops, exiting prematurely in parseFieldList()...',$parseString);</span>
<a name="l00775"></a>00775 <span class="stringliteral"> }</span>
<a name="l00776"></a>00776 <span class="stringliteral"> }</span>
<a name="l00777"></a>00777 <span class="stringliteral"></span>
<a name="l00778"></a>00778 <span class="stringliteral"> // Return result array:</span>
<a name="l00779"></a>00779 <span class="stringliteral"> return $stack;</span>
<a name="l00780"></a>00780 <span class="stringliteral"> }</span>
<a name="l00781"></a>00781 <span class="stringliteral"></span>
<a name="l00791"></a><a class="code" href="classt3lib__sqlparser.html#fb008468bcb6cff9b5ccd5fa7d670729">00791</a> <span class="stringliteral"> function parseFromTables(&$parseString, $stopRegex='') {</span>
<a name="l00792"></a>00792 <span class="stringliteral"></span>
<a name="l00793"></a>00793 <span class="stringliteral"> // Prepare variables:</span>
<a name="l00794"></a>00794 <span class="stringliteral"> $parseString = $this->trimSQL($parseString);</span>
<a name="l00795"></a>00795 <span class="stringliteral"> $this->lastStopKeyWord = '';</span>
<a name="l00796"></a>00796 <span class="stringliteral"> $this->parse_error = '';</span>
<a name="l00797"></a>00797 <span class="stringliteral"></span>
<a name="l00798"></a>00798 <span class="stringliteral"> $stack = array(); // Contains the parsed content</span>
<a name="l00799"></a>00799 <span class="stringliteral"> $pnt = 0; // Pointer to positions in $stack</span>
<a name="l00800"></a>00800 <span class="stringliteral"> $loopExit = 0; // Recursivity brake.</span>
<a name="l00801"></a>00801 <span class="stringliteral"></span>
<a name="l00802"></a>00802 <span class="stringliteral"> // $parseString is continously shortend by the process and we keep parsing it till it is zero:</span>
<a name="l00803"></a>00803 <span class="stringliteral"> while (strlen($parseString)) {</span>
<a name="l00804"></a>00804 <span class="stringliteral"> // Looking for the table:</span>
<a name="l00805"></a>00805 <span class="stringliteral"> if ($stack[$pnt]['table'] = $this->nextPart($parseString,'^([[:alnum:]_]+)(,|[[:space:]]+)')) {</span>
<a name="l00806"></a>00806 <span class="stringliteral"> // Looking for stop-keywords before fetching potential table alias:</span>
<a name="l00807"></a>00807 <span class="stringliteral"> if ($stopRegex && ($this->lastStopKeyWord = $this->nextPart($parseString, $stopRegex))) {</span>
<a name="l00808"></a>00808 <span class="stringliteral"> $this->lastStopKeyWord = strtoupper(str_replace(array(' ',"</span>\t<span class="stringliteral">","</span>\r<span class="stringliteral">","</span>\n<span class="stringliteral">"),'',$this->lastStopKeyWord));</span>
<a name="l00809"></a>00809 <span class="stringliteral"> return $stack;</span>
<a name="l00810"></a>00810 <span class="stringliteral"> }</span>
<a name="l00811"></a>00811 <span class="stringliteral"> if(!preg_match('/^(LEFT|JOIN)[[:space:]]+/i',$parseString)) {</span>
<a name="l00812"></a>00812 <span class="stringliteral"> $stack[$pnt]['as_keyword'] = $this->nextPart($parseString,'^(AS[[:space:]]+)');</span>
<a name="l00813"></a>00813 <span class="stringliteral"> $stack[$pnt]['as'] = $this->nextPart($parseString,'^([[:alnum:]_]+)[[:space:]]*');</span>
<a name="l00814"></a>00814 <span class="stringliteral"> }</span>
<a name="l00815"></a>00815 <span class="stringliteral"> } else return $this->parseError('No table name found as expected in parseFromTables()!',$parseString);</span>
<a name="l00816"></a>00816 <span class="stringliteral"></span>
<a name="l00817"></a>00817 <span class="stringliteral"> // Looking for JOIN</span>
<a name="l00818"></a>00818 <span class="stringliteral"> if ($join = $this->nextPart($parseString,'^(LEFT[[:space:]]+JOIN|LEFT[[:space:]]+OUTER[[:space:]]+JOIN|JOIN)[[:space:]]+')) {</span>
<a name="l00819"></a>00819 <span class="stringliteral"> $stack[$pnt]['JOIN']['type'] = $join;</span>
<a name="l00820"></a>00820 <span class="stringliteral"> if ($stack[$pnt]['JOIN']['withTable'] = $this->nextPart($parseString,'^([[:alnum:]_]+)[[:space:]]+ON[[:space:]]+',1)) {</span>
<a name="l00821"></a>00821 <span class="stringliteral"> $field1 = $this->nextPart($parseString,'^([[:alnum:]_.]+)[[:space:]]*=[[:space:]]*',1);</span>
<a name="l00822"></a>00822 <span class="stringliteral"> $field2 = $this->nextPart($parseString,'^([[:alnum:]_.]+)[[:space:]]+');</span>
<a name="l00823"></a>00823 <span class="stringliteral"> if ($field1 && $field2) {</span>
<a name="l00824"></a>00824 <span class="stringliteral"></span>
<a name="l00825"></a>00825 <span class="stringliteral"> // Explode fields into field and table:</span>
<a name="l00826"></a>00826 <span class="stringliteral"> $tableField = explode('.',$field1,2);</span>
<a name="l00827"></a>00827 <span class="stringliteral"> $field1 = array();</span>
<a name="l00828"></a>00828 <span class="stringliteral"> if (count($tableField)!=2) {</span>
<a name="l00829"></a>00829 <span class="stringliteral"> $field1['table'] = '';</span>
<a name="l00830"></a>00830 <span class="stringliteral"> $field1['field'] = $tableField[0];</span>
<a name="l00831"></a>00831 <span class="stringliteral"> } else {</span>
<a name="l00832"></a>00832 <span class="stringliteral"> $field1['table'] = $tableField[0];</span>
<a name="l00833"></a>00833 <span class="stringliteral"> $field1['field'] = $tableField[1];</span>
<a name="l00834"></a>00834 <span class="stringliteral"> }</span>
<a name="l00835"></a>00835 <span class="stringliteral"> $tableField = explode('.',$field2,2);</span>
<a name="l00836"></a>00836 <span class="stringliteral"> $field2 = array();</span>
<a name="l00837"></a>00837 <span class="stringliteral"> if (count($tableField)!=2) {</span>
<a name="l00838"></a>00838 <span class="stringliteral"> $field2['table'] = '';</span>
<a name="l00839"></a>00839 <span class="stringliteral"> $field2['field'] = $tableField[0];</span>
<a name="l00840"></a>00840 <span class="stringliteral"> } else {</span>
<a name="l00841"></a>00841 <span class="stringliteral"> $field2['table'] = $tableField[0];</span>
<a name="l00842"></a>00842 <span class="stringliteral"> $field2['field'] = $tableField[1];</span>
<a name="l00843"></a>00843 <span class="stringliteral"> }</span>
<a name="l00844"></a>00844 <span class="stringliteral"> $stack[$pnt]['JOIN']['ON'] = array($field1,$field2);</span>
<a name="l00845"></a>00845 <span class="stringliteral"> } else return $this->parseError('No join fields found in parseFromTables()!',$parseString);</span>
<a name="l00846"></a>00846 <span class="stringliteral"> } else return $this->parseError('No join table found in parseFromTables()!',$parseString);</span>
<a name="l00847"></a>00847 <span class="stringliteral"> }</span>
<a name="l00848"></a>00848 <span class="stringliteral"></span>
<a name="l00849"></a>00849 <span class="stringliteral"> // Looking for stop-keywords:</span>
<a name="l00850"></a>00850 <span class="stringliteral"> if ($stopRegex && $this->lastStopKeyWord = $this->nextPart($parseString, $stopRegex)) {</span>
<a name="l00851"></a>00851 <span class="stringliteral"> $this->lastStopKeyWord = strtoupper(str_replace(array(' ',"</span>\t<span class="stringliteral">","</span>\r<span class="stringliteral">","</span>\n<span class="stringliteral">"),'',$this->lastStopKeyWord));</span>
<a name="l00852"></a>00852 <span class="stringliteral"> return $stack;</span>
<a name="l00853"></a>00853 <span class="stringliteral"> }</span>
<a name="l00854"></a>00854 <span class="stringliteral"></span>
<a name="l00855"></a>00855 <span class="stringliteral"> // Looking for comma:</span>
<a name="l00856"></a>00856 <span class="stringliteral"> if (strlen($parseString) && !$this->nextPart($parseString,'^(,)')) {</span>
<a name="l00857"></a>00857 <span class="stringliteral"> return $this->parseError('No comma found as expected in parseFromTables()',$parseString);</span>
<a name="l00858"></a>00858 <span class="stringliteral"> }</span>
<a name="l00859"></a>00859 <span class="stringliteral"></span>
<a name="l00860"></a>00860 <span class="stringliteral"> // Increasing pointer:</span>
<a name="l00861"></a>00861 <span class="stringliteral"> $pnt++;</span>
<a name="l00862"></a>00862 <span class="stringliteral"></span>
<a name="l00863"></a>00863 <span class="stringliteral"> // Check recursivity brake:</span>
<a name="l00864"></a>00864 <span class="stringliteral"> $loopExit++;</span>
<a name="l00865"></a>00865 <span class="stringliteral"> if ($loopExit>500) {</span>
<a name="l00866"></a>00866 <span class="stringliteral"> return $this->parseError('More than 500 loops, exiting prematurely in parseFromTables()...',$parseString);</span>
<a name="l00867"></a>00867 <span class="stringliteral"> }</span>
<a name="l00868"></a>00868 <span class="stringliteral"> }</span>
<a name="l00869"></a>00869 <span class="stringliteral"></span>
<a name="l00870"></a>00870 <span class="stringliteral"> // Return result array:</span>
<a name="l00871"></a>00871 <span class="stringliteral"> return $stack;</span>
<a name="l00872"></a>00872 <span class="stringliteral"> }</span>
<a name="l00873"></a>00873 <span class="stringliteral"></span>
<a name="l00882"></a><a class="code" href="classt3lib__sqlparser.html#150e4f0572e42e372ae92017fbec7279">00882</a> <span class="stringliteral"> function parseWhereClause(&$parseString, $stopRegex='') {</span>
<a name="l00883"></a>00883 <span class="stringliteral"></span>
<a name="l00884"></a>00884 <span class="stringliteral"> // Prepare variables:</span>
<a name="l00885"></a>00885 <span class="stringliteral"> $parseString = $this->trimSQL($parseString);</span>
<a name="l00886"></a>00886 <span class="stringliteral"> $this->lastStopKeyWord = '';</span>
<a name="l00887"></a>00887 <span class="stringliteral"> $this->parse_error = '';</span>
<a name="l00888"></a>00888 <span class="stringliteral"></span>
<a name="l00889"></a>00889 <span class="stringliteral"> $stack = array(0 => array()); // Contains the parsed content</span>
<a name="l00890"></a>00890 <span class="stringliteral"> $pnt = array(0 => 0); // Pointer to positions in $stack</span>
<a name="l00891"></a>00891 <span class="stringliteral"> $level = 0; // Determines parenthesis level</span>
<a name="l00892"></a>00892 <span class="stringliteral"> $loopExit = 0; // Recursivity brake.</span>
<a name="l00893"></a>00893 <span class="stringliteral"></span>
<a name="l00894"></a>00894 <span class="stringliteral"> // $parseString is continously shortend by the process and we keep parsing it till it is zero:</span>
<a name="l00895"></a>00895 <span class="stringliteral"> while (strlen($parseString)) {</span>
<a name="l00896"></a>00896 <span class="stringliteral"></span>
<a name="l00897"></a>00897 <span class="stringliteral"> // Look for next parenthesis level:</span>
<a name="l00898"></a>00898 <span class="stringliteral"> $newLevel = $this->nextPart($parseString,'^([(])');</span>
<a name="l00899"></a>00899 <span class="stringliteral"> if ($newLevel=='(') { // If new level is started, manage stack/pointers:</span>
<a name="l00900"></a>00900 <span class="stringliteral"> $level++; // Increase level</span>
<a name="l00901"></a>00901 <span class="stringliteral"> $pnt[$level] = 0; // Reset pointer for this level</span>
<a name="l00902"></a>00902 <span class="stringliteral"> $stack[$level] = array(); // Reset stack for this level</span>
<a name="l00903"></a>00903 <span class="stringliteral"> } else { // If no new level is started, just parse the current level:</span>
<a name="l00904"></a>00904 <span class="stringliteral"></span>
<a name="l00905"></a>00905 <span class="stringliteral"> // Find "</span>modifyer<span class="stringliteral">", eg. "</span>NOT or !<span class="stringliteral">"</span>
<a name="l00906"></a>00906 <span class="stringliteral"> $stack[$level][$pnt[$level]]['modifier'] = trim($this->nextPart($parseString,'^(!|NOT[[:space:]]+)'));</span>
<a name="l00907"></a>00907 <span class="stringliteral"></span>
<a name="l00908"></a>00908 <span class="stringliteral"> // Fieldname:</span>
<a name="l00909"></a>00909 <span class="stringliteral"> if ($fieldName = $this->nextPart($parseString,'^([[:alnum:]._]+)([[:space:]]+|&|<=|>=|<|>|=|!=|IS)')) {</span>
<a name="l00910"></a>00910 <span class="stringliteral"></span>
<a name="l00911"></a>00911 <span class="stringliteral"> // Parse field name into field and table:</span>
<a name="l00912"></a>00912 <span class="stringliteral"> $tableField = explode('.',$fieldName,2);</span>
<a name="l00913"></a>00913 <span class="stringliteral"> if (count($tableField)==2) {</span>
<a name="l00914"></a>00914 <span class="stringliteral"> $stack[$level][$pnt[$level]]['table'] = $tableField[0];</span>
<a name="l00915"></a>00915 <span class="stringliteral"> $stack[$level][$pnt[$level]]['field'] = $tableField[1];</span>
<a name="l00916"></a>00916 <span class="stringliteral"> } else {</span>
<a name="l00917"></a>00917 <span class="stringliteral"> $stack[$level][$pnt[$level]]['table'] = '';</span>
<a name="l00918"></a>00918 <span class="stringliteral"> $stack[$level][$pnt[$level]]['field'] = $tableField[0];</span>
<a name="l00919"></a>00919 <span class="stringliteral"> }</span>
<a name="l00920"></a>00920 <span class="stringliteral"> } else {</span>
<a name="l00921"></a>00921 <span class="stringliteral"> return $this->parseError('No field name found as expected in parseWhereClause()',$parseString);</span>
<a name="l00922"></a>00922 <span class="stringliteral"> }</span>
<a name="l00923"></a>00923 <span class="stringliteral"></span>
<a name="l00924"></a>00924 <span class="stringliteral"> // See if the value is calculated. Support only for "</span>&<span class="stringliteral">" (boolean AND) at the moment:</span>
<a name="l00925"></a>00925 <span class="stringliteral"> $stack[$level][$pnt[$level]]['calc'] = $this->nextPart($parseString,'^(&)');</span>
<a name="l00926"></a>00926 <span class="stringliteral"> if (strlen($stack[$level][$pnt[$level]]['calc'])) {</span>
<a name="l00927"></a>00927 <span class="stringliteral"> // Finding value for calculation:</span>
<a name="l00928"></a>00928 <span class="stringliteral"> $stack[$level][$pnt[$level]]['calc_value'] = $this->getValue($parseString);</span>
<a name="l00929"></a>00929 <span class="stringliteral"> }</span>
<a name="l00930"></a>00930 <span class="stringliteral"></span>
<a name="l00931"></a>00931 <span class="stringliteral"> // Find "</span>comparator<span class="stringliteral">":</span>
<a name="l00932"></a>00932 <span class="stringliteral"> $stack[$level][$pnt[$level]]['comparator'] = $this->nextPart($parseString,'^(<=|>=|<|>|=|!=|NOT[[:space:]]+IN|IN|NOT[[:space:]]+LIKE|LIKE|IS[[:space:]]+NOT|IS)');</span>
<a name="l00933"></a>00933 <span class="stringliteral"> if (strlen($stack[$level][$pnt[$level]]['comparator'])) {</span>
<a name="l00934"></a>00934 <span class="stringliteral"> // Finding value for comparator:</span>
<a name="l00935"></a>00935 <span class="stringliteral"> $stack[$level][$pnt[$level]]['value'] = $this->getValue($parseString,$stack[$level][$pnt[$level]]['comparator']);</span>
<a name="l00936"></a>00936 <span class="stringliteral"> if ($this->parse_error) { return $this->parse_error; }</span>
<a name="l00937"></a>00937 <span class="stringliteral"> }</span>
<a name="l00938"></a>00938 <span class="stringliteral"></span>
<a name="l00939"></a>00939 <span class="stringliteral"> // Finished, increase pointer:</span>
<a name="l00940"></a>00940 <span class="stringliteral"> $pnt[$level]++;</span>
<a name="l00941"></a>00941 <span class="stringliteral"></span>
<a name="l00942"></a>00942 <span class="stringliteral"> // Checking if the current level is ended, in that case do stack management:</span>
<a name="l00943"></a>00943 <span class="stringliteral"> while ($this->nextPart($parseString,'^([)])')) {</span>
<a name="l00944"></a>00944 <span class="stringliteral"> $level--; // Decrease level:</span>
<a name="l00945"></a>00945 <span class="stringliteral"> $stack[$level][$pnt[$level]]['sub'] = $stack[$level+1]; // Copy stack</span>
<a name="l00946"></a>00946 <span class="stringliteral"> $pnt[$level]++; // Increase pointer of the new level</span>
<a name="l00947"></a>00947 <span class="stringliteral"></span>
<a name="l00948"></a>00948 <span class="stringliteral"> // Make recursivity check:</span>
<a name="l00949"></a>00949 <span class="stringliteral"> $loopExit++;</span>
<a name="l00950"></a>00950 <span class="stringliteral"> if ($loopExit>500) {</span>
<a name="l00951"></a>00951 <span class="stringliteral"> return $this->parseError('More than 500 loops (in search for exit parenthesis), exiting prematurely in parseWhereClause()...',$parseString);</span>
<a name="l00952"></a>00952 <span class="stringliteral"> }</span>
<a name="l00953"></a>00953 <span class="stringliteral"> }</span>
<a name="l00954"></a>00954 <span class="stringliteral"></span>
<a name="l00955"></a>00955 <span class="stringliteral"> // Detecting the operator for the next level:</span>
<a name="l00956"></a>00956 <span class="stringliteral"> $op = $this->nextPart($parseString,'^(AND[[:space:]]+NOT|OR[[:space:]]+NOT|AND|OR)(\(|[[:space:]]+)');</span>
<a name="l00957"></a>00957 <span class="stringliteral"> if ($op) {</span>
<a name="l00958"></a>00958 <span class="stringliteral"> $stack[$level][$pnt[$level]]['operator'] = $op;</span>
<a name="l00959"></a>00959 <span class="stringliteral"> } elseif (strlen($parseString)) {</span>
<a name="l00960"></a>00960 <span class="stringliteral"></span>
<a name="l00961"></a>00961 <span class="stringliteral"> // Looking for stop-keywords:</span>
<a name="l00962"></a>00962 <span class="stringliteral"> if ($stopRegex && $this->lastStopKeyWord = $this->nextPart($parseString, $stopRegex)) {</span>
<a name="l00963"></a>00963 <span class="stringliteral"> $this->lastStopKeyWord = strtoupper(str_replace(array(' ',"</span>\t<span class="stringliteral">","</span>\r<span class="stringliteral">","</span>\n<span class="stringliteral">"),'',$this->lastStopKeyWord));</span>
<a name="l00964"></a>00964 <span class="stringliteral"> return $stack[0];</span>
<a name="l00965"></a>00965 <span class="stringliteral"> } else {</span>
<a name="l00966"></a>00966 <span class="stringliteral"> return $this->parseError('No operator, but parsing not finished in parseWhereClause().',$parseString);</span>
<a name="l00967"></a>00967 <span class="stringliteral"> }</span>
<a name="l00968"></a>00968 <span class="stringliteral"> }</span>
<a name="l00969"></a>00969 <span class="stringliteral"> }</span>
<a name="l00970"></a>00970 <span class="stringliteral"></span>
<a name="l00971"></a>00971 <span class="stringliteral"> // Make recursivity check:</span>
<a name="l00972"></a>00972 <span class="stringliteral"> $loopExit++;</span>
<a name="l00973"></a>00973 <span class="stringliteral"> if ($loopExit>500) {</span>
<a name="l00974"></a>00974 <span class="stringliteral"> return $this->parseError('More than 500 loops, exiting prematurely in parseWhereClause()...',$parseString);</span>
<a name="l00975"></a>00975 <span class="stringliteral"> }</span>
<a name="l00976"></a>00976 <span class="stringliteral"> }</span>
<a name="l00977"></a>00977 <span class="stringliteral"></span>
<a name="l00978"></a>00978 <span class="stringliteral"> // Return the stacks lowest level:</span>
<a name="l00979"></a>00979 <span class="stringliteral"> return $stack[0];</span>
<a name="l00980"></a>00980 <span class="stringliteral"> }</span>
<a name="l00981"></a>00981 <span class="stringliteral"></span>
<a name="l00990"></a><a class="code" href="classt3lib__sqlparser.html#794b29918fe99ccb55c0453b2402796f">00990</a> <span class="stringliteral"> function parseFieldDef(&$parseString, $stopRegex='') {</span>
<a name="l00991"></a>00991 <span class="stringliteral"> // Prepare variables:</span>
<a name="l00992"></a>00992 <span class="stringliteral"> $parseString = $this->trimSQL($parseString);</span>
<a name="l00993"></a>00993 <span class="stringliteral"> $this->lastStopKeyWord = '';</span>
<a name="l00994"></a>00994 <span class="stringliteral"> $this->parse_error = '';</span>
<a name="l00995"></a>00995 <span class="stringliteral"></span>
<a name="l00996"></a>00996 <span class="stringliteral"> $result = array();</span>
<a name="l00997"></a>00997 <span class="stringliteral"></span>
<a name="l00998"></a>00998 <span class="stringliteral"> // Field type:</span>
<a name="l00999"></a>00999 <span class="stringliteral"> if ($result['fieldType'] = $this->nextPart($parseString,'^(int|smallint|tinyint|mediumint|bigint|double|numeric|decimal|float|varchar|char|text|tinytext|mediumtext|longtext|blob|tinyblob|mediumblob|longblob)([[:space:],]+|\()')) {</span>
<a name="l01000"></a>01000 <span class="stringliteral"></span>
<a name="l01001"></a>01001 <span class="stringliteral"> // Looking for value:</span>
<a name="l01002"></a>01002 <span class="stringliteral"> if (substr($parseString,0,1)=='(') {</span>
<a name="l01003"></a>01003 <span class="stringliteral"> $parseString = substr($parseString,1);</span>
<a name="l01004"></a>01004 <span class="stringliteral"> if ($result['value'] = $this->nextPart($parseString,'^([^)]*)')) {</span>
<a name="l01005"></a>01005 <span class="stringliteral"> $parseString = ltrim(substr($parseString,1));</span>
<a name="l01006"></a>01006 <span class="stringliteral"> } else return $this->parseError('No end-parenthesis for value found in parseFieldDef()!',$parseString);</span>
<a name="l01007"></a>01007 <span class="stringliteral"> }</span>
<a name="l01008"></a>01008 <span class="stringliteral"></span>
<a name="l01009"></a>01009 <span class="stringliteral"> // Looking for keywords</span>
<a name="l01010"></a>01010 <span class="stringliteral"> while($keyword = $this->nextPart($parseString,'^(DEFAULT|NOT[[:space:]]+NULL|AUTO_INCREMENT|UNSIGNED)([[:space:]]+|,|\))')) {</span>
<a name="l01011"></a>01011 <span class="stringliteral"> $keywordCmp = strtoupper(str_replace(array(' ',"</span>\t<span class="stringliteral">","</span>\r<span class="stringliteral">","</span>\n<span class="stringliteral">"),'',$keyword));</span>
<a name="l01012"></a>01012 <span class="stringliteral"></span>
<a name="l01013"></a>01013 <span class="stringliteral"> $result['featureIndex'][$keywordCmp]['keyword'] = $keyword;</span>
<a name="l01014"></a>01014 <span class="stringliteral"></span>
<a name="l01015"></a>01015 <span class="stringliteral"> switch($keywordCmp) {</span>
<a name="l01016"></a>01016 <span class="stringliteral"> case 'DEFAULT':</span>
<a name="l01017"></a>01017 <span class="stringliteral"> $result['featureIndex'][$keywordCmp]['value'] = $this->getValue($parseString);</span>
<a name="l01018"></a>01018 <span class="stringliteral"> break;</span>
<a name="l01019"></a>01019 <span class="stringliteral"> }</span>
<a name="l01020"></a>01020 <span class="stringliteral"> }</span>
<a name="l01021"></a>01021 <span class="stringliteral"> } else {</span>
<a name="l01022"></a>01022 <span class="stringliteral"> return $this->parseError('Field type unknown in parseFieldDef()!',$parseString);</span>
<a name="l01023"></a>01023 <span class="stringliteral"> }</span>
<a name="l01024"></a>01024 <span class="stringliteral"></span>
<a name="l01025"></a>01025 <span class="stringliteral"> return $result;</span>
<a name="l01026"></a>01026 <span class="stringliteral"> }</span>
<a name="l01027"></a>01027 <span class="stringliteral"></span>
<a name="l01028"></a>01028 <span class="stringliteral"></span>
<a name="l01029"></a>01029 <span class="stringliteral"></span>
<a name="l01030"></a>01030 <span class="stringliteral"></span>
<a name="l01031"></a>01031 <span class="stringliteral"></span>
<a name="l01032"></a>01032 <span class="stringliteral"></span>
<a name="l01033"></a>01033 <span class="stringliteral"></span>
<a name="l01034"></a>01034 <span class="stringliteral"></span>
<a name="l01035"></a>01035 <span class="stringliteral"></span>
<a name="l01036"></a>01036 <span class="stringliteral"></span>
<a name="l01037"></a>01037 <span class="stringliteral"></span>
<a name="l01038"></a>01038 <span class="stringliteral"> /************************************</span>
<a name="l01039"></a>01039 <span class="stringliteral"> *</span>
<a name="l01040"></a>01040 <span class="stringliteral"> * Parsing: Helper functions</span>
<a name="l01041"></a>01041 <span class="stringliteral"> *</span>
<a name="l01042"></a>01042 <span class="stringliteral"> ************************************/</span>
<a name="l01043"></a>01043 <span class="stringliteral"></span>
<a name="l01053"></a><a class="code" href="classt3lib__sqlparser.html#79a91063ceb67a9179e72b35562bca4f">01053</a> <span class="stringliteral"> function nextPart(&$parseString,$regex,$trimAll=FALSE) {</span>
<a name="l01054"></a>01054 <span class="stringliteral"> $reg = array();</span>
<a name="l01055"></a>01055 <span class="stringliteral"> if (preg_match('/'.$regex.'/i',$parseString.' ', $reg)) { // Adding space char because [[:space:]]+ is often a requirement in regex's</span>
<a name="l01056"></a>01056 <span class="stringliteral"> $parseString = ltrim(substr($parseString,strlen($reg[$trimAll?0:1])));</span>
<a name="l01057"></a>01057 <span class="stringliteral"> return $reg[1];</span>
<a name="l01058"></a>01058 <span class="stringliteral"> }</span>
<a name="l01059"></a>01059 <span class="stringliteral"> }</span>
<a name="l01060"></a>01060 <span class="stringliteral"></span>
<a name="l01068"></a><a class="code" href="classt3lib__sqlparser.html#823616337fd26fdff4a222de04223124">01068</a> <span class="stringliteral"> function getValue(&$parseString,$comparator='') {</span>
<a name="l01069"></a>01069 <span class="stringliteral"> $value = '';</span>
<a name="l01070"></a>01070 <span class="stringliteral"></span>
<a name="l01071"></a>01071 <span class="stringliteral"> if (t3lib_div::inList('NOTIN,IN,_LIST',strtoupper(str_replace(array(' ',"</span>\n<span class="stringliteral">","</span>\r<span class="stringliteral">","</span>\t<span class="stringliteral">"),'',$comparator)))) { // List of values:</span>
<a name="l01072"></a>01072 <span class="stringliteral"> if ($this->nextPart($parseString,'^([(])')) {</span>
<a name="l01073"></a>01073 <span class="stringliteral"> $listValues = array();</span>
<a name="l01074"></a>01074 <span class="stringliteral"> $comma=',';</span>
<a name="l01075"></a>01075 <span class="stringliteral"></span>
<a name="l01076"></a>01076 <span class="stringliteral"> while($comma==',') {</span>
<a name="l01077"></a>01077 <span class="stringliteral"> $listValues[] = $this->getValue($parseString);</span>
<a name="l01078"></a>01078 <span class="stringliteral"> $comma = $this->nextPart($parseString,'^([,])');</span>
<a name="l01079"></a>01079 <span class="stringliteral"> }</span>
<a name="l01080"></a>01080 <span class="stringliteral"></span>
<a name="l01081"></a>01081 <span class="stringliteral"> $out = $this->nextPart($parseString,'^([)])');</span>
<a name="l01082"></a>01082 <span class="stringliteral"> if ($out) {</span>
<a name="l01083"></a>01083 <span class="stringliteral"> if ($comparator=='_LIST') {</span>
<a name="l01084"></a>01084 <span class="stringliteral"> $kVals = array();</span>
<a name="l01085"></a>01085 <span class="stringliteral"> foreach ($listValues as $vArr) {</span>
<a name="l01086"></a>01086 <span class="stringliteral"> $kVals[] = $vArr[0];</span>
<a name="l01087"></a>01087 <span class="stringliteral"> }</span>
<a name="l01088"></a>01088 <span class="stringliteral"> return $kVals;</span>
<a name="l01089"></a>01089 <span class="stringliteral"> } else {</span>
<a name="l01090"></a>01090 <span class="stringliteral"> return $listValues;</span>
<a name="l01091"></a>01091 <span class="stringliteral"> }</span>
<a name="l01092"></a>01092 <span class="stringliteral"> } else return array($this->parseError('No ) parenthesis in list',$parseString));</span>
<a name="l01093"></a>01093 <span class="stringliteral"> } else return array($this->parseError('No ( parenthesis starting the list',$parseString));</span>
<a name="l01094"></a>01094 <span class="stringliteral"></span>
<a name="l01095"></a>01095 <span class="stringliteral"> } else { // Just plain string value, in quotes or not:</span>
<a name="l01096"></a>01096 <span class="stringliteral"></span>
<a name="l01097"></a>01097 <span class="stringliteral"> // Quote?</span>
<a name="l01098"></a>01098 <span class="stringliteral"> $firstChar = substr($parseString,0,1);</span>
<a name="l01099"></a>01099 <span class="stringliteral"> switch($firstChar) {</span>
<a name="l01100"></a>01100 <span class="stringliteral"> case '"</span>':
<a name="l01101"></a>01101 $value = array($this-><a class="code" href="classt3lib__sqlparser.html#6d9a0b6a7f6c14dfe4c46cd2d665e49e">getValueInQuotes</a>($parseString,<span class="charliteral">'"'</span>),<span class="charliteral">'"'</span>);
<a name="l01102"></a>01102 <span class="keywordflow">break</span>;
<a name="l01103"></a>01103 <span class="keywordflow">case</span> <span class="stringliteral">"'"</span>:
<a name="l01104"></a>01104 $value = array($this-><a class="code" href="classt3lib__sqlparser.html#6d9a0b6a7f6c14dfe4c46cd2d665e49e">getValueInQuotes</a>($parseString,<span class="stringliteral">"'"</span>),<span class="stringliteral">"'"</span>);
<a name="l01105"></a>01105 <span class="keywordflow">break</span>;
<a name="l01106"></a>01106 <span class="keywordflow">default</span>:
<a name="l01107"></a>01107 $reg = array();
<a name="l01108"></a>01108 <span class="keywordflow">if</span> (preg_match('/^([[:alnum:]._-]+)/i',$parseString, $reg)) {
<a name="l01109"></a>01109 $parseString = ltrim(substr($parseString,strlen($reg[0])));
<a name="l01110"></a>01110 $value = array($reg[1]);
<a name="l01111"></a>01111 }
<a name="l01112"></a>01112 <span class="keywordflow">break</span>;
<a name="l01113"></a>01113 }
<a name="l01114"></a>01114 }
<a name="l01115"></a>01115 <span class="keywordflow">return</span> $value;
<a name="l01116"></a>01116 }
<a name="l01117"></a>01117
<a name="l01126"></a><a class="code" href="classt3lib__sqlparser.html#6d9a0b6a7f6c14dfe4c46cd2d665e49e">01126</a> function getValueInQuotes(&$parseString,$quote) {
<a name="l01127"></a>01127
<a name="l01128"></a>01128 $parts = explode($quote,substr($parseString,1));
<a name="l01129"></a>01129 $buffer = '';
<a name="l01130"></a>01130 foreach($parts as $k => $v) {
<a name="l01131"></a>01131 $buffer.=$v;
<a name="l01132"></a>01132
<a name="l01133"></a>01133 $reg = array();
<a name="l01134"></a>01134 <span class="comment">//preg_match('/[\]*$/',$v,$reg); // does not work. what is the *exact* meaning of the next line?</span>
<a name="l01135"></a>01135 ereg('[\]*$',$v,$reg);
<a name="l01136"></a>01136 <span class="keywordflow">if</span> ($reg AND strlen($reg[0])%2) {
<a name="l01137"></a>01137 $buffer.=$quote;
<a name="l01138"></a>01138 } <span class="keywordflow">else</span> {
<a name="l01139"></a>01139 $parseString = ltrim(substr($parseString,strlen($buffer)+2));
<a name="l01140"></a>01140 <span class="keywordflow">return</span> $this->parseStripslashes($buffer);
<a name="l01141"></a>01141 }
<a name="l01142"></a>01142 }
<a name="l01143"></a>01143 }
<a name="l01144"></a>01144
<a name="l01152"></a><a class="code" href="classt3lib__sqlparser.html#4dd8a26a5941882e59cf8291d42a6e13">01152</a> function parseStripslashes($str) {
<a name="l01153"></a>01153 $search = array('\\\\', '\\\'', '\\<span class="stringliteral">"', '\0', '\n', '\r', '\Z');</span>
<a name="l01154"></a>01154 <span class="stringliteral"> $replace = array('\\', '\'', '"</span>', <span class="stringliteral">"\x00"</span>, <span class="stringliteral">"\x0a"</span>, <span class="stringliteral">"\x0d"</span>, <span class="stringliteral">"\x1a"</span>);
<a name="l01155"></a>01155
<a name="l01156"></a>01156 <span class="keywordflow">return</span> str_replace($search, $replace, $str);
<a name="l01157"></a>01157 }
<a name="l01158"></a>01158
<a name="l01166"></a><a class="code" href="classt3lib__sqlparser.html#b6b72ec352d1199fa39042661b1d2a30">01166</a> function compileAddslashes($str) {
<a name="l01167"></a>01167 <span class="keywordflow">return</span> $str;
<a name="l01168"></a>01168 $search = array(<span class="charliteral">'\\'</span>, <span class="charliteral">'\''</span>, <span class="charliteral">'"'</span>, <span class="stringliteral">"\x00"</span>, <span class="stringliteral">"\x0a"</span>, <span class="stringliteral">"\x0d"</span>, <span class="stringliteral">"\x1a"</span>);
<a name="l01169"></a>01169 $replace = array('\\\\', '\\\'', '\\<span class="stringliteral">"', '\0', '\n', '\r', '\Z');</span>
<a name="l01170"></a>01170 <span class="stringliteral"></span>
<a name="l01171"></a>01171 <span class="stringliteral"> return str_replace($search, $replace, $str);</span>
<a name="l01172"></a>01172 <span class="stringliteral"> }</span>
<a name="l01173"></a>01173 <span class="stringliteral"></span>
<a name="l01181"></a><a class="code" href="classt3lib__sqlparser.html#021ad281fa14992ada15223cced8aec2">01181</a> <span class="stringliteral"> function parseError($msg,$restQuery) {</span>
<a name="l01182"></a>01182 <span class="stringliteral"> $this->parse_error = 'SQL engine parse ERROR: '.$msg.': near "</span>'.substr($restQuery,0,50).<span class="charliteral">'"'</span>;
<a name="l01183"></a>01183 <span class="keywordflow">return</span> $this->parse_error;
<a name="l01184"></a>01184 }
<a name="l01185"></a>01185
<a name="l01195"></a><a class="code" href="classt3lib__sqlparser.html#d2ef5063c9c6a0c08dfd86f53229e9c9">01195</a> function trimSQL($str) {
<a name="l01196"></a>01196 <span class="keywordflow">return</span> trim(rtrim($str, <span class="stringliteral">"; \r\n\t"</span>)).<span class="charliteral">' '</span>;
<a name="l01197"></a>01197 <span class="comment">//return trim(ereg_replace('[[:space:];]*$','',$str)).' ';</span>
<a name="l01198"></a>01198 }
<a name="l01199"></a>01199
<a name="l01200"></a>01200
<a name="l01201"></a>01201
<a name="l01202"></a>01202
<a name="l01203"></a>01203
<a name="l01204"></a>01204
<a name="l01205"></a>01205
<a name="l01206"></a>01206
<a name="l01207"></a>01207
<a name="l01208"></a>01208
<a name="l01209"></a>01209
<a name="l01210"></a>01210
<a name="l01211"></a>01211 <span class="comment">/*************************</span>
<a name="l01212"></a>01212 <span class="comment"> *</span>
<a name="l01213"></a>01213 <span class="comment"> * Compiling queries</span>
<a name="l01214"></a>01214 <span class="comment"> *</span>
<a name="l01215"></a>01215 <span class="comment"> *************************/</span>
<a name="l01216"></a>01216
<a name="l01224"></a><a class="code" href="classt3lib__sqlparser.html#15e160cfa44f3b6f0b55108b4aac6804">01224</a> function compileSQL($components) {
<a name="l01225"></a>01225 <span class="keywordflow">switch</span>($components['type']) {
<a name="l01226"></a>01226 <span class="keywordflow">case</span> 'SELECT':
<a name="l01227"></a>01227 $query = $this->compileSELECT($components);
<a name="l01228"></a>01228 <span class="keywordflow">break</span>;
<a name="l01229"></a>01229 <span class="keywordflow">case</span> 'UPDATE':
<a name="l01230"></a>01230 $query = $this->compileUPDATE($components);
<a name="l01231"></a>01231 <span class="keywordflow">break</span>;
<a name="l01232"></a>01232 <span class="keywordflow">case</span> 'INSERT':
<a name="l01233"></a>01233 $query = $this->compileINSERT($components);
<a name="l01234"></a>01234 <span class="keywordflow">break</span>;
<a name="l01235"></a>01235 <span class="keywordflow">case</span> 'DELETE':
<a name="l01236"></a>01236 $query = $this->compileDELETE($components);
<a name="l01237"></a>01237 <span class="keywordflow">break</span>;
<a name="l01238"></a>01238 <span class="keywordflow">case</span> 'EXPLAIN':
<a name="l01239"></a>01239 $query = 'EXPLAIN '.$this->compileSELECT($components);
<a name="l01240"></a>01240 <span class="keywordflow">break</span>;
<a name="l01241"></a>01241 <span class="keywordflow">case</span> 'DROPTABLE':
<a name="l01242"></a>01242 $query = 'DROP TABLE'.($components['ifExists']?' IF EXISTS<span class="charliteral">':'</span>').<span class="charliteral">' '</span>.$components['TABLE'];
<a name="l01243"></a>01243 <span class="keywordflow">break</span>;
<a name="l01244"></a>01244 <span class="keywordflow">case</span> 'CREATETABLE':
<a name="l01245"></a>01245 $query = $this->compileCREATETABLE($components);
<a name="l01246"></a>01246 <span class="keywordflow">break</span>;
<a name="l01247"></a>01247 <span class="keywordflow">case</span> 'ALTERTABLE':
<a name="l01248"></a>01248 $query = $this->compileALTERTABLE($components);
<a name="l01249"></a>01249 <span class="keywordflow">break</span>;
<a name="l01250"></a>01250 }
<a name="l01251"></a>01251
<a name="l01252"></a>01252 <span class="keywordflow">return</span> $query;
<a name="l01253"></a>01253 }
<a name="l01254"></a>01254
<a name="l01262"></a><a class="code" href="classt3lib__sqlparser.html#799b9a1b720fd3881e1ed2e66b39d6e9">01262</a> function compileSELECT($components) {
<a name="l01263"></a>01263
<a name="l01264"></a>01264 <span class="comment">// Initialize:</span>
<a name="l01265"></a>01265 $where = $this->compileWhereClause($components['WHERE']);
<a name="l01266"></a>01266 $groupBy = $this->compileFieldList($components['GROUPBY']);
<a name="l01267"></a>01267 $orderBy = $this->compileFieldList($components['ORDERBY']);
<a name="l01268"></a>01268 $limit = $components['LIMIT'];
<a name="l01269"></a>01269
<a name="l01270"></a>01270 <span class="comment">// Make query:</span>
<a name="l01271"></a>01271 $query = 'SELECT '.($components['STRAIGHT_JOIN'] ? $components['STRAIGHT_JOIN'].'' : '').'
<a name="l01272"></a>01272 '.$this->compileFieldList($components['SELECT']).'
<a name="l01273"></a>01273 FROM '.$this->compileFromTables($components['FROM']).
<a name="l01274"></a>01274 (strlen($where)?'
<a name="l01275"></a>01275 WHERE '.$where : '').
<a name="l01276"></a>01276 (strlen($groupBy)?'
<a name="l01277"></a>01277 GROUP BY '.$groupBy : '').
<a name="l01278"></a>01278 (strlen($orderBy)?'
<a name="l01279"></a>01279 ORDER BY '.$orderBy : '').
<a name="l01280"></a>01280 (strlen($limit)?'
<a name="l01281"></a>01281 LIMIT '.$limit : '');
<a name="l01282"></a>01282
<a name="l01283"></a>01283 <span class="keywordflow">return</span> $query;
<a name="l01284"></a>01284 }
<a name="l01285"></a>01285
<a name="l01293"></a><a class="code" href="classt3lib__sqlparser.html#1ac9d25bf41d5e6b479ca9798c245d79">01293</a> function compileUPDATE($components) {
<a name="l01294"></a>01294
<a name="l01295"></a>01295 <span class="comment">// Where clause:</span>
<a name="l01296"></a>01296 $where = $this->compileWhereClause($components['WHERE']);
<a name="l01297"></a>01297
<a name="l01298"></a>01298 <span class="comment">// Fields</span>
<a name="l01299"></a>01299 $fields = array();
<a name="l01300"></a>01300 foreach($components['FIELDS'] as $fN => $fV) {
<a name="l01301"></a>01301 $fields[]=$fN.<span class="charliteral">'='</span>.$fV[1].$this->compileAddslashes($fV[0]).$fV[1];
<a name="l01302"></a>01302 }
<a name="l01303"></a>01303
<a name="l01304"></a>01304 <span class="comment">// Make query:</span>
<a name="l01305"></a>01305 $query = 'UPDATE '.$components['TABLE'].' SET
<a name="l01306"></a>01306 '.implode(',
<a name="l01307"></a>01307 ',$fields).'
<a name="l01308"></a>01308 '.(strlen($where)?'
<a name="l01309"></a>01309 WHERE '.$where : '');
<a name="l01310"></a>01310
<a name="l01311"></a>01311 <span class="keywordflow">return</span> $query;
<a name="l01312"></a>01312 }
<a name="l01313"></a>01313
<a name="l01321"></a><a class="code" href="classt3lib__sqlparser.html#a75ae4dc6caac9a7426bca30d022e301">01321</a> function compileINSERT($components) {
<a name="l01322"></a>01322
<a name="l01323"></a>01323 <span class="keywordflow">if</span> ($components['VALUES_ONLY']) {
<a name="l01324"></a>01324 <span class="comment">// Initialize:</span>
<a name="l01325"></a>01325 $fields = array();
<a name="l01326"></a>01326 foreach($components['VALUES_ONLY'] as $fV) {
<a name="l01327"></a>01327 $fields[]=$fV[1].$this->compileAddslashes($fV[0]).$fV[1];
<a name="l01328"></a>01328 }
<a name="l01329"></a>01329
<a name="l01330"></a>01330 <span class="comment">// Make query:</span>
<a name="l01331"></a>01331 $query = 'INSERT INTO '.$components['TABLE'].'
<a name="l01332"></a>01332 VALUES
<a name="l01333"></a>01333 ('.implode(',
<a name="l01334"></a>01334 ',$fields).<span class="charliteral">')'</span>;
<a name="l01335"></a>01335 } <span class="keywordflow">else</span> {
<a name="l01336"></a>01336 <span class="comment">// Initialize:</span>
<a name="l01337"></a>01337 $fields = array();
<a name="l01338"></a>01338 foreach($components['FIELDS'] as $fN => $fV) {
<a name="l01339"></a>01339 $fields[$fN]=$fV[1].$this->compileAddslashes($fV[0]).$fV[1];
<a name="l01340"></a>01340 }
<a name="l01341"></a>01341
<a name="l01342"></a>01342 <span class="comment">// Make query:</span>
<a name="l01343"></a>01343 $query = 'INSERT INTO '.$components['TABLE'].'
<a name="l01344"></a>01344 ('.implode(',
<a name="l01345"></a>01345 ',array_keys($fields)).')
<a name="l01346"></a>01346 VALUES
<a name="l01347"></a>01347 ('.implode(',
<a name="l01348"></a>01348 ',$fields).<span class="charliteral">')'</span>;
<a name="l01349"></a>01349 }
<a name="l01350"></a>01350
<a name="l01351"></a>01351 <span class="keywordflow">return</span> $query;
<a name="l01352"></a>01352 }
<a name="l01353"></a>01353
<a name="l01361"></a><a class="code" href="classt3lib__sqlparser.html#60366707bbd79deb824939ca484abf62">01361</a> function compileDELETE($components) {
<a name="l01362"></a>01362
<a name="l01363"></a>01363 <span class="comment">// Where clause:</span>
<a name="l01364"></a>01364 $where = $this->compileWhereClause($components['WHERE']);
<a name="l01365"></a>01365
<a name="l01366"></a>01366 <span class="comment">// Make query:</span>
<a name="l01367"></a>01367 $query = 'DELETE FROM '.$components['TABLE'].
<a name="l01368"></a>01368 (strlen($where)?'
<a name="l01369"></a>01369 WHERE '.$where : '');
<a name="l01370"></a>01370
<a name="l01371"></a>01371 <span class="keywordflow">return</span> $query;
<a name="l01372"></a>01372 }
<a name="l01373"></a>01373
<a name="l01381"></a><a class="code" href="classt3lib__sqlparser.html#a1124c9b8c5160a765316b644fbbd2e0">01381</a> function compileCREATETABLE($components) {
<a name="l01382"></a>01382
<a name="l01383"></a>01383 <span class="comment">// Create fields and keys:</span>
<a name="l01384"></a>01384 $fieldsKeys = array();
<a name="l01385"></a>01385 foreach($components['FIELDS'] as $fN => $fCfg) {
<a name="l01386"></a>01386 $fieldsKeys[]=$fN.<span class="charliteral">' '</span>.$this->compileFieldCfg($fCfg['definition']);
<a name="l01387"></a>01387 }
<a name="l01388"></a>01388 foreach($components['KEYS'] as $kN => $kCfg) {
<a name="l01389"></a>01389 <span class="keywordflow">if</span> ($kN == 'PRIMARYKEY') {
<a name="l01390"></a>01390 $fieldsKeys[]='PRIMARY KEY ('.implode(<span class="charliteral">','</span>, $kCfg).<span class="charliteral">')'</span>;
<a name="l01391"></a>01391 } elseif ($kN == 'UNIQUE') {
<a name="l01392"></a>01392 $fieldsKeys[]='UNIQUE '.$kN.' ('.implode(<span class="charliteral">','</span>, $kCfg).<span class="charliteral">')'</span>;
<a name="l01393"></a>01393 } <span class="keywordflow">else</span> {
<a name="l01394"></a>01394 $fieldsKeys[]='KEY '.$kN.' ('.implode(<span class="charliteral">','</span>, $kCfg).<span class="charliteral">')'</span>;
<a name="l01395"></a>01395 }
<a name="l01396"></a>01396 }
<a name="l01397"></a>01397
<a name="l01398"></a>01398 <span class="comment">// Make query:</span>
<a name="l01399"></a>01399 $query = 'CREATE TABLE '.$components['TABLE'].' (
<a name="l01400"></a>01400 '.implode(',
<a name="l01401"></a>01401 ', $fieldsKeys).'
<a name="l01402"></a>01402 )'.($components['tableType'] ? ' TYPE='.$components['tableType'] : '');
<a name="l01403"></a>01403
<a name="l01404"></a>01404 <span class="keywordflow">return</span> $query;
<a name="l01405"></a>01405 }
<a name="l01406"></a>01406
<a name="l01414"></a><a class="code" href="classt3lib__sqlparser.html#4c0edcae82c72efb79550773bae70b0f">01414</a> function compileALTERTABLE($components) {
<a name="l01415"></a>01415
<a name="l01416"></a>01416 <span class="comment">// Make query:</span>
<a name="l01417"></a>01417 $query = 'ALTER TABLE '.$components['TABLE'].<span class="charliteral">' '</span>.$components['action'].<span class="charliteral">' '</span>.($components['FIELD']?$components['FIELD']:$components['KEY']);
<a name="l01418"></a>01418
<a name="l01419"></a>01419 <span class="comment">// Based on action, add the final part:</span>
<a name="l01420"></a>01420 <span class="keywordflow">switch</span>(strtoupper(str_replace(array(<span class="charliteral">' '</span>,<span class="stringliteral">"\t"</span>,<span class="stringliteral">"\r"</span>,<span class="stringliteral">"\n"</span>),'',$components['action']))) {
<a name="l01421"></a>01421 <span class="keywordflow">case</span> 'ADD':
<a name="l01422"></a>01422 $query.=<span class="charliteral">' '</span>.$this->compileFieldCfg($components['definition']);
<a name="l01423"></a>01423 <span class="keywordflow">break</span>;
<a name="l01424"></a>01424 <span class="keywordflow">case</span> 'CHANGE':
<a name="l01425"></a>01425 $query.=<span class="charliteral">' '</span>.$components['newField'].<span class="charliteral">' '</span>.$this->compileFieldCfg($components['definition']);
<a name="l01426"></a>01426 <span class="keywordflow">break</span>;
<a name="l01427"></a>01427 <span class="keywordflow">case</span> 'DROP':
<a name="l01428"></a>01428 <span class="keywordflow">case</span> 'DROPKEY':
<a name="l01429"></a>01429 <span class="keywordflow">break</span>;
<a name="l01430"></a>01430 <span class="keywordflow">case</span> 'ADDKEY':
<a name="l01431"></a>01431 <span class="keywordflow">case</span> 'ADDPRIMARYKEY':
<a name="l01432"></a>01432 $query.=' ('.implode(<span class="charliteral">','</span>,$components['fields']).<span class="charliteral">')'</span>;
<a name="l01433"></a>01433 <span class="keywordflow">break</span>;
<a name="l01434"></a>01434 }
<a name="l01435"></a>01435
<a name="l01436"></a>01436 <span class="comment">// Return query</span>
<a name="l01437"></a>01437 <span class="keywordflow">return</span> $query;
<a name="l01438"></a>01438 }
<a name="l01439"></a>01439
<a name="l01440"></a>01440
<a name="l01441"></a>01441
<a name="l01442"></a>01442
<a name="l01443"></a>01443
<a name="l01444"></a>01444
<a name="l01445"></a>01445
<a name="l01446"></a>01446
<a name="l01447"></a>01447
<a name="l01448"></a>01448
<a name="l01449"></a>01449
<a name="l01450"></a>01450
<a name="l01451"></a>01451
<a name="l01452"></a>01452
<a name="l01453"></a>01453 <span class="comment">/**************************************</span>
<a name="l01454"></a>01454 <span class="comment"> *</span>
<a name="l01455"></a>01455 <span class="comment"> * Compiling queries, helper functions for parts of queries</span>
<a name="l01456"></a>01456 <span class="comment"> *</span>
<a name="l01457"></a>01457 <span class="comment"> **************************************/</span>
<a name="l01458"></a>01458
<a name="l01467"></a><a class="code" href="classt3lib__sqlparser.html#cc90134c5d654d72c5d769a61bbc8797">01467</a> function compileFieldList($selectFields) {
<a name="l01468"></a>01468
<a name="l01469"></a>01469 <span class="comment">// Prepare buffer variable:</span>
<a name="l01470"></a>01470 $outputParts = array();
<a name="l01471"></a>01471
<a name="l01472"></a>01472 <span class="comment">// Traverse the selectFields if any:</span>
<a name="l01473"></a>01473 <span class="keywordflow">if</span> (is_array($selectFields)) {
<a name="l01474"></a>01474 foreach($selectFields as $k => $v) {
<a name="l01475"></a>01475
<a name="l01476"></a>01476 <span class="comment">// Detecting type:</span>
<a name="l01477"></a>01477 <span class="keywordflow">switch</span>($v['type']) {
<a name="l01478"></a>01478 <span class="keywordflow">case</span> 'function':
<a name="l01479"></a>01479 $outputParts[$k] = $v['function'].<span class="charliteral">'('</span>.$v['func_content'].<span class="charliteral">')'</span>;
<a name="l01480"></a>01480 <span class="keywordflow">break</span>;
<a name="l01481"></a>01481 <span class="keywordflow">case</span> 'field':
<a name="l01482"></a>01482 $outputParts[$k] = ($v['distinct']?$v['distinct']:'').($v['table']?$v['table'].<span class="charliteral">'.'</span>:'').$v['field'];
<a name="l01483"></a>01483 <span class="keywordflow">break</span>;
<a name="l01484"></a>01484 }
<a name="l01485"></a>01485
<a name="l01486"></a>01486 <span class="comment">// Alias:</span>
<a name="l01487"></a>01487 <span class="keywordflow">if</span> ($v['as']) {
<a name="l01488"></a>01488 $outputParts[$k].= <span class="charliteral">' '</span>.$v['as_keyword'].<span class="charliteral">' '</span>.$v['as'];
<a name="l01489"></a>01489 }
<a name="l01490"></a>01490
<a name="l01491"></a>01491 <span class="comment">// Specifically for ORDER BY and GROUP BY field lists:</span>
<a name="l01492"></a>01492 <span class="keywordflow">if</span> ($v['sortDir']) {
<a name="l01493"></a>01493 $outputParts[$k].= <span class="charliteral">' '</span>.$v['sortDir'];
<a name="l01494"></a>01494 }
<a name="l01495"></a>01495 }
<a name="l01496"></a>01496 }
<a name="l01497"></a>01497
<a name="l01498"></a>01498 <span class="comment">// Return imploded buffer:</span>
<a name="l01499"></a>01499 <span class="keywordflow">return</span> implode(', ',$outputParts);
<a name="l01500"></a>01500 }
<a name="l01501"></a>01501
<a name="l01509"></a><a class="code" href="classt3lib__sqlparser.html#54d890252a76b92ebd049952d48f10b9">01509</a> function compileFromTables($tablesArray) {
<a name="l01510"></a>01510
<a name="l01511"></a>01511 <span class="comment">// Prepare buffer variable:</span>
<a name="l01512"></a>01512 $outputParts = array();
<a name="l01513"></a>01513
<a name="l01514"></a>01514 <span class="comment">// Traverse the table names:</span>
<a name="l01515"></a>01515 <span class="keywordflow">if</span> (is_array($tablesArray)) {
<a name="l01516"></a>01516 foreach($tablesArray as $k => $v) {
<a name="l01517"></a>01517
<a name="l01518"></a>01518 <span class="comment">// Set table name:</span>
<a name="l01519"></a>01519 $outputParts[$k] = $v['table'];
<a name="l01520"></a>01520
<a name="l01521"></a>01521 <span class="comment">// Add alias AS if there:</span>
<a name="l01522"></a>01522 <span class="keywordflow">if</span> ($v['as']) {
<a name="l01523"></a>01523 $outputParts[$k].= <span class="charliteral">' '</span>.$v['as_keyword'].<span class="charliteral">' '</span>.$v['as'];
<a name="l01524"></a>01524 }
<a name="l01525"></a>01525
<a name="l01526"></a>01526 <span class="keywordflow">if</span> (is_array($v['JOIN'])) {
<a name="l01527"></a>01527 $outputParts[$k] .= <span class="charliteral">' '</span>.$v['JOIN']['type'].<span class="charliteral">' '</span>.$v['JOIN']['withTable'].' ON ';
<a name="l01528"></a>01528 $outputParts[$k] .= ($v['JOIN']['ON'][0]['table']) ? $v['JOIN']['ON'][0]['table'].<span class="charliteral">'.'</span> : '';
<a name="l01529"></a>01529 $outputParts[$k] .= $v['JOIN']['ON'][0]['field'];
<a name="l01530"></a>01530 $outputParts[$k] .= <span class="charliteral">'='</span>;
<a name="l01531"></a>01531 $outputParts[$k] .= ($v['JOIN']['ON'][1]['table']) ? $v['JOIN']['ON'][1]['table'].<span class="charliteral">'.'</span> : '';
<a name="l01532"></a>01532 $outputParts[$k] .= $v['JOIN']['ON'][1]['field'];
<a name="l01533"></a>01533 }
<a name="l01534"></a>01534 }
<a name="l01535"></a>01535 }
<a name="l01536"></a>01536
<a name="l01537"></a>01537 <span class="comment">// Return imploded buffer:</span>
<a name="l01538"></a>01538 <span class="keywordflow">return</span> implode(', ',$outputParts);
<a name="l01539"></a>01539 }
<a name="l01540"></a>01540
<a name="l01550"></a><a class="code" href="classt3lib__sqlparser.html#af2c268db8c2a473a3d8393ea772a507">01550</a> function compileWhereClause($clauseArray) {
<a name="l01551"></a>01551
<a name="l01552"></a>01552 <span class="comment">// Prepare buffer variable:</span>
<a name="l01553"></a>01553 $output='';
<a name="l01554"></a>01554
<a name="l01555"></a>01555 <span class="comment">// Traverse clause array:</span>
<a name="l01556"></a>01556 <span class="keywordflow">if</span> (is_array($clauseArray)) {
<a name="l01557"></a>01557 foreach($clauseArray as $k => $v) {
<a name="l01558"></a>01558
<a name="l01559"></a>01559 <span class="comment">// Set operator:</span>
<a name="l01560"></a>01560 $output.=$v['<span class="keyword">operator</span>'] ? <span class="charliteral">' '</span>.$v['<span class="keyword">operator</span>'] : '';
<a name="l01561"></a>01561
<a name="l01562"></a>01562 <span class="comment">// Look for sublevel:</span>
<a name="l01563"></a>01563 <span class="keywordflow">if</span> (is_array($v['sub'])) {
<a name="l01564"></a>01564 $output.=' ('.trim($this->compileWhereClause($v['sub'])).<span class="charliteral">')'</span>;
<a name="l01565"></a>01565 } <span class="keywordflow">else</span> {
<a name="l01566"></a>01566
<a name="l01567"></a>01567 <span class="comment">// Set field/table with modifying prefix if any:</span>
<a name="l01568"></a>01568 $output.=<span class="charliteral">' '</span>.trim($v['modifier'].<span class="charliteral">' '</span>.($v['table']?$v['table'].<span class="charliteral">'.'</span>:'').$v['field']);
<a name="l01569"></a>01569
<a name="l01570"></a>01570 <span class="comment">// Set calculation, if any:</span>
<a name="l01571"></a>01571 <span class="keywordflow">if</span> ($v['calc']) {
<a name="l01572"></a>01572 $output.=$v['calc'].$v['calc_value'][1].$this->compileAddslashes($v['calc_value'][0]).$v['calc_value'][1];
<a name="l01573"></a>01573 }
<a name="l01574"></a>01574
<a name="l01575"></a>01575 <span class="comment">// Set comparator:</span>
<a name="l01576"></a>01576 <span class="keywordflow">if</span> ($v['comparator']) {
<a name="l01577"></a>01577 $output.=<span class="charliteral">' '</span>.$v['comparator'];
<a name="l01578"></a>01578
<a name="l01579"></a>01579 <span class="comment">// Detecting value type; list or plain:</span>
<a name="l01580"></a>01580 <span class="keywordflow">if</span> (<a class="code" href="classt3lib__div.html#d994a5608365c288d051d6022d4e9976">t3lib_div::inList</a>('NOTIN,IN',strtoupper(str_replace(array(<span class="charliteral">' '</span>,<span class="stringliteral">"\t"</span>,<span class="stringliteral">"\r"</span>,<span class="stringliteral">"\n"</span>),'',$v['comparator'])))) {
<a name="l01581"></a>01581 $valueBuffer = array();
<a name="l01582"></a>01582 foreach($v['value'] as $realValue) {
<a name="l01583"></a>01583 $valueBuffer[]=$realValue[1].$this->compileAddslashes($realValue[0]).$realValue[1];
<a name="l01584"></a>01584 }
<a name="l01585"></a>01585 $output.=' ('.trim(implode(<span class="charliteral">','</span>,$valueBuffer)).<span class="charliteral">')'</span>;
<a name="l01586"></a>01586 } <span class="keywordflow">else</span> {
<a name="l01587"></a>01587 $output.=<span class="charliteral">' '</span>.$v['value'][1].$this->compileAddslashes($v['value'][0]).$v['value'][1];
<a name="l01588"></a>01588 }
<a name="l01589"></a>01589 }
<a name="l01590"></a>01590 }
<a name="l01591"></a>01591 }
<a name="l01592"></a>01592 }
<a name="l01593"></a>01593
<a name="l01594"></a>01594 <span class="comment">// Return output buffer:</span>
<a name="l01595"></a>01595 <span class="keywordflow">return</span> $output;
<a name="l01596"></a>01596 }
<a name="l01597"></a>01597
<a name="l01604"></a><a class="code" href="classt3lib__sqlparser.html#d2950812e683bd0a007f9fa2eb873b92">01604</a> function compileFieldCfg($fieldCfg) {
<a name="l01605"></a>01605
<a name="l01606"></a>01606 <span class="comment">// Set type:</span>
<a name="l01607"></a>01607 $cfg = $fieldCfg['fieldType'];
<a name="l01608"></a>01608
<a name="l01609"></a>01609 <span class="comment">// Add value, if any:</span>
<a name="l01610"></a>01610 <span class="keywordflow">if</span> (strlen($fieldCfg['value'])) {
<a name="l01611"></a>01611 $cfg.=<span class="charliteral">'('</span>.$fieldCfg['value'].<span class="charliteral">')'</span>;
<a name="l01612"></a>01612 }
<a name="l01613"></a>01613
<a name="l01614"></a>01614 <span class="comment">// Add additional features:</span>
<a name="l01615"></a>01615 <span class="keywordflow">if</span> (is_array($fieldCfg['featureIndex'])) {
<a name="l01616"></a>01616 foreach($fieldCfg['featureIndex'] as $featureDef) {
<a name="l01617"></a>01617 $cfg.=<span class="charliteral">' '</span>.$featureDef['keyword'];
<a name="l01618"></a>01618
<a name="l01619"></a>01619 <span class="comment">// Add value if found:</span>
<a name="l01620"></a>01620 <span class="keywordflow">if</span> (is_array($featureDef['value'])) {
<a name="l01621"></a>01621 $cfg.=<span class="charliteral">' '</span>.$featureDef['value'][1].$this->compileAddslashes($featureDef['value'][0]).$featureDef['value'][1];
<a name="l01622"></a>01622 }
<a name="l01623"></a>01623 }
<a name="l01624"></a>01624 }
<a name="l01625"></a>01625
<a name="l01626"></a>01626 <span class="comment">// Return field definition string:</span>
<a name="l01627"></a>01627 <span class="keywordflow">return</span> $cfg;
<a name="l01628"></a>01628 }
<a name="l01629"></a>01629
<a name="l01630"></a>01630
<a name="l01631"></a>01631
<a name="l01632"></a>01632
<a name="l01633"></a>01633
<a name="l01634"></a>01634
<a name="l01635"></a>01635
<a name="l01636"></a>01636
<a name="l01637"></a>01637
<a name="l01638"></a>01638
<a name="l01639"></a>01639
<a name="l01640"></a>01640 <span class="comment">/*************************</span>
<a name="l01641"></a>01641 <span class="comment"> *</span>
<a name="l01642"></a>01642 <span class="comment"> * Debugging</span>
<a name="l01643"></a>01643 <span class="comment"> *</span>
<a name="l01644"></a>01644 <span class="comment"> *************************/</span>
<a name="l01645"></a>01645
<a name="l01653"></a><a class="code" href="classt3lib__sqlparser.html#c3eb43a0818156a99dd3756ee96906cf">01653</a> function debug_parseSQLpart($part,$str) {
<a name="l01654"></a>01654 $retVal = <span class="keyword">false</span>;
<a name="l01655"></a>01655
<a name="l01656"></a>01656 <span class="keywordflow">switch</span>($part) {
<a name="l01657"></a>01657 <span class="keywordflow">case</span> 'SELECT':
<a name="l01658"></a>01658 $retVal = $this->debug_parseSQLpartCompare($str,$this->compileFieldList($this->parseFieldList($str)));
<a name="l01659"></a>01659 <span class="keywordflow">break</span>;
<a name="l01660"></a>01660 <span class="keywordflow">case</span> 'FROM':
<a name="l01661"></a>01661 $retVal = $this->debug_parseSQLpartCompare($str,$this->compileFromTables($this->parseFromTables($str)));
<a name="l01662"></a>01662 <span class="keywordflow">break</span>;
<a name="l01663"></a>01663 <span class="keywordflow">case</span> 'WHERE':
<a name="l01664"></a>01664 $retVal = $this->debug_parseSQLpartCompare($str,$this->compileWhereClause($this->parseWhereClause($str)));
<a name="l01665"></a>01665 <span class="keywordflow">break</span>;
<a name="l01666"></a>01666 }
<a name="l01667"></a>01667 <span class="keywordflow">return</span> $retVal;
<a name="l01668"></a>01668 }
<a name="l01669"></a>01669
<a name="l01678"></a><a class="code" href="classt3lib__sqlparser.html#83ba9a1d535651d1264f52eb3ada5d8c">01678</a> function debug_parseSQLpartCompare($str,$newStr,$caseInsensitive=FALSE) {
<a name="l01679"></a>01679 <span class="keywordflow">if</span> ($caseInsensitive) {
<a name="l01680"></a>01680 $str1 = strtoupper($str);
<a name="l01681"></a>01681 $str2 = strtoupper($newStr);
<a name="l01682"></a>01682 } <span class="keywordflow">else</span> {
<a name="l01683"></a>01683 $str1 = $str;
<a name="l01684"></a>01684 $str2 = $newStr;
<a name="l01685"></a>01685 }
<a name="l01686"></a>01686
<a name="l01687"></a>01687 <span class="comment">// Fixing escaped chars:</span>
<a name="l01688"></a>01688 $search = array(<span class="charliteral">'\0'</span>, <span class="charliteral">'\n'</span>, <span class="charliteral">'\r'</span>, <span class="charliteral">'\Z'</span>);
<a name="l01689"></a>01689 $replace = array(<span class="stringliteral">"\x00"</span>, <span class="stringliteral">"\x0a"</span>, <span class="stringliteral">"\x0d"</span>, <span class="stringliteral">"\x1a"</span>);
<a name="l01690"></a>01690 $str1 = str_replace($search, $replace, $str1);
<a name="l01691"></a>01691 $str2 = str_replace($search, $replace, $str2);
<a name="l01692"></a>01692
<a name="l01693"></a>01693 <span class="preprocessor"> # Normally, commented out since they are needed only in tricky cases...</span>
<a name="l01694"></a>01694 <span class="preprocessor"></span><span class="preprocessor"># $str1 = stripslashes($str1);</span>
<a name="l01695"></a>01695 <span class="preprocessor"></span><span class="preprocessor"># $str2 = stripslashes($str2);</span>
<a name="l01696"></a>01696 <span class="preprocessor"></span>
<a name="l01697"></a>01697 <span class="keywordflow">if</span> (strcmp(str_replace(array(<span class="charliteral">' '</span>,<span class="stringliteral">"\t"</span>,<span class="stringliteral">"\r"</span>,<span class="stringliteral">"\n"</span>),'',$this->trimSQL($str1)),str_replace(array(<span class="charliteral">' '</span>,<span class="stringliteral">"\t"</span>,<span class="stringliteral">"\r"</span>,<span class="stringliteral">"\n"</span>),'',$this->trimSQL($str2)))) {
<a name="l01698"></a>01698 <span class="keywordflow">return</span> array(
<a name="l01699"></a>01699 str_replace(array(<span class="charliteral">' '</span>,<span class="stringliteral">"\t"</span>,<span class="stringliteral">"\r"</span>,<span class="stringliteral">"\n"</span>),<span class="charliteral">' '</span>,$str),
<a name="l01700"></a>01700 str_replace(array(<span class="charliteral">' '</span>,<span class="stringliteral">"\t"</span>,<span class="stringliteral">"\r"</span>,<span class="stringliteral">"\n"</span>),<span class="charliteral">' '</span>,$newStr),
<a name="l01701"></a>01701 );
<a name="l01702"></a>01702 }
<a name="l01703"></a>01703 }
<a name="l01704"></a>01704
<a name="l01711"></a><a class="code" href="classt3lib__sqlparser.html#f802771d3b43abddfc70fc5bc0f09043">01711</a> function debug_testSQL($SQLquery) {
<a name="l01712"></a>01712
<a name="l01713"></a>01713 <span class="comment">// Getting result array:</span>
<a name="l01714"></a>01714 $parseResult = $this->parseSQL($SQLquery);
<a name="l01715"></a>01715
<a name="l01716"></a>01716 <span class="comment">// If result array was returned, proceed. Otherwise show error and exit.</span>
<a name="l01717"></a>01717 <span class="keywordflow">if</span> (is_array($parseResult)) {
<a name="l01718"></a>01718
<a name="l01719"></a>01719 <span class="comment">// Re-compile query:</span>
<a name="l01720"></a>01720 $newQuery = $this->compileSQL($parseResult);
<a name="l01721"></a>01721
<a name="l01722"></a>01722 <span class="comment">// TEST the new query:</span>
<a name="l01723"></a>01723 $testResult = $this->debug_parseSQLpartCompare($SQLquery, $newQuery);
<a name="l01724"></a>01724
<a name="l01725"></a>01725 <span class="comment">// Return new query if OK, otherwise show error and exit:</span>
<a name="l01726"></a>01726 <span class="keywordflow">if</span> (!is_array($testResult)) {
<a name="l01727"></a>01727 <span class="keywordflow">return</span> $newQuery;
<a name="l01728"></a>01728 } <span class="keywordflow">else</span> {
<a name="l01729"></a>01729 debug(array('ERROR MESSAGE'=>'Input query did not match the parsed and recompiled query exactly (not observing whitespace)', 'TEST result' => $testResult),'SQL parsing failed:');
<a name="l01730"></a>01730 exit;
<a name="l01731"></a>01731 }
<a name="l01732"></a>01732 } <span class="keywordflow">else</span> {
<a name="l01733"></a>01733 debug(array('query' => $SQLquery, 'ERROR MESSAGE'=>$parseResult),'SQL parsing failed:');
<a name="l01734"></a>01734 exit;
<a name="l01735"></a>01735 }
<a name="l01736"></a>01736 }
<a name="l01737"></a>01737 }
<a name="l01738"></a>01738
<a name="l01739"></a>01739
<a name="l01740"></a>01740 <span class="keywordflow">if</span> (defined('TYPO3_MODE') && $TYPO3_CONF_VARS[TYPO3_MODE]['XCLASS']['t3lib/<span class="keyword">class</span>.<a class="code" href="classt3lib__sqlparser.html">t3lib_sqlparser</a>.php']) {
<a name="l01741"></a>01741 include_once($TYPO3_CONF_VARS[TYPO3_MODE]['XCLASS']['t3lib/<span class="keyword">class</span>.<a class="code" href="classt3lib__sqlparser.html">t3lib_sqlparser</a>.php']);
<a name="l01742"></a>01742 }
<a name="l01743"></a>01743 ?>
</pre></div><?php
include_once '../doc-typo3-funcs.php';
get_footer();
?>