OSDN > Find Software > Communications > Nucleus日本語版 > SCM > git > nucleus-plugins > Commit

Nucleus日本語版
Fork
nucleus-next
nucleus-jp-ancient
nucleus-plugins

nucleus-plugins: Commit

Nucleus CMS日本語版用プラグインのうち、日本語版開発者がサポートしているもの

sqlite: debug, MySQL-specific comment, '-- '.

--- a/sqlite/trunk/nucleus/sqlite/sqlite.php

+++ b/sqlite/trunk/nucleus/sqlite/sqlite.php

		@@ -111,9 +111,6 @@ function nucleus_mysql_query($p1,$p2=null,$unbuffered=false){//echo htmlspecialc
111	111	if (strpos($query,"\xEF\xBB\xBF")===0) $query=substr($query,3);// UTF-8 stuff
112	112	if (substr($query,-1)==';') $query=substr($query,0,strlen($query)-1);
113	113
114		- // Remove MySQL specific comment, '-- '.
115		- $query=preg_replace('/($\|[\r\n])\-\-[\s^\r\n]([^\r\n]*)/','',$query);
116		-
117	114	// Escape style is changed from MySQL type to SQLite type here.
118	115	// This is important to avoid possible SQL-injection.
119	116	$strpositions=array();// contains the data show where the strings are (startposition => endposition)

		@@ -287,6 +284,8 @@ function sqlite_changeQuote(&$query){
287	284	if ($i2<($j=$i1)) $j=$i2;
288	285	if ($i3<$j) $j=$i3;
289	286	$temp=preg_replace('/[\s]+/',' ',substr($query,$i,$j-$i)); // Change all spacying to ' '.
	287	+ // Remove MySQL specific comment, '-- '.
	288	+ $temp=preg_replace('/($\|[\r\n])\-\-[\s^\r\n]([^\r\n]*)/',' ',$temp);
290	289	$ret.=($temp);
291	290	$c=$query[($i=$j)]; // $c keeps the type of quote.
292	291	if (strstr($temp,';')) exit('Warning: try to use more than two queries?');